FAQ: One Place Product

• Initial Assignment of OnePlace IVR Passwords
  • Agent Passwords are the last four digits of the agent's pager number. Ex: Agent Name: Donna Hoel (cbrader) Pager Number: 9187614793 Agent Password: 4793 (last four digits)
  • Office Passwords are the last four digits of the office's zip code. Ex: Office Name: Tulsa-Yale (cbrader) Zip Code: 71436 Office Password: 1436 (last four digits)
  • Main (Company) Passwords are the first four digits of the clientcode translated into numbers on the telephone keypad. Ex: Clientcode: cbrader First four letters: cbra Company Password: 2(c)2(b)7(r)2(a)(translated on keypad)
  • Agent and Office passwords are generated automatically on the initial run of the shipping script
  • Main or Company passwords are hand entered into the OnePlace Password table in Ozone
  • All Passwords can be changed from the client's online page where there is a link to the password change system


• General Structure of OnePlace Access Databases (.mdb files)
  • All OnePlace databases have a tblAgent and tblOffice for agent and office data which is entered via online entry.
  • All OnePlace databases have OnePlaceProperty, OnePlaceAgent and OnePlaceOffice tables which is the source of Property, Agent and Office data to the IVR system. The data is appended from the respective tblAgent or tblOffice using append queries customized for each client.
  • All OnePlace databases have these reports, which are generated daily:
    • OnePlaceNewAgent
    • OnePlaceNewProperty
    • OnePlaceNewCommunity
    • OnePlacePropertyExclusion
    • DuplicatePropertyCodes
  • OnePlace databases which utilize an RDC datafeed have ODBC links to tables such as v_PropertyRDC which is the source of the property data for the IVR system
  • Depending on need, there can be other tables as well. Some of the most commonly seen are:
    • tblProperty, for online entry of property types not contained in the RDC feed, or when the client is not receiving an RDC datafeed
    • tblLookupSearchArea, used for touch 1 or touch 2 systems that need a specific search area mapped to the IVR from the RDC feed or other source of property data
    • tblOpenHouse, for open house data to be used in the IVR and Web

• One Place Shipping Q&A
  • Data empty on client machine:
    • Question: One Place shipping seems to run OK on the shipping machine, but client machine's tables are left empty. The problem has been narrowed down to sqltransfer_client.vbs not importing the new data. Also, an error about an invalid -6 option shows up in the \logs on the client machine. What should be done?
    • Answer: The problem lies in that xp_cmdshell uses SQL Executive/Agent to launch the client script to import the data. The SQL Executive (version 6.5) or SQL Agent (version 7.x or higher) is not set to Autostart or has stopped. Start the service and set it to autostart. Test One Place shipping for this client (the big script) and reboot the client machine and test again. Running sqltransfer_client.vbs manually via remote control (with appropriate command line parameters) is a good way manually dig in further if this solution does not fix the problem.