Keyword

Tool for importing / exporting items to / from K2

  • Individual IT
  • Individual IT's Avatar Topic Author
  • Offline
  • Elite Member
  • Developer of the K2 Import / Export Tool
More
10 years 9 months ago #58890 by Individual IT
Replied by Individual IT on topic Re: Tool for importing / exporting items to / from K2
Yes that could be done with some limitations.
The category structure will not be transfered.
Images are exported as path to the file. so you would have to copy them
somewhere you can reach them from the new page and maybe change the path
in the CSV file.
Some minor fields might not be transfered.

It's bad for business but I give you an other idea:
1. make a full backup of both pages
2. update K2 on Joomla 2.5 to the same version as on J3.3
3. export all k2_* tables via phpmyadmin from J2.5
4. import all this tables to J3.3

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

  • Gabriel Hernandez Garcia
  • Gabriel Hernandez Garcia's Avatar
  • Offline
  • New Member
More
10 years 9 months ago #58891 by Gabriel Hernandez Garcia
Replied by Gabriel Hernandez Garcia on topic Re: Tool for importing / exporting items to / from K2

Individual IT wrote: If the export does not give an option to convert to UTF8 you can try to import as it is or try to convert it with an external tool (like libreoffice) or convert to UTF8 during import, there is an option for that.

Your first problem is the separator and the encloser. to change that do:
1. Download and Install LibreOffice
2. Open the CSV with LibreOffice
3. check the values are correct
4. Go to File-Save As
5. Select folder and file name
6. select Text-CSV as format
7. check the "Edit filter Settings" box
8. click "Save"
9. select , as field delimiter and " as text-delimiter
10. click OK
11. open the saved file with a text editor and double check it
12. try to import the file

BEFORE EVEN TRYING TO IMPORT MAKE A FULL BACKUP OF YOUR DATABASE AND JOOMLA FILES


Thanks for your support. :)

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

More
10 years 9 months ago #58892 by Coptechs
Thank you for the reply. I am trying to figure out which route I will go.

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 9 months ago #58893 by Individual IT
Replied by Individual IT on topic Re: Tool for importing / exporting items to / from K2
I've just published new versions of the tool with small bug fixes.

To get it use the download link you got after buying the extension, if that one is still valid or buy it again: www.individual-it.net/en/Joomla/#27

Check the ratings at JED and rate it yourself: extensions.joomla.org/extensions/extension-specific/k2-extensions/12408

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

More
10 years 9 months ago #58894 by Christian Nielsen
Replied by Christian Nielsen on topic Re: Tool for importing / exporting items to / from K2
Hi!

I have exported my items from one of my sites and now want to import it on my other site, i choose my csv file and hit import. So far so good, but when i get to the step were i should associate the fields, i can't choose any fields in the drop downs, it shows blank, and if i choose to continue all the imported items are blank and have the title "Imported item".

Hope you could help me with this asap

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 9 months ago #58895 by Individual IT
Replied by Individual IT on topic Re: Tool for importing / exporting items to / from K2
Please edit the CSV file with a simple text-browser and check the format.
You need , as field delimiter and " as text-delimiter.

Its best to use LibreOffice for editing the CSV. check the comment of Gabriel getk2.org/community/English-K2-Community/1546-Tool-for-importing--exporting-items-to--from-K2?limit=30&start=210#194102

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

More
10 years 8 months ago - 10 years 8 months ago #58896 by Christian Nielsen
Replied by Christian Nielsen on topic Re: Tool for importing / exporting items to / from K2
Thanks, everything seems to work now except for the images, have tried to move those manually but it dosent help :(

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 #58897 by Individual IT
Replied by Individual IT on topic Re: Tool for importing / exporting items to / from K2
Hi,
I'm sorry to hear you got problems.
Can you please tell us how you tried to transfer the images, so we can help.

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

More
10 years 7 months ago #58898 by Mauro Baldo
I'm having problems with migration from 2 sites in joomla 1.5, you could help, if necessary, could spend data management sites.

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 #58899 by Individual IT
Replied by Individual IT on topic Re: Tool for importing / exporting items to / from K2
Hi,
what problems do you have?
Please report also what version of the K2 Import tool you are using.

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

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