StreetSweeper Pro automation - Common parameters
This document lists the parameters available for automation in StreetSweeper Pro. It includes notes on changes for legacy users to facilitate conversion to the new product.
Products affected: StreetSweeper® Pro
| Parameter | Values | Purpose | Required | Notes |
| FILE = | Database file path and file name | Required | Fixed length or DBF | |
| ACCENT_TYPE= | ANSI / UTF8 / PC8 | Database file encoding option | Optional | UTF-8 if unspecified |
| UPDATE_INPUT= | Y/N | Y updates input file, N creates output file | Optional | also UPDATE=[INPUT/OUTPUT] |
| OUT_FILE_TYPE= | FIXED / COMMA / TAB / DBF | Output file format | Optional | Same as input type if unspecified |
| OUT_FILE_NAME= | Output file path and file name | Optional | Input file name with “_export” added to the end if unspecified. | |
| COMMANDS= | AC, LC, NCOA, DL | Processes to be run | Optional | Single process can be specified on command line. |
| START_RECORD= | # | Starting record # | Optional | Value greater than means there’s a header row. |
| RECLEN= | # | Length of database record | Required | also SIZE= Records may be longer than specified. |
| NAME1= | x,y | NAME1 field | Optional | |
| NAME2= | x,y | NAME2 field | Optional | |
| NAME3= | x,y | NAME3 field | Optional | |
| ADDRESS1= | x,y | ADDRESS1 field | Required | |
| ADDRESS2= | x,y | ADDRESS2 field | Optional | |
| CITY_NAME= | x,y | CITY field | Required | |
| PROV= | x,y | PROVINCE field | Required | |
| POSTAL_CODE= | x,y | POSTAL CODE field | Required | also PSTCDE= or PST_CDE= |
| MAILER_NAME= | [company/customer name] | Company/Customer name | Required | If the name matches with a company/customer record from the interface, it will import all of that information. |
| MAILER_ADDRESS1= | [address 1] | Company/Customer address 1 | Required* | Required if MAILER_NAME doesn’t match with a company/customer record. |
| MAILER_ADDRESS2= | [address 2] | Company/Customer address 2 | Optional | |
| MAILER_CITY= | [city] | Company/Customer city | Required* | Required if MAILER_NAME doesn’t match with a company/customer record. |
| MAILER_PROVINCE= | [province] | Company/Customer province | Required* | Required if MAILER_NAME doesn’t match with a company/customer record. |
| MAILER_POSTALCODE= | [postal code] | Company/Customer postal code | Required* | Required if MAILER_NAME doesn’t match with a company/customer record. |
| DROPDT= | MMDDYYYY | Drop date | Optional | Today’s date if not specified. |
| RECORD_ID= | x,y | Record ID field | Optional | Not used, transferred to output database. |
| USER1= | x,y | User-defined field | Optional | Can be used to define language identifier. |
| USER2= | x,y | User-defined field | Optional | Not used, transferred to output database. |
| USER10= | x,y | User-defined field | Optional | Not used, transferred to output database. |
| ||END | End of file marker | Optional |
Note: For Y / N VALUES, the following are acceptable values for Y: YES, ON, Y, T, TRUE, VALID, OUI, VRAI.
UPDATED: 18 October 2024