Hi
Sorry, forgot to mention I did include that line, I replaced it instead of
name and no luck
I just tried it with the <attribute name -'name'/> back in there and still no luck
Code is as follows
string fetchxml = @"
<fetch distinct='false' mapping='logical' output-format='xml-platform' version='1.0'>
<entity name='salesorderdetail'>
<attribute name='productid'/>
<attribute name='productdescription'/>
<attribute name='priceperunit'/>
<attribute name='quantity'/>
<attribute name='extendedamount'/>
<attribute name='salesorderdetailid'/>
<order descending='false' attribute='productid'/>
<link-entity name='product' alias='af' to='productid' from='productid'>
<attribute name='name'/>
<attribute name='productnumber'/>
<link-entity name='salesorderdetail' alias='ab' to='productid' from='productid'>
<link-entity name='salesorder' alias='ac' to='salesorderid' from='salesorderid'>
<filter type='and'>
<condition attribute='salesorderid' operator='eq' value='" + orderID + @"'/>
</filter>
</link-entity>
</link-entity>
</link-entity>
</entity>
</fetch>";
EntityCollection result = service.RetrieveMultiple(new FetchExpression(fetchxml));
{
if (result != null && result.Entities.Count > 0)
{
string todaysDate = DateTime.Now.ToString("dd/MM/yyyy"); //for date ordered
DateTime dateAndTime = (DateTime)dateDeliveryRequiredImage["requestsdeliveryby"];
var date = dateAndTime.ToString("dd/MM/yyy");
List<string> _product = new List<string>();
foreach (Entity _entity in result.Entities)
{
productid = _entity.Attributes["productnumber"].ToString();
quantity = _entity.Attributes["quantity"].ToString();
CSVFile = CSVFile +
"FM-SSO" + "," +
"" + "," + //room for transaction user id
actualID + "," +
"" + "," + //room for ordered by address
"" + "," + //room for deliver to address
"" + "," + //room for invoive to address
customerOrderRefImage["new_customerorderreference"].ToString() + "," +
todaysDate + "," +
date + "," +
productid + "," +
quantity + "," +
"" + "," + //room for ordered by address
"" + "," + //room for ordered by address
"" + "," + //room for ordered by address
"" + "," + //room for ordered by address
"" + "," + //room for ordered by address
"\n"; //room for ordered by address
}
string AddressPath = "FM-SSO" + "_" + actualID;
string AddressSavePath = @"\\fm\CRMdata\maesteg\" + AddressPath + ".csv";
System.IO.File.WriteAllText(AddressSavePath, CSVFile.ToString());
}
S.Harrison
