Import CSV to Entity model

Discussions about database modeling product Cameo Data Modeler functionalities

Moderator: Moderators

Import CSV to Entity model

Postby jvernonjpmc » Fri Sep 02, 2016 7:18 am

I need to import the definition of an Impala table into MagicDraw. I have the column name and data type in a CSV format, e.g. client_id, string.

How do I import this information into an ER model?
Forum Beginner
Forum Beginner
Posts: 42
Posts Rating:0
Joined: Mon Aug 15, 2016 3:56 pm

Re: Import CSV to Entity model

Postby supatp » Mon Sep 05, 2016 4:00 am

Dear jvernonjpmc,

If you already have the ER model (Entities), and want to import each column, you can follow this sample.

Says that you already have the "PurchaseOrder" Entities that represent the table.
You will prepare the CSV like this:


Note: make sure that the spelling of the Type is match with UML primitive type.

When you call up the CSV Import, you will select "Property" as a target type, then click Next.
Next you will map the:
- name, to the ColName
- type, to the Type
- owner, to the Table

Best Regards,
Supat P.
Customer Support
Customer Support
Posts: 165
Posts Rating:10
Joined: Mon Feb 08, 2010 2:45 am

Re: Import CSV to Entity model

Postby » Tue Jun 11, 2019 4:10 am

You can import the CSV to the entity model with the assistance of and you can also get help cameo data.
Forum Newbie
Forum Newbie
Posts: 1
Posts Rating:0
Joined: Tue Jun 11, 2019 4:05 am

Return to Cameo Data Modeler

Who is online

Users browsing this forum: No registered users and 0 guests