Print Page | Close Window

Excel end of file indicator

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=9406
Printed Date: 22 Oct 2021 at 4:19am
Software Version: Web Wiz Forums 11.05 - http://www.webwizforums.com


Topic: Excel end of file indicator
Posted By: GenTent
Subject: Excel end of file indicator
Date Posted: 19 Aug 2019 at 2:04pm
Is there a slick way to determine that I've reached the last record of a file pickup, in this case excel? 

-------------
thanks,

Mark Carpenter

www.gentent.com

WeaterProof Your Power!



Replies:
Posted By: Biker-Jim
Date Posted: 19 Aug 2019 at 5:24pm
File pickup will result in the entire file being processed as one message, which if you have a spreadsheet isn't typically most people want to happen.

I would suggest using the CSV / Excel Spreadhseet pickup instead
http://www.thinkautomation.com/help/csvpickup.htm" rel="nofollow - http://www.thinkautomation.com/help/csvpickup.htm

That method processes each line as a new message.

You could then look into using the trigger actions and your own custom database to keep track of what row number you are on.

For example, each time you process a new line take the value from a database field, and add 1 to it, then update your database field with a trigger action. A 'count' in short.


Posted By: GenTent
Date Posted: 20 Aug 2019 at 8:18am
Hi Jim, thanks for the response.  I am using the excel pickup.  The issue is I do not know how many rows (messages) are coming in, so I don't know when I receive the last message.  I'd like to know when I process the last message so that I can send a "finished" message to my operators. 

-------------
thanks,

Mark Carpenter

www.gentent.com

WeaterProof Your Power!


Posted By: Biker-Jim
Date Posted: 21 Aug 2019 at 9:11am
There's no straight forward way of doing what you're asking. The only method I could think of would involve complex scripting. I'll mention it to the developers and get a feature request raised to see if we can't add a function that does an action, like send an email, once the last row is done or something.


Posted By: GenTent
Date Posted: 21 Aug 2019 at 9:15am
Hi Jim, I think that's brilliant thinking.  An email that could be captured by another trigger could work quite nicely, or an %msg_EOF% indicator built-in variable.  Thanks for looking into this. 

-------------
thanks,

Mark Carpenter

www.gentent.com

WeaterProof Your Power!



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