Posted on April 30, 2014at 12:53 pm
A great way of creating Excel documents with data from an IBM AS/400, iSeries or System i environment is by using a spool file converter. But if this is something you’ve never done before, where do you start when converting spool files to Excel?
The answer: CoolSpools, from IBM experts Ariadne Software. Their range of AS/400 solutions includes a powerful spool file converter that can output to a wide range of popular file formats, including Excel.
There are lots of great reasons to convert spool files to Excel. Perhaps the most important is this: because the information is coming directly from your AS/400 you can rest assured that it’s accurate and up to date. There’s no chance of human error and the
Not with CoolSpools spool file converter. Extracting the data from your spool file and converting it into Excel is a simple procedure – and you have a great deal of control over it. It’s so easy to learn, and should you have any issues, you can find a wealth of helpful information at http://www.CoolSpools.co.uk/support.
Again, not with CoolSpools! You can convert spool files to Excel quickly and automatically, giving you the information you need, in the format you require, whenever you need it. What could be simpler?
By now, you can probably guess that the answer is “not with CoolSpools”! The powerful CoolSpools spool file converter doesn’t just convert spool to Excel – it can also carry out a whole host of management and formatting procedures.
You can split one file into many. Append your new Excel sheet to an existing workbook. Format the output, including conditional formatting such as color coding. And ensure the right people get the right info by controlling email distribution of your Excel spreadsheets. All this can be managed using CoolSpools software.
CoolSpools doesn’t just convert spool files to Excel. You can also convert spool files to PDF, XML, TIFF, text files, CSV, HTML and RTF. It could well be the most powerful and flexible AS/400 spool file converter on the market today.
Find out more about how to convert spool to Excel with CoolSpools software at www.staging.giextensions.com/coolspools.
Posted on October 20, 2013at 11:49 am
Don’t you wish someone would invent an easier way to automatically convert System i spool & database files into Excel documents, with the cells already formatted correctly, with the data appended to last month’s data and with the reports automatically emailed to your management team? Then here’s some great news – if you work in a System i environment, someone already has…
CoolSpools (www.staging.giextensions.com/coolspools) software has been developed by experts in all things System i. One of its many useful features is System i to Excel file conversion. Here’s how it can help you…
Put simply: CoolSpools is a conversion tool that takes the data from your spool and database files and converts it into a variety of file formats. One of the functions CoolSpools can perform is System i Spool file to Excel conversion – taking the data from your spool files and converting spool to Excel.
Not at all. CoolSpools doesn’t just convert spool files and database files to Excel – it can also format the outputted Excel documents too. Colors, fonts, borders – you name it, CoolSpools software does it. It can even carry out conditional formatting.
Indeed it is. But not with CoolSpools. Tell CoolSpools where to split the document (perhaps at invoice number or customer name) and it’ll do it for you. No need to manually manipulate your Excel documents at all! It can even manage emailing your Excel documents to several recipients. Everyone gets everything they need – and nothing they don’t.
No problem – CoolSpools has this covered too.
Yes. And as far as we’re aware, no other System i spool file converter offers this incredibly useful functionality.
Indeed. CoolSpools can also convert spool files to PDF, XML and a whole host of other file formats. However you need to present your data, and whatever format you need, CoolSpools is sure to have a solution for you.
Easy. Head to www.staging.giextensions.com/coolspools now to find out more about its System i Spool and Database file conversion and its many other flexible capabilities.
Posted on April 09, 2013at 10:39 am
Spooling is a function of your computer system that saves data for later processing or printing. The system saves this data in a spooled file.
CoolSpools (www.ariadnesoftware.co.uk) is the complete information management solution for IBM System i. With CoolSpools you can manage spooled files. Our software converts the spooled file to Excel, PDF and XML. This ultimately saves your time and money by moving your business away from paper-based documents and by distributing information via electronic formats.
CoolSpools is easy to use but immensely powerful. It helps you give your users and customers the right information, at the right time, and, just as importantly, in the right format. Our solutions address issues such as:
• sending documents to customers by email without having to change print programs
• publishing company reports on a corporate server so they can be archived and accessed easily from a PC
• producing Excel files from the System i without having to rely on users or operators to run file transfers
E-reading and the environment
Technologically, the world is moving to a place where documents are created on computers, distributed via computers and digested on computers. This trend can be seen in the lean towards tablets and e-books over paperbacks, and is quickly becoming the way we read and share our data. While there are still many of us who would rather read a printed document than looking at the same document on a computer monitor, the main benefits of CoolSpools are the money saved, the easy access you have to your spooled files and the positive impact on the environment by refraining from printing unnecessarily.
There is a direct correlation between the amount of trees that have to be cut down and the amount of money it costs you, and the initial cost for CoolSpools, is usually far surpassed by the savings in reduced paper for most businesses. Kenneth Mohn of Large US Dairy informed us that the use of CoolSpools had resulted in the company spending 20% less on paper.
Here at CoolSpools, we care about the environment, saving money and increasing efficiency. If you want to understand how our solutions can help your business, please contact us at www.ariadnesoftware.co.uk/Contact.htm, email email@example.com or call us on +44 (0)1625 547 962.