BAS only updating specific assets and reformatting data automatically.

[StefanGrisham]

Hello, 

Currently attempting to import assets via BAS. When doing so only 13 out of the 192 get imported even though these are the same formats as the records not being created. Lastly, it seems like BAS is changing the format of excel data automatically. For example:

Serial number 12801210492 shows up as 1.2801e+010

IP address 172.32.110 shows up as 172.30

Attached are the logs appearing on the import.  

[gsc_mysam_sggl · Accepted solution]

Hi @StefanGrisham,

It seems the data in excel file is in general format, try changing the entire serial number and ip address column into text format by selecting the entire column and then in the home menu-number module dropdown choose text value so that the entire column will be identified in excel file as text and while importing that data into the DB using BA, it will be marked as varchar instead of int or float. This way you can temporarily fix the issue for the data in wrong format. As a permanent fix, you can follow the below link which automatically modifies the format of the column in excel to most repeated format.

Using FlexNet Business Adapters FlexNet Manager Suite 2022 R1 - Working With Excel Files (flexera.com)

Coming to the values importing only 13/192, I can say without logs that the matching criteria attribute you used in BA, should be blank in the excel file and the import rule is set to reject the record if it is duplicate.

It is better to raise a support case and get help so that they can check the logs and the source file too and guide you on this issue.

Hope this helps.

Regards,

Srikanth

[StefanGrisham]

Good morning,

It looks like I was able to save the excel as a regular spreadsheet instead of CSV and select the "read intermixed data as text" checkbox to avoid OLE-DB from changing the format. Coincidentally this fixed the issue of only 13 assets being created out of 192