Welcome to Telelogic Product Support
  Home Downloads Knowledgebase Case Tracking Licensing Help Telelogic Passport
Telelogic SYNERGY (steve huntington)
Decrease font size
Increase font size
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
Search Topic Search Topic
Topic Tools Topic Tools
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.
Answer This question was answered by Manuel Fernando Rivera, on Monday, March 10, 2008 12:10 PM

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).
 6-Sep-2007 09:45
User is offline View Users Profile Print this message


Manuel Fernando Rivera

Posts: 12
Joined: 12-Apr-2007

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


Richard Sheehan

Posts: 3
Joined: 15-Jun-2005

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
Report this to a Moderator Report this to a Moderator
 12-Oct-2007 10:04
User is offline View Users Profile Print this message


michael Barnes

Posts: 85
Joined: 12-Nov-2003

An approach I have used is email. In summary:
    Write Acces script to send an email (in Synergy format) to Synergy-database address
    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
    /pt/mailatts (on Unix server)


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.
Report this to a Moderator Report this to a Moderator
 10-Mar-2008 12:10
User is offline View Users Profile Print this message


Manuel Fernando Rivera

Posts: 12
Joined: 12-Apr-2007

Answer 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).
Report this to a Moderator Report this to a Moderator
Statistics
20925 users are registered to the Telelogic SYNERGY forum.
There are currently 2 users logged in.
The most users ever online was 15 on 15-Jan-2009 at 15:34.
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.