Jump to content
Sign in to follow this  
mLipok

AU3 Tools - Quick Updater

Recommended Posts

mLipok

Referring to:

and

/?do=embed#entry1102929'' frameborder='0' data-embedContent>>

I would like to present AU3 Tools - Quick Updater :

Global $URL_Scite = 'http://www.autoitscript.com/autoit3/scite/download/beta_SciTE4AutoIt3/'

_INET_DownloadIfNotEqual("AutoIt3Wrapper.exe")
_INET_DownloadIfNotEqual("Obfuscator.exe")
_INET_DownloadIfNotEqual("SciTE.exe")
_INET_DownloadIfNotEqual("SciteConfig.exe")
_INET_DownloadIfNotEqual("Tidy.exe")
_INET_DownloadIfNotEqual("SciLexer.dll")

Func _INET_DownloadIfNotEqual($fFileToDownlad)
    Local $fLocalDestination
    If _INET_CompareSize_IsEqual($fFileToDownlad) = False Then
        $fLocalDestination = _INET_GetUpdate($fFileToDownlad)
        FileMove($fLocalDestination, @ScriptDir & '\' & $fFileToDownlad, 1)
    EndIf
EndFunc   ;==>_INET_DownloadIfNotEqual

Func _INET_CompareSize_IsEqual($fFileToDownlad)
    Local $nWebSize = InetGetSize($URL_Scite & $fFileToDownlad)
    Local $nLocalSize = FileGetSize(@ScriptDir & '\' & $fFileToDownlad)
    If $nWebSize = $nLocalSize Then
        Return True
    Else
        Return False
    EndIf
EndFunc   ;==>_INET_CompareSize_IsEqual

Func _INET_GetUpdate($fFileToDownlad)
    Local $fLocalDestination = @TempDir & "\" & $fFileToDownlad
    Local $hDownload = InetGet($URL_Scite & $fFileToDownlad, $fLocalDestination, 1, 1)
    Do
        Sleep(250)
    Until InetGetInfo($hDownload, 2) ; Check if the download is complete.
    Local $nBytes = InetGetInfo($hDownload, 0)
    InetClose($hDownload) ; Close the handle to release resources.
    Return $fLocalDestination
EndFunc   ;==>_INET_GetUpdate

HOW TO USE:

Simply compile and run waiting to download current updates tools

If You want to replace file in SciTE4AutoIt dir then run it script from directory where SciTE4AutoIt is instaled

 

ps.

This is a really fast set up, update tool
contains no error checking
requires no configuration
requires that the target downloaded files were not used by other Windows processes
 
 
EDIT:
CAUTION:
 
EDIT:
WORD JOKE : as they say on the commercial
"before use, read the label or contact your doctor or pharmacist" :)
Edited by mlipok

Signature beginning:   Wondering who uses AutoIT and what it can be used for ?
* GHAPI UDF - modest begining - comunication with GitHub REST API *
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 API *

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 *

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 * 

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) * 

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 *

"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: 2018-03-17

Share this post


Link to post
Share on other sites
Melba23

Hi,

Just for emphasis: Using this tool will download the latest Beta versions of the various SciTE files and tools. As their name implies, these versions are not for general release and are often "works in progress" which may not be entirely backwards compatible nor fully functional - although as a rule Jos does a pretty good job of not breaking things. ;)

So please read his post in the "CAUTION" link above - and remember that if you do use this app, it is at your own risk and peril. :pirate:

M23

Edit: No need to read the link - just look below! :D

Edited by Melba23

Any of my own code posted anywhere on the forum is available for use by others without any restriction of any kind._______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

 

Share this post


Link to post
Share on other sites
Jos

@mlipok,

I hope you did get the point I made earlier that I am not a fan of this and that this is not being supported by me.

It is fine when you want to use it for yourself but downloading the Beta versions of the utilities sometimes require extra changes to be made.

One prime example of that was with an upgrade of SciTE which also required to update an LUA file or else SciTE would become unresponsive.

End of all my disclaimer replies ;)

Jos


Visit the SciTE4AutoIt3 Download page for the latest versions  - Beta files                                How to post scriptsource        Forum Rules
 
Live for the present,
Dream of the future,
Learn from the past.
  :)

Share this post


Link to post
Share on other sites
mLipok

Thank you for Your attention and valuable comments as for me and for the potential users of this script.

I hope that for those who test new tools and beta versions of AutoIt these tools will be helpful.


Signature beginning:   Wondering who uses AutoIT and what it can be used for ?
* GHAPI UDF - modest begining - comunication with GitHub REST API *
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 API *

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 *

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 * 

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) * 

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 *

"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: 2018-03-17

Share this post


Link to post
Share on other sites
Myicq

Assume that this tool could be used to update anything locally compared to a remote server, right ?

If so, the OP could simply change the URL to be unimportant dummy files. Would still prove the funtion but would not cause (relevant) issues with beta versions.


I am just a hobby programmer, and nothing great to publish right now.

Share this post


Link to post
Share on other sites
mLipok

@Myicq

if You want to update Your own aplication 

Yes You can but you have to modify the script exactly as it says @jaberwocky6669


Signature beginning:   Wondering who uses AutoIT and what it can be used for ?
* GHAPI UDF - modest begining - comunication with GitHub REST API *
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 API *

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 *

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 * 

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) * 

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 *

"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: 2018-03-17

Share this post


Link to post
Share on other sites
mLipok

First I want to thanks @Melba23 for "DTC.au3" 

'?do=embed' frameborder='0' data-embedContent>>


New version:

#Tidy_Parameters=/reel
#AutoIt3Wrapper_Au3Check_Parameters=-q -d -w 1 -w 2 -w 3 -w- 4 -w 5 -w 6 -w- 7

Global $URL_Scite = 'http://www.autoitscript.com/autoit3/scite/download/beta_SciTE4AutoIt3/'
Global $sRaport = ''

#include <Date.au3>
#include <debug.au3>
#include <IE.au3>
#include <array.au3>
#include <MsgBoxConstants.au3>
#include "DTC.au3" ; http://www.autoitscript.com/forum/topic/154684-date-time-convert-initial-release-17-sep-13/

_DebugSetup()
_Main()

Func _Main()
    Local $sIn_Date, $sOut_Date, $sName, $sWebDate
    Local $oIE = _IECreate("http://www.autoitscript.com/autoit3/scite/download/beta_SciTE4AutoIt3/?C=M;O=D")
    Local $sText = _IEBodyReadText($oIE)
;~  ClipPut($sText)
    _IEQuit($oIE)

    Local $aResult = StringRegExp($sText, "(?i)(.*)(\d\d-\w*-\d{4})", 3)
;~ _ArrayDisplay($aResult,'$aResult')

    For $i = 0 To UBound($aResult) - 1 Step 2
        $sName = $aResult[$i]
        $sWebDate = $aResult[$i + 1]
        $sIn_Date = $sWebDate
        $sOut_Date = _Date_Time_Convert($sIn_Date, "dd-MMM-yyyy", "yyyy/MM/dd")
        _INET_DownloadIfNotEqual($sName, $sOut_Date)
        _DebugOut('')
    Next

    If $sRaport = '' Then $sRaport = 'Not downloaded any files.'
    _DebugOut('')
    _DebugOut('=====================================================================================')
    _DebugOut('')
    _DebugOut('SUMMARY: List of downloaded files:')
    _DebugOut($sRaport)
    _DebugOut('')
    _DebugOut('=====================================================================================')
    _DebugOut('')

EndFunc   ;==>_Main

Func _INET_DownloadIfNotEqual($fFileToDownlad, $sWebDate = Default)
    Local $sSubDir
    Local $fLocalDestination
    Local $fLocalFinalDestination = @ScriptDir & '\BETADownload\'
    If FileExists($fLocalFinalDestination) = 0 Then DirCreate($fLocalFinalDestination)
    If StringInStr($fFileToDownlad, '/') Then
        _DebugOut('... skipping :' & $fFileToDownlad)
    Else
        _DebugOut($fFileToDownlad & ' :')
        Select
            Case $fFileToDownlad = 'Tidy.exe'
                $sSubDir = $fLocalFinalDestination & 'Tidy\'
            Case $fFileToDownlad = 'AutoIt3Wrapper.exe' Or $fFileToDownlad = 'AutoIt3Wrapper.au3'
                $sSubDir = $fLocalFinalDestination & 'AutoIt3Wrapper\'
            Case $fFileToDownlad = 'Obfuscator.exe'
                $sSubDir = $fLocalFinalDestination & 'Obfuscator\'
            Case $fFileToDownlad = 'SciteConfig.exe' Or $fFileToDownlad = 'SciteConfig.au3'
                $sSubDir = $fLocalFinalDestination & 'SciteConfig\'
            Case StringRight($fFileToDownlad, 4) = '.lua'
                $sSubDir = $fLocalFinalDestination & 'LUA\'
            Case Else
                $sSubDir = $fLocalFinalDestination
        EndSelect
        _DebugOut('$sSubDir = ' & $sSubDir)
        If FileExists($sSubDir) = 0 Then DirCreate($sSubDir)
        Local $sLocalDate = StringLeft(FileGetTime($sSubDir & $fFileToDownlad, $FT_MODIFIED, 1), 8)
        $sLocalDate = _Date_Time_Convert($sLocalDate, "yyyyMMdd", "yyyy/MM/dd")
        _DebugOut('$sWebDate  = ' & $sWebDate)
        _DebugOut('$sLocalDate = ' & $sLocalDate)
        If _
                _INET_CompareSize_IsEqual($fFileToDownlad, $sSubDir) = False Or _
                _DateDiff('D', $sLocalDate, $sWebDate) > 0 _
                Then
            _DebugOut('!!! Downloading: ' & $fFileToDownlad)
            $fLocalDestination = _INET_GetUpdate($fFileToDownlad)
            FileMove($fLocalDestination, $sSubDir & $fFileToDownlad, 1)
        EndIf
    EndIf
    _DebugOut('')
    _DebugOut('')
EndFunc   ;==>_INET_DownloadIfNotEqual

Func _INET_CompareSize_IsEqual($fFileToDownlad, $sSubDir)
    Local $vWebSize = InetGetSize($URL_Scite & $fFileToDownlad)
    Local $vLocalSize = FileGetSize($sSubDir & $fFileToDownlad)
;~  _DebugOut('$fFileToDownlad = ' & $fFileToDownlad )
    _DebugOut('$vWebSize  = ' & $vWebSize)
    _DebugOut('$vLocalSize = ' & $vLocalSize)
    Return $vWebSize = $vLocalSize
EndFunc   ;==>_INET_CompareSize_IsEqual

Func _INET_GetUpdate($fFileToDownlad)
    Local $fLocalDestination = @TempDir & "\" & $fFileToDownlad
    Local $hDownload = InetGet($URL_Scite & $fFileToDownlad, $fLocalDestination, 1, 1)
    Do
        Sleep(250)
    Until InetGetInfo($hDownload, 2) ; Check if the download is complete.
;~  Local $nBytes = InetGetInfo($hDownload, 0)
    InetClose($hDownload) ; Close the handle to release resources.
    $sRaport &= $fFileToDownlad & @CRLF
    Return $fLocalDestination
EndFunc   ;==>_INET_GetUpdate

REMARKS:

Read post #2 #3 #4 before using this script.

Whats new:

- check not only sizes (as before) but also file dates
- saving files in subdirectories

- reports in _DebugOut()

- using "DTC.au3"
- created to build using the latest version of AutoIt BETA
Edited by mlipok

Signature beginning:   Wondering who uses AutoIT and what it can be used for ?
* GHAPI UDF - modest begining - comunication with GitHub REST API *
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 API *

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 *

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 * 

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) * 

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 *

"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: 2018-03-17

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
Sign in to follow this  

  • Similar Content

    • JuanFelipe
      By JuanFelipe
      Hello friends, I have a simple question, can I have a variable that is not reset, even if my program is closed?
      That is, I want to make a program that can only be opened once, have a variable $ ini = 0, when it is opened for the first and only time it becomes $ ini = 1, so that it can not use the program a second time, as if it was a test software.
      I do not want the variable to depend on a reading of an external file that is easily manipulated. Thank you.
    • nooneclose
      By nooneclose
      My program has to first search for names in Column D that do not match up with column C. I got that search to work using arrays. It was slow and I could not figure out how to delete them so I just manually put coded the names that do not belong. I found their cell location but I do not know how to store that location and delete it.
      This is what I have so far.
      Local $NameToDelete1[6]  = _Excel_RangeFind($OpenWorkbook, "Smith, Bill") _ArrayDisplay($NameToDelete1, "Excel UDF: _Excel_RangeFind Example 1", "", 0, "|", "Sheet|Name|Cell|Value|Formula|Comment") _Excel_RangeDelete($OpenWorkbook.ActiveSheet, $NameToDelete1[2], $xlShiftUp)  
      Please help, I wanted to have this program done yesterday but I did not see this problem until yesterday. 
    • TrashBoat
      By TrashBoat
      So Im trying to make a simple 2d game and make some sort of collision detection so why not to make a 2 dimensional array but i have no clue how  to write it in multiple lines
      Global $map[5,5] = [0,0,0,0,0 _ [0,0,0,0,0 _ [0,0,0,0,0 _ [0,0,0,0,0 _ [0,0,0,0,0] something like this but it doesn't work
    • Zein
      By Zein
      #include "..\Include\Array.au3" #include "..\Include\File.au3" #include "..\Include\AutoItConstants.au3" Local $aRetArray Local $sFilePath = "n.csv" _FileReadToArray($sFilePath, $aRetArray, ",") ; _FileReadToArray($sFilePath, $aRetArray, $FRTA_COUNT, ",") _ArrayDisplay($aRetArray, "Original", Default, 8) The above code shows two versions of _FileReadToArray and both don't work as expected.
      The first one doesn't use the comma as a delimiter. (so I get a single column array)  I tried adding "Default" between $aRetArray and "," then it told me it had an incorrect number of parameters. 

      I looked again at the documentation:
       
      #include <File.au3> _FileReadToArray ( $sFilePath, ByRef $vReturn [, $iFlags = $FRTA_COUNT [, $sDelimiter = ""]] )
      And I with or without the flags params I should be getting a 2D array due to my file being a csv. 
      I then tried a regular flag, $FRTA_COUNT, and it tells me that I'm using a variable $FRTA_COUNT while it's not declared. Tried putting in 1 instead and it told me again, incorrect number of params. 

       
    • nooneclose
      By nooneclose
      I need to perform a subtotal in excel and I would like to automate this process using Autoit if possible like always any and all help will be greatly appreciated. 
      I can not find a good example but the two from Microsoft. Here is one of the two from msdn.microsoft.com/en-us/vba/excel-vba/articles/range-subtotal-method-excel
      I do not really understand how to translate this into AutoIt, but I gave it a try and here is what I have.
      $OpenRange      = "A1:E200" $xlSum          = -4157 $Added_Array[2] = [2, 3] $OpenRange.Subtotal("B1", $xlSum, $Added_Array, True, False, True) I just need to perform a subtotal on a range based on a header called department, and then perform a sum on the results.
×