HI Matthew,
Would using a button on a PAW book with the "Allow file upload" box check work for you?
Assuming a user clicks the button and uploads a CSV/TXT file, the file will end up in the model_data folder.
Pass the filename from the button with the Control Type=File.
From there, the TI can use Location and the filename to process it as a data source name for server...
------------------------------
George Tonkin
Business Partner
MCI Consultants
Johannesburg
------------------------------
Original Message:
Sent: Thu January 02, 2025 05:07 PM
From: Matthew Berson
Subject: Upload a flat file from Excel to PA SaaS
We're looking for a creative way to get a file (CSV) from Excel to the PA SaaS server to then be consumed by a TI process.
We initially tried to just use DBSW formulas to upload the data but it is too slow and also seeing some odd behavior on the server side with this.
It would be amazing if you could upload a file from Excel to the upload directory (model_upload) and I will be putting an RFE out there for that.
I suspect in the v11 server (PA on Cloud) you could leverage the Externals directory, but it doesn't seem like that directory is accessible via TI in V12.
------------------------------
Matthew Berson
------------------------------