Import Companies

Download template

Introduction

In OfficeRnD, you can now easily submit and import your customers' data following a Step-by-Step flow. As you might have probably read here, the ideal import flow should be executed one after another, starting with importing your companies' data first. The import functionality can be found under the Settings/Import/Companies tab, and this article will go through the Companies Import process first. It can be a useful functionality for updating purposes as well (updating/editing existing companies), more on that later.

Important to Note

  1. It's best if you download our template using the link above in order to see which columns are going to be necessary to be filled out in order to complete the import. Alternatively, you can use your own spreadsheet (please note that only .csv files can be uploaded) and after that, you'll be able to match the columns in your files to the columns in OfficeRND - more on that later.
  2. If there is a validation error when uploading the data, you might not be able to proceed unless the error has been fixed. There are two types of warnings in terms of the validation of the import file - red (an error that should be fixed in order to continue with the import) and slightly yellow (it has a warning function only, but you will be able to continue with the import, more on that later).
  3. If the companies already exist in the system, new companies won't be added, but the system will update the existing ones.
  4. Spaces in the beginning and in the end of the entry would be automatically removed.

Import Flow Steps

The Companies import flow contains three main steps - Upload spreadsheet, Match columns, and Summary. We will go through each one in detail.

Upload spreadsheet

mceclip1.png

  1. Download the example file to get started (Optional - the file can be found here at the top of the article, and when you click on the "Download template" button in the Companies tab). 
  2. Upload your file (click on the Upload CSV button). 

The required columns are the following (they will have a "*" symbol included for that purpose):

  • Company Name* - The name of the company that will be added/updated.
  • Location* - The location of the company.
  • Start Date* - For the start date of the company, note that one of the following formats should be used: YYYY-MM-DD, DD/MM/YYYY, or MM/DD/YYYY.

Other columns that can be of use (Optional):

  • Company Email
  • Twitter
  • Billing Name
  • VAT Number
  • Reg Number
  • Address
  • City
  • State
  • Zip
  • Country
  • Tags

Match columns

mceclip2.png

  1. Choose date format from which OfficeRnD will parse the dates

    You'll first need to select the date format that you're currently using in your CSV file in order to help OfficeRND set the start dates of the companies correctly.

    Note: This is important because if the format is not set correctly you won't be able to Continue.

  2. Match columns from your file to properties in OfficeRnD

    At the bottom of the import page you'll be able to see two rows of columns:
    The first row displays the default columns in OfficeRND.
    The second row displays the columns of the uploaded file. You can match your columns to the columns in OfficeRND so that you can make sure that the data from your columns are going to be used in the default ORND column. Following the same logic, you can match a custom property field to an existing custom property in OfficeRnD.

     

    Animation.gif

    If there are any errors or inconsistencies in the data, the system will display a warning and will not let you continue.
    You'll be able to see a description of the problem either on the row that's problematic or on the whole column.

    Animation1.gifIf there are any errors in the file there is an "Upload new file" below that you can use in case you have fixed the errors, and you would like to proceed with the import functionality anew.

Note: If there is an error message that for some reason you are not able to troubleshoot, you can reach out to support@officernd.com.

Summary

mceclip0.png

  1. Review the import summary below (Summary of what this data will add/update).

  2. Save your choices as a matching preset for future imports (Optional - columns will be automatically matched. You will still be able to re-match and edit them). You will need to click on "Save preset CSV", set an Import Settings Name, and then save the changes made. You can choose this matching preset in future imports. Animation2.gif

  3. Click on the "Import" button.
  4. You will receive a confirmation of a successful data import.

Update Companies using the Import Feature

As we mentioned earlier, the Import Feature can be also used for Updating purposes, if the companies already exist in the system, new companies won't be added, but the system will update the existing ones. Here is an example:

mceclip0.png

What's next:

  • Import Members
  • Import Memberships

 

Was this article helpful?
0 out of 0 found this helpful

Comments

0 comments

Please sign in to leave a comment.