Skip to main content
Hello,



we have a following problem.

So we wanted to Import a Excel.csv data to the categories, but we don't know which seperator we need?

With a ; "simicolon" it doesn't work, so can someone help us?



Greetings

Aron
Hi A.Zuidinga,



Here's a sample CSV file:





Category,Sub-Category,Third Level Category,EUP,admin,Incident,Request,Change,Problem,CMDB

cat1,cat1.1,cat1.1.1,Y,Y,Y,Y,Y,Y,Y

cat1,cat1.1,cat1.1.2,Y,Y,Y,N,N,N,N

cat1,cat1.1,cat1.1.3,Y,Y,Y,Y,Y,Y,Y





The settings you can use for the import are:

1. Check the "Do not import the head line (the first line)"

2. Number of fields - 10

3. Read csv file from line number - 1



The list of fields:

1. Category

2. Sub-Category

3. Third Level Category

4. Visible in End User Portal

5. Visible in Admin Portal

6. Incident

7. Request

8. Change

9. Problem

10. CMDB



See the attached files.

Reply