Solved

Import an ERD and display the relationships in Lucidchart

Forum|Forum|2 years ago
July 17, 2024
9 replies
709 views

I am very new to this but...I got my .csv file to import into LucidChart. I can see all of the tables. I clicked on the tables one at a time and no relationships were drawn. Now I don’t know what to do.

I looked at the .csv file and the PKs and FKs are indicated for each table in the file. How do I create the ERD and have the relationships show up?

Best answer by Amelia W

Hi @mathildeguilbard, I’m glad to hear that! We appreciate your feedback for our documentation as well.

Going forward, if your DBMS is not formally supported in Lucid, or if you run into any import errors, you can write a custom query and run it in your database. Then, the example file can be used to help you generate an output file in the format our ERD importer expects.

For any other users that might have questions about ERD’s, I recommend reviewing our Create an Entity Relationship Diagram in Lucidchart article from the Lucid Help Center for more information about the set up and intended functionality.

Amelia W

Lucid support team

Hi @JellyBean, thanks for posting in the Lucid Community! You can then drag the database tables from the shape menu onto the canvas. If you have properly set up the primary and foreign keys, when you drag related tables onto the canvas, Lucidchart draws relationship lines automatically.

I would recommend reviewing our ERD article from the Lucid Help Center as an additional resource, but please let me know any questions about the intended functionality of ERDs in Lucidchart!

M

mathildeguilbard

Hi @Amelia W, this is not working for me.

The relationship lines are not automatically drawn, even if I have properly set-up primary and foreign in the Constraint_type column of my CSV. Can you explain further what should be done ?

Mathilde

Amelia W

Lucid support team

Hi @mathildeguilbard, thanks for adding to this thread! When Lucidchart is not drawing lines between the entities of your imported ERD, it is likely that your data file does not indicate the relationships using primary and foreign keys as our importer would expect. To check this, please open your data file and make sure that the cells at the end of each row are populated with information about the relationships between entities.

I’ve attached an example csv file in the format our ERD importer expects, would you mind comparing your file to this example? Please let me know if the issue persists!

ERD Example.csv

M

mathildeguilbard

Thanks it seems to be working!

As I use a BigQuery dbms it is not that easy to take on and the documentation does not very clearly explain which columns of the CSV are crucial (but i figured it out finally :)))

Amelia WAnswer

Lucid support team

Hi @mathildeguilbard, I’m glad to hear that! We appreciate your feedback for our documentation as well.

Going forward, if your DBMS is not formally supported in Lucid, or if you run into any import errors, you can write a custom query and run it in your database. Then, the example file can be used to help you generate an output file in the format our ERD importer expects.

For any other users that might have questions about ERD’s, I recommend reviewing our Create an Entity Relationship Diagram in Lucidchart article from the Lucid Help Center for more information about the set up and intended functionality.

M

mathildeguilbard

I have a strange pb today, I cannot clik the “import your data” button. I have no eror message it is just not display the options ‘from salesforce” or “from SQL database” anymore… It worked this morning but not anymore, I am confused

Eric R

Lucid support team

@mathildeguilbard thanks for your comment! I am able to reproduce this on my end and have reported this to our development team.

I recognize that this issue may hinder your workflow, and I want to be transparent so that you are able to move forward in the best way possible. Our development team has to rigorously prioritize what to work on based on the extent and criticality of the issue. Because of this, it is not likely that this issue will be resolved quickly. I apologize for any disruption this may cause, and I would like to do all I can to help you continue your work.

In the meantime, I recommend adding the ERD shape library to your document and clicking the Import button here instead.

I hope this helps. Please don't hesitate to let me know if you have any additional questions or concerns.

P

Patrick OAG TX

I ran the PostSQL query that was provided and it didn’t provide any constraints in the data file. I know there are constraints when I create the DDL extract, it has the PK listed in the tables and ALTER Tables commands for FK.

Leianne C

Lucid support team

Hi @Patrick OAG TX, thank you for posting in the community! Since this may require us to take a closer look at your CSV file etc, I’ve gone ahead and created a support ticket for your issue. Please keep an eye out for an email from Lucid Support!

Thank you and please let us know if you have any questions.

Create an account in the community

Log in to the community