Re: Problem opening Xls file in IFS -- RPG400-L

Thanks Scott - High praise coming from you.

We still use IBM Client Access 5250 - and also the newer IBM I Access Client Solutions for both Windows and MacOS and within the 5250 session we use the STRPCCMD to open the URL from within a 5250 session. Works perfectly.

We created a folder on the AS400’s web server that is cleared out every 24 hours so it’s basically a temp folder.

We got fed up with the “old” way of using shared IFS because every so often the Windows client would forget the userID/password credentials for the shared folder. In addition, I don’t like the fact of having shared folders on the AS/400 accessible by the user community. There’s really no need for it. The web-server method is so much cleaner and faster, and is client-independent. A win-win for everything!

On Mar 24, 2020, at 7:54 AM, Scott Klement <rpg400-l@xxxxxxxxxxxxxxxx> wrote:

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
http://www.scottklement.com

--
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://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/rpg400-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 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://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/rpg400-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