Keyword

Tool for importing / exporting items to / from K2

More
10 years 2 months ago #141802 by Igor
I checked and updated, but still the same.

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 1 month ago #142006 by Individual IT
Replied by Individual IT on topic Tool for importing / exporting items to / from K2
seems to be fixed with Joomla 3.0
I strogly advise not to use the outdated Joomla 2.5

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

More
9 years 11 months ago #144629 by Sean Butterworth
Replied by Sean Butterworth on topic Tool for importing / exporting items to / from K2
Hi

The "Instructions" button in the component's control panel leads to a page at JoomlaWorks with the following error message:

"Access Denied
You do not have permissions to access this page."

Even though I'm logged in at JoomlaWorks.

The same applies to the "Manual" link on your website

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
9 years 11 months ago #144649 by Individual IT
Replied by Individual IT on topic Tool for importing / exporting items to / from K2
Hi Sean,
it should lead to this forum. Sorry I forgot to update the link in the component after the K2 forum was moved.
Thank you to point that out. I will change it in the next version

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

More
9 years 10 months ago #145537 by Peer
hi there,

I want to use the import export tool to update the image and image_gallery which I thought would be easier with this tool.
However I'm struggling with the import.

On a test-system I've got J3.4.1 and k2 2.6.8 installed. k2_import export is 2.2 based on windows Xampp

In my testfile I've got "ID","Image","Images for the Gallery" with two rows of data. The IDs from the csv-file are the same than the item IDs within k2_items-table and charset is utf8.
I always end up with the error-massage shown below.
- I then updated components/com_k2_views/item/view.html.php manually due to the date issue. no effect.
- I then updated to k2 2.6.9, no effect.
- My item titles and aliases are getting overwritten by "imported-item-2015-07-09-10-23-xx"

What are the minimum values to only "update" k2 items by selected id given in the csv file and which options shall be selected to configute only for an update?

many thanks, Peer

the errormessage is as follows:
importing items, please stand by
items were imported, but with some problems:
row: 1 - save item -
"" is not a valid date in the "created" column. Will set to 2015-07-09 10:41:28
"" is not a valid date in the "Publish Up" column. Will set to 2015-07-09 10:41:28
"" is not a valid date in the "Publish Down" column. Will set to 0000-00-00 00:00:00 what means "never"
row: 1 - save image - Local file doesn't exist. tmp/k2_import/C2-Leather-Basic.png
row: 2 - save item -
"" is not a valid date in the "created" column. Will set to 2015-07-09 10:41:28
"" is not a valid date in the "Publish Up" column. Will set to 2015-07-09 10:41:28
"" is not a valid date in the "Publish Down" column. Will set to 0000-00-00 00:00:00 what means "never"
could not copy the file tmp/k2_import/C1-White-Semi.png
could not copy the file tmp/k2_import/C1-White-Basic.png
could not copy the file tmp/k2_import/C1-White-Full.png
row: 2 - save image - Local file doesn't exist. tmp/k2_import/C1-White-Semi.png
Row: 2 / memory peak: 7.5 MB
Import finished

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
9 years 10 months ago #145553 by Individual IT
Replied by Individual IT on topic Tool for importing / exporting items to / from K2
Hi,
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.

Where did you store the images for the import?

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

More
9 years 10 months ago #145580 by Peer
HI,

I didn'nt had the datefiels within my export. My colums were only "ID","Image","Images for the Gallery"
However, I tried further on an added the colums "title","created","publish_up","publish_down" from the database.

I suggest that the title always gets rewritten e.g. the alias and the import script loops the date fields.
With these fields added to the import I don't get an error anymore. That was not what I suggested for an update for the image and gallery but it works in the meantime.

I suppose that you can't reproduce this, don't you?

Peer

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
9 years 9 months ago #145648 by Individual IT
Replied by Individual IT on topic Tool for importing / exporting items to / from K2
Hi,
sorry I do not understand you.

According to your first post you had the date-fields:
- created
- Published Up
- Published Down

For recreating the alias field just do set "Alias" to "take standard value" in the "associate the fields" window or delete the column in the CSV file all together

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
9 years 9 months ago #146020 by Individual IT
Replied by Individual IT on topic Tool for importing / exporting items to / from K2
A new version (2.3) of this extension was published with some nice new features:
  • Import/Export category images
  • images/gallery images/category images/attachments can be imported from an URL
  • easier selection of sub-categories during the import
  • Place items into correct category if the import has to overwrite based on ID
  • Help link updated
  • path for images/gallery images/category images/attachments can be anywhere on the server, does not need to be under the joomla folder

find the new version here: www.individual-it.net/en/Joomla/#27
If you already bought this extension please also check if your download link is still valid. You get the update for free if your download link is still active. It stays active for 10 days for every EUR you have paid.

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

More
9 years 9 months ago #146395 by Victor
Hi,

Just purchased this tool and it's working great.
However I'm using two different K2 plugins for adding multiple categories and extra field groups per item.
Is it possible to import item into multiple categories?
How about import also the information of all Extra Field Groups into item (not only one)?

Please advice.

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
9 years 9 months ago #146425 by Individual IT
Replied by Individual IT on topic Tool for importing / exporting items to / from K2
Hi Victor.
Multiple categories or multiple extra field groups are not possible with the K2 Import/Export extension.
How do you plugins manage the multiple categories?

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

More
9 years 9 months ago #146431 by Victor
Hi,
I'm using these following plugins:
1. For multiple extra fields: www.joomreem.com/multiple-extra-fields-groups-mefg-for-k2.html
2. For multiple categories: www.netpin.gr/extensions/item/1-k2-additonal-categories

Hope you can add some support for these plugins.

Thanks.

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

More
9 years 8 months ago #147146 by gr8
Hi,

I have existing K2 items created but need to import over the top of them based on new custom field values. The only real field that i can use that is unique to each item is the 'alias' field.

Title will not work because some items have the exact same title with only the alias to separate them.

How can re-import a csv using your extension and only target those items with a specific alias.

Please advise.

Thanks,
Ryan.

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
9 years 8 months ago #147293 by Individual IT
Replied by Individual IT on topic Tool for importing / exporting items to / from K2
hi Ryan,
can you use the "ID" to overwrite? That one should not change

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

More
9 years 7 months ago #148167 by Peer
Replied by Peer on topic SEO images for k2
Hi,

i followed the instructions from gavick.com mentioned in the following post to use the item alias within the image name.
www.gavick.com/forums/general-discussion/seo-k2-image-18208

I changed all recent files according to the following instructions:
$handle->file_new_name_body = $row->alias.$row->id;
.md5("Image".$row->id).  change to .$row->alias.$row->id.
md5("Image".$current->id) change to $current->alias.$current->id;
.md5("Image".$item->id).  change to .$item->alias.$item->id.
.md5("Image".$news_id).  change to .$news_alias.$news_id.
Code works for all manually uploaded images.

Actually I'm trying to change your "k2import.php" which is the only script I found to handle the images.
on line 865: $handle->file_new_name_body = md5("Image".$this->_k2_item_id);
on line 1138: $image_name = $image_savepath . md5("Image".$items[$item_count]->id) . ".jpg";

Everything I do, I dont get the alias placed within the imagename. May you give me a hint how to appropriate change the code for my needs?

many thanks in advance

Peer

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
9 years 7 months ago #148268 by Individual IT
Replied by Individual IT on topic SEO images for k2
That would be a bigger change, because in line 865 you have no access to the alias.
The alias is created with the code starting from line 89
you would have to save that information e.g. in a variable $this->alias and use it in the saveImage() method

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

More
9 years 5 months ago #149282 by Madeleine McMullin
Replied by Madeleine McMullin on topic Tool for importing / exporting items to / from K2
I've tried using the import tool - v2.3 and have managed to upload the items but not the images. I've even downloaded libreoffice specially as I was having so many difficulties. I have the images in a directory on the server and initially managed to upload some, although I needed to open the files to see the images. I've exported the category and then reimported to make sure that the dates are correct and I get the message that the image is not present in the specified location. I've tried uploading them as a zip to import but I just get a timeout when it is trying to import the file as there are a lot of them. Can you help please?

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
9 years 5 months ago #149302 by Individual IT
Replied by Individual IT on topic Tool for importing / exporting items to / from K2
Hi Madeleine,
make sure in the CSV file the full path of the images are give. On a UNIX/LINUX system this probably would be something like /home/www/......

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

More
9 years 5 months ago #149317 by Madeleine McMullin
Replied by Madeleine McMullin on topic Tool for importing / exporting items to / from K2
Hi, the path I'm using is home/domainname/public_html/ so should be fine. I've checked it against the products that already have images and it matches, except that the folder that they are kept in is different.
Any other ideas?

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
9 years 5 months ago #149350 by Individual IT
Replied by Individual IT on topic Tool for importing / exporting items to / from K2
please try to use a / at the beginning so it becomes /home/domainname/public_html/

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


Powered by Kunena Forum