This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision | ||
importing [2012/12/31 14:23] 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: | ||
+ | |||
< | < | ||
+ | |||
+ | 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 13: | Line 16: | ||
- | __Incremental | + | === Incremental |
The increment data service is different from the regular //full// services due to a number of reasons. | The increment data service is different from the regular //full// services due to a number of reasons. | ||
- The first being the fact it is incremental as the name implies. | - The first being the fact it is incremental as the name implies. | ||
- | - By default it will only return rows of data that have been //added// or //updated// within the last 24 hours. This default | + | - By default it will only return rows of data that have been //added// or //updated// within the last 24 hours. This default |
- Because of its incremental nature, it includes a new element named " | - Because of its incremental nature, it includes a new element named " | ||
- | __Incremental | + | === Incremental |
- | text | + | The days parameter gives you the ability to re-download older data or have old [[importing# |
+ | < | ||
+ | http:// | ||
+ | </ | ||
+ | The days parameter defaults to **1** day if none is given. | ||
- | __Incremental | + | === Incremental |
- | This new element will include (if any) a comma seperated | + | This new element will include (if any) a comma separated |
<code xml> | <code xml> | ||
< | < | ||
Line 35: | Line 42: | ||
===== Retrieval methods ====== | ===== Retrieval methods ====== | ||
+ | Downloading the XML is done via URLs. If you've read the [[importing# | ||
- | ===== Importing into your database ====== | + | < |
+ | http:// | ||
+ | </ | ||
+ | The above URL will download the specials table from the incremental data service with only the last 24 hours of updates/ | ||
+ | |||
+ | === 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 ====== | ||
+ | To make importing easier we have provided an [[download_example_schema|example schema]] that matches the table/ |