Re: [itsm] OTRS-Import/Export Problem
Hi there! I have a question about that subject. Which one is exactly the DeplStateID? I added Production on the DeplStateID and it still said Need DeplStateID! Thanks and regards María Alejandra Piedra Unidad de Informática y Sistemas de Información IICA (506) 2216-0171 Alejandra.Piedra@iica.int _________________________________________________________________ Hotmail is redefining busy with tools for the New Busy. Get more from your inbox. http://www.windowslive.com/campaign/thenewbusy?ocid=PID28326::T:WLMTAGL:ON:W...
Hey Ale,
That's weird. There are three fields that are mandatory for each CI: name,
deployment state and incident state. The last two are definitions you have
on your General Catalog. When bulk importing, include them in your CSV and
make sure your entry matches exactly the original name of the state.
Try first with a single CI till your import works, remember not to include
the titles of each column when importing your spreadsheet to CSV ;)
Leonardo Certuche
www.itconsultores.com.co
On 26 April 2010 12:12, Maria Alejandra Piedra
Hi there!
I have a question about that subject. Which one is exactly the DeplStateID?
I added Production on the DeplStateID and it still said Need DeplStateID!
Thanks and regards
María Alejandra Piedra
Unidad de Informática y Sistemas de Información
IICA (506) 2216-0171
Alejandra.Piedra@iica.int
------------------------------ Hotmail is redefining busy with tools for the New Busy. Get more from your inbox. See how.http://www.windowslive.com/campaign/thenewbusy?ocid=PID28326::T:WLMTAGL:ON:W...
--------------------------------------------------------------------- OTRS mailing list: itsm - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/itsm To unsubscribe: http://lists.otrs.org/mailman/listinfo/itsm
NEW! ENTERPRISE SUBSCRIPTION - Get more information NOW! http://www.otrs.com/en/support/enterprise-subscription/
Hi, On 26.04.2010, at 19:12, Maria Alejandra Piedra wrote:
I have a question about that subject. Which one is exactly the DeplStateID? I added Production on the DeplStateID and it still said Need DeplStateID!
could you post a part of your import file? Nils Leideck -- Nils Leideck Senior Consultant nils.leideck@leidex.net nils.leideck@otrs.com http://webint.cryptonode.de / a Fractal project
Hi Nils! It goes something like this: Fenix Production Operational Dell I don't know what Deployment state ID I have to add. Thanks and regards! Maria Alejandra Piedra From: nils.leideck@leidex.net Date: Mon, 26 Apr 2010 21:16:58 +0200 To: itsm@otrs.org Subject: Re: [itsm] OTRS-Import/Export Problem Hi, On 26.04.2010, at 19:12, Maria Alejandra Piedra wrote:I have a question about that subject. Which one is exactly the DeplStateID?I added Production on the DeplStateID and it still said Need DeplStateID! could you post a part of your import file? Nils Leideck -- Nils Leideck Senior Consultant nils.leideck@leidex.net nils.leideck@otrs.com http://webint.cryptonode.de / a Fractal project _________________________________________________________________ Hotmail has tools for the New Busy. Search, chat and e-mail from your inbox. http://www.windowslive.com/campaign/thenewbusy?ocid=PID28326::T:WLMTAGL:ON:W...
Hi, On 26.04.2010, at 21:25, Maria Alejandra Piedra wrote:
It goes something like this: Fenix Production Operational Dell I don't know what Deployment state ID I have to add.
this looks well ... "Production" is the Deployment State therefor it is the 3rd column in your import file. Please make sure this is configured properly in the import / export definition. Nils Leideck -- Nils Leideck Senior Consultant nils.leideck@leidex.net nils.leideck@otrs.com http://webint.cryptonode.de / a Fractal project
Ok, getting there! Basicaly two questions, the first one is, do I have to add the Number in the import file? And the second one is, in the CSV file, I have every value separated by each column, is this correct or do I have to separate it by commas? Thanks and regards María Alejandra Piedra Unidad de Informática y Sistemas de Información IICA (506) 2216-0171 Alejandra.Piedra@iica.int From: nils.leideck@leidex.net Date: Mon, 26 Apr 2010 21:33:58 +0200 To: itsm@otrs.org Subject: Re: [itsm] OTRS-Import/Export Problem Hi, On 26.04.2010, at 21:25, Maria Alejandra Piedra wrote:It goes something like this: FenixProduction OperationalDellI don't know what Deployment state ID I have to add. this looks well ... "Production" is the Deployment State therefor it is the 3rd column in your import file.Please make sure this is configured properly in the import / export definition. Nils Leideck -- Nils Leideck Senior Consultant nils.leideck@leidex.net nils.leideck@otrs.com http://webint.cryptonode.de / a Fractal project _________________________________________________________________ The New Busy think 9 to 5 is a cute idea. Combine multiple calendars with Hotmail. http://www.windowslive.com/campaign/thenewbusy?tile=multicalendar&ocid=PID28...
Hi Ale,
To build your CSV file you can use an spreadsheet application such as
microsoft excel or openoffice calc. There you can put your CI attibutes on
each column and once you're done yo can save it as CSV and define if it's
separated by "," or ";"
Then you go to the import/export feature and build your import definition
accordingly
Best of lucks,
Leonardo Certuche
On 26 April 2010 15:08, Maria Alejandra Piedra
Ok, getting there!
Basicaly two questions, the first one is, do I have to add the Number in the import file? And the second one is, in the CSV file, I have every value separated by each column, is this correct or do I have to separate it by commas?
Thanks and regards
María Alejandra Piedra
Unidad de Informática y Sistemas de Información
IICA (506) 2216-0171
Alejandra.Piedra@iica.int
------------------------------ From: nils.leideck@leidex.net Date: Mon, 26 Apr 2010 21:33:58 +0200
To: itsm@otrs.org Subject: Re: [itsm] OTRS-Import/Export Problem
Hi,
On 26.04.2010, at 21:25, Maria Alejandra Piedra wrote:
It goes something like this: FenixProduction OperationalDellI don't know what Deployment state ID I have to add.
this looks well ... "Production" is the Deployment State therefor it is the 3rd column in your import file. Please make sure this is configured properly in the import / export definition.
Nils Leideck
-- Nils Leideck Senior Consultant
nils.leideck@leidex.net nils.leideck@otrs.com
http://webint.cryptonode.de / a Fractal project
------------------------------ The New Busy think 9 to 5 is a cute idea. Combine multiple calendars with Hotmail. Get busy.http://www.windowslive.com/campaign/thenewbusy?tile=multicalendar&ocid=PID28...
--------------------------------------------------------------------- OTRS mailing list: itsm - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/itsm To unsubscribe: http://lists.otrs.org/mailman/listinfo/itsm
NEW! ENTERPRISE SUBSCRIPTION - Get more information NOW! http://www.otrs.com/en/support/enterprise-subscription/
Hey there!
Finally got it to work! But just one final question, how do I do to add more than one value to a field.
For instance, I need to add several Hard Disks for a single Server.
Thank you so much for all the help!
María
Alejandra Piedra
Unidad
de Informática y Sistemas de Información
IICA
(506) 2216-0171
Alejandra.Piedra@iica.int
From: leonardo.certuche@itconsultores.com.co
Date: Mon, 26 Apr 2010 15:24:32 -0500
To: itsm@otrs.org
Subject: Re: [itsm] OTRS-Import/Export Problem
Hi Ale,
To build your CSV file you can use an spreadsheet application such as microsoft excel or openoffice calc. There you can put your CI attibutes on each column and once you're done yo can save it as CSV and define if it's separated by "," or ";"
Then you go to the import/export feature and build your import definition accordingly
Best of lucks,
Leonardo Certuche
On 26 April 2010 15:08, Maria Alejandra Piedra
participants (3)
-
Leonardo Certuche -
Maria Alejandra Piedra -
Nils Leideck - ITSM