We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy.
Unfortunately, activation email could not send to your email. Please try again.

How to handle the columns which are modified at the database in dashboard application?

Sometimes we could have changed the column name at the database after designing the dashboards. In this situation, if you are re-opening the saved dashboard, the modified column name will not be recognized. Hence, to handle this situation, we can manually update the column name in *.sydx file to avoid recreation of dashboards. NOTE: This is a temporary solution for this scenario and soon we will provide feature support for the same. 

In this illustration, consider the older column name as "EmployeeID" and new column name as “Employee-ID".

Follow the below procedure to update the *.sydx file with the renamed column.

1. Rename the *.sydx file extension to *.zip format.

 

Before Edit

cid:image001.png@01D3AED1.7020EC00  

After Edit                cid:image002.png@01D3AED1.7020EC00

 

2. Extract the zip file.

cid:image003.png@01D3AED1.7020EC00

3. Open the "DataSources" folder.

4. Please do the following changes in each data source file which are configured using the renamed column.

  • Select the following tags.

DataSource >> TreeViewSchemaInfo >> Table (Select the appropriate table which has the renamed column) >> Fields >> FieldInfo (Select the appropriate field which is renamed).

 

 

cid:image004.png@01D3AED1.7020EC00

 

    cid:image005.png@01D3AED1.7020EC00

                               

  • In the FieldInfo section, change the value of the below mentioned tags using new column name like below.

For ColumnName tag, change EmployeeID to Employee-ID.

                                              cid:image006.png@01D3AED1.7020EC00

      For Key tag, change [dbo_Employees].[EmployeeID] to [dbo_Employees].[Employee-ID].

                                             cid:image007.png@01D3AED1.7020EC00

                 For PrimaryKeyColumn tag inside Parent tag, change EmployeeID to Employee-ID.

                                                cid:image008.png@01D3AED1.7020EC00

  • For expression fields, copy the older "Key" tag value from "FieldInfo" tag and

use string replace option to replace all that copied value to new value.

Older Value: [dbo_Employees].[EmployeeID]

New Value: [dbo_Employees].[Employee-ID]

                                               

                                                cid:image009.png@01D3AED1.7020EC00                          

5. Next move to the Widgets folder. Open each widget file and replace the older column name with new one, if it exists, like we did in #4 (previous point). 

6. Select the all folders and files and convert it into *.zip file.

cid:image011.png@01D3AED1.7020EC00

 

7. Finally rename the extension from *.zip to *.sydx. Now open the *.sydx file using the dashboard designer applicable and proceed as usual.

 

 

 

Article ID: Published Date: Last Revised Date: Platform: Control:
9108 08/06/2018 08/06/2018 Dashboard Platform Dashboard Datasources
Did you find this information helpful?
Add Comment
You must log in to leave a comment

You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.