Material BOM Import into Vantage

Hi,

I thought that for 6.1 there were general conversion tools from
epicor that were available?

The other option is to use MS access.

1) Load the spreadsheet into access
2) Check field types , include any other fields required by jobmtl
and set defaults.
3) ODBC Link to JOBmtl
4) Create a update query.

The only problem doing it this way that other tables that are
required to be populated will not.



--- In vantage@yahoogroups.com, Rough Brothers <roughbros@y...>
wrote:
>
> Does anyone Import Job Material and/or Operations into Vantage?
>
> Our current system has the capability to Import a Material List
into a JOB from Excel?
>
> For Vantage, this is a Modification that Custom Programming has to
write.
>
> However, Custom Programming is so backed up that we are being left
holding the bag.
>
> We currently have a Progress Programmer looking at it but he
doesn't know Vantage at all.
>
>
> I am looking for any suggestions/input on getting this custom
programming written in a timely manner.
>
> Any insight besides, "YOU'RE - - - - - - - " would be appreciated.
>
>
>
>
> __________________________________________________
> Do You Yahoo!?
> Tired of spam? Yahoo! Mail has the best spam protection around
> http://mail.yahoo.com
>
> [Non-text portions of this message have been removed]
Does anyone Import Job Material and/or Operations into Vantage?

Our current system has the capability to Import a Material List into a JOB from Excel?

For Vantage, this is a Modification that Custom Programming has to write.

However, Custom Programming is so backed up that we are being left holding the bag.

We currently have a Progress Programmer looking at it but he doesn't know Vantage at all.


I am looking for any suggestions/input on getting this custom programming written in a timely manner.

Any insight besides, "YOU'RE - - - - - - - " would be appreciated.




__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com

[Non-text portions of this message have been removed]
1) I'm going to make the assumption you are on 6.1
2) I haven't had the chance to look at these, but there are
IM tables that may aid in importing. You may want to look
into this.

Now whether this will work for importing a BOM to any
degree, I'm not sure. But if it works, it would beat Custom
Programming any day!

HTH,

M. Manasa Reddy
ERP Specialist
Crestview Aerospace Corporation
Email: mreddy@...
Phone: (850) 682-2746 x 272


-----Original Message-----
From: vantage@yahoogroups.com
[mailto:vantage@yahoogroups.com]On Behalf Of Rough Brothers
Sent: Tuesday, May 17, 2005 2:05 PM
To: Vantage Users
Subject: [Vantage] Material BOM Import into Vantage



Does anyone Import Job Material and/or Operations into
Vantage?

Our current system has the capability to Import a Material
List into a JOB from Excel?

For Vantage, this is a Modification that Custom
Programming has to write.

However, Custom Programming is so backed up that we are
being left holding the bag.

We currently have a Progress Programmer looking at it but
he doesn't know Vantage at all.


I am looking for any suggestions/input on getting this
custom programming written in a timely manner.

Any insight besides, "YOU'RE - - - - - - - " would be
appreciated.




__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection
around
http://mail.yahoo.com

[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/links



------------------------------------------------------------
------------------
Yahoo! Groups Links

a.. To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/

b.. To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com

c.. Your use of Yahoo! Groups is subject to the Yahoo!
Terms of Service.



[Non-text portions of this message have been removed]
Hi, R&R,



A rough and ready you could get going this afternoon is macro express.



It comes with a 30 day eval. (http://www.macros.com/download.htm )



In a nutshell you



* open a spreadsheet, position the cursor in a certain relative cell,



* Open the vantage window,



* Write down the keystrokes and copy's and pastes.



* Input the macro into macro express.



* Hit the hot key, and it does it.



I just used it to change the costs on around a thousand parts; it saved a lot of keying. (?50,000 keystrokes?)



A couple of things to watch out for.

- slow down the keystrokes; a couple of milliseconds usually does the trick.

- put a ¼ or ½ second delay in when switching to vantage, or when a vantage window needs to pop-up.

- make sure to reference your windows by name. i.e. Excel - MyBomSheet.xls. That way if the window hasn't opened you can either programmatically open it, delay until it opens, or have the macro crash and burn.



Take care,



Steve





________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Rough Brothers
Sent: Tuesday, May 17, 2005 3:05 PM
To: Vantage Users
Subject: [Vantage] Material BOM Import into Vantage




Does anyone Import Job Material and/or Operations into Vantage?

Our current system has the capability to Import a Material List into a JOB from Excel?

For Vantage, this is a Modification that Custom Programming has to write.

However, Custom Programming is so backed up that we are being left holding the bag.

We currently have a Progress Programmer looking at it but he doesn't know Vantage at all.


I am looking for any suggestions/input on getting this custom programming written in a timely manner.

Any insight besides, "YOU'RE - - - - - - - " would be appreciated.




__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com

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



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




________________________________

Yahoo! Groups Links

* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/

* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com <mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>

* Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service <http://docs.yahoo.com/info/terms/> .



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

Is this like Ground Control?

M. Manasa Reddy
ERP Specialist
Crestview Aerospace Corporation
Email: mreddy@...
Phone: (850) 682-2746 x 272


-----Original Message-----
From: vantage@yahoogroups.com
[mailto:vantage@yahoogroups.com]On Behalf Of Steve Wirch
Sent: Tuesday, May 17, 2005 2:48 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Material BOM Import into Vantage


Hi, R&R,



A rough and ready you could get going this afternoon is
macro express.



It comes with a 30 day eval.
(http://www.macros.com/download.htm )



In a nutshell you



* open a spreadsheet, position the cursor in a certain
relative cell,



* Open the vantage window,



* Write down the keystrokes and copy's and pastes.



* Input the macro into macro express.



* Hit the hot key, and it does it.



I just used it to change the costs on around a thousand
parts; it saved a lot of keying. (?50,000 keystrokes?)



A couple of things to watch out for.

- slow down the keystrokes; a couple of milliseconds
usually does the trick.

- put a ¼ or ½ second delay in when switching to vantage,
or when a vantage window needs to pop-up.

- make sure to reference your windows by name. i.e.
Excel - MyBomSheet.xls. That way if the window hasn't
opened you can either programmatically open it, delay until
it opens, or have the macro crash and burn.



Take care,



Steve





________________________________

From: vantage@yahoogroups.com
[mailto:vantage@yahoogroups.com] On Behalf Of Rough Brothers
Sent: Tuesday, May 17, 2005 3:05 PM
To: Vantage Users
Subject: [Vantage] Material BOM Import into Vantage




Does anyone Import Job Material and/or Operations into
Vantage?

Our current system has the capability to Import a Material
List into a JOB from Excel?

For Vantage, this is a Modification that Custom
Programming has to write.

However, Custom Programming is so backed up that we are
being left holding the bag.

We currently have a Progress Programmer looking at it but
he doesn't know Vantage at all.


I am looking for any suggestions/input on getting this
custom programming written in a timely manner.

Any insight besides, "YOU'RE - - - - - - - " would be
appreciated.




__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection
around
http://mail.yahoo.com

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



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




________________________________

Yahoo! Groups Links

* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/

* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscr
ibe>

* Your use of Yahoo! Groups is subject to the Yahoo!
Terms of Service <http://docs.yahoo.com/info/terms/> .



[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/links



------------------------------------------------------------
------------------
Yahoo! Groups Links

a.. To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/

b.. To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com

c.. Your use of Yahoo! Groups is subject to the Yahoo!
Terms of Service.



[Non-text portions of this message have been removed]
Importing items into the JobMtl table is not that complex a task.
The program would be very simple to write.

The progress program needs to read the excel file, verify data
formats, and write to the JobMtl table. Contact me off list and
I can send sample code to push your programmer in the right
direction.

HTH,
Calvin Dekker
calvin@...
630 675 9102


-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf
Of Rough Brothers
Sent: Tuesday, May 17, 2005 2:05 PM
To: Vantage Users
Subject: [Vantage] Material BOM Import into Vantage



Does anyone Import Job Material and/or Operations into Vantage?

Our current system has the capability to Import a Material List into a JOB
from Excel?

For Vantage, this is a Modification that Custom Programming has to write.

However, Custom Programming is so backed up that we are being left holding
the bag.

We currently have a Progress Programmer looking at it but he doesn't know
Vantage at all.


I am looking for any suggestions/input on getting this custom programming
written in a timely manner.

Any insight besides, "YOU'RE - - - - - - - " would be appreciated.




__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com

[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/links
Yahoo! Groups Links