Hello Drew, You have updated the spreadsheet and added the expected return date of chapter 9 macros as 22nd March 2020 and today is 23rd March 2020. Kindly correct it.
Pulkit Krishna On Mon, Mar 23, 2020 at 2:11 PM Pulkit Krishna <pulkitkrishn...@gmail.com> wrote: > Hello Drew, > What about chapter 9 macros? > > Pulkit Krishna > > On Mon, Mar 23, 2020 at 2:11 PM Pulkit Krishna <pulkitkrishn...@gmail.com> > wrote: > >> Hello Drew, >> What about chapter 9 macros? >> >> Pulkit Krishna >> >> On Mon, Mar 23, 2020 at 1:02 AM Drew Jensen <drewjensen.in...@gmail.com> >> wrote: >> >>> Thanks for asking Pulkit. >>> >>> I did search the AOO form didn't see my CSV export tutorial (thinking it >>> must of been on the old oooForum and that is now kaput) - but there are >>> plenty of examples there of using SELECT INTO TEXT function with the HSQL >>> embedded dbms. >>> >>> But then I got thinking that is not the only way to answer this >>> question. The main way people export data from base is with Calc (drag >>> a Table icon or Query icon to a calc sheet for instance), and that there is >>> already good documentation on in the Calc Guide for one thing (it is import >>> there, of course). If you wanted a csv file from a table just drag it to a >>> blank Calc file save it as the .csv file. >>> >>> Dave, does that make sense as a way to go for you? >>> >>> Best wishes, >>> >>> Drew >>> >>> >>> On Sat, Mar 21, 2020 at 10:48 PM Pulkit Krishna < >>> pulkitkrishn...@gmail.com> wrote: >>> >>>> Hello Drew and Dan, >>>> Are you done with your respective reviews? >>>> >>>> Pulkit Krishna >>>> >>>> On Thu, Mar 19, 2020 at 10:13 PM Drew Jensen < >>>> drewjensen.in...@gmail.com> wrote: >>>> >>>>> Also, others may have also, but I wrote a small tutorial on doing this >>>>> (exporting using TEXT TABLES) for the old OOo forums and that should be >>>>> there still. I'll go this evening and see if I can find that and pass >>>>> it >>>>> onto you if I can find it. >>>>> >>>>> On Thu, Mar 19, 2020 at 12:37 PM Drew Jensen < >>>>> drewjensen.in...@gmail.com> >>>>> wrote: >>>>> >>>>> > Howdy, >>>>> > >>>>> > Well, IMO, dumping the DB with a simple script command is great if >>>>> you are >>>>> > migrating the data but for exporting data: >>>>> > >>>>> > You need to look at the HSQLdb documentation on TEXT TABLES and the >>>>> SELECT >>>>> > INTO construct. >>>>> > >>>>> > Using that you can export all of a table or use the standard query >>>>> > functions to export a subset of records or to join records from >>>>> multiple >>>>> > tables into a single export file. >>>>> > >>>>> > I hope that helps, >>>>> > >>>>> > Drew >>>>> > >>>>> > On Thu, Mar 19, 2020 at 12:26 PM Dan Lewis <elderdanle...@gmail.com> >>>>> > wrote: >>>>> > >>>>> >> Page 6 of chapter 10 Database Maintenance contains this section. Can >>>>> >> anyone explain how to actually do this? I can use SCRIPT 'database >>>>> >> name'; and then SET SCRIPTFORMAT TEXT. This reduces the database >>>>> folder >>>>> >> within the *.odb file. But how do I use Tools > SQL after these two >>>>> steps? >>>>> >> >>>>> >> Dan >>>>> >> >>>>> >> >>>>> >> -- >>>>> >> To unsubscribe e-mail to: >>>>> >> documentation+unsubscr...@global.libreoffice.org >>>>> >> Problems? >>>>> >> >>>>> https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ >>>>> >> Posting guidelines + more: >>>>> https://wiki.documentfoundation.org/Netiquette >>>>> >> List archive: >>>>> https://listarchives.libreoffice.org/global/documentation/ >>>>> >> Privacy Policy: https://www.documentfoundation.org/privacy >>>>> >> >>>>> > >>>>> >>>>> -- >>>>> To unsubscribe e-mail to: >>>>> documentation+unsubscr...@global.libreoffice.org >>>>> Problems? >>>>> https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ >>>>> Posting guidelines + more: >>>>> https://wiki.documentfoundation.org/Netiquette >>>>> List archive: >>>>> https://listarchives.libreoffice.org/global/documentation/ >>>>> Privacy Policy: https://www.documentfoundation.org/privacy >>>>> >>>> -- To unsubscribe e-mail to: documentation+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/documentation/ Privacy Policy: https://www.documentfoundation.org/privacy