Skip to main content

I want to see example ERD import format.



I tried exporting the example ERD provided by Lucid then attempted to import it but it fails with error 'could not parse the output you provided"



If you created the Export it should work as Import yes?

Hi Kevin thanks for posting in the Lucid Community. Can you confirm what method you used to export your example ERD as well as what method you attempted to import it with?


The following is an example output for a PostgreSQL which Lucidchart could import using the PostgreSQL option: 


postgresqlquizbowlpublicdatabase_migrationsapplied2timestamp with time zone
postgresqlquizbowlpublicdatabase_migrationsname1character varying
postgresqlquizbowlpublicload_data_versionsapplied3timestamp with time zone
postgresqlquizbowlpublicload_data_versionschecksum2character varying
postgresqlquizbowlpublicload_data_versionsname1character varying
postgresqlquizbowlpublicevent_teamcreate_date4timestamp with time zone
postgresqlquizbowlpublicevent_teamcreate_user_id3integerFOREIGN KEYpublicuser_accountuser_id
postgresqlquizbowlpublicevent_teamteam_id2integerPRIMARY KEY
postgresqlquizbowlpublicevent_teamteam_id2integerFOREIGN KEYpublicteamteam_id
postgresqlquizbowlpublicevent_teamevent_id1integerPRIMARY KEY
postgresqlquizbowlpublicevent_teamevent_id1integerFOREIGN KEYpubliceventevent_id
postgresqlquizbowlpublicevent_questioncreate_date9timestamp with time zone
postgresqlquizbowlpublicevent_questioncreate_user_id8integerFOREIGN KEYpublicuser_accountuser_id
postgresqlquizbowlpublicevent_questionclose_timestamp7timestamp with time zone
postgresqlquizbowlpublicevent_questionstart_timestamp6timestamp with time zone
postgresqlquizbowlpublicevent_questionsequence5integer
postgresqlquizbowlpublicevent_questionround_number4integer
postgresqlquizbowlpublicevent_questionquestion_id3integerFOREIGN KEYpublicquestionquestion_id
postgresqlquizbowlpublicevent_questionevent_id2integerFOREIGN KEYpubliceventevent_id
postgresqlquizbowlpublicevent_questionevent_question_id1integerPRIMARY KEY
postgresqlquizbowlpublicschoollast_mod_date10timestamp with time zone
postgresqlquizbowlpublicschoollast_mod_user_id9integerFOREIGN KEYpublicuser_accountuser_id
postgresqlquizbowlpublicschoolcreate_date8timestamp with time zone
postgresqlquizbowlpublicschoolcreate_user_id7integerFOREIGN KEYpublicuser_accountuser_id
postgresqlquizbowlpublicschoolstate_abbrev6character varying
postgresqlquizbowlpublicschoolcity5USER-DEFINED
postgresqlquizbowlpublicschoolnickname4USER-DEFINED
postgresqlquizbowlpublicschoolmascot3USER-DEFINED
postgresqlquizbowlpublicschoolname2USER-DEFINEDUNIQUE
postgresqlquizbowlpublicschoolschool_id1integerPRIMARY KEY
postgresqlquizbowlpublicsessionexpires3integer
postgresqlquizbowlpublicsessionsession_data2text
postgresqlquizbowlpublicsessionsession_id1character varyingPRIMARY KEY
postgresqlquizbowlpublicslidelast_mod_date7timestamp with time zone
postgresqlquizbowlpublicslidelast_mod_user_id6integerFOREIGN KEYpublicuser_accountuser_id
postgresqlquizbowlpublicslidecreate_date5timestamp with time zone
postgresqlquizbowlpublicslidecreate_user_id4integerFOREIGN KEYpublicuser_accountuser_id
postgresqlquizbowlpublicslideurl3USER-DEFINED
postgresqlquizbowlpublicslidename2USER-DEFINED
postgresqlquizbowlpublicslideslide_id1integerPRIMARY KEY
postgresqlquizbowlpublicevent_logcreate_date6timestamp with time zone
postgresqlquizbowlpublicevent_logcreate_user_id5integerFOREIGN KEYpublicuser_accountuser_id
postgresqlquizbowlpublicevent_logdata4text
postgresqlquizbowlpublicevent_logtype3USER-DEFINED
postgresqlquizbowlpublicevent_logevent_id2integerFOREIGN KEYpubliceventevent_id
postgresqlquizbowlpublicevent_logevent_log_id1integerPRIMARY KEY
postgresqlquizbowlpublicquestion_typedescription3text
postgresqlquizbowlpublicquestion_typename2USER-DEFINED
postgresqlquizbowlpublicquestion_typequestion_type_value1character varyingPRIMARY KEY
postgresqlquizbowlpublicuser_logincreate_date6timestamp with time zone
postgresqlquizbowlpublicuser_logincreate_user_id5integerFOREIGN KEYpublicuser_accountuser_id
postgresqlquizbowlpublicuser_loginuser_agent4text
postgresqlquizbowlpublicuser_loginsession_id3character varying
postgresqlquizbowlpublicuser_loginlogin_ip2cidr
postgresqlquizbowlpublicuser_loginuser_login_id1integerPRIMARY KEY
postgresqlquizbowlpublicversioned_schemasha13character varying40
postgresqlquizbowlpublicversioned_schemarevision2integer
postgresqlquizbowlpublicversioned_schemaname1character varying
postgresqlquizbowlpublicsubmissionlast_mod_date10timestamp with time zone
postgresqlquizbowlpublicsubmissionlast_mod_user_id9integerFOREIGN KEYpublicuser_accountuser_id
postgresqlquizbowlpublicsubmissioncreate_date8timestamp with time zone
postgresqlquizbowlpublicsubmissioncreate_user_id7integerFOREIGN KEYpublicuser_accountuser_id
postgresqlquizbowlpublicsubmissionpoints6integer
postgresqlquizbowlpublicsubmissionis_correct5boolean
postgresqlquizbowlpublicsubmissiontime_to_answer4numeric
postgresqlquizbowlpublicsubmissionanswer3USER-DEFINED
postgresqlquizbowlpublicsubmissionevent_question_id2integerFOREIGN KEYpublicevent_questionevent_question_id
postgresqlquizbowlpublicsubmissionsubmission_id1integerPRIMARY KEY
postgresqlquizbowlpubliceventlast_mod_date8timestamp with time zone
postgresqlquizbowlpubliceventlast_mod_user_id7integerFOREIGN KEYpublicuser_accountuser_id
postgresqlquizbowlpubliceventcreate_date6timestamp with time zone
postgresqlquizbowlpubliceventcreate_user_id5integerFOREIGN KEYpublicuser_accountuser_id
postgresqlquizbowlpubliceventend_time4timestamp with time zone
postgresqlquizbowlpubliceventstart_time3timestamp with time zone
postgresqlquizbowlpubliceventname2USER-DEFINED
postgresqlquizbowlpubliceventevent_id1integerPRIMARY KEY
postgresqlquizbowlpublicquestionlast_mod_date13timestamp with time zone
postgresqlquizbowlpublicquestionlast_mod_user_id12integerFOREIGN KEYpublicuser_accountuser_id
postgresqlquizbowlpublicquestioncreate_date11timestamp with time zone
postgresqlquizbowlpublicquestioncreate_user_id10integerFOREIGN KEYpublicuser_accountuser_id
postgresqlquizbowlpublicquestionlevel_id9character varying
postgresqlquizbowlpublicquestionpoints8integer
postgresqlquizbowlpublicquestionexplanation7USER-DEFINED
postgresqlquizbowlpublicquestionquestion_type_value6character varyingFOREIGN KEYpublicquestion_typequestion_type_value
postgresqlquizbowlpublicquestionanswer_value5USER-DEFINED
postgresqlquizbowlpublicquestionanswer4USER-DEFINED
postgresqlquizbowlpublicquestionoptions3text
postgresqlquizbowlpublicquestionquestion2USER-DEFINED
postgresqlquizbowlpublicquestionquestion_id1integerPRIMARY KEY
postgresqlquizbowlpublicteamlast_mod_date8timestamp with time zone
postgresqlquizbowlpublicteamlast_mod_user_id7integerFOREIGN KEYpublicuser_accountuser_id
postgresqlquizbowlpublicteamcreate_date6timestamp with time zone
postgresqlquizbowlpublicteamcreate_user_id5integerFOREIGN KEYpublicuser_accountuser_id
postgresqlquizbowlpublicteammascot4USER-DEFINED
postgresqlquizbowlpublicteamname3USER-DEFINEDUNIQUE
postgresqlquizbowlpublicteamschool_id2integerFOREIGN KEYpublicschoolschool_id
postgresqlquizbowlpublicteamteam_id1integerPRIMARY KEY
postgresqlquizbowlpublicuser_accountlast_mod_date12timestamp with time zone
postgresqlquizbowlpublicuser_accountlast_mod_user_id11integerFOREIGN KEYpublicuser_accountuser_id
postgresqlquizbowlpublicuser_accountcreate_date10timestamp with time zone
postgresqlquizbowlpublicuser_accountcreate_user_id9integerFOREIGN KEYpublicuser_accountuser_id
postgresqlquizbowlpublicuser_accountis_admin8boolean
postgresqlquizbowlpublicuser_accountpassword7character varying
postgresqlquizbowlpublicuser_accountlast_name6USER-DEFINED
postgresqlquizbowlpublicuser_accountfirst_name5USER-DEFINED
postgresqlquizbowlpublicuser_accountemail4USER-DEFINEDUNIQUE
postgresqlquizbowlpublicuser_accountschool_id3integerFOREIGN KEYpublicschoolschool_id
postgresqlquizbowlpublicuser_accountteam_id2integerFOREIGN KEYpublicteamteam_id
postgresqlquizbowlpublicuser_accountuser_id1integerPRIMARY KEY


Hi


i exported using sample ERD. see screenshot below..then proceeded to test export as an import



 


 


Thank you for the sample import!


I was able to use that as to generate my own import.


 


Hi Kevin thanks for getting back to me with that information! In your screenshot what Lucidchart is providing you is actually a query to run in your DBMS to generate an output not the output itself. Running that query in your DBMS would give you a result like the example I pasted in my response which is what Lucidchart is able to interpret in order to build an ERD. This is also why you received a "could not parse" error when attempting to upload the query itself. I hope this helps to clarify!

I'm glad that you were able to successfully import the example I provided - please don't hesitate to let me know if you have additional questions. I also recommend our Entity Relationship Diagrams article from the Lucidchart Help Center for additional information on working with ERDs. 


This sample data import format for PostgreSQL no longer works in lucid.
Can I please get an updated version?

 


@Kevin N Can you please attempt uploading that sample as a TXT or CSV file (the first option) instead of pasting it as plain text? I’ve attached that same sample file as a CSV for your convenience. Please let me know if you have trouble with this!


your sample csv worked.. thank you!!


Reply