O$ Problem copy data from DF1 to SQL

[Mike Matthews]

The majority of the reported issues are Char types.  I found 1 date field that was entered in 1006, only out by a thousand years.  Omnis ok with that, FB not.

The Char fields are more difficult to track down.  Which of the 63 char fields is wrong and why?  So even if I export and import, I get the same problem.

Mike



Mike Matthews
Managing Director 
Lineal Software Solutions Ltd

Very Grumpy Former  UK Apple Reseller,  Omnis Business Partner
Tel: +44 (0)1271 850 550 

Email: mike.matthews at lineal.co.uk

Web: www.lineal.co.uk


On 20 May 2012, at 16:39, Wizardcompserv at aol.com wrote:

Do you have either a lot of date fields or text fields?  I have found  a 
problem trying to get a file out of a df1 into access.  I ended up  exporting 
it to a text file and importing that to access.

Kind  Regards
Wendy Osbaldestin
Wizard Computer Services
_www.wizardcompserv.co.uk_ (http://www.wizardcompserv.co.uk/) 
Tel:  01260271647  


In a message dated 20/05/2012 14:27:39 GMT Daylight Time,  
omnis at lineal.co.uk writes:

Not  sure.  Some of the records are old and new, but only a handful of 
records  have this error, so poss a unicode thing in certain entries.  But which 
field?  I don't relish the idea of doing a binary split on exp/import,  
but I bet I'll end doing just that.  

The DF1 is about 8 years old  and was started before my time.  It is 
allegedly converted to Unicode,  but I think there may have been an issue there, 
last year when we went from  4.3 to 5.1 and Unicode.

The problem still exists if I do an export to  TAB delim and back into a 
new DF1.

I haven't yet tried to export and  import into a SQL DB yet though.

I am also getting 230 -  Exception.  Numeric value out of range in another 
table.   Argh..

Mike


Mike Matthews
Managing Director 
Lineal  Software Solutions Ltd

Very Grumpy Former  UK Apple  Reseller,  Omnis Business Partner
Tel: +44 (0)1271 850 550  

Email: mike.matthews at lineal.co.uk

Web:  www.lineal.co.uk


On 20 May 2012, at 14:19, Andy Hilton  wrote:

Mike

Just a wild guess but this is not any kind of  unicode issue is it ?

Not sure what/how Frontbase is set up for that -  but typically this is one 
of things that I have found to be an issue when  doing straight drag across 
db conversions - especially with UK clients where  there is a high 
probability of finding a pound sign :)

Andy

On  May 20, 2012, at 8:23 AM, Mike Matthews wrote:

> I have now checked  all fields to make sure they are within length.  I 
made a list of Char  fields and then stepped through each record for just 
those fields.  No  errors for length.
> 
> Then I dragged the data slot into a fresh  DF1, using the SQLBrowser.  No 
problems.  So it looks like some  knackered data that the FB DAM is having 
a problem with.  Familiar to  anyone?
> 
> Thanks
> 
> Mike
> 
> 
> Mike Matthews
> Managing Director 
> Lineal Software  Solutions Ltd
> 
> Very Grumpy Former  UK Apple  Reseller,  Omnis Business Partner
> Tel: +44 (0)1271 850 550  
> 
> Email: mike.matthews at lineal.co.uk
> 
> Web:  www.lineal.co.uk
> 
> 
> On 20 May 2012, at 11:31, Mike  Matthews wrote:
> 
> There is a SEQ field in the DF1, and it looks  fine.  In the schema 
however, the SEQ field is not there when I make the  schema by dragging the data 
slot into the lib.
> 
> There are only  6 errors out of 4850 records, so not all by any means.
> 
> Very  odd.
> 
> I need to find the field that is giving me this problem  so I can see 
what the data is, but I suspect I shall end up writing code to  loop though the 
field list and check each col by col for each record.   Only for Char 
fields, but what a pain.
> 
> Mike
> 
> 
> Mike Matthews
> Managing Director 
> Lineal Software  Solutions Ltd
> 
> Very Grumpy Former  UK Apple  Reseller,  Omnis Business Partner
> Tel: +44 (0)1271 850 550  
> 
> Email: mike.matthews at lineal.co.uk
> 
> Web:  www.lineal.co.uk
> 
> 
> On 20 May 2012, at 11:21, Jean Marc  Azerad wrote:
> 
> 
> Any Seq around?
> How does it  appears in the Schema class?
> 
> JM
> 
> 
> Le  20 mai 2012 à 11:42, Mike Matthews a écrit :
> 
>> Hello All  Good People,
>> 
>> I am having a nasty time so far in  getting data out from a DF1 data 
file into a FrontBase DB, on a Mac with  v5.1.  Quite torrid in fact.
>> 
>> I open the two DB  in the Studio SQL browser and drag the data slots 
across.  All normal so  far.  I have made the schema from the DF1 data slot, so 
it is  accurate.  There are quite a few fields though, 200 maybe.
>> 
>> During the transfer, I get an error saying that the data has been  an 
error,  Exception 239 string data, right truncated.  Which means  that the 
data coming out is longer than the space allowed to store it,  right?  I don't 
know why this is, etc.  I have tickled the DF1 data  as much as possible to 
get it into the right size.
>> 
>> I  have tried opening the data and passing the data as a list using 
code, same  problem.
>> 
>> The main trouble here is, I don't know which  field it is.  Bloomin' 
hundreds of them.  
>> 
>> How can you easily find out which field is too long in which record and 
needs  checking?
>> 
>> Thanks
>> 
>> Mike
>> 
>> 
>> 
>> Mike  Matthews
>> Managing Director 
>> Lineal Software Solutions  Ltd
>> 
>> Very Grumpy Former  UK Apple Reseller,   Omnis Business Partner
>> Tel: +44 (0)1271 850 550 
>> 
>> Email: mike.matthews at lineal.co.uk
>> 
>> Web:  www.lineal.co.uk 
> 
> _____________________________________________________________
> Manage  your list subscriptions at http://lists.omnis-dev.com
> 
> _____________________________________________________________
> Manage  your list subscriptions at  http://lists.omnis-dev.com

_____________________________________________________________
Manage  your list subscriptions at  http://lists.omnis-dev.com

_____________________________________________________________
Manage  your list subscriptions at  http://lists.omnis-dev.com

_____________________________________________________________
Manage your list subscriptions at http://lists.omnis-dev.com