Proxis Stock Manager

Stock Manager exports its inventory to a comma-separated value (.csv) file. Unfortunately, Microsoft Excel's default behavior, when opening a .csv file, is to treat numeric columns as numbers, and in so doing, it removes leading zeroes and converts long numbers to scientific notation. As barcodes are typically long strings of numbers, often with leading zeroes, this presents a problem when it comes to opening your Stock Manager inventory in Excel.

Before we begin, you will need to make sure that you have set Windows Explorer to display file extensions for known file types. You may find directions for this in the Microsoft knowledge base. After you have done that, follow these steps to open your file in Microsoft Excel:

1. Export your inventory to a .csv file. To do this, in Stock Manager, click File, point to Export Inventory, and click Full File. Select a location, then click Save.
2. Locate your file in Windows Explorer. Right-click on the file, then select Rename.
3. Highlight the portion of the file name which says csv and press Backspace. Type txt, then press Enter.
4. Open Microsoft Excel. Hold Ctrl and press O to open a new file, and select the location and file you have just renamed.
   Note: You will likely need to select All Files (*.*) from the drop-down menu to the right of the File Name field before you are able to locate your inventory file.
5. Click Next.
6. Click to check Comma and then click Next.
7. Select the left-most column under Data preview, then select Text under Column data format. Click Finish.

Your file should now be successfully imported into Microsoft Excel, without any loss of integrity in your item number field.

You will need to download the msstdfmt.dll file from the internet and place in in the C:\Windows\System32 folder. Once you have done that you will want to open up a command prompt window and enter in the following:

cd c:\windows\system32

regsvr32.exe msstdfmt.dll

If this doesn't work, place the msstdfmt.dll file into the c:\windows\system folder. Then run the same command as above but change system32 to system.

Creating an export:

• File > Export Inventory > Full File

Creating the import:

• Edit the rows with the correct information
• Avoid any commas or quotations in any of the fields
• Save the file
• If you're prompted that some features will be lost if you save as a CSV (Comma delimited). Click Yes to keep the format.

Importing the file:

• File > Import Inventory
• Click Browse and locate the saved .CSV for the import.
• Once the import is selected, click Test File
• There should be a preview for the file output created showing any errors in red.
• Click Import to complete the process.
[Read More]

• To do so, hit the Windows key + r. This should open the Run box.
• In the run line, enter regedit and click okay.
• Go to the following key and make the change desired:
  • HKEY_CURRENT_USER\Software\VB and VBA Program Settings\Stock Manager\Preferences\Database
  • Double click on the Database_File and then change the path to the new path.
  
  
  
  
  
  
  Updated: 12/7/2007 12:44:41 PM JD [Read More]