Issue 8858 - DBF files with a weird names?
Summary: DBF files with a weird names?
Status: CLOSED FIXED
Alias: None
Product: General
Classification: Code
Component: code (show other issues)
Version: 643
Hardware: PC Linux, all
: P3 Trivial (vote)
Target Milestone: OOo 1.0.3
Assignee: ocke.janssen
QA Contact: issues@dba
URL:
Keywords: oooqa
Depends on:
Blocks:
 
Reported: 2002-10-30 22:37 UTC by pavel
Modified: 2003-01-13 10:03 UTC (History)
2 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description pavel 2002-10-30 22:37:12 UTC 
Hi,

I can not open DBF file which is named v.2001.1.dbf. After rename to q.dbf it is
opened without any problems.

Is OOo sensitive do names? Reproducible with 1.0.1 and also with 643 as of today.
Comment 1 pavel 2002-10-30 22:40:04 UTC 
I have only czech builds here so I can not show you the exact message.
But it should be something like

Impossible to connect to the file.

This message is somewhere in sc project (GSI:
sc\source\ui\src\scerrors.src).
Comment 2 prgmgr 2002-10-31 00:51:26 UTC 
Pavel, thank you for using and supporting OOo.

Duplicated on Win NT 4.0 SP6a, OOo 643.

A DBF file that has more than one period in the file name cannot be 
opened by OOo.

The error message is:

Error loading document file:///<path>/<filename>:
Read Error
Impossible to connect to the file.
Comment 3 prgmgr 2002-10-31 00:52:19 UTC 
Assigning to DB team for now.  Not sure if this is where it should go.
Comment 4 Frank Schönheit 2002-10-31 09:55:40 UTC 
Pavel,

Am I right in assuming that you try to open the file in Calc? Or do
you connect to it as a datasource (Tools/Data Sources).
Comment 5 pavel 2002-10-31 10:49:12 UTC 
Yes, I tried to open it via Ctrl+O in Calc. The same bug can be seen
if you enter that name on the command line.

On the other hand - when that file is in a directory that is marked as
the directory of sdbc:dbase: of new data source, that table can not be
seen in that Data Source. After renaming it to v200011.dbf, I can see
it there too. So the problem with the name of DBF file is present here
too.

After renaming the file v.2001.1.dbf to v20011.dbf I can even open it
in Calc and it can also be opened from the command line. Everything is
OK :-) But it is not feasible to rename files to work with them...

So I think that the problem is not in DBF parsing, but in the file
identification or process.
Comment 6 Frank Schönheit 2002-10-31 11:13:34 UTC 
Pavel, thanks for the feedback.
I suppose this restriction is because of the non-SQL-conformance of a
table name like "a.b.c". In databases, the "." is used as separator
between table names and schema names, means something like "a.b" would
refer to "table b within schema a".

Ocke, since 643 we have the possibility to switch off SQL naming
convention conformance. Do you see a chance to extend this to a point
where we allow for dotted dBase file names?
Alternatively, we may need to introduce a special flag when opening a
dBase connection from within Calc. It does not seem to make sense to
tell the users they can't open a file in Calc because it has a not
SQL-conformant name - database issues is the last they would expect
when opening a file in Calc.
Comment 7 ocke.janssen 2002-11-01 11:38:59 UTC 
I fixed it yet.

Best regards,

Ocke
Comment 8 pavel 2002-11-01 12:08:02 UTC 
Did you fixed it in OO643C? If not, can you please fix there too?
Comment 9 ocke.janssen 2002-11-15 12:09:51 UTC 
Hi,

the fix will be in the version. If you want to build by your own, you
will need the file
dba/connectivity/source/drivers/file/FDatabaseMetaData.cxx 
Make a diff between the versions 1.25 and 1.26. That should work too.

Best regards,
Ocke
Comment 10 ocke.janssen 2002-12-13 10:00:22 UTC 
close