Navigate
Wasp Helpdesk
  • Register

  • or
  • Login
    Need a password reminder?
or
Contact Us
  • Get in touch

    Send us an email

  • Start a chat session

  • Knowledgebase Read help articles
  • News News & updates
  • Contact Us We are here to help
  • Training View our options
  • Product Sunsets Non-Supported Products
Barcode System Consult
Barcode Printer Consult
Barcode Label Consult
  • Portal
  • Knowledgebase
  • FAQs
  • AssetCloud & InventoryCloud: Migrating data from MobileAsset v7 or InventoryControl v7
Subscribe Download PDF

AssetCloud & InventoryCloud: Migrating data from MobileAsset v7 or InventoryControl v7

Jason Whitmer
2025-03-25
in FAQs

Symptom: Data exported from MobileAsset v7 or 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: Earlier versions of SQL Server Management Studio do not properly account for special characters when saving results, 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: Versions of SQL Server Management Studio 16 or later 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:
https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms?view=sql-server-ver15 

Note: If you need to run SSMS on a 32-bit version of Windows, this installer of SSMS v16.5.3 will work:
https://go.microsoft.com/fwlink/?LinkID=840946

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 (at least v16).

Note that if you have installed the On-Premise edition of the new product on the same machine as the v7 product, it should have also installed version 18.2 or later of Management Studio, so the download should not be necessary.

Rate the quality of this page

This page was helpful :) :( This page was not helpful

7 of 21 people found this page helpful


Quick Jump
  • Wasp Helpdesk
  • Knowledgebase
  • News
  • Contact Us
Top
Helpdesk software provided by Deskpro