CUS Business Systems
  • Home
  • About CUS
  • Software Products
    • Powerful CUS Features
    • Auction Management System
      • Online Auctions Overview
    • Mail & Marketing System
      • InterLink
    • Inventory System
    • Custom Forms
    • Release Updates V 11
  • Online Auction/InterLink
    • Online Auctions Overview
      • Sample Online auction
    • Salebill
    • InterLink
  • Services
    • Services we offer
    • System Requirements
    • Release Updates V 11
    • Download Center
      • Version 10 Download Center
      • Version 11 Download Center
      • Version 12 Download Center
    • Remote Support
  • Contact Us
Search

How do I import outside data into my Auction?

Posted by Tech Support - February 27, 2013 -
0

You can import auction lotting data from an outside Excel type file format into the CUS Inventory System. From there, you will be able to transfer it to an auction.  Your Excel file needs to contain the data fields that you want to import with a header row containing the correct CUS field names. No commas or double quote marks are allowed. You can use Excel’s Find/Replace feature to replace commas with semi-colons. Save the file as a comma delimited (.csv) file format with a simple file name (usually the auction name). The best place to save the file is in the aucinv directory either on your local C: if you’re on a single user or your network drive, usually F:

Once the file is saved, close it and go into the Inventory System. Go to Utility Menu, ASCII file import. Enter the location of the file you saved or use the drop down arrow to find it. Enter the name of the auction that these items will be assigned to. The data will be imported into your Main Inventory file with the auction name assigned to each lot. You’re ready to transfer the lots into your auction.

Got Questions? or Comments?
Contact Us
Click here to visit the
Online Sample Auction

Quick Link Section
Auction Management System
Mail and Marketing System
Inventory System

(c) 2019 CUS Business Systems