Sorry for double post, decided to break my answer into two separate posts so that it’s not confusing or too long because it unrelated to the first post.
Regarding Airtable CSV import… it works mostly Okay but I do have some issues which are related to the way I use CSV Extension and the way I use it is just to import text, no attachments in my case.
-
The mapping is not permanent, if I have mapping pre-set, and I end up importing a wrong CSV, the mapping will be reset and Airtable import extension will try again guess the mapping pairs, and if I cancel the import process and then open the correct CSV to import, the mapping is broken with some pairs so I have to remap. For that reason I had to use multiple copies (I have about 10 copies of the CSV Import Extension in Airtable) to be able to pre-set mapping, plus another 10 copies as backup so I can restore the mapping if things get messed up.
-
Airtable CSV import extension only auto-maps a CSV field ones, I may have 2 fields in my Airtable, one being the matching field and another being the edit field (I do that because the edit field may be empty but the matching field is autogenerated in case the edit field is empty, this allows me to avoid imports into wrong records). Anyhow, the 2nd pair being identical must be setup manually. Because Airtable CSV Extension things that is not a good idea, it always overrides my mapping and I have to manually pair that 2nd pair before every import. That kind of relates to point above.
-
Airtable CSV Import extension doesn’t warn me if a field mapping is missing (again related to previous points)
-
Extension doesn’t warn me if I am importing the wrong file (maybe if I could set in the extension to warn me if the file name of the imported CSV does not match in part the preset file name when I set up the CSV import template. That would prevent the issues described above in many cases.
-
I have 100’s of fields so going through that longe list of Airtable fields when mapping it to my CSV is very tedious, the fields are not even sorted alphabetically, but rather by date when the field was created (this is one of the weird nags in Airtable). So I wish there was easier way to find the field i am looking for from the list of my fields. An ideal wish would be also if the fields that are paired, would go to the top of that list, see how the field order works in Interfaces, there selected fields move to the top, the bottom has list of hidden fields. Something like that could be nice to have also for that Airtable CSV extension.
-
This is just wish list… The extension could also give me better to preview what is being updated through the import of the CSV record, that would be nice to have.
-
Some CSV files have headers and other messy comments so I am dependent on using Easy Data Transfer app which is an amazing app although quite costly, to manipulate CSV data before import. I couldn’t imagine Airtable extension would be able to handle something like that, but a few basics would be nice, such as setting from which row the data is imported, which row is the header, which rows at the bottom to ignore, and maybe using something like a text or regex filter to ignore certain rows… again this is just a wishful thinking.