Issue 18728

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.
Product: Calc Reporter: radimnov <radimnov>
Component: open-importAssignee: AOO issues mailing list <issues>
Status: CONFIRMED --- QA Contact:
Severity: Trivial    
Priority: P4 CC: bettina.haberer, helenrussian, issues, jimfitz, kpalagin, kyoshida, mmeeks, muthusuba, niklas.nebel, ooo, rail_ooo, www.openoffice.org
Version: OOo 1.1 RC3Keywords: rfe_eval_ok, third_party_support, usability
Target Milestone: ---   
Hardware: PC   
OS: Windows 2000   
Issue Type: ENHANCEMENT Latest Confirmation in: ---
Developer Difficulty: ---
Attachments:
Description Flags
Patch Set 1
none
Patch Set 2
none
Patch Set 3 - having separate load/save for import and export preferences. none

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 12 muthusuba 2010-03-27 12:24:43 UTC 
Created attachment 68569 [details]
Patch Set 1
Comment 13 muthusuba 2010-03-27 12:25:34 UTC 
Created attachment 68570 [details]
Patch Set 2
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.