#1  
Old 21st October 2003, 05:39 AM
William E. Mahaffey
 
Posts: n/a
Default FF to NexusDB conversion

I am using CB6 and rewriting an application that was originally written in
CB4 for FlashFiler. The program has been modified for FF2 so all my tables
are FF2 tables. I would like to write my own FF2 to NexusDB conversion
routines for this application. I am making a few changes in the database
structure and need minimal user intervention as I upgrade them to the new
program.

I have looked at the import folder under NexusDB1. I do not know much
Pascal so I need a little help. I would like for my program to read the
existing FF2 tables and copy the data over to the new NexusDB tables. Could
someone give me a high level overview of how to use the pascal units and
which ones that I need to use? Mainly what I need is a list of the Pascal
units that I will need and a very high level list of the procedures that I
will need to use.

Thanks in advance for your help.

William


  #2  
Old 21st October 2003, 05:43 AM
William E. Mahaffey
 
Posts: n/a
Default Re: FF to NexusDB conversion

I forgot to mention that this program is designed to run on a local area
network with a remote server. I have no problem writing a separate
conversion program that may have to be run on the server computer.

Thanks again,

William


  #3  
Old 21st October 2003, 07:42 AM
Franz-Leo Chomse [NDX]
 
Posts: n/a
Default Re: FF to NexusDB conversion


>I have looked at the import folder under NexusDB1. I do not know much
>Pascal so I need a little help. I would like for my program to read the
>existing FF2 tables and copy the data over to the new NexusDB tables. Could
>someone give me a high level overview of how to use the pascal units and
>which ones that I need to use? Mainly what I need is a list of the Pascal
>units that I will need and a very high level list of the procedures that I
>will need to use.


you need the units of the Ff2NX project. Use the standalone FF2NX
utility to test the parameter configuration needed and create a
configuration file for it.

Then you can simulate a batch run of ff2nx in your program. The Pascal
version of such a routine would be

procedure ImportFlashFilerFiles(const ParameterFileName: AnsiString);
begin
{ Clear command line parser values }
CommandLineParser.ClearValues;
{ Read parameter file }
CommandLineParser.ProcessParameterFile(ParameterFi leName);
{ Source engine: FlashFiler }
ucnxiFlashFilerEngine.CreateSourceEngine;
{ Destination engine: Nexus }
ucnxiNexusEngine.CreateDestinationEngine;
{ Structure converter: Dictionary }
ucnxiDictionaryConverter.CreateStructureConverter;
{ Data mover: Standard }
ucnxiBasicDataMover.CreateDataMover;
{ Transfer Manager: Standard }
ucnxiTransferManager.CreateTransferManager;
{ Run }
TransferManager.NoWait := True;
TransferManager.RunBatch;
{ Free used objects to avoid problems with the finalization sequence }
FreeAndNil(DataMover);
FreeAndNil(StructureConverter);
FreeAndNil(DestinationEngine);
FreeAndNil(SourceEngine);
FreeAndNil(TransferManager);
end;


Regards from Germany

Franz-Leo Chomse [NexusDB Expert]
franz.leo.chomse@ndx.nexusdb_x.com (please remove "_x" to reply)
  #4  
Old 21st October 2003, 08:21 AM
William E. Mahaffey
 
Posts: n/a
Default Re: FF to NexusDB conversion

Franz-Leo,

{ Structure converter: Dictionary }
ucnxiDictionaryConverter.CreateStructureConverter;
{ Data mover: Standard }
ucnxiBasicDataMover.CreateDataMover;
{ Transfer Manager: Standard }


I do not want to convert the existing FF2 data structure. The structure of
new tables will be some what different. All the fields that exist in the
FF2 tables will exist in the NexusDB tables, however most all the field
lengths will be longer in the NexusDB tables and there will be new fields in
some of the NexusDB tables.

I am not positive but I beleive all I want to do is be able to read the FF2
tables and copy like fields into the NexusDB tables.

Thanks again for your help.

William





  #5  
Old 21st October 2003, 09:24 AM
Rodrigo Gómez [NDX]
 
Posts: n/a
Default Re: FF to NexusDB conversion

I guess that you'll have to create a program that includes both engines, FF2
and Nexus, and do the copy of the records by hand.

As you say, the structure changed a little, so any "generic" conversion tool
won't work for you.

--
Rodrigo Gómez [NDX]
rgomez@msa.sinspam.com.mx
(remove "sinspam." from the address)


"William E. Mahaffey" <wmahaffeyREMOVECAPS@PLEASEsuziessoftware.com>
escribió en el mensaje news:3f9443d0@wic040d....
> Franz-Leo,
>
> { Structure converter: Dictionary }
> ucnxiDictionaryConverter.CreateStructureConverter;
> { Data mover: Standard }
> ucnxiBasicDataMover.CreateDataMover;
> { Transfer Manager: Standard }
>
>
> I do not want to convert the existing FF2 data structure. The structure

of
> new tables will be some what different. All the fields that exist in the
> FF2 tables will exist in the NexusDB tables, however most all the field
> lengths will be longer in the NexusDB tables and there will be new fields

in
> some of the NexusDB tables.
>
> I am not positive but I beleive all I want to do is be able to read the

FF2
> tables and copy like fields into the NexusDB tables.
>
> Thanks again for your help.
>
> William
>
>
>
>
>



  #6  
Old 21st October 2003, 08:59 PM
Franz-Leo Chomse [NDX]
 
Posts: n/a
Default Re: FF to NexusDB conversion

On Mon, 20 Oct 2003 15:21:07 -0500, "William E. Mahaffey"
<wmahaffeyREMOVECAPS@PLEASEsuziessoftware.com> wrote:

>Franz-Leo,
>
> { Structure converter: Dictionary }
> ucnxiDictionaryConverter.CreateStructureConverter;
> { Data mover: Standard }
> ucnxiBasicDataMover.CreateDataMover;
> { Transfer Manager: Standard }
>
>
>I do not want to convert the existing FF2 data structure. The structure of
>new tables will be some what different. All the fields that exist in the
>FF2 tables will exist in the NexusDB tables, however most all the field
>lengths will be longer in the NexusDB tables and there will be new fields in
>some of the NexusDB tables.


That's the task of the transfer parameters. As long as the Nexus
tables have the same name as the FlashFiler tables, and as long as
you map fields by name, you can either choos to replace the contents
of the target table or to add the FlashFiler data to the Nexus table.

In this case the structure converter is not used, but since its
existence is checked, you have to provide one.

The data mover is just a for all records in source table copy it to
the target table loop.


Regards from Germany

Franz-Leo Chomse [NexusDB Expert]
franz.leo.chomse@ndx.nexusdb_x.com (please remove "_x" to reply)
  #7  
Old 21st October 2003, 10:25 PM
Ulrich Herrmann
 
Posts: n/a
Default Re: FF to NexusDB conversion

Hi William,
I can send you a little bcb6 example for copying tables from ff to nx. But
it is not very fast because it read Record for Record and copy Field by
Field (FieldByName) for every Field from the source table. I copy it to
public.binaries. Perhaps it can help you. For very big database it is not
the best.

Ulrich Herrmann

"William E. Mahaffey" <wmahaffeyREMOVECAPS@PLEASEsuziessoftware.com> schrieb
im Newsbeitrag news:3f941dd9@wic040d....
> I am using CB6 and rewriting an application that was originally written in
> CB4 for FlashFiler. The program has been modified for FF2 so all my

tables
> are FF2 tables. I would like to write my own FF2 to NexusDB conversion
> routines for this application. I am making a few changes in the database
> structure and need minimal user intervention as I upgrade them to the new
> program.
>
> I have looked at the import folder under NexusDB1. I do not know much
> Pascal so I need a little help. I would like for my program to read the
> existing FF2 tables and copy the data over to the new NexusDB tables.

Could
> someone give me a high level overview of how to use the pascal units and
> which ones that I need to use? Mainly what I need is a list of the Pascal
> units that I will need and a very high level list of the procedures that I
> will need to use.
>
> Thanks in advance for your help.
>
> William
>
>



  #8  
Old 22nd October 2003, 03:40 AM
William E. Mahaffey
 
Posts: n/a
Default Re: FF to NexusDB conversion

Franz-Leo,

Let me look at that. I am sure I will have more questions as I get into
this.

Thanks again for your help.

William



  #9  
Old 22nd October 2003, 03:41 AM
William E. Mahaffey
 
Posts: n/a
Default Re: FF to NexusDB conversion

Ulrich,

I will take a look at this.

Thank you so very much for your help.

William





Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Conversion FF 1.57 to Nexusdb E.P. nexusdb.public.support 1 6th September 2008 04:54 PM
MS access .mdb Conversion to NexusDB, Or?... Q Correll nexusdb.public.discussions 39 30th March 2007 04:05 AM
Apollo to NexusDB Conversion Andrew Sowerby nexusdb.public.support 2 7th January 2007 10:28 PM
Conversion of OS Software to NexusDB Malcolm Cheyne nexusdb.public.discussions 92 6th March 2006 05:40 AM
FF to NexusDB conversion William E. Mahaffey Support Newsgroups 8 22nd October 2003 03:41 AM


All times are GMT +11. The time now is 06:51 AM.


Powered by vBulletin® Version 3.6.8
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.