Jump to content
gahhon

How to read and update data in Google SpreadSheet?

Recommended Posts

gahhon

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
FrancescoDiMuro

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
6 hours ago, FrancescoDiMuro said:

Hmm... It don't say anything about AutoIT script example?

 

Share this post


Link to post
Share on other sites
FrancescoDiMuro

@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
gahhon

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
gahhon
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
FrancescoDiMuro

@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
Nine
3 hours ago, gahhon said:

The reason why I am doing this is similar to database, since the database need to rent

you could use SQLite (no rent) 

Share this post


Link to post
Share on other sites
gahhon
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
Nine
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
gahhon
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
Nine
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
gahhon
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
Nine

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
gahhon
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
Nine
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
gahhon
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

  • Similar Content

    • gahhon
      By gahhon
      I have a python script automate.py and I wanna run it via CMD.
      As I know to execute python via CMD is something like this
      $CMD = "Something python here" Run(@ComSpec & " /c " & $CMD) But how can I just open the 1 CMD and send multiple commands to the CMD based on the function called?
      For instance like:

      Launch CMD and send python then send import automate If google() function is called - send automate.google() to the CMD If yahoo() function is called - send automate.yahoo() to the CMD  I don't want to execute multiple CMD to call the automate functions. This is due to inside the python script have global variable to handle duplicate flag.
      So if I execute multiple CMD to call the functions, the global variable will be keep new as NULL. Which is not my expectation.
       
      Thanks
    • gahhon
      By gahhon
      I only found that AutoIt can actually execute the entire python script or execute the .exe (converted to .exe from .py)
      But what if I just want call the particular function? If that possible to do so?
      This is because python can't create fancy GUI like AutoIT does. So my plan is use AutoIT to have fancy GUI.
      Then each buttons will trigger specific function in the python script or .exe file.
      For instances:
      btnSum - trigger function in python script or .exe file (funcSum)
      btnMinus - trigger function in python script or .exe file (funcMinus)
       
      Thanks for advance information.
    • nacerbaaziz
      By nacerbaaziz
      Hello my friends
      Can we create a single context menu on more than one item?
      For example, a context menu includes standardized options on more than one control, such as buttons or check boxes
      to Create a context menu on one item am using this function
      GUICtrlCreateContextMenu ($ HWND)
      How to link it with more than one element please?
      or if we can't do that, please give me a solution
      so i tried to add an context menus to all the controls but the script will be long, for that if their are any solutions i hope to give it to me
      thanks in advanced
    • gahhon
      By gahhon
      _Metro_SplashTextScreen(1, "", $iMsg) AdlibRegister("_Metro_LoopInProgress") DirRemove($DIR_WA_FOLDER, 1) Local $iCopy = _WinAPI_ShellFileOperation($CUR_WA_FOLDER, $DIR_WA_FOLDER, $FO_COPY, BitOr($FOF_SIMPLEPROGRESS, $FOF_NOCONFIRMMKDIR)) AdlibUnRegister("_Metro_LoopInProgress") _Metro_SplashTextScree If @error Then _Metro_MsgBox(0, "", $iCopy) _FileWriteLog($LOG_INSTALLATION, "Error: " & $iCopy) Else _Metro_MsgBox(0, "", "Application is up to date!") _FileWriteLog($LOG_INSTALLATION, "Debug: Application is up to date.") EndIf According to the help file of _WinAPI_ShellFileOperation there are a lot of failure and error code. But how can I handle all of them and display corresponding error message based on the help file?
      The incident is like this:
      I'll lock the folder with permission, so when I execute the _WinAPI_ShellFileOperation to copy and overwrite the folder contents, it popped me an error message saying that permission issue to caused I can't access the folder and overwrite the contents.

      Then I clicked Cancel button, and my AutoIT application exit immediately and it's not execute the function _Metro_MsgBox(0, "", $iCopy) to display the message.
       
      Anyway, I did also tried the code below, the it still display "Application is up to date!"
      According to the help file, 120 - Security settings denied access to the source.
      If @error = 120 Then _Metro_MsgBox(0, "", $iCopy) _FileWriteLog($LOG_INSTALLATION, "Error: " & $iCopy) Else _Metro_MsgBox(0, "", "Application is up to date!") _FileWriteLog($LOG_INSTALLATION, "Debug: Application is up to date.") EndIf  
    • gahhon
      By gahhon
      I have a application that have a function is to create a shortcut to desktop, lets say is ChromePortable.lnk.
      $iCreate = FileCreateShortcut($DIR_WA_FOLDER & '\GoogleChromePortable.exe', $DIR_SHORTCUT, $DIR_WA_FOLDER, '--kiosk "https://example.com/"') So the shortcut will be launch as kiosk mode and force to enter the specific website. However, the user is still able to right-click on the shortcut and modify the target value to remove the kiosk mode. What can I do to disable the user to editing the target value?
      So far, I had asked and tried from SuperUser for advises Disable Shortcut Target Field
      icacls "ChromePortable.lnk" /GRANT EVERYONE:RX So this will set the permission of this shortcut file to only Read & Execute only! But after I set it, the user is still can modify.
      Please kindly advise.
      Please note and assume that user don't have Administration account or etc, that should be only have 1 account to logon to the computer.
       
      EDIT:
      I must disable inheritance to remove all others permissions like SYSTEM, ADMINISTRATORS, etc. Then only GRANT everyone for READ & EXECUTE only.
      But still the user can go to edit the permissions tho. Any advise?
×