Importing Data into Vantage

system · June 3, 2009, 3:07pm

Greg, you'll need to give them a call or drop an email as it's not publicly marketed yet.

Dele

--- In vantage@yahoogroups.com, "gcavhis" <gcavhis@...> wrote:
>
> --- In vantage@yahoogroups.com, "deleoye" <deleoye@> wrote:
> >Dele,
>
> I am interested in getting some info on the tool you mention here from Dot Net IT. What is the product name, etc.? I went to the website listed but did not see anything listed there.
>
> Thanks
>
> Greg
>
> > I use a Data Import Tool from a company called Dot Net IT (http://www.dotnetit.co.uk). I'm on Progress, but the tool performs the import using the Vantage Business Objects as opposed to writing directly to the DB.
> >
> > Dele
> >
> > --- In vantage@yahoogroups.com, "Late, Travis" <tlate@> wrote:
> > >
> > > I'll see what I can do about narrowing down the part numbers.
> > >
> > >
> > >
> > > Thanks,
> > >
> > > Travis
> > >
> > >
> > >
> > > From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
> > > Of Rob Bucek
> > > Sent: Wednesday, May 27, 2009 3:30 PM
> > > To: vantage@yahoogroups.com
> > > Subject: RE: [Vantage] Importing Data into Vantage
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > > Id seriously consider a BPM on this one... if you can isolate those part
> > > number in a query based on some criteria you're in business..id be happy
> > > to help you with that one..you can then test it out on a test DB..
> > >
> > > Rob Bucek
> > >
> > > Manufacturing Engineer
> > >
> > > PH: 715-284-5376 ext 311
> > >
> > > FAX: 715-284-4084
> > >
> > > <http://www.dsmfg.com/>
> > >
> > > (Click the logo to view our site)
> > >
> > > ________________________________
> > >
> > > From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> > > [mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
> > > Behalf
> > > Of Late, Travis
> > > Sent: Wednesday, May 27, 2009 2:54 PM
> > > To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> > > Subject: RE: [Vantage] Importing Data into Vantage
> > >
> > > No we are on progress.
> > >
> > > From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> > > <mailto:vantage%40yahoogroups.com>
> > > [mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> > > <mailto:vantage%40yahoogroups.com> ] On
> > > Behalf
> > > Of Rob Bucek
> > > Sent: Wednesday, May 27, 2009 2:46 PM
> > > To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> > > <mailto:vantage%40yahoogroups.com>
> > > Subject: RE: [Vantage] Importing Data into Vantage
> > >
> > > Do you have sequal?
> > >
> > > Rob Bucek
> > >
> > > Manufacturing Engineer
> > >
> > > PH: 715-284-5376 ext 311
> > >
> > > FAX: 715-284-4084
> > >
> > > <http://www.dsmfg.com/ <http://www.dsmfg.com/> >
> > >
> > > (Click the logo to view our site)
> > >
> > > ________________________________
> > >
> > > From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> > > <mailto:vantage%40yahoogroups.com>
> > > <mailto:vantage%40yahoogroups.com>
> > > [mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> > > <mailto:vantage%40yahoogroups.com>
> > > <mailto:vantage%40yahoogroups.com> ] On
> > > Behalf
> > > Of Late, Travis
> > > Sent: Wednesday, May 27, 2009 2:30 PM
> > > To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> > > <mailto:vantage%40yahoogroups.com>
> > > <mailto:vantage%40yahoogroups.com>
> > > Subject: [Vantage] Importing Data into Vantage
> > >
> > > We do not have Service Connect. Is there a way to import data directly
> > > into Vantage without service connect? Here is our scenario:
> > >
> > > We would like to update a number of our parts with a Planning Time fence
> > > number of 60. Is there a way to do a mass update for this field?
> > >
> > > Thanks,
> > >
> > > Travis Late
> > >
> > > ERP Project Manager
> > >
> > > M-B Companies, Inc
> > >
> > > 1200 Park Street
> > >
> > > Chilton, WI 53014
> > >
> > > Phone: 920-898-1560 Ext.152
> > >
> > > Cell: 920-960-0062
> > >
> > > Email: tlate@ <mailto:tlate%40m-bco.com>
> > > <mailto:tlate%40m-bco.com>
> > > <mailto:tlate%40m-bco.com>
> > > <mailto:tlate%40m-bco.com> <mailto:
> > > tlate@ <mailto:tlate%40m-bco.com> <mailto:tlate%40m-bco.com>
> > > <mailto:tlate%40m-bco.com>
> > > <mailto:tlate%40m-bco.com> >
> > >
> > > [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]
> > >
> >
>

system · May 27, 2009, 3:30pm

We do not have Service Connect. Is there a way to import data directly
into Vantage without service connect? Here is our scenario:

We would like to update a number of our parts with a Planning Time fence
number of 60. Is there a way to do a mass update for this field?

Thanks,

Travis Late

ERP Project Manager

M-B Companies, Inc

1200 Park Street

Chilton, WI 53014

Phone: 920-898-1560 Ext.152

Cell: 920-960-0062

Email: tlate@... <mailto:tlate@...>

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

system · May 27, 2009, 3:49pm

Do you have sequal?

Rob Bucek

Manufacturing Engineer

PH: 715-284-5376 ext 311

FAX: 715-284-4084

<http://www.dsmfg.com/>

(Click the logo to view our site)

________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Late, Travis
Sent: Wednesday, May 27, 2009 2:30 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Importing Data into Vantage

We do not have Service Connect. Is there a way to import data directly
into Vantage without service connect? Here is our scenario:

We would like to update a number of our parts with a Planning Time fence
number of 60. Is there a way to do a mass update for this field?

Thanks,

Travis Late

ERP Project Manager

M-B Companies, Inc

1200 Park Street

Chilton, WI 53014

Phone: 920-898-1560 Ext.152

Cell: 920-960-0062

Email: tlate@... <mailto:tlate%40m-bco.com> <mailto:
tlate@... <mailto:tlate%40m-bco.com> >

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

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

system · May 27, 2009, 3:54pm

No we are on progress.

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Rob Bucek
Sent: Wednesday, May 27, 2009 2:46 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Importing Data into Vantage

Do you have sequal?

Rob Bucek

Manufacturing Engineer

PH: 715-284-5376 ext 311

FAX: 715-284-4084

<http://www.dsmfg.com/>

(Click the logo to view our site)

________________________________

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Late, Travis
Sent: Wednesday, May 27, 2009 2:30 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Importing Data into Vantage

We do not have Service Connect. Is there a way to import data directly
into Vantage without service connect? Here is our scenario:

We would like to update a number of our parts with a Planning Time fence
number of 60. Is there a way to do a mass update for this field?

Thanks,

Travis Late

ERP Project Manager

M-B Companies, Inc

1200 Park Street

Chilton, WI 53014

Phone: 920-898-1560 Ext.152

Cell: 920-960-0062

Email: tlate@... <mailto:tlate%40m-bco.com>
<mailto:tlate%40m-bco.com> <mailto:
tlate@... <mailto:tlate%40m-bco.com> <mailto:tlate%40m-bco.com> >

[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]

system · May 27, 2009, 3:59pm

My suggestion would have been a DTS package...but that requires SQL...I
know even less about progress..and that isn't saying much!

Rob Bucek

Manufacturing Engineer

PH: 715-284-5376 ext 311

FAX: 715-284-4084

<http://www.dsmfg.com/>

(Click the logo to view our site)

________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Late, Travis
Sent: Wednesday, May 27, 2009 2:54 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Importing Data into Vantage

No we are on progress.

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Rob Bucek
Sent: Wednesday, May 27, 2009 2:46 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Importing Data into Vantage

Do you have sequal?

Rob Bucek

Manufacturing Engineer

PH: 715-284-5376 ext 311

FAX: 715-284-4084

<http://www.dsmfg.com/ <http://www.dsmfg.com/> >

(Click the logo to view our site)

________________________________

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Late, Travis
Sent: Wednesday, May 27, 2009 2:30 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Importing Data into Vantage

We do not have Service Connect. Is there a way to import data directly
into Vantage without service connect? Here is our scenario:

We would like to update a number of our parts with a Planning Time fence
number of 60. Is there a way to do a mass update for this field?

Thanks,

Travis Late

ERP Project Manager

M-B Companies, Inc

1200 Park Street

Chilton, WI 53014

Phone: 920-898-1560 Ext.152

Cell: 920-960-0062

Email: tlate@... <mailto:tlate%40m-bco.com>
<mailto:tlate%40m-bco.com>
<mailto:tlate%40m-bco.com> <mailto:
tlate@... <mailto:tlate%40m-bco.com> <mailto:tlate%40m-bco.com>
<mailto:tlate%40m-bco.com> >

[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]

system · May 27, 2009, 4:01pm

I have used a windows macro program with some success.
If you are updating all selected parts with the same value, just run the
macro on the part and go to the next record and repeat.
I forget the package that I used, but it was a free one.
I did about 300 parts.
It works best to use as many keystrokes as possible versus mouse clicks to
run the macro.

If you do this, set up a BAQ to check your work.
Someone also talked about this a couple weeks ago on the forum. If you want
to search for a software.
Good luck,

Bruce
bruce@...
www.ERPgeek.com
763-486-0030

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Late, Travis
Sent: Wednesday, May 27, 2009 2:54 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Importing Data into Vantage

No we are on progress.

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Rob Bucek
Sent: Wednesday, May 27, 2009 2:46 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Importing Data into Vantage

Do you have sequal?

Rob Bucek

Manufacturing Engineer

PH: 715-284-5376 ext 311

FAX: 715-284-4084

<http://www.dsmfg.com/>

(Click the logo to view our site)

________________________________

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Late, Travis
Sent: Wednesday, May 27, 2009 2:30 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Importing Data into Vantage

We do not have Service Connect. Is there a way to import data directly
into Vantage without service connect? Here is our scenario:

We would like to update a number of our parts with a Planning Time fence
number of 60. Is there a way to do a mass update for this field?

Thanks,

Travis Late

ERP Project Manager

M-B Companies, Inc

1200 Park Street

Chilton, WI 53014

Phone: 920-898-1560 Ext.152

Cell: 920-960-0062

Email: tlate@... <mailto:tlate%40m-bco.com>
<mailto:tlate%40m-bco.com> <mailto:
tlate@... <mailto:tlate%40m-bco.com> <mailto:tlate%40m-bco.com> >

[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]

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

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]

system · May 27, 2009, 4:05pm

Without running SQL up against the DB directly which is a big epicor NO NO
you aren't left with many options, other than service connect and sending
your DB to epicor and having them fix them for you. This would cost a small
fortune and disable your company from using vantage while they have your DB.

~Charlie

_____

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Rob Bucek
Sent: Wednesday, May 27, 2009 3:57 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Importing Data into Vantage

My suggestion would have been a DTS package...but that requires SQL...I
know even less about progress..and that isn't saying much!

Rob Bucek

Manufacturing Engineer

PH: 715-284-5376 ext 311

FAX: 715-284-4084

<http://www.dsmfg <http://www.dsmfg.com/> com/>

(Click the logo to view our site)

________________________________

From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
[mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com] On
Behalf
Of Late, Travis
Sent: Wednesday, May 27, 2009 2:54 PM
To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
Subject: RE: [Vantage] Importing Data into Vantage

No we are on progress.

From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
<mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Rob Bucek
Sent: Wednesday, May 27, 2009 2:46 PM
To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
<mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Importing Data into Vantage

Do you have sequal?

Rob Bucek

Manufacturing Engineer

PH: 715-284-5376 ext 311

FAX: 715-284-4084

<http://www.dsmfg <http://www.dsmfg.com/> com/ <http://www.dsmfg
<http://www.dsmfg.com/> com/> >

(Click the logo to view our site)

________________________________

From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Late, Travis
Sent: Wednesday, May 27, 2009 2:30 PM
To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Importing Data into Vantage

We do not have Service Connect. Is there a way to import data directly
into Vantage without service connect? Here is our scenario:

We would like to update a number of our parts with a Planning Time fence
number of 60. Is there a way to do a mass update for this field?

Thanks,

Travis Late

ERP Project Manager

M-B Companies, Inc

1200 Park Street

Chilton, WI 53014

Phone: 920-898-1560 Ext.152

Cell: 920-960-0062

Email: tlate@m-bco. <mailto:tlate%40m-bco.com> com
<mailto:tlate%40m-bco.com>
<mailto:tlate%40m-bco.com>
<mailto:tlate%40m-bco.com> <mailto:
tlate@m-bco. <mailto:tlate%40m-bco.com> com <mailto:tlate%40m-bco.com>
<mailto:tlate%40m-bco.com>
<mailto:tlate%40m-bco.com> >

[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]

system · May 27, 2009, 4:20pm

There is a possibility that you might be able to do it with a bam or BPM
if you have something solid to filter by...

Rob Bucek

Manufacturing Engineer

PH: 715-284-5376 ext 311

FAX: 715-284-4084

<http://www.dsmfg.com/>

(Click the logo to view our site)

________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Charlie Wilson
Sent: Wednesday, May 27, 2009 3:05 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Importing Data into Vantage

Without running SQL up against the DB directly which is a big epicor NO
NO
you aren't left with many options, other than service connect and
sending
your DB to epicor and having them fix them for you. This would cost a
small
fortune and disable your company from using vantage while they have your
DB.

~Charlie

_____

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf Of
Rob Bucek
Sent: Wednesday, May 27, 2009 3:57 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Importing Data into Vantage

My suggestion would have been a DTS package...but that requires SQL...I
know even less about progress..and that isn't saying much!

Rob Bucek

Manufacturing Engineer

PH: 715-284-5376 ext 311

FAX: 715-284-4084

<http://www.dsmfg <http://www.dsmfg.com/ <http://www.dsmfg.com/> >
com/>

(Click the logo to view our site)

________________________________

From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
[mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com] On
Behalf
Of Late, Travis
Sent: Wednesday, May 27, 2009 2:54 PM
To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
Subject: RE: [Vantage] Importing Data into Vantage

No we are on progress.

From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
<mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Rob Bucek
Sent: Wednesday, May 27, 2009 2:46 PM
To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
<mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Importing Data into Vantage

Do you have sequal?

Rob Bucek

Manufacturing Engineer

PH: 715-284-5376 ext 311

FAX: 715-284-4084

<http://www.dsmfg <http://www.dsmfg.com/ <http://www.dsmfg.com/> > com/
<http://www.dsmfg
<http://www.dsmfg.com/ <http://www.dsmfg.com/> > com/> >

(Click the logo to view our site)

________________________________

From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Late, Travis
Sent: Wednesday, May 27, 2009 2:30 PM
To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Importing Data into Vantage

We do not have Service Connect. Is there a way to import data directly
into Vantage without service connect? Here is our scenario:

We would like to update a number of our parts with a Planning Time fence
number of 60. Is there a way to do a mass update for this field?

Thanks,

Travis Late

ERP Project Manager

M-B Companies, Inc

1200 Park Street

Chilton, WI 53014

Phone: 920-898-1560 Ext.152

Cell: 920-960-0062

Email: tlate@m-bco. <mailto:tlate%40m-bco.com> com
<mailto:tlate%40m-bco.com>
<mailto:tlate%40m-bco.com>
<mailto:tlate%40m-bco.com> <mailto:
tlate@m-bco. <mailto:tlate%40m-bco.com> com <mailto:tlate%40m-bco.com>
<mailto:tlate%40m-bco.com>
<mailto:tlate%40m-bco.com> >

[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]

system · May 27, 2009, 4:23pm

Travis:

I've imported data with DTS (data transfer services) which is a part of
SQL with great success. We are running Progress but have a stripped
down version of SQL for another program which is how I have the DTS
program. I've also successfully opened some of the database files in
open office. If you're going to attempt anything like this I'd do it in
a test database first and would also make sure when you're ready to do
it on your live database that you have a current good backup.

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Late, Travis
Sent: Wednesday, May 27, 2009 3:30 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Importing Data into Vantage

We do not have Service Connect. Is there a way to import data directly
into Vantage without service connect? Here is our scenario:

We would like to update a number of our parts with a Planning Time fence
number of 60. Is there a way to do a mass update for this field?

Thanks,

Travis Late

ERP Project Manager

M-B Companies, Inc

1200 Park Street

Chilton, WI 53014

Phone: 920-898-1560 Ext.152

Cell: 920-960-0062

Email: tlate@... <mailto:tlate%40m-bco.com>
<mailto:tlate@... <mailto:tlate%40m-bco.com> >

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

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

system · May 27, 2009, 4:27pm

We have a SQL server here that we use for another application. Is there
any instructions on performing this in a test environment?

Travis

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Alison Levy
Sent: Wednesday, May 27, 2009 3:23 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Importing Data into Vantage

Travis:

I've imported data with DTS (data transfer services) which is a part of
SQL with great success. We are running Progress but have a stripped
down version of SQL for another program which is how I have the DTS
program. I've also successfully opened some of the database files in
open office. If you're going to attempt anything like this I'd do it in
a test database first and would also make sure when you're ready to do
it on your live database that you have a current good backup.

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Late, Travis
Sent: Wednesday, May 27, 2009 3:30 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Importing Data into Vantage

We do not have Service Connect. Is there a way to import data directly
into Vantage without service connect? Here is our scenario:

We would like to update a number of our parts with a Planning Time fence
number of 60. Is there a way to do a mass update for this field?

Thanks,

Travis Late

ERP Project Manager

M-B Companies, Inc

1200 Park Street

Chilton, WI 53014

Phone: 920-898-1560 Ext.152

Cell: 920-960-0062

Email: tlate@... <mailto:tlate%40m-bco.com>
<mailto:tlate%40m-bco.com>
<mailto:tlate@... <mailto:tlate%40m-bco.com>
<mailto:tlate%40m-bco.com> >

[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]

system · May 27, 2009, 4:31pm

Id seriously consider a BPM on this one... if you can isolate those part
number in a query based on some criteria you're in business..id be happy
to help you with that one..you can then test it out on a test DB..

Rob Bucek

Manufacturing Engineer

PH: 715-284-5376 ext 311

FAX: 715-284-4084

<http://www.dsmfg.com/>

(Click the logo to view our site)

________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Late, Travis
Sent: Wednesday, May 27, 2009 2:54 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Importing Data into Vantage

No we are on progress.

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Rob Bucek
Sent: Wednesday, May 27, 2009 2:46 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Importing Data into Vantage

Do you have sequal?

Rob Bucek

Manufacturing Engineer

PH: 715-284-5376 ext 311

FAX: 715-284-4084

<http://www.dsmfg.com/ <http://www.dsmfg.com/> >

(Click the logo to view our site)

________________________________

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Late, Travis
Sent: Wednesday, May 27, 2009 2:30 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Importing Data into Vantage

We do not have Service Connect. Is there a way to import data directly
into Vantage without service connect? Here is our scenario:

We would like to update a number of our parts with a Planning Time fence
number of 60. Is there a way to do a mass update for this field?

Thanks,

Travis Late

ERP Project Manager

M-B Companies, Inc

1200 Park Street

Chilton, WI 53014

Phone: 920-898-1560 Ext.152

Cell: 920-960-0062

Email: tlate@... <mailto:tlate%40m-bco.com>
<mailto:tlate%40m-bco.com>
<mailto:tlate%40m-bco.com> <mailto:
tlate@... <mailto:tlate%40m-bco.com> <mailto:tlate%40m-bco.com>
<mailto:tlate%40m-bco.com> >

[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]

system · May 27, 2009, 4:35pm

I'll see what I can do about narrowing down the part numbers.

Thanks,

Travis

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Rob Bucek
Sent: Wednesday, May 27, 2009 3:30 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Importing Data into Vantage

Id seriously consider a BPM on this one... if you can isolate those part
number in a query based on some criteria you're in business..id be happy
to help you with that one..you can then test it out on a test DB..

Rob Bucek

Manufacturing Engineer

PH: 715-284-5376 ext 311

FAX: 715-284-4084

<http://www.dsmfg.com/>

(Click the logo to view our site)

________________________________

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Late, Travis
Sent: Wednesday, May 27, 2009 2:54 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Importing Data into Vantage

No we are on progress.

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Rob Bucek
Sent: Wednesday, May 27, 2009 2:46 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Importing Data into Vantage

Do you have sequal?

Rob Bucek

Manufacturing Engineer

PH: 715-284-5376 ext 311

FAX: 715-284-4084

<http://www.dsmfg.com/ <http://www.dsmfg.com/> >

(Click the logo to view our site)

________________________________

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Late, Travis
Sent: Wednesday, May 27, 2009 2:30 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Importing Data into Vantage

We do not have Service Connect. Is there a way to import data directly
into Vantage without service connect? Here is our scenario:

We would like to update a number of our parts with a Planning Time fence
number of 60. Is there a way to do a mass update for this field?

Thanks,

Travis Late

ERP Project Manager

M-B Companies, Inc

1200 Park Street

Chilton, WI 53014

Phone: 920-898-1560 Ext.152

Cell: 920-960-0062

Email: tlate@... <mailto:tlate%40m-bco.com>
<mailto:tlate%40m-bco.com>
<mailto:tlate%40m-bco.com>
<mailto:tlate%40m-bco.com> <mailto:
tlate@... <mailto:tlate%40m-bco.com> <mailto:tlate%40m-bco.com>
<mailto:tlate%40m-bco.com>
<mailto:tlate%40m-bco.com> >

[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]

system · May 27, 2009, 4:56pm

I have used BPM on a UD table to mass update fields in my Sales Order table.
I just used UD10 wich we do no use, then put in my criteria for user equal to me on the post update. Then put in the 4gl code.
Once I saved it went through all my sales orders & updated
the ones it needed to. Then I just deleted the BPM. Worked like a charm.

--- In vantage@yahoogroups.com, "Rob Bucek" <rbucek@...> wrote:
>
> Id seriously consider a BPM on this one... if you can isolate those part
> number in a query based on some criteria you're in business..id be happy
> to help you with that one..you can then test it out on a test DB..
>
>
>
> Rob Bucek
>
> Manufacturing Engineer
>
> PH: 715-284-5376 ext 311
>
> FAX: 715-284-4084
>
> <http://www.dsmfg.com/>
>
> (Click the logo to view our site)
>
>
>
> ________________________________
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
> Of Late, Travis
> Sent: Wednesday, May 27, 2009 2:54 PM
> To: vantage@yahoogroups.com
> Subject: RE: [Vantage] Importing Data into Vantage
>
>
>
>
>
> No we are on progress.
>
> From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> [mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
> Behalf
> Of Rob Bucek
> Sent: Wednesday, May 27, 2009 2:46 PM
> To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> Subject: RE: [Vantage] Importing Data into Vantage
>
> Do you have sequal?
>
> Rob Bucek
>
> Manufacturing Engineer
>
> PH: 715-284-5376 ext 311
>
> FAX: 715-284-4084
>
> <http://www.dsmfg.com/ <http://www.dsmfg.com/> >
>
> (Click the logo to view our site)
>
> ________________________________
>
> From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> <mailto:vantage%40yahoogroups.com>
> [mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> <mailto:vantage%40yahoogroups.com> ] On
> Behalf
> Of Late, Travis
> Sent: Wednesday, May 27, 2009 2:30 PM
> To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> <mailto:vantage%40yahoogroups.com>
> Subject: [Vantage] Importing Data into Vantage
>
> We do not have Service Connect. Is there a way to import data directly
> into Vantage without service connect? Here is our scenario:
>
> We would like to update a number of our parts with a Planning Time fence
> number of 60. Is there a way to do a mass update for this field?
>
> Thanks,
>
> Travis Late
>
> ERP Project Manager
>
> M-B Companies, Inc
>
> 1200 Park Street
>
> Chilton, WI 53014
>
> Phone: 920-898-1560 Ext.152
>
> Cell: 920-960-0062
>
> Email: tlate@... <mailto:tlate%40m-bco.com>
> <mailto:tlate%40m-bco.com>
> <mailto:tlate%40m-bco.com> <mailto:
> tlate@... <mailto:tlate%40m-bco.com> <mailto:tlate%40m-bco.com>
> <mailto:tlate%40m-bco.com> >
>
> [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]
>

system · May 27, 2009, 5:19pm

Exactly!

Rob Bucek

Manufacturing Engineer

PH: 715-284-5376 ext 311

FAX: 715-284-4084

<http://www.dsmfg.com/>

(Click the logo to view our site)

________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Michael McWilliams
Sent: Wednesday, May 27, 2009 3:56 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Importing Data into Vantage

I have used BPM on a UD table to mass update fields in my Sales Order
table.
I just used UD10 wich we do no use, then put in my criteria for user
equal to me on the post update. Then put in the 4gl code.
Once I saved it went through all my sales orders & updated
the ones it needed to. Then I just deleted the BPM. Worked like a charm.

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> , "Rob
Bucek" <rbucek@...> wrote:

>
> Id seriously consider a BPM on this one... if you can isolate those

part

> number in a query based on some criteria you're in business..id be

happy

> to help you with that one..you can then test it out on a test DB..
>
>
>
> Rob Bucek
>
> Manufacturing Engineer
>
> PH: 715-284-5376 ext 311
>
> FAX: 715-284-4084
>
> <http://www.dsmfg.com/ <http://www.dsmfg.com/> >
>
> (Click the logo to view our site)
>
>
>
> ________________________________
>
> From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>

[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf

> Of Late, Travis
> Sent: Wednesday, May 27, 2009 2:54 PM
> To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> Subject: RE: [Vantage] Importing Data into Vantage
>
>
>
>
>
> No we are on progress.
>
> From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>