Categories
View Replies (14)

Resolved import k2 item tags

  1. jimmywiddle
    jimmywiddle
  2. RO CSVI
  3. Friday, 10 June 2016
  4.  Subscribe via email
Hi, Im having problems with everything it seems, sorry about all the posts, once again your help is much appreciated.

Im trying to import data for k2 tags, but in the preview I can see it importing no data, whatever i try, I have things setup as follows:

- New Template field -
Field name: tags
Replacement rule: copy-tags-id

- Copy Replacement Rule -
Name: copy-tags-id
Action: Import
Plugin: copy
Source field: prop-id (correct field (present on template fields) which contains 1 tag required (a propertyID) is also being imported and used in other fields)
Target field: tags

Surely this should be it no? I guess im missing something but I have no idea what?

Many thanks in advance!
0
Responses (14)
rolandd
rolandd
Accepted Answer Pending Moderation
Hello Jimmy,

Im having problems with everything it seems, sorry about all the posts
No worries, that is what we are here for.

You don't need to run the actual import to see if the plugins work, the preview already triggers them.

First assign the rule to the prop-id field as that is the one that contains the data. That should be it I think unless the source field name is incorrect.
Kind regards,

RolandD

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 1
jimmywiddle
jimmywiddle
Accepted Answer Pending Moderation
Hi thanks again for the reply/help!

Typically I still have problems, I can now see the tag (theres only 1) in the preview in the tag column (everything looks fine and surely should be working) but when going into the k2 item, there are no tags there.

Any help would be much appreciated!
  1. more than a month ago
  2. RO CSVI
  3. # 2
rolandd
rolandd
Accepted Answer Pending Moderation
Hello Jimmy,

Post me the debug log of your import and a printscreen of your import preview showing the tag.
Kind regards,

RolandD

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 3
jimmywiddle
jimmywiddle
Accepted Answer Pending Moderation
Many thanks, they are attached.
Attachments (2)
created-date-import-preview.png created-date-import-preview.png
com_csvi.log.519.zip
  1. more than a month ago
  2. RO CSVI
  3. # 4
rolandd
rolandd
Accepted Answer Pending Moderation
Hello Jimmy,

You know what I see in the debug log is odd. The tag is found with ID 3 and the Item has ID 458 and the cross reference table between tag and item is filled with these values.

Now it doesn't happen for all items because for some it can't find the item, so in that case there won't be any tag linked to that item.

In case of Canary Wharf E14 9JH 106DH 116 the tag reference is stored. Is that one empty as well for you?
Kind regards,

RolandD

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 5
jimmywiddle
jimmywiddle
Accepted Answer Pending Moderation
Hmm strange, yes it not storing any tags at all, yep they are all empty im afraid to say.
  1. more than a month ago
  2. RO CSVI
  3. # 6
rolandd
rolandd
Accepted Answer Pending Moderation
I wonder if you have a database issue. If you know how, can you go to PhpMyAdmin and execute this query 
INSERT INTO `mcj91ao6d_jos_k2_tags_xref`

(`tagID`,`itemID`) VALUES 

(3,458)
That is the query in your debug log and works fine for me to add the cross reference.
Kind regards,

RolandD

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 7
jimmywiddle
jimmywiddle
Accepted Answer Pending Moderation
Hi Roland,
Thanks again for your reply/help.

Ok done

- MySQL returned an empty result set (i.e. zero rows). (Query took 0.0023 sec)
- INSERT INTO `mcj91ao6d_jos_k2_tags_xref` (`tagID`,`itemID`) VALUES (3,458)
  1. more than a month ago
  2. RO CSVI
  3. # 8
rolandd
rolandd
Accepted Answer Pending Moderation
Hello Jimmy,

So that looks good. Now when you look in the k2_tags_xref table, do you see any entries there?

If you do, can you send me Joomla, FTP login and a test file so I can see for myself what happens?
Kind regards,

RolandD

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 9
jimmywiddle
jimmywiddle
Accepted Answer Pending Moderation
Yes I see the following:

id tagid itemid
25 3 458
26 4 474
27 4 473

Although I believe i manually setup ids 26 and 27 and also perhaps 25 as i added these tags before I ran the sql query this morning.

Many thanks for looking at this, ill private message you acccess, thanks again!
  1. more than a month ago
  2. RO CSVI
  3. # 10
rolandd
rolandd
Accepted Answer Pending Moderation
Jimmy,

Don't see the problem. Ran the import and the items have their tags if the tag exists in the system. If the tag doesn't exist in the system, it is not assigned to the item.
Kind regards,

RolandD

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 11
jimmywiddle
jimmywiddle
Accepted Answer Pending Moderation
Hi Roland,

I think you have just stated the problem... if the tag doesn't exist in the system already, it isn't created/assigned to the item? right?

Looks like I have a big problem? Is there anyway we can create new tags from the import?

Really hoping on some good news, as this and the k2 category params import (other post) could make this process a whole lot more manual than it was before, I know my client wont be happy with this.
  1. more than a month ago
  2. RO CSVI
  3. # 12
rolandd
rolandd
Accepted Answer Pending Moderation
Jimmy,

Attached a patch file that will add non-existing tags to the system upon import.

could make this process a whole lot more manual
I guess you mean less instead of more.
Attachments (1)
patch_k2item_tags_20160616.zip
Kind regards,

RolandD

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 13
jimmywiddle
jimmywiddle
Accepted Answer Pending Moderation
Hi Roland,

Is less now :) Once again thanks so much!!!

Amazing support and component!!!
I would recommend everytime!!!

Thanks again!!! :)
  1. more than a month ago
  2. RO CSVI
  3. # 14
  • Page :
  • 1


There are no replies made for this post yet.
Be one of the first to reply to this post!