Storage Unit Import with Powershell
Importing Storage Units (SUs) into CompuTec WMS using PowerShell streamlines bulk data entry and ensures efficient warehouse setup. This guide walks you through the complete process - from preparing your CSV files to executing the import script. Whether you're setting up your WMS for the first time or updating existing records, this tutorial helps you avoid common pitfalls and get the job done right.
How to use the Import Script
Follow these steps to set up and run the Storage Unit import using PowerShell:
-
Download the files from here.
-
Copy the net45 directory to C:\
-
Run Powershell ISE (x64) or Powershell (version 7 only) as Administrator:
-
Open the ImportSU file in Notepad, copy its content and paste it to the Windows Powershell ISE:
-
Enter correct credentials (login and password from CompuTec WMS):
-
Choose the correct database type using one of the following options:
dst_MSSQL = 1,
dst_DB_2 = 2,
dst_SYBASE = 3,
dst_MSSQL2005 = 4,
dst_MAXDB = 5,
dst_MSSQL2008 = 6,
dst_MSSQL2012 = 7,
dst_MSSQL2014 = 8,
dst_HANADB = 9,
dst_MSSQL2016 = 10,
dst_MSSQL2017 = 11,
dst_MSSQL2019 = 15
-
Enter the correct path to your prepared .csv files:
-
Copy the BusinessObjects folder from CompuTec WMS to C:\Windows\System32\WindowsPowerShell\v1.0:
-
Run the script to begin the import process.
CSV Files Preparation
-
Download the CSV Files from here.
-
Open Microsoft Excel.
-
Go to Data tab and open From text/CS:
-
Open SUHeader.csv / SULines.csv.
-
In the data type detection menu, select Do not detect data types. Then load the file:
-
Right-click on the following columns: U_Code, U_WhsCode, U_BinCode, U_SSCC (U_Parent as well, if you create SU in SU) and change the type from General to Text:
-
Enter relevant data: new, different U_Code and U_SSCC, correct warehouse and bin codes. Check the U_BinAbs (AbsEntry from OBIN)
-
Enter the proper data for the following SULines: ItemCode, Quantity, Manage Type, Item Type and DistNumber. Remember, that the Code must be the same as U_Code from SUHeader.
-
Save the files as CSV UTF-8 (comma delimited) format. Adjust the delimiter (; or ,) based on your region and configure it accordingly in the script:
-
Open the saved files in Notepad and delete the first row (headers) before import: