[[https://www.revelation.com/|Sign up on the Revelation Software website to have access to the most current content, and to be able to ask questions and get answers from the Revelation community]]


==== XML with multi layers problem! (OpenInsight 32-bit Specific) ====
=== At 15 FEB 2007 04:18:28PM Cuong Van CV Nguyen wrote: ===
 
{{tag>"OpenInsight 32-bit Specific"}}
 
<QUOTE>
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

cvannguyen@ingnz.com
</QUOTE>
----

=== At 15 FEB 2007 04:48PM support@sprezzatura.com wrote:  ===

<QUOTE>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.



support@sprezzatura.com

The Sprezzatura Group Web Site

[i]World Leaders in all things RevSoft[/i]

[img]http://www.sprezzatura.com/zz.gif[/img]

</QUOTE>

----

=== At 15 FEB 2007 08:34PM dsig@sigafoos.org wrote:  ===

<QUOTE>

</QUOTE>

----

=== At 15 FEB 2007 08:35PM dsig@sigafoos.org wrote:  ===

<QUOTE> ok .. will try again



Was this reported in the bug tracker?

</QUOTE>

----

=== At 16 FEB 2007 03:25AM support@sprezzatura.com wrote:  ===

<QUOTE>It's not a bug [i]per se[/i] 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.



support@sprezzatura.com

The Sprezzatura Group Web Site

[i]World Leaders in all things RevSoft[/i]

[img]http://www.sprezzatura.com/zz.gif[/img]

</QUOTE>

----

=== At 20 FEB 2007 06:21PM dsig@sigafoos.org wrote:  ===

<QUOTE>'per se' you are correct .. how about an enhancement?

</QUOTE>

----

=== At 20 FEB 2007 06:40PM support@sprezzatura.com wrote:  ===

<QUOTE>We've got one - but thanks for offering ;).



support@sprezzatura.com

The Sprezzatura Group Web Site

[i]World Leaders in all things RevSoft[/i]

[img]http://www.sprezzatura.com/zz.gif[/img]

</QUOTE>

----

=== At 21 FEB 2007 04:42PM Cuong Van CV Nguyen wrote:  ===

<QUOTE>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.







</QUOTE>

----

=== At 21 FEB 2007 05:00PM [url=http://www.sprezzatura.com]The Sprezzatura Group[/url] wrote:  ===

<QUOTE>That's great news. Way to go Cuong and Richard!



[url=http://www.sprezzatura.com]The Sprezzatura Group[/url]

[i]World leaders in all things RevSoft[/i]

[img]http://www.sprezzatura.com/zz.gif[/img]

</QUOTE>

----

=== At 22 FEB 2007 02:59AM Richard Bright wrote:  ===

<QUOTE>

One, was to consult the experts such as Sprez, SRP,  Bob C.  Can't remember the other :).

</QUOTE>

----

=== At 22 FEB 2007 03:08AM Richard Bright wrote:  ===

<QUOTE>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 

r.bright@ark.co.nz 

</QUOTE>


[[https://www.revelation.com/revweb/oecgi4p.php/O4W_HANDOFF?DESTN=O4W_RUN_FORM&INQID=NONWORKS_READ&SUMMARY=1&KEY=8E1DF64FB67783838525728300750C48|View this thread on the  forum...]]