Skip to content
+1-888-319-3663

COMMUNITY FORUM

XML query , Include attributes as columns only shows one node in Preview

Adrian asked 6 years ago
XML query ,  Include attributes  as columns
When look at the attributes I see the attributes for only one node in the Preview tab and Key Fields tab.
 
For example I have an order, with a header, line Item, and specs all of them have attributes.  I see the attributes for the Line Item node only
Cal replied 5 years ago

Did you ever resolve this?

Answers
Adrian answered 5 years ago
Yes I used C# class which created an xml file which I used smartconnect to import into GP
        namespace BCAtranform
{
    class BCATrans
    {
        public static void transform(string[] args)
        {
            String bcaPath =@”c:\bca\”;
            String fromFile =args[0];
            String toFile = args[1];
            String xsltFile = args[2];
            // Load the style sheet.
            XslCompiledTransform xslt = new XslCompiledTransform();
            xslt.Load(bcaPath+xsltFile);
 
            // Execute the transform and output the results to a file.
            xslt.Transform(bcaPath + fromFile , bcaPath+toFile);
        }
    }
}
 
 

If you would like to submit an answer or comment, please sign in to the eOne portal.