RE: [EXTERNAL] Re: Problem opening Xls file in IFS -- RPG400-L

Eddie,

Might you be able to provide any insight on how to set this up, or a link that might provide instructions for this. I'm interested in looking into this.

We fight the users forgetting their password all the time.

I'm not sure about us using it as a temp folder like you do. We have documents need to be accessed for a longer period of time.

-----Original Message-----
From: RPG400-L <rpg400-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of Scott Klement
Sent: Tuesday, March 24, 2020 10:55 AM
To: rpg400-l@xxxxxxxxxxxxxxxxxx
Subject: [EXTERNAL] Re: Problem opening Xls file in IFS

Eddie,

Bravo! That is a much, much better solution that the way Gio is coding it.

Best yet is to eliminate 5250 and STRPCCMD entirely, and do it entirely with web.

-SK

On 3/24/2020 12:00 AM, Eddie Gomez wrote:

We had similar problems. We moved away from using shared folders on the IFS to serving files via the integrated web server. Worked perfectly and let us become platform independent as we have MacOS workstations as well that connect to our AS400.

On Mar 23, 2020, at 19:38, Scott Klement <rpg400-l@xxxxxxxxxxxxxxxx> wrote:

Obviously the problem is that Windows didn't keep the login
information. It doesn't remember it permanently (unless you tell it
to.)

You can use the "net use" PC command to set the Windows login information. You can use that from your script to make sure it's ready to launch the Xls (or PDF, which appears to be what you're actually trying to launch).

On 3/23/20 6:24 PM, gio.cot via RPG400-L wrote:
Hi all

I'm try to open from RPG a Xls file stored in Ifs with this command :
STRPCCMD PCCMD('rundll32 shell32,ShellExec_RunDLL
"\\192.168.0.100\PDF\MYFLR\MYDOC_1141521.pdf") PAUSE(*NO)').
Yesterday i tested my program and it was ok; today i have retried
and

It don't works (i don't know why), then after some test, i have
opened the folder from windows explorer. Windows have asked AS400's
user and password and then showed the folder with MYDOC_1141521.pdf.
After that i have retried to run my program and now the STRPCCMD PCCMD('rundll32 shell32,ShellExec..
works fine and open the document.

Questions:

1. Which could the problem ?

2. Possible that until i don't open MYFLR via windows, STRPCCMD
PCCMD('rundll32 shell32,ShellExec.. Don't works

3. Which workaround ?

Thanks in advance

Gio

--
Scott Klement
https://linkprotect.cudasvc.com/url?a=http%3a%2f%2fwww.scottklement.c
om&c=E,1,1JEhMmvtEyQZOoI1Xw5gvCdt88S67Tfn3ioMNwVXARbZh68B7YRoOsne3JJi
HPxmQaUfXjV4KiK66YGqLJBtnxbWPnHnR0jWVxT2LmWsie4VEsl3MQ,,&typo=1

--
This is the RPG programming on IBM i (RPG400-L) mailing list To post
a message email: RPG400-L@xxxxxxxxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit:
https://linkprotect.cudasvc.com/url?a=https%3a%2f%2flists.midrange.co
m%2fmailman%2flistinfo%2frpg400-l&c=E,1,ais2OY6iM_ZtazPkc2Ry97pIUeG3I
IeUaDZNHRz0UqMZiWXJ3bT92sFlYTXiscVi2_jMi2jGjKvehq2GJcWG8DAN41mdGott1z
dcCd-SEFs,&typo=1 or email: RPG400-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives at
https://linkprotect.cudasvc.com/url?a=https%3a%2f%2farchive.midrange.
com%2frpg400-l.&c=E,1,EcHdKgMrYkOUWCgPakVTxpNqz70pqWIlyPeoheM5huf8FPW
dvjx9ntbYbna_akyct-y5uqKa0kKNNjlg-G2SZpNm_NU8IRDK-lzORgqB&typo=1

Please contact support@xxxxxxxxxxxx for any subscription related questions.

Help support
https://linkprotect.cudasvc.com/url?a=https%3a%2f%2fmidrange.com&c=E,
1,OggeWGh_ozrwuQUbkMpN66wPU07j8JF6R5ftKSp_yaO78gjlP-GumFc_m0Rz17gJMgC
8-6GUAepNqQP6m8vskVtzy5KtTnaKl2-N9AP_-RKHQLhcDXSFsQ,,&typo=1 by
shopping at amazon.com with our affiliate link:
https://linkprotect.cudasvc.com/url?a=https%3a%2f%2famazon.midrange.c
om&c=E,1,vXNPBdyXmL2R-E001AMC7CPL3xT3DFJiuP-z_xO4_QPpiq19jWiKuexKoz6S
tKkb3_J9KvukSYumFbmi-R2daRVq8exLapapFQBMf1NHZMXtfhC2vmOWvYz4&typo=1

--
This is the RPG programming on IBM i (RPG400-L) mailing list To post a message email: RPG400-L@xxxxxxxxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit: https://linkprotect.cudasvc.com/url?a=https%3a%2f%2flists.midrange.com%2fmailman%2flistinfo%2frpg400-l&c=E,1,r18q8xofRii0E4c4XtOCdxfZCOe_gYDlEEUcK4XMs02dh46pBi0EnO76ez54itlhzR21X-G0duv2nGEiSoGD1QUSTplTljoymaOwtgbT&typo=1
or email: RPG400-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives at https://linkprotect.cudasvc.com/url?a=https%3a%2f%2farchive.midrange.com%2frpg400-l.&c=E,1,rj8DrqPecCB2jGFqk5LDh94Zryylo2y5JZqPps5k5F3zsr5amwH2JCGkdtfg4MUrUmXDF05kitZZufvh0TW0W0YPkIPiVAHESz2hwai8_yue-ROXv66CQG4,&typo=1

Please contact support@xxxxxxxxxxxx for any subscription related questions.

Help support https://linkprotect.cudasvc.com/url?a=https%3a%2f%2fmidrange.com&c=E,1,LogHIDYHKOjomQznlRDOadlKZLzfFT2kUyWRlXhTEZV2y_VuwNsCunTHKoJti4yzwpzf7XVE1G1JLL0tkyxz_qLLMZFxXDUh8xq0pXzzbg,,&typo=1 by shopping at amazon.com with our affiliate link: https://linkprotect.cudasvc.com/url?a=https%3a%2f%2famazon.midrange.com&c=E,1,gpkWaumcn-27EWtwshIJEeaYdtLp5ocjaKhmetshNuhn6Sacx_RfzpkgbKROHPM7eBk2b4UoREQ0BT5R7hIbYYsKcxLSozWSSrXrFoZX-3iQFqE76CIn&typo=1
NOTICE: This message, including any attachment, is intended as a confidential and privileged communication. If you have received this message in error, or are not the named recipient(s), please immediately notify the sender and delete this message.