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.
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.
Tagged: 8.5.7, csv export, image, logo
- This topic has 9 replies, 2 voices, and was last updated 10 years, 7 months ago by
Steven Zahm.
-
AuthorPosts
-
01/04/2016 at 12:24 pm #359851
Dirk Leeward
ParticipantI just noticed that the image URLs are not included in the export. That appears to be the last piece of data needed to create an export for a printed directory.
Any workaround for that?
01/04/2016 at 3:06 pm #359859Steven Zahm
Keymaster@ Dirk
I’ve just added this to the exported data. This will be in the next update planned for later this week.
I hope that helps!
ps. Question. What app do you plan on importing the CSV into to create a printed directory?
01/04/2016 at 4:34 pm #359888Dirk Leeward
ParticipantThat should do it. Still looking for the right app. Will share when I find it.
01/05/2016 at 11:34 am #359985Steven Zahm
Keymaster@ Dirk
re: That should do it. Still looking for the right app. Will share when I find it.
As a thought… have you considered importing the CSV file into Excel and then settings up a mail merge in Word. Alternatively you could do the same with Google Docs/Spreadsheet with the AutoCrat addon. The problem to solve would how to import the image. I’m not sure that is possible with URLs.
01/05/2016 at 2:53 pm #360029Dirk Leeward
ParticipantThat was my first thought too, but the image stumped me.
With the MS approach, I found one add-in, http://onmerge.com/OnMergeImages.html but it only works with local image files, not URLs. You would have to add a feature to export the images and logos (along with privacy field) and uniquely name them so they would be compatible with how OnMerge works here http://onmerge.com/HelpImages.html
I tried AutoCrat but it is painfully slow and it (or Google) doesn’t support merging or embedding images in Docs. The API may support it but AutoCrat doesn’t.
You can display an image from a URL in Google Sheets with =IMAGE(“URL”,4,50,50) You set the size of the image by replacing 50,50 with desired dimensions.
I’ve done a lot of research and I have not found anything close to what a combination of Connections and and one of these should be able to do. If you developed a template, you could probably sell it along with your other premium items. I’d buy one!
01/05/2016 at 5:50 pm #360036Steven Zahm
Keymaster@ Dirk
I have started research exporting PDF/s. I think to get my feet wet I’m going to make an Avery Label PDF export for addresses. I know there will not be much, if any, demand for such an extension but creating PDF/s involve quite a bit of work to learn what works and what does not.
It seems the MS approach would work just fine now that I think about it a little more. You do not/should not need OnMergeImages, here’s how. Though it does sound like it would make doing the merge easier.
To “export” the images, log into your site with FTP and download the
connections-imagesfolder found here:../wp-content/uploads/. After you have them downloaded locally and do a string find/replace on the CSV file to replace the URL portion of the path with your local path to theconnections-imagesfolder.01/06/2016 at 1:58 pm #360162Dirk Leeward
ParticipantThat link was an article copied from the OnMergeImages website. It sounds like it would be money well spent.
As for the export, that folder is empty on my site, but photos are visible in Connections. Anywhere else they could be?
Sure would be easier to find something that will use URL’s rather than local files. Will also look into software that makes a remote folder look like it is a local folder to Windows, similar to what DropBox does.
01/06/2016 at 4:49 pm #360208Steven Zahm
Keymaster@ Dirk
re: that folder is empty on my site, but photos are visible in Connections. Anywhere else they could be?
No, the only location Connections reads images files from is:
../wp-content/uploads/connections-images/Unless you site is a multi site install of WordPress in which case you wold have to look under the correct blog ID uploads folder.
re: Will also look into software that makes a remote folder look like it is a local folder to Windows, similar to what DropBox does.
I use to use this a lot and it work quite well. Now with high speed internet… I image it would work even better.
01/16/2016 at 10:27 pm #361440Dirk Leeward
ParticipantLooking forward to testing this once the export issues are solved.
01/18/2016 at 9:39 am #361510Steven Zahm
Keymaster@ Dirk
re: Looking forward to testing this once the export issues are solved.
What issues? I’m not aware of any.
-
AuthorPosts
You cannot reply to this support topic. Please open your own support topic.
