Import/Expot ITSM 3.02

[yuri0001]

Good afternoon, colleagues!
Created the CI in the CMDB made a template for export. Export 1 row.
Created a line in the image exported, has changed its data and tried to import.
Received in the system log lines like
Wed Apr 20 15:54:25 2011 notice OTRS-CGI-10 Last processed line number of import file: 1
Wed Apr 20 15:54:25 2011 notice OTRS-CGI-10 Import of a ITSMConfigItem records: 1 failed, 0 succeeded
Wed Apr 20 15:54:25 2011 error OTRS-CGI-10 Can't import entity 1: Identifier field is empty
Nothing was imported.
Questions:
1. In line with the error log - what kind of an empty field ID speech. How can this be connected with the column "ID" in the definition of the template in step 4 - "daw" against each field in the template. I saw this as an opportunity to export the header row of fields, but nothing of the sort not seen.
2. Should there be a line in the header file to import?
3. What does the parameter - Empty fields indicate that the current values ​​are kept:?
4. That must be encoding field in step 3. Firstly it is a text and, accordingly, as it correctly stated. Ask the UTF-8. When opened in Excel - nonreadable in russian. If I had called .txt, as in the report output when loaded into Excel see everything correctly. Or Ineed to specify the correct encoding, but how had I called it correctly?
Refuse my bad English

[Wolfgangf]

Yuri,

can you show us your export definition please?
1) you need to have one column in the export marked as "Identifier" acting as a unique key for searching the CI; typically something like "Name" or "Number"
2) no header line required / allowed
3) means: if you do not enter a value in this field(eg "", the existing value will not be changed
4) i'd suggest "UTF-8" encoding

hope this helps

[yuri0001]

Yuri,

can you show us your export definition please?
1) you need to have one column in the export marked as "Identifier" acting as a unique key for searching the CI; typically something like "Name" or "Number"
2) no header line required / allowed
3) means: if you do not enter a value in this field(eg "", the existing value will not be changed
4) i'd suggest "UTF-8" encoding

hope this helps

I'll tried again? marked first column "Number" as "Identifier" - result nothing upload with errors in log. See attachment.
Thanks for your replies!

[yuri0001]

Views?

[yuri0001]

Found the cause of the error message. The problem was that if the export to CSV to export the records were empty fields, they in exported file .CSV displayed as two characters (ie, two double quotes). after the discovery in Excel and saving it after adding a record or even without adding - quote missing and between delimiters (;) - nothing. This gives the input format error when trying to import. If in the exported file to correct these fields (set to blank), then after you save, import is successful.: o
How to deal with it in Excel'e not yet understood. So you probably should not leave empty fields in the template field is a click there a gap. Something like this.

[yuri0001]

It seems that the problem with empty fields - crucial parameter in "Empty fields indicate that the current values ​​are kept:" at the second step of creating / editing template.
But what means the "Maximum number of one element:" the line above?