How to import/export members from/to another system?
I have watched the video tutorials on Members and Login, they seem great!
Now, we have our members stored somewhere else on another system. I can write the C# code that reads those members, but how would I then put these members into Umbraco?
I am not sure what I should be looking at or searching for... could anyone point me to the right direction?
There are many other things I need to import from various (messy) sources to Umbraco and I will need to do some manipulations to the data (using C#) before inserting them into the web database (or Umbraco).
But thanks anyway! Would you know how to do it in C# by any chance?
I would go with Anders suggestion(I Build CMSImport so it's not an objective answer). Makes sure you export the data to a single not so messy format and then use CMSImport to import it into Umbraco. Magic will happen :-).
I would go with Anders suggestion(I Build CMSImport so it's not an objective answer). Makes sure you export the data to a single not so messy format and then use CMSImport to import it into Umbraco. Magic will happen :-).
Now I'm confused. I was assuming you had an Sql database where you have some members that you want to import into Umbraco, is that assumption right?
If so then you can export that data into a file and you can use CMSImport to import those members. Don't have to use it but then you will need to use the Membership API to import those members. Work that CMSImport already done for you.
What do you mean with Manipulate Umbraco database when a sale happens? With Umbraco you never have to manipulate the database since everything is accessed via an API.
Hardi, do you mean you want to export data back out from Umbraco afterwards? You can do this relatively easily using the Membership API unless CMS Import also does that. As Richard states, you can do the import manually using the API however CMS Import is such a great tool at an affordable price it should pay for itself.
If you want to export members as Simon says you can use MemberExport (http://our.umbraco.org/projects/website-utilities/memberexport ) also. Both tools are free if you don't have that much members.
Sorry to confuse you guys. I am actually confused because I've always been developing both the code and the database. And I am always free to do anything I want with the database. But with Umbraco... alright I think I know what I want, these Umbraco APIs, where can I find information about that? Thanks guys!
How to import/export members from/to another system?
I have watched the video tutorials on Members and Login, they seem great!
Now, we have our members stored somewhere else on another system. I can write the C# code that reads those members, but how would I then put these members into Umbraco?
I am not sure what I should be looking at or searching for... could anyone point me to the right direction?
Thanks in advance.
Hi Hardi
You can use the great package CMSImport to to that.
http://www.cmsimport.com/
That doesn't look like what I need.
There are many other things I need to import from various (messy) sources to Umbraco and I will need to do some manipulations to the data (using C#) before inserting them into the web database (or Umbraco).
But thanks anyway! Would you know how to do it in C# by any chance?
I could use C# to extract the member data and manipulate it and save it to a CVS file and then use CMSImport to import the data?
Hi,
I would go with Anders suggestion(I Build CMSImport so it's not an objective answer). Makes sure you export the data to a single not so messy format and then use CMSImport to import it into Umbraco. Magic will happen :-).
Cheers,
Richard
Hi,
I would go with Anders suggestion(I Build CMSImport so it's not an objective answer). Makes sure you export the data to a single not so messy format and then use CMSImport to import it into Umbraco. Magic will happen :-).
Cheers,
Richard
Thanks guys! Then how do you extract or manipulate the Umbraco database? (eg. when a sale happens)
I wonder why you have to use CmsImport. Is the database too complex?
Now I'm confused. I was assuming you had an Sql database where you have some members that you want to import into Umbraco, is that assumption right?
If so then you can export that data into a file and you can use CMSImport to import those members. Don't have to use it but then you will need to use the Membership API to import those members. Work that CMSImport already done for you.
What do you mean with Manipulate Umbraco database when a sale happens? With Umbraco you never have to manipulate the database since everything is accessed via an API.
Hope to hear from you.
Hardi, do you mean you want to export data back out from Umbraco afterwards? You can do this relatively easily using the Membership API unless CMS Import also does that. As Richard states, you can do the import manually using the API however CMS Import is such a great tool at an affordable price it should pay for itself.
Simon
If you want to export members as Simon says you can use MemberExport (http://our.umbraco.org/projects/website-utilities/memberexport ) also. Both tools are free if you don't have that much members.
Richard
Sorry to confuse you guys. I am actually confused because I've always been developing both the code and the database. And I am always free to do anything I want with the database. But with Umbraco... alright I think I know what I want, these Umbraco APIs, where can I find information about that? Thanks guys!
is working on a reply...