Keyword

Tool for importing / exporting items to / from K2

More
8 years 6 months ago #58900 by Bryan Chao
Hi,

I am trying to import new K2 items. To test the system, I exported one category of items, and reuploaded the information to another category (same extra field structure).

While all items uploaded, the EFs are completely blank.

I am using joomla 3.0, using the uploader tool from May 2014.

Please Log in or Create an account to join the conversation.

  • Individual IT
  • Individual IT's Avatar Topic Author
  • Offline
  • Elite Member
  • Developer of the K2 Import / Export Tool
More
8 years 6 months ago #58901 by Individual IT
Replied by Individual IT on topic Re: Tool for importing / exporting items to / from K2
While Uploading did the tool recognize the extrafields in the CSV file and did it automatically (or you manually) assign the right fields with the columns in the file?

Did any error occur during import?
Please also edit the CSV file and check if the extra fields were correctly exported.

P.S. All fields and values have to exist in the target system.

Please Log in or Create an account to join the conversation.

More
8 years 6 months ago #58902 by Bryan Chao
When exporting, the extra fields came out.

When uploading, the system didn't seem to recognize the extra fields.

Please Log in or Create an account to join the conversation.

More
8 years 6 months ago #58903 by Christian Nielsen
Replied by Christian Nielsen on topic Re: Tool for importing / exporting items to / from K2
Trying to import my exported k2 items. When I'm try to import without images, everything works just fine, but when I'm trying to import with images i get the following error:

Messages

importing items, please stand by
error - Internal Server Error

When reporting this error check Javascript Console for more information
Date: Tue, 29 Jul 2014 10:05:00 GMT
Server: Apache/2.2.23 (Unix) mod_ssl/2.2.23 OpenSSL/0.9.8y DAV/2 PHP/5.4.10
Connection: close
X-Powered-By: PHP/5.4.10
Content-Length: 0
Content-Type: text/html

The image path is correct (have tested it multiple times) and i have tried both ways (move images manually to the correct path and zip the csv and the files) but none of those seems to work, have over 850 items with images to each one of those.

Please Log in or Create an account to join the conversation.

  • Individual IT
  • Individual IT's Avatar Topic Author
  • Offline
  • Elite Member
  • Developer of the K2 Import / Export Tool
More
8 years 6 months ago #58904 by Individual IT
Replied by Individual IT on topic Re: Tool for importing / exporting items to / from K2
@Bryan Chao: Please post a part of the CSV file here and check if all extra fields and values are created in the target system as in the source system

@Suprehn Try to import less items per loop. Option: "Import rows per loop" default is 10, try first with 5 and then with 1

Please Log in or Create an account to join the conversation.

More
8 years 6 months ago - 8 years 6 months ago #58905 by Christian Nielsen
Replied by Christian Nielsen on topic Re: Tool for importing / exporting items to / from K2
Well, the four first rows works when i turn it down to 1 per row. After the four first i get the same error.

EDIT
Fixed it, was row number 5 that was corrupted, removed it, and now it works,

Please Log in or Create an account to join the conversation.

More
8 years 6 months ago - 8 years 6 months ago #58906 by Bryan Chao
So I tried first exporting a category (all EFs were seen), and reimported exactly identically into another parent category. The process seemed to work fine EXCEPT EFs were not detected. Secondly, the new category did not show up under the new parent.
Attachments:

Please Log in or Create an account to join the conversation.

  • Individual IT
  • Individual IT's Avatar Topic Author
  • Offline
  • Elite Member
  • Developer of the K2 Import / Export Tool
More
8 years 6 months ago #58907 by Individual IT
Replied by Individual IT on topic Re: Tool for importing / exporting items to / from K2
Hi,
your first problem is that the CSV file is not formated correctly. You need a double quote->" around every field. Please check to documentation: www.individual-it.net/en/Instructions-for-K2-Import-Component.html

Is the attached file the direct export or did you edit it? If you edit the file its better to use LibreOffice than Excel because it handles CSV nicer

Please Log in or Create an account to join the conversation.

More
8 years 6 months ago #58908 by Bryan Chao
around every field as well as column title?

It is the direct export, i didn't edit at all. Am using libreoffice.

After I permanently deleted some dead categories, it seems to be working now.

Please Log in or Create an account to join the conversation.

More
8 years 5 months ago - 8 years 5 months ago #58909 by Roy Kern
Hi,
Purchased yesterday and just installed and I received these errors
see attached
http://s759.photobucket.com/user/dizzbee/media/7ac6ea66-d22e-41e1-aa94-40bf0a1d8a3d.jpg.html

Please Log in or Create an account to join the conversation.


Powered by Kunena Forum