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.
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.
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.
11/02/2017 at 9:29 am #439678Richard CardonaParticipant
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, -Richard11/02/2017 at 10:54 am #439686Steven ZahmKeymaster
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 #439705Richard CardonaParticipant
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 #440683Randy AbidinParticipant
I am Richard’s dev guy. That worked perfectly!
11/10/2017 at 9:15 am #440718Steven ZahmKeymaster
- This reply was modified 2 years, 4 months ago by Randy Abidin.
Great to hear!
You cannot reply to this support topic. Please open your own support topic.