[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: [libreoffice-documentation] Exporting data: how is it done


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 <pulkitkrishna00@gmail.com>
wrote:

> Hello Drew,
> What about chapter 9 macros?
>
> Pulkit Krishna
>
> On Mon, Mar 23, 2020 at 2:11 PM Pulkit Krishna <pulkitkrishna00@gmail.com>
> wrote:
>
>> Hello Drew,
>> What about chapter 9 macros?
>>
>> Pulkit Krishna
>>
>> On Mon, Mar 23, 2020 at 1:02 AM Drew Jensen <drewjensen.inbox@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 <
>>> pulkitkrishna00@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.inbox@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.inbox@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 <elderdanlewis@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+unsubscribe@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+unsubscribe@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+unsubscribe@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

References:
[libreoffice-documentation] Exporting data: how is it doneDan Lewis <elderdanlewis@gmail.com>
Re: [libreoffice-documentation] Exporting data: how is it doneDrew Jensen <drewjensen.inbox@gmail.com>
Re: [libreoffice-documentation] Exporting data: how is it doneDrew Jensen <drewjensen.inbox@gmail.com>
Re: [libreoffice-documentation] Exporting data: how is it donePulkit Krishna <pulkitkrishna00@gmail.com>
Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.