[Damon Bell]

We have a directory with 2600 entries and would like to bulk upload images. We already bulk uploaded the listings with the CSV importer.

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.

We have around 10 placeholder images that we want to rotate through. What I wanted to do was export the database as a csv file, add links using a spreadsheet, and then import the new db.

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.

[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.

[Damon Bell]

Thanks for the info, I’ll check out the link.

If you send an email to the email address from my account then I’ll send you an excel spreadsheet showing what did not upload as well as the .csv.

One thing I just thought of is that I saved the spreadsheet to .csv with Libre Office, not with excel. Maybe there is something that happens from Libre office in the .csv conversion???

[Steven Zahm]

@ Damon

I just sent you an email, reply back to that with the files. Thanks!

Actually I use LibreOffice for my testing… Excel has more issues creating standard CSV files. Generally in my experience the files from LibreOffice are perfect for importing.

[Author]

Posts