Re: Sending large Excel Spreadsheet

As another aside to this, changing the transform so it creates an xlsx file
instead of xls cut the size down from 83mb to 19mb and it now is small
enough that our email system handles it so I have no need to do the FTP. Go
figure.

On Tue, Oct 29, 2019 at 8:11 AM Blair Hamren <bhamren@xxxxxxxxx> wrote:

Thanks everyone. I have this working and just need to automate it. For now
it was a proof of concept for someone.

I create the Excel spreadsheet on the IFS using XLERATOR/CPYTOEXCEL and
its transform of *OOXML to create a spreadsheet with the extension of .xlsx
Next I FTP to the shared drive by setting cd to IFS directory, lcd to the
shared drive, bin for binary and get. (I am currently just running it from
my laptop command prompt).
I will probably have to run this from a CL program so I have work to do,
but at least I can open the spreadsheet without any errors. The first few
times I was using a different transform and outputting to a .xls extension
and I was getting corruption errors.

On Tue, Oct 29, 2019 at 7:23 AM Rob Berendt <rob@xxxxxxxxx> wrote:

Look up QNTC.
Also look up setting up NFS mounts.

If that local PC has a share on it, then accessing it via
MD '/QNTC/MYPCNAME'
CPY ... TOOBJ('/QNTC/MYPCNAME/MyPCShareName/mypcfile.xlsx')
Is really easy.

QNTC has a few quirks which have gotten much better with current releases
of the OS. Some people prefer doing NFS mounts. I've done it, it works.
A bit more setup on both the from side and the to side but your CPY command
works just as well.

Recently read a IFS comparison and they relegated QNTC as something only
used for reading from PC's built into your IBM i (remember FSIOP, IPCS and
that genre?). They really need to write their own material or refreshen
their 15 year old information. Might have been "Deep Dive into the IFS".
About then is when I decided I have better things to do with my time. They
also listed '/QOPT' as dead.

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


-----Original Message-----
From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of
Blair Hamren
Sent: Monday, October 28, 2019 1:54 PM
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxxxxxxxx>
Subject: Re: Sending large Excel Spreadsheet

CAUTION: This email originated from outside of the organization. Do not
click links or open attachments unless you recognize the sender and know
the content is safe.


Yes it is email file size.The current utility can build the spreadsheet
and
email it in one fell swoop (so I am not able to zip it), or it can just
create the spreadsheet on the IFS. I am hoping to build it on the IFS and
just get it transferred to a shared drive. Maybe FTP is my best option.

On Mon, Oct 28, 2019 at 1:32 PM John Yeung <gallium.arsenide@xxxxxxxxx>
wrote:

We have a utility that can convert a file to an Excel Spreadsheet and

email

it to a user. This same utility can also just create the spreadsheet

on

the

IFS.

The above seems to handle everything you need.

I can open a blank spreadsheet and use iACS to transfer the data into

the

blank spreadsheet, but am looking to rather put the spreadsheet on the

IFS

and then transfer it to some location on a shared drive.

So, is your problem that you are looking for help with the "transfer
it to some location on a shared drive"?

If I'm understanding you correctly, Excel has absolutely zero to do
with your problem. Your problem is entirely about e-mail size
limitations. Is that right?

John Y.
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing

list

To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link: https://amazon.midrange.com

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list
To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link: https://amazon.midrange.com
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list
To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link: https://amazon.midrange.com