2019-06-03

At the request of the client, we need to export all of the Media from the Renjeau.com website, in a spreadsheet so that it can be reviewed.
An interesting wrinkle: Need also to export the Media Tags, which are apparently vertical-bar-delimited in one field.
Those need to be turned into individual cells.

For example: 
Input:
ID	Title	Etc.	Media-Tags
111	Pretty	nnn	red|blue|abstract
112	Nicely	nnn	blue|abstract|h100
113	Quigley	nnn	yellow|h100|w10

Output:
ID	Title	Etc.	abstract	blue	h100	red	w10	yellow
111	Pretty	nnn	1		1	1	1	0	0
112	Nicely	nnn	1		1	1	0	0	0
113	QUigley	nnn	0		0	1	0	1	1

So you need to know what ALL of the media tags are in order to print them out in individual cells with 1 or 0.

Some fields may have returns in them.
The data is presumably created first by exporting via AllExport plugin, using a special query to export media.

TODO:
Export Title, Alt, Description, Caption, Filename, GUID, additional metadata as needed. Bonus points if you can get the Artist. 
(Hint: post_parent is the id of the Artist to which this Media is attached.)

NOte that since a Media item is really a Post,
 the "excerpt" and "content" may be mapped to "description" and "caption" --
 but I think there is actually an additional meta field that holds one of these. 
 (Maybe the ALT is a meta field? _wp_attachment_image_alt)
 
 Basically when you export from AllExport you need to get ALL meta data.



References:
https://wordpress.stackexchange.com/questions/1777/are-captions-stored-anywhere
https://wordpress.stackexchange.com/questions/193196/how-to-get-image-title-alt-attribute/193198
https://mor10.com/power-of-wordpress-image-metadata/