TeamDesk Knowledge Base & Support

   Home      FAQ      Forum      Idea Exchange      Ask a Question      My Stuff      Help   
  
Exporting of column Information
Scenario.....
We have multiple databases that are identical but used by different clients. we love the development branch for creating new functions and releasing to our clients. but from a standpoint of developing it would be great if we had the ability to export the development changes and then import those into our other databases. Example out latest update we added over 60 columns that we have to manually create in each database(currently at 18) this is very time consuming and would be great to be able to deploy multiple with a import export feature.

ID
1249
Category
Setup
Author

Mike Nelson
Date Created
1/24/2019 2:03:49 PM
Date Updated
1/28/2019 4:40:10 AM
Status
New Idea
Score
30
Promoted By
Scott MillerPatricio BustosMike Nelson
Comments
Patricio Bustos 1/27/2019 2:05:55 PM
Great! We have the same vision. Something like the BRANCH function it would be amazing.
Philipp Matuschka 1/28/2019 4:40:10 AM
Hi Mike

Another approach here is to actually have all your clients in one database and have an additional column by which you control access. So I have a column called Record Access Client ID in every table and every Record Access Permission incorporates this as part of it's access rules.

Each user has a column in his User Settings which links him to a particular client and every time he creates a record the column Record Access Client ID is populated from his User Settings column.

You can then get more sophisticated and link a User to multiple Clients and let him select which one is "in Context" at any particular time. It takes some careful management, but I have been running it for 3 years now without an issue. The advantage is that you DON'T have to go and update your 18 clients afterwards.

I know that there is at least one other developer doing this and I have even had a long Skype conversation with him. I am just having a complete memory lapse as to his name at the moment. Farm machinery in the US is his business.
Feedback
 
Back to Search Results