ngsi.com www

Qport Office - FAQ's

General | Requirements | Ordering & Installation | Maintenance & Fees

Demos, Trials, & Training | Data & Output | Support & Security

General

What is Qport Office?
Qport Office is for companies that still rely on IBM Query/400. It allows authorized users to run Query/400 queries from the Windows desktop and output data directly to Microsoft Excel, Word, and Access. You can also display your output on the built-in Windows display and print your results to your local PC printer. You do not need to revise your Query/400 queries; they run normally, but you initiate them from an easy-to-use, graphical Windows interface instead of a green screen menu.

Does Qport Office replace Query400?
Qport Office gives you run-only access to your existing IBM Query/400 queries from your Windows desktop. You get additional functions without having to replace Query/400 - you can continue to use Query/400 to create and revise your queries. If you're interested in a replacement for Query/400, please consider our NGS-IQ solution.

Do you have other products?
We also offer a comprehensive reporting and business intelligence solution known as NGS-IQ. There is more information about NGS-IQ on this website. You are also welcome to email us at marketing@ngsi.com or call 800-824-1220.

Is the software user friendly?
Anyone familiar with basic Windows software operation can learn to use Qport Office in minutes. It's a simple, one-screen interface with point-click options.

How can we learn more about Qport Office?
Please tell us your email address and telephone number so that we can contact you and answer your questions, or call us at (800) 824-1220.

Software Requirements

How many people can use Qport Office?
NGS provides a two-concurrent user license of Qport Office without a license fee. You can install the software on any number of Windows PCs, and up to two people at a time can run queries.

Does it work with Office 2010, 2013, 2016, or 365?
The software will work with Microsoft Office 2010, 2013, 2016, and 365.

What other software is required?
IBM Query/400 is the only software required on your IBM server. You install and run Qport Office on your Windows PC.

Will it work with other query reporting tools in addition to IBM queries?
Qport Office works exclusively with IBM Query/400.

Will the software run queries not written in Query400?
Qport Office runs IBM Query/400 queries. It cannot run queries created in other tools.

Ordering and Installation

How do we order the software? Can we download it?
Complete the order form and we will email you instructions for downloading and installing Qport Office.

Do we have to speak to a salesperson?
When you complete the order form, we will contact you to verify your shipping and CPU information, but you do not need to speak to a salesperson.

How do we install the software?
NGS provides installation instructions and a license key when you order Qport Office. You can download and install the software in just a few minutes. If you have questions during the process, you are welcome to contact NGS technical support.

Maintenance and Fees

How much does the software cost? What is included?
NGS lets you download a two-concurrent user license of Qport Office without a license fee. We also provide you with 90 days of software support when you order. Support is optional after 90 days, and the software will continue to operate whether or not you pay the fee.

Is there maintenance? How do we extend the 90-day warranty?
After the initial 90-day warranty, you may extend maintenance by paying an annual fee. This fee is optional, and the software will continue to operate whether you pay or not. For a quote, please contact us at marketing@ngsi.com or call 800-824-1220.

What if we need more users?
You can license additional users as needed. Please email us at marketing@ngsi.com or call (800) 824-1220 and request a quote.

Demos, Trials, and Training

Can we request a demo?
To schedule a Web demonstration, please email us at marketing@ngsi.com or call (800) 824-1220.

Can we get a free trial of Qport Office?
There is no fee for a two-user license of Qport Office, so we encourage you to complete the online order form and install the software immediately after you download it. If you aren't satisfied, just uninstall the software from your Windows device.

Does NGS provide training?
You may schedule an introductory Web training session and also watch our short on demand video overview.

Data and Output

Do queries run in batch or interactively?
Queries process as batch jobs in the IBM i communications subsystem.

How do we run queries? Can queries run from shortcuts or hyperlinks?
Qport Office lets you run Query/400 queries from your Windows desktop, shortcut, or hyperlink. You enter the query name and where you want to send the output, save your instructions as an executable file, and point to that file from your shortcut or hyperlink. You can also use the easy, one-screen interface of Qport Office to enter your requests.

Where can we output data to?
Users can output queries to Excel, Access, Word, Windows display, and PC printers.

Can Qport Office create spreadsheets?
You can use Qport Office to output any Query/400 query to Excel. You can create, replace, and append your output to a specific Excel workbook, sheet, and range. You can also save your instructions and use them again and again to save steps and keystrokes.

Can it refresh or update data in an Excel sheet?
Users can refresh (update) a range within a sheet of an Excel workbook while preserving previously saved formatting.

Can we select date ranges?
IBM Query/400 doesn't support run-time prompting for date entry, but our NGS-IQ solution does give users this ability. Please contact us at marketing@ngsi.com or call 800-824-1220.

Can Qport Office create, generate, or update an Access database or table?
You can use Qport Office to output any Query/400 query to Microsoft Access. You can create and append to Access tables. You can also save your instructions and use them again and again to save steps and keystrokes.

Can Qport Office create or generate a Word document or file?
You can use Qport Office to output any Query/400 query to Microsoft Word.

Can Qport Office output queries in Adobe PDF format?
Qport Office can't create Adobe PDF files. If you're interested in PDF output, we encourage you to email us at marketing@ngsi.com or call (800) 824-1220 to ask about our comprehensive reporting and BI solution, NGS-IQ.

Can Qport Office create Web reports?
Qport Office can't create Web reports. If you're interested in Web reporting and HTML output, we encourage you to email us at marketing@ngsi.com or call (800) 824-1220 to ask about our comprehensive reporting and BI solution, NGS-IQ.

Support and Security

Is there technical support?
As a Qport Office customer, you have access to the same technical support team that supports all of NGS's other software. You can reach us by email and telephone during normal business hours.

How does the security work?
Qport Office complies with your IBM i security settings. Users must enter their IBM user ID and password before running a query.

Request Literature

Discuss Your Needs

Considering IBM Db2 Web Query?

NGS Blog

Follow Us

Privacy Policy

3835 N. Freeway Blvd, Suite 200 Sacramento, CA USA 95834
Office: (916) 920.2200 Sales: (800) 824.1220 Support: (800) 257.2442 Fax: (916) 920.1380

We Use Cookies

Site Map

Copyright & Copy; New Generation Software, Inc. All rights reserved.