Nov 14, 2020 08:51 AM
I have a base that is designed to be refreshed with data from a CSV file periodically. It has about 140 fields right now and I need to add approximately 50 more. I would like to be able to do this using the CSV Import app, but I can’t find a way to have it load data into existing fields AND add new columns to the base at the same time.
I have field descriptions entered for most of the existing fields, which is a big reason why I don’t want to just start over with a new import to create the new fields. If I could get and set field descriptions via API, that would be another route to my goal, but I haven’t found any evidence that’s possible.
Am I stuck adding the new fields one by one or is there another way?
Thank you for any light you can shed.
Solved! Go to Solution.
Nov 14, 2020 11:51 AM
Hi Tom, and welcome to the community!
Correct. This is not supported in the CSV import feature despite many requests. [sigh]
Correct, the REST API doesn’t support this either (again, despite many requests). The SDK does (to a limited degree) but that requires you build your import process as a custom REACT javascript custom app - a non-trivial task indeed.
I think you’re stuck, but, you can probably mitigate the effort with this approach.
I’m unsure if tools from @openside can help in this regard but it’s worth a mention.
Nov 14, 2020 11:51 AM
Hi Tom, and welcome to the community!
Correct. This is not supported in the CSV import feature despite many requests. [sigh]
Correct, the REST API doesn’t support this either (again, despite many requests). The SDK does (to a limited degree) but that requires you build your import process as a custom REACT javascript custom app - a non-trivial task indeed.
I think you’re stuck, but, you can probably mitigate the effort with this approach.
I’m unsure if tools from @openside can help in this regard but it’s worth a mention.
Nov 14, 2020 02:09 PM
I ended up doing essentially what you described and brute-forced it, since it was a one-time task. Having your confirmation that there wasn’t really any other feasible alternative made the difference, so thank you for taking the time to respond!
Dec 14, 2022 06:16 PM
Hi - this is still not possible?