Skip to main content

Add phone numbers, emails or addresses for owners from a file

Yes, you can do this with a file. Import a spreadsheet with the phone numbers, emails or mailing addresses your owners are missing.

M
Written by Michael Bollinger

Yes, you can do this with a file. Import a spreadsheet with the phone numbers, emails or mailing addresses your owners are missing. An import adds to the owners you already have and doesn't make copies of them, as long as PayHOA recognizes each row. The file only needs the columns that say who each owner is, plus the columns you're adding. A blank cell leaves the owner as they are.

What you need in the file

Unit Number

Owner 1 First Name

Owner 1 Last Name

Owner 1 Phone

Lot 12

John

Smith

(859) 555-0101

Lot 14

Maria

Lopez

(859) 555-0103

Lot 15

David

Chen

The columns that identify the owner must be exactly as they are in PayHOA: the unit's title, and the owner's first and last name. Capitals and extra spaces don't matter.

Important: Every row needs the owner's name. A row with only a unit and a phone number or mailing address isn't saved, because PayHOA can't tell whose it is. The row shows no warning: it reads No changes like the others. A file with only such a row finishes with No units & owners needed changes. Every row already matched.

The columns you're adding. Include only the ones you need: Owner 1 Phone, Owner 1 Secondary Phone, Owner 1 Email, Mailing Address Line 1, Mailing Address Line 2, Mailing City, Mailing State, Mailing Zip.

A unit with two owners. Add Owner 2 First Name, Owner 2 Last Name and Owner 2 Phone columns. PayHOA finds each owner by name, not by position, so it doesn't matter which owner you list first.

The easiest way to get this right is to start from a custom report, under Reports. It lists every owner with the unit title and name exactly as PayHOA has them.

Steps

  1. Export your owners. Click Reports, then Build report under Custom reports. Tick Unit Title, First Name, Last Name, Email and the fields you're adding, such as Phone. Click Show results, Export, then Export CSV. See the full export steps.

  2. Save a second copy.

  3. Fill in the empty cells. Don't change a unit title or a name. Type a missing email only for the first owner on a row.

  4. Upload the file. Click Units, Add units, then the Import owners and units tab. See 1. Open the importer.

  5. Answer Confirm your import. A file like this is usually described as owner and member data. Phone numbers and mailing addresses are saved whatever the sentence says, so click Yes, that's right, then Continue. Missing emails are only filled in when it says unit and property data. If you're adding emails and it doesn't, click No, let me clarify, type This is unit data. Update the units and owners we already have. and click Continue. When the window comes back, click Yes, that's right, then Continue. See 6. Confirm your import.

  6. Check the columns. Each should sit under the right field. A column headed Owner 1 Phone sits under Owner Phone, or under Owner 1 Phone when the file also has a second owner's columns. See 10. Match your columns.

  7. Check the Status column, then click Start import.

  8. Check the result. On Import complete there should be one card, Existing owners updated, and no New units created or Owners added card. The card counts the owners who gained a detail. A number added to a second owner on a row is saved but may not be counted. To check secondary phone numbers, run the custom report again: they may not show on the person's page. See 15. Import complete.

What you'll see before you import

  • A green i beside the owner's first and last name (Mapped to existing entity): PayHOA found this owner. A second owner on the row has no mark, even when PayHOA found them.

  • No changes: PayHOA recognized the owner, and the row only fills in details they didn't have. The new detail has no mark.

  • Updating: the row replaces a value the owner already has. The new value has an orange i. Point to it to see Previous value:, or click the x beside it to keep the old value.

Important: No changes doesn't mean nothing is saved. When every row only fills in blanks, the line above the table reads 12 records match your existing data. No changes will be made. Start import still saves every phone number, email and address in the file.

Don't import if you see either of these (11. Check the rows).

  • New, or a warning triangle: PayHOA didn't recognize the unit.

  • A list icon on an owner's name: PayHOA didn't find that name on the unit, and would add them as a second person.

What gets added, and what doesn't

In your file

What happens

A phone number or mailing address for an owner who has none

Filled in.

The same, for an owner who already has one

Replaced, with an orange i, when the unit number is the unit's exact title. With a loose match (12 for Lot 12), the old value can be kept even though the mark shows. A second owner's change has no mark, and when the row has their email the old value is kept.

An email for the first owner on the row, who has none

Filled in, in a file read as unit and property data. Nothing is sent to the owner.

An email for an owner who already has one

Never replaced. See Change someone's email.

A blank cell

Left as it is.

Owners and units that aren't in the file

Untouched.

Consent to texts

Not recorded. See Text message consent.

Watch out for

Warning: There is no undo. A detail an import filled in has to be removed by hand.

Important: A name that isn't exactly the name in PayHOA (Jon for John) can add the owner to the unit a second time.

Important: A missing email is only filled in for the first owner on the row. A second owner given an email PayHOA doesn't know is added as another person with the same name, with no sign on the mapping page. Add a co-owner's email on the person's page instead.

Common questions

I already imported my owners. Can I import again just to add phone numbers? Yes. Import a file with the unit number, each owner's first and last name, and a phone column. You don't need the other columns again. PayHOA finds each owner and adds the number.

Will it create duplicates? Not when PayHOA recognizes the row. It finds the unit by its title, and the owner by their email or by exactly the same name on that unit. Before you import, check that no row reads New and no name has a list icon.

Some owners already have a phone number. Will it be overwritten? Only if the number in your file is different. The row then reads Updating and the new number has an orange i. Click the x beside it to keep the old number.

It says no changes will be made. Did something go wrong? No. Rows that only fill in a missing detail read No changes, and the line above the table can say No changes will be made. Click Start import anyway. The details are saved.

Related

Did this answer your question?