CW 2.6 - UserTracking Export - Semicolon only field delimiter?

Unanswered Question
Nov 27th, 2008
User Badges:

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?

  • 1
  • 2
  • 3
  • 4
  • 5
Overall Rating: 0 (0 ratings)
Loading.
Joe Clarke Thu, 11/27/2008 - 09:42
User Badges:
  • Cisco Employee,
  • Hall of Fame,

    Founding Member

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?

steve.sobot Fri, 11/28/2008 - 08:44
User Badges:

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?

Joe Clarke Fri, 11/28/2008 - 10:03
User Badges:
  • Cisco Employee,
  • Hall of Fame,

    Founding Member

Yes, as that is the column delimiter.

steve.sobot Tue, 12/02/2008 - 06:54
User Badges:

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.

Actions

This Discussion