How about ODBC support for parts?

Hi Craig,

ODBC support has been requested several times previously by a number of people, myself included. I agree it would be a nice addition.

I have worked around this issue by writing a php interface to my back end database (in this case sqlite but the principle is the same for MySQL) running on nginx (or you could use apache or whatever) and then using ULP's network functions to interact with the database via this web interface. It actually works reasonably well although I still need to iron out a few wrinkles in my implementation and rewrite some of my code to be more elegant.

Best Regards,

Rachael

On 05/22/2016 11:15 AM, rachaelp wrote:

I have worked around this issue by writing a php interface to my back

end database

Would you be willing to share your PHP and ULP code?

Thanks,

Craig

Craig Arno wrote on Tue, 24 May 2016 15:52

On 05/22/2016 11:15 AM, rachaelp wrote:

 

I have worked around this issue by writing a php interface to my

back

end database

 

Would you be willing to share your PHP and ULP code?

 

Thanks,

Craig

Hi Craig,

I will share the essence of the code once it's tidied up and not quite so

"hacky"! It's very tied to how my database works for me so probably not

useful to share it in its entirety and also at the moment it's not elegant

as components are matched based upon building a description string in ULP

from the attributes of a part and then doing a lookup in the database on

that description. My end goal is to have it look up on all the parameters

individually and if there is more than one match it would pop up a window

with the choices for me to select or if a match could not be found at all

it would pop up a list of all the database parts in the category for me to

do a manual search or add a new entry. This is the long term goal but I

have other work to do in the mean time though!

If I get a chance to pull together some sanitized code snippets based on

where I am currently I will pop them on here in the interim until I can get

something better to share.

Best Regards,

Rachael

--

Web access to CadSoft support forums at www.eaglecentral.ca.  Where the CadSoft EAGLE community meets.

Craig Arno wrote on Tue, 24 May 2016 15:52

On 05/22/2016 11:15 AM, rachaelp wrote:

 

I have worked around this issue by writing a php interface to my

back

end database

 

Would you be willing to share your PHP and ULP code?

 

Thanks,

Craig

Hi Craig,

I will share the essence of the code once it's tidied up and not quite so

"hacky"! It's very tied to how my database works for me so probably not

useful to share it in its entirety and also at the moment it's not elegant

as components are matched based upon building a description string in ULP

from the attributes of a part and then doing a lookup in the database on

that description. My end goal is to have it look up on all the parameters

individually and if there is more than one match it would pop up a window

with the choices for me to select or if a match could not be found at all

it would pop up a list of all the database parts in the category for me to

do a manual search or add a new entry. This is the long term goal but I

have other work to do in the mean time though!

If I get a chance to pull together some sanitized code snippets based on

where I am currently I will pop them on here in the interim until I can get

something better to share.

Best Regards,

Rachael

--

Web access to CadSoft support forums at www.eaglecentral.ca.  Where the CadSoft EAGLE community meets.

Craig Arno wrote on Tue, 24 May 2016 15:52

On 05/22/2016 11:15 AM, rachaelp wrote:

 

I have worked around this issue by writing a php interface to my

back

end database

 

Would you be willing to share your PHP and ULP code?

 

Thanks,

Craig

Hi Craig,

I will share the essence of the code once it's tidied up and not quite so

"hacky"! It's very tied to how my database works for me so probably not

useful to share it in its entirety and also at the moment it's not elegant

as components are matched based upon building a description string in ULP

from the attributes of a part and then doing a lookup in the database on

that description. My end goal is to have it look up on all the parameters

individually and if there is more than one match it would pop up a window

with the choices for me to select or if a match could not be found at all

it would pop up a list of all the database parts in the category for me to

do a manual search or add a new entry. This is the long term goal but I

have other work to do in the mean time though!

If I get a chance to pull together some sanitized code snippets based on

where I am currently I will pop them on here in the interim until I can get

something better to share.

Best Regards,

Rachael

--

Web access to CadSoft support forums at www.eaglecentral.ca.  Where the CadSoft EAGLE community meets.