Jump to content
HurleyShanabarger

Datatype from COM/Object

Recommended Posts

Hello,

is there any way to use external datatypes from COM objects that are not in AutoIt? For example, I have this code which is running as VBA in Excel and I would like to convert it:

Sub Test()
    Dim obSimatic: Set obSimatic = CreateObject("Simatic.Simatic.1")
    Dim obSubSystem As S7SubSystem
    Dim obSlave As S7Slave3                                        ' S7-Slave
    Dim obModule As S7Module6                                      ' S7-Modul
    
    ' Set variables
    Set obSubSystem = obSimatic.Projects("AutoIt_Read").Stations("SIMATIC 300").SubSystems(101)
    Set obSlave = obSubSystem.Slaves(2)
    Set obModule = obSlave.Modules(1)
    
    ' Get parameter
    Dim sName As String
    Dim sValue As String
    Dim pFlag As ModuleIoFlags_t
    Dim lChannel As Long
    Call Modu.GetFirstParameter(sName, sValue, pFlag, lChannel)
    Debug.Print sName & ":" & sValue

    ' Reset
    Set obModule = Nothing
    Set obSlave = Nothing
    Set obSubSystem = Nothing
End Sub

Long and String are of course not a problem, but e.g. S7SubSystem, S7Slave3, S7Module6 and ModuleIoFlags_t are. Can I somehow create them in AutoIt?

This is what I have in AutoIt:

#Region Main
    Global $g_Error = ObjEvent("AutoIt.Error", "__ErrFunc")
    _Main()

    Func _Main()
        Local $obSimatic = ObjCreate("Simatic.Simatic.1")
        Local $obSubSystem = $obSimatic.Projects("AutoIt_Read").Stations("SIMATIC 300").SubSystems(101)
        $obSlave = $obSubSystem.Slaves(2)
        $obModule = $obSlave.Modules(1)

        Local $sName = String("")
        Local $sValue = String("")
        Local $pFlag = DllStructGetPtr("ptr")
        Local $lChannel = 0
        $obModule.GetFirstParameter($sName, $sValue, $pFlag, $lChannel)
        ConsoleWrite($sName & ":" & $sValue & @CRLF)
    EndFunc   ;==>_Main
    
    Func __ErrFunc($obError)
        ConsoleWrite(@TAB & "Number:        " & @TAB & StringRegExpReplace("0x" & Hex($obError.number), "[\r\n]$", "") & @CRLF)
        ConsoleWrite(@TAB & "WinDescription:" & @TAB & StringRegExpReplace($obError.windescription, "[\r\n]+$", "") & @CRLF)
        ConsoleWrite(@TAB & "Description:   " & @TAB & StringRegExpReplace($obError.description, "[\r\n]$", "") & @CRLF)
        ConsoleWrite(@TAB & "Source:        " & @TAB & StringRegExpReplace($obError.source, "[\r\n]$", "") & @CRLF)
        ConsoleWrite(@TAB & "Helpfile:      " & @TAB & StringRegExpReplace($obError.helpfile, "[\r\n]$", "") & @CRLF)
        ConsoleWrite(@TAB & "HelpContext:   " & @TAB & StringRegExpReplace($obError.helpcontext, "[\r\n]$", "") & @CRLF)
        ConsoleWrite(@TAB & "LastDllError:  " & @TAB & StringRegExpReplace($obError.lastdllerror, "[\r\n]$", "") & @CRLF)
        ConsoleWrite(@TAB & "ScriptLine:    " & @TAB & StringRegExpReplace($obError.scriptline, "[\r\n]$", "") & @CRLF)
        ConsoleWrite(@TAB & "RetCode:       " & @TAB & StringRegExpReplace("0x" & Hex($obError.retcode), "[\r\n]$", "") & @CRLF)
    EndFunc   ;==>__ErrFunc
#EndRegion Main

When calling, get the excepetion of an datatype mismatch, and I guess the culprit is $pFlag. This are the information from a TypeViewer:

typedef enum {
    const int MODULE_UK = 0,
    const int MODULE_DI = 1,
    const int MODULE_DO = 2,
    const int MODULE_AI = 3,
    const int MODULE_AO = 4
} __MIDL___MIDL_itf_S7HCOM_X_0000_0005;

How can I convert this for AutoIt?

Edited by HurleyShanabarger

Share this post


Link to post
Share on other sites

Hello,

this are the information from the TypeViewer for that function:

[id(0x0000000a), helpstring("method GetFirstParameter")] 
long GetFirstParameter(
    [out] BSTR* pParName,
    [out] BSTR* pParValue,
    [out] ModuleIoFlags_t#i* pIoFlags,
    [out] long* pChannelNo
);

If the script is run, the error reported from the error handler is this:

Number:         0x80020005
    WinDescription: Type mismatch.
    Description:    
    Source:         
    Helpfile:       
    HelpContext:    
    LastDllError:   0
    ScriptLine:     74
    RetCode:        0x00000000

The mentioned scriptline is the one, where the method is called.

Share this post


Link to post
Share on other sites
On 12/16/2020 at 1:59 AM, HurleyShanabarger said:

When calling, get the excepetion of an datatype mismatch, and I guess the culprit is $pFlag. This are the information from a TypeViewer:

typedef enum {
    const int MODULE_UK = 0,
    const int MODULE_DI = 1,
    const int MODULE_DO = 2,
    const int MODULE_AI = 3,
    const int MODULE_AO = 4
} __MIDL___MIDL_itf_S7HCOM_X_0000_0005;

How can I convert this for AutoIt?

Did you try this:

#Region Main
    Global $g_Error = ObjEvent("AutoIt.Error", "__ErrFunc")
    _Main()

    Func _Main()
        Local $obSimatic = ObjCreate("Simatic.Simatic.1")
        Local $obSubSystem = $obSimatic.Projects("AutoIt_Read").Stations("SIMATIC 300").SubSystems(101)
        $obSlave = $obSubSystem.Slaves(2)
        $obModule = $obSlave.Modules(1)

        Local Const $MODULE_UK = 0
        Local Const $MODULE_DI = 1
        Local Const $MODULE_DO = 2
        Local Const $MODULE_AI = 3
        Local Const $MODULE_AO = 4

        Local $sName = String("")
        Local $sValue = String("")
        Local $iFlag = Int(0)
        Local $lChannel = 0
        $obModule.GetFirstParameter($sName, $sValue, $iFlag, $lChannel)
        ConsoleWrite($sName & ":" & $sValue & ":" & $iFlag & @CRLF)
    EndFunc   ;==>_Main
    
    Func __ErrFunc($obError)
        ConsoleWrite(@TAB & "Number:        " & @TAB & StringRegExpReplace("0x" & Hex($obError.number), "[\r\n]$", "") & @CRLF)
        ConsoleWrite(@TAB & "WinDescription:" & @TAB & StringRegExpReplace($obError.windescription, "[\r\n]+$", "") & @CRLF)
        ConsoleWrite(@TAB & "Description:   " & @TAB & StringRegExpReplace($obError.description, "[\r\n]$", "") & @CRLF)
        ConsoleWrite(@TAB & "Source:        " & @TAB & StringRegExpReplace($obError.source, "[\r\n]$", "") & @CRLF)
        ConsoleWrite(@TAB & "Helpfile:      " & @TAB & StringRegExpReplace($obError.helpfile, "[\r\n]$", "") & @CRLF)
        ConsoleWrite(@TAB & "HelpContext:   " & @TAB & StringRegExpReplace($obError.helpcontext, "[\r\n]$", "") & @CRLF)
        ConsoleWrite(@TAB & "LastDllError:  " & @TAB & StringRegExpReplace($obError.lastdllerror, "[\r\n]$", "") & @CRLF)
        ConsoleWrite(@TAB & "ScriptLine:    " & @TAB & StringRegExpReplace($obError.scriptline, "[\r\n]$", "") & @CRLF)
        ConsoleWrite(@TAB & "RetCode:       " & @TAB & StringRegExpReplace("0x" & Hex($obError.retcode), "[\r\n]$", "") & @CRLF)
    EndFunc   ;==>__ErrFunc
#EndRegion Main

?


Signature beginning:   Wondering who uses AutoIt and what it can be used for ?
* GHAPI UDF - modest beginning - communication with GitHub REST API Forum Rules *
Include Dependency Tree (Tool for analyzing script relations)
ADO.au3 UDF     POP3.au3 UDF     XML.au3 UDF    How to use IE.au3  UDF with  AutoIt v3.3.14.x  for other useful stuff click the following button

Spoiler

Any of my own code posted anywhere on the forum is available for use by others without any restriction of any kind. 

My contribution (my own projects): * Debenu Quick PDF Library - UDF * Debenu PDF Viewer SDK - UDF * Acrobat Reader - ActiveX Viewer * UDF for PDFCreator v1.x.x * XZip - UDF * AppCompatFlags UDF * CrowdinAPI UDF * _WinMergeCompare2Files() * _JavaExceptionAdd() * _IsBeta() * Writing DPI Awareness App - workaround * _AutoIt_RequiredVersion() * Chilkatsoft.au3 UDF * TeamViewer.au3 UDF * JavaManagement UDF * VIES over SOAP * WinSCP UDF * GHAPI UDF - modest begining - comunication with GitHub REST APIErrorLog.au3 UDF - A logging Library *

My contribution to others projects or UDF based on  others projects: * _sql.au3 UDF  * POP3.au3 UDF *  RTF Printer - UDF * XML.au3 UDF * ADO.au3 UDF SMTP Mailer UDF * Dual Monitor resolution detection * * 2GUI on Dual Monitor System * _SciLexer.au3 UDF * SciTE - Lexer for console pane

Useful links: * Forum Rules * Forum etiquette *  Forum Information and FAQs * How to post code on the forum * AutoIt Online Documentation * AutoIt Online Beta Documentation * SciTE4AutoIt3 getting started * Convert text blocks to AutoIt code * Games made in Autoit * Programming related sites * Polish AutoIt Tutorial * DllCall Code Generator * 

Wiki: Expand your knowledge - AutoIt Wiki * Collection of User Defined Functions * How to use HelpFile * Good coding practices in AutoIt * 

OpenOffice/LibreOffice/XLS Related: WriterDemo.au3 * XLS/MDB from scratch with ADOX

IE Related:  * How to use IE.au3  UDF with  AutoIt v3.3.14.x * Why isn't Autoit able to click a Javascript Dialog? * Clicking javascript button with no ID * IE document >> save as MHT file * IETab Switcher (by LarsJ ) * HTML Entities * _IEquerySelectorAll() (by uncommon) * IE in TaskSchedulerIE Embedded Control Versioning (use IE9+ and HTML5 in a GUI) *

PDF Related:How to get reference to PDF object embeded in IE *

I encourage you to read: * Global Vars * Best Coding Practices * Please explain code used in Help file for several File functions * OOP-like approach in AutoIt * UDF-Spec Questions *  EXAMPLE: How To Catch ConsoleWrite() output to a file or to CMD *

I also encourage you to check awesome @trancexx code:  * Create COM objects from modules without any demand on user to register anything. * Another COM object registering stuffOnHungApp handlerAvoid "AutoIt Error" message box in unknown errors  * HTML editor

"Homo sum; humani nil a me alienum puto" - Publius Terentius Afer
"Program are meant to be read by humans and only incidentally for computers and execute" - Donald Knuth, "The Art of Computer Programming"
:naughty:  :ranting:, be  :) and       \\//_.

Anticipating Errors :  "Any program that accepts data from a user must include code to validate that data before sending it to the data store. You cannot rely on the data store, ...., or even your programming language to notify you of problems. You must check every byte entered by your users, making sure that data is the correct type for its field and that required fields are not empty."

Signature last update: 2021-01-03

Share this post


Link to post
Share on other sites

I tried your suggestion, but it does not work either. I also tried the following variations:

#Region Main
    Global $g_Error = ObjEvent("AutoIt.Error", "__ErrFunc")
    _Main()

    Func _Main()
        Local $obSimatic = ObjCreate("Simatic.Simatic.1")
        Local $obSubSystem = $obSimatic.Projects("AutoIt_Read").Stations("SIMATIC 300").SubSystems(101)
        $obSlave = $obSubSystem.Slaves(2)
        $obModule = $obSlave.Modules(1)

        Local Const $MODULE_UK = 0
        Local Const $MODULE_DI = 1
        Local Const $MODULE_DO = 2
        Local Const $MODULE_AI = 3
        Local Const $MODULE_AO = 4

        Local $tFlag = DllStructCreate("struct ModuleIoFlags_t;int MODULE_UK;int MODULE_DI;int MODULE_DO;int MODULE_AI;int MODULE_AO;endstruct")
        DllStructSetData($tFlag, "MODULE_UK", 0)
        DllStructSetData($tFlag, "MODULE_UK", 0)
        DllStructSetData($tFlag, "MODULE_DI", 1)
        DllStructSetData($tFlag, "MODULE_DO", 2)
        DllStructSetData($tFlag, "MODULE_AI", 3)
        DllStructSetData($tFlag, "MODULE_AO", 4)

        Local $sName = String("")
        Local $sValue = String("")

        Local $iFlag_1
        Local $iFlag_2 = Int(0)
        Local $iFlag_3 = DllStructGetPtr($tFlag)
        Local $iFlag_4 = DllStructGetPtr($tFlag, "ModuleIoFlags_t")

        Local $lChannel = 0
        Local $iResult
        $iResult = $obModule.GetFirstParameter($sName, $sValue, $iFlag_1, $lChannel)
        $iResult = $obModule.GetFirstParameter($sName, $sValue, $iFlag_2, $lChannel)
        $iResult = $obModule.GetFirstParameter($sName, $sValue, $iFlag_3, $lChannel)
        $iResult = $obModule.GetFirstParameter($sName, $sValue, $iFlag_4, $lChannel)
    EndFunc   ;==>_Main

    Func __ErrFunc($obError)
        ConsoleWrite(@TAB & "Number:        " & @TAB & StringRegExpReplace("0x" & Hex($obError.number), "[\r\n]$", "") & @CRLF)
        ConsoleWrite(@TAB & "WinDescription:" & @TAB & StringRegExpReplace($obError.windescription, "[\r\n]+$", "") & @CRLF)
        ConsoleWrite(@TAB & "Description:   " & @TAB & StringRegExpReplace($obError.description, "[\r\n]$", "") & @CRLF)
        ConsoleWrite(@TAB & "Source:        " & @TAB & StringRegExpReplace($obError.source, "[\r\n]$", "") & @CRLF)
        ConsoleWrite(@TAB & "Helpfile:      " & @TAB & StringRegExpReplace($obError.helpfile, "[\r\n]$", "") & @CRLF)
        ConsoleWrite(@TAB & "HelpContext:   " & @TAB & StringRegExpReplace($obError.helpcontext, "[\r\n]$", "") & @CRLF)
        ConsoleWrite(@TAB & "LastDllError:  " & @TAB & StringRegExpReplace($obError.lastdllerror, "[\r\n]$", "") & @CRLF)
        ConsoleWrite(@TAB & "ScriptLine:    " & @TAB & StringRegExpReplace($obError.scriptline, "[\r\n]$", "") & @CRLF)
        ConsoleWrite(@TAB & "RetCode:       " & @TAB & StringRegExpReplace("0x" & Hex($obError.retcode), "[\r\n]$", "") & @CRLF)
    EndFunc   ;==>__ErrFunc
#EndRegion Main

I have searched the forum as well, but I could not find any other post with a suggestion for typedef enum.

Edited by HurleyShanabarger

Share this post


Link to post
Share on other sites

I think that we should ask @trancexx .
Could you take a look @trancexx ?


Signature beginning:   Wondering who uses AutoIt and what it can be used for ?
* GHAPI UDF - modest beginning - communication with GitHub REST API Forum Rules *
Include Dependency Tree (Tool for analyzing script relations)
ADO.au3 UDF     POP3.au3 UDF     XML.au3 UDF    How to use IE.au3  UDF with  AutoIt v3.3.14.x  for other useful stuff click the following button

Spoiler

Any of my own code posted anywhere on the forum is available for use by others without any restriction of any kind. 

My contribution (my own projects): * Debenu Quick PDF Library - UDF * Debenu PDF Viewer SDK - UDF * Acrobat Reader - ActiveX Viewer * UDF for PDFCreator v1.x.x * XZip - UDF * AppCompatFlags UDF * CrowdinAPI UDF * _WinMergeCompare2Files() * _JavaExceptionAdd() * _IsBeta() * Writing DPI Awareness App - workaround * _AutoIt_RequiredVersion() * Chilkatsoft.au3 UDF * TeamViewer.au3 UDF * JavaManagement UDF * VIES over SOAP * WinSCP UDF * GHAPI UDF - modest begining - comunication with GitHub REST APIErrorLog.au3 UDF - A logging Library *

My contribution to others projects or UDF based on  others projects: * _sql.au3 UDF  * POP3.au3 UDF *  RTF Printer - UDF * XML.au3 UDF * ADO.au3 UDF SMTP Mailer UDF * Dual Monitor resolution detection * * 2GUI on Dual Monitor System * _SciLexer.au3 UDF * SciTE - Lexer for console pane

Useful links: * Forum Rules * Forum etiquette *  Forum Information and FAQs * How to post code on the forum * AutoIt Online Documentation * AutoIt Online Beta Documentation * SciTE4AutoIt3 getting started * Convert text blocks to AutoIt code * Games made in Autoit * Programming related sites * Polish AutoIt Tutorial * DllCall Code Generator * 

Wiki: Expand your knowledge - AutoIt Wiki * Collection of User Defined Functions * How to use HelpFile * Good coding practices in AutoIt * 

OpenOffice/LibreOffice/XLS Related: WriterDemo.au3 * XLS/MDB from scratch with ADOX

IE Related:  * How to use IE.au3  UDF with  AutoIt v3.3.14.x * Why isn't Autoit able to click a Javascript Dialog? * Clicking javascript button with no ID * IE document >> save as MHT file * IETab Switcher (by LarsJ ) * HTML Entities * _IEquerySelectorAll() (by uncommon) * IE in TaskSchedulerIE Embedded Control Versioning (use IE9+ and HTML5 in a GUI) *

PDF Related:How to get reference to PDF object embeded in IE *

I encourage you to read: * Global Vars * Best Coding Practices * Please explain code used in Help file for several File functions * OOP-like approach in AutoIt * UDF-Spec Questions *  EXAMPLE: How To Catch ConsoleWrite() output to a file or to CMD *

I also encourage you to check awesome @trancexx code:  * Create COM objects from modules without any demand on user to register anything. * Another COM object registering stuffOnHungApp handlerAvoid "AutoIt Error" message box in unknown errors  * HTML editor

"Homo sum; humani nil a me alienum puto" - Publius Terentius Afer
"Program are meant to be read by humans and only incidentally for computers and execute" - Donald Knuth, "The Art of Computer Programming"
:naughty:  :ranting:, be  :) and       \\//_.

Anticipating Errors :  "Any program that accepts data from a user must include code to validate that data before sending it to the data store. You cannot rely on the data store, ...., or even your programming language to notify you of problems. You must check every byte entered by your users, making sure that data is the correct type for its field and that required fields are not empty."

Signature last update: 2021-01-03

Share this post


Link to post
Share on other sites

Yeah, but no change. I tested most of the obvious basic stuff.

Not sure if this can be done at all with AutoIt, guess some "specialist" might have an answer to it.

Edited by HurleyShanabarger

Share this post


Link to post
Share on other sites

I have not found a solution, but started to learn C# to achieve what I need.

1/3 of the time I miss AutoIt, 1/3 I realize how much I acutally don't know and the rest I kind of enjoy it.

 

So, if anyone has further ideas, I can test it.

Share this post


Link to post
Share on other sites
  1. Have you confirmed that your VB script works successfully?
  2. What version of Step7 do you have installed?
  3. Is you Windows OS 32 or 64 bit?
  4. When you run your script in AutoIt, are you running it as 32 or 64 bit?

Share this post


Link to post
Share on other sites
  1. Yes, it is working, I made sure of it to rule out any general problem.
  2. Installed version of Step 7 is 5.6 SP with the latest Hotfix (HF5).
  3. OS is 64bit
  4. Script has to be run in 32bit, otherwise the object creation fails

Share this post


Link to post
Share on other sites

The problem that you encountered is found in the internal AutoIt code that converts proprietary AutoIt variables to standard COM data types that can be transferred to an object method.

The vast majority of data types are handled correctly. However, there are still several examples of data that are not handled correctly and therefore give rise to data type mismatch errors as in your example.

There are a few examples of solving the problems. These examples are all based on the VTable interface of the object and the ObjCreateInterface() function. Ie. your object must be dual interface. And the techniques are far from trivial and based on a manual handling of variants and safearrays.

But because your object works in VBScript code, there is a much simpler solution, which is demonstrated in this post here. In the example in the post a data type mismatch error means that an object method cannot be executed in AutoIt code. Instead, data is passed to a VBScript as global variables through a ROT object. Then the object method can be executed successfully in the VBScript code. If necessary, method output data can be passed back to the AutoIt code through the same ROT object.

Share this post


Link to post
Share on other sites

Sorry for my late reply.

I really appreciate the answer, even though I would have a liked solution to still work with my favorite scripting language. For the issues I have been asking in this thread I will deal with a solution in C#.

With another project I am trying to pass a Variant* to an com object - I hope your links will help me solve this using AutoIt.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

  • Recently Browsing   0 members

    No registered users viewing this page.

×
×
  • Create New...