XML Import - Trouble with single instance of nested object

[james_richards]

I imagine I'm overlooking something really simple here. I've created a test business space to trial out importing XML data and works great when I have multiple child objects but seems to fail when an object only has one.

In the example below I have some CD's in an XML and child object LOCATION to store what rooms they may be in. I'm using version 8.3 and can share my bsv if that is helpful. All the records with more than one LOCATION (and ROOM attribute) are working great. The one with only one LOCATION does not create a ref table entry and no LOCATION is created.

Code: Select all

<?xml version="1.0" encoding="utf-8"?>
<CATALOG>
    <CD>
        <TITLE>Empire Burlesque</TITLE>
        <ARTIST>Bob Dylan</ARTIST>
        <COUNTRY>USA</COUNTRY>
        <COMPANY>Columbia</COMPANY>
        <PRICE>10.90</PRICE>
        <YEAR>1985</YEAR>
        <LOCATIONS>
            <LOCATION ROOM="Living Room" SHELF="Test"/>
            <LOCATION>
                <ROOM>Bedroom 1</ROOM>
            </LOCATION>
        </LOCATIONS>
    </CD>
    <CD>
        <TITLE>Hide your heart</TITLE>
        <ARTIST>Bonnie Tyler</ARTIST>
        <COUNTRY>UK</COUNTRY>
        <COMPANY>CBS Records</COMPANY>
        <PRICE>9.90</PRICE>
        <YEAR>1988</YEAR>
        <LOCATIONS>
            <LOCATION>
                <ROOM>Basement</ROOM>
            </LOCATION>
            <LOCATION>
                <ROOM>Den</ROOM>
            </LOCATION>
			<LOCATION ROOM="Car" SHELF="Console"/>
        </LOCATIONS>
    </CD>
    <CD>
        <TITLE>Greatest Hits</TITLE>
        <ARTIST>Dolly Parton</ARTIST>
        <COUNTRY>USA</COUNTRY>
        <COMPANY>RCA</COMPANY>
        <PRICE>9.90</PRICE>
        <YEAR>1982</YEAR>
		<LOCATIONS>
			<LOCATION ROOM="Bedroom 2" SHELF="Bottom"/>
		</LOCATIONS>
    </CD>
	 <CD>
        <TITLE>Garbage Man</TITLE>
        <ARTIST>Oscar</ARTIST>
        <COUNTRY>USA</COUNTRY>
        <COMPANY>Smelly Records</COMPANY>
        <PRICE>1.90</PRICE>
        <YEAR>1985</YEAR>
        <LOCATIONS>
            <LOCATION ROOM="Living Room" SHELF="Test"/>
            <LOCATION>
                <ROOM>Bedroom 1</ROOM>
            </LOCATION>
        </LOCATIONS>
    </CD>

</CATALOG>

[james_richards]

I see some reads so I'm adding in my test bsv in case anyone feels like having a look. I did notice that there is the PARSE_XML function in the lastest version which may very well be the solution I'll need. Maybe I'll have to download the latest version and see how much work I'll be in for to update existing apps from 8.3.

Anywho linking to the XML test bsv.
https://drive.google.com/file/d/1ymHaxL ... vV54avsV8L

[BobK]

I was able to get this to work and here are the changes I made to do it:

1) In your CD BO, change the attribute name LOCATIONS to LOCATION
2) Even though you CD BO does not have any rules, add WITH VALIDATION to your IMPORT statement
3) In the XML stored in SystemSettings.xmlstring, remove all <LOCATIONS> and </LOCATIONS> tags

Run your Import processes and it should work.