Totally New To Xml

Jun 14, 2005

Whilst on holiday last week I have been reading about the wonders of xml! Following this, one of my clients has forwarded a piece of code that he says is "dead easy" to use!!! erm. Maybe easy for some, but total gobbeldy gook to a layperson like me.

What I would really love to do is understand how to use this to automatically fire data via the web from my database to his

I am assuming that say on line 4 where it says "983", I could substitute this with Me.DealerCode (for exampole?)

Here is the code he has sent me

<?xml version="1.0" ?>
<proposal request_type="NEW_PROPOSAL">
<proposal_type>CONSUMER</proposal_type>
<introducer_ref>983</introducer_ref>
<vendor>ABC Cars Ltd</vendor>
<customer type="MAIN"> <!-- Range MAIN, JOINT -->
<name>
<title>Mr</title> <!-- Range MR, MRS, MISS, MS, DR -->
<first_name>Keith</first_name>
<last_name>Miller</last_name>
</name>
<date_of_birth>
<dd>1</dd>
<mm>1</mm>
<yyyy>1970</yyyy>
</date_of_birth>
<gender>M</gender> <!-- Range M, F -->
<marital_status>married</marital_status> <!-- Range SINGLE, MARRIED, DIVORCED_SEPARATED,WIDOWED, LIVES_WITH_PARTNER -->
<home_phone>
<std>01908</std>
<number>123456</number>
</home_phone>
<work_phone>
<std>01234</std>
<number>456789</number>
</work_phone>
<mobile_phone>
<std>07777</std>
<number>987654</number>
</mobile_phone>
<address type="current"> <!-- Range CURRENT, PREVIOUS -->
<years_at>3</years_at>
<months_at></months_at>
<occupancy_status>owner</occupancy_status> <!-- Range OWNER, FURNISHED_TENANT, UNFURNISHED_TENANT, LIVES_WITH_PARENTS, COUNCIL_TENANT, TENANT -->
<flat></flat>
<house_name></house_name>
<house_number>18</house_number>
<postcode>mk187es</postcode>
<street> </street>
<district></district>
<town></town>
<county></county>
</address>
<employment index="0"> <!-- Range 0,1,2,3, ... -->
<employment_type>E</employment_type> <!-- Range E=Employed, SE=Self Employed, R=Retired, UE=Unemployed, O=Other -->
<employed_from>
<mm>12</mm>
<yyyy>1999</yyyy>
</employed_from>
<occupation>Plumber</occupation>
<company_name>Plumbers Ltd</company_name>
<business_address>1 Plumbing Road</business_address>
<business_postcode>MK11MK</business_postcode>
</employment>
<bank>
<account_name>Mr K Miller</account_name>
<sortcode>601455</sortcode>
<account_no>36528609</account_no>
</bank>
</customer>
<customer type="JOINT"> <!-- Range MAIN, JOINT -->
<name>
<title>Mr</title> <!-- Range MR, MRS, MISS, MS, DR -->
<first_name>Graham</first_name>
<last_name>White</last_name>
</name>
<date_of_birth>
<dd>02</dd>
<mm>01</mm>
<yyyy>1949</yyyy>
</date_of_birth>
<gender>M</gender> <!-- Range M, F -->
<marital_status>MARRIED</marital_status> <!-- Range SINGLE, MARRIED, DIVORCED_SEPARATED,WIDOWED, LIVES_WITH_PARTNER -->
<home_phone>
<std>01908</std>
<number>456789</number>
</home_phone>
<work_phone>
<std>01234</std>
<number>789987</number>
</work_phone>
<mobile_phone>
<std>07777</std>
<number>111222</number>
</mobile_phone>
<address type="CURRENT"> <!-- Range CURRENT, PREVIOUS -->
<years_at>3</years_at>
<months_at></months_at>
<occupancy_status>OWNER</occupancy_status> <!-- Range OWNER, FURNISHED_TENANT, UNFURNISHED_TENANT, LIVES_WITH_PARENTS, COUNCIL_TENANT, TENANT -->
<flat></flat>
<house_name></house_name>
<house_number>8</house_number>
<postcode>MK77EP</postcode>
<street></street>
<district></district>
<town></town>
<county></county>
</address>
<address type="previous"> <!-- Range CURRENT, PREVIOUS -->
<years_at>1</years_at>
<months_at></months_at>
<occupancy_status>FURNISHED_TENANT</occupancy_status> <!-- Range OWNER, FURNISHED_TENANT, UNFURNISHED_TENANT, LIVES_WITH_PARENTS, COUNCIL_TENANT, TENANT -->
<flat></flat>
<house_name></house_name>
<house_number>8</house_number>
<postcode>MK77EP</postcode>
<street></street>
<district></district>
<town></town>
<county></county>
</address>
<employment index="0"> <!-- Range 0,1,2,3, ... -->
<employment_type>E</employment_type> <!-- Range E=Employed, SE=Self Employed, R=Retired, UE=Unemployed, O=Other -->
<employed_from>
<mm>02</mm>
<yyyy>1983</yyyy>
</employed_from>
<occupation>Project Manager</occupation>
<company_name>Transition Computing Ltd</company_name>
<business_address>Suite 12, Challenge House, Bletchley
</business_address>
<business_postcode>MK63DP</business_postcode>
</employment>
</customer>
<vehicle>
<vrm>V843LOX</vrm>
<mileage>5000</mileage>
<type>U</type> <!-- Range N,U -->
<first_reg>UK</first_reg> <!-- Range UK, OVERSEAS -->
<category>CAR</category> <!-- Range CAR, MCYCLE, LCV, OTHER -->
<classic>N</classic> <!-- Range Y, N -->
<make>BMW</make>
<model>3 SERIES (E46) 323CI SE</model>
<body_type>Coupe</body_type>
<transmission>MANUAL 5 GEARS</transmission>
<engine_capacity>2500</engine_capacity>
<colour>BLUE</colour>
<FRUK>
<dd>03</dd>
<mm>11</mm>
<yyyy>1999</yyyy>
</FRUK>
<year_of_manufacture>1999</year_of_manufacture>
<engine_number>26749325</engine_number>
<VIN>WBABM32020EX32433</VIN>
<fuel_type>PETROL</fuel_type>
<ins_grp>15</ins_grp>
<TVMA>9200</TVMA>
<retail>11400</retail>
</vehicle>
<finance>
<cost>5000</cost>
<vat_applicable>N</vat_applicable> <!-- Range Y, N -->
<deposit>500</deposit>
<term>36</term> <!-- Range 12 to 48 -->
<flat_rate>6</flat_rate>
</finance>
</proposal>

View Replies


ADVERTISEMENT

Help Me Please - This Is Totally Urgent.

Sep 3, 2006

ok fellas

there are a few things that really bothering me ALOT and i want it sorted otu asap

i have the combo box and want to have it jump to the student details instead it overwrite one part of the name

for example

i have a list said

MUNTZ NELSN
SIMPSON BART
SIMPSON LISA
VAN HOUNTON MILHOUSE
WIGGUM RALPH

and at the page for example MUNTZ Nelson
and i want to jump to WiGGUM ralph via the drop down
instead the name MUNTZ is being overwritten with WIGGUM...grrr please help me

the second thing that bugged me is
how do i create a button to go to the report to have it shown to check to make sure it ok before printing... i have two report files so i need two buttons so plz help

and the last thing which might be the dumbest question of all time
how do i make the tables to store pictures and i want to have the picture field on the forums but i cant work out

please help, this is extremely EXTREMELY URGENT

thank you

View 13 Replies View Related

Totally Lost

Oct 12, 2006

Howdy all!

I am sorta new to access (I used to use it about 6 years ago, but haven't latly so relearning everything), and I am trying to build a db to track the different projects I make for my webstore (www.mutzigcreations.com (http://www.mutzigcreations.com).

I am trying to make a form that is tabbed so that I can enter in all my base information (different materials {wood, acyrlic, and specials}, clips, platings, etc..) into my different tables, but for the life of me I can't seem to get anything to work.

I really just want 1 tab per item, so 1 tab for clips that would enable me to enter in all the different clips into my clips table. I can't seem to get a connection of any sort to work and was wondering if anyone had any advice or guidence on what to do?

Thank you!
Doug

View 2 Replies View Related

Help, Should Be Easy But Totally Lost.

May 6, 2005

ok i no hardly anything about forms, searched the forum no luck.


i have a number of fields in a mainform (created through a wizard) i have no discovered that i have run out of room on the page (Detail Page i think)

so i would likr to add a another page/form within the mainform.

not sure how to go about it, i created a subform but cannot seem to transfer any information to it. i tried copy and paste but this eturns script errors.

i could be going about this the totally wrong way but i dont know.

so what i am trying to do is create a nother form/subform in the mainform (detail) page if that makes any sense

View 3 Replies View Related

Totally Stupid Question...

Mar 19, 2006

Right.. I'm a complete noob @ access...

Ok.. I have a yes/no column in my table and I want to build a query on that table so it returns all the records with NO (unticked box).

How do I do that?



Any help appreciated :)

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved