Omnis data transfer

wendy wizardcompserv at gmail.com
Thu Jun 9 07:19:17 EDT 2016


But in my database I have records that can be connected to Grandparent and parent and others only connect to parent - I like to make things complicated!!!!

Kind regards
Wendy Osbaldestin
Wizard Computer Services
Tel:  01260271647
Mobile: 07740541021


-----Original Message-----
From: omnisdev-en [mailto:omnisdev-en-bounces at lists.omnis-dev.com] On Behalf Of Daniel Sananes
Sent: 09 June 2016 12:03
To: OmnisDev List - English
Subject: SV: Omnis data transfer

I did this yesterday.
The child that I imported (InvoiceRows) was connected to InvoiceHead and Article Child
-----
ChildField1
ChildField2
..
..
InvNumber
ArtNumber
-----
When importing Child it will find the Invoice through InvNumber and Article from ArtNumber.
Thus establishing connection to both.


regards
 
Daniel Sananés
Kopparbergs Bryggeri AB
Tel:  + 46 (0)736 70 40 70
www.kopparbergs.se


-----Ursprungligt meddelande-----
Från: omnisdev-en [mailto:omnisdev-en-bounces at lists.omnis-dev.com] För wendy
Skickat: den 9 juni 2016 12:46
Till: 'OmnisDev List - English' <omnisdev-en at lists.omnis-dev.com>
Ämne: RE: Omnis data transfer

I agree in part  - that will work if there is only 1 connection - but you could have a record that has 2 connections

Kind regards
Wendy Osbaldestin
Wizard Computer Services
Tel:  01260271647
Mobile: 07740541021


-----Original Message-----
From: omnisdev-en [mailto:omnisdev-en-bounces at lists.omnis-dev.com] On Behalf Of Daniel Sananes
Sent: 09 June 2016 11:31
To: OmnisDev List - English
Subject: SV: Omnis data transfer

Hi Wendy,
One can export and import without loosing connections.
Simply export the parent and then export the child.
When exporting the child the last field in export data window for that child will be a record from the parent.
Then import parent, then child and Omnis takes care of re-establishing the connection.

regards
 
Daniel Sananés
Kopparbergs Bryggeri AB
Tel:  + 46 (0)736 70 40 70
www.kopparbergs.se


-----Ursprungligt meddelande-----
Från: omnisdev-en [mailto:omnisdev-en-bounces at lists.omnis-dev.com] För wendy
Skickat: den 9 juni 2016 11:18
Till: 'OmnisDev List - English' <omnisdev-en at lists.omnis-dev.com>
Ämne: RE: Omnis data transfer

When I have to do this I export all the data and import into a new database.  
Be aware that if you have text fields with line feeds in them and you export as tab delimited you will lose the line feed - for these files I use the Omnis data transfer.
You will also lose any connections to other files - these I reset manually when the import is finished.

Kind regards
Wendy Osbaldestin
Wizard Computer Services
Tel:  01260271647
Mobile: 07740541021

-----Original Message-----
From: omnisdev-en [mailto:omnisdev-en-bounces at lists.omnis-dev.com] On Behalf Of Mike Matthews
Sent: 09 June 2016 10:09
To: OmnisDev List - English
Subject: Re: Omnis data transfer

So now you have to export either side of the bad record.

Then drop that format, and reimport.

And while importing in 2 sessions, add the missing record by hand.

You should get away with it now.  But once all good, do a full export and reimport.

Mike





Mike Matthews,
 Managing Director, SQLWorks Software Ltd

Tel: +44 (0)1271 375999

Email: mike.matthews at sqlworks.co.uk

Web: www.sqlworks.co.uk

Use SQLWorks, forget Sage, ACT!, Opera, Access & SAP

On 9 Jun 2016, at 09:56, Daniel Sananes <daniel.s at kopparbergs.se> wrote:

> Hi Marc,
> 
> The datafile reported ONE fault regarding ONE record.
> So a Repair after Check data was done.
> Now Omnis reports thousands and thousands of faults regarding unused blocks.
> Inserting into the datafile is not possible, message is "Datafiles are full".
> Omnis says there are 3.000.000 blocks free.
> But as the fault-message says "Unused blocks" etc. I could not find any other solution than exporting/importing.
> 
> Marc, I would gladly like to try your Transfer Tool.
> 
> 
> regards
>  
> Daniel Sananés
> Kopparbergs Bryggeri AB
> Tel:  + 46 (0)736 70 40 70
> www.kopparbergs.se
> 
> 
> -----Ursprungligt meddelande-----
> Från: omnisdev-en [mailto:omnisdev-en-bounces at lists.omnis-dev.com] För 
> Marc De Roover
> Skickat: den 7 juni 2016 22:32
> Till: OmnisDev List - English <omnisdev-en at lists.omnis-dev.com>
> Ämne: Re: Omnis data transfer
> 
> Daniel,
> 
> We built a data transfer tool that doesn’t require to import/export. 
> Since we have so much data we ran up to the limits of the file size of the OS. So we figured out a way to work around it.
> 
> If you want I can send you a copy of our library.
> 
> What you might want to do in advance is to check which index is giving 
> you all of your data ( run over each index start to end & end to start 
> to find an index which is fully functional )
> 
> If none of them is fully OK you will have to see which index is the best en how ( which index ) can you give the missing records.
> 
> Marc
> 
> PS: to keep our data in good health:
> 	- we try not to delete and insert data ( mark them as to be deleted )
> 		after we deleted the data we do an import-export
> 	- we do daily a quick-check and if something is found we perform a import export with our tool
> 	- we use ODB to share our data in multi-user
> 
> 
> On 7 Jun 2016, at 19:57, Daniel Sananes wrote:
> 
>> Hi all
>> 
>> Summer has hit Sweden. Really warm.
>> 
>> One of our datafiles is corrupt.
>> The only way now seem to be export and import.
>> Can I use omnis data transfer for this or should I use any of the 
>> other alternatives?
>> Maybe the faults will be exported if I use omnis data transfer?
>> 
>> regards
>>  
>> Daniel Sananés
>> Kopparbergs Bryggeri AB
>> Tel:  + 46 (0)736 70 40 70
>> www.kopparbergs.se
>> 
>> 
>> 
>> _____________________________________________________________
>> Manage your list subscriptions at http://lists.omnis-dev.com
> 
> _____________________________________________________________
> Manage your list subscriptions at http://lists.omnis-dev.com
> 
> -----
> No virus found in this message.
> Checked by AVG - www.avg.com
> Version: 2016.0.7639 / Virus Database: 4591/12371 - Release Date: 
> 06/06/16 _____________________________________________________________
> 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

-----
No virus found in this message.
Checked by AVG - www.avg.com
Version: 2016.0.7639 / Virus Database: 4591/12371 - Release Date: 06/06/16 _____________________________________________________________
Manage your list subscriptions at http://lists.omnis-dev.com


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

-----
No virus found in this message.
Checked by AVG - www.avg.com
Version: 2016.0.7639 / Virus Database: 4591/12371 - Release Date: 06/06/16 _____________________________________________________________
Manage your list subscriptions at http://lists.omnis-dev.com





More information about the omnisdev-en mailing list