C# Script to store to a database

• 

  Michele Mura

  May 17, 2019 06:42 (Edited May 17, 2019 06:43)

  Hi Guest500,

  what do you mean with the sentence "saving the .e3p file to the database"? You want to save a link into a record? The file itself as blob data into a field? Or what?

  Thanks

  Best regards

  mm

  0

  Comment actions Permalink
• 

  Guest500

  May 20, 2019 16:55

  Hey Michele,

  I mean that I have a newly created sub circuit, and I want to save it to the database so that I can re use it.

  I know I can save a sub circuit to the database using the e3 menu commands in the application, but I want to do it using script.

  Basically if I do it through the e3 application, I will open the DB editor, select 'new component', select new sub circuit, add details and then when I click next, I need to attach an .e3p file, and finally it gives me the option to select to the database. I need help on how to attach the .e3p file to the new component, but using C# script.

  Is there a way?

   

  Thanks!

  0

  Comment actions Permalink
• 

  Michele Mura

  May 21, 2019 07:28

  I still did not check if the COM interface has some class/methods to solve this task but I thought about two possible solutions:

  1) Do it manually writing data directly into the database (not so easy and you have to master the .e3p format and the data-model of the database itself.

  2) Create a procedure that controls the application and, using the interface, performs automatically the same operations a user do with mouse and keyboard.

  (I saw an example of solution nr.2 here in Italy, during ZIW 2018 in Bologna).

  0

  Comment actions Permalink
• 

  Guest500

  May 21, 2019 20:14

  Hey Michele,

  I want to try saving it using script, I can save it manually in the component database, but even there I have no idea how the .e3p file is saved.

  And for the second suggestion, I am working on that one, and that's the place I am stuck. I cannot find any methods that will store a new sub circuit's .e3p file to the database.

  Is there any other way around ?

  Thanks!

  0

  Comment actions Permalink
• 

  Michele Mura

  May 22, 2019 07:03

  Maybe I was not clear enough..

  When I said:

  2) Create a procedure that controls the application and, using the interface, performs automatically the same operations a user do with mouse and keyboard.

  I meant to write code to interact with the application through code and not using COM interface.

  It's like the VB command "SendKeys" that sends keystrokes to an application..

  Example: send ALT+F to Word to open the File menu and then send "N" and "D" to create a new blank document. (Office 365)

  0

  Comment actions Permalink

Please sign in to leave a comment.