Re: Sending large Excel Spreadsheet -- MIDRANGE-L

As a final aside on this, it turns out there is one last BOM file that is
very large that has a 66 mb size even as xlsx.

I went to talk to our system admin to see if we have some way to push this
file with FTP so I can do it in a CL program. No - they don't want to open
up to shared folders. They suggested iACS file transfer (which I had
already demoed and is the fastest and easiest - open a blank spreadsheet,
click on the saved transfer and it runs) but my PM didn't like that for
some reason. Then the admin says that we have Web Query for IBM i with
unlimited end user licenses. Problem solved and also made my 4 days of work
to add these emails and provide all testing to these 7 programs a waste of
time - they could have done it all in Web Query.

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

There's a reason why xls was referred to hssf or "horrible spread sheet
format".

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: Tuesday, October 29, 2019 9:09 AM
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.

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

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