Exporting and importing Job Ticketing data

KB Home   |   Exporting and importing Job Ticketing data

“Why does my imported order data look strange?”

Order data exported from Job Ticketing is encoded in UTF-8. UTF-8 is widely used to accommodate for “non-standard” characters.

When using MS Excel to import data, the encoding used is defined by the OS, which depends on the locale and other settings. To ensure that order data is imported into Excel without corrupting characters, perform the following steps:

  1. From within Excel, under the ‘Data’ tab, click on ‘From Text/CSV’
  2. Select the csv export containing Job Ticketing order data info
  3. In the next step, under “File origin”, select the ‘UTF-8’ encoding option
  4. Complete the import wizard.

Keywords: Job Ticketing


Categories: Job Ticketing

Comments

Share your findings and experience with other PaperCut users. Feel free to add comments and suggestions about this Knowledge Base article. Please don't use this for support requests.

Article last modified on March 07, 2019, at 05:32 AM
Printable View   |   Article History   |   Edit Article