× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.


  1.  Home
  2. MIDRANGE-L
  3. April 2016

RE: Speaking of data transfers

Then Paul's email is correct. You have to download once to create the
FDF file before you can upload.




Kevin Bucknum
Senior Programmer Analyst
MEDDATA/MEDTRON
Tel: 985-893-2550

-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of
Hoteltravelfundotcom
Sent: Monday, April 18, 2016 12:29 PM
To: Midrange Systems Technical Discussion
Subject: Re: Speaking of data transfers

nope not using any plugin.
It's clear that the PC has to have an FDF. I have not seen where and how
you make this FDF.

On Mon, Apr 18, 2016 at 1:19 PM, Kevin Bucknum
<Kevin@xxxxxxxxxxxxxxxxxxx>
wrote:

Are you using the plugin from within excel? I've never used it, but
one of the developers we used to have did, and he had a link to this
page in our internal documentation.
https://www-304.ibm.com/support/docview.wss?uid=nas8N1019202



Kevin Bucknum
Senior Programmer Analyst
MEDDATA/MEDTRON
Tel: 985-893-2550

-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of

Hoteltravelfundotcom
Sent: Monday, April 18, 2016 12:16 PM
To: Midrange Systems Technical Discussion
Subject: Re: Speaking of data transfers


question is, where and how to create this FDF.

On Fri, Apr 15, 2016 at 10:12 AM, Rob Berendt <rob@xxxxxxxxx> wrote:

I know that having more than one point on an email now a days can
lose

a lot of people's attention span but did you notice the thing at the
bottom?
<snip>
But the basic thing to remember is that the DB2 file has to exist.
The transfer will not create one.
</snip>


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>
To: Midrange Systems Technical Discussion
<midrange-l@xxxxxxxxxxxx>
Date: 04/15/2016 09:44 AM
Subject: Re: Speaking of data transfers
Sent by: "MIDRANGE-L" <midrange-l-bounces@xxxxxxxxxxxx>



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> 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>
To: Midrange Systems Technical Discussion
<midrange-l@xxxxxxxxxxxx>
Date: 04/15/2016 09:13 AM
Subject: Speaking of data transfers
Sent by: "MIDRANGE-L" <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 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.


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

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


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

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

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

As an Amazon Associate we earn from qualifying purchases.

This thread ...
Replies:
Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.