Welcome to Softhard Solutions Softhard Solutions AzureMate Logo

AzureMate Desktop Storage Tables Form Explanation
Cloud Data Storage Explorer Management Software

Become a new user of AzureMate Cloud Data Storage Explorer application.

ShopMateWeb Online and ShopMate Desktop - Best Business Accounting Database Software.
Screen Shot See Also
AzureMate Software System - Desktop Cloud Data Storage Explorer Management Application

AzureMate Desktop System - Explorer Tables Form Page Explained

Hello and welcome to AzureMate, Windows Azure Cloud Data Storage Explorer System, Tables Form Page. The Table Storage System in Azure is a system similar to Databases containing Tables of structured data records. In Azure Tables the entity records are Non-Sql system. Every entity record in a Table can have a different schema structure.
View Tables Form Screen Shot...

This AzureMate Tables Storage Manager form provides you with the ability to manipulate the currently used Azure Storage Account's Table Containers and their entity record data. The operations on the table containers include:

  • Creating new Table containers.
  • Uploading new entity records to containers.
  • Editing existing entity records of containers.
  • Deleting existing containers with all of their data.
  • Deleting all or individual entity records from containers.

Important Note
AzureMate implements paging on both, displayed Table Containers and displayed Entity Records. You can set how many entities and tables to display at a time in the Form's Settings manager. The default is 25 tables and 100 entities when you first start AzureMate.

Tips
When you are exploring your records here, always be aware of the Page Buttons on top. If they are disabled, there are no more pages, if they are enabled, there is more data available.

In some cases Buttons rely on something to be written into an updatable grid's field or into a text box to get enabled and as you type they remain disabled until you hit the Enter or Tab key on your keyboard.

Any time you are not sure of something while running AzureMate, press the F1 function key (usually situated on top of your keyboard) for extensive context help.

The grids may contain one or more fields that are too short to display fully and show the continuation mark '...'. You can point into these fields with your mouse and the editor will display the words fully as a tip. You can also widen the columns to show more content.

Tables Explorer Form

When you look at the top right corner of the page you will see the currently selected storage account's total number of Blob, Table and Queue containers.

Following table contains all the available elements for review.

Element Description
TreeView
on left
This Tree-View contains either all or paged Table Containers and their records. It is separated from the List-View of Record Entities on the right by an invisible vertical line which serves for making either of the views wider or shorter by moving your mouse horizontally between them until the line appears. Grab the line with your mouse and move it to the left or right as desired.

There is no context menu (right clicking your mouse) associated with this Tree-View. Left click any tree branch to reveal records on the right List-View.
List-View
on right
This List-View contains either all or paged Entities, depending on what you click and select in the Tree-View on left.

There is a context menu (right clicking your mouse) associated with this List-View. It contains three menu choices:

Re-view - Edits selected record.
Save - Saves selected record(s) to a .csv file.
Delete - Deletes selected record(s).

When you select (highlight) only one item for Re-view, or more items for Save or for Delete, in this List-View, right click the highlighted portion to select either to Re-view one highlighted record or Save or Delete one or more of them from the currently selected Table. The Save option is here for convenience, the button Save does the same thing.

You can also double click any item to review it.
Hyper-link:
New Container

Left click this link button to start the process of creating a new Table Container. When you click this link button, the Create new Container manager will appear asking you for the new container Name. Once you enter a name it will create the container and add it here.

Important Note
The new Table container you just successfully created may be hidden by the paging process and not displayed here.

Hyper-link:
Delete Container
Left click this link button to start the process of deleting the selected Table Container from the currently used storage account. Be cautious, if the container contains any records, they are all deleted with it!
Hyper-link:
Refresh Containers
Left click this link button to start the process of refreshing the available Table Containers in the currently used storage account for new display. When you click this link button, any available pages are disregarded and new are created if necessary.
Button:
Next Page
of Containers
Left click this button to start the process of retrieving the next page of available Containers in the currently used storage account for display. When you click this button, the next page of available Containers is added to the display. This button is Disabled if there are no more pages available.
Hyper-link:
Upload new Entity
Left click this link button to start the process of uploading new record entity to the selected table Container. When you click this link button, the Edit Entity Manager form appears where you can edit the record. If you do update the record there, all pages are preserved here.
Hyper-link:
Set Data Filter
Left click this link button to start the process of building a WCF Data filter to limit the entities returned, using a query builder. When you click this link button, the Query Builder Manager form appears where you can build the filter.

If you do create a filter there, the filter is written into the adjacent text box and is valid for any table you select. If you know the syntax, you can type your own filter into the text box
Text box:
WCF Data
Query Filter

Displays the currently built WCF (Windows Communication Foundation) Data filter to limit records returned. Enter new or update existing filter (for example: PartitionKey eq 'AzureMate' and RowKey eq 'Softhard Solutions').

After exiting the text box, you can either click the Run Filter hyper-link button to run the entered query filter, if a table is selected, or click on a Table on the Tree-View to run the filter automatically.

Important Note
After you used the currently built filter on a Table, it may not pertain to a next Table you select. Whichever Table you select, the filter is active on it. Always be aware of this fact.

Hyper-link:
Run Filter
Left click this link button to start the process of running the entered query filter if a table is selected. When you click this link button and a table is selected, the query is run against the current table and results (if any) are shown.
Button:
Form Settings
Left click this button to start the process of applying various settings to this form. When you click this button, Explore Tables Settings Manager form appears where you can set your pagination settings.
Button:
Next Page of
Entities
Left click this button to start the process of retrieving the next page of available record entities from the currently selected Table Container. When you click this button, the next page of available Entities is added to the display. This button is Disabled if there are no more pages available.
Hyper-link:
Select All Items
Left click this link button to start the process of selecting all the items in the List-View. When you click this link button, all items in the List-View are selected and you can then right click on the selection and review or delete it.
Button:
Save Entities
When you are ready, left click this Save Button to Copy the contents of the entities into a .csv (Comma Separated Values) file, which then can be used in your spreadsheets. If there are any selected records, only those are saved, otherwise all records (contained in the List View) are saved.

A file name is generated by your system and used in creating, or overwriting if it exists, a text file with the contents of the selected entities and put into sub folder \CsvFiles (created if it does not exist) of your runtime folder.

Since the file name is a gibberish, you should rename the file to a more understanding name. If the entities are successfully copied, a Windows Notepad pops up showing the records. If there are no entities, this button is Disabled.
Top of Page
What Next
Install 64 bit AzureMate Desktop Application (for Windows 7, 8, 10 or higher) for 30 Days Operations Free Trial. After this period, register your installed copy of AzureMate and pay one time, low AUD$195.00 donation. Any updates and new releases of AzureMate will come to you free automatically.

AzureMate free trial

Go ahead, open an azure storage account and try AzureMate and see what it can do for your business data. Try AzureMate Desktop Application Software operations free of any charge for 30 Days. Before you create an account and install AzureMate, please read our Terms and Conditions of Use of our websites and also our Privacy Policy Statement.


After clicking this button, AzureMateSetup.exe installer file is downloaded to your system. Depending on your browser (some only allow saving a file, some both, saving or running it), any installation involves downloading the AzureMateSetup.exe installer file and running it on your system to CHECK for any prerequisites and if any are missing, attempt to install them first, and complete the installation. If your browser allows you to run the file, use it as you do not need it saved, most save the file in your user Downloads folder from where you can run it.