Network Automation Software We are currently migrating this forum
over to our HelpSystems domain. Please
post all new threads in our new
HelpSystems Community Portal.
Post to the HelpSystems Forum
You are not currently logged on. You must be logged on in order to post. Log on
Or Create a new account
AutoMate Discussion
Decrease font size
Increase font size
Topic Title: compare 2 files to identify changes
Topic Summary: How to compare excel/CSV files
Created On: 07/30/2015 11:28 AM
Status: Read Only
Linear : Threading : Single : Branch
Search Topic Search Topic
Topic Tools Topic Tools
View similar topics View similar topics
View topic in raw text format. Print this topic.
 07/30/2015 11:28 AM
User is offline View Users Profile Print this message

Author Icon
DavidHeite
Student (5-19 posts)

Posts: 20
Joined: 02/27/2013

Hello everyone,

We were hoping to get some insight in regards to an Automate process.  We wanted to try to automate comparing two excel (or CSV) files to indentify changes.  For example, each month we have an employee file that is updated but each month has a full population.  We want to compare the two months and determine what was added for the next month.

we are running Automate BPA Server 9.0.5 on a windows 2008 R2 server

If anyone has any suggestions. any help is appreciated!

thanks

david

 



 Category Survey
AutoMate BPA Server 9 version: 9.0.5
Windows version: Windows Server 2008 R2
 07/31/2015 04:45 PM
User is offline View Users Profile Print this message

Author Icon
Valentineo McGowan
HelpSystems

Posts: 766
Joined: 09/03/2013

Hello David,

Presently AutoMate nor BPA Server possess the necessary functionality to run a 'Diff' on the contents of two files.
However I will research this further to see what can be done through the use of other Actions/Activities we have.

 Category Survey


-------------------------

Valentineo McGowan | Technical Consultant
AutoMate | Division of HelpSystems
HelpSystems, LLC | T: +1 213.738.6966 | F: +1.213.738.7665
 08/03/2015 09:42 AM
User is offline View Users Profile Print this message

Author Icon
DavidHeite
Student (5-19 posts)

Posts: 20
Joined: 02/27/2013

Hi Valentineo, thank you very much for the information.  I appreciate your help.  Any additional information you have would be great.  Thanks!!!

 

david

 



 Category Survey
AutoMate BPA Server 9 version: 9.0.5
Windows version: Windows Server 2008 R2
 08/04/2015 12:17 PM
User is offline View Users Profile Print this message

Author Icon
Valentineo McGowan
HelpSystems

Posts: 766
Joined: 09/03/2013

Hello David,

After further deliberation with our team, as I mentioned earlier there is no functionality currently that supports checking the 'difference' between two files. Preferably *.csv.
We do apologize for the inconvenience.

 Category Survey


-------------------------

Valentineo McGowan | Technical Consultant
AutoMate | Division of HelpSystems
HelpSystems, LLC | T: +1 213.738.6966 | F: +1.213.738.7665
 08/06/2015 04:38 AM
User is offline View Users Profile Print this message

Author Icon
BenjaminKorper
Artisan (200-499)

Posts: 231
Joined: 06/18/2009

Hi David,

We have acchieved this behaviour in the past by building the comparison function into a third excel sheet.
Tab1: Datasource 1
Tab2: Datasource 2
Tab3: Formula's that do the comparison

BPA renews the data on tab 1 and 2, Excel automatically calculates the difference, BPA reads the differences from tab 3

If you need any help with this, our services department might be able to help you.

Regards,

Benjamin

 Category Survey


-------------------------

 08/06/2015 04:41 AM
User is offline View Users Profile Print this message

Author Icon
BenjaminKorper
Artisan (200-499)

Posts: 231
Joined: 06/18/2009

Hi David,

We have acchieved this behaviour in the past by building the comparison function into a third excel sheet.
Tab1: Datasource 1
Tab2: Datasource 2
Tab3: Formula's that do the comparison

BPA renews the data on tab 1 and 2, Excel automatically calculates the difference, BPA reads the differences from tab 3

If you need any help with this, our services department might be able to help you.

Regards,

Benjamin

 Category Survey


-------------------------

Statistics
18258 users are registered to the AutoMate Discussion forum.
There are currently 0 users logged in.
The most users ever online was 5551 on 01/08/2018 at 11:11 AM.
There are currently 2237 guests browsing this forum, which makes a total of 2237 users using this forum.

FuseTalk Enterprise Edition v4.0 - © 1999-2020 FuseTalk Inc. All rights reserved.

Sitemap Network Automation Software Blog