Keyword

Tool for importing / exporting items to / from K2

More
12 years 10 months ago #58720 by Daniel Pulido
Replied by Daniel Pulido on topic Re: Tool for importing / exporting items to / from K2
Sorry, in the previous message I'm not told you that the version of joomla i´m using is 1.5.26 and k2 2.5.4 i hope you can tell mi what´s wrong with this thank you

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
12 years 10 months ago #58721 by Individual IT
Replied by Individual IT on topic Re: Tool for importing / exporting items to / from K2
please try to use the version 0.9_beta2
If you cannot download it please drop me an email in my contact form www.individual-it.net/en/kontakt-impressum.html

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

More
12 years 10 months ago #58722 by Daniel Pulido
Replied by Daniel Pulido on topic Re: Tool for importing / exporting items to / from K2
Hello again Artur, the same thing using 0.9_beta2 and 0.9_beta1 please help me
any suggestion?

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
12 years 10 months ago #58723 by Individual IT
Replied by Individual IT on topic Re: Tool for importing / exporting items to / from K2
please send me the CSV file.
If I cannot find the mistake there, it would be good it you send me the joomla admin details so I can debug on your host.

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

More
12 years 10 months ago #58724 by Peter
When I try using this module on my localhost copy of my site, I receive the following error message:

importing items, please stand by
items were successful imported
Row: 10 / memory peak: 13.5 MB
importing items, please stand by
items were imported, but with some problems:

cannot open file: C:\xampp\htdocs\onthego/tmp\

Row: undefined / memory peak: 7.75 MB
Import finished


I tried increasing the memory_limit in xampp's php.ini file from 648MB to 1648MB and restarting Apache and MySQL, but it still fails at the same spot (row 10). It works fine if I split up my spreadsheet, but who wants to do that? ;)

Any ideas on how I can fix this?

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
12 years 10 months ago #58725 by Individual IT
Replied by Individual IT on topic Re: Tool for importing / exporting items to / from K2
Hi,
this is strange if he finds the file ones and then not again.
please check first your joomla settings for the tmp directory C:\xampp\htdocs\onthego/tmp\ lools strange should ne C:\xampp\htdocs\onthego\tmp\
And then tell me the version of the extension you are using - see first post. and send me the CSV file

What you always can do is increase the number of rows that are imported in one go, but this will not solve the real problem

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

More
12 years 9 months ago #58726 by Nick
It seems that the tool returns an empty page with no errors when I export all the categories (nothing selected). I have 400 categories. What do?

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
12 years 9 months ago #58727 by Individual IT
Replied by Individual IT on topic Re: Tool for importing / exporting items to / from K2
Hi Nick,
does the export of less categories work? If yes you probably running in limitations of your server max_execution_time or memory_limit

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

More
12 years 9 months ago #58728 by Nick
doh of course, how long do you think i should set those? max execution time is 30 sec... Eh i'll just set it to 100. Will report back!

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

More
12 years 9 months ago - 12 years 9 months ago #58729 by Nick
I changed the max_exec time to 300 seconds and still a blank screen. Memory limit is 128 mb. What should i do? :O

I tried going through your code but its going to take a while to understand it.

Can't you just split up the queries and do just 100 each time? I have 3000+ items..

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
12 years 9 months ago #58730 by Individual IT
Replied by Individual IT on topic Re: Tool for importing / exporting items to / from K2
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.

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
12 years 9 months ago #58731 by Individual IT
Replied by Individual IT on topic Re: Tool for importing / exporting items to / from K2
@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 Log in or Create an account to join the conversation.

More
12 years 9 months ago #58732 by emakki

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.

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
12 years 9 months ago - 12 years 9 months ago #58733 by Individual IT
Replied by Individual IT on topic Re: Tool for importing / exporting items to / from K2
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:
Attachments:

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

More
12 years 8 months ago #58734 by Guy Fraenkel
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

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

More
12 years 8 months ago #58735 by Guy Fraenkel
Where can i get support for this extension??

greets

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
12 years 8 months ago #58736 by Individual IT
Replied by Individual IT on topic Re: Tool for importing / exporting items to / from K2
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

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

More
12 years 8 months ago #58737 by Sanjiv Khullar
Replied by Sanjiv Khullar on topic Re: Tool for importing / exporting items to / from K2
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

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
12 years 8 months ago #58738 by Individual IT
Replied by Individual IT on topic Re: Tool for importing / exporting items to / from K2
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?

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
12 years 7 months ago #58739 by Individual IT
Replied by Individual IT on topic Re: Tool for importing / exporting items to / from K2
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

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


Powered by Kunena Forum