Skip to main content
hamburger menu
+ Create a topic
Simon D101
Simon D101
March 24, 2023
Solved

Importing ERD file from MySQL leads to error "Error:We couldn't parse the output you provided." in Lucidchart

  • March 24, 2023
  • 26 replies
  • 903 views

Hi

I've created an ERD on LucidChart and exported it for MySQL and tried to use this input to re-create in LucidChart the same document with the ERD import from SQL but get an error.
"Error:We couldn't parse the output you provided."
What is wrong with my input?

I'm trying to figure out how should I setup my SQL schema for import from SQL

How can generated data from export not being good for input?

Thank you

    Best answer by Micah

    Hi @efredericksen, thanks for this question! Can you confirm what DBMS you’re using and that you’ve selected the corresponding query in this modal?

    I see “sqlserver” in your output. If this is correct, I recommend comparing it to the example output file I’ve attached to this comment. Using this as a template will allow you to identify any differences in structure that Lucidchart isn’t able to interpret. 

     

     

    Comments

    Show previous replies
    F
    fhoracio.sanchez
    March 8, 2024

    will this work with Redshift databases ? i changed the code so that i runs in my db but then when i tried either uploading the output as csv or directly pasting in plain text i get the parse error 

     

    my redshift code

    SELECT 
      'redshift' AS dbms,
      t.table_catalog,
      t.table_schema,
      t.table_name,
      c.column_name,
      c.ordinal_position,
      c.data_type,
      c.character_maximum_length,
      n.constraint_type,
      k2.table_schema as table_schema,
      k2.table_name,
      k2.column_name 
    FROM 
      information_schema.tables t 
      NATURAL LEFT JOIN information_schema.columns c 
      LEFT JOIN (
        information_schema.key_column_usage k 
        NATURAL JOIN information_schema.table_constraints n 
        NATURAL LEFT JOIN information_schema.referential_constraints r
      ) ON 
        c.table_catalog = k.table_catalog 
        AND c.table_schema = k.table_schema 
        AND c.table_name = k.table_name 
        AND c.column_name = k.column_name 
      LEFT JOIN information_schema.key_column_usage k2 ON 
        k.ordinal_position = k2.ordinal_position 
        AND r.unique_constraint_catalog = k2.constraint_catalog 
        AND r.unique_constraint_schema = k2.constraint_schema 
        AND r.unique_constraint_name = k2.constraint_name 
    WHERE 
      t.table_type = 'BASE TABLE' 
      AND t.table_schema NOT IN ('information_schema', 'pg_catalog')

     

    and still get the “We couldn t parse the output you provided”

    Micah
    Micah
    Lucid community team
    March 8, 2024

    Hi @fhoracio.sanchez, thanks for this question! Although Redshift is based on PostgreSQL, Lucidchart does not directly support import from Redshift as there are a number of feature differences which are outlined here. If you are able, you can use the sample PostgreSQL output I’ve attached as a template for formatting your own data, and then use the PostgreSQL dialogue to import it. 

    If you'd like to see support for more databases in the future, we’d love to hear more in our Product Feedback space. I hope this helps!

    A
    ACDC
    March 25, 2024

    Hi @Micah ,
    I am (Newbie) also haiving issues when i try to upload attached csv file...through sql server.
    Could you please check if you are able to load and let me know what i am missing. fyi I am building thei data base and try to load as sql server..



    dbms,TABLE_CATALOG,TABLE_SCHEMA,TABLE_NAME,COLUMN_NAME,ORDINAL_POSITION,DATA_TYPE,CHARACTER_MAXIMUM_LENGTH,CONSTRAINT_TYPE,TABLE_SCHEMA,TABLE_NAME,COLUMN_NAME
    ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,PROJ_ELEMENT_ID,1,int,,PRIMARY KEY,,,
    ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,PROJECT_ID,6,int,,FOREIGN KEY,dbo,pjf_projects_all_b,PROJECT_ID
    ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,RQMT_ID,4,int,,,,,
    ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,SPRINT_ID,5,int,,,,,
    ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,IS_INTEGRATED,2,varchar,1,,,,
    ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,OBJECT_TYPE,7,varchar,30,,,,
    ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,LAST_SYNC_DATE,3,datetime,,,,,
    ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,ELEMENT_NUMBER,8,varchar,100,,,,
    ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,DENORM_TOP_ELEMENT_ID,9,int,,,,,
    ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,DENORM_WBS_LEVEL,10,int,,,,,
    ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,DENORM_PARENT_ELEMENT_ID,11,int,,,,,
    ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,SERVICE_TYPE_CODE,12,varchar,30,,,,
    ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,CHARGEABLE_FLAG,13,varchar,1,,,,
    ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,BILLABLE_FLAG,14,varchar,1,,,,
    ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,LIMIT_TO_TXN_CONTROLS_FLAG,15,varchar,1,,,,
    ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,START_DATE,16,date,,,,,
    ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,COMPLETION_DATE,17,date,,,,,
    ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,LABOR_COST_MULTIPLIER_NAME,18,varchar,20,,,,
    ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,COST_IND_RATE_SCH_ID,19,int,,,,,
    ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,COST_IND_SCH_FIXED_DATE,20,date,,,,,
    ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,OVR_COST_IND_RATE_SCH_ID,21,int,,,,,
    ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,ALLOW_CROSS_CHARGE_FLAG,22,varchar,1,,,,
    ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,CC_PROCESS_LABOR_FLAG,23,varchar,1,,,,
    ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,LABOR_TP_SCHEDULE_ID,24,int,,,,,
    ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,LABOR_TP_FIXED_DATE,25,date,,,,,
    ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,CC_PROCESS_NL_FLAG,26,varchar,1,,,,
    ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,NL_TP_SCHEDULE_ID,27,int,,,,,
    ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,NL_TP_FIXED_DATE,28,date,,,,,
    ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,RECEIVE_PROJECT_INVOICE_FLAG,29,varchar,1,,,,
    ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,WORK_TYPE_ID,30,int,,,,,
    ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,RETIREMENT_COST_FLAG,31,varchar,1,,,,
    ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,CINT_ELIGIBLE_FLAG,32,varchar,1,,,,
    ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,CINT_STOP_DATE,33,date,,,,,
    ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,GEN_ETC_SOURCE_CODE,34,varchar,30,,,,
    ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,CLIN_ELEMENT_ID,35,int,,,,,
    ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,CREATION_DATE,36,datetime,,,,,
    ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,CREATED_BY,37,varchar,64,,,,
    ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,LAST_UPDATE_DATE,38,datetime,,,,,
    ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,LAST_UPDATED_BY,39,varchar,64,,,,
    ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,PM_SOURCE_CODE,40,varchar,30,,,,
    ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,PM_SOURCE_REFERENCE,41,varchar,100,,,,
    ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,MANAGER_PERSON_ID,42,int,,,,,
    ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,CARRYING_OUT_ORGANIZATION_ID,43,int,,,,,
    ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,LAST_UPDATE_LOGIN,44,varchar,32,,,,
    ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,ATTRIBUTE_CATEGORY,45,varchar,30,,,,
    ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,ATTRIBUTE1,46,varchar,150,,,,
    ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,ATTRIBUTE2,47,varchar,150,,,,
    ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,ATTRIBUTE3,48,varchar,150,,,,
    ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,ATTRIBUTE4,49,varchar,150,,,,
    ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,ATTRIBUTE5,50,varchar,150,,,,
    ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,ATTRIBUTE6,51,varchar,150,,,,
    ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,ATTRIBUTE7,52,varchar,150,,,,
    ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,ATTRIBUTE8,53,varchar,150,,,,
    ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,ATTRIBUTE9,54,varchar,150,,,,
    ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,ATTRIBUTE10,55,varchar,150,,,,
    ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,ATTRIBUTE11,56,varchar,150,,,,
    ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,ATTRIBUTE12,57,varchar,150,,,,
    ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,ATTRIBUTE13,58,varchar,150,,,,
    ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,ATTRIBUTE14,59,varchar,150,,,,
    ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,ATTRIBUTE15,60,varchar,150,,,,
    ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,ATTRIBUTE16,61,varchar,150,,,,
    ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,ATTRIBUTE17,62,varchar,150,,,,
    ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,ATTRIBUTE18,63,varchar,150,,,,
    ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,ATTRIBUTE19,64,varchar,150,,,,
    ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,ATTRIBUTE20,65,varchar,150,,,,
    ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,ATTRIBUTE21,66,varchar,150,,,,
    ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,ATTRIBUTE22,67,varchar,150,,,,
    ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,ATTRIBUTE23,68,varchar,150,,,,
    ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,ATTRIBUTE24,69,varchar,150,,,,
    ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,ATTRIBUTE25,70,varchar,150,,,,
    ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,ATTRIBUTE26,71,varchar,150,,,,
    ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,ATTRIBUTE27,72,varchar,150,,,,
    ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,ATTRIBUTE28,73,varchar,150,,,,
    ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,ATTRIBUTE29,74,varchar,150,,,,
    ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,ATTRIBUTE30,75,varchar,150,,,,
    ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,ATTRIBUTE31,76,varchar,150,,,,
    ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,ATTRIBUTE32,77,varchar,150,,,,
    ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,ATTRIBUTE33,78,varchar,150,,,,
    ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,ATTRIBUTE34,79,varchar,150,,,,
    ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,ATTRIBUTE35,80,varchar,150,,,,
    ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,ATTRIBUTE36,81,varchar,150,,,,
    ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,ATTRIBUTE37,82,varchar,150,,,,
    ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,ATTRIBUTE38,83,varchar,150,,,,
    ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,ATTRIBUTE39,84,varchar,150,,,,
    ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,ATTRIBUTE40,85,varchar,150,,,,
    ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,ATTRIBUTE41,86,varchar,150,,,,
    ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,ATTRIBUTE42,87,varchar,150,,,,
    ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,ATTRIBUTE43,88,varchar,150,,,,
    ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,ATTRIBUTE44,89,varchar,150,,,,
    ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,ATTRIBUTE45,90,varchar,150,,,,
    ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,ATTRIBUTE46,91,varchar,150,,,,
    ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,ATTRIBUTE47,92,varchar,150,,,,
    ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,ATTRIBUTE48,93,varchar,150,,,,
    ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,ATTRIBUTE49,94,varchar,150,,,,
    ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,ATTRIBUTE50,95,varchar,150,,,,
    ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,ATTRIBUTE1_NUMBER,96,int,,,,,
    ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,ATTRIBUTE2_NUMBER,97,int,,,,,
    ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,ATTRIBUTE3_NUMBER,98,int,,,,,
    ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,ATTRIBUTE4_NUMBER,99,int,,,,,
    ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,ATTRIBUTE5_NUMBER,100,int,,,,,
    ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,ATTRIBUTE6_NUMBER,101,int,,,,,
    ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,ATTRIBUTE7_NUMBER,102,int,,,,,
    ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,ATTRIBUTE8_NUMBER,103,int,,,,,
    ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,ATTRIBUTE9_NUMBER,104,int,,,,,
    ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,ATTRIBUTE10_NUMBER,105,int,,,,,
    ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,ATTRIBUTE11_NUMBER,106,int,,,,,
    ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,ATTRIBUTE12_NUMBER,107,int,,,,,
    ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,ATTRIBUTE13_NUMBER,108,int,,,,,
    ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,ATTRIBUTE14_NUMBER,109,int,,,,,
    ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,ATTRIBUTE15_NUMBER,110,int,,,,,
    ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,ATTRIBUTE1_DATE,111,date,,,,,
    ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,ATTRIBUTE2_DATE,112,date,,,,,
    ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,ATTRIBUTE3_DATE,113,date,,,,,
    ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,ATTRIBUTE4_DATE,114,date,,,,,
    ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,ATTRIBUTE5_DATE,115,date,,,,,
    ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,ATTRIBUTE6_DATE,116,date,,,,,
    ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,ATTRIBUTE7_DATE,117,date,,,,,
    ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,ATTRIBUTE8_DATE,118,date,,,,,
    ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,ATTRIBUTE9_DATE,119,date,,,,,
    ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,ATTRIBUTE10_DATE,120,date,,,,,
    ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,ATTRIBUTE11_DATE,121,date,,,,,
    ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,ATTRIBUTE12_DATE,122,date,,,,,
    ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,ATTRIBUTE13_DATE,123,date,,,,,
    ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,ATTRIBUTE14_DATE,124,date,,,,,
    ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,ATTRIBUTE15_DATE,125,date,,,,,
    ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,PARENT_STRUCTURE_ID,126,int,,FOREIGN KEY,dbo,pjf_proj_elements_b,PARENT_STRUCTURE_ID
    ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,OBJECT_VERSION_NUMBER,127,int,,,,,
    ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,STRUCTURE_TYPE,128,varchar,30,,,,
    ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,LEAF_NODE_FLAG,129,varchar,1,,,,
    ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,CREATED_FROM_SOURCE_ID,130,int,,,,,
    ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,PLANNING_START_DATE,131,date,,,,,
    ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,PLANNING_END_DATE,132,date,,,,,
    ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,BASELINE_START_DATE,133,date,,,,,
    ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,BASELINE_FINISH_DATE,134,date,,,,,
    ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,SITE_USE_ID,135,int,,,,,
    ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,PERCENT_COMP_CALC_METHOD,136,varchar,30,,,,
    ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,ETC_CALC_METHOD,137,varchar,30,,,,
    ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,PLANNING_DATES_ROLLUP_FLAG,138,varchar,1,,,,
    ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,CAPITALIZABLE_FLAG,139,varchar,1,,,,
    ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,DENORM_ELEM_VER_ID,140,int,,,,,
    ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,DENORM_PARENT_STRUCT_VER_ID,141,int,,,,,
    ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,DENORM_PARENT_ELEM_VER_ID,142,int,,,,,
    ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,DENORM_PARENT_OBJECT_TYPE,143,varchar,30,,,,
    ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,DENORM_WBS_NUMBER,144,varchar,240,,,,
    ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,DENORM_DISPLAY_SEQUENCE,145,int,,,,,
    ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,IC_CLIN_ELEMENT_ID,146,int,,,,,
    ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,CRITICAL_FLAG,147,varchar,1,,,,
    ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,MILESTONE_FLAG,148,varchar,1,,,,
    ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,PRIMARY_RESOURCE_ID,149,int,,,,,
    ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,TASK_TYPE_CODE,150,varchar,30,,,,
    ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,TASK_CODE01_ID,151,int,,,,,
    ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,TASK_CODE02_ID,152,int,,,,,
    ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,TASK_CODE03_ID,153,int,,,,,
    ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,TASK_CODE04_ID,154,int,,,,,
    ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,TASK_CODE05_ID,155,int,,,,,
    ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,TASK_CODE06_ID,156,int,,,,,
    ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,TASK_CODE07_ID,157,int,,,,,
    ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,TASK_CODE08_ID,158,int,,,,,
    ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,TASK_CODE09_ID,159,int,,,,,
    ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,TASK_CODE10_ID,160,int,,,,,
    ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,TASK_CODE11_ID,161,int,,,,,
    ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,TASK_CODE12_ID,162,int,,,,,
    ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,TASK_CODE13_ID,163,int,,,,,
    ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,TASK_CODE14_ID,164,int,,,,,
    ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,TASK_CODE15_ID,165,int,,,,,
    ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,TASK_CODE16_ID,166,int,,,,,
    ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,TASK_CODE17_ID,167,int,,,,,
    ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,TASK_CODE18_ID,168,int,,,,,
    ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,TASK_CODE19_ID,169,int,,,,,
    ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,TASK_CODE20_ID,170,int,,,,,
    ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,TASK_CODE21_ID,171,int,,,,,
    ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,TASK_CODE22_ID,172,int,,,,,
    ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,TASK_CODE23_ID,173,int,,,,,
    ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,TASK_CODE24_ID,174,int,,,,,
    ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,TASK_CODE25_ID,175,int,,,,,
    ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,TASK_CODE26_ID,176,int,,,,,
    ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,TASK_CODE27_ID,177,int,,,,,
    ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,TASK_CODE28_ID,178,int,,,,,
    ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,TASK_CODE29_ID,179,int,,,,,
    ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,TASK_CODE30_ID,180,int,,,,,
    ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,TASK_CODE31_ID,181,int,,,,,
    ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,TASK_CODE32_ID,182,int,,,,,
    ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,TASK_CODE33_ID,183,int,,,,,
    ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,TASK_CODE34_ID,184,int,,,,,
    ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,TASK_CODE35_ID,185,int,,,,,
    ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,TASK_CODE36_ID,186,int,,,,,
    ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,TASK_CODE37_ID,187,int,,,,,
    ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,TASK_CODE38_ID,188,int,,,,,
    ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,TASK_CODE39_ID,189,int,,,,,
    ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,TASK_CODE40_ID,190,int,,,,,
    ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,NUMBER_ATTR01,191,int,,,,,
    ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,NUMBER_ATTR02,192,int,,,,,
    ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,NUMBER_ATTR03,193,int,,,,,
    ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,NUMBER_ATTR04,194,int,,,,,
    ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,NUMBER_ATTR05,195,int,,,,,
    ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,NUMBER_ATTR06,196,int,,,,,
    ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,NUMBER_ATTR07,197,int,,,,,
    ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,NUMBER_ATTR08,198,int,,,,,
    ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,NUMBER_ATTR09,199,int,,,,,
    ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,NUMBER_ATTR10,200,int,,,,,
    ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,TEXT_ATTR01,201,varchar,200,,,,
    ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,TEXT_ATTR02,202,varchar,200,,,,
    ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,TEXT_ATTR03,203,varchar,200,,,,
    ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,TEXT_ATTR04,204,varchar,200,,,,
    ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,TEXT_ATTR05,205,varchar,200,,,,
    ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,TEXT_ATTR06,206,varchar,200,,,,
    ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,TEXT_ATTR07,207,varchar,200,,,,
    ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,TEXT_ATTR08,208,varchar,200,,,,
    ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,TEXT_ATTR09,209,varchar,200,,,,
    ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,TEXT_ATTR10,210,varchar,200,,,,
    ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,TEXT_ATTR11,211,varchar,200,,,,
    ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,TEXT_ATTR12,212,varchar,200,,,,
    ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,TEXT_ATTR13,213,varchar,200,,,,
    ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,TEXT_ATTR14,214,varchar,200,,,,
    ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,TEXT_ATTR15,215,varchar,200,,,,
    ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,TEXT_ATTR16,216,varchar,200,,,,
    ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,TEXT_ATTR17,217,varchar,200,,,,
    ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,TEXT_ATTR18,218,varchar,200,,,,
    ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,TEXT_ATTR19,219,varchar,200,,,,
    ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,TEXT_ATTR20,220,varchar,200,,,,
    ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,ISSUE_ID,221,int,,,,,
    ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,TASK_STATUS_CODE,222,varchar,30,,,,
    ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,OBJECT_ASSOCIATION_BITMAP,223,int,,,,,
    ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,EXTERNAL_ID,224,varchar,240,,,,
    ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,LAST_VIEWED_DATE,225,datetime,,,,,
    ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,DENORM_EXECUTION_DISP_SEQ,226,int,,,,,
    ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,ELEMENT_TYPE,227,varchar,30,,,,
    ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,USER_DEFINED_TASK_TYPE,228,varchar,30,,,,
    ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,PROJ_ELEMENT_ID_META,229,int,,,,,
    ORC,Snap,dbo,PJF_PROJ_ELEMENTS_B,GATE_FLAG,230,varchar,1,,,,
     

    Micah
    Micah
    Lucid community team
    March 25, 2024

    @ACDC Thanks for continuing this thread. To clarify, are you saying that CSV you pasted in your response above is an output from an SQL Server data base, you are attempting to upload it again with the SQL Server option within Lucidchart, and are receiving an error? If so, could you please respond with a screenshot of the error message you’re seeing?

    A
    ACDC
    March 25, 2024

    Thanks @Micah ,
    I have built up an excel table (in sql format with foreign and primary keys and all other fields) from pdf documentation of an Oracel database. (I had to go with documentation ad Oracel extract seems to be not providing all the tables i need and drops the foreign keys)


    I have many tables but for now I just tried to create 2 tables with relationships in Lucid to start with but failed on the upload.

    Below is the error i get . I wonder if anyone has done something similar.

    Error Message

    File format i load

     

    Micah
    Micah
    Lucid community team
    March 25, 2024

    @ACDC I recommend taking a look at the two example CSVs I attached, which contain a sample output from an Oracle and SQL database after running the query. I recommend taking a look and using the method of your choice as a “template,” ensuring that your columns in Excel match the columns shown in the example.

     

    I also believe you may be mixing information across Oracle and SQL sever, which Lucidchart isn’t able to interpret. For example, in your CSV you pasted above, your DBMS column shows “ORC,” but the SQL server option would expect to see “sqlserver” here. I recommend you model your tables after only one of the options, then use the corresponding import method. 

    A
    ACDC
    March 26, 2024

     thanks @Micah , I can load the file now but i dont get any relationships detected automatically.

    I have only loaded 3 tables with relationships...Could you please guide/check what am i missing on my file..Or show me a simple 3 table example so i can built my template accordingly...

     

    exampl 3 table



     

    dbms TABLE_CATALOG TABLE_SCHEMA TABLE_NAME COLUMN_NAME ORDINAL_POSITION DATA_TYPE CHARACTER_MAXIMUM_LENGTH CONSTRAINT_TYPE TABLE_SCHEMA TABLE_NAME COLUMN_NAME
    sqlserver Snap dbo PJF_PROJ_ELEMENTS_B PROJ_ELEMENT_ID 1 int   PRIMARY KEY      
    sqlserver Snap dbo PJF_PROJ_ELEMENTS_B PARENT_STRUCTURE_ID 126 int   FOREIGN KEY dbo pjf_proj_elements_b PARENT_STRUCTURE_ID
    sqlserver Snap dbo PJF_PROJ_ELEMENTS_B PROJECT_ID 6 int   FOREIGN KEY dbo pjf_projects_all_b PROJECT_ID
    sqlserver Snap dbo PJF_PROJECTS_ALL_B PROJECT_ID 1 int   PRIMARY KEY      
    sqlserver Snap dbo PJF_PROJECTS_ALL_B PROJECT_TYPE_ID 5 int   FOREIGN KEY dbo pjf_project_types_b PROJECT_TYPE_ID
    sqlserver Snap dbo PJF_PROJECTS_ALL_B PROJECT_STATUS_CODE 8 varchar 30 FOREIGN KEY dbo pjf_project_statuses_b PROJECT_STATUS_CODE
    sqlserver Snap dbo PJF_PROJECTS_ALL_B COST_IND_RATE_SCH_ID 40 int   FOREIGN KEY dbo pjf_ind_rate_sch_b COST_IND_RATE_SCH_ID
    sqlserver Snap dbo PJF_PROJECTS_ALL_B OVR_COST_IND_RATE_SCH_ID 42 int   FOREIGN KEY dbo pjf_ind_rate_sch_b OVR_COST_IND_RATE_SCH_ID
    sqlserver Snap dbo PJF_PROJECTS_ALL_B LABOR_TP_SCHEDULE_ID 64 int   FOREIGN KEY dbo pjf_tp_schedules LABOR_TP_SCHEDULE_ID
    sqlserver Snap dbo PJF_PROJECTS_ALL_B NL_TP_SCHEDULE_ID 67 int   FOREIGN KEY dbo pjf_tp_schedules NL_TP_SCHEDULE_ID
    sqlserver Snap dbo PJF_PROJECTS_ALL_B WORK_TYPE_ID 69 int   FOREIGN KEY dbo pjf_work_types_b WORK_TYPE_ID
    sqlserver Snap dbo PJF_PROJECTS_ALL_B CINT_RATE_SCH_ID 87 int   FOREIGN KEY dbo pjc_cint_rate_sch_b CINT_RATE_SCH_ID
    sqlserver Snap dbo PJO_PROJECT_PROGRESS PROJECT_PROGRESS_ID 1 int   PRIMARY KEY    
    sqlserver Snap dbo PJO_PROJECT_PROGRESS PROJECT_ID 2 int   FOREIGN KEY dbo pjf_projects_all_b PROJECT_ID
    sqlserver Snap dbo PJO_PROJECT_PROGRESS PROJ_ELEMENT_ID 5 int   FOREIGN KEY dbo pjf_proj_elements_b PROJ_ELEMENT_ID
    sqlserver Snap dbo PJO_PROJECT_PROGRESS ELEMENT_VERSION_ID 6 int   FOREIGN KEY dbo pjf_proj_element_version ELEMENT_VERSION_ID
    sqlserver Snap dbo PJO_PROJECT_PROGRESS PLAN_VERSION_ID 10 int   FOREIGN KEY dbo pjo_plan_versions_b PLAN_VERSION_ID
    Micah
    Micah
    Lucid community team
    March 27, 2024

    @ACDC Sure, here’s an example where the relationships are drawn automatically - I’ve attached a CSV file for SQL server and a screenshot of the result in Lucidchart. 

     

    A
    ACDC
    April 2, 2024

    @Micah , I have simplified my csv file as per below but still no lcuk with relationship auto recognition..This is driving me crazy now..
     

     

    Micah
    Micah
    Lucid community team
    April 2, 2024

    @ACDC Can you please paste your CSV in a response so I can copy it and take a closer look? Apologies for the continued trouble with this!

    Show more replies

    Level up your skills & unlock exclusive perks!

    Join Lucid Legends
    Lucid Software Inc. Supplemental Community TermsAccessibility statement

    Get Started

    Products

    Solutions

    Company

    Resources

    Privacy Legal Cookie privacy choices Cookie policy Your privacy choices
    © 2026  Lucid Software Inc.