Project Detail

Description

We have a client who's products are pulled from a text file and rendered on the page via a template. Currently the only way to edit the product values is to open the text file in Notepad and make the changes.

We would like a browser based interface that shows each field (even if the value for that product is empty) so our client's support staff can make the necessary changes without having to open the text file in Notepad.

Here is the raw input of one product.

0, 0002, 10, 602SS-DTCK, , Diagnostic Specimen Dry Ice Cooler Kit, 11 1/8" x 9 5/8" x 10 7/8", 2 per case , , ,
, , , ,
1, 10, 25
$26.50, $26.50, $26.50
Price is per caseUnder 50 available Easy open positive lock closureHigh impact-resistanceTotal clarity, see potential leakage BEFORE opening containerReusable, low cost and simple to useMeets 95k Pa requirement for air shipmentMeets requirements of IATA packing instructionsMeets domestic mail manual requirementsCompliant with CFR 49 173.199

And here's what those values mean:
0, 0002, 10,(THIS IS THE CATEGORY) 602SS-DTCK, (PRODUCT CODE) , Diagnostic Specimen Dry Ice Cooler Kit, (PRODUCT TITLE) 11 1/8" x 9 5/8" x 10 7/8",(PRODUCT SIZE) 2 per case , (QUANTITY PER CASE) , ,
, , , ,
1, 10, 25 (QUANITY PRICE BREAKS, 1 case, 10 case, ect..)
$26.50, $26.50, $26.50 (PRODUCT PRICING - you'll see there really isn't any price breaks for this product)
Price is per caseUnder 50 available Easy open positive lock closureHigh impact-resistanceTotal clarity, see potential leakage BEFORE opening containerReusable, low cost and simple to useMeets 95k Pa requirement for air shipmentMeets requirements of IATA packing instructionsMeets domestic mail manual requirementsCompliant with CFR 49 173.199 (PRODUCT DESCRIPTION)

The commas are key as are the page breaks. Right now if a carriage return is accidently entered the text file won't work. We've tried to open this file in Access but since not every product has all the values then it's buggered.


I am including a small sample of some products used on this site. This is the URL of the product listed above:
http://www.cargopak.com/products/detail.asp?pn=602SS-DTCK



Additional files submitted:
sample.txt