Massive Part primary warehouse change

Look into the Engineering Data Load Tool. It is based on Service Connect
and is sold by the Professional Services Group. It can modify all data on
the Part, Rev, BOM, or Operation.



John Warshawer

<mailto:john@...> john at jdwconsulting.com

Office: (520) 577-4530

Mobile: (520) 990-6345



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Butler, Bruce
Sent: Tuesday, April 08, 2008 10:02 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Massive Part primary warehouse change



Is there a way I can connect to the database via Excel, not using ODBC,
change the primary plant for a massive list of parts, and have the
system manage the normal referential updates such as adding the new
warehouse to the PartWhse table?

Thanks,

Bruce

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





[Non-text portions of this message have been removed]
Is there a way I can connect to the database via Excel, not using ODBC,
change the primary plant for a massive list of parts, and have the
system manage the normal referential updates such as adding the new
warehouse to the PartWhse table?



Thanks,

Bruce





[Non-text portions of this message have been removed]
I have been tasked to do a similar thing with the G/L account in the
Part table. (some parts have G/L accounts associated, some don't).
Other than manual entry and ODBC, the only way I know about is
ServiceConnect, which isn't cheap if you don't have it already.

--- In vantage@yahoogroups.com, "Butler, Bruce" <bbutler@...> wrote:
>
> Is there a way I can connect to the database via Excel, not using ODBC,
> change the primary plant for a massive list of parts, and have the
> system manage the normal referential updates such as adding the new
> warehouse to the PartWhse table?
>
>
>
> Thanks,
>
> Bruce
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
You can always use the Business Objects in a .net application
(asp.net, vb.net, c#) Although I haven't tried them, MS has express
versions of the visual studio apps that are free.

.02 - bw

--- In vantage@yahoogroups.com, "jkeyes0" <jordan.keyes@...> wrote:
>
> I have been tasked to do a similar thing with the G/L account in the
> Part table. (some parts have G/L accounts associated, some don't).
> Other than manual entry and ODBC, the only way I know about is
> ServiceConnect, which isn't cheap if you don't have it already.
>
> --- In vantage@yahoogroups.com, "Butler, Bruce" <bbutler@> wrote:
> >
> > Is there a way I can connect to the database via Excel, not using
ODBC,
> > change the primary plant for a massive list of parts, and have the
> > system manage the normal referential updates such as adding the
new
> > warehouse to the PartWhse table?
> >
> >
> >
> > Thanks,
> >
> > Bruce
> >
> >
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
> I have been tasked to do a similar thing with the G/L account in the
> Part table. (some parts have G/L accounts associated, some don't).
> Other than manual entry and ODBC, the only way I know about is
> ServiceConnect, which isn't cheap if you don't have it already.

You should be able to do it with .Net programming going against the Business
Objects directly. I've posted some samples here earlier but feel free to ask
for further direction.

Mark W.
I have a looming project with a similar need to (likely have to) bring 404 (mutli-table) data into Excel WITHOUT utilizing simple (but prone to bogging down the system) SQL/ODBC.

I was going to investigate using a BAQ report that dumps the results to and XML file. Supposedly, Excel is able to utilize XML (but I've yet to try).

Any one out there have experience successfully doing anything like this?

Rob Brown

"Butler, Bruce" <bbutler@...> wrote:
Is there a way I can connect to the database via Excel, not using ODBC,
change the primary plant for a massive list of parts, and have the
system manage the normal referential updates such as adding the new
warehouse to the PartWhse table?

Thanks,

Bruce

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






---------------------------------
You rock. That's why Blockbuster's offering you one month of Blockbuster Total Access, No Cost.

[Non-text portions of this message have been removed]
Just out of curiosity, if all you are doing is reading data what is the
aversion to utilizing ODBC?



Regards,



Michael



Michael Barry
Aspacia Systems Inc
866.566.9600
312.803.0730 fax
<http://www.aspacia.com/> http://www.aspacia.com/




From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Robert Brown
Sent: Tuesday, April 08, 2008 1:06 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Massive Part primary warehouse change



I have a looming project with a similar need to (likely have to) bring 404
(mutli-table) data into Excel WITHOUT utilizing simple (but prone to bogging
down the system) SQL/ODBC.

I was going to investigate using a BAQ report that dumps the results to and
XML file. Supposedly, Excel is able to utilize XML (but I've yet to try).

Any one out there have experience successfully doing anything like this?

Rob Brown

"Butler, Bruce" <bbutler@... <mailto:bbutler%40sawing.com> > wrote:
Is there a way I can connect to the database via Excel, not using ODBC,
change the primary plant for a massive list of parts, and have the
system manage the normal referential updates such as adding the new
warehouse to the PartWhse table?

Thanks,

Bruce

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

---------------------------------
You rock. That's why Blockbuster's offering you one month of Blockbuster
Total Access, No Cost.

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





[Non-text portions of this message have been removed]
I have parts that are purchased for standard methods.
However, I have odd numbers of different parts for whatever reason.

I am looking for the easiest way to pull up a part number for a completed manufactured product and for it to tell me how many I can build or what the missing quantities would be for a specified quantity. Then, I could purchase only the parts missing from the complete sets.

Does anyone have any ideas?
I would be ammenable to creating a BAQ if someone has a quick idea of the tables and relationships I would have to query.
If I did this, I suppose I could create a dashboard that would allow me to input quantities, but this would risk, me inputting a number that is too high and every part would be short by -1 or more.

So, ideally, my logic might be to keep increasing the necessary quantities on a finished item until all exception requirements are greater than zero...but maybe I am overthinking this.

I am sure someone out there had this need and has a much more elegant solution.
Thanks in advance.
Carey


_________________________________________________________________
Use video conversation to talk face-to-face with Windows Live Messenger.
http://www.windowslive.com/messenger/connect_your_way.html?ocid=TXT_TAGLM_WL_Refresh_messenger_video_042008

[Non-text portions of this message have been removed]
Personally? None.

From what I've seen, BAQs are very bit as resource consuming as ODBC read queries and, unlike SQL, aren't very easily optimized. There are also outright bugs in the BAQ developer program (issues with date constants relative to 'today', no null date criteria support, inabity to hand edit phrase builder generated partial code in order to optimize it, etc.).

The BAQ positives are its ability to do a mix of outer and inner joins no matter how many tables are in the query (unlike SQL which would require a series of simple queries and UNION statements to bring them together), produce quick BAQ reports, use the BAQs for searches and create Dashboards.

The project goals however are to fulfill all application requirements using internally supported vantage methods (BAQ based Dashboards or Reports and VB customizations of existing apps).

With the SDK (and visual studio) I suspect writing an app from scratch would be (by far) the most effective. However, we aren't licensed for SDK use and development.

My fallback for this one particularly complex application need is use Vantage tools to collect the data and then pull it into excel for final processing and output generate by the multiple data arrays (once in excel which has much more powerful vbScripting and basic formula capabilities than anything vantage can claim to have in their tool box - including Crystal).


Any experience doing xml dumps for use by excel?

Rob Brown

Michael Barry <mbarry@...> wrote:
Just out of curiosity, if all you are doing is reading data what is the
aversion to utilizing ODBC?

Regards,

Michael

Michael Barry
Aspacia Systems Inc
866.566.9600
312.803.0730 fax
<http://www.aspacia.com/> http://www.aspacia.com/

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Robert Brown
Sent: Tuesday, April 08, 2008 1:06 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Massive Part primary warehouse change

I have a looming project with a similar need to (likely have to) bring 404
(mutli-table) data into Excel WITHOUT utilizing simple (but prone to bogging
down the system) SQL/ODBC.

I was going to investigate using a BAQ report that dumps the results to and
XML file. Supposedly, Excel is able to utilize XML (but I've yet to try).

Any one out there have experience successfully doing anything like this?

Rob Brown

"Butler, Bruce" <bbutler@... <mailto:bbutler%40sawing.com> > wrote:
Is there a way I can connect to the database via Excel, not using ODBC,
change the primary plant for a massive list of parts, and have the
system manage the normal referential updates such as adding the new
warehouse to the PartWhse table?

Thanks,

Bruce

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

---------------------------------
You rock. That's why Blockbuster's offering you one month of Blockbuster
Total Access, No Cost.

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

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






---------------------------------
You rock. That's why Blockbuster's offering you one month of Blockbuster Total Access, No Cost.

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