Welcome to Telelogic Product Support
  Home Downloads Knowledgebase Case Tracking Licensing Help Telelogic Passport
Telelogic DOORS (steve huntington)
Decrease font size
Increase font size
Topic Title: CSV Export
Topic Summary:
Created On: 9-Feb-2007 09:39
Status: Post and Reply
Linear : Threading : Single : Branch
1 2 Next Last unread
Search Topic Search Topic
Topic Tools Topic Tools
Quick Reply Quick Reply
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.
 9-Feb-2007 09:39
User is offline View Users Profile Print this message


Mussie Woldemicael

Posts: 95
Joined: 12-Sep-2006

Is there a possibility to get all the attributes of a module without
explicitly calling or knowing the attributes?
I need it for an CSV export!

cheers Mussie

Edited: 9-Feb-2007 at 09:39 by Mussie Woldemicael
Report this to a Moderator Report this to a Moderator
 9-Feb-2007 11:39
User is offline View Users Profile Print this message


Pekka Mäkinen

Posts: 276
Joined: 18-Mar-2004

From DXL Help:

for attribute definition in module
Syntax for ad in module do {
...
}

where:

ad is a variable of type AttrDef
module is a variable of type Module


Operation
Assigns the attribute definition ad to be each successive definition present in the module m, provided the definition applies to either modules or objects.

Example

AttrDef ad
for ad in current Module do {
print "Attribute: " ad.name "\n"
}

-------------------------
Pekka.Makinen@softqa.fi
SoftQA Oy -http://www.softqa.fi/
Report this to a Moderator Report this to a Moderator
 9-Feb-2007 12:27
User is offline View Users Profile Print this message


Reik Schroeder

Posts: 361
Joined: 28-Jul-2003

Hi Mussie,

alternatively you could use one of the following statements:
for module attributes in module
Syntax
for attribute in attributes(module) do {
...
}
where:

attribute is a string variable
module is a variable of type Module


Operation
Assigns the string attribute to be each successive attribute that is defined for module.

Example
string modAttrName
for modAttrName in attributes (current Module) do
print modAttrName "\n"


for object attributes in module
Syntax
for objAttrName in module do {
...
}
where:

objAttrName is a string variable
module is a variable of type Module


Operation
Assigns the string objAttrName to be each successive attribute that is defined for objects in module.

Example
string objAttrName
for objAttrName in (current Module) do print objAttrName "\n"


Also copied from DXL reference manual.

But then you will not be able to distinghish between attributes of diffrent types and between system and selfdefined ones.

Greetings
Reik

-------------------------
Evosoft GmbH
for Siemens Industry Sector


Berlin, Germany
Report this to a Moderator Report this to a Moderator
 9-Feb-2007 13:00
User is offline View Users Profile Print this message


Mussie Woldemicael

Posts: 95
Joined: 12-Sep-2006

Thanks for the answers!
I already found it in the manual ;-)
I'm just thinking about how to get the data into a CSV file!
If you have ideas I'd welcome any comments on that!

cheers Mussie
Report this to a Moderator Report this to a Moderator
 9-Feb-2007 13:21
User is offline View Users Profile Print this message


Tony Goodman

Posts: 1098
Joined: 12-Sep-2002

Try this.

-------------------------
Tony Goodman
http://www.smartdxl.com
Report this to a Moderator Report this to a Moderator
 9-Feb-2007 14:18
User is offline View Users Profile Print this message


Mussie Woldemicael

Posts: 95
Joined: 12-Sep-2006

How do I start this script??

Report this to a Moderator Report this to a Moderator
 9-Feb-2007 15:27
User is offline View Users Profile Print this message


Tony Goodman

Posts: 1098
Joined: 12-Sep-2002

Add the following to the bottom of the file:

batchCsvExport(fullName current Module, "c:/temp/report.csv")

-------------------------
Tony Goodman
http://www.smartdxl.com

Edited: 9-Feb-2007 at 15:27 by Tony Goodman
Report this to a Moderator Report this to a Moderator
 9-Feb-2007 15:45
User is offline View Users Profile Print this message


David Pechacek

Posts: 674
Joined: 5-Dec-2006

Export to a spreadsheet, choose comma separated, include column headings.

-------------------------
David Pechacek
AAI Services Textron
dpechacek@sc-aaicorp.com
David.Pechacek@gmail.com
Report this to a Moderator Report this to a Moderator
 12-Feb-2007 08:47
User is offline View Users Profile Print this message


Mussie Woldemicael

Posts: 95
Joined: 12-Sep-2006

Is there a possibility to identify the module via foldername and module name?

cheers,
Mussie
Report this to a Moderator Report this to a Moderator
 12-Feb-2007 10:45
User is offline View Users Profile Print this message


Mussie Woldemicael

Posts: 95
Joined: 12-Sep-2006

Ok I found a way to path the foldername and modulename!
The only problem I've now is how to start the script from batchmode?
If someone knows how to do that I'd welcome any comments!!

cheers,
Mussie
Report this to a Moderator Report this to a Moderator
 12-Feb-2007 11:49
User is offline View Users Profile Print this message


Mussie Woldemicael

Posts: 95
Joined: 12-Sep-2006

I found this in the manual "doors -batch dxlfile" for starting doors from prompt but unfortunately I don't know how to pass the password and username!?
Any idea?

cheers Mussie 
Report this to a Moderator Report this to a Moderator
 12-Feb-2007 12:02
User is offline View Users Profile Print this message


Reik Schroeder

Posts: 361
Joined: 28-Jul-2003

Hi Mussi,

therefore the parameters -u and -P are used.

Please refer to Doors Manual (Index: Command line switches) in chapter "Summary of command line switches" for more information.

Greetings
Reik

-------------------------
Evosoft GmbH
for Siemens Industry Sector


Berlin, Germany
Report this to a Moderator Report this to a Moderator
 12-Feb-2007 12:10
User is offline View Users Profile Print this message


Mussie Woldemicael

Posts: 95
Joined: 12-Sep-2006

Which Manual are you using? I can't find that chapter?
Report this to a Moderator Report this to a Moderator
 12-Feb-2007 12:23
User is offline View Users Profile Print this message


Mussie Woldemicael

Posts: 95
Joined: 12-Sep-2006

Found it! :-)
Report this to a Moderator Report this to a Moderator
 14-Feb-2007 12:46
User is offline View Users Profile Print this message


Mussie Woldemicael

Posts: 95
Joined: 12-Sep-2006

Is there a possibility to pass arguments for DXL functions via prompt to Doors?

cheers,
Mussie
Report this to a Moderator Report this to a Moderator
 14-Feb-2007 13:20
User is offline View Users Profile Print this message


Pekka Mäkinen

Posts: 276
Joined: 18-Mar-2004

Not to my knowledge. But DOORS can of course read a configuration file or a registry value, search these in the DXL help.

-------------------------
Pekka.Makinen@softqa.fi
SoftQA Oy -http://www.softqa.fi/
Report this to a Moderator Report this to a Moderator
 14-Feb-2007 13:28
User is offline View Users Profile Print this message


Reik Schroeder

Posts: 361
Joined: 28-Jul-2003

Hi Mussi,

may be you could use environment variables to pass parameters to your scripts?!

They can be accessed from Doors via getenv function....

Greetings
Reik

-------------------------
Evosoft GmbH
for Siemens Industry Sector


Berlin, Germany
Report this to a Moderator Report this to a Moderator
 16-Feb-2007 07:45
User is offline View Users Profile Print this message


Mussie Woldemicael

Posts: 95
Joined: 12-Sep-2006

Hello DXLiens,
is there a possibility to export a certain baseline?

cheers,
Mussie
Report this to a Moderator Report this to a Moderator
 16-Feb-2007 08:38
User is offline View Users Profile Print this message


Reik Schroeder

Posts: 361
Joined: 28-Jul-2003

Hi Mussi,

you should change line

m = read(mName, false)

into

m = load (moduleVersion (module mName , baseline (1, 0, "")), false);

where 1, 0, "" is the major, minor, suffix of the Baseline you whant to open ...

I hope that helps you a little bit ...

Greetings
Reik

-------------------------
Evosoft GmbH
for Siemens Industry Sector


Berlin, Germany
Report this to a Moderator Report this to a Moderator
 16-Feb-2007 12:15
User is offline View Users Profile Print this message


Mussie Woldemicael

Posts: 95
Joined: 12-Sep-2006

Hi Reik,
thanks for the answer I just found it out an hour ago myself!
I did not look in the forum for a while but I appreciate your answer!

best regards,
Mussie

Report this to a Moderator Report this to a Moderator
Telelogic DOORS » DXL Exchange » CSV Export

1 2 Next Last unread
Topic Tools Topic Tools
Statistics
20925 users are registered to the Telelogic DOORS forum.
There are currently 1 users logged in.
The most users ever online was 15 on 15-Jan-2009 at 16:36.
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.