• 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Importing a csv to livecloud from your app, and notes on importing CSV data
#1
Hi Everyone:

First of all

the CSV import in livecloud is an awesome feature. , Can you show us if its accessible via command or code to do from the client side app? For instance , take the contacts app example.. A client would want to import his own data into his clients app.

It would also be cool to show how it can be done from a datagrid.

A note for people using MSExcel 2010 to generate .csv files : It errors  , but if you upload the file to google sheets and then download it as a csv..it works wonderfully.

I'm not sure if its a purely 2010 excel version issue. Maybe later editions work. 

Sid
  Reply
#2
Problem solved!

Mark and Efrain have fixed the issue and the improved API will be released soon that will solve imports from MSexcel csv files

For those of you needing do this in the meantime:

you can replace the semicolon of the header line with comma and it will work. This should only be broken in the header (line 1 of the text file). - MSExcel exports their headers with semicolons instead of commas. This is not the standard.

Well done on the quick response to my support request guys.

Sid
  Reply
#3
Hi Sid,

We just pushed an update to LCM right now. You have a new function called cdb_importCSV(pTable, pTarget, pPath). The docs online have been updated with information on the new API: https://docs.livecloud.io/ImportCSV/

There are other useful fixes to LCM in this update as well. See the change logs for more details.
  Reply
#4
(03-11-2020, 01:15 AM)mark_talluto Wrote: Hi Sid,

We just pushed an update to LCM right now. You have a new function called cdb_importCSV(pTable, pTarget, pPath). The docs online have been updated with information on the new API:  https://docs.livecloud.io/ImportCSV/

There are other useful fixes to LCM in this update as well. See the change logs for more details.

Hi Mark,

Thank you for this.

Its a great feature and will be used extensively.

Sid
  Reply
#5
That is great to hear. Thanks for feedback.
  Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)