Re: [libreoffice-users] Re: Script to parse spreadsheet and send to own database as CSV or JSON

Hello.  I am not into this kind of stuff, but you can google a bit.  I think you should use csv 
(you can convert json into csv online) and then import and export spreadsheet using calc and base 
to select and manipulate.

https://help.libreoffice.org/6.3/en-US/text/scalc/guide/csv_files.html


https://help.libreoffice.org/3.3/Common/Importing_and_Exporting_Data_in_Base

I think python has this feature also.

Paolo




On Thursday, April 21, 2022, 07:17:29 PM GMT+2, Andrew Pitonyak <andrew@pitonyak.org> wrote: 





I cannot comment on things that are online, but I believe that you can automate LibreOffice using 
Python; even though I have never done it. Well I guess I don't remember if I've done it or not and 
done a lot of things I don't remember just a long time ago. Most of the automation I have done is 
been in basic.

⁣Get BlueMail for Android ​

On Apr 20, 2022, 12:58 PM, at 12:58 PM, Albin <albin@neuroleap.com> wrote:
> Hello,
>
> Just wondering if you've received this question?
>
> Respectfully,
>
> -albin
> ___________________________________________________
> Digital Wizard | NeuroLeap Corp | San Jose, CA, USA
> *Special Power for Special Children!*
> The content of this email is confidential and intended for the
> recipient
> specified in message only. It is strictly forbidden to share any part
> of
> this message with any third party, without a written consent of the
> sender.
> If you received this message by mistake, please reply to this message
> and
> follow with its deletion, so that we can ensure such a mistake does not
> occur in the future.
>
>
> On Fri, Apr 15, 2022 at 10:51 PM Albin <albin@neuroleap.com> wrote:
>
> > Hello,
> >
> > We have spreadsheets filled out by our psychologists and other
> > specialists, which are periodically (in the background) parsed and
> sent to
> > a database on our servers.
> > Currently, we are using Google Sheets and Google Cloud, however, we
> need
> > to migrate to another solution. Since we have no profits and no
> budget to
> > buy anything, I was wondering if we could accomplish the parsing via
> > scripts (preferably using Python) using LibreOffice Calc Online?
> >
> > Thank you.
> >
> > Respectfully,
> >
> > -albin
> > ___________________________________________________
> > Digital Wizard | NeuroLeap Corp | San Jose, CA, USA
> > *Special Power for Special Children!*
> > The content of this email is confidential and intended for the
> recipient
> > specified in message only. It is strictly forbidden to share any part
> of
> > this message with any third party, without a written consent of the
> sender.
> > If you received this message by mistake, please reply to this message
> and
> > follow with its deletion, so that we can ensure such a mistake does
> not
> > occur in the future.
>
> -- 
> To unsubscribe e-mail to: users+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/users/
> Privacy Policy: https://www.documentfoundation.org/privacy


-- 
To unsubscribe e-mail to: users+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/users/
Privacy Policy: https://www.documentfoundation.org/privacy

-- 
To unsubscribe e-mail to: users+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/users/
Privacy Policy: https://www.documentfoundation.org/privacy