Jump to content

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
Link to comment
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.

Link to comment
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:
Please remember: "AutoIt"..... *  Wondering who uses AutoIt and what it can be used for ? * Forum Rules *
ADO.au3 UDF * POP3.au3 UDF * XML.au3 UDF * IE on Windows 11 * How to ask ChatGPT for AutoIt Codefor 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 * Include Dependency Tree (Tool for analyzing script relations) * Show_Macro_Values.au3 *

 

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 * IE on Windows 11

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

winhttp.au3 related : * https://www.autoitscript.com/forum/topic/206771-winhttpau3-download-problem-youre-speaking-plain-http-to-an-ssl-enabled-server-port/

"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: 2023-04-24

Link to comment
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
Link to comment
Share on other sites

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

Signature beginning:
Please remember: "AutoIt"..... *  Wondering who uses AutoIt and what it can be used for ? * Forum Rules *
ADO.au3 UDF * POP3.au3 UDF * XML.au3 UDF * IE on Windows 11 * How to ask ChatGPT for AutoIt Codefor 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 * Include Dependency Tree (Tool for analyzing script relations) * Show_Macro_Values.au3 *

 

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 * IE on Windows 11

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

winhttp.au3 related : * https://www.autoitscript.com/forum/topic/206771-winhttpau3-download-problem-youre-speaking-plain-http-to-an-ssl-enabled-server-port/

"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: 2023-04-24

Link to comment
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?
Link to comment
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.

Link to comment
Share on other sites

  • 1 month later...

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.

Link to comment
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
 Share

  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...