UPLOADING TXT and XML files.. IS IT POSSIBLE?...

(Andrea Sala) #1

UPLOADING TXT and XML files… IS IT POSSIBLE?

I need to upload *.xml files in my spreadsheet. I’ve made some experiment with a “file” column type.

XML (and txt too) are uploaded in Drive and my spreadsheet as an image (format *.JPG).

Is it possible to upload them as data? Are there any workarounds?

(Praveen Seshadri (AppSheet)) #2

No, right now, file attachments are primarily meant to be PDF files.

(Andrea Sala) #3

Ok. Thanks for the answer.

Is it something you are planning to do, or you’re not interested in such develpements?

I would like to enable my users to upload XML files via app, in order to automatically import their structured content in my Google spreadsheet.

The XML schema never change.

My goal is to auto populate my spreadsheet with the values of data imported from the xml, in order to do some calculations and to present the results in an Appsheet View.

Thanks again.

(Andrea Sala) #4

BTW as I mentioned before, when I upload an xml file through Appsheet it is stored in Google Drive as an image (format *jpg) but as soon I rename it (in *.txt or *.xml) it is immediately readable with notepad.

So probably, I just need a script in order to automatize the renaming and the importing.

Do you think it could be done with a Google script?