EAN databases provide valuable data - including full text descriptions, amenity lists, hotel IDs, star ratings, and more for every property we offer. Building pages using these files is an excellent way to increase site content regardless of the hotel version or the files you access.  Deliver general static data more readily and serve your visitors more quickly by utilizing local data files on your own domain.

 Recommended update schedule

Failure to update local database files frequently results in delivery of outdated and incorrect data, leading to frustrated customers and lost sales regardless of traffic volumes. Increase sales by keeping database content up-to-date and keep users from landing on inactive properties from outdated local content.

  1. For heavier trafficked sites, once or more per week is crucial.
  2. Daily updates are necessary for the busiest sites serving thousands of users and placing hundreds of bookings per day.
  3. New sites or sites with very low traffic volume should update no less than once per month minimum. Twice per month is recommended.

To update local database records:

Match and parse the current active property table in your database with a newer downloaded active property file, then process with create/remove/update operations.

To open a file:

Review our full tutorial for importing, joining, and running queries on our database files with Microsoft Access. 

Opening files with Microsoft Excel:

  1. Download the appropriate database to your computer and unzip the archive.
  2. Launch Excel and click the open file icon. A dialog box will appear – change the files of type dropdown option to 'all files.'
  3. Navigate to where the unzipped text file is located on your computer and open the file.
  4. Another dialog box will then appear. Select the "delimited" option, then click "Next."
  5. To define the delimiting character, the checkbox next to "Other," place a vertical pipe character { | } in the corresponding field and click finish.

The file might take a few moments to open depending on the speed of your computer.

Note: Excel might not display all of the data contained within certain files. If you experience issues we suggest using a more powerful program, such as Access.

Content and Data Concerns

  1. Multi-language files are in UTF-16 since some of the languages are double-byte character sets (Chinese, Korean etc). 
  2. Files with ONLY English content are ISO-8859.
  3. Note that we cannot remove all non-text characters from these files as it causes issues in some languages. 
  4. We have removed non-printable characters. However, if the source data includes additional problematic characters, we are unable to anticipate all these types of issues prior to generating the file. These types of character issues require the data to be corrected or changed by the supplier source on their end before sending downstream, which is out of EAN control. 
  5. As the content is pulled from a multitude of sources, inconsistent field names or naming conventions from one file to the next may depend on the source of the content for that file at the time the procedure was set up.  Simply note the differences and match the tables on the unique identifier which will be the property or hotel ID. Any specific reasons or logic in how the files are created, designed, or processed is proprietary nondisclosure with the multitude of sources the content is extracted. Place efforts in working with the content and building your own rather than spending time reasoning proprietary processes that have evolved over years of business interactions. Unfortunately changes or updates to these files at this time create issues for long standing use cases.
  6. Any data that is not provided or populated within the files is simply not available or has not been entered by the source. Take this opportunity to research and create your own.  
  7. Best Practice: update regularly to handle any problem characters as they are discovered since we can't control input from source properties. Generate unique content for a better user experience and search engine placement. Updating regularly also ensures you have the most current list of active properties.

File Generation Details

  • The EAN Hotel ID is the unique identifier for all active properties in the EAN system.
  • All columns are delimited by a pipe ( | ) character.
  • All rows are delimited by a line feed character (LF).
  • All files are compressed in .zip files.
  • All multi-language (ML) files are separated into their respective languages and their file names are marked accordingly with a suffix of xx_XX (language_locale).
  • All EAN databases are updated nightly between midnight and 2AM Central Standard Time. However, the updated files are not available until 7AM Central Standard Time.
  • Disregard any naming conventions in the actual URL path of the file.  All files are appropriate for any hotel APIs you are creating as they represent active properties in our system.  The data is available to help you create static content that can be served locally.