SpooliT Help

About Asymex Pty Ltd

Archiving

SpooliT's innovative document management solution takes the hard work out of document storage and retrieval.

Think of a SpooliT Archive as your filing system. A typical filing system contains drawers and folders and files. A SpooliT archive is no different. SpooliT requires at least one filing system or Archive in order to perform nearly all functions.

A SpooliT archive typically contains the following:

  • Selection rules
  • Automation rules
  • Archived reports
  • Categories used to store archived documents
  • Recipients (eMail users and fax numbers)
  • Spool file distribution logs (Automated eMail and Export distribution logs)
  • Excel template definitions
  • Report Splitting template definitions
  • Overlay marking template definitions

A SpooliT archive can be stored on any of the following media.

  • Local PC
  • Shared drive anywhere on your LAN
  • The IFS
  • Optical disk
  • Any disk storage system
  • Copied to CD
  • Copied to DVD

A SpooliT Archive may contain System i, iSeries or AS400 spool files or reports that have been transferred from the System i, iSeries or AS400 computer and stored a shared drive on any storage device. An Archive is analogous to a filing cabinet, whose cabinet drawers are known as Category Groups, whose folders with each drawer are known as Categories, and finally whose folder's contents are spool files.

You may choose to have more than one archive defined within SpooliT, which may be stored in different physical locations.

Reports that have been archived are automaticallly indexed using report content for easy search and retreival.

Archived Reports can be resent back to your System i, iSeries or AS400 systems. The reports are regenerated with all their original data, formatting and report attributes just as they once existed on your system originally.

"SpooliT: The complete AS400 iSeries Spool File and Document Management solution."

Bundling

In a simple-step operation, SpooliT enables you to electronically send a number of different spool files to any number of e-mail addresses. For example, at the touch of a button you could send all of your daily sales reports to all of your sales reps around the country in real time.

  • No manual printing
  • No manual collating
  • No manual sorting
  • No manual distribution
  • Straight through processing and workflow enabling
  • Full Automation (Real-time or scheduled)
  • View our 'SpooliT ROI Calculator' and see how quickly SpooliT pays for itself.Click Here to view.

"SpooliT: The complete AS400 iSeries Spool File and Document Management solution."

Bursting

In a simple-step operation, SpooliT enables you to electronically send a spool file to any number of e-mail addresses.

  • No manual printing
  • No manual collating
  • No manual sorting
  • No manual distribution
  • Straight through processing and workflow enabling
  • Full Automation (Real-time or scheduled)
  • View our 'SpooliT ROI Calculator' and see how quickly SpooliT pays for itself.Click Here to view.

"SpooliT: The complete AS400 iSeries Spool File and Document Management solution."

Usability

SpooliT has been designed with usability and ease of use as our highest focus points.

Our customers have benchmarked our solutions against other vendor products - They voted ours to have the best conversion capabilities and definitely the easiest to use and configure.

We guarantee you will not find another solution that is:

  • Easier to Install and configure
  • Easier to create selection rules
  • Easier to automate processes
  • Easier to generate Excel spreadsheets
  • Easier to Split reports

Our guiding principle:

  • "There is no point in delivering a fully featured product such as SpooliT if you need a PhD just to use it!"
  • SpooliT includes the following:
  • Intuitive look and feel
  • Easy installation directly from our web site
  • No programming requirement
  • Workflow enabling
  • SpooliT Helper Wizard to guide you through the most advanced configuration features with ease, ensuring you maximise the SpooliT benefits
  • Extensive 24 hour online support and FAQ
  • SpooliT enables your "paperless" office
  • View our 'SpooliT ROI Calculator' and see how quickly SpooliT pays for itself.Click Here to view.

"SpooliT: The complete AS400 iSeries Spool File and Document Management solution."

Save Money

How we save your $$$'s

  • Saves time and resource effort in report distribution to end-users.
  • Reduces consumables expenditure (i.e. paper, ink cartridges etc) by distributing reports electronically.
  • Reduces peripherals expenditure (i.e. fewer printers are required).
  • Reduces mailing and courier costs by distributing reports electronically.
  • Reduces technical resource requirement in report distribution to pc applications (i.e. End users can download reports themselves into pc applications rather than the traditional reliance on IT departments).
  • Reduces time and resource effort required to manually archive and retrieve historical reports by providing an automated electronic archival system.
  • Reduces hardcopy document storage costs by using electronic storage.
  • Reduces requirement for pre-printed stationery such as invoice statements by allowing electronic distribution of invoices.
  • Reduces resource requirement to manually insert invoices and statements into envelopes by allowing automatic electronic distribution.
  • Increases productivity. No need to manually distrubute reports or leave your desk to get a report from a printer
  • Increases productivity by automatically delivering report data in an Excel format.
  • Increases productivity by automatically splitting large reports into sections and electronically delivering the report sections.
  • Increases productivity by enabling users to convert System i reports into an format they want including (Excel, PDF, Word, CSV, HTML, RTF, TXT)
  • View our 'SpooliT ROI Calculator' and see how quickly SpooliT pays for itself.Click Here to view.

"SpooliT: The complete AS400 iSeries Spool File and Document Management solution."

Exporting

  • SpooliT enables you to download spool files on demand to PC applications, such as Adobe, Word or Excel.
  • SpooliT supports Excel, CSV, Word, TXT, RTF, HTML and PDF export formats.
  • SpooliT uses an intelligent optimal formatting technique that preserves the "look and feel" of the report - you can even have the traditional "blue line spool file paper" backdrop to your downloaded file, if you so desire!
  • SpooliT's user-friendly formatting options will meet (and exceed!) the requirements of your most demanding user.
  • View our 'SpooliT ROI Calculator' and see how quickly SpooliT pays for itself.Click Here to view.

"SpooliT: The complete AS400 iSeries Spool File and Document Management solution."

Emailing

SpooliT enables spool files to be sent as e-Mails that may be received by any e-mail client, including: Microsoft Internet Mail, Outlook, Exchange, Netscape, Eudora, Lotus Notes, Domino and more.

Distribution rules can be defined using the SpooliT rules wizard. Distribution rules can send reports in a variety of file formats to one or many recipients. Distribution rules can be scheduled for particular times or can be real-time distribution - immediately as reports spool to an OUTQ.

  • SpooliT enables spool file data to be eMailed electronically without the need to print the report by default
  • Save money on printing cost.
  • Distribute spool files electornically via email.
  • eMail reports from your AS400, iSeries or i5 as soon as spoofiles are created.

There are 7 ways to setup eMail/fax distribution rules in SpooliT.

  • Selecting Users from the SpooliT eMail/Fax distribution list.
  • User Alias (linking an iSeries User to an eMail address).
  • Obtaining eMails/Fax from inside the Report (report content).
  • Using an iSeries Lookup Table to obtain the eMail/Fax.
  • Using a PC Lookup Table to obtain the eMail/Fax.
  • Joining the user who created the report with a Domain name.
  • Joining text from inside the report (report content) with a domain name.

"SpooliT: The complete AS400 iSeries Spool File and Document Management solution."

Printing

  • SpooliT enables AS400 or iSeries spool files to be printed on your pc or network printer.
  • In addition, SpooliT enables you to send archived spool files from your PC or network archive back to your AS400 or iSeries outq for printing.
  • SpooliT increases your spool file printing options by a significant order of magnitude.

  • View our 'SpooliT ROI Calculator' and see how quickly SpooliT pays for itself.Click Here to view.

"SpooliT: The complete AS400 iSeries Spool File and Document Management solution."

Convert to WORD

SpooliT's innovative document management solution makes conversion from spool files into WORD as easy as point and click.

WORD features include:

  • Convert spool files into WORD for instant viewing.
  • Export spool files into WORD format and save to a PC, Network, Intrenet, Intranet, CD or DVD in seconds
  • eMail spool files in WORD format
  • Automate distribution of spool files in a WORD format to any email recipient.
  • Also Export spool files into PDF format
  • Also Export spool files into EXCEL format
  • Also Export spool files into HTML format
  • Also Export spool files into CSV format
  • Also Export spool files into RTF format

    "SpooliT: The complete AS400 iSeries Spool File and Document Management solution."

Convert to PDF

SpooliT's innovative document management solution makes conversion from spool files into PDF as easy as point and click.

PDF features include:

  • Convert System i, iSeries and AS400 spool files into PDF for instant viewing.
  • Export spool files into PDF and save to a PC, Network, Intrenet, Intranet, CD or DVD in seconds
  • eMail spool files in PDF format
  • Automate distribution of spool files in a PDF format to any email recipient.
  • Convert text only reports with or without the green-bar format.

Correctly converts all reports that include Barcodes, MICR fonts, Boxes, Rotational fonts, Native iSeries Overlays and more.

SpooliT converts all spool file report types including:

  • *SCS (Text only)
  • *AFPDS
  • *IPDS
  • *AFPDSLINE
  • *USERASCII
  • *LINE
  • Also Export spool files into WORD format
  • Also Export spool files into EXCEL format
  • Also Export spool files into HTML format
  • Also Export spool files into CSV format
  • Also Export spool files into RTF format

"SpooliT: The complete AS400 iSeries Spool File and Document Management solution."

Convert to EXCEL

SpooliT's innovative document management solution makes conversion from spool files into EXCEL as easy as point and click.

Convert spool files into Excel in 3 easy steps.

Microsoft Excel tends to be the tool of choice for analysis of data for most PC users.iSeries users receive data in reports and spend countless hours re-keying data from reports into excel to perform analysis.

I.T. can spend time and resource building tools to extract data from tables or reports so that users can attempt to manually import data into excel. However this is not necessary. SpooliT provides you with the flexibility to select the data you want from a report and output this data into excel easily.

No programming changes are required. This is performed by creating SpooliT Excel Templates. An Excel Template is a set of rules or instructions SpooliT will use to export data from a report into Microsoft Excel.

SpooliT allows you to be selective about which sections of a report and which columns of data in the spool file you want exported to excel, and also allows you to remove unwanted rows (such as page breaks, column headings etc) automatically if required. You do not need to include all columns of data from the original report. You do not need to include the columns of data in the order that they appear in the report. SpooliT will allow you to choose only the columns you want from a report and output the required column data into any excel column.

You can include conditioning rules or simple boolean logic to extract the data you require. (For example values > $1000).

Data can be selected from different areas of the report (i.e. SpooliT calls these "Report Sections"). If a report includes many sections of data (i.e. Company, Division,State,Branch,details lines etc...) then you may choose data from any or all of these areas ("Sections").

To select columns of data from a report, SpooliT provides you with a "Canvas" of the report to work with. This report "Canvas" allows you to scan over areas of the report to define 'Sections'. Within a 'section' you can include data columns from the report by defining the columns of data required in any given "Section". Use the 'Section Wizard' to locate analyze your data and automatically create default column fields. Or, manually define columns by simply scanning over the data element you require from the report "Canvas" and this defines a rule to select a column of data. You can instruct SpooliT if the column is Text only, Date only, numeric only etc. As you identify the columns of data required in an area of the report "Section", you are creating a dynamic excel template definition that can be used as a "mask" over a report.

The excel template can be used to export into a standard Excel format or a CSV file if required.

The SpooliT Excel Template feature is a powerful form of data mining direct from your spool file data.

Users can define rules to select and/or omit data in any format they require. Furthermore, these template rules can then be linked to categorization rules and automated distribution rules where users can receive Excel spreadsheets generated from the excel template. The resultant excel spreadsheet may be exported to a folder on a PC or a network drive or even sent to an FTP server. Excel template definitions may be used and shared by many users. Excel template definitions may be saved, exported and imported by different SpooliT users that require access to a template created by another user.

Excel features include:

  • Export System i, AS400 and iSeries spool files into Excel and save to any Local or Network folders, Internet, Intranet, CD or DVD
  • eMail spool files in Excel format to any recipient
  • Use a GUI report canvas to quickly select report sections to extract into excel.
  • Automate distribution of spool files in a Excel format to any email recipient.
  • Define Excel templates to select specific data from complex reports and convert and format into Excel.
  • Mine the data you really need from a report and omit the data you dont need. Export the mined data into an Excel spreadsheet.
  • Use SpooliT Excel Wizard to make Excel creation ease
  • Define simple selection rules to include report sections
  • Change fonts, colors, background colors.
  • Apply Cell formatting and editing
  • Change the order of column cells.
  • Append report sections to form a single excel row or kepp section independent
  • Apply calculations to numeric data (i.e. Sum, Count, Avg, Min, Max)
  • Correctly convert negative numbers with minus signs and CR/DR
  • Share Excel templates with other users. Import and export excel template definitions.
  • We guarantee our report to excel conversion is the easiest to use solution available
  • Report headings can be excluded or included
  • Column headings may be included or excluded per cell column
  • Totals lines may be excluded or included
  • Certain columns may excluded or included
  • Extended column data formatting support
  • Blanks lines may be excluded if required
  • Numeric values and dates can be formatted
  • Specify excel Cell to output into (override output cell or use SpooliT auto cell output)

    "SpooliT: The complete AS400 iSeries Spool File and Document Management solution."

Convert to HTML

SpooliT's innovative document management solution makes conversion from spool files into HTML as easy as point and click.

HTML features include:

  • Convert spool files into HTML for instant viewing.
  • Export spool files into HTML and save to a PC, Network, Intrenet, Intranet, CD or DVD in seconds
  • eMail spool files in HTML format
  • Automate distribution of spool files in a HTML format to any email recipient.
  • Also Export spool files into EXCEL format
  • Also Export spool files into CSV format
  • Also Export spool files into RTF format
  • Also Export spool files into WORD format
  • Also Export spool files into HTML format

    "SpooliT: The complete AS400 iSeries Spool File and Document Management solution."

Convert to CSV

SpooliT's innovative document management solution makes conversion from spool files into CSVas easy as point and click.

CSV features include:

  • Convert spool files into CSV for instant viewing.
  • Export spool files into CSV and save to a PC, Network, Intrenet, Intranet, CD or DVD in seconds
  • eMail spool files in Excel format
  • Automate distribution of spool files in a CSV format to any email recipient.
  • Define Excel templates to select specific data from complex reports and convert and format into CSV format.
  • Mine the data you really need from a report and omit the data you dont need. Export the mined data into an Excel spreadsheet.
  • Also Export spool files into PDF format
  • Also Export spool files into WORDformat
  • Also Export spool files into HTML format
  • Also Export spool files into EXCEL format

    "SpooliT: The complete AS400 iSeries Spool File and Document Management solution."

Convert Spool Files

SpooliT is a System i and PC client server application which manages System i, iSeries and AS400 spool files.
SpooliT is a rules based solution which monitors your output queues and automates report archiving, indexing and distribution.
Reports can be eMailed, faxed, Split, Exported to users in the format they want to see (i.e. PDF, Excel, Word, Text, HTML, RTF and CSV).
SpooliT delivers a total Spool file solution for the IBM System i.
Use wizards to easily define rules and excel templates without any programming changes. Versatility guaranteed!

Features

  • SpooliT enables access to spool file data electronically without the need to print the report by default
  • Save money on printing cost.
  • Distribute spool files electornically via email on internet or intranet.
  • Get your important reporting data into the format you want (Excel, PDF, HTML, CSV, Word, TXT, HTML).
  • eMail Reports in any format to recipients
  • Export converted reports in any format to folders on any PC or network folders.
  • Upload converted documents in any format to an FTP server.
  • Correctly converts all reports that include Barcodes, MICR fonts, Boxes, Rotational fonts, Native iSeries Overlays and more.

    SpooliT converts all spool file report types including:

  • *SCS (Text only)
  • *AFPDS
  • *IPDS
  • *AFPDSLINE
  • *USERASCII
  • *LINE
  • View our 'SpooliT ROI Calculator' and see how quickly SpooliT pays for itself.Click Here to view.

    "SpooliT: The complete AS400 iSeries Spool File and Document Management solution."

Convert Spool Files

SpooliT is a System i and PC client server application which manages System i, iSeries and AS400 spool files.
SpooliT is a rules based solution which monitors your output queues and automates report archiving, indexing and distribution.
Reports can be eMailed, faxed, Split, Exported to users in the format they want to see (i.e. PDF, Excel, Word, Text, HTML, RTF and CSV).
SpooliT delivers a total Spool file solution for the IBM System i.
Use wizards to easily define rules and excel templates without any programming changes. Versatility guaranteed!

Features

  • SpooliT enables access to spool file data electronically without the need to print the report by default
  • Save money on printing cost.
  • Distribute spool files electornically via email on internet or intranet.
  • Get your important reporting data into the format you want (Excel, PDF, HTML, CSV, Word, TXT, HTML).
  • eMail Reports in any format to recipients
  • Export converted reports in any format to folders on any PC or network folders.
  • Upload converted documents in any format to an FTP server.
  • Correctly converts all reports that include Barcodes, MICR fonts, Boxes, Rotational fonts, Native iSeries Overlays and more.

    SpooliT converts all spool file report types including:

  • *SCS (Text only)
  • *AFPDS
  • *IPDS
  • *AFPDSLINE
  • *USERASCII
  • *LINE
  • View our 'SpooliT ROI Calculator' and see how quickly SpooliT pays for itself.Click Here to view.

    "SpooliT: The complete AS400 iSeries Spool File and Document Management solution."

Rules Based

SpooliT is a rules based system. You can create rules instructing SpooliT which OUTQ's you want to monitor or which specific spool files you require to be processed. You achieve this by creating 'selection rules'. Selection rules enable you to define which spool files or OUTQ's you require to be monitored and processed.

Rules can be generic

  • monitoring an entire OUTQ)
  • Or an individual report such as a Specific Sales Report on a specific OUTQ.

Rules definitions are generally based on spool file attributes. Each spool file report has spool file attributes. Spool file attributes include (System, Library, OUTQ, File name, User name, User data, Job name, Forms type etc). The more spool file attributes you include, the more specific the selection rule. The less spool file attributes you include, the broader the selection Rules.

Selection rule definitions are not restricted to only spool file attributes. Rules can also include 'capture fields' from within a spool file itself, such as a report name and report title. 'Capture fields' can be useful if your application software generates many spools which are all called (for example QSYSPRT) and you require to identify a particular report by looking inside the report itself to identify the 'report name' and 'report title'.

Once you create selection rules, these rules may be automated. Automating rules enables 'straight through processing'. Automating rules require no programming changes. Rules provide the selection criteria, whilst automating rules provides the schedule or interval under which reports should be processed.

You can automate tasks such as archiving, eMailing, exporting, printing or general spool file management. You can define any number of automated rules or scheduledjobs over any number of partitions or iSeries/System i/AS400 servers.

"SpooliT: The complete AS400 iSeries Spool File and Document Management solution."