The community will be in read-only from Tuesday 11:59pm (PST) to Wednesday 7:30am (PST)
The community will be in read-only from Tuesday 11:59pm (PST) to Wednesday 7:30am (PST)
Service Desk Practitioners Forum
cancel
Showing results for 
Search instead for 
Did you mean: 

Create Classification List (tree) from file

SOLVED
Go to solution
Highlighted
Marco Antonio G
Regular Collector

Create Classification List (tree) from file

Greetings...I was wondering if it is at all possible to build the contents of the Classification (for Service Calls) list by importing from a specially formatted file (i.e, a TEXT, Excel Spreadsheet, etc.)?
6 REPLIES
George M. Meneg
Honored Contributor

Re: Create Classification List (tree) from file

Hello Marco Antonio,

Yes, you can import classification (as almost any other code) through data exchange.
menes fhtagn
Marco Antonio G
Regular Collector

Re: Create Classification List (tree) from file

Great! But is it possible to import the actual tree structure as well?

How would I go about representing this in an excel spreadsheet so that when the Tree is ceated the codes are distributed correctly in heir correct levels?
George M. Meneg
Honored Contributor
Solution

Re: Create Classification List (tree) from file

Hello,

This is quite simple. A column will hold the classification, the other the classification parent.

Construct the excel in such way that the classification with parents to be in the bottom.

For example if you have this structure
A
..B
....C
..D
..E
..G
....H

Your excel should be like
A
B
D
E
G
B A
C B
H G
menes fhtagn
Marco Antonio G
Regular Collector

Re: Create Classification List (tree) from file

THanks buddy! I understand what you're proposing...is this easy enough to map out in the Data Exchange?
George M. Meneg
Honored Contributor

Re: Create Classification List (tree) from file

Hello Marco,

Yes, this is very easy. Both mapping and ini files would be fairy simple for this task. If you have any difficulties just drop a note and I (or any other member of this community) will help you.
menes fhtagn
Marco Antonio G
Regular Collector

Re: Create Classification List (tree) from file

Thanks....I'll have a go at it and see how it works!
//Add this to "OnDomLoad" event