Do you have a lot of comments.
a loop that exports just 100 items would be possible but I would have to change a lot in the background.

@All who have problems with international characters,
I think I found the source of our problem.
fgetcsv is not really binary save, it depends on the environment variable LANG, I cannot predict it and not set it inside of joomla.
www.php.net/manual/en/function.fgetcsv.php
"Locale setting is taken into account by this function. If LANG is e.g. en_US.UTF-8, files in one-byte encoding are read wrong by this function. "

This means I need an own csv import function.
I will fix this problem, but it might take a while.

Individual IT wrote: @All who have problems with international characters,
I think I found the source of our problem.
fgetcsv is not really binary save, it depends on the environment variable LANG, I cannot predict it and not set it inside of joomla.
www.php.net/manual/en/function.fgetcsv.php
"Locale setting is taken into account by this function. If LANG is e.g. en_US.UTF-8, files in one-byte encoding are read wrong by this function. "

This means I need an own csv import function.
I will fix this problem, but it might take a while.

Please put in mind JSon does not convert UTF characters. I faced this issue in Arabic when I installed a k2 article submit component (I thinks it is something Story). I used your import script and it really saves tons of time. However, it imports all characters except Arabic.

I would really be happy if this issue is resolved for all international users. Keep up the good work.

The version 0.9_beta3 is out and is has a complete new csv parsing function.
As I was to lazy to write an own one I've stolen it from: thuejk.blogspot.com/2010/01/phps-implementation-of-fgetcsv-and.html

This is the best csv parsing function I could find and it seems to work very well. I have positive feedback with Greek and Cyrillic items, so I hope all UTF8 characters should work fine now.

I also changes the peace of code that generates the alias, now the original code of K2 is used. Its more complex but it should work with the whole UTF8 range.

So have fun with the new version: extensions.joomla.org/extensions/extension-specific/k2-extensions/12408 and don't forget to rate it at
The Joomla! Extensions Directory if you like it.

As this forum has no RSS and no email notification in the case of a problem it might be faster to write me an email: www.individual-it.net/en/kontakt-impressum.htm or a twitter messege: twitter.com/individualit.

For people who didn't use the extension before here some pics:

Hello,

i have just purchased the tool and i want to do the following:

Import all K2 stuff from my old Joomla 1.5 (running latest K2) to my new Joomla 2.5 (running latest K2).

I install the component on both systems, they run on the same server (/ and /25/). When i export in the 1.5 i get a 5mb file. When i try to import this file in 2.5, all seems to be ok, but when i want to assosiate the rows the image (path to image) value is missing. What can i do about this? How can i fix it?

Thank you very much,
greets

Where can i get support for this extension??

greets

Sorry this forum has no RSS that’s why its hard to keep track with the questions.

The export does not export the image, but you still can import images but you would have to do this manually.
But if you are using the same K2 version in both joomla installations, try just to copy the MySQL tables via phpmyadmin

I get the following error

JFile: :copy: Cannot find or read file: $/home/film/public_html.
Unknown Archive type

Warning: strstr() [function.strstr]: Empty delimiter in /home/film/public_html/administrator/components/com_k2import/controller.php on line 890

Please advise

Hi,
could you please tell me what joomla and PHP version do you use and when exactly this error occurs?

do you try to upload a ZIP file?

just uploaded the 0.9_beta4 version.
this version fixes some problems when exporting extra-field names or content with special characters line " or '

JED page
direct download
Ask questions and get support on twitter

Hi there,

The component is working fine except for two problems:

1. The alias is importing without considering the hifen. Ex.: "Agricultor-prefeitura-de-maranguape-esaf-fundamental-2008" turns in "agricultorprefeiturademaranguapeesaffundamental2008" .

2. The Attachment1 Title is not being recognized and it is taking the name of the file instead of the name put in the csv file.

I'm using LibreOffice, my csv file is encoded in UTF-8 and I'm putting quotation marks in all text cells.

Since all others csv data is being imported correctly I'm not understanding why the two issues above are happening.

Can anyone help me with it please?

Thanks in advance.

PS: I put the csv file attached.

Here's the file.

Hi,
I will have a look at it, but could you please report what PHP / Joomla / K2 / Import-tool version you are using.

PHP Version: 5.2.17
Joomla! Version: Joomla! 2.5.6 Stable [ Ember ] 19-June-2012 14:00 GMT
K2 Version: 2.5.7
K2 Importing Version: 0.9_beta4

I found the problem with the aliases and today I will investigate the Attachment problem

Just declared the version 0.9 as stable and published it: www.individual-it.net/en/Joomla/ .
The only change from 0.9_beta4 are that it now accepts "-" in the aliases and the auto association with the fields are improved a (very) little bit.

@Franklin This version should solve your problem with the aliases. And are you sure you associated the Attachment Title correctly with the right column in the CSV file. If in the "associate the fields" screen the attachment title dropdown is set to "take standard or leave empty" the software will try to generate a title.
The automatic association is just guess work. You have always to double-check it. But you can help it by naming the column "Attachment Title 1" instead of "Attachment1 Title". I changed my example file and the export according to it.
P.S. if your download link does not work anymore, write me a short email

Hi,

I was leaving the attachment title empty in the "associate the fields". It's working fine now.

Could you please send the new stable version to my email? I was not able to find the link to download it again.

Thank you.

Hello,

I already have 5,000 items living in K2. Now I need to import 5,000 images, one for each item.

Does this tool can import only item images and leave the rest of the items info just as they are already in the database?

That would solve my problem

Please advise.

The easiest way would be to export the items, then change the CSV with the images and the reimport the file with the option: Overwrite - based on ID.

BUT before you are doing this make a full database backup!!!

Just published the version 0.9a just some minor fixes included.

extensions.joomla.org/extensions/extension-specific/k2-extensions/12408