Difference between revisions of "Information Systems:Downloading Purolator invoices"
Jump to navigation
Jump to search
m |
|||
| Line 4: | Line 4: | ||
* Username: 24247882 |
* Username: 24247882 |
||
* Password: f7Yn(9Ja#Y |
* Password: f7Yn(9Ja#Y |
||
| + | * Open the csv file in Excel and change column CD and CE and FC to number with zero decimal points |
||
| + | * Then save as a CSV |
||
Place the files here: \\SUPERSERVER\Distribution Centre\Richmond\GeraldP\Freight GP\Purolator\Raw Invoices |
Place the files here: \\SUPERSERVER\Distribution Centre\Richmond\GeraldP\Freight GP\Purolator\Raw Invoices |
||
Revision as of 15:36, 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
- Open the csv file in Excel and change column CD and CE and FC to number with zero decimal points
- Then save as a CSV
Place the files here: \\SUPERSERVER\Distribution Centre\Richmond\GeraldP\Freight GP\Purolator\Raw Invoices
I use the free FTP client FileZilla. It's so clever, because it's like Godzilla, but for files. (I know right?!)