Network Version of Valentina

[Don Toro]

> So records 2 .. 21 are deleted, right ?
That's correct.

>* do you mean that you have distribute already your application?
>* do you mean that you have many users already that have 1.x dbs ?
The V1 database has not been distributed yet. So there is still time to fix the RecID if I can get to Load function in VServer to work correctly. This way I can create a V1 and V2 database. This should re-order the RecID in my Words table.

>Do you believe in this? What about vers 2 of YOUR application?
Yes. The Words table will not change.

The standalone application I am finishing now is done in Valentina V1. Since you said that you no longer support V1 of Valentina for Network I thought that I would convert the database to Valentina V2 for the Network version of the app. 

>WHY somebody will EXPORT from db 1.x and then import into 2.x database.
The user might have a copy of the standalone version installed at home and a copy of the Network version installed at work. Some time the user might want to move some of the data from home to work. So I wrote an import/export function to facilitate this. I export the data into a text file and than import back into the right table.

So let me redo the WordsScore table. The WordRecId is an objectPtr that points to the RecId of a record in the Words Table.
WordRecId     Score
1             25
22            100
...

Does cloning the database create a new database? Because if I try it nothing happens.

Donard Toro
Information Manager/Computer Programmer
-------------------------------------------------------------------
Thinking Publications, a division of
McKinley Companies, Inc.
424 Galloway Street, Eau Claire, WI 54703
Phone: 1.800.225.4769 (US) & 1.715.832.2488
Fax: 1.800.828.8885 (US) & 1.715.832.9082
www.ThinkingPublications.com
-------------------------------------------------------------------
COMMUNICATION SOLUTIONS THAT CHANGE LIVES
Specializing in resources for individuals
with speaking, listening, reading, writing, and thinking skill deficits


-----Original Message-----
From: Ruslan Zasukhin [mailto:sunshine at public.kherson.ua]
Sent: Friday, February 10, 2006 4:41 PM
To: valentina at lists.macserve.net
Subject: Re: Re[2]: Network Version of Valentina


On 2/11/06 12:10 AM, "Don Toro" <don at thinkingpublications.com> wrote:

Hi Don,

> OK, I don't think I'm explaining this right.

> Data in original Valentina 1 DB
> Words Table
> RecID     Word
> 1         word1
> 22        word1
> 34        word3
> 56        word4
> 71        word5

So records 2 .. 21 are deleted, right ?

 
> Data in new Valentina 2 DB after coversion
> Words Table
> RecID     Word
> 1         word1
> 2         word1
> 3         word3
> 4         word4
> 5         word5

RIGHT

 
> Exported Data for the WordsScore table of V1 database
> RecID,Score
> 1,25
> 22,100
> 56,34
> 71,0

QUESTION: 
    * do you mean that you have distribute already your application?
    * do you mean that you have many users already that have 1.x dbs ?


> The Words table is not going to change after the database is delivered to the
> end user. 

Do you believe in this? What about vers 2 of YOUR application?

And IF table Words is not going to change, then why it have this wholes?

It looks like you preapre some database with information to be distributed
to people. Then it is bad idea to have wholes and other empty spaces.

Such PREPARED database, should get good massage before deployment:
    1) Clone it -- to remove wholes
    2) reindex it
    3) Compact it
    4) defragment it

These steps will make db smaller and faster.


> Let's say we have a table named WordsScore. This table has two colums one is a
> link to the RecID of the Word table and the other field has the score for that
> word. So lets say that I export the data from the WordsScore table in V1
> database.
 
THIS step is not very clear to me.

> Importing this data in the WordsScore table of V2 database would have an
> incorrect RecID.

And this also. 
 
> I cannot link by the Word field in the Words table because we can have
> duplicate words with different RecIDs.

WHY somebody will EXPORT from db 1.x and then import into 2.x database.

This is assumes to be the same user?
So he have 2 versions of your app on computer?

If you think about HOW TO convert users 1.x dbs then simply use
Convert_1_2() function.


------
IF you think about more complex of data exchange between users, then you
need use not just export into text file, but .... Right! XML.

XML allow you export LINKED records, and later parse them and put into
related tables correctly. We use this technique for years in XML load/dump.
 

-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]


_______________________________________________
Valentina mailing list
Valentina at lists.macserve.net
http://lists.macserve.net/mailman/listinfo/valentina