Resolved Joomla Content: Wrong export file with issues

Sure :silly:

Hello,

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

This is becoming a dump all thread inch:

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,
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.

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,

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,

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,

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,

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 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

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

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

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.

Hello,

I've added the menuordering field in the last import, it seems, that it didn't appear ... I've now tried it again, and added the published field with value=1. These are my settings in the export template:https://gyazo.com/1f9c7778053165a68eb3aba4c297bd94 and this in the import template: https://gyazo.com/1f9c7778053165a68eb3aba4c297bd94.

Please see result: https://gyazo.com/b6e8e4d7035ac66cda2957dd27d3136b publishing doesn't work, although I've set the falue to "1". I've then published the entries manually in Joomla, but this doesn't work also...

Ordering: https://gyazo.com/047c9316ebcabeade497e5e8b6bfc72e
Link: https://gyazo.com/682531847dcde6ebad23e283bd1c8451

I've added the files fpr you.
Have an nice start into the week.
Best wishes, Benny

Hello,

I first thought it's in case of the "/" characters, so I've changed the names of some categories, but this wasn't it. As you see the ordering of the subentries are wrong, and also the links don't work. You can see it here. Live shop: http://gyazo.com/fb0854a61817b186b96abd02815cd02c , new shop:https://gyazo.com/371ca75db0285bd30c70525e2c214866 ("Wählen Sie eine Kategorie".

As i mentioned earlier, menu ordering is missing in your import file though it is there in your template fields. You need to have this menuordering field added to your Joomla-Mainmenu1.csv file so your menu entries are ordered during import. Also your menus are not published and so i think links don't work. The debug log shows that links are entered correct. Try publishing the menus by adding published field to your import and by setting default value to 1. Let me know if this helps.

Good morning from Germany,

I've checked all VM import parts again (manufacturer categories, manufacturers, VM categories and products) and everything is working well. I've tried to timport the mainmanu with all if its content (about 220 entries). Unfortunately it didn't work. This is the liveshop mainmanu: https://gyazo.com/9e4d10431e89e7029fa74b2940d16e2f and this is the new shop: https://gyazo.com/8cad28cc29154dc660d25de4dbf3748a.

I first thought it's in case of the "/" characters, so I've changed the names of some categories, but this wasn't it. As you see the ordering of the subentries are wrong, and also the links don't work. You can see it here. Live shop: https://gyazo.com/fb0854a61817b186b96abd02815cd02c, new shop:https://gyazo.com/371ca75db0285bd30c70525e2c214866 ("Wählen Sie eine Kategorie".

I have added the log and import file for you. Templates are looking like this:

Live shop:https://gyazo.com/a55475ffb676f8e336ba6d2ca8daeded, new shop: https://gyazo.com/a55475ffb676f8e336ba6d2ca8daeded.
Have a nice day.

Hello,

I checked the templates and the shops now. I found the problem about the VM categories. I had categories like "Proteine / Eiweiß" or something like "Guarana / Maca / Taurin" in my live shop. The "/" characters created the issues in the import. Par example: The liveshop categorie "Proteine / Eiweiß" - new shop: 2!!! categories like "Proteine" and "Eiweiß". I deleted all VM categories and products, changed all the categories with the "/" characters.in my live shop and tried a new import of the VM categories in my new shop after making the changes. Then I imported the products again and published them.

At the moment I can't find any issues anymore. The products are all imported into the correct categories and the categories are also shown correctly. At last I've executed the SQL order "UPDATE `xxxxx__virtuemart_medias` set `published`=1" to get published all the VM mediafiles. This works also.

I will check everything about the VM manufacturer categories, the manufacturers, the VM categories and the products. At the moment I think the import was succesfull.

If everything will be correct, after checking the imports tomorrow, the next think will be the mainmenu. Users are secondary.

I will also send the post to Roland.

Thx and have a nice day, Benny

Thx, I will send an email to him.

Hello,

menuordering field is available in import and activated but doesn't work. PLease see logfile and my further settings in the last post under.

You have the menuordering field in your template fields but it is missing in your import file. Your debug log shows only the below fields are imported

Use field value for field type

[DEBUG]	Use field value for field path

[DEBUG]	Use field value for field menutype

[DEBUG]	Use field value for field title

[DEBUG]	Use field value for field alias

[DEBUG]	Use field value for field component

[DEBUG]	Use field value for field link

[DEBUG]	Use default value for field menu-meta_description

[DEBUG]	Use default value for field menu-meta_keywords

I didn't noticed that "VM Userinfo" stands for the import. I've imported the "JOOMLA users". Now I've tried to fix it with importing the userinfo for VM, but that doesn't work either. Please see logfile.

May i know issue you are having with Users? The debug log shows the user has been processed in VirtueMart too.

One question, is it possible that you will do the imports... I really appreciate your support, but I guess it would be much easier and faster for you than for me and you illsave a lot of time... I'm really newbie in importing... I will spend a fee of course!

The imports are:

whole VM (users, categories, manufacturers and mf categories) and the Joomla menus.

Please email all your details to Roland at contact@csvimproved.com and he will get in touch with you on these imports.

Hello,

menuordering field is available in import and activated but doesn't work. PLease see logfile and my further settings in the last post under.

I didn't noticed that "VM Userinfo" stands for the import. I've imported the "JOOMLA users". Now I've tried to fix it with importing the userinfo for VM, but that doesn't work either. Please see logfile.

One question, is it possible that you will do the imports... I really appreciate your support, but I guess it would be much easier and faster for you than for me and you illsave a lot of time... I'm really newbie in importing... I will spend a fee of course!

The imports are:

whole VM (users, categories, manufacturers and mf categories) and the Joomla menus.