import xlsx file in cmdb

[Jung Hoon Lee]

hi there I want to ask something about imported excel file
as u know the CMDB is collected information from system information, and before to find this system we are always managed .xlsx file (not csv) in this case, what I do to?

basically, I want to setted import data not only csv
how can I change it

is it only can use csv file?

[creiss]

Hi,

you cannot change it. i-doit only support csv files.

Kind Regards,
Christian

[Jung Hoon Lee]

@creiss hello creiss i hope u have a great day
i hope to ask another one more thing, it is about export data from export wizard,
it is only can exported by .xml file, it is also we can't change to csv or xlsx file? (normally u dont used xlsx file? many of thing is not supported xlsx file i think so)

(it is step3 from export wizard, format : only "xml" can selected)

[creiss]

Hello @jung-hoon-lee,

no problem.

Currently you can only export data via the export wizard in a xml format. If you want to export data as csv you have to use the Report Manager, you can find (only in pro version of i-doit) under "Extras".

Hope you have a great day, too.

Kind Regards,
Christian

[Jung Hoon Lee]

@creiss Thanks to apply me now i feel that u be my teacher very helpful to me thanks

i want to ask another two thing,
one thing is some of page did not can't exported, even if csv file, in that case how can i change it?
(such as "software tab -> object a -> application(folder) -> installation")
(i can't export only this installation tab)

and the another one is some page can't change the column
if i want to add to other column in page, i can use to "configuration list view" but some of page did not cant use "configuration list view" how can i setted it

i will wait to your reply thanks

[creiss]

Hello @jung-hoon-lee,

you cannot export the data directly from the installation view of an application. But if you are using i-doit pro (as I understood because of your usage of the CSV-Import), you can create a report to show these information and export them as a CSV.

I am not sure, if I understood your second question. Did I get it right, that you can only change the list view for a few object types? This should have something to do with your rights, although there is just one general right to do so and no separation between the different object types.

Kind Regards,
Christian

[Jung Hoon Lee]

@creiss dear creiss
hi I always Thanks to u r help

this time i want to ask the "file import"

as you told me i can use to imported csv file in CSV Import(which is in Extra Tab -> CSV Import Tab)

and this picture is our sample data it is made from cmdb web page (picture No.1)

and now i'm try to another thing, Exported csv file and just change Title name, and put in it but it dosen't work
(picture No.2)

in this case how can i solve it?
(it is okay that i'm not useing again same file, i just solve to imported whole of information one of "bit")

[Jung Hoon Lee]

@jung-hoon-lee picture no.2 is here