Re: Speaking of data transfers

[paultherrien <paultherrien@xxxxxxxxxxxxxxxxxx>]

On your local pc,
 

> 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>
> >  > 

 
Paul Therrien
Andeco Software, LLC
paultherrien@xxxxxxxxxxxxxxxxxx