Jump to content

Recommended Posts

Hi,

I've written a specialty INI file editor for a specific set of INI files related to a bigger script I'm working on.

I'm trying to create a verification script that checks the ini files structure and format and gives an error if they are not in expected format.

What I did so far is create a couple of custom arrays, each with the list of Sections expected in the files and I use IniReadSectionNames in order to read the sections from the selected INI file and compare it to the array.

It works fine, excepts it only gives an error if one or more of the sections in the custom array is missing, if they all exist but there are other additional sections that shouldn't be there it doesn't give an error and continue to open the editor screen.

Here are the relevant part of my script:

The Custom Verification Arrays:

;Creating Arrays for INI Verification
Global $aSettingsVerify[7]
$aSettingsVerify[1] = "Conversion"
$aSettingsVerify[2] = "AIO"
$aSettingsVerify[3] = "Data"
$aSettingsVerify[4] = "Redist"
$aSettingsVerify[5] = "Split"
$aSettingsVerify[6] = "Autorun"
Global $aDataVerify[6]
$aDataVerify[1] = "Compression"
$aDataVerify[2] = "Exclude"
$aDataVerify[3] = "LangExclude"
$aDataVerify[4] = "PreCommands"
$aDataVerify[5] = "PostCommands"

The IniReadSectionNames verification part:

Case $OK
                If StringInStr($ActiveConfig, "Settings.ini") Then
                    $CheckArray1 = IniReadSectionNames($ActiveConfig)
                    $CheckArray2 = _ArrayCompare($aSettingsVerify, $CheckArray1)
                    $CheckArray3 = UBound($CheckArray2, 1)
                    If $CheckArray3 = 1 Then
                        GUIDelete($ConfigStart)
                        SettingsGUI()
                    EndIf
                    If $CheckArray3 > 1 Then
                        WrongIni()
                    EndIf
                EndIf
                If StringInStr($ActiveConfig, "Data") Then
                    $CheckArray1 = IniReadSectionNames($ActiveConfig)
                    $CheckArray2 = _ArrayCompare($aDataVerify, $CheckArray1)
                    $CheckArray3 = UBound($CheckArray2, 1)
                    If $CheckArray3 = 1 Then
                        GUIDelete($ConfigStart)
                        DataGUI()
                    EndIf
                    If $CheckArray3 > 1 Then
                        WrongIni()
                    EndIf
                EndIf

The Function that performs the compare: (Found it in another thread on this forums somewhere by using Google Search)

;Compares Imported INI file with the Verification array
Func _ArrayCompare(ByRef $a1, ByRef $a2)
    Local $nOldSize = UBound($a2)
    Local $a3[$nOldSize], $nNewSize = $nOldSize

    For $i = 0 To UBound($a1) - 1
        For $j = 0 To $nOldSize - 1
            If Not $a3[$j] And ($a1[$i] = $a2[$j]) Then
                $a3[$j] = 1
                $nNewSize -= 1
            EndIf
        Next
    Next

    Local $a4[$nNewSize], $j = 0
    For $i = 0 To $nOldSize - 1
        If Not $a3[$i] Then
            $a4[$j] = $a2[$i]
            $j += 1
        EndIf
    Next

    Return $a4
EndFunc   ;==>_ArrayCompare

 

Any way to make a check if there are sections other than the ones in the Verification Array and produce an error?

Thanks

Ron Vollach
Microsoft Certified Professional (MCP)
Creator of Ultimate Conversion Compressor (UCC)
UCC Wikia

Link to post
Share on other sites
  • Moderators

VollachR,

Run a check of the size of the array returned by IniReadSectionNames - if it is larger than the checking array there are too many entries.

M23

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

Open spoiler to see my UDFs:

Spoiler

ArrayMultiColSort ---- Sort arrays on multiple columns
ChooseFileFolder ---- Single and multiple selections from specified path treeview listing
Date_Time_Convert -- Easily convert date/time formats, including the language used
ExtMsgBox --------- A highly customisable replacement for MsgBox
GUIExtender -------- Extend and retract multiple sections within a GUI
GUIFrame ---------- Subdivide GUIs into many adjustable frames
GUIListViewEx ------- Insert, delete, move, drag, sort, edit and colour ListView items
GUITreeViewEx ------ Check/clear parent and child checkboxes in a TreeView
Marquee ----------- Scrolling tickertape GUIs
NoFocusLines ------- Remove the dotted focus lines from buttons, sliders, radios and checkboxes
Notify ------------- Small notifications on the edge of the display
Scrollbars ----------Automatically sized scrollbars with a single command
StringSize ---------- Automatically size controls to fit text
Toast -------------- Small GUIs which pop out of the notification area

 

Link to post
Share on other sites

As Melba23 pointed out you can compare section name count for example:

If UBound($CheckArray1) - 1 <> UBound($aSettingsVerify) - 1 Then ... ;~ Action here

Alternatively you can get an array of incorrect names and also compare the sizes for example:

#include <Array.au3>
Global $aVerify[7]
$aVerify[1] = "Conversion"
$aVerify[2] = "AIO"
$aVerify[3] = "Data"
$aVerify[4] = "Redist"
$aVerify[5] = "Split"
$aVerify[6] = "Autorun"

;~ IniReadSection
Global $aSection[9]
$aSection[1] = "Conversion"
$aSection[2] = "AIO"
$aSection[3] = "Data"
$aSection[4] = "Redist"
$aSection[5] = "Split"
$aSection[6] = "Autorun"
$aSection[7] = "AutoRunning"
$aSection[8] = "Confersion"

Global $aCompare = _SectionCompare($aSection, $aVerify)
_ArrayDisplay($aCompare, "Error Return = " & @error)

Func _SectionCompare($_aSections, $_aVerification)
    Local $_iError, $_iSearch
    If (UBound($_aSections) -1) < (UBound($_aVerification) - 1) Then $_iError = -1 ;~ $_aSections Array Count less than $_aVerification Array Count
    If (UBound($_aSections) -1) = (UBound($_aVerification) - 1) Then $_iError = 0 ;~ $_aSections Array Count equal to $_aVerification Aay Count
    If (UBound($_aSections) -1) > (UBound($_aVerification) - 1) Then $_iError = 1 ;~ $_aSections Array Count greater than $_aVerification Array Count
    ;~ Check items in $_aSections that match an item in $_aVerification
    For $i = UBound($_aVerification) - 1 To 0 Step - 1
        ConsoleWrite($_aVerification[$i] & @CRLF)
        $_iSearch = _ArraySearch($_aSections, $_aVerification[$i])
        If $_iSearch = -1 Then ContinueLoop
        _ArrayDelete($_aSections, $_iSearch)
    Next
    Return SetError($_iError, 0, $_aSections)
EndFunc

 

Link to post
Share on other sites
21 minutes ago, Melba23 said:

VollachR,

Run a check of the size of the array returned by IniReadSectionNames - if it is larger than the checking array there are too many entries.

M23

I thought about that but I'm not sure how to modify the existing function to include that check, as I said, I found that function online, don't remember where or who wrote it but I didn't do it myself, all I did was remove the _ArrayDisplay that was near the end of the function.

 

5 minutes ago, Subz said:

As Melba23 pointed out you can compare section name count for example:

If UBound($CheckArray1) - 1 <> UBound($aSettingsVerify) - 1 Then ... ;~ Action here

Alternatively you can get an array of incorrect names and also compare the sizes for example:

#include <Array.au3>
Global $aVerify[7]
$aVerify[1] = "Conversion"
$aVerify[2] = "AIO"
$aVerify[3] = "Data"
$aVerify[4] = "Redist"
$aVerify[5] = "Split"
$aVerify[6] = "Autorun"

;~ IniReadSection
Global $aSection[9]
$aSection[1] = "Conversion"
$aSection[2] = "AIO"
$aSection[3] = "Data"
$aSection[4] = "Redist"
$aSection[5] = "Split"
$aSection[6] = "Autorun"
$aSection[7] = "AutoRunning"
$aSection[8] = "Confersion"

Global $aCompare = _SectionCompare($aSection, $aVerify)
_ArrayDisplay($aCompare, "Error Return = " & @error)

Func _SectionCompare($_aSections, $_aVerification)
    Local $_iError, $_iSearch
    If (UBound($_aSections) -1) < (UBound($_aVerification) - 1) Then $_iError = -1 ;~ $_aSections Array Count less than $_aVerification Array Count
    If (UBound($_aSections) -1) = (UBound($_aVerification) - 1) Then $_iError = 0 ;~ $_aSections Array Count equal to $_aVerification Aay Count
    If (UBound($_aSections) -1) > (UBound($_aVerification) - 1) Then $_iError = 1 ;~ $_aSections Array Count greater than $_aVerification Array Count
    ;~ Check items in $_aSections that match an item in $_aVerification
    For $i = UBound($_aVerification) - 1 To 0 Step - 1
        ConsoleWrite($_aVerification[$i] & @CRLF)
        $_iSearch = _ArraySearch($_aSections, $_aVerification[$i])
        If $_iSearch = -1 Then ContinueLoop
        _ArrayDelete($_aSections, $_iSearch)
    Next
    Return SetError($_iError, 0, $_aSections)
EndFunc

 

I don't see how the 2nd example will work, if somebody modifies the ini file and add a section that shouldn't be there I have no way to guess what section name that person added, so I can't really create an array with incorrect names as that can be anything that isn't in the verification array.

As for the first suggestion, as I said above for Melba23's answer, I'm not sure where or how to add that into the existing _ArrayCompare function, or is there away to add it in the part of the script that calls the function without messing things up?

Ron Vollach
Microsoft Certified Professional (MCP)
Creator of Ultimate Conversion Compressor (UCC)
UCC Wikia

Link to post
Share on other sites

The $aSection above was an example of an IniReadSection, it should return the differences, here is another example since I didn't  make the first a 2D Array and forgot about comparing the results after the loop.  As I only have partial piece of your script I can't test so will leave it with you.

#include <Array.au3>

Global $aSettingsVerify[7]
    $aSettingsVerify[1] = "Conversion"
    $aSettingsVerify[2] = "AIO"
    $aSettingsVerify[3] = "Data"
    $aSettingsVerify[4] = "Redist"
    $aSettingsVerify[5] = "Split"
    $aSettingsVerify[6] = "Autorun"

Global $aDataVerify[6]
    $aDataVerify[1] = "Compression"
    $aDataVerify[2] = "Exclude"
    $aDataVerify[3] = "LangExclude"
    $aDataVerify[4] = "PreCommands"
    $aDataVerify[5] = "PostCommands"

If StringInStr($ActiveConfig, "Settings.ini") Then
    $CheckArray1 = IniReadSectionNames($ActiveConfig)
    $CheckArray2 = _SectionCompare($CheckArray1, $aSettingsVerify)
    Switch @error
        Case -2, -1, 1
            GUIDelete($ConfigStart)
            SettingsGUI()
    EndSwitch
    _ArrayDisplay($CheckArray2, "Error Return = " & @error)
EndIf
If StringInStr($ActiveConfig, "Data") Then
    $CheckArray1 = IniReadSectionNames($ActiveConfig)
    $CheckArray2 = _SectionCompare($CheckArray1, $aDataVerify)
    Switch @error
        Case -2, -1, 1
            GUIDelete($ConfigStart)
            SettingsGUI()
    EndSwitch
    _ArrayDisplay($CheckArray2, "Error Return = " & @error)
EndIf

; ==================================================================================================
; Func _SectionCompare($_aSections, $_aVerification)
;
; $_aSections       := Section Names Array
; $_aVerifcation    := Verification Array
;
; Returns:
;   Success: "" with @error set to 0
;   Failure: "" if $_aSections is empty or $_vResult Array with differnces, with @error set
;       @error = -2 = $_aSections Array contains incorrect data
;       @error = -1 $_aSections Array Count less than $_aVerification Array Count
;       @error = 1 $_aSections Array Count greater than $_aVerification Array Count
;
; Author: Subz
; ==================================================================================================

Func _SectionCompare($_aSections, $_aVerification)
    Local $_iError, $_iSearch
    If (UBound($_aSections) -1) < (UBound($_aVerification) - 1) Then $_iError = -1 ;~ $_aSections Array Count less than $_aVerification Array Count
    If (UBound($_aSections) -1) = (UBound($_aVerification) - 1) Then $_iError = 0 ;~ $_aSections Array Count equal to $_aVerification Aay Count
    If (UBound($_aSections) -1) > (UBound($_aVerification) - 1) Then $_iError = 1 ;~ $_aSections Array Count greater than $_aVerification Array Count
    ;~ Check items in $_aSections that match an item in $_aVerification
    For $i = UBound($_aVerification) - 1 To 0 Step - 1
        $_iSearch = _ArraySearch($_aSections, $_aVerification[$i], 0, 0, 0, 0, 1, 0)
        If $_iSearch = -1 Then ContinueLoop
        _ArrayDelete($_aSections, $_iSearch)
    Next
    $_iError = UBound($_aSections) -1 = 0 ? 0 : -2
    $_vReturn = UBound($_aSections) = 0 ? "" : $_aSections
    Return SetError($_iError, 0, $_vReturn)
EndFunc

 

Link to post
Share on other sites

OK, turned out I didn't need that additional check after all, my existing check was enough once I moved another part of the script from another "Case" into the "Case $OK" portion, it was probably a logic issue.

I accidentally made the script import the in sections (with IniReadSection) to Arrays before performing the check instead of after, which caused my problem, now that I moved it to be done after the check is performed I get the error message at every situation it needs to be without any additional checks.

That's the change I made:

Case $OK
                If StringInStr($ActiveConfig, "Settings.ini") Then
                    $CheckArray1 = IniReadSectionNames($ActiveConfig)
                    $CheckArray2 = _ArrayCompare($aSettingsVerify, $CheckArray1)
                    $CheckArray3 = UBound($CheckArray2, 1)
                    If $CheckArray3 = 1 Then
                        Global $aConversion = IniReadSection($ActiveConfig, "Conversion")
                        Global $aAIO = IniReadSection($ActiveConfig, "AIO")
                        Global $aData = IniReadSection($ActiveConfig, "Data")
                        Global $aRedist = IniReadSection($ActiveConfig, "Redist")
                        Global $aSplit = IniReadSection($ActiveConfig, "Split")
                        Global $aAutorun = IniReadSection($ActiveConfig, "Autorun")
                        GUIDelete($ConfigStart)
                        SettingsGUI()
                    EndIf
                    If $CheckArray3 > 1 Then
                        WrongIni()
                    EndIf
                EndIf
                If StringInStr($ActiveConfig, "Data") Then
                    $CheckArray1 = IniReadSectionNames($ActiveConfig)
                    $CheckArray2 = _ArrayCompare($aDataVerify, $CheckArray1)
                    $CheckArray3 = UBound($CheckArray2, 1)
                    If $CheckArray3 = 1 Then
                        Global $aCompression = IniReadSection($ActiveConfig, "Compression")
                        Global $aExclude = IniReadSection($ActiveConfig, "Exclude")
                        Global $aLangExclude = IniReadSection($ActiveConfig, "LangExclude")
                        Global $aPreCommands = IniReadSection($ActiveConfig, "PreCommands")
                        Global $aPostCommands = IniReadSection($ActiveConfig, "PostCommands")
                        GUIDelete($ConfigStart)
                        DataGUI()
                    EndIf
                    If $CheckArray3 > 1 Then
                        WrongIni()
                    EndIf
                EndIf

Before I had these IniReadSection lines in a previous Case for a ComboBox that let the user select the Ini file to edit before enabling the OK button, now it's in the OK button case after the check if it's correct.

These IniReadSection arrays are used to later fill the edit fields in the GUI, don't know why creating them earlier caused a problem but it works now.

Ron Vollach
Microsoft Certified Professional (MCP)
Creator of Ultimate Conversion Compressor (UCC)
UCC Wikia

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.

  • Similar Content

    • By DJ143
      I have a autoit exe file which is used in upload/browse file functionality.  This has been integrated with selenium framework and I am invoking the autoit exe using Java process and runtime. 
      Now the issue is when I run the scripts and invoke the autoit exe in local it works perfectly.  But when I use selenium grid or jenkins to run the scripts in another windows server it is not working.
      Can anyone please suggest any solution for this?
    • By Hermes
      Hello, the script below will read column A from an excel file - and if a value matches in the browser, it will click the corresponding link and click on a specific button to paste the data, then writes "Completed" in Column B. It will continue to read from the excel file and do the same thing for all the remaining rows.
      #Include "Chrome.au3" #Include "wd_core.au3" #Include "wd_helper.au3" #Include "WinHttp.au3" #include <MsgBoxConstants.au3> #include <File.au3> #include <IE.au3> #include <Array.au3> #include <INet.au3> #include <AutoItConstants.au3> #include <WinAPIFiles.au3> #include <GDIPlus.au3> #include <Excel.au3> #Include "WinHttp.au3" #Include "_HtmlTable2Array.au3" Local $sDesiredCapabilities, $sSession SetupChrome() _WD_Startup() $sSession = _WD_CreateSession($sDesiredCapabilities) _WD_LoadWait($sSession) _WD_Navigate($sSession, "table1.html") _WD_LoadWait($sSession) _WD_WaitElement($sSession, $_WD_LOCATOR_ByXPath, "//table[@class='main']") Local $sElement = _WD_FindElement($sSession, $_WD_LOCATOR_ByXPath, "//table[@class='main']") ;ConsoleWrite ("mat-table " & $sElement & @CRLF) Local $aArray1 = _WD_FindElement($sSession, $_WD_LOCATOR_ByXPath, ".//td[contains(@class,'data')]", $sElement, True) sleep(1000) For $i = 0 to UBound($aArray1) - 1 $aArray1[$i] = _WD_ElementAction($sSession, $aArray1[$i], 'text') Next ;_ArrayDisplay($aArray1) ;Email variables $SmtpServer = "" ; address for the smtp-server to use - REQUIRED $FromName = "Hermes" ; name from who the email was sent $FromAddress = "sender@gmail.com" ; address from where the mail should come $ToAddress = "recipient@gmail.com" ; destination address of the email - REQUIRED, use commas (,) to add more email addresses $Subject = "File not found" ; subject from the email - can be anything you want it to be $Body = "File not found!" ; the messagebody from the mail - can be left blank but then you get a blank mail $AttachFiles = "" ; the file(s) you want to attach seperated with a ; (Semicolon) - leave blank if not needed $CcAddress = "" ; address for cc - leave blank if not needed $BccAddress = "" ; address for bcc - leave blank if not needed $Importance = "High" ; Send message priority: "High", "Normal", "Low" $Username = "" ; username for the account used from where the mail gets sent - REQUIRED $Password = "" ; password for the account used from where the mail gets sent - REQUIRED $IPPort = 25 ; port used for sending the mail $ssl = 0 ; enables/disables secure socket layer sending - put to 1 if using httpS $tls = 0 ; enables/disables TLS when required Local $oAppl = _Excel_Open() Local $sWorkbook = "c:\test.xlsx" Local $oWorkbook = _Excel_BookOpen($oAppl, $sWorkbook) ;open excel and pass both parameters If FileExists($sWorkbook) Then ;Check if the file exist. Local $oAppl = _Excel_Open() Local $sWorkbook = "c:\test.xlsx" Local $oWorkbook = _Excel_BookOpen($oAppl, $sWorkbook) ;open excel and pass both parameters Local $aArray2 = _Excel_RangeRead($oWorkbook,Default,$oWorkbook.ActiveSheet.Usedrange.Columns("A:A")) Local $iIdx Local $Skipline = 0 ;0==> first line Do Local $temprf For $i = 0 To UBound($aArray2) - 1 $temprf &= $aArray2[$i] _WD_WaitElement($sSession, $_WD_LOCATOR_ByXPath, ".//a[contains(@class,'edit') and contains(text(),'Edit')]") Local $aElement = _WD_FindElement($sSession, $_WD_LOCATOR_ByXPath, ".//a[contains(@class,'edit') and contains(text(),'Edit')]", $sElement, True) $iIdx = _ArraySearch($aArray1, $aArray2[$i]) If @error Then ContinueLoop _WD_ElementAction($sSession, $aElement[$iIdx], 'click') If $i < $Skipline Then ContinueLoop $oRange = $oWorkbook.ActiveSheet.Range("B" & $i + 1 & ":XFD" & $i + 1) _Excel_RangeCopyPaste($oWorkbook.Activesheet, $oRange) ;Paste Local $oTest4 = _WD_FindElement($sSession, $_WD_LOCATOR_ByCSSSelector, "pastebutton") _WD_ElementAction($sSession, $oTest4, 'click') Sleep(1000) ;Save Button Local $save3 = _WD_FindElement($sSession, $_WD_LOCATOR_ByCSSSelector, "button.button") _WD_ElementAction($sSession, $save3, 'click') _Excel_RangeWrite($oWorkbook, $oWorkbook.Activesheet, "Completed", "B" & $i+1) sleep(1000) Next Until (Not @error) _Excel_Close($oWorkbook) Else _INetSmtpMailCom($SmtpServer, $FromName, $FromAddress, $ToAddress, $Subject, $Body, $CcAddress, $BccAddress, $Importance, $Username, $Password, $IPPort, $ssl, $tls) Exit EndIf _WD_LoadWait($sSession) ;Attaching files to emails Func _INetSmtpMailCom($s_SmtpServer, $s_FromName, $s_FromAddress, $s_ToAddress, $s_Subject = "", $as_Body = "", $s_CcAddress = "", $s_BccAddress = "", $s_Importance="Normal", $s_Username = "", $s_Password = "", $IPPort = 25, $ssl = 0, $tls = 0) Local $objEmail = ObjCreate("CDO.Message") $objEmail.From = '"' & $s_FromName & '" <' & $s_FromAddress & '>' $objEmail.To = $s_ToAddress Local $i_Error = 0 Local $i_Error_desciption = "" If $s_CcAddress <> "" Then $objEmail.Cc = $s_CcAddress If $s_BccAddress <> "" Then $objEmail.Bcc = $s_BccAddress $objEmail.Subject = $s_Subject If StringInStr($as_Body, "<") And StringInStr($as_Body, ">") Then $objEmail.HTMLBody = $as_Body Else $objEmail.Textbody = $as_Body & @CRLF EndIf $objEmail.Configuration.Fields.Item ("http://schemas.microsoft.com/cdo/configuration/sendusing") = 2 $objEmail.Configuration.Fields.Item ("http://schemas.microsoft.com/cdo/configuration/smtpserver") = $s_SmtpServer If Number($IPPort) = 0 then $IPPort = 25 $objEmail.Configuration.Fields.Item ("http://schemas.microsoft.com/cdo/configuration/smtpserverport") = $IPPort ;Authenticated SMTP If $s_Username <> "" Then $objEmail.Configuration.Fields.Item ("http://schemas.microsoft.com/cdo/configuration/smtpauthenticate") = 1 $objEmail.Configuration.Fields.Item ("http://schemas.microsoft.com/cdo/configuration/sendusername") = $s_Username $objEmail.Configuration.Fields.Item ("http://schemas.microsoft.com/cdo/configuration/sendpassword") = $s_Password EndIf ; Set security params If $ssl Then $objEmail.Configuration.Fields.Item ("http://schemas.microsoft.com/cdo/configuration/smtpusessl") = True If $tls Then $objEmail.Configuration.Fields.Item ("http://schemas.microsoft.com/cdo/configuration/sendtls") = True ;Update settings $objEmail.Configuration.Fields.Update ; Set Email Importance Switch $s_Importance Case "High" $objEmail.Fields.Item ("urn:schemas:mailheader:Importance") = "High" Case "Normal" $objEmail.Fields.Item ("urn:schemas:mailheader:Importance") = "Normal" Case "Low" $objEmail.Fields.Item ("urn:schemas:mailheader:Importance") = "Low" EndSwitch $objEmail.Fields.Update ; Sent the Message $objEmail.Send $objEmail="" EndFunc ;==>_INetSmtpMailCom Local $aDir = _FileListToArrayRec(@TempDir, "scoped_dir*;chrome_*", $FLTAR_FOLDERS, $FLTAR_NORECUR, $FLTAR_NOSORT, $FLTAR_FULLPATH) Sleep(2000) For $i = 1 To $aDir[0] DirRemove($aDir[$i], $DIR_REMOVE) Next _WD_LoadWait($sSession) _WD_Shutdown() Func SetupChrome() _WD_Option('Driver', 'chromedriver.exe') _WD_Option('Port', 9515) _WD_Option('DriverParams', '--log-path="' & @ScriptDir & '\chrome.log"') $sDesiredCapabilities = '{"capabilities": {"alwaysMatch": {"goog:chromeOptions": {"w3c": true, "args":["start-maximized","disable-infobars"]}}}}' EndFunc ;==>SetupChrome If the excel file doesn't exists in the folder, it will send an email to a specific recipient.
      What i am trying figure out now is if the excel crashes while the script/loop is running, I want to relaunch the excel file continue to the last row before the excel crashed. So if the value of column B is not marked as "completed", it should continue from that row
      Appreciate any help that I can get to achieve this.
      table1.html test.xlsx
    • By adityaparakh
      Hello ,
      I am trying to use Websockets in AutoIt.
      It is to fetch live stock market prices , API is provided and documentation available for python language.
      The link for the code snippet is :
      https://symphonyfintech.com/xts-market-data-front-end-api-v2/#tag/Introduction
      https://symphonyfintech.com/xts-market-data-front-end-api-v2/#tag/Instruments/paths/~1instruments~1subscription/post
       
      https://github.com/symphonyfintech/xts-pythonclient-api-sdk
       
      Second Link is to subscribe to a list of ExchangeInstruments.
      Now I would like to get live stock ltp (LastTradedPrice) for a few stocks whose "ExchangeInstrumentID" I know.
      I am able to use the WinHttp object to perform actions using simple codes like below :
      I have the secretKey and appkey and can generate the needed token. And get the unique ExchangeInstrumentID.

      Below code is just for example of how I am using WinHttp. Unrelated to socket part.
      Global $InteractiveAPItoken = IniRead(@ScriptDir & "\Config.ini", "token", "InteractiveAPItoken", "NA") $baseurl = "https://brokerlink.com/interactive/" $functionurl = "orders" $oHTTP = ObjCreate("winhttp.winhttprequest.5.1") $oHTTP.Open("POST", $baseurl & $functionurl, False) $oHTTP.SetRequestHeader("Content-Type", "application/json;charset=UTF-8") $oHTTP.SetRequestHeader("authorization", $InteractiveAPItoken) $pD = '{ "exchangeSegment": "NSEFO", "exchangeInstrumentID": ' & $exchangeInstrumentID & ', "productType": "' & $producttype & '", "orderType": "MARKET", "orderSide": "' & $orderside & '", "timeInForce": "DAY", "disclosedQuantity": 0, "orderQuantity": ' & $qty & ', "limitPrice": 0, "stopPrice": 0, "orderUniqueIdentifier": "' & $orderidentifier & '"}' $oHTTP.Send($pD) $oReceived = $oHTTP.ResponseText $oStatusCode = $oHTTP.Status
          
          
      But am struggling to understand and use socket.
      Would be of great help if you can have a look at the link mentioned above and help with the code sample for AutoIt.
      To connect and listen to a socket.
      Thanks a lot
       
    • By Hermes
      Hi, I have a site that has the following elements below: 
      <div>More element here</div> <div>More element here</div> <div>More element here</div> When I do this in Auto It:
      Local $oSelectDiv = _WD_FindElement($sSession, $_WD_LOCATOR_ByCSSSelector, "div") _WD_HighlightElement($sSession, $oSelectDiv, 1) I also tried to add [3], but it doesnt seems to work:
      Local $oSelectDiv = _WD_FindElement($sSession, $_WD_LOCATOR_ByCSSSelector, "div[3]") _WD_HighlightElement($sSession, $oSelectDiv, 1) It always highlight the first one, but I am trying to highlight the 3rd in the list. Is there anyway to select the 3rd div without having to add any class/id in the divs, and without using XPATH? The structure of the elements in that site were built that way.
    • By meety
      My au3 script program needs administrator privileges on win10 to be executed correctly, because it needs to be added to the boot---Script code:RegWrite("HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Run", @ScriptName, "REG_SZ", @ScriptFullPath)
      I need to let the program automatically get administrator privileges, so I use a function of #RequireAdmin. Although the program can be added to the boot, but does not execute after system boot up? why is that?
      What should I do?
      --------------------------------------------------------------------
      Update:
      I found that after using the #RequireAdmin function, the program cannot be executed after system boot up.
      An example is given below. after it is compiled, it will not be executed after system boot up in the following two ways.
      1. C:\ProgramData\Microsoft\Windows\Start Menu\Programs\StartUp\
      2. RegWrite("HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Run", @ScriptName, "REG_SZ", @ScriptFullPath)
      why is that?
      example
      #include <MsgBoxConstants.au3>
      #RequireAdmin
      Func test()
          MsgBox(0, "", "this is test message")
      EndFunc   ;==>test
      test()
       
       
×
×
  • Create New...