Use FileUpload to get CSV and update database

[Andrea_Rector]

I must be missing something fairly straightforward because I can’t figure out how to use the File Upload component to update a database, after selecting one csv file. The user manual has this documentation but it doesn’t show how to script writing the data to the database.

There’s also this post about Scripting importing multiple csv and inserting into sql Database but it uses the filepath which I don’t have when using the File Upload component.

Any recommended resources?

[PGriffith]

Start with this topic:

Perspective onFileReceived - CSV

Having issues trying to figure out how to parse a CSV and get it into a database from perspective using the file upload component. I have looked around most of the afternoon on the forum and can’t quite find any examples that are not people trying to parse images. sdata = event.file.getBytes() byteArray = bytearray(sdata).decode("UTF-8") system.perspective.print(byteArray) I have the above and it will print out the data in the CSV file in a string list I am assuming with the decode. What I …

[Andrea_Rector]

Thank you!