+10Hello the community,
I want to write a script which will read the data from a csv file which is in the attachment field "doc" in the table "fileImport"
The csv has 4 columns:
Nom,Ligne,Jour,Valeur
here is an example of the data:
Nom,Ligne,Jour,Valeur Bornet Marc,AL / ASD,2024-04-01,2
Doe John 85%,AL / ASD,2024-04-01,17
I want to parse all data and to create/update/delete records in the table "Planning" and writing the data in the appropriate field:
Nom,Ligne,Jour,SV
how can I do such a script
Best answer by Thierry_Gattlen
Sorry, I don’t know scripting, so I can’t help you with your specific request. Hopefully, someone else will be able to help you with writing a script below.
In the meantime, while you’re waiting for other people to chime in below, if you are interested in doing this in a no-code way that doesn’t require writing any programming code at all, you can do all of this with Make’s CSV automations and Make’s Airtable automations.
I give an entire demonstration on parsing CSV files into Airtable by using Make on this episode of the BuiltOnAir podcast.
If you’ve never used Make before, there is a bit of a learning curve, so I’ve assembled a bunch of Make training resources in this thread. For example, here is how you would instantly trigger a Make automation from Airtable. I also give live demonstrations of how to use Make in many of my Airtable podcast appearances here. For example, I show how to work with attachment fields in Make in this video, which may be helpful for you.
Hope this helps! If you’d like to hire an expert Airtable consultant to help you with anything Airtable-related, please feel free to contact me through my website: Airtable consultant — ScottWorld
Thank you for @ScottWorld for your answer.
Going via Make is not possible because the CSV is behind a VPN. I have succeeded in making this script with the help of Chat GPT. The problem now is to put the CSV in Airtable using the API... which seems to be complicated.
To solve this, we are writing the content of the CSV in a long text field and parse it. It is working very fine.
Thanks for your help.
Thierry
+35Sorry, I don’t know scripting, so I can’t help you with your specific request. Hopefully, someone else will be able to help you with writing a script below.
In the meantime, while you’re waiting for other people to chime in below, if you are interested in doing this in a no-code way that doesn’t require writing any programming code at all, you can do all of this with Make’s CSV automations and Make’s Airtable automations.
Make can pull your CSV file out of your attachment field, parse all of the data from that CSV file, and do whatever you’d like with that data!
I give an entire demonstration on parsing CSV files into Airtable by using Make on this Airtable podcast episode.
If you’ve never used Make before, there is a bit of a learning curve, so I’ve assembled a bunch of Make training resources in this thread. For example, here is how you would instantly trigger a Make automation from Airtable.
I also give live demonstrations of how to use Make in many of my Airtable podcast appearances here. For example, I show how to work with attachment fields in Make in this video, which may be helpful for you.
Hope this helps! If you’d like to hire an expert Airtable consultant to help you with anything Airtable-related, please feel free to contact me through my website: Airtable consultant — ScottWorld
+10Sorry, I don’t know scripting, so I can’t help you with your specific request. Hopefully, someone else will be able to help you with writing a script below.
In the meantime, while you’re waiting for other people to chime in below, if you are interested in doing this in a no-code way that doesn’t require writing any programming code at all, you can do all of this with Make’s CSV automations and Make’s Airtable automations.
I give an entire demonstration on parsing CSV files into Airtable by using Make on this episode of the BuiltOnAir podcast.
If you’ve never used Make before, there is a bit of a learning curve, so I’ve assembled a bunch of Make training resources in this thread. For example, here is how you would instantly trigger a Make automation from Airtable. I also give live demonstrations of how to use Make in many of my Airtable podcast appearances here. For example, I show how to work with attachment fields in Make in this video, which may be helpful for you.
Hope this helps! If you’d like to hire an expert Airtable consultant to help you with anything Airtable-related, please feel free to contact me through my website: Airtable consultant — ScottWorld
Thank you for @ScottWorld for your answer.
Going via Make is not possible because the CSV is behind a VPN. I have succeeded in making this script with the help of Chat GPT. The problem now is to put the CSV in Airtable using the API... which seems to be complicated.
To solve this, we are writing the content of the CSV in a long text field and parse it. It is working very fine.
Thanks for your help.
Thierry
+3Hello
Thank you,
Isis
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.