Consuming Web Service in Excel

In Excel you could use obtain external datasource. I teach customer to use that excel feature to use pivotals directly to Navision tables.

kine wrote:

mrQQ wrote:

Hello,

in one of MS demos they showed how you could use Excel to list navision table data, and then have the changes appear in Nav. I think it was done using web services.

Does anyone remember how they did it?

Yes, it is possible, but had no time to try it yet...

My understanding was that this feature was not in the marketing beta?

The answer is explained here:
http://demiliani.com/blog/archive/2008/10/23/6516.aspx

Hi Freddy.

Nice example, you have created. Better than those on partner source.

I have some problem with your code.

I have started the VS project on the NAV 2009 CTP4.

I have published Vendor, Item and Customer from Navision. Why do you have these 3 web reference. You only use Customer.

When I run the code I get the customer list. But when i edit, delete or add lines and click save changes on the ribon. It just reloads the data and no data is updated.

Where I use the debugger on this code and inserts a breakpoint on "service.Delete(((CustomerRef.Customer)obj).Key);" it is not run where I delete a record and click save changes on the ribon.

internal void Save()
{
// Initialize the Service Connection
CustomerRef.Customer_Service service = new CustomerRef.Customer_Service();
service.UseDefaultCredentials = true;

// Run through records marked for deletion and delete those
DataView dv = new DataView(this.dataTable, "", "", DataViewRowState.Deleted);
foreach (DataRowView drv in dv)
{
object obj = GetRecordObject((string)drv[0]);
if (obj != null)
{


service.Delete(((CustomerRef.Customer)obj).Key);
}
}

What is the problem??

Hi

Thanks for the quick response.

I am running part 4. There are 3 webreferences in the project.

i have exposed

page 21, 30 and 26 which all is card. I have updatede the webreference but it is still not working.

I only see 5 records where i run the project in excel.
Update: removed the filter from the code

have just downloaded the file again from http://www.freddy.dk/NAVTemplate_Final.zip

there are these web reference in code on sheet1.cs

private void Sheet1_Startup(object sender, System.EventArgs e)
{
if (string.IsNullOrEmpty(this.page))
{
// Test mode
this.page = "Customer";
this.view = "SORTING(No.) WHERE(Balance (LCY)=FILTER(>10,000))";
}

switch (this.page)
{
case "Customer":
this.service = new CustomerRef.Customer_Service();
break;
case "Vendor":
this.service = new VendorRef.Vendor_Service();
break;
case "Item":
this.service = new ItemRef.Item_Service();
break;
default:
MessageBox.Show(string.Format("Page {0} is not setup for Edit In Excel. Please contact your system administrator", this.page), "Microsoft Dynamics NAV", MessageBoxButtons.OK, MessageBoxIcon.Error);
break;
}
if (this.service != null)
{
this.service.UseDefaultCredentials = true;
Load();
}
}

I think his problem occurs when deleting a line.

but I tried deleting and inserting .. and all works fine .

Hi.

Have done some more testing.

Insert works.
Delete and edit does not work.

// Run through records marked for delete, create or modify
DataView dv = new DataView(this.dataTable, "", "", DataViewRowState.Deleted | DataViewRowState.Added | DataViewRowState.ModifiedCurrent);
foreach (DataRowView drv in dv)
{
bool retry;
do

only finds records for insert not for edit and delete

i am am using CTP4 Navision 2009.

visual studio 2008 and office 2007 is installed on the virtual pc.

i have found a way to get it to work.

Unzipped ctp4 from partner source again. Had changed the language, on the ctp4 that I was running before.

And now it is working.

But can still not figure out why it is not working on the old VPC.

Thanks for all your help. Super example,

I am really looking forward to the release of dynamicsNAV 2009. Super new stuff.

I am currently developing a SharePoint site using web service from Navision. Instead of using Employee Portal. (Looking forward to dynamicsNAV 2009 SP1)