Category: CONVERT SPOOL TO EXCEL

Posted on January 27, 2014at 10:31 am

System i File Conversion: Making it Easy With CoolSpools Software

IBM’s System i, AS/400 and iSeries servers are powerful, flexible and reliable. This you already know. But did you know you can make your System i environment work even harder for you? This can be done with the help of System i file conversion.

System i experts Ariadne Software have developed the CoolSpools range of products, designed to make it easier, quicker and more convenient to manage, access, convert and distribute information using System i. In addition to their spool file management and email applications, CoolSpools also offers two comprehensive System i file conversion packages: CoolSpools Spool File Converter and CoolSpools Database.

So what’s CoolSpools Spool File Converter?

The clue’s in the name! In a nutshell, CoolSpools Spool File Converter makes System i PDF file conversion so much faster. It takes your System i spool files and converts them to a wide range of useful file formats.

You could convert spool to PDF. Convert spool to Excel. Convert spool to XML. Text files, CSV, RTF, TIFF… a whole host of popular file formats can be converted.

But CoolSpools Spool File Converter does so much more than mere System i file conversion.

You can also split files. Merge files. Format files. Insert images into your PDFs. Even email the converted files to multiple recipients. And CoolSpools software makes it all so easy to do!

What about CoolSpools Database?

CoolSpools Database performs a different type of System i file conversion. Instead of converting your spool files, CoolSpools database converts System i database files to a variety of file formats, such as Excel, XML and plain text.

Why should I want to carry out System i file conversion?

Lots of reasons and lots of savings!

Taking data from your System i spool files or database files guarantees its accuracy and integrity.
It allows you to output System i files in a format that suits you, whether it’s PDFs for business reports, Excel to communicate sales figures, or XML to program System i applications.

This saves a huge amount of time and all of the printing & postage costs. Typically customers can save between £25,000 and £40,000 per year!

CoolSpools software is all about taking control of your System i data and presenting it how you need it, when you need it – all with minimal fuss.

Where can I find more about CoolSpools software and System i file conversion?

Easy! To learn more about CoolSpools’ powerful System i file conversion capabilities, plus their full suite of easy-to-use software for IBM AS/400, iSeries and System i, visit http://www.coolspools.com/spool-converter/.

Take Control of AS/400 XML: CoolSpools Spool File Converter & Database

Posted on January 27, 2014at 10:22 am

Do you work with XML in an AS/400, iSeries or System i environment? If so, wouldn’t you like a better, easier, simpler way of creating XML? If so, you’ll love CoolSpools software.

Created by AS/400 experts Ariadne Software, CoolSpools products are designed to make AS/400 data distribution a smoother and more efficient experience. Two CoolSpools products have been designed to make creating XML easy: CoolSpools File Converter and CoolSpools Database. Here’s how they could help you…

What does CoolSpools Converter do?

It takes your AS/400 spool files and converts them to a wide range of file formats – including XML.

What is CoolSpools Database ?

CoolSpools Database is a powerful database management system, rather than taking data from your AS/400 spool files, the data is taken from your database files.

What file formats be converted to XML?

CoolSpools can convert all database file types the following AS/400 spool file formats: *SCS, *AFPDS, *IPDS, *LINE, *AFPDSLINE and *USERASCII. Many similar products can only handle simple *SCS spool files as they lack the power and flexibility of CoolSpools.

Other than XML, what other file formats can CoolSpools convert to?

CoolSpools can convert database and spool files to PDF, Excel, CSV, plain text, HTML, RTF and TIFF. It can also output as compressed spool files or create a new spool file by duplicating, splitting or creating a subset.

Does CoolSpools offer any other AS/400 applications?

Yes! CoolSpools Admin makes it easy to manage your AS/400 spool files, while CoolSpools Email makes it easy to email direct from your AS/400, System i or iSeries environment. When combined, all four packages in the CoolSpools software suite make a truly unbeatable AS/400 document and data management system.

Take the pain out of producing XML – convert your spool files and database files using the power of CoolSpools software. To find out more, and to order CoolSpools software, visit http://www.coolspools.com/spool-converter/.

Create iSeries XML the Easy Way with CoolSpools

Posted on December 20, 2013at 3:27 pm

Work in an IBM AS/400, System i or iSeries environment? Need to create XML files to import into web applications? Forget entering all the data manually – now it’s easier than ever…

IBM iSeries experts Ariadne Software have developed CoolSpools, a powerful, flexible spool file converter. Anyone running an iSeries is sure to find CoolSpools software incredibly useful – especially if you require XML files.

You see, CoolSpools can generate a wide range of file formats by converting your iSeries spool files. You can convert spool to PDF, Excel and – crucially – XML.

Here are just five reasons to consider using CoolSpools to produce XML from your iSeries…

Less risk of human error

Using CoolSpools to create XML minimises the risk of data being entered incorrectly. The data is taken directly from your spool files, which CoolSpools converts and outputs as XML. There’s no chance of human error – it’s all done for you using CoolSpools software.

Save time programming applications

As well as ensuring the integrity of your data, importing data using XML generated using CoolSpools software saves time. Why have interface files or new applications, when you can export from your spool files using XML and import the data into your applications?

CoolSpools software is easy to use

CoolSpools is so easy to use, you’ll soon become a master of converting spool files to XML, Excel, PDF and a whole host of other useful file formats.

CoolSpools software is flexible

It may be easy to learn, but CoolSpools is not just a mere simple spool file converter. You have control over what data you convert into XML from your spool files, ensuring you get all the data you need.

Ariadne Software offers comprehensive support for CoolSpools

Need help, assistance or updates for your CoolSpools software? Ariadne Software’s support page is always available at http://www.coolspools.com/Support.htm, with more in-depth tech support just an email or phone call away.

So why not start creating XML the simple, accurate and fast way using the CoolSpools spool file converter?

And remember, CoolSpools does so much more than convert spool to XML. You can also create iSeries PDFs, Excel, TIFFs, text files, HTML and other file formats. CoolSpools gives you total control over what you include, what you leave out, and to whom you email your converted iSeries documents.

Find out more about CoolSpools software – including their spool file converter, email management, database software and administration solutions – at http://www.coolspools.com/.

Beginner’s Guide to AS/400 XML & How CoolSpools Can Convert it For You

Posted on December 10, 2013at 11:20 am

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 (http://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 http://www.coolspools.com/.

System i File Conversion Simplified With CoolSpools Software

Posted on November 25, 2013at 11:20 am

There are many great reasons to use file conversion software in order to make your working life easier, and to make mundane tasks take much less time. If you work with an IBM System i, AS/400 or iSeries server, there are several System i file conversion solutions to choose from – but perhaps the most impressive and fully-featured is CoolSpools (http://www.coolspools.com/).

Developed by a team of IBM AS/400 experts at Ariadne Software, CoolSpools is the ideal solution when it comes to System i file conversion.

CoolSpools is a powerful spool file converter

CoolSpools software is, at its heart, a System i spool file converter. CoolSpools offers you an easy, hassle-free way of converting and presenting the data in your spool files in a format that can be easily distributed and understood.

CoolSpools coverts to a wide range of file formats

No matter what format you need to present your information in, CoolSpools can handle it. From AS/400 Excel files for financial reports to XML to populate your website, from PDF documents to HTML, CoolSpools is sure to have a file format to suit your System i file conversion needs.

Formatting however you need it with CoolSpools

CoolSpools is no mere spool file converter! As well as performing System i file conversion on your spool files, it can also format the output in a variety of ways. Splitting, merging, formatting, inserting images, conditional formatting in Excel… all can be handled by CoolSpools software, saving time and effort on your part.

Keep confidential data away from prying eyes

If security is an issue, there’s no need to worry with CoolSpools. After converting spool to PDF, CoolSpools software can even password protect the finished document. It can also add digital signatures to your document, so you and anyone else receiving the document will be able to tell if it’s been tampered with.

Distribution for your converted System i files

If you need to email different parts of your converted PDF or Excel file to multiple recipients, CoolSpools makes this easy. There are several methods available to you, depending on who you want your converted file to go to, and where your email addresses are stored.

No doubt about it. If you work in an IBM System i, AS/400 or iSeries environment, a spool file converter will make producing and editing documents so much easier. Using System i file conversion software such as CoolSpools ensures your data is accurate, well-presented and seen by all the right people.

Find out more about CoolSpools’ unparalleled System i file conversion functions, and how they can save you time and money, at http://www.coolspools.com/.

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

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 (http://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 http://www.coolspools.com/ now to find out more about its System i Spool and Database file conversion and its many other flexible capabilities.

Convert spool file to PDF

Posted on October 15, 2013at 12:32 pm

Selecting the best tool.

Spool File to PDF

Adobe’s PDF is now the de facto standard for exchanging documents electronically. The advantage of PDF is that it is a universal file format that can preserve fonts, formatting, colors and graphics. Adobe PDF files are compact and can be shared, viewed, navigated, and printed. Start your journey here to learn how to convert a spool file to pdf.

System i businesses looking to make the leap to paperless trading are faced with quite a number of products that are capable of taking a System i spool file and converting it to PDF format. However, not all of these products offer the same range of features. When selecting a tool of this kind, it is important to ask the following questions:

What kinds of spooled files can be handled?

Some tools can only handle simple *SCS spooled files. If you use more complex spooled files, make sure the tool you choose can process:

• AFP (Advanced Function Printing)
• IPDS (Intelligent Printer Data Stream)
• Line data

What spooled file content can be processed?

Some tools can only process the textual content of your spooled fie. If you want the PDF file to reproduce the appearance of your spooled file accurately, make sure the tool you select can handle:

• Multiple, mixed fonts
• Images and graphics
• Overlays and page segments
• Barcodes

What added value can the tool provide?

While converting your spooled file, some tools allow you to add value to your reports by allowing you to add such things as:

• Data compression
• Indexes and bookmarks
• Color
• Titles and control information
• Logos, watermarks, and pre-printed forms

How easy is it to integrate with my existing systems?

Think about how you will implement the tool within your current environment. Will you need to re-code your applications or change your reports to achieve what you require? Look for features such as:

• A command line interface
• The ability to split reports so that, for example, a single billing spooled file can be divided automatically into separate invoice files for different customers
• Exit program points to allow you to perform special processing on the files as they are created, e.g. pass them to an e-mail application

Please visit our website at www.CoolSpools.com to download a 30-day free trial of our tools for converting System i spool files to Adobe PDF, RTF, Excel, CSV, TIFF, HTML and other PC file formats. Start spool file to pdf conversions now!

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.

How to Reclaim Wasted Hours

Posted on September 19, 2013at 8:49 am

… 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? CoolSpools spool file converter can get back your valuable time…

Introducing CoolSpools spool file converter (http://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,  iSeries PDF, XML and many more popular file formats – automatically, no effort required.

2. Hassle-free formatting 

CoolSpools can automatically reformat 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 Iseries 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 manuall. It can be used in all kinds of things, including system i Excel.

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 http://www.coolspools.com/spool-converter/.

17 Ways Spool File Converter Turbo-Boosts AS400 Systems

Posted on September 02, 2013at 8:24 am

When it comes to spool file conversion, CoolSpools (http://www.coolspools.com/) is one of the most powerful AS400 PDF solutions on the market. The Spool File Converter developed by IBM experts Ariadne Software, CoolSpools automatically manages, converts, and distributes documents created from AS400, System i or iSeries spools.

Here are 17 useful things CoolSpools software can do…

1. Convert spool to PDF

Creating PDFs just got a whole lot easier! Why manually create PDFs when CoolSpools can automate the process from your spool files?

2. Split converted AS400 PDFs into multiple files

Tell CoolSpools where to split your files –for example, when invoice numbers or customer names change – and it’ll split the output into multiple PDFs.

3. Join converted AS400 PDFs to existing documents

Want to create a report with data from multiple System i spool files? Or add pages to an existing PDF – even one that wasn’t created by CoolSpools? Not a problem.

4. Drop pages you don’t need from AS400 PDFs

Tell CoolSpools the page numbers or phrases to leave out, and it’ll remove them for you.

5. Insert images in converted PDF files

Forms, logos, watermarks, cute photos of kittens… as long as it’s a JPEG or GIF, CoolSpools can insert it into your PDF.

6. Password protect your AS400 PDFs

Keep prying eyes away from your sensitive data!

7. Bookmarks and indexes

Generate a set of bookmarks – great for navigating and indexing larger PDFs.

8. Convert spool to Excel

AS400 isn’t the only file format CoolSpools software can convert to – it can also output Excel.

9. Add converted AS400 Excel to existing documents as a new worksheet

Is CoolSpools the only AS400 spool file converter that can do this? We think so.

10. Split converted AS400 Excel output into multiple documents

Sales reports split by region? Accounts projections split by quarter? Tell CoolSpools where to split, and it splits!

11. Drop unwanted pages or lines from your AS400 Excel spreadsheet

Don’t bore readers with irrelevant information – let CoolSpools chop it out.

12. Format your AS400 Excel files

Color, fonts, shading, borders, conditional formatting – automated with CoolSpools.

13. Convert spool to XML

Spend less time programming XML into applications – let CoolSpools convert your spool output to XML for you.

14. Convert spool to even more file formats

XML, Excel and PDF not enough? You can also convert to CSV, HTML, RFT, TIFF, text and more…

15. Control filenames and output paths

You determine what the converted files are called, and where they’re saved.

16. Control who receives what

CoolSpools has powerful tools to help you email the right files to the right recipients – automatically.

17. Convert spool files without a PC

Everything’s done within your AS400, iSeries or System i environment, with no need for additional hardware.

When it comes to converting spool to XML, Excel or PDF, CoolSpools is the ultimate solution. Head to http://www.coolspools.com/ to learn even more about the power of CoolSpools software.