cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

7 digit PO number(one-off upload) converts to exponential value

ImIronMan
By Level 6 Flexeran
Level 6 Flexeran

Hi Team

When we tried to import PO's using "one-off upload" - all details are imported successfully, however the PO number shown as scientific number like 1.23e+00, we observed its happening with 7 digit PO numbers. 

6 digit purchase orders does not seems to have any issue

Regards

Rajesh Ponnala

#poimport

(2) Solutions

Hi Rajesh,

Can you try this, please?

When using the default template for importing POs as well as when using a business importer (MGSBI)

  • If you are importing from an Excel (.xlsx) file, make sure all data in the "PO Number" column are formatted as "Text" (data display left aligned in Excel)
  • If you are importing data from a CSV file, use a "schema.ini" file to specify that the "PO Number" column needs to be treated as "Text".

View solution in original post

Generally, the "schema.ini" file should be present in the same folder as the CSV file.

There is plenty of information available on how to create/use a "schema.ini" file, like:

View solution in original post

(4) Replies

Hi Rajesh,

Can you try this, please?

When using the default template for importing POs as well as when using a business importer (MGSBI)

  • If you are importing from an Excel (.xlsx) file, make sure all data in the "PO Number" column are formatted as "Text" (data display left aligned in Excel)
  • If you are importing data from a CSV file, use a "schema.ini" file to specify that the "PO Number" column needs to be treated as "Text".

ImIronMan
By Level 6 Flexeran
Level 6 Flexeran

Thanks  @statler for your quick response

Will surely try , as you suggested.

Can you please assist me where to find schema.ini file ? and is this file must be present in the csv file folder  while importing?

 

Regards

Rajesh Ponnala

Generally, the "schema.ini" file should be present in the same folder as the CSV file.

There is plenty of information available on how to create/use a "schema.ini" file, like:

Thank you !!

Good Day !!