Difference between revisions of "Information Systems:Downloading Purolator invoices"
Jump to navigation
Jump to search
(Created page with "FTP credentials for downloading invoice files off the Purolator FTP site. These are uploaded once per week. They are currently still being emailed to Gerald/John, but technica...") |
|||
| (5 intermediate revisions by 2 users not shown) | |||
| Line 4: | Line 4: | ||
* Username: 24247882 |
* Username: 24247882 |
||
* Password: f7Yn(9Ja#Y |
* Password: f7Yn(9Ja#Y |
||
| + | * Change Mode to Binary |
||
| + | * Change remote directory to OUT |
||
| + | * GET or MGET the latest files - since this is a manual process compare what file dates are present on the SuperServer and download what we don't have to a local temp folder |
||
| + | * Open the csv file in Excel and change columns CD and CE and FC to a number format with zero decimal places |
||
| ⚫ | |||
| + | * Answer YES to the formatting question |
||
| + | * Repeat for each new file on the Purolator FTP site |
||
| + | Please try and leave a copy of the file on the FTP site and just download a copy for our use. I use the free FTP client FileZilla. It's so clever, because it's like Godzilla, but for files. (I know right?!) |
||
| ⚫ | |||
Latest revision as of 16:01, 23 November 2017
FTP credentials for downloading invoice files off the Purolator FTP site. These are uploaded once per week. They are currently still being emailed to Gerald/John, but technically they are now only supposed to be retrievable only by FTP. The invoice file will be in the OUT folder.
- FTP Server: ftp2.purolator.com
- Username: 24247882
- Password: f7Yn(9Ja#Y
- Change Mode to Binary
- Change remote directory to OUT
- GET or MGET the latest files - since this is a manual process compare what file dates are present on the SuperServer and download what we don't have to a local temp folder
- Open the csv file in Excel and change columns CD and CE and FC to a number format with zero decimal places
- Then save as a CSV to \\SUPERSERVER\Distribution Centre\Richmond\GeraldP\Freight GP\Purolator\Raw Invoices
- Answer YES to the formatting question
- Repeat for each new file on the Purolator FTP site
Please try and leave a copy of the file on the FTP site and just download a copy for our use. I use the free FTP client FileZilla. It's so clever, because it's like Godzilla, but for files. (I know right?!)