Jump to content
Sign in to follow this  
gahhon

How to read and update data in Google SpreadSheet?

Recommended Posts

I don't find any relevant topic via Google Search. Please kindly advise how to read and update data in Google SpreadSheet.

Thanks a lot.

Share this post


Link to post
Share on other sites

Click here to see my signature:

Spoiler

Thoughts:

  • I will always thank you for the time you spent for me.
    I'm here to ask, and from your response, I'd like to learn.
    By my knowledge, I can help someone else, and "that someone" could help in turn another, and so on.

/*--------------------------------------------------------------------------------------------------------------------------------------------------------------------------*/

ALWAYS GOOD TO READ:

 

Share this post


Link to post
Share on other sites

@gahhon
Every post where someone asked about Google Spreadsheets refers to Google API :)


Click here to see my signature:

Spoiler

Thoughts:

  • I will always thank you for the time you spent for me.
    I'm here to ask, and from your response, I'd like to learn.
    By my knowledge, I can help someone else, and "that someone" could help in turn another, and so on.

/*--------------------------------------------------------------------------------------------------------------------------------------------------------------------------*/

ALWAYS GOOD TO READ:

 

Share this post


Link to post
Share on other sites

The reason why I am doing this is similar to database, since the database need to rent so I rather do in Google Docs (SpreadSheet) to check the values.

If this value is match and not exceed a certain, then I increment a value.

Share this post


Link to post
Share on other sites
Just now, FrancescoDiMuro said:

@gahhon
Every post where someone asked about Google Spreadsheets refers to Google API :)

I see the Guide section, it shows Java, PhP, Phython and etc. But not related to AutoIT script?

any advance?

Share this post


Link to post
Share on other sites

@gahhon
That's because you can't do it directly with AutoIt :)


Click here to see my signature:

Spoiler

Thoughts:

  • I will always thank you for the time you spent for me.
    I'm here to ask, and from your response, I'd like to learn.
    By my knowledge, I can help someone else, and "that someone" could help in turn another, and so on.

/*--------------------------------------------------------------------------------------------------------------------------------------------------------------------------*/

ALWAYS GOOD TO READ:

 

Share this post


Link to post
Share on other sites
22 hours ago, FrancescoDiMuro said:

@gahhon
That's because you can't do it directly with AutoIt :)

Awh. Maybe it is under-development with AutoIT tho :D

20 hours ago, Nine said:

you could use SQLite (no rent) 

But I still need a server to store the database?

I thought SQLite is just a Database language like mySQL, Oracle etc?

Other than connecting to Database, then compare and update the value, is there any way to work as what I want.

 

Achievement: I want to limit my designed application as per device.

For example: Company A is signed up for 30 devices to install and use this application, then application only can install 30 times with this Company A. (If using Database, then I compare with the Company ID and AmountInstall not greater and equal than 30 times)

Edited by gahhon

Share this post


Link to post
Share on other sites
1 hour ago, gahhon said:

But I still need a server to store the database?

No, this is why it is called Lite.  You can install it on any computer, and run it standalone.  Google it, download it, use it...

Share this post


Link to post
Share on other sites
29 minutes ago, Nine said:

No, this is why it is called Lite.  You can install it on any computer, and run it standalone.  Google it, download it, use it...

Then how is possible the application to read and update the Database data, while the application is not execute on my computer?

Share this post


Link to post
Share on other sites
9 minutes ago, gahhon said:

Then how is possible the application to read and update the Database data, while the application is not execute on my computer?

And how will you prevent any techies to erase your data, or modify your data ?  If it's only a question of counting the number of machines running your application, then you don't need a database.  But you certainly need a form of data encryption.

Share this post


Link to post
Share on other sites
3 minutes ago, Nine said:

And how will you prevent any techies to erase your data, or modify your data ?  If it's only a question of counting the number of machines running your application, then you don't need a database.  But you certainly need a form of data encryption.

So far based on my testing, I know the .au3 file can convert into .exe file, thus .exe file will encrypted all those of coding then the techies will not able to see the database information?
Any idea of how to do the form of data encryption? This is my first time to build the real-life application.
Much appreciate for the helps.

Edited by gahhon

Share this post


Link to post
Share on other sites

Hard to tell just like this, it will greatly depends on HOW you gonna manage access limitation to your application.  Will it be by user name /  by license key number / by machine name / etc.  Then maybe after all you will need a database to manage all that.  SQLite allows basic multi-users access and some kind of encryption. 

Share this post


Link to post
Share on other sites
On 16/01/2019 at 4:45 AM, Nine said:

Hard to tell just like this, it will greatly depends on HOW you gonna manage access limitation to your application.  Will it be by user name /  by license key number / by machine name / etc.  Then maybe after all you will need a database to manage all that.  SQLite allows basic multi-users access and some kind of encryption. 

Yeah. Regardless of by username, license key, machine name, etc, I still need database to manage all that.
and is not to manage access limitation, is prevent the user copy and paste to another machine.

Example: If user copy and paste to another machine (Machine B), then Machine B cannot execute my application due to the application is only executable on Machine A.

By the way, SQLite is only can be use within the local network tho :/

Share this post


Link to post
Share on other sites
5 minutes ago, gahhon said:

Example: If user copy and paste to another machine (Machine B), then Machine B cannot execute my application due to the application is only executable on Machine A.

Well good luck with that !  I worked for Oracle many years and they were never able to implement a decent solution for such a thing.  They finally decided to rely on client honesty,  Unless you are ready to receive tons of service support calls, I would think about it in depth.  Imagine one sec that your client decide to upgrade all their computers ?  You cannot force your client to be down for that !  Would you ?

Doesn't mean that you shouldn't have some kind of a hidden log to monitor who is accessing your application tho...

Share this post


Link to post
Share on other sites
4 minutes ago, Nine said:

Well good luck with that !  I worked for Oracle many years and they were never able to implement a decent solution for such a thing.  They finally decided to rely on client honesty,  Unless you are ready to receive tons of service support calls, I would think about it in depth.  Imagine one sec that your client decide to upgrade all their computers ?  You cannot force your client to be down for that !  Would you ?

Doesn't mean that you shouldn't have some kind of a hidden log to monitor who is accessing your application tho...

Well. You make the points tho.

Even though that I can monitor who is accessing the application, but I still need to figure what kind of data to be stored and how to store them.

Usually, company would use database to store this monitor log, but as your recommendation I don't think SQLite is the option tho.

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  

  • Recently Browsing   0 members

    No registered users viewing this page.

  • Similar Content

    • By learner123
      Hi All,
       
      I am new to this AUTO IT and I have created a script that will open an app,enter pin and copy the code generated to clipboard. My java code call this autoIT script and use the copied generated code from clipboard.
      This works fine when server  window is on focus. My server is an windows server. 
      But when I minimize or disconnect the server, the script opens the app.exe but doesn't copy any value to clipboard.  
      Can anyone help me on this 😐
       
      Run("C:\Program Files (x86)\RSA SecurID Software Token\SecurID.exe")
      Local $hWnd=WinWait("abc - RSA SecurID Token") ; waits until the window is the active window
      $hWin = WinGetHandle("abc - RSA SecurID Token");
      ControlSend($hWnd,"","","1111") ; simulates pressing the Home key
      ControlSend($hWnd,"","","{ENTER}");
      ControlSend($hWnd,"","","^c");
      Sleep(1000) ;
      ControlSend($hWnd,"","","^c");
       
    • By learner123
      Hi All,
      So I have created a small autoIT script to enter pin into a RSA token(app which generate new code every 30 second), and copy the generated code.
      I have a java application which requires this code so every time my java-code requires this RSA code, it runs the autoIT script and the copied generated code is then used in my java application. 
      I have deployed this code on a windows server and it works fine when I am logged in and the window is on focus, But as soon as I schedule task and disconnect the server (not logged out only disconnect), or even minimize the server window, the autoIT scripts fails and its not able to copy the value.
       
      Please find below the code for AUTOIT.
       
      WinActivate("rsa - RSA SecurID Token") ; activates the window that has old in the tilte bar
      WinWaitActive("rsa - RSA SecurID Token") ; waits until the window is the active window
      Send("1111") ; simulates pressing the Home key, enters password to get the code
      Send("{ENTER}") ; simulates pressing the Enter key
      Sleep(1000) ;
      Send("^c") ; simulates pressing the CTRL+c keys (copy)
       
      Also I saw some post regarding that WINACTIVE only works when window is active. But my below AUTO IT script to handle windows pop up  works perfectly fine when the server is disconnected. 
       
      Opt("WinTitleMatchMode", 1)
      WinWait("https://url","","10")
      WinWaitActive("https://url","","10")
      Sleep(2000)
      Send("userid")
      Sleep(1000)
      Send("{TAB}")
      Sleep(1000)
      Send("passwrd")
      Send("{TAB}")
      Sleep(500)
      Send("{ENTER}")
       
       
    • By JuanFelipe
      Hello gyus, I try to make a code to login in a web page in my job, buy i can’t understand why my form is blocked, this is my code: 
      #include <ButtonConstants.au3> #include <EditConstants.au3> #include <GUIConstantsEx.au3> #include <StaticConstants.au3> #include <StringConstants.au3> #include <WindowsConstants.au3> #include <WinAPIFiles.au3> #include <FileConstants.au3> #include <File.au3> #include <Array.au3> #include <IE.au3> #include <Excel.au3> #include <GuiEdit.au3> #include <GuiStatusBar.au3> #include <DateTimeConstants.au3> #include <Date.au3> #Region ### START Koda GUI section ### Form=C:\noentry\koda_1.7.3.0\Forms\spoa.kxf $Form1 = GUICreate("Eva y Vehículos", 1200, 1000, 10, 10) $prueba = GUICtrlCreateButton("Prueba",10,990,50,20) ;VARIABLES ========================================================================================== $psi = "https://psi.policia.gov.co/PSI/Login.aspx?ReturnUrl=%2fPSI#no-back-button" $chequeVehiculos = "https://psi.policia.gov.co/PSI/frm_lista_chk.aspx" $evaluacionEva = "https://psi.policia.gov.co/PSI/eva_frmver.aspx" $oIE = ObjCreate("Shell.Explorer.2") $GUIActiveX = GUICtrlCreateObj ($oIE, 10, 10, 1180, 980) ;GUICtrlSetState(-1, $GUI_DISABLE) GUISetState(@SW_SHOW) $oIE.navigate($psi) ;_IELoadWait($oIE) _InicioSesion() #EndRegion ### END Koda GUI section ### While 1 $nMsg = GUIGetMsg() Switch $nMsg Case $GUI_EVENT_CLOSE Exit Case $prueba _InicioSesion() EndSwitch WEnd Func _InicioSesion() Local $username = _IEGetObjByName($oIE, "txtUsuario") Local $pass = _IEGetObjByName($oIE, "txtClave") Local $logina = _IEGetObjByName($oIE, "btnIngresar") $username.value="example" $pass.value="examplepass" _IEAction($logina, 'click') _IELoadWait($oIE) MsgBox(16,"","") EndFunc  
    • By shelly
      Here is the below code for handling pop-up when window is  inactive ..but I don't know how to change sleep and when i run this script it runs sometimes and sometimes it stops .
      ControlSend("Policy Decisions -- Webpage Dialog","","Internet Explorer_Server1","{SPACE}")
      ControlSend("Policy Decisions -- Webpage Dialog","","Internet Explorer_Server1","{DOWN}")
      ControlSend("Policy Decisions -- Webpage Dialog","","Internet Explorer_Server1","{ENTER}")
      --- these 3 lines never worked while TAB lines works sometimes but not in accurate way
      I am new too AutoIt .. help me out why this script behaves in strange way
      ControlFocus("Policy Decisions -- Webpage Dialog","","Internet Explorer_Server1")
      Sleep(3000)
      ControlSend("Policy Decisions -- Webpage Dialog", "", "Internet Explorer_Server1","1")
      ControlSend("Policy Decisions -- Webpage Dialog","","Internet Explorer_Server1","{TAB}")
      ControlSend("Policy Decisions -- Webpage Dialog", "", "Internet Explorer_Server1","the request is send")
      Sleep(3000)
      ControlSend("Policy Decisions -- Webpage Dialog","","Internet Explorer_Server1","{TAB}")
      ControlSend("Policy Decisions -- Webpage Dialog","","Internet Explorer_Server1","{TAB}")
      ControlSend("Policy Decisions -- Webpage Dialog","","Internet Explorer_Server1","{TAB}")
      ControlSend("Policy Decisions -- Webpage Dialog","","Internet Explorer_Server1","{TAB}")
      ControlSend("Policy Decisions -- Webpage Dialog","","Internet Explorer_Server1","{TAB}")
      ControlSend("Policy Decisions -- Webpage Dialog","","Internet Explorer_Server1","{TAB}")
      ControlSend("Policy Decisions -- Webpage Dialog","","Internet Explorer_Server1","{TAB}")
      Sleep(3000)
      ControlSend("Policy Decisions -- Webpage Dialog","","Internet Explorer_Server1","{TAB}")
      ControlSend("Policy Decisions -- Webpage Dialog","","Internet Explorer_Server1","{TAB}")
      ControlSend("Policy Decisions -- Webpage Dialog","","Internet Explorer_Server1","{TAB}")
      ControlSend("Policy Decisions -- Webpage Dialog","","Internet Explorer_Server1","{TAB}")
      ControlSend("Policy Decisions -- Webpage Dialog","","Internet Explorer_Server1","{TAB}")
      ControlSend("Policy Decisions -- Webpage Dialog","","Internet Explorer_Server1","{TAB}")
      Sleep(3000)
      ControlSend("Policy Decisions -- Webpage Dialog","","Internet Explorer_Server1","{TAB}")
      ControlSend("Policy Decisions -- Webpage Dialog","","Internet Explorer_Server1","{TAB}")
      ControlSend("Policy Decisions -- Webpage Dialog","","Internet Explorer_Server1","{SPACE}")
      Sleep(3000)
      ControlSend("Policy Decisions -- Webpage Dialog","","Internet Explorer_Server1","{TAB}")
      ControlSend("Policy Decisions -- Webpage Dialog","","Internet Explorer_Server1","{TAB}")
      Sleep(3000)
      ControlSend("Policy Decisions -- Webpage Dialog","","Internet Explorer_Server1","{TAB}")
      ControlSend("Policy Decisions -- Webpage Dialog","","Internet Explorer_Server1","{TAB}")
      Sleep(3000)
      ControlSend("Policy Decisions -- Webpage Dialog","","Internet Explorer_Server1","{TAB}")
      ControlSend("Policy Decisions -- Webpage Dialog","","Internet Explorer_Server1","{DOWN}")
      ControlSend("Policy Decisions -- Webpage Dialog","","Internet Explorer_Server1","{TAB}")
      Sleep(3000)
      ControlSend("Policy Decisions -- Webpage Dialog","","Internet Explorer_Server1","{TAB}")
      ControlSend("Policy Decisions -- Webpage Dialog","","Internet Explorer_Server1","{ENTER}")
       
×
×
  • Create New...