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: Help Import CSV
Topic Summary:
Created On: 18-Dec-2006 18:29
Status: Post and Reply
Linear : Threading : Single : Branch
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.
 18-Dec-2006 18:29
User is offline View Users Profile Print this message


Louie Landale

Posts: 2070
Joined: 12-Sep-2002

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
Report this to a Moderator Report this to a Moderator
 18-Dec-2006 18:57
User is offline View Users Profile Print this message


David Pechacek

Posts: 674
Joined: 5-Dec-2006

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
Report this to a Moderator Report this to a Moderator
 2-Feb-2007 15:01
User is offline View Users Profile Print this message


Phil Allen

Posts: 3
Joined: 26-Oct-2006

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
Report this to a Moderator Report this to a Moderator
 5-Feb-2007 13:46
User is offline View Users Profile Print this message


Karen Hidalgo

Posts: 55
Joined: 4-Nov-2003

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
Report this to a Moderator Report this to a Moderator
 5-Feb-2007 14:44
User is offline View Users Profile Print this message


Pete Kowalski

Posts: 301
Joined: 7-Feb-2003

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
Report this to a Moderator Report this to a Moderator
 5-Feb-2007 16:05
User is offline View Users Profile Print this message


Karen Hidalgo

Posts: 55
Joined: 4-Nov-2003

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
Report this to a Moderator Report this to a Moderator
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.