Service Connect versus Web Services Directly

Hello Group,

Has anyone successfully implemented Inventory Cycle Count process?
I just started testing it in our TEST Epicor environment. There are some
problems I am encountering with Cycle Count Schedule Maintenance screen
not selecting parts in order to continue with Action Menu "Perform Part
Selection". On ABC Qtys tab it's showing Quantity To Select 8,215 parts,
but Total Selected is 0.

Mike Tonoyan / Natel Engr.
mtonoyan@...

______________________________________________________________________
Notice: This email transmission may contain confidential information and is intended only for the person(s) named. Any use, copying or disclosure to/by any other person(s) is strictly prohibited. By accepting this information, recipients confirm that they understand and will comply with all applicable ITAR and EAR requirements.
______________________________________________________________________
We are in the beginning stages of designing a two way synchronization between Microsoft Dynamics CRM and Epicor 9.05 for customers and contacts. We have been using Dynamics CRM for many years and desire to continue using it over the CRM module in Epicor. Initially, it was suggested we use Service Connect as the mechanism for the Epicor side. We have already written some preliminary asp .NET code for Dynamics CRM. Working with Service Connect, it feels a bit limited being accustomed to the flexibility of a high level language and wondered if anyone has actually used the web services exposed by Service Connect programmatically instead of using them within Service Connect? If not, does this even seem possible?

Thanks for any ideas.
Tim
I have made several asp.net applications using web services. If you can dream it up, it most likely can be done with the webservices.

Most of what we use it for is processing Excel spreadsheets, adding columns of data retrieved from Vantage based on a column in the spreadsheet.
A few other apps provide on screen display of Job Operation info (eliminates printing of routes), On screen clocking in and out of jobs, A utility to export TimePhase info for ranges of parts into Excel, BOM compare export to Excel.....

bw

--- In vantage@yahoogroups.com, "Tim Vonderhaar" <tvonderhaar@...> wrote:
>
> We are in the beginning stages of designing a two way synchronization between Microsoft Dynamics CRM and Epicor 9.05 for customers and contacts. We have been using Dynamics CRM for many years and desire to continue using it over the CRM module in Epicor. Initially, it was suggested we use Service Connect as the mechanism for the Epicor side. We have already written some preliminary asp .NET code for Dynamics CRM. Working with Service Connect, it feels a bit limited being accustomed to the flexibility of a high level language and wondered if anyone has actually used the web services exposed by Service Connect programmatically instead of using them within Service Connect? If not, does this even seem possible?
>
> Thanks for any ideas.
> Tim
>
We use the Pervasive Data Integrator to sync our Vantage datagase to SalesForce. We had a consultant set everything up, so I can't tell you much about.


From: Tim Vonderhaar <tvonderhaar@...>
To: vantage@yahoogroups.com
Sent: Friday, August 19, 2011 7:33 AM
Subject: [Vantage] Service Connect versus Web Services Directly


Â
We are in the beginning stages of designing a two way synchronization between Microsoft Dynamics CRM and Epicor 9.05 for customers and contacts. We have been using Dynamics CRM for many years and desire to continue using it over the CRM module in Epicor. Initially, it was suggested we use Service Connect as the mechanism for the Epicor side. We have already written some preliminary asp .NET code for Dynamics CRM. Working with Service Connect, it feels a bit limited being accustomed to the flexibility of a high level language and wondered if anyone has actually used the web services exposed by Service Connect programmatically instead of using them within Service Connect? If not, does this even seem possible?

Thanks for any ideas.
Tim




[Non-text portions of this message have been removed]
We've built similar sync software to connect Epicor with other systems. I'd
suggest you skip service connect all together. The speed is pretty dismal
for this kind of work.

I'd just go straight to the web services. You may even need to skip the web
services and go straight to the BOs if you need high volume.

On Fri, Aug 19, 2011 at 8:23 AM, bw2868bond <bwalker@...>wrote:

> **
>
>
> I have made several asp.net applications using web services. If you can
> dream it up, it most likely can be done with the webservices.
>
> Most of what we use it for is processing Excel spreadsheets, adding columns
> of data retrieved from Vantage based on a column in the spreadsheet.
> A few other apps provide on screen display of Job Operation info
> (eliminates printing of routes), On screen clocking in and out of jobs, A
> utility to export TimePhase info for ranges of parts into Excel, BOM compare
> export to Excel.....
>
> bw
>
>
> --- In vantage@yahoogroups.com, "Tim Vonderhaar" <tvonderhaar@...> wrote:
> >
> > We are in the beginning stages of designing a two way synchronization
> between Microsoft Dynamics CRM and Epicor 9.05 for customers and contacts.
> We have been using Dynamics CRM for many years and desire to continue using
> it over the CRM module in Epicor. Initially, it was suggested we use Service
> Connect as the mechanism for the Epicor side. We have already written some
> preliminary asp .NET code for Dynamics CRM. Working with Service Connect, it
> feels a bit limited being accustomed to the flexibility of a high level
> language and wondered if anyone has actually used the web services exposed
> by Service Connect programmatically instead of using them within Service
> Connect? If not, does this even seem possible?
> >
> > Thanks for any ideas.
> > Tim
> >
>
>
>



--
*Waffqle Driggers*
*High End Dev, System Design, Profit Drinking
*
*:: 904.962.2887*
*:: waffqle@...*
*:: NO FAXES*

*

*


[Non-text portions of this message have been removed]
Thanks for the feedback. Did you use Service Connect's tool WS-Configuration to install the web services you wanted to use or is there a more preferred method, i.e. the SDK?

Also, do code examples exist anywhere?

--- In vantage@yahoogroups.com, "bw2868bond" <bwalker@...> wrote:
>
> I have made several asp.net applications using web services. If you can dream it up, it most likely can be done with the webservices.
>
> Most of what we use it for is processing Excel spreadsheets, adding columns of data retrieved from Vantage based on a column in the spreadsheet.
> A few other apps provide on screen display of Job Operation info (eliminates printing of routes), On screen clocking in and out of jobs, A utility to export TimePhase info for ranges of parts into Excel, BOM compare export to Excel.....
>
> bw
>
> --- In vantage@yahoogroups.com, "Tim Vonderhaar" <tvonderhaar@> wrote:
> >
> > We are in the beginning stages of designing a two way synchronization between Microsoft Dynamics CRM and Epicor 9.05 for customers and contacts. We have been using Dynamics CRM for many years and desire to continue using it over the CRM module in Epicor. Initially, it was suggested we use Service Connect as the mechanism for the Epicor side. We have already written some preliminary asp .NET code for Dynamics CRM. Working with Service Connect, it feels a bit limited being accustomed to the flexibility of a high level language and wondered if anyone has actually used the web services exposed by Service Connect programmatically instead of using them within Service Connect? If not, does this even seem possible?
> >
> > Thanks for any ideas.
> > Tim
> >
>
There's a web service installer program on the server. Should be located:
C:\Program Files\Epicor Software\Epicor904\WebServices
...or whatever you equivalent directory is. There are some docs in there as
well that you may find helpful. I believe that's the same one SC uses, but
it's been a while since I played with SC and I could be wrong.

SDK doesn't really factor in. Also, if you don't have the SDK, don't get it
thinking it'll make this easier.

I don't know that Epicor has any code examples. But once they're installed,
you can use them like any other web services. Nothing special about em. If
you're on 9.05 and have the choice between WSE and WCF web services, use the
WCF.

If you have trouble getting the code working, let me know and I'll try to
dig up a sample for you.

On Fri, Aug 19, 2011 at 3:57 PM, Tim Vonderhaar <
tvonderhaar@...> wrote:

> **
>
>
> Thanks for the feedback. Did you use Service Connect's tool
> WS-Configuration to install the web services you wanted to use or is there a
> more preferred method, i.e. the SDK?
>
> Also, do code examples exist anywhere?
>
>
> --- In vantage@yahoogroups.com, "bw2868bond" <bwalker@...> wrote:
> >
> > I have made several asp.net applications using web services. If you can
> dream it up, it most likely can be done with the webservices.
> >
> > Most of what we use it for is processing Excel spreadsheets, adding
> columns of data retrieved from Vantage based on a column in the spreadsheet.
> > A few other apps provide on screen display of Job Operation info
> (eliminates printing of routes), On screen clocking in and out of jobs, A
> utility to export TimePhase info for ranges of parts into Excel, BOM compare
> export to Excel.....
> >
> > bw
> >
> > --- In vantage@yahoogroups.com, "Tim Vonderhaar" <tvonderhaar@> wrote:
> > >
> > > We are in the beginning stages of designing a two way synchronization
> between Microsoft Dynamics CRM and Epicor 9.05 for customers and contacts.
> We have been using Dynamics CRM for many years and desire to continue using
> it over the CRM module in Epicor. Initially, it was suggested we use Service
> Connect as the mechanism for the Epicor side. We have already written some
> preliminary asp .NET code for Dynamics CRM. Working with Service Connect, it
> feels a bit limited being accustomed to the flexibility of a high level
> language and wondered if anyone has actually used the web services exposed
> by Service Connect programmatically instead of using them within Service
> Connect? If not, does this even seem possible?
> > >
> > > Thanks for any ideas.
> > > Tim
> > >
> >
>
>
>



--
*Waffqle Driggers*
*High End Dev, System Design, Profit Drinking
*
*:: 904.962.2887*
*:: waffqle@...*
*:: NO FAXES*

*

*


[Non-text portions of this message have been removed]
Any time you can skip a layer of complexity, do it. ESC sits on top of web services, which sit on top of the BOs.... There are some great uses for ESC but it is not the end-all. Without knowing more, it sounds as though you would be better suited to either hit the web services or the BOs directly.

SB

--- In vantage@yahoogroups.com, "Tim Vonderhaar" <tvonderhaar@...> wrote:
>
> We are in the beginning stages of designing a two way synchronization between Microsoft Dynamics CRM and Epicor 9.05 for customers and contacts. We have been using Dynamics CRM for many years and desire to continue using it over the CRM module in Epicor. Initially, it was suggested we use Service Connect as the mechanism for the Epicor side. We have already written some preliminary asp .NET code for Dynamics CRM. Working with Service Connect, it feels a bit limited being accustomed to the flexibility of a high level language and wondered if anyone has actually used the web services exposed by Service Connect programmatically instead of using them within Service Connect? If not, does this even seem possible?
>
> Thanks for any ideas.
> Tim
>
Thanks SB. I have no experience with BO, sounds like I need to though.

--- In vantage@yahoogroups.com, "sbraudrick@..." <sbraudrick@...> wrote:
>
> Any time you can skip a layer of complexity, do it. ESC sits on top of web services, which sit on top of the BOs.... There are some great uses for ESC but it is not the end-all. Without knowing more, it sounds as though you would be better suited to either hit the web services or the BOs directly.
>
> SB
>
> --- In vantage@yahoogroups.com, "Tim Vonderhaar" <tvonderhaar@> wrote:
> >
> > We are in the beginning stages of designing a two way synchronization between Microsoft Dynamics CRM and Epicor 9.05 for customers and contacts. We have been using Dynamics CRM for many years and desire to continue using it over the CRM module in Epicor. Initially, it was suggested we use Service Connect as the mechanism for the Epicor side. We have already written some preliminary asp .NET code for Dynamics CRM. Working with Service Connect, it feels a bit limited being accustomed to the flexibility of a high level language and wondered if anyone has actually used the web services exposed by Service Connect programmatically instead of using them within Service Connect? If not, does this even seem possible?
> >
> > Thanks for any ideas.
> > Tim
> >
>
Thanks waffqle. I will try and get basic code running this week using WCF. From what I have read so far, SC still only uses WSE, but the install of Epicor clearly states the phasing out of WSE in favor of WCF. That said, I will just use WCF as you suggested. Installing the web services appear to be the same process, just a different executable in a different folder. Thanks for the offer to dig up some sample code, I may take you up on that.

Tim

--- In vantage@yahoogroups.com, Waffqle <waffqle@...> wrote:
>
> There's a web service installer program on the server. Should be located:
> C:\Program Files\Epicor Software\Epicor904\WebServices
> ...or whatever you equivalent directory is. There are some docs in there as
> well that you may find helpful. I believe that's the same one SC uses, but
> it's been a while since I played with SC and I could be wrong.
>
> SDK doesn't really factor in. Also, if you don't have the SDK, don't get it
> thinking it'll make this easier.
>
> I don't know that Epicor has any code examples. But once they're installed,
> you can use them like any other web services. Nothing special about em. If
> you're on 9.05 and have the choice between WSE and WCF web services, use the
> WCF.
>
> If you have trouble getting the code working, let me know and I'll try to
> dig up a sample for you.
>
> On Fri, Aug 19, 2011 at 3:57 PM, Tim Vonderhaar <
> tvonderhaar@...> wrote:
>
> > **
> >
> >
> > Thanks for the feedback. Did you use Service Connect's tool
> > WS-Configuration to install the web services you wanted to use or is there a
> > more preferred method, i.e. the SDK?
> >
> > Also, do code examples exist anywhere?
> >
> >
> > --- In vantage@yahoogroups.com, "bw2868bond" <bwalker@> wrote:
> > >
> > > I have made several asp.net applications using web services. If you can
> > dream it up, it most likely can be done with the webservices.
> > >
> > > Most of what we use it for is processing Excel spreadsheets, adding
> > columns of data retrieved from Vantage based on a column in the spreadsheet.
> > > A few other apps provide on screen display of Job Operation info
> > (eliminates printing of routes), On screen clocking in and out of jobs, A
> > utility to export TimePhase info for ranges of parts into Excel, BOM compare
> > export to Excel.....
> > >
> > > bw
> > >
> > > --- In vantage@yahoogroups.com, "Tim Vonderhaar" <tvonderhaar@> wrote:
> > > >
> > > > We are in the beginning stages of designing a two way synchronization
> > between Microsoft Dynamics CRM and Epicor 9.05 for customers and contacts.
> > We have been using Dynamics CRM for many years and desire to continue using
> > it over the CRM module in Epicor. Initially, it was suggested we use Service
> > Connect as the mechanism for the Epicor side. We have already written some
> > preliminary asp .NET code for Dynamics CRM. Working with Service Connect, it
> > feels a bit limited being accustomed to the flexibility of a high level
> > language and wondered if anyone has actually used the web services exposed
> > by Service Connect programmatically instead of using them within Service
> > Connect? If not, does this even seem possible?
> > > >
> > > > Thanks for any ideas.
> > > > Tim
> > > >
> > >
> >
> >
> >
>
>
>
> --
> *Waffqle Driggers*
> *High End Dev, System Design, Profit Drinking
> *
> *:: 904.962.2887*
> *:: waffqle@...*
> *:: NO FAXES*
>
> *
>
> *
>
>
> [Non-text portions of this message have been removed]
>
Any pointers on what mechanism to use to detect data changes, deletions, creations on Epicors side? Dynamics CRM has a pluggin functionality that allows connecting to an Update / Create / Delete / Merge events. Once triggered, there is pre and post XML data that can be used to determine exactly what has changed.

--- In vantage@yahoogroups.com, Waffqle <waffqle@...> wrote:
>
> We've built similar sync software to connect Epicor with other systems. I'd
> suggest you skip service connect all together. The speed is pretty dismal
> for this kind of work.
>
> I'd just go straight to the web services. You may even need to skip the web
> services and go straight to the BOs if you need high volume.
>
> On Fri, Aug 19, 2011 at 8:23 AM, bw2868bond <bwalker@...>wrote:
>
> > **
> >
> >
> > I have made several asp.net applications using web services. If you can
> > dream it up, it most likely can be done with the webservices.
> >
> > Most of what we use it for is processing Excel spreadsheets, adding columns
> > of data retrieved from Vantage based on a column in the spreadsheet.
> > A few other apps provide on screen display of Job Operation info
> > (eliminates printing of routes), On screen clocking in and out of jobs, A
> > utility to export TimePhase info for ranges of parts into Excel, BOM compare
> > export to Excel.....
> >
> > bw
> >
> >
> > --- In vantage@yahoogroups.com, "Tim Vonderhaar" <tvonderhaar@> wrote:
> > >
> > > We are in the beginning stages of designing a two way synchronization
> > between Microsoft Dynamics CRM and Epicor 9.05 for customers and contacts.
> > We have been using Dynamics CRM for many years and desire to continue using
> > it over the CRM module in Epicor. Initially, it was suggested we use Service
> > Connect as the mechanism for the Epicor side. We have already written some
> > preliminary asp .NET code for Dynamics CRM. Working with Service Connect, it
> > feels a bit limited being accustomed to the flexibility of a high level
> > language and wondered if anyone has actually used the web services exposed
> > by Service Connect programmatically instead of using them within Service
> > Connect? If not, does this even seem possible?
> > >
> > > Thanks for any ideas.
> > > Tim
> > >
> >
> >
> >
>
>
>
> --
> *Waffqle Driggers*
> *High End Dev, System Design, Profit Drinking
> *
> *:: 904.962.2887*
> *:: waffqle@...*
> *:: NO FAXES*
>
> *
>
> *
>
>
> [Non-text portions of this message have been removed]
>
I am trying to create a dashboard for our PO approval process to show
only the PO's with part numbers which have revision changes from the
last time they were purchased or the vendor purchasing point address was
changed from the last time. I am having a problem with pulling the very
last PO information only to compare with the current, pending for
approval PO. I am wondering if anyone has already created a similar
dashboard.

Mike Tonoyan / Natel Engr.
mtonoyan@...

______________________________________________________________________
Notice: This email transmission may contain confidential information and is intended only for the person(s) named. Any use, copying or disclosure to/by any other person(s) is strictly prohibited. By accepting this information, recipients confirm that they understand and will comply with all applicable ITAR and EAR requirements.
______________________________________________________________________