ARC IAR Utilities

Utilities designed free of charge for working with your ARC IL Ticketing data.

Working with ARC IL DATA

About our ARC IL Utilities

Working with ARC IL ticketing information is an integral part of business for many corporate business travel agencies today. Sector Micro Computer provides a number of utilities, free of charge, for BTAs to use with their IL ticketing data for reporting and importing into accounting systems.


Listed below are the following utilities you may download for use with your ARC IL Ticketing data.

System Requirements
  • Runtime: Microsoft .NET Framework Version 4.0. Click [HERE] to visit the Microsoft Website to download and install the latest .NET framework.
  • Operating Systems: Microsoft Windows XP (Service Pack 3), Windows Vista (Service Pack 1 or greater), Windows 7, Windows8, Windows Server 2003 (Service Pack 2), Windows Server 2008 R2 (Service Pack 1)
  • Hardware requirements (minimum): Pentium 1Ghz with 512MB RAM
  • Disk Space: 30 MB free disk space

  • [Click here to download]

    About

    ILUTIL [Standard] is the latest utility developed at Sector Micro Computer and is now available for use. ILUTIL [Standard] was designed to allow users to print an ARC type sales report or export their data to a file that can be used in other applications. ILUTIL [Standard] retains the features of the previous utility, and builds on them by adding NEW features such as XML based output - where you have the option to export your data to an XML based file. Full support for the latest specifications from ARC – the ILUTIL [Standard] application will recognize the new fields from ARC and will include them in the CSV and XML output.

    What's New?
  • Export process includes old exchange tickets not containing a date of issue.
  • Added checks to import process for missing Issue Dates in Dci Headers.
  • Improved speed of import process when working with large data files.
  • Ticketing data is now encrypted during import process.
  • Added feature to Mask Credit Card Numbers during import process.
  • SQL Server 2005 Express is no longer a requirement to use this utility.
  • Resolved issues with UAC on Windows Vista/7.
  • Improved support for 64-Bit systems.

  • Loading and Exporting to CSV or XML

    Loading your data into the ILUTIL database is a simple process. (see Figure 1) In the ARC IL File text box, either type in the location and name of the file you downloaded from ARC, or click on the Browse Button next to the text box to search for the file. Once you locate your file, simply click on the Load button and ILUTIL [Standard] will load your data into the database for use. The progress bar will indicate when this task is complete. After the utility has finished loading the data into the database, you may either produce a report, or export your data to a Comma Delimited file (CSV) or XML file.


    ILUTIL [Standard]

    By default, the option "CSV, No Headers" is selected for exporting to a comma-delimited file.

    NOTE: This export option MUST BE USED if you wish to produce a CSV file that, in turn, will be imported into our Alpha Accounting System.

    If you wish to use the other options for export, click the down arrow next to the Export button to one of the additional options for export. Once selected, the caption on the Export button will change to reflect the choice you made (either CSV, No Headers, CSV Headers, TAB Delimited, or XML File). Once you selected the option of your choice, click the Export button. A Save As dialog box will pop up asking you to enter a name for the file and a location to where you want to save the file to. Once you enter a name and specify a location where the file should be save to, click on the OK button and ILUTIL [Standard] will export your data.

    Click [HERE] to download

    About

    This utility is designed to assist IAR users in printing a report from the data in the ARC database using the IL handoff file. The IL file contains the basic data used for your ARC sales report. The utility ILUtil will print the file in an ARC report style with columns for the document number, issue date, error and void status, base, tax and commission amounts, and form of payment. By using the 1B format, the PNR locator will also be present. The document order of the report will be in the order of the file. Output from the utility can be directly to a printer or a file. File output will be in CSV format, ready for import into a spreadsheet.

    Click [HERE] to download the IARtoCSV utility.

    About

    This utility is designed for users and developers who are interested in working with the IAR data but are finding it difficult to use because of its unfriendly format. If you open up the IAR file in a text editor (assuming it can handle the width), it looks like one very long line. No breaks and strange characters like the ASCII 128 End Of Field character. By applying the rules set by ARC, we have created a program to convert the IAR format for any current IAR file, both 1A and 1B formats for IL and IB files. It will convert fields into comma and quote separated values and it will mark repeating sections with the fields BEGINREPEAT and ENDREPEAT. Data sets will begin with NEWDATASET.

    The resulting CSV file is intended to be read by other PC based programs like spreadsheets or databases that can read CSV files. For example, if you create an IAR IL file (the result of an IL command in the GDS/IAR work area) and download it from the Internet site, you can run it through the IARtoCSV.EXE program and then open up the resulting file in Excel. By removing the first two lines (the file header record and the BEGINREPEAT record) you have a table of your ARC report.

    Usage
    c:\IL_DOS>\IARTOCSV.exe ILFileName (where ILFileName represents the name of the IL Ticketing Data you downloaded from ARC)

    This will produce a file with the same filename with an extension .CSV. The CSV file will be created in the same directory as the original data.

    If you wish to specify the output filename, you can do so by including a second parameter in the command line.

    c:\IL_DOS>IARTOCSV.exe ILFileName output.CSV

    Output.csv can be any name (example: mydata.csv). The CSV extension added to the output file name is not required, but recommended as it facilitates opening the file in spreadsheet applications.

    From Windows Desktop

    Drag the IARfilename icon on top of the IARTOCSV program icon (or a shortcut icon).

    NOTE: We recommend that you set you set up a folder on your desktop which contains the executable and the IAR data files. The output files will be created in the same folder.You will notice in the image above, after dragging the Sample.IAR file over the IARtoCSV.exe application, it automatically created a Sample.CSV file that can be used in Excel or any other application that can read CSV files.