[rt-users] Export Missing Fields Break Tabs

2013-06-12 Thread Robert Gabriel 
Greetz,

We have RT 4.0.11 which we love using, thank you.

When we do a search from the CLI like so:

#shell

/opt/rt4/bin/rt ls -o Queue -t ticket -q CoT,GDF,NCPG (Status = new OR
Status = received OR Status = assigned \

OR Status = locating OR Status = offline OR Status = user_leave OR Status =
user_busy OR Status = user_away \

OR Status = attending OR Status = soc_confrm OR Status = seclvl_res) \

-f id,status,queue,subject,CF-Virus Detected,CF-Host
IP,CF-Location,CF-Domain,CF-Number
of events past 7 days, \

CF-Actual Error,CF-Affected User,CF-Pattern,CF-Resolved By,CF-Source
Type,CF-System Type \

report.txt

#shell

upon importing report.txt into a spreadsheet several rows are broken.

It looks like the ticket in question is imported across several rows with
fields being aligned far left.

If we do a spreadsheet from the feed in RT it's all good.

Are there any solutions/workarounds for this?

Could control characters in our tickets be causing problems?

Are there any major differences between feed spreadsheets and CLI output?

Looking at the CLI I don't see any export *.csv options.

Thank you in advance.


-- 
RT Training in Seattle, June 19-20: http://bestpractical.com/training

Re: [rt-users] Export Missing Fields Break Tabs

2013-06-12 Thread Thomas Sibley 
On 06/12/2013 06:10 AM, Robert Gabriel wrote:
 Are there any major differences between feed spreadsheets and CLI output?

Yes, the CLI output does not attempt to be importable by a spreadsheet.


-- 
RT Training in Seattle, June 19-20: http://bestpractical.com/training

Re: [rt-users] Export Missing Fields Break Tabs

2013-06-12 Thread Robert Gabriel 
On 12 June 2013 18:34, Thomas Sibley t...@bestpractical.com wrote:

 On 06/12/2013 06:10 AM, Robert Gabriel wrote:
  Are there any major differences between feed spreadsheets and CLI output?

 Yes, the CLI output does not attempt to be importable by a spreadsheet.


Thank you, I'll use that as an authoritative argument with my colleagues.


-- 
RT Training in Seattle, June 19-20: http://bestpractical.com/training