Export of Next Likely Purchase recommendations
If the transaction data is loaded with the available data import options, then this call exports the data:
nlpbatch -d "jdbc:postgresql://192.168.56.102/crm_db?user=crm&password=crm" -pr c:/tmp/mapping.csv -s 60 -re 3 -ra 2 -pf "+(equity)" -o ls_results.json
This table shows the command line parameters of the call:
| Option | Abbreviation | Required | Comment |
|---|---|---|---|
| recommendations | -re | Yes | Number of recommendations |
| rationales | -ra | Yes | Number of rationales |
| prodfilter | -pf | Yes | Product tag expression. Example: +(Fixed Income) |
| dburl | -d | Yes | Database connection string |
| schema | -sc | No.
Default public |
Database schema |
| prodresolver | -pr | Yes | File with product mapping |
| exclude | -e | No.
Default "false" |
Exclude purchased products from recommendations |
| size | -s | No.
Default 60 |
Number of existing products |
| csv | -c | No.
Default JSON |
Output in .csv format |
| output | -o | No.
Default STDOUT |
Output file name |
| trfilter | -tr | No.
Default empty |
Exclude transaction filter |