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
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 our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 21
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. # 22
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 our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 23
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. # 24
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 our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 25
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. # 26
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 our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 27
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. # 28
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 our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 29
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 our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 30
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. # 31
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 our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 32
Accepted Answer Pending Moderation
  1. more than a month ago
  2. RO CSVI
  3. # 33
Accepted Answer Pending Moderation
Hello,
Can you post the debug log of the import?
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. # 34
Accepted Answer Pending Moderation
Hello,

I've set the value to 1 into the import template, but this doesn't fix the problem, pleawse see:

Backend: https://gyazo.com/4b0fbfaae712c7fa43d68b277ce897c0
CSVI settings: https://gyazo.com/ee29e1ffd49c80325312580ee8a97472
  1. more than a month ago
  2. RO CSVI
  3. # 35
Accepted Answer Pending Moderation
Hello,
Lets us focus on one issue at a time, first lets fix the problem with product images. Your product images are not published and it is not seen on front end. I published the first image on your site and it is shows on front end In your import you can add a field media_published and set the default value to 1 to publish all your product images during import. Try and let me know if it solves this issue.
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. # 36
Accepted Answer Pending Moderation
Good morning from Germany,

in the meantime, I have all the imports tested. In the category overview, I do not see any products pictures although these are on the server. I thought first it was the attitude of the "available pieces", unfortunately this was not the case. You can see it here: http://new3.beast-supplements.de/index.php/shop/arginin

Then I've tried to import the menus, there I got several issues with ordering and links...

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

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

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

A lot more things to dol, bute hope we will get it fixed :-)
Have nice start into the week, best wishes.
Attachments (2)
  1. more than a month ago
  2. RO CSVI
  3. # 37
Accepted Answer Pending Moderation
  1. more than a month ago
  2. RO CSVI
  3. # 38
Accepted Answer Pending Moderation
Thank you so much, Glad to know that your issues are all solved :)
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. # 39
Accepted Answer Pending Moderation
Thx, this was helpful. Now currencies are in the new shop.

I have downloaded the images from the live shop and uploaded them into the new, thaught perhaps there has been an issue in the last upload. All files have been allready uploaded successfully. The problems was the layout view.... 30 products = NO IMAGES ...lol 15 are working!

https://gyazo.com/f8298634693c7fac2524c7fc37a4875c

So I think: WE GOT IT! I will now look around for any issues and get back to you on monday. Thx a lot for your help. I will write a review!
  1. more than a month ago
  2. RO CSVI
  3. # 40


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