This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision | ||
userguide:export_db [2009/12/03 14:22] 132.168.73.9 |
userguide:export_db [2016/07/25 10:54] 132.168.72.225 |
||
---|---|---|---|
Line 1: | Line 1: | ||
====== Database Export ====== | ====== Database Export ====== | ||
Many validated identification results can be exported within a relational database. | Many validated identification results can be exported within a relational database. | ||
- | This feature requires : | + | This feature requires |
- | * Postgresql 8.1 | + | * Postgresql |
* an existing database | * an existing database | ||
For more information on MSI db, see [[..:msidb|corresponding page]] | For more information on MSI db, see [[..:msidb|corresponding page]] | ||
- | |||
- | ===== Installing a database ===== | ||
- | |||
- | ==== Installing Postgresql ==== | ||
- | {{:userguide:postgres-install-msi.png?400}} | ||
- | * Execute PostgreSQL 8.1.msi | ||
- | * Follow instructions | ||
- | * Note : master password needs to be set at this stage | ||
- | |||
- | |||
- | === Setting up a database === | ||
- | {{:userguide:setting-up-database.png?600}} | ||
- | |||
- | {{:userguide:setting-up-database-2.png?600}} | ||
- | |||
- | Under user « postgres » : | ||
- | * Connect to database (dble_click) | ||
- | * Create new user « example » with permission to login and create a database | ||
- | * Disconnect from database (R-click) | ||
- | * Reconnect under « example » username (cf. above) | ||
- | {{:userguide:setting-up-database-3.png?500}} | ||
- | |||
- | {{:userguide:setting-up-database-4.png?600}} | ||
- | * Select database Uppsala and click the button « execute arbitraty sql queries » | ||
- | * In query window select file/open | ||
- | * Select the file MSIDBModel (previously named ExportDBModel) included in the IRMa installation folder | ||
- | * All the queries necessary to create the MSidb are now open | ||
- | |||
- | {{:userguide:setting-up-database-5.png?500}} \\ | ||
- | {{:userguide:setting-up-database-6.png?400}} \\ | ||
- | {{:userguide:setting-up-database-7.png?400}} \\ | ||
- | * Execute the queries | ||
- | * The database gets populated with all the tables IRMa needs to store identifications data | ||
- | |||
===== Connecting to a database ===== | ===== Connecting to a database ===== | ||
Line 55: | Line 21: | ||
- | * {{:userguide:connecting-to-database-5.png?400}} | + | * {{:userguide:connecting-to-database-5.png?500}} |
* **You’re ready to export** | * **You’re ready to export** | ||
- | {{:userguide:connecting-to-database-6.png?300}} | + | {{:userguide:connecting-to-database-6.png?500}} |