Issue 22611 - DATASOURCE DATE ROUTINES
Summary: DATASOURCE DATE ROUTINES
Status: CLOSED NOT_AN_OOO_ISSUE
Alias: None
Product: Base
Classification: Application
Component: code (show other issues)
Version: OOo 1.1 RC4
Hardware: PC Windows XP
: P3 Trivial (vote)
Target Milestone: ---
Assignee: marc.neumann
QA Contact: issues@dba
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2003-11-18 18:16 UTC by Unknown
Modified: 2006-05-31 14:29 UTC (History)
1 user (show)

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


Attachments

Note You need to log in before you can comment on or make changes to this issue.
Description Unknown 2003-11-18 18:16:01 UTC
Bugs in version 1.1rc4 for Windows (with Win XP pro):

In a "Datasource" dbf table with 1000 records
with this structure:

DATAESAME,D	(date)
COGNOME,C,30	(char)
NOME,C,30	
DATANASCIT,D	
INDIRIZZO,C,50	
CITTA,C,30	
TELEFONO,C,30	
PRESTAZION,C,50	
PROVENIENZ,C,30	
MEDICO,C,50	
REFERTO,M	(memo)								
										
										
										
										
										
										
										
										
										
										
										
										
										
										
										
										
										
										
										
										
										
										
										
						

If you click the Data to text.. icon --> Insert Database Columns
as Text (*): if you insert text and dates this way,as an example
    <cognome>  <nome>  <datanascit>  <dataesame>
    
in english
    <surname>  <firstname> <birthdate>  <examdate>
    
dates (in Italy format is DD/MM/YYYY or DD-MM-YYYY) are transfered
in the text with a minus two days error for example this patient 
data: 

	ROMANO Rosalba 15-08-1957 02-10-2003

are transfered in the text as:

	ROMANO  Rosalba  13/08/57  30/09/03

(note that the date format is not maintained, although I used the
option 
	Format(DATAESAME) --> (*) From Database
is it another bug?)

This error was produced on the same data both with a .dbf file and
an MySQL/odbc table. The bug is present both in the Windows (I use
WinXP pro) and in RedHat 9.0 Linux.

I found another bug in updating OpenOffice from version 1.0.3 to
1.1rc4 with the Windows version:

All dates in the dbf table (obtained with previos versions of OO) 
are shifted of 2 days (HUGE BUG!). Your date routines need to be
reviewed to be more reliable. This does not appear to happen with
the same version on OpenOffice in Linus (RedHat 9.0)

Check also the date format.
I am trying to use OpenOffice as a small RIS (radiology information
system) for the patients RX reports and for storing records. So far
we have a dbf table with 1000 records.

When you want to print a document that contains data from a database
fields the program asks:

"Your document contains addres database fields. Do you want to print
a form letter [Yes][No][Help]"

This did not happen with version 1.0.3.
I find it very intrusive and it adds extra-step to print a document.
This "feature" should be available elsewhere, not when you have to
quickly print a report, for example.

File-->Autopilot-->Form does not work, it outputs a message saying
"The files required could not be found - please start the OpenOffice.
org Setup and choose Repair"

Repairing the application does not fix it.

best regards
Daniel Liscia

<danyliscia@libero.it>
Comment 1 Frank Schönheit 2003-11-19 07:45:18 UTC
Daniel, thanks for supporting OOo.

One thing: *Please* submit separate issues for separate problems.
There is a number of reasons for this, amonst them the fact that
different problems are to be handled/fixed by different people, which
*requires* different issues in IZ.
So please split this issue here up into separate issues, where each
one describes exactly *one* problem you have. Thanks!
Comment 2 marc.neumann 2003-11-24 08:18:04 UTC
Hi,

separated issue arrieved. I close this "many isssues task".

Bye Marc
Comment 3 marc.neumann 2003-11-24 08:18:16 UTC
close
Comment 4 hans_werner67 2004-02-02 12:21:04 UTC
change subcomponent to 'none'