On 28/07/2020 18:13, Martin A. Brooks via GLLUG wrote: > On 2020-07-28 17:40, John Winters via GLLUG wrote: >> Importing into any Linux database from a CSV file is easy-peasy and can >> be accomplished in 5-10 lines of code. > > That is almost certainly guaranteed not to work for any relational > database as the relations will not be maintained.
Not true at all. The relations are easily maintained. Either preserve the existing keys and references, or if it is necessary to generate new key fields then construct an in-memory mapping between them and convert whilst loading. I have used the technique as described above on several occasions and it works just fine. John -- Xronos Scheduler - https://xronos.uk/ All your school's schedule information in one place. Timetable, activities, homework, public events - the lot Live demo at https://schedulerdemo.xronos.uk/ -- GLLUG mailing list GLLUG@mailman.lug.org.uk https://mailman.lug.org.uk/mailman/listinfo/gllug