I'll have to check them out...although, in this case, I am pulling informtion from multiple files to make up one table.
I developed a system that builds an image in a dynamic array of each of the flattened rows. When it builds the arrary, before writing it, it will read the image already on file based on a key. if the image is different, it writes the old image to a "history" file with a date/time added to the key, and then writes the new image to a "changes" file using the source file as an added key, as well as writing the changed image to the saved file. Basicaly, I am left with a set of files (dynamic arrays) which mimic the MySQL tables I have a "changes" file which only has data which has changed (or is new) to be exported to the MySQL table next time I have a "history" file so I can compare the changes file against, so only the fields that change are exported. I run through the changes, sorted by the "source" file it came from (added to the ID when written), the source file tells the export program the name of the sequential output file that holds the INSERT / UPDATE commands Once the SQL files are completed it is pushed into MySQL to do it's thing to update the MySQL database. What is good is that if the MySQL database is ever corrupted, no big deal, truncate everything, and do a full load based on the dynamic images created, as opposed to doing a partial update. But to answer the question, no, its not to be visible from U2 It works pretty good. George Gallen Senior Programmer/Analyst Accounting/Data Division [email protected] ph:856.848.9005 Ext 220 The Wyanoke Group http://www.wyanokegroup.com ________________________________________ From: [email protected] [[email protected]] On Behalf Of Wols Lists [[email protected]] Sent: Thursday, November 10, 2011 4:54 AM To: [email protected] Subject: Re: [U2] Suggestions for flattening Multivalues... On 09/11/11 19:05, Steve Romanow wrote: > Are any of the multivalued fields associated to each other? You would > have a subtable per association, not per column. > > The messiness still exists, it just needs to be managed. And are you looking to export it to MySQL (or whatever), or are you planing to make it visible from U2 via ODBC or OleDB? There's a bunch of programs on PickWiki that will dump FILEs into normalised tables, based on "correctly" set up associations. You might find some of it useful. Cheers, Wol _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users
