Vantage - Problem with Parts & Costing ID

Yahoo Archive
1
Have you ever tested it? With Progress, I recall hearing chatter about that but I always test theories. :-) I do remember being told that, but you're relying on Progress licensing now vs Vantage UI licensing. Plus, hypothetically, an ODBC connection is only attached to the Progress database momentarily while performing a query.

And, this is one major reason to go with SQL vs Progress. With Progress you're stuck. With SQL, you have so much more flexibility and scalability. Even doing things like data forensics is incredibly easier.

With Progress I feel claustrophobic.

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Lynn
Sent: Tuesday, November 18, 2008 10:38 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Vantage - Problem with Parts & Costing ID

Hi Vic:

Can you clear up something for me regarding your last paragraph?

I am on Vantage8.03/Progress. If I were to use ODBC, aren't I still
using a Progress license everytime I connect via ODBC? Therefore, a
Vantage license will still, in a sense, used by those people viewing
reports via ODBC, correct?

Lynn

--- In vantage@yahoogroups.com, "Vic Drecchio" <vic.drecchio@...>
wrote:
>
> It's risky to *populate* the database circumventing the Vantage biz
logic.
>
> It's *never* risky to VIEW data via circumventing Vantage. It may
be slow or it may be inaccurate, but it's not "risky". I do it all
the time. If you are just viewing data (no modify, insert, update,
etc), there is zero risk. If you choose to go this route, either
make your ODBC drivers read-only OR (as I do with SQL) create SQL
Views on the tables I want to use to avoid locks and strictly keep
the data view-only.
>
> In fact, I've created an entire Vantage Intranet using ASP and SQL
and hit our tables, view reports, etc. I even have created an entire
time tracking system for our 100 engineers to enter time to a UD
table against projects and jobs. Once the time has been verified by
their manager, I have a SQL trigger on UD20 that populates LaborHed
and LaborDtl accordingly and safely. All circumventing Vantage.
Saving lots and lots of money initially and annually.
>
> It's great for Execs and certain scenarios where it's ridiculous to
purchase a license for their level of use. It allows me to not have
to purchase a license for Vantage (and thereby not paying annual
maintenance on them, too) for someone who would use Vantage for 5
mins a day or just wants to see Sales to date or oh-hand
inventory.......
>
>
>
>
> Vic Drecchio
> ERP Administrator
> Â
> TIMCO Aviation Services
> Greensboro, NC
> Email:Â Â vic.drecchio@...
> Office:Â 336.668.4410 x3091
> Mobile:Â 704.530.3092
>
>
>
>
> -----Original Message-----
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
Behalf Of nmtaylor1969
> Sent: Tuesday, November 18, 2008 9:55 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: Vantage - Problem with Parts & Costing ID
>
>
> Charlie,
>
> I am interested in your comments here...
>
> Are you saying that you hit the DB directly without going through
the
> business logic...?
>
> I confess I do this every now and again, but it is risky...!
>
> Isn't it like playing Russian Roulette...!?
>
> Thanks,
>
> Nick
>
> --- In vantage@yahoogroups.com, "Charlie Wilson" <foamdesigncsw@>
> wrote:
> >
> > This is true..
> >
> >
> >
> > I like the down and dirty VBS.
> >
> >
> >
> > It took me a little while to figure out the ODBC setup for
progress.
> >
> >
> >
> > I use it for a data pull for a piece of reporting software we
use.
> >
> >
> >
> > Set cn = CreateObject("ADODB.Connection")
> >
> >
> >
> > strCS = "Driver=Progress OpenEdge 10.1B
> >
>
driver;HOST=ERPSERVER;DB=mfgsys;UID=sysprogress;PWD=sysprogress;PORT=8
> 350;"
> >
> >
> >
> > cn.open strCS
> >
> >
> >
> > Set rs = CreateObject("ADODB.recordset")
> >
> >
> >
> > strSQL = "Select statement"
> >
> >
> >
> > rs.open strSQL, cn, 3,3
> >
> >
> >
> > Obvious this is for openedge 10.1B it can be changed to work for
> 10.0
> >
> >
> >
> > If you are every going to do anything like this at any point
never
> do it
> > without through testing. If you can I would recommend building a
> totally
> > different server and loading it with a copy of your DB and test
all
> scripts
> > to make sure you get exactly what you want. I would also
recommend
> that you
> > Kick off all users and make a backup of the DB then make your
> changes.
> > Confirm your changes worked the way you wanted and then allow all
> the other
> > users back in. Doing this will allow you to roll back on your
> backup if
> > something goes wrong.
> >
> > _____
> >
> > From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
> Behalf Of
> > Mark Wonsil
> > Sent: Tuesday, November 18, 2008 9:32 AM
> > To: vantage@yahoogroups.com
> > Subject: RE: [Vantage] Re: Vantage - Problem with Parts & Costing
ID
> >
> >
> >
> > > You can also do this through a VBS script using the ODBC if I
am
> not
> > > mistaken.
> >
> > Or VB.Net through the Business Objects...
> >
> >
> >
> > No virus found in this incoming message.
> > Checked by AVG - http://www.avg.com
> > Version: 8.0.175 / Virus Database: 270.9.4/1794 - Release Date:
> 11/17/2008
> > 5:24 PM
> >
> >
> >
> >
> > [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
>



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

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
2
Hi,

I hope somebody can help.

We have ran into quite a major problem with Vantage 8.03.404 where we have input over 3000 parts in preparation for going live.

Now, during a training session we have discovered that the Parts don't have a Costing ID (the field is blank & greyed out so we are unable to to add it).

We THINK our plant ID was only added a week ago, AFTER all of the part had been added.

Does anybody know of a way that we can add in the Costing ID WITHOUT having to re-input all of our parts?

Now, if we add a new part, the Costing ID is filled in, but that is only good going forward - it will not help the 3000+ parts already inputted.

Any help would be greatly appreciated!!

Thanks,




CHRIS THOMPSON




[Non-text portions of this message have been removed]
3
You may want to check with support, but I thought I saw a conversion
to set cost id added between 403 and 404

--- In vantage@yahoogroups.com, Chris Thompson <chriselectrix@...>
wrote:
>
> Hi,
>
> I hope somebody can help.
>
> We have ran into quite a major problem with Vantage 8.03.404 where
we have input over 3000 parts in preparation for going live.
>
> Now, during a training session we have discovered that the Parts
don't have a Costing ID (the field is blank & greyed out so we are
unable to to add it).
>
> We THINK our plant ID was only added a week ago, AFTER all of the
part had been added.
>
> Does anybody know of a way that we can add in the Costing ID
WITHOUT having to re-input all of our parts?
>
> Now, if we add a new part, the Costing ID is filled in, but that is
only good going forward - it will not help the 3000+ parts already
inputted.
>
> Any help would be greatly appreciated!!
>
> Thanks,
>
>
>
>
> CHRIS THOMPSON
>
>
>
>
> [Non-text portions of this message have been removed]
>
4
Hi,

Where was that conversion?

Cheers,


CHRIS THOMPSON




________________________________
From: bw2868bond <bwalker@...>
To: vantage@yahoogroups.com
Sent: Tuesday, November 18, 2008 12:15:27 PM
Subject: [Vantage] Re: Vantage - Problem with Parts & Costing ID


You may want to check with support, but I thought I saw a conversion
to set cost id added between 403 and 404

--- In vantage@yahoogroups .com, Chris Thompson <chriselectrix@ ...>
wrote:
>
> Hi,
>
> I hope somebody can help.
>
> We have ran into quite a major problem with Vantage 8.03.404 where
we have input over 3000 parts in preparation for going live.
>
> Now, during a training session we have discovered that the Parts
don't have a Costing ID (the field is blank & greyed out so we are
unable to to add it).
>
> We THINK our plant ID was only added a week ago, AFTER all of the
part had been added.
>
> Does anybody know of a way that we can add in the Costing ID
WITHOUT having to re-input all of our parts?
>
> Now, if we add a new part, the Costing ID is filled in, but that is
only good going forward - it will not help the 3000+ parts already
inputted.
>
> Any help would be greatly appreciated! !
>
> Thanks,
>
>
>
>
> CHRIS THOMPSON
>
>
>
>
> [Non-text portions of this message have been removed]
>






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

We are on 8.03.305 and don't have a costing ID field, however if you
have ServiceConnect these sorts of mass changes are a breeze.

I dont know how else you could do this without messing around in the
DB directly, but of course this is a highly dangerous strategy.

Nick

--- In vantage@yahoogroups.com, Chris Thompson <chriselectrix@...>
wrote:
>
> Hi,
>
> I hope somebody can help.
>
> We have ran into quite a major problem with Vantage 8.03.404 where
we have input over 3000 parts in preparation for going live.
>
> Now, during a training session we have discovered that the Parts
don't have a Costing ID (the field is blank & greyed out so we are
unable to to add it).
>
> We THINK our plant ID was only added a week ago, AFTER all of the
part had been added.
>
> Does anybody know of a way that we can add in the Costing ID
WITHOUT having to re-input all of our parts?
>
> Now, if we add a new part, the Costing ID is filled in, but that is
only good going forward - it will not help the 3000+ parts already
inputted.
>
> Any help would be greatly appreciated!!
>
> Thanks,
>
>
>
>
> CHRIS THOMPSON
>
>
>
>
> [Non-text portions of this message have been removed]
>
6
Looks like it was added in 405 - conversion 9762

--- In vantage@yahoogroups.com, Chris Thompson <chriselectrix@...>
wrote:
>
> Hi,
>
> Where was that conversion?
>
> Cheers,
>
>
> CHRIS THOMPSON
>
>
>
>
> ________________________________
> From: bw2868bond <bwalker@...>
> To: vantage@yahoogroups.com
> Sent: Tuesday, November 18, 2008 12:15:27 PM
> Subject: [Vantage] Re: Vantage - Problem with Parts & Costing ID
>
>
> You may want to check with support, but I thought I saw a
conversion
> to set cost id added between 403 and 404
>
> --- In vantage@yahoogroups .com, Chris Thompson
<chriselectrix@ ...>
> wrote:
> >
> > Hi,
> >
> > I hope somebody can help.
> >
> > We have ran into quite a major problem with Vantage 8.03.404
where
> we have input over 3000 parts in preparation for going live.
> >
> > Now, during a training session we have discovered that the Parts
> don't have a Costing ID (the field is blank & greyed out so we are
> unable to to add it).
> >
> > We THINK our plant ID was only added a week ago, AFTER all of the
> part had been added.
> >
> > Does anybody know of a way that we can add in the Costing ID
> WITHOUT having to re-input all of our parts?
> >
> > Now, if we add a new part, the Costing ID is filled in, but that
is
> only good going forward - it will not help the 3000+ parts already
> inputted.
> >
> > Any help would be greatly appreciated! !
> >
> > Thanks,
> >
> >
> >
> >
> > CHRIS THOMPSON
> >
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
7
How do you do conversions - this is all new to me.

Thanks.




________________________________
From: bw2868bond <bwalker@...>
To: vantage@yahoogroups.com
Sent: Tuesday, November 18, 2008 12:45:33 PM
Subject: [Vantage] Re: Vantage - Problem with Parts & Costing ID


Looks like it was added in 405 - conversion 9762

--- In vantage@yahoogroups .com, Chris Thompson <chriselectrix@ ...>
wrote:
>
> Hi,
>
> Where was that conversion?
>
> Cheers,
>
>
> CHRIS THOMPSON
>
>
>
>
> ____________ _________ _________ __
> From: bw2868bond <bwalker@... >
> To: vantage@yahoogroups .com
> Sent: Tuesday, November 18, 2008 12:15:27 PM
> Subject: [Vantage] Re: Vantage - Problem with Parts & Costing ID
>
>
> You may want to check with support, but I thought I saw a
conversion
> to set cost id added between 403 and 404
>
> --- In vantage@yahoogroups .com, Chris Thompson
<chriselectrix@ ...>
> wrote:
> >
> > Hi,
> >
> > I hope somebody can help.
> >
> > We have ran into quite a major problem with Vantage 8.03.404
where
> we have input over 3000 parts in preparation for going live.
> >
> > Now, during a training session we have discovered that the Parts
> don't have a Costing ID (the field is blank & greyed out so we are
> unable to to add it).
> >
> > We THINK our plant ID was only added a week ago, AFTER all of the
> part had been added.
> >
> > Does anybody know of a way that we can add in the Costing ID
> WITHOUT having to re-input all of our parts?
> >
> > Now, if we add a new part, the Costing ID is filled in, but that
is
> only good going forward - it will not help the 3000+ parts already
> inputted.
> >
> > Any help would be greatly appreciated! !
> >
> > Thanks,
> >
> >
> >
> >
> > CHRIS THOMPSON
> >
> >
> >
> >
> > [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]
8
Now that first coffee has taken hold, I think that conversion only
sets cost id for the Plant - not on individual parts.

I think contacting support is your best option. They can probably set
you up with a one time procedure to accomplish what you need.

good luck

--- In vantage@yahoogroups.com, Chris Thompson <chriselectrix@...>
wrote:
>
> How do you do conversions - this is all new to me.
>
> Thanks.
>
>
>
>
> ________________________________
> From: bw2868bond <bwalker@...>
> To: vantage@yahoogroups.com
> Sent: Tuesday, November 18, 2008 12:45:33 PM
> Subject: [Vantage] Re: Vantage - Problem with Parts & Costing ID
>
>
> Looks like it was added in 405 - conversion 9762
>
> --- In vantage@yahoogroups .com, Chris Thompson
<chriselectrix@ ...>
> wrote:
> >
> > Hi,
> >
> > Where was that conversion?
> >
> > Cheers,
> >
> >
> > CHRIS THOMPSON
> >
> >
> >
> >
> > ____________ _________ _________ __
> > From: bw2868bond <bwalker@ >
> > To: vantage@yahoogroups .com
> > Sent: Tuesday, November 18, 2008 12:15:27 PM
> > Subject: [Vantage] Re: Vantage - Problem with Parts & Costing ID
> >
> >
> > You may want to check with support, but I thought I saw a
> conversion
> > to set cost id added between 403 and 404
> >
> > --- In vantage@yahoogroups .com, Chris Thompson
> <chriselectrix@ ...>
> > wrote:
> > >
> > > Hi,
> > >
> > > I hope somebody can help.
> > >
> > > We have ran into quite a major problem with Vantage 8.03.404
> where
> > we have input over 3000 parts in preparation for going live.
> > >
> > > Now, during a training session we have discovered that the
Parts
> > don't have a Costing ID (the field is blank & greyed out so we
are
> > unable to to add it).
> > >
> > > We THINK our plant ID was only added a week ago, AFTER all of
the
> > part had been added.
> > >
> > > Does anybody know of a way that we can add in the Costing ID
> > WITHOUT having to re-input all of our parts?
> > >
> > > Now, if we add a new part, the Costing ID is filled in, but
that
> is
> > only good going forward - it will not help the 3000+ parts
already
> > inputted.
> > >
> > > Any help would be greatly appreciated! !
> > >
> > > Thanks,
> > >
> > >
> > >
> > >
> > > CHRIS THOMPSON
> > >
> > >
> > >
> > >
> > > [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]
>
9
I think I'll need it!! :-)




________________________________
From: bw2868bond <bwalker@...>
To: vantage@yahoogroups.com
Sent: Tuesday, November 18, 2008 1:02:05 PM
Subject: [Vantage] Re: Vantage - Problem with Parts & Costing ID


Now that first coffee has taken hold, I think that conversion only
sets cost id for the Plant - not on individual parts.

I think contacting support is your best option. They can probably set
you up with a one time procedure to accomplish what you need.

good luck

--- In vantage@yahoogroups .com, Chris Thompson <chriselectrix@ ...>
wrote:
>
> How do you do conversions - this is all new to me.
>
> Thanks.
>
>
>
>
> ____________ _________ _________ __
> From: bw2868bond <bwalker@... >
> To: vantage@yahoogroups .com
> Sent: Tuesday, November 18, 2008 12:45:33 PM
> Subject: [Vantage] Re: Vantage - Problem with Parts & Costing ID
>
>
> Looks like it was added in 405 - conversion 9762
>
> --- In vantage@yahoogroups .com, Chris Thompson
<chriselectrix@ ...>
> wrote:
> >
> > Hi,
> >
> > Where was that conversion?
> >
> > Cheers,
> >
> >
> > CHRIS THOMPSON
> >
> >
> >
> >
> > ____________ _________ _________ __
> > From: bw2868bond <bwalker@ >
> > To: vantage@yahoogroups .com
> > Sent: Tuesday, November 18, 2008 12:15:27 PM
> > Subject: [Vantage] Re: Vantage - Problem with Parts & Costing ID
> >
> >
> > You may want to check with support, but I thought I saw a
> conversion
> > to set cost id added between 403 and 404
> >
> > --- In vantage@yahoogroups .com, Chris Thompson
> <chriselectrix@ ...>
> > wrote:
> > >
> > > Hi,
> > >
> > > I hope somebody can help.
> > >
> > > We have ran into quite a major problem with Vantage 8.03.404
> where
> > we have input over 3000 parts in preparation for going live.
> > >
> > > Now, during a training session we have discovered that the
Parts
> > don't have a Costing ID (the field is blank & greyed out so we
are
> > unable to to add it).
> > >
> > > We THINK our plant ID was only added a week ago, AFTER all of
the
> > part had been added.
> > >
> > > Does anybody know of a way that we can add in the Costing ID
> > WITHOUT having to re-input all of our parts?
> > >
> > > Now, if we add a new part, the Costing ID is filled in, but
that
> is
> > only good going forward - it will not help the 3000+ parts
already
> > inputted.
> > >
> > > Any help would be greatly appreciated! !
> > >
> > > Thanks,
> > >
> > >
> > >
> > >
> > > CHRIS THOMPSON
> > >
> > >
> > >
> > >
> > > [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]
10
Good Morning Everyone,



I am trying to create a bpm that will alert the user entering an order
that the customer is COD. I have created a bpm that I thought would
work but it does not and I do not understand why. Has anyone created a
bpm like this or can someone tell me what I did wrong on mine? Here is
what I have:



Method Code: SalesOrder.Update



Pre-Processing Method



Condition:

The number of row in the query is more then 0



The query is: for each ttOrderHed where (ttOrderHed.RowMod = 'A' or
ttOrderHed.RowMod = 'U') , each Customer where Customer.Company =
ttOrderHed.Company and Customer.CustID = ttOrderHed.CustomerCustID and
Customer.COD = True no-lock





Actions:



Show an informational message





Thanks in advance for all of the help! J



Dale





From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Chris Thompson
Sent: Tuesday, November 18, 2008 6:47 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Re: Vantage - Problem with Parts & Costing ID



How do you do conversions - this is all new to me.

Thanks.

________________________________
From: bw2868bond <bwalker@...
<mailto:bwalker%40adcocircuits.com> >
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Sent: Tuesday, November 18, 2008 12:45:33 PM
Subject: [Vantage] Re: Vantage - Problem with Parts & Costing ID

Looks like it was added in 405 - conversion 9762

--- In vantage@yahoogroups .com, Chris Thompson <chriselectrix@ ...>
wrote:
>
> Hi,
>
> Where was that conversion?
>
> Cheers,
>
>
> CHRIS THOMPSON
>
>
>
>
> ____________ _________ _________ __
> From: bw2868bond <bwalker@... >
> To: vantage@yahoogroups .com
> Sent: Tuesday, November 18, 2008 12:15:27 PM
> Subject: [Vantage] Re: Vantage - Problem with Parts & Costing ID
>
>
> You may want to check with support, but I thought I saw a
conversion
> to set cost id added between 403 and 404
>
> --- In vantage@yahoogroups .com, Chris Thompson
<chriselectrix@ ...>
> wrote:
> >
> > Hi,
> >
> > I hope somebody can help.
> >
> > We have ran into quite a major problem with Vantage 8.03.404
where
> we have input over 3000 parts in preparation for going live.
> >
> > Now, during a training session we have discovered that the Parts
> don't have a Costing ID (the field is blank & greyed out so we are
> unable to to add it).
> >
> > We THINK our plant ID was only added a week ago, AFTER all of the
> part had been added.
> >
> > Does anybody know of a way that we can add in the Costing ID
> WITHOUT having to re-input all of our parts?
> >
> > Now, if we add a new part, the Costing ID is filled in, but that
is
> only good going forward - it will not help the 3000+ parts already
> inputted.
> >
> > Any help would be greatly appreciated! !
> >
> > Thanks,
> >
> >
> >
> >
> > CHRIS THOMPSON
> >
> >
> >
> >
> > [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]
11
I know messing around in the database can be dangerous but in this case it would be advantageous with minimal consequences. Other than the Plant table the Part Cost table is the only table that contains the Cost Id field. Since you only have about 3000 parts an update query in Microsoft Access can perform the necessary function for you in a matter of minutes and would be easy to undo if necessary. All the query would need to do is set the cost id field to match what you now have in your Plant record.

Of course, this is a personal opinion only and I would also not normally recommend this. I did update queries several times during our implementation phase because of incomplete information during the import procedures we had. The procedures were changed to include the necessary information but I did the queries to keep from having to re-import since the import process for us took several hours. I never had an issue afterwards.


----- Original Message -----
From: Chris Thompson
To: vantage@yahoogroups.com
Sent: Tuesday, November 18, 2008 7:13 AM
Subject: Re: [Vantage] Re: Vantage - Problem with Parts & Costing ID


I think I'll need it!! :-)

________________________________
From: bw2868bond <bwalker@...>
To: vantage@yahoogroups.com
Sent: Tuesday, November 18, 2008 1:02:05 PM
Subject: [Vantage] Re: Vantage - Problem with Parts & Costing ID

Now that first coffee has taken hold, I think that conversion only
sets cost id for the Plant - not on individual parts.

I think contacting support is your best option. They can probably set
you up with a one time procedure to accomplish what you need.

good luck

--- In vantage@yahoogroups .com, Chris Thompson <chriselectrix@ ...>
wrote:
>
> How do you do conversions - this is all new to me.
>
> Thanks.
>
>
>
>
> ____________ _________ _________ __
> From: bw2868bond <bwalker@... >
> To: vantage@yahoogroups .com
> Sent: Tuesday, November 18, 2008 12:45:33 PM
> Subject: [Vantage] Re: Vantage - Problem with Parts & Costing ID
>
>
> Looks like it was added in 405 - conversion 9762
>
> --- In vantage@yahoogroups .com, Chris Thompson
<chriselectrix@ ...>
> wrote:
> >
> > Hi,
> >
> > Where was that conversion?
> >
> > Cheers,
> >
> >
> > CHRIS THOMPSON
> >
> >
> >
> >
> > ____________ _________ _________ __
> > From: bw2868bond <bwalker@ >
> > To: vantage@yahoogroups .com
> > Sent: Tuesday, November 18, 2008 12:15:27 PM
> > Subject: [Vantage] Re: Vantage - Problem with Parts & Costing ID
> >
> >
> > You may want to check with support, but I thought I saw a
> conversion
> > to set cost id added between 403 and 404
> >
> > --- In vantage@yahoogroups .com, Chris Thompson
> <chriselectrix@ ...>
> > wrote:
> > >
> > > Hi,
> > >
> > > I hope somebody can help.
> > >
> > > We have ran into quite a major problem with Vantage 8.03.404
> where
> > we have input over 3000 parts in preparation for going live.
> > >
> > > Now, during a training session we have discovered that the
Parts
> > don't have a Costing ID (the field is blank & greyed out so we
are
> > unable to to add it).
> > >
> > > We THINK our plant ID was only added a week ago, AFTER all of
the
> > part had been added.
> > >
> > > Does anybody know of a way that we can add in the Costing ID
> > WITHOUT having to re-input all of our parts?
> > >
> > > Now, if we add a new part, the Costing ID is filled in, but
that
> is
> > only good going forward - it will not help the 3000+ parts
already
> > inputted.
> > >
> > > Any help would be greatly appreciated! !
> > >
> > > Thanks,
> > >
> > >
> > >
> > >
> > > CHRIS THOMPSON
> > >
> > >
> > >
> > >
> > > [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]




Charles Carden
IT Manager
Manitex, Inc.


[Non-text portions of this message have been removed]
12
You can also do this through a VBS script using the ODBC if I am not
mistaken.



Access is probably easier though.



~Charlie



_____

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Charles Carden
Sent: Tuesday, November 18, 2008 9:14 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Re: Vantage - Problem with Parts & Costing ID



I know messing around in the database can be dangerous but in this case it
would be advantageous with minimal consequences. Other than the Plant table
the Part Cost table is the only table that contains the Cost Id field. Since
you only have about 3000 parts an update query in Microsoft Access can
perform the necessary function for you in a matter of minutes and would be
easy to undo if necessary. All the query would need to do is set the cost id
field to match what you now have in your Plant record.

Of course, this is a personal opinion only and I would also not normally
recommend this. I did update queries several times during our implementation
phase because of incomplete information during the import procedures we had.
The procedures were changed to include the necessary information but I did
the queries to keep from having to re-import since the import process for us
took several hours. I never had an issue afterwards.

----- Original Message -----
From: Chris Thompson
To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
Sent: Tuesday, November 18, 2008 7:13 AM
Subject: Re: [Vantage] Re: Vantage - Problem with Parts & Costing ID

I think I'll need it!! :-)

________________________________
From: bw2868bond <bwalker@adcocircuit <mailto:bwalker%40adcocircuits.com>
s.com>
To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
Sent: Tuesday, November 18, 2008 1:02:05 PM
Subject: [Vantage] Re: Vantage - Problem with Parts & Costing ID

Now that first coffee has taken hold, I think that conversion only
sets cost id for the Plant - not on individual parts.

I think contacting support is your best option. They can probably set
you up with a one time procedure to accomplish what you need.

good luck

--- In vantage@yahoogroups .com, Chris Thompson <chriselectrix@ ...>
wrote:
>
> How do you do conversions - this is all new to me.
>
> Thanks.
>
>
>
>
> ____________ _________ _________ __
> From: bw2868bond <bwalker@... >
> To: vantage@yahoogroups .com
> Sent: Tuesday, November 18, 2008 12:45:33 PM
> Subject: [Vantage] Re: Vantage - Problem with Parts & Costing ID
>
>
> Looks like it was added in 405 - conversion 9762
>
> --- In vantage@yahoogroups .com, Chris Thompson
<chriselectrix@ ...>
> wrote:
> >
> > Hi,
> >
> > Where was that conversion?
> >
> > Cheers,
> >
> >
> > CHRIS THOMPSON
> >
> >
> >
> >
> > ____________ _________ _________ __
> > From: bw2868bond <bwalker@ >
> > To: vantage@yahoogroups .com
> > Sent: Tuesday, November 18, 2008 12:15:27 PM
> > Subject: [Vantage] Re: Vantage - Problem with Parts & Costing ID
> >
> >
> > You may want to check with support, but I thought I saw a
> conversion
> > to set cost id added between 403 and 404
> >
> > --- In vantage@yahoogroups .com, Chris Thompson
> <chriselectrix@ ...>
> > wrote:
> > >
> > > Hi,
> > >
> > > I hope somebody can help.
> > >
> > > We have ran into quite a major problem with Vantage 8.03.404
> where
> > we have input over 3000 parts in preparation for going live.
> > >
> > > Now, during a training session we have discovered that the
Parts
> > don't have a Costing ID (the field is blank & greyed out so we
are
> > unable to to add it).
> > >
> > > We THINK our plant ID was only added a week ago, AFTER all of
the
> > part had been added.
> > >
> > > Does anybody know of a way that we can add in the Costing ID
> > WITHOUT having to re-input all of our parts?
> > >
> > > Now, if we add a new part, the Costing ID is filled in, but
that
> is
> > only good going forward - it will not help the 3000+ parts
already
> > inputted.
> > >
> > > Any help would be greatly appreciated! !
> > >
> > > Thanks,
> > >
> > >
> > >
> > >
> > > CHRIS THOMPSON
> > >
> > >
> > >
> > >
> > > [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]

Charles Carden
IT Manager
Manitex, Inc.

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



No virus found in this incoming message.
Checked by AVG - http://www.avg.com
Version: 8.0.175 / Virus Database: 270.9.4/1794 - Release Date: 11/17/2008
5:24 PM




[Non-text portions of this message have been removed]
13
> You can also do this through a VBS script using the ODBC if I am not
> mistaken.

Or VB.Net through the Business Objects...
14
This is true..



I like the down and dirty VBS.



It took me a little while to figure out the ODBC setup for progress.



I use it for a data pull for a piece of reporting software we use.



Set cn = CreateObject("ADODB.Connection")



strCS = "Driver=Progress OpenEdge 10.1B
driver;HOST=ERPSERVER;DB=mfgsys;UID=sysprogress;PWD=sysprogress;PORT=8350;"



cn.open strCS



Set rs = CreateObject("ADODB.recordset")



strSQL = "Select statement"



rs.open strSQL, cn, 3,3



Obvious this is for openedge 10.1B it can be changed to work for 10.0



If you are every going to do anything like this at any point never do it
without through testing. If you can I would recommend building a totally
different server and loading it with a copy of your DB and test all scripts
to make sure you get exactly what you want. I would also recommend that you
Kick off all users and make a backup of the DB then make your changes.
Confirm your changes worked the way you wanted and then allow all the other
users back in. Doing this will allow you to roll back on your backup if
something goes wrong.

_____

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Mark Wonsil
Sent: Tuesday, November 18, 2008 9:32 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: Vantage - Problem with Parts & Costing ID



> You can also do this through a VBS script using the ODBC if I am not
> mistaken.

Or VB.Net through the Business Objects...



No virus found in this incoming message.
Checked by AVG - http://www.avg.com
Version: 8.0.175 / Virus Database: 270.9.4/1794 - Release Date: 11/17/2008
5:24 PM




[Non-text portions of this message have been removed]
15
Hi Dale,

First, I'd use the SalesOrder.ChangeCustomer method instead of the
Update method.

Then a slight change to your query: for each ttOrderHed where
(ttOrderHed.RowMod = 'A' or ttOrderHed.RowMod = 'U') , each Customer
where Customer.Company = ttOrderHed.Company and Customer.Custnum =
ttOrderHed.Custnum and Customer.COD = True no-lock

and you should be ok.

Nigel.


--- In vantage@yahoogroups.com, "Dale R. Kalsow" <dale.r.kalsow@...>
wrote:
>
> Good Morning Everyone,
>
>
>
> I am trying to create a bpm that will alert the user entering an
order
> that the customer is COD. I have created a bpm that I thought would
> work but it does not and I do not understand why. Has anyone
created a
> bpm like this or can someone tell me what I did wrong on mine?
Here is
> what I have:
>
>
>
> Method Code: SalesOrder.Update
>
>
>
> Pre-Processing Method
>
>
>
> Condition:
>
> The number of row in the query is more then 0
>
>
>
> The query is: for each ttOrderHed where (ttOrderHed.RowMod = 'A' or
> ttOrderHed.RowMod = 'U') , each Customer where Customer.Company =
> ttOrderHed.Company and Customer.CustID = ttOrderHed.CustomerCustID
and
> Customer.COD = True no-lock
>
>
>
>
>
> Actions:
>
>
>
> Show an informational message
>
>
>
>
>
> Thanks in advance for all of the help! J
>
>
>
> Dale
>
>
>
>
>
16
Charlie,

I am interested in your comments here...

Are you saying that you hit the DB directly without going through the
business logic...?

I confess I do this every now and again, but it is risky...!

Isn't it like playing Russian Roulette...!?

Thanks,

Nick

--- In vantage@yahoogroups.com, "Charlie Wilson" <foamdesigncsw@...>
wrote:
>
> This is true..
>
>
>
> I like the down and dirty VBS.
>
>
>
> It took me a little while to figure out the ODBC setup for progress.
>
>
>
> I use it for a data pull for a piece of reporting software we use.
>
>
>
> Set cn = CreateObject("ADODB.Connection")
>
>
>
> strCS = "Driver=Progress OpenEdge 10.1B
>
driver;HOST=ERPSERVER;DB=mfgsys;UID=sysprogress;PWD=sysprogress;PORT=8
350;"
>
>
>
> cn.open strCS
>
>
>
> Set rs = CreateObject("ADODB.recordset")
>
>
>
> strSQL = "Select statement"
>
>
>
> rs.open strSQL, cn, 3,3
>
>
>
> Obvious this is for openedge 10.1B it can be changed to work for
10.0
>
>
>
> If you are every going to do anything like this at any point never
do it
> without through testing. If you can I would recommend building a
totally
> different server and loading it with a copy of your DB and test all
scripts
> to make sure you get exactly what you want. I would also recommend
that you
> Kick off all users and make a backup of the DB then make your
changes.
> Confirm your changes worked the way you wanted and then allow all
the other
> users back in. Doing this will allow you to roll back on your
backup if
> something goes wrong.
>
> _____
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
Behalf Of
> Mark Wonsil
> Sent: Tuesday, November 18, 2008 9:32 AM
> To: vantage@yahoogroups.com
> Subject: RE: [Vantage] Re: Vantage - Problem with Parts & Costing ID
>
>
>
> > You can also do this through a VBS script using the ODBC if I am
not
> > mistaken.
>
> Or VB.Net through the Business Objects...
>
>
>
> No virus found in this incoming message.
> Checked by AVG - http://www.avg.com
> Version: 8.0.175 / Virus Database: 270.9.4/1794 - Release Date:
11/17/2008
> 5:24 PM
>
>
>
>
> [Non-text portions of this message have been removed]
>
17
It basically does the same thing as using SQL Explorer to run SQL up against
the DB.



So it is basically a direct connection into the DB.



I only use it to pull Data off the database never to manipulate. But in
theory it can be done.



~Charlie



_____

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
nmtaylor1969
Sent: Tuesday, November 18, 2008 9:55 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Vantage - Problem with Parts & Costing ID




Charlie,

I am interested in your comments here...

Are you saying that you hit the DB directly without going through the
business logic...?

I confess I do this every now and again, but it is risky...!

Isn't it like playing Russian Roulette...!?

Thanks,

Nick

--- In vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com, "Charlie
Wilson" <foamdesigncsw@...>
wrote:
>
> This is true..
>
>
>
> I like the down and dirty VBS.
>
>
>
> It took me a little while to figure out the ODBC setup for progress.
>
>
>
> I use it for a data pull for a piece of reporting software we use.
>
>
>
> Set cn = CreateObject("ADODB.Connection")
>
>
>
> strCS = "Driver=Progress OpenEdge 10.1B
>
driver;HOST=ERPSERVER;DB=mfgsys;UID=sysprogress;PWD=sysprogress;PORT=8
350;"
>
>
>
> cn.open strCS
>
>
>
> Set rs = CreateObject("ADODB.recordset")
>
>
>
> strSQL = "Select statement"
>
>
>
> rs.open strSQL, cn, 3,3
>
>
>
> Obvious this is for openedge 10.1B it can be changed to work for
10.0
>
>
>
> If you are every going to do anything like this at any point never
do it
> without through testing. If you can I would recommend building a
totally
> different server and loading it with a copy of your DB and test all
scripts
> to make sure you get exactly what you want. I would also recommend
that you
> Kick off all users and make a backup of the DB then make your
changes.
> Confirm your changes worked the way you wanted and then allow all
the other
> users back in. Doing this will allow you to roll back on your
backup if
> something goes wrong.
>
> _____
>
> From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
[mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com] On
Behalf Of
> Mark Wonsil
> Sent: Tuesday, November 18, 2008 9:32 AM
> To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
> Subject: RE: [Vantage] Re: Vantage - Problem with Parts & Costing ID
>
>
>
> > You can also do this through a VBS script using the ODBC if I am
not
> > mistaken.
>
> Or VB.Net through the Business Objects...
>
>
>
> No virus found in this incoming message.
> Checked by AVG - http://www.avg <http://www.avg.com> com
> Version: 8.0.175 / Virus Database: 270.9.4/1794 - Release Date:
11/17/2008
> 5:24 PM
>
>
>
>
> [Non-text portions of this message have been removed]
>



No virus found in this incoming message.
Checked by AVG - http://www.avg.com
Version: 8.0.175 / Virus Database: 270.9.4/1794 - Release Date: 11/17/2008
5:24 PM




[Non-text portions of this message have been removed]
18
I regularly use SQL to post updates directly to the DB. To be honest,
I couldn't get by without it: we have had occasions where journals
have posted with lines missing, AR allocations have gone wrong, or
mass updates need to be done.

Epicor frown very heavily on it and I would be extremely reluctant to
offer advice on doing it - if you don't know how to do it, you really
shouldn't be doing it! You could easily destroy your entire database.

Even though I'm reasonably comfortable with it, I still take my time
with every update before I finally commit it. I've haven't had any
problems yet - touch wood!

Nigel.

--- In vantage@yahoogroups.com, "Charlie Wilson" <foamdesigncsw@...>
wrote:
>
> It basically does the same thing as using SQL Explorer to run SQL
up against
> the DB.
>
>
>
> So it is basically a direct connection into the DB.
>
>
>
> I only use it to pull Data off the database never to manipulate.
But in
> theory it can be done.
>
>
>
> ~Charlie
>
>
>
> _____
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
Behalf Of
> nmtaylor1969
> Sent: Tuesday, November 18, 2008 9:55 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: Vantage - Problem with Parts & Costing ID
>
>
>
>
> Charlie,
>
> I am interested in your comments here...
>
> Are you saying that you hit the DB directly without going through
the
> business logic...?
>
> I confess I do this every now and again, but it is risky...!
>
> Isn't it like playing Russian Roulette...!?
>
> Thanks,
>
> Nick
>
> --- In vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com,
"Charlie
> Wilson" <foamdesigncsw@>
> wrote:
> >
> > This is true..
> >
> >
> >
> > I like the down and dirty VBS.
> >
> >
> >
> > It took me a little while to figure out the ODBC setup for
progress.
> >
> >
> >
> > I use it for a data pull for a piece of reporting software we
use.
> >
> >
> >
> > Set cn = CreateObject("ADODB.Connection")
> >
> >
> >
> > strCS = "Driver=Progress OpenEdge 10.1B
> >
>
driver;HOST=ERPSERVER;DB=mfgsys;UID=sysprogress;PWD=sysprogress;PORT=8
> 350;"
> >
> >
> >
> > cn.open strCS
> >
> >
> >
> > Set rs = CreateObject("ADODB.recordset")
> >
> >
> >
> > strSQL = "Select statement"
> >
> >
> >
> > rs.open strSQL, cn, 3,3
> >
> >
> >
> > Obvious this is for openedge 10.1B it can be changed to work for
> 10.0
> >
> >
> >
> > If you are every going to do anything like this at any point
never
> do it
> > without through testing. If you can I would recommend building a
> totally
> > different server and loading it with a copy of your DB and test
all
> scripts
> > to make sure you get exactly what you want. I would also
recommend
> that you
> > Kick off all users and make a backup of the DB then make your
> changes.
> > Confirm your changes worked the way you wanted and then allow all
> the other
> > users back in. Doing this will allow you to roll back on your
> backup if
> > something goes wrong.
> >
> > _____
> >
> > From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
> [mailto:vantage@yahoogroups <mailto:vantage
%40yahoogroups.com> .com] On
> Behalf Of
> > Mark Wonsil
> > Sent: Tuesday, November 18, 2008 9:32 AM
> > To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
> > Subject: RE: [Vantage] Re: Vantage - Problem with Parts & Costing
ID
> >
> >
> >
> > > You can also do this through a VBS script using the ODBC if I
am
> not
> > > mistaken.
> >
> > Or VB.Net through the Business Objects...
> >
> >
> >
> > No virus found in this incoming message.
> > Checked by AVG - http://www.avg <http://www.avg.com> com
> > Version: 8.0.175 / Virus Database: 270.9.4/1794 - Release Date:
> 11/17/2008
> > 5:24 PM
> >
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
>
>
> No virus found in this incoming message.
> Checked by AVG - http://www.avg.com
> Version: 8.0.175 / Virus Database: 270.9.4/1794 - Release Date:
11/17/2008
> 5:24 PM
>
>
>
>
> [Non-text portions of this message have been removed]
>
19
It's risky to *populate* the database circumventing the Vantage biz logic.

It's *never* risky to VIEW data via circumventing Vantage. It may be slow or it may be inaccurate, but it's not "risky". I do it all the time. If you are just viewing data (no modify, insert, update, etc), there is zero risk. If you choose to go this route, either make your ODBC drivers read-only OR (as I do with SQL) create SQL Views on the tables I want to use to avoid locks and strictly keep the data view-only.

In fact, I've created an entire Vantage Intranet using ASP and SQL and hit our tables, view reports, etc. I even have created an entire time tracking system for our 100 engineers to enter time to a UD table against projects and jobs. Once the time has been verified by their manager, I have a SQL trigger on UD20 that populates LaborHed and LaborDtl accordingly and safely. All circumventing Vantage. Saving lots and lots of money initially and annually.

It's great for Execs and certain scenarios where it's ridiculous to purchase a license for their level of use. It allows me to not have to purchase a license for Vantage (and thereby not paying annual maintenance on them, too) for someone who would use Vantage for 5 mins a day or just wants to see Sales to date or oh-hand inventory.......




Vic Drecchio
ERP Administrator
Â
TIMCO Aviation Services
Greensboro, NC
Email:Â Â vic.drecchio@...
Office:Â 336.668.4410 x3091
Mobile:Â 704.530.3092




-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of nmtaylor1969
Sent: Tuesday, November 18, 2008 9:55 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Vantage - Problem with Parts & Costing ID


Charlie,

I am interested in your comments here...

Are you saying that you hit the DB directly without going through the
business logic...?

I confess I do this every now and again, but it is risky...!

Isn't it like playing Russian Roulette...!?

Thanks,

Nick

--- In vantage@yahoogroups.com, "Charlie Wilson" <foamdesigncsw@...>
wrote:
>
> This is true..
>
>
>
> I like the down and dirty VBS.
>
>
>
> It took me a little while to figure out the ODBC setup for progress.
>
>
>
> I use it for a data pull for a piece of reporting software we use.
>
>
>
> Set cn = CreateObject("ADODB.Connection")
>
>
>
> strCS = "Driver=Progress OpenEdge 10.1B
>
driver;HOST=ERPSERVER;DB=mfgsys;UID=sysprogress;PWD=sysprogress;PORT=8
350;"
>
>
>
> cn.open strCS
>
>
>
> Set rs = CreateObject("ADODB.recordset")
>
>
>
> strSQL = "Select statement"
>
>
>
> rs.open strSQL, cn, 3,3
>
>
>
> Obvious this is for openedge 10.1B it can be changed to work for
10.0
>
>
>
> If you are every going to do anything like this at any point never
do it
> without through testing. If you can I would recommend building a
totally
> different server and loading it with a copy of your DB and test all
scripts
> to make sure you get exactly what you want. I would also recommend
that you
> Kick off all users and make a backup of the DB then make your
changes.
> Confirm your changes worked the way you wanted and then allow all
the other
> users back in. Doing this will allow you to roll back on your
backup if
> something goes wrong.
>
> _____
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
Behalf Of
> Mark Wonsil
> Sent: Tuesday, November 18, 2008 9:32 AM
> To: vantage@yahoogroups.com
> Subject: RE: [Vantage] Re: Vantage - Problem with Parts & Costing ID
>
>
>
> > You can also do this through a VBS script using the ODBC if I am
not
> > mistaken.
>
> Or VB.Net through the Business Objects...
>
>
>
> No virus found in this incoming message.
> Checked by AVG - http://www.avg.com
> Version: 8.0.175 / Virus Database: 270.9.4/1794 - Release Date:
11/17/2008
> 5:24 PM
>
>
>
>
> [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
20
I think I might let Epicor have a look at this one.

In the meantime I have a Crystal BOM report but I need to ODBC from Crystal to Vantage to view the data.

Any ideas?




________________________________
From: Charlie Wilson <foamdesigncsw@...>
To: vantage@yahoogroups..com
Sent: Tuesday, November 18, 2008 2:43:29 PM
Subject: RE: [Vantage] Re: Vantage - Problem with Parts & Costing ID


This is true..

I like the down and dirty VBS.

It took me a little while to figure out the ODBC setup for progress.

I use it for a data pull for a piece of reporting software we use.

Set cn = CreateObject( "ADODB.Connectio n")

strCS = "Driver=Progress OpenEdge 10.1B
driver;HOST= ERPSERVER; DB=mfgsys; UID=sysprogress; PWD=sysprogress; PORT=8350; "

cn.open strCS

Set rs = CreateObject( "ADODB.recordset ")

strSQL = "Select statement"

rs.open strSQL, cn, 3,3

Obvious this is for openedge 10.1B it can be changed to work for 10.0

If you are every going to do anything like this at any point never do it
without through testing. If you can I would recommend building a totally
different server and loading it with a copy of your DB and test all scripts
to make sure you get exactly what you want. I would also recommend that you
Kick off all users and make a backup of the DB then make your changes.
Confirm your changes worked the way you wanted and then allow all the other
users back in. Doing this will allow you to roll back on your backup if
something goes wrong.

_____

From: vantage@yahoogroups .com [mailto:vantage@yahoogroups .com] On Behalf Of
Mark Wonsil
Sent: Tuesday, November 18, 2008 9:32 AM
To: vantage@yahoogroups .com
Subject: RE: [Vantage] Re: Vantage - Problem with Parts & Costing ID

> You can also do this through a VBS script using the ODBC if I am not
> mistaken.

Or VB.Net through the Business Objects...

No virus found in this incoming message.
Checked by AVG - http://www.avg com
Version: 8.0.175 / Virus Database: 270.9.4/1794 - Release Date: 11/17/2008
5:24 PM

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






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