I would like to perform the action of importing a csv file even if the csv file contains additional lines before the headers, this is a user constraint of my application, to avoid any manual intervention by the user. Is it possible to create an automation with Appscript to preprocess the user’s csv file to make import possible with Appsheet’s native import action? Appsheet events only relate to data change type and not to a click on an action from what I could see. I had a look around the editor and forums and didn’t find much. Thank you in advance for your help.
May I ask what kind of data are you planning to have before headers? Lot of rows? What?
The csv file used for import is exported from a tool and the first five lines are like this:
Version 4.0.4.0
Date 06/12/2023 5:54 p.m.
DBid 7
DB name B82y
Data definition
After these lines follow the headers
The csv file will be used to populate the corresponding fields of a table in the application’s Appsheet database.
With the app directy you can’t do that as the CSV import action doesn’t allow additional rows before the header row. The only way I can think of..
#1 - The app user uploads the CSV file through the app
#2 - That triggers the Bot that triggers the script
#3 - The script reads the data starting from the 6th row
#4 - It writes the data to your data source the app is using
This is exactly what I tried to do but the only events which cause the activation of a process (call a script in this case) are Data change type events, I do not see in the editor the possibility of choosing the fact that the user is trying to perform the import action as the trigger. I also told myself that I could define an action of type execute a sequence of actions with as first action “go to a website” which will direct the user to a web page which will allow him to process the csv and return the csv well formatted then the second and last action of this sequence will be the native Appsheet import csv action, But I am not sure that after having obtained the well formatted csv file by returning to the application the user will be able to directly carry out the import