1. Chigolo
  2. RO CSVI
  3. Wednesday, 23 November 2016
  4.  Subscribe via email
Hi guys,

I wanted to export my Joomla content, especially this fields: https://gyazo.com/d3912a26e5b8965a9510873bdd9cc077 the file was exported with NO addition, so I added ".csv" by myself after the export. As I imported the file, the artciles were looking like this: https://gyazo.com/06465cdbdcc5499292c78c18701bf1b9.

I am newbie. I want to export and import all Joomla menus, categories and articles, after that Virtuemart...

Can you please help me? I have read the tutorials, but I can't find the issue.

Thx, B.
Accepted Answer Pending Moderation
  1. more than a month ago
  2. RO CSVI
  3. # 61
Accepted Answer Pending Moderation
Hello,
In your template settings, on file tab you have set Use file for configuration: Yes, this option will read the headers from your import file and so media_published did not work. You either need to add media_published field in your import file or set Use file for configuration to No so CSVI reads headers from your template fields.
Kind regards,

Tharuna

=========================
If you use CSVI, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 62
Accepted Answer Pending Moderation
Allright, I have tried to set the config to "no", but this doesn't work, cause everything is changed then... https://gyazo.com/27ec8629312d92c2a3a4937758c2021d I have deleted all products.
Next try: I have then added the feld: media_published without any values to the import file, and also tried with value 1 (in both templates: export & import). The import wasn't succesfull. Is there a chance to fix the media_published field after importing the files? I saw the media files aren't published in manufacturers and the vm categories, too. Or do i have to import them again?

here are thw two logfiles (online in 2 minutes!!):
http://www.beast-supplements.de/com_csvi.log.104.txt
http://www.beast-supplements.de/com_csvi.log.105.txt
  1. more than a month ago
  2. RO CSVI
  3. # 63
Accepted Answer Pending Moderation
Hello,
There is one simple solution, if you know how to do, go to your phpmyadmin >> select your database >> look for #__virtuemart_medias table >> on SQL tab paste the query below and click Go. Dont forget to replace #_ with your table prefix in the query. This query will publish all the images of products, manufacturer and category.

UPDATE `#__virtuemart_medias` set `published`=1
Kind regards,

Tharuna

=========================
If you use CSVI, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 64
Accepted Answer Pending Moderation
Hello,
Forgot to mention in my previous reply that you don't have to import your manufacturer or categories again as with this solution you are trying to update publish field directly in your database. Hope it is clear.
Kind regards,

Tharuna

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

this would be the best solution. I've asked my hoster, I'm getting error message: https://gyazo.com/1e6d2622974fc14aa772d5e88e1d842d

I'll be back soon! Thx for helping!
  1. more than a month ago
  2. RO CSVI
  3. # 66
Accepted Answer Pending Moderation
Hello,
You shouldn't be having the 'SELECT * FROM s4z67_virtuemart_medias WHERE 1' statement above the 'UPDATE s4z67_virtuemart_medias set published=1' statement. Please remove that and run only the query i sent above and click on Go.
Kind regards,

Tharuna

=========================
If you use CSVI, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 67
Accepted Answer Pending Moderation
Thx! Done and working (products, manufacturers and vm categories). This solution was great! I only can i say: Your support ist best ever. Hope you've read my review.

Nest stops:

[color=red]Then I've tried to import the menus, there I got several issues with ordering and links...

Please see:
live shop: http://gyazo.com/5944a945ff27a178e9f75f4570be5dc3 (correct VM category link)
correct ordering http://gyazo.com/9c0510a178dea01faac4c2de9463f06d

nerw shop:link http://gyazo.com/a18003d7b126a4b1ee6815f43c199aa8 ("Weight Gainer" is wrong, it's in every case)
wrong ordering: http://gyazo.com/366bec4a65b1136521fc31492267240b

And then finally I can't import any VM users...[/color]
  1. more than a month ago
  2. RO CSVI
  3. # 68
Accepted Answer Pending Moderation
Hello,
To order your menu you need to have menuordering field in your import file. Try import adding this field and if you have any issues post the debug log and import file to check.

And then finally I can't import any VM users...

Post me the debug log and sample import file to check.
Kind regards,

Tharuna

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

menueordering field was still available in the import file, I have added the file and log, also from the user import (I wanted to have all VM user fields!). User import doesn't generate a logfile... please see: https://gyazo.com/8e5cea031495e65b10415b8873a4fd01

I have also discovered an issue in the VM category import... The maincategories don't have any products in it and were getting "switched"... Live shop: "Protein/Eiweiß"
https://gyazo.com/77529f6e3ca5662be00c24cd12254b9f#

new one "Protein" & Eiweiß" as an own category
https://gyazo.com/9a464e56ddf16049c6b847d7a11caeae
https://gyazo.com/aff402dd9ee5b36606260f7b7c86f3ec

This happend also by "Triblus/Maca" and others... Is the error caused by the "/"character? I could rename the categories in the live shop if needed.
Attachments (3)
  1. more than a month ago
  2. RO CSVI
  3. # 70
Accepted Answer Pending Moderation
Hello,
Can we go through one issue at a time? This way we solve all issues without any confusion.

menueordering field was still available in the import file,

I dont see menuordering field in your import file you have attached.

I have added the file and log, also from the user import (I wanted to have all VM user fields!).

The Joomla-Users.csv file you have attached has no data in it. It just says "No data has been found for the selections made". Make sure that you export the users from your live site without any filters set for your user export template.

User import doesn't generate a logfile... please see: http://gyazo.com/8e5cea031495e65b10415b8873a4fd01

Please check Where to get the debug information? section on top of this page to know on how to get the debug log.
Kind regards,

Tharuna

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

sure! Ok so this are the settings in the live shop: https://gyazo.com/8566944966e9cf6dde2288c1a638d40d and this in the new one: https://gyazo.com/a242126d02990a3a048331cf8ffbe282. Menuordering field ist available.

I have the changed the logifle of the user import to "enabled" now. Again export and import- result: It's funny, now the import worked... lol
I can see the users in Joomla now, but the fields here are missing: https://gyazo.com/a5f3f308be6f48b0fb26c09e620d473a adress and so on...

I didn't find how to import the users as "VM users"
Attachments (2)
  1. more than a month ago
  2. RO CSVI
  3. # 72
Accepted Answer Pending Moderation
Hello,
sure! Ok so this are the settings in the live shop: http://gyazo.com/8566944966e9cf6dde2288c1a638d40d and this in the new one: http://gyazo.com/a242126d02990a3a048331cf8ffbe282 . Menuordering field ist available.

menuordering field is supported only for import and not in export. If you don't see this field in import update your available fields and check.

I have the changed the logifle of the user import to "enabled" now. Again export and import- result: It's funny, now the import worked... lol
I can see the users in Joomla now, but the fields here are missing: http://gyazo.com/a5f3f308be6f48b0fb26c09e620d473a adress and so on...

Please check the import VirtueMart users document. You are missing the address data fields in your import file and so these fields are not there in your VirtueMart.
Kind regards,

Tharuna

=========================
If you use CSVI, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 73
Accepted Answer Pending Moderation
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.
Attachments (2)
  1. more than a month ago
  2. RO CSVI
  3. # 74
Accepted Answer Pending Moderation
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.
Kind regards,

Tharuna

=========================
If you use CSVI, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 75
Accepted Answer Pending Moderation
Thx, I will send an email to him.
  1. more than a month ago
  2. RO CSVI
  3. # 76
Accepted Answer Pending Moderation
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
  1. more than a month ago
  2. RO CSVI
  3. # 77
Accepted Answer Pending Moderation
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.
Attachments (2)
  1. more than a month ago
  2. RO CSVI
  3. # 78
Accepted Answer Pending Moderation
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.
Kind regards,

Tharuna

=========================
If you use CSVI, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 79
Accepted Answer Pending Moderation
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
Attachments (2)
  1. more than a month ago
  2. RO CSVI
  3. # 80


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