Tony

Forum Replies Created

Viewing 6 posts - 1 through 6 (of 6 total)
  • Author
    Posts

  • Tony
    Participant

    We have software that imports the ILR files and the data can then be compare/merge etc. However, it depends on what you want from the results.

    To see the difference in XML I actually use Beyond Compare. It just compares the text and shows the difference in the window. What is really nice is the highlighting and visual representation of the differences.

    Tony

     
    in reply to: Software to compare two ILR files #4375

    Tony
    Participant

    FEConnect removed some text from above – XSS probably

    for C:\Users\\ read as C:\Users\(computer account name)\

    Sorry – should have realised the angle brackets were going to be an issue

     
    in reply to: Where does FIS go? #2841

    Tony
    Participant

    C:\Users\\AppData\Roaming\Microsoft\Windows\Start Menu\Programs\Skills Funding Agency\Data Collection and Funding Transformation

    This is the location of the shortcut (application reference), the actual application goes into Local/Apps and is updated by the above app links, but the data goes elsewhere (SQL Server). As a click once Microsoft application, it’s not as simple as where is the EXE I am afraid.

    This is where my exe ends up: C:\Users\\AppData\Local\Apps\2.0\DH66RAXE.KNV\YG808JL1.ONA\fund..stem_32bb07491246f85f_0001.0000_none_e660c4eadc961209\Funding Information System.exe

    As on Monday this week, the Data Service Helpdesk now ‘officially’ supports FIS, so if it’s trying to download every time, I would report it to them.

    Tony

     
    in reply to: Where does FIS go? #2835

    Tony
    Participant

    It’s been a while but I think ConciseEmployerStructure is an array…

    uk.gov.lsc.edrs.services.EmployerLookup wsEL=null;
    uk.gov.lsc.edrs.services.ConciseEmployerStructure[] wsOrg=null;
    try
    {
    wsEL = new EDSURNLookup.uk.gov.lsc.edrs.services.EmployerLookup();
    wsOrg = wsEL.ByUrn(iUrn, sWSPassword);
    }

    Works – so try to convert that to VB.NET?

    Tony

     
    in reply to: Recording of Large Employer Information on the ILR #524

    Tony
    Participant

    The web service is definition is at https://services.edrs.lsc.gov.uk/lookup.asmx?wsdl

    and the portal is http://edrs.lsc.gov.uk/

    You’ll need passwords for each.

    Tony

     
    in reply to: Recording of Large Employer Information on the ILR #521

    Tony
    Participant

    The list names is available via the EDS (EDRS etc) portal or web service. We do a lot of data mining with some of the publically available information listed on web sites or web services and write some very simple, very useful tools to get the data.

    To get the name of the organisation from a URN, you can use Excel

    I have written a simple Excel Template to get the details from EDRS. Download it at https://www.cognisoft.com/files/exceledsurnlookup.zip

    Run setup to install the Excel Template and then open the xltx in Excel 2007, enter your Web Service credentials in the username.password box and click ‘Get’. You can ask for several at a time. (or the whole Large Employer list!)

    Our main applications can do much more.

    Tony
    tony@cognisoft.co.uk

     
    in reply to: Recording of Large Employer Information on the ILR #519
Viewing 6 posts - 1 through 6 (of 6 total)