Bulk upload of listing data

[Heinz Hemken]

Hi All,

I have over a thousand classified ad-like headings and nearly 20,000 listings I would like to bulk-upload to phpwsListings. Can I do this easily with a perl script or something like it writing directly to MySql? Is there a better way? Does phpwsListings handle listings that fall under more than one heading? If not, can you all suggest a more appropriate way to do it?

Thanks very much for your help and for all of your OSS efforts and contributions!

Heinz

[Loye Young]

I haven't tried this, but I would think that a simple SQL INSERT statement would do the trick. I use phpMyAdmin to do the MySQL database manipulation, and it works great.

I also want to build my site in compliance with the Newspaper Association of America CREST standards. Manually uploading the headings and fields one at a time seems like it would be a beating emotionally, not to mention laboriously slow.

I would create a dummy heading and proforma tags and then look in the database tables to see what changed. Then write a SQL statement that would do the modifications.

If you need help, send me an email through SourceForge and we can work together on it. After we're done, we can offer the fruits of our labor to the community.

In any event, please post back here to tell us how you solved the problem.

Loye Young

[imani]

Loye, I would be interested in assisting this project. As I am expecting MLS uploads in the future.

I am just above rookie in the php skill level, but I am dedicated.