RE: [mdb-dev] Problems with mdbtools handling large numbers

[Jeff S. <why...@ya...>]

I could not reproduce this problem.  Does compacting this in Access correct this problem?
 If not, then my suggestion is to delete all other tables, compact the database, and send
the file to me (not the list) to analyze.  If this is not possible, you may have to turn
debugging options on and narrow it down yourself.

 -- Jeff Smith


--- "Seuffert, Peter J." <pet...@ng...> wrote:

> Thank you for your swift reply Jeff.  Unfortunately, I have found another problem that
> may or may not be related.
> 
> I've attached two files that demonstrate what I'm seeing, but in essence, if the table
> consists of only numbers, there appear to be data loss issues.  The db I'm using is a
> large relational db, and most of the tables start with a three column key consisting of
> 2 strings and an integer value.  Using the mdb-export utility, I have verified that
> these tables are being read in without problem.  There is at least one table, however,
> that consists of numerous rows containing four columns, and using the mdb-export tool,
> I can see that I'm losing data in the export functionality.  More specifically, the
> rows that end in zero seem to be exported fine, while all those that don't come across
> as just commas.  For example, using Access to export the data into csv files, one
> excerpt shows:
> 
> 2,39,340.00,0.00
> 2,40,350.00,0.00
> 3,1,0.00,3.00
> 3,2,45.00,2.00
> 3,3,90.00,0.00
> 
> while the mdb-export utility leaves the same area looking like:
> 
> 2,39,340,0
> 2,40,350,0
> ,,,
> ,,,
> 3,3,90,0
> 
> The .csv file attached is from mdb-export, while the .txt is from Access.  Any help
> would be greatly appreciated.
> 
> Thanks,
> Pete
> 
> Peter Seuffert II
> Northrop Grumman Corporation
> 
> 
> -----Original Message-----
> From: Jeff Smith [mailto:why...@ya...]
> Sent: Saturday, March 19, 2005 9:56 AM
> To: Seuffert, Peter J.; mdb...@li...
> Subject: Re: [mdb-dev] Problems with mdbtools handling large numbers
> 
> 
> --- "Seuffert, Peter J." <pet...@ng...> wrote:
> > I'm trying to use mdbtools to read an access97 db on a Fedora Core 2 linux box.  Its
> > working fantastically, except for one issue with large numbers.  In Access, I can see
> > the numbers in one column increase up past 100,000, but in a while mdb_fetch_row()
> > loop, the last valid value my program receives is 100,000.  The next number in the db
> > should be 125,000 but the value being returned by mdbtools is truncated to 125.  The
> > mdb-export utility is verifying that my program isn't doing anything quirky with the
> > return.
> 
> Peter,
>   I have isolated the problem and it is now fixed in cvs.  Trailing zeros after a
> decimal
> point were supposed to be trimmed, but the trailing-zero trimming was also occurring on
> numbers without a decimal point.  100000 worked only because of a quirk that caused it
> to
> have an intermediate value of "100000.0".  I have corrected this as well, though I
> doubt
> many people will notice as its effects are more subtle.
> 
>   Thank you for your report.
> 
>  -- Jeff Smith
> 
> 
> 		
> __________________________________ 
> Do you Yahoo!? 
> Yahoo! Small Business - Try our new resources site!
> http://smallbusiness.yahoo.com/resources/ 
> > 0,1,0.00,0.00
> 0,2,90.00,0.00
> 0,3,180.00,0.00
> 0,4,270.00,0.00
> 1,1,0.00,0.00
> 1,2,45.00,0.00
> 1,3,90.00,0.00
> 1,4,135.00,0.00
> 1,5,180.00,0.00
> 1,6,225.00,0.00
> 1,7,270.00,0.00
> 1,8,315.00,0.00
> 2,1,0.00,0.00
> 2,2,10.00,0.00
> 2,3,20.00,0.00
> 2,4,30.00,0.00
> 2,5,40.00,0.00
> 2,6,45.00,0.00
> 2,7,50.00,0.00
> 2,8,60.00,0.00
> 2,9,70.00,0.00
> 2,10,80.00,0.00
> 2,11,90.00,0.00
> 2,12,100.00,0.00
> 2,13,110.00,0.00
> 2,14,120.00,0.00
> 2,15,130.00,0.00
> 2,16,135.00,0.00
> 2,17,140.00,0.00
> 2,18,150.00,0.00
> 2,19,160.00,0.00
> 2,20,170.00,0.00
> 2,21,180.00,0.00
> 2,22,190.00,0.00
> 2,23,200.00,0.00
> 2,24,210.00,0.00
> 2,25,220.00,0.00
> 2,26,225.00,0.00
> 2,27,230.00,0.00
> 2,28,240.00,0.00
> 2,29,250.00,0.00
> 2,30,260.00,0.00
> 2,31,270.00,0.00
> 2,32,280.00,0.00
> 2,33,290.00,0.00
> 2,34,300.00,0.00
> 2,35,310.00,0.00
> 2,36,315.00,0.00
> 2,37,320.00,0.00
> 2,38,330.00,0.00
> 2,39,340.00,0.00
> 2,40,350.00,0.00
> 3,1,0.00,3.00
> 3,2,45.00,2.00
> 3,3,90.00,0.00
> 3,4,135.00,0.00
> 3,5,180.00,2.00
> 3,6,225.00,0.00
> 3,7,270.00,0.00
> 3,8,315.00,2.00
> 4,1,0.00,2.00
> 4,2,45.00,1.00
> 4,3,90.00,0.00
> 4,4,135.00,0.00
> 4,5,180.00,2.00
> 4,6,225.00,0.00
> 4,7,270.00,0.00
> 4,8,315.00,1.00
> 5,1,0.00,3.00
> 5,2,45.00,2.00
> 5,3,90.00,0.00
> 5,4,135.00,1.00
> 5,5,180.00,3.00
> 5,6,225.00,1.00
> 5,7,270.00,0.00
> 5,8,315.00,2.00
> 6,1,0.00,3.00
> 6,2,45.00,1.00
> 6,3,90.00,0.00
> 6,4,135.00,1.00
> 6,5,180.00,3.00
> 6,6,225.00,1.00
> 6,7,270.00,0.00
> 6,8,315.00,1.00
> 7,1,0.00,6.00
> 7,2,45.00,2.00
> 7,3,90.00,0.00
> 7,4,135.00,2.00
> 7,5,180.00,6.00
> 7,6,225.00,2.00
> 7,7,270.00,0.00
> 7,8,315.00,2.00
> 8,1,0.00,0.00
> 8,2,45.00,2.00
> 8,3,90.00,6.00
> 8,4,135.00,2.00
> 8,5,180.00,0.00
> 8,6,225.00,2.00
> 8,7,270.00,6.00
> 8,8,315.00,2.00
> 9,1,0.00,6.00
> 9,2,45.00,4.00
> 9,3,90.00,3.00
> 9,4,135.00,4.00
> 9,5,180.00,6.00
> 9,6,225.00,0.00
> 9,7,270.00,0.00
> 9,8,315.00,0.00
> 10,1,0.00,6.00
> 10,2,45.00,0.00
> 10,3,90.00,0.00
> 10,4,135.00,0.00
> 10,5,180.00,6.00
> 10,6,225.00,4.00
> 10,7,270.00,3.00
> 10,8,315.00,4.00
> 11,1,0.00,15.00
> 11,2,45.00,10.00
> 11,3,90.00,0.00
> 11,4,135.00,3.00
> 11,5,180.00,6.00
> 11,6,225.00,3.00
> 11,7,270.00,0.00
> 11,8,315.00,10.00
> 12,1,0.00,6.00
> 12,2,45.00,4.00
> 12,3,90.00,3.00
> 12,4,135.00,4.00
> 12,5,180.00,3.00
> 12,6,225.00,0.00
> 12,7,270.00,0.00
> 12,8,315.00,0.00
> 13,1,0.00,2.00
> 13,2,90.00,0.00
> 13,3,180.00,6.00
> 13,4,270.00,0.00
> 14,1,0.00,6.00
> 14,2,90.00,3.00
> 14,3,180.00,0.00
> 14,4,270.00,3.00
> 15,1,0.00,3.00
> 15,2,45.00,1.00
> 15,3,90.00,0.00
> 15,4,135.00,3.00
> 15,5,180.00,1.00
> 15,6,225.00,1.00
> 15,7,270.00,0.00
> 15,8,315.00,1.00
> 16,1,0.00,6.00
> 16,2,45.00,2.00
> 16,3,90.00,6.00
> 16,4,135.00,2.00
> 16,5,180.00,0.00
> 16,6,225.00,2.00
> 16,7,270.00,6.00
> 16,8,315.00,2.00
> 17,1,0.00,2.00
> 17,2,90.00,0.00
> 17,3,180.00,6.00
> 17,4,270.00,9.00
> 18,1,0.00,6.00
> 18,2,90.00,3.00
> 18,3,180.00,0.00
> 18,4,270.00,5.00
> 19,1,0.00,2.00
> 19,2,90.00,0.00
> 19,3,180.00,6.00
> 19,4,270.00,4.00
> 20,1,0.00,6.00
> 20,2,90.00,2.00
> 20,3,180.00,0.00
> 20,4,270.00,2.00
> 21,1,0.00,0.00
> 21,2,45.00,0.00
> 21,3,90.00,0.00
> 21,4,135.00,2.00
> 21,5,180.00,6.00
> 21,6,225.00,2.00
> 21,7,270.00,0.00
> 21,8,315.00,0.00
> 22,1,0.00,0.00
> 22,2,90.00,0.00
> 22,3,180.00,6.00
> 22,4,270.00,0.00
> 23,1,0.00,0.00
> 23,2,90.00,0.00
> 23,3,180.00,0.00
> 23,4,270.00,0.00
> 24,1,0.00,3.00
> 24,2,45.00,2.00
> 24,3,90.00,0.00
> 24,4,135.00,1.00
> 24,5,180.00,3.00
> 24,6,225.00,12.00
> 24,7,270.00,0.00
> 24,8,315.00,2.00
> 25,1,0.00,15.00
> 25,2,45.00,6.00
> 25,3,90.00,3.00
> 25,4,135.00,0.00
> 25,5,180.00,0.00
> 
=== message truncated ===


__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com