Scheduling cost account imports in PitneyShip Pro or PitneyShip Enterprise
If you need to add new cost accounts on a regular basis, you can schedule regular imports from an SFTP server.
- To use scheduled imports, you must have a CSV file stored on an SFTP server.
- Whatever changes you make to your import source file will be added to your PitneyShip Pro or PitneyShip Enterprise cost accounts. However, your source file must stay in the same format.
- You can only schedule one location at a time. If you want to schedule imports for multiple locations, repeat this scheduling process for each location.
The features and options you see may vary depending upon your role and subscription. If you have any questions regarding your permissions, please contact your administrator.
The following characters are not allowed for cost account names or codes:
~ ` ^ & - = \ | { } [ ] “ ; < >
Determining which method to use
There are two different methods of scheduling cost account imports depending upon your subscription features.
Method 1: Without "Cost Accounting" account list management service
If you do not use the "Cost Accounting" account list management service, your Cost Accounts screen in PitneyShip Pro or PitneyShip Enterprise will look like this. It will have an Automatic Import List tab and the Import button will have a drop-down menu. You will use Method 1.
Method 2: With "Cost Accounting" account list management service
If you do use the "Cost Accounting" account list management service to synchronize your cost accounts across all of your Pitney Bowes products, your Cost Accounts screen in PitneyShip Pro or PitneyShip Enterprise will look like this. It will have a Schedule Import tab and the Import button will not have a drop-down menu. You will use Method 2.
Method 1: Without "Cost Accounting" account list management service
- Select Settings > Cost Accounts.
- Select Import > Automatic Import.
- Select Download a .csv template.
- Make sure that the format of your cost accounts file matches the format of the template file.
Important: The data columns must be in the same order as in the template. - Select the Text Delimiter that is used in your file.
- Enter the SFTP Filename Path and SFTP Server URL.
Note: Include the port number at the end of the URL. For example SFTP-PITNEYCLOUD.COM:22 - Select the Authentication Option you wish to use.
- If you selected Password, enter the SFTP Username and Password.
- If you selected SSH Keys (PEM Format), enter the Username, then select Choose File and upload your SSH Key file in PEM format.
- Select the Test Access button to test the connection.
- Select Notifications.
- Enter the email address(es) you want to be notified if the import fails.
- Select Schedule.
- Select the Days and Time you wish the import to occur.
- Select Continue.
- In the Configure Automatic Import window, match your CSV file fields in the Your CSV Fields column with the SendPro 360 fields in the Location Fields column, then select Save Configuration.
- Select Import.
Method 2: With "Cost Accounting" account list management service
Watch this video or follow the instructions below to learn how to schedule cost account imports if you use the "Cost Accounting" account list management service.
- Select Settings > Cost Accounts.
- Select the Schedule Import tab.
- Select the location you want to associate with your cost account list.
- Select Add Config.
- Enter your SFTP Username and SFTP Password.
- Enter the SFTP Filename Path and SFTP Server URL.
Note: Include the port number at the end of the URL. For example SFTP-PITNEYCLOUD.COM:22 - In the Emails field, enter the email address(es) you want to be notified if the import fails.
- Select the Frequency of the import.
- Select Continue.
- Map the cost account fields to the fields in your CSV file.
- Select Save and Close.
Related topics
UPDATED: September 10, 2024