DwZone Forum DwZone Forum
Welcome to the DwZone-it Forum
 
  FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups  
    RegisterRegister -->   LoginLogin  
Import/Export Tools  
DwZone Forum Index -> Import/Export Tools
.
Moderators: Administrators, Moderators 		 Mark all topics read
Hint: For improved responsiveness, use Internet Explorer 4 (or above) with Javascript enabled, choose 'Dynamic' from the View dropdown and hit 'Set Options' to save your changes.
New Topic Search for
 View     Per page     Messages Since 
Messages 1 to 10 of 88 (Total: 87) First |  Prev |  Next |  Last  
 Subject Author Date  
   CSV import from external site  
View this persons public profile  Adrian Smith   8:25 11 Sep 2019  
   Excel import error on new host  
View this persons public profile  Sharon   8:21 5 Nov 2018  
   Re: Excel import error on new host  
View this persons public profile  Gianluigi   10:24 5 Nov 2018  
   Re: Excel import error on new host  
View this persons public profile  sharon   11:50 5 Nov 2018  
   empty date fields  
View this persons public profile  Chris   2:53 20 Sep 2018  
    special Charakters Ä Ö Ü  
View this persons public profile  heise   2:17 3 Nov 2017  
 
Hi, i have read the Topic from 2014,but i have the same Problem and cant fix them.

The Website is small, almost the Grid and a EXCEl-Export. But in Excel.xls there is no Special Charakters.

Here is my Website code of my Intranet Website:

FIRST:
<%@LANGUAGE="VBSCRIPT" CODEPAGE="65001"%>
<!--#include file="../dwzGrid/AspAjaxDataGrid.asp" -->
<% Session.LCID = 1031 %>
AND AS META:
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />

but it wont work right with Special character EXPORT. ON the Website (on the Screen showing) there is everything right!!!







<%@LANGUAGE="VBSCRIPT" CODEPAGE="65001"%>
<!--#include file="../dwzGrid/AspAjaxDataGrid.asp" -->
<% Session.LCID = 1031 %>
<%
Response.Expires = 0
Response.AddHeader "Pragma","no-cache"
Response.AddHeader "cache-control","no-store"
Response.ExpiresAbsolute = CDate("01.01.2000")
Response.Expires = #01/01/2000#
%>





<%
' Connection-String
Dim MM_DB_AKi203_STRING
MM_DB_AKi203_STRING = "Provider=SQLNCLI;Server=VM1-h1\HY;Database=AKi203;Trusted_Connection=yes;"
' Connection-String
Dim MM_conDBAKi203_STRING
MM_conDBAKi203_STRING = "Provider=SQLNCLI;Server=VM1-h1\HY;Database=AKi203;Trusted_Connection=yes;"
%>
<%
'******************************
'http://www.DwZone-it.com
'AspAjax DataGrid
'Version 1.4.20
'******************************
Dim dwzGrid_1
Set dwzGrid_1 = new dwzAspAjaxDataGrid
dwzGrid_1.Init()
dwzGrid_1.SetInstance "1"
dwzGrid_1.SetRootPath "../"
dwzGrid_1.SetCnString MM_DB_AKi203_STRING
dwzGrid_1.SetEditPar "void|_@_|void|_@_|dbo.T_LOGWEB_USR|_@_|IDNR|_@_|ALL|_@_|false"
dwzGrid_1.Add "UserName", "Benutzername", "100", "String", "Center", "Y", "Y", "N|_@_|Y|_@_|50|_@_|3|_@_|TextBox|_@_||_@_||_@_||_@_||_@_||_@_||_@_|Void|_@_||_@_|true|_@_||_@_||_@_||_@_||_@_||_@_||_@_|20|_@_|12|_@_||_@_||_@_|None|_@_|rec_placeholder|_@_|Y|_@_|None|_@_|None|_@_|"
dwzGrid_1.Add "BNName", "Name", "100", "String", "Left", "Y", "Y", "Y|_@_|Y|_@_|50|_@_||_@_|TextBox|_@_||_@_||_@_||_@_||_@_||_@_|Bitte geben Sie den Namen ein.|_@_|Void|_@_||_@_|false|_@_||_@_||_@_||_@_||_@_||_@_||_@_||_@_|70|_@_||_@_||_@_|None|_@_|rec_placeholder|_@_|Y|_@_|None|_@_|None|_@_|"
dwzGrid_1.Add "Vorname", "Vorname", "100", "String", "Left", "Y", "Y", "Y|_@_|Y|_@_|25|_@_||_@_|TextBox|_@_||_@_||_@_||_@_||_@_||_@_|Bitte geben Sie einen Vornamen ein.|_@_|Void|_@_||_@_|false|_@_||_@_||_@_||_@_||_@_||_@_||_@_||_@_|70|_@_||_@_||_@_|None|_@_|rec_placeholder|_@_|Y|_@_|None|_@_|None|_@_|"
dwzGrid_1.Add "KontaktEMail", "EMAIL", "200", "String", "Left", "Y", "Y", "Y|_@_|Y|_@_|70|_@_||_@_|TextBox|_@_||_@_||_@_||_@_||_@_||_@_|Bitte geben Sie eine Email-Adresse ein.|_@_|Void|_@_||_@_|false|_@_||_@_||_@_||_@_||_@_||_@_||_@_||_@_|100|_@_||_@_||_@_|None|_@_|rec_placeholder|_@_|Y|_@_|None|_@_|None|_@_|"
dwzGrid_1.Add "AKTIV_1_0", "Aktiv", "70", "Boolean (1/0)", "Left", "Y", "Y", "Y|_@_|Y|_@_||_@_||_@_|TextBox|_@_|Integer|_@_|^[0-9]*$|_@_||_@_||_@_||_@_||_@_|Void|_@_||_@_|false|_@_||_@_||_@_||_@_||_@_||_@_||_@_||_@_||_@_||_@_||_@_|None|_@_|rec_placeholder|_@_|Y|_@_|None|_@_|None|_@_|"
dwzGrid_1.Add "UserPassword1", "Passwort", "80", "String", "Left", "N", "N", "Y|_@_|Y|_@_|70|_@_||_@_|TextBox|_@_||_@_||_@_||_@_||_@_||_@_|Bitte geben Sie ein Passwort ein bis zu 19stellig.|_@_|Void|_@_||_@_|false|_@_||_@_||_@_||_@_||_@_||_@_||_@_||_@_|50|_@_||_@_||_@_|None|_@_|rec_placeholder|_@_|Y|_@_|None|_@_|None|_@_|"
dwzGrid_1.Add "MV", "Rolle", "120", "String", "Center", "Y", "Y", "Y|_@_|Y|_@_|50|_@_||_@_|TextBox|_@_||_@_||_@_||_@_||_@_||_@_|Bitte geben Sie V für Vertrieb und für Marktfolge ein.|_@_|Void|_@_||_@_|false|_@_||_@_||_@_||_@_||_@_||_@_||_@_||_@_|10|_@_||_@_||_@_|None|_@_|rec_placeholder|_@_|Y|_@_|None|_@_|None|_@_|"
dwzGrid_1.Add "PWCHG", "Initial-PW", "150", "String", "Center", "Y", "Y", "Y|_@_|Y|_@_|50|_@_||_@_|TextBox|_@_||_@_||_@_||_@_||_@_||_@_|Nur Ja oder Nein.|_@_|Void|_@_||_@_|false|_@_||_@_||_@_||_@_||_@_||_@_||_@_||_@_|10|_@_||_@_||_@_|None|_@_|rec_placeholder|_@_|Y|_@_|None|_@_|None|_@_|"
dwzGrid_1.Add "UserKdNr", "Kostenstelle", "150", "String", "Center", "Y", "Y", "Y|_@_|Y|_@_|50|_@_||_@_|TextBox|_@_||_@_||_@_||_@_||_@_||_@_|Nur Ja oder Nein.|_@_|Void|_@_||_@_|false|_@_||_@_||_@_||_@_||_@_||_@_||_@_||_@_|10|_@_||_@_||_@_|None|_@_|rec_placeholder|_@_|Y|_@_|None|_@_|None|_@_|"
dwzGrid_1.AddDetailPar ""
dwzGrid_1.AddDetailFields ""
dwzGrid_1.SaveDelete()
%>
<%
'******************************
' http://www.DwZone-it.com
' AspAjax DataGrid
'******************************
dwzGridSkin = "cupertino"
'******************************
' http://www.DwZone-it.com
' AspAjax DataGrid
'******************************
%>
<%
Dim rsUSR1__MMColParam
rsUSR1__MMColParam = "sph"
If (Request("MM_EmptyValue") <> "") Then
rsUSR1__MMColParam = Request("MM_EmptyValue")
End If
%>
<%
Dim rsUSR1
Dim rsUSR1_cmd
Dim rsUSR1_numRows

Set rsUSR1_cmd = Server.CreateObject ("ADODB.Command")
rsUSR1_cmd.ActiveConnection = MM_DB_AKi203_STRING
rsUSR1_cmd.CommandText = "SELECT * FROM dbo.T_LOGWEB WHERE Firma = ? ORDER BY UserName ASC"
rsUSR1_cmd.Prepared = true
rsUSR1_cmd.Parameters.Append rsUSR1_cmd.CreateParameter("param1", 200, 1, 15, rsUSR1__MMColParam) ' adVarChar

Set rsUSR1 = rsUSR1_cmd.Execute
rsUSR1_numRows = 0
%>
<%
'******************************
' http://www.DwZone-it.com
' AspAjax DataGrid
' Version 1.4.20
'******************************
dwzGrid_1.AddEditRecordset "UserName", Null
dwzGrid_1.AddEditRecordset "BNName", Null
dwzGrid_1.AddEditRecordset "Vorname", Null
dwzGrid_1.AddEditRecordset "KontaktEMail", Null
dwzGrid_1.AddEditRecordset "AKTIV_1_0", Null
dwzGrid_1.AddEditRecordset "UserPassword1", Null
dwzGrid_1.AddEditRecordset "MV", Null
dwzGrid_1.AddEditRecordset "PWCHG", Null
dwzGrid_1.AddEditRecordset "UserKdNr", Null
dwzGrid_1.SetRecordset rsUSR1
dwzGrid_1.SetDetailRecordset Null
dwzGrid_1.SetMainPar "740|_@_|440|_@_|void|_@_|true|_@_|true|_@_|true|_@_|true|_@_|true|_@_|true|_@_|true|_@_|false|_@_|true|_@_|false|_@_|true|_@_|false|_@_|true|_@_|true|_@_|true|_@_|15|_@_|10,15,20,25,40|_@_||_@_|Form|_@_|de|_@_|utf-8;65001;Unicode (UTF-8)|_@_|%|_@_|#|_@_|Datensatz anpassen|_@_|false|_@_|erforderllich|_@_|Maximal {1}|_@_|Text Format|_@_|Datumsformat|_@_|Kleinster Wert {1}|_@_|Groesster Wert {1}|_@_|Nicht der erste DS|_@_|false|_@_||_@_|true|_@_|true|_@_|false|_@_|false|_@_|false|_@_|,|_@_|No|_@_|false|_@_|root|_@_|row|_@_|Nodes|_@_|false|_@_|Arial;12;#000000;false;false;false;#FFFFFF|_@_|Arial;12;#000000;false;false;false;#FFFFFF;0;#000000;0,3|_@_|A4;L;25;25;25;25;false;Center;1|_@_|No|_@_||_@_||_@_||_@_|#66B7FF|_@_|0.6|_@_|10|_@_|350|_@_|_s|_@_|false|_@_|None|_@_|<b>{0} - {1} Item(s)</b>|_@_|false|_@_|false|_@_|false|_@_|false|_@_|false|_@_|ASC|_@_|false|_@_|true|_@_|320|_@_|180|_@_|1024|_@_|768|_@_|false|_@_|false|_@_|false|_@_|0|_@_|false|_@_|false|_@_||_@_|680|_@_|320|_@_|false"
dwzGrid_1.CreateData()
%>




<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Benutzer</title>
<script type="text/javascript" src="p7adaptations/p7EHCscripts.js"></script>
<script type="text/javascript" src="p7tmm/p7TMMscripts.js"></script>
<link href="p7tmm/p7TMM15.css" rel="stylesheet" type="text/css" media="all" />
<link href="p7adaptations/p7adapt-05-tmm.css" rel="stylesheet" type="text/css" />
<link href="p7adaptations/p7adapt-05-response.css" rel="stylesheet" type="text/css" />
<link href="https://fonts.googleapis.com/css?family=Federo" rel="stylesheet" type="text/css" />
<!--[if lt IE 9]>
<style>body {min-width: 760px;}#columns {zoom: 1;}</style>
<![endif]-->
<!--[if lt IE 8]>
<style>.three-column-column2 {width: 30%;}body {overflow-y: visible;}</style>
<![endif]-->
<!--[if lte IE 6]>
<style>#masthead, #columns, #footer {width: 980px;}</style>
<![endif]-->
<link rel="stylesheet" type="text/css" href="../Styles/dmxUniform/default/uniform.default.css" />
<script type="text/javascript" src="../ScriptLibrary/jquery-latest.packV72.js"></script>
<script type="text/javascript" src="../ScriptLibrary/dmxUniform.js"></script>


<%
'******************************
' http://www.DwZone-it.com
' AspAjax DataGrid
'******************************
dwzGrid_1.GetHeadCode()
'******************************
' AspAjax DataGrid
'******************************
%>
</head>

<body>
<div id="masthead">
<h3>Test</h3>
<p class="subhead"></p>
</div>
<div id="columns">
<div class="navigation">
<div class="content p7ehc-1">
<div id="p7TMM_1" class="p7TMM15">
<ul class="p7TMM">
<li><a href="010adsph.asp" target="_self">Logout</a></li>

</ul>
<!--[if lte IE 6]>
<style>.p7TMM15 .p7TMM, .p7TMM15 a, .p7TMM15 li {height:1%;}</style>
<![endif]-->
<!--[if IE 5]>
<style>.p7TMM15 a, .p7TMM15 a {overflow: visible !important;}</style>
<![endif]-->
<script type="text/javascript">
<!--
P7_TMMop('p7TMM_1',1,0,0,3,1,1,0,1,-1,150);
//-->
</script>
</div>
</div>

</div>
<div class="main-content">
<div class="content p7ehc-1">
<h2 class="header"><br />
</h2>
<div class="inner-columns-wrapper">

<div class="three-column-content p7ehc-a">
<h3 class="header">Userverwaltung</h3>




<%
'******************************
' http://www.DwZone-it.com
' AspAjax DataGrid
'******************************
dwzGrid_1.CreateGrid()
'******************************
' http://www.DwZone-it.com
' AspAjax DataGrid
'******************************
%>





</div>
<div class="three-column-column3"></div>
</div>
</div>
</div>
<span class="clearfix"> </span>
</div>
<div id="footer"><%IF sprache ="EN" THEN %>©2017 CIB - computer associated property valuation<% ELSE %>©2017 CIB - Computerunterstützte Immobilienbewertung<% END IF %></div>
</body>
</html>
<%
rsUSR1.Close()
Set rsUSR1 = Nothing
%>
<%
'******************************
' http://www.DwZone-it.com
' AspAjax DataGrid
'******************************
Set dwzGrid_1 = nothing
%>
 
Reply to this current thread  View this persons public profile  Send Private Message
   Re: special Charakters Ä Ö Ü  
View this persons public profile  heise   7:57 3 Nov 2017  
   Re: special Charakters Ä Ö Ü  
View this persons public profile  Gianluigi   11:03 3 Nov 2017  
   Re: special Charakters Ä Ö Ü  
View this persons public profile  Gianluigi   11:04 3 Nov 2017  
   Re: special Charakters Ä Ö Ü  
View this persons public profile  Gianluigi   11:05 3 Nov 2017  
Last Visit: Friday 19 Apr, 2024 8:54 am First |  Prev |  Next |  Last  
 Login
Username:  Password:    
Read Message Read Message   Unread message Unread message
Read message [popular] Read message [popular]   Unread message [popular] Unread message [popular]
Read message [locked] Read message [locked]   Unread message [locked] Unread message [locked]
All times are GMT-2

Jump to: