Query Export - Continuous Process

Yahoo Archive
1
Yes, I apologize, Epicor Service Connect User Guide.



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 Blake Clemens
Sent: Monday, April 06, 2009 8:36 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Query Export - Continuous Process



I have the Service Connect User's Guide. Is that the same thing?

Thanks for the help on this Rob. I really appreciate it.

Thanks,

Blake Clemens

DMC

________________________________

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Rob Bucek
Sent: Monday, April 06, 2009 9:25 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Query Export - Continuous Process

If you have the service connect tools guide there is a helpful example
in there on setting up a BPM workflow. If you're doing workflows Id
recommend getting it. Since it sounds like you really won't be
filtering on any particular conditions, just sending data out as it's
added, your BPM should be fairly straight forward. If that was a true
statement, on your update method of the UD table you'll create a
pre-process action (you won't need any condition) which will be enable
post process. In your post process on conditions, set to enabled from
(pick your pre-process). Under actions choose Service connect workflow,
and set the parameters as required.

Rob Bucek

Manufacturing Engineer

PH: 715-284-5376 ext 311

FAX: 715-284-4084

<http://www.dsmfg.com/ <http://www.dsmfg.com/> <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 Blake Clemens
Sent: Monday, April 06, 2009 8:03 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Query Export - Continuous Process

Thanks Rob!

I was afraid that was going to be the answer. I have not set up a BPM
yet but am eager to learn to do so. Is there any documentation out
there to get me started? I downloaded the document from Epicor but like
most of their documentation it doesn't make any sense.

Thanks,

Blake Clemens

DMC

________________________________

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 Rob Bucek
Sent: Monday, April 06, 2009 8:51 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Query Export - Continuous Process

That's a perfect scenario for a BPM. I have a couple BPM's sending data
sets to a service connect workflow. There are business methods for UD
tables, just use the update method.

Rob Bucek

Manufacturing Engineer

PH: 715-284-5376 ext 311

FAX: 715-284-4084

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

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

<http://www.dsmfg.com/ <http://www.dsmfg.com/> <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%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Blake Clemens
Sent: Friday, April 03, 2009 1:56 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Query Export - Continuous Process

I have a problem... Here is my scenario... We are on Vantage 8.03.405A.

I used a user defined table (UD01) to create a menu. This menu's only
purpose is to store a Sales Order Number and a Date. I then created a
query to show all Sales Order Numbers and Dates entered in this User
Defined Table. The query works fine. I would like to export this
query. So I decided to use the Business Activity Query Export Process.
I want this query to be exported continuously, let's say every 60
seconds. I created a new schedule in the System Agent that runs every 60
seconds. I submitted the query to this schedule via the Business
Activity Query Export Process and checked the "reoccurring" check box.
I restarted the appservers. I see the schedule in the System Monitor
but the file doesn't export. Actually, it exports one time right after
I restart the appservers but it won't export multiple times. My
intention is for Service Connect to grab this exported query and process
it through a work flow that I will create. What am I missing here? I
would like to think that this is fairly simple to set up. Although it
is Friday and my brain is only running at 10% of its potential which is
only 10% anyways. Any help here would be greatly appreciated.

Thanks,

Blake Clemens

IT Systems Engineer

Delmarva Millwork Corporation

(800) 360-2364 x132

***Privileged & Confidential***

This email, together with any attachments, is intended for the named
recipient(s) only and may contain privileged and confidential
information. If received in error, please inform the sender as quickly
as possible and delete this email and any copies. If not an intended
recipient of this email, you must not copy, distribute or rely on it,
and any form of disclosure, modification, distribution and/or
publication of this email is prohibited.

Unless stated otherwise, this email represents only the views of the
sender and not the views of Delmarva Millwork Corporation.

[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]
2
I have a problem... Here is my scenario... We are on Vantage 8.03.405A.



I used a user defined table (UD01) to create a menu. This menu's only
purpose is to store a Sales Order Number and a Date. I then created a
query to show all Sales Order Numbers and Dates entered in this User
Defined Table. The query works fine. I would like to export this
query. So I decided to use the Business Activity Query Export Process.
I want this query to be exported continuously, let's say every 60
seconds. I created a new schedule in the System Agent that runs every 60
seconds. I submitted the query to this schedule via the Business
Activity Query Export Process and checked the "reoccurring" check box.
I restarted the appservers. I see the schedule in the System Monitor
but the file doesn't export. Actually, it exports one time right after
I restart the appservers but it won't export multiple times. My
intention is for Service Connect to grab this exported query and process
it through a work flow that I will create. What am I missing here? I
would like to think that this is fairly simple to set up. Although it
is Friday and my brain is only running at 10% of its potential which is
only 10% anyways. Any help here would be greatly appreciated.



Thanks,

Blake Clemens

IT Systems Engineer

Delmarva Millwork Corporation

(800) 360-2364 x132













***Privileged & Confidential***



This email, together with any attachments, is intended for the named
recipient(s) only and may contain privileged and confidential
information. If received in error, please inform the sender as quickly
as possible and delete this email and any copies. If not an intended
recipient of this email, you must not copy, distribute or rely on it,
and any form of disclosure, modification, distribution and/or
publication of this email is prohibited.

Unless stated otherwise, this email represents only the views of the
sender and not the views of Delmarva Millwork Corporation.





[Non-text portions of this message have been removed]
3
With numbers like that for brain power you may have to hang it up for the
day. Cuz it seems like the group is rather dead this after noon.



I would like to know how to do this as well cuz I have some problems I would
like to solve in the same manor.



We may get lucky and some one on the west coast where the day is still young
may have some brain power left.



I have a SC Choice that is giving me hell that I can't figure out.



~Charlie

_____

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Blake Clemens
Sent: Friday, April 03, 2009 2:56 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Query Export - Continuous Process



I have a problem... Here is my scenario... We are on Vantage 8.03.405A.

I used a user defined table (UD01) to create a menu. This menu's only
purpose is to store a Sales Order Number and a Date. I then created a
query to show all Sales Order Numbers and Dates entered in this User
Defined Table. The query works fine. I would like to export this
query. So I decided to use the Business Activity Query Export Process.
I want this query to be exported continuously, let's say every 60
seconds. I created a new schedule in the System Agent that runs every 60
seconds. I submitted the query to this schedule via the Business
Activity Query Export Process and checked the "reoccurring" check box.
I restarted the appservers. I see the schedule in the System Monitor
but the file doesn't export. Actually, it exports one time right after
I restart the appservers but it won't export multiple times. My
intention is for Service Connect to grab this exported query and process
it through a work flow that I will create. What am I missing here? I
would like to think that this is fairly simple to set up. Although it
is Friday and my brain is only running at 10% of its potential which is
only 10% anyways. Any help here would be greatly appreciated.

Thanks,

Blake Clemens

IT Systems Engineer

Delmarva Millwork Corporation

(800) 360-2364 x132

***Privileged & Confidential***

This email, together with any attachments, is intended for the named
recipient(s) only and may contain privileged and confidential
information. If received in error, please inform the sender as quickly
as possible and delete this email and any copies. If not an intended
recipient of this email, you must not copy, distribute or rely on it,
and any form of disclosure, modification, distribution and/or
publication of this email is prohibited.

Unless stated otherwise, this email represents only the views of the
sender and not the views of Delmarva Millwork Corporation.

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





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

I believe you are correct. I'm outta here.



Thanks,

Blake Clemens

DMC







________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Charlie Wilson
Sent: Friday, April 03, 2009 3:07 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Query Export - Continuous Process



With numbers like that for brain power you may have to hang it up for
the
day. Cuz it seems like the group is rather dead this after noon.

I would like to know how to do this as well cuz I have some problems I
would
like to solve in the same manor.

We may get lucky and some one on the west coast where the day is still
young
may have some brain power left.

I have a SC Choice that is giving me hell that I can't figure out.

~Charlie

_____

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf Of
Blake Clemens
Sent: Friday, April 03, 2009 2:56 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Query Export - Continuous Process

I have a problem... Here is my scenario... We are on Vantage 8.03.405A.

I used a user defined table (UD01) to create a menu. This menu's only
purpose is to store a Sales Order Number and a Date. I then created a
query to show all Sales Order Numbers and Dates entered in this User
Defined Table. The query works fine. I would like to export this
query. So I decided to use the Business Activity Query Export Process.
I want this query to be exported continuously, let's say every 60
seconds. I created a new schedule in the System Agent that runs every 60
seconds. I submitted the query to this schedule via the Business
Activity Query Export Process and checked the "reoccurring" check box.
I restarted the appservers. I see the schedule in the System Monitor
but the file doesn't export. Actually, it exports one time right after
I restart the appservers but it won't export multiple times. My
intention is for Service Connect to grab this exported query and process
it through a work flow that I will create. What am I missing here? I
would like to think that this is fairly simple to set up. Although it
is Friday and my brain is only running at 10% of its potential which is
only 10% anyways. Any help here would be greatly appreciated.

Thanks,

Blake Clemens

IT Systems Engineer

Delmarva Millwork Corporation

(800) 360-2364 x132

***Privileged & Confidential***

This email, together with any attachments, is intended for the named
recipient(s) only and may contain privileged and confidential
information. If received in error, please inform the sender as quickly
as possible and delete this email and any copies. If not an intended
recipient of this email, you must not copy, distribute or rely on it,
and any form of disclosure, modification, distribution and/or
publication of this email is prohibited.

Unless stated otherwise, this email represents only the views of the
sender and not the views of Delmarva Millwork Corporation.

[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]
5
That's a perfect scenario for a BPM. I have a couple BPM's sending data
sets to a service connect workflow. There are business methods for UD
tables, just use the update method.



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 Blake Clemens
Sent: Friday, April 03, 2009 1:56 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Query Export - Continuous Process



I have a problem... Here is my scenario... We are on Vantage 8.03.405A.

I used a user defined table (UD01) to create a menu. This menu's only
purpose is to store a Sales Order Number and a Date. I then created a
query to show all Sales Order Numbers and Dates entered in this User
Defined Table. The query works fine. I would like to export this
query. So I decided to use the Business Activity Query Export Process.
I want this query to be exported continuously, let's say every 60
seconds. I created a new schedule in the System Agent that runs every 60
seconds. I submitted the query to this schedule via the Business
Activity Query Export Process and checked the "reoccurring" check box.
I restarted the appservers. I see the schedule in the System Monitor
but the file doesn't export. Actually, it exports one time right after
I restart the appservers but it won't export multiple times. My
intention is for Service Connect to grab this exported query and process
it through a work flow that I will create. What am I missing here? I
would like to think that this is fairly simple to set up. Although it
is Friday and my brain is only running at 10% of its potential which is
only 10% anyways. Any help here would be greatly appreciated.

Thanks,

Blake Clemens

IT Systems Engineer

Delmarva Millwork Corporation

(800) 360-2364 x132

***Privileged & Confidential***

This email, together with any attachments, is intended for the named
recipient(s) only and may contain privileged and confidential
information. If received in error, please inform the sender as quickly
as possible and delete this email and any copies. If not an intended
recipient of this email, you must not copy, distribute or rely on it,
and any form of disclosure, modification, distribution and/or
publication of this email is prohibited.

Unless stated otherwise, this email represents only the views of the
sender and not the views of Delmarva Millwork Corporation.

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





[Non-text portions of this message have been removed]
6
Thanks Rob!



I was afraid that was going to be the answer. I have not set up a BPM
yet but am eager to learn to do so. Is there any documentation out
there to get me started? I downloaded the document from Epicor but like
most of their documentation it doesn't make any sense.



Thanks,

Blake Clemens

DMC







________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Rob Bucek
Sent: Monday, April 06, 2009 8:51 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Query Export - Continuous Process



That's a perfect scenario for a BPM. I have a couple BPM's sending data
sets to a service connect workflow. There are business methods for UD
tables, just use the update method.

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 Blake Clemens
Sent: Friday, April 03, 2009 1:56 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Query Export - Continuous Process

I have a problem... Here is my scenario... We are on Vantage 8.03.405A.

I used a user defined table (UD01) to create a menu. This menu's only
purpose is to store a Sales Order Number and a Date. I then created a
query to show all Sales Order Numbers and Dates entered in this User
Defined Table. The query works fine. I would like to export this
query. So I decided to use the Business Activity Query Export Process.
I want this query to be exported continuously, let's say every 60
seconds. I created a new schedule in the System Agent that runs every 60
seconds. I submitted the query to this schedule via the Business
Activity Query Export Process and checked the "reoccurring" check box.
I restarted the appservers. I see the schedule in the System Monitor
but the file doesn't export. Actually, it exports one time right after
I restart the appservers but it won't export multiple times. My
intention is for Service Connect to grab this exported query and process
it through a work flow that I will create. What am I missing here? I
would like to think that this is fairly simple to set up. Although it
is Friday and my brain is only running at 10% of its potential which is
only 10% anyways. Any help here would be greatly appreciated.

Thanks,

Blake Clemens

IT Systems Engineer

Delmarva Millwork Corporation

(800) 360-2364 x132

***Privileged & Confidential***

This email, together with any attachments, is intended for the named
recipient(s) only and may contain privileged and confidential
information. If received in error, please inform the sender as quickly
as possible and delete this email and any copies. If not an intended
recipient of this email, you must not copy, distribute or rely on it,
and any form of disclosure, modification, distribution and/or
publication of this email is prohibited.

Unless stated otherwise, this email represents only the views of the
sender and not the views of Delmarva Millwork Corporation.

[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]
7
If you have the service connect tools guide there is a helpful example
in there on setting up a BPM workflow. If you're doing workflows Id
recommend getting it. Since it sounds like you really won't be
filtering on any particular conditions, just sending data out as it's
added, your BPM should be fairly straight forward. If that was a true
statement, on your update method of the UD table you'll create a
pre-process action (you won't need any condition) which will be enable
post process. In your post process on conditions, set to enabled from
(pick your pre-process). Under actions choose Service connect workflow,
and set the parameters as required.



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 Blake Clemens
Sent: Monday, April 06, 2009 8:03 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Query Export - Continuous Process



Thanks Rob!

I was afraid that was going to be the answer. I have not set up a BPM
yet but am eager to learn to do so. Is there any documentation out
there to get me started? I downloaded the document from Epicor but like
most of their documentation it doesn't make any sense.

Thanks,

Blake Clemens

DMC

________________________________

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Rob Bucek
Sent: Monday, April 06, 2009 8:51 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Query Export - Continuous Process

That's a perfect scenario for a BPM. I have a couple BPM's sending data
sets to a service connect workflow. There are business methods for UD
tables, just use the update method.

Rob Bucek

Manufacturing Engineer

PH: 715-284-5376 ext 311

FAX: 715-284-4084

<http://www.dsmfg.com/ <http://www.dsmfg.com/> <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 Blake Clemens
Sent: Friday, April 03, 2009 1:56 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Query Export - Continuous Process

I have a problem... Here is my scenario... We are on Vantage 8.03.405A.

I used a user defined table (UD01) to create a menu. This menu's only
purpose is to store a Sales Order Number and a Date. I then created a
query to show all Sales Order Numbers and Dates entered in this User
Defined Table. The query works fine. I would like to export this
query. So I decided to use the Business Activity Query Export Process.
I want this query to be exported continuously, let's say every 60
seconds. I created a new schedule in the System Agent that runs every 60
seconds. I submitted the query to this schedule via the Business
Activity Query Export Process and checked the "reoccurring" check box.
I restarted the appservers. I see the schedule in the System Monitor
but the file doesn't export. Actually, it exports one time right after
I restart the appservers but it won't export multiple times. My
intention is for Service Connect to grab this exported query and process
it through a work flow that I will create. What am I missing here? I
would like to think that this is fairly simple to set up. Although it
is Friday and my brain is only running at 10% of its potential which is
only 10% anyways. Any help here would be greatly appreciated.

Thanks,

Blake Clemens

IT Systems Engineer

Delmarva Millwork Corporation

(800) 360-2364 x132

***Privileged & Confidential***

This email, together with any attachments, is intended for the named
recipient(s) only and may contain privileged and confidential
information. If received in error, please inform the sender as quickly
as possible and delete this email and any copies. If not an intended
recipient of this email, you must not copy, distribute or rely on it,
and any form of disclosure, modification, distribution and/or
publication of this email is prohibited.

Unless stated otherwise, this email represents only the views of the
sender and not the views of Delmarva Millwork Corporation.

[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]
8
I have the Service Connect User's Guide. Is that the same thing?



Thanks for the help on this Rob. I really appreciate it.



Thanks,

Blake Clemens

DMC







________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Rob Bucek
Sent: Monday, April 06, 2009 9:25 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Query Export - Continuous Process



If you have the service connect tools guide there is a helpful example
in there on setting up a BPM workflow. If you're doing workflows Id
recommend getting it. Since it sounds like you really won't be
filtering on any particular conditions, just sending data out as it's
added, your BPM should be fairly straight forward. If that was a true
statement, on your update method of the UD table you'll create a
pre-process action (you won't need any condition) which will be enable
post process. In your post process on conditions, set to enabled from
(pick your pre-process). Under actions choose Service connect workflow,
and set the parameters as required.

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 Blake Clemens
Sent: Monday, April 06, 2009 8:03 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Query Export - Continuous Process

Thanks Rob!

I was afraid that was going to be the answer. I have not set up a BPM
yet but am eager to learn to do so. Is there any documentation out
there to get me started? I downloaded the document from Epicor but like
most of their documentation it doesn't make any sense.

Thanks,

Blake Clemens

DMC

________________________________

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: Monday, April 06, 2009 8:51 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Query Export - Continuous Process

That's a perfect scenario for a BPM. I have a couple BPM's sending data
sets to a service connect workflow. There are business methods for UD
tables, just use the update method.

Rob Bucek

Manufacturing Engineer

PH: 715-284-5376 ext 311

FAX: 715-284-4084

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

<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 Blake Clemens
Sent: Friday, April 03, 2009 1:56 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Query Export - Continuous Process

I have a problem... Here is my scenario... We are on Vantage 8.03.405A.

I used a user defined table (UD01) to create a menu. This menu's only
purpose is to store a Sales Order Number and a Date. I then created a
query to show all Sales Order Numbers and Dates entered in this User
Defined Table. The query works fine. I would like to export this
query. So I decided to use the Business Activity Query Export Process.
I want this query to be exported continuously, let's say every 60
seconds. I created a new schedule in the System Agent that runs every 60
seconds. I submitted the query to this schedule via the Business
Activity Query Export Process and checked the "reoccurring" check box.
I restarted the appservers. I see the schedule in the System Monitor
but the file doesn't export. Actually, it exports one time right after
I restart the appservers but it won't export multiple times. My
intention is for Service Connect to grab this exported query and process
it through a work flow that I will create. What am I missing here? I
would like to think that this is fairly simple to set up. Although it
is Friday and my brain is only running at 10% of its potential which is
only 10% anyways. Any help here would be greatly appreciated.

Thanks,

Blake Clemens

IT Systems Engineer

Delmarva Millwork Corporation

(800) 360-2364 x132

***Privileged & Confidential***

This email, together with any attachments, is intended for the named
recipient(s) only and may contain privileged and confidential
information. If received in error, please inform the sender as quickly
as possible and delete this email and any copies. If not an intended
recipient of this email, you must not copy, distribute or rely on it,
and any form of disclosure, modification, distribution and/or
publication of this email is prohibited.

Unless stated otherwise, this email represents only the views of the
sender and not the views of Delmarva Millwork Corporation.

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