![]() |
Processing csv attached to email |
Post Reply ![]() |
Author | |
AlexUhde ![]() New User ![]() Joined: 26 Dec 2017 Location: Brisbane Points: 22 |
![]() ![]() ![]() ![]() ![]() Posted: 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 |
![]() ![]() ![]() ![]() ![]() |
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 |
![]() ![]() ![]() ![]() ![]() |
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 |