NAV Web Store - Code Samples

Administrator

NAV Web Store - Code Samples
The Dynamics™ NAV Web Store site demonstrates how simple it is to create applications and services for Dynamics™ NAV and the .NET platform.

After installing the sample site, start browsing and add items to your shopping cart and submit it to the Dynamics™ NAV back end system for ordering. You can create reviews for any items; you can review your existing orders… Take the quick tour to know more about it.

The sample site is multi-language and multi-currency enabled. French and English come in the package. Creating new languages only requires the translation of 79 lines in an XML file.

Objects for the following demo companies of Dynamics™ NAV are included:
- CRONUS International Ltd.
- CRONUS Australia Pty. Ltd.
- CRONUS New Zealand Ltd.
- CRONUS France S.A.
- CRONUS UK Ltd.
- CRONUS USA, Inc.
- CRONUS Singapore Pte. Ltd.

http://www.mibuso.com/dlinfo.asp?FileID=775

Discuss this download here.

Lanki

Hello,

while installing the NAV Web Store (third folder), I get this exception handler error: Line 10: Incorrect Syntax near '('.

Any idea what's causing this or what i'm doing wrong in the installation process?

I must say that I'm using a Belgian Database and the Worldwide Objects.

ofbridge

You get this error (handler error: Line 10: Incorrect Syntax near '('. ) because you are trying to install the NAV Web Store on SQL Server 2000. SQL Server 2005 is required.

a0116

Hello,

I am getting the same error (Product: NAV Web Store -- Error 1001. Line 10: Incorrect syntax near '('., (NULL), (NULL), (NULL).) when trying to running the web store setup routine with SQL 2005.

I am running localized versions of the following:

Windows xp
Sql 2005
Nav client 4.0 sp2
NAS 4.0 sp2
IIS 5.1
Cfront from 4.0 sp2

Any ideas on what I might be doing wrong?

jonsan21

Hello,

Seems like the third installation (Web Store) can not support named instances.

My default instance still running 2000, where I have a named instance SQL2005 for the SQL2005 version.

Anyway to change this in the installation?

I tried to install to a machine which has default instance to be SQL2005, and backup then restore the database over, but seems like I have a lot of permission problem?

ofbridge

The scripts to install the NAV Web Services and the NAV Web Store were a bit complicated to put together, since there are many things to setup (URL address for the Web Services, NAS, MSMQ, creating the database, permissions for ASPNET account...). I am not sure I will have time to modify the script to allow named instance... The NAV Web Store database will always get created on "localhost", which needs to be a SQL Server 2005.

But if you are interested, I can give you the Visual Studio 2005 Deployment Project so you can modify (and debug :-) the script at your convenience.

jonsan21

Hi,

That would be great.

Can you help to zip it up and send to me?

Thanks a zillion.

Rgds,

Jon.

kriki

jonsan21:[Please use PM's instead of 'Me too'-posts]
See Forum Rule #14: Forum Rules.
And remember : spammers like it very much that you put your email-address in the posts.

jonsan21 wrote:

Hi,

That would be great.

Can you help to zip it up and send to me @ jonsan21@gmail.com?

Thanks a zillion.

Rgds,

Jon.

jmaz

i get the following error when launching http://localhost/NAVWebStore/Default.aspx

"The Communication with the Dynamics Nav back-end application cannot be established"

Nav application server is installed and running , get the start with parameter "WEBSERVICES" in event viewer

there are no other errors shown in event viewer

I have reinstalled the Web services components and restart the IIS
the ASPNET account has public and dbowner access to Nav db (SQL 2005)and Web store db

the account used to connect is a domain account and has nav super role in navision
the domain account is administrator of the PC and has access to nav and webstore

the web store installed is in the default website and the default app pool identity is "Local System"

the default web site authentication is windows authentication
and i have also set the anonymous user account to the domain account (as above)

i am missing something here ?

shane

jmaz,

I too had the problem you are having so I went through all the settings again…

Make sure that the Message Queues and the NAS company name are named correctly. I made this mistake. They have to have the same name as the company name in Navision.

Message Queues: Company Name 1, Company Name 2
NAS: Company Name

Also double check the other NAS settings as well. When I installed I accepted the defaults only to realize I needed to make changes to match my configuration. I’m also running the NAS Service under an administrative account.

I however am having a few other issues. I can add a user (via the website) but not login with that user afterwards and I can not see any of the parts catalogue. Currently I’m trying to work through this.

Good luck.

ofbridge

After updating the Product Group Code field in NAV (item card) to update the catalogue in the Web Store, you need to do an "iisreset", because the catalogue is cached to improve performance. If you don't want the catalogue to be cached, you can remove the following line in the _Menu.aspx file: <%@ OutputCache Duration="3600" VaryByParam="selection" %>. By default, the Product Group Code fields in a CRONUS company are empty, so you need to create them to see the catalogue in the Web Store.

When registering a user from the web-site, the Web Store Access table is populated in NAV. When registering a new user in the Web Store for an existing customer card, the name you specify in the web page should be exactly the same than the name in the customer card.

Kappe

Hi

I have the problem that I even can't install the NAV Web Store.
I get the well known ( ) error:
Named Pipes Provider, error: 40 - Could not open a connection to SQL Server message.

I have it all running on a local machine with SQL 2005 Express installed and remote connections are allowed on the SQL.
So I'm not sure what it could be instead.

Could any body give me a hint?

Regards
Kappe

Benno

At the end of the installation of the webservices I receive an MSMQ permission error. I use Windows XP Professional and MSMQ is installed in Workgroup mode. How can I solve this problem so I can use the webshop.

Layla

Is it possible to run it on MSSQL 2000? If it is, please tell me how?

Regards

ofbridge

It is important to follow the recommendations in the installation procedure document:
- You have to be an Admin of the computer (to avoid permission errors with MSMQ for example)
- SQL Server 2005 is a pre-requesite. I have not tested the installation procedure with the Express edition

leachol16

Hi,

I've installed the Nav Web store, everyting was working Until I tried to Submit an order and then i get a an error regarding the MSXML.

Error: This message is for C/AL programmers: The call to member save failed. msxml4.dll returned the following message: System does not support the specified encoding.

This is the message, printed on the web page and in navision when you run CU80000 RunNavisionProcess via GUI NAV not NAS.

I've tried reinstalling MS4.00 SP2 again and i've tried altering the encoding on the XML ports from UTF-16 to UTF-8 bit no joy.

I'm running XP Pro, with Explorer 7, SQL 2005 sp1 and NAVGB403

Does anybody have any ideas ?

Luk

Hello everyone,

I think I'm suffering more or less the same problem Shane suffered, the NAS settings. I require the startup parameter for the NAS. Can anyone help me on this one?

Thank you!
Luk.

Luk

Hello again!

Found the NAS settings: start-up parameter should be "WEBSERVICES"
It was in the installation pdf ](*,) Sorry forumadmin for these obsolete postings.

Best regards, Luk.

Luk

I can't get the NAS properly started.

With the start-up parameter "WEBSERVICES" it just won't start. I get the following error: "Could not start the MS BS Navision Application Server ICOML06-SQL service on Local Computer. Error 1: Incorrect function."

Without the start-up parameter, the service starts, but in the log file (event viewer) I get 2 warnings:
1) "The description for Event ID ( 109 ) in Source ( ICOML06-SQL ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. You may be able to use the /AUXSOURCE= flag to retrieve this description; see Help and Support for details. The following information is part of the event: The localhost server cannot be found."
2) "The description for Event ID ( 109 ) in Source ( ICOML06-SQL ) cannot be found. The local computer may not ... The following information is part of the event: The Navision Application Server ICOML06-SQL could not initialize properly. The server will attempt to initialize every 30 seconds until this is successful."

And, when installing the NAV WebStore, I get error: "In exception handler: Database 'NAV Web Store (4-0)' already exists."

Does anyone have an idea what I'm doing wrong??
Thank's a lot!

Sorcerer

leachol16 wrote:

Error: This message is for C/AL programmers: The call to member save failed. msxml4.dll returned the following message: System does not support the specified encoding.

I've got the same one (using NAV 5.0, but also in 4.0). Anyone an idea about this?

andrejsm

Now I've got the same one (using NAV in 4.0). Any solutions for this problem?

mic1000000

Hi,

I' ve installed the Nav Web Store on one Compuer. Everthing works fine. But I've to split the installation, so that the webserver is on a different server.
I think the best interface between the 2 servers would be the web service. Is that right?
I installed the parts of the architecture till the web service on the navision machine (SQL 2000). Installtion process works.
On a different machine I installled SQL 2005 Express (standard instance) and the nav web store. Installion process was also ok.
First a got a Problem to connect to the nav store database. I solved it by changing the web server user...
But the webservice don't work. I get the following error:
"The communication with the Dynamics NAV back-end application cannot be established"
I think it is also a user rights problem!?

Can anyone help me?

Thank you!
Daniel

Swingparty

Edit:
Soled the problem with registring a new account. Now my problem is the following when trying to submit an order:

Error: This message is for C/AL programmers: The call to member save failed. msxml4.dll returned the following message: System does not support the specified encoding.

I've seen that some other in here had the same problem. Any solutions?


Hi,

I've installed NWS and everything works fine untill registring an account, then I get this error message:

Registration failed: the information provided is not valid or the EMail address already exists

Anyone have a sugestion what I'm missing?

lokiworld

Swingparty wrote:

Hi,

I've installed NWS and everything works fine untill registring an account, then I get this error message:

Registration failed: the information provided is not valid or the EMail address already exists

Anyone have a sugestion what I'm missing?

Here is one scenario, that works for sure:

1. Open MS Dynamics NAV, database, company.
2. Select "Sales & Marketing > Order Processing > Customers" in Navigation Pane.
3. Create customer with some e-mail address.
4. Open "Object Designer", open table "Web Store Access" and add a record with the same e-mail. It is not possible to set password here. See the next step.
5. Open NAV database in SQL Management Studio and select table "{COMPANY-NAME}$WebStoreAccess".
6. Set the password field value as "E99A18C428CB38D5F260853678922E03". This is a MD5 hash with removed "-" characters of the password "abc123".
7. Simply log in with that e-mail and password.

naviguy777

Hi,
I was wondering if anyone here knows (or owns?) a web store running on this install (Domain?) I would like to see the performance of it before I even go through the setup and everything. I am especially interested in how quickly pages can be built up when teh business logic is kept behind a firewall.
Any comments / experiences and - most important - URLs would be helpful.

Thanks.

csicso

Hi everyone!

I've installed the Web Store for NAV 4.0 SP2. Everythings ok, but when I trying to run for example the Codeunit 80000 with our customer's licence it throws a message, that I don't have permissoin...

When I trying with our (developer) licence, it's ok. Which licence type needed for the Web Store?

Thanks for reply!

Csicso

PS: sorry my english, I'm from Hungary...

absarwaikar

Hi,

I installed the web store. When I submit an order I get the following error,
Error: This message is for C/AL programmers: The call to member save failed. msxml4.dll returned the following message: System does not support the specified encoding.
I tried UTF-8, UTF-16 and ISO-8859-1. Also I dont think the error is encoding 'cos the same code (NavisionWebServicesFunction:RemoveNamespace) works for NavisionObject initial load. But it doesnt work when called from NavisionObject:GetParameterListAsXml. ](*,)

The line which err's out is XMLDoc2.Save in GetParameterListAsXml

Help!!!

Thanks

ajhvdb

I think the topic poster is [-( anymore

aliennav

I have installed webservices but at the end it is giving a message"After Install please check that NAVSERVER\ASPNET has the permission to NAV Database."

NAVSERVER is the name of the machine on which everything (NAS,Webservice,Sql 2K5,etc....) is installed.

Kindly tell me how to give permission to access NAV DB to ASPNET account.Where is it found??

dezarnaulds

Hello,

I wonder if leachol16, Sorcerer, Swingparty or absarwaikar have found a solution for this error :

Error: This message is for C/AL programmers: The call to member save failed. msxml4.dll returned the following message: System does not support the specified encoding.

Thanks for feedback.

Cyril.

gummiob

i was trying to install this but i cannot get this to work

is it possible if someone can get me the extracted file ? that would be nice