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?
Answer
Import an ERD and display the relationships in Lucidchart
+1Best answer by Amelia W
Hi
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.
+9Hi
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!
Hi
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
+9Hi
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!
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 :)))
+9Hi
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.
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
+7
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.
Create an account in the community
A Lucid account is required to interact with the Community, and your participation is subject to the Supplemental Lucid Community Terms. You may not participate in the Community if you are under age 18. You will be redirected to the Lucid app to log in.
Log in to the community
A Lucid account is required to interact with the Community, and your participation is subject to the Supplemental Lucid Community Terms. You may not participate in the Community if you are under age 18. You will be redirected to the Lucid app to log in.
Log in with Lucid
or
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
