You can use the Import Resources Wizard to import resources from an external data source. This tool provides a quick way to add new resources to your database or update information for existing resources.

Getting Started

The Import Resources Wizard walks you through the process of importing new resources, or new information about existing resources.

To launch the Import Resources Wizard, click Resources at the top right of the B2W Operational Suite window, then select Import Resources.

Importing Resources

  1. On the Select Add-in page, choose the format from which you'll be importing and click Next to continue. Note that your choices are limited to your installed Resources Import add-ins. You can download import resources add-ins from the B2W Community Portal
  2. On the Select Resource Type to Import page, select the type of resource you want to import. Depending on the source of your import data, you may be able to select multiple resources types at once. For example, when importing from a CSV file, you can import only one resource type at a time, but when importing from a Viewpoint database, you can import multiple resource types at once.
  3. Depending on the type of import you're performing, the things you do on the Import Settings page differ. If you are using a file-based import such as .CSV, click Browse to select the file from which you'll be importing.
  4. Also on the Import Settings page, select the type of import you want to perform. Your choices are:
    • Update Records Only
    • Update & Add Records
    • Add Records Only
    Note that these options may vary depending on the type of resource you are importing. For example, when importing Labor Type Rates, these choices do not appear, as this type of information may only be updated, not added.
  5. On the Import Mappings page, your actions will vary somewhat with the type of add-in you are using. For example, when importing from CSV file, you will be asked to specify whether the first row of your data source contains column names. When importing from Viewpoint, you'll be asked for other items.
  6. On the Import Summary page, review the list of actions to occur, then click Import to begin the import process.
  7. A confirmation message appears when the import process is complete. The message will also list any problems with the import process. To see more detail about these problems, click View Log File. Otherwise, click View Resources to return to the Resources area.

Additional Information

Required columns when importing new resources from CSV format

When importing new resources from a CSV file, certain columns are required:

  • Certification: Employee ID, Certification Name
  • Contact: Organization ID, Contact Name
  • Employee: Employee ID, Last Name, Business Unit
  • Equipment: Equipment ID, Description, Business Unit
  • Equipment Part: Equipment ID, Part ID
  • Equipment Rate: Rate Class ID, Equipment ID
  • Equipment Rate Class: Rate Class ID, Name, Business Unit
  • Equipment Type: Name, Equipment Type ID, Business Unit
  • Labor Rate Class: Rate Class ID, Name, Business Unit
  • Labor Type: Labor Type ID, Name, Business Unit
  • Labor Type Rate: Rate Class ID, Labor Type ID
  • Materials: Material ID, Description, UM Abbreviation, Business Unit
  • Miscellaneous: Miscellaneous ID, Description, UM Abbreviation, Business Unit
  • Organization: Organization ID, Company Name, Business Unit
  • Overhead Account: Account ID, Description, Business Unit, Overhead Value Type
  • Part: Part ID, Description, Unit of Measure Abbreviation, Business Unit, Standard Unit Cost
  • Part Inventory: Part ID, Place ID, Bin Description, Quantity
  • Places: Description, Business Unit
  • Production Account: Account ID, Description, Business Unit, UM Abbreviation
  • Truck (Internal): Name, ID, Equipment ID (must be of a type that transports materials)
  • Truck (Subcontracted): Name, ID, Organization, Equipment Type (must be a type that transports materials)