Cisco Support Community
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements

Welcome to Cisco Support Community. We would love to have your feedback.

For an introduction to the new site, click here. And see here for current known issues.

New Member

LMS 2.5 cmexport query

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

1 ACCEPTED SOLUTION

Accepted Solutions
Red

Re: LMS 2.5 cmexport query

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

4 REPLIES
Red

Re: LMS 2.5 cmexport query

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

New Member

Re: LMS 2.5 cmexport query

Its that easy? Thanks a lot.

Ill give it a try when back at work.

Many Thanks

New Member

Re: LMS 2.5 cmexport query

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

Blue

Re: LMS 2.5 cmexport query

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

116
Views
5
Helpful
4
Replies
CreatePlease login to create content