How to structure a problem

A few random suggestions:

A sketch is a good starting point for something that needs export like this. Back of a napkin is fine. It helps focus the mind.

Text attributes can contain a lot more than “short text”. Remember, $Text is a text attribute and it can contain thousands of words per note. The limitation is what can be displayed for attributes in Key Attributes listings, not the attribute itself.

There was a recent discussion of CSV export – check this out.

However, CSV will NOT work for images. If you need to export the image consider HTML. (If compatible with InDesign).