![]() |
Telelogic System Architect (steve huntington) | ![]() |
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 |
![]() |
![]()
|
![]() |
|
![]() 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 |
|
![]() |
|
![]() |
|
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 |
|
![]() |
FuseTalk Standard Edition v3.2 - © 1999-2009 FuseTalk Inc. All rights reserved.