Import Logos all from one folder with ID

Support has been upgraded!

The Support Forum is closed. Not to worry! Providing the top quality support you expect and we're known for will continue! We're not ending support, just changing where you submit requests. This will provide you with the best experience possible.

Premium Support

Have you purchased an addon for Connections such as one of our premium templates or extensions with a valid license and you need help?

Please open a Support Ticket in your user account.

Click here to open a support ticket.

Free Support

Are you using the free Connections plugin? Don't worry, you are still very important to us! We are still providing you with the same high quality support that we're known for.

Please open a new support topic in the WordPress support forums for Connections.

Click here to open a support topic.

This topic is: resolved

Tagged: 8.6.12, csv import, extension, import logo

This topic has 4 replies, 3 voices, and was last updated 6 years ago by Steven Zahm.

Viewing 5 posts - 1 through 5 (of 5 total)

Author

Posts
11/02/2017 at 9:29 am #439678

Richard Cardona
Participant

Hello!

We are moving from an older cold fusion site, and have Connections set up on a new WP site, and have successfully migrated all our contacts’ data, and new custom fields (using a php script our developer wrote). This leaves us with about 250 logo images to administer to get into the site. Is there a way to place all these logo images up at the site in one folder like “/wp-content/uploads/connections-images/logos” and then import according to the ID in the database?

For instance, just import a CSV with just the logo URL to match database ID #:
Database ID for contact = 004
Logo Img name= 004.png
Logo URL = http://www.sitename.com/wp-content/uploads/connections-images/logos/004.png

All the correct data is contained in the Connections database, already, but we need to get the Logos in there too and they already have the IDs as their names.

Can we just import the Logo URL, and it will place the paths in the right matching ID record?

Or any other way to do this (rather than manually one by one).
Thank you, -Richard

11/02/2017 at 10:54 am #439686

Steven Zahm
Keymaster

@ Richard

Navigate to the Connections : Tools admin page, click the Export tab, scroll to the bottom and use the Export All tool. Open the CSV file in LibreOffice Calc or Google Spreadsheets (avoid Excel) fill in the logo URL for each entry. You could get crafty and use a formula to take the base URL and filename and concatenate them together so you only need to enter the base URL once and add the filename for each.

With the latest release of the CSV Import you can import the logo by importing your updated CSV file which has a fully qualifies URL for the logo.

The only thing that could throw a wrench into the works is… do you have any of the repeatable fields, such as the address and phone field sets, where you have more than one of the same type? For example two addresses for an entry with their type both set as “Work”? If you do, only one of a type will be exported so when you update you will lose one of the “Work” addresses. Hope that make sense!

Hope this helps, let me know.

11/02/2017 at 12:41 pm #439705

Richard Cardona
Participant

Thank you, I’ve shared with my dev and will let you know how it works. Much appreciate your very quick reply Steven!

11/09/2017 at 10:00 pm #440683
Randy Abidin
Participant
@ Steven,

I am Richard’s dev guy. That worked perfectly!

Thanks!
Randy
- This reply was modified 6 years ago by Randy Abidin.
11/10/2017 at 9:15 am #440718

Steven Zahm
Keymaster

@ Randy

Great to hear!
Author

Posts

Viewing 5 posts - 1 through 5 (of 5 total)

You cannot reply to this support topic. Please open your own support topic.