IE_Automated_FileUpload.au3

mLipok · January 17, 2021

I found solution here:
https://stackoverflow.com/questions/33253517/upload-a-file-via-input-input-in-html-form-with-vba
and:
https://www.motobit.com/tips/detpg_uploadvbsie/

And I translate this code to AutoIt3 code:

; Upload file using http protocol And multipart/form-data
; v1.01
; 2001 Antonin Foller, PSTRUH Software
Global $oErrorHandler = ObjEvent("AutoIt.Error", _ErrFunc)

do_vbsUpload()

Func do_vbsUpload()

#cs
    ; We need at least two arguments (File & URL)

    ConsoleWrite('- ' & @ScriptLineNumber & @CRLF)

    If $CmdLine[0] < 2 Then InfoEcho()
    ConsoleWrite('- ' & @ScriptLineNumber & @CRLF)

    ; Are some required objects missing?
    If StringInStr(CheckRequirements(), "Error") > 0 Then InfoEcho()
    ConsoleWrite('- ' & @ScriptLineNumber & @CRLF)

    Local $s_FileName, $s_DestURL, $s_FieldName
    $s_FieldName = "FileField" ; Default field name

    For $i_argCounter = 1 To $CmdLine[0]
        ConsoleWrite('+ '& $i_argCounter& ' >> '  & $CmdLine[$i_argCounter] & @CRLF)
        Select
            Case $i_argCounter = 1
;~              $s_FileName = $CmdLine[$i_argCounter]
                $s_FileName = @ScriptFullPath
            Case $i_argCounter = 2
                $s_DestURL = $CmdLine[$i_argCounter]
            Case $i_argCounter = 3
                $s_FieldName = $CmdLine[$i_argCounter]
        EndSelect
    Next

    UploadFile($s_DestURL, $s_FileName, $s_FieldName)
#ce

    UploadFile('http://www.dobeash.com/test.html', @ScriptFullPath, 'fileExample')

EndFunc   ;==>do_vbsUpload


; ******************* upload - begin
; Upload file using input type=file
Func UploadFile($s_DestURL, $s_FileName, $s_FieldName)
    ; Boundary of fields.

    ; Be sure this string is Not In the source file
    Const $Boundary = "---------------------------0123456789012"

    ; Get source file As a binary data.
    Local $d_FileContents = GetFile($s_FileName)

    ; Build multipart/form-data document
    Local $s_FormData = BuildFormData($d_FileContents, $Boundary, $s_FileName, $s_FieldName)

    ; Post the data To the destination URL
    IEPostBinaryRequest($s_DestURL, $s_FormData, $Boundary)
EndFunc   ;==>UploadFile

; Build multipart/form-data document with file contents And header info
Func BuildFormData($d_FileContents, $Boundary, $s_FileName, $s_FieldName)
    Const $s_ContentType = "application/upload"

    ; The two parts around file contents In the multipart-form data.
    Local $s_Pre = "--" & $Boundary & @CRLF & mpFields($s_FieldName, $s_FileName, $s_ContentType)
    Local $s_Po = @CRLF & "--" & $Boundary & "--" & @CRLF

    ; Build form data using recordset binary field
    Const $i_adLongVarBinary = 205
    Local $oRS = ObjCreate("ADODB.Recordset")
    ; https://docs.microsoft.com/en-us/sql/ado/reference/ado-api/append-method-ado?view=sql-server-ver15
    $oRS.Fields.Append("b", $i_adLongVarBinary, StringLen($s_Pre) + BinaryLen($d_FileContents) + StringLen($s_Po))
    $oRS.Open()
    $oRS.AddNew()

    ; Convert Pre string value To a binary data
    Local $i_LenData = StringLen($s_Pre)
    $oRS("b").AppendChunk(StringToMB($s_Pre) & StringToBinary(Chr(0)))
    $s_Pre = $oRS("b").GetChunk($i_LenData)
    $oRS("b") = ""

    ; Convert Po string value To a binary data
    $i_LenData = StringLen($s_Po)
    $oRS("b").AppendChunk(StringToMB($s_Po) & StringToBinary(Chr(0)))
    $s_Po = $oRS("b").GetChunk($i_LenData)
    $oRS("b") = ""

    ; Join Pre & $d_FileContents & Po binary data
    $oRS("b").AppendChunk($s_Pre)
    $oRS("b").AppendChunk($d_FileContents)
    $oRS("b").AppendChunk($s_Po)
    $oRS.Update()
    Local $s_FormData = $oRS("b")
    $oRS.Close()
    Return $s_FormData
EndFunc   ;==>BuildFormData

; sends multipart/form-data To the URL using IE
Func IEPostBinaryRequest($s_URL, $s_FormData, $Boundary)
    ; Create InternetExplorer
    Local $oIE = ObjCreate("InternetExplorer.Application")

    ; You can uncoment Next line To see form results
    $oIE.Visible = True

    ; Send the form data To $s_URL As POST multipart/form-data request
    $oIE.Navigate($s_URL, '', '', $s_FormData, _
            "Content-Type: multipart/form-data; boundary=" & $Boundary & @CRLF)

    While $oIE.Busy
        Wait(1, "Upload To " & $s_URL)
    WEnd

    ; Get a result of the script which has received upload
;~   On Error Resume Next
    Local $s_IE_InnerHTML = $oIE.Document.body.innerHTML
    MsgBox(0, 'TEST #' & @CRLF & @ScriptLineNumber, $s_IE_InnerHTML)
    $oIE.Quit()
    Return $s_IE_InnerHTML
EndFunc   ;==>IEPostBinaryRequest

; Infrormations In form field header.
Func mpFields($s_FieldName, $s_FileName, $s_ContentType)
    Local $s_MPTemplate = _ ; template For multipart header
            'Content-Disposition: form-data; name="{field}";' & _
            'FileName="{file}"' & @CRLF & _
            'Content-Type: {ct}' & @CRLF & @CRLF & _
            ''
    Local $s_Out
    $s_Out = StringReplace($s_MPTemplate, "{field}", $s_FieldName)
    $s_Out = StringReplace($s_Out, "{file}", $s_FileName)
    $s_Out = StringReplace($s_Out, "{ct}", $s_ContentType)
    Return $s_Out
EndFunc   ;==>mpFields


Func Wait($i_Seconds, $s_Message)
    MsgBox(64, '', $s_Message, $i_Seconds)
EndFunc   ;==>Wait


; Returns file contents As a binary data
Func GetFile($s_FileName)
    Local $oStream = ObjCreate("ADODB.Stream")
    $oStream.Type = 1 ; Binary
    $oStream.Open()
    $oStream.LoadFromFile($s_FileName)
    Local $d_GetFile = $oStream.Read()
    $oStream.Close()

    Return $d_GetFile
EndFunc   ;==>GetFile

; Converts OLE string To multibyte string
Func StringToMB($S)
    Local $I, $B
    For $I = 1 To StringLen($S)
        $B &= StringToBinary(Asc(StringMid($S, $I, 1)))
    Next
    Return $B
EndFunc   ;==>StringToMB
; ******************* upload - end

; ******************* Support
; Basic script info
Func InfoEcho()
    Local $sMsg = _
            "Upload file using http And multipart/form-data" & @CRLF & _
            "Copyright (C) 2001 Antonin Foller, PSTRUH Software" & @CRLF & _
            "use" & @CRLF & _
            "[cscript|wscript] fupload.vbs file $s_URL [fieldname]" & @CRLF & _
            "  file ... Local file To upload" & @CRLF & _
            "  $s_URL ... $s_URL which can accept uploaded data" & @CRLF & _
            "  fieldname ... Name of the source form field." & @CRLF & _
            @CRLF & CheckRequirements() & @CRLF & _
            ""
    ConsoleWrite('! ' & $sMsg & @CRLF)
EndFunc   ;==>InfoEcho

; Checks If all of required objects are installed
Func CheckRequirements()
    Local $sMsg = _
            "This script requires some objects installed To run properly." & @CRLF & _
            CheckOneObject("ADODB.Recordset") & @CRLF & _
            CheckOneObject("ADODB.Stream") & @CRLF & _
            CheckOneObject("InternetExplorer.Application") & @CRLF & _
            ""
    Return $sMsg
    ;   $sMsgBox $sMsg
EndFunc   ;==>CheckRequirements

; Checks If the one object is installed.
Func CheckOneObject($sClassName)
    Local $sMsg
    ObjCreate($sClassName)
    If @error = 0 Then
        $sMsg = "OK"
    Else
        $sMsg = "Error:" & @error
    EndIf
    Return $sClassName & " - " & $sMsg
EndFunc   ;==>CheckOneObject
; ******************* Support - end


 ; User's COM error function. Will be called if COM error occurs
Func _ErrFunc(ByRef $oError)
        ; Do anything here.
        ConsoleWrite(@ScriptName & " (" & $oError.scriptline & ") : ==> COM Error intercepted !" & @CRLF & _
                        @TAB & "err.number is: " & @TAB & @TAB & "0x" & Hex($oError.number) & @CRLF & _
                        @TAB & "err.windescription:" & @TAB & $oError.windescription & @CRLF & _
                        @TAB & "err.description is: " & @TAB & $oError.description & @CRLF & _
                        @TAB & "err.source is: " & @TAB & @TAB & $oError.source & @CRLF & _
                        @TAB & "err.helpfile is: " & @TAB & $oError.helpfile & @CRLF & _
                        @TAB & "err.helpcontext is: " & @TAB & $oError.helpcontext & @CRLF & _
                        @TAB & "err.lastdllerror is: " & @TAB & $oError.lastdllerror & @CRLF & _
                        @TAB & "err.scriptline is: " & @TAB & $oError.scriptline & @CRLF & _
                        @TAB & "err.retcode is: " & @TAB & "0x" & Hex($oError.retcode) & @CRLF & @CRLF)
EndFunc   ;==>_ErrFunc

But I miss something and the code not works as intendend.

Please join and contribute, in solving this issue, as this will be handy for entire community.

@mLipok

btw.
I think that this may be realated to ChrB() which I simply translate to StringToBinary()

Especialy this :

StringToBinary(Chr(0)))

could be the main issue.

But for now I'm tired and going to sleep.
Hope maybe tomorrow somebody solve this issue.

Edited January 17, 2021 by mLipok

mLipok · January 17, 2021

small fix:

Func BuildFormData($d_FileContents, $Boundary, $s_FileName, $s_FieldName)
    Const $s_ContentType = "application/upload"

    ; The two parts around file contents In the multipart-form data.
    Local $s_Pre = "--" & $Boundary & @CRLF & mpFields($s_FieldName, $s_FileName, $s_ContentType)
    Local $s_Po = @CRLF & "--" & $Boundary & "--" & @CRLF

    ; Build form data using recordset binary field
    Const $i_adLongVarBinary = 205
    Local $oRS = ObjCreate("ADODB.Recordset")
    ; https://docs.microsoft.com/en-us/sql/ado/reference/ado-api/append-method-ado?view=sql-server-ver15
    $oRS.Fields.Append("b", $i_adLongVarBinary, StringLen($s_Pre) + BinaryLen($d_FileContents) + StringLen($s_Po))
    $oRS.Open()
    $oRS.AddNew()

    ; Convert Pre string value To a binary data
    Local $i_LenData = StringLen($s_Pre)
    $oRS.Fields.Item("b").AppendChunk(StringToMB($s_Pre) & StringToBinary(Chr(0)))
    $s_Pre = $oRS.Fields.Item("b").GetChunk($i_LenData)
    $oRS.Fields.Item("b") = ""

    ; Convert Po string value To a binary data
    $i_LenData = StringLen($s_Po)
    $oRS.Fields.Item("b").AppendChunk(StringToMB($s_Po) & StringToBinary(Chr(0)))
    $s_Po = $oRS.Fields.Item("b").GetChunk($i_LenData)
    $oRS.Fields.Item("b") = ""

    ; Join Pre & $d_FileContents & Po binary data
    $oRS.Fields.Item("b").AppendChunk($s_Pre)
    $oRS.Fields.Item("b").AppendChunk($d_FileContents)
    $oRS.Fields.Item("b").AppendChunk($s_Po)
    $oRS.Update()
    Local $s_FormData = $oRS.Fields.Item("b")
    $oRS.Close()
    Return $s_FormData
EndFunc   ;==>BuildFormData

not yet finished.

mLipok · January 17, 2021

still not working but... modified code:

; https://www.motobit.com/tips/detpg_uploadvbsie/
; Upload file using http protocol And multipart/form-data
; v1.01
; 2001 Antonin Foller, PSTRUH Software
Global $oErrorHandler = ObjEvent("AutoIt.Error", _ErrFunc)

do_vbsUpload()

Func do_vbsUpload()

;~  UploadFile('http://www.dobeash.com/test.html', @ScriptFullPath, 'fileExample')
    UploadFile('http://www.dobeash.com/test.html', @ScriptName, 'fileExample')

EndFunc   ;==>do_vbsUpload


; ******************* upload - begin
; Upload file using input type=file
Func UploadFile($s_DestURL, $s_FileName, $s_FieldName)
    ; Boundary of fields.

    ; Be sure this string is Not In the source file
    Const $Boundary = "---------------------------0123456789012"

    ; Get source file As a binary data.
    Local $d_FileContents = GetFile($s_FileName)
    MsgBox(0, @ScriptLineNumber & ' ' & VarGetType($d_FileContents), BinaryToString($d_FileContents))


    ; Build multipart/form-data document
    Local $s_FormData = BuildFormData($d_FileContents, $Boundary, $s_FileName, $s_FieldName)

    MsgBox(0, @ScriptLineNumber & ' ' & VarGetType($s_FormData) & ' ' & BinaryLen($s_FormData), $s_FormData)
    ; Post the data To the destination URL
    IEPostBinaryRequest($s_DestURL, $s_FormData, $Boundary)
EndFunc   ;==>UploadFile

; Build multipart/form-data document with file contents And header info
Func BuildFormData($d_FileContents, $Boundary, $s_FileName, $s_FieldName)
    Const $s_ContentType = "application/upload"

    ; The two parts around file contents In the multipart-form data.
    Local $s_Pre = "--" & $Boundary & @CRLF & mpFields($s_FieldName, $s_FileName, $s_ContentType)
    Local $s_Po = @CRLF & "--" & $Boundary & "--" & @CRLF

    MsgBox(0, @ScriptLineNumber & '', $s_Pre)
    MsgBox(0, @ScriptLineNumber & '', $s_Po)

    ; Build form data using recordset binary field
    Const $i_adLongVarBinary = 205
    Local $oRS = ObjCreate("ADODB.Recordset")
    ; https://docs.microsoft.com/en-us/sql/ado/reference/ado-api/append-method-ado?view=sql-server-ver15
    $oRS.Fields.Append("b", $i_adLongVarBinary, StringLen($s_Pre) + BinaryLen($d_FileContents) + StringLen($s_Po))
    $oRS.Open()
    $oRS.AddNew()

    ; Convert Pre string value To a binary data
    Local $i_LenData = StringLen($s_Pre)
    $oRS.Fields("b").AppendChunk(StringToMB($s_Pre) & StringToBinary(Chr(0)))
    $oRS.Update()
    $s_Pre = $oRS.Fields("b").GetChunk($i_LenData)
    $oRS.Fields("b") = ""

    ; Convert Po string value To a binary data
    $i_LenData = StringLen($s_Po)
    $oRS.Fields("b").AppendChunk(StringToMB($s_Po) & StringToBinary(Chr(0)))
    $oRS.Update()
    $s_Po = $oRS.Fields("b").GetChunk($i_LenData)
    $oRS.Fields("b") = ""

    ; Join Pre & $d_FileContents & Po binary data
    $oRS.Fields("b").AppendChunk($s_Pre)
    $oRS.Fields("b").AppendChunk($d_FileContents)
    $oRS.Fields("b").AppendChunk($s_Po)
    $oRS.Update()
    Local $s_FormData = $oRS.Fields("b").value
    $oRS.Close()
    Return $s_FormData
EndFunc   ;==>BuildFormData

; sends multipart/form-data To the URL using IE
Func IEPostBinaryRequest($s_URL, $s_FormData, $Boundary)
    ; Create InternetExplorer
    Local $oIE = ObjCreate("InternetExplorer.Application")

    ; You can uncoment Next line To see form results
    $oIE.Visible = True

    ; Send the form data To $s_URL As POST multipart/form-data request
    $oIE.Navigate($s_URL, '', '', $s_FormData, _
            "Content-Type: multipart/form-data; boundary=" & $Boundary & @CRLF)

    While $oIE.Busy
        Wait(1, "Upload To " & $s_URL)
    WEnd

    ; Get a result of the script which has received upload
;~   On Error Resume Next
    Local $s_IE_InnerHTML = $oIE.Document.body.innerHTML
    MsgBox(0, @ScriptLineNumber & ' TEST', $s_IE_InnerHTML)
    $oIE.Quit()
    Return $s_IE_InnerHTML
EndFunc   ;==>IEPostBinaryRequest

; Infrormations In form field header.
Func mpFields($s_FieldName, $s_FileName, $s_ContentType)
    Local $s_MPTemplate = _ ; template For multipart header
            'Content-Disposition: form-data; name="{field}";' & _
            'FileName="{file}"' & @CRLF & _
            'Content-Type: {ct}' & @CRLF & @CRLF & _
            ''
    Local $s_Out
    $s_Out = StringReplace($s_MPTemplate, "{field}", $s_FieldName)
    $s_Out = StringReplace($s_Out, "{file}", $s_FileName)
    $s_Out = StringReplace($s_Out, "{ct}", $s_ContentType)
    Return $s_Out
EndFunc   ;==>mpFields

Func Wait($i_Seconds, $s_Message)
    MsgBox(64, '', $s_Message, $i_Seconds)
EndFunc   ;==>Wait


; Returns file contents As a binary data
Func GetFile($s_FileName)
    Local $oStream = ObjCreate("ADODB.Stream")
    $oStream.Type = 1 ; Binary
    $oStream.Open()
    $oStream.LoadFromFile(@ScriptDir & '\' & $s_FileName)
    Local $d_GetFile = $oStream.Read()
    $oStream.Close()

    Return $d_GetFile
EndFunc   ;==>GetFile

; Converts OLE string To multibyte string
Func StringToMB($S)
    Local $I, $B
    For $I = 1 To StringLen($S)
        $B &= StringToBinary(Asc(StringMid($S, $I, 1)))
    Next
    Return $B
EndFunc   ;==>StringToMB
; ******************* upload - end

; User's COM error function. Will be called if COM error occurs
Func _ErrFunc(ByRef $oError)
    ; Do anything here.
    ConsoleWrite(@ScriptName & " (" & $oError.scriptline & ") : ==> COM Error intercepted !" & @CRLF & _
            @TAB & "err.number is: " & @TAB & @TAB & "0x" & Hex($oError.number) & @CRLF & _
            @TAB & "err.windescription:" & @TAB & $oError.windescription & @CRLF & _
            @TAB & "err.description is: " & @TAB & $oError.description & @CRLF & _
            @TAB & "err.source is: " & @TAB & @TAB & $oError.source & @CRLF & _
            @TAB & "err.helpfile is: " & @TAB & $oError.helpfile & @CRLF & _
            @TAB & "err.helpcontext is: " & @TAB & $oError.helpcontext & @CRLF & _
            @TAB & "err.lastdllerror is: " & @TAB & $oError.lastdllerror & @CRLF & _
            @TAB & "err.scriptline is: " & @TAB & $oError.scriptline & @CRLF & _
            @TAB & "err.retcode is: " & @TAB & "0x" & Hex($oError.retcode) & @CRLF & @CRLF)
EndFunc   ;==>_ErrFunc

Edited January 17, 2021 by mLipok

mLipok · January 18, 2021

once this was already disscused:

But there was not any translated Au3 script.

My recent version:

#include <FileConstants.au3>
#include <WinAPIConv.au3>

; https://www.motobit.com/tips/detpg_uploadvbsie/
; Upload file using http protocol And multipart/form-data
; v1.01
; 2001 Antonin Foller, PSTRUH Software
Global $oErrorHandler = ObjEvent("AutoIt.Error", _ErrFunc)

do_vbsUpload()

Func do_vbsUpload()
;~  UploadFile('http://www.dobeash.com/test.html', @ScriptFullPath, 'fileExample')
    UploadFile('https://www.newocr.com/', @ScriptFullPath, 'userfile')
EndFunc   ;==>do_vbsUpload


; ******************* upload - begin
; Upload file using input type=file
Func UploadFile($s_DestURL, $s_FileName, $s_FieldName)
    ; Boundary of fields.

    ; Be sure this string is Not In the source file
    Const $BOUNDARY = "--<<Boundary>>" & @YEAR & @MON & @MDAY & @MIN & @SEC & @MSEC & "<<Boundary>>--"

    ; Get source file As a binary data.
    Local $d_FileContents = GetFile($s_FileName)

    ; Build multipart/form-data document
    Local $s_FormData = BuildFormData($d_FileContents, $BOUNDARY, $s_FileName, $s_FieldName)

    ClipPut($s_FormData)
    MsgBox(0, @ScriptLineNumber & ' ' & VarGetType($s_FormData) & ' ' & BinaryLen($s_FormData), $s_FormData)
    ; Post the data To the destination URL
    IEPostBinaryRequest($s_DestURL, $s_FormData, $BOUNDARY)
EndFunc   ;==>UploadFile

; Build multipart/form-data document with file contents And header info
Func BuildFormData($d_FileContents, $BOUNDARY, $s_FileName, $s_FieldName)
    Const $s_ContentType = "application/upload"

    ; The two parts around file contents In the multipart-form data.
    Local $s_Prefix = "--" & $BOUNDARY & @CRLF & mpFields($s_FieldName, $s_FileName, $s_ContentType)
    Local $s_Postfix = @CRLF & "--" & $BOUNDARY & "--" & @CRLF

    MsgBox(0, @ScriptLineNumber & '', $s_Prefix & @CRLF & '************' & @CRLF & $s_Postfix)


    ; Build form data using recordset binary field
    Const $i_adLongVarBinary = 205
    Local $oRS = ObjCreate("ADODB.Recordset")
    ; https://docs.microsoft.com/en-us/sql/ado/reference/ado-api/append-method-ado?view=sql-server-ver15
    $oRS.Fields.Append("b", $i_adLongVarBinary, StringLen($s_Prefix) + BinaryLen($d_FileContents) + StringLen($s_Postfix))
    $oRS.Open()
    $oRS.AddNew()

    ; Convert Pre string value To a binary data
    Local $i_LenData = StringLen($s_Prefix)
    $oRS.Fields("b").AppendChunk(StringToMB($s_Prefix) & StringToBinary(Chr(0)))
    $oRS.Update()
    $s_Prefix = $oRS.Fields("b").GetChunk($i_LenData)
    $oRS.Fields("b") = ""

    ; Convert Po string value To a binary data
    $i_LenData = StringLen($s_Postfix)
    $oRS.Fields("b").AppendChunk(StringToMB($s_Postfix) & StringToBinary(Chr(0)))
    $oRS.Update()
    $s_Postfix = $oRS.Fields("b").GetChunk($i_LenData)
    $oRS.Fields("b") = ""

    ; Join Pre & $d_FileContents & Po binary data
    $oRS.Fields("b").AppendChunk($s_Prefix)
    $oRS.Fields("b").AppendChunk($d_FileContents)
    $oRS.Fields("b").AppendChunk($s_Postfix)
    $oRS.Update()
    Local $s_FormData = $oRS.Fields("b").value
    $oRS.Close()
    Return $s_FormData
EndFunc   ;==>BuildFormData

; sends multipart/form-data To the URL using IE
Func IEPostBinaryRequest($s_URL, $s_FormData, $BOUNDARY)
    ; Create InternetExplorer
    Local $oIE = ObjCreate("InternetExplorer.Application")

    ; You can uncoment Next line To see form results
    $oIE.Visible = True

    ; Send the form data To $s_URL As POST multipart/form-data request
    Local $iResult = $oIE.Navigate($s_URL, '', '', $s_FormData, _
            "Content-Type: multipart/form-data; boundary=" & $BOUNDARY & @CRLF)
    ConsoleWrite('! $iResult=' & $iResult & @CRLF)


    While $oIE.Busy
        Wait(1, "Upload To " & $s_URL)
    WEnd

    ; Get a result of the script which has received upload
;~   On Error Resume Next
    Local $s_IE_InnerHTML = $oIE.Document.body.innerHTML
    MsgBox(0, @ScriptLineNumber & ' TEST', $s_IE_InnerHTML)
    $oIE.Quit()
    Return $s_IE_InnerHTML
EndFunc   ;==>IEPostBinaryRequest

; Infrormations In form field header.
Func mpFields($s_FieldName, $s_FileName, $s_ContentType)
    Local $s_MPTemplate = _ ; template For multipart header
            'Content-Disposition: form-data; name="{field}"; filename="{file}"' & @CRLF & _
            'Content-Type: {ct}' & @CRLF & @CRLF & _
            ''
    Local $s_Out = $s_MPTemplate
    $s_Out = StringReplace($s_Out, "{field}", $s_FieldName)
    $s_Out = StringReplace($s_Out, "{file}", $s_FileName)
    $s_Out = StringReplace($s_Out, "{ct}", $s_ContentType)
    Return $s_Out
EndFunc   ;==>mpFields

Func Wait($i_Seconds, $s_Message)
    MsgBox(64, '', $s_Message, $i_Seconds)
EndFunc   ;==>Wait


; Returns file contents As a binary data
Func GetFile($s_FileName)
    Local $oStream = ObjCreate("ADODB.Stream")
    $oStream.Type = 1 ; adTypeBinary
;~  https://docs.microsoft.com/en-us/sql/ado/reference/ado-api/charset-property-ado?view=sql-server-ver15
;~  Charset is used only with text Stream objects (Type is adTypeText). This property is ignored if Type is adTypeBinary.
;~  "unicode", "iso-8859-1", "Windows-1252"
;~  $oStream.Charset = "Windows-1252"

    $oStream.Open()
    $oStream.LoadFromFile($s_FileName)
    Local $d_GetFile = $oStream.Read()
    $oStream.Close()

    Return $d_GetFile
EndFunc   ;==>GetFile

; Converts OLE string To multibyte string
Func StringToMB($S)
    Local $I, $B
    For $I = 1 To StringLen($S)
        $B &= StringToBinary(Asc(StringMid($S, $I, 1)))
    Next
    Return $B
EndFunc   ;==>StringToMB
; ******************* upload - end

; User's COM error function. Will be called if COM error occurs
Func _ErrFunc(ByRef $oError)
    ; Do anything here.
    ConsoleWrite(@ScriptName & " (" & $oError.scriptline & ") : ==> COM Error intercepted !" & @CRLF & _
            @TAB & "err.number is: " & @TAB & @TAB & "0x" & Hex($oError.number) & @CRLF & _
            @TAB & "err.windescription:" & @TAB & $oError.windescription & @CRLF & _
            @TAB & "err.description is: " & @TAB & $oError.description & @CRLF & _
            @TAB & "err.source is: " & @TAB & @TAB & $oError.source & @CRLF & _
            @TAB & "err.helpfile is: " & @TAB & $oError.helpfile & @CRLF & _
            @TAB & "err.helpcontext is: " & @TAB & $oError.helpcontext & @CRLF & _
            @TAB & "err.lastdllerror is: " & @TAB & $oError.lastdllerror & @CRLF & _
            @TAB & "err.scriptline is: " & @TAB & $oError.scriptline & @CRLF & _
            @TAB & "err.retcode is: " & @TAB & "0x" & Hex($oError.retcode) & @CRLF & @CRLF)
EndFunc   ;==>_ErrFunc

Edited January 18, 2021 by mLipok

mLipok · January 18, 2021

hm...

I even try VBS (attached in ZIP ) ... with no success.

I hope that HTTP master like @trancexx and ENCODING master like @jchd will find some spare time to look at this.
Also @Danp2 our WDDriver master could look at this.

Hope together we can find complete solution.

IE_Automated_FileUpload.zip

Danp2 · January 18, 2021

I stopped using IE years ago, so I would question if it is worthwhile to expend time on this effort.

@mLipok I wonder how many people would use this even if you got it working?

mLipok · January 18, 2021

@Danp2 I wonder if you can do the same with WebDriver ?

I think that still many use IE especially in corporate environment where they can not install web driver.

Danp2 · January 18, 2021

@mLipok See _WD_SelectFiles, which allows you to select files for uploading.

You may be right about the corporate environment. However, I would expect that to change over time since IE is no longer in development, websites will cease supporting it, it will lack security fixes, etc.

mLipok · January 18, 2021

We still have some GOV page which needs IE

mLipok · January 18, 2021

4 minutes ago, Danp2 said:

See _WD_SelectFiles, which allows you to select files for uploading.

is there also function to post request and get downloaded PDF or other file as a binary without saving them as file on local drive ?

Edited January 18, 2021 by mLipok

Danp2 · January 18, 2021

12 minutes ago, mLipok said:

is there also function to post request and get downloaded PDF or other file as a binary without saving them as file on local drive ?

Not sure. I don't believe there is anything in the W3C specs regarding this. But there are preferences / settings that can be dynamically set to control file downloads. My general understanding is that you can pretty much automate anything that you can manually perform in the browser.

mLipok · January 18, 2021

maybe this way:

https://blog.codecentric.de/en/2010/07/file-downloads-with-selenium-mission-impossible/

or here:

https://dzone.com/articles/how-to-download-amp-upload-files-using-selenium-wi

Quote
Download a File In Selenium WebDriver Using The Browser Profile Setting

By leveraging the browser profile setting, you can download files in Selenium WebDriver without interacting with the download window pop-up. You need to trick the browser profile. Here I have given an example for Google Chrome browser and Mozilla Firefox browser.

Add this code into your Selenium Java testing suite.

Google Chrome
System.setProperty("webdriver.chrome.driver", "/Users/neeraj.kumar/Desktop/chromedriver");
ChromeOptions options = new ChromeOptions();
Map<String, Object> prefs = new HashMap<String, Object>();
prefs.put("download.prompt_for_download", false);
options.setExperimentalOption("prefs", prefs);
RemoteWebDriver driver = new ChromeDriver(options);
Mozilla Firefox
FirefoxProfile profile=new FirefoxProfile();
profile.setPreference("browser.helperApps.neverAsk.openFile", "application/octet-stream");
WebDriver driver=new FirefoxDriver(profile);

Edited January 18, 2021 by mLipok

Danp2 · January 18, 2021

Right... I did mention the prefs in my earlier post. However, I don't see how that helps with your stated requirements --

Quote

get downloaded PDF or other file as a binary without saving them as file on local drive

mLipok · January 18, 2021

Maybe here:

https://webdriver.io/docs/docs/wdio-intercept-service.html

Danyfirex · January 24, 2021

Hello I think using https://www.newocr.com/ it will be a little complex because it use probably some cookies etc it also upload the image first then process it. maybe using the API it would be better/easier. here is a sample using other web site. You don't need to use same code than vbs You're using AutoIt so please take advantage of its own functions.

Global $oErrorHandler = ObjEvent("AutoIt.Error", _ErrFunc)

_TestUploadIE()

Func _TestUploadIE()
    FileDelete("FileExample.txt")
    FileWrite("FileExample.txt", "Hello World-" & Random(1000000, 9999999, 1))
    Local $oIE = ObjCreate("InternetExplorer.Application")
    ; You can uncoment Next line To see form results
    $oIE.Visible = True
    Local $sBOUNDARY = "---------------------------24464570528145"
    Local $sUrl = "https://cgi-lib.berkeley.edu/ex/fup.cgi"
    Local $sPostHeaders = "Content-Type: multipart/form-data; boundary=" & $sBOUNDARY & @CRLF

    Local $sPost = "--" & $sBOUNDARY & @CRLF & _
            'Content-Disposition: form-data; name="upfile"; filename="CompatibilityView.txt"' & @CRLF & _
            'Content-Type: text/plain' & @CRLF & @CRLF & _
            BinaryToString(FileRead("FileExample.txt")) & @CRLF & _
            "--" &  $sBOUNDARY & @CRLF & _
            'Content-Disposition: form-data; name="note"' & @CRLF & @CRLF & @CRLF & _
            "--" &  $sBOUNDARY & "--" & @CRLF

    Local $bPost = StringToBinary($sPost)
    ConsoleWrite($sPost)
    $oIE.Navigate($sUrl, Null, Null, $bPost, $sPostHeaders)

    While $oIE.Busy
        Wait(1, "Upload To " & $sUrl)
    WEnd


EndFunc   ;==>_TestUploadIE


Func Wait($i_Seconds, $s_Message)
    MsgBox(0, '', $s_Message, $i_Seconds)
EndFunc   ;==>Wait

; User's COM error function. Will be called if COM error occurs
Func _ErrFunc(ByRef $oError)
    ; Do anything here.
    ConsoleWrite(@ScriptName & " (" & $oError.scriptline & ") : ==> COM Error intercepted !" & @CRLF & _
            @TAB & "err.number is: " & @TAB & @TAB & "0x" & Hex($oError.number) & @CRLF & _
            @TAB & "err.windescription:" & @TAB & $oError.windescription & @CRLF & _
            @TAB & "err.description is: " & @TAB & $oError.description & @CRLF & _
            @TAB & "err.source is: " & @TAB & @TAB & $oError.source & @CRLF & _
            @TAB & "err.helpfile is: " & @TAB & $oError.helpfile & @CRLF & _
            @TAB & "err.helpcontext is: " & @TAB & $oError.helpcontext & @CRLF & _
            @TAB & "err.lastdllerror is: " & @TAB & $oError.lastdllerror & @CRLF & _
            @TAB & "err.scriptline is: " & @TAB & $oError.scriptline & @CRLF & _
            @TAB & "err.retcode is: " & @TAB & "0x" & Hex($oError.retcode) & @CRLF & @CRLF)
EndFunc   ;==>_ErrFunc

Saludos

mLipok · January 24, 2021

Interestning.
Why you use :
https://cgi-lib.berkeley.edu/ex/fup.cgi
?

When I try this URL then browser redirect me:

Quote

No data uploaded

Please enter it in fup.html.

is it related to:

<form method="POST" enctype="multipart/form-data" action="fup.cgi">
File to upload: <input type="file" name="upfile"><br>
Notes about the file: <input type="text" name="note"><br>
<br>
<input type="submit" value="Press"> to upload the file!
</form>

?

mLipok · January 24, 2021

Two more questions

Are you able to do the same on the same URL with attached PDF ?
Are you also able to do the same but with: http://www.dobeash.com/test.html ... ( there is no CGI ) ?

IE_Automated_FileUpload.pdf

mLipok · January 24, 2021

1 hour ago, Danyfirex said:

You don't need to use same code than vbs You're using AutoIt so please take advantage of its own functions.

Yeah I know but I just use example from that site and wanted to translate them 1<>1

Danyfirex · January 24, 2021

I use the post url. In the example as you see in the action html page source. I'll check the site that you post above and let you know.

Saludos

Danyfirex · January 24, 2021

I use the post url. In the example as you see in the action html page source. I'll check the site that you post above and let you know.

Saludos

IE_Automated_FileUpload.au3

Recommended Posts

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Download a File In Selenium WebDriver Using The Browser Profile Setting

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

No data uploaded

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Create an account or sign in to comment

Create an account

Sign in

Recently Browsing 0 members

Similar Content