Importing Data to my Website

upload, export, import

[josil]

Hi

Just finished my website.

I have a client that has a lot of products with descriptions, photos and other related information in his website, that want to export automatically to my database to be viewed on my website without uploding one by one by one, which would take him monthes to do it.

There is any script that I can add in my website in order to allow him to do the upload automatically from his website to my?

Thank you

[rocknbil]

Well, you can code an upload to import from a .csv file to get the data into the online database easily enough, but the images will be another story.

I'd probably code something up that does that first, then uses ftp from within a script to transfer the images. Nothing I know of open source, but I don't "do" open source.

[josil]

Hi
Thanks for your opinion, but can you give some lead to start trying to do something.
First about the data. The cod that you mention supose to be on my website in order to another person to use to upload the information or anoher way around?

And the Photos? What type o script?

Thank you

[JS_Harris]

All you need is a copy of the appropriate db files and a copy of the images folder. From there you can create the tables on your site, keep the image links relative and you should be fine. Use a text editor to strip out any extra data that the db contains before uploading it to your server. If you're using a CMS it helps that the db was created using the same CMS but if it wasn't there are conversion scripts out there that work.

You'll have a hard time finding a script to do this without a copy of the db because you would then simply be scraping content from site to site... be sure to let your client know that both sites can't rank well for the same images/articles, one of the two won't be found in search.

[josil]

Thanks a lot.

I will try that