• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 242
  • Last Modified:

Copy Data on the screen where the data was presented by a java applicaton

I use a commercial application that presents data on the screen via a java application.

I want to copy the data on the screen and insert the data into a spreadsheet.

Normally I use ctl-a, ctl-c, and ctl-v to paste.

That does not work here.

Any thoughts on how I can get the data off the screen (other than screen shots).

Thanks,
Cgee
0
williecg
Asked:
williecg
  • 5
  • 4
  • 2
  • +1
1 Solution
 
aikimarkCommented:
what software development tools do you use?
0
 
williecgAuthor Commented:
I am a business analysist, so I am not a developer. I use VB, Net 4, and the office suite.
0
 
aikimarkCommented:
@williecg

(assuming you access this application through a browser) If you view source for the page, do you see the data you want to transfer?
0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
BillDLCommented:
What does the Java Applet actually display in your browser?  Is it text-based content that you want to grab, or does it show images?
0
 
williecgAuthor Commented:
BillDL,

it displays rows of data like excel, it is not images.

Aikimark,

I looked at the web page via view source, the data does not appear.
Below is what appears

<HTML>
<HEAD>
  <TITLE>MLXchange</TITLE>
      <LINK rel="stylesheet" type="text/css" href="/5.3.09.19049/Styles/MLXchange.css" />
  <LINK rel="stylesheet" type="text/css" href="/DotNet/Framework/GetCustomCSS.ashx" />
  <!-- NOTE: DO NOT include any scripts directly in this file unless they are only ever used in
     the stand-alone version of MLXchange. If you are unsure, just include the scripts through
     DefaultScriptINC.asp (below)... this will ensure they are available when accessing the
     application through MLS Passport, or through normal execution. -->
   
 
  <script src="/A2EB891D63C8/avg_ls_dom.js" type="text/javascript"></script><SCRIPT language="javascript" src="/5.3.09.19049/Include/ErrorHandler.js"></SCRIPT>
  <SCRIPT defer language="javascript" src="/5.3.09.19049/Include/AppUserInfo.js"></SCRIPT>
  <SCRIPT defer language="javascript" src="/5.3.09.19049/Include/ClientParam.js"></SCRIPT>
  <SCRIPT defer language="javascript" src="/5.3.09.19049/Include/CMAPresentationList.js"></SCRIPT>
  <SCRIPT defer language="javascript" src="/5.3.09.19049/Include/ComponentPoolStatus.js"></SCRIPT>
  <SCRIPT defer language="javascript" src="/5.3.09.19049/Include/ProcessTags.js"></SCRIPT>
  <SCRIPT defer language="javascript" src="/5.3.09.19049/Include/FieldIDs.js"></SCRIPT>
  <SCRIPT defer language="javascript" src="/5.3.09.19049/Include/FilterFields.js"></SCRIPT>
  <SCRIPT defer language="javascript" src="/5.3.09.19049/Include/MiscParms.js"></SCRIPT>
  <SCRIPT defer language="javascript" src="/5.3.09.19049/Include/UserParms.js"></SCRIPT>
  <SCRIPT defer language="javascript" src="/5.3.09.19049/Include/ImageGlobals.js"></SCRIPT>
  <SCRIPT defer language="javascript" src="/5.3.09.19049/Include/LMMFieldList.js"></SCRIPT>
  <SCRIPT defer language="javascript" src="/5.3.09.19049/Include/MapManager.js"></SCRIPT>
  <SCRIPT defer language="javascript" src="/5.3.09.19049/Include/ShowOperatorStatus.js"></SCRIPT>
  <SCRIPT defer language="javascript" src="/5.3.09.19049/Include/StatusMappings.js"></SCRIPT>
  <SCRIPT defer language="javascript" src="/5.3.09.19049/Include/UserAppLevel.js"></SCRIPT>
  <SCRIPT defer language="javascript" src="/5.3.09.19049/Include/UserClassImgUploadPermission.js"></SCRIPT>
  <SCRIPT defer id="scriptViewUtils" language="javascript" src="/5.3.09.19049/Include/ViewUtil.js"></SCRIPT>
  <SCRIPT language="javascript" src="/5.3.09.19049/Include/XMLUtils.js"></SCRIPT>
  <SCRIPT defer language="javascript" src="/5.3.09.19049/Include/ShowWait.js"></SCRIPT>
  <SCRIPT defer language="javascript" src="/5.3.09.19049/Include/SmartLink.js"></SCRIPT>
  <SCRIPT defer language="javascript" src="/5.3.09.19049/Include/WindowUtils.js"></SCRIPT>
  <SCRIPT defer language="javascript" src="/5.3.09.19049/Search/CacheSearchCriteria.js"></SCRIPT>
  <SCRIPT defer language="javascript" src="/5.3.09.19049/Search/SearchFields.js"></SCRIPT>
  <SCRIPT defer language="javascript" src="/5.3.09.19049/Search/GridFields.js"></SCRIPT>
  <SCRIPT defer language="javascript" src="/5.3.09.19049/Search/GridList.js"></SCRIPT>
  <SCRIPT defer language="javascript" src="/5.3.09.19049/Search/SearchList.js"></SCRIPT>
  <SCRIPT defer language="javascript" src="/5.3.09.19049/Search/PrevSearchList.js"></SCRIPT>
  <SCRIPT defer language="javascript" src="/5.3.09.19049/Search/ViewList.js"></SCRIPT>
  <SCRIPT defer language="javascript" src="/5.3.09.19049/Home/Resources.js"></SCRIPT>
  <SCRIPT defer language="javascript" src="/5.3.09.19049/Home/Hotsheet.js"></SCRIPT>
  <SCRIPT defer language="javascript" src="/5.3.09.19049/Home/InventoryList.js"></SCRIPT>
  <SCRIPT defer language="javascript" src="/5.3.09.19049/Transactions/Transactions.js"></SCRIPT>
  <SCRIPT defer language="javascript" src="/5.3.09.19049/Login/Billing.js"></SCRIPT>
  <SCRIPT language="javascript" src="/5.3.09.19049/Include/Default.js"></SCRIPT>
  <SCRIPT defer language="javascript" src="/5.3.09.19049/ListingMaintenance/FieldHelp.js"></SCRIPT>
  <SCRIPT defer language="javascript" src="/5.3.09.19049/Search/ClientList.js"></SCRIPT>
  <SCRIPT defer language="javascript" src="/5.3.09.19049/Include/FieldValidation.js"></SCRIPT>
  <SCRIPT defer language="javascript" src="/5.3.09.19049/Include/ValidValues.js"></SCRIPT>
  <SCRIPT defer language="javascript" src="/5.3.09.19049/Include/AppLevelFunc.js"></SCRIPT>
  <SCRIPT defer language="javascript" src="/5.3.09.19049/Include/OfficeNameList.js"></SCRIPT>
  <SCRIPT defer language="javascript" src="/5.3.09.19049/Include/BoardCodeList.js"></SCRIPT>
  <SCRIPT defer language="javascript" src="/5.3.09.19049/Include/ProcessMappedFields.js"></SCRIPT>
  <SCRIPT defer language="javascript" src="/5.3.09.19049/Include/ProcessMappedFieldCache.js"></SCRIPT>
  <SCRIPT defer language="javascript" src="/5.3.09.19049/Include/AccessUtils.js"></SCRIPT>
  <SCRIPT defer language="javascript" src="/5.3.09.19049/Include/StationeryList.js"></SCRIPT>
  <SCRIPT defer language="javascript" src="/5.3.09.19049/Login/MD5.js"></SCRIPT>
  <SCRIPT defer language="javascript" src="/5.3.09.19049/Tools/SecurityLinx/RegisteredProfileManager.js"></SCRIPT>
  <SCRIPT defer language="javascript" src="/5.3.09.19049/Include/UserData.js"></SCRIPT>
  <SCRIPT defer language="javascript" src="/5.3.09.19049/Include/LogicalRelationList.js"></SCRIPT>
 
 
  <SCRIPT language="javascript">
   
    // Session Buffer Minutes is used to check the session slightly before
    // it supposed to expire to deal with time difference with the actual servers.
    var SESSION_BUFFER_MINUTES = 1;
    var g_iSessionTimeout     = 600;  // Store the session timeout (its in minutes).
    var g_iInactivityTimeout  = 90;    // Store the Inactivity timeout (its in minutes).
   
    // Login type used.
    var g_sIsPubPrivLogin = new String("true");
   
    // Nextgen user data used in HEADER.ASP
    var g_sUserName   = 'CAROLYN GRIMSLEY';
    var g_sUserFirstName = 'CAROLYN';
    var sBusinessName = '';
    var sUID          = '866245185';
   
    // Store the UserClassID. Used to determine if this is a datalink user.
    var g_iUserClass  = new Number(13);
    var g_sPswdExpireDays = '-1';
     
    // Store the User GUID in a global variable for access from the Infranet pages
    var g_sGUID = new String('{738DC3A1-A7A5-4C8C-B427-C2B83CFFCE8E}');
       
    // Set global variable to indicate if we are hosted (i.e. run from Passport)
    // This must stay here and not in the DefaultJS file as in LMDefault.asp
    // this is set to TRUE. If it was in JS it would always get set to false.
    var g_bHosted = ('1' == '0') ? true : false;
   
    // Indicate if we need to configure Professional
    var g_bConfigurePro = ('1' == '0') ? true : false;
   
    // Indicate if we need to display a special page at Startup
    var g_sMLXReleaseInfoStartPage = new String('');

    // Indicate if the user wants to be taken to a Sign-in as Dialog at Startup
    var g_bDisplaySignInAs = ('1' == '0') ? true : false;
   
    //  Indicate if we need to switch to a particular function at Startup
    var g_sMLXFunction = new String('');
   
    //  Store User's board code as a global
    var g_sUserBoardID = new String('N');

    //  Gateway Auto Build
    var g_iMLXType = 2;
    var g_bGatewayBuildSite = ('Y' == 'N') ? true : false;
    var g_bRegistrationComplete = ('Y' == 'N') ? true : false;
   
    var g_sStartMenuDefault = new String('');
   
    // Registered profile id
    var iProfileID = parseInt('');

    // If profile is disabled... (ProfileID == -1001)
   
       
    // If too many sessions...
     
    // end if too many sessions...

   
    // Check if this is a datalink user. If it is and they don't have too many sessions,
    // send them to the datalink screen.
    if((6 == g_iUserClass || 99 == g_iUserClass))
    {
      // Rather than have the datalink page look up the session
      // timeout and inactivity time out, just pass them as
      // query strings. This should be changed down the road
      // so that datalinks default.asp can be cached but since it
      // isn't curently I'm not making it any worse. M.K. 06/2006
      var sURL = "/5.3.09.19049/DataLink/default.asp" +
                "?MaxSessionTimeout=" +g_iSessionTimeout +
                "&InactivityTimeout=" +g_iInactivityTimeout;
      document.location.href = sURL;
    }
   
  </SCRIPT>
 
  <NOSCRIPT>
    <P align="center">
      <TABLE WIDTH="80%" border=0>
        <TR>
          <TD id="TitleText" class="TitleText" style="color:red">Warning...</TD>
        </TR>
        <TR>
          <TD id "InfoText" class="InfoText" COLSPAN=2>
            <P align="center" class ="ErrorText">
              Your browser is currently not setup to allow scripting. MLXchange requires
              the use of scripting to deliver its dynamic content. Please click
              <A HREF="/SettingsInstr.htm">here</A> for instructions on how to do this.
            </P>
          </TD>
        </TR>
      </TABLE>
    </P>
  </NOSCRIPT>
</HEAD>
<BODY ondragstart="return false;" id="theBody" class="CoverPage" onload="RenderDefault()" onUnload="OnBodyUnload()">
  <DIV id="divLoginPage">
    <DIV id="divLoginMLXLogo"></DIV>
    <DIV id="divLoginBrandingImage"></DIV>
    <DIV id="divLoginLinks" style="display:none"></DIV>
    <DIV id="divLoginHeader"></DIV>
    <DIV id="divConnecting">Loading MLXchange...</DIV> <!-- connecting animation and copyright -->
    <DIV id="divLoginCopyright">
      MLXchange is a trademark of MarketLinx, Inc. Copyright 2011
    </DIV>
  </DIV>
</BODY>
</HTML>
0
 
CodeCruiserCommented:
> I am not a developer. I use VB, Net 4,

:-)

>data was presented by a java applicaton

This is a website that's producing data using Javascript

I dont think you will have much luck with this.
0
 
aikimarkCommented:
if the data is text, you should see it.  Please check again.
0
 
williecgAuthor Commented:
CodeCrusier,

I like your insight, I just don't understand the why of your statement, could you provide non developer explanation?

Aikimark,
 I can print the page via browser print function.  

I print it to a pdf file, then I can scrape the data from the pdf file.

Could not do that if it were images.

thanks folks.

Cgee
0
 
BillDLCommented:
Hi Cgee

What CodeCruiser was saying is that the web page you gave the source code for seems to only be using JavaSCRIPT, Not loading any JAVA Applets.

Java vs JavaScript
0
 
aikimarkCommented:
@Cgee

How about saving one of these pages (HTML complete) and posting it.  Let us know what data you need to import.
0
 
williecgAuthor Commented:
I had to go out of town on a family matter. I am back now.  

I spoke with someone on the development team for the application.  There is a java application that runs on the pc, (it is not an applet).  They have it designed such you cannot scrape it.

My solution was to print it as a pdf, and scrape the pdf.

Not very elegant, but it works.

Thanks for all of your suggestions.
0
 
williecgAuthor Commented:
Not very elegant, but it works.
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

  • 5
  • 4
  • 2
  • +1
Tackle projects and never again get stuck behind a technical roadblock.
Join Now