Will this work to migrate K2 Items, Categories, etc. from a 2.5 site to a 3.3 site? Or does it only work within a particular version of Joomla?

Hi the format "Gold,Teal,Purple" should be fine.
Thank you for the screen-shots. But the items I can see in k2_extra_fields are all of the type textfield and before you were talking about multi select fields
And I see that you have extra tables that I don't have. That might be because of the k2fields extension. If this extension changes the database structure my tool will not be able to export/import correctly.

Thank you for your reply. Yes, I did assign the extra fields group to the category. I am attaching to this reply 3 screen shots, one of the table k2_extra_fields, one of k2_extra_fields_values and one of k2_extra_fields_list_values, so you can see what the database tables look like. I am also attaching a CSV file which was producted by the Export command of the K2 Import/Export component.

What I am confused about, is the exact format I need to have the CSV file in for import. With the extra fields, which can contain multiple options, should I be importing option names, such as:
"Gold,Teal,Purple"
or with spaces:
"Gold, Teal, Purple"
or with IDs:
"1535,1539,1542"
or:
"1535, 1539, 1542"
or
"1535:1539:1542"

Which is the proper format?
If necessary I can give you administrator access to look at the component or even cpanel access to look at the database and send you the login information by email.
Thank you for your help.

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

Hi Bob.
I've just double checked with exactly the same software you are using and it is working for me. So its not a change in K2
In the CSV the values should be noted as you write you have done it.
The values in the database should be at the end: {"id":"2","value":["1","2"]}] so the IDs of the group and the values
"969=:=:=","1189=:=:=", looks strange

Did you assign the extra field group to the category you are trying to import into?

Can you please check for me what is the content in the table *k2_extra_fields for the fields you are trying to import and also how the fields are saved in the DB when you create the item by K2.

Hi Bob,
this looks to me like an change in K2 to that I will have to addapt the software. This might take a while as I'm on a training at the moment.

Individual IT wrote: Hi Gabriel Hernández,
both files are not encoded UTF-8, what should not be a big problem as long there are encoded the same way as your database and website.
The real problem is that the files do not have quatation marks on the correct places. It looks for me that you have edited the first file after exporting it and the second has no quatation marks at all. This can work but no guatrantee for it.
each column must be separated by ","
text-fields must be enclosed within double-quote characters => "

check the example CSV file www.individual-it.net/images/stories/com_k2import/example_new.csv
and the instructions: www.individual-it.net/en/Instructions-for-K2-Import-Component.html

Please compare the example CSV with your file using a simple text editor.
In my experiences LibreOffice handles CSV files much better than Excel. There you have also the posibility to say how the columns have to be separated end enclosed.

Hope That Helps

The problem maybe is if my csv file came from another database (not k2) to be specific from sobipro and they export application doesn't give the option to encode and about the quantation marks i just have the option of the data Separator and multi-values separator.

So i think will be impossible use that database with your plugin, at least i don't know how to do it.
:( :(

Thank you for your reply.
Joomla 3.3.0
K2 2.6.8
K2fields 2.0.0
K2 Import 2.0 rc1
I would like to know the exact format for importing multiple options.
Thanks for your help!

Hi Bob,
what version of Joomla, K2 and the extension are you using?

Hi Gabriel Hernández,
both files are not encoded UTF-8, what should not be a big problem as long there are encoded the same way as your database and website.
The real problem is that the files do not have quatation marks on the correct places. It looks for me that you have edited the first file after exporting it and the second has no quatation marks at all. This can work but no guatrantee for it.
each column must be separated by ","
text-fields must be enclosed within double-quote characters => "

check the example CSV file www.individual-it.net/images/stories/com_k2import/example_new.csv
and the instructions: www.individual-it.net/en/Instructions-for-K2-Import-Component.html

Please compare the example CSV with your file using a simple text editor.
In my experiences LibreOffice handles CSV files much better than Excel. There you have also the posibility to say how the columns have to be separated end enclosed.

Hope That Helps

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.

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!!! :)

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 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

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.

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

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

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

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.

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 ;)