![]() |
Telelogic SYNERGY (steve huntington) | ![]() |
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 |
![]() |
![]()
|
![]() Answer: Thanks all! | |
![]() |
|
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 |
|
![]() |
|
![]() |
|
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 |
|
![]() |
|
![]() |
|
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 |
|
![]() |
|
![]() |
|
Thanks all!
------------------------- Terry Carpenter |
|
![]() |
Telelogic SYNERGY
» SYNERGY/Change
»
delimited file out of CS4.2 UNIX?
|
![]() |
FuseTalk Standard Edition v3.2 - © 1999-2009 FuseTalk Inc. All rights reserved.