Aug 15, 2024 01:55 PM
Aug 15, 2024 02:33 PM
Hi,
Check your CSV
Aug 15, 2024 05:39 PM
Hi,
I did, this is the csv string: 320,390,390,390,480,590,590,590,590,
Aug 16, 2024 12:12 PM
Aug 18, 2024 02:02 AM - edited Aug 18, 2024 02:03 AM
Do you need to create a new table or import new data in the existing?
I'm used
and it's quite simple.
but if you need to use Extension to add data to existing table, you should include field names as a first row
You can use this code to generate if you have a lot of fields
console.log([...Array(15).keys()].map(n=>'KeyM'+n).join(','))
of course, this should be enabled
Aug 18, 2024 06:40 AM
Hi,
The extension requires a $20 plan. Not interested.
The file is a simple notepad, no headers
Can you tell me where the green toggle is located.?
This seems like a simple issue.
Aug 18, 2024 11:02 PM
I thought you used extension because usual add table function has no Field Map details like in your screenshot.
Now it's clear. I never used Import Data but it's almost the same as Import with Create new table.
Import function must know which field to use for which number, and it reads first line of csv as field names.
So, CSV must contain several lines and first is field names
And since field name must be unique, it adds extra numbers 2, 3 etc
Easiest workaround is to duplicate line in CSV, to have it like:
320,390,390,390,480,590,590,590,590
320,390,390,390,480,590,590,590,590
and then in options select
The alternative solution is to Download CSV (in View menu) and use list of fields from it.