Data Import XML directory

[Walter Vaughan]

After loading a good amount of data into ofBiz with mySQL as the back end, I
decided to use postgreSQL.

 From the webtools, the sensible thing would be to do is create a backup with
"XML_DATA_EXPORT_ALL" creating a folder in the temp directory.

Then switch the config to use "localpostgres" instead of "localmysql" with the
required changes inside that xml.

I then created a new empty database and ran ant run-install-seed. So far so good.

I then ran the XML_DATA_IMPORT_DIR from webtools, and watched the logs.

Woops!! Almost nothing loads because of key restraints, even checking "DummyFK's".

Well, Now I am wondering how that could ever work the way it seems it should.

I thought I read that dumping and reloading was a feature of the the entity
engine data tools, but googling got me nowhere.

Help!

--
Waltr

[Jacques Le Roux]

You may have a look here : http://ofbizwiki.go-integral.com/Wiki.jsp?page=IntegrityConstrain

Jacques

----- Original Message -----
From: "Walter Vaughan" <[hidden email]>
To: <[hidden email]>
Sent: Friday, December 08, 2006 7:43 PM
Subject: Data Import XML directory

> After loading a good amount of data into ofBiz with mySQL as the back end, I
> decided to use postgreSQL.
>
>  From the webtools, the sensible thing would be to do is create a backup with
> "XML_DATA_EXPORT_ALL" creating a folder in the temp directory.
>
> Then switch the config to use "localpostgres" instead of "localmysql" with the
> required changes inside that xml.
>
> I then created a new empty database and ran ant run-install-seed. So far so good.
>
> I then ran the XML_DATA_IMPORT_DIR from webtools, and watched the logs.
>
> Woops!! Almost nothing loads because of key restraints, even checking "DummyFK's".
>
> Well, Now I am wondering how that could ever work the way it seems it should.
>
> I thought I read that dumping and reloading was a feature of the the entity
> engine data tools, but googling got me nowhere.
>
> Help!
>
> --
> Waltr

[David E Jones-2]

Are you _sure_ you had the dummy fks set? If it is really set there  
will never be any foreign key exceptions. It may be that it is set  
and you are really getting another error back, like a transaction  
timeout or something.

-David


On Dec 8, 2006, at 11:43 AM, Walter Vaughan wrote:

> After loading a good amount of data into ofBiz with mySQL as the  
> back end, I decided to use postgreSQL.
>
> From the webtools, the sensible thing would be to do is create a  
> backup with
> "XML_DATA_EXPORT_ALL" creating a folder in the temp directory.
>
> Then switch the config to use "localpostgres" instead of  
> "localmysql" with the required changes inside that xml.
>
> I then created a new empty database and ran ant run-install-seed.  
> So far so good.
>
> I then ran the XML_DATA_IMPORT_DIR from webtools, and watched the  
> logs.
>
> Woops!! Almost nothing loads because of key restraints, even  
> checking "DummyFK's".
>
> Well, Now I am wondering how that could ever work the way it seems  
> it should.
>
> I thought I read that dumping and reloading was a feature of the  
> the entity engine data tools, but googling got me nowhere.
>
> Help!
>
> --
> Waltr