Import data using web services

(0) Share

Report

Posted on by Bob Titular

Currently running SL 2011 FP1. We import data invoices/vouchers into SL via the Object model on a daily basis from another in-house application. However, we're running into performance issues when an invoice has > 200 line items (we're a transportation company and each line item represents a ticket - something similar to a bill of lading). I'm looking to see if web services may solve this performance issue. I know I'd have to create my own custom web services. In essence, my own AR Batch and AP Batch web service. Is this possible to accomplish with the current version of the SL Web Service framework?

Examples included in the SDK are in VB. Any examples available in c#?

Thanks!

Bob

*This post is locked for comments

All responses (3)

Answers (0)

Bob Titular 75 on at

Like (0)

Report

RE: Import data using web services

Blaine, I found the problem. It's related to the mapping issue on a windows 8 workstation. After manually mapping my network share, I was able to resolve the Win32Exception error message. Here's the link that I used:

community.dynamics.com/.../having-trouble-installing-microsoft-dynamics-sl-on-windows-8.aspx
Bob Titular 75 on at

Like (0)

Report

RE: Import data using web services

Blaine,

Thanks for the response. Looks like I'll be importing my data directly to the SL SQL tables and then using the object model to release the batches.

Is the Microsoft.Dynamics.SL.ObjectModel.dll compatible for development on a windows 8 workstation? I've created a project that targets a 32bit CPU & .NET 3.5 framework and VS2012. The .NET 3.5 framework and the SL client is installed on the Win8 workstation. When I attempt to instantiate an SIVToolbar object, I get a Win32Exception exception - the system cannot find the file specified.

Taking the same project and running in on a windows 7 machine with VS2010 works with no problems.

Thanks again for your help!

Bob
Blaine Bryant on at

Like (0)

Report

RE: Import data using web services

Bob,

We do not have any Web services that do anything like what you are trying to do. I do not think using Web Services will be helpful to you in this regard. The amount of time that it would take to customize a Web Service to the point where it would work would be significant. I think you could spend less time simply creating your own process to insert the files into your DB tables.