Steven Zahm@ Damon
re: Where in the db are the image links stored? I looked through all of the connections db tables and can’t find where these are.
The image names (meta) are saved in the {db-prefix}_connections table as a serialized array in the options column.
Doing this will be pretty tricky because each entry needs to have its own subfolder in the ../wp-content/uploads/connections-images/ so this will be a bit more involved than simply doing an export/import of the table. You’ll also have to loop thru each entry in the db and create that subfolder and place the correct placeholder image.
What I suggest use CSS to set your placeholder images based on category as explained in this QuickTip. This would be far easier and quicker to accomplish if the results suits your needs.
re: Also, when we used the csv bulk import tool it skipped about 40 of the entries which we had to manually enter. I tried multiple times with the same result. There didn’t seem to be any pattern or anything common. It just seemed to randomly skip the uploads. Anyway, if you are interested in looking at it, I can send you a spreadsheet containing what was uploaded and which ones didn’t upload.
Yes, I would be very interested in testing your CSV file. I’ve imported, probably, a million plus entries and only have witnessed this once with another users CSV file. At the time I did not track down the issue because I need to get the custom work finished for them.
Of note, Connections 8.3 which is going to be released today has a very robust logging API. Initial support is logging the email sent thru Connections (Form and Contact extensions). This is to allow users to verify that email notifications are being sent. My intent is to also extend this to the CSV Import extension, which is actually partially completed, will be to use this to log any import errors on a per row basis. So at the very least one would know exactly what was not imported.