![]() |
Telelogic DOORS (steve huntington) | ![]() |
new topic :
profile :
search :
help :
dashboard :
calendar :
home
|
||
Latest News:
|
|
Topic Title: Help Import CSV Topic Summary: Created On: 18-Dec-2006 18:29 Status: Post and Reply |
Linear : Threading : Single : Branch |
![]() |
![]()
|
![]() |
|||||
We are doing a massive CSV export from one database and importing it into existing modules and objects in another database.
Does anyone know how in DXL I can iniate the Import Spreadsheet native dialog, defaulting the name of the import file to one chosen by the DXL? That is, we run my script that uses the name of the current module to determine which CSV to import, it then activates the dialog and sets the file name; then my DXL ends allowing the user to simply [Import]" - Louie |
|||||
![]() |
|||||
![]() |
|||||
That Spreadsheet import script is in
C:\Program Files\Telelogic\DOORS_8.1\lib\dxl\standard\import\commas.dxl You can modify it as you see fit. Just be sure to move it elsewhere so you don't mess up the one that came with DOORS. You could add some code into it to just get the module name you're running it from then set the initial value of the fileName DBE in it to the value you want, then you'll just have to hit "Import" to run it. Or you can completely rewrite things to not even use the dialog box. DBE fileName(DB box, [string label], [string initFileName], [string extension], [string description], [bool readOnly]) Things with [] around them are optional. So once you figure out what module you're in and what file you'd like to import, just set the initFileName field to that value. I'm working with it as well currently to build a little tool that does a number of things in sequence instead of having several scripts to do each piece. If you ask me they made it read values from the dialog box far too many times. I wish you could just call the function that passes the selections from the dialog box to the rest of the script. But unfortunately the dialog box has to be active for it to work. You can set the options you want anyway and just realize the dialog box without actually interacting with it though. The function that starts the main bulk of the work is the impSprParseCB function. ------------------------- David Pechacek AAI Services Textron dpechacek@sc-aaicorp.com David.Pechacek@gmail.com |
|||||
![]() |
|||||
![]() |
|||||
As an extension to this discussion:
I have csv data that has been updated from DOORS data. Do you know a way to use dxl restore the data to DOORS and retain previoius (or new) Object Level? I guess this will mean some clever "create object after/create object below " commands. I have looked at the comma.dxl script but failed to totally understand. I'm a systems engineer not software. Regards Phil Allen |
|||||
![]() |
|||||
![]() |
|||||
I have attached a DOORS Tech Tip with the dxl code explaining how to recreate the levels after import.
------------------------- Karen Hidalgo<BR>Northrop Grumman - TASC<BR>karen.hidalgo@ngc.com |
|||||
![]() |
|||||
![]() |
|||||
What exactly is DOORS Tech Tip? Is this a publication published by Telelogic, or just simply a document you created on your own Karen?
------------------------- pete.kowalski(at)motorola.com |
|||||
![]() |
|||||
![]() |
|||||
It was actually something I received from my Telelogic rep a few years ago. I have some other ones, but I am not sure of their history or if they are developed/maintained by Telelogic. Sorry I couldn't be more help.
------------------------- Karen Hidalgo<BR>Northrop Grumman - TASC<BR>karen.hidalgo@ngc.com |
|||||
![]() |
Telelogic DOORS
» DXL Exchange
»
Help Import CSV
|
![]() |
FuseTalk Standard Edition v3.2 - © 1999-2009 FuseTalk Inc. All rights reserved.