Saturday, July 26, 2008

Import Price List Overview (Expanded)

1. Go to the Price List window by clicking on the Price List button at the top of the screen.



2. Click on the "Import PL" button.



3. Click on 1. Find File


Click to enlarge




4. Find the IMPORTME or your own DB, I'm using my own Tim's Database file in your QwikQuote directory (usually \Program Files\QQ6). Then click Open.



5. Click on the IMPORTME.DBF file so that it appears in the "File Name:" box in the upper left of the "Open File for Import" box (Make sure the Files of type: selection box says "DBase III"). Then click on "Open".
Click to enlarge









6. Click on the down arrows on the right side of the box labeled "Part Number" and click on the choice called "PART_NO." You have just told QwikQuote that you want to import the field "PART_NO" into the Part Number field within QwikQuote.












7. Make appropriate choices for the rest of the fields. For instance, choose "MANUFACTURE" from the list for the field labeled "Manufacturer."






8. It is not necessary to have a choice for each field. For instance, you would leave the "Weight" field as "None" since there is no data to import to that field.




9. When you have aligned the fields, click on the "2. Import Records" button to begin the process. .10. QwikQuote asks you to create a new database by naming it. Enter a database name in the "File name" field. For instance, "Products." You do not have to add the ".mdb" extension, it will be added automatically for you. Then click "Save".11. The bar that appears below the import buttons will fill to 100% while QwikQuote imports the records, and you will see the list you have imported in your product database.

No comments: