Successful publication of tables using Tables module in MapMint

[omshinde]

Hello all,
After publishing the Mumbai (India) data using MapMint., I tried to publish the tables associated with the data using the Tables module of MapMint. The compiled points are included here for reference.

The MapMint Tables module can be accessed by http://localhost/ui/Tables_bs.

After accessing the above link on your local machine you will obtain an interface as presented below.

Note: Initially, the screen will appear without any tables selected.

But, before moving to the functioning of Tables module, we need to setup the Themes module. The themes saved using Themes module will be used in viewing tables.

The Themes module can be accessed by following the link: http://localhost/ui/Themes_bs .

Initially, the themes module will look as:

A new theme with desired properties can be saved. For first publication, I have not selected any option for parent theme. Also, the Group shall be selected as public. After saving the theme, we can move again to the Tables module.

Now, the tables can be added by using the + favicon shown at the top. The schema and table name should be selected. A name should be chosen for the Table to be viewed. For creating this issue, I have created a new table in the database by the name demo_issue_tables.

The output on the screen before and after adding the table are as follows:

• Before

• After

As we can see that after adding the table, it becomes visible on the screen. The right half of the screen contains 5 sections- Parameters, Information, View, Edit, and Report.

1. Parameters: This tab includes Name, Description, and Table (Schemas and Tables) information. I did not make any changes in this section and saved it.

2. Informations: This tab shows the information about the table values.

3. View: The view settings are important for publishing tables. Following image shows the settings which can be used.

Note:

• The clause should not be left empty. For instance, I had filled it with true.

• The visible checkbox should be checked. If this is not the case, then the view will not be visible.

• In Groups, any option other than public should be selected. In my case it is admin.

• More than 1 themes could also be selected at a time. Only those themes which are saved in the Themes module will be visible for selection.
  Then the Table configuration needs to be selected. After saving, the tables can be accessed by following the link: http://localhost/ui/public/tables/ .

After selecting the Table given in the left-navigation bar, we can see the Demo view table.

But, we don't have any data in it. So, let's add some data in the demo_issue_table. For this, the Edit tab will be used in the Tables module.

4. Edit: I have used the settings shown in the below image.

After saving and again accessing localhost/ui/public/tables/, we will see something like this.

After using ADD option, I was successfully able to add data to the table.

I have not used the Report tab up till now.

Some issues which I faced are presented below. They should be avoided for successful publication of the tables.

1. Please check that you should have only 1 admin and 1 public groups.

2. Also, the mm_tables.p_view_groups, which stores vid and gid should be connected to admin group only (group other than Public). If you face this issue, then try to print the query (req) and the JSON array (res) in the file /home/src/mapmint/mapmint-ui/templates/preview/tables.tmpl. This helped a lot in understanding the issue.

I hope this will help in publishing tables using the Tables module of MapMint.