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