Can I do this query in an autoaction - query type to copy a cell number from CB to Acymailing:
Code:
UPDATE xxx_acymailing_subscriber
INNER JOIN xxx_comprofiler ON (xxx_acymailing_subscriber.cell = xxx_comprofiler.cb_cell)
SET xxx_acymailing_subscriber.userid = [user_id]
Best regards
Fribse
Frømandsklubben Nikon,
www.nikondyk.dk
We're a volunteer driven diving club in Ishøj, Denmark.
Har du brug for en dykkerklub der rummer alle, så kom ned til os.
You didn't specify what trigger you intend to use so I'm not sure what your intended usage is. An example below can be used on the after registration and after profile update triggers to copy over when registering or saving profile.
Code:
UPDATE `#__acymailing_subscriber`
SET `cell` = '[cb_cell]'
WHERE `userid` = '[user_id]'
Please note the above is just an example. Be sure to test thoroughly. To do an initial move from CB to AcyMailing on mass scale I suggest running a query directly through phpmyadmin. The below for example should do this ok.
Code:
UPDATE `jos_acymailing_subscriber` AS a
, `jos_comprofilerr` AS b
SET a.`cell` = b.`cb_cell`
WHERE a.`userid` = b.`user_id`
Please note the above is also just an example. If your table prefix isn't jos_ then be sure to replace it with the correct prefix.
Kyle (Krileon) Community Builder Team Member Before posting on forums:
Read FAQ thoroughly
+
Read our Documentation
+
Search the forums CB links:
Documentation
-
Localization
-
CB Quickstart
-
CB Paid Subscriptions
-
Add-Ons
-
Forge
-- If you are a Professional, Developer, or CB Paid Subscriptions subscriber and have a support issue please always post in your respective support forums for best results!
-- If I've missed your support post with a delay of 3 days or greater and are a Professional, Developer, or CBSubs subscriber please
send me a private message
with your thread and will reply when possible!
-- Please note I am available Monday - Friday from 8:00 AM CST to 4:00 PM CST. I am away on weekends (Saturday and Sunday) and if I've missed your post on or before a weekend after business hours please wait for the next following business day (Monday) and will get to your issue as soon as possible, thank you.
-- My role here is to provide guidance and assistance. I cannot provide custom code for each custom requirement. Please do not inquire me about custom development.
I see, thanks!
I seem to have a working test setup now.
Best regards
Fribse
Frømandsklubben Nikon,
www.nikondyk.dk
We're a volunteer driven diving club in Ishøj, Denmark.
Har du brug for en dykkerklub der rummer alle, så kom ned til os.
The following user(s) said Thank You: nant, krileon
krileon
