SPONSORS:






User Tag List

Thanks Thanks:  0
Likes Likes:  0
Dislikes Dislikes:  0
Results 1 to 3 of 3
  1. #1
    Super Member
    Join Date
    Jul 1999
    Location
    Rancho Santa Margarita, CA
    Posts
    1,441
    Post Thanks / Like
    Mentioned
    4 Post(s)
    Tagged
    1 Thread(s)
    Total Downloaded
    0

    Excel data on local PC, AUT on remote PC

    Scenario:
    ST2010 runs on your local PC. MS Excel containing your data (input and output) also in this PC.
    AUT runs on a remote PC (an embedded/stripped version of XP OS loaded, no MS Excel or Excel driver, many stuffs missing) where only ST2010 Agents are installed.
    How would you set this up where you read the data from .xls file on local PC, switch to AUT on remote and gather info and write to file (.xls or .txt), then compare this info from remote with data in previous .xls file?

    If this something you've done before, can you give an example?
    I'm sure this will require having multiple SilkTest Agents (one in local, one in remote) but, I'm not sure if Excel or Excel driver has to exist in the remote machine.

    Thanks a lot.
    SilkInTheCity

  2. #2
    Senior Member
    Join Date
    Oct 2002
    Location
    England
    Posts
    368
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Total Downloaded
    0

    Re: Excel data on local PC, AUT on remote PC

    The excel ODBC driver will allow you to connect to a remote .xls (assuming it's in a shared folder that you have permissions to), so I'd go this route.

    Create a dsn on the remote machine pointing to back to the .xls (in a shared folder) on your local machine. This assumes you can install the excel driver on the remote, otherwise you're limited to .txt files.

    The only thing you'd have to be careful of is ensuring that the connection to the .xls is terminated after you've read the input data and before you invoke the remote agent, and similarly, ensure that the remote agent relinquishes control of the .xls in the shared folder on your local machine, once it's written all the output data. Otherwise you'll get all sorts of mayhem breaking out as the connection will still be active hence (probably) locking the .xls. Excel is extremely sensitive to locks particularly when in the file is open for update/write.

    Unless of course someone here has a more elegant solution?

    Regards
    peat

  3. #3
    Super Member
    Join Date
    Jul 1999
    Location
    Rancho Santa Margarita, CA
    Posts
    1,441
    Post Thanks / Like
    Mentioned
    4 Post(s)
    Tagged
    1 Thread(s)
    Total Downloaded
    0

    Re: Excel data on local PC, AUT on remote PC

    [ QUOTE ]
    The excel ODBC driver will allow you to connect to a remote .xls (assuming it's in a shared folder that you have permissions to), so I'd go this route.

    Create a dsn on the remote machine pointing to back to the .xls (in a shared folder) on your local machine. This assumes you can install the excel driver on the remote, otherwise you're limited to .txt files.

    The only thing you'd have to be careful of is ensuring that the connection to the .xls is terminated after you've read the input data and before you invoke the remote agent, and similarly, ensure that the remote agent relinquishes control of the .xls in the shared folder on your local machine, once it's written all the output data. Otherwise you'll get all sorts of mayhem breaking out as the connection will still be active hence (probably) locking the .xls. Excel is extremely sensitive to locks particularly when in the file is open for update/write.

    Unless of course someone here has a more elegant solution?

    Regards
    peat

    [/ QUOTE ]

    Thanks for your input peat!
    Yeah. The more I looked at what this remote machine has (a medical device like the size of an iPad) with all ODBC drivers including that for Excel showing "Not marked", it seems like my best option is to use the .txt files.

    Installation of the Excel driver is out of the picture as an option unless it can be installed on the d: drive. They set the c: drive protected to have the application be the only thing that will run (almost no space left for anything else) then a bigger d: drive that has around 5 Gig of space and not protected where SilkTest Agents are installed.

 

 

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Search Engine Optimisation provided by DragonByte SEO v2.0.36 (Pro) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
Resources saved on this page: MySQL 12.50%
vBulletin Optimisation provided by vB Optimise v2.6.4 (Pro) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
User Alert System provided by Advanced User Tagging v3.2.8 (Pro) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
vBNominate (Lite) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
Feedback Buttons provided by Advanced Post Thanks / Like (Pro) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
Username Changing provided by Username Change (Free) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
BetaSoft Inc.
Digital Point modules: Sphinx-based search
All times are GMT -8. The time now is 04:16 PM.

Copyright BetaSoft Inc.