Create a CSV file and upload it on google drive

[Giorgio_Alfonzi]

Hi, i'm a newbee so i'm sorry in advance if i can't compriend even the basic.

I have not tested it, but probably I sourted out the "create a csv file" now the big deal is to upload it on google drive, i have read this guide: https://groups.google.com/g/mitappinventortest/c/ppfzpAlo8Ek/m/2yKfZyh0AQAJ, but i'm not good enough to borrow only part of the script that I need, also i can't compriend the WEB APP script thing, in a post I have read that you need to publish the app... totally lost!
Can someone help? thank you in advance.

[TIMAI2]

See here for uploading a file.

• Upload Any File To Google Drive with AI2

You may want to consider just uploading the data to a google sheet?

• HOWTO: Create a Google Apps Script Web App bound to a Spreadsheet

• Google Sheets - Simple POST and GET Data

[Giorgio_Alfonzi]

HI, thak you for the advice, I will try to follow the guide.
But before that I have another problem:

The SaveFile should save the file in the path "sdcard" because the fileName start with "/", but it doesn't work!, I tryed with emulator, app companion, and the apk, same problem.
As you can see down in the image the program create a path to save every file, so I should be able to put as file name "/CSV/" and it should work. When I test it with the path "/CSV/" it says that the path /storage/emulated/0/Android/data.../CSV could not be created, it's pointing the wrong path!, that I can't even see without a rooted phone.
Any idea?

[TIMAI2]

Are you using an Android 11 device ?

[vknow360]

FileTools is not fully compatible with Android 10 and higher versions, currently.

[Anke]

@Giorgio_Alfonzi

As you can see down in the image the program create a path to save every file, so I should be able to put as file name "/CSV/" and it should work. When I test it with the path "/CSV/" it says that the path /storage/emulated/0/Android/data.../CSV could not be created, it's pointing the wrong path!

Problem with July 30 2020 Version: nb184 no longer able to write and read files

No, it is written to the app-specific directory (ASD): Companion: /storage/emulated/0/Android/data/edu.mit.appinventor.aicompanion3/files compiled app (APK): /storage/emulated/0/Android/data/<packageName>/files Cause: The file component (for API level ≥ 29) adds the ASD path to the beginning of each path that you declare. If I save a text in the ASD [grafik] this path is returned (but doesn't exist and cannot be created): /storage/emulated/0/Android/data/edu.mit.appinventor.aico…

See also here:

Save a text file or an image (Canvas) in the ASD & share it on all Android versions

How to save a file (text, Canvas: image) read and share it on all Android versions. [grafik] Note: You cannot share a text file from the → Private dir (internal storage): /data/user/0/<packageName>/files/

@Giorgio_Alfonzi

that I can't even see without a rooted phone.

Yes, on Android 11 this path is no longer visible on your device using the default FileManager.
Use Total Commander (app) or connect your device to your computer / notebook via USB and open this path from there.

[Giorgio_Alfonzi]

Yes, i'm using android 11, so I solved my problem utilizing "total commander" and only adding a new folder "CSV" in the normal files path.
Now everything works i'm starting the second part of the program, the upload to google drive.
I have many questions:

• , i pasted the link of drive open to everyone that has the link, is this correct?

• refering to this guide https://ai2.metricrat.co.uk/guides/upload-any-file-to-google-drive-with-ai2 and knowing that everyfile that i create should go instantanly on Google Drive, i suppose that i don't need a "SelectFile" that complicated, right?

• I think I need this part

  
  , but i don't understand what URL_WEBAPPSCRIPT is.

I'm pretty lost D: i'm sorry I know that i'm asking for much.
kind regards.

[Giorgio_Alfonzi]

This are the updated block of my app

• I don't know where to write the script for URL_WEBAPPSCRIPT
• I don't know if I did well the mimetype part
• I think i should put nothing in the design URL part of the Web1, unlike the img sent before
  Thank you guys so much for helping me, much appreciated.
  Kind regards.

[hay_kel]

You can see this video on youtube: How to use a CSV file stored in Google Drive by an App Inventor application - YouTube