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.