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

CW 2.6 - UserTracking Export - Semicolon only field delimiter?

When perfoming an Export of the UserTracking report (from CampusManager) a semicolon in a description field messes up the field separation. Are there other characters that should be avoided besides semicolons?

4 REPLIES
Cisco Employee

Re: CW 2.6 - UserTracking Export - Semicolon only field delimite

A semi-colon? The export should be CSV, and fields with embedded commas should be quoted. Can you provide an example of what you're doing, and what you're seeing?

New Member

Re: CW 2.6 - UserTracking Export - Semicolon only field delimite

Thank you for your reply.

This issue was reported by a third party, so there may be some local issues involved.

I have tried a CSV output upon a limited data set, and have not yet been able to reproduce the problem as reported to me. I will investigate further and report back appropriately.

I was informed that fields with embedded semicolons were causing formatting problems when processed by the CSV export function.

Is the comma the only character that needs to be quoted for correct processing?

Cisco Employee

Re: CW 2.6 - UserTracking Export - Semicolon only field delimite

Yes, as that is the column delimiter.

New Member

Re: CW 2.6 - UserTracking Export - Semicolon only field delimite

False alarm...

jclarke, indeed you are correct, the problem has been traced to a local script file working on CampusManager data.

CiscoWorks Export/CSV functionlity works fine (with commas as delimiters).

Thanks for your input, appreciated.

109
Views
0
Helpful
4
Replies
CreatePlease login to create content