Category Archives: spooling

03 
Nov

Communication in the modern world – converting iSeries files to xml

World imageCommunication has always been key to development, strategy, progress and indeed survival, but in the modern world individuals and organisations alike often suffer from communication overload. That is why it is increasingly important that information is filtered and delivered to the recipient in a meaningful and relevant way. Converting important data from your iSeries system to be shared across intranets, the world wide web and elsewhere requires a flexible file format. CoolSpools (www.coolspools.com) has been developed to facilitate the conversion of iSeries spool files and database files to XML and a variety of formats including Excel, CSV, HTML, TXT, RTF and fully searchable PDFs.

Why xml?

xmlXML stands for eXtensible Markup Language. XML is a flexible, open and powerful way to help you exchange information among diverse platforms and applications, geographic boundaries and businesses. XML is widely touted as a key component in the solution to the problem of information exchange between applications and within BtoB environments. XML is simple, extensible and, best of all, nonproprietary.

In order for your applications to work with XML content, you need an XML parser. An XML parser is a set of APIs that assist in the creation, navigation (retrieval) or modification of XML document content. CoolSpools removes the need of a parser to create XML from your data from spool files and database files.

CoolSpools Spool Converter and Database

spool converterThe CoolSpools Spool Converter and Database products have been installed across the globe, providing our customers with a simple and reliable system to convert data from their iSeries spool files and database files. CoolSpools runs only on IBM iSeries servers, without the need of a PC.
To see what they think of our CoolSpools software solutions take a look at our testimonial section on our website, where you will find a selection of genuine comments from a range of our customers www.coolspools.com/Testimonials.htm. You can download CoolSpools for a no-obligation 30-day free trial from www.coolspools.com/cooldown.phpmake life easier

For further information on how you could implement the CoolSpools software to convert your iSeries files to into xml format then email sales@ariadnesoftware.co.uk or phone and speak to one of our experts directly on + 44 (0)1625 547962.

Readmore..

Published Date: 3rd November 2015
Category: General, spooling
Tags: ,


 

16 
Feb

Do you wish you could convert your spooled files to PDF files?

Well the good news is that you can! CoolSpools (www.coolspools.com) was developed primarily to convert all system i series and AS400 series spooled files into a variety of more manageable and useable file formats, including PDF.

Wave goodbye to the mountain of paper…

There are still many organisations worldwide where vast amounts of reports are produced and printed out on printers and then manually analysed and distributed to the appropriate staff. However with the CoolSpools Spool Converter solution you can automatically generate reports to PDF files and distribute them electronically or publish them in the cloud.

Bespoke PDF files that save time and money

You might currently extract separate sections of the data created on your system to send to different departments or individuals. This can be handled within CoolSpools as we have devised a system which allows you to select which lines or pages to include or exclude and which people you wish to receive each section of information. The CoolSpools Spool Converter will do it all for you on a weekly or monthly or annual basis depending on your business requirements. All you have to do it set it up and instruct it what to send and to whom and it will run all by itself (making you look even more efficient!).

Spool Conversion, Security and more besides…

However, the CoolSpools Spool Converter does more than just spool conversion. It provides easy to use flexible functionality to enhance the converted output. Apart from producing bespoke reports, the Spool Converter also enables the originator to password protect and encrypt the outputted PDF files, as well as adding restrictions to the PDF and including digital signatures to authenticate the report and show it has not been tampered with.

Nothing to lose and everything to gain…

So in summary the CoolSpools Spool Converter will definitely save your business time and costs whilst reducing its impact on the environment by saving paper. It will facilitate efficiency and transparency across your organisation and help your business to meet targets and analyse your operation in a more efficient manner. So what have you got to lose? Give us a call today and find out how CoolSpools can facilitate your information dissemination on + 44 (0)1625 547962 or email sales@ariadne.co.uk.

Readmore..

Published Date: 16th February 2015
Category: AS400, spooling, system i
Tags: , ,


 

23 
May

5 benefits of converting a Spool file to PDF

Spool files can be converted into a variety of different formats meaning you can choose the right format for your purpose. Files can be converted to Excel, XML and most importantly PDF’S. There are a number of reasons why converting a spool file to PDF will benefit you and your company – here are a few:

It’s safe and secure

When a PDF file is converted you have the ability to password protect and encrypt it so that any information you wish to stay secure can only be opened by an authorised person. You can also create a digital signature in order for you to guarantee the file has not been tampered with in any way. The final security feature is that you can put restrictions on what can be changed so that no important information gets rewritten or erased.

Freedom in what you can convert

Some may think that when converting a spool file to PDF that you don’t have a choice in what pages are converted, that would be wrong. The Spool converter allows you to select lines or pages by ‘dropping’ certain parts of the document. It also allows you to send different parts of the document to different people so that everybody does not see all information that they have no need to to see.

Not just your ordinary text document

Instead of being an ordinary document with no visual content the spool converter allows you to carry over graphics and images so you have the opportunity to include company logo’s or watermarks in to maintain symmetry throughout your work, therefore additional software is no longer needed to make your document more visually appealing.

Can keep all your work together

Keeping your work together is important for the organisation of your company and that’s why Coolspools has got it covered for you. In order to make it easier for you to keep everything safe and collective you can create a report or document pack which contains a set of related documents from different spool files.

Easy to navigate

Your work needs to be easy to navigate around as many people may not want to search a whole document to find a snippet of information. Coolspools Spool converter has the ability to create a set of bookmarks from the content of your document to use for an index or set of outlines to make it easier and more efficient for people to view larger documents.

If you want to learn more about converting a Spool file to PDF, and how our software can help you, then look at the Coolspools website at www.coolspools.com/CoolSpoolsSpoolConvertermore.htm.

Readmore..

Published Date: 23rd May 2014
Category: General, spooling


 

30 
Apr

How to Convert Spool to Excel with CoolSpools

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.

But why convert spool files to 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

Is it difficult to convert spool to Excel?

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.

Is converting spool files to Excel a time-consuming task?

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?

After I convert spool files to Excel, will formatting the exported files be a laborious task?

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.

Such as?

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.

What other file formats can I convert to?

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.coolspools.com.

Readmore..

Published Date: 30th April 2014
Category: spooling


 

10 
Dec

A Beginner’s Guide to AS/400 XML – And How CoolSpools Can Convert it For You…

If you work in an IBM AS/400, System i or iSeries environment, did you know it’s possible to convert data from your spool files into a variety of file formats? The easy way to do this is by using a spool file converter, such as CoolSpools (www.coolspools.com). This clever piece of software takes data direct from your System i spool files and converts into to file formats such as XML.

But why would you want to produce XML? The experts behind CoolSpools, Ariadne Software, explain:

First up – what is XML?

An abbreviation of “Extensible Markup Language”, XML is a format that presents information in a way that can be understood both by human readers and by machines.

What can I use XML for?

There are many uses for XML documents. They can be used to exchange data over the internet, to populate content management systems, for web development, database development… the uses are almost endless.

How do I produce XML documents?

If you’re running an IBM AS/400 server, the easiest way to populate XML documents with the data you need is by using a spool file converter and database tool such as CoolSpools software.

Sounds difficult!

Not with CoolSpools software. It’s designed to do all the hard work – the data extraction, the spool file conversion, the formatting… what you’ll get is AS/400 data that is ready to be imported into your CMS, web application or whatever else you need.

Why is using CoolSpools spool file converter better than manually creating interface files?

Many reasons! The data is coming direct and automatically from your AS/400 – so there’s no need to worry about human error leading to incorrect data. And converting AS/400 data automatically to XML is much, much faster than manually processing it, so you’ll save time too.

So what else can CoolSpools software do?

Too many things to mention here! As well as converting AS/400 data to XML, you can also convert spool files to PDF (and even insert images), convert spool files to Excel (and apply conditional formatting), convert spool files to HTML (ideal for web developers) plus a whole host of other popular file formats. CoolSpools can even email your outputted files to the recipients you specify – everything’s taken care of for you.

Find out more about how CoolSpools software can help you produce accurate, fast XML at www.coolspools.com.

Readmore..

Published Date: 10th December 2013
Category: AS400, IBM, spooling


 

20 
Oct

Take the Pain Out Of System i Spool to Excel File Creation

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.coolspools.com) 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…

What do you mean by “System i to Excel file conversion”?

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.

But I’ll still have to spend hours formatting my data to make it readable.

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.

That’s great. But I need to split out my master spool file into multiple different documents – and email them to multiple recipients. That’s such a chore.

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.

Amazing. But sometimes I have the opposite issue – I need to append new data to existing spreadsheets as new worksheets.

No problem – CoolSpools has this covered too.

Even with Excel documents that weren’t created using CoolSpools software?

Yes. And as far as we’re aware, no other System i spool file converter offers this incredibly useful functionality.

Sounds great… but is there anything else CoolSpools does other than carry out System i files to Excel conversion?

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.

I’m sold! So, how do I order CoolSpools software?

Easy. Head to www.coolspools.com now to find out more about its System i Spool and Database file conversion and its many other flexible capabilities.

Readmore..

Published Date: 20th October 2013
Category: spooling


 

19 
Sep

How to Reclaim Wasted Hours with CoolSpools Spool File Converter

How much of your day is spent creating, formatting and distributing reports on the System i, AS/400 or iSeries? Here’s how you can get back your valuable time…

Introducing CoolSpools spool file converter (www.coolspools.com/CoolSpoolsSpoolConverter.htm). Developed by industry experts Ariadne Software, CoolSpools is perhaps the most powerful System i spool file converter on the market.

Here’s how CoolSpools software can speed up your report distribution:

1. Data is taken directly from your System i spool files

Spend a large amount of time transferring data? Then stop – there’s a much better way! CoolSpools software takes your spool files and converts the output to Excel, PDF, XML and many more popular file formats – automatically, no effort required.

2. Hassle-free formatting 

CoolSpools can automatically re format your data for you – including color-coding and conditional formatting. You can also define which fonts are to be used – and even insert JPEGs or GIFs into your PDFs. There’s no need to slave over your keyboard ensuring your documents are correctly formatted – CoolSpools does it for you.

3. Split, join, and send your Excel files and PDFs 

Need to update documents by adding new sheets to Excel workbooks or new pages to existing PDFs e.g. quotes or invoices? Let CoolSpools do it for you! Need to remove unwanted pages? Tell CoolSpools what to remove, and it’s gone. Need to split your PDFs or Excel books into multiple documents, and send each to multiple recipients? Don’t do it manually – automate it all with CoolSpools.

4. Bookmark your System i PDFs 

Inserting bookmarks and indexing your PDFs makes reading documents much easier – but it’s always a chore. Not so with CoolSpools – it can generate indexes and outlines for you. Bookmarking your PDFs has never been easier!

5. More than just System i Spool conversion to Excel and PDFs… 

In addition to its powerful PDF and Excel creation, there’s so much more CoolSpools software can do with your spool files. CSV, HTML, text files, RTF, TIFF – CoolSpools can convert your System i spool files into all these formats, and automatically email the output to your users in a fraction of the time it would take for you to print & post or email the data manually.

So if you need to convert spool to PDF, Excel, XML or other popular file formats, by using CoolSpools spool file converter you’ll save time, be more productive and ensure everyone’s getting the info they need in a format they’ll understand.

Learn more about CoolSpools spool file converter at www.coolspools.com/CoolSpoolsSpoolConverter.htm.

Readmore..

Published Date: 19th September 2013
Category: AS400, IBM, spooling, system i
Tags:


 

04 
Jul

System i Document Creation: Your Problems Solved with CoolSpools Software

When communicating information throughout your business, there are several factors to consider. Accuracy is, of course, a given. You want to ensure the right people are given the right information, without being distracted or confused by extraneous details. And you’ll need to ensure its well-presented and easy to digest.

Your spool files can provide all the accurate data you need – but manipulating the data into the right format can be a painstaking, time-consuming task. But help is at hand with spool file converter software – and if you’re using an IBM System i (e.g. AS/400 or iSeries) environment, CoolSpools software makes it all so easy.

Developed by well-established IT experts Ariadne (www.ariadnesoftware.co.uk), CoolSpools is a powerful, simple and reliable System i file conversion tool. CoolSpools software can convert AS/400 spool filea to Excel, PDF and XML.

Here are just a few of the many AS/400 document creation problems that become a thing of the past with CoolSpools

PROBLEM: You need to produce documents including several images, such as a company logo, diagrams, forms or perhaps even photography. Inserting and formatting the images within your documents is a time-consuming process you’d rather avoid.

HOW COOLSPOOLS CAN HELP: Inserting images into System i PDFs is a doddle with CoolSpools. Simply tell CoolSpools where to insert the JPEG or GIF format images as it converts your spool to PDF.

PROBLEM: You’re producing a report for multiple recipients, but each recipient must only receive the part of the report that’s relevant to them. For example you may require invoices for multiple clients, or sales reports for managers covering different areas.

HOW COOLSPOOLS CAN HELP: When converting spool to Excel or PDF, tell CoolSpools the points at which the files need to be split – such as region name or invoice number. CoolSpools will split System i Excel output into separate files for you, saved in separate folders. Or it’ll split your converted System i PDFs into several documents, and can even email them to multiple email addresses.

PROBLEM: Your spool files contain a large amount of data you intend to use to populate your website. You need an easy way to import the data without manually re-entering it.

HOW COOLSPOOLS CAN HELP: CoolSpools’ powerful spool file converter can automatically generate XML from your spool files for your web applications to access. This saves time on reprogramming the data, and as it’s coming from your spool files, the accuracy and integrity of your data is assured.

These are just a handful of the ways the CoolSpools software can help you produce clear, accurate and visually-attractive documents from your AS/400 data extracts. Find out more about what CoolSpools could do for you, and the reason it’s already a global success, at www.ariadnesoftware.co.uk.

Readmore..

Published Date: 4th July 2013
Category: General, IBM, spooling
Tags: , , ,


 

26 
Jun

System i Document Creation: Your Problems Solved with CoolSpools Software

When communicating information throughout your business, there are several factors to consider. Accuracy is, of course, a given. You want to ensure the right people are given the right information, without being distracted or confused by extraneous details. And you’ll need to ensure its well-presented and easy to digest.

Your spool files can provide all the accurate data you need – but manipulating the data into the right format can be a painstaking, time-consuming task. But help is at hand with spool file converter software – and if you’re using an IBM System i (e.g. AS/400 or iSeries) environment, CoolSpools software makes it all so easy.

Developed by well-established IT experts Ariadne , CoolSpools is a powerful, simple and reliable System i file conversion tool. CoolSpools software can convert AS/400 spool filea to Excel, PDF and XML.

Here are just a few of the many AS/400 document creation problems that become a thing of the past with CoolSpools

PROBLEM: You need to produce documents including several images, such as a company logo, diagrams, forms or perhaps even photography. Inserting and formatting the images within your documents is a time-consuming process you’d rather avoid.

HOW COOLSPOOLS CAN HELP: Inserting images into System i PDFs is a doddle with CoolSpools. Simply tell CoolSpools where to insert the JPEG or GIF format images as it converts your spool to PDF.

PROBLEM: You’re producing a report for multiple recipients, but each recipient must only receive the part of the report that’s relevant to them. For example you may require invoices for multiple clients, or sales reports for managers covering different areas.

HOW COOLSPOOLS CAN HELP: When converting spool to Excel or PDF, tell CoolSpools the points at which the files need to be split – such as region name or invoice number. CoolSpools will split System i Excel output into separate files for you, saved in separate folders. Or it’ll split your converted System i PDFs into several documents, and can even email them to multiple email addresses.

PROBLEM: Your spool files contain a large amount of data you intend to use to populate your website. You need an easy way to import the data without manually re-entering it.

HOW COOLSPOOLS CAN HELP: CoolSpools’ powerful spool file converter can automatically generate XML from your spool files for your web applications to access. This saves time on reprogramming the data, and as it’s coming from your spool files, the accuracy and integrity of your data is assured.

These are just a handful of the ways the CoolSpools software can help you produce clear, accurate and visually-attractive documents from your AS/400 data extracts. Find out more about what CoolSpools could do for you, and the reason it’s already a global success, at www.ariadnesoftware.co.uk.

Readmore..

Published Date: 26th June 2013
Category: AS400, IBM, spooling


 

26 
Jun

Converting System i Spool Files: 5 Great Reasons to Choose CoolSpools Software

If you use your IBM System i (or AS/400 or iSeries) spool files to populate documents or feed web applications, you’ll know there are a number of spool file converters on the market, each making bold claims about how it’s the most powerful, most fully-featured or easiest to use.

With this in mind, you may take our claim that CoolSpools really IS the most powerful, most fully-featured, easiest to use System i spool file converter with a pinch of salt.

But wait. Hear us out.

Created by well-established global IT solutions providers Ariadne Software, there’s a compelling case to be made that CoolSpools software really is the best there is. So here are five compelling reasons why CoolSpools is the number 1 IBM System i file conversion solution:

REASON 1: CoolSpools can convert your AS/400 data extract to a multitude of file formats

There are so many different reasons why you may wish to convert your AS/400 data extract. You might want to convert spool to Excel for invoices or sales reports. You might want to convert spool to PDF for briefing documents. You may want to produce AS/400 XML to populate web applications. CoolSpools can handle all of the above – as well as converting spools to text, CSV, HTML, RTF or TIFF.

REASON 2: CoolSpools software does not require a PC to convert from spools

With CoolSpools, all of your spool file conversion is handled in System i – but you can, of course, access your converted iSeries PDF, XML and Excel files via a PC if you wish.

REASON 3: CoolSpools can deal with many different iSeries spool file formats

Whether your spool files are *SCS, *AFPDS, *IPDS, *USERASCII, *LINE or *AFPDSLINE format, CoolSpools can easily convert them into the file format you need.

REASON 4: Comprehensive System i file conversion features

There’s so much CoolSpools can do with your converted spool files – and it’s all so simple. Whether you need to split your iSeries PDF or Excel file into multiple documents (and email them to multiple recipients), drop unwanted sections from your converted files, insert JPEGs of GIFs, or password protect your converted System i PDF, CoolSpools makes it simple.

REASON 5: Powerful features unique to CoolSpools

CoolSpools can also perform tasks that no other System i file conversion solution can handle. For example, with CoolSpools you can append your converted iSeries Excel or PDF file to an existing document – even if it wasn’t created using CoolSpools. As far as we’re aware, no other AS/400 file conversion tool can do this.

If we’ve convinced you that CoolSpools is the ultimate IBM System i file conversion solution, or you’d like to find out more about what it can do for you, visit www.ariadnesoftware.co.uk.

Readmore..

Published Date: 26th June 2013
Category: AS400, IBM, spooling