Keyword

Tool for importing / exporting items to / from K2

More
10 years 8 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
10 years 8 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
10 years 8 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
10 years 8 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
10 years 8 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
10 years 8 months ago - 10 years 8 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
10 years 8 months ago - 10 years 8 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
10 years 8 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
10 years 8 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
10 years 8 months ago - 10 years 8 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.

  • Individual IT
  • Individual IT's Avatar Topic Author
  • Offline
  • Elite Member
  • Developer of the K2 Import / Export Tool
More
10 years 8 months ago #58910 by Individual IT
Replied by Individual IT on topic Re: Tool for importing / exporting items to / from K2
@Bryan Chao. Yes every field including the title. did you delete the categories in the CSV file on in K2

@Roy Kern Thats not a error its just says I could program stricter. Your Error reporting is very verbose, good for development, bad for usage. Go to System-> Global Configuration->Server and set "Error Reporting" to "Simple"

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

More
10 years 8 months ago #58911 by Bryan Chao
Didn't delete. Everyhting is the same. It imports correctly into the new category without changing anything in the file, but once I change something in the item, I cannot import the "new item" back into the original category.

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

More
10 years 7 months ago #58912 by Bryan Chao
Hi,

Ok I managed to import the spreadsheet of data but I cannot get the gallery to upload.

I get this error: row: 1 - save item -
could not copy the file tmp/k2_import/1.jpg

Attached is the zipped file which only includes one item and the adjoining gallery. ideas?
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
10 years 7 months ago #58913 by Individual IT
Replied by Individual IT on topic Re: Tool for importing / exporting items to / from K2
Hmm the CSV seems to be fine and also the image.
What version of the extension do you use? And is your server running Windows or Linux?

Please check one think for me:
When you preparing the import and you are on the screen "K2 Import Tool - associate the fields" do not click "continue" but login into your server via FTP and check what it the content of tmp/k2_import/
Also please check if the path to the tmp folder in the joomla global configuration is correct

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

More
10 years 7 months ago #58914 by Bryan Chao
>>What version of the extension do you use? com_k2import_2.0_stable.zip dated 5/20/14

>> And is your server running Windows or Linux? Linux

Please check one think for me:
>> When you preparing the import and you are on the screen "K2 Import Tool - associate the fields" do not click "continue" but login into your server via FTP and check what it the content of tmp/k2_import/

It includes the image file and the csv

> Also please check if the path to the tmp folder in the joomla global configuration is correct
yes.

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
10 years 7 months ago #58915 by Individual IT
Replied by Individual IT on topic Re: Tool for importing / exporting items to / from K2
Please make an backup of your database and files and send me a admin user, so I can check
www.individual-it.net/en/kontakt-impressum.html

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

More
10 years 7 months ago #58916 by Renzo
Hi,
I have tryed the extension and everything works well.
I only cannot find how to import the field "hits"

Has it been forgotten?

Regards
Renzo

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
10 years 7 months ago #58917 by Individual IT
Replied by Individual IT on topic Re: Tool for importing / exporting items to / from K2
Hi Renzo,
Hits is not imported nor exported. Do you need it urgent? Should not be to hard to implement.

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

More
10 years 7 months ago #58918 by Bryan Chao
Did you get my message?

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
10 years 7 months ago #58919 by Individual IT
Replied by Individual IT on topic Re: Tool for importing / exporting items to / from K2
yes, and I've tried several things and send you a reply yesterday.

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


Powered by Kunena Forum