The idea is very simle: Read data from a CSV file, export data into MySQL; Retrive data from MySQL and put data into templates and display pages. (Use templates to seprate design and coding.)
It does not matter use Template::Toolkit or HTML::Template module or something like that.
There are dozens of CSV file. Each has different fields and hundreds of lines. Template tages in templates are used to display specific data from database (price, image, URL, etc). Set template tags' names manually.
Some add-ons are:
1 Use mod_perl and cache
2 Web based admin pages (to read CSV file, export data to mysql, etc)
3 Use LWP to get CSV file
How much shall it cost? How long?
Thanks
One table that each CSV file maps to or one table for each distinct CSV file type? CSV files are totally random in what fields they have? Any useful header info to automate mapping? Manual spec requred for each file?
Could use more detailed info on the mapping of CSV files to MySQL tables.
One table that each CSV file maps to or one table for each distinct CSV file type? CSV files are totally random in what fields they have? Any useful header info to automate mapping? Manual spec requred for each file?
Good monrning,
Each distinct CSV file maps to one table. Each CSV file has different field, but bascially the same, fields like URL, Title, Description, Image, etc are supposed to have in each file. Manual spec is required because it is up to users to decide where to put template tags in templates, with what name. If a field's title is Image, then the tag is supposed to be Image as well, although changable. So users can put this tag, for example<!-- Template VAR="Image" --> , in tempaltes.
2 Web based admin pages (to read CSV file, export data to mysql, etc)
What's behind "etc"?
How much shall it cost? How long?
Your description of the project is far too vague; it could take anywhere from a day to three months to develop. There's no right answer. Find a developer you trust who has a proven track record of delivering results and get them to quote you something. That's how much it will cost.
If *you're* the developer, do the project once and next time you'll know how much time it will take.
