Your Expert Advice Appreciated

Discussion in 'AppleScript' started by Craka, Oct 6, 2016.

  1. Craka

    Craka New Member

    Joined:
    Oct 5, 2016
    Messages:
    3
    Likes Received:
    0
    MY PROBLEM

    First of all I'm no tech genius or even that savvy that said

    The issue i have is that there is a database that i can only access online through a portal.

    What i want to do is get a full copy of this database so i can use for marketing.

    As i can't get one given to me the only option i have is to enter the parameters get the result copying paste to another file.

    To do this manually will be around 35,000 entries

    What I need to do if you look at the image downloaded is

    Copy post code from Excel / Sheets etc
    Paste into Postcode field
    Select from drop down box titled division
    Click search
    Copy Results
    Paste Results to excel

    Repeat around 35,000 times

    Any ideas how i may do this
     

    Attached Files:

    Craka, Oct 6, 2016
    #1
    1. Advertisements

  2. Craka

    Cory Cooper Moderator

    Joined:
    May 19, 2004
    Messages:
    5,101
    Likes Received:
    149
    Hello and welcome.

    Unfortunately, if you are not the owner of the database, and you cannot acquire a copy from them directly, then what you are asking is actually not legal. Because of this, we cannot help you.

    Sorry,

    C
     
    Cory Cooper, Oct 6, 2016
    #2
    1. Advertisements

  3. Craka

    Craka New Member

    Joined:
    Oct 5, 2016
    Messages:
    3
    Likes Received:
    0
    Hi Cory,

    It is Legal i am entitled to access the database.

    My issues is the arcaic nature i must go through to do this,
     
    Craka, Oct 6, 2016
    #3
  4. Craka

    Cory Cooper Moderator

    Joined:
    May 19, 2004
    Messages:
    5,101
    Likes Received:
    149
    OK, thanks for the additional information.

    If you are entitled to access the data, then I would work with the company's IT department to acquire the database by another means. Trying to extract each of the ~35K records via a web interface script would be a long, tedious, and quite complex undertaking. Not to mention any website/database overload issues, and/or possibility of triggering some form of website/server security measures.

    Please know that I am not trying to be accusatory or negative in my responses, I just have to protect myself, Mac Help, and you from any legal ramifications for any suggestions given. As you stated, it is an archaic method to access data, and it would require scripting that is beyond the capabilities of many folks, including myself.

    Hopefully you can work with them to acquire a copy of the database, even though you stated "As i can't get one given to me" in your initial post.

    Again, sorry we can't be of more help to you, and I hope you will understand my/our position.

    C
     
    Cory Cooper, Oct 6, 2016
    #4
    Spawn_Dooley likes this.
  5. Craka

    Craka New Member

    Joined:
    Oct 5, 2016
    Messages:
    3
    Likes Received:
    0
    thanks
     
    Craka, Oct 7, 2016
    #5
    1. Advertisements

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.
Similar Threads
  1. Guilty-Light
    Replies:
    2
    Views:
    755
  2. Duncan Langford

    G5 DVD playing - advice appreciated!

    Duncan Langford, Sep 22, 2003, in forum: Apps
    Replies:
    3
    Views:
    218
    Alan Quirt
    Sep 24, 2003
  3. Duncan Langford

    G5 DVD playing - advice appreciated!

    Duncan Langford, Sep 22, 2003, in forum: Hardware
    Replies:
    2
    Views:
    216
    John Johnson
    Sep 23, 2003
  4. Duncan Langford

    G5 DVD playing - advice appreciated!

    Duncan Langford, Sep 22, 2003, in forum: Video Hardware
    Replies:
    2
    Views:
    234
    John Johnson
    Sep 23, 2003
  5. Duncan Langford

    G5 DVD playing - advice appreciated!

    Duncan Langford, Sep 22, 2003, in forum: Misc
    Replies:
    2
    Views:
    206
    John Johnson
    Sep 23, 2003
  6. FUTURE SHOCK: iPad Protected by 200 Patents

    Your Dying Words Better Be Your PIN, Or Verizon Will Bill Your Corpse

    FUTURE SHOCK: iPad Protected by 200 Patents, Mar 6, 2010, in forum: iPhone
    Replies:
    6
    Views:
    561
    Larry
    Mar 8, 2010
  7. Apple
    Replies:
    1
    Views:
    1,027
    oldscribe
    Apr 19, 2013
Loading...