Come importare/esportare una query?
From MedITEX - Wiki
| Line 1: | Line 1: | ||
| − | <p> | + | <p>Per aprire <strong>Report editor</strong>, cliccare su <strong>Report -> Report editor </strong>nella bara dei menù.</p> |
<table style="margin-left: auto; margin-right: auto;" border="0" width="10" height="24"> | <table style="margin-left: auto; margin-right: auto;" border="0" width="10" height="24"> | ||
<tbody> | <tbody> | ||
<tr> | <tr> | ||
| − | <td><img src="/images/ | + | <td><img src="/images/Report_Editor_1_IT.png" alt="" width="462" height="288" /></td> |
</tr> | </tr> | ||
</tbody> | </tbody> | ||
</table> | </table> | ||
<p> </p> | <p> </p> | ||
| − | <p>Report | + | <p>Report Editor si aprirà.</p> |
<table style="margin-left: auto; margin-right: auto;" border="0"> | <table style="margin-left: auto; margin-right: auto;" border="0"> | ||
<tbody> | <tbody> | ||
<tr> | <tr> | ||
| − | <td style="text-align: center;"><img src="/images/ | + | <td style="text-align: center;"><img src="/images/Report_Editor_7_IT.png" alt="" width="63" height="35" /></td> |
| − | <td> | + | <td>Cliccare su <strong>Apri</strong> per aprire la finestra sottostante ed <strong>Importare/Esportare </strong>query.<strong> <br /></strong></td> |
</tr> | </tr> | ||
<tr> | <tr> | ||
| − | <td colspan="2"><img src="/images/ | + | <td colspan="2"><img src="/images/Strum_amm_query_1_IT.png" alt="" width="750" height="539" /></td> |
</tr> | </tr> | ||
</tbody> | </tbody> | ||
| Line 25: | Line 25: | ||
<tr> | <tr> | ||
<td> | <td> | ||
| − | <p><strong> | + | <p><strong>Tasto destro </strong>sulla query e selezionare l'opzione <strong>Query</strong>.</p> |
</td> | </td> | ||
</tr> | </tr> | ||
<tr> | <tr> | ||
| − | <td><img src="/images/ | + | <td><img src="/images/Strum_amm_query_5_IT.png" alt="" width="646" height="374" /></td> |
</tr> | </tr> | ||
</tbody> | </tbody> | ||
</table> | </table> | ||
<p> </p> | <p> </p> | ||
| − | <h2> | + | <h2>Esportare una query</h2> |
<p>A query may be exported in order to import it later into another server (e.g.: it is possible to send the query to a colleague using MedITEX in another center) or by another user in his/her own folder.</p> | <p>A query may be exported in order to import it later into another server (e.g.: it is possible to send the query to a colleague using MedITEX in another center) or by another user in his/her own folder.</p> | ||
<p>If the option <strong> Export </strong>is selected, the query will be copied into the folder <strong>Query builder</strong>, usually located at "<SERVER>\MedITEX IVF\File_Storage\QueryBuilder". The file will be saved as <strong>FQB [Name].grd</strong>. "<strong>Name</strong>" here represents the name of the query. This file can be sent and copied into another computer.</p> | <p>If the option <strong> Export </strong>is selected, the query will be copied into the folder <strong>Query builder</strong>, usually located at "<SERVER>\MedITEX IVF\File_Storage\QueryBuilder". The file will be saved as <strong>FQB [Name].grd</strong>. "<strong>Name</strong>" here represents the name of the query. This file can be sent and copied into another computer.</p> | ||
<p> </p> | <p> </p> | ||
| − | <h2> | + | <h2>Importare una query</h2> |
<p>To <strong>import </strong>a query just select the corresponding option from the menu<strong> Query</strong>. Browse your computer and select the file you wish to import.</p> | <p>To <strong>import </strong>a query just select the corresponding option from the menu<strong> Query</strong>. Browse your computer and select the file you wish to import.</p> | ||
<table style="margin-left: auto; margin-right: auto;" border="0" width="563" height="5"> | <table style="margin-left: auto; margin-right: auto;" border="0" width="563" height="5"> | ||
| Line 49: | Line 49: | ||
</table> | </table> | ||
<p> </p> | <p> </p> | ||
| − | <h2> | + | <h2>Importare una query Expert</h2> |
<p>Expert queries are created by our support team and they are meant for very specific user requests. These queries are not editable.</p> | <p>Expert queries are created by our support team and they are meant for very specific user requests. These queries are not editable.</p> | ||
<p>In order to import an expert query, you must click on any field from the <strong>Group list </strong>(area 1).</p> | <p>In order to import an expert query, you must click on any field from the <strong>Group list </strong>(area 1).</p> | ||
Revision as of 15:53, 26 April 2016
Per aprire Report editor, cliccare su Report -> Report editor nella bara dei menù.
| <img src="/images/Report_Editor_1_IT.png" alt="" width="462" height="288" /> |
Report Editor si aprirà.
| <img src="/images/Report_Editor_7_IT.png" alt="" width="63" height="35" /> | Cliccare su Apri per aprire la finestra sottostante ed Importare/Esportare query. |
| <img src="/images/Strum_amm_query_1_IT.png" alt="" width="750" height="539" /> | |
|
Tasto destro sulla query e selezionare l'opzione Query. |
| <img src="/images/Strum_amm_query_5_IT.png" alt="" width="646" height="374" /> |
Esportare una query
A query may be exported in order to import it later into another server (e.g.: it is possible to send the query to a colleague using MedITEX in another center) or by another user in his/her own folder.
If the option Export is selected, the query will be copied into the folder Query builder, usually located at "<SERVER>\MedITEX IVF\File_Storage\QueryBuilder". The file will be saved as FQB [Name].grd. "Name" here represents the name of the query. This file can be sent and copied into another computer.
Importare una query
To import a query just select the corresponding option from the menu Query. Browse your computer and select the file you wish to import.
| <img style="display: block; margin-left: auto; margin-right: auto;" src="/images/hint48.png" alt="" width="48" height="48" /> | When you right-click a query from the list and select Import, it will not overwrite this query. Instead, you will be asked to type in a new name and the query will be imported separately. |
Importare una query Expert
Expert queries are created by our support team and they are meant for very specific user requests. These queries are not editable.
In order to import an expert query, you must click on any field from the Group list (area 1).
  |
After it is selected, press Ctrl+E. The Selection section will change to the picture bellow.
  |
Click on Expertenabfrage and drag it to the Query section (area 2). The window Edit expert query will open.
  |
Now open the "*.sql" file sent by the support team in any text editor like Notepad. Copy everything with Ctrl+A then Ctrl+C or select the whole code and right-mouse-click Copy.
Go back to the Edit expert query window. Delete all the default code.
Press Ctrl+V to paste the code we previously copied.
Press the OK buttom at the bottom right corner.
Back in the main Report editor window, save this new query and now you are able to run it just like a normal query.
| <a href="/index.php?title=MedITEX_IVF_how_to">Back to How to</a> | <a href="#top">Back to top</a> |