Common functions:Exporting and Merging Data

From Logilys
Revision as of 11:45, 23 February 2016 by Cbrochu (talk | contribs)
Jump to: navigation, search

Template:Header Common Functions TOC

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=6695"