Hi,
the values in the file are separated by tabs, not by comma thats the problem

Individual IT wrote: Hi,
the values in the file are separated by tabs, not by comma thats the problem

Thanks!

Don't forget to rate the extension: extensions.joomla.org/extensions/extension-specific/k2-extensions/12408

I tried that with a programmer but it was impossible. Right now, it is impossible to migrate my Zoo articles to K2 (Joomla 3.2)

I test the module in localhost XAMPP

• Joomla version 3.2.3.
• XAMPP
• K2 version K2 v2.6.8
• the K2 Import / Export tool version latest: com_k2import_2.0_rc1

I use the Import for K2 module to transfer K2 items from one website to another. I have K2 Extrafield Groups and Extra fields in K2.

Problem 1
I tried to export more than 2.300 K2 items from one K2 category and always have the same error: /…/administrator/index.php?option=com_k2import&format=raw The export hangs and nothing happened.

Problem 2
In categories with fewer K2 items I managed to export the data (with Extra fields etc.). When I Import the data all of the K2 items and Category are correct but no Extrafields and ExtraField groups imported.

Are there any solutions on those problems?

Thank you
Alex

Hallo Alex,
exporting large sets can cause your server to run out of memory. Try to export category by category.
Before the export did you create the extra group in K2? and was the association correct during the import?

Thank you for your reply.

I must first to create the Extra Fields and associate them. That is clear I' ve done it and it worked.
The problem with the category remain. I have more than a 2.000 items in one category. The module has not the ability to split a category for export in parts.

Do you have any other proposal to export large categories.

Thank you

At the moment the only way to split exports is to export category by category. If you category is huge you have to increase the different limits im PHP or delete e.g. coments, they need a lot of ressources to be exported

Hi, I just have a question: I have a newspage made with K2 in joomla 2.5, which now contains over 300 items, but I have been forced to recreate the site with a joomla 3.2 and K2. Is it possible with your solution to transfer all the items from the J2.5 page to the new J3.2 site?

Yes that should be possible with some limitations:
1. some minor fields might not be transfered
2. images names are exported but you would need to transfer them to a place where you can access them from the new page and maybe modify the path in the export file
3. the structure of the categories is not exported. So the only way to import the complete structure is to create it first on the destnation system and have unique names for every single category. Then import with the option "recognize if the category already
exists regardless of the level"

Yes, it worked! :) All my items are now on my new site ^^ That was two euro worth all the money!! :)

One point: you should probably do a rethinking on that instruction page. While the process was simple enough, that instruction was scary as h***!! I almost gave up before I actually started try out on my own ;)

Glad to hear it worked, please place a comment also on JED: extensions.joomla.org/extensions/extension-specific/k2-extensions/12408

I know I'm not a great writer of documentations. I would be very happy if you could help me to improve the instructions.

Hi There

I was hoping you might be able to help me troubleshoot a problem I am having with K2 Import. I am using the following:

Joomla 2.5.17
PHP 5.4.26
K2 2.6.8
K2Import 1.1

I have exported the category from K2 and made the required changes to the file. Once I go to import the .csv, it takes me to the first import screen where I select the extra fields group and choose to overwrite existing items. I then click on continue and it eventually sends me to a screen where I can match up all the fields. However, there appears to be some kind of conflict as that is all that shows on the screen; no more menus or buttons, no evidence of joomla at all. This becomes a dead end as there is nothing to click on to proceed.

I'm not sure if I have a conflict of some sort as this feature used to work for me when I populated the K2 categories. I am willing to share login info if you are able to take a look and discover the problem.


Any help would be greatly appreciated!
Robin

can you please try to use an other browser and share a part of the csv file.

HI there,

I have an issue after exporting k2 article from joomla 3.2 to joomla 3.2 all when fine :) , except for the year of the articles

the csv file contain the dates and year and is all fine, but in k2 after import it display like this 29 November -0001 23:34 the

see attached image
screencast.com/t/NUdnwcGNdd

apparently i'm missing something :) thanks for all your help

check the date and time formats in your CSV file. It should be "YYYY-MM-DD hh:mm:ss" e.g. "2012-05-16 15:17:14". If you saved the file with a spreadsheet software like Excel or Openoffice check the CSV file with a text editor before importing.

I tried to import my csv files, after assign the columns and everthing appear a successful message of import but items doesn't appear.

Can you help me?

I'm attaching a sample of my CSV file, and just to let you know i didn't assign all the columns.

I just need the from the E to the O row, can i add that info to specif category already on my k2 categories?

Thanks

Sorry I don't see any attachment.
Can you please try to create some test items in K2 export them and import the file into a new category without editing the file.

And please report your Joomla,K2 and K2Import versions

I already created 3 items then i tried to uploaded changing just the title like they are different items and i getting some errors:

I'm attaching 2 csv files to check it.

The "export-template.csv" are the items created on k2 and then exported to another category i get this error:

An error has occurred.
422 Found an unescaped quote in quoted field 72 of csv line 0 (text line 1). The first 50 chars from the start of the field are '"robots=\n'.


The "fssc-part1.csv" are the data from another database (not k2) wich i want to use to create k2 items. When i used i had this message but the items wasn't created.

importing items, please stand by
items were successful imported
Row: undefined / memory peak: 13.25 MB
Import finished


Like you can see i'm just interested on some fields or rows, to be exactly just the title and extrafields.

Can you help me to handle this?

Using this versions:
Joomla! 3.2.3
K2 v2.6.8
K2 Import 2.0_rc1


Thank you so much!!! :)

Hi. I am trying to use K2 Import/Export to import items with extra fields, that have multiple options. I have already created the option lists. For example, I have a field "Color" which has options like Magenta, Red, Gold, Green, Purple, etc. I am also using the k2fields extension.

In the documentation for K2 Import/Export, it says, "for... multi select lists : "option 1, option 3"" etc.
Is a space required after the comma?

I imported a field with 2 options in it, i.e., for the "Color" field, I imported "Gold,Purple."
When I look in the database after the import, in the table k2_items, I see under "extra_fields" this:
[{"id":"16","value":"Gold, Purple"}]

But, nothing shows up on the front end. The Colors field is there, but there is nothing next it. So the "Gold, Purple" does not appear.

Also, I noticed on the back end, that that field (Colors) became impossible to edit. The field name is there, but there is no edit box for it.

To find out the proper way to code the field options, I created an item within k2, and assigned some options to that field, then use K2 Import/Export to export that item. The resulting CSV file that I downloaded has this type of data in the extra fields:
"969=:=:=","1189=:=:=",

Apparently those numbers are references to the option values, rather than the text of the option. (These numbers are not the ones for Gold and Purple, they are just other options I randomly chose when creating a new item.)

So, what I'm asking is, how do I properly code the options for a field with multiple possible options?
Do I have to use the numbers instead of the text values? And if so, how do I know what the numbers are for each option? And finally, what is the proper format for me to code these in the CSV file for import?

Thank you for your help.