Including HTML

[orionnt]

Im setting up my store, and will be carrying several items from the same distributor. Ive already had several talks wit hthe distributor and they have given me permission to use there product descriptions from there website on my site. However i do not want to copy and paste 1000+ descriptions from there website into my database.

 

Are there any scripts or contributions or anything that someone knows of, where i can put in the page with the products descripton, then put int he "start" and "end" tags, and have it include all the html inbetween in the place of the product description on my site?

 

this will save me from having to copy and paste all of those descriptions. My distributor is currently working on a price list to give to there resellers that has the descriptions in them since there currently one only contains price, weight, and name. However they said it could 3-4 months before that is complete.

 

Any help would be greatly appreciated.

[dchockenberry]

The best thing I've personally come up with is using frontpage or some such editor.

 

I copy and paste their description into frontpage, then view the html code and copy and paste that into the descripion box in admin.

[Jeremy at oddly enough]

You can do this if you have phpmyadmin, excel, and word:

If you can get your distributor to compose the descriptions list so that each description is contained on a single line, separated by a retun character at the end of the description only, then you can use excel to compose a mysql script, and put them deriectly into the database in a very short time. The mysql command would be :

UPDATE products_description products_description='[I]html description here[/I]' WHERE products_id=[I]n[/I]

 

Any punctuation marks that are operators in mysql, like commas or quotes, need to be escaped (put a / in front of it). If the descriptions are contained on a single line, you can paste them neatly into a column in excel, You put the command from UPDATE to the first ' in the first cell, then paste in the description column. Then in the next cell you go from the second ' to the =. Next you use auto enumerate to put in product id numbers, and finish off with a cell for the ;

Choose a character like # or % and put it at the end and beginning of adjacent cells, to help get rid of unneeded commas after saving as a csv. Drag the other cells down too the bottom of the descriptions columns so that all lines have the commad and numbers. Open it with a word processor and get rid of the commas by replacing #,# or %,% with nothing, select all copy and paste into the sql box in phpmyadmin for your database.

 

You also need to have your products listed in the database in the same order that the descriptions are, and they need to be numbered sequentially (as in product_id) for this to work easily. Jeremy

[Jeremy at oddly enough]

I guess italics don't work inside the code box, ignore the italics tags!