Re: The FDF file on a transfer

[Dan Rasch <drasch@xxxxxxxxxxxx>]

I have had limited success using the methods offered here (and I
appreciate the help), but still need a map to the fields.  

The particulars:

1. Saved the Excel file as .PRN and transferred as ASCII.  
   This method sent all the data for all the records,
   but did not map the fields correctly. Environment:
   a. saved spreadsheet as .PRN
   b. transferred from PC to 400 using 
       PC file name = the .PRN file,
       400 file name = lib/file
   c, details:
       (not checked) use PC file descr file 
       file type = ASCII text, 
       translate = (ASCII checked)
       create = Yes, both file and member      
       record length = 600

2. Transferred backwards from 400 to PC and created a FDF file,  
   but must be doing something wrong on the back end, because I  
   only get one record, and it has 6 bytes of garbage followed by spaces.
   The environment:
   a. transferred my 400 file to the PC and created C:\TRANSFER.FDF
   b. transferred from PC to 400 using
       PC file name = (Excel spreadshhet file name)
       AS/400 file name = (lib/file)
   c. details:
       (checked) Use PC File descr
       file description file C:\TRANSFER.FDF
       translate = (ASCII checked) 
       AS/400 file Create = No, replace member only
   Under the 'desperate times' theory, I also tried checking the ANSI to
   decimal instead of ASCII, but had the same basic result.


Dan Rasch - because if the human species concentrated on the really 
important things in life, there would be a shortage of fishing poles!


On Thu, 27 Apr 2000, Rob Berendt wrote:

> The usual and customary method is to create a file on 
> the 400 first, key in a dummy record, download it and 
> save the FDF file.  Then, clear the file and use the FDF 
> file to upload the real data.
> 
> 
> 
> 
> 
> drasch@mail.win.org on 04/27/2000 12:15:50 PM
> Please respond to MIDRANGE-L@midrange.com@Internet
> To:   MIDRANGE-L@midrange.com@Internet
> cc:    
> Fax to:       
> Subject:      The FDF file on a transfer
> 
> 
> I am trying to upload an Excel spreadsheet up to the 400 using the Send
> icon on my tool bar.  The transfer is looking for an FDF file, and I can
> remember building the FDF on the fly in the past.  But I cannot seem to
> locate the icon or button to accomplish this.  
> 
> I went looking in the archives, but could not link to the site for some
> reason.  Any help would be appreciated.
> 
> Dan Rasch - because if the human species concentrated on the really 
> important things in life, there would be a shortage of fishing poles!
> 
> 
> +---
> | This is the Midrange System Mailing List!
> | To submit a new message, send your mail to MIDRANGE-L@midrange.com.
> | To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
> | To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
> | Questions should be directed to the list owner/operator: david@midrange.com
> +---
> 
> 
> +---
> | This is the Midrange System Mailing List!
> | To submit a new message, send your mail to MIDRANGE-L@midrange.com.
> | To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
> | To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
> | Questions should be directed to the list owner/operator: david@midrange.com
> +---
> 

+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---