Importing locations automatically on a schedule in PitneyShip Enterprise

You can import locations into the system automatically on a fixed schedule from an SFTP server.
Products affected: PitneyShip® Enterprise

Enterprise administrators can import shared locations into the system automatically on a fixed schedule from an SFTP server.

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.

  1. Select Settings > Divisions & Locations.
  2. Select Import > Automatic Import.
  3. Select Download Template.
  4. Make sure that the format of your locations file matches the format of the template file.
    Important: The data columns must be in the same order as in the template.
  5. Select the Text Delimiter that is used in your file.
  6. Enter the File Path and SFTP Server URL.
  7. 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.
  8. Select the Test Access button to test the connection.
  9. Select Notifications.
  10. Enter the email address(es) you want to be notified if the import fails.
  11. Select Schedule.
  12. Select the Days and Time you wish the import to occur.
  13. Select Continue.
  14. In the Configure Automatic Import window, match your CSV file fields in the Your CSV Fields column with the PitneyShip Enterprise fields in the Location Fields column, then select Save Configuration.
  15. Select Import.

To view past automatic imports, go to the Automatic Import List tab and select History.

To view or change saved configurations, go to the Automatic Import List tab and select Configurations.

Related topics

UPDATED: August 28, 2024