Step 1 – Install Pitcher
Copy the files located in the 'VLPitcher' folder to a new folder called 'VendorLink' in the Program Files folder. This folder can usually be found in the following path: C:\Program Files.
Step 2 – Configuration
Go to the folder where you copied the files in the 'VLPitcher' folder in Step 1. Usually this is C:\Program Files\VendorLink. An example file is also included in the appendix of this manual.
Open the configuration file VLCProquroClient.ini and enter the following settings:
| Setting | Enter |
| connectiontype | sql or dsn |
| datasource | instance of the server (eg: schema) |
| initialcatalog | the name of the database |
| userid | the SQL username |
| password | the SQL password |
| tables | a list of tables or views, separated with a | |
| code | the unique VendorLink customer code, which can be requested via support@vendorlink.nl |
| proxy* | true or false |
| usedefaultcredentials* | true or false |
| ip* | the hostname of the proxy server |
| username* | a username for the proxy server |
| password* | a password for the proxy server |
| filepath | the location of the file to retrieve |
| filetype | the file extension of the file, without a full stop (example: csv) |
| separator | the delimiter used in the file (example: | ) |
| removefirstline | yes or no (determines whether the first row in the file will be deleted) |
| removelastline | yes or no |
* = not required
Step 3 – Job settings
To improve the data quality, the data can be read into VendorLink every day. To set this up, the VendorLink Pitcher must be run every night so that the data is sent to VendorLink. After installation, the executable in the C:\Program Files\VendorLink folder can be added to a Windows task that starts the VendorLink Pitcher once every evening between 19:00 and 01:00.