Categories
View Replies (1)

Resolved Created another custom Rule Plugin to query database and add a field to import

  1. davidmdavis
    davidmdavis
  2. RO CSVI
  3. Thursday, 29 March 2018
  4.  Subscribe via email
So my first custom rule plugin worked out great. Thanks for the help on that. My next question is as far as finding K2 items. I created a database query to get the id, I can't seem to be able to set published status to 2 for trashed or trashed to 1
The only fields I am using on import are my HIN number to run the query to find the k2 item id and the published set at 2 and trash at 1.

It seems to fail every time to do anything. Do i need more than the unique k2 item id to update k2? I don't see my items being skipped.

Just wondering if there was any input? It seems to process everything fine and finds the information and replaces it but I don't know if the "id" field needs to be first or what for this to run. My first import file field is the custom extra field.

Is it possible to process on just the k2 item records id or does it need the entire name?

I will post this custom rule once I have it figured out for others to base work off of.
0
Responses (1)
tharuna
tharuna
Accepted Answer Pending Moderation
Hello David,
I created a database query to get the id, I can't seem to be able to set published status to 2 for trashed or trashed to 1
The only fields I am using on import are my HIN number to run the query to find the k2 item id and the published set at 2 and trash at 1.

It seems to fail every time to do anything. Do i need more than the unique k2 item id to update k2? I don't see my items being skipped.

Add alias and category_path or catid fields to your import file instead of id and run the import. CSVI uses these as needed fields and to find the matching record from the database.

Just wondering if there was any input? It seems to process everything fine and finds the information and replaces it but I don't know if the "id" field needs to be first or what for this to run. My first import file field is the custom extra field.

No, there is no order needed for fields in import file. CSVI looks for availability of fields and not their order.

Is it possible to process on just the k2 item records id or does it need the entire name?

Run the import by adding the needed fields as mentioned. If you still have problem, please post the import debug log and sample of your import file to check. To Know on how to get the debug log check How to get debug information? document.
Kind regards,

Tharuna

=========================
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
  • Page :
  • 1


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