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: Automated import from MS Access
Topic Summary: retrieve and modify data within an MS access database
Created On: 25-Jul-2007 16:03
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.
 25-Jul-2007 16:03
User is offline View Users Profile Print this message


Chris Palmer

Posts: 4
Joined: 4-Jan-2007

Can anyone help with retrieving and modifying data held within an MS access database from within doors using DXL. I need to step through an access database, compare the data with the equivelant DOORS data then align the data so that both databases match.
Report this to a Moderator Report this to a Moderator
 25-Jul-2007 16:51
User is offline View Users Profile Print this message


Peter Albert

Posts: 232
Joined: 30-Dec-2005

As far as I know, built-in access to MS Access data is not available from DOORS (this might no longer be the case for the most recent DOORS version, I am still working on 7.0). If your task has to be performed only once, I would propose to export the MS Access data into a .csv spreadsheet, import that into a DOORS module, do all your comparison stuff using DOORS / DXL on the two modules, potentially export an updated module back to .csv and this one back into MS Access. This is of course no good if you need dynamic access the other database.

Peter
Report this to a Moderator Report this to a Moderator
 25-Jul-2007 17:12
User is offline View Users Profile Print this message


David Pechacek

Posts: 674
Joined: 5-Dec-2006

I'm on 8.1 (soon to be 8.2) and there's no interface with Access that I'm aware of. Does Access use the OLE/COM interface like Excel and Word do? If so you can look to trying to write code that will drive access through DXL in DOORS. But outside of that theres no way to do it short of trying to write a program in C/C++ or some other language that can control both.

You could always export the data of each to Excel and compare them there, then import any changes back into each once they are identical.

-------------------------
David Pechacek
AAI Services Textron
dpechacek@sc-aaicorp.com
David.Pechacek@gmail.com
Report this to a Moderator Report this to a Moderator
 26-Jul-2007 14:25
User is offline View Users Profile Print this message


Chris Welch

Posts: 19
Joined: 10-Jan-2006

Chris P

Do a search here on the forum for "ADO" or "ODBC" and you will like see several threads about doing this.  I wrote a series of scripts a few years ago that pulls information from Rational Test datastores (mdb or SQL Anywhere) and in some cases upwards of 100k records. Also use it to update data in our Portal.

Cheers
Chris W.
Report this to a Moderator Report this to a Moderator
Statistics
20925 users are registered to the Telelogic DOORS forum.
There are currently 2 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 2 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.