Tag Archives: as/400

3 Everyday System i Tasks Made Easy

Posted on September 30, 2013at 8:52 am

If you work in an IBM System i, AS/400 or iSeries environment, there are many applications on the market than claim to make things easier and faster.

But are any of them as powerful as CoolSpools (http://www.coolspools.com/)?

When it comes to converting spool to Excel, PDF, XML or many other popular file formats, few – if any – System i solutions on the market match the simplicity and versatility of CoolSpools software

Here are just three of the tasks involving System i Excel files, System i PDFs and XML that can be done quicker and easier using CoolSpools…

Task: Producing Excel Sales Reports 

Involves: Importing data into Excel. Applying any formatting. Splitting into multiple documents for sales territory or product type. Emailing different files to different recipients.

How CoolSpools software can help: CoolSpools takes the data straight from your System i spool files and converts it to Excel. But it does so much more than that! Your Excel files can be formatted for you, with color-coding and even conditional formatting. CoolSpools can even split your System i Excel files into multiple different files based on criteria you specify – then send your System i Excel files to multiple recipients.

Task: Producing PDF Quotes & distribute to recipients. 

Involves: Merging the relevant spool file data with company information such as logos and watermarks. Attaching business terms and conditions. Sending the PDFs by email.

How CoolSpools software can help: Again, the data is coming straight from your spool files, which the CoolSpools spool file converter outputs as a System i PDF – no manual entry needed. You don’t need to spend valuable time inserting and positioning images – if it’s a JPEG or GIF, the CoolSpools software can insert it into the PDF for you, plus it can merge or attach additional PDF’s. And once you tell CoolSpools software where to send the System i PDF files, consider them sent!

Task: Importing data into web applications.

Involves: Extracting the relevant data. Checking the veracity of the data. Creating XML for import.

How CoolSpools software can help: By taking care of everything! CoolSpools software can convert your spool file data to XML, ready to be imported into your web applications. You can be assured the data is correct, as it’s coming direct from your System i spools.

This is just a taste of how CoolSpools spool file converter can make your working life easier.

Whether you need Excel, PDF, XML, HTML, TIFF or CSV, CoolSpools can convert spool files to all these formats – and format the output however you desire.

So forget those mundane tasks – leave it all to CoolSpools. Find out more about this powerful System i spool file converter.

System i Information Management Made Easy

Posted on July 11, 2013at 12:46 pm

Are you getting the most from your System i environment? Is your data managed, extracted and communicated in the most efficient manner? Or do you feel like your System i databases and spool files could be working harder for you?

If so, the CoolSpools (http://www.coolspools.com/) software suite could be just what you need, as we provide system i information management.

Developed by IBM as400 experts Ariadne, CoolSpools is the complete System i information management solution. With CoolSpools you can manage emails, administer spool files, and convert database and spool extracts to System i PDF, Excel, XML, HTML and many other formats.

Here’s an overview of the four powerful packages on offer from CoolSpools – and how they could help you make the most of your System i environment…

Database extracts to suit you

Extracting information from your System i database into Excel, HTML or XML is so much easier thanks to CoolSpools Database. All as400 database files are supported, and if used in conjunction with CoolSpools Spool Converter it can even extract data from your database into PDFs.

Spool file administration

Get full control over your System i spool files with this powerful administration software. With automated conversion, distribution and management tools, the ability to work with online AS/400 spool files, plus the option to run the same command against multiple iSeries spools, you’ll have unprecedented, unparalleled control over your System i spool files.

Convert spool to Excel, PDF and more… 

Perhaps the most impressive of CoolSpools’ tools is its spool file converter. Convert spool to Excel, PDF or XML. Split your as400 Excel files or PDFs into multiple documents – or append them to existing documents. Insert conditional formatting into System i Excel files, or images into your iSeries PDFs. There’s so much it can do – and it’s so easy to use.

Flexible email management tools 

Once you’ve converted your System i spool file to your required format, such as iSeries PDF or Excel, you’ll want to ensure the right people receive the right files, and at the right time. Here’s where CoolSpools’ email management software comes in. The software is highly customisable, allowing for up to 32 attachments, and emails can be sent via the command line or from programs via API.

Each of the four pieces of CoolSpools software can be purchased individually, but buy them together and not only will you have a complete as400 informational management suite at your fingertips, you’ll also make huge savings.

So what are you waiting for? Take control of your System i environment with CoolSpools software and you won’t believe you ever managed without it.