Interesting...

Post edited by: crony, at: 2009/10/04 01:05

I forgot the VM integration plugin that seems to generate the random into VM...

So you where right, I need to check the SQL actions further with provided example...
Thanks !

ok, I'm checking with sql actions...

Post edited by: crony, at: 2009/10/04 17:30

This query thru SQL action does not update anything into VM table:

[code:1]UPDATE `#__vm_user_info` SET `address_type` = 'BT', `address_type_name` = '-default-', `last_name` = '[last_name]', `first_name` = '[first_name]', `phone_1` = '[cb_telephone]', `address_1` = '[cb_addresse]', `city` = '[cb_ville]', `state` = '-', `country` = 'FRA' , `zip` = '[cb_codepostal]' WHERE `user_id` = [user_id][/code:1]

Why ?

I also tried "CREATE into" as it's a new entry into the table...Same...
Tested thru phpmyadmin with a fixed user_id, seems alright...

Post edited by: crony, at: 2009/10/04 19:15

I think the reason it is not working is because you have not created the user in the vm user_info table. You need to make sure that the vm integration is used first to create this row in the table (jos_vm_user_info) after this occurs (doesn't have to be a special user group, default will create the row as well) then you will be able to update the table with the cb.user_id = vm.user_id.

I know this works because I have the same setup...

if you want to try it, I have created a module which you just install like any other and enable it, which will copy the following fields from CB to VM.

firstname
lastname
company
address
city
state
country
zip
phone
fax
and email