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:39] cruisefactory [/increment/] |
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 16: | Line 19: | ||
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 services days parameter === | === Incremental services days parameter === | ||
- | The days parameter gives you the ability to re-download older data or have old [[void|delete ids]] appear in your feed to make sure your database is always up-to-date and accurate. To use the days parameter you must add the number of days to go back to the end of your URL, the number of days is up to you and has no limits. For example to go back 7 days to retrieve the last week of updates/ | + | The days parameter gives you the ability to re-download older data or have old [[importing# |
< | < | ||
http:// | http:// | ||
</ | </ | ||
+ | The days parameter defaults to **1** day if none is given. | ||
=== Incremental services delete element === | === Incremental services delete element === | ||
- | 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 46: | Line 50: | ||
The above URL will download the specials table from the incremental data service with only the last 24 hours of updates/ | 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 ====== | ===== Importing into your database ====== | ||
+ | To make importing easier we have provided an [[download_example_schema|example schema]] that matches the table/ |