VERIFIED SOLUTION i
X

Data corruption while converting Sagent Weblink exported '.csv' data into '.xlsx' format

Issue

After exporting data from Sagent Weblink, data gets corrupted while converting data from CSV to XLSX format. This could occur for alphanumeric data.

Cause

This could happen if the data is not converted from CSV to Excel format using text option in the 'Text import wizard' of Microsoft Excel.

Resolution

UPDATED: August 10, 2018


Use following steps to convert CSV to Excel format:
  1. Open Microsoft Excel.
  2. Select 'Data' > 'From Text'. This opens the 'Text Import Wizard'.
  3. Click on Next, then select the delimiter as 'comma' (or as applicable).
  4. Click on Next.
  5. In the 'Data Preview' section, select the affected column (which has alphanumeric data or which has the error).
  6. Now select 'Text' in the 'Column data format' option.
  7. Click on 'Finish'
User-added image

Environment Details

Product Feature: Weblink Client

Downloads

  • No Downloads