User Tools

Site Tools


importing

Differences

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

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
importing [2012/12/31 14:47]
cruisefactory
importing [2012/12/31 15:12] (current)
cruisefactory [Importing into your database]
Line 6: Line 6:
 This is a simple data service that provides the //full// table of data //all of the time//. This is a simple data service that provides the //full// table of data //all of the time//.
 Accessing the regular //full// data service by using the /services/ URL. For example: Accessing the regular //full// data service by using the /services/ URL. For example:
 +
 <code>http://feeds.cruisefactory.net/services/YOUR_KEY/get/TABLE_NAME</code> <code>http://feeds.cruisefactory.net/services/YOUR_KEY/get/TABLE_NAME</code>
 +
 +The //full// service download is best used for tables that are not updated regularly, although it can be used for any and all tables at your discretion.
 ==== /increment/ ==== ==== /increment/ ====
 This is an incremental data service that sends only //updated// data. This is an incremental data service that sends only //updated// data.
Line 47: Line 50:
 The above URL will download the specials table from the incremental data service with only the last 24 hours of updates/additions. The above URL will download the specials table from the incremental data service with only the last 24 hours of updates/additions.
  
 +=== Automated XML data download ===
 +Having the XML data downloaded automatically via a cron job or other equivilant is recommended as having the database updated during less busy times and regularly is best practice. Without automating this process, you can have the possibility of out of date data in your local system.
 ===== Importing into your database ====== ===== Importing into your database ======
 +To make importing easier we have provided an [[download_example_schema|example schema]] that matches the table/column structure of the XML data service. You should be able to download and import the XML directly into this example database.
importing.1356925664.txt.gz ยท Last modified: 2012/12/31 14:47 by cruisefactory