Re: Speaking of data transfers

On April 18, 2016 at 1:09 PM Hoteltravelfundotcom <hoteltravelfun@xxxxxxxxx>
wrote:

where do i make this FDF?

On Fri, Apr 15, 2016 at 9:49 AM, paultherrien
<paultherrien@xxxxxxxxxxxxxxxxxx <mailto:paultherrien@xxxxxxxxxxxxxxxxxx> >
wrote:
> > I believe ... the file that cannot be found is the FDF - file
> > definition file. When you upload to the I the file transfer program is
> > looking for an FDF file to tell it how to transfer and format the data.

> On April 15, 2016 at 9:44 AM Hoteltravelfundotcom
> <hoteltravelfun@xxxxxxxxx <mailto:hoteltravelfun@xxxxxxxxx> > wrote:
>
>
> simple upload using data transfer to IBMi.
> Option 2 on your list.
>
> On Fri, Apr 15, 2016 at 9:27 AM, Rob Berendt <rob@xxxxxxxxx
> <mailto:rob@xxxxxxxxx> > wrote:
>
> > There's a few things to consider here:
> > - Simply transferring an Excel spreadsheet from your PC to somewhere
> > in
> > the IFS on your IBM i
> > or
> > - Trying to take data from an Excel spreadsheet and transfer it into
> > a DB2
> > file in the /QSYS.LIB file system.
> >
> > If you are trying to do the latter then there's other things to
> > consider.
> > 1 - Are you willing to use the Excel plug-in to transfer data from
> > Excel
> > directly into a DB2 file, or
> > 2 - Are you trying to use the Data Transfer from IBM i Access Client
> > Solutions?
> > 3 - Are you trying to use the deprecated IBM i Client Access for
> > Windows
> > Data Transfer?
> >
> > If you're using 3 I won't help you.
> >
> > But the basic thing to remember is that the DB2 file has to exist.
> > The
> > transfer will not create one.
> >
> >
> >
> >
> > Rob Berendt
> > --
> > IBM Certified System Administrator - IBM i 6.1
> > Group Dekko
> > Dept 1600
> > Mail to: 2505 Dekko Drive
> > Garrett, IN 46738
> > Ship to: Dock 108
> > 6928N 400E
> > Kendallville, IN 46755
> > http://www.dekko.com
> >
> >
> >
> >
> >
> > From: Hoteltravelfundotcom <hoteltravelfun@xxxxxxxxx
> > <mailto:hoteltravelfun@xxxxxxxxx> >
> > To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx
> > <mailto:midrange-l@xxxxxxxxxxxx> >
> > Date: 04/15/2016 09:13 AM
> > Subject: Speaking of data transfers
> > Sent by: "MIDRANGE-L" <midrange-l-bounces@xxxxxxxxxxxx
> > <mailto:midrange-l-bounces@xxxxxxxxxxxx> >
> >
> >
> >
> > HI I have not done this in a long time. the simple data transfer on
> > the
> > Data transfer to i.
> >
> > I selected the pc file which is an excel.
> >
> > then i selected the file and member and lib
> > but i get a error message
> > 'The system cannot find the file specified'
> >
> > why is that?
> > --
> > This is the Midrange Systems Technical Discussion (MIDRANGE-L)
> > mailing
> > list
> > To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> > <mailto: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
> > <mailto: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 <mailto:support@xxxxxxxxxxxx> for
> > any subscription related
> > questions.
> >
> >
> > --
> > This is the Midrange Systems Technical Discussion (MIDRANGE-L)
> > mailing list
> > To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> > <mailto: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
> > <mailto: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 <mailto:support@xxxxxxxxxxxx> for
> > any subscription related
> > questions.
> >
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
> list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> <mailto: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
> <mailto: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 <mailto:support@xxxxxxxxxxxx> for
> any subscription related questions.
Paul Therrien
Andeco Software, LLC
paultherrien@xxxxxxxxxxxxxxxxxx <mailto:paultherrien@xxxxxxxxxxxxxxxxxx>
>