web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics SL (Archived) / Import data using web ...
Microsoft Dynamics SL (Archived)

Import data using web services

(0) ShareShare
ReportReport
Posted on by Bob Titular 77

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

I have the same question (0)
  • Blaine Bryant Profile Picture
    Blaine Bryant on at
    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.

  • Bob Titular Profile Picture
    Bob Titular 77 on at
    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

  • Bob Titular Profile Picture
    Bob Titular 77 on at
    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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics SL (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans