![]() |
Telelogic SYNERGY (steve huntington) | ![]() |
Topic Title: CRs Import from Access Topic Summary: How to import CRs from MS Access Created On: 6-Sep-2007 09:45 Status: Read Only |
Linear : Threading : Single : Branch |
![]() |
![]()
|
![]() Answer: Hello, Finally I have created a module in Access with functions wicht create a text file with a format. After that a Perl script is authomatically executed on Synergy server (with Programmed Tasks). | |
![]() |
|
Hello,
Someone has a method to import CRs from a MS Access database? Other departament in my company works with MS Access in order to control his problems, we need to read his database and import his CRs from this Access database to Telelogic Change. Some help about it? Thanks in advance. Manuel |
|
![]() |
|
![]() |
|
Manuel,
You can export an MS-Access table to an ascii file (CSV would be my choice). Once you have the data in an ascii format, you should then be able to use a PERL script to read the data. If there are multiple tables then you would have to export each one to get "all" the data. That's at least the way I'd attack the problem since I'm more familiar wth the UNIX world and PERL as opposed to the ever changing Microsoft world. Hope this helps. Rich |
|
![]() |
|
![]() |
|
An approach I have used is email. In summary:
Set up database to receive emails. The database must be configured to allow each attribute to be received. The attributes that may be set by email are defined in email sending from Access may require each email to be authorised by the user (anti-virus protection). There is a tool available called ClickYes that can be turned on whilst the script is running to remove the need to manually authorise each email. |
|
![]() |
|
![]() |
|
Hello,
Finally I have created a module in Access with functions wicht create a text file with a format. After that a Perl script is authomatically executed on Synergy server (with Programmed Tasks). |
|
![]() |
Telelogic SYNERGY
» SYNERGY/Change
»
CRs Import from Access
|
![]() |
FuseTalk Standard Edition v3.2 - © 1999-2009 FuseTalk Inc. All rights reserved.