I am trying to use XML Importer utility from OI to import/export files to XML, and it is working OK with a flat file with 1 or 2 layers.
But this Utility does not work for XML files that contain 3 or more layers.
Has anyone come across with this problem?
Any assistance or help much appreciated.
Thanks- Cuong Nguyen
Yes we had to custom code a solution that works with "n" layers. See http://www.revsoft.co.uk/usssl.htm for the user story. Sorry not to have better news.
The Sprezzatura Group Web Site
World Leaders in all things RevSoft
ok .. will try again
Was this reported in the bug tracker?
It's not a bug per se assuming we are understanding the question correctly. We are taking this to mean many to many to many relationships. The importer does not allow you to say "import these tags into this table, these tags into this table using this tag as the primary key and withing those tags use this tag as the primary key to import these tags into this table" to as many levels as you want.
The Sprezzatura Group Web Site
World Leaders in all things RevSoft
'per se' you are correct .. how about an enhancement?
We've got one - but thanks for offering ;).
The Sprezzatura Group Web Site
World Leaders in all things RevSoft
Thanks for all the comments and support.
I have got the import file going, now the export should be similar.
Also, thanks to Richard Bright for couple good suggestions.
Best Regards,
Cuong Nguyen.
That's great news. Way to go Cuong and Richard!
World leaders in all things RevSoft
One, was to consult the experts such as Sprez, SRP, Bob C. Can't remember the other :).
BTW, for other ignorant people like me reading this thread, Microsoft have just released a nice little XML reader - XML Notepad 2007 see www.microsoft.com/downloads/details.aspx?familyid=72D6AA49-787D-4118-BA5F-4F30FE913628&displaylang=en
Richard Bright
BrightIdeas New Zealand