Create csv from table 1 and upload to table 2

Discussions related to customizing hooks. Hooks are documented at http://bigprof.com/appgini/help/advanced-topics/hooks/
Post Reply
cloudsea
Posts: 2
Joined: 2015-12-12 15:46

Create csv from table 1 and upload to table 2

Post by cloudsea » 2017-08-11 16:29

Hi,

I have a batch action which allows we to send the contents of a table ("table 1") to a csv file (which is currently downloaded to client).

Is there any way that this file can be "attached" into a field in another table ("table 2"), upon a similar command? - i.e. without the user downloading the csv, then re-uploading it to the new table?

I guess I would run the command from the table 2 view, and it would collect whatever contents are in table 1 and attach as a csv to a defined upload field.

Thanks a lot in advance of any ideas.

Steven

User avatar
a.gneady
Site Admin
Posts: 1281
Joined: 2012-09-27 14:46
Contact:

Re: Create csv from table 1 and upload to table 2

Post by a.gneady » 2017-08-13 13:35

If you set the concerned field in table2 as a file upload field, and you save the CSV file to the default upload folder (usually the "images" folder) then all you need to do is save the CSV file name into that field.
:idea: AppGini plugins to add more power to your apps:
  • DataTalk is an innovative AppGini plugin based on ChatGPT that allows you to interact with your AppGini database using natural language questions, without writing any SQL. Check the demo video
  • Mass Update plugin: Update multiple records at once and improve your workflow efficiency.
  • Check our other plugins and get a generous discount of up to 30% when buying 2 or more plugins.

Post Reply