Skip to main content
enelson
July 1, 2022

Bug/Improvement: Updating ERD with new Data

  • July 1, 2022
  • 13 replies
  • 119 views

I read the post on "Anyway to update ERD diagrams with new import changes".  It did not address my concern.

I am importing updated ERD info.  If I let LucidChart update the ERD entities from the new data the shape and size of the updated ERD entities is lost.  I've noticed that tables made larger to make FK relationships easier to see on the diagram where shrunk down after the import.  As part of this all the FK lines that I seperated out now overlap once again. 

So this is the bug I'm reporting.  Or call it an improvement.  I am going to argue that this is a bug in that the imported ERD has no information about the size shape and position of the data.  And because that data is not imported LucidChart should leave those properties of the existing ERD entities alone when updating the ERD entities from the new ERD import.

Second bug:  After importing updated ERD data into an existing diagram some of the entities in the toolbox have the same name.  So if table "Foo" was in the toolbox  before the import of the updated ERD data then there *can* be two "Foo" tables in the toolbox.  Only 1 of the 2 has the new ERD information.  I suspect that table_catalog column is different between the original data and the newly imported data but I am not 100% positive.  Becaue none of the properties on the ERD entities already drawn indicate the dbms table_catalog information I can't tell where the problem is.   

    Comments

    Phillip W
    Lucid support team
    July 14, 2022

    Hey Ed 

    This is fantastic! I really appreciate your willingness to provide this information within the Community. I will continue to post information concerning this issue as it is made available to me. 

    Rose D
    November 17, 2022

    Are there any updates to this support ticket?

    Thank you.

    Micah
    Lucid community team
    November 17, 2022

    Hi Rose thanks for continuing this conversation. I've addressed the concern that you and Ed share about ERD styling and positioning edits not being maintained after uploading a new dataset in your other thread here but would love to understand more about what you're experiencing with your ERD. 

    Ed describes his second bug above as follows:

    After importing updated ERD data into an existing diagram some of the entities in the toolbox have the same name.  So if table "Foo" was in the toolbox  before the import of the updated ERD data then there *can* be two "Foo" tables in the toolbox.  Only 1 of the 2 has the new ERD information.  I suspect that table_catalog column is different between the original data and the newly imported data but I am not 100% positive.  Becaue none of the properties on the ERD entities already drawn indicate the dbms table_catalog information I can't tell where the problem is.  

    Are you observing duplicated tables as well? Any additional information you can provide will help me to better assist you!