Re: Help Systems' email about AFP support discontinued at 7.3 - not true ! - or is it ?

Excellent point on the snapshot at end of month/year that the accountants
may want, Scott.

A spooled file will work as long as you remember to run the report. But if
IT knows you want the data to work with, again I say that creating a PF for
that snapshot of data is just as easy, if not easier than creating the
report. Heck, create both! :)

Brad
www.bvstools.com

On Fri, Dec 9, 2016 at 4:19 PM, Lindstrom, Scott R. <
Scott.Lindstrom@xxxxxxxxxxxxxx> wrote:

Brad - is correct - this is VERY common. Certainly has been done
everywhere I have worked.

And to argue the other point of view - a spool file is a snapshot of data
*at a point in time*. For an accountant it may be the General Ledger at
the close of the month. They don't want to see the data as it is *now*;
the want it from the report.

And by using products like Brad's they get their data immediately without
having to ask IT to program a file extract, or by doing it themselves using
something like Query or ODBC (which for many users is beyond their
ability/comfort level) (especially if the data comes from multiples files
that have to be joined together).

Scott

-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of
Bradley Stone
Sent: Friday, December 09, 2016 4:08 PM
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
Subject: Re: Help Systems' email about AFP support discontinued at 7.3 -
not true ! - or is it ?

I don't think you're missing anything, Nathan. I've said the same thing
for over 20 years.

Customers want spooled files converted to excel, csv or some other data
format. That's like taking a photograph of your daughter and asking it
what she had for supper. There's no "data", just a picture of the data.
Spooled files I feel are the same... a snapshot of your data, not actual
data.

But, trust me, using spooled files as "data" is used a VERY often in our
world, even though creating a PF from a query or program to get real data
isn't too difficult.

Yes, my SPLTOOL product will create a column delimited file that can be
imported to excel (stripping out headers as long as they're on the same
lines on each page). But most of the time I also suggest that they try
creating a PF instead and copying that to an ISV file.

Brad
www.bvstools.com

On Fri, Dec 9, 2016 at 3:10 PM, Nathan Andelin <nandelin@xxxxxxxxx> wrote:

The "forms" metaphor in this case seems a bit counter intuitive, to me at
least. Forms in my mind are pre-printed documents which contain input
elements which one fills out manually and hands back to whoever is

seeking

your input. Think filling our a drivers licence application and handing

it

back to a clerk.

It sounds like iForms is a WYSIWYG report designer and generator which

can

import data from multiple types of data sources. I've never understood

why

people felt that spool files were good "data sources".

I must be missing something..., probably out of touch.

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://urldefense.proofpoint.com/v2/url?u=http-3A__lists.
midrange.com_mailman_listinfo_midrange-2Dl&d=DgICAg&c=_
2JymsjkoSdpgdT4DmA4bg&r=-518Ilz5cVhEAzb0mENLKbaCPCUJ_
jWIaTTDYAFSng4&m=LUNA_CmD0jD4dxcl_m3NW88pdh1KCoBe6YB57O1a7M8&s=
765A4u5YGJguSEEQSanXdcchJPasONTZmDjItAO4AR0&e=
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://urldefense.proofpoint.com/v2/url?u=http-3A__archive.
midrange.com_midrange-2Dl&d=DgICAg&c=_2JymsjkoSdpgdT4DmA4bg&r=-
518Ilz5cVhEAzb0mENLKbaCPCUJ_jWIaTTDYAFSng4&m=LUNA_CmD0jD4dxcl_
m3NW88pdh1KCoBe6YB57O1a7M8&s=LaQejmjkxR8zF5dvpmUj2hTHm9VKro
boRq-muPU9s8E&e= .

Please contact support@xxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link: https://urldefense.proofpoint.com/v2/url?u=http-3A__amzn.to_
2dEadiD&d=DgICAg&c=_2JymsjkoSdpgdT4DmA4bg&r=-518Ilz5cVhEAzb0mENLKbaCPCUJ_
jWIaTTDYAFSng4&m=LUNA_CmD0jD4dxcl_m3NW88pdh1KCoBe6YB57O1a7M8&s=
bRfSPsFN-U5UL84BcDYpfYsiM4p-RDN6MvDgDd9IY6o&e=
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link: http://amzn.to/2dEadiD