hamburger menu
+ Create a topic
Solved

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

Simon D101

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

icon

Best answer by Micah 7 February 2024, 20:22

View original

Comments

Coumba D
Userlevel 3
Badge +6

Hi Simon

Thanks for posting in the Community!

I am not sure I fully understand. Do you mean that you manually created an ERD in Lucidchart which you then exported for MySQL and then directly re-imported the exported file back into Lucidchart?

Could you provide some more details regarding what you are trying to achieve so I can try and guide you better?

Thanks!

Simon D101

Hi Coumba

Yes I'm trying to do exactly what you mentioned.
We can import our DB in format of (MySQL PostgreSQL Oracle SQL Server) I tried with MySQL 
Reference: https://lucidchart.zendesk.com/hc/en-us/articles/207299756-Entity-Relationship-Diagrams#import-database
However it didn't work
I tried with the example given from the SQL "7. Click Copy to Clipboard to copy the query." didn't work either
So at last resort I create manually the ERD "https://lucidchart.zendesk.com/hc/en-us/articles/207299756-Entity-Relationship-Diagrams#manually-create-erd"
and export it as MySQL => https://lucidchart.zendesk.com/hc/en-us/articles/207299756-Entity-Relationship-Diagrams#export-erd
Then I tried to import this file into the import of ERD it doesn't work
How can something generated from export cannot be good format for import?
Could you share a working MySQL file good for import in the ERD?

Thank you

Best regards

Simon

Coumba D
Userlevel 3
Badge +6

Hi Simon

Thanks for the explanation.

Note that you will need to first run the query reference at step 7 of the Import your database section of our  ERD help article in your DBMS before either pasting the output in plain text or importing the results generated by your DBMS back into Lucidchart.

Basically step 7 is only about copying the query from Lucidchart and the following steps explain what to do with the query:

 

 

 

I hope this helps however if you feel that I am misunderstanding I would recommend filing a support ticket and include the URL to your document so that our team can take a closer look and test if necessary!

Simon D101

Hi Coumba

Thank you for highlight the request to DB first missed this part.
I tried it it works thanks
However only the Primary key Foreign Key(constraint key) are into the schema which is not all the data(other columns).
At the end I created it manually from my DB as I couldn't find a solution.

Thank you

Simon

Coumba D
Userlevel 3
Badge +6

Hi Simon

Glad to read that you've been able to import your file after having ran the query in your DBMS!

If I understand correctly the issue that you are now experiencing not all entities (with the exception of your primary and foreign keys) are rendered onto your ERD.

When you import your file into Lucidchart the software immediately converts the imported query into a list of databases tables and schemas and organizes the list in your shape menu. If some of the entities you expect to see rendered are not available from your shape menu it is likely that they were not clearly referenced in your data file or the file is mis-formatted.

To be able to help with that we would need to take a look at the .csv file or plain text output received from your DBMS after running the query provided by Lucidchart. I will turn this community post into a support request and reach out to you that way to ask for this information as well as a few other ones in order for me to take a look. You'll receive an email from me very shortly!

Naresh R

 I would recommend filing a support ticket and include the URL

E
Badge

I am having the same issue, but with what seems to be a valid Import File. I attempted to convert the CSV to TSV and Text but still get this error when trying to import. I will post the first few rows of the data. I’m not sure what the issue is as the error doesn’t give specific reason for failure.

 

#NAMES
dbms    TABLE_CATALOG    TABLE_SCHEMA    TABLE_NAME    COLUMN_NAME    ORDINAL_POSITION    DATA_TYPE    CHARACTER_MAXIMUM_LENGTH    CONSTRAINT_TYPE    TABLE_SCHEMA    TABLE_NAME    COLUMN_NAME
#TYPES
str    str    str    str    str    I    str    I    str    str    str    str
#ROWS    774
sqlserver    Ignition    Report    UserReport    id    1    int        PRIMARY KEY            
sqlserver    Ignition    Report    UserReport    UserID    2    int        FOREIGN KEY    dbo    scada_users    id
sqlserver    Ignition    Report    UserReport    ReportID    3    int                    
sqlserver    Ignition    Report    UserReport    FrequencyID    4    int                    
sqlserver    Ignition    Report    UserReport    DeliveryTimeID    5    int                    
sqlserver    Ignition    LSEM    Attachment    AttachmentId    1    int        PRIMARY KEY            
sqlserver    Ignition    LSEM    Attachment    ObjectId    2    int                    
sqlserver    Ignition    LSEM    Attachment    ObjectType    3    nvarchar    50                
sqlserver    Ignition    LSEM    Attachment    GlobalId    4    nvarchar    50                
sqlserver    Ignition    LSEM    Attachment    FileName    5    nvarchar    256                
sqlserver    Ignition    LSEM    Attachment    FileType    6    nvarchar    10                
sqlserver    Ignition    LSEM    Attachment    FileSize    7    int                    
sqlserver    Ignition    LSEM    Attachment    S3FileName    8    nvarchar    255                
sqlserver    Ignition    LSEM    Attachment    S3ThumbnailName    9    nvarchar    255                
sqlserver    Ignition    LSEM    Attachment    CreatedBy    10    int                    
sqlserver    Ignition    LSEM    Attachment    CreatedOn    11    datetime2                

Micah
Userlevel 6
Badge +17

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. 

 

 

1 Attachment
E
Badge

Hi @Micah , Thank you for the response. We are using MSSQL. We did finally get this to work by tweaking the query a bit to remove some deprecated tables that most likely caused the issue. I love this feature and the export as well and I was showing a colleague this functionality. They were very impressed. 

 

Thanks again!!

Micah
Userlevel 6
Badge +17

@efredericksen Thanks for getting back to me, and well done with the workaround! MSSQL isn’t directly supported in our import options, which may have contributed to the parsing error, but our recommendation is to do exactly what you did. Great to hear this was successful and will be useful for you! Please reach out if there’s more we can do to support your work.

F
Badge

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
Userlevel 6
Badge +17

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!

1 Attachment
A
Badge

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
Userlevel 6
Badge +17

@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
Badge

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
Userlevel 6
Badge +17

@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. 

2 Attachments
A
Badge

 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
Userlevel 6
Badge +17

@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. 

 

1 Attachment
A
Badge

@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
Userlevel 6
Badge +17

@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!

A
Badge

hI @Micah ,
Below is the CSV i have tried.

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,AdventureWorks2008R3,Sales,PJF_PROJ_ELEMENTS_B,PROJ_ELEMENT_ID,1,int,NULL,PRIMARY KEY,,,
sqlserver,AdventureWorks2008R3,Sales,PJF_PROJ_ELEMENTS_B,PROJECT_ID,6,int,NULL,FOREIGN KEY,Sales,PJF_PROJECTS_ALL_B,PROJECT_ID
sqlserver,AdventureWorks2008R3,Sales,PJF_PROJECTS_ALL_B,PROJECT_ID,1,int,NULL,PRIMARY KEY,,,
 

Micah
Userlevel 6
Badge +17

@ACDC I’m sorry for the continued trouble here. I tested your CSV and was able to add tables to my canvas with relationship lines automatically created. In my example below, I added two of each table and see the following:

 

 

Can you try pasting your CSV as plain text in the upload option, add the tables to the canvas, and if no relationship lines are drawn, respond with a screenshot of what you’re seeing?

 

A
Badge

 hi @Micah , That worked for me..However when i add more tables (as i want to expand it ) and realtionships it just does not pick up the relationships… Below is the CSV , see if you can spot a problem…

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,AdventureWorks2008R3,Sales,PJB_BILLING_EVENTS,EVENT_ID,1,int,NULL,PRIMARY KEY,NULL,NULL,NULL
sqlserver,AdventureWorks2008R3,Sales,PJB_BILLING_EVENTS,PROJECT_ID,11,int,NULL,FOREIGN KEY,Sales,PJF_PROJECTS_ALL_B,PROJECT_ID
sqlserver,AdventureWorks2008R3,Sales,PJB_BILLING_EVENTS,TASK_ID,12,int,NULL,FOREIGN KEY,Sales,PJF_PROJ_ELEMENTS_B,TASK_ID
sqlserver,AdventureWorks2008R3,Sales,PJB_INV_LINE_DISTS,INVOICE_DIST_ID,1,int,NULL,PRIMARY KEY,NULL,NULL,NULL
sqlserver,AdventureWorks2008R3,Sales,PJB_INV_LINE_DISTS,INVOICE_ID,4,int,NULL,FOREIGN KEY,Sales,PJB_INVOICE_HEADERS,INVOICE_ID
sqlserver,AdventureWorks2008R3,Sales,PJB_INV_LINE_DISTS,INVOICE_LINE_ID,5,int,NULL,FOREIGN KEY,Sales,PJB_INVOICE_LINES,INVOICE_LINE_ID
sqlserver,AdventureWorks2008R3,Sales,PJB_INV_LINE_DISTS,BILL_TRX_ID,7,int,NULL,FOREIGN KEY,Sales,PJB_BILL_TRXS,BILL_TRX_ID
sqlserver,AdventureWorks2008R3,Sales,PJB_INV_LINE_DISTS,CREDITED_INVOICE_ID,76,int,NULL,FOREIGN KEY,Sales,PJB_INVOICE_HEADERS,CREDITED_INVOICE_ID
sqlserver,AdventureWorks2008R3,Sales,PJB_INV_LINE_DISTS,CREDITED_INVOICE_LINE_ID,77,int,NULL,FOREIGN KEY,Sales,PJB_INVOICE_LINES,CREDITED_INVOICE_LINE_ID
sqlserver,AdventureWorks2008R3,Sales,PJB_INV_LINE_DISTS,RBS_ELEMENT_ID,82,int,NULL,FOREIGN KEY,Sales,PJF_RBS_ELEMENTS,RBS_ELEMENT_ID
sqlserver,AdventureWorks2008R3,Sales,PJB_INVOICE_FORMATS,INVOICE_FORMAT_ID,1,int,NULL,PRIMARY KEY,NULL,NULL,NULL
sqlserver,AdventureWorks2008R3,Sales,PJB_INVOICE_FORMATS,INVOICE_GROUP_ID,3,int,NULL,FOREIGN KEY,Sales,PJB_INV_GROUP_HEADERS,INVOICE_GROUP_ID
sqlserver,AdventureWorks2008R3,Sales,PJB_INVOICE_HEADERS,INVOICE_ID,1,int,NULL,PRIMARY KEY,NULL,NULL,NULL
sqlserver,AdventureWorks2008R3,Sales,PJB_INVOICE_HEADERS,ACCTD_RATE_TYPE,36,varchar,NULL,FOREIGN KEY,Sales,GL_DAILY_CONVERSION_TYPES,ACCTD_RATE_TYPE
sqlserver,AdventureWorks2008R3,Sales,PJB_INVOICE_LINES,INVOICE_LINE_ID,1,int,NULL,PRIMARY KEY,NULL,NULL,NULL
sqlserver,AdventureWorks2008R3,Sales,PJB_INVOICE_LINES,INVOICE_ID,5,int,NULL,FOREIGN KEY,Sales,PJB_INVOICE_HEADERS,INVOICE_ID
sqlserver,AdventureWorks2008R3,Sales,PJB_INVOICE_LINES,CREDITED_INVOICE_ID,11,int,NULL,FOREIGN KEY,Sales,PJB_INVOICE_HEADERS,CREDITED_INVOICE_ID
sqlserver,AdventureWorks2008R3,Sales,PJB_INVOICE_LINES,INVOICE_FORMAT_ID,14,int,NULL,FOREIGN KEY,Sales,PJB_INVOICE_FORMATS,INVOICE_FORMAT_ID
sqlserver,AdventureWorks2008R3,Sales,PJF_PROJ_ELEMENTS_B,PROJ_ELEMENT_ID,1,int,NULL,PRIMARY KEY,NULL,NULL,NULL
sqlserver,AdventureWorks2008R3,Sales,PJF_PROJ_ELEMENTS_B,PARENT_STRUCTURE_ID,2,int,NULL,NULL,NULL,NULL,NULL
sqlserver,AdventureWorks2008R3,Sales,PJF_PROJ_ELEMENTS_B,PROJECT_ID,6,int,NULL,FOREIGN KEY,Sales,PJF_PROJECTS_ALL_B,PROJECT_ID
sqlserver,AdventureWorks2008R3,Sales,PJF_PROJECTS_ALL_B,PROJECT_ID,1,int,NULL,PRIMARY KEY,NULL,NULL,NULL
sqlserver,AdventureWorks2008R3,Sales,PJF_PROJECTS_ALL_B,PROJECT_TYPE_ID,2,int,NULL,FOREIGN KEY,Sales,PJF_PROJECT_TYPES_B,PROJECT_TYPE_ID
sqlserver,AdventureWorks2008R3,Sales,PJF_PROJECTS_ALL_B,CARRYING_OUT_ORGANIZATION_ID,3,int,NULL,NULL,NULL,NULL,NULL
sqlserver,AdventureWorks2008R3,Sales,PJF_PROJECTS_ALL_B,PUBLIC_SECTOR_FLAG,4,varchar,NULL,NULL,NULL,NULL,NULL
sqlserver,AdventureWorks2008R3,Sales,PJF_PROJECTS_ALL_B,PROJECT_STATUS_CODE,5,varchar,NULL,FOREIGN KEY,Sales,PJF_PROJECT_STATUSES_B,PROJECT_STATUS_CODE
sqlserver,AdventureWorks2008R3,Sales,PJF_PROJECTS_ALL_B,COST_IND_RATE_SCH_ID,6,int,NULL,FOREIGN KEY,Sales,PJF_IND_RATE_SCH_B,COST_IND_RATE_SCH_ID
sqlserver,AdventureWorks2008R3,Sales,PJF_PROJECTS_ALL_B,COST_IND_SCH_FIXED_DATE,7,date,NULL,NULL,NULL,NULL,NULL
sqlserver,AdventureWorks2008R3,Sales,PJF_PROJECTS_ALL_B,OVR_COST_IND_RATE_SCH_ID,8,int,NULL,FOREIGN KEY,Sales,PJF_IND_RATE_SCH_B,OVR_COST_IND_RATE_SCH_ID
sqlserver,AdventureWorks2008R3,Sales,PJF_PROJECTS_ALL_B,LABOR_TP_SCHEDULE_ID,9,int,NULL,FOREIGN KEY,Sales,PJF_TP_SCHEDULES,LABOR_TP_SCHEDULE_ID
sqlserver,AdventureWorks2008R3,Sales,PJF_PROJECTS_ALL_B,LABOR_TP_FIXED_DATE,10,date,NULL,NULL,NULL,NULL,NULL
sqlserver,AdventureWorks2008R3,Sales,PJF_PROJECTS_ALL_B,CC_PROCESS_NL_FLAG,11,varchar,NULL,NULL,NULL,NULL,NULL
sqlserver,AdventureWorks2008R3,Sales,PJF_PROJECTS_ALL_B,NL_TP_SCHEDULE_ID,12,int,NULL,FOREIGN KEY,Sales,PJF_TP_SCHEDULES,NL_TP_SCHEDULE_ID
sqlserver,AdventureWorks2008R3,Sales,PJF_PROJECTS_ALL_B,NL_TP_FIXED_DATE,13,date,NULL,NULL,NULL,NULL,NULL
sqlserver,AdventureWorks2008R3,Sales,PJF_PROJECTS_ALL_B,WORK_TYPE_ID,14,int,NULL,FOREIGN KEY,Sales,PJF_WORK_TYPES_B,WORK_TYPE_ID
sqlserver,AdventureWorks2008R3,Sales,PJF_PROJECTS_ALL_B,CINT_RATE_SCH_ID,15,int,NULL,FOREIGN KEY,Sales,PJC_CINT_RATE_SCH_B,CINT_RATE_SCH_ID
sqlserver,AdventureWorks2008R3,Sales,PJO_PLAN_LINE_DETAILS,PLAN_LINE_DETAIL_ID,1,int,NULL,PRIMARY KEY,NULL,NULL,NULL
sqlserver,AdventureWorks2008R3,Sales,PJO_PLAN_LINE_DETAILS,PLANNING_ELEMENT_ID,8,int,NULL,FOREIGN KEY,Sales,PJO_PLANNING_ELEMENTS,PLANNING_ELEMENT_ID
sqlserver,AdventureWorks2008R3,Sales,PJO_PLAN_LINE_DETAILS,PLAN_VERSION_ID,13,int,NULL,FOREIGN KEY,Sales,PJO_PLAN_VERSIONS_B,PLAN_VERSION_ID
sqlserver,AdventureWorks2008R3,Sales,PJO_PLAN_LINES,PLAN_LINE_ID,1,int,NULL,PRIMARY KEY,NULL,NULL,NULL
sqlserver,AdventureWorks2008R3,Sales,PJO_PLAN_LINES,PLANNING_ELEMENT_ID,39,int,NULL,FOREIGN KEY,Sales,PJO_PLANNING_ELEMENTS,PLANNING_ELEMENT_ID
sqlserver,AdventureWorks2008R3,Sales,PJO_PLAN_LINES,PLAN_VERSION_ID,41,int,NULL,FOREIGN KEY,Sales,PJO_PLAN_VERSIONS_B,PLAN_VERSION_ID
sqlserver,AdventureWorks2008R3,Sales,PJO_PLAN_TYPES_B,PLAN_TYPE_ID,1,int,NULL,PRIMARY KEY,NULL,NULL,NULL
sqlserver,AdventureWorks2008R3,Sales,PJO_PLAN_VERSIONS_B,PLAN_VERSION_ID,1,int,NULL,PRIMARY KEY,NULL,NULL,NULL
sqlserver,AdventureWorks2008R3,Sales,PJO_PLAN_VERSIONS_B,PROJECT_ID,16,int,NULL,FOREIGN KEY,Sales,PJF_PROJECTS_ALL_B,PROJECT_ID
sqlserver,AdventureWorks2008R3,Sales,PJO_PLAN_VERSIONS_B,PLAN_TYPE_ID,18,int,NULL,FOREIGN KEY,Sales,PJO_PLAN_TYPES_B,PLAN_TYPE_ID
sqlserver,AdventureWorks2008R3,Sales,PJO_PLANNING_CURRENCIES,PLANNING_CURRENCY_ID,1,int,NULL,PRIMARY KEY,NULL,NULL,NULL
sqlserver,AdventureWorks2008R3,Sales,PJO_PLANNING_CURRENCIES,PLANNING_OPTION_ID,2,int,NULL,FOREIGN KEY,Sales,PJO_PLANNING_OPTIONS,PLANNING_OPTION_ID
sqlserver,AdventureWorks2008R3,Sales,PJO_PLANNING_ELEMENTS,PLANNING_ELEMENT_ID,1,int,NULL,PRIMARY KEY,NULL,NULL,NULL
sqlserver,AdventureWorks2008R3,Sales,PJO_PLANNING_ELEMENTS,PLAN_VERSION_ID,6,int,NULL,FOREIGN KEY,Sales,PJO_PLAN_VERSIONS_B,PLAN_VERSION_ID
sqlserver,AdventureWorks2008R3,Sales,PJO_PLANNING_ELEMENTS,PROJECT_ID,7,int,NULL,FOREIGN KEY,Sales,PJF_PROJECTS_ALL_B,PROJECT_ID
sqlserver,AdventureWorks2008R3,Sales,PJO_PLANNING_ELEMENTS,TASK_ID,8,int,NULL,FOREIGN KEY,Sales,PJF_PROJ_ELEMENTS_B,TASK_ID
sqlserver,AdventureWorks2008R3,Sales,PJO_PLANNING_ELEMENTS,RBS_ELEMENT_ID,9,int,NULL,FOREIGN KEY,Sales,PJF_RBS_ELEMENTS,RBS_ELEMENT_ID
sqlserver,AdventureWorks2008R3,Sales,PJO_PLANNING_OPTIONS,PLANNING_OPTION_ID,1,int,NULL,PRIMARY KEY,NULL,NULL,NULL
sqlserver,AdventureWorks2008R3,Sales,PJO_PLANNING_OPTIONS,PLAN_TYPE_ID,31,int,NULL,FOREIGN KEY,Sales,PJO_PLAN_TYPES_B,PLAN_TYPE_ID
sqlserver,AdventureWorks2008R3,Sales,PJO_PLANNING_OPTIONS,AMOUNT_SET_ID,42,int,NULL,FOREIGN KEY,Sales,PJO_FIN_PLAN_AMT_SETS,AMOUNT_SET_ID
sqlserver,AdventureWorks2008R3,Sales,PJO_PROJECT_PROGRESS,PROJECT_PROGRESS_ID,1,int,NULL,PRIMARY KEY,NULL,NULL,NULL
sqlserver,AdventureWorks2008R3,Sales,PJO_PROJECT_PROGRESS,PROJECT_ID,2,int,NULL,FOREIGN KEY,Sales,PJF_PROJECTS_ALL_B,PROJECT_ID
sqlserver,AdventureWorks2008R3,Sales,PJO_PROJECT_PROGRESS,PROJ_ELEMENT_ID,5,int,NULL,FOREIGN KEY,Sales,PJF_PROJ_ELEMENTS_B,PROJ_ELEMENT_ID
sqlserver,AdventureWorks2008R3,Sales,PJO_PROJECT_PROGRESS,ELEMENT_VERSION_ID,6,int,NULL,FOREIGN KEY,Sales,PJF_PROJ_ELEMENT_VERSION,ELEMENT_VERSION_ID
sqlserver,AdventureWorks2008R3,Sales,PJO_PROJECT_PROGRESS,PLAN_VERSION_ID,10,int,NULL,FOREIGN KEY,Sales,PJO_PLAN_VERSIONS_B,PLAN_VERSION_ID
 

Micah
Userlevel 6
Badge +17

Hi @ACDC, thanks for your response. I’ve uploaded your CSV to import tables, and when experimenting by dragging a few out, I was able to see automatically-created relationships between Sales.PJO_PLAN_VERSIONS_B and many other tables. Take a look below:

 

Are there any relationships in particular that you are expecting to see and are not?

A
Badge

@Micah ,  i wonder if this is happening to me because i am on trial not fully signe dup yet..

 

Reply


Lucid Software Inc. Supplemental Community Terms

Get Started

Products

Solutions

Resources

Company

Privacy Legal Cookie privacy choices Cookie policy
©   2024  Lucid Software Inc.