[Solved]Import CI after create class definition

[Gonzalo]

Hi!
I create the class definition "Server" to simplify the default CI Computer - type Server. The code is attached. What really interests me is the import of the CI server, but When I try to import launch me an error. The Sistem log describe Need DeplStateID! but my CSV have the Name, Deployment State, and Incident State that I understand that is always requiered. I didn't know what is the problem? I also attached the Export/Import Fields.

Code: Select all

{
        Key => 'processor_cores',
        Name => 'Processor cores',
        Searchable => 1,
        Input => {
            Type => 'Text',
            Size => 50,
            MaxLength => 100,
        },
    },
    {
        Key => 'processor_speed',
        Name => 'Processor Speed',
        Input => {
            Type => 'Text',
            Size => 50,
            MaxLength => 100,
        },
        #CountMax => 16,
    },
    {
        Key => 'processor_description',
        Name => 'Processor Description',
        Input => {
            Type => 'TextArea',
        },
    },
    {
        Key => 'memory',
        Name => 'Ram',
        Input => {
            Type => 'Text',
            Size => 50,
            MaxLength => 100,
        },
        #CountMax => 10,
    },
  
{
        Key => 'man_ip_address',
        Name => 'IP Address',
        Input => {
            Type => 'Text',
            Size => 50,
            MaxLength => 100,
            Required => 0,
        },
},
];

Thank you!

[RStraub]

Could you post 1-2 lines of the csv you are importing?

I think what you are trying is to import the Deployment state via string. What OTRS expects is the Deployment-State-ID.

Try this query in your mysql:

Code: Select all

select id,name from general_catalog where general_catalog_class like '%deployment%';

There you'll see the ID for your deployment states, try those instead of the strings.

[Gonzalo]

Hi RStraub!

I found the error, I took the csv from external software (discovery tool) that the csv is with ',' and when I open with Excel I transform in columns to do the import. So I din't know that columns in excel works with ";", that's the error, when OTRS found the first separated value.

Anyway thak you very much to try to find the solution!

Gonzalo