Scripts for Firefox - (Moved)

[jasontj]

Hi.  I have the below script that I used the FF.au3 to control Firefox.  However now I can't get MozRepl installed since it's no longer supported.  I've got about 50 scripts like this for different website that I need to rewrite to control Firefox.  I also connect to Lotus Notes to update some docs with the results of searches I do on these website.  Does anyone have a good suggestion on what I can use to accomplish what I need done?  I would love a way to temporarily get MozRepl back running because this is causing my team a lot of work at the moment.  In the long run, I need something that will work on the newest version of windows and the newest web browsers.

As you can see, I open an Excel spreadsheet, read 1 name at a time and put them into fields on a website to search.  This is just part of my script.  Any help on what direction to go would be appreciated.

Thanks in advance!

Jason

 

#include <File.au3>
#include <Array.au3>
#include <Excel.au3>
#include <FF.au3>
#Include <Date.au3>

Global $sCellValueL
Global $sCellValueF
Global $RecordNumber

Global $Session = ObjCreate("Notes.NotesSession")
Global $Search_db = $Session.GetDatabase($serverName, "system\center.nsf")
Global $Search_view = $Search_db.GetView("BGRPT")
Global $sXlsFile = @ScriptDir & "\TX_DALLAS_CRI.xls"
Global $sCheck
Global $testStr1
Global $testCode
Global $sHTML

$URLstr = "https://www.dallascounty.org/criminalBackgroundSearch/"

_FFstart()
_FFConnect()
If _FFIsConnected() Then
    _FFOpenUrl($URLstr)
    _FFLoadWait()
    $sHTML = _FFReadText()
    $testCode = StringRegExp($sHTML, "Any unauthorized use or misuse of the site or the sites information by Visitor", 0)
    if $testCode = 1 Then        
        Enter_Code()    
    EndIf        
EndIf

$oExcel = _ExcelBookOpen($sXlsFile)

; Gets an array of MasterNumbers from the Excel file
$INDEX = 1
$sCellValueL = (_ExcelReadCell($oExcel,"A" & $INDEX))
$sCellValueF = (_ExcelReadCell($oExcel,"B" & $INDEX))
$RecordNumber = (_ExcelReadCell($oExcel,"F" & $INDEX))

do 
    $oTextL = _FFObjGet("lastName", "name")
    $oTextF = _FFObjGet("firstName", "name")
    
    _FFObj($oTextL, "value", $sCellValueL)
    _FFObj($oTextF, "value", $sCellValueF)

;    _FFFormCheckBox("ctl00_ContentPlaceHolder1_CheckBoxList2_1", False, 0, "id") ; , "Criminal Cases", "name")    
;    $subButton = _FFObjGet("ctl00_ContentPlaceHolder1_Button1", "id")

    _FFFormSubmit()
    _FFLoadWait()

[water]

I suggest to run a version of FF that still supports MozRepl until you have rewritten your scripts.
Check the WebDriver UDF that supports all current browser versions.

BTW 1: The Excel UDF has been rewritten looong time a ago - enhancing performance by a factor of up to 100.
BTW 2: You have posted in the wrong forum - The forum cleary states: "Do not create AutoIt-related topics here, use the AutoIt General Help and Support or AutoIt Technical Discussion forums."

[jasontj]

Thanks water.  I am using an older version of Firefox that does support the mozrepl, but now I've got no way to install it since it's not on the FF addon page.

Sorry about posting in the wrong spot.  I'll post in the other forum.

 

[jasontj]

Hi.  I have the below script that I used the FF.au3 to control Firefox.  However now I can't get MozRepl installed since it's no longer supported.  I've got about 50 scripts like this for different website that I need to rewrite to control Firefox.  I also connect to Lotus Notes to update some docs with the results of searches I do on these website.  Does anyone have a good suggestion on what I can use to accomplish what I need done?  I would love a way to temporarily get MozRepl back running because this is causing my team a lot of work at the moment.  In the long run, I need something that will work on the newest version of windows and the newest web browsers.

As you can see, I open an Excel spreadsheet, read 1 name at a time and put them into fields on a website to search.  This is just part of my script.  Any help on what direction to go would be appreciated.  I will also need to control Chrome and IE if possible.

Thanks in advance!

Jason

 

#include <File.au3>
#include <Array.au3>
#include <Excel.au3>
#include <FF.au3>
#Include <Date.au3>

Global $sCellValueL
Global $sCellValueF
Global $RecordNumber

Global $Session = ObjCreate("Notes.NotesSession")
Global $Search_db = $Session.GetDatabase($serverName, "system\center.nsf")
Global $Search_view = $Search_db.GetView("BGRPT")
Global $sXlsFile = @ScriptDir & "\TX_DALLAS_CRI.xls"
Global $sCheck
Global $testStr1
Global $testCode
Global $sHTML

$URLstr = "https://www.dallascounty.org/criminalBackgroundSearch/"

_FFstart()
_FFConnect()
If _FFIsConnected() Then
    _FFOpenUrl($URLstr)
    _FFLoadWait()
    $sHTML = _FFReadText()
    $testCode = StringRegExp($sHTML, "Any unauthorized use or misuse of the site or the sites information by Visitor", 0)
    if $testCode = 1 Then        
        Enter_Code()    
    EndIf        
EndIf

$oExcel = _ExcelBookOpen($sXlsFile)

; Gets an array of MasterNumbers from the Excel file
$INDEX = 1
$sCellValueL = (_ExcelReadCell($oExcel,"A" & $INDEX))
$sCellValueF = (_ExcelReadCell($oExcel,"B" & $INDEX))
$RecordNumber = (_ExcelReadCell($oExcel,"F" & $INDEX))

do 
    $oTextL = _FFObjGet("lastName", "name")
    $oTextF = _FFObjGet("firstName", "name")
    
    _FFObj($oTextL, "value", $sCellValueL)
    _FFObj($oTextF, "value", $sCellValueF)

;    _FFFormCheckBox("ctl00_ContentPlaceHolder1_CheckBoxList2_1", False, 0, "id") ; , "Criminal Cases", "name")    
;    $subButton = _FFObjGet("ctl00_ContentPlaceHolder1_Button1", "id")

    _FFFormSubmit()
    _FFLoadWait()

[jasontj]

Thanks water.  I am using an older version of Firefox that does support the mozrepl, but now I've got no way to install it since it's not on the FF addon page.  I really don't have any issues with Excel.  My functions there are basic reads and writes so speeding it up it's important to me.  That's secondary at this point.  I just desperately need to control my web browsers and forms on them.

Sorry about posting in the wrong spot.  I'll post in the other forum.

 

[water]

Maybe the Classic Add-Ons Archive hlps: https://www.trishtech.com/2018/10/use-older-firefox-extensions-through-classic-add-ons-archive/

[Jos]

Moved to the appropriate forum, as the Developer General Discussion forum very clearly states:

Quote

General development and scripting discussions. If it's super geeky and you don't know where to put it - it's probably here.

---

Do not create AutoIt-related topics here, use the AutoIt General Help and Support or AutoIt Technical Discussion forums.

Moderation Team

[JLogan3o13]

Moved to the appropriate forum, as the Technical Discussion states very clearly:

Quote

Do not post general support questions here, instead use the AutoIt Help and Support forums.

Moderation Team

Edited July 3, 2019 by JLogan3o13

[jasontj]

Thanks JLogan3o13.  Sorry for posting in the wrong spot.

[jasontj]

Hey @water, I tried installing the "classic addon" as you suggested.  I've got Firefox version 52.9.0 (32-bit) and it "This add-on could not be installed because it has not been verified".  I clicked the "learn more", but it gave me info on why it couldn't install.  Any ideas?  Thanks.

Jason

[jasontj]

I found the answer.  Go into the about:config and change this to false:  xpinstall.signatures.required

[jasontj]

By the way, thanks very much @water for your help.  I'm back up and running.  Saves us 10 hours or more of work per day.  

[Jos]

This is the last time I am cleaning your stuff up without any consequences!
Do not cross post and post it the correct forum please for here on.

Jos

[jasontj]

Will @Jos.  My bad.

[water]

11 hours ago, jasontj said:

 Saves us 10 hours or more of work per day.  

[AliZeeshan]

On 7/4/2019 at 1:22 AM, water said:

Maybe the Classic Add-Ons Archive hlps: https://www.trishtech.com/2018/10/use-older-firefox-extensions-through-classic-add-ons-archive/

Hey can you tell me that does autoit suport autoit ?

[JLogan3o13]

5 hours ago, AliZeeshan said:

Hey can you tell me that does autoit suport autoit ?

This does not make any sense @AliZeeshan