Transfer civiCRM users' addresses??

  • Joe Bedford
  • Topic Author
  • Offline
  • New Member
  • New Member
More
7 years 3 months ago - 7 years 3 months ago #90844 by Joe Bedford
Transfer civiCRM users' addresses?? was created by Joe Bedford
When I used the tool to transfer joomla users, the accounts transferred but addresses associated with those accounts did NOT transfer. Is that the way it's supposed to work or is there a bug?

Also, if someone creates a new account in eShop, is it possible to automatically propagate that to joomla?

Thanks, Joe
Last edit: 7 years 3 months ago by Joe Bedford. Reason: changed title from joomla to civiCRM

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

More
7 years 3 months ago #90907 by Jack Battersby
Replied by Jack Battersby on topic Transfer joomla users' addresses??
Joe, I am new to eshop and setting up my store now, but I think the plugin you are looking for is here.

eshopdocs.joomservices.com/plugins-and-t...ns/eshop-user-plugin

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

  • Joe Bedford
  • Topic Author
  • Offline
  • New Member
  • New Member
More
7 years 3 months ago #90931 by Joe Bedford
Replied by Joe Bedford on topic Transfer joomla users' addresses??
Thanks. I'm very new too.

That plugin is installed and enabled. The thing I was talking about is the Tool that transfers pre-existing joomla users doesn't transfer address information. I'll test to see if a new user's address information gets transferred.

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

  • Joe Bedford
  • Topic Author
  • Offline
  • New Member
  • New Member
More
7 years 3 months ago - 7 years 3 months ago #90983 by Joe Bedford
Replied by Joe Bedford on topic Transfer joomla users' addresses??
I think I've figured out what's happening: joomla doesn't store users' addresses. We're running civiCRM. A user creates an account in joomla then when s/he enters an address, it's going into civiCRM.

I need to figure out how to get address information to/from civiCRM / eShop. I've changed the title of the thread to reflect my new understanding.
Last edit: 7 years 3 months ago by Joe Bedford.

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

More
7 years 3 months ago #90984 by Jack Battersby
Replied by Jack Battersby on topic Transfer civiCRM users' addresses??
You can do it with php my admin if you know how. Just export both tables, reconcile them to a clean list and reimport them.

You can dupe the database for testing.

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

  • Joe Bedford
  • Topic Author
  • Offline
  • New Member
  • New Member
More
7 years 3 months ago #91016 by Joe Bedford
Replied by Joe Bedford on topic Transfer civiCRM users' addresses??
I can export the tables but I don't see how to import them. Do you have php code for that?

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

  • Giang Dinh Truong
  • Offline
  • Administrator
  • Administrator
More
7 years 3 months ago #91231 by Giang Dinh Truong
Replied by Giang Dinh Truong on topic Transfer civiCRM users' addresses??
Dear all,

I am sorry but EShop does not have the feature to integrate with CiviCRM system so you can not migrate the user's address from CiviCRM to EShop.

Sincerely, Giang

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

  • Joe Bedford
  • Topic Author
  • Offline
  • New Member
  • New Member
More
7 years 3 months ago #91273 by Joe Bedford
Replied by Joe Bedford on topic Transfer civiCRM users' addresses??
Where are the user tables located for eShop? I'd like to see if I can figure out a way to get the civiCRM data into them.

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

  • Giang Dinh Truong
  • Offline
  • Administrator
  • Administrator
More
7 years 3 months ago #91355 by Giang Dinh Truong
Replied by Giang Dinh Truong on topic Transfer civiCRM users' addresses??
Hello Joe,

They are #__eshop_customers and #__eshop_addresses table.

Hope that this is useful.
Sincerely, Giang

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

Moderators: Giang Dinh Truong