jeudi 8 mars 2018

Updating fields in one web page based upon another?

I have a web page in which you enter some query parameters and it returns the results:

Scheme  RespCode    ShortDesc   LongDesc                    Meaning MeaningDescL    MeaningDescS
ABI93   000                     Approved                    A       Approve Apv
ABI93   001                     Honour With Identification  D       Decline Dcn
ABI93   002                     Approved For Partial Amount A       Approve Apv

from which I want to correlate the 'RespCode' in another web page with the 'LongDesc'. The second web page is a report that looks like this:

 Slot               Label   UserName    Message                RespCode TxnCount    RespTime
2018-03-06 18:00:00 VMGANB  ANBPFD01    VMX.ACCOUNT.INQ        000      2764    0.01237
2018-03-06 18:00:00 VMGANB  ANBPFD01    VMX.ACCOUNT.INQ        118      2   0.01604
2018-03-06 18:00:00 VMGANB  ANBPFD01    VMX.CARDACTIVATION.UPD  000     12  0.01120
2018-03-06 18:00:00 VMGANB  ANBPFD01    VMX.REALTIME.PAY        000     140 0.01729
2018-03-06 18:00:00 VMGANB  ANBPFD01    VMX.REALTIME.PAY        100     17  0.04473
2018-03-06 18:00:00 VMGANB  ANBPFD01    VMX.STATEMENT.INQ       000     67  0.00814

and I'd like to see the 3-digit RespCode from the 2nd page replaced with either the LongDesc from the 1st web page.

I'm NOT a web developer, although I have tinkered a bit - could I have both pages open and some JS to parse one page and dynamically update the other? Or should I save both pages, parse the first to build some code to edit the saved 2nd page and then display it?

There is no cgi-bin URL for the report page with the necessary parameters, so I don't think I can trigger the reports from my own web-page and then capture the results and do the necessary substitution.

Edit: Sorry if I've not explained this very well - I could always copy these 2 pages into Excel and use VLOOKUP to replace the RespCode with the LongDesc, if that makes my intention clearer.




Aucun commentaire:

Enregistrer un commentaire