Re: BI / Reporting tools

A Couple things on the reporting tool. This will be used in our production system and it's intended for end-users, some report will need to be setup initially set by the developers with scheduling capability to automatically run reports.

Jamal

-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of midrange-l-request@xxxxxxxxxxxx
Sent: Monday, 18, 2016 1:57 PM
To: midrange-l@xxxxxxxxxxxx
Subject: MIDRANGE-L Digest, Vol 15, Issue 652

Send MIDRANGE-L mailing list submissions to
midrange-l@xxxxxxxxxxxx

To subscribe or unsubscribe via the World Wide Web, visit
http://lists.midrange.com/mailman/listinfo/midrange-l
or, via email, send a message with subject or body 'help' to
midrange-l-request@xxxxxxxxxxxx

You can reach the person managing the list at
midrange-l-owner@xxxxxxxxxxxx

When replying, please edit your Subject line so it is more specific than "Re: Contents of MIDRANGE-L digest..."


*** NOTE: When replying to this digest message, PLEASE remove all text unrelated to your reply and change the subject line so it is meaningful.

Today's Topics:

1. Re: Speaking of data transfers (Rob Berendt)
2. Re: Re: BI / Reporting tools
(Mark Murphy/STAR BASE Consulting Inc.)
3. Re: BI / Reporting tools (Jim It)


----------------------------------------------------------------------

message: 1
date: Mon, 18 Apr 2016 13:44:33 -0400
from: Rob Berendt <rob@xxxxxxxxx>
subject: Re: Speaking of data transfers

By far, the EASIEST way to create the FDF is to download a file from IBM i to your PC. It will generate this FDF for you. Then you can use that when you upload from your PC to IBM i.


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/18/2016 01:15 PM
Subject: Re: Speaking of data transfers
Sent by: "MIDRANGE-L" <midrange-l-bounces@xxxxxxxxxxxx>



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.