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: Excel Files import
Topic Summary:
Created On: 12-Sep-2005 15:49
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.
 12-Sep-2005 15:49
User is offline View Users Profile Print this message


Subhash Sen

Posts: 4
Joined: 7-Sep-2005

I want to import some Excel files into SA. 

What is the trick?

Thanks


Subhash Sen
Joint Tactical Radio System (JTRS)
Arlington, VA 22209
subhash.sen@hqda.army.mil

-------------------------
Subhash Sen
Business Enterprise Architect
Engineering Management & Integration, Inc. (EM&I)
Joint Tactical Radio System (JTRS)
Rosslyn Plaza North, Arlington, VA
(703) 696-2004 (Client Site)
(301) 758-7513 (Cell)
http:\\jtrs.army.mil
Report this to a Moderator Report this to a Moderator
 12-Sep-2005 15:56
User is offline View Users Profile Print this message


Peter Hagemann

Posts: 6
Joined: 4-Aug-2005

Have a look at the "CSV import" in the manual or the help file :-)

-------------------------
Peter Hagemann
Systems Architect
Kuehne + Nagel
Hamburg, Germany
Report this to a Moderator Report this to a Moderator
 12-Sep-2005 16:54
User is offline View Users Profile Print this message


Subhash Sen

Posts: 4
Joined: 7-Sep-2005

I looked into HELP file of SA and only thing found was Exporting Project data into IDEF0, not import to IDEF0.

Also when I click to "Imprt Definitions" in the "Dictionary" menu of SA, I get an Error message called "No Key block" .

I don't know what that is.

Can you help.

-------------------------
Subhash Sen
Business Enterprise Architect
Engineering Management & Integration, Inc. (EM&I)
Joint Tactical Radio System (JTRS)
Rosslyn Plaza North, Arlington, VA
(703) 696-2004 (Client Site)
(301) 758-7513 (Cell)
http:\\jtrs.army.mil
Report this to a Moderator Report this to a Moderator
 27-Sep-2005 17:53
User is offline View Users Profile Print this message


Andrea Heithoff

Posts: 33
Joined: 15-Aug-2005

The "No Key block" error probably means you didn't include all the identifying fields in the CSV file.

The import CSV file needs to:
1-match exactly the property name to the column name
2-include a minimum of each field that identifies the definition (whatever appears in square brackets in the browser)

One tip that is helpful is to export the definitions first, then use those column headings. To import a LISTOF property, the entries should be in "" and separated by a carriage return (alt-enter or CHAR(10) in Excel).

Andrea Heithoff
Enterprise Elements
(202) 641-8663

Edited: 12-Dec-2005 at 19:43 by Andrea Heithoff
Report this to a Moderator Report this to a Moderator
 12-Jan-2006 13:27
User is offline View Users Profile Print this message


David Colbourn

Posts: 2
Joined: 12-Jan-2006

The trick to doing Excel imports is first doing an excel export of the type you want to import.  Once you see the CSV file in Excel you can see all the properties that will need defaults and all the GUI visable properties and even the invisable ones.  This is the way to go if your doing mass updates.
Report this to a Moderator Report this to a Moderator
 17-Jan-2006 15:42
User is offline View Users Profile Print this message


Allan Leake

Posts: 1
Joined: 17-Jan-2006

David is quite correct. I went through process this last year and successfully (more or less) populated a SA encyclopedia by importing CSV files. What I did was to create a sample encyclopedia then exported CSV files for entity, attribute and data element. I analyzed the result and then used these files as templates. I extracted the required information from the old CASE tool repository and did "copy and paste" into the appropriate columns in the CSV files. I then imported these files into the new target encyclopedia. After that it was a matter of dropping the entities on diagrams and drawing the relationships. Tedious, but way faster than starting from scratch.

I hope that helps.
Report this to a Moderator Report this to a Moderator
 7-Feb-2006 13:56
User is offline View Users Profile Print this message


Christine anderson

Posts: 9
Joined: 15-Sep-2005

This is a feature I often use to either populate or correct bulk data.

Note of caution: if you are importing objects that must have another object as a parent e.g. Columns or Attributes, then the description field of the parent must be updated to include the new children otherwise when you open the entity or the table it will deny the existence of its new offspring
Report this to a Moderator Report this to a Moderator
 17-May-2006 16:05
User is offline View Users Profile Print this message


Fred Beaujot

Posts: 1
Joined: 9-May-2006

I searched this forum looking for tips and tricks for CSV definition imports. I am looking for a way to import additions to a LISTOF without losing the existing entries in the list. I know I can export the existing definition then add the new list entries in excel and re-import, but for bulk updates, this is not feasible.
Report this to a Moderator Report this to a Moderator
 18-May-2006 01:33
User is offline View Users Profile Print this message


Duane Hennessy

Posts: 112
Joined: 18-May-2006

The only way to do this is to use an ADODB recordset and update the tables and the properties field that way.

I usually go direct to the Server for updates, changes and deletions instead of relying upon the GUI as I find direct access more stable and controllable.
Report this to a Moderator Report this to a Moderator
 8-Jun-2006 19:21
User is offline View Users Profile Print this message


Andrea Heithoff

Posts: 33
Joined: 15-Aug-2005

Fred,
If you don't have access to the underlying database, doing an append in Excel isn't as hard as you may think (assuming you have the additions in a spreadsheet):
1-export the existing defintions
2-insert two columns where your LISTOF field appears
3-in one column, use a VLOOKUP command to retrieve the additions
4-in the second column, use CONCATENATE to combine old and new, with a twist:
   =concatenate(old cell, char(10), additional cell)
5-copy and paste special-values the concatenated column
6-copy the attribute name from the old cell heading to the combined cell heading
7-delete the old and additional columns
8-save and import

Yes, it's a pain, but using those two functions in Excel are a lot easier than trying to manually add data together.  Just make sure each reference in the LISTOF property is in quotes so you don't unintentionally create a bunch of new definitions.  (Again, concatenate is handy, using concatenate("""", name, """") to result in "name")
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.