Print Page | Close Window

Processing csv attached to email

Printed From: Parker Software Ltd
Category: ThinkAutomation Business Process Automation
Forum Name: ThinkAutomation Version 4
Forum Description: For questions relating to ThinkAutomation Version 4
URL: http://www.parkersoftware.com/forum/forum_posts.asp?TID=9422
Printed Date: 28 Feb 2021 at 9:30am
Software Version: Web Wiz Forums 11.05 - http://www.webwizforums.com


Topic: Processing csv attached to email
Posted By: AlexUhde
Subject: Processing csv attached to email
Date 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



Replies:
Posted By: Liam
Date 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


Posted By: Nexent1
Date 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.



Print Page | Close Window

Forum Software by Web Wiz Forums® version 11.05 - http://www.webwizforums.com
Copyright ©2001-2016 Web Wiz Ltd. - https://www.webwiz.co.uk