Page 9 of 9
Data Exchange
Fundamental Sequence of the Data Exchange
- Invoke the command to display the data exchange dialog in menu Learning Package
- Choose the Data Source Provider
- Choose the Data Source File (grayed out if provider does not use one)
- Choose the Data Sink Provider
- Choose the Data Sink File (grayed out if provider does not use one)
- Press the Copy Button (enabled if all requirements are fulfilled)
- The progress bar indicates, if the Copy action is active yet
Explanation of the Data Source Providers
These are the sources of the Data Exchange. The following are implemented:
| Provider | Explanation | Particularities |
| CSV Import | Import from a CSV file | Use required format |
| OPEN Sql Database Source | Learning package is the source for export | The package just opened in the program |
| Sql Database Source | Learning package is the source for export |
A package not opened but existing as MDF file |
Explanation of the Data Sink Providers
These are the sinks or targets of the Data Exchange. The following are implemented:
| Provider | Explanation | Particularities |
| CSV Export | Export in a CSV file | |
| Null Sink | Null Sink | No output generated |
| OPEN Updating Sql Database Sink | Just opened package is target of an import | The package just opened in the user interface. The structure (e.g. number of lessons and cardfiles) must remain the same, only their content maybe updated |
| Sql Database Sink | Learning package is target of an import | Target is a MDF file (package), it may exist and will then be overwritten |
| Updating Sql Database Sink | Learning package if target of an import | Only used to update the content |
Attention! Use both "Updating" sinks only in exceptional cases, f.i. if you wish to improve the content of some cardfiles in the CSV file and then want to reimport the file.
Example for a CSV Import
- Choose CSV Import as data source provider
- Choose an existing CSV file
- Choose Sql Database Sink
- Choose a not existent MDF file
- Press Copy
- Open the learning package just imported with Learning Package - Open Learning Package