[Anthony Cooper]

Greetings,

I have created an Excel file (attatched) with 11 test entries and only 3 were imported correctly into the Directory. I removed all formatting from the Excel file.

I had done a few tests importing only 1 entry at a time and I had no problem. Now I tried with 11 entries… I have a total of aprx. 150 to import.

I removed the column fields that were not necessary and only left the ones I needed.

Thank you in advance for any assistance offered.

Attachments:

You must be logged in to view attached files.

[Steven Zahm]

@ Anthony Cooper

The issue is that file encoding that Excel is applying to the file when the CSV is being exported. My suggestion, use either Google Spreadsheet or LibreOffice Calc to create the CSV file. Make sure to export the file with UTF8 encoding. If Excel has that option (I do not know) then you could try changing the file encoding to UTF8. Working with Excel to create CSV files can be hit or miss due to the system config of the PC that it is installed on. Whereas Google Spreadsheet or LibreOffice Calc “just work” as long as you set the encoding to UTF8.

Hope that helps, let me know.

[Anthony Cooper]

Thank you,

Yes, by creating the file in a Google Spreadsheet it worked!

By the way, I have a couple of questions regarding “Site Shot”:
1. For some entries it is taking what I consider to an excessive amount of time to load the preview – is this normal?

1. If an entry has a logo image – will this override the SiteShot preview?
2. Can you choose for which entries you want a SiteShot image or not?
3. Do the Site Shot previews have an effect of load time for a page?

Sorry, I did not post elsewhere, I was not sure where to do so.

[Steven Zahm]

@ Anthony

re: For some entries it is taking what I consider to an excessive amount of time to load the preview – is this normal?

SiteShot uses a WordPress.org service to provide the screenshots of websites. When you view your directory, SiteShot send a request to that service. That request enters a processing queue. If that processing queue is busy it can take a little time to get a thumbnail. In my experience though, usually the thumbnail is available within a few seconds and will appear in the next page load. Now, if a site that is being screenshotted is slow to respond the WordPress service will move on and come back to it as to not hold up the queue. At least that is my best guess based on experience because I do not have any real insight on how they manage that processing queue.

re: If an entry has a logo image – will this override the SiteShot preview?

No, but, it is possible to use a SiteShot as a backup if there is not image/logo. You would use the image_fallback='siteshot' shortcode option in cMap.

re: Can you choose for which entries you want a SiteShot image or not?

Sorry, no. It all or none.

re: Do the Site Shot previews have an effect of load time for a page?

I’m sure it does. It could be positive, negative or even no difference. It really depends on a whole host of factors which will be different for each site. The best way for you to tell is to load the page 10 times clearing the browser cache after each time and average out the page load time. Do it twice once with SiteShot loaded and once without it.

Hope this thoroughly answers your questions.

[Anthony Cooper]

Thank you very mucho for your detailed answer…

[Anthony Cooper]

Maybe these responses could be included in the documentation of the SiteShot Extension as probably others would have the same queries. Just a suggestion :-)

[Steven Zahm]

@ Anthony Thanks for the suggestion, I did just that :) http://connections-pro.com/documentation/siteshot/#FAQs

[Author]

Posts