![]() |
Telelogic System Architect (steve huntington) | ![]() |
Topic Title: Excel Files import Topic Summary: Created On: 12-Sep-2005 15:49 Status: Read Only |
Linear : Threading : Single : Branch |
![]() |
![]()
|
![]() |
|
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 |
|
![]() |
|
![]() |
|
Have a look at the "CSV import" in the manual or the help file :-)
------------------------- Peter Hagemann Systems Architect Kuehne + Nagel Hamburg, Germany |
|
![]() |
|
![]() |
|
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 |
|
![]() |
|
![]() |
|
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 |
|
![]() |
|
![]() |
|
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.
|
|
![]() |
|
![]() |
|
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. |
|
![]() |
|
![]() |
|
![]() 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 ![]() |
|
![]() |
|
![]() |
|
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.
|
|
![]() |
|
![]() |
|
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. |
|
![]() |
|
![]() |
|
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") |
|
![]() |
FuseTalk Standard Edition v3.2 - © 1999-2009 FuseTalk Inc. All rights reserved.