Resolved category_path combined question

Hi Roland,

Whatever I try I cannot get the category_path column to show on the preview.

Its difficult to set it up the same as different fields are available I tried with the combine but no joy im afraid, heres what I got:

TEMPLATE FIELDS:
Field name: category_path
Rules: category_path-category-import

Field name: combine
Your field: categorypath_Properties
Default value: Properties
Rules: category_path-category-import

Field name: combine
Your field: Properties_PropertyID (this is the name of the column containing the ID in the import file)
Rules: category_path-category-import

RULES:
Name: category_path-category-import
Action: import
Plugin: combine
Source fields: categorypath_Properties,Properties_PropertyID
Target field: category_path
Combine character: /

To clarify the category_path needs to be:
Property/[Properties_PropertyID]

(Property/ will be the same for all items imported)

Please tell me what im doing wrong, call me an idiot if you want lol
Thanks again!

Jimmy,

The problem is you had set your template to Use file for configuration instead of using the fields you assigned to the template. I changed that, you can check the preview now.

Hi Roland,

Thanks again for your reply/help!

Good news the category_path is now appearing on the preview although all the preview data makes absolutely no sense to me at all (it has all changed and replaced with random data from the import file), ive been trying to work out some relation between the data and setting/import file, but cant, as i say, it all seems random?

Sorry about this, your help would (as usual) very much appreciated and thanks again!

Hello Jimmy,

I can tell you for sure that CSVI isn't randomizing the data by itself, it simply shows how you configured the template.

Check the fields you have assigned to your template if they are in the same order as the fields are in your import file.

If needed start removing all the assigned rules to the fields of your import template. Look at what you have and assign rules as you need them.

Hi Roland,

Thanks again for your reply/help!

Ive checked the fields and removed all the rules, its not random now and is importing the first 4 columns.
Im attempting to use the same import file for k2 items and k2 category params (as I believe, you said previously I could).

Basically for the 4 fields required 3 of them will have the same data for all categories therefore I was hoping i could use default values in the field settings and only the category_path will change, which will be made up of properties/[the-id-taken-from-import-file] the other fields.

K2 Category import category_path properties/[id-of-field-from-import]
K2 Category import inheritFrom Properties
K2 Category import theme properties
K2 Category import extraFieldsGroup 1

But yes currently the import just pulls the first 4 columns ignoring the default values set for 3 fields.

And the rule seems to be ignored or doesn't make sense to me for the category_path

Your help would be once again very much appreciated, many thanks in advance!!!

Hello,

What you are doing wrong is not specifying all the fields in your import file. You now have only 4 fields defined in your import template. Basically what you are saying is that the import file only has 4 fields. That is not the case is it? How would CSVI know which columns to pull in? You added 4 fields, so CSVI pulls in the first 4 columns.

You must add all the columns in your import file. The ones you don't want to import you choose the fields skip so that CSVI will skip them.

Hi Roland,

At last, I got it perfect many many thanks for your help!

BUT I have an issue when adding this to the menu to run on the frontend, unfortunetly it only shows me export templates in the 'Select template' dropdown although i have selected 'COM_CSVI_IMPORT_FRONTEND' on the menu type dropdown, also the language is missing for import but not export (and only the export templates show no matter if import or export menu types are selected).

Ive completed this job if I can add this menu item, so im very keenly awaiting your help.

Many thanks in advance!!!!

Hey Jimmy,

Front-end import is not part of the current release, this will come in the next release version 6.6.0. You can find the patch for front-end import in this thread.

Hi Roland,

Once again many thanks, I applied the patch but it hasn't made any difference with regards to trying to setup the import as an menu item, still the same problem im afraid.

Thanks again for your help Roland, hoping its a quick one for you as im desperate to finish this project, thanks!!!!!

Hey Jimmy,

Before applying the patch I linked, did you also apply the patch posted in the thread at the top of the page? This is the main patch, the second one is a fix to that. Give that a try.

Hi Roland,

Cant thankyou enough, such fast and efficient support, it puts others to absolute shame!!!

Many thanks again Roland!!! Legend!!!

Hello Jimmy,

Glad to hear all is finally solved. You are fast becoming a CSVI Expert

Perhaps you can help me out and post a review at the Joomla! Extension Directory