Search Again: Re: Combining two OG databases. From: ISP List Date: Tuesday, December 2, 2003 Time: 11:57:24 am At 02:05 PM 12/2/2003 -0500, you wrote: >Ok how about a how to on exporting and importing then :) I've done quite a few imports/exports for others that I've done work for, and there is really no "easy" way to do it. One of the key things to do is to write down the default import order (which you can get by doing an export, the writing down the fields) so you can massage your import data to fit with the default import order (this eliminates the need to mess around with the field order during the import). Expect to do the import several times, as there *will* be things you didn't expect come up :-) Make sure you make a backup of the data pre-import. If you use Excel to massage any data, make sure the field type for all columns is set to "General" so it won't truncate spaces and other characters that you'll want to preserve. --------------------------------------- Mike Bacher / mike@sparklogic.com SparkLogic Development / ISP Consulting Use OptiGold ISP? Check out OptiSkin! http://www.sparklogic.com/optiskin/ --------------------------------------- --------------------------------------------------- To subscribe, unsubscribe or to search list archive please visit http://www.optigold.com/lists/isp.html ---------------------------------------------------

Messages In This Thread: Combining two OG databases. by Timothy Bohen on Dec 2, 2003 at 10:37:58 am Re: Combining two OG databases. by ISP List on Dec 2, 2003 at 11:04:56 am Re: Combining two OG databases. by Timothy Bohen on Dec 2, 2003 at 11:07:58 am Re: Combining two OG databases. by Shawn Hogan on Dec 2, 2003 at 11:18:02 am Re: Combining two OG databases. by ISP List on Dec 2, 2003 at 11:57:24 am