Import from VM2

Start
Prev
1
Next
End

Joomill
Topic Author
Offline

Posts: 221
Thank you received: 10
Hikaserial Subscription Hikashop Multisite

10 years 8 months ago #211898

-- HikaShop version -- : 2.5.0
-- Joomla version -- : 3.4.3
-- PHP version -- : 5.5
-- Browser(s) name and version -- : Firefox

Hi,

I did various imports from VM1 without any problem.
Now i tried a VM2 import and have 2 difficulties.
--Virtuemart Version: 2.6.10 --

1) When i import orders the field: address_street is empty (both billing and shipping)
This is not when i import users, only orders
The vm2 database-field is called address_1 in table _virtuemart_order_userinfos

2) All dates (orders, products etc.) are 1970-01-01 00:33
The VM2 database-field is called created_on and shows dates like 2012-06-28 18:52:2
(in VM1 it was a unix timestamp)

Can you help me to fix this?
Kind regards,
Jeroen

Last edit: 10 years 8 months ago by Joomill.

Please Log in or Create an account to join the conversation.

nicolas
Away

Posts: 85610
Thank you received: 14021
MODERATOR

10 years 8 months ago #211959

Hi,

1. The address_1 field is already used for both addresses import.
This is the code for the user addresses import:
take.ms/lhbEx
This is the code for the order addresses import:
take.ms/9MR8E
You can find that in the file administrator/components/com_hikashop/helpers/import/vm2.php
As you can see, they both handle the address_1 and even address_2 fields of VM, and they do it with the same code so I'm surprised that it would work for the user but not the order. If it was for the whole addresses, I could understand but just that field not importing would be strange.

2. That's good to know.
Here is a new version of the vm2.php file that you can replace and which will handle the dates properly.

This attachment is hidden for guests.
Please log in or register to see it.

This message has an attachment file.
Please log in or register to see it.

Last edit: 10 years 8 months ago by nicolas.

The following user(s) said Thank You: Joomill

Please Log in or Create an account to join the conversation.

Joomill
Topic Author
Offline

Posts: 221
Thank you received: 10
Hikaserial Subscription Hikashop Multisite

10 years 8 months ago #212043

Thank you so much for fixing the date-fields

I couldn't find the error for the address so i changed both lines (for user and order import) to:
'address_street' => 'vmui.address_1',

And it works now for us.
we don't use address_2 in VM, so we don't need to import it.

Please Log in or Create an account to join the conversation.