Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.5K Microsoft Dynamics NAV
- 18.5K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 115 Navision DOS
- 854 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 615 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 264 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 992 SQL General
- 385 SQL Performance
- 33 SQL Tips & Tricks
- 34 Design Patterns (General & Best Practices)
- Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.7K General
- 1.1K General Chat
- 1.6K Website
- 79 Testing
- 1.2K Download section
- 23 How Tos section
- 259 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Options
Use of unbounded Text Element when Exporting xmlport to WS
primeap
Member Posts: 37
Hi
i use an xmlport to export a record as a webservice like described here:
http://www.kauffmann.nl/blog/index.php/2011/02/24/how-to-use-xmlports-in-web-services-2/#comment-4642
i have a question. when i use the xmlport and set an Element with Source Type “Text”
and on the properties i leave tha maxoccur to “unbounded”
in the .net this Element will be mapped as an array of string -> name[]..
ok, thats fine.
but my question is..
HOW CAN I FILL THE ARRAY IN NAVISION ON THE SAME RECORD?
Saying im exporting the saleline 123
in that i define a text element barcodes unbounded
so i can assign multiple barcodes to the same line..
regards
alex
i use an xmlport to export a record as a webservice like described here:
http://www.kauffmann.nl/blog/index.php/2011/02/24/how-to-use-xmlports-in-web-services-2/#comment-4642
i have a question. when i use the xmlport and set an Element with Source Type “Text”
and on the properties i leave tha maxoccur to “unbounded”
in the .net this Element will be mapped as an array of string -> name[]..
ok, thats fine.
but my question is..
HOW CAN I FILL THE ARRAY IN NAVISION ON THE SAME RECORD?
Saying im exporting the saleline 123
in that i define a text element barcodes unbounded
so i can assign multiple barcodes to the same line..
regards
alex
0
Best Answer
-
Options
kauffmann
Member Posts: 56
Hi Alex,
The solution is to use the table Item Cross Reference as a linked table in the XML Port. Just like you are used to in Reports.
Some things to note here:
* Set MinOccurs to zero. Otherwise you will get an error when no Item Cross Reference exists for a certain Item. In that case there will be no ItemCrossRef node, which breaks the rule of MinOccurrs = Once. The .Net code will fail on this (while NAV has no problem with generating it :-#).
* You can avoid any code in the XMLPort by using the SourceTableView and LinkFields properties.
This example results in Visual Studio as follows:
Succes!A good programmer makes al the right mistakes
My blog5
Answers
but the output comes only for the last barcode..
there are two active barcodes in the item cross reference table
1000 STK Barcode 022255127790 Nein 12.01.12
1000 STK Barcode 22255127790 Nein 12.01.12
The solution is to use the table Item Cross Reference as a linked table in the XML Port. Just like you are used to in Reports.
Some things to note here:
* Set MinOccurs to zero. Otherwise you will get an error when no Item Cross Reference exists for a certain Item. In that case there will be no ItemCrossRef node, which breaks the rule of MinOccurrs = Once. The .Net code will fail on this (while NAV has no problem with generating it :-#).
* You can avoid any code in the XMLPort by using the SourceTableView and LinkFields properties.
This example results in Visual Studio as follows:
Succes!
My blog
thank you very much!