LMS 2.5 cmexport query

[nickmaiolo]

I have read the help section and as many manuals i can find. Is there a way to export the user tracking database into a text file instead of an xml file like older versions have done?

I had a process of changing the data from a text file and importing it someplace else. We are looking to migrate to LMS 2.5 on our live systems soon and we need the same functionality as now but xml seems a lot harder to work with.

Anyone know of a way to convert it into a tab delimited text file straight from export or afterwards with XSLT?

Any help appreicated

Nick

[nhabib · Accepted solution]

There is a ut command line utility that you may use. It is located in NMSROOT/campus/bin

Here is an example that would export everything on a Solaris box (command is the same on Windows):

cd /opt/CSCOpx/campus/bin

./ut -cli -query all -export /tmp/ut.csv -u admin -p admin

You will get benign error messages such as these:

log4j:ERROR No appenders could be found for category

log4j:ERROR please initialize the log4j system properly

However, the file /tmp/ut.csv will be created

[nickmaiolo]

Its that easy? Thanks a lot.

Ill give it a try when back at work.

Many Thanks

[dainat-bis]

Is this workaraound to get a csv file still possible in the LMS3.0 ?

[yjdabear]

Yeah, right down to the log4j errors. Just try it. It's not like it's going to blow up the LMS install.