Apache OpenOffice (AOO) Bugzilla – Full Text Issue Listing
|Summary:||Import DBF files - supress Character set selection dialog at each access. This makes batch/frequent use easier. Perhaps we should store the last used code page.|
|Component:||open-import||Assignee:||AOO issues mailing list <issues>|
|Status:||CONFIRMED ---||QA Contact:|
|Priority:||P4||CC:||bettina.haberer, helenrussian, issues, jimfitz, kpalagin, kyoshida, mmeeks, muthusuba, niklas.nebel, ooo, rail_ooo, www.openoffice.org|
|Version:||OOo 1.1 RC3||Keywords:||rfe_eval_ok, third_party_support, usability|
|Issue Type:||ENHANCEMENT||Latest Confirmation in:||---|
Description radimnov 2003-08-27 13:36:47 UTC
It would be nice to have chance supress Character set selection dialog when importing DBF files. I'm importing some DBF's every day and every time I must to scroll to codepage "Eastern Europe DOS/OS2-852". All DBF's I'm using, are the same codepage. There are at least two solutions: 1) set default Character set in Options 2) provide a "Don't show this dialog again" checkbox. I'dont know, if there is mechanism to unset this checkbox later (when I need to use other than default character set). Thanks
Comment 1 oc 2003-08-28 12:49:20 UTC
Hi Bettina, one4you
Comment 2 bettina.haberer 2004-01-30 16:05:46 UTC
Summary: Import DBF files - supress Character set selection dialog at each access. Perhaps we should store the last used code page. But have to think about. This issue is considered for OO.o later.
Comment 3 erwin.tenhumberg 2004-11-04 15:09:12 UTC
enhanced summary, set keywords and reassigned issue according to RFE process
Comment 4 frank 2005-06-09 16:28:40 UTC
*** Issue 48990 has been marked as a duplicate of this issue. ***
Comment 5 kpalagin 2007-05-17 08:03:45 UTC
I would suggest preselecting last used encoding when displaying the list, so that user could simply click OK, instead of scrolling up and down.
Comment 6 kpalagin 2007-11-20 15:32:18 UTC
Dear Bettina, with our current behavior importing more than a few of .dbf files causes very bad user experience. Please consider this RFE for 3.0. Thanks a lot for your attention. Regards, Kirill Palagin.
Comment 7 pmike 2008-04-22 09:22:58 UTC
Certain DBF files (with markers 0x8B and 0xCB) provides its encoding. Byte at offset 0x1D can have the following values: 0 - unknown 1 - 437 -- MS-DOS, U.S.A. 2 - 850 -- MS-DOS, International 3 - 1252 -- Windows, U.S.A & West European 4 - 10000 -- Macintosh, U.S.A. 100 - 852 MS-DOS, East European 101 - 866 MS-DOS, Russian 102 - 865 MS-DOS, Nordic 103 - 861 MS-DOS, Iceland 104 - 895 MS-DOS, Kamenicky (Czech) 105 - 620 MS-DOS, Mazovia (Polish) 106 - 737 MS-DOS, Greek 107 - 857 MS-DOS, Turkey 108 - 863 MS-DOS, Canada 120 - 950 Windows, Traditional Chinese 121 - 949 Windows, Korean (Hangul) 122 - 936 Windows, Simplified Chinese 123 - 932 Windows, Japanese (Shift-jis) 124 - 874 Windows, Thai 150 - 10007 Macintosh, Russian 151 - 10029 Macintosh, East European 152 - 10006 Macintosh, Greek 200 - 1250 Windows, East European 201 - 1251 Windows, Russian 203 - 1253 Windows, Greek 202 - 1254 Windows, Turkish 125 - 1255 Windows, Hebrew (Only supported on Hebrew OS) 126 - 1256 Windows, Arabic (Only supported on Arabic OS) 204 - 1257 Windows, Baltic I think this can help a lot to "guess" encoding.
Comment 8 bormant 2008-04-22 09:54:43 UTC
> Certain DBF files (with markers 0x8B and 0xCB) provides its encoding. Correct is Certain DBF files (*except* with markers 0x8B and 0xCB) provides its encoding.
Comment 9 kpalagin 2009-05-15 20:43:23 UTC
Kohei,Muthusuba, please consider this issue for the same treatment as issue 3687. Thanks a lot for your attention. WBR, KP.
Comment 10 kpalagin 2010-03-08 09:18:23 UTC
Muthisuba, you have done great with 3687. Please consider developing patch for this issue too. Thanks a lot for your attention. WBR, KP.
Comment 11 muthusuba 2010-03-08 10:41:50 UTC
KP, sure...will try to look at it this weekend sometime. muthusuba
Comment 14 muthusuba 2010-03-27 12:35:11 UTC
I have attached two patch sets. Patch 1: Provides additional encoding types being read from input file. This is done using pmike 's comment. Also, when the user selects IBM_850 encoding, the encoding type is read from the input file. It defaults to IBM_850 encoding if none are matching/usable. Patch 2: For saving/remembering the user's encoding choice. ----- I was looking at creating a helper class to do the saving and loading of the dialog options. This simplest one would be to just provide the functionality of load_ and save_. Are there any other better ideas?
Comment 15 kpalagin 2010-03-28 11:06:08 UTC
Muthusuba, thanks a lot for your effort! It is very much appreciated. Rail, please review the patch and consider for inclusion in OOO Pro. Regards, KP
Comment 16 muthusuba 2010-03-28 12:31:37 UTC
Created attachment 68593 [details] Patch Set 3 - having separate load/save for import and export preferences.
Comment 17 Unknown 2010-10-23 07:01:06 UTC
Created attachment 72370
Comment 18 Jim Fitz 2017-10-31 10:06:11 UTC
This would be very useful for me too - I am continually opening .dbf files with the same character set (OS2-850) but it always throws up the dialog box. To make this more awkward, if there is already a few Calc instances running, this dialog box appears in the background for the last instance opened so you have to find that first before you can accept it.