Convert CSV to Web Catalog?


#1

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:

Name,Notes,Photo1,Photo2,Photo3,Photo4,Photo5,Photo6,Photo7,Photo8
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.

2019-06-03_01-01-51

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.


#2

Hey @anamorph,

Can it be done? Sure.

Here's a very rudimentary proof-of-concept for the basic table on the face page:

Crude Example of Making a Contact Sheet from Source Text.kmmacros (4.9 KB)

My HTML is old and rusty, so it's crude indeed.

Not the simplest of tasks though. Expect to spend several hours.

-Chris


#3

Thanks very much for this. Very helpful.


#4

Hey @anamorph,

Here's a version that uses only Keyboard Maestro actions.

-Chris


Crude Example of Making a Contact Sheet from Source Text (KM-Only).kmmacros (7.1 KB)


#5

Very cool. So instructive. Thanks!