|
Processing csv attached to email |
Post Reply 
|
| Author | |
AlexUhde 
New User 
Joined: 26 Dec 2017 Location: Brisbane Points: 22 |
 Post Options
 Thanks(0)
 Quote Reply
 Topic: Processing csv attached to emailPosted: 13 Oct 2020 at 6:53am |
|
Hello all,
I would like to know how I can process a csv file attached to an email in an efficient way. What I have done so far is always use 2 account, one which safes the file and one that then picks it up. I'm just wondering if there is a way to do it all in one account. Kind regards,
Alex |
|
 |
|
|
Liam
Admin Group 
Joined: 29 Jun 2011 Location: Stoke-on-Trent Points: 267 |
Post Options
Thanks(0)
Quote Reply
Posted: 12 Nov 2020 at 10:55am |
|
Hi alex
unfortunately this is probably the best way of working this scenario. There isn't really a way of processing a CSV, row by row within a trigger. Liam
|
|
|
|
|
Nexent1
New User
Joined: 24 Jun 2010 Location: Mississauga Points: 38 |
Post Options
Thanks(0)
Quote Reply
Posted: 29 Dec 2020 at 8:34pm |
|
Hi AlexUhde ,
I do this all the time using the Is Repeating Block feature. The first trigger is set just to parse each row and pass it to the second trigger. The second Trigger parses the data in each line and updates a SQL DB. I have both triggers in the same account and do not need to save the file and pick it up with another account. If you look up the examples of the Is Repeating Block feature, it gives good examples on how to do this.
|
|
|
|
|
Post Reply
|
|
Tweet
|
| Forum Jump | Forum Permissions You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum |
Topic Options