Some users may experience issues accessing the case portal. For more information, please click here.

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

Business adapter imports large numbers as scientific notation

Business adapter imports large numbers as scientific notation

When importing large numbers in Business Adapter Studio from an Excel spreadsheet, they may show in scientific notation (for example, 1.01578e+010) in the FlexNet Manager Suite UI. This commonly occurs for purchase order numbers or serial numbers that you may not want expressed in scientific notation. Large values become expressed as scientific notation due to the behavior of Microsoft's OLE DB driver, which reads the source data.

 Change the cell data type

To correct this, you can use a schema.ini file to specify the data type for any cells you don't want to show in scientific notation.

1. Change the cell category in the Excel spreadsheet cell to text.

Right-click on the cell(s), choose Format cells, select Text, then select OK.

         format cells.png
 
2. In the data source view, enable the Read "Intermixed" data columns as text option under the Excel File Properties section.

inter.png

3. Use a schema.ini file to specify the data type when importing. The schema.ini file will be consumed in the process.

NOTE: See Microsoft's documentation for help with Schema.ini Files (Text File Driver).

Was this article helpful? Yes No
No ratings
Version history
Last update:
‎Dec 28, 2022 12:06 PM
Updated by:
Contributors