Jump to content

Recommended Posts

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

Link to post
Share on other sites

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."

My UDFs and Tutorials:

Spoiler

UDFs:
Active Directory (NEW 2022-02-19 - Version 1.6.1.0) - Download - General Help & Support - Example Scripts - Wiki
ExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example Scripts
OutlookEX (2021-11-16 - Version 1.7.0.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX_GUI (2021-04-13 - Version 1.4.0.0) - Download
Outlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - Wiki
PowerPoint (2021-08-31 - Version 1.5.0.0) - Download - General Help & Support - Example Scripts - Wiki
Task Scheduler (2019-12-03 - Version 1.5.1.0) - Download - General Help & Support - Wiki

Standard UDFs:
Excel - Example Scripts - Wiki
Word - Wiki

Tutorials:
ADO - Wiki
WebDriver - Wiki

 

Link to post
Share on other sites

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.

 

Link to post
Share on other sites

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

Link to post
Share on other sites

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.

 

Link to post
Share on other sites

My UDFs and Tutorials:

Spoiler

UDFs:
Active Directory (NEW 2022-02-19 - Version 1.6.1.0) - Download - General Help & Support - Example Scripts - Wiki
ExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example Scripts
OutlookEX (2021-11-16 - Version 1.7.0.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX_GUI (2021-04-13 - Version 1.4.0.0) - Download
Outlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - Wiki
PowerPoint (2021-08-31 - Version 1.5.0.0) - Download - General Help & Support - Example Scripts - Wiki
Task Scheduler (2019-12-03 - Version 1.5.1.0) - Download - General Help & Support - Wiki

Standard UDFs:
Excel - Example Scripts - Wiki
Word - Wiki

Tutorials:
ADO - Wiki
WebDriver - Wiki

 

Link to post
Share on other sites
  • Developers

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

SciTE4AutoIt3 Full installer Download page   - Beta files       Read before posting     How to post scriptsource   Forum etiquette  Forum Rules 
 
Live for the present,
Dream of the future,
Learn from the past.
  :)

Link to post
Share on other sites
  • Moderators

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 by JLogan3o13

"Profanity is the last vestige of the feeble mind. For the man who cannot express himself forcibly through intellect must do so through shock and awe" - Spencer W. Kimball

How to get your question answered on this forum!

Link to post
Share on other sites

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

Link to post
Share on other sites
  • Developers

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

SciTE4AutoIt3 Full installer Download page   - Beta files       Read before posting     How to post scriptsource   Forum etiquette  Forum Rules 
 
Live for the present,
Dream of the future,
Learn from the past.
  :)

Link to post
Share on other sites
11 hours ago, jasontj said:

 Saves us 10 hours or more of work per day.  

:)

My UDFs and Tutorials:

Spoiler

UDFs:
Active Directory (NEW 2022-02-19 - Version 1.6.1.0) - Download - General Help & Support - Example Scripts - Wiki
ExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example Scripts
OutlookEX (2021-11-16 - Version 1.7.0.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX_GUI (2021-04-13 - Version 1.4.0.0) - Download
Outlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - Wiki
PowerPoint (2021-08-31 - Version 1.5.0.0) - Download - General Help & Support - Example Scripts - Wiki
Task Scheduler (2019-12-03 - Version 1.5.1.0) - Download - General Help & Support - Wiki

Standard UDFs:
Excel - Example Scripts - Wiki
Word - Wiki

Tutorials:
ADO - Wiki
WebDriver - Wiki

 

Link to post
Share on other sites
  • 6 months later...
  • Moderators
5 hours ago, AliZeeshan said:

Hey can you tell me that does autoit suport autoit ?

This does not make any sense @AliZeeshan

"Profanity is the last vestige of the feeble mind. For the man who cannot express himself forcibly through intellect must do so through shock and awe" - Spencer W. Kimball

How to get your question answered on this forum!

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 noellarkin
      This is for those pages that seem to load when you use _FFOpenURL(), but they have a text saying "please wait while we load your page..." but according to _FFOpenURL() the page has loaded.  An example seen in popular sites is the Cloudflare page saying "Checking your browser before...". It's the opposite of pausing a script until an element is visible on a page. It takes Elements in the form of id, xpath or text search.
      Global $BrowserPort = 4242 Global $TimeOut = 60000 Global $LocalHost = "127.0.0.1" Func _FFWaitWhileElement($thiselement, $elementtype = "xpath", $timeoutms = 60000) _FFConnect($LocalHost, $BrowserPort, $TimeOut) Local $Element Local $ElementFound = 1 Local $TimeoutCountdown = 0 While $ElementFound <> 0 And $TimeoutCountdown < $timeoutms If $elementtype = "xpath" Then $Element = _FFXPath($thiselement) EndIf If $elementtype = "id" Then Local $ConstructXPath = ".//*[@id='" & $thiselement & "']" $Element = _FFXPath($ConstructXPath) EndIf ; MsgBox(0, "", $Element) Local $ElementXPathTextContent = _FFCmd("FFau3.xpath.textContent") ; MsgBox(0, "", $ElementXPathTextContent) Local $ElementXPathInnerHTML = _FFCmd("FFau3.xpath.innerHTML") ; MsgBox(0, "", $ElementXPathInnerHTML) If $ElementXPathTextContent = "_FFCmd_Err" Or $ElementXPathInnerHTML = "_FFCmd_Err" Then $ElementFound = 0 Else $ElementFound = 1 EndIf If $elementtype = "text" Then $ElementFound = _FFSearch($thiselement) ; MsgBox(0, "", $ElementFound) EndIf $TimeoutCountdown += 1000 _FFDisConnect() _FFConnect($LocalHost, $BrowserPort, $TimeOut) WEnd Return $ElementFound EndFunc _FFConnect($LocalHost, $BrowserPort, $TimeOut) _FFOpenURL("https://www.site.com/page", True) _FFWaitForElement("Please Wait...","text", 60000) MsgBox(0,"","Page finished loading") It's pretty simple, hope it helps some of you who are working with FF.au3 :)
    • By pete_wilde
      Hi guys,
      I am very much a newbie, but I am slowly learning by writting simple scripts.
      #include <Clipboard.au3> #include <File.au3> #include <Msgboxconstants.au3> Const $test_url = "https://www.autoitscript.com/site/" Const $hFileOpen = FileOpen(@WorkingDir & "\TEMP.txt",$FO_OVERWRITE) ; Open FIREFOX at https://www.autoitscript.com/site/ ShellExecute("firefox.exe",$test_url) Sleep(60000) ; Allow the page to open - no rush Send("^a") ; Select ALL text Sleep(1000) ; Pause for 1 second Send("^c") ; CTRL + C to copy text Sleep(1000) ; Pause for 1 second ; Write Data to File FileWrite($hFileOpen,_ClipBoard_GetData ($CF_UNICODETEXT)) ; Close Temp File FileClose($hFileOpen) MsgBox(262144,"Completed","Data Written To File") The above code basically just copies text on a webpage and outputs it to a file.  Works well. I understand AutoIT a little more now.

      However, Send() doesn't work when my screen lock is on. :-(
       
      Is there a simple tweak which I can do so that it does work when my screen is locked, bearing in mind that I am not a guru like most users yet.
      I read somewhere the ControlSend works, but requires the browser "handle".

      Thanks in advance.

      Best regards,
      Pete
    • By vkrisz81
      hello!
      can anybody tell me is there any working udf for firefox? because the .15 version cant communicate with firefox. the first statement does not work . i know it worked because i tested it few months ago, but now its dead. after refresh firefox 2 weeks ago.
      is there any tip?
×
×
  • Create New...