I need to automate a reconciliation of two folders that contain over 50 CSV files.
I have created a BC3 script that creates HTML output reports. I have found some issues:
I have created a BC3 script that creates HTML output reports. I have found some issues:
- Generated reports do not include a helpful summary of the counts of matches, approximate matches, mismatches, and the totals. Is there a way to get that or is the situation still the same as in this 2007 post?
- Comparison and HTML report writing seems to take around 8 minutes. However, if I open the session and Compare Results it only takes 1.5 minutes. Is it possible to accelerate it? If not, is there a way to start BC3 from the command line in a session (which I know I can) AND start the folder comparison automatically (to save the user manually selecting all files and clicking on Compare Results?
- I am creating rules for each of the files and saving them to a BC3 session. I have discovered that the folders for comparison are stored as absolute paths so that if the session is used on the same directories, but on a different absolute path, then all the rules are lost. E.g. if the rules are defined for C:\temp\side-a\file1.csv and then used on C:\temp-different\side-a\file1.csv then BC3 does not recognise the rules. Is there away to migrate rules e.g. if directory is changed, but the relative path is the same, then the rules would kick in?
Comment