BAI2Excel

· Account - /ACCT

· Data Import (include to activate) - /BAI2

· Source File for import - /SRCE

· Output File Detail - /OUTD

· Output File Summary- /OUTS

A valid source file would be any file formatted in BAI version 2.

Syntax Example

If Treasury Desktop was installed in the default location:

c:\Program Files\TreasurySoftware\BRCOM.exe /ACCT="sample" /BAI2 /SRCE="C:\aaavb\1000\Data\citi.txt" /OUTD="c:\testdetail.csv" /OUTS="c:\testSumm.csv"

Reminder:

Turn on/off appropriate settings.  From the main menu 'File', 'BAI File Conversion', 'Output' tab - unselect open in Excel afterwards.

Notes for all applications:

· The order of the parameters is not significant

· Capitalization is not significant

· When specifying a file name (SRCE), use the full file path and name within quotes. When using mapped drives, remember that the path should be centric/relative to the machine where Treasury Desktop is located, not the machine issuing the trigger/command.

· Place the account name in quotes.

Working with multiple users and multiple account:

Each command line trigger - will create an independent instance of the application. There is no limit to the number of instances.

If processing simultaneous command line requests, use different accounts (Sample1, Sample2, etc...) to minimize any record locking issues. If this is not an alternative, consider processing sequentially, or using our Control Panel.

For Web and Citrix based applications, please contact a Treasury Software support representative.