Preparation of MDMS Data for Data Loading

This document shows the preparation of the mdms changes be to done for data loading.

Example : Create a json for new ulb and Add required details given.

Eg.

Example:

Steps to create the jsons of GP data -

• The GP data is given in excel format.

• Copy all the GP’s list and make an excel with format given below

• The name and localname is the GP name provided

• The label is always GP and boundaryNum is 1.

• Id is unique for each GP and should be in sequential order.

• Provide a proper format of GP code according to GPname.

• Convert the excel data into json using excel-json online converter.

• Check the format once,change id into string if it is in integer format.

• Add "children": [] for each GP separately after converting to json.

Steps To Create the jsons of Slum data : The slum data is provided in excel format.

• Make an excel with with given format

• Add all the slums in name field

• change the code according to ulb name

• add locality VIL1 according to boundary-data.

• convert the excel data into json using excel to json converter.

• create a folder of a respective tenant and inside it add slum.json file in FSM folder.

5. Adding New Vehicles in VehicleMakeModel Before pushing the vehicle data,new vehicle should be added in mdms.

Eg. new vehicle add

6. Billing-slab pricing preparation For adding the rate slabs(pricing) of vehicles,consider different combination of propertyType , slum and tank capacity.

   2. RESIDENTIAL and RESIDENTIAL.SUB-PROPERTY_TYPE

   3. INSTITUTIONAL and INSTITUTIONAL.SUB-PROPERTY_TYPE

   4. COMMERCIAL and COMMERCIAL.SUB-PROPERTY_TYPE

   5. Sample Data for pricing :

Steps to make billing-slab data: A. Create an excel file in given format

B. Consider all property types and sub-property type present in mdms with slum YES and with slum NO.

C. for capacity 1000L,the pricing is given as

For slum NO :

1. RESIDENTIAL and RESIDENTIAL.SUB-PROPERTY_TYPE - 1000

2. INSTITUTIONAL and INSTITUTIONAL.SUB-PROPERTY_TYPE - 1000

3. COMMERCIAL and COMMERCIAL.SUB-PROPERTY_TYPE - 1000

For slum YES(Per trip Pricing for Slum areas) :

1. RESIDENTIAL and RESIDENTIAL.SUB-PROPERTY_TYPE - 800

2. INSTITUTIONAL and INSTITUTIONAL.SUB-PROPERTY_TYPE - 800

3. COMMERCIAL and COMMERCIAL.SUB-PROPERTY_TYPE - 800

D. for capacity 3000L,the pricing is given as

For slum NO :

1. RESIDENTIAL and RESIDENTIAL.SUB-PROPERTY_TYPE - 2000

2. INSTITUTIONAL and INSTITUTIONAL.SUB-PROPERTY_TYPE - 2000

3. COMMERCIAL and COMMERCIAL.SUB-PROPERTY_TYPE - 3000

For slum YES(Per trip Pricing for Slum areas) :

1. RESIDENTIAL and RESIDENTIAL.SUB-PROPERTY_TYPE - 1500

2. INSTITUTIONAL and INSTITUTIONAL.SUB-PROPERTY_TYPE - 1500

3. COMMERCIAL and COMMERCIAL.SUB-PROPERTY_TYPE - 1500

E. After creating the excel file by considering the combinations,convert the excel file into json.

F. Push the same json file in billing slab api using runner.