Difference between revisions of "Common functions:Exporting and Merging Data"

From Logilys
Jump to: navigation, search
 
(35 intermediate revisions by 3 users not shown)
Line 1: Line 1:
−
{{Header_ProDon | | 4.6.5.5 | Nadia Carrier | | 2011/07/11 }}  
+
{{Header_TOC}}<br>
  
 
== Introduction  ==
 
== Introduction  ==
  
−
The data export/merge consists of exporting data from '''ProDon''' to ''Word''''',''' ''Excel'' or ''Text'' files to process or organize data based on different needs (e.g. special reports, lists for verification purposes, etc.). This function is available in many of the software managements (e.g. Client management, Donation occasion management, Analysis &amp; History, etc.). The data can be exported in full or following the result of a search.  
+
The data export/merge consists in exporting data from '''''ProDon''''' to '''''Word'''''<b>,</b> '''''Excel''''' or '''''Text''''' files in order to process or organize data based on different needs (e.g. special reports, lists for verification purposes, etc.). This function is available in many of the software managements (e.g. Client management, Donation occasion management, Analysis &amp; History, etc.). The data can be exported in full or following the result of a search.  
  
−
'''IMPORTANT: '''The modifications made in the merge files are not applied in '''ProDon'''.
+
'''IMPORTANT: '''The modifications made in the merge files are not applied in '''''ProDon'''''.  
  
 
== Export/Merge  ==
 
== Export/Merge  ==
  
−
From a management screen, search the data to export, and click on the "[[Image:Button Exportation merge.png]] Export and merge" button.  
+
From a management screen, search the data to export, and click on the "[[Image:Button Exportation merge.png]] Export and merge" button.<br>  
−
 
 
−
<br>  
 
  
 
{| cellspacing="1" cellpadding="1" border="1" style="width: 456px; height: 326px;" class="wikitable"
 
{| cellspacing="1" cellpadding="1" border="1" style="width: 456px; height: 326px;" class="wikitable"
Line 23: Line 21:
  
 
| width="50%" |  
 
| width="50%" |  
−
'''<span style="color: rgb(255, 0, 0);">B: </span>'''Choose to which type of file (''Word'', ''Excel'' or ''Text'') the data will be exported or merged.  
+
'''<span style="color: rgb(255, 0, 0);">B: </span>'''Choose to which type of file ('''''Word''''', '''''Excel''''' or '''''Text''''') the data will be exported or merged.  
  
 
|}
 
|}
  
−
== In a ''Word'' merge file ==
+
== In a ''Word'' Merge File ==
−
 
 
−
This merge feature in '''''Word''''' is useful in the software sections where it is not possible to create a master document (e.g. in the Participants tab of Analysis &amp; History). When creating a merge document, the fields available onscreen in the software will then become available in '''''Word'''''.
 
  
−
<br>  
+
This merge feature in '''''Word''''' is useful in the software sections where it is not possible to create a master document (e.g. in the Participants tab of Analysis &amp; History). When creating a merge document, the fields available on the software screen will then be available in '''''Word'''''.<br>  
  
−
{| cellspacing="1" cellpadding="1" border="1" style="width: 454px; height: 452px;" class="wikitable"
+
{| cellspacing="1" cellpadding="1" border="1" class="wikitable" style="width: 454px; height: 452px;"
 
|-
 
|-
 
| colspan="2" | [[Image:Export and merge data 002.png]]
 
| colspan="2" | [[Image:Export and merge data 002.png]]
 
|-
 
|-
−
|  
+
| width="50%" |  
 
'''<span style="color: rgb(255, 0, 0);">A: </span>'''Choose to export data in a '''''Word''''' merge file.  
 
'''<span style="color: rgb(255, 0, 0);">A: </span>'''Choose to export data in a '''''Word''''' merge file.  
  
−
|  
+
| width="50%" |  
 
'''<span style="color: rgb(255, 0, 0);">B: </span>'''If the merge file has already been created, select it using the drop-down arrow.  
 
'''<span style="color: rgb(255, 0, 0);">B: </span>'''If the merge file has already been created, select it using the drop-down arrow.  
  
 
|-
 
|-
−
|  
+
| width="50%" |  
 
'''<span style="color: rgb(255, 0, 0);">C: </span>'''After selecting the right merge document, click on "Merge &amp; edit" or on "Merge &amp; print".  
 
'''<span style="color: rgb(255, 0, 0);">C: </span>'''After selecting the right merge document, click on "Merge &amp; edit" or on "Merge &amp; print".  
  
−
|  
+
| width="50%" |  
 
'''<span style="color: rgb(255, 0, 0);">D: </span>'''To add or modify a merge document, click on the "Merge document management" button.  
 
'''<span style="color: rgb(255, 0, 0);">D: </span>'''To add or modify a merge document, click on the "Merge document management" button.  
  
 
|-
 
|-
 
| colspan="2" |  
 
| colspan="2" |  
−
'''NOTE:''' The .Merge &amp; edit" button allows you to consult the merged documents prior to printing, whereas the "Merge &amp; print" button prints the merged documents directly.  
+
'''NOTE:''' The "Merge &amp; edit" button allows you to consult the merged documents prior to printing, whereas the "Merge &amp; print" button prints the merged documents directly.  
  
 
|}
 
|}
Line 60: Line 56:
 
<br>  
 
<br>  
  
−
=== Edit a merge file ===
+
=== Editing a Merge File ===
  
 
{| cellspacing="1" cellpadding="1" border="1" class="wikitable" style="width: 439px; height: 390px;"
 
{| cellspacing="1" cellpadding="1" border="1" class="wikitable" style="width: 439px; height: 390px;"
Line 68: Line 64:
 
| colspan="2" | [[Image:Export and merge data 003.png]]
 
| colspan="2" | [[Image:Export and merge data 003.png]]
 
|-
 
|-
−
|  
+
| width="50%" |  
 
'''<span style="color: rgb(255, 0, 0);">A: </span>'''To create a new merge document, click on "[[Image:Button add plus.png]] Add".  
 
'''<span style="color: rgb(255, 0, 0);">A: </span>'''To create a new merge document, click on "[[Image:Button add plus.png]] Add".  
  
−
|  
+
| width="50%" |  
 
'''<span style="color: rgb(255, 0, 0);">B: </span>'''To edit a master document, select the document to be modified, then click on the appropriate button.  
 
'''<span style="color: rgb(255, 0, 0);">B: </span>'''To edit a master document, select the document to be modified, then click on the appropriate button.  
  
 
|-
 
|-
−
| colspan="2" | '''NOTE: '''The merge fields related to this part of the software will automatically be exported in '''''Word''''' to create the document.
+
| colspan="2" |  
 +
'''NOTE: '''The merge fields related to that part of the software will automatically be exported in '''''Word''''' to create the document.  
 +
 
 
|}
 
|}
  
−
== In an ''Excel'' file <br>  ==
+
== In an ''Excel'' File <br>  ==
  
 +
{| cellspacing="1" cellpadding="1" border="1" style="width: 457px; height: 469px;" class="wikitable"
 +
|-
 +
| colspan="2" | [[Image:Export and merge data 004.png]]
 +
|-
 +
| width="50%" |
 +
'''<span style="color: rgb(255, 0, 0);">A: </span>'''Choose to export data in an '''''Excel''''' file.
  
 +
| width="50%" |
 +
'''<span style="color: rgb(255, 0, 0);">B: </span>'''The software names the '''''Excel''''' file by default. However, it is possible to manually rename it, as in this example.
  
−
{| cellspacing="1" cellpadding="1" border="1" style="width: 455px; height: 498px;"
 
 
|-
 
|-
−
| colspan="2" | [[Image:Export_and_merge_data_004.png]]
+
| width="50%" |  
 +
'''<span style="color: rgb(255, 0, 0);">C: </span>'''To export or add data in an existing file, you have to name the file in step <span style="color: rgb(255, 0, 0);">'''B '''</span>in the same way as a source file. To see the names of the previously created files, click on "Generate &amp; explore".
 +
 
 +
| width="50%" |
 +
'''<span style="color: rgb(255, 0, 0);">D: </span>'''This box allows you to export only the columns visible in the configured view.  
 +
 
 
|-
 
|-
−
|  
+
| width="50%" |  
−
'''<span style="color: rgb(255, 0, 0);">A: </span>'''Choose to export data in an '''''Excel''''' file.
+
'''<span style="color: rgb(255, 0, 0);">E: </span>'''This box allows you to export all the available columns for that part of the software.  
  
−
|  
+
| width="50%" |  
−
'''<span style="color: rgb(255, 0, 0);">B: </span>'''The software names the '''''Excel'''''file by default. However, it is possible to manually rename it, as in this example.
+
'''<span style="color: rgb(255, 0, 0);">F: </span>'''This function allows you to transform every field format into "standard" format so that it is ignored during the data exportation.  
  
 
|-
 
|-
−
|  
+
| width="50%" |
−
|  
+
'''<span style="color: rgb(255, 0, 0);">G: </span>'''After choosing all the wanted options, click on "Generate &amp; open" or on "Generate &amp; explore".
−
|-
+
 
−
|
+
| width="50%" |  
−
|
+
'''NOTE: '''The "Generate &amp; open" button generates the merge document onscreen, whereas the "Generate &amp; explore" button generates the file without opening it. The latter option is useful when there are many merge documents to generate and that there is no need to open them all.
 +
 
 
|}
 
|}
  
−
== In a ''Text ''file ==
+
== In a ''Text ''File ==
  
−
{| cellspacing="1" cellpadding="1" border="1" style="width: 456px; height: 472px;" class="wikitable"
+
{| cellspacing="1" cellpadding="1" border="1" class="wikitable" style="width: 456px; height: 472px;"
 
|-
 
|-
−
| colspan="2" | [[Image:Export_and_merge_data_005.png]]
+
| colspan="2" | [[Image:Export and merge data 005.png]]
 
|-
 
|-
−
|  
+
| width="50%" |
−
|  
+
'''<span style="color: rgb(255, 0, 0);">A: </span>'''Choose to export data in a '''''Text''''' file.
 +
 
 +
| width="50%" |
 +
'''<span style="color: rgb(255, 0, 0);">B: </span>'''The software names the '''''Text''''' file by default. However, it is possible to manually rename it, as in this example.
 +
 
 
|-
 
|-
−
|  
+
| width="50%" |
−
|  
+
'''<span style="color: rgb(255, 0, 0);">C: </span>'''To export or add data in an existing file, you have to name the file in step <span style="color: rgb(255, 0, 0);">'''B'''</span> in the same way as a source file. To see the names of the previously created files, click on "Generate &amp; explore".
 +
 
 +
| width="50%" |
 +
'''<span style="color: rgb(255, 0, 0);">D: </span>'''This box allows you to see only the columns visible in the configured view.
 +
 
 
|-
 
|-
−
|  
+
| width="50%" |  
−
|
+
'''<span style="color: rgb(255, 0, 0);">E: </span>'''This box allows you to export all the available columns for that part of the software.
−
|-
 
−
|
 
−
|  
 
−
|}
 
  
−
<br>  
+
| width="50%" |
 +
'''<span style="color: rgb(255, 0, 0);">F: </span>'''This function allows you to transform every field format into "standard" format so that it is ignored during the data exportation.
  
−
<br>  
+
|-
 +
| width="50%" |
 +
'''<span style="color: rgb(255, 0, 0);">G: </span>'''After choosing all the wanted options, click on "Generate &amp; open" or on "Generate &amp; explore".
  
−
<br>
+
| width="50%" |
 +
'''NOTE: '''The "Generate &amp; open" button generates the merge document onscreen, whereas the "Generate &amp; explore" button generates the file without opening it. The latter option is useful when there are many merge documents to generate and that there is no need to open them all.
  
−
<br>
+
|}
−
 
 
−
<br>
 
  
 
<br>  
 
<br>  
  
−
{{Footer_ProDon}}
+
{{Footer_Common_Functions}}<br>

Latest revision as of 07:42, 5 May 2016

Exporting and Merging Data

Introduction

The data export/merge consists in exporting data from ProDon to Word, Excel or Text files in order to process or organize data based on different needs (e.g. special reports, lists for verification purposes, etc.). This function is available in many of the software managements (e.g. Client management, Donation occasion management, Analysis & History, etc.). The data can be exported in full or following the result of a search.

IMPORTANT: The modifications made in the merge files are not applied in ProDon.

Export/Merge

From a management screen, search the data to export, and click on the "Button Exportation merge.png Export and merge" button.

This window opens.
Export and merge data 001.png

A: Choose the selection of data to export or merge.

B: Choose to which type of file (Word, Excel or Text) the data will be exported or merged.

In a Word Merge File

This merge feature in Word is useful in the software sections where it is not possible to create a master document (e.g. in the Participants tab of Analysis & History). When creating a merge document, the fields available on the software screen will then be available in Word.

Export and merge data 002.png

A: Choose to export data in a Word merge file.

B: If the merge file has already been created, select it using the drop-down arrow.

C: After selecting the right merge document, click on "Merge & edit" or on "Merge & print".

D: To add or modify a merge document, click on the "Merge document management" button.

NOTE: The "Merge & edit" button allows you to consult the merged documents prior to printing, whereas the "Merge & print" button prints the merged documents directly.



Editing a Merge File

After clicking on the "Merge document management" button, this window opens.
Export and merge data 003.png

A: To create a new merge document, click on "Button add plus.png Add".

B: To edit a master document, select the document to be modified, then click on the appropriate button.

NOTE: The merge fields related to that part of the software will automatically be exported in Word to create the document.

In an Excel File

Export and merge data 004.png

A: Choose to export data in an Excel file.

B: The software names the Excel file by default. However, it is possible to manually rename it, as in this example.

C: To export or add data in an existing file, you have to name the file in step B in the same way as a source file. To see the names of the previously created files, click on "Generate & explore".

D: This box allows you to export only the columns visible in the configured view.

E: This box allows you to export all the available columns for that part of the software.

F: This function allows you to transform every field format into "standard" format so that it is ignored during the data exportation.

G: After choosing all the wanted options, click on "Generate & open" or on "Generate & explore".

NOTE: The "Generate & open" button generates the merge document onscreen, whereas the "Generate & explore" button generates the file without opening it. The latter option is useful when there are many merge documents to generate and that there is no need to open them all.

In a Text File

Export and merge data 005.png

A: Choose to export data in a Text file.

B: The software names the Text file by default. However, it is possible to manually rename it, as in this example.

C: To export or add data in an existing file, you have to name the file in step B in the same way as a source file. To see the names of the previously created files, click on "Generate & explore".

D: This box allows you to see only the columns visible in the configured view.

E: This box allows you to export all the available columns for that part of the software.

F: This function allows you to transform every field format into "standard" format so that it is ignored during the data exportation.

G: After choosing all the wanted options, click on "Generate & open" or on "Generate & explore".

NOTE: The "Generate & open" button generates the merge document onscreen, whereas the "Generate & explore" button generates the file without opening it. The latter option is useful when there are many merge documents to generate and that there is no need to open them all.


Document name: Common functions:Exporting and Merging Data


Retrieved from "http://wikien.logilys.com/index.php?title=Common_functions:Exporting_and_Merging_Data&oldid=6857"