Welcome to Telelogic Product Support
  Home Downloads Knowledgebase Case Tracking Licensing Help Telelogic Passport
Telelogic SYNERGY (steve huntington)
Decrease font size
Increase font size
Topic Title: delimited file out of CS4.2 UNIX?
Topic Summary:
Created On: 10-Jul-2003 21:16
Status: Read Only
Linear : Threading : Single : Branch
Search Topic Search Topic
Topic Tools Topic Tools
Subscribe to this topic Subscribe to this topic
E-mail this topic to someone. E-mail this topic
Bookmark this topic Bookmark this topic
View similar topics View similar topics
View topic in raw text format. Print this topic.
Answer This question was answered by Terrence Carpenter, on Friday, July 25, 2003 11:22 PM

Answer:
Thanks all!
 10-Jul-2003 21:16
User is offline View Users Profile Print this message


Terrence Carpenter

Posts: 25
Joined: 10-Jul-2003

Hello!
Can I get a delimited file of CRs from CS4.2? I would feed this file into Excel macros to create charts and statistics.

Thanks!

-------------------------
Terry Carpenter
Report this to a Moderator Report this to a Moderator
 24-Jul-2003 23:01
User is offline View Users Profile Print this message


Burt Alcantara

Posts: 1
Joined: 24-Jul-2003

Terry,
To your query, before the -f, add a -u to get rid of the line numbers. After each atribute format add a comma so it looks like:

ccm query "attrval='thisval'" or "attrval2='thatval'" -u -f "%attrval,%attrval2,%attrval3" > /tmp/my_excel_file

The commas will show up in the query result. Of course, a comma embedded in text or numbers will present additional processing.

You can also insert any string value when doing complex queries to easily pick out key values.

-f "My Left Foot:%my_left_foot My Right Hand:%my_right_hand..."

You could use a perl library to get it directly into excel but that's a lot more complicated.
Burt
Report this to a Moderator Report this to a Moderator
 25-Jul-2003 09:45
User is offline View Users Profile Print this message


Pierre Guillet

Posts: 21
Joined: 4-Jul-2003

Hi all,
If you want to use directly a CM Session to extract Change Requests:
- Don't forget to modify the date format (CCM_DATETIME_FMT env variable) before launching the session,
- Add a double quote on String fields to avoid Excel using characters inside the delimited string (attribute delimiter can appearin the text)
- Filter the query result (if attribute is not created, <void> is returned as value)

See the attached example




-------------------------
Pierre Guillet
Report this to a Moderator Report this to a Moderator
 25-Jul-2003 23:22
User is offline View Users Profile Print this message


Terrence Carpenter

Posts: 25
Joined: 10-Jul-2003

Answer Answer
Thanks all!

-------------------------
Terry Carpenter
Report this to a Moderator Report this to a Moderator
Statistics
20925 users are registered to the Telelogic SYNERGY forum.
There are currently 1 users logged in.
The most users ever online was 15 on 15-Jan-2009 at 15:34.
There are currently 0 guests browsing this forum, which makes a total of 1 users using this forum.
You have posted 0 messages to this forum. 0 overall.

FuseTalk Standard Edition v3.2 - © 1999-2009 FuseTalk Inc. All rights reserved.