Specify a field value once-only during an import

While importing you enter a value for a field that applies to all the records to be imported.

Example:

In the import definition for sales contacts, you use Ask for value once when populating the credit limit field.

  • You first import 500 sales contacts (small and medium-sized companies) and enter a credit limit of €5,000 once. This credit limit applies to all 500 sales contacts.
  • You then import 30 large accounts and enter a credit limit of €50,000 once. This credit limit applies to all 30 large accounts.

The difference with the Fixed value option is that, for that option, the value is saved in the import definition. If you use the Ask for value once option, Profit always imports the same value, but this value is not saved in the import definition.

Profit also has an option for asking for a value per line.

To set an import definition:

  1. Go to: the import function.
  2. Click repeatedly on: Next. The field list appears.
  3. Select the Profit field.
  4. Select the Ask for value once field option.

  5. Complete the rest of the wizard and perform the import action.
  6. Enter the fixed value.

  7. Click on: OK

    Profit performs the import.

Directly to

  1. Import options for fields
  2. Empty field via import
  3. Import fixed value for a field
  4. Automatically edit import field for this imported
  5. Automatically add consecutive number to field via import
  6. Enter field value for each line during import
  7. Enter field value once during import
  8. Import images