CW 2.6 - UserTracking Export - Semicolon only field delimiter?

steve.sobot · ‎11-27-2008

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?

Joe Clarke · ‎11-27-2008

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 · ‎11-28-2008

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 · ‎11-28-2008

Yes, as that is the column delimiter.

steve.sobot · ‎12-02-2008

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.