No import from Virtuemart 1.1.9

-- HikaShop version -- : 2.2.3 Business
-- Joomla version -- : 1.5.26
-- PHP version -- : 5.3.21

Hi,
At last I was ready to import my Virtuemart 1.1.9 data into Hikashop 2.2.3 on my Joomla 1.5 website.
But to my disappointment it did not work.
In Step 1 Initializing tables I got the message: All table created
But after clicking on Next nothing happens at all! I'm just staying on the same screen.
I've tried several times, with the same sad result.

Before I have imported all Virtuemart data into Hikashop 2.2.1 on a copy of the website on my computer. This worked perfect!

Please advise!

regards,
Udo

Hi Udo,
Can you download the last Hikashop version (2.3.0) through our website, install it and test it again ? Also note that you should probably update your Joomla 1.5 version.
Thanks .

Thanks, I've updated to version 2.3.0 and now the Virtuemart import went well!

With an exception: during the import of orders and customers it seems like some data is lost. I still have to look into the details but i see the orders are not connected to the customers (when looking at a customer you don't see his orders). Moreover the order numbers were replaced by some arbitrary code (this did not happen when I uses Hikashop 2.2.1), Sometimes names and e-mail addresses are lost in the order data.

Is there a way to repair this?

By the way: updating the Joomla 1.5 version is not possible since 1.5.26 is the last version.

Udo

Ok, so can you please :
- Active the Joomla debug mode ("Administration->Global configuration->System->Debug System/Language")
- Set the "error reporting" option of the Joomla configuration to "maximum"
- Test it again so that we can see if it display an error message.

Hi Mohamed,

What do you mean by "Test it again"?
I've already imported all Virtuemart data.
Do I have to clear all orders and customers first?

I also note that often orders are connected to a wrong customer.
Order numbers look like this: 241_c6771ff3de488e52a031c29bb58a
For your information: in my previous message I wrote this problem didnot happen on my local testsite using Hikashop 2.2.1. At that time I used Hikashop Essential. Now I'm using Business.

Moreover (but this may be another problem): the data filtering of the orders dysfunctions!
When selecting a From or To date (by typing or by clicking the calendar) the date jumps to 1970-01-01. This can only be restored by logging out.

regards,
Udo

Hi Udo,

Clearing the orders and customers is indeed a solution.
We just need to see if there are any error during the import.

Do you see any logic in the order number? Is it comming from another element?
About the fitler, it works on our end, which browser are you using?

Hi,

Clearing the orders and customers didnot work.
I tried to do it on the local copy of my site. I deleted all orders and tried to import them again. But the Virtuemart Import didnot see new orders.
After that I tried to delete the customers too, but the system said: "can't delete the users because orders are attached to them." And indeed they are. Deleting the order listing wasn't enough. Deleting orders per customer would take too much time, having 2000 customers...

I found out there is some logic in the new order number.
Order numbers are for example: 241_c6771ff3de488e52a031c29bb58a and 927_5b3a238cdc289f550b0f18681fe2
* The series after _ are probable random
* The number before _ is the user id in Virtuemart/Joomla (for instance 1073)
* Very important: the user id in Hikashop is DIFFERENT from this user id in Virtuemart and Joomla!
* The customers new user id in Hikashop is 927. The orders attached to him in Hikashop are the orders starting with 927_.
* But this are not his orders! His order numbers in Hikashop start with 1073_. His orders are attached to someone else, the customer who was given user id 1073 by Hikashop.
It's rather confusing.

Also there are negative order numbers, like -1121_3f916b66274ff9a8de7c5a7af0
This are orders from customers who are not registrated (customers can choose if they want to registrate).
In those orders the user information, in particular the email adress of the customer, is lost.

This is the most confusing support ticket I've ever posted...
I hope you can help.

About the date filtering of the orders:
I'm using Firefox 27.0.1 but in Chrome the problem is the same. And when using the backend of the demo website in Firefox the date filtering works fine. So the browsers is no causing the problem.

regards,
Udo



241

Hi,

Didn't you notice my previous message?

I found a way to empty all orders and users: truncate the user, order and order_product tables in the dbase.
I've done this on my testwebsite.
After reimporting the orders and users from Virtuemart the users and orders have the same problems as before on the live site!
The debug mode and maximum error reporting were on..
But no error was reported.

Like I wrote before importing users and orders went smoothly in Hikashop 2.2.1
It seems like something is wrong in Hikashop 2.3.0 !

regards,
Udo

Hi Jerome,

That's very good news!
Is the order number okay too?

To check if I've understood this correct:
:
1- You suggest to truncate the user, order and product_order tables in the dbase, and to import these data once more from Virtuemart into Hikashop.
If this is what I should do, I can do it myself.

2- The patch is integrated into new downloads of Hikashop 2.3.0, isn't it.

The Virtuemart import of products, categories, images is okay and I've already edited them, so these data should not get lost.

Thanks, have a nice sunny Sunday like we have in Amsterdam right now,

Udo

Hi,

I've imported the users and orders once more and now the orders are connected to the correct customer. Hurray!
Also I successfully modified the display of the order_number in the dbase according to your instructions.

About this display of the order number: I never modified the way Virtuemart displays these numbers.
And after importing Virtuemart in Hikashop 2.2.1 Starter on a local testwebsite there was no problem with the order numbers.
So still it's possible that Hikashop 2.3.0 is causing this display problem.
Anyway, my problem is solved. When the Hikashop webshop is live I 'll import the newest Virtuemart orders and will have to modify the dbase again.

One more question. It's about users who are not registered.
In the order list the e-mailaddress of a non-registered user is not shown in his order.
In the user list the name of the non-registered user is not shown, but his e-mailaddress is.
But now I can't say which e-mail address belongs to which user. (unless he uses his name in the e-mailadress).

Is this the way Hikashop treats non-registered users? Or is someting still missing in my Virtuemart import?

regards,
Udo

Hi,

I'm not sure if you noticed my remarks about another problem with the Virtuemart import.
It's about customers who are not registered.

In the order list the id and e-mailaddress of a non-registered customer are not shown in his order.
This is not like it should be. I've tested it in your demo website and then the id and e-mailaddress are listed.

In the customer list the name of the non-registered customer is not shown, but his e-mailaddress is.
The same happens in the demo website, so this seems to be correct.
But now I can't say which e-mail address belongs to which customer.

When I imported Virtumart into my testwebsite using Hikashop Starter 2.2.1 this problem did not exist.

Please advise.

Thanks,
Udo

Hi,
Attached are some screen shots about the way non-registered customers are shown (anonymised).

* screen1 shows the order list (missing: no name of the non-registered customers)
* screen2 shows the order details of a non-registered customer (missing: mail address, id)
* screen3 shows the user details after clicking in the order list (missing: name, mail address, order)
* screen4 shows the user list, selecting only this user (missing: name)
* screen5 shows the user details after clicking in the user list (missing: name, order)

I hope this information makes clear what's going on.

regards,
Udo

Your help will be most welcome.

UPDATE MAY 20 2014
There is no perfect solution, it appears. Apparently import from Virtuemart is quite complicated.
It strikes me that there was a logic in the errors:
* in all recently imported customer accounts (2 months) only street and house number are missing
* in all customer accounts from 2 months ago untill 16 months ago the entire address is missing
* in all customer accounts older then 16 months ago a wrong address is shown. It's the address of another customer.

Meanwhile I have made some corrections and the result is workable.
The migration from Virtuemart to Hikashop is completed and I'm very glad with the result.

Thanks for the support.

Udo