Page 1 of 1

PostPosted: Thu Dec 07, 2006 11:43 am
by compudude86
ok, i took everyones advice and created individual apps for each table. now, i need a way to combine all the tables on DIST into BOOK:products, using the dataface interface. how would i go about setting this up?

PostPosted: Thu Dec 07, 2006 1:42 pm
by shannah
Hi Joe,

Can you elaborate on this? So you have a number of tables in the DIST database that are all identical and you want to copy them into the products table of the BOOK database? Is this correct?

-Steve

PostPosted: Thu Dec 07, 2006 4:01 pm
by compudude86
that is correct, yes. i need a sort of "one-click" way to do this. there are about 10 tables in the dist db that need to go into the one products table...

PostPosted: Thu Dec 07, 2006 4:23 pm
by shannah
There may be tools available to do something like this, but the safest easiest way that I can think of is to do a dump of each table using PHPMyAdmin, put them together in a single text file, then import them into the other table also using PHPMyAdmin.

Hope this is a one-time thing as if it is a recurring process it sounds complicated - which would mean that there's a better way..

-Steve

PostPosted: Tue Dec 12, 2006 10:28 am
by compudude86
ok, thank you. thats what i originally planned on doing, but i was trying to see if there was an easier way.