Skip to main content
Tom P
May 18, 2017

ERD csv import not showing datatype in generated ERD diagram

  • May 18, 2017
  • 2 replies
  • 42 views

When I import a CSV file that is the result of a query against a SQL Server db I do not see the datatype of columns indicated only the field lengths.  DataTypes I am importing are either 'dt'  'nchar' or 'decimal' types.

Is there any documentation on how the csv file is parsed and what could be causing the datatype to not be captured?

 

Thanks!

    Comments

    Sara M102
    Lucidite
    May 18, 2017

    Hey Tom! This article may help.

    Sara M102
    Lucidite
    May 18, 2017

    Quick follow up. I reached out to our Product team to get more information about this. You should be able to include any text in the Data Type field and it should work. Can you take a screenshot of the generated ERD? 

    I've attached an example CSV file here for ERD imports in case you want to double check that your file is formatted correctly