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
  • Cloud
  • InventoryCloud
  • Using InventoryCloud Export Scripts
Subscribe Download PDF

Using InventoryCloud Export Scripts

Russ Hart
2023-01-19
in InventoryCloud
  1.  Transaction history, purchase orders and pick orders cannot be exported from InventoryControl or imported into InventoryCloud.
  2. In order for the export scripts to work properly you need to use  SQL Server Management Studio 2016 or newer
    *Note: This is not merely a recommendation. 
    The export will not work properly in earlier versions of SSMS 
    (not even the version of SSMS installed with InventoryControl v7 by default).
  3.  SQL Server Management Studio 2018 can be downloaded here https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms?view=sql-server-ver15
  4. Download the scripts and extract them to a folder
  5. Login to SQL Server Management Studio using sa and Wasp$07Wasp$07 for user name and password (Enterprise users with your own SQL Server may be different)
  6. In SQL Server Management System go to Tools > Options > Query Results > SQL Server > Results to Grid and ensure that "Include column headers when copying or saving the results" is checked.1614106264042.png
  7. In SQL Server Management Studio, make sure that WaspTrackInventory is selected, then click on File > Open File.  Choose the appropriate SQL Script. 
  8.  Click on Execute 1621266116090.png
  9. Once it has executed successfully right click in an empty space and choose Save Results As 1621266226816.png Give the file a name associated with the number and name of the sql file that produced it.1621266296327.png
  10. Export your data using all number scripts.  If there are no results you do not need to save the file.
  11. Once all files have been saved, open InventoryCloud.  Click on the gear icon and choose Form Customization 1621266554562.png
  12. Open the file created by 00_CustomeFields.sql and create a custom field for each row. 1621266707835.png Click on New, choose the data type and type your field name and click Visible 1621266776688.png Then click Save at the bottom of the screen 
  13. After creating all of your custom fields you should be able to import your data using the files you saved from the database, in the order listed.
    ****Note: Be advised that users with the basic edition of the software may not have the ability to import sites, this will cause all subsequent form numbers to be off by one.



If you have images or attachments in InventoryControl, you can use the article below to import them into your InventoryCloud 

https://support.waspbarcode.com/kb/articles/assetcloud-inventorycloud-how-can-we-import-the-attachments-from-mobileasset-inventorycontrol 

Rate the quality of this page

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

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