Importing Data from MySQL to Revit

[Hexageo]

Hi all,

i am trying to connect Dynamo to an MySQL Database running on XAMPP (local) in order to import data into Revit,
The problem I’m having, is that I can’t seem to manage to connect to the database because Dynamo keeps telling me “Dereferencing a non-pointer”.

Anyone got an idea what is wrong here? I can’t seem to find my flaw

[jacob.small]

The code block at the bottom of your graph doesn’t define a table (the requested input), but attempts to call a function of a class which isn’t defined.

[Andreas_Dieckmann]

Just missing quotation marks…
“DB_NAME.TABLE_NAME”

[Hexageo]

Alright, thanks guys. Managed to connect to the database. but get stuck right after. Sorry, total Dynamo noob here.
Any advice on how to solve this? Not sure how to change boolean and string values in Dynamo!?

[jacob.small]

Provide a password for the connection string node.

[Hexageo]

User ‘root’ doesnt use a password (this is a local server running under XAMPP)
i also tried adding a user “hexa” using the pw “hexa” but that doesnt make a difference

//EDIT

sorry, it does make a difference, see attached:

[Marcel_Rijsmus]

i think the password for SQL should be something like Servername/Password or alike.
@Andrew_Hannell

[Andrew_Hannell]

so that user has access to that database ?

[Hexageo]

Yes sir, both users, root and hexa have access

[Hexageo]

I tried adding localhost\pw as suggested, but that doesn’t seem to make a difference

[Andreas_Dieckmann]

Have you tried replacing localhost with 127.0.0.1 or entering an obscenely high number for timeout?

[Andrew_Hannell]

Any particular reason you are using MYSQL ?

It is sophisticated- but the permissions/authentication can be complicated
You might have installed it so that it requires SHA256 authentication ie needs a TLS connection or RSA key pair. You also need to set permissions on the database (schema)- refer below screenshot

Fine if you are running a bank, possibly overkill for BIM/Dynamo use

I’d recommend:
for simplicity: SQLite - just a file you connect to, no server
for ease of use: PostgresSQL
for spatial stuff: PostgresSQL with spatial extensions: PostGIS
for recalcitrant IT depts who don’t like opensource, and drivers etc built into Windows: MSSQL Express

Please PM me if you need further help- I am a freelancer and this is how I make a living

Andrew

[Andrew_Hannell]

I forgot to say, you can also try creating an ODBC connection to touubleshoot it, & use the same details in Dynamo

[Hexageo]

Alright, so that is working… Will try this in Dynamo now. Thanks!

[Hexageo]

Managed to connect using ODBC! Thanks so much Andrew

[msakr4]

Hello Hexageo,

I am currently working on something similar. I have a mysql database running on XAMPP. I linked it to mysql workbench and I want to export the max value found in the table to a userdefined parameter in REVIT.

I have no knowledge of Dynamo and would really appreciate some help please.

thanks

[msakr4]

[msakr4]