Import categories

  • 18 November 2020
  • 1 reply
  • 67 views

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

1 reply

Badge
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