Keyword

Tool for importing / exporting items to / from K2

More
10 years 6 months ago #58920 by Saifullah Sammo
Replied by Saifullah Sammo on topic Re: Tool for importing / exporting items to / from K2
Hi,
I am using k2 import component for importing English and Turkish article by Csv format.
but getting a lots of error.
Joomla! 3.3.1 Stable [ Ember ]
K2 Version 2.6.8
some of them are:

Strict Standards: Declaration of K2importController::display() should be compatible with JControllerLegacy::display($cachable = false, $urlparams = Array) in /home/minaretr/public_html/administrator/components/com_k2import/controller.php on line 23

Strict Standards: Only variables should be assigned by reference in /home/minaretr/public_html/administrator/components/com_k2import/k2import.php on line 29

Strict Standards: Only variables should be assigned by reference in /home/minaretr/public_html/administrator/components/com_k2import/k2import.php on line 30

Strict Standards: Non-static method k2importToolbarHelper::upload() should not be called statically, assuming $this from incompatible context in /home/minaretr/public_html/administrator/components/com_k2import/views/k2import/view.html.php on line 28

Strict Standards: Only variables should be assigned by reference in /home/minaretr/public_html/administrator/components/com_k2import/helper.php on line 14

Strict Standards: Non-static method k2importToolbarHelper::export() should not be called statically, assuming $this from incompatible context in /home/minaretr/public_html/administrator/components/com_k2import/views/k2import/view.html.php on line 30

Strict Standards: Only variables should be assigned by reference in /home/minaretr/public_html/administrator/components/com_k2import/helper.php on line 24

Strict Standards: Only variables should be assigned by reference in /home/minaretr/public_html/administrator/components/com_k2import/views/k2import/view.html.php on line 34

Strict Standards: Only variables should be assigned by reference in /home/minaretr/public_html/administrator/components/com_k2import/views/k2import/view.html.php on line 56

Strict Standards: Only variables should be assigned by reference in /home/minaretr/public_html/administrator/components/com_k2import/views/k2import/view.html.php on line 57

Strict Standards: Only variables should be assigned by reference in /home/minaretr/public_html/administrator/components/com_k2import/views/k2import/view.html.php on line 144

Strict Standards: Only variables should be assigned by reference in /home/minaretr/public_html/administrator/components/com_k2import/models/category.php on line 133

Strict Standards: Only variables should be assigned by reference in /home/minaretr/public_html/administrator/components/com_k2import/views/k2import/tmpl/default.php on line 14

Even though i am using the sample csv file format from www.individual-it.net/en/Instructions-fo...mport-Component.html here.

what should i 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
10 years 6 months ago #58921 by Individual IT
Replied by Individual IT on topic Re: Tool for importing / exporting items to / from K2
Its not a error it just says I could program stricter. Your Error reporting is very verbose, good for development, bad for usage. Go to System-> Global Configuration->Server and set "Error Reporting" to "Simple"

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

More
10 years 6 months ago #58922 by Saifullah Sammo
Replied by Saifullah Sammo on topic Re: Tool for importing / exporting items to / from K2
:( Hi, I have done that. I am importing English and Turkish content using your component.
It works fine English Content. But there are some Turkish character which are like Ğ Ç Ş Ü İ , and this characters can not be imported with this component. Now what to 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
10 years 6 months ago #58923 by Individual IT
Replied by Individual IT on topic Re: Tool for importing / exporting items to / from K2
Please check if your file is saved as UTF 8 and your server and database also run UTF8

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

More
10 years 6 months ago #58924 by Saifullah Sammo
Replied by Saifullah Sammo on topic Re: Tool for importing / exporting items to / from K2
yes, Indeed. Both the MySQL settings and Open Office File settings are in UTF 8 :|

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 5 months ago #58925 by Individual IT
Replied by Individual IT on topic Re: Tool for importing / exporting items to / from K2
Can you please post a part of your file, so I can try to make an import.

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

More
10 years 5 months ago #58926 by Marco Cevoli
Hi,
I've exported a category with 6 items, made some modifications and tried to import the file, but I get this error:

Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 80 bytes) in /home/servername/public_html/libraries/legacy/exception/exception.php on line 130

Any ideas?

Thanks a lot

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 5 months ago #58927 by Individual IT
Replied by Individual IT on topic Re: Tool for importing / exporting items to / from K2
Hi,
you will have to increase the memory_limit in your php.ini

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

More
10 years 5 months ago #58928 by kelvin
Hello, I just bought the component and exported a category on my website, when importing the csv file for that category i get this error massage at the end (Had to make the error massage short because it was very long);
row: 1 there is no user with the ID: 62 I'm using the ID:411
row: 1 - save item -

could not find item to overwrite I will create a new one. WHERE clause: title = 'Music | D-Eye - Caro [@Yungboy_D_Eye]' AND `catid` ='3'

row: 1 - save image - Local file doesn't exist. /home/content/93/9888393/html/media/k2/items/src/73d7edd1405081e5433c41d9ad2ee18c.jpg
row: 2 there is no user with the ID: 62 I'm using the ID:411
row: 2 - save image - Local file doesn't exist. /home/content/93/9888393/html/media/k2/items/src/ce93b7c97ea8831859bbe17c36b83648.jpg
row: 3 there is no user with the ID: 62 I'm using the ID:411
row: 3 - save item -

After which the exported category that had 197 items on the old site now has just only 9 items on the new site after importing. what happened to the remaining items and why are images not imported.

How do i export and import the complete amount of items that was in the category?
How do i export and import the images for all the items belonging to that category?

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

More
10 years 5 months ago #58929 by JoomlaWorks
@Artur I think it's time for you to setup a forum for your extension. It's proven to be quite popular :)

Fotis / JoomlaWorks Support Team
---
Please search the forum before posting a new topic :)

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 5 months ago #58930 by Individual IT
Replied by Individual IT on topic Re: Tool for importing / exporting items to / from K2
Hi kelvin.
Did you select the option to overwrite items. If you did so then maybe some items are overwritten.

The export of images only exports the path. you have to transfer the images yourself to the new server and give its path in the CSV file.
the "path to an image" can be the path to an existing file on your server, starting from the joomla-root e.g. images/stories/pastarchives.jpg

Please check also the documentation:
www.individual-it.net/en/Instructions-for-K2-Import-Component.html

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 5 months ago #58931 by Individual IT
Replied by Individual IT on topic Re: Tool for importing / exporting items to / from K2
Hi Fotis,
yes I'm glad its used a lot.
Do you mean that I should install a forum on my own domain? If possible I would prefer to stay on getk2.org. It's simply just less work for me.

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

More
10 years 5 months ago #58932 by JoomlaWorks
Having a dedicated forum might have been a good idea for searching, announcements, bugs and so on. But if you prefer to keep this post, then it's OK with me :)

Fotis / JoomlaWorks Support Team
---
Please search the forum before posting a new topic :)

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

More
10 years 5 months ago - 10 years 5 months ago #58933 by kelvin

Individual IT wrote: Hi kelvin.
Did you select the option to overwrite items. If you did so then maybe some items are overwritten.

The export of images only exports the path. you have to transfer the images yourself to the new server and give its path in the CSV file.
the "path to an image" can be the path to an existing file on your server, starting from the joomla-root e.g. images/stories/pastarchives.jpg

Please check also the documentation:
www.individual-it.net/en/Instructions-for-K2-Import-Component.html


I did not select the option to overwrite items. i worked with the default settings. i have tried to export and import the category again and am still getting the same result.
I also noticed that the category imported does not appear in the category tab.
this is very urgent as am under pressure from my client.

[Solved] Eventually i was able to find a way around this issue. I increased the "Import Rows Per Loop" from 10 to 500. this way i was able to import all my 197 items without issues. This was done on the test website i had installed on my laptop. I am yet to try this on the Live site, this may be an issue based on PHP max_execution_time. But am thinking if the Live site can handle it then its ok, if not then i can import 10-15 rows per loop and then continue by using "Start num row" to import 10 - 15 rows at a time. If there is any other way to make this easier for me i would appreciate it.
I hope this would help someone out there.

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 5 months ago #58934 by Individual IT
Replied by Individual IT on topic Re: Tool for importing / exporting items to / from K2
I'm happy to hear its working but its still strange.
If it works with 500rows in one go it should work with less.
can you post your CSV file?

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

More
10 years 5 months ago #58935 by kelvin

Individual IT wrote: I'm happy to hear its working but its still strange.
If it works with 500rows in one go it should work with less.
can you post your CSV file?


been working on this for days now.. need help desperately, i have backed up my images from /media/k2/items/src. and copied them to my localhost on my laptop, when ever i edit the image column of the exported .csv file to point to the new image location, i get an endless looping and eventually the import page stops to load, i dont get to see a success on import page, but when i check k2 i see my items, also after creating a menu link to the category i get this error message on the frontpage;

An error has occurred.
The requested page cannot be found.

Home Page
If difficulties persist, please contact the System Administrator of this site and report the error below.
#403 You are not authorized to view this resource

here is the link to the export CSV file.
Pressplay360.opendrive.com/files/OF80ODUyNTMzMl9qNGxSeF85OTI4/Hype.zip

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 5 months ago #58936 by Individual IT
Replied by Individual IT on topic Re: Tool for importing / exporting items to / from K2
Hi,
please try not to place the images into the same folder as on the source system. Place them into the tmp folder of joomla and in the CSV file give the path starting from the joomla root without leading slash.
Please check also the documentation www.individual-it.net/en/Instructions-for-K2-Import-Component.html

Afterwards please report if you still have problems.

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

More
10 years 5 months ago - 10 years 5 months ago #58937 by kelvin

Individual IT wrote: Hi,
please try not to place the images into the same folder as on the source system. Place them into the tmp folder of joomla and in the CSV file give the path starting from the joomla root without leading slash.
Please check also the documentation www.individual-it.net/en/Instructions-for-K2-Import-Component.html

Afterwards please report if you still have problems.

Thanks a lot. I finally got it working, after i created a menu item for the imported category i noticed my imported items were not showing, i noticed that access level was set to 0 on the CSV file so i changed a few access level on some k2 items in the k2 component and the few i changed showed up on the front page with out issues.
My Question! when editing my other CSV files, in the access level column what value should i set for public access instead of the 0 value? thanks for your patience am almost done!

Solved! i simply changed the value from 0 to 1 in all my exported CSV files. that way they become public on the frontend. This is one plugin i enjoyed working with. thanks!

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 5 months ago #58938 by Individual IT
Replied by Individual IT on topic Re: Tool for importing / exporting items to / from K2
Glad to hear its working.
The values do correspond directly to the values in the database.

If you like the extension a comment or rating at JED would be great

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 5 months ago - 10 years 5 months ago #58939 by Individual IT
Replied by Individual IT on topic Re: Tool for importing / exporting items to / from K2
I've just updated the extension and published two new versions:

2.1 for Joomla 3.x
changes:
  • small bugfixes
  • better date checks
  • import/export Hints + Item Parameters

1.3 for Joomla 1.5 - 2.x
changes:
  • small bugfixes
  • better date checks
  • works better with K2 2.6.8 , actually K2 2.6.8 is now required. If you are using an older version of K2 please make an update of K2


As always: If you recently bought the extension please check the link you received after payment, it might be still valid (for every EURO you pay you get 10 days of free download)

Have fun: K2 Import/Export tool

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


Powered by Kunena Forum