What time can I retrieve my data export file from Signature? 3
Can I retrieve the file via FTP from Signature? 4
Can I obtain the photos of ships, hotels, and destinations that are available on Signature’s Intranet and consumer sites? 4
Can I use a Web Service to retrieve individual offer/product details? 4
Where can I download the person enrichment series spot logo? 4
Frequent Application Patterns 4
Differentiating Cruise Offer Types 4
Creating a Destination Page 5
Retrieve Offers By City 5
Retrieve Offers By Region 6
Retrieve Cruise Offers By Ship 6
Retrieve Cruise Offers By Cruise Line 6
Export Formats 6
Microsoft Access 6
Variable Content 7
Signature Travel Network (“Signature”) automatically prepares and sends a complete database of active cruise and tour offers, with detailed destination, ship, pricing, date, and hotel product information. The format of this data can be:
XML. This format is spread across several files in a custom schema created by Signature Travel Network.
Contact firstname.lastname@example.org, who will discuss the required information with you and add you to the export recipient list.
Can I receive the export data by email?
Originally, yes. But the data files have grown so large (over 15MB when compressed in ZIP format) that it is advisable to request transfer by FTP.
What time can I retrieve my data export file from Signature?
The daily process completes every morning at 10:30 AM Eastern Time and at this time may be downloaded. If you have opted to retrieve your file via FTP, the file will be delivered by this time.
Can I retrieve the file via FTP from Signature?
Yes, you may provide a host name or IP along with a password and we’ll send the file daily.
Can I obtain the photos of ships, hotels, and destinations that are available on Signature’s Intranet and consumer sites?
No. Signature Travel Network has an exclusive license to use the photographic content on its site. Due to copyright laws, members wishing to use certain photographs must make individual arrangements with the owners of the digital rights to those images.
Can I use a Web Service to retrieve individual offer/product details?
Signature plans to offer this service in the future, but at this time our members have expressed a preference for the full set of data in a format that is easy to import into a local database accessible from their own servers.
Where can I download the person enrichment series spot logo?
Signature frequently receives requests for assistance in constructing logic and queries to present offer information in a certain way. This section describes, using SQL examples, how to construct common applications. The SQL examples use the table and field names from the Access schema (see below), but should be straightforward enough to be applied to other schemas.
Differentiating Cruise Offer Types
Because Signature has different cruise offer types, some ship/port/date combinations may contain more than one offer. For example, the Princess Cruises® Grand Princess® has two trips roundtrip from Galveston on April 7, 2007. One is a general promotional offering, and one is a Signature group offer with exclusive amenities. These sailings are differentiated in the data export by the field sig_cruise_offers.offer_type_id. General promotional offerings have an offer_type_id value of 1, whereas Signature promotions have a value of 2 in that field. Signature Private Collection (hosted) offers and agency-specific offers have a value of 3 and 4, respectively. It is important to check this field when querying cruise offers to differentiate between offer types in your search results. For example, a query of general promotional offerings for the Grand Princess® follows:
You can create destination-specific pages automatically using Signature’s destination names and descriptions. An example of creating a SQL query in ASP to retrieve destination-specific content based on a URL-provided city code (from Signature’s city code lookup in the sig_cruise_destinations table) follows:
sql = "SELECT destination_name,description "
sql = sql + " FROM sig_cruise_destinations "
sql = sql + " WHERE destinationid = " + Request.QueryString("id")
The retrieved fields can then be used to populate a page; assuming the query result is in a variable named rsDestination, here’s a VBScript/ASP example: