Making changes in bulk

I use this method as well. I use the ABC Code table as opposed to the Company table, but same logic applies. I believe I got this little trick from Rob Bucek. Thanks again Rob.


--- In vantage@yahoogroups.com, "Kevin Simon" <ksimon@...> wrote:
>
> I don't know if you ever said what version you're on, but by one of the
> versions (it may be 9.04), you no longer need the license - it's bundled
> with the software.
>
>
>
> What I've done for one time programs, which I find a lot easier than
> compiling programs, etc, is I have a checkbox on the Company form, and I
> have a BPM that triggers when the checkbox changes and it's being run by me.
> Then, I simply insert my code in the advanced, 4GL section, open company
> maint and click the box.
>
>
>
> Kevin Simon
>
>
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
> cubcrafters_it
> Sent: Wednesday, March 23, 2011 7:06 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: Making changes in bulk
>
>
>
>
>
> Thanks! That's what I needed.
>
> I got a quote back from my CAM for $3600 + $720 maintenance for OpenEdge
> Architect (for OpenEdge 10.2a). Any idea how that differs from the Dev
> license?
>
> --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> , Jose
> Gomez <jose@> wrote:
> >
> > This si the link for the editor
> > "C:\Program Files\epicor\oe101c\bin\prowin32.exe" -db "C:\Program
> > Files\Epicor Software\Epicor904\db\Test\mfgsys.db" -S 9020 -H disraeli -N
> > TCP -Mm 1024
> >
> > This is the link for the compiler
> > "C:\Program Files\epicor\oe101c\bin\prowin32.exe" -p _comp.p -db
> > "C:\Program Files\Epicor Software\Epicor904\db\mfgsys.db" -S 9020 -H
> > disraeli -N TCP -Mm 1024
> >
> > S= DB Port
> > H Host
> > -Mm don't know what it means but its one of the parameters in the
> > mfgsys.pffile it can be 1024, 2048 or 4096 depending on your setup
> >
> > *Jose C Gomez*
> > *Software Engineer*
> > *
> > *T: 904.469.1524 mobile
> > E: jose@
> > http://www.josecgomez.com
> > <http://www.linkedin.com/in/josecgomez>
> <http://www.facebook.com/josegomez>
> > <http://www.google.com/profiles/jose.gomez> <http://www.twitter.com/joc85>
> > <http://www.josecgomez.com/professional-resume/>
> > <http://www.josecgomez.com/feed/>
> >
> > *Quis custodiet ipsos custodes?*
> >
> >
> >
> > On Wed, Mar 23, 2011 at 1:12 PM, cubcrafters_it <
> > jason.navarrete@> wrote:
> >
> > >
> > >
> > > Very good to know. I see 4GL Dev listed in my test 9.04 and 9.05
> instances,
> > > so maybe I'll poke around in there more.
> > >
> > > Next question (and apologies to Chris for hijacking his thread, but
> > > hopefully it's mutually beneficial) -- Jose, what's the link you're
> using on
> > > the desktop to start the Procedure Editor, that prompts for a password?
> I'm
> > > now calling the Procedure Editor from the OpenEdge Desktop utility, but
> it
> > > doesn't prompt to connect to a database, and I'm assuming that might be
> why
> > > I get a 'Unknown or ambiguous table Customer. (725)' error.
> > >
> > >
> > > --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
> "Carl Peterson" <cpeterson@> wrote:
> > > >
> > > > The Progress license codes are located in your Progress root directory
> -
> > > for
> > > > example, epicor\oe101b and file name is progress.cfg
> > > >
> > > > The Progress 4GL Development license, before 9.05, is a chargeable and
> > > > around the price of $1800.00 + 18% maintenance and can be purchased
> from
> > > > Epicor. You only need a single user version.
> > > >
> > > > Carl
> > > >
> > > > From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> [mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
> Behalf
> > > Of
> > > > cubcrafters_it
> > > > Sent: Wednesday, March 23, 2011 12:32 PM
> > > > To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> > > > Subject: [Vantage] Re: Making changes in bulk
> > > >
> > > >
> > > > I don't have a link for a Procedure Editor, but I can bring one up
> with
> > > Data
> > > > Administration or something similar.
> > > >
> > > > But the only license code I got aside from the Epicor License was a
> key
> > > for
> > > > Crystal Reports.
> > > >
> > > > Any idea what the cost was to step to the 4GL dev license?
> > > >
> > > > --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> <mailto:vantage%40yahoogroups.com> , Jose
> > > > Gomez <jose@> wrote:
> > > > >
> > > > > Do you have those programs I showed on the video? On progress
> licence
> > > > codes
> > > > > one shouold say 4gl Development.
> > > > >
> > > > > *Jose C Gomez*
> > > > > *Software Engineer*
> > > > > *
> > > > > *T: 904.469.1524 mobile
> > > > > E: jose@
> > > > > http://www.josecgomez.com
> > > > > <http://www.linkedin.com/in/josecgomez>
> > > > <http://www.facebook.com/josegomez>
> > > > > <http://www.google.com/profiles/jose.gomez> <
> > > http://www.twitter.com/joc85>
> > > > > <http://www.josecgomez.com/professional-resume/>
> > > > > <http://www.josecgomez.com/feed/>
> > > > >
> > > > > *Quis custodiet ipsos custodes?*
> > > > >
> > > > >
> > > > >
> > > > > On Wed, Mar 23, 2011 at 12:08 PM, cubcrafters_it <
> > > > > jason.navarrete@> wrote:
> > > > >
> > > > > >
> > > > > >
> > > > > > How do you tell if you have the Progress Development License?
> > > > > >
> > > > > >
> > > > > > --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> <mailto:vantage%40yahoogroups.com> ,
> > > Jose
> > > > Gomez <jose@> wrote:
> > > > > > >
> > > > > > > Sure,
> > > > > > >
> > > > > > > Do you have the Progress Development Licence?? if so, simply go
> to
> > > > your
> > > > > > > server
> > > > > > >
> > > > > > > Open your Epicor Admin Tools
> > > > > > > Go to Run Progress Editor
> > > > > > >
> > > > > > > There write a progress query that will accomplish what you want
> for
> > > > > > example
> > > > > > >
> > > > > > > for each jobMethod where jobMethod.Company="YOUR COMPANY":
> > > > > > > Assign jobMethod.FieldName = "New Value".
> > > > > > > end.
> > > > > > >
> > > > > > > Save your file
> > > > > > >
> > > > > > > Go to the Application Compiler under Start -> Open Edge
> > > > > > >
> > > > > > > Load your file and compile it, if it compiles without problem
> > > > > > >
> > > > > > > Then go back to Epicor Admin Tools and this time Click Run
> Progress
> > > > > > Program
> > > > > > >
> > > > > > > Load your compiled file and run it.
> > > > > > >
> > > > > > > As a disclaimer do this in test first and make sure it does what
> > > you
> > > > > > want.
> > > > > > > I'll try to put together a video tutorial for you if I have time
> in
> > > a
> > > > few
> > > > > > > minutes.
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > > > *Jose C Gomez*
> > > > > > > *Software Engineer*
> > > > > > > *
> > > > > > > *T: 904.469.1524 mobile
> > > > > > > E: jose@
> > > > > >
> > > > > > > http://www.josecgomez.com
> > > > > > > <http://www.linkedin.com/in/josecgomez> <
> > > > > > http://www.facebook.com/josegomez>
> > > > > > > <http://www.google.com/profiles/jose.gomez> <
> > > > > > http://www.twitter.com/joc85>
> > > > > > > <http://www.josecgomez.com/professional-resume/>
> > > > > > > <http://www.josecgomez.com/feed/>
> > > > > > >
> > > > > > > *Quis custodiet ipsos custodes?*
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > > > On Wed, Mar 23, 2011 at 9:59 AM, Chris Thompson <chriselectrix@
> > > > > > ...>wrote:
> > > > > >
> > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > > > We are progress.
> > > > > > > >
> > > > > > > > I have no idea how to do what you've just said.
> > > > > > > >
> > > > > > > > Would you mind giving me a few pointers?
> > > > > > > >
> > > > > > > > ________________________________
> > > > > > > > From: Jose Gomez <jose@>
> > > > > >
> > > > > > > > To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> <mailto:vantage%40yahoogroups.com>
> > > > > > > > Sent: Wed, 23 March, 2011 13:55:48
> > > > > > > > Subject: Re: [Vantage] Making changes in bulk
> > > > > > > >
> > > > > > > >
> > > > > > > > Progress or SQL?
> > > > > > > >
> > > > > > > > if so write a Procedure for either and run it. (Easiest I can
> > > think)
> > > > > > > >
> > > > > > > > *Jose C Gomez*
> > > > > > > > *Software Engineer*
> > > > > > > > *
> > > > > > > > *T: 904.469.1524 mobile
> > > > > > > > E: jose@
> > > > > >
> > > > > > > > http://www.josecgomez.com
> > > > > > > > <http://www.linkedin.com/in/josecgomez> <
> > > > > > > > http://www.facebook.com/josegomez>
> > > > > > > > <http://www.google.com/profiles/jose.gomez> <
> > > > > > > > http://www.twitter.com/joc85>
> > > > > > > > <http://www.josecgomez.com/professional-resume/>
> > > > > > > > <http://www.josecgomez.com/feed/>
> > > > > > > >
> > > > > > > > *Quis custodiet ipsos custodes?*
> > > > > > > >
> > > > > > > >
> > > > > > > > On Wed, Mar 23, 2011 at 9:39 AM, Chris Thompson
> <chriselectrix@
> > > > > >
> > > > > > > > >wrote:
> > > > > > > >
> > > > > > > > >
> > > > > > > > >
> > > > > > > > > Hi All
> > > > > > > > >
> > > > > > > > > We need to make changes in bulk to hundreds of job methods.
> > > > > > > > >
> > > > > > > > > We need to change a /LID to -LID.
> > > > > > > > >
> > > > > > > > > Is there any EASY way to do this?
> > > > > > > > >
> > > > > > > > > [Non-text portions of this message have been removed]
> > > > > > > > >
> > > > > > > > >
> > > > > > > > >
> > > > > > > >
> > > > > > > > [Non-text portions of this message have been removed]
> > > > > > > >
> > > > > > > > ------------------------------------
> > > > > > > >
> > > > > > > >
> > > > > > > > Useful links for the Yahoo!Groups Vantage Board are: ( Note:
> You
> > > > must
> > > > > > have
> > > > > > > >
> > > > > > > > already linked your email address to a yahoo id to enable
> access.
> > > )
> > > > > > > > (1) To access the Files Section of our Yahoo!Group for Report
> > > > Builder
> > > > > > and
> > > > > > > > Crystal Reports and other 'goodies', please goto:
> > > > > > > > http://groups.yahoo.com/group/vantage/files/.
> <http://groups.yahoo.com/group/vantage/files/>
> > > > <http://groups.yahoo.com/group/vantage/files/>
> > > > > > > >
> > > > > > > > (2) To search through old msg's goto:
> > > > > > > > http://groups.yahoo.com/group/vantage/messages
> > > > > > > > (3) To view links to Vendors that provide Vantage services
> goto:
> > > > > > > > http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
> > > > > > > >
> > > > > > > >
> > > > > > > > [Non-text portions of this message have been removed]
> > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > >
> > > > > > >
> > > > > > > [Non-text portions of this message have been removed]
> > > > > > >
> > > > > >
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > > > [Non-text portions of this message have been removed]
> > > > >
> > > >
> > > >
> > > >
> > > > [Non-text portions of this message have been removed]
> > > >
> > >
> > >
> > >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
Hi All

We need to make changes in bulk to hundreds of job methods.

We need to change a /LID to -LID.

Is there any EASY way to do this?




[Non-text portions of this message have been removed]
Progress or SQL?

if so write a Procedure for either and run it. (Easiest I can think)

*Jose C Gomez*
*Software Engineer*
*
*T: 904.469.1524 mobile
E: jose@...
http://www.josecgomez.com
<http://www.linkedin.com/in/josecgomez> <http://www.facebook.com/josegomez>
<http://www.google.com/profiles/jose.gomez> <http://www.twitter.com/joc85>
<http://www.josecgomez.com/professional-resume/>
<http://www.josecgomez.com/feed/>

*Quis custodiet ipsos custodes?*



On Wed, Mar 23, 2011 at 9:39 AM, Chris Thompson <chriselectrix@...>wrote:

>
>
> Hi All
>
> We need to make changes in bulk to hundreds of job methods.
>
> We need to change a /LID to -LID.
>
> Is there any EASY way to do this?
>
> [Non-text portions of this message have been removed]
>
>
>


[Non-text portions of this message have been removed]
We are progress.

I have no idea how to do what you've just said.

Would you mind giving me a few pointers?



________________________________
From: Jose Gomez <jose@...>
To: vantage@yahoogroups.com
Sent: Wed, 23 March, 2011 13:55:48
Subject: Re: [Vantage] Making changes in bulk

Progress or SQL?

if so write a Procedure for either and run it. (Easiest I can think)

*Jose C Gomez*
*Software Engineer*
*
*T: 904.469.1524 mobile
E: jose@...
http://www.josecgomez.com
<http://www.linkedin.com/in/josecgomez>Â <http://www.facebook.com/josegomez>
 <http://www.google.com/profiles/jose.gomez> <http://www.twitter.com/joc85>
 <http://www.josecgomez.com/professional-resume/>
<http://www.josecgomez.com/feed/>

*Quis custodiet ipsos custodes?*



On Wed, Mar 23, 2011 at 9:39 AM, Chris Thompson <chriselectrix@...>wrote:

>
>
> Hi All
>
> We need to make changes in bulk to hundreds of job methods.
>
> We need to change a /LID to -LID.
>
> Is there any EASY way to do this?
>
> [Non-text portions of this message have been removed]
>

>


[Non-text portions of this message have been removed]



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

Useful links for the Yahoo!Groups Vantage Board are: ( Note:Â You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.%c2%a0

(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links






[Non-text portions of this message have been removed]
Sure,

Do you have the Progress Development Licence?? if so, simply go to your
server

Open your Epicor Admin Tools
Go to Run Progress Editor

There write a progress query that will accomplish what you want for example

for each jobMethod where jobMethod.Company="YOUR COMPANY":
Assign jobMethod.FieldName = "New Value".
end.

Save your file

Go to the Application Compiler under Start -> Open Edge

Load your file and compile it, if it compiles without problem

Then go back to Epicor Admin Tools and this time Click Run Progress Program

Load your compiled file and run it.

As a disclaimer do this in test first and make sure it does what you want.
I'll try to put together a video tutorial for you if I have time in a few
minutes.




*Jose C Gomez*
*Software Engineer*
*
*T: 904.469.1524 mobile
E: jose@...
http://www.josecgomez.com
<http://www.linkedin.com/in/josecgomez> <http://www.facebook.com/josegomez>
<http://www.google.com/profiles/jose.gomez> <http://www.twitter.com/joc85>
<http://www.josecgomez.com/professional-resume/>
<http://www.josecgomez.com/feed/>

*Quis custodiet ipsos custodes?*



On Wed, Mar 23, 2011 at 9:59 AM, Chris Thompson <chriselectrix@...>wrote:

>
>
> We are progress.
>
> I have no idea how to do what you've just said.
>
> Would you mind giving me a few pointers?
>
> ________________________________
> From: Jose Gomez <jose@...>
> To: vantage@yahoogroups.com
> Sent: Wed, 23 March, 2011 13:55:48
> Subject: Re: [Vantage] Making changes in bulk
>
>
> Progress or SQL?
>
> if so write a Procedure for either and run it. (Easiest I can think)
>
> *Jose C Gomez*
> *Software Engineer*
> *
> *T: 904.469.1524 mobile
> E: jose@...
> http://www.josecgomez.com
> <http://www.linkedin.com/in/josecgomez> <
> http://www.facebook.com/josegomez>
> <http://www.google.com/profiles/jose.gomez> <
> http://www.twitter.com/joc85>
> <http://www.josecgomez.com/professional-resume/>
> <http://www.josecgomez.com/feed/>
>
> *Quis custodiet ipsos custodes?*
>
>
> On Wed, Mar 23, 2011 at 9:39 AM, Chris Thompson <chriselectrix@...
> >wrote:
>
> >
> >
> > Hi All
> >
> > We need to make changes in bulk to hundreds of job methods.
> >
> > We need to change a /LID to -LID.
> >
> > Is there any EASY way to do this?
> >
> > [Non-text portions of this message have been removed]
> >
> >
> >
>
> [Non-text portions of this message have been removed]
>
> ------------------------------------
>
>
> Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
>
> already linked your email address to a yahoo id to enable access. )
> (1) To access the Files Section of our Yahoo!Group for Report Builder and
> Crystal Reports and other 'goodies', please goto:
> http://groups.yahoo.com/group/vantage/files/.
>
> (2) To search through old msg's goto:
> http://groups.yahoo.com/group/vantage/messages
> (3) To view links to Vendors that provide Vantage services goto:
> http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
>
>
> [Non-text portions of this message have been removed]
>
>
>


[Non-text portions of this message have been removed]
The difficulty is, the text that needs changing is in the middle of a much
larger text section (within the same field)




________________________________
From: Jose Gomez <jose@...>
To: vantage@yahoogroups.com
Sent: Wed, 23 March, 2011 14:08:56
Subject: Re: [Vantage] Making changes in bulk

Sure,

Do you have the Progress Development Licence?? if so, simply go to your
server

Open your Epicor Admin Tools
Go to Run Progress Editor

There write a progress query that will accomplish what you want for example

for each jobMethod where jobMethod.Company="YOUR COMPANY":
Assign jobMethod.FieldName = "New Value".
end.

Save your file

Go to the Application Compiler under Start -> Open Edge

Load your file and compile it, if it compiles without problem

Then go back to Epicor Admin Tools and this time Click Run Progress Program

Load your compiled file and run it.

As a disclaimer do this in test first and make sure it does what you want.
I'll try to put together a video tutorial for you if I have time in a few
minutes.




*Jose C Gomez*
*Software Engineer*
*
*T: 904.469.1524 mobile
E: jose@...
http://www.josecgomez.com
<http://www.linkedin.com/in/josecgomez>Â <http://www.facebook.com/josegomez>
 <http://www.google.com/profiles/jose.gomez> <http://www.twitter.com/joc85>
 <http://www.josecgomez.com/professional-resume/>
<http://www.josecgomez.com/feed/>

*Quis custodiet ipsos custodes?*



On Wed, Mar 23, 2011 at 9:59 AM, Chris Thompson <chriselectrix@...>wrote:

>
>
> We are progress.
>
> I have no idea how to do what you've just said.
>
> Would you mind giving me a few pointers?
>
> ________________________________
> From: Jose Gomez <jose@...>
> To: vantage@yahoogroups.com
> Sent: Wed, 23 March, 2011 13:55:48
> Subject: Re: [Vantage] Making changes in bulk
>
>
> Progress or SQL?
>
> if so write a Procedure for either and run it. (Easiest I can think)
>
> *Jose C Gomez*
> *Software Engineer*
> *
> *T: 904.469.1524 mobile
> E: jose@...
> http://www.josecgomez.com
> <http://www.linkedin.com/in/josecgomez>Â <
> http://www.facebook.com/josegomez>
>Â <http://www.google.com/profiles/jose.gomez> <
> http://www.twitter.com/joc85>
>Â <http://www.josecgomez.com/professional-resume/>
> <http://www.josecgomez.com/feed/>
>
> *Quis custodiet ipsos custodes?*
>
>
> On Wed, Mar 23, 2011 at 9:39 AM, Chris Thompson <chriselectrix@...
> >wrote:
>
> >
> >
> > Hi All
> >
> > We need to make changes in bulk to hundreds of job methods.
> >
> > We need to change a /LID to -LID.
> >
> > Is there any EASY way to do this?
> >
> > [Non-text portions of this message have been removed]
> >
> >
> >
>
> [Non-text portions of this message have been removed]
>
> ------------------------------------
>
>
> Useful links for the Yahoo!Groups Vantage Board are: ( Note:Â You must have
>
> already linked your email address to a yahoo id to enable access. )
> (1) To access the Files Section of our Yahoo!Group for Report Builder and
> Crystal Reports and other 'goodies', please goto:
> http://groups.yahoo.com/group/vantage/files/.
>
> (2) To search through old msg's goto:
> http://groups.yahoo.com/group/vantage/messages
> (3) To view links to Vendors that provide Vantage services goto:
> http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
>
>
> [Non-text portions of this message have been removed]
>

>


[Non-text portions of this message have been removed]



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

Useful links for the Yahoo!Groups Vantage Board are: ( Note:Â You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.%c2%a0

(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links






[Non-text portions of this message have been removed]
Jose, that would be so much easier in MSSQL. :-) :-)


-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Jose Gomez
Sent: Wednesday, March 23, 2011 10:09 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Making changes in bulk

Sure,

Do you have the Progress Development Licence?? if so, simply go to your
server

Open your Epicor Admin Tools
Go to Run Progress Editor

There write a progress query that will accomplish what you want for
example

for each jobMethod where jobMethod.Company="YOUR COMPANY":
Assign jobMethod.FieldName = "New Value".
end.

Save your file

Go to the Application Compiler under Start -> Open Edge

Load your file and compile it, if it compiles without problem

Then go back to Epicor Admin Tools and this time Click Run Progress
Program

Load your compiled file and run it.

As a disclaimer do this in test first and make sure it does what you
want.
I'll try to put together a video tutorial for you if I have time in a
few
minutes.




*Jose C Gomez*
*Software Engineer*
*
*T: 904.469.1524 mobile
E: jose@...
http://www.josecgomez.com
<http://www.linkedin.com/in/josecgomez>
<http://www.facebook.com/josegomez>
<http://www.google.com/profiles/jose.gomez>
<http://www.twitter.com/joc85>
<http://www.josecgomez.com/professional-resume/>
<http://www.josecgomez.com/feed/>

*Quis custodiet ipsos custodes?*



On Wed, Mar 23, 2011 at 9:59 AM, Chris Thompson
<chriselectrix@...>wrote:

>
>
> We are progress.
>
> I have no idea how to do what you've just said.
>
> Would you mind giving me a few pointers?
>
> ________________________________
> From: Jose Gomez <jose@...>
> To: vantage@yahoogroups.com
> Sent: Wed, 23 March, 2011 13:55:48
> Subject: Re: [Vantage] Making changes in bulk
>
>
> Progress or SQL?
>
> if so write a Procedure for either and run it. (Easiest I can think)
>
> *Jose C Gomez*
> *Software Engineer*
> *
> *T: 904.469.1524 mobile
> E: jose@...
> http://www.josecgomez.com
> <http://www.linkedin.com/in/josecgomez> <
> http://www.facebook.com/josegomez>
> <http://www.google.com/profiles/jose.gomez> <
> http://www.twitter.com/joc85>
> <http://www.josecgomez.com/professional-resume/>
> <http://www.josecgomez.com/feed/>
>
> *Quis custodiet ipsos custodes?*
>
>
> On Wed, Mar 23, 2011 at 9:39 AM, Chris Thompson
<chriselectrix@...
> >wrote:
>
> >
> >
> > Hi All
> >
> > We need to make changes in bulk to hundreds of job methods.
> >
> > We need to change a /LID to -LID.
> >
> > Is there any EASY way to do this?
> >
> > [Non-text portions of this message have been removed]
> >
> >
> >
>
> [Non-text portions of this message have been removed]
>
> ------------------------------------
>
>
> Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have
>
> already linked your email address to a yahoo id to enable access. )
> (1) To access the Files Section of our Yahoo!Group for Report Builder
and
> Crystal Reports and other 'goodies', please goto:
> http://groups.yahoo.com/group/vantage/files/.
>
> (2) To search through old msg's goto:
> http://groups.yahoo.com/group/vantage/messages
> (3) To view links to Vendors that provide Vantage services goto:
> http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
>
>
> [Non-text portions of this message have been removed]
>
>
>


[Non-text portions of this message have been removed]



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

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
haha nice one Vic ;-)


You can use a find and replace function if its in the middle of other texts
for example

FOR EACH Customer WHERE Customer.CustID="9046351996":
ASSIGN
Customer.Name = Replace(Customer.Name,"Jose","Pete").
END.

*Jose C Gomez*
*Software Engineer*
*
*T: 904.469.1524 mobile
E: jose@...
http://www.josecgomez.com
<http://www.linkedin.com/in/josecgomez> <http://www.facebook.com/josegomez>
<http://www.google.com/profiles/jose.gomez> <http://www.twitter.com/joc85>
<http://www.josecgomez.com/professional-resume/>
<http://www.josecgomez.com/feed/>

*Quis custodiet ipsos custodes?*



On Wed, Mar 23, 2011 at 10:15 AM, Vic Drecchio <vic.drecchio@...>wrote:

>
>
> Jose, that would be so much easier in MSSQL. :-) :-)
>
>
> -----Original Message-----
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
> Of Jose Gomez
> Sent: Wednesday, March 23, 2011 10:09 AM
> To: vantage@yahoogroups.com
> Subject: Re: [Vantage] Making changes in bulk
>
> Sure,
>
> Do you have the Progress Development Licence?? if so, simply go to your
> server
>
> Open your Epicor Admin Tools
> Go to Run Progress Editor
>
> There write a progress query that will accomplish what you want for
> example
>
> for each jobMethod where jobMethod.Company="YOUR COMPANY":
> Assign jobMethod.FieldName = "New Value".
> end.
>
> Save your file
>
> Go to the Application Compiler under Start -> Open Edge
>
> Load your file and compile it, if it compiles without problem
>
> Then go back to Epicor Admin Tools and this time Click Run Progress
> Program
>
> Load your compiled file and run it.
>
> As a disclaimer do this in test first and make sure it does what you
> want.
> I'll try to put together a video tutorial for you if I have time in a
> few
> minutes.
>
> *Jose C Gomez*
> *Software Engineer*
> *
> *T: 904.469.1524 mobile
> E: jose@...
> http://www.josecgomez.com
> <http://www.linkedin.com/in/josecgomez>
> <http://www.facebook.com/josegomez>
> <http://www.google.com/profiles/jose.gomez>
> <http://www.twitter.com/joc85>
> <http://www.josecgomez.com/professional-resume/>
> <http://www.josecgomez.com/feed/>
>
> *Quis custodiet ipsos custodes?*
>
> On Wed, Mar 23, 2011 at 9:59 AM, Chris Thompson
> <chriselectrix@...>wrote:
>
> >
> >
> > We are progress.
> >
> > I have no idea how to do what you've just said.
> >
> > Would you mind giving me a few pointers?
> >
> > ________________________________
> > From: Jose Gomez <jose@...>
> > To: vantage@yahoogroups.com
> > Sent: Wed, 23 March, 2011 13:55:48
> > Subject: Re: [Vantage] Making changes in bulk
> >
> >
> > Progress or SQL?
> >
> > if so write a Procedure for either and run it. (Easiest I can think)
> >
> > *Jose C Gomez*
> > *Software Engineer*
> > *
> > *T: 904.469.1524 mobile
> > E: jose@...
> > http://www.josecgomez.com
> > <http://www.linkedin.com/in/josecgomez> <
> > http://www.facebook.com/josegomez>
> > <http://www.google.com/profiles/jose.gomez> <
> > http://www.twitter.com/joc85>
> > <http://www.josecgomez.com/professional-resume/>
> > <http://www.josecgomez.com/feed/>
> >
> > *Quis custodiet ipsos custodes?*
> >
> >
> > On Wed, Mar 23, 2011 at 9:39 AM, Chris Thompson
> <chriselectrix@...
> > >wrote:
> >
> > >
> > >
> > > Hi All
> > >
> > > We need to make changes in bulk to hundreds of job methods.
> > >
> > > We need to change a /LID to -LID.
> > >
> > > Is there any EASY way to do this?
> > >
> > > [Non-text portions of this message have been removed]
> > >
> > >
> > >
> >
> > [Non-text portions of this message have been removed]
> >
> > ------------------------------------
> >
> >
> > Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
> have
> >
> > already linked your email address to a yahoo id to enable access. )
> > (1) To access the Files Section of our Yahoo!Group for Report Builder
> and
> > Crystal Reports and other 'goodies', please goto:
> > http://groups.yahoo.com/group/vantage/files/.
> >
> > (2) To search through old msg's goto:
> > http://groups.yahoo.com/group/vantage/messages
> > (3) To view links to Vendors that provide Vantage services goto:
> > http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
> >
> >
> > [Non-text portions of this message have been removed]
> >
> >
> >
>
> [Non-text portions of this message have been removed]
>
> ------------------------------------
>
> Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
> have already linked your email address to a yahoo id to enable access. )
> (1) To access the Files Section of our Yahoo!Group for Report Builder
> and Crystal Reports and other 'goodies', please goto:
> http://groups.yahoo.com/group/vantage/files/.
> (2) To search through old msg's goto:
> http://groups.yahoo.com/group/vantage/messages
> (3) To view links to Vendors that provide Vantage services goto:
> http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
>
>
>


[Non-text portions of this message have been removed]
Here is a Quick video tutorial I threw together, its kinda fast so watch
several times if you need(it may take a few minitues to be available as it
is processing. Chage the resolution to HD so that you can see better.

Again here goes the disclaimer

*If you break your DB and or destroy the world I am not responsible! I am
letting you know how to do it, but I can in no way be liable for what the
code you write will do. Make sure you run it in test first,*

http://www.youtube.com/watch?v=4Dv295qg3FY



*Jose C Gomez*
*Software Engineer*
*
*T: 904.469.1524 mobile
E: jose@...
http://www.josecgomez.com
<http://www.linkedin.com/in/josecgomez> <http://www.facebook.com/josegomez>
<http://www.google.com/profiles/jose.gomez> <http://www.twitter.com/joc85>
<http://www.josecgomez.com/professional-resume/>
<http://www.josecgomez.com/feed/>

*Quis custodiet ipsos custodes?*



On Wed, Mar 23, 2011 at 10:22 AM, Jose Gomez <jose@...> wrote:

> haha nice one Vic ;-)
>
>
> You can use a find and replace function if its in the middle of other texts
> for example
>
> FOR EACH Customer WHERE Customer.CustID="9046351996":
> ASSIGN
> Customer.Name = Replace(Customer.Name,"Jose","Pete").
> END.
>
> *Jose C Gomez*
> *Software Engineer*
> *
> *T: 904.469.1524 mobile
> E: jose@...
> http://www.josecgomez.com
> <http://www.linkedin.com/in/josecgomez> <http://www.facebook.com/josegomez>
> <http://www.google.com/profiles/jose.gomez> <http://www.twitter.com/joc85>
> <http://www.josecgomez.com/professional-resume/> <http://www.josecgomez.com/feed/>
>
> *Quis custodiet ipsos custodes?*
>
>
>
> On Wed, Mar 23, 2011 at 10:15 AM, Vic Drecchio <vic.drecchio@...>wrote:
>
>>
>>
>> Jose, that would be so much easier in MSSQL. :-) :-)
>>
>>
>> -----Original Message-----
>> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
>> Of Jose Gomez
>> Sent: Wednesday, March 23, 2011 10:09 AM
>> To: vantage@yahoogroups.com
>> Subject: Re: [Vantage] Making changes in bulk
>>
>> Sure,
>>
>> Do you have the Progress Development Licence?? if so, simply go to your
>> server
>>
>> Open your Epicor Admin Tools
>> Go to Run Progress Editor
>>
>> There write a progress query that will accomplish what you want for
>> example
>>
>> for each jobMethod where jobMethod.Company="YOUR COMPANY":
>> Assign jobMethod.FieldName = "New Value".
>> end.
>>
>> Save your file
>>
>> Go to the Application Compiler under Start -> Open Edge
>>
>> Load your file and compile it, if it compiles without problem
>>
>> Then go back to Epicor Admin Tools and this time Click Run Progress
>> Program
>>
>> Load your compiled file and run it.
>>
>> As a disclaimer do this in test first and make sure it does what you
>> want.
>> I'll try to put together a video tutorial for you if I have time in a
>> few
>> minutes.
>>
>> *Jose C Gomez*
>> *Software Engineer*
>> *
>> *T: 904.469.1524 mobile
>> E: jose@...
>> http://www.josecgomez.com
>> <http://www.linkedin.com/in/josecgomez>
>> <http://www.facebook.com/josegomez>
>> <http://www.google.com/profiles/jose.gomez>
>> <http://www.twitter.com/joc85>
>> <http://www.josecgomez.com/professional-resume/>
>> <http://www.josecgomez.com/feed/>
>>
>> *Quis custodiet ipsos custodes?*
>>
>> On Wed, Mar 23, 2011 at 9:59 AM, Chris Thompson
>> <chriselectrix@...>wrote:
>>
>> >
>> >
>> > We are progress.
>> >
>> > I have no idea how to do what you've just said.
>> >
>> > Would you mind giving me a few pointers?
>> >
>> > ________________________________
>> > From: Jose Gomez <jose@...>
>> > To: vantage@yahoogroups.com
>> > Sent: Wed, 23 March, 2011 13:55:48
>> > Subject: Re: [Vantage] Making changes in bulk
>> >
>> >
>> > Progress or SQL?
>> >
>> > if so write a Procedure for either and run it. (Easiest I can think)
>> >
>> > *Jose C Gomez*
>> > *Software Engineer*
>> > *
>> > *T: 904.469.1524 mobile
>> > E: jose@...
>> > http://www.josecgomez.com
>> > <http://www.linkedin.com/in/josecgomez> <
>> > http://www.facebook.com/josegomez>
>> > <http://www.google.com/profiles/jose.gomez> <
>> > http://www.twitter.com/joc85>
>> > <http://www.josecgomez.com/professional-resume/>
>> > <http://www.josecgomez.com/feed/>
>> >
>> > *Quis custodiet ipsos custodes?*
>> >
>> >
>> > On Wed, Mar 23, 2011 at 9:39 AM, Chris Thompson
>> <chriselectrix@...
>> > >wrote:
>> >
>> > >
>> > >
>> > > Hi All
>> > >
>> > > We need to make changes in bulk to hundreds of job methods.
>> > >
>> > > We need to change a /LID to -LID.
>> > >
>> > > Is there any EASY way to do this?
>> > >
>> > > [Non-text portions of this message have been removed]
>> > >
>> > >
>> > >
>> >
>> > [Non-text portions of this message have been removed]
>> >
>> > ------------------------------------
>> >
>> >
>> > Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
>> have
>> >
>> > already linked your email address to a yahoo id to enable access. )
>> > (1) To access the Files Section of our Yahoo!Group for Report Builder
>> and
>> > Crystal Reports and other 'goodies', please goto:
>> > http://groups.yahoo.com/group/vantage/files/.
>> >
>> > (2) To search through old msg's goto:
>> > http://groups.yahoo.com/group/vantage/messages
>> > (3) To view links to Vendors that provide Vantage services goto:
>> > http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
>> >
>> >
>> > [Non-text portions of this message have been removed]
>> >
>> >
>> >
>>
>> [Non-text portions of this message have been removed]
>>
>> ------------------------------------
>>
>> Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
>> have already linked your email address to a yahoo id to enable access. )
>> (1) To access the Files Section of our Yahoo!Group for Report Builder
>> and Crystal Reports and other 'goodies', please goto:
>> http://groups.yahoo.com/group/vantage/files/.
>> (2) To search through old msg's goto:
>> http://groups.yahoo.com/group/vantage/messages
>> (3) To view links to Vendors that provide Vantage services goto:
>> http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
>>
>>
>>
>
>


[Non-text portions of this message have been removed]
How do you tell if you have the Progress Development License?

--- In vantage@yahoogroups.com, Jose Gomez <jose@...> wrote:
>
> Sure,
>
> Do you have the Progress Development Licence?? if so, simply go to your
> server
>
> Open your Epicor Admin Tools
> Go to Run Progress Editor
>
> There write a progress query that will accomplish what you want for example
>
> for each jobMethod where jobMethod.Company="YOUR COMPANY":
> Assign jobMethod.FieldName = "New Value".
> end.
>
> Save your file
>
> Go to the Application Compiler under Start -> Open Edge
>
> Load your file and compile it, if it compiles without problem
>
> Then go back to Epicor Admin Tools and this time Click Run Progress Program
>
> Load your compiled file and run it.
>
> As a disclaimer do this in test first and make sure it does what you want.
> I'll try to put together a video tutorial for you if I have time in a few
> minutes.
>
>
>
>
> *Jose C Gomez*
> *Software Engineer*
> *
> *T: 904.469.1524 mobile
> E: jose@...
> http://www.josecgomez.com
> <http://www.linkedin.com/in/josecgomez> <http://www.facebook.com/josegomez>
> <http://www.google.com/profiles/jose.gomez> <http://www.twitter.com/joc85>
> <http://www.josecgomez.com/professional-resume/>
> <http://www.josecgomez.com/feed/>
>
> *Quis custodiet ipsos custodes?*
>
>
>
> On Wed, Mar 23, 2011 at 9:59 AM, Chris Thompson <chriselectrix@...>wrote:
>
> >
> >
> > We are progress.
> >
> > I have no idea how to do what you've just said.
> >
> > Would you mind giving me a few pointers?
> >
> > ________________________________
> > From: Jose Gomez <jose@...>
> > To: vantage@yahoogroups.com
> > Sent: Wed, 23 March, 2011 13:55:48
> > Subject: Re: [Vantage] Making changes in bulk
> >
> >
> > Progress or SQL?
> >
> > if so write a Procedure for either and run it. (Easiest I can think)
> >
> > *Jose C Gomez*
> > *Software Engineer*
> > *
> > *T: 904.469.1524 mobile
> > E: jose@...
> > http://www.josecgomez.com
> > <http://www.linkedin.com/in/josecgomez> <
> > http://www.facebook.com/josegomez>
> > <http://www.google.com/profiles/jose.gomez> <
> > http://www.twitter.com/joc85>
> > <http://www.josecgomez.com/professional-resume/>
> > <http://www.josecgomez.com/feed/>
> >
> > *Quis custodiet ipsos custodes?*
> >
> >
> > On Wed, Mar 23, 2011 at 9:39 AM, Chris Thompson <chriselectrix@...
> > >wrote:
> >
> > >
> > >
> > > Hi All
> > >
> > > We need to make changes in bulk to hundreds of job methods.
> > >
> > > We need to change a /LID to -LID.
> > >
> > > Is there any EASY way to do this?
> > >
> > > [Non-text portions of this message have been removed]
> > >
> > >
> > >
> >
> > [Non-text portions of this message have been removed]
> >
> > ------------------------------------
> >
> >
> > Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
> >
> > already linked your email address to a yahoo id to enable access. )
> > (1) To access the Files Section of our Yahoo!Group for Report Builder and
> > Crystal Reports and other 'goodies', please goto:
> > http://groups.yahoo.com/group/vantage/files/.
> >
> > (2) To search through old msg's goto:
> > http://groups.yahoo.com/group/vantage/messages
> > (3) To view links to Vendors that provide Vantage services goto:
> > http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
> >
> >
> > [Non-text portions of this message have been removed]
> >
> >
> >
>
>
> [Non-text portions of this message have been removed]
>
Do you have those programs I showed on the video? On progress licence codes
one shouold say 4gl Development.

*Jose C Gomez*
*Software Engineer*
*
*T: 904.469.1524 mobile
E: jose@...
http://www.josecgomez.com
<http://www.linkedin.com/in/josecgomez> <http://www.facebook.com/josegomez>
<http://www.google.com/profiles/jose.gomez> <http://www.twitter.com/joc85>
<http://www.josecgomez.com/professional-resume/>
<http://www.josecgomez.com/feed/>

*Quis custodiet ipsos custodes?*



On Wed, Mar 23, 2011 at 12:08 PM, cubcrafters_it <
jason.navarrete@...> wrote:

>
>
> How do you tell if you have the Progress Development License?
>
>
> --- In vantage@yahoogroups.com, Jose Gomez <jose@...> wrote:
> >
> > Sure,
> >
> > Do you have the Progress Development Licence?? if so, simply go to your
> > server
> >
> > Open your Epicor Admin Tools
> > Go to Run Progress Editor
> >
> > There write a progress query that will accomplish what you want for
> example
> >
> > for each jobMethod where jobMethod.Company="YOUR COMPANY":
> > Assign jobMethod.FieldName = "New Value".
> > end.
> >
> > Save your file
> >
> > Go to the Application Compiler under Start -> Open Edge
> >
> > Load your file and compile it, if it compiles without problem
> >
> > Then go back to Epicor Admin Tools and this time Click Run Progress
> Program
> >
> > Load your compiled file and run it.
> >
> > As a disclaimer do this in test first and make sure it does what you
> want.
> > I'll try to put together a video tutorial for you if I have time in a few
> > minutes.
> >
> >
> >
> >
> > *Jose C Gomez*
> > *Software Engineer*
> > *
> > *T: 904.469.1524 mobile
> > E: jose@...
>
> > http://www.josecgomez.com
> > <http://www.linkedin.com/in/josecgomez> <
> http://www.facebook.com/josegomez>
> > <http://www.google.com/profiles/jose.gomez> <
> http://www.twitter.com/joc85>
> > <http://www.josecgomez.com/professional-resume/>
> > <http://www.josecgomez.com/feed/>
> >
> > *Quis custodiet ipsos custodes?*
> >
> >
> >
> > On Wed, Mar 23, 2011 at 9:59 AM, Chris Thompson <chriselectrix@
> ...>wrote:
>
> >
> > >
> > >
> > > We are progress.
> > >
> > > I have no idea how to do what you've just said.
> > >
> > > Would you mind giving me a few pointers?
> > >
> > > ________________________________
> > > From: Jose Gomez <jose@...>
>
> > > To: vantage@yahoogroups.com
> > > Sent: Wed, 23 March, 2011 13:55:48
> > > Subject: Re: [Vantage] Making changes in bulk
> > >
> > >
> > > Progress or SQL?
> > >
> > > if so write a Procedure for either and run it. (Easiest I can think)
> > >
> > > *Jose C Gomez*
> > > *Software Engineer*
> > > *
> > > *T: 904.469.1524 mobile
> > > E: jose@...
>
> > > http://www.josecgomez.com
> > > <http://www.linkedin.com/in/josecgomez> <
> > > http://www.facebook.com/josegomez>
> > > <http://www.google.com/profiles/jose.gomez> <
> > > http://www.twitter.com/joc85>
> > > <http://www.josecgomez.com/professional-resume/>
> > > <http://www.josecgomez.com/feed/>
> > >
> > > *Quis custodiet ipsos custodes?*
> > >
> > >
> > > On Wed, Mar 23, 2011 at 9:39 AM, Chris Thompson <chriselectrix@...
>
> > > >wrote:
> > >
> > > >
> > > >
> > > > Hi All
> > > >
> > > > We need to make changes in bulk to hundreds of job methods.
> > > >
> > > > We need to change a /LID to -LID.
> > > >
> > > > Is there any EASY way to do this?
> > > >
> > > > [Non-text portions of this message have been removed]
> > > >
> > > >
> > > >
> > >
> > > [Non-text portions of this message have been removed]
> > >
> > > ------------------------------------
> > >
> > >
> > > Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
> have
> > >
> > > already linked your email address to a yahoo id to enable access. )
> > > (1) To access the Files Section of our Yahoo!Group for Report Builder
> and
> > > Crystal Reports and other 'goodies', please goto:
> > > http://groups.yahoo.com/group/vantage/files/.
> > >
> > > (2) To search through old msg's goto:
> > > http://groups.yahoo.com/group/vantage/messages
> > > (3) To view links to Vendors that provide Vantage services goto:
> > > http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
> > >
> > >
> > > [Non-text portions of this message have been removed]
> > >
> > >
> > >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
>
>


[Non-text portions of this message have been removed]
I don't have a link for a Procedure Editor, but I can bring one up with Data Administration or something similar.

But the only license code I got aside from the Epicor License was a key for Crystal Reports.

Any idea what the cost was to step to the 4GL dev license?

--- In vantage@yahoogroups.com, Jose Gomez <jose@...> wrote:
>
> Do you have those programs I showed on the video? On progress licence codes
> one shouold say 4gl Development.
>
> *Jose C Gomez*
> *Software Engineer*
> *
> *T: 904.469.1524 mobile
> E: jose@...
> http://www.josecgomez.com
> <http://www.linkedin.com/in/josecgomez> <http://www.facebook.com/josegomez>
> <http://www.google.com/profiles/jose.gomez> <http://www.twitter.com/joc85>
> <http://www.josecgomez.com/professional-resume/>
> <http://www.josecgomez.com/feed/>
>
> *Quis custodiet ipsos custodes?*
>
>
>
> On Wed, Mar 23, 2011 at 12:08 PM, cubcrafters_it <
> jason.navarrete@...> wrote:
>
> >
> >
> > How do you tell if you have the Progress Development License?
> >
> >
> > --- In vantage@yahoogroups.com, Jose Gomez <jose@> wrote:
> > >
> > > Sure,
> > >
> > > Do you have the Progress Development Licence?? if so, simply go to your
> > > server
> > >
> > > Open your Epicor Admin Tools
> > > Go to Run Progress Editor
> > >
> > > There write a progress query that will accomplish what you want for
> > example
> > >
> > > for each jobMethod where jobMethod.Company="YOUR COMPANY":
> > > Assign jobMethod.FieldName = "New Value".
> > > end.
> > >
> > > Save your file
> > >
> > > Go to the Application Compiler under Start -> Open Edge
> > >
> > > Load your file and compile it, if it compiles without problem
> > >
> > > Then go back to Epicor Admin Tools and this time Click Run Progress
> > Program
> > >
> > > Load your compiled file and run it.
> > >
> > > As a disclaimer do this in test first and make sure it does what you
> > want.
> > > I'll try to put together a video tutorial for you if I have time in a few
> > > minutes.
> > >
> > >
> > >
> > >
> > > *Jose C Gomez*
> > > *Software Engineer*
> > > *
> > > *T: 904.469.1524 mobile
> > > E: jose@
> >
> > > http://www.josecgomez.com
> > > <http://www.linkedin.com/in/josecgomez> <
> > http://www.facebook.com/josegomez>
> > > <http://www.google.com/profiles/jose.gomez> <
> > http://www.twitter.com/joc85>
> > > <http://www.josecgomez.com/professional-resume/>
> > > <http://www.josecgomez.com/feed/>
> > >
> > > *Quis custodiet ipsos custodes?*
> > >
> > >
> > >
> > > On Wed, Mar 23, 2011 at 9:59 AM, Chris Thompson <chriselectrix@
> > ...>wrote:
> >
> > >
> > > >
> > > >
> > > > We are progress.
> > > >
> > > > I have no idea how to do what you've just said.
> > > >
> > > > Would you mind giving me a few pointers?
> > > >
> > > > ________________________________
> > > > From: Jose Gomez <jose@>
> >
> > > > To: vantage@yahoogroups.com
> > > > Sent: Wed, 23 March, 2011 13:55:48
> > > > Subject: Re: [Vantage] Making changes in bulk
> > > >
> > > >
> > > > Progress or SQL?
> > > >
> > > > if so write a Procedure for either and run it. (Easiest I can think)
> > > >
> > > > *Jose C Gomez*
> > > > *Software Engineer*
> > > > *
> > > > *T: 904.469.1524 mobile
> > > > E: jose@
> >
> > > > http://www.josecgomez.com
> > > > <http://www.linkedin.com/in/josecgomez> <
> > > > http://www.facebook.com/josegomez>
> > > > <http://www.google.com/profiles/jose.gomez> <
> > > > http://www.twitter.com/joc85>
> > > > <http://www.josecgomez.com/professional-resume/>
> > > > <http://www.josecgomez.com/feed/>
> > > >
> > > > *Quis custodiet ipsos custodes?*
> > > >
> > > >
> > > > On Wed, Mar 23, 2011 at 9:39 AM, Chris Thompson <chriselectrix@
> >
> > > > >wrote:
> > > >
> > > > >
> > > > >
> > > > > Hi All
> > > > >
> > > > > We need to make changes in bulk to hundreds of job methods.
> > > > >
> > > > > We need to change a /LID to -LID.
> > > > >
> > > > > Is there any EASY way to do this?
> > > > >
> > > > > [Non-text portions of this message have been removed]
> > > > >
> > > > >
> > > > >
> > > >
> > > > [Non-text portions of this message have been removed]
> > > >
> > > > ------------------------------------
> > > >
> > > >
> > > > Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
> > have
> > > >
> > > > already linked your email address to a yahoo id to enable access. )
> > > > (1) To access the Files Section of our Yahoo!Group for Report Builder
> > and
> > > > Crystal Reports and other 'goodies', please goto:
> > > > http://groups.yahoo.com/group/vantage/files/.
> > > >
> > > > (2) To search through old msg's goto:
> > > > http://groups.yahoo.com/group/vantage/messages
> > > > (3) To view links to Vendors that provide Vantage services goto:
> > > > http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
> > > >
> > > >
> > > > [Non-text portions of this message have been removed]
> > > >
> > > >
> > > >
> > >
> > >
> > > [Non-text portions of this message have been removed]
> > >
> >
> >
> >
>
>
> [Non-text portions of this message have been removed]
>
Not sure what the cost was. You don't have a list of progress license
codes/?

Sent from mobile
On Mar 23, 2011 12:32 PM, "cubcrafters_it" <jason.navarrete@...>
wrote:
> I don't have a link for a Procedure Editor, but I can bring one up with
Data Administration or something similar.
>
> But the only license code I got aside from the Epicor License was a key
for Crystal Reports.
>
> Any idea what the cost was to step to the 4GL dev license?
>
> --- In vantage@yahoogroups.com, Jose Gomez <jose@...> wrote:
>>
>> Do you have those programs I showed on the video? On progress licence
codes
>> one shouold say 4gl Development.
>>
>> *Jose C Gomez*
>> *Software Engineer*
>> *
>> *T: 904.469.1524 mobile
>> E: jose@...
>> http://www.josecgomez.com
>> <http://www.linkedin.com/in/josecgomez> <
http://www.facebook.com/josegomez>
>> <http://www.google.com/profiles/jose.gomez> <http://www.twitter.com/joc85
>
>> <http://www.josecgomez.com/professional-resume/>
>> <http://www.josecgomez.com/feed/>
>>
>> *Quis custodiet ipsos custodes?*
>>
>>
>>
>> On Wed, Mar 23, 2011 at 12:08 PM, cubcrafters_it <
>> jason.navarrete@...> wrote:
>>
>> >
>> >
>> > How do you tell if you have the Progress Development License?
>> >
>> >
>> > --- In vantage@yahoogroups.com, Jose Gomez <jose@> wrote:
>> > >
>> > > Sure,
>> > >
>> > > Do you have the Progress Development Licence?? if so, simply go to
your
>> > > server
>> > >
>> > > Open your Epicor Admin Tools
>> > > Go to Run Progress Editor
>> > >
>> > > There write a progress query that will accomplish what you want for
>> > example
>> > >
>> > > for each jobMethod where jobMethod.Company="YOUR COMPANY":
>> > > Assign jobMethod.FieldName = "New Value".
>> > > end.
>> > >
>> > > Save your file
>> > >
>> > > Go to the Application Compiler under Start -> Open Edge
>> > >
>> > > Load your file and compile it, if it compiles without problem
>> > >
>> > > Then go back to Epicor Admin Tools and this time Click Run Progress
>> > Program
>> > >
>> > > Load your compiled file and run it.
>> > >
>> > > As a disclaimer do this in test first and make sure it does what you
>> > want.
>> > > I'll try to put together a video tutorial for you if I have time in a
few
>> > > minutes.
>> > >
>> > >
>> > >
>> > >
>> > > *Jose C Gomez*
>> > > *Software Engineer*
>> > > *
>> > > *T: 904.469.1524 mobile
>> > > E: jose@
>> >
>> > > http://www.josecgomez.com
>> > > <http://www.linkedin.com/in/josecgomez> <
>> > http://www.facebook.com/josegomez>
>> > > <http://www.google.com/profiles/jose.gomez> <
>> > http://www.twitter.com/joc85>
>> > > <http://www.josecgomez.com/professional-resume/>
>> > > <http://www.josecgomez.com/feed/>
>> > >
>> > > *Quis custodiet ipsos custodes?*
>> > >
>> > >
>> > >
>> > > On Wed, Mar 23, 2011 at 9:59 AM, Chris Thompson <chriselectrix@
>> > ...>wrote:
>> >
>> > >
>> > > >
>> > > >
>> > > > We are progress.
>> > > >
>> > > > I have no idea how to do what you've just said.
>> > > >
>> > > > Would you mind giving me a few pointers?
>> > > >
>> > > > ________________________________
>> > > > From: Jose Gomez <jose@>
>> >
>> > > > To: vantage@yahoogroups.com
>> > > > Sent: Wed, 23 March, 2011 13:55:48
>> > > > Subject: Re: [Vantage] Making changes in bulk
>> > > >
>> > > >
>> > > > Progress or SQL?
>> > > >
>> > > > if so write a Procedure for either and run it. (Easiest I can
think)
>> > > >
>> > > > *Jose C Gomez*
>> > > > *Software Engineer*
>> > > > *
>> > > > *T: 904.469.1524 mobile
>> > > > E: jose@
>> >
>> > > > http://www.josecgomez.com
>> > > > <http://www.linkedin.com/in/josecgomez> <
>> > > > http://www.facebook.com/josegomez>
>> > > > <http://www.google.com/profiles/jose.gomez> <
>> > > > http://www.twitter.com/joc85>
>> > > > <http://www.josecgomez.com/professional-resume/>
>> > > > <http://www.josecgomez.com/feed/>
>> > > >
>> > > > *Quis custodiet ipsos custodes?*
>> > > >
>> > > >
>> > > > On Wed, Mar 23, 2011 at 9:39 AM, Chris Thompson <chriselectrix@
>> >
>> > > > >wrote:
>> > > >
>> > > > >
>> > > > >
>> > > > > Hi All
>> > > > >
>> > > > > We need to make changes in bulk to hundreds of job methods.
>> > > > >
>> > > > > We need to change a /LID to -LID.
>> > > > >
>> > > > > Is there any EASY way to do this?
>> > > > >
>> > > > > [Non-text portions of this message have been removed]
>> > > > >
>> > > > >
>> > > > >
>> > > >
>> > > > [Non-text portions of this message have been removed]
>> > > >
>> > > > ------------------------------------
>> > > >
>> > > >
>> > > > Useful links for the Yahoo!Groups Vantage Board are: ( Note: You
must
>> > have
>> > > >
>> > > > already linked your email address to a yahoo id to enable access. )
>> > > > (1) To access the Files Section of our Yahoo!Group for Report
Builder
>> > and
>> > > > Crystal Reports and other 'goodies', please goto:
>> > > > http://groups.yahoo.com/group/vantage/files/.
>> > > >
>> > > > (2) To search through old msg's goto:
>> > > > http://groups.yahoo.com/group/vantage/messages
>> > > > (3) To view links to Vendors that provide Vantage services goto:
>> > > > http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
>> > > >
>> > > >
>> > > > [Non-text portions of this message have been removed]
>> > > >
>> > > >
>> > > >
>> > >
>> > >
>> > > [Non-text portions of this message have been removed]
>> > >
>> >
>> >
>> >
>>
>>
>> [Non-text portions of this message have been removed]
>>
>
>


[Non-text portions of this message have been removed]
The Progress license codes are located in your Progress root directory - for
example, epicor\oe101b and file name is progress.cfg

The Progress 4GL Development license, before 9.05, is a chargeable and
around the price of $1800.00 + 18% maintenance and can be purchased from
Epicor. You only need a single user version.

Carl

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
cubcrafters_it
Sent: Wednesday, March 23, 2011 12:32 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Making changes in bulk


I don't have a link for a Procedure Editor, but I can bring one up with Data
Administration or something similar.

But the only license code I got aside from the Epicor License was a key for
Crystal Reports.

Any idea what the cost was to step to the 4GL dev license?

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> , Jose
Gomez <jose@...> wrote:
>
> Do you have those programs I showed on the video? On progress licence
codes
> one shouold say 4gl Development.
>
> *Jose C Gomez*
> *Software Engineer*
> *
> *T: 904.469.1524 mobile
> E: jose@...
> http://www.josecgomez.com
> <http://www.linkedin.com/in/josecgomez>
<http://www.facebook.com/josegomez>
> <http://www.google.com/profiles/jose.gomez> <http://www.twitter.com/joc85>
> <http://www.josecgomez.com/professional-resume/>
> <http://www.josecgomez.com/feed/>
>
> *Quis custodiet ipsos custodes?*
>
>
>
> On Wed, Mar 23, 2011 at 12:08 PM, cubcrafters_it <
> jason.navarrete@...> wrote:
>
> >
> >
> > How do you tell if you have the Progress Development License?
> >
> >
> > --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> , Jose
Gomez <jose@> wrote:
> > >
> > > Sure,
> > >
> > > Do you have the Progress Development Licence?? if so, simply go to
your
> > > server
> > >
> > > Open your Epicor Admin Tools
> > > Go to Run Progress Editor
> > >
> > > There write a progress query that will accomplish what you want for
> > example
> > >
> > > for each jobMethod where jobMethod.Company="YOUR COMPANY":
> > > Assign jobMethod.FieldName = "New Value".
> > > end.
> > >
> > > Save your file
> > >
> > > Go to the Application Compiler under Start -> Open Edge
> > >
> > > Load your file and compile it, if it compiles without problem
> > >
> > > Then go back to Epicor Admin Tools and this time Click Run Progress
> > Program
> > >
> > > Load your compiled file and run it.
> > >
> > > As a disclaimer do this in test first and make sure it does what you
> > want.
> > > I'll try to put together a video tutorial for you if I have time in a
few
> > > minutes.
> > >
> > >
> > >
> > >
> > > *Jose C Gomez*
> > > *Software Engineer*
> > > *
> > > *T: 904.469.1524 mobile
> > > E: jose@
> >
> > > http://www.josecgomez.com
> > > <http://www.linkedin.com/in/josecgomez> <
> > http://www.facebook.com/josegomez>
> > > <http://www.google.com/profiles/jose.gomez> <
> > http://www.twitter.com/joc85>
> > > <http://www.josecgomez.com/professional-resume/>
> > > <http://www.josecgomez.com/feed/>
> > >
> > > *Quis custodiet ipsos custodes?*
> > >
> > >
> > >
> > > On Wed, Mar 23, 2011 at 9:59 AM, Chris Thompson <chriselectrix@
> > ...>wrote:
> >
> > >
> > > >
> > > >
> > > > We are progress.
> > > >
> > > > I have no idea how to do what you've just said.
> > > >
> > > > Would you mind giving me a few pointers?
> > > >
> > > > ________________________________
> > > > From: Jose Gomez <jose@>
> >
> > > > To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> > > > Sent: Wed, 23 March, 2011 13:55:48
> > > > Subject: Re: [Vantage] Making changes in bulk
> > > >
> > > >
> > > > Progress or SQL?
> > > >
> > > > if so write a Procedure for either and run it. (Easiest I can think)
> > > >
> > > > *Jose C Gomez*
> > > > *Software Engineer*
> > > > *
> > > > *T: 904.469.1524 mobile
> > > > E: jose@
> >
> > > > http://www.josecgomez.com
> > > > <http://www.linkedin.com/in/josecgomez> <
> > > > http://www.facebook.com/josegomez>
> > > > <http://www.google.com/profiles/jose.gomez> <
> > > > http://www.twitter.com/joc85>
> > > > <http://www.josecgomez.com/professional-resume/>
> > > > <http://www.josecgomez.com/feed/>
> > > >
> > > > *Quis custodiet ipsos custodes?*
> > > >
> > > >
> > > > On Wed, Mar 23, 2011 at 9:39 AM, Chris Thompson <chriselectrix@
> >
> > > > >wrote:
> > > >
> > > > >
> > > > >
> > > > > Hi All
> > > > >
> > > > > We need to make changes in bulk to hundreds of job methods.
> > > > >
> > > > > We need to change a /LID to -LID.
> > > > >
> > > > > Is there any EASY way to do this?
> > > > >
> > > > > [Non-text portions of this message have been removed]
> > > > >
> > > > >
> > > > >
> > > >
> > > > [Non-text portions of this message have been removed]
> > > >
> > > > ------------------------------------
> > > >
> > > >
> > > > Useful links for the Yahoo!Groups Vantage Board are: ( Note: You
must
> > have
> > > >
> > > > already linked your email address to a yahoo id to enable access. )
> > > > (1) To access the Files Section of our Yahoo!Group for Report
Builder
> > and
> > > > Crystal Reports and other 'goodies', please goto:
> > > > http://groups.yahoo.com/group/vantage/files/.
<http://groups.yahoo.com/group/vantage/files/>
> > > >
> > > > (2) To search through old msg's goto:
> > > > http://groups.yahoo.com/group/vantage/messages
> > > > (3) To view links to Vendors that provide Vantage services goto:
> > > > http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
> > > >
> > > >
> > > > [Non-text portions of this message have been removed]
> > > >
> > > >
> > > >
> > >
> > >
> > > [Non-text portions of this message have been removed]
> > >
> >
> >
> >
>
>
> [Non-text portions of this message have been removed]
>



[Non-text portions of this message have been removed]
Nope. The only Progress license codes I have are the ones from EpicWeb for the OpenEdge Management tool.

And I tried to check syntax on a test procedure and I get 'This version of PROGRESS compiles only encrypted programs. (1086).'


--- In vantage@yahoogroups.com, Jose Gomez <jose@...> wrote:
>
> Not sure what the cost was. You don't have a list of progress license
> codes/?
>
> Sent from mobile
> On Mar 23, 2011 12:32 PM, "cubcrafters_it" <jason.navarrete@...>
> wrote:
> > I don't have a link for a Procedure Editor, but I can bring one up with
> Data Administration or something similar.
> >
> > But the only license code I got aside from the Epicor License was a key
> for Crystal Reports.
> >
> > Any idea what the cost was to step to the 4GL dev license?
> >
> > --- In vantage@yahoogroups.com, Jose Gomez <jose@> wrote:
> >>
> >> Do you have those programs I showed on the video? On progress licence
> codes
> >> one shouold say 4gl Development.
> >>
> >> *Jose C Gomez*
> >> *Software Engineer*
> >> *
> >> *T: 904.469.1524 mobile
> >> E: jose@
> >> http://www.josecgomez.com
> >> <http://www.linkedin.com/in/josecgomez> <
> http://www.facebook.com/josegomez>
> >> <http://www.google.com/profiles/jose.gomez> <http://www.twitter.com/joc85
> >
> >> <http://www.josecgomez.com/professional-resume/>
> >> <http://www.josecgomez.com/feed/>
> >>
> >> *Quis custodiet ipsos custodes?*
> >>
> >>
> >>
> >> On Wed, Mar 23, 2011 at 12:08 PM, cubcrafters_it <
> >> jason.navarrete@> wrote:
> >>
> >> >
> >> >
> >> > How do you tell if you have the Progress Development License?
> >> >
> >> >
> >> > --- In vantage@yahoogroups.com, Jose Gomez <jose@> wrote:
> >> > >
> >> > > Sure,
> >> > >
> >> > > Do you have the Progress Development Licence?? if so, simply go to
> your
> >> > > server
> >> > >
> >> > > Open your Epicor Admin Tools
> >> > > Go to Run Progress Editor
> >> > >
> >> > > There write a progress query that will accomplish what you want for
> >> > example
> >> > >
> >> > > for each jobMethod where jobMethod.Company="YOUR COMPANY":
> >> > > Assign jobMethod.FieldName = "New Value".
> >> > > end.
> >> > >
> >> > > Save your file
> >> > >
> >> > > Go to the Application Compiler under Start -> Open Edge
> >> > >
> >> > > Load your file and compile it, if it compiles without problem
> >> > >
> >> > > Then go back to Epicor Admin Tools and this time Click Run Progress
> >> > Program
> >> > >
> >> > > Load your compiled file and run it.
> >> > >
> >> > > As a disclaimer do this in test first and make sure it does what you
> >> > want.
> >> > > I'll try to put together a video tutorial for you if I have time in a
> few
> >> > > minutes.
> >> > >
> >> > >
> >> > >
> >> > >
> >> > > *Jose C Gomez*
> >> > > *Software Engineer*
> >> > > *
> >> > > *T: 904.469.1524 mobile
> >> > > E: jose@
> >> >
> >> > > http://www.josecgomez.com
> >> > > <http://www.linkedin.com/in/josecgomez> <
> >> > http://www.facebook.com/josegomez>
> >> > > <http://www.google.com/profiles/jose.gomez> <
> >> > http://www.twitter.com/joc85>
> >> > > <http://www.josecgomez.com/professional-resume/>
> >> > > <http://www.josecgomez.com/feed/>
> >> > >
> >> > > *Quis custodiet ipsos custodes?*
> >> > >
> >> > >
> >> > >
> >> > > On Wed, Mar 23, 2011 at 9:59 AM, Chris Thompson <chriselectrix@
> >> > ...>wrote:
> >> >
> >> > >
> >> > > >
> >> > > >
> >> > > > We are progress.
> >> > > >
> >> > > > I have no idea how to do what you've just said.
> >> > > >
> >> > > > Would you mind giving me a few pointers?
> >> > > >
> >> > > > ________________________________
> >> > > > From: Jose Gomez <jose@>
> >> >
> >> > > > To: vantage@yahoogroups.com
> >> > > > Sent: Wed, 23 March, 2011 13:55:48
> >> > > > Subject: Re: [Vantage] Making changes in bulk
> >> > > >
> >> > > >
> >> > > > Progress or SQL?
> >> > > >
> >> > > > if so write a Procedure for either and run it. (Easiest I can
> think)
> >> > > >
> >> > > > *Jose C Gomez*
> >> > > > *Software Engineer*
> >> > > > *
> >> > > > *T: 904.469.1524 mobile
> >> > > > E: jose@
> >> >
> >> > > > http://www.josecgomez.com
> >> > > > <http://www.linkedin.com/in/josecgomez> <
> >> > > > http://www.facebook.com/josegomez>
> >> > > > <http://www.google.com/profiles/jose.gomez> <
> >> > > > http://www.twitter.com/joc85>
> >> > > > <http://www.josecgomez.com/professional-resume/>
> >> > > > <http://www.josecgomez.com/feed/>
> >> > > >
> >> > > > *Quis custodiet ipsos custodes?*
> >> > > >
> >> > > >
> >> > > > On Wed, Mar 23, 2011 at 9:39 AM, Chris Thompson <chriselectrix@
> >> >
> >> > > > >wrote:
> >> > > >
> >> > > > >
> >> > > > >
> >> > > > > Hi All
> >> > > > >
> >> > > > > We need to make changes in bulk to hundreds of job methods.
> >> > > > >
> >> > > > > We need to change a /LID to -LID.
> >> > > > >
> >> > > > > Is there any EASY way to do this?
> >> > > > >
> >> > > > > [Non-text portions of this message have been removed]
> >> > > > >
> >> > > > >
> >> > > > >
> >> > > >
> >> > > > [Non-text portions of this message have been removed]
> >> > > >
> >> > > > ------------------------------------
> >> > > >
> >> > > >
> >> > > > Useful links for the Yahoo!Groups Vantage Board are: ( Note: You
> must
> >> > have
> >> > > >
> >> > > > already linked your email address to a yahoo id to enable access. )
> >> > > > (1) To access the Files Section of our Yahoo!Group for Report
> Builder
> >> > and
> >> > > > Crystal Reports and other 'goodies', please goto:
> >> > > > http://groups.yahoo.com/group/vantage/files/.
> >> > > >
> >> > > > (2) To search through old msg's goto:
> >> > > > http://groups.yahoo.com/group/vantage/messages
> >> > > > (3) To view links to Vendors that provide Vantage services goto:
> >> > > > http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
> >> > > >
> >> > > >
> >> > > > [Non-text portions of this message have been removed]
> >> > > >
> >> > > >
> >> > > >
> >> > >
> >> > >
> >> > > [Non-text portions of this message have been removed]
> >> > >
> >> >
> >> >
> >> >
> >>
> >>
> >> [Non-text portions of this message have been removed]
> >>
> >
> >
>
>
> [Non-text portions of this message have been removed]
>
Very good to know. I see 4GL Dev listed in my test 9.04 and 9.05 instances, so maybe I'll poke around in there more.

Next question (and apologies to Chris for hijacking his thread, but hopefully it's mutually beneficial) -- Jose, what's the link you're using on the desktop to start the Procedure Editor, that prompts for a password? I'm now calling the Procedure Editor from the OpenEdge Desktop utility, but it doesn't prompt to connect to a database, and I'm assuming that might be why I get a 'Unknown or ambiguous table Customer. (725)' error.



--- In vantage@yahoogroups.com, "Carl Peterson" <cpeterson@...> wrote:
>
> The Progress license codes are located in your Progress root directory - for
> example, epicor\oe101b and file name is progress.cfg
>
> The Progress 4GL Development license, before 9.05, is a chargeable and
> around the price of $1800.00 + 18% maintenance and can be purchased from
> Epicor. You only need a single user version.
>
> Carl
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
> cubcrafters_it
> Sent: Wednesday, March 23, 2011 12:32 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: Making changes in bulk
>
>
> I don't have a link for a Procedure Editor, but I can bring one up with Data
> Administration or something similar.
>
> But the only license code I got aside from the Epicor License was a key for
> Crystal Reports.
>
> Any idea what the cost was to step to the 4GL dev license?
>
> --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> , Jose
> Gomez <jose@> wrote:
> >
> > Do you have those programs I showed on the video? On progress licence
> codes
> > one shouold say 4gl Development.
> >
> > *Jose C Gomez*
> > *Software Engineer*
> > *
> > *T: 904.469.1524 mobile
> > E: jose@
> > http://www.josecgomez.com
> > <http://www.linkedin.com/in/josecgomez>
> <http://www.facebook.com/josegomez>
> > <http://www.google.com/profiles/jose.gomez> <http://www.twitter.com/joc85>
> > <http://www.josecgomez.com/professional-resume/>
> > <http://www.josecgomez.com/feed/>
> >
> > *Quis custodiet ipsos custodes?*
> >
> >
> >
> > On Wed, Mar 23, 2011 at 12:08 PM, cubcrafters_it <
> > jason.navarrete@> wrote:
> >
> > >
> > >
> > > How do you tell if you have the Progress Development License?
> > >
> > >
> > > --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> , Jose
> Gomez <jose@> wrote:
> > > >
> > > > Sure,
> > > >
> > > > Do you have the Progress Development Licence?? if so, simply go to
> your
> > > > server
> > > >
> > > > Open your Epicor Admin Tools
> > > > Go to Run Progress Editor
> > > >
> > > > There write a progress query that will accomplish what you want for
> > > example
> > > >
> > > > for each jobMethod where jobMethod.Company="YOUR COMPANY":
> > > > Assign jobMethod.FieldName = "New Value".
> > > > end.
> > > >
> > > > Save your file
> > > >
> > > > Go to the Application Compiler under Start -> Open Edge
> > > >
> > > > Load your file and compile it, if it compiles without problem
> > > >
> > > > Then go back to Epicor Admin Tools and this time Click Run Progress
> > > Program
> > > >
> > > > Load your compiled file and run it.
> > > >
> > > > As a disclaimer do this in test first and make sure it does what you
> > > want.
> > > > I'll try to put together a video tutorial for you if I have time in a
> few
> > > > minutes.
> > > >
> > > >
> > > >
> > > >
> > > > *Jose C Gomez*
> > > > *Software Engineer*
> > > > *
> > > > *T: 904.469.1524 mobile
> > > > E: jose@
> > >
> > > > http://www.josecgomez.com
> > > > <http://www.linkedin.com/in/josecgomez> <
> > > http://www.facebook.com/josegomez>
> > > > <http://www.google.com/profiles/jose.gomez> <
> > > http://www.twitter.com/joc85>
> > > > <http://www.josecgomez.com/professional-resume/>
> > > > <http://www.josecgomez.com/feed/>
> > > >
> > > > *Quis custodiet ipsos custodes?*
> > > >
> > > >
> > > >
> > > > On Wed, Mar 23, 2011 at 9:59 AM, Chris Thompson <chriselectrix@
> > > ...>wrote:
> > >
> > > >
> > > > >
> > > > >
> > > > > We are progress.
> > > > >
> > > > > I have no idea how to do what you've just said.
> > > > >
> > > > > Would you mind giving me a few pointers?
> > > > >
> > > > > ________________________________
> > > > > From: Jose Gomez <jose@>
> > >
> > > > > To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> > > > > Sent: Wed, 23 March, 2011 13:55:48
> > > > > Subject: Re: [Vantage] Making changes in bulk
> > > > >
> > > > >
> > > > > Progress or SQL?
> > > > >
> > > > > if so write a Procedure for either and run it. (Easiest I can think)
> > > > >
> > > > > *Jose C Gomez*
> > > > > *Software Engineer*
> > > > > *
> > > > > *T: 904.469.1524 mobile
> > > > > E: jose@
> > >
> > > > > http://www.josecgomez.com
> > > > > <http://www.linkedin.com/in/josecgomez> <
> > > > > http://www.facebook.com/josegomez>
> > > > > <http://www.google.com/profiles/jose.gomez> <
> > > > > http://www.twitter.com/joc85>
> > > > > <http://www.josecgomez.com/professional-resume/>
> > > > > <http://www.josecgomez.com/feed/>
> > > > >
> > > > > *Quis custodiet ipsos custodes?*
> > > > >
> > > > >
> > > > > On Wed, Mar 23, 2011 at 9:39 AM, Chris Thompson <chriselectrix@
> > >
> > > > > >wrote:
> > > > >
> > > > > >
> > > > > >
> > > > > > Hi All
> > > > > >
> > > > > > We need to make changes in bulk to hundreds of job methods.
> > > > > >
> > > > > > We need to change a /LID to -LID.
> > > > > >
> > > > > > Is there any EASY way to do this?
> > > > > >
> > > > > > [Non-text portions of this message have been removed]
> > > > > >
> > > > > >
> > > > > >
> > > > >
> > > > > [Non-text portions of this message have been removed]
> > > > >
> > > > > ------------------------------------
> > > > >
> > > > >
> > > > > Useful links for the Yahoo!Groups Vantage Board are: ( Note: You
> must
> > > have
> > > > >
> > > > > already linked your email address to a yahoo id to enable access. )
> > > > > (1) To access the Files Section of our Yahoo!Group for Report
> Builder
> > > and
> > > > > Crystal Reports and other 'goodies', please goto:
> > > > > http://groups.yahoo.com/group/vantage/files/.
> <http://groups.yahoo.com/group/vantage/files/>
> > > > >
> > > > > (2) To search through old msg's goto:
> > > > > http://groups.yahoo.com/group/vantage/messages
> > > > > (3) To view links to Vendors that provide Vantage services goto:
> > > > > http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
> > > > >
> > > > >
> > > > > [Non-text portions of this message have been removed]
> > > > >
> > > > >
> > > > >
> > > >
> > > >
> > > > [Non-text portions of this message have been removed]
> > > >
> > >
> > >
> > >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
>
>
> [Non-text portions of this message have been removed]
>
This si the link for the editor
"C:\Program Files\epicor\oe101c\bin\prowin32.exe" -db "C:\Program
Files\Epicor Software\Epicor904\db\Test\mfgsys.db" -S 9020 -H disraeli -N
TCP -Mm 1024

This is the link for the compiler
"C:\Program Files\epicor\oe101c\bin\prowin32.exe" -p _comp.p -db
"C:\Program Files\Epicor Software\Epicor904\db\mfgsys.db" -S 9020 -H
disraeli -N TCP -Mm 1024

S= DB Port
H Host
-Mm don't know what it means but its one of the parameters in the
mfgsys.pffile it can be 1024, 2048 or 4096 depending on your setup

*Jose C Gomez*
*Software Engineer*
*
*T: 904.469.1524 mobile
E: jose@...
http://www.josecgomez.com
<http://www.linkedin.com/in/josecgomez> <http://www.facebook.com/josegomez>
<http://www.google.com/profiles/jose.gomez> <http://www.twitter.com/joc85>
<http://www.josecgomez.com/professional-resume/>
<http://www.josecgomez.com/feed/>

*Quis custodiet ipsos custodes?*



On Wed, Mar 23, 2011 at 1:12 PM, cubcrafters_it <
jason.navarrete@...> wrote:

>
>
> Very good to know. I see 4GL Dev listed in my test 9.04 and 9.05 instances,
> so maybe I'll poke around in there more.
>
> Next question (and apologies to Chris for hijacking his thread, but
> hopefully it's mutually beneficial) -- Jose, what's the link you're using on
> the desktop to start the Procedure Editor, that prompts for a password? I'm
> now calling the Procedure Editor from the OpenEdge Desktop utility, but it
> doesn't prompt to connect to a database, and I'm assuming that might be why
> I get a 'Unknown or ambiguous table Customer. (725)' error.
>
>
> --- In vantage@yahoogroups.com, "Carl Peterson" <cpeterson@...> wrote:
> >
> > The Progress license codes are located in your Progress root directory -
> for
> > example, epicor\oe101b and file name is progress.cfg
> >
> > The Progress 4GL Development license, before 9.05, is a chargeable and
> > around the price of $1800.00 + 18% maintenance and can be purchased from
> > Epicor. You only need a single user version.
> >
> > Carl
> >
> > From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
> Of
> > cubcrafters_it
> > Sent: Wednesday, March 23, 2011 12:32 PM
> > To: vantage@yahoogroups.com
> > Subject: [Vantage] Re: Making changes in bulk
> >
> >
> > I don't have a link for a Procedure Editor, but I can bring one up with
> Data
> > Administration or something similar.
> >
> > But the only license code I got aside from the Epicor License was a key
> for
> > Crystal Reports.
> >
> > Any idea what the cost was to step to the 4GL dev license?
> >
> > --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> , Jose
> > Gomez <jose@> wrote:
> > >
> > > Do you have those programs I showed on the video? On progress licence
> > codes
> > > one shouold say 4gl Development.
> > >
> > > *Jose C Gomez*
> > > *Software Engineer*
> > > *
> > > *T: 904.469.1524 mobile
> > > E: jose@
> > > http://www.josecgomez.com
> > > <http://www.linkedin.com/in/josecgomez>
> > <http://www.facebook.com/josegomez>
> > > <http://www.google.com/profiles/jose.gomez> <
> http://www.twitter.com/joc85>
> > > <http://www.josecgomez.com/professional-resume/>
> > > <http://www.josecgomez.com/feed/>
> > >
> > > *Quis custodiet ipsos custodes?*
> > >
> > >
> > >
> > > On Wed, Mar 23, 2011 at 12:08 PM, cubcrafters_it <
> > > jason.navarrete@> wrote:
> > >
> > > >
> > > >
> > > > How do you tell if you have the Progress Development License?
> > > >
> > > >
> > > > --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
> Jose
> > Gomez <jose@> wrote:
> > > > >
> > > > > Sure,
> > > > >
> > > > > Do you have the Progress Development Licence?? if so, simply go to
> > your
> > > > > server
> > > > >
> > > > > Open your Epicor Admin Tools
> > > > > Go to Run Progress Editor
> > > > >
> > > > > There write a progress query that will accomplish what you want for
> > > > example
> > > > >
> > > > > for each jobMethod where jobMethod.Company="YOUR COMPANY":
> > > > > Assign jobMethod.FieldName = "New Value".
> > > > > end.
> > > > >
> > > > > Save your file
> > > > >
> > > > > Go to the Application Compiler under Start -> Open Edge
> > > > >
> > > > > Load your file and compile it, if it compiles without problem
> > > > >
> > > > > Then go back to Epicor Admin Tools and this time Click Run Progress
> > > > Program
> > > > >
> > > > > Load your compiled file and run it.
> > > > >
> > > > > As a disclaimer do this in test first and make sure it does what
> you
> > > > want.
> > > > > I'll try to put together a video tutorial for you if I have time in
> a
> > few
> > > > > minutes.
> > > > >
> > > > >
> > > > >
> > > > >
> > > > > *Jose C Gomez*
> > > > > *Software Engineer*
> > > > > *
> > > > > *T: 904.469.1524 mobile
> > > > > E: jose@
> > > >
> > > > > http://www.josecgomez.com
> > > > > <http://www.linkedin.com/in/josecgomez> <
> > > > http://www.facebook.com/josegomez>
> > > > > <http://www.google.com/profiles/jose.gomez> <
> > > > http://www.twitter.com/joc85>
> > > > > <http://www.josecgomez.com/professional-resume/>
> > > > > <http://www.josecgomez.com/feed/>
> > > > >
> > > > > *Quis custodiet ipsos custodes?*
> > > > >
> > > > >
> > > > >
> > > > > On Wed, Mar 23, 2011 at 9:59 AM, Chris Thompson <chriselectrix@
> > > > ...>wrote:
> > > >
> > > > >
> > > > > >
> > > > > >
> > > > > > We are progress.
> > > > > >
> > > > > > I have no idea how to do what you've just said.
> > > > > >
> > > > > > Would you mind giving me a few pointers?
> > > > > >
> > > > > > ________________________________
> > > > > > From: Jose Gomez <jose@>
> > > >
> > > > > > To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> > > > > > Sent: Wed, 23 March, 2011 13:55:48
> > > > > > Subject: Re: [Vantage] Making changes in bulk
> > > > > >
> > > > > >
> > > > > > Progress or SQL?
> > > > > >
> > > > > > if so write a Procedure for either and run it. (Easiest I can
> think)
> > > > > >
> > > > > > *Jose C Gomez*
> > > > > > *Software Engineer*
> > > > > > *
> > > > > > *T: 904.469.1524 mobile
> > > > > > E: jose@
> > > >
> > > > > > http://www.josecgomez.com
> > > > > > <http://www.linkedin.com/in/josecgomez> <
> > > > > > http://www.facebook.com/josegomez>
> > > > > > <http://www.google.com/profiles/jose.gomez> <
> > > > > > http://www.twitter.com/joc85>
> > > > > > <http://www.josecgomez.com/professional-resume/>
> > > > > > <http://www.josecgomez.com/feed/>
> > > > > >
> > > > > > *Quis custodiet ipsos custodes?*
> > > > > >
> > > > > >
> > > > > > On Wed, Mar 23, 2011 at 9:39 AM, Chris Thompson <chriselectrix@
> > > >
> > > > > > >wrote:
> > > > > >
> > > > > > >
> > > > > > >
> > > > > > > Hi All
> > > > > > >
> > > > > > > We need to make changes in bulk to hundreds of job methods.
> > > > > > >
> > > > > > > We need to change a /LID to -LID.
> > > > > > >
> > > > > > > Is there any EASY way to do this?
> > > > > > >
> > > > > > > [Non-text portions of this message have been removed]
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > >
> > > > > > [Non-text portions of this message have been removed]
> > > > > >
> > > > > > ------------------------------------
> > > > > >
> > > > > >
> > > > > > Useful links for the Yahoo!Groups Vantage Board are: ( Note: You
> > must
> > > > have
> > > > > >
> > > > > > already linked your email address to a yahoo id to enable access.
> )
> > > > > > (1) To access the Files Section of our Yahoo!Group for Report
> > Builder
> > > > and
> > > > > > Crystal Reports and other 'goodies', please goto:
> > > > > > http://groups.yahoo.com/group/vantage/files/.
> > <http://groups.yahoo.com/group/vantage/files/>
> > > > > >
> > > > > > (2) To search through old msg's goto:
> > > > > > http://groups.yahoo.com/group/vantage/messages
> > > > > > (3) To view links to Vendors that provide Vantage services goto:
> > > > > > http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
> > > > > >
> > > > > >
> > > > > > [Non-text portions of this message have been removed]
> > > > > >
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > > > [Non-text portions of this message have been removed]
> > > > >
> > > >
> > > >
> > > >
> > >
> > >
> > > [Non-text portions of this message have been removed]
> > >
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
>
>


[Non-text portions of this message have been removed]
Thanks! That's what I needed.

I got a quote back from my CAM for $3600 + $720 maintenance for OpenEdge Architect (for OpenEdge 10.2a). Any idea how that differs from the Dev license?


--- In vantage@yahoogroups.com, Jose Gomez <jose@...> wrote:
>
> This si the link for the editor
> "C:\Program Files\epicor\oe101c\bin\prowin32.exe" -db "C:\Program
> Files\Epicor Software\Epicor904\db\Test\mfgsys.db" -S 9020 -H disraeli -N
> TCP -Mm 1024
>
> This is the link for the compiler
> "C:\Program Files\epicor\oe101c\bin\prowin32.exe" -p _comp.p -db
> "C:\Program Files\Epicor Software\Epicor904\db\mfgsys.db" -S 9020 -H
> disraeli -N TCP -Mm 1024
>
> S= DB Port
> H Host
> -Mm don't know what it means but its one of the parameters in the
> mfgsys.pffile it can be 1024, 2048 or 4096 depending on your setup
>
> *Jose C Gomez*
> *Software Engineer*
> *
> *T: 904.469.1524 mobile
> E: jose@...
> http://www.josecgomez.com
> <http://www.linkedin.com/in/josecgomez> <http://www.facebook.com/josegomez>
> <http://www.google.com/profiles/jose.gomez> <http://www.twitter.com/joc85>
> <http://www.josecgomez.com/professional-resume/>
> <http://www.josecgomez.com/feed/>
>
> *Quis custodiet ipsos custodes?*
>
>
>
> On Wed, Mar 23, 2011 at 1:12 PM, cubcrafters_it <
> jason.navarrete@...> wrote:
>
> >
> >
> > Very good to know. I see 4GL Dev listed in my test 9.04 and 9.05 instances,
> > so maybe I'll poke around in there more.
> >
> > Next question (and apologies to Chris for hijacking his thread, but
> > hopefully it's mutually beneficial) -- Jose, what's the link you're using on
> > the desktop to start the Procedure Editor, that prompts for a password? I'm
> > now calling the Procedure Editor from the OpenEdge Desktop utility, but it
> > doesn't prompt to connect to a database, and I'm assuming that might be why
> > I get a 'Unknown or ambiguous table Customer. (725)' error.
> >
> >
> > --- In vantage@yahoogroups.com, "Carl Peterson" <cpeterson@> wrote:
> > >
> > > The Progress license codes are located in your Progress root directory -
> > for
> > > example, epicor\oe101b and file name is progress.cfg
> > >
> > > The Progress 4GL Development license, before 9.05, is a chargeable and
> > > around the price of $1800.00 + 18% maintenance and can be purchased from
> > > Epicor. You only need a single user version.
> > >
> > > Carl
> > >
> > > From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
> > Of
> > > cubcrafters_it
> > > Sent: Wednesday, March 23, 2011 12:32 PM
> > > To: vantage@yahoogroups.com
> > > Subject: [Vantage] Re: Making changes in bulk
> > >
> > >
> > > I don't have a link for a Procedure Editor, but I can bring one up with
> > Data
> > > Administration or something similar.
> > >
> > > But the only license code I got aside from the Epicor License was a key
> > for
> > > Crystal Reports.
> > >
> > > Any idea what the cost was to step to the 4GL dev license?
> > >
> > > --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> , Jose
> > > Gomez <jose@> wrote:
> > > >
> > > > Do you have those programs I showed on the video? On progress licence
> > > codes
> > > > one shouold say 4gl Development.
> > > >
> > > > *Jose C Gomez*
> > > > *Software Engineer*
> > > > *
> > > > *T: 904.469.1524 mobile
> > > > E: jose@
> > > > http://www.josecgomez.com
> > > > <http://www.linkedin.com/in/josecgomez>
> > > <http://www.facebook.com/josegomez>
> > > > <http://www.google.com/profiles/jose.gomez> <
> > http://www.twitter.com/joc85>
> > > > <http://www.josecgomez.com/professional-resume/>
> > > > <http://www.josecgomez.com/feed/>
> > > >
> > > > *Quis custodiet ipsos custodes?*
> > > >
> > > >
> > > >
> > > > On Wed, Mar 23, 2011 at 12:08 PM, cubcrafters_it <
> > > > jason.navarrete@> wrote:
> > > >
> > > > >
> > > > >
> > > > > How do you tell if you have the Progress Development License?
> > > > >
> > > > >
> > > > > --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
> > Jose
> > > Gomez <jose@> wrote:
> > > > > >
> > > > > > Sure,
> > > > > >
> > > > > > Do you have the Progress Development Licence?? if so, simply go to
> > > your
> > > > > > server
> > > > > >
> > > > > > Open your Epicor Admin Tools
> > > > > > Go to Run Progress Editor
> > > > > >
> > > > > > There write a progress query that will accomplish what you want for
> > > > > example
> > > > > >
> > > > > > for each jobMethod where jobMethod.Company="YOUR COMPANY":
> > > > > > Assign jobMethod.FieldName = "New Value".
> > > > > > end.
> > > > > >
> > > > > > Save your file
> > > > > >
> > > > > > Go to the Application Compiler under Start -> Open Edge
> > > > > >
> > > > > > Load your file and compile it, if it compiles without problem
> > > > > >
> > > > > > Then go back to Epicor Admin Tools and this time Click Run Progress
> > > > > Program
> > > > > >
> > > > > > Load your compiled file and run it.
> > > > > >
> > > > > > As a disclaimer do this in test first and make sure it does what
> > you
> > > > > want.
> > > > > > I'll try to put together a video tutorial for you if I have time in
> > a
> > > few
> > > > > > minutes.
> > > > > >
> > > > > >
> > > > > >
> > > > > >
> > > > > > *Jose C Gomez*
> > > > > > *Software Engineer*
> > > > > > *
> > > > > > *T: 904.469.1524 mobile
> > > > > > E: jose@
> > > > >
> > > > > > http://www.josecgomez.com
> > > > > > <http://www.linkedin.com/in/josecgomez> <
> > > > > http://www.facebook.com/josegomez>
> > > > > > <http://www.google.com/profiles/jose.gomez> <
> > > > > http://www.twitter.com/joc85>
> > > > > > <http://www.josecgomez.com/professional-resume/>
> > > > > > <http://www.josecgomez.com/feed/>
> > > > > >
> > > > > > *Quis custodiet ipsos custodes?*
> > > > > >
> > > > > >
> > > > > >
> > > > > > On Wed, Mar 23, 2011 at 9:59 AM, Chris Thompson <chriselectrix@
> > > > > ...>wrote:
> > > > >
> > > > > >
> > > > > > >
> > > > > > >
> > > > > > > We are progress.
> > > > > > >
> > > > > > > I have no idea how to do what you've just said.
> > > > > > >
> > > > > > > Would you mind giving me a few pointers?
> > > > > > >
> > > > > > > ________________________________
> > > > > > > From: Jose Gomez <jose@>
> > > > >
> > > > > > > To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> > > > > > > Sent: Wed, 23 March, 2011 13:55:48
> > > > > > > Subject: Re: [Vantage] Making changes in bulk
> > > > > > >
> > > > > > >
> > > > > > > Progress or SQL?
> > > > > > >
> > > > > > > if so write a Procedure for either and run it. (Easiest I can
> > think)
> > > > > > >
> > > > > > > *Jose C Gomez*
> > > > > > > *Software Engineer*
> > > > > > > *
> > > > > > > *T: 904.469.1524 mobile
> > > > > > > E: jose@
> > > > >
> > > > > > > http://www.josecgomez.com
> > > > > > > <http://www.linkedin.com/in/josecgomez> <
> > > > > > > http://www.facebook.com/josegomez>
> > > > > > > <http://www.google.com/profiles/jose.gomez> <
> > > > > > > http://www.twitter.com/joc85>
> > > > > > > <http://www.josecgomez.com/professional-resume/>
> > > > > > > <http://www.josecgomez.com/feed/>
> > > > > > >
> > > > > > > *Quis custodiet ipsos custodes?*
> > > > > > >
> > > > > > >
> > > > > > > On Wed, Mar 23, 2011 at 9:39 AM, Chris Thompson <chriselectrix@
> > > > >
> > > > > > > >wrote:
> > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > > > Hi All
> > > > > > > >
> > > > > > > > We need to make changes in bulk to hundreds of job methods.
> > > > > > > >
> > > > > > > > We need to change a /LID to -LID.
> > > > > > > >
> > > > > > > > Is there any EASY way to do this?
> > > > > > > >
> > > > > > > > [Non-text portions of this message have been removed]
> > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > >
> > > > > > > [Non-text portions of this message have been removed]
> > > > > > >
> > > > > > > ------------------------------------
> > > > > > >
> > > > > > >
> > > > > > > Useful links for the Yahoo!Groups Vantage Board are: ( Note: You
> > > must
> > > > > have
> > > > > > >
> > > > > > > already linked your email address to a yahoo id to enable access.
> > )
> > > > > > > (1) To access the Files Section of our Yahoo!Group for Report
> > > Builder
> > > > > and
> > > > > > > Crystal Reports and other 'goodies', please goto:
> > > > > > > http://groups.yahoo.com/group/vantage/files/.
> > > <http://groups.yahoo.com/group/vantage/files/>
> > > > > > >
> > > > > > > (2) To search through old msg's goto:
> > > > > > > http://groups.yahoo.com/group/vantage/messages
> > > > > > > (3) To view links to Vendors that provide Vantage services goto:
> > > > > > > http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
> > > > > > >
> > > > > > >
> > > > > > > [Non-text portions of this message have been removed]
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > >
> > > > > >
> > > > > > [Non-text portions of this message have been removed]
> > > > > >
> > > > >
> > > > >
> > > > >
> > > >
> > > >
> > > > [Non-text portions of this message have been removed]
> > > >
> > >
> > >
> > >
> > > [Non-text portions of this message have been removed]
> > >
> >
> >
> >
>
>
> [Non-text portions of this message have been removed]
>
Open edge architect is an IDE for progress. Very nice but not necessary.
You'll still need the dev license.
Ps we paid much less for it

Sent from mobile
On Mar 23, 2011 7:07 PM, "cubcrafters_it" <jason.navarrete@...>
wrote:
> Thanks! That's what I needed.
>
> I got a quote back from my CAM for $3600 + $720 maintenance for OpenEdge
Architect (for OpenEdge 10.2a). Any idea how that differs from the Dev
license?
>
>
> --- In vantage@yahoogroups.com, Jose Gomez <jose@...> wrote:
>>
>> This si the link for the editor
>> "C:\Program Files\epicor\oe101c\bin\prowin32.exe" -db "C:\Program
>> Files\Epicor Software\Epicor904\db\Test\mfgsys.db" -S 9020 -H disraeli -N
>> TCP -Mm 1024
>>
>> This is the link for the compiler
>> "C:\Program Files\epicor\oe101c\bin\prowin32.exe" -p _comp.p -db
>> "C:\Program Files\Epicor Software\Epicor904\db\mfgsys.db" -S 9020 -H
>> disraeli -N TCP -Mm 1024
>>
>> S= DB Port
>> H Host
>> -Mm don't know what it means but its one of the parameters in the
>> mfgsys.pffile it can be 1024, 2048 or 4096 depending on your setup
>>
>> *Jose C Gomez*
>> *Software Engineer*
>> *
>> *T: 904.469.1524 mobile
>> E: jose@...
>> http://www.josecgomez.com
>> <http://www.linkedin.com/in/josecgomez> <
http://www.facebook.com/josegomez>
>> <http://www.google.com/profiles/jose.gomez> <http://www.twitter.com/joc85
>
>> <http://www.josecgomez.com/professional-resume/>
>> <http://www.josecgomez.com/feed/>
>>
>> *Quis custodiet ipsos custodes?*
>>
>>
>>
>> On Wed, Mar 23, 2011 at 1:12 PM, cubcrafters_it <
>> jason.navarrete@...> wrote:
>>
>> >
>> >
>> > Very good to know. I see 4GL Dev listed in my test 9.04 and 9.05
instances,
>> > so maybe I'll poke around in there more.
>> >
>> > Next question (and apologies to Chris for hijacking his thread, but
>> > hopefully it's mutually beneficial) -- Jose, what's the link you're
using on
>> > the desktop to start the Procedure Editor, that prompts for a password?
I'm
>> > now calling the Procedure Editor from the OpenEdge Desktop utility, but
it
>> > doesn't prompt to connect to a database, and I'm assuming that might be
why
>> > I get a 'Unknown or ambiguous table Customer. (725)' error.
>> >
>> >
>> > --- In vantage@yahoogroups.com, "Carl Peterson" <cpeterson@> wrote:
>> > >
>> > > The Progress license codes are located in your Progress root
directory -
>> > for
>> > > example, epicor\oe101b and file name is progress.cfg
>> > >
>> > > The Progress 4GL Development license, before 9.05, is a chargeable
and
>> > > around the price of $1800.00 + 18% maintenance and can be purchased
from
>> > > Epicor. You only need a single user version.
>> > >
>> > > Carl
>> > >
>> > > From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
Behalf
>> > Of
>> > > cubcrafters_it
>> > > Sent: Wednesday, March 23, 2011 12:32 PM
>> > > To: vantage@yahoogroups.com
>> > > Subject: [Vantage] Re: Making changes in bulk
>> > >
>> > >
>> > > I don't have a link for a Procedure Editor, but I can bring one up
with
>> > Data
>> > > Administration or something similar.
>> > >
>> > > But the only license code I got aside from the Epicor License was a
key
>> > for
>> > > Crystal Reports.
>> > >
>> > > Any idea what the cost was to step to the 4GL dev license?
>> > >
>> > > --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
Jose
>> > > Gomez <jose@> wrote:
>> > > >
>> > > > Do you have those programs I showed on the video? On progress
licence
>> > > codes
>> > > > one shouold say 4gl Development.
>> > > >
>> > > > *Jose C Gomez*
>> > > > *Software Engineer*
>> > > > *
>> > > > *T: 904.469.1524 mobile
>> > > > E: jose@
>> > > > http://www.josecgomez.com
>> > > > <http://www.linkedin.com/in/josecgomez>
>> > > <http://www.facebook.com/josegomez>
>> > > > <http://www.google.com/profiles/jose.gomez> <
>> > http://www.twitter.com/joc85>
>> > > > <http://www.josecgomez.com/professional-resume/>
>> > > > <http://www.josecgomez.com/feed/>
>> > > >
>> > > > *Quis custodiet ipsos custodes?*
>> > > >
>> > > >
>> > > >
>> > > > On Wed, Mar 23, 2011 at 12:08 PM, cubcrafters_it <
>> > > > jason.navarrete@> wrote:
>> > > >
>> > > > >
>> > > > >
>> > > > > How do you tell if you have the Progress Development License?
>> > > > >
>> > > > >
>> > > > > --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
,
>> > Jose
>> > > Gomez <jose@> wrote:
>> > > > > >
>> > > > > > Sure,
>> > > > > >
>> > > > > > Do you have the Progress Development Licence?? if so, simply go
to
>> > > your
>> > > > > > server
>> > > > > >
>> > > > > > Open your Epicor Admin Tools
>> > > > > > Go to Run Progress Editor
>> > > > > >
>> > > > > > There write a progress query that will accomplish what you want
for
>> > > > > example
>> > > > > >
>> > > > > > for each jobMethod where jobMethod.Company="YOUR COMPANY":
>> > > > > > Assign jobMethod.FieldName = "New Value".
>> > > > > > end.
>> > > > > >
>> > > > > > Save your file
>> > > > > >
>> > > > > > Go to the Application Compiler under Start -> Open Edge
>> > > > > >
>> > > > > > Load your file and compile it, if it compiles without problem
>> > > > > >
>> > > > > > Then go back to Epicor Admin Tools and this time Click Run
Progress
>> > > > > Program
>> > > > > >
>> > > > > > Load your compiled file and run it.
>> > > > > >
>> > > > > > As a disclaimer do this in test first and make sure it does
what
>> > you
>> > > > > want.
>> > > > > > I'll try to put together a video tutorial for you if I have
time in
>> > a
>> > > few
>> > > > > > minutes.
>> > > > > >
>> > > > > >
>> > > > > >
>> > > > > >
>> > > > > > *Jose C Gomez*
>> > > > > > *Software Engineer*
>> > > > > > *
>> > > > > > *T: 904.469.1524 mobile
>> > > > > > E: jose@
>> > > > >
>> > > > > > http://www.josecgomez.com
>> > > > > > <http://www.linkedin.com/in/josecgomez> <
>> > > > > http://www.facebook.com/josegomez>
>> > > > > > <http://www.google.com/profiles/jose.gomez> <
>> > > > > http://www.twitter.com/joc85>
>> > > > > > <http://www.josecgomez.com/professional-resume/>
>> > > > > > <http://www.josecgomez.com/feed/>
>> > > > > >
>> > > > > > *Quis custodiet ipsos custodes?*
>> > > > > >
>> > > > > >
>> > > > > >
>> > > > > > On Wed, Mar 23, 2011 at 9:59 AM, Chris Thompson <chriselectrix@
>> > > > > ...>wrote:
>> > > > >
>> > > > > >
>> > > > > > >
>> > > > > > >
>> > > > > > > We are progress.
>> > > > > > >
>> > > > > > > I have no idea how to do what you've just said.
>> > > > > > >
>> > > > > > > Would you mind giving me a few pointers?
>> > > > > > >
>> > > > > > > ________________________________
>> > > > > > > From: Jose Gomez <jose@>
>> > > > >
>> > > > > > > To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com
>
>> > > > > > > Sent: Wed, 23 March, 2011 13:55:48
>> > > > > > > Subject: Re: [Vantage] Making changes in bulk
>> > > > > > >
>> > > > > > >
>> > > > > > > Progress or SQL?
>> > > > > > >
>> > > > > > > if so write a Procedure for either and run it. (Easiest I can
>> > think)
>> > > > > > >
>> > > > > > > *Jose C Gomez*
>> > > > > > > *Software Engineer*
>> > > > > > > *
>> > > > > > > *T: 904.469.1524 mobile
>> > > > > > > E: jose@
>> > > > >
>> > > > > > > http://www.josecgomez.com
>> > > > > > > <http://www.linkedin.com/in/josecgomez> <
>> > > > > > > http://www.facebook.com/josegomez>
>> > > > > > > <http://www.google.com/profiles/jose.gomez> <
>> > > > > > > http://www.twitter.com/joc85>
>> > > > > > > <http://www.josecgomez.com/professional-resume/>
>> > > > > > > <http://www.josecgomez.com/feed/>
>> > > > > > >
>> > > > > > > *Quis custodiet ipsos custodes?*
>> > > > > > >
>> > > > > > >
>> > > > > > > On Wed, Mar 23, 2011 at 9:39 AM, Chris Thompson
<chriselectrix@
>> > > > >
>> > > > > > > >wrote:
>> > > > > > >
>> > > > > > > >
>> > > > > > > >
>> > > > > > > > Hi All
>> > > > > > > >
>> > > > > > > > We need to make changes in bulk to hundreds of job methods.
>> > > > > > > >
>> > > > > > > > We need to change a /LID to -LID.
>> > > > > > > >
>> > > > > > > > Is there any EASY way to do this?
>> > > > > > > >
>> > > > > > > > [Non-text portions of this message have been removed]
>> > > > > > > >
>> > > > > > > >
>> > > > > > > >
>> > > > > > >
>> > > > > > > [Non-text portions of this message have been removed]
>> > > > > > >
>> > > > > > > ------------------------------------
>> > > > > > >
>> > > > > > >
>> > > > > > > Useful links for the Yahoo!Groups Vantage Board are: ( Note:
You
>> > > must
>> > > > > have
>> > > > > > >
>> > > > > > > already linked your email address to a yahoo id to enable
access.
>> > )
>> > > > > > > (1) To access the Files Section of our Yahoo!Group for Report
>> > > Builder
>> > > > > and
>> > > > > > > Crystal Reports and other 'goodies', please goto:
>> > > > > > > http://groups.yahoo.com/group/vantage/files/.
>> > > <http://groups.yahoo.com/group/vantage/files/>
>> > > > > > >
>> > > > > > > (2) To search through old msg's goto:
>> > > > > > > http://groups.yahoo.com/group/vantage/messages
>> > > > > > > (3) To view links to Vendors that provide Vantage services
goto:
>> > > > > > > http://groups.yahoo.com/group/vantage/linksYahoo! Groups
Links
>> > > > > > >
>> > > > > > >
>> > > > > > > [Non-text portions of this message have been removed]
>> > > > > > >
>> > > > > > >
>> > > > > > >
>> > > > > >
>> > > > > >
>> > > > > > [Non-text portions of this message have been removed]
>> > > > > >
>> > > > >
>> > > > >
>> > > > >
>> > > >
>> > > >
>> > > > [Non-text portions of this message have been removed]
>> > > >
>> > >
>> > >
>> > >
>> > > [Non-text portions of this message have been removed]
>> > >
>> >
>> >
>> >
>>
>>
>> [Non-text portions of this message have been removed]
>>
>
>


[Non-text portions of this message have been removed]
I don't know if you ever said what version you're on, but by one of the
versions (it may be 9.04), you no longer need the license - it's bundled
with the software.



What I've done for one time programs, which I find a lot easier than
compiling programs, etc, is I have a checkbox on the Company form, and I
have a BPM that triggers when the checkbox changes and it's being run by me.
Then, I simply insert my code in the advanced, 4GL section, open company
maint and click the box.



Kevin Simon



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
cubcrafters_it
Sent: Wednesday, March 23, 2011 7:06 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Making changes in bulk





Thanks! That's what I needed.

I got a quote back from my CAM for $3600 + $720 maintenance for OpenEdge
Architect (for OpenEdge 10.2a). Any idea how that differs from the Dev
license?

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> , Jose
Gomez <jose@...> wrote:
>
> This si the link for the editor
> "C:\Program Files\epicor\oe101c\bin\prowin32.exe" -db "C:\Program
> Files\Epicor Software\Epicor904\db\Test\mfgsys.db" -S 9020 -H disraeli -N
> TCP -Mm 1024
>
> This is the link for the compiler
> "C:\Program Files\epicor\oe101c\bin\prowin32.exe" -p _comp.p -db
> "C:\Program Files\Epicor Software\Epicor904\db\mfgsys.db" -S 9020 -H
> disraeli -N TCP -Mm 1024
>
> S= DB Port
> H Host
> -Mm don't know what it means but its one of the parameters in the
> mfgsys.pffile it can be 1024, 2048 or 4096 depending on your setup
>
> *Jose C Gomez*
> *Software Engineer*
> *
> *T: 904.469.1524 mobile
> E: jose@...
> http://www.josecgomez.com
> <http://www.linkedin.com/in/josecgomez>
<http://www.facebook.com/josegomez>
> <http://www.google.com/profiles/jose.gomez> <http://www.twitter.com/joc85>
> <http://www.josecgomez.com/professional-resume/>
> <http://www.josecgomez.com/feed/>
>
> *Quis custodiet ipsos custodes?*
>
>
>
> On Wed, Mar 23, 2011 at 1:12 PM, cubcrafters_it <
> jason.navarrete@...> wrote:
>
> >
> >
> > Very good to know. I see 4GL Dev listed in my test 9.04 and 9.05
instances,
> > so maybe I'll poke around in there more.
> >
> > Next question (and apologies to Chris for hijacking his thread, but
> > hopefully it's mutually beneficial) -- Jose, what's the link you're
using on
> > the desktop to start the Procedure Editor, that prompts for a password?
I'm
> > now calling the Procedure Editor from the OpenEdge Desktop utility, but
it
> > doesn't prompt to connect to a database, and I'm assuming that might be
why
> > I get a 'Unknown or ambiguous table Customer. (725)' error.
> >
> >
> > --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
"Carl Peterson" <cpeterson@> wrote:
> > >
> > > The Progress license codes are located in your Progress root directory
-
> > for
> > > example, epicor\oe101b and file name is progress.cfg
> > >
> > > The Progress 4GL Development license, before 9.05, is a chargeable and
> > > around the price of $1800.00 + 18% maintenance and can be purchased
from
> > > Epicor. You only need a single user version.
> > >
> > > Carl
> > >
> > > From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
> > Of
> > > cubcrafters_it
> > > Sent: Wednesday, March 23, 2011 12:32 PM
> > > To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> > > Subject: [Vantage] Re: Making changes in bulk
> > >
> > >
> > > I don't have a link for a Procedure Editor, but I can bring one up
with
> > Data
> > > Administration or something similar.
> > >
> > > But the only license code I got aside from the Epicor License was a
key
> > for
> > > Crystal Reports.
> > >
> > > Any idea what the cost was to step to the 4GL dev license?
> > >
> > > --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> , Jose
> > > Gomez <jose@> wrote:
> > > >
> > > > Do you have those programs I showed on the video? On progress
licence
> > > codes
> > > > one shouold say 4gl Development.
> > > >
> > > > *Jose C Gomez*
> > > > *Software Engineer*
> > > > *
> > > > *T: 904.469.1524 mobile
> > > > E: jose@
> > > > http://www.josecgomez.com
> > > > <http://www.linkedin.com/in/josecgomez>
> > > <http://www.facebook.com/josegomez>
> > > > <http://www.google.com/profiles/jose.gomez> <
> > http://www.twitter.com/joc85>
> > > > <http://www.josecgomez.com/professional-resume/>
> > > > <http://www.josecgomez.com/feed/>
> > > >
> > > > *Quis custodiet ipsos custodes?*
> > > >
> > > >
> > > >
> > > > On Wed, Mar 23, 2011 at 12:08 PM, cubcrafters_it <
> > > > jason.navarrete@> wrote:
> > > >
> > > > >
> > > > >
> > > > > How do you tell if you have the Progress Development License?
> > > > >
> > > > >
> > > > > --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ,
> > Jose
> > > Gomez <jose@> wrote:
> > > > > >
> > > > > > Sure,
> > > > > >
> > > > > > Do you have the Progress Development Licence?? if so, simply go
to
> > > your
> > > > > > server
> > > > > >
> > > > > > Open your Epicor Admin Tools
> > > > > > Go to Run Progress Editor
> > > > > >
> > > > > > There write a progress query that will accomplish what you want
for
> > > > > example
> > > > > >
> > > > > > for each jobMethod where jobMethod.Company="YOUR COMPANY":
> > > > > > Assign jobMethod.FieldName = "New Value".
> > > > > > end.
> > > > > >
> > > > > > Save your file
> > > > > >
> > > > > > Go to the Application Compiler under Start -> Open Edge
> > > > > >
> > > > > > Load your file and compile it, if it compiles without problem
> > > > > >
> > > > > > Then go back to Epicor Admin Tools and this time Click Run
Progress
> > > > > Program
> > > > > >
> > > > > > Load your compiled file and run it.
> > > > > >
> > > > > > As a disclaimer do this in test first and make sure it does what
> > you
> > > > > want.
> > > > > > I'll try to put together a video tutorial for you if I have time
in
> > a
> > > few
> > > > > > minutes.
> > > > > >
> > > > > >
> > > > > >
> > > > > >
> > > > > > *Jose C Gomez*
> > > > > > *Software Engineer*
> > > > > > *
> > > > > > *T: 904.469.1524 mobile
> > > > > > E: jose@
> > > > >
> > > > > > http://www.josecgomez.com
> > > > > > <http://www.linkedin.com/in/josecgomez> <
> > > > > http://www.facebook.com/josegomez>
> > > > > > <http://www.google.com/profiles/jose.gomez> <
> > > > > http://www.twitter.com/joc85>
> > > > > > <http://www.josecgomez.com/professional-resume/>
> > > > > > <http://www.josecgomez.com/feed/>
> > > > > >
> > > > > > *Quis custodiet ipsos custodes?*
> > > > > >
> > > > > >
> > > > > >
> > > > > > On Wed, Mar 23, 2011 at 9:59 AM, Chris Thompson <chriselectrix@
> > > > > ...>wrote:
> > > > >
> > > > > >
> > > > > > >
> > > > > > >
> > > > > > > We are progress.
> > > > > > >
> > > > > > > I have no idea how to do what you've just said.
> > > > > > >
> > > > > > > Would you mind giving me a few pointers?
> > > > > > >
> > > > > > > ________________________________
> > > > > > > From: Jose Gomez <jose@>
> > > > >
> > > > > > > To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
> > > > > > > Sent: Wed, 23 March, 2011 13:55:48
> > > > > > > Subject: Re: [Vantage] Making changes in bulk
> > > > > > >
> > > > > > >
> > > > > > > Progress or SQL?
> > > > > > >
> > > > > > > if so write a Procedure for either and run it. (Easiest I can
> > think)
> > > > > > >
> > > > > > > *Jose C Gomez*
> > > > > > > *Software Engineer*
> > > > > > > *
> > > > > > > *T: 904.469.1524 mobile
> > > > > > > E: jose@
> > > > >
> > > > > > > http://www.josecgomez.com
> > > > > > > <http://www.linkedin.com/in/josecgomez> <
> > > > > > > http://www.facebook.com/josegomez>
> > > > > > > <http://www.google.com/profiles/jose.gomez> <
> > > > > > > http://www.twitter.com/joc85>
> > > > > > > <http://www.josecgomez.com/professional-resume/>
> > > > > > > <http://www.josecgomez.com/feed/>
> > > > > > >
> > > > > > > *Quis custodiet ipsos custodes?*
> > > > > > >
> > > > > > >
> > > > > > > On Wed, Mar 23, 2011 at 9:39 AM, Chris Thompson
<chriselectrix@
> > > > >
> > > > > > > >wrote:
> > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > > > Hi All
> > > > > > > >
> > > > > > > > We need to make changes in bulk to hundreds of job methods.
> > > > > > > >
> > > > > > > > We need to change a /LID to -LID.
> > > > > > > >
> > > > > > > > Is there any EASY way to do this?
> > > > > > > >
> > > > > > > > [Non-text portions of this message have been removed]
> > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > >
> > > > > > > [Non-text portions of this message have been removed]
> > > > > > >
> > > > > > > ------------------------------------
> > > > > > >
> > > > > > >
> > > > > > > Useful links for the Yahoo!Groups Vantage Board are: ( Note:
You
> > > must
> > > > > have
> > > > > > >
> > > > > > > already linked your email address to a yahoo id to enable
access.
> > )
> > > > > > > (1) To access the Files Section of our Yahoo!Group for Report
> > > Builder
> > > > > and
> > > > > > > Crystal Reports and other 'goodies', please goto:
> > > > > > > http://groups.yahoo.com/group/vantage/files/.
<http://groups.yahoo.com/group/vantage/files/>
> > > <http://groups.yahoo.com/group/vantage/files/>
> > > > > > >
> > > > > > > (2) To search through old msg's goto:
> > > > > > > http://groups.yahoo.com/group/vantage/messages
> > > > > > > (3) To view links to Vendors that provide Vantage services
goto:
> > > > > > > http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
> > > > > > >
> > > > > > >
> > > > > > > [Non-text portions of this message have been removed]
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > >
> > > > > >
> > > > > > [Non-text portions of this message have been removed]
> > > > > >
> > > > >
> > > > >
> > > > >
> > > >
> > > >
> > > > [Non-text portions of this message have been removed]
> > > >
> > >
> > >
> > >
> > > [Non-text portions of this message have been removed]
> > >
> >
> >
> >
>
>
> [Non-text portions of this message have been removed]
>





[Non-text portions of this message have been removed]