tag:blogger.com,1999:blog-6691994129222744759.post3437930226152227031..comments2024-03-21T11:36:24.769-07:00Comments on Dynamics GP Land: Sending XML Files to eConnectChristina Phillipshttp://www.blogger.com/profile/03332221198245457747noreply@blogger.comBlogger5125tag:blogger.com,1999:blog-6691994129222744759.post-86635027686591586012009-09-09T10:57:41.125-07:002009-09-09T10:57:41.125-07:00Thanks Lou. Yes, I've researched the field len...Thanks Lou. Yes, I've researched the field length issue. Based on my tests with GP 9, in most cases, eConnect does not complain at all about a value that exceeds the field length (even 50 chars for a 20 char field). It simply truncates the value. <br /><br />I haven't tested it in GP 10, but I now add field length testing as part of my validation routine that is performed on all data prior to sending it to eConnect.Steve Endowhttps://www.blogger.com/profile/03950475674093020502noreply@blogger.comtag:blogger.com,1999:blog-6691994129222744759.post-49089054924041434882009-09-09T10:54:11.109-07:002009-09-09T10:54:11.109-07:00Be thankful that you did not have long SOP documen...Be thankful that you did not have long SOP document numbers. If you would assume that just because GP will accept a 21 character SOP document number then eConnect will, you would be wrong. eConnect will only accept a 20 digit SOP document number. Microsoft will fix this in a future service pack.Lou Spevackhttps://www.blogger.com/profile/15258147449355059246noreply@blogger.comtag:blogger.com,1999:blog-6691994129222744759.post-72388336507840970482009-08-06T16:16:11.038-07:002009-08-06T16:16:11.038-07:00Thanks Mariano. Good point, and it's definite...Thanks Mariano. Good point, and it's definitely a suggestion I've heard before.<br /><br />BizTalk and other queue based solutions are options, and I've even had discussions with a developer who insisted that SQL Message Broker is the obvious solution, but I tend to try and avoid them for most of my clients because of the additional cost, infrastructure, and/or complexity such solutions can introduce.<br /><br />For example, I just checked BizTalk 2009 Standard licensing, and it looks like the single processor license is anywhere from $8,500 to $12,000, which is pretty pricey if it's only being used for a GP integration.<br /><br />For single source integrations to GP, a simple .NET app either talking to SQL Server or using basic file management has been very simple and low cost, and the client doesn't need any extra infrastructure or licensing. And best of all, they are comfortable clicking an icon on the desktop or using Windows Scheduler to manage an automated integration.<br /><br />I do have one client that uses BizTalk to manage integrations with numerous external sites and trading partners, and we have discussed rolling a few of their GP integrations over to BizTalk, which makes sense since they have the knowledge and infrastructure in place, and would theoretically allow them to centralize their integrations. But so far they haven't been compelled to convert them as they always seem to have more pressing issues.<br /><br />If there's more to such solutions that I'm missing, I'd be interested in hearing the other benefits that might be relevant for a GP integration.<br /><br />Thanks,<br /><br />SteveSteve Endowhttps://www.blogger.com/profile/03950475674093020502noreply@blogger.comtag:blogger.com,1999:blog-6691994129222744759.post-13060739309518796122009-08-06T13:21:47.202-07:002009-08-06T13:21:47.202-07:00When dealing with this many transactions, it's...When dealing with this many transactions, it's best to have a message broker. This is where BizTalk Server comes into play, namely working with envelopes and Orchestrations. In the case of 47,000 invoices in an XML file, you can use an envelope to separate these into 47,000 different messages that can be submitted to an Orchestration on a separate host. Orchestrations can also be configured to control the flow of data going to the eConnect adapter.<br /><br />Best regards,<br /><br />MG.-<br />Mariano Gomez, MVPMariano Gomezhttps://www.blogger.com/profile/13267738662239812289noreply@blogger.comtag:blogger.com,1999:blog-6691994129222744759.post-87069565344387782862009-08-06T12:44:58.579-07:002009-08-06T12:44:58.579-07:00Steve,
Great Post detailing your experiences on e...Steve,<br /><br />Great Post detailing your experiences on econnect. I think those who are new to econnect must read this post to understand the good and bad part of it. Reading your experiences, I thought you might want to ask your client for a quick upgrade to V10 that makes your life and their life easier, i guess in terms of econnect!!Janakhiramhttps://www.blogger.com/profile/04465158187134382030noreply@blogger.com