Joomla web development, eMarketing and training
Joomla 1.0 Web Development
How to configure SerrBizMLS?
Tuesday, 07 August 2007 20:58

Before configuring you need to add the following EXTRA FIELDS to HOT PROPERITES: Remote_id and remote_agent. Bulk imports will NOT work if you do NOT have these EXTRA FIELDS.

1) Navigate to the SerrBizMLS component through Joomla control panel and click the Regenerate Import Fields.
Note: This is required before do anything else with SerrBizMLS.  This creates a new table in your data base and associates initializes the SerrBizMLS table in the database with the corresponding Hot Property fields.

2) In the SerrBizMLS component click the Modify Import Fields link. Click the fields you want to import. Be sure to set which ones are required and which ones are not. Click the UPDATE button at the bottom of the page.

*NOTE: MLS and IDX listing may require direct links to 3rd party sites. In this case, you need to make EXTRA Fields in Hot Property.

3) In the SerrBizMLS component click ADD CLIENT. Fill in the blanks.
*The file directory should be something like: /home/user/feed

4) In the SerrBizMLS component click Map Client ID's link. Here is where you can map MLS agent IDs to the internal Hot Properties Agent ID.

IMPORTANT Notes:
By default, REMOTE AGENT ID is mapped to the FIRST AGENT in HOT PROPERTIES. If you upload BULK listings that are only associated to your HOT PROPERTIES agents, then you STILL need to MAP CLIENT IDS accordingly. If you like, you can make the REMOTE AGENT ID and NAME the SAME as the HP id and name.

5) In the SerrBizMLS component click View Modify clients. Here you can modify or delete parameters of a feed that you already added. Also, you can download a sample .txt file of how to construct a data feed. Download this file to the FEED folder in your ROOT level.

IMPORTANT NOTES ABOUT THE FEED FILE
The file must be formatted exactly as the SAMPLE feed shows. Notice the __END__ in the last record.  This is VERY important.  Without this, the system will NOT work.  Why?  This is safeguard against the system accidentally deleting listing because of a partial data feed.  You see, the SerrBizMLS system checks the FEED against the LIVE database.  If a listing is MISSING from the FEED, but still in the LIVE DATABASE, the component will DELETE the listing from the LIVE DB.  The __END__ record tells the component the feed is complete and to proceed with the rest of its routines. 

6) Open the SAMPLE and populate according to the data you want to import. Be sure the last record is set to the value of The __END__.

7) Save the SAMPLE using the same FILE NAME you specified in step 3.

8) Upload the file to your server.

9) In the control panel of your server set up the following CRON Jobs.

A)
lynx -dump http://www.yourdomain.com/_bulkimport_cron.php?cmd=cron > /dev/null 2>&1

Depending on the size of your data feed you will need to set this run once every .5 to 12 hours.

For feeds with under 1,000 records, every .5 hours should be okay.

What does this cron job do?  It reads the FEED file and puts it in CACHE. The next cron job runs through the CACHED data and updates accordingly.

B)
lynx -dump http://www.yourdomain.com/_bulkimport_cron.php?cmd=process > /dev/null 2>&1

Set this CRON JOB to run about every 5 minutes of every hour of every day.

What does this CRON JOB Do?
This job reads the CACHED records and checks for NEW listings, updates or listings to delete.  It automatically does this.  The more records you have, the longer it will take.

NOTES ABOUT CRON:
Depending on your server configuration, file upload restrictions and CPU , this process can be very quick, or very slow.  If you need assistance fine tuning your server, let us know and we can assist you.

Note: If your feeds have over 2000 records, you will need to adjust the following parameters of the admin.bulkimport.config.php file.

The paramters to adjust are:

$bulkImportMaxRows = 2000; // don't change (max num rows in the cron file to process)

$bulkImportMaxBatch = 4000; // don't change (max num rows to insert into cache table per batch$i field)

10) In the control panel of Joomla navigate back to the SerrBizMLS-HP component > View/Modify Clients. Set the CRON to ACTIVE. For testing, set the interval to 1.  After testing change it to at least 1/2 hour.

11) That's it. According to your setting, the FEED file should start being imported according to your schedule.  If you like, you can always run the CRON JOBS manually by calling the these URLS:

Run this first: http://www.yourdomain.com/_bulkimport_cron.php?cmd=cron
Run this second: http://www.yourdomain.com/_bulkimport_cron.php?cmd=process



Download Now
Last Updated ( Tuesday, 07 August 2007 21:12 )
 

Add your comment

Your name:
Subject:
Comment:
  The word for verification. Lowercase letters only with no spaces.
Word verification:


+ Suggested tags