Hans Karlsen (talk | contribs) (Created page with "Once you have the MDriven Turnkey Excel Plugin installed (How to install) you will find in the tab AddOns: none|thumb|712x712px Clicking t...") |
(Automatically adding template at the end of the page.) |
||
| (12 intermediate revisions by 4 users not shown) | |||
| Line 1: | Line 1: | ||
Once you have the MDriven Turnkey Excel Plugin installed ([[How to install]]) you will find in the tab AddOns: | |||
Once you have the MDriven Turnkey Excel Plugin installed ([[How to install Turnkey Excel plugin]]), you will find it in the tab AddOns: | |||
[[File:2018-07-09 20h05 37.png|none|thumb|712x712px]] | [[File:2018-07-09 20h05 37.png|none|thumb|712x712px]] | ||
Clicking the action brings up this window: | Clicking the action brings up this window: | ||
| Line 5: | Line 6: | ||
This window contains a browser. | This window contains a browser. | ||
Paste | Paste the URL to your MDriven Turnkey application in the box at the top and press "Go". | ||
The application shows up in the embedded browser. | |||
=== Get Data from MDriven Turnkey into Excel === | |||
Find a view with a Grid of data in your application: | |||
[[File:2018-07-09 20h12 35.png|none|thumb|1276x1276px]] | |||
The data you see in the FIRST GRID in the Turnkey UI will be downloaded to Excel when you press the button (A). The data will be placed in the selected cell in Excel (B). | |||
=== Find Data in MDriven Turnkey Based on Excel Selection === | |||
Select some cells in Excel (A and B) and press "Seek Selected in Turnkey" (C). If the UI in MDriven Turnkey is a Seeker, then each cell's data will be "sought" after and the result will build up in the applications search result grid (D): | |||
[[File:2018-07-09 20h21 58.png|none|thumb|1083x1083px]] | |||
=== Write Data From Excel Into the MDriven Turnkey Application === | |||
If your MDriven Turnkey UI is a seeker - and the seeker result has the key in the leftmost column, and if some columns are marked as Writable (not read-only) in the MDriven Designer ViewModel, then you can select a square section of data in Excel (A), having the key at the leftmost column and press "Write Selected to Turnkey" (B). Data in the leftmost column will be used to seek up an existing matching object - if none is found and if an Action with the name "CreateNew" is found, the action is assumed to create a new object of the same class as you have in the result list. In this case, it will be given the key. After this, other writable columns will be given their values from the Excel area you selected (C). This will work even with lookups (ComboBoxes) - as that is the preferred way to assign single links. | |||
If any data is touched, the Save/Cancel option will show in turnkey (D). | |||
[[File:2018-07-09 20h31 10.png|none|thumb|1192x1192px]] | |||
<html> | |||
<p><iframe height="315" src="https://www.youtube.com/embed/jhttEzcerYU" frameborder="0" width="560" allowfullscreen allow="autoplay; encrypted-media"></iframe></p> <p>This amazing Excel-AddIn will enable you to move and update data between any Turnkey app and Excel.</p> <p>Now you can satisfy a lot of ad-hoc user requirements in one elegant stroke.</p> <p>Contrary to the normal “total abdication of all security concerns” that usually apply when you give access to end users to your data via Excel, MDriven Turnkey always exposes only the data you have designed in the views to the authorized persons controlled by your access groups from the model.</p> | |||
</html> | |||
[[Category:MDriven Turnkey]] | |||
{{Edited|July|12|2024}} | |||
Latest revision as of 15:34, 10 February 2024
Once you have the MDriven Turnkey Excel Plugin installed (How to install Turnkey Excel plugin), you will find it in the tab AddOns:
Clicking the action brings up this window:
This window contains a browser.
Paste the URL to your MDriven Turnkey application in the box at the top and press "Go".
The application shows up in the embedded browser.
Get Data from MDriven Turnkey into Excel
Find a view with a Grid of data in your application:
The data you see in the FIRST GRID in the Turnkey UI will be downloaded to Excel when you press the button (A). The data will be placed in the selected cell in Excel (B).
Find Data in MDriven Turnkey Based on Excel Selection
Select some cells in Excel (A and B) and press "Seek Selected in Turnkey" (C). If the UI in MDriven Turnkey is a Seeker, then each cell's data will be "sought" after and the result will build up in the applications search result grid (D):
Write Data From Excel Into the MDriven Turnkey Application
If your MDriven Turnkey UI is a seeker - and the seeker result has the key in the leftmost column, and if some columns are marked as Writable (not read-only) in the MDriven Designer ViewModel, then you can select a square section of data in Excel (A), having the key at the leftmost column and press "Write Selected to Turnkey" (B). Data in the leftmost column will be used to seek up an existing matching object - if none is found and if an Action with the name "CreateNew" is found, the action is assumed to create a new object of the same class as you have in the result list. In this case, it will be given the key. After this, other writable columns will be given their values from the Excel area you selected (C). This will work even with lookups (ComboBoxes) - as that is the preferred way to assign single links.
If any data is touched, the Save/Cancel option will show in turnkey (D).
This amazing Excel-AddIn will enable you to move and update data between any Turnkey app and Excel.
Now you can satisfy a lot of ad-hoc user requirements in one elegant stroke.
Contrary to the normal “total abdication of all security concerns” that usually apply when you give access to end users to your data via Excel, MDriven Turnkey always exposes only the data you have designed in the views to the authorized persons controlled by your access groups from the model.