As part of your Onboarding with OfficeR&D, we can import your existing member data with their companies, memberships, locations, and dates.
In the next section of this article, you'll find the format that we use to import your existing data.
Prerequisites - these steps must be completed by you before we can import the member data.
- Add and configure your locations under Space/Locations
- Add and configure plans under Billing/Plans
OfficeR&D enables you to import members from a CSV file with the following columns:
IMPORTANT: Make sure to use comma (,) as CSV delimiter otherwise your data will not get validated
- Name1 - name of the member
- Email (optional) - contact email of the member
- Company1 - name of the company
- Company Email (optional) - contact email of the company
- Location2 - name of the location in multi-location accounts
- Plan3 - name of an existing plan
- Start Date3,4 - membership start date in one of the available formats
- End Date (optional)3,4 - membership end date in one of the available formats
- Membership Name3 (optional) - membership name to override the default plan name
- Price (optional)3 - membership price to override the default plan price
- Quantity3 (optional) - the membership plan quantity (treated as 1 if omitted)
- Phone (optional) - member phone
- Twitter (optional) - twitter handle
- Url (optional) - company website url
- Billing Name (optional)5 - billing name for company or member
- VAT Number (optional)5 - vat number for company or member
- Reg Number (optional)5 - registration number for company or member
- Address (optional)6 - company or member registered address
- City (optional)6 - company or member registered address city
- State (optional)6 - company or member registered address state
- Zip (optional)6 - company or member registered address zip
- Country (optional)6 - company or member registered address country
- Tags (optional)6 - company tags. Comma-separated skills, industries, etc. If specified, values in this field will override current company tags.
Here is more information on each of the fields above and how they depend on each other:
1 - You MUST set either name or company or both. If member or company does not exist they will be created, otherwise their properties will be updated.
- Name - if you set Name field only a member with that name will be created/updated
- Company - if you set Company field only a company with that name will be created/updated
- Name and Company - if you set both company and name a member and a company will be created/updated and the member will be assigned to the company
2 - If you have a single location you can omit this field. In multi-location organisations this field is required.
3 - These fields should be set if you want to create and assign a membership to the member and/or company
4 - Start Date and End Date fields can use one of the following date formats: YYYY-MM-DD, DD/MM/YYYY and MM/DD/YYYY
5 - These fields should be set if you want to assign billing details to the member or company. If both member and company are specified those fields will be set to the company.
6 - These fields should be set if you want to assign registered address to the member or company. If both member and company are specified those fields will be set to the company.
You can download a sample CSV with all columns pre-filled from here. After download you can delete the columns you won't need or leave them empty.
Important: Make sure to use the exact headers listed above as otherwise your data won't be imported correctly.
Note: All additional columns in the file will be imported as custom fields. For this to happen you need to have the fields configured in Settings/Community/Custom Properties.