Ok, thanks, if you find a demo I would like to see it.
Here is a sample file to help shed some light. This of course could be trimmed or modifed however need be, but there is 11,000 records, so hopefully not too much editing.
I have uploaded the file here
for you to see. I have this in .sql and xls formats, but I dont know how to modify the .sql format.
I just want to be able to setup photopost with the necessary areas like,
Name, State, Telephone, zip code etc.. and then have the spreadsheet match that, and import it.
So hopefully in the end I will have all 11,000 listings and searchable by zip, state, etc..
The thing is, I wont be using this for classified type listings, but for campground listings. I wanted a searchable database of campgrounds for my members. The reason for choosing a classifieds software is because I want owners to be able to pay a fee, upload a listing, renew it, etc... I want it as automated as possible, and classifieds software provides that.
The ones I am importing will only be basic listings, no pics, website, etc.. they are just there to benefit my members.
I am torn between reviewpost and photopost class, because they both offer something I want. Is there any way to to have both in one? I want the pay/post feature, and I wanted members to be able to review campgrounds. So is there a way to allow reviewpost to be a pay per listing, or is there a way to add reviews to photopost classifieds?
If this is possible, but not free, please let me know if its something you could/would do and a rough estimate. A site called campout.com is a great example of I am looking for. They use reviewpost I think and you can add a campground, and review them, comment etc.. That is what I want, with the addition of paying for the added campground.
Last quetion, could this work with your system? The imported listings would need to be non expiring ads, just tied to any account (same account). But I would want these to never "expire" or have a way to easily keep them all active.
Thanks for all the help, I hope to get this going soon, just got to determine what will work best.