Anyone involved with institutional reporting will tell you that when it comes to the end results, one report definitely does not fit all. Submitting reports to third parties—be they government agencies, financial institutions, or higher ed clearinghouses—can be particularly tricky. Every third-party organization has different data requirements and formatting standards, all of which must be followed down to the very last detail. Designed with an eye to those finicky requirements, Argos’s Extract Report format offers tools for producing reports that are both versatile and precise.
Of the three report formats available in Argos, Extract Reports are the most commonly overlooked. They offer some layout options and structural flexibility that Banded Reports and CSV Reports do not. Extract Reports don’t have the rich formatting options of Banded Reports, but they do allow for much more rigidly defined layouts. And although CSV Reports offer an option for generating simple comma-delimited output, Extract Reports boasts some useful bells and whistles. One of the biggest advantages of Extract Reports is that no matter how complex or precise your output requirements are, you can produce the report you need without having to enlist the help of the IT department.
We thought it would be useful to share some best practices for using Extract Reports (much as we did with Banded Reports, recently), to help you fully harness the power of these reports.
Know your Audience
The first step to getting the most out of your Extract Report experience is to gather as much information as you can about the formatting requirements of your recipient. Let’s say Enrollment Services needs an extract of student data that they can import into their ID card system—make sure you have a super-detailed discussion with the department about the ID card system’s formatting requirements. You might even need to talk to the ID card system vendor to get that information. Fortunately, in the case of third-party organizations, they typically have intensely detailed documentation that lays out out their formatting requirements. Get to know that documentation.
The Right Format for the Job
Extract reports come in three different formats, and each has its its strengths and weaknesses. Although most of the time, the recipient’s requirements will dictate which format you use, it’s useful to have a good grasp on what each of the formats can do. Here’s a quick breakdown of the three formats:
- Fixed-Width – In this format, the width of each field is fixed at a length that you can define. This format lets you produce reports that meet stringent custom formatting specs from third-party organizations.
- Delimited – Similar to CSV reports, each field in this format is separated by a delimiter. Unlike CSV reports, however, delimited Extract Reports have options for adding headers and footers, totals and subtotals, logical arguments and alternate delimiters (in case any of your values include commas).
- XML – Of the three formats, XML is probably the most complex. Although it’s not specified as often as fixed-width or delimited files, it is gaining popularity with some clearinghouses, publishers and financial institutions. Read on for more details about the XML format.
Anatomy of an XML Report
As with fixed-width reports, if a recipient is asking for an XML file, they will provide detailed specs for how to assemble the file. Each data point in an XML report will be presented within in a hierarchy of custom tags (like you’d see in an HTML document). The tags provide not only the value for the data point, but also a description of what the data point is. Below is an example of the beginning of an XML report, prepared for submission to the PubMed database:
One of the big advantages to XML files, as you can see above, is that they’re readable not only for computers but for humans as well. The custom tags use plain English, so it’s easy to tell what you’re looking at. Also, the code for a single record can wrap across multiple lines, so the output isn’t nearly as unwieldy as delimited or fixed-width files.
Right On Time
In addition to simplifying the generation of third-party reports, Extract Reports can be coupled with a few other Argos features to simplify and automate their submission, as well. To submit a report directly to an FTP server from within Argos, you simply need to supply the FTP credentials within the MAPS configuration tool, and then give Argos permission to access that FTP host. Once the FTP server is set up, you can use the scheduling feature to not only run your Extract Report at regular intervals, but also upload the finished report to the specified FTP server—no more missed deadlines.
We know that, with such a wide variety of options, Extract Reports can sometimes seem a little intimidating. Hopefully the tips above will encourage you to experiment with Extract Reports and find ways in which they can make your reporting life easier.