Import from VM2

  • Posts: 206
  • Thank you received: 10
  • Hikashop Multisite
9 years 3 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: 9 years 3 months ago by Joomill.

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

  • Posts: 82863
  • Thank you received: 13372
  • MODERATOR
9 years 3 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.

File Attachment:

File Name: vm2.zip
File Size:12 KB

Attachments:
Last edit: 9 years 3 months ago by nicolas.
The following user(s) said Thank You: Joomill

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

  • Posts: 206
  • Thank you received: 10
  • Hikashop Multisite
9 years 3 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.

  • Posts: 82863
  • Thank you received: 13372
  • MODERATOR
9 years 3 months ago #212054

Hi,

Thank you for your feedback. We'll add the fix to the dates import with the next release of HikaShop.

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

Time to create page: 0.061 seconds
Powered by Kunena Forum