download files with scandic letters

[Deepan Ignatius]

Hi,

My java program is writing contents to a excel file and naming it with scandic characters(äÄöÖåÅ). When the file is exported to a Windows machine I am able to view and download the same from my jsp. But when the file is exported to a Linux machine I am unable to view and download the same file. Is it something related with the encoding? Could you guys help me to resolve it?

Eg:- of a file name - "Kyä_1998_SB15.xls"

Thanks!

[Jesper de Jong]

Yes, that's most likely a problem that has to do with character encodings. Can you please be more specific about what the problem is (describe it in more detail)? It might not even have anything to do with your program or with Java, but with the way you transfer those files from Windows to Linux or vice versa.

[Deepan Ignatius]

code part(servlet):

			pstmt=con.prepareStatement(strSelectDealerQry);
			pstmt.setString(1,strBatchNumber);
			rs1 = pstmt.executeQuery();
			while(rs1.next())
			{
				
				String strDealerName = "";
				strDealerBusinessCode = rs1.getString(1);
				strDealerName = rs1.getString(2);
				logger.info("Inside Subvention Dealer Report: Dealer name: "+strDealerName+strDealerBusinessCode);
				

				JasperReport jasperReport;
				JasperReport jasperReport1;
				JasperReport jasperReport2;//New


				JasperPrint jasperPrint;
				JasperPrint jasperPrint1;
				JasperPrint jasperPrint2;//New
				
				HashMap jasperParameter = new HashMap();
				
				jasperParameter.put("batch_number",strBatchNumber);
				jasperParameter.put("dealer_business_code",strDealerBusinessCode);
				jasperParameter.put("dealer_name", strDealerName);
				
				jasperParameter.put("l_shop_name",strlblShopName );
				jasperParameter.put("l_shop_id", strlblShopId);
				jasperParameter.put("l_seller", strlblSeller);
				jasperParameter.put("l_seller_id", strlblSellerId);
				jasperParameter.put("l_subscription_owner", strlblOwner);
				jasperParameter.put("l_subscription_number",strlblSubscriptionNumber );
				jasperParameter.put("l_handset_model", strlblHandsetModel);
				jasperParameter.put("l_imei", strlblIMEI);
				jasperParameter.put("l_sale_date",strlblSaleDate);
				jasperParameter.put("l_subvention", strlblSubventionEuro);
				jasperParameter.put("l_remarks", strlblRemarks);//UAT defect 347
				jasperParameter.put("REPORT_LOCALE", new Locale("fi","FI"));//added based on comments (27.08.2009)
				
				
				
				String strSelectShopQry="select distinct shop_id, shop_name " +
				"from icoms_report_subvention where batch_number = ? and dealer_business_code= ? order by shop_id" ;
				pstmt=con.prepareStatement(strSelectShopQry);
				pstmt.setString(1,strBatchNumber);
				pstmt.setString(2,strDealerBusinessCode);
				rs = pstmt.executeQuery();
				

				jasperReport = JasperCompileManager.compileReport(strTemplate_Subvention_Excel);
				jasperReport1 = JasperCompileManager.compileReport(strTemplate_Subvention_Excel1);
				jasperReport2 = JasperCompileManager.compileReport(strTemplate_Subvention_Excel2);//New for Webshop
				

				jasperPrint = JasperFillManager.fillReport(jasperReport,jasperParameter, con);
				String strShopId="";
				String strShopName="";
				int intName=1;
				String strAllShops="";
				String strSheetName="";
				while(rs.next())
				{
					strShopId = rs.getString(1);
					strShopName = rs.getString(2);
					if(logger.isDebugEnabled()) logger.debug("Shop Id"+strShopId);
					jasperParameter.put("shop_id", strShopId);
					
					if (strShopId != null)
					{
					jasperPrint1 = JasperFillManager.fillReport(jasperReport1,jasperParameter, con);
					List<JRPrintPage> pages = new ArrayList<JRPrintPage>(jasperPrint1.getPages());
					
					for(int count=0;count<pages.size();count++)
					{
					jasperPrint.addPage(  (JRPrintPage)pages.get(count));
					
					}
					
					}
					else
					{
						strShopId = "";
						strShopName = strlblWebSheetName;
						
						jasperPrint2 = JasperFillManager.fillReport(jasperReport2,jasperParameter, con);
						List><JRPrintPage> pages = new ArrayList<JRPrintPage>(jasperPrint2.getPages());
						
						for(int count=0;count<pages.size();count++)
						{
						jasperPrint.addPage((JRPrintPage)pages.get(count));
						}
					}

					strSheetName = strShopId+" "+strShopName.replace(",", " ");
					
					if (strSheetName.length()>31)
					{
					strAllShops= strAllShops+strSheetName.substring(0,31)+",";
					}
					else
					{
						strAllShops= strAllShops+strSheetName+",";
					}
					strAllShops = strAllShops.replace("/", " ");
					strAllShops = strAllShops.replace("\\", " ");
					strAllShops = strAllShops.replace("*", " ");
					strAllShops = strAllShops.replace("?", " ");
					strAllShops = strAllShops.replace("[", " ");
					strAllShops = strAllShops.replace("]", " ");
					intName++;
				
				}
				
				
				String[] strSheetNames;
				strSheetNames = new String[intName+1];
				String[] strSheetNames1 = null;
				
				if(logger.isDebugEnabled()) logger.debug("All Shops"+strAllShops);
				if(strlblAll==null)
					strlblAll="Yhteensä";
				strSheetNames[0] = strlblAll;
				strSheetNames1 = strAllShops.split(",");
				for(int j=0; j<(strSheetNames1.length);j++)
				{
					if(logger.isDebugEnabled()) logger.debug("Inside ShopIds loop");
					strSheetNames[j+1]= strSheetNames1[j];
					
				}
				
				String strOutputFileName = strOutputFile_Subvention_Excel+strDealerName+"_"+strDealerBusinessCode+"_"+strBatchNumber+".xls";
				
				JRXlsExporter exporter = new JRXlsExporter();
				exporter.setParameter(JRXlsExporterParameter.IS_ONE_PAGE_PER_SHEET,Boolean.TRUE);
				exporter.setParameter(JRExporterParameter.JASPER_PRINT, jasperPrint);
				exporter.setParameter(JRExporterParameter.OUTPUT_FILE_NAME,strOutputFileName );
				
				exporter.setParameter(JRXlsExporterParameter.IS_REMOVE_EMPTY_SPACE_BETWEEN_ROWS,Boolean.TRUE);
				exporter.setParameter(JRXlsExporterParameter.SHEET_NAMES,strSheetNames );
				exporter.setParameter(JRXlsExporterParameter.IS_WHITE_PAGE_BACKGROUND, false);
				exporter.setParameter(JRXlsExporterParameter.IGNORE_PAGE_MARGINS,Boolean.TRUE);
				exporter.setParameter(JRXlsExporterParameter.IS_COLLAPSE_ROW_SPAN,Boolean.TRUE);
				exporter.setParameter(JRXlsExporterParameter.IS_DETECT_CELL_TYPE, Boolean.TRUE);
				exporter.exportReport();

--- creates an excel file and saves it in a Linux system.

File generated in Linux system is Anteron Oye2ää_1992570-8_CO3112201401.xls[but the original name generated in servlet is "Anteron Oye2ää_1992570-8_CO3112201401.xls"]

After this, I display the files generated in the Linux in my jsp[by listing the files present in the directory in the linux system] where it is listed properly like below

Anteron Oye2ää_1992570-8_CO3112201401.xls

and upon clicking the above link to download the file it is resulting an error. I tried to copy the shortcut for the above file(listed in my jsp) , the value present is

http://tsl8an01:4443/IcomsApp/DownloadFiles.jsp?FilePath=/u02/appdata/reports/ST/icoms/CommissionReport/Excel/&FileName=Anteron+Oye2%C3%A4%C3%A4_1992570-8_CO3112201401.xls

PS: when the name of the file doesn't have scandic characters I am able to download it from the same jsp.

[Rob Spoor]

Deepan, please UseCodeTags next time. I've added them for you this time.

[Jesper de Jong]

Please UseCodeTags when you post souce code - I added them to your post above.

Deepan Ignatius wrote:File generated in Linux system is Anteron Oye2ää_1992570-8_CO3112201401.xls[but the original name generated in servlet is "Anteron Oye2ää_1992570-8_CO3112201401.xls"]

Where and how do you see this? Are you logged in to the Linux box, and when you do "ls" in a terminal window, do you then see "Anteron Oye2ää..." or "Anteron Oye2ää..."?

[Deepan Ignatius]

yes. I am looging into the Linux box and seeing it as "Anteron Oye2ää..."

and it is working perfectly even with a unix box. The probelm is only when the reports are generated in the Linux machine.

[Rob Spoor]

Most consoles, including bash, tcsh and even Windows' command prompt, cannot handle much (if anything) that's not ASCII.

[Wouter Oet]

Rob Prime wrote:Deepan, please UseCodeTags next time. I've added them for you this time.

Jesper Young wrote:Please UseCodeTags when you post souce code - I added them to your post above.

Who is telling the truth ?

[Rob Spoor]

Both. We probably both pressed Edit for the original post, without code tags. I added them, updated (message was edited 1 time). Then a minute later Jesper, who was editing the original message, updated it (message was edited 2 times). Jesper's update essentially overwrote mine.