Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Link to export: Make excel-fil and import

Image Added

  1. Select the the Company Module

  2. Select the tab Import / Export

  3. Click on "Import/ update

...

  1. Companies. Review Exporting data to MS-Excel to better understand how to prepare an excel file from dRofus that could be used in this process. 

...

Image Removed

Choose file and browse to the excel file using the Choose File icon in the Import/Update menu. The excel file should include either an ID, name, and any other fields in order to update existing companies company data.  This is the key to link the excel file data to the exiting data in dRofus. dRofus will read the excel file and ask if the columns can be read to pre-populate the fields, pick yes to match the excel columns with the fields in the user interface. At this step, an import option will need to be determined. Import New, Update existing, or Import new and update existing. 

Image Removed

Then, determine which unique key will be used to identify the Parent Company if necessary. A Parent Company is not required to import or update company data. 

Image Removed

...

...

4. Select Excel fil by clicking on […]

5. Select which sheet in your excel fil that you will export information from

6. Select Row

7. Select if you would:

  • Update existing contact

  • Import new

  • Import and Update

8. Select identifier key: When updating a company you need to have ID, Name or Organization number in your excel fil. dRofus will use the parameter to identify the company.

9. Enter the letter to the coloum in your excelfil that you would like to import

Read more about excel-import

10. Select import