RE: Output from PF to Excel XLS file in IFS -- MIDRANGE-L

I know I'm coming in late on this discussion, but we use the Kemetech product 
to convert
PF's directly to XLS (and back!) and have been quite happy with it.

One feature we use is the ability to put data on different tabs based on a 
field in the file.  For example,
 we will build a sales report for a manager of all of their rep's sales sorted 
by the sales rep.  We tell
it to break the data in different tabs based on the field, and the manager gets 
a native Excel file with
the data put in different tabs for each rep.  They love it.

We also use it for remote data entry.  We build a file with data that needs to 
be corrected or entered,
email it to someone, they enter the data in the specified column, and I convert 
that spreadsheet
back to a PF directly.  

Love it.


Rich Herdman
Abbott Foods
Columbus, Oh


On Fri, 07 Feb 2003 19:40:09 -0500, Art Tostaine, Jr. wrote:

>I agree on Kemetech.  I signed up on their website for an evaluation copy
>but I haven't heard anything yet.
>
>Art Tostaine, Jr.
>CCA, Inc.
>Jackson, NJ 08527
>
>
>-----Original Message-----
>From: midrange-l-bounces@midrange.com
>[mailto:midrange-l-bounces@midrange.com] On Behalf Of
>meovino@estes-express.com
>Sent: Friday, February 07, 2003 4:15 PM
>To: Midrange Systems Technical Discussion
>Subject: RE: Output from PF to Excel XLS file in IFS
>
>
>Reeve,
>
>Yes, it's a long B/L number, all numeric digits.  It's nothing wrong with
>LTL/38, it's two "features" of Excel working in tandem:
>
>1.  Text qualifiers in a CSV file are ignored if every character in the
>field is numeric or blank.
>2.  Excel displays long (> 12 digit) numbers as scientific notation, no
>matter how wide you make the column.
>
>The suggestion of the products from Kemetech look like they'll fit our
>needs quite nicely.
>
>Thanks!
>Mike E.
>
>
>
>
> 
>
>                    "Reeve Fritchman"
>
>                    <reeve@ltl400.com>          To:     "'Midrange Systems
>Technical Discussion'"                         
>                    Sent by:                     <midrange-l@midrange.com>
>
>                    midrange-l-bounces@mi       cc:
>
>                    drange.com                  Subject:     RE: Output from
>PF to Excel XLS file in IFS                  
> 
>
> 
>
>                    02/07/03 02:01 PM
>
>                    Please respond to
>
>                    Midrange Systems
>
>                    Technical Discussion
>
> 
>
> 
>
>
>
>
>
>Hmmm...this would have to be something like a long B/L number (an alpha
>field) or a shipment number (FHSN?).  Let me check with one of my guys; I'm
>sure we figured out a way to do this (but I might be wrong).
>
>Say hello to HBC III and RWE JR. for me...
>
>-reeve
>
>> -----Original Message-----
>> From: midrange-l-bounces@midrange.com
>[mailto:midrange-l-bounces@midrange.com] On Behalf Of
>> meovino@estes-express.com
>> Sent: Friday, February 07, 2003 1:24 PM
>> To: Midrange Systems Technical Discussion
>> Subject: Re: Output from PF to Excel XLS file in IFS
>>
>>
>> > forgive me for being flippant, but if the user 'absolutely, positively,
>> > will not accept anyting but an honest-to-god XLS file', and he/she
>> actually
>> > has the pull to make such an unreasonable mandate, tell him/her that
>the
>> > cost of purchasing SEQUEL will come out of her/his budget!  ;)
>>
>> Unfortunately, not an option ;-)  I'm trying to get them to do the math
>to
>> justify the cost based on timesavings.  It will work out, but I'm not
>going
>> to do it for them.
>>
>> > as far as other options - I've never done this, but can't you (at least
>> > 'semi') automate the process of importing external data (in this case,
>a
>> > .csv) into an excel template file, creating a new excel spreadsheet?
>> Maybe
>> > a VB macro, or some such.
>>
>> CSV won't cut it; we're doing that right now.  Excel displays numbers
>with
>> more than 12 (?) digits in scientific notation, no matter how wide you
>make
>> the column.  It's a "feature."  I need to be able to format that column
>as
>> text.  If we wrap the value in double quotes with the CPYTOIMPF command,
>> Excel still treats the field as a number if there's no text in the field
>> (even blank spaces won't help).
>>
>> VB macros are not an option.  We want to mail this out to customers, from
>a
>> program that runs on schedule in batch, with no human intervention.
>>
>> Mike E.
>>
>>
>> _______________________________________________
>> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
>list
>> To post a message email: MIDRANGE-L@midrange.com
>> To subscribe, unsubscribe, or change list options,
>> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
>> or email: MIDRANGE-L-request@midrange.com
>> Before posting, please take a moment to review the archives
>> at http://archive.midrange.com/midrange-l.
>
>
>
>_______________________________________________
>This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
>To post a message email: MIDRANGE-L@midrange.com
>To subscribe, unsubscribe, or change list options,
>visit: http://lists.midrange.com/mailman/listinfo/midrange-l
>or email: MIDRANGE-L-request@midrange.com
>Before posting, please take a moment to review the archives
>at http://archive.midrange.com/midrange-l.
>
>
>
>
>
>_______________________________________________
>This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
>To post a message email: MIDRANGE-L@midrange.com
>To subscribe, unsubscribe, or change list options,
>visit: http://lists.midrange.com/mailman/listinfo/midrange-l
>or email: MIDRANGE-L-request@midrange.com
>Before posting, please take a moment to review the archives
>at http://archive.midrange.com/midrange-l.
>
>
>_______________________________________________
>This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
>To post a message email: MIDRANGE-L@midrange.com
>To subscribe, unsubscribe, or change list options,
>visit: http://lists.midrange.com/mailman/listinfo/midrange-l
>or email: MIDRANGE-L-request@midrange.com
>Before posting, please take a moment to review the archives
>at http://archive.midrange.com/midrange-l.
>