[webchap]

Hi there, have previously used the iframe feed from Vebra but looking at a different method so I can pull data in to agent's own custom built website.

Basically Vebra provide a Zip file containing 4 CSV files and is updated daily from the agents office based software.

I presume I then need to take that Zip file and import the data contained in the CSV files into a database and then pull in the information from the database into the website pages.

Has anyone else had experience with this and Vebra at all?

Never written a Cron Job before so unsure.

Site will be on a Windows server.

Any help most welcome and if I am struggling may be a job I farm out to be done for me.

Just wondering if I have the gist of it correct?

[BlueDreamer]

In short your need a script that will read the CSV's and import new data into your database.

Normally with a setup like this your script would query the CSV's at set intervals, eg once an hour or once a day, and just import any new entries.

[GalaxyTramp]

Hi

Do they provide an XML feed of the properties? This would be a more conventional way to insert into a DB.

[GarethH]

I do this on a few of my sites. For a £100 one off fee, Vebra can upload the 4 files extracted to a location accessible via FTP.

My process is:

1. Logon via FTP to the site.
2. Download the files (properties.txt, rooms.txt, images.txt)
3. Import into a temporary database directly.
4. Query the database to see if the property already exists.
5. Update the changes or insert new ones
6. Import and resize the photos
7. Delete any properties that didn't update (as they don't exist anymore).

I hope this helps.