old user import need advice
Lisa
New Member
Posts: 2
pred 7 rokmi 9 mesiacmi - pred 7 rokmi 9 mesiacmi #1473
od Lisa
old user import need advice bolo vytvorené Lisa
Doing a site update for a client. Old hand coded site has two tables of users with extensive history in linked tables. I need to keep these thousands of historical records linked to their users by the id numbers.
I've got all the data in my component. But now I want to import these users into Joomla and link the joomla user ID to the extended information in the two radically different tables.
Those in table A will have a different ACL than those in table B.
Table A has user IDs 1-9000, Table B has different users, IDs 1-18000.
So I need new users in the system 1-27000 linked to the right users in the right tables, but somehow keeping the relationship with data in the history tables.
I know I need to update more than joomla user table, but not sure which others?
And I have no idea how to proceed.
I'm just wondering if anyone with more experience has a suggestion on how to handle this?
I've got all the data in my component. But now I want to import these users into Joomla and link the joomla user ID to the extended information in the two radically different tables.
Those in table A will have a different ACL than those in table B.
Table A has user IDs 1-9000, Table B has different users, IDs 1-18000.
So I need new users in the system 1-27000 linked to the right users in the right tables, but somehow keeping the relationship with data in the history tables.
I know I need to update more than joomla user table, but not sure which others?
And I have no idea how to proceed.
I'm just wondering if anyone with more experience has a suggestion on how to handle this?
Posledný krát upravené:pred 7 rokmi 9 mesiacmi Lisa Dôvod: fix typo
Prosím Prihlásiť alebo Registrácia pre zdieľanie konverzácie.
Victor
Administrator
Posts: 19
pred 7 rokmi 9 mesiacmi #1475
od Victor
Back-end developer on Component Creator
Odpoveď od Victor na tému old user import need advice
Hi Lisa,
I'm Victor, Lead developer of Component Creator and this enquiry has been escalated to me. I'm afraid that you have a tricky task in your hands and there is not an easy solution for this.
What I would suggest is to try to create a table that try to cover as much as possible the historic table of both Table A and Table B. Once you have this, migrate the users and their data from Table A and then migrate Table B and their data changing the references using the new identifier in Joomla! users table.
This is out of Component Creator, even our of our Premium support because this problem is caused by an overcomplicated database design process but I just wanted to throw some light to your problem.
Regards,
Víctor
I'm Victor, Lead developer of Component Creator and this enquiry has been escalated to me. I'm afraid that you have a tricky task in your hands and there is not an easy solution for this.
What I would suggest is to try to create a table that try to cover as much as possible the historic table of both Table A and Table B. Once you have this, migrate the users and their data from Table A and then migrate Table B and their data changing the references using the new identifier in Joomla! users table.
This is out of Component Creator, even our of our Premium support because this problem is caused by an overcomplicated database design process but I just wanted to throw some light to your problem.
Regards,
Víctor
Back-end developer on Component Creator
Prosím Prihlásiť alebo Registrácia pre zdieľanie konverzácie.
Lisa
New Member
Posts: 2
pred 7 rokmi 9 mesiacmi #1478
od Lisa
Odpoveď od Lisa na tému old user import need advice
Thanks, Victor!
I know it is outside of your component -- hence my request for advice in the forum rather than support. (grin) I'm confident the database will be much simpler when I'm done!!! I figured someone else in this group of folks might have encountered or might encounter this in future.
When someone has over-designed a database, that's when we get called in to fix it, right?
Thanks for the advice. I do appreciate it.
I think I've got a solution. Using the user set with the least amount of additional linking tables, I'm going to adjust their user id to current id + (# greater than other table highest id value) and then do the same in each of the related fields. This should keep the relationships intact while allowing me to combine Tables A and B. Then I just have to import them into the affected Joomla tables...
I know it is outside of your component -- hence my request for advice in the forum rather than support. (grin) I'm confident the database will be much simpler when I'm done!!! I figured someone else in this group of folks might have encountered or might encounter this in future.
When someone has over-designed a database, that's when we get called in to fix it, right?
Thanks for the advice. I do appreciate it.
I think I've got a solution. Using the user set with the least amount of additional linking tables, I'm going to adjust their user id to current id + (# greater than other table highest id value) and then do the same in each of the related fields. This should keep the relationships intact while allowing me to combine Tables A and B. Then I just have to import them into the affected Joomla tables...
Prosím Prihlásiť alebo Registrácia pre zdieľanie konverzácie.
Emmanuel Tsalampounis
Návštevník
pred 3 rokmi 7 mesiacmi #9842
od Emmanuel Tsalampounis
Odpoveď od Emmanuel Tsalampounis na tému old user import need advice
Hello Lisa,
We have to review your database to find the best way to proceed. It will be a custom development task, you could contact us here if you want: www.component-creator.com/en/help/contact
We have to review your database to find the best way to proceed. It will be a custom development task, you could contact us here if you want: www.component-creator.com/en/help/contact
Prosím Prihlásiť alebo Registrácia pre zdieľanie konverzácie.
Čas vytvorenia stránky: 0.056 sekúnd