I'm working at a charity where we have moved from assorted W9x machines to mandriva. There is a W9x database application which has the peculiarity of allowing the user to create multiple identical field names per record, and thus has variable record lengths.
I'm being told that exporting this to csv and consolidating the data in multiple identically named fields will lose data.
(1) Is this plausible? I've done it, audited, and there is no doubt that every bit of data in every field has moved across. I cannot find any sort of grouping or sorting that can be done in the W9x app that I cannot do in Tellico. What could I be missing? The thing that is hard to see is, if the field labels are identical, how can you do things with the data split up into two, that you cannot do with them in one? Doesn't having multiple identical field labels limit rather than expand one's ability to manipulate the data?
Is this something about xml as opposed to csv in databases?
(2) Is it really possible that there are data structures which require multiple identical field labels and variable length records? Like, what and why? And could a collection database be one of them, and why?
(3) Is there a good source on open database format? The recent BECTA publication mandates odb or csv export for databases in the education sector. Where would you go to get a good account of odb? With particular reference to the moveability of a database from one platform to another.
Peter