How can I setup "Dependent on field" when importing Category and Subcategory?

[Kento Takahashi]

Hi all,

I would like to import Category and Subcategory of Incident by importing Excel sheet.

How can I map Category and Subcategory?

Excel sheet is like below.

Category	Subcategory
Category1	Subcategory1
Category1	Subcategory2
Category2	Subcategory3
Category2	Subcategory4

Thanks

[Vishal Khandve]

create two excel- one for category and import it in sys_choice table.(go to sys_choice table list view> right click>import> add excel> upadet > preview> complete import)

create another excel for subcategory and import in sys_choice table.(same for subcategory)

Thank you,

vishal

[User177031 · Accepted solution]

Hi Kento,

1. You need to import the Category in one excel sheet.

2. Then copy the choices of category and map them to related sub category on dependent field in the second excel sheet.

3. Import the second excel sheet once you map them to subcategory in excel sheet.

Also make sure Sub category field is set as dependent to Category on dictionary form.

Refer to attached file.

[Rahul Kumar17]

hi

Yes you can do this. Steps for Importing the Subcategories are mentioned below:-

1) Got to System Definition -> Choice Lists

2) Right click on the List and select Import

3) You will be redirected to 'Import external data into Choice' window. Select 'Insert' value in the 'Insert or Update' field and then click on the 'Create Excel Template' button.

4) Download the sys_choice.xls and fill up the sheet. For Example: -

5) Choose the filled sys_choice.xls file and click on 'Upload Data' button.

6) Click on 'Preview Imported Data' button.

7) Click on 'Complete Import' button.

😎 Once import is completely done then enter the Table name.   I chose 'incident' table.

9) Check the relevant form. Since I had chosen 'incident' table in Step 8 so I am checking Incident form. In step 4, the Dependent Value in the xls is 'hardware' so I am selecting Category as Hardware. Then check the Subcategories i.e. Test SubCategory100 and so on as per the column 'Label' in the xls in Step 4.

Likewise, you can import Categories. Just leave the Dependent Value column as <blank> in the XLS on Step 4.

Thanks