Import orders from CSVΒΆ

Migrate orders from your current workflow system to PACE Packager Hub. The migration process consists of two steps: (1) export data from your workflow system to CSV file; (2) import orders from the prepared CSV file to PACE Packager Hub.

Important

Precondition 1 : You have the Supervisor role.
Precondition 2 : Sign In on Web Portal of PACE Packager Hub.
  1. First, choose an Organization and Project in the top-left corner you will work with. The list shows only those projects to which you are assigned.

    navigation-row-dropdown-projects

  2. In the top-right corner next to New order, click the button-down-arrow down arrow and select Import from CSV.

    orders-import-orders

  3. Click Browse and choose the prepared CSV file that contains the exported data you need to import to PACE Packager Hub.

    orders-import-orders-step1-browse

  4. Review the parsed data from the selected CSV file in the Data preview section. If everything looks fine, click Next > located at the bottom. Otherwise, change the file parsing parameters such as Encoding, CSV delimiters and Text qualifier, so that the data is properly parsed. Then, click Next >.

    orders-import-orders-step1-preview

  5. Then define how items from the CSV file will be imported into your project on PACE Packager Hub. Import all items (1) as a single order type (e.g. App Packaging); or (2) as several order types (e.g. App Packaging, Bug Fix, Support Request). For the option #(2) you need to choose a mapping between the CSV item types and order types of your project. For this, select the CSV column that defines an item type, and then set respective order type for each unique value from this column.

    Click Next > to continue.

    orders-import-orders-step2-multiple

  6. Set mapping between columns from CSV and order attributes of your project. For this, for each CSV column you need to import set the order attribute from the list that will keep the value. Some commonly used attributes such as Status, Assignee and others may be pre-selected automatically.

    Note

    In case of importing items from CSV as several order types, you need to choose the attribute mapping for each order type separately (they are presented as horizontal tabs).

    orders-import-orders-step3-NOK

  7. For attributes of the System user, Date, Dropdown list type and the Status, you need to map values from CSV with the possible values of the attribute.

    If you see the red NOK label next to the selected attribute, click Set mapping and define the value mapping settings. For instance, you can map old (non-existing) statuses from CSV to the new order statuses of the project.

    orders-import-orders-step3-set-mapping

  8. When the mapping between attributes and values is completed and all red NOK labels have disappeared, click Import > at the bottom of the dialog.

    orders-import-orders-step3-OK

  9. Wait for the import to complete and then Close the import summary.

    orders-import-orders-summary

  10. Find the imported order on the All orders tab of your project.

    orders-import-orders-view-imported




Note

PACE Packager Hub PACE Packager Hub is an end-to-end ecosystem that is fully dedicated to customer servicing, teamwork, and management of packaging tasks in teams of any size - learn more.

Try PACE Packager Hub for free - 21 days no obligations unlimited trial with all functions unlocked.