How to enter a bunch of hotels/events/services/restaurants

How to enter a bunch of hotels/events/services/restaurants/reports

If there are more than 10 entries to add, the procedure with the HTML-Form might be too boring for some of you. So we provide alternate ways. Though it may look somewhat difficult it may return out to be quite simple after you have had a look at the example below.

1. Create a simple text file (e.g. with the notepad editor) containing all necessary data in the following format. Everything after the # is only comment and need not be typed. If you want to use comments in your own files, make sure that there is a white space before it. If you have your date in a kind of database program and have your data available in XML or if you have difficulties to produce a text file like below, please send me an Email. We'll find a way.

ID=all                                #Start the general section
Section=H                             #all following entries are hotels
Country=us                            #all following entries are in the U.S.A.

                                      #The data of the first hotel follow
ID=1                                  #your running number
Objectname=Miami Beach Hotel          #syntax is: Fieldname=Value
State=FL                              #you should use abbreviations if possible
Region=Miami
URL=http://www.miamibeach.com/        #Please don't forget the http://
ContactEmail=desk@miamibeach.com      #Email contact for guests
Category=4                            #see below for list of Categories
RoomsSeats=50                         #see below for list of fields
Features=PO,SA                        #see below for list of Features

ID=2                                  #The data of the second hotel follow
Objectname=Illibilly Bed & Breakfast
State=IL
Region=Urbana-Champaign
URL=http://www.illibilly.com/
ContactEmail=info@illibilly.com
Category=2
RoomsSeats=20

ID=all                                #Return to the general section
Section=R                             #all following entries are restaurants

ID=3                                  #The data of the first restaurant follows
Objectname=The Happy Burger Inn
State=NM
Region=Albuquerque
URL=http://www.happyburger.com/
ContactEmail=eat@happyburger.com
Category=1
RoomsSeats=55
SmokeFreeType=R                       #separate room for nonsmokers (see below)
Style=Fast Food

2. Send the text file with your data to me by using this form. You will then get a report of the submitting process.

Possible Fields:

Field	Explanation
Section, Country, Objectname and RegistrantEmail are required. All other fields are optional.
Objectnr	If you enter your codenumber here, the corresponding record will be updated rather than inserted.
Section	see below
Country	The country code. If you do not know, please have a look at this page.
Objectname	The name of your enterprise
URL	The complete URL of your enterprises homepage
URLReview	An URL of a review about your enterprise
ContactEmail	The Email that your customers should use
Registrant	Your name (will not be published, just for our correspondence)
RegistrEmail	Your name (will not be published, for sending you the confirmation)
TelCountryCode	Phone code prefix of your country (e.g. 1 for USA, 49 for Germany)
TelAreaCode	area code of your enterprises phone
TelLocalnum	rest of the phone number
FaxCountryCode	county prefix of your enterprises fax number
FaxAreaCode	area code of your enterprises fax
FaxLocalnum	rest of the faxnumber
State	The name of the federal state (or more general: the name of the part of your country, in an administrative sense)
Region	the name of the part of your state, like a tourist would call it, e.g. Grand Canyon
ZIPCode	up to 12 characters long. (german: Postleitzahl)
Town	max. 25 characters
Townpart	e.g. Manhatten, Schwabing
StreetNo	e.g. "110 Upper Blvd.", "Hauptstr. 25"
AdressSupplem	any part of the address not yet mentioned
SmokeFreeType	see below
RoomsSeats	Number of persons that can be served by your enterprise at one time
Style	e.g. vegetarian,mexican,old fashioned,gay
Category	see below
Housetype	e.g. Youth Hostel, Kurhaus
PriceLow	what a customer has to pay at least
PriceMid	what an average customers pays for one visit at your site
PriceHigh	what a customer pays if he prefers exquisite things
PriceCurrency	three letter abreviation of the currency for the prices in this record.
StartDate	the first day of the event or the day your enterprise started
EndDate	the last day of the event or the day your enterprise will finally close
ClosedPeriod	50 characters do describe periods of closing, e.g. "closed on mondays"
PetsWelcome	see below
KidsWelcome	see below
Handicapped	see below
Features	see below for list of Features
PointLat	geographic coordinates: latitude as decimal degrees
PointLon	geographic coordinates: longitude as decimal degrees
PointAlt	geographic coordinates: altitude above sea level in meters
Comment	50 characters room for anything we might have forgotten, not visible for guests
Kommentar	250 characters room for anything we might have forgotten, visible for guests
created	date (YYYY-MM-DD) of the creation of this record
updated	date of the last update of this record

Field	Explanation	Price per day
The following fields are not free. If you use them, the billing data are required, because you will be charged yearly.
XDescription	80 characters of extra description, e.g. A brand new house with Sauna, Whirlpool and Dance Floor	0.15$
XSpecialOffer	Something you offer for a limited time, e.g. Halloween Party	0.35$
XSO_Start	Date when your special offer starts	included
XSO_End	Date when your special offer ends	included
XSO_Price	A typical price a customer has to pay for your special offer	included
BillingPerson	The name of the person we can send our invoice to	required
BillingFax	The faxnumber where we can send our invoice to	required for Europe
BillingEmail	The Email where we can send our invoice to	required
BillingCCNum	Your credit card number	required for outside Europe
BillingCCHold	The name of the credit card holder	required for outside Europe
BillingCCExp	credit card expiry date	required for outside Europe

The following fields are only applicable for restaurants
Field	Explanation	max. length
Foto1URL	The complete URL of a photo of your restaurant	100
kueche	The nationality of the food	90
seatsinside	number of seats inside for regular guests	5
seatsoutside	number of seats outside	5
seatsextra	number of seats for events, parties etc.	5
zeitoffen	opened, e.g.: 12-15 and 18-23 except holidays	200
zeitwarm	time when warm meals are served	200
reservation	one of: 'unnoetig', 'moeglich', 'empfohlen', 'erforderlich'
Haustyp	a set of: 'Restaurant', 'Landgasthaus', 'Pizzeria', 'Bar', 'Bistro', 'Cafe', 'Kneipe', 'Musikkneipe', 'Nachtclub', 'Internetcafe', 'Imbiss', 'Konditorei', 'imHotel'

The following fields are only needed if you want to provide a list of free rooms for your hotel
Field	Explanation	max. length
URLxx	The complete URL of your homepage in another language	100
Languagexx	The language in which URLxx is written	2
text1en	english text that will appear above the photo	255
text1xx	text in the other language that will appear above the photo	255
FotoURL	The complete URL of an already scanned picture of the contact person for the guests.	100
Fototexten	caption of the photo in english	255
Fototextxx	caption of the photo in the other language	255
text2xx	text in the other language that will appear below the photo	255
text2en	english text that will appear below the foto	255
remember	the amount of days when you want to be remebered by email to send your new list of free rooms	5

Field values:

Sections		Categories		SmokeFreeType		Pets ... Kids ... Hanicapped ...
Value	means	Value	means	Value	means	Value	means
H	Hotel	5	De Luxe	H	whole house smokefree	Y	... are welcome
E	Event	4	First Class	R	separate room for nonsmokers	N	... are not welcome
R	Restaurant	3	Business	Pxx	xx seats/rooms are reserved for nonsmokers	U	don't know
S	Service/Activity	2	Tourist	L	excellent air condition
B	Travel report	2	Low Budget	-	mixed

Abbreviations for Features:

GA	Garage optional
GI	Garage included
GP	enough parking
IA	Internet: modem-plug
II	Internet: ISDN-plug in room
IT	Internet: PC/Terminal in foyer
IL	Internet: LAN (Ethernet) in room
IW	Internet: WLAN
KI	children care
BE	Beauty
DB	steam bath
FI	Fitness-Studio
PO	Pool
SA	Sauna
SO	Solarium
TR	drying room
OV	well reachable with public transport
FA	bicycle rent
WE	mechanic tools room
SM	rooms for seminars
VE	vegetarian meal
VG	vegane meal
VZ	sugarfree food

Language codes have to be written as two-character ISO-codes in lowercase, e.g. de for german.

This explanatory page was last updated 2013/01/20.