Parker Software Ltd Homepage
Forum Home Forum Home > ThinkAutomation Business Process Automation > ThinkAutomation Version 4
  New Posts New Posts RSS Feed - Processing csv attached to email
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Processing csv attached to email

 Post Reply Post Reply
Author
Message
AlexUhde View Drop Down
New User
New User


Joined: 26 Dec 2017
Location: Brisbane
Points: 22
Post Options Post Options   Thanks (0) Thanks(0)   Quote AlexUhde Quote  Post ReplyReply Direct Link To This Post Topic: Processing csv attached to email
    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
Back to Top
Liam View Drop Down
Admin Group
Admin Group
Avatar

Joined: 29 Jun 2011
Location: Stoke-on-Trent
Points: 266
Post Options Post Options   Thanks (0) Thanks(0)   Quote Liam Quote  Post ReplyReply Direct Link To This Post 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
Back to Top
Nexent1 View Drop Down
New User
New User
Avatar

Joined: 24 Jun 2010
Location: Mississauga
Points: 38
Post Options Post Options   Thanks (0) Thanks(0)   Quote Nexent1 Quote  Post ReplyReply Direct Link To This Post 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.
Back to Top
 Post Reply Post Reply
  Share Topic   

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 11.05
Copyright ©2001-2016 Web Wiz Ltd.

This page was generated in 0.099 seconds.