Symptom: Data exported from MobileAsset/InventoryControl v7 using the supplied v7 Export Scripts includes commas, quotation marks, or embedded carriage returns, causing those records to not import cleanly or at all.
Cause: SQL Server Management Studio does not properly account for special characters when saving results in older versions, causing the records to appear to have extra columns, enclose larger pieces of data into a single field, or break single records into one or more lines, which will prevent the import process from being able to read the record into the expected columns.
Resolution: Newer version of SQL Server Management Studio are updated to properly enclose data fields with those special characters in quotes, so they can be processed properly when importing. We recommend you download and install the current version of the Management Studio from this link, and use it to export the data:
This will not replace the existing version of Management Studio on your machine, so both versions will be available. Make sure you are using the new version by watching for the version number on the splash screen when launching the program. (v18.4 as of this writing)
Note that if you have installed the OnPremise version of the new product on the same machine as the v7 product, it should have also installed this newer version of Management Studio, so the download should not be necessary.