Importing sites with a profile import

How do I import sites when I mass import profiles?

Overview

If your spreadsheet says which site each person belongs to, you do not have to file them by hand afterwards. Put a Sites column in your file and the profile import adds each person to the sites named on their row.
Any site name Vome does not recognise is yours to decide: add it to a site you already have, create it as a new site, or skip it. A name that matches nothing never stops the person from importing.

Info
Plan required: Sites is on the Enterprise and Ultimate plans. On Recruit and Pro there are no sites to import into, so leave the Sites column out of your file.

1. Where do the site names go?

In a Sites column in your spreadsheet, which you map on the Map fields step like any other column. It is in the template offered on the upload step and attached to the mass import article.
One person can belong to several sites. Write them all in the same cell and separate them with a comma.
Names are matched loosely. Capital letters, accents, spaces and punctuation are ignored, so east-end in your file matches a site called East End.

2. Where do I decide what happens to each name?

On the Customize & Assign step. If any site name in your file does not match one of your sites, a Sites from your file card appears there. When every name matches, there is nothing to decide and the card stays hidden.
The card lists every distinct site name in your file once, with how many rows use it and what is about to happen to it. Above the list, counts show how many sites will be created, how many matched an existing site and how many are skipped.
Nothing is created until you run the import on Review & Save. You can change any decision, or go back a step, until then.

3. What are the two options?

The card opens with a choice that covers every unrecognised name at once.
  • Create sites that do not exist yet. Each unknown name becomes a new site, with only its name, and everyone in your file with that name is added to it. You can add its address and details later on the Sites page.
  • Only add people to existing sites. Nothing new is created. A name that matches no site is skipped, and the person still imports normally.
Pick the first when your sites only exist in your spreadsheet so far. Pick the second when your sites are already set up in Vome and the column is only there to file people correctly.

4. Can I decide name by name instead?

Yes. The choice above is the default for the whole file, and every name in the list can be changed on its own. Open the dropdown next to a name and pick one of:
  • Create as a new site.
  • Skip, do not add.
  • Add to an existing site, then the site you mean.
When a name is close to a site you already have, Vome shows Close to an existing site with that site's name underneath it, and Use it accepts the suggestion. It is only ever offered, never applied for you, because putting people on the wrong site is easy to miss afterwards.

5. Who can create sites from an import?

The account holder, and admins whose custom role includes Create sites. That is the same rule as the Sites page.
Other admins see Only admins who can create sites can add new ones. on the card. They can still add each name to an existing site or skip it, and everyone still imports.
If your role limits you to certain sites in the Database, you can only add people to your own sites. A name that belongs to a site you do not manage shows This site exists, but it is not one of your sites. It cannot be created a second time, so add it to one of your sites or skip it.

6. What if my file would create a lot of sites?

Above 5 new sites, Vome asks you to confirm before you can continue. It tells you the exact number, and you tick the confirmation, for example Yes, create all 8 new sites.
A number that large usually means the wrong column was mapped to Sites. If it surprises you, go back to Map fields before you confirm.

7. What happens to people who are already in my Database?

When you choose to update existing profiles, people already in your Database are added to the sites on their row too, the same way as new profiles.
Caution
An import only ever adds sites. It never removes anyone from a site they are already on, even if their row names different sites or leaves the cell blank.

The Sites column and the Assign sites option on the same step add up rather than compete. If you do both, people get the sites on their row and the sites you picked for the whole file.

8. What happens to a name that is skipped?

Only that site is left out. The person still imports, and you can add them to a site from the Database later.

9. Can I undo it?

Yes, within 30 days, from Import history. Undoing an import takes people back off the sites the import added them to. Sites the import created stay on your Sites page.
Read How do I see my past imports and undo an import?

Summary

  • Sites needs the Enterprise or Ultimate plan.
  • Put site names in a Sites column, several per cell separated by commas.
  • Names that match a site are used as they are. Capitals, accents, spaces and punctuation are ignored.
  • Unknown names are decided on the Sites from your file card on Customize & Assign: add to an existing site, create, or skip.
  • A close spelling is suggested, never applied for you.
  • Only the account holder and admins whose role includes Create sites can create them. Site-limited admins only add people to their own sites.
  • Over 5 new sites needs a confirmation.
  • Sites are only ever added, never removed, and a skipped name never skips the person.