Hello,
I've been doing a lot of digging around on the forums and I have not found conclusive answers for my questions. If someone would be so kind to answer them, that would be great!
First a description of what my end goals are:
I want to create a script to automatically generate side-by-side difference reports for roughly 100 csv files. I would like to dump 50 of the files in one folder and dump the remaining 50 files in a second folder. Read the folders in the script and loop through each file in each folder creating difference reports for them, ending with a total of 50 difference reports.
Preferably I would like to create an html-color report and save it as an MS Excel file (*.xlsx) - but from what I was reading this is not doable in BC4. So I will need to save the difference reports as *.html files and then open each one in Excel and perform a Save-As *.xlsx.
Below is my command line to activate the script:
Below is the code for the script:
Question 1: How can I automatically generate a name for each difference report. Currently I have "Diff_Report.html" as the name but this will obviously overwrite every single difference report file and I will be left with one difference report at the end, rather than 50 difference reports. I would like to use a part of the name from the .csv files so they can easily be recognized if that is possible?
Question 2: Is it possible to set up rules in the script for the data-report, for example enable "unsorted alignment "?
Question 3: Is it possible save the difference report as a MS Excel file? (From material I've read I don't think it is)?
I've been doing a lot of digging around on the forums and I have not found conclusive answers for my questions. If someone would be so kind to answer them, that would be great!
First a description of what my end goals are:
I want to create a script to automatically generate side-by-side difference reports for roughly 100 csv files. I would like to dump 50 of the files in one folder and dump the remaining 50 files in a second folder. Read the folders in the script and loop through each file in each folder creating difference reports for them, ending with a total of 50 difference reports.
Preferably I would like to create an html-color report and save it as an MS Excel file (*.xlsx) - but from what I was reading this is not doable in BC4. So I will need to save the difference reports as *.html files and then open each one in Excel and perform a Save-As *.xlsx.
Below is my command line to activate the script:
Code:
BCompare.exe @"C:\Users\probat\Desktop\Compare_Sample\Sample_Script.txt"
Code:
# Generating a report of differences # This script generates a report of only differences. #_____________________________________________________ # Set up basic comparison features. criteria rules-based # Filter out log files. filter "*.txt; *.mdb" # Load first comparison. load "C:\Users\probat\Desktop\Compare_Sample\First_Folder" "C:\Users\probat\Desktop\Compare_Sample\Second_Folder" # Compare files with timestamp differences. select all.diff.files # Generate a report of the differences. data-report layout:side-by-side & options:ignore-unimportant,line-numbers & output-to:"C:\Users\probat\Desktop\Compare_Sample\Diff_Report.html" & output-options:html-color
Question 2: Is it possible to set up rules in the script for the data-report, for example enable "unsorted alignment "?
Question 3: Is it possible save the difference report as a MS Excel file? (From material I've read I don't think it is)?
Comment