Re: Offline PO creation -- MAPICS-L

James,

Absolutely correct, but I was assuming (yeah, I know, I know...) that she would just use the record and playback macro functionality of Client Access, and wouldn't do any VBScript programming. I also had my CA macros log in and log out, and you can even have them scheduled. That's how I ran my system backups, IPL, and restarting everything for a while. Cool tool, and it's totally free.

But overall, ROBOT is the best solution, if you have the $$$ for it.

Dale (Cork) Gindlesperger, CPIM
Click here for my professional profile on LinkedIn

"If I'd asked my customers what they wanted, they'd have said a faster horse." - Henry Ford

________________________________
From: "LeLeux, James" <jleleux@xxxxxxxxxxx>
To: MAPICS ERP System Discussion <mapics-l@xxxxxxxxxxxx>
Sent: Wednesday, June 15, 2011 10:31 PM
Subject: Re: [MAPICS-L] Offline PO creation

Macros do a lot more than just record key strokes.

This can get you started with the VBScript aspect:
http://www.mcpressonline.com/programming/scripting/beef-up-client-access-macros-with-vbscript.html

You can create a macro to log in, run a process, log-out. So you don't have to worry about it being 'on' 24/7, or affect your backups.

I've used them with variables, external files, output files, to update data, etc. To me the key is to think VB6, not .NET. (but that's just me)
Unfortunately my macros are for 3270 mainframe (passport software), otherwise I would send you some.

For the DIY'ers in the crowd! :)

James LeLeux
IT Director: Cherry, Shur-Lok, & SPS Santa Ana
2701 South Harbor Blvd
Santa Ana, CA 92704
M   714-929-8063
SKYPE james.leleux
jleleux@xxxxxxxxxxx

-----Original Message-----
From: mapics-l-bounces@xxxxxxxxxxxx [mailto:mapics-l-bounces@xxxxxxxxxxxx] On Behalf Of Dale Gindlesperger
Sent: Wednesday, June 15, 2011 6:35 PM
To: MAPICS ERP System Discussion
Subject: Re: [MAPICS-L] Offline PO creation

Sue,

It's possible (but admittedly awkward) to use a Client Access macro to perform a function like that. I've done it, but there are NO variables available (as there are with ROBOT). All you get are recorded keystrokes, and no real way to tell if there's a problem or not. But, that being said, you CAN do it that way.

Dale (Cork) Gindlesperger, CPIM
Click here for my professional profile

"If I'd asked my customers what they wanted, they'd have said a faster horse." - Henry Ford

________________________________
From: Sue Clement <synapse@xxxxxxx>
To: mapics-l@xxxxxxxxxxxx
Sent: Wednesday, June 15, 2011 6:57 PM
Subject: [MAPICS-L] Offline PO creation

Thank you for the suggestions. I already have a program written to
populate POOFFL. If we don't have ROBOT, is there any other way to
process it automatically?

Thanks again.

Sue C. Clement
Synapse Corporation
synapse@xxxxxxx
513.683.0100

-----Original Message-----
From: mapics-l-bounces@xxxxxxxxxxxx
[mailto:mapics-l-bounces@xxxxxxxxxxxx]
On Behalf Of mapics-l-request@xxxxxxxxxxxx
Sent: Wednesday, June 15, 2011 1:00 PM
To: mapics-l@xxxxxxxxxxxx
Subject: MAPICS-L Digest, Vol 9, Issue 74

Send MAPICS-L mailing list submissions to
    mapics-l@xxxxxxxxxxxx

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

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

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

Today's Topics:

   1. Offline PO Creation question (Sue Clement)
   2. Re: Offline PO Creation question (Susan Glorioso (O'Donnell))
   3. Re: Offline PO Creation question (gogo400@xxxxxxxxx)

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

message: 1
date: Tue, 14 Jun 2011 16:55:46 -0400
from: "Sue Clement" <synapse@xxxxxxx>
subject: [MAPICS-L] Offline PO Creation question

We are staring to use the Offline PO creation feature and would like to
automate the processing. Has anyone done this? I am hoping to call a
program with the processing parms.

Thanks.

Sue C. Clement

Synapse Corporation

<mailto:synapse@xxxxxxx> synapse@xxxxxxx

513.683.0100

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

message: 2
date: Tue, 14 Jun 2011 17:11:07 -0400
from: "Susan Glorioso $O'Donnell$" <Susan.Glorioso@xxxxxxxxxxxxxxx>
subject: Re: [MAPICS-L] Offline PO Creation question

Hello! Do you mean using option 13. Create Purchase orders from
offline file on menu AM6M10? If so...here is what I did.

I wrote simple interface program to clear/populate this file (the
POOFFL file). I then used Help system's ROBOT Replay to run through
screens for option 13. ROBOT replay emulates keystrokes - we've talked
about this software in other discussions. I placed my jobs in Help
Systems ROBOT job scheduler to run in order. Once option 13 is done,
it updates the records in POOFFL and one of the fields is whether it
was able to create a release or not. I then query POOFFL and make
report of those in error; so the Business can deal with them.

If this is what you are talking about, I can give more information
about populating POOFFL - it needs just a few fields populated to do its 'thing'.

-----Original Message-----
From: mapics-l-bounces@xxxxxxxxxxxx
[mailto:mapics-l-bounces@xxxxxxxxxxxx] On Behalf Of Sue Clement
Sent: Tuesday, June 14, 2011 4:56 PM
To: mapics-l@xxxxxxxxxxxx
Subject: [MAPICS-L] Offline PO Creation question

We are staring to use the Offline PO creation feature and would like to
automate the processing. Has anyone done this? I am hoping to call a
program with the processing parms.

Thanks.

Sue C. Clement

Synapse Corporation

<mailto:synapse@xxxxxxx> synapse@xxxxxxx

513.683.0100

_______________________________________________
This is the MAPICS ERP System Discussion (MAPICS-L) mailing list To
post a message email: MAPICS-L@xxxxxxxxxxxx To subscribe, unsubscribe,
or change list options,
visit: http://lists.midrange.com/mailman/listinfo/mapics-l
or email: MAPICS-L-request@xxxxxxxxxxxx Before posting, please take a
moment to review the archives at http://archive.midrange.com/mapics-l.

The information contained in this E-mail message is intended for the
personal and confidential use of the designated
recipient(s) named above. This message and all communication contained
herein is privileged and confidential. If the reader of this message is
not the intended recipient or an agent responsible for delivering it to
the intended recipient, you are hereby notified that you have received
this E-mail message in error, and that any review, dissemination,
distribution or copying of this message is strictly prohibited. If you
have received this message in error, please notify MTD PRODUCTS INC
immediately by calling
(330) 225-2600.

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

message: 3
date: Tue, 14 Jun 2011 14:49:17 -0700
from: gogo400@xxxxxxxxx
subject: Re: [MAPICS-L] Offline PO Creation question

Sue--- Been there, you will need to write some programs to make it
happen as its more than just making a single program call UNLESS you use System-Link.

We are staring to use the Offline PO creation feature and would like
to automate the processing. Has anyone done this? I am hoping to
call a program with the processing parms.

Thanks.

Sue C. Clement

Synapse Corporation

<mailto:synapse@xxxxxxx> synapse@xxxxxxx

513.683.0100

_______________________________________________
This is the MAPICS ERP System Discussion (MAPICS-L) mailing list To
post a message email: MAPICS-L@xxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/mapics-l
or email: MAPICS-L-request@xxxxxxxxxxxx Before posting, please take a
moment to review the archives at http://archive.midrange.com/mapics-l.

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

_______________________________________________
This is the MAPICS ERP System Discussion (MAPICS-L) digest list To post
a message email: MAPICS-L@xxxxxxxxxxxx To subscribe, unsubscribe, or
change list options,
visit: http://lists.midrange.com/mailman/listinfo/mapics-l
or email: MAPICS-L-request@xxxxxxxxxxxx Before posting, please take a
moment to review the archives at http://archive.midrange.com/mapics-l.

End of MAPICS-L Digest, Vol 9, Issue 74
***************************************

_______________________________________________
This is the MAPICS ERP System Discussion (MAPICS-L) mailing list To
post a message email: MAPICS-L@xxxxxxxxxxxx To subscribe, unsubscribe,
or change list options,
visit: http://lists.midrange.com/mailman/listinfo/mapics-l
or email: MAPICS-L-request@xxxxxxxxxxxx Before posting, please take a
moment to review the archives at http://archive.midrange.com/mapics-l.

_______________________________________________
This is the MAPICS ERP System Discussion (MAPICS-L) mailing list To post a message email: MAPICS-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/mapics-l
or email: MAPICS-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives at http://archive.midrange.com/mapics-l.

_______________________________________________
This is the MAPICS ERP System Discussion (MAPICS-L) mailing list
To post a message email: MAPICS-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/mapics-l
or email: MAPICS-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/mapics-l.