Home
Suggestions and new ideas
General User-Sync-Tool
4 years ago submited by Julian Wolf
General User-Sync-Tool
Here is another Feature-Request, that will be a challenge, but a great one. A general User-Sync-Tool that works togehter with different systems. New Systems should be able to be created manualy or as an "upload".
The sync-tool connects with the user-databases of the most common systems: Joomla, Typo3, vBulletin, phpBB2, XTC, OS-Commerce and so on.
Using the sync-Tool every user in the "outside"-system (for example vBulletin) can create his PAP-Account with just one mouse-klick. All data including the password and so on is transfered to PAP and only the data, which is mandatory in PAP but not present in the "outside"-system, should be asked for. The other data should be shown, but not changable.
Now as the user is there on bouth sides, it should be marked as "joint" or "synced" or something like that. Every change, that the user makes in one of the systems, should be done in the other system also.
To keep it easier: When all the data, which is in bouth systems, is blocked in pap, he only can change his data in the outside-system. Let´s say we take vBulletin: The adress is present in vBulletin, but not the paypal-eMail. So when the user joins pap with this klick, the adress is transfered while the paypal-eMail is asked for.
When he later goes on "change user-data" in PAP, the adress-fields are blocked. When he wants to change them, he has to go to the original system.
A little button could be for "quit connection", when he klicks that bouth accounts are "free" again and he can change everything.
So each time when data from this user is needet, pap asks in the "outside-database" if there are any changes. The data does not even need to be saved in pap, becuase it should always come from outside. This covers every change in the outside-system.
There are a lot of benefits for this connection. But sure, every other system must be "hand-integrated". If you provide us with a module, that builts the framework for this integration, I am sure that you will find a lot of forum-posts with templates to integrate all the common systems. Wouldn´t that be a great step?
Best wishes, Ju lian!
The sync-tool connects with the user-databases of the most common systems: Joomla, Typo3, vBulletin, phpBB2, XTC, OS-Commerce and so on.
Using the sync-Tool every user in the "outside"-system (for example vBulletin) can create his PAP-Account with just one mouse-klick. All data including the password and so on is transfered to PAP and only the data, which is mandatory in PAP but not present in the "outside"-system, should be asked for. The other data should be shown, but not changable.
Now as the user is there on bouth sides, it should be marked as "joint" or "synced" or something like that. Every change, that the user makes in one of the systems, should be done in the other system also.
To keep it easier: When all the data, which is in bouth systems, is blocked in pap, he only can change his data in the outside-system. Let´s say we take vBulletin: The adress is present in vBulletin, but not the paypal-eMail. So when the user joins pap with this klick, the adress is transfered while the paypal-eMail is asked for.
When he later goes on "change user-data" in PAP, the adress-fields are blocked. When he wants to change them, he has to go to the original system.
A little button could be for "quit connection", when he klicks that bouth accounts are "free" again and he can change everything.
So each time when data from this user is needet, pap asks in the "outside-database" if there are any changes. The data does not even need to be saved in pap, becuase it should always come from outside. This covers every change in the outside-system.
There are a lot of benefits for this connection. But sure, every other system must be "hand-integrated". If you provide us with a module, that builts the framework for this integration, I am sure that you will find a lot of forum-posts with templates to integrate all the common systems. Wouldn´t that be a great step?
Best wishes, Ju lian!
oemPro (and other software)
4 years ago Alan Tutt
oemPro (and other software) has a feature that may be exactly what you're looking for.
What they do is to allow the administrator to define the database structure and access codes of the outside system (CMS, blog, forum, shopping cart, etc) and you can set the software to automatically read the user data in the outside system and use it as if it were internal data.
For example, if PAP had this ability, I could define the user table structure in my shopping cart, and PAP would be able to automatically set up affiliate accounts for all my customers. With more flexibility, I would even be able to define conditions those customers must meet before being granted an affiliate account.
For the greatest flexibility, PAP would need to allow the administrator to define a custom SQL query for the integration. Of course, this would not be appropriate for non-technical users, so some GUI to help define a workable query would also be needed.
The beauty of this is that there is no "hand integration" needed. The outside system never needs to know what is happening, as PAP would read the updated database info automatically when required.
__________________
- Alan Tutt
What they do is to allow the administrator to define the database structure and access codes of the outside system (CMS, blog, forum, shopping cart, etc) and you can set the software to automatically read the user data in the outside system and use it as if it were internal data.
For example, if PAP had this ability, I could define the user table structure in my shopping cart, and PAP would be able to automatically set up affiliate accounts for all my customers. With more flexibility, I would even be able to define conditions those customers must meet before being granted an affiliate account.
For the greatest flexibility, PAP would need to allow the administrator to define a custom SQL query for the integration. Of course, this would not be appropriate for non-technical users, so some GUI to help define a workable query would also be needed.
The beauty of this is that there is no "hand integration" needed. The outside system never needs to know what is happening, as PAP would read the updated database info automatically when required.
__________________
- Alan Tutt