Customised exporting using XMLPort

Maintex
Member Posts: 4
Hi,
I have an XMLPort that I currently populate with values in code that I then export to a PHP page. The PHP page interpretes these values and returns data from a MySQL database based on the values exported to it.
Up until now this has been fine, however, I now want to output the fields I want to have returned to me from the PHP page. I can easily do this by setting an XMLPort text variable to a string containing the fields that I want and seperated by a common delimter. However, what would be nice is to be able to have the following:
But I don't know how to do this without creating a table containing the fieldnames and exporting that table using the XMLPort. Is there a way in OnInit/OnPre/OnPost XMLPort to create this array of fields in code so that it will be output like the XML shown above?
Thanks in advance,
Maintex
I have an XMLPort that I currently populate with values in code that I then export to a PHP page. The PHP page interpretes these values and returns data from a MySQL database based on the values exported to it.
Up until now this has been fine, however, I now want to output the fields I want to have returned to me from the PHP page. I can easily do this by setting an XMLPort text variable to a string containing the fields that I want and seperated by a common delimter. However, what would be nice is to be able to have the following:
<fields> <field> a </field> <field> b </field> <field> etc... </field> </fields>
But I don't know how to do this without creating a table containing the fieldnames and exporting that table using the XMLPort. Is there a way in OnInit/OnPre/OnPost XMLPort to create this array of fields in code so that it will be output like the XML shown above?
Thanks in advance,
Maintex
0
Comments
-
May be you can try to use Integer table as base and for each node under this Table node use text variable you will fill with next value in the OnBeforePassVariable or OnAfterAssignVariable for import...0
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.7K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 116 Navision DOS
- 851 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 617 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 320 Dynamics CRM
- 111 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 990 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 35 Design Patterns (General & Best Practices)
- 1 Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1.1K General Chat
- 1.6K Website
- 83 Testing
- 1.2K Download section
- 23 How Tos section
- 252 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions