Differences

This shows you the differences between two versions of the page.

--- structure [2012/12/29 17:55]
cruisefactory
+++ structure [2018/05/24 09:51] (current)
cruisefactory
@@ Line 1: / Line 1: @@
 ====== XML Structure ======
 //Please note that all date fields from Cruise Factory are date only and do not contain the time.//
+===== XML Layout =====
+The XML is layed out exactly as below, although this example is missing the table column elements (rows) which are [[structure#table_layouts|listed below]] for each table.
+<code xml>
+<database>
+<table>
+	<row>
+		...
+	</row>
+</table>
+<delete>
+	<ids>
+		...
+	</ids>
+</delete>
+</database>
+</code>
+The above code is for the //increment// data service, although everything apart from the extra //**delete**// element is the same as the regular //full// service. Read up on the differences between the regular and incremental services [[importing#types_of_data_services|here]].
+===== Table Layouts =====
 ==== amenities ====
@@ Line 172: / Line 192: @@
 <price_balcony> double </price_balcony>
 <price_suites> double </price_suites>
+</code>
+==== latlong ====
+<code xml>
+<id> int </id>
+<port_id> int </port_id>
+<lat> float </lat>
+<long> float </long>
 </code>
@@ Line 362: / Line 390: @@
 <name> varchar (max 100) </name>
 <description> text </description>
+</code>
+==== amended_conditions ====
+<code xml>
+<id> int </id>
+<sailingdate_id> int </sailingdate_id>
+<disclaimer> varchar (max 255) </disclaimer>
+<conditions> text </conditions>
 </code>

Cruise Factory XML