(UTC)
  Lantica User Forum › Lantica Discussions › Lantica Discussion › Import to Back up database
(Moderator: Forum Admin)
‹ Previous Topic | Next Topic ›
Page Index Toggle Pages: 1 Send Topic Send Topic Print Print
Normal Topic Import to Back up database (Read 11608 times)
cbislander
Full Member
***
Offline



Posts: 103
Joined: Mar 22nd, 2018
Import to Back up database
Aug 29th, 2019 at 10:15pm
Print Post Print Post  
I have a database that has an invoice with items sub form.
In the original the items are listed in the sub form

1
2
3

But when I export all the fields and import all the fields, the back up database lists the items

3
2
1

How do I make sure the back up database displays the sub form in the same order?
  
Back to top
 
IP Logged
 
Ray the Reaper
Global Moderator
Members
Lantica Support
*****
Offline


The One & The Only

Posts: 2480
Joined: Aug 20th, 2003
Re: Import to Back up database
Reply #1 - Aug 30th, 2019 at 1:37pm
Print Post Print Post  
Export automatically sorts the records by field order. So in the case of a parent/child export: The Parent records will be sorted by the First element selected for the export, then the second and so on. For each parent record, the child records are sorted the same way. By the first element selected, then by the second, etc. So if you have a date element on the subform, or an id, place that first in the export spec for the subform elements and the same in the import spec.

-Ray
  
Raymond Yoxall Consulting
ray.yoxall@gmail.com
ryoxall@lantica.com
Sesame Applications, Design and Support
Back to top
WWW WWW  
IP Logged
 
cbislander
Full Member
***
Offline



Posts: 103
Joined: Mar 22nd, 2018
Re: Import to Back up database
Reply #2 - Aug 31st, 2019 at 5:35pm
Print Post Print Post  
Hi Ray,

I did put an ID number for the Item on the invoice but I did not have a default sort.  I just had to set it up to sort by the item field in the sub form first.
  
Back to top
 
IP Logged
 
Page Index Toggle Pages: 1
Send Topic Send Topic Print Print
‹ Previous Topic | Next Topic ›
 
  « Board Index ‹ Board Top  

Lantica User Forum » Powered by YaBB 2.6.11!
YaBB Forum Software © 2000-2024. All Rights Reserved.

Valid RSS Valid XHTML Valid CSS Powered by Perl Source Forge