Resolved Joomla Content: Wrong export file with issues

Good morning Benny,

Looking at the debug log it tells me you have set to use the file for configuration, so any fields you have added to your template will not be used. In your import file there is no field called published. This means that all menu items will be unpublished as you have noticed. The published field can take either a 1 or a Y to being published.

The import file also has no field for menu ordering, this means that no ordering will be added to the menu items. To use the menuordering field you can use the values 1,2,3, etc. but also -1 for making it the first child or -2 to make it the last child.

My suggestion is to add these 2 fields, published and menuordering, to your CSV file and then run the import to see how it goes.

Ho Roland,

thx for answering. If I have understood correctly, the setting in the import template must be set to "no". Right this:https://gyazo.com/ae8cedf6cf3c6f1d5a80175fb0861eeb

The "menuorder" and "published" fields must also be entered in the export template as a field or not? Are these the right settings for the file export: https://gyazo.com/79709966b1c17ab4a621f6872d81cbcd

Regarding the "ordering": I have a maximum of one sub-category, I would like to export the main categories including the subcategories.

Best wishes, Benny

For better understanding: The fields of the export and the import file must be identical?

Hello Benny,

If I have understood correctly, the setting in the import template must be set to "no".

This depends of course on what you want to do, by setting this option to No, the fields will be used in your template and not the column headers in your file.

The "menuorder" and "published" fields must also be entered in the export template as a field or not?

Yes, because you want to import them again.

The fields of the export and the import file must be identical?

They don't have to be but if you are exporting from one site to another it is best to keep them the same. It just makes things easier

Hi Roland,

If I have understood correctly, the setting in the import template must be set to "no".

This depends of course on what you want to do, by setting this option to No, the fields will be used in your template and not the column headers in your file.

[color=red]So If I will not add anyhting at all, EVERYTHING will be exported into the file if config is set to "yes"?[/color]

The "menuorder" and "published" fields must also be entered in the export template as a field or not?

Yes, because you want to import them again.

OK, the fields were already added,
export settings https://gyazo.com/4a3b19a9d8fe4587229df962f4095d1f
import settings: https://gyazo.com/e589a79ea5a50347e66bb5684f5d3cdf with publish field set to value "Y".
Result: Error message by trying to import the file https://gyazo.com/837cd828cd70aed03f4d2d7baf4464ef and it generates more menus... https://gyazo.com/905f3d35a44d7c319be20345a7bd2ca1 which shouldn't ne there, please see logfile and import file called Joomla-Mainmenu1.csv and logfile 124.

I've deleted the unwanted entries and did antoher import (with same file as mentioned above), this time I'vbe set the value of the published field to "1" (import template!). Same thing... https://gyazo.com/395aa023e2b1c80762e4ae1a901c4046 the logfile is 125.

The fields of the export and the import file must be identical?

They don't have to be but if you are exporting from one site to another it is best to keep them the same. It just makes things easier

Hope we will get this fixed, it's a really big menu....

Hello,

So If I will not add anyhting at all, EVERYTHING will be exported into the file if config is set to "yes"?

This option is not related to the export but to the import routines. It is a switch to tell CSVI to either use the fields or use the column headers in the file.

Hope we will get this fixed, it's a really big menu....

I am sure we will, it just needs to be configured correctly.

What you need to do is order the fields in exactly the same order. The way it is now is that the fields are all over the place. So you are reading the fields in the wrong order. Make sure all the fields are in the same order and then run your export and import again.

Let's see what gives.

Hi Roland,

So If I will not add anyhting at all, EVERYTHING will be exported into the file if config is set to "yes"?

This option is not related to the export but to the import routines. It is a switch to tell CSVI to either use the fields or use the column headers in the file.

Hope we will get this fixed, it's a really big menu....

I am sure we will, it just needs to be configured correctly. [color=red]Sounds good! :-)[/color]

What you need to do is order the fields in exactly the same order. The way it is now is that the fields are all over the place. So you are reading the fields in the wrong order. Make sure all the fields are in the same order and then run your export and import again.

I've added the field ordering now,
export:
import:

I'm stil getting more menus (like alias, component, seperator, type, url) please see:https://gyazo.com/3c993352f6d6e240e179724178321844 If you want to you can login into my backend and see if there is something gone wrong.... I will send you a pm. I've already deleted the unwanted entries.

Let's see what gives.

Have a nice day, I will get back to you tomorrow.

Hello,

Your debug log shows your import fields are set in this order:

• menutype


• path


• title


• type


• component


• link


• menu-meta_description


• menu-meta_keywords


• menuordering


• published


• alias

while in your export file your fields are ordered as:

• type


• path


• menutype


• title


• alias


• component


• link


• menu-meta_description


• menu-meta_keywords


• published

As you can see they are not in the same order, that is causing all kinds of problems with your import. As posted before, the fields must be in the same order otherwise you won't be able to move forward.

Hi Roland,

sorry, I've tried to order the fields by "title", this didn't work, so I didn' et the unwanted entries anymore. Yeah :-)

OK, so now please see: https://gyazo.com/15d125d5821e4c53cef654f2a6d4f6aa

As you see the "publishing" worked, but the ordering is wrong and the links to the Vm categories don't fit.

Live shop: https://gyazo.com/2f46d68c02dc29f279883d3440ecab50 (new one is above)

Links live shop:https://gyazo.com/6335569d11997907cc992c00365ea807
Links new shop: https://gyazo.com/a30baeaa5b159ddbda8a1da1a32cbcbb

We're coming closer! Last thing will be user import.

Hello,
The problem with 'Select a category' option in the menu is with the link you are importing for the category. Say for example the link column for path sportnahrung/aminosaeuren in your import file has value index.php?option=com_virtuemart&view=category&virtuemart_category_id=71&virtuemart_manufacturer_id=0&categorylayout=0&showcategory=1&showproducts=1&productsublayout=0, if you see the virtuemart_category_id=71 in the link and there must be no category_id with id as 71 in your VirtueMart categories table and so it selects wrong category option. You may need to put in the correct category_id in these links from your VirtueMart category table so the category is selected correct in the menu page after import.

Allright, I understand. It's because the categories don't have the same ID as in the live shop.

I will fix it manually. So last thing is the import of the users. I will get back on this tomorrow. Thx!

Hello,

Can you please start a new thread for the user import issue? Thanks.

This is becoming a dump all thread inch:

Sure :silly: