ValuePRO has pre-built, well tested and used procedures for importing your existing data in any published edition of PropertyPRO, including version 1, 2 and 200 as well as the web edition.
Our process for importing PropertyPRO data boils down to receiving your data file in MS Access format.
This is the most reliable file format we can receive to import your data. Any version of MS Access is supported by ValuePRO for data imports.
PropertyPRO 1.0 and MS Access based editions
If you are running PropertyPRO 1.0, then your data is already stored in MS Access format and you simply need to copy your file called: PropertyPRO_be.mdb from your PropertyPRO server.
We recommend zipping the entire folder where this file is located and providing the file to us.
PropertyPRO 2000 and SQL Server/MSDE Based Editions
If you have data in this format, then we recommend that you allow us to remotely access your PropertyPRO server via remote desktop or other technology (eg. Log Me In) and handle the data export for you.
If you cannot provide remote access to this server, then please have a qualified IT consultant call us for instructions on how to handle the export from MSDE to MS Access format.
If you are an experienced MS Access user and have administrator access to your PropertyPRO server, then you can follow these steps to export the file to MS Access for us:
- Open MS Access on the server or on a workstation with Administrator privileges to your PropertyPRO server
- Create a New Empty Database
- Select File, Get External Data, Import Tables
- In the file open prompt, change the file type to ODBC Data Sources
- In the ODBC Data Sources pop up window, change tabs to System Data Source
- Press the New button
- You will see a pop up list of possible data source types - scroll down to the bottom and choose the option that says SQL Server
- A new window will pop up - enter "PPro" as the data source name
- Add in a description if you choose
- Press Next
- In the Server drop down box, select your PropertyPRO server - it will be called something like \\SERVER\PROPERTYPRO
- In the authentication section, leave the settings as Use Trusted Connection
- Press Next
- In the Database drop down list, select PropertyPRO Data
- Press Next, Test the Connection and press Finish
- You should then be presented a list of System data sources including the one you've just created. Select it and press OK
- Now you should be presented with a large number of tables to select - a lot of these tables will be prefaced by "pp_..." or "prow_...". Highlight all of the tables by holding down Control and A. Then press OK and wait for the tables to all import
- Press OK for any warning messages or prompts that come up in the interim
- Now go back to step 3 and repeat up to and including step 7
- Now enter "PProImages" as the data source name
- Repeat step 11, 12 and 13
- In the database drop down box, select PropertyPRO_images
- Repeat steps 15, 16, 17 and 18
- Back in Access, choose Tools, Database Utilities, Compact and Repair - this will reduce the overall size of the database
- Then close the MS Access file and zip it up
- The file is then ready to ship to ValuePRO