Difference between revisions of "Tabular Data Manager: Basic Operations"

From Gcube Wiki
Jump to: navigation, search
(Blanked the page)
Line 1: Line 1:
== Main interface features ==
 
Composition of the interface :
 
  
=== Ribbon menu ===
 
:The interface consists of a top ribbon menu of four tabs (i.e Home, Curation, Modify, Rule, Template and Analyse) which includes the main functionalities of the portlet.
 
[[Image:tabular_data_manager_ribbon1.png|thumb|center|740px|x100px|Tabular Data Manager, Ribbon menu]]
 
[[Image:tabular_data_manager_curation.png|thumb|center|740px|x100px|Tabular Data Manager, Curation tab ]]
 
[[Image:tabular_data_manager_modify.png|thumb|center|740px|x100px|Tabular Data Manager, Modify tab]]
 
[[Image:tabular_data_manager_rule.png|frame|center|Tabular Data Manager, Rule tab]]
 
[[Image:tabular_data_manager_template.png|frame|center|Tabular Data Manager, Template tab]]
 
[[Image:tabular_data_manager_analyse.png|frame|center|Tabular Data Manager, Analyse tab]]
 
 
=== Tools area ===
 
:The interface has a left side panel which reports all the informations related to the activated Tabular Resource. In this panel the user, switching on the TAB "Properties", can change the basic informations of the Tabular Resource, visualize the validations result for the latest task executed (using the "Validations" button) or check the resources connected to this tabular resource (i.e. maps, csv files etc.) using the "Resources" button.
 
[[Image:tabular_data_manager_tools1.png|frame|center|Tabular Data Manager, tools area]]
 
 
=== Main area ===
 
:In the central panel, your active tabular resource is displayed. The picture shows on which tabular resource you are working on as confirmed by the bottom panel.
 
[[Image:tabular_data_manager_main1.png|700px|thumb|center|Tabular Data Manager, main area]]
 
 
== Home ==
 
 
=== Tabular Resource Menu ===
 
: This section includes basic operations to open, close, delete, investigating the properties and clone your tabular resource.
 
[[Image:tabular_data_manager_openbutton.png|frame|center|Tabular Data Manager, Tabular Resource Menu]]
 
 
==== Open ====
 
: A window will show the list of tabular resource available to the user.
 
:To open your tabular resource you need to click on the Home tab and on the Open button of the Tabular Resource menu.
 
:A window will appear to show the list of tabular resources already uploaded in your workspace and thus available to be visualized
 
 
==== Close All ====
 
:A singular tabular resources can be closed directly in the bottom menu of the central panel (See Figure in Section "Main area"). You can also use the close button on the top of the ribbon menu, Home-> Tabular Resource, which allows to close all the open tabular resources in you working environment.
 
 
==== Clone ====
 
:You can create one or more copies of your tabular resource using the Clone button in the Tabular Resource menu.
 
 
==== Share ====
 
: Users can decide sharing their own tabular resources by using the Share button in the same Menu. This button will be active only on the opened tabular resource. The person receiving the shared tabular resource, will automatically have it in the Tabular Data Manager repository.
 
[[Image:share.png|frame|center|Tabular Data Manager, Share]]
 
 
==== Delete ====
 
:It is possible to delete your tabular resources using the button Delete on the Tabular Resource menu of the Home tab. The resource will  not be available into your workspace anymore. A po-up window will appear to confirm the operation.
 
[[Image:tabular_data_manager_delete.png|frame|center|Tabular Data Manager, Delete]]
 
 
==== Properties ====
 
:The tab properties shows the main characteristics of the activated tabular resource, for example: description, type and owner.
 
[[Image:tabular_data_manager_properties1.png|frame|center|Tabular Data Manager, properties]]
 
 
===== Resources =====
 
:The Resources button, shows the resources associated with the tabular resource. The users can manage resources using the context menu.
 
[[Image:tabular_data_manager_tabresources1.png|frame|center|Tabular Data Manager, resources]]
 
 
===== Validations =====
 
:The Validations button, shows the validations associated with the tabular resource. The users can manage validations using the context menu.
 
[[Image:tabular_data_manager_validations1.png|frame|center|Tabular Data Manager, validations]]
 
 
=== Import Menu ===
 
==== CSV ====
 
:Users can import their file in .csv format, by clicking on the CSV button of the Import menu.
 
[[Image:tabular_data_manager_ribbon1.png|thumb|center|800px|x101px|Tabular Data Manager, Ribbon menu]]
 
:The user can specify using a pop-up window the file source. There are two possibilities: File source, if you want to retrieve your files from your local computer or Workspace, if you want to retrieve them from your workspace.
 
 
[[Image:source_csv.png|frame|center|Tabular Data Manager, CSV source selection]]
 
:After, several pop-up windows will appear for both file configuration and detail.
 
[[Image:csv_configuration.png|frame|center|Tabular Data Manager, CSV configuration]]
 
[[Image:detail_table.png|frame|center|Tabular Data Manager, Details on the imported table]]
 
:A final pop-up window will inform you when the file is successfully imported
 
[[Image:success_import.png|frame|center|Tabular Data Manager, file successfully uploded]]
 
 
==== SDMX ====
 
:Users can import tabular resources from SDMX registry, by clicking on the SDMX button of the Import menu.
 
 
=== Export Menu ===
 
==== CSV ====
 
:Users can export their file in a .csv format, by clicking on the CSV button in the Export menu.
 
 
[[Image:tabular_data_manager_ribbon1.png|thumb|center|800px|x101px|Tabular Data Manager, Ribbon menu]]
 
 
:Using a pop-up window, the user specifies the folder into the workspace where the file will be saved. From the workspace the file can be downloaded in local.
 
 
[[Image:exportWork.png|frame|center|Tabular Data Manager, Export your CSV in your Workspace folder]]
 
 
:A pop-up windows will help you to configure your file for the export.
 
[[Image:exportCsv.png|frame|center|Tabular Data Manager, Configure the export of your CSV file]]
 
 
:A final pop-up window will inform you the success of the export procedure.
 
[[Image:exportComplete.png|frame|center|Tabular Data Manager, the file has been successfully exported]]
 
 
==== JSON ====
 
:Users can export their file in a .json format, by clicking on the JSON button in the Export menu.
 
[[Image:tabular_data_manager_export_json1.png|frame| center|Tabular Data Manager, Export JSON]]
 
 
==== SDMX ====
 
:Users can export tabular resources in SDMX registry, by clicking on the SDMX button of the Export menu.
 
 
=== Tasks Menu ===
 
==== Timeline ====
 
: This button displays all the operations performed on the active tabular resource. It gives information on the type, the status and the progress of the operation in case some of them are still on course.
 
[[Image:timelinemonitor.png|frame|center|Tabular Data Manager, Timeline monitor view]]
 
 
==== Background ====
 
: Users can run multiple operations and leave them in the background while working with other tabular resources.
 
 
=== History Menu ===
 
:The history menu registers all the operation you performed in the file. The user can decide to go back until the original is not recovered.
 
[[Image:tabular_data_manager_ribbon1.png|thumb|center|800px|x101px|Tabular Data Manager, Ribbon menu]]
 
==== History ====
 
:Records of all the operation executed on the table. The user can sort ascending or descending the operations and decide which one to visualize.
 
[[Image:history.png|frame|center|Tabular Data Manager, Screen-shot of the last executed operation on one file ]]
 
 
==== Undo ====
 
: This button allows to recover the previous version of the file by annulling the executed operations
 
 
[[Image:discard.png|500px|thumb|center|Tabular Data Manager, Discard last operation]]
 
 
== Grid Menu ==
 
:A column and a context menu, are available directly on your tabular resource. By using the column menu, which appear in each column header, you can access to the main functionalities, present in the tabs of the ribbon bar (see image in the section Column Menu). On the other hand, the right click on the cell allows to execute basic operations (see image of the section Contex Menu)
 
 
:Example of the Grid Header Column Menu
 
[[Image:tabular_data_manager_grid_header_menu1.png|700px|thumb|center|Tabular Data Manager, grid header column menu]]
 
 
:Example of the Context Menu
 
[[Image:tabular_data_manager_grid_context_menu1.png|700px|thumb|center|Tabular Data Manager, grid context menu]]
 
 
 
=== Inline Filter ===
 
: This functions allows to filter the rows to a certain value the user establishes, the tabular resource is not changed only the view is modified.
 
[[Image:tabular_data_manager_inlinefilter_text.png|frame|center|Tabular Data Manager, Inline Filter Text]]
 
: Note the Inline Filter changes according to the column type.
 
[[Image:inlinefilter.png|frame|center|Tabular Data Manager, Inline Filter Integer or Numeric]]
 
[[Image:tabular_data_manager_inlinefilter_boolean.png|frame|center|Tabular Data Manager, Inline Filter Boolean]]
 
[[Image:tabular_data_manager_inlinefilter_date.png|frame|center|Tabular Data Manager, Inline Filter Attribute Date]]
 
 
=== Filter ===
 
:Look at [[Tabular Data Manager#Filter|Filter]] section.
 
 
=== Replace Batch ===
 
: This functions has a duplex utility: the user can replace the cells that have been identified with errors in previous operations or can replace all at once the cells that match the criteria selected.
 
[[Image:replacebatch.png|600px|thumb|center|Tabular Data Manager, Replace Batch]]
 
 
=== Replace by Expression ===
 
;By simple condition:
 
:There is the possibility to replace column values by expression. Let's use the tabular resource below, by 'Type' column:
 
[[Image:tabular_data_manager_replacebyexpressionConditionTR1.png|frame|center|Tabular Data Manager, replace by expression simple]]
 
:Set this condition and replace value:
 
[[Image:tabular_data_manager_replacebyexpressionCondition1.png|frame|center|Tabular Data Manager, replace by expression set condition]]
 
:The result is:
 
[[Image:tabular_data_manager_replacebyexpressionConditionResult1.png|frame|center|Tabular Data Manager, replace by expression result]]
 
 
;By Text column data type:
 
:Let's use the tabular resource below:
 
[[Image:tabular_data_manager_replacebyexpressionTR1.png|frame|center|Tabular Data Manager, replace by expression tabular resource]]
 
:Set this replace value:
 
[[Image:tabular_data_manager_replacebyexpressionReplace1.png|frame|center|Tabular Data Manager, replace by expression replace]]
 
:The result is:
 
[[Image:tabular_data_manager_replacebyexpressionResult.png|frame|center|Tabular Data Manager, replace by expression result]]
 
 
;By Integer or Numeric column data type:
 
:Let's use the tabular resource below, by '2011+2012+2013' numeric column data type:
 
[[Image:tabular_data_manager_replacebyexpressionArithmeticTR1.png|frame|center|Tabular Data Manager, replace by arithmetic expression tabular resource]]
 
:Set this replace value:
 
[[Image:tabular_data_manager_replacebyexpressionArithmetic1.png|frame|center|Tabular Data Manager, replace by arithmetic expression ]]
 
:The result is:
 
[[Image:tabular_data_manager_replacebyexpressionArithmeticResult1.png|frame|center|Tabular Data Manager, replace by arithmetic expression result]]
 
 
== External links ==
 
* [http://en.wikipedia.org/wiki/Regular_expression  POSIX Regular Expression]
 
 
 
[[Category:Tabular Data Manager]]
 

Revision as of 11:31, 22 May 2015