|
 |
| News from the Kore
|
|
August 2002 Issue
|
|
Tech Tip: Get to
the Right Records Fast!
Frank Kertai
fkertai@koretech.com
Managing Partner
Kore
Technologies, LLC
This
month's tech tip is about a nice use
of “QSELECT”: a
verb used to explode multi-value fields into a list of individual values. The
technique illustrated works with any Universe or Unidata application
where keys for one file are stored in another file (DataFlo is one
such application). This method provides a much faster -- and
often easier -- approach to getting certain subsets of records than
having to perform end-to-end searches through an entire data
file. The best way to illustrate this usage is probably by
example.
Let’s suppose you want a listing of all of the open
line items for sales orders dated in July, 2002. In DataFlo,
the main file for sales orders is called the "SO" file. The
first thing we would do is find the open sales
orders:
SELECT
SO WITH DATE >= "07-01-02" AND <= "07-31-02" AND WITH STATUS=
"N""I""O"
The
line items for sales orders are stored in the "SOLI" file. Attribute 5 of the SO file contains a
multi-valued list of keys to the line items stored in
the SOLI file for each sales order, so QSELECT can be used, while
the select list is active from the initial select statement, to pick up the SOLI
record identifiers from specific Sales
Orders.
Thus, we use QSELECT to create a list of SOLI IDs
based on attribute 5:
QSELECT SO (5)
We now have a list with the SOLI record IDs for open
July sales orders. We
can use this list to then print out our
report:
SORT SOLI WITH STATUS = "N""I""O" AND WITH OPN_QTY
> "0" BY PART_NO BY-EXP DATE BREAK-ON PART_NO DATE TOTAL OPN_QTY
HEADING "'T' Open Sales
Order Line Items for July Orders '
L'"
This
technique lets you take advantage of the full power of the first
file when trying to select records in the second.
If you
have a puzzling
question or a suggestion for next month's tech tip send us an
e-mail.
|
|
|
 |
Kore
is on the Move -- Literally
Kore has outgrown its existing offices! With the new hires you read
about last month Kore Technologies needs a new home. So, we
have leased space in
an existing business park in San Diego that not only will meet our
current needs, but also will allow us to grow without space
problems for at least the next few years. Of course, in
keeping with the personality of the company, we expect to create a
space that is functional, business-like and fun - we'll leave the
elegant marble foyer to technology companies that are more hype than
substance.
No
one likes
moving,
and we're no exception. We plan to make the move both quick and painless, but
use the opportunity to "beef up" our network and phone infrastructure in the
process and establish a state-of-the-art technology environment with room to
grow.
Our new offices should make it easier to continue to
provide the best possible service to you, our
customers.
We’ll announce when we have moved in. In the meantime its business
as usual at Kore Technologies!
|
|
|
Key-Con
Fuels Discovers Flexibility
Indiana , PA — July
31, 2002 — Key-Con Fuels, a purchaser of coal and limestone
for the Keystone and Conemaugh Generating Stations, is now sending
out its business forms with a modern new look, thanks to its
recent acquisition of Kourier Forms Manager . The primary
reason for implementing Forms Manager wasn't replacing their
antiquated pre-printed forms, it was being able to meet the demand
of a rapidly changing marketplace: "We changed from no flexibility
to all of the flexibility in the world." stated Jamie Ellis,
Supervisor-Office Administration and Information Systems. "Before
'Forms Manager', even an area code change generated the need for
another set of pre-printed forms. Now we can change addresses,
standard terms, or any other standard element of our forms, and in
less time than it took to explain changes to our forms provider. And
we can even do it ourselves!" Since Forms Manager uses standard
Microsoft tools, no special software is
required.
“Of course we'll save money, and it is nice to
not have to worry about storing or running out of forms, but the
overall
value of
professional looking, crisp forms is hard to quantify. And,
learning to use the Forms Manager was easy.”
- Jamie Ellis, Key-Con Fuels, Inc.
About Key-Con Fuels:
Key-Con Fuels provides the fuel that powers the
Keystone and Conemaugh Generating Stations (two large coal-fired
electric generating stations). The Stations consume approximately
ten million tons of coal each year with the total generating
capacity of the four units being 3.4 million
kilowatts.
|
|
|
Network security is an uncomfortable subject. We know that there are
thousands of hackers trying to find their way into even the most
secure environments, and that it is very hard to stop them. Everyone does the things
they know how to do to make their networks secure, and hope that is
good enough. But is
it? Unfortunately, the
answer is, "probably not."
The good news, though, is that relatively minor
changes to configuration, setup, hardware, etc., can make your
network sufficiently secure that a would-be intruder will skip your
network and go elsewhere.
Kore Technologies is offering a low-cost security audit
program that will detail the steps you need to take to protect one
of your company’s most valuable assets: its data. Click here
or call Frank Kertai at (831) 439-0940 to find out more.
How much is it worth to go home at night knowing your
network is secure?
|
|
|
Product
and Service News
New Release of Kourier 3.1: The major
enhancement in Kourier 3.1 is the introduction of the Java FTP
client for faster, more reliable data transfers. In addition, the export
facility was enhanced to allow data to be sent to multiple accounts
with one execution.
We also changed the contacts in Kourier so you
can specify their communication preference, either e-mail or fax. Finally, user reserved
fields have been added to the tables to support
customization.
New Release of KommerceServer 3.1: The major enhancement in KommerceServer 3.1 is
architectural: a new style view was created which provides
single-click sorting of columns and automatic
integration to Excel! Currently, this new technology has been deployed in WebTeam,
and will be rolled out into the rest of the web applications in the next release.
Help is
available for easy DataFlo reporting: Remember when it was easy to get totals on a report
simply by typing ‘N’ and going to the last page? Unfortunately, the standard
Preview report manager doesn’t provide that facility. Now, Kore has created a
nifty, inexpensive modification to the Preview report manager that
allows you to see the last page of the report just like in the “good
old days”.
To receive this enhancement contact us
.
|
|
|
Paul’s
Corner
 A
funny thing happened to me
August 1st on the way to work. I was cruising along about
5:30am and realized I wasn’t sure where I was. Then to my dismay the next
exit was a few miles beyond my freeway exit to work. Aaugh! I took that exit to
turn around and found that Cal-Trans was working underneath the bridge so
I was stuck in line for a little while. Oh well, such is
life.
No
need to get stuck in line for your sales order reports! Did you know that
there are five DataFlo sales order reports that may be run by only
one person at a time?
These reports generate data into the SOD file and then report
from it. Because there
is only one file, the reports have to set a Process Lock so only one
person can use that file at a time. Why not change those reports
so that anyone can print a report at any time? It’s simple! The ‘trick’ is that you
modify the report to use the user-specific Preview Turbo Work file
rather than the SOD file and remove the Process Lock. Here
are the changes required
for later versions of the software that use the Preview Report
Manager: change the
Calculation Subroutine to build the information in the user’s TWFnnn
file; in Before List set the List Data File to the TWFnnn file;
change the Display Using file to SOD; and be sure to disable the
Process Locking. Make
these few simple changes and ‘ta daaah’ happy users. If you need help, you know
where to find me.
I went to the Epicor
Users Group conference in May and had a great time. I really enjoy meeting folks
especially those I’ve been working with all these years. It was a real ego boost for
me to have people come by the Kore Technologies booth and say
“Where’s Paul?” I
really look forward to the next few conferences as I have about
10,000 people I’ve worked with over the years that I’d really like
to meet.
Please
remember, “Great Service to your Customer is always rewarded”.
If you have any questions or comments on our
newletter please contact
Frank Busalacchi. We're here to help!
|
|
|
|
|
|
