Welcome to Telelogic Product Support
  Home Downloads Knowledgebase Case Tracking Licensing Help Telelogic Passport
Telelogic System Architect (steve huntington)
Decrease font size
Increase font size
Topic Title: Import / Export Definitions
Topic Summary: I've always run into problems....
Created On: 11-Mar-2007 14:56
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.
 11-Mar-2007 14:56
User is offline View Users Profile Print this message


Soren Alsmo

Posts: 3
Joined: 10-Feb-2007

Hi,
 I've been working with SA for some years, and occasionally the need to import / export comes up. Now the amounts to import are considerable, and I need to learn the best way.
I'm running Windows XP / language Swedish ( but I don't think that matterrs)

My probems are -
1.When saving from Excel, even if I choose the csv format) , I get semicolon as separator. So I always need to open the file and make "replace ; with ," before importing to SA. What have I missed?

2.When exporting text posts with included carriage return ( like description) or "listof stuff"  ( like application-application enterfaces) the Excel sheet will suffer from broken lines - <carriage rtns>  and look impossible to understand or handle. The "internal linefeeds" just breaks the post-structure into fragments. What have I missed?

3. I need to improve my ways in Excel - combining text strings, manipulating stuff fluently. Any hints on efficient ways to handle imports are appreciated! Should one have an access db to keep an overview of customer material? Is it worth the effort to make a VB editor ( connected to a db) to make life easier ( when you've done the editor) or is it waste of time?

Grateful for reply
Sorenswede


Report this to a Moderator Report this to a Moderator
 12-Mar-2007 14:57
User is offline View Users Profile Print this message


Soren Alsmo

Posts: 3
Joined: 10-Feb-2007

T think I've solved most of my simple problems now. The comma/ semicolon separator problem s a local language issue.

The linefeed etc issue is very much improved by the suggestion to use EditPlus2, and I'm trying to get a better understanding of the stringseparation in csv-formats.

So no answer needed,

Rgds
Soren
Report this to a Moderator Report this to a Moderator
Statistics
20925 users are registered to the Telelogic System Architect forum.
There are currently 0 users logged in.
The most users ever online was 16 on 30-Oct-2008 at 14:46.
There are currently 0 guests browsing this forum, which makes a total of 0 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.