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.

[Read More]

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.

For more information, or extra assistance, please give Technical Support a call at 1-800-903-6571 or email at [email protected]. [Read More]

Stock manager uses a delimited .CSV format which can be edited in excel for its import files. The easiest way to create a template for an import is to actually perform an export from the software in order to generate a .CSV in the correct format.

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]

In order to change a setting in Stock Manager without accessing the program, you will need to use the regedit function in windows.

• 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]