- Posts: 8
COMMUNITY FORUM
Tool for importing / exporting items to / from K2
- Bryan Chao
- Offline
- New Member
Less
More
10 years 3 months ago #58900
by Bryan Chao
Replied by Bryan Chao on topic Re: Tool for importing / exporting items to / from K2
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.
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
- Topic Author
- Offline
- Elite Member
- Developer of the K2 Import / Export Tool
10 years 3 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.
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.
- Bryan Chao
- Offline
- New Member
Less
More
- Posts: 8
10 years 3 months ago #58902
by Bryan Chao
Replied by Bryan Chao on topic Re: Tool for importing / exporting items to / from K2
When exporting, the extra fields came out.
When uploading, the system didn't seem to recognize the extra fields.
When uploading, the system didn't seem to recognize the extra fields.
Please Log in or Create an account to join the conversation.
- Christian Nielsen
- Offline
- New Member
Less
More
- Posts: 10
10 years 3 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.
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
- Topic Author
- Offline
- Elite Member
- Developer of the K2 Import / Export Tool
10 years 3 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
@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.
- Christian Nielsen
- Offline
- New Member
Less
More
- Posts: 10
10 years 3 months ago - 10 years 3 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,
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.
- Bryan Chao
- Offline
- New Member
Less
More
- Posts: 8
10 years 3 months ago - 10 years 3 months ago #58906
by Bryan Chao
Replied by Bryan Chao on topic Re: Tool for importing / exporting items to / from K2
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.
Please Log in or Create an account to join the conversation.
- Individual IT
- Topic Author
- Offline
- Elite Member
- Developer of the K2 Import / Export Tool
10 years 3 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
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.
- Bryan Chao
- Offline
- New Member
Less
More
- Posts: 8
10 years 3 months ago #58908
by Bryan Chao
Replied by Bryan Chao on topic Re: Tool for importing / exporting items to / from K2
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.
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.
- Roy Kern
- Offline
- New Member
Less
More
- Posts: 1
10 years 3 months ago - 10 years 3 months ago #58909
by Roy Kern
Replied by Roy Kern on topic Re: Tool for importing / exporting items to / from K2
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
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.