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
  • 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
2021-10-04
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: The current version of SQL Server Management Studio is 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 

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 v18)

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 20 people found this page helpful


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