equipment browser export

[DCIM_Support]

Hi, when i export from the equipment browser into excel, (csv), i have some data that splits onto 2 x lines. This seems to be completely random. is there a reason for this? or anyway i can stop this?

(CID:93193599)

[DCIM_Support]

Can you post a screenshot of both the equipment browser and the data in excel?

(CID:93193610)

[DCIM_Support]

What version of Data Center Operation do you use? Please provide a CSV file that demonstrates the problem. You may remove lines before and after the problematic data. You may also anonymize the data (e.g. use "a" for letters and "1" for digits).

(CID:93193687)

[DCIM_Support]

aaaaaa aaaa 11/11/11;"aaa-Aaa-11";"Aaa";"aa111111aa ;";1111";"";"";"";"Aaa11aa";"aaaaaaa aAaaAaa";"aaaaaaaaaaa a1111 aaaaaaaaa";"Aaaaa111111a";"11";"aaaaaaaa aaaa";"";"1";"1111";"";"a-1/aaa-Aaa-11/aA11a/aaaaaaaa aaaa/aaaaa 11/aaaaaa aaaa aaaaaa/aaaaaaa/aaaaaaaaa aa/";""; 11/11/11;"aaaAA11";"Aaaa";"aaAa111111111 ;";11";"";"";"";"Aaa11aaaa";"AaaA";"aaa 111aa";"aaaA111111";"1";"aaaaaaaa aaaa";"";"1";"11";"";"a-1/aaaAA11/aA11a/aaaaaaaa aaaa/aaaaa 11/aaaaaa aaaa aaaaaa/aaaaaaa/aaaaaaaaa aa/";""; ;"aaa-Aaa-1";"Aaa";"aaaaa111111111 ;";111";"";"";"";"Aaa11aa";"aaa";"aa1-111 aAa";"aaa-Aaa-1a1";"1";"aaaaaaaa aaaa";"a11";"1";"111";"11111";"a-1/aaa-Aaa-1/aA11a/aaaaaaaa aaaa/aaaaa 11/aaaaaa aaaa aaaaaa/aaaaaaa/aaaaaaaaa aa/";""; 11/11/11;"aaaa11";"Aaa";"aaa1111aaa ;";1";"";"";"";"Aaa11aa";"aaaaaaa aAaaAaa";"aaaaaaaa aa111a a1";"AaaaaAaaaaaa";"";"aaaaaaaa aaaa";"";"";"1";"";"11/Aaaaa111111a/a-1/aaaa11/aA11a/aaaaaaaa aaaa/aaaaa 11/aaaaaa aaaa aaaaaa/aaaaaaa/aaaaaaaaa aa/";"";

(CID:93193705)

[DCIM_Support]

I have contacted Pete by email to receive the CSV content in a better way. This question will be updated with our findings.

(CID:93193711)

[DCIM_Support]

It turns out that Excel (at least 2007 and 2013) on Windows has problems with newlines inside cells in CSV files (the data delimited by semicolon). Importing the same CSV files in e.g. Excel 2011 for Mac and LibreOffice Calc 4.2 on Ubuntu works correctly.

For now, you have three options:

1. Avoid newlines in your data to be exported (e.g. no newlines in custom properties).
2. Do not use Excel on Windows to import the data.
3. Edit the exported CSV file and remove newlines inside cells before opening the file in Excel on Windows.

We will investigate this further to try to come up with a workaround in a new version of Data Center Operation.

Update: DCO 7.4.5 includes a new preference that allows you to select whether or not to include newlines/line breaks in the CSV file.

(CID:93193859)

[DCIM_Support]

This question is closed for comments. You're welcome to start a new topic if you have further comments on this issue.