I need help automating the construction of simple catalog web pages from data in CSV format. I don't even know if KM/Applescript are the best tools for this job.
Let's start by saying that I don't know a thing about HTML code, let alone CSS. But I need to solve this problem.
For the next few months, I'm going to be receiving daily catalog reports in CSV format. They will be formatted like this:
Gladiator(2000),"Ridley Scott & Russell Crowe",http://www.movieposter.com/posters/archive/main/22/A70-11370,http://www.movieposter.com/posters/archive/main/22/A70-11371,http://www.movieposter.com/posters/archive/main/184/MPW-92384,,,,,,
John Wick 3(2019), Keanu Reeves,http://www.movieposter.com/posters/archive/main/249/MPW-124540,http://www.movieposter.com/posters/archive/main/248/MPW-124223,,,,,,,
Each item can have up to eight photos in addition to name and a notes field. The photo URLs link to full-res photos.
I need an automated method to convert this CSV data into a web catalog. That is, a top-sheet web page that makes a table using the Name, Notes and Photo1 fields. The Photo will be a reduced version taken from the full-size image linked in the Photo1 field URL.
Clicking on any of the table items will take you to a linked page where the Photo1-8 fields are shown at their full resolution along with the Name and Notes fields.
Conceptually, it seems like something that one should be able to automate.
I'd appreciate any assistance I can get.
Thanks in advance for your help.