Support • PartBase PRO Manual

Maintenance Utilities: Import, Misc. Utilities, Delete, Pack and Reindex, START

These utilities are used for cleaning up invalid data in various database files. The invalid data could result from importing. Some of these functions allow you to select the "Database Files to Process". You may select Inventory or Requirements. You also may choose "All Offer Files" or "Select Offers Files" which will allow you to select which offer file(s) to maintain. 

Separate Offers into proper files - This utility would only be used if the databases were out of order. For example, if you found a part number that starts with a 3 in the offer database that starts with 2's. Having this situation is rare. It could happen if there were some sort of data corruption.

Check for Invalid Characters - When you run this utility PartBase PRO will search the database for invalid characters. An invalid character is a character that is not a number, letter, or standard symbol. In the Settings box you have a choice to change the invalid characters to a space or delete the record with the invalid characters. 

After clicking "Ok", you then choose the database that you would like to run this function on -  inventory, requirements, or offers.

On the screen, the company code you want to change is on the left side. The company code you want converted to is on the right side. The center section is for your own internal use, you may type in any note about the code change you like, and it does not affect the function of the utility.

Prior to running this feature we recommend you go to the PartBase “Reports” section and select the “Print Unmatched Supplier Codes” option. This will give you a printed list of company codes that are in your Supplier Offers database that do not appear in your View/Edit Company database. The codes that show up on this list could be a new company that you have no knowledge of, or they are companies that are already in your View/Edit Company database but have a different code assigned to them. Research this list and add all codes that need to be changed into the “Convert Company Codes” utility. After this utility is run we suggest you also run "Delete Duplicates" and "Pack and Reindex".

In the "Convert?" column, by putting a "Y" next to the company code will mark this record to be converted. Double click or click the "Tag/Untag" button to put "Y" in this field. Click it again to remove it. Click on "Tag All" to mark all the records to be converted. Click "Close" when finished editing the table to continue.

In version 1.0.008 or higher, there are also other fields in the Conversion Table: Import from, Imported Phone, Imported Fax, & Imported Email.

Currently it is used by Importing Hi-Tech Parts (HTP) . New HTP company codes, which are in the format HTP#### where #### is the member #,  can automatically be imported into the Company Codes Conversion Table. There is no need to manually enter in new codes to convert. While importing, company codes will automatically be converted to the PartBase code if it exists in the conversion table. 

It is also used by Importing IC Source "Digest.zip" file.

Fix invalid reference #'s in inventory - This is applicable only if you have the Inventory Module and Sales Module. This function would be used if you were using the older version of PartBase (IIx or earlier). Certain invalid entries that occurred in that version could have been update into PRO. These invalid reference #'s may cause incorrect items to be invoiced.