Re: [documentation-dev] doc.oo.o website updated
Frank Peters wrote: Hi, I updated the main project page on doc.oo.o to have more links pointing to the wiki and putting even more focus on the user. I added some Google coop searches to workaround the sh*tty collabnet search. The ultimate goal would be to have the main access through the wiki with the website being the repository for static published docs, and possibly the place to hold searches that require forms. Let me know -f Hi Frank, Just took a look - I like it. You are doing some really nice stuff. Thought I would mention that I have been musing over the idea of a slightly more expansive use of the google coop search function, a look at my first thoughts on the subject can be found here http://wiki.services.openoffice.org/wiki/U.s.oo.o/Planning/wiki/OOo_CSE My hope is to incorporate this into the new user.services site at some point in the not too distant future. I would really like hear any ideas or comments you might have on subject, not too mention any feedback you might get from the use you are making of the CSE at the main site. Drew - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [documentation-dev] Re: Mid-level base tutorial
Hi Mariano Sorry for being slow on getting back. I gave a complete reading and it looks pretty good, I would like to read it one more time. I just got busy with another endeavor that pulled a lot of my time away. But I didn't see anything in the first pass that jumped out and said NOPE that is not correct if that helps. Also, a little bit ahead of when it is needed, a new page was added to the Base wiki this morning with Ocke Janssen's assistance that lists the functions available for use in the new Sun Report Builder. The URL for this page is: http://wiki.services.openoffice.org/wiki/Base/Reports/Functions by the time the reports are needed for this tutorial that page should be finished with a solid set of examples of how to use each of those functions and, with a little luck and help from a few others, a set of simple example reports showing how to utilize them together. I'm still excited about what you are doing, more so since reviewing the draft of the chapters even. I know I still owe you the update on the data type range and precision specs for numerics...I'll get it done. Drew Hi Jean and Frank! As I said last time, there is a first draft of points one and two of the proposed outline for the mid-level Base tutorial. However, I have not published yet. First because Andrew Jensen is still reviewing it and I want to make sure that the copy is correct from a technical point of view. I am expecting Andrew to provide feedback at any moment now. Also, I need to include some information about variable data types that he promised me. The other reason is that point one and two do not deliver without point three. I have been hesitant about posting something that still needs revision and is incomplete. However, the draft could benefit from the feedback from an editor or the corrections by a copy expert. I was hoping that maybe Jean, as technical editor, or Frank would be interested in reviewing this or sending me with someone who would. Andrew mentioned the possibility that this document be stored at OO.o Authors while the third part is being developed and where it could be accessed by those helping with the editing. Also, I understand that the formal and stylistic rules and the templates for e-publishing are there. I would appreciate if Jean of Frank can orient me in the right direction at this stage of the project. Thanks! Mariano. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [documentation-dev] Re: Mid-level base tutorial
[EMAIL PROTECTED] wrote: Andrew: I am happy to announce that I have finished the explanation on data modeling. This is the part where I take a real life example and apply the concepts described in points 1 and 2 in order to achieve the design of a working database. I am sending you this. I still need to explain the merits of making a table data definition list and pulling all the analysis into one final UML diagram. I am sure that this will not be a problem for you to visualize. Please read this text remembering that this is an educational text. This means that there is a though development in progress that goes progressively optimizing the concpets provided and does not start by rendering hard universal rules. On the contrary, it reaches them at the end. I'll be looking for it in my inbox then. Wonderful Drew - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [documentation-dev] Mid level Base tutorial
Mariano Casanova wrote: Hi Drew, nice to hear from you. I am very excited about ending this job and being able to coordinate with you. Please let me know if you still have the forms and reports for the example or if you need them again. I think that they pretty much help delineated the end result desired. I will be waiting for you instructions. I think I have them all - but if it isn't that much of a problem could you just bundle the whole kit-n-caboodle into a zip file and attach it to a direct email at drewjensen.inbox AT gmail.com - that way I;m sure to have your latest product and won't waist any of your or my time working something outdated. Thanks Drew - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [documentation-dev] Trying out some ideas for reworking the main Documentation Wiki page
Clayton wrote: Considerably more user friendly approach. Let them pick the general areas of the documentation they want and drill down, no more clutter right on the landing page to have to sift through. I also think that it'll help with organization and maintenance on our end as well. I agree with you Sak, it's more user friendly. May be we could mix the layout of the how-to page with your proposal to get well separated areas for each item? The page I put together was done just to figure out how to use the hidden text blocks. Frank has created and example page that gives a much better idea what is possible with the hidden/expanded text areas: http://wiki.services.openoffice.org/wiki/Documentation_new Hi Clayton, The page Frank put together looks nice. One nit pick however. Using Firefox under Ubuntu just now to view it - if I move the mouse kind of slowly the cateories ( with the arrows ) can start to beat on off some. Leave the mouse cursor just a few pixels below the text and this and it just becomes a regular flashing highlight... - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[documentation-dev] OpenOffice.org booth at ALA-2010
Hi, Thanks, in large part to the generousness of the folks over at WorldLabel.com, OpenOffice.org will be hosting a booth at the American Library Association's national conference in June of this year. You can find information about the event, and plans for OpenOffice.org activities there at http://wiki.services.openoffice.org/wiki/US/Home/ALA-2010 As part of those plans we are arranging a kick-off get together on IRC at irc://freenode/ooousa For those on the list interested in getting involved - particularly if you are in the Washington DC area and you might be willing to help out at the booth - but in any way. Feel free to sign up for the meeting (or just drop by the channel - no reservations required) - a meeting scheduler has been setup at Doodle: http://doodle.com/8axp46z5svkc6m32 This email has been sent to a number of mailing lists so please it would be best if folks wanting to reply do so - via the marketing mailing list - a comment on the wiki page (above) - or a note on the irc channel Thanks so much for you time, Drew Jensen - To unsubscribe, e-mail: dev-unsubscr...@documentation.openoffice.org For additional commands, e-mail: dev-h...@documentation.openoffice.org
Re: [documentation-dev] Top 25 Technical Writing Blogs
http://wiki.services.openoffice.org/wiki/Template:AddThis
and can be inserted into a page using {{AddThis}} and the button will
show up at the point where the Template call is added.
Excellent!
-
To unsubscribe, e-mail: dev-unsubscr...@documentation.openoffice.org
For additional commands, e-mail: dev-h...@documentation.openoffice.org
Re: [documentation-dev] Top 25 Technical Writing Blogs
http://wiki.services.openoffice.org/wiki/Template:AddThis ...and one lttle nit-picky thing..(you know there was going to be one of those with me..right) The Oracle logo...well, just look for yourself http://www.facebook.com/dj.son.of.gus I shared a wiki page and let it display the logo...yuk Drew - To unsubscribe, e-mail: dev-unsubscr...@documentation.openoffice.org For additional commands, e-mail: dev-h...@documentation.openoffice.org
Re: [documentation-dev] Base mid level tutorial posted
On 08/12/2010 08:31 PM, mcasan...@instituto-hispano.org wrote: Dear community: Please note that the completed Mid-level Base Tutorial has been posted. You can find it at: http://documentation.openoffice.org/servlets/ProjectDocumentList?folderID=778expandFolder=778folderID=778 Please consider this a beta version. I will be receiving feedback about it until September and will introduce any relevant changes then. After this, this edition will be considered frozen. Drew, if you find this work acceptable I would appreciate if you leave a sticky about it at the ooforum, Base. I am also very interested in your feedback. Cheers, Mariano Casanova Hi Mariano, (First sorry if this email arrives twice...odd things with the computer today..) I have it downloaded and have begun reading. I used the .sql file you uploaded to create a Base file database - worked as a charm under 3.2 - 3.3 beta. Tried a few of the queries - hit a small problem. The document it using nice double quotes that need to be changed - and - there can be line break problems in copy/paste. So for instance looking at the example on page #136. If I copy / paste this into a query definition I get this: SELECT CONCAT( CONCAT( “Patient”.“Surname”, ', ' ), “Patient”.“First Name” ) AS “Patient Name”, “Phone Number”.“Number”, “Phone Number”.“Description” FROM “Patient”, “Phone Number” WHERE “Patient”.“ID Number” = “Phone Number”.“Patient ID” ORDER BY “Patient Name” ASC; *chuckling*...which the email list server might change again.. OK the query fails for two reasons. 1 - the characters and ” must be 2 - A object name which, in this case First Name, can not have break across lines. So to get the query to run I need this SELECT CONCAT( CONCAT( Patient.Surname, ', ' ), Patient.First Name ) AS Patient Name, Phone Number.Number, Phone Number.Description FROM Patient, Phone Number WHERE Patient.ID Number = Phone Number.Patient ID ORDER BY Patient Name ASC; or this, SELECT CONCAT( CONCAT( Patient.Surname, ', ' ), Patient.First Name ) AS Patient Name, Phone Number.Number, Phone Number.Description FROM Patient, Phone Number WHERE Patient.ID Number = Phone Number.Patient ID ORDER BY Patient Name ASC; perhaps. Other wise - It's reading very nicely.. Question - will you be including any example data? or an ODB file even? Thanks Drew - To unsubscribe, e-mail: dev-unsubscr...@documentation.openoffice.org For additional commands, e-mail: dev-h...@documentation.openoffice.org
Re: [documentation-dev] Re: Feedback by Drew Jensen for Base Tutorial
On 08/14/2010 01:28 AM, mcasan...@instituto-hispano.org wrote: Hi Drew, and thank you for sending me feedback. I really appreciate this. I did notice the slanted quote signs and how text with them would sometimes throw an error when I try to run it as a query. This did bother me too, a lot, but wasn't sure of what was going on. That is why I wrote the footnote in page 112. Now I see. It seems that OO.oWriter included them automatically (and sometimes not). I will change this. On the other hand and except for the SQL that composes the example database, the philosophy of the tutorial is that all code snippets should be typed and not copy and pasted. There is a reason for this: *chuckling*..as I was typing the email I was thinking...hmmm, Mariano is a professor and you know he is going to say... Theories of cognition describe several levels of knowledge: to know about, to understand, to apply... *smile* Alright - well, I will go ahead and keep on moving the SQL (cpy/pst) but only for QA purposes then...so far, other then typography no problems getting any of the SQL to run. I have to say also, I really am looking forward to reading 'in detail' your section on aggregate functions. Til later, Drew - To unsubscribe, e-mail: dev-unsubscr...@documentation.openoffice.org For additional commands, e-mail: dev-h...@documentation.openoffice.org
Re: [documentation-dev] Re: Feedback by Drew Jensen for Base Tutorial
On 08/14/2010 05:36 PM, mcasan...@instituto-hispano.org wrote: Thank you Drew. I am very interested in knowing what you think about the aggregate functions section. Please note that I have reviewed and corrected all SQL code that had slanted quotation marks. In doing so I also found some typos (like missing quotation marks) that have also been corrected. The updated version has been published with date 2010/08/14. You might want to switch your copy. There are no other changes in the text. Cheers, Mariano. Hello Mariano, et al, Grabbed the updated version and here is where I'm at: Section 1 - rather a fast skimming (I will go back to this section now in earnest) Section 2 - went through with a bit more detail Section 3 - hunkered down and when through these chapters in earnest. Couple of comments first: Chapter Seven has this in the first paragraph: Now is time to turn on the computer. Go ahead! Oh, praise the Lord! This approach of reinforcing to the reader the importance of 'thinking' before you start typing when developing their database really is quite important. (I best stop here, on this subject, lest a rant follow on the difference between a spreadsheet and a database) Alright then, so much for inflating the ego...and now: Actually there is only one 'and now', Chapter Nine and the section: Querying more than one table at a time This is the only section that I thought needed just a bit more depth. Reading along I was impressed with the job you did of keeping the level of detail focused to the reader's skill level. I've tried my hand at a few tutorials and finding the right balance, then maintaining it, is something that has proven, for me at least, difficult. Honestly I think I missed it much more often then hit it. For the most part I think you are pretty close to spot on. With the exception of this section on Joins. The text shows only the use of an inner join making no mention of outer joins. I think this is a mistake. This is a fairly fundamental concept IMO and even if you don't go into great detail I think it merits a paragraph or two and a link to further reading. Anyway - I'll stop here for the moment and plan on getting back to it again tomorrow and drop another email when I do. Till then, Drew - To unsubscribe, e-mail: dev-unsubscr...@documentation.openoffice.org For additional commands, e-mail: dev-h...@documentation.openoffice.org
Re: [documentation-dev] Re: Feedback for Base Tutorial
Hi, Went over Section 1 this morning. One small typo - 1st paragraph on page 28 spouses of a person, and unsigned byte , the 'and' 'an'. The chapter on normalization is excellent. The chapter on data types I really want to go over again, I felt a bit uneasy with one of two items. Nit-picky stuff, rather the nature of the subject matter. Anyway, I may want to offer a replacement for one or two lines (that's all) - but want first to go check some facts. I can get to that this evening, but again, it's nit-picky so maybe not appropriate for the audience. Also, perhaps others may have a different take on it. Over all Section 1 is quite good IMO. Alright - I'll get to Section 2 tomorrow. Thanks Drew - To unsubscribe, e-mail: dev-unsubscr...@documentation.openoffice.org For additional commands, e-mail: dev-h...@documentation.openoffice.org
Re: [documentation-dev] Re: Feedback for Base Tutorial
Howdy Mariano, Went through Section 2 this morning. Nice job again on the data modeling section, that can be tricky stuff and you handle it IMO quite well. OK, one small typo. Page 66, 1st line. This form is built This report is built As for the joins I'll get something together and off to you here shortly. Best wishes, Drew - To unsubscribe, e-mail: dev-unsubscr...@documentation.openoffice.org For additional commands, e-mail: dev-h...@documentation.openoffice.org
Re: [documentation-dev] Re: Feedback for Base Tutorial
On 08/24/2010 07:20 PM, Buck Deadrich wrote: Don't know why I am receiving this. It has no bearing on me. --- On Fri, 8/20/10, Drew Jensendrewjensen.in...@gmail.com wrote: Hi Buck, Well, do you mean - How did you get on a mailing list? or How is this relevant to this mailing list? Thanks Drew - To unsubscribe, e-mail: dev-unsubscr...@documentation.openoffice.org For additional commands, e-mail: dev-h...@documentation.openoffice.org
[documentation-dev] Today's word is Idiot
Hi, Well, it seems that a very long time ago I created a problem - with my email accounts and registrations with some ooo mailing lists. Specifically with the authors list. Just checked and it seems that for a while now I've been sending email to that list under the wrong account - again. Particularly emails in response to those from Dan regarding the Base document...I really do feel like an idiot. I'm assuming you read both lists..so my apology here. Anyway - I'll fix this and resend the current ones again, to the authors list. Drew - To unsubscribe, e-mail: dev-unsubscr...@documentation.openoffice.org For additional commands, e-mail: dev-h...@documentation.openoffice.org
Re: [documentation-dev] Today's word is Idiot
On 08/28/2010 10:47 PM, Jean Weber wrote: On Sun, Aug 29, 2010 at 12:34 PM, Drew Jensen drewjensen.in...@gmail.com wrote: Well, it seems that a very long time ago I created a problem - with my email accounts and registrations with some ooo mailing lists. Specifically with the authors list. Just checked and it seems that for a while now I've been sending email to that list under the wrong account - again. Particularly emails in response to those from Dan regarding the Base document...I really do feel like an idiot. I'm assuming you read both lists..so my apology here. Anyway - I'll fix this and resend the current ones again, to the authors list. And do be sure it's the current authors list, not the old one. auth...@documentation.openoffice.org During my travels this month, Clayton has been monitoring the Authors list. I guess he didn't catch your notes and pass them on, or perhaps you've been sending to the old list @user-faq? --Jean Can I ask another question - shouldn't the list server be bouncing my emails back to me? The user list does, but no other list I'm subscribed to at openoffice does, so I just assume they go through and it seems here that was a problem - no doubt of my making somehow. Drew - To unsubscribe, e-mail: dev-unsubscr...@documentation.openoffice.org For additional commands, e-mail: dev-h...@documentation.openoffice.org
Re: [documentation-dev] Today's word is Idiot
Can I ask another question - shouldn't the list server be bouncing my emails back to me? The user list does, but no other list I'm subscribed to at openoffice does, so I just assume they go through and it seems here that was a problem - no doubt of my making somehow. Drew The Authors and Dev lists don't return messages to sender if they don't go through, although the list moderator can chooses to return them. I don't think it would be a good idea to return them automatically, because it would interfere with the moderators' ability to reply to expressions of interest from potential contributors, who may not want to subscribe before finding out what they are getting into. --Jean I think that I wasn't clear - I don't mean a bounced message when It fails to post to the list - I mean a normal message. For instance I just sent a response to a question at user list and in a minute it will come back to me, in my inbox, from the mail list. When I send to any other list at ooo this doesn't happen. Drew - To unsubscribe, e-mail: dev-unsubscr...@documentation.openoffice.org For additional commands, e-mail: dev-h...@documentation.openoffice.org
Re: [documentation-dev] Today's word is Idiot
I think that I wasn't clear - I don't mean a bounced message when It fails to post to the list - I mean a normal message. For instance I just sent a response to a question at user list and in a minute it will come back to me, in my inbox, from the mail list. When I send to any other list at ooo this doesn't happen. and I just switched the authors list to an account on a different server..it now sends back to me also..guess I should switch out the other accounts also - problem solved. - To unsubscribe, e-mail: dev-unsubscr...@documentation.openoffice.org For additional commands, e-mail: dev-h...@documentation.openoffice.org
Re: [documentation-dev] Re: Feedback for Base Tutorial
On 08/26/2010 02:41 PM, Joe Smith wrote: [ Sorry, I'm jumping into the middle of a thread here. I don't have the original message to reply to. ] Mariano, As a frustrated beginner with Base, I've been eagerly awaiting a draft of your tutorial. Now that it's here, I can say it was definitely worth the wait: you've done a great job organizing the material and explaining complex material very clearly. That's a big challenge, but you really nailed it, I think. This should be a huge help to people who need to get started doing actual work with Base. As I've read through, I've noticed a few typos and run into some questions, so I started collecting them. I was going to go all the way through, but this is long enough already and I want to try to coordinate with Drew and anyone else who's proofing. I'm not necessarily looking for a response, but if there's any follow-up, we can use the list, or just email me directly. Wow - well, just proves that I am not copy editor.. p20 ... whether in one filed or in multiple columns. ... whether in one _field_ or in multiple columns. p21 ... Teacher ID and Project Name _conform_ the compound primary key... Maybe form? Lets _re-sate_ this in formal parlance: Lets _re-state_ this in formal parlance: p35 ... they are assigned to a _therapists_ ... ... they are assigned to a _therapist_ ... p36 We can imagine that a patient and a _therapists_ ... We can imagine that a patient and a _therapist_ ... p42 Seems to use inconsistent terminology, sometimes referring to the people being treated at the clinic as patients and other times as clients. For example, What is the situation with the medication? We already know that one _client_ would be using... medications (0..n) while several medications could be being used by several _patients_ at the same time (n..m). On this one - that really is closer to real life - folks talk about patients and clients and of course it is just one person. There is a name for this, persona - so sometimes a person has the persona of a client, for instance when viewed by the client administrator and other times they have the persona of patient, as when a doctor or therapist is talking about them. Drew - To unsubscribe, e-mail: dev-unsubscr...@documentation.openoffice.org For additional commands, e-mail: dev-h...@documentation.openoffice.org
Re: [documentation-dev] Re: Feedback for Base Tutorial
Howdy,
Inner and outer joins.
Actually there is a good example for an outer join with doctors and
patients.
Patients have a relationship with Doctors, yes.
Suppose I want to list all the doctors and all the patients assigned to
each.
If you do an inner join between two table it returns the set of records
that match on the linked field(s).
But what if you have a doctor in the database that has no patients.
Using an inner join you would not see the doctor record, since it can
not match to a DoctorID in the patient table.
In this case you need to use an OUTER join which means, return me all
the records that match between the tables, and then depending on if it
is a LEFT or RIGHT outer join also return all records in the lefthand or
righthand table that does not have a a match in the other.
OK
- two doctors
Williams and Parker
- one patient
Crathers
To get both docotors and the patient into a result set you need to use a
query such as
SELECT
Medical Doctor.Surname AS Doctor,
Patient.Surname AS Patient
FROM { OJ Medical Doctor LEFT OUTER JOIN Patient ON Medical Doctor.ID Number =
Patient.Medical Doctor ID }
more later..
Drew
-
To unsubscribe, e-mail: dev-unsubscr...@documentation.openoffice.org
For additional commands, e-mail: dev-h...@documentation.openoffice.org
Re: [documentation-dev] Outer join example
On 08/31/2010 04:49 PM, mcasan...@instituto-hispano.org wrote:
Thank you Drew for the information. This is consistent with my recent
research. I would like to confirm with you that the query you sent uses
the syntax understood by Base/HSQL
To get both docotors and the patient into a result set you need to use a
query such as
SELECT
Medical Doctor.Surname AS Doctor,
Patient.Surname AS Patient
FROM { OJ Medical Doctor LEFT OUTER JOIN Patient ON Medical
Doctor.ID Number = Patient.Medical Doctor ID }
more later..
Drew
I would guess that OJ means Outer Join and that it is not by chance that
you are using the key words LEFT OUTER JOIN and that Medical
Doctor.ID Number is at the left of the clause.
Ah - well.
Base uses ODBC compliant naming for Outer Joins. This specification requires
'{oj' to initiate the outer join part of the statment and '}' to end it.
So, it is not just the oj but the curly bracket { and oj taken as a
whole that is required.
This is for all intent an purpose the same for JDBC connections.
When the Base query designer is used to create an outer join query this
ODBC/JDBC naming convention is used - when doing so by hand, and the
backend supports it, one can drop this {oj. But that is not not
something that makes much sense any more, as all, that I know of anyway,
database servers now recognize the {oj marker.
Drew
-
To unsubscribe, e-mail: dev-unsubscr...@documentation.openoffice.org
For additional commands, e-mail: dev-h...@documentation.openoffice.org
Re: [documentation-dev] Re: Feedback for Base Tutorial
On 08/31/2010 07:45 PM, Joe Smith wrote: On 08/31/2010 04:38 PM, mcasan...@instituto-hispano.org wrote: Thank you all for the input in proofreading the tutorial Glad it's helpful; I'm enjoying going through it! I can see that you've spent a lot of effort to make things clear, and it really helps. After stumbling through Chapter 9 (Queries), I'm now completely stuck at Chapter 10 (Reports) for lack of a functional database: there's no data to try the examples on! Of course I can enter some data, but an interesting report (or query) requires more records than I'm interested in typing. It could be a big win if the text was accompanied by a complete sample data set. Then, all the examples and student exercises found in the text could be run on a realistic data set, and the output compared to the expected answer shown in the text. I've read other database books that worked that way and it really made the material much more practical. You've already thought about this, I'm guessing; no? My sample data set is almost finished; if it's of any use, you're welcome to it. Joe Hi Joe, Mariano +1 for some example data Mariano I understand your reasoning for not wanting a full ODB file, and I agree with that. However, you could simply include the data load as part of the script that builds the Schema, or and I would suggest this route. A separate text file file with the insert statements for the test data and have the reader load this via the SQL window again, at the beginning of the section on queries. Best wishes, Drew - To unsubscribe, e-mail: dev-unsubscr...@documentation.openoffice.org For additional commands, e-mail: dev-h...@documentation.openoffice.org
Re: [documentation-dev] Feedback for Base Tutorial -Data set
On 09/01/2010 11:48 PM, mcasan...@instituto-hispano.org wrote: Drew, Joe: Having a data set available for Chapter 10 sounds like a very good idea. I particularly like the option of providing a separate text file with the insert statements to load through the SQL window, as this gives opportunity to showcase another feature available to Base. I do not have a big data set myself and would be happy to accept Joe's offer. Drew, can this be extracted form the zipped file without much hassle? Cheers, Mariano Casanova. Hi, Yes, simply use the SCRIPT command within the SQL Window SCRIPT 'filename' Then use any text editor to open that file, filename and delete everything before the first INSERT statement. The file is good to go at that point. Drew - To unsubscribe, e-mail: dev-unsubscr...@documentation.openoffice.org For additional commands, e-mail: dev-h...@documentation.openoffice.org
Re: [documentation-dev] Publishing final version of Base Tutorial
On 09/21/2010 10:43 PM, Joe Smith wrote: On 09/21/2010 08:43 AM, mcasan...@instituto-hispano.org wrote: Drew, Joe: I am about to publish the latest edition of the Base Tutorial. This version corrects all the errata identified so far (thanks Joe for your contributions) and adds a section on outer joins, among other fixes. Drew, please let me know if you are OK with chapter 10. If it's fine with you I would also like to send you the section on Outer Joins so that you can review the SQL code. Joe, can we count on your offer for a Data Set? Also, could you confirm the spelling of your full name so that I can include it in the acknowledgments? I am hoping to publish this final version by Friday at the very latest. I thank you for your help. Mariano Casanova. Hi Mariano, Sorry for the delay--the sample set turned into more of a project than I expected. Somehow, it always does ;-) Anyway, here's my first complete set: http://www.martnet.com/~jes/temp/MLTut2a.odb I intended for the data to be sensible but I've only just now got it all into the database and have not tested anything, not even the entry forms, but maybe this will be enough to get started. The sample data includes some silly familiar names (therapists Anna Recksiek and Frazer Crane); the meds are all silly/fictitious/OTC=non-prescription (Focusyn, Cordrazine), except I included the real medications mentioned on p109 in the text. I thought it best to avoid looking too much like real medical records, but you may feel the silliness clashes with the more serious tone of the book. We can switch to purely random names (as the patient names are already) quite easily, if you prefer. No attribution is necessary--really--but if you want to include it, my real, actual name is: Joe Smith. Joe Hi Mariano, Joe Joe, I've grabbed the file and will use the data in it as I read the latest text, which I'll do tomorrow.. Cool! Drew - To unsubscribe, e-mail: dev-unsubscr...@documentation.openoffice.org For additional commands, e-mail: dev-h...@documentation.openoffice.org
Re: [documentation-dev] Base tutorial and the new reality
On 10/06/2010 04:59 PM, Joe Smith wrote: On 10/06/2010 02:43 PM, mcasan...@instituto-hispano.org wrote: ... The only thing missing is a reference to loading the collection of data to play with in chapter 10, which Drew and Joe had proposed. I would like to know if the set offered by Joe is available or if Drew would want to create one. A humorous tone is not only fine with me but also encouraged, Joe; but a random set would be as useful. To do this I would like to upload the set so that I can provide the exact URL in the text of the tutorial. ... My sample set is still available here: http://www.martnet.com/~jes/temp/MLTut2a.odb But that's just a temporary location. The release file should be available from some public repository--alongside the text would make it simple for people to find, I expect. If you want the data in some other form, just let me know. Drew mentioned a plain ascii SCRIPT dump. Such a file is trivial to prepare from the .odb, but I'd be happy to convert to whatever format is best. If a different set would be better, that's cool by me--whatever supports the text best. I don't claim any rights to the data--I'm not sure it's even possible to claim any legal rights for randomly-generated data like this. Joe Hi Mariano, Joe, Grabbed the odb file, will check against the schema again in the latest files Mariano uploaded and setup the text files for the data load. I suppose the wiki is as good a place as any for that when I'm done. Should give the permanent link needed. So, something, sometime tomorrow and I'll send email when done - OK. Drew - To unsubscribe, e-mail: dev-unsubscr...@documentation.openoffice.org For additional commands, e-mail: dev-h...@documentation.openoffice.org
