Buyers can be imported from an excel spreadsheet.
1. First create an excel spreadsheet with the following fields. (note: there are many other fields you can use, these are just some of the more common fields used when importing.) 
2. Enter buyer information on spreadsheet. (note: If you choose not to use bid card numbers buyers will only be imported into "Buyer Maintenance".)
3. After completing your spreadsheet, save it and close excel.
4. Open Auction Flex and click the Auction Maintenance button 
from the Navigator or the Navigator toolbar.
5. If you have previously entered the auction use the navigation buttons 
to locate it otherwise click the new button 
to create a new auction.
6. Click the Exit this form button 
to close Auction Maintenance.
7. Click the Buyer Check-In 
button from the Navigator or the Navigator toolbar.
8. Click the Import button 
from the Auction Buyer Controls section.
9. Ensure that you are on step 1and click the ellipses button 
and locate your excel spreadsheet.
10. Click the Step 2 Tab and choose the fields that we created for our spreadsheet. (note: Fields must be in same order as spreadsheet.)
Field Mappings Explained (skipping self explanatory fields):
| • | Mailing Codes (Format = XX XX - this import field is designed for customers importing a list of buyers from other software programs where the mailing list codes are stored in groupings of 2 letters such as: AN VE where the AN might stand for Antiques and the VE might stand for vehicles. You can have up to 15 2 letter mail codes in this field. |
| • | Mailing List 1-10 (Y/N) - these import fields are designed for customers importing a list of buyers where there is a separate column for each mailing list and wherein the designation is Y or N (yes and no respectively) for whether or not the buyer is subscribed to the mailing list. A blank column will be interpreted as N. A mailing list will automatically be created for each mailing list (the description for the mailing list will be MAILING LIST 1, MAILING LIST 2, ETC. For records with a Y indicator, the buyer will be subscribed to the mailing list. |
| • | Mailing List Code 1-10 - these import fields are designed for customers importing a list of buyers where there is a separate column for each mailing list and wherein the "Code" of the mailing list is included in the column instead of Y or N. Examples might be ANTIQUES BOATS DIRIGIBLES VEHICLES. A mailing list will automatically be created for each unique mail code included in your import file and the buyer will be subscribed to this mailing list. |
11. Click the Step 3 Tab and click the view selected file button. Be sure to check the Skip First Row When Importing check box.
12. Click the Step 4 Tab. Click the appropriate rules that apply to you.(For this tutorial we will use the Default settings.)
13. Click the Step 5 Tab and Click the Import Buyers button 
.