XML query , Include attributes as columns only shows one node in Preview
Adrian asked 8 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
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
Answers
Adrian answered 7 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);
}
}
}
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);
}
}
}
Did you ever resolve this?