<%-- Selektion aller verfuegbaren Daten fuer CSV-Datei --%>
<ce:set var="sql" value="select user_salutation, user_firstname, user_lastname, user_company, user_street, uavx_street2, user_city, uavx_zip, user_fax, 
				 user_phone, user_email, uavx_email, indc_gender, user_url, uavx_pobox1, uavx_pobox2, uavx_iso_id, user_country, uavx_country, uavx_lang_id, uavx_company2
				 from TBL_USER usr left join TBL_EPT_UAVX_USER_AV_EXT uavx on usr.user_id=uavx.user_id where usr.user_id=#r_su_user_id#"/>
<ce:sql sql="#sql#" into="t_user_salutation, t_user_firstname, t_user_lastname, t_user_company, t_user_street, t_uavx_street2, t_user_city, t_uavx_zip, t_user_fax, t_user_phone, t_user_email, t_uavx_email, t_indc_gender, t_user_url, t_uavx_pobox1, t_uavx_pobox2, t_uavx_iso_id, t_user_country, t_uavx_country, t_uavx_lang_id, t_uavx_company2"/>

<ce:set var="sql_su" value="select uavx_iso_id, uavx_lang_id, uavx_country
				 from TBL_USER usr inner join TBL_EPT_UAVX_USER_AV_EXT uavx on usr.user_id=uavx.user_id where usr.user_id=#r_user_id#"/>
<ce:sql sql="#sql_su#" into="t_uavx_iso_id, t_uavx_lang_id, t_uavx_user_country_av"/>

<%-- Datei und Header in Abhaengigkeit der Sprache generieren --%>
<ce:if cond="#CE_LANGUAGE#=='de'">
	<ce:set var="t_user_country" value="#t_uavx_country#"/><%-- dt. Laendername --%>
	<ce:set var="user_country_av" value="#t_uavx_user_country_av#"/><%-- dt. AV-Laendername --%>
	<ce:set var="contact_category" value="MMI Vertriebspartner"/>
	<ce:set var="filename" value="#glo_file_path_bean#MMI-Kontakt-#t_uavx_iso_id#.csv"/>
	<ce:saveas file="#filename#"></ce:saveas>
	<ce:saveas file="#filename#" action="append">"Anrede","Vorname","Nachname","Firma","<ce:msg key="outlook-imp.field-street"/> <ce:msg key="outlook-imp.field-business"/>","<ce:msg key="outlook-imp.field-street"/> <ce:msg key="outlook-imp.field-business"/> 2","Ort <ce:msg key="outlook-imp.field-business"/>","Postleitzahl <ce:msg key="outlook-imp.field-business"/>","Land <ce:msg key="outlook-imp.field-business"/>","Fax <ce:msg key="outlook-imp.field-business"/>","Telefon <ce:msg key="outlook-imp.field-business"/>","Kategorien","E-Mail-Adresse","E-Mail: Angezeigter Name","E-Mail 2: Adresse","E-Mail 2: Angezeigter Name","Geschlecht","Webseite","Postfach <ce:msg key="outlook-imp.field-business"/>","Sprache"
</ce:saveas>
</ce:if>
<ce:if cond="#CE_LANGUAGE#=='en'">
	-> <ce:getUser userID="#r_user_id#" into="l_obj_user"/>
	<ce:set var="user_country_av" value="#l_obj_user.country#"/><%-- engl. AV-Laendername --%>
	<ce:set var="contact_category" value="MMI Partners"/>
	<ce:set var="filename" value="#glo_file_path_bean#MMI-Contact-#t_uavx_iso_id#.csv"/>
	<ce:saveas file="#filename#"></ce:saveas>
	<ce:saveas file="#filename#" action="append">"Title","First Name","Last Name","Company","Business Street","Business Street 2","Business City","Business Postal Code","Business Country","Business Fax","Business Phone","Categories","E-mail Address","E-mail Display Name","E-mail 2 Address","E-mail 2 Display Name","Gender","Web Page","PO Box","Language"
</ce:saveas>
</ce:if>

<%-- Schreiben der Kontakt-Daten in Datei --%>
<ce:if cond="#t_uavx_lang_id#==1">
	<ce:msg key="profile.lang_de" into="t_uavx_lang"/>
</ce:if>
<ce:if cond="#t_uavx_lang_id#==2">
	<ce:msg key="profile.lang_en" into="t_uavx_lang"/>
</ce:if>
<ce:if cond="#t_indc_gender# == 'M'">
	<ce:msg key="profile.gender_m" into="t_gender"/>
</ce:if>
<ce:if cond="#t_indc_gender# == 'F'">
	<ce:msg key="profile.gender_f" into="t_gender"/>
</ce:if>
<ce:saveas file="#filename#" action="append">"#t_user_salutation#","#t_user_firstname#","#t_user_lastname#","#t_user_company# #t_uavx_company2#","#t_user_street#","#t_uavx_street2#","#t_user_city#","#t_uavx_zip#","#t_user_country#","#t_user_fax#","#t_user_phone#","#contact_category#","#t_user_email#","#t_user_email#","#t_uavx_email#","#t_uavx_email#","#t_gender#","#t_user_url#","#t_uavx_pobox1# #t_uavx_pobox2#","#t_uavx_lang#"
</ce:saveas>

<ce:if cond="#mmi_ww_intern#==1">
<table cellspacing="0" cellpadding="0" width="450" border="0"><tr><td>
</ce:if>
<table cellspacing="0" cellpadding="0" width="100%" border="0">
<ce:if cond="#mmi_ww_intern#==1">
	<tr>
		<td>
		<ce:if cond="CE_LANGUAGE=='de'">
			<IMG SRC="http://ecom.messe-muenchen.de/plugin/image/#CE_CURRENT_DB#/mmi_weltweit" alt="MMI Weltweit">
		</ce:if>
		<ce:if cond="CE_LANGUAGE=='en'">
			<IMG SRC="http://ecom.messe-muenchen.de/plugin/image/#CE_CURRENT_DB#/header_en" alt="MMI Worldwide">
		</ce:if>
		</td>
	</tr>
	<tr>
		<td>&nbsp;</td>
	</tr>
</ce:if>
	<tr>
		<td>
			<table cellspacing="2" cellpadding="1" border="0" width="100%"> 
				<tr>
					<td class="ww_text" align="left"><b><ce:msg key="outlook-imp.header"/> - #user_country_av#</b></td>
				</tr>
				<tr>
					<td>&nbsp;</td>
				</tr>
				<tr>
					<td class="ww_text" align="left"><ce:msg key="outlook-imp.text"/></td>
				</tr>
				<tr>
					<td class="ww_text" align="left">
					<ce:if cond="CE_LANGUAGE=='de'">
						<br><img src="http://ecom.messe-muenchen.de/plugin/image/#CE_CURRENT_DB#/arrow_003866.gif" border="0">&nbsp;<a href="#glo_file_path_url#MMI-Kontakt-#t_uavx_iso_id#.csv" class="ww_link-blue"><ce:msg key="outlook-imp.download"/></a> <ce:msg key="maillist.csv-save"/>
					</ce:if>    	
					<ce:if cond="CE_LANGUAGE=='en'">
						<br><img src="http://ecom.messe-muenchen.de/plugin/image/#CE_CURRENT_DB#/arrow_003866.gif" border="0">&nbsp;<a href="#glo_file_path_url#MMI-Contact-#t_uavx_iso_id#.csv" class="ww_link-blue"><ce:msg key="outlook-imp.download"/></a> <ce:msg key="maillist.csv-save"/>
					</ce:if>    	
					</td>
				</tr>
				<tr>
					<td class="ww_text" align="left"><ce:msg key="outlook-imp.helptext"/></td>
				</tr>
			<ce:if cond="#mmi_ww_intern#==1">
				<tr>
					<td>&nbsp;</td>
				</tr>
				<tr>
					<td align="right"><a href="/plugin/template/#CE_CURRENT_DB#/#CE_TOPICFOLDER_ID#/&page=Profile&amp;lastPage=#lastPage#&amp;sel_country=#sel_country#&amp;r_continent=#r_continent#&amp;random=#random#" class="ww_link-blue"><ce:msg key="navigation.back"/></a></td>
				</tr>
			</ce:if>
			</table>
		</td>
	</tr>
</table>
<ce:if cond="#mmi_ww_intern#==1">
</td></tr></table>
</ce:if>

<ce:setnull var="r_user_id, filename, sql, t_uavx_lang, t_gender, contact_category"/>
<ce:setnull var="l_obj_user, t_uavx_user_country_av, user_country_av"/>
<x:call name="ecom_functions.deleteSessionVariables" params="TBL_USER, t_"/>
<x:call name="ecom_functions.deleteSessionVariables" params="TBL_EPT_UAVX_USER_AV_EXT, t_"/>

<%--
////////////////////////////////////////////////
Felder deutsch:
"Anrede"
"Vorname"
"Nachname"
"Firma"
"Stra?e gesch?ftlich"
"Stra?e gesch?ftlich 2"
"Ort gesch?ftlich"
"Postleitzahl gesch?ftlich"
"Land gesch?ftlich"
"Fax gesch?ftlich"
"Telefon gesch?ftlich"
"Kategorien"
"E-Mail-Adresse"
"E-Mail: Angezeigter Name"
"E-Mail 2: Adresse"
"E-Mail 2: Angezeigter Name"
"Geschlecht"
"Webseite"
"Postfach gesch?ftlich"
"Sprache"

////////////////////////////////////////////////
Felder englisch:
"Title"
"First Name"
"Last Name"
"Company"
"Business Street"
"Business Street 2"
"Business City"
"Business Postal Code"
"Business Country"
"Business Fax"
"Business Phone"
"Categories"
"E-mail Address"
"E-mail Display Name"
"E-mail 2 Address"
"E-mail 2 Display Name"
"Gender"
"Web Page"
"PO Box"
"Language"
--%>