ForumsMessage Boards
Excel doesn't display changes in the data
Hi,
We want to send data from Excelerator, modify it, and when it is received again, that the Excel sheet reflects the changes done.
Data is sent from Excel using Excelerator, modified and sent back, and when it is received again, the Excel sheet doesn't reflect the changes done in all the fields. Only the fields that are part of the primary unique key defined in the schema, display the new value in the Excel sheet.
"Process Response Qdoc" is checked both in the QXtend Excelerator settings and in the Excelerator Design Template, and qdocResponses.log contains the data sent back to QXtend with the changes done.
Below is the schema used, the ones that are part of the primary unique key display the new value (for example TraceCode displays the new vlaue, but ShipToAddress1 doesn't) . Is this the expected behavior? Is there any way to update the displayed values without declaring them as unique?:
<?xml version="1.0"?>
<xsd:schema xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns="" xmlns:prodata="urn:schemas-progress-com:xml-prodata:0001">
<xsd:element name="IndirectSalesExcel" prodata:proDataSet="true" prodata:datasetName="dsIndirectSaleExcel">
<xsd:complexType>
<xsd:sequence>
<xsd:element name="IndirectSalesLineExcel" minOccurs="0" maxOccurs="unbounded" prodata:tableName="ttIndirectSalesLineExcel" prodata:undo="true">
<xsd:complexType>
<xsd:sequence>
<xsd:element name="DomainCode" type="xsd:string" nillable="true"/>
<xsd:element name="TraceCode" type="xsd:string" nillable="true"/>
<xsd:element name="TraceFileName" type="xsd:string" nillable="true"/>
<xsd:element name="TraceDate" type="xsd:date" nillable="true"/>
<xsd:element name="CustomerCode" type="xsd:string" nillable="true"/>
<xsd:element name="StatusCode" type="xsd:string" nillable="true"/>
<xsd:element name="IndirectSalesLineID" type="xsd:string" nillable="true"/>
<xsd:element name="SalesLine" type="xsd:int" nillable="true"/>
<xsd:element name="ShipToNumber" type="xsd:string" nillable="true"/>
<xsd:element name="ShipToName" type="xsd:string" nillable="true"/>
<xsd:element name="ShipToAddress1" type="xsd:string" nillable="true"/>
<xsd:element name="ShipToAddress2" type="xsd:string" nillable="true"/>
<xsd:element name="ShipToAddress3" type="xsd:string" nillable="true"/>
<xsd:element name="ShipToState" type="xsd:string" nillable="true"/>
<xsd:element name="ShipToCity" type="xsd:string" nillable="true"/>
<xsd:element name="ShipToCounty" type="xsd:string" nillable="true"/>
<xsd:element name="ShipToCountry" type="xsd:string" nillable="true"/>
<xsd:element name="ShipToZip" type="xsd:string" nillable="true"/>
<xsd:element name="BillToName" type="xsd:string" nillable="true"/>
<xsd:element name="BillToAddress1" type="xsd:string" nillable="true"/>
<xsd:element name="BilltoAddress2" type="xsd:string" nillable="true"/>
<xsd:element name="BillToAddress3" type="xsd:string" nillable="true"/>
<xsd:element name="BillToState" type="xsd:string" nillable="true"/>
<xsd:element name="BillToCity" type="xsd:string" nillable="true"/>
<xsd:element name="BillToCounty" type="xsd:string" nillable="true"/>
<xsd:element name="BillToCountry" type="xsd:string" nillable="true"/>
<xsd:element name="BillToZip" type="xsd:string" nillable="true"/>
<xsd:element name="InvoiceDate" type="xsd:date" nillable="true"/>
<xsd:element name="InvoiceNumber" type="xsd:string" nillable="true"/>
<xsd:element name="CurrencyCode" type="xsd:string" nillable="true"/>
<xsd:element name="CustomerItemCode" type="xsd:string" nillable="true"/>
<xsd:element name="CustomerItemDescription" type="xsd:string" nillable="true"/>
<xsd:element name="SellingQuantity" type="xsd:decimal" nillable="true"/>
<xsd:element name="SellingUnitOfMeasure" type="xsd:string" nillable="true"/>
<xsd:element name="IndAddressID" type="xsd:string" nillable="true"/>
<xsd:element name="SalesRegion" type="xsd:string" nillable="true"/>
<xsd:element name="ItemCode" type="xsd:string" nillable="true"/>
<xsd:element name="UnitPrice" type="xsd:decimal" nillable="true"/>
<xsd:element name="ExtendedPrice" type="xsd:decimal" nillable="true"/>
<xsd:element name="InternalBuyingGroup" type="xsd:string" nillable="true"/>
<xsd:element name="PerceivedBuyingGroup" type="xsd:string" nillable="true"/>
<xsd:element name="GroupID" type="xsd:string" nillable="true"/>
<xsd:element name="HIN1" type="xsd:string" nillable="true"/>
<xsd:element name="GLN" type="xsd:string" nillable="true"/>
<xsd:element name="DEANumber" type="xsd:string" nillable="true"/>
<xsd:element name="IDNGroup" type="xsd:string" nillable="true"/>
<xsd:element name="ContractCode" type="xsd:string" nillable="true"/>
<xsd:element name="DistributorContractCode" type="xsd:string" nillable="true"/>
<xsd:element name="ContractUnitOfMeasure" type="xsd:string" nillable="true"/>
<xsd:element name="ContractUnitPrice" type="xsd:decimal" nillable="true"/>
<xsd:element name="DistributorUnitPrice" type="xsd:decimal" nillable="true"/>
<xsd:element name="ChargebackPerUnit" type="xsd:decimal" nillable="true"/>
<xsd:element name="ExtendedChargeback" type="xsd:decimal" nillable="true"/>
<xsd:element name="DistAssumedChargeback" type="xsd:decimal" nillable="true"/>
<xsd:element name="Discrepancy" type="xsd:decimal" nillable="true"/>
<xsd:element name="IsChargeback" type="xsd:boolean" nillable="true"/>
<xsd:element name="IsProcessed" type="xsd:boolean" nillable="true"/>
<xsd:element name="PricingTier" type="xsd:int" nillable="true"/>
<xsd:element name="ConcurrencyControlID" type="xsd:int" nillable="true"/>
<xsd:element name="DataOperation" type="xsd:string" nillable="true"/>
</xsd:sequence>
</xsd:complexType>
</xsd:element>
</xsd:sequence>
</xsd:complexType>
<xsd:unique name="IndirectSalesLineIndex" prodata:primaryIndex="true">
<xsd:selector xpath=".//IndirectSalesLineExcel"/>
<xsd:field xpath="DomainCode"/>
<xsd:field xpath="TraceCode"/>
<xsd:field xpath="IndirectSalesLineID"/>
</xsd:unique>
</xsd:element>
</xsd:schema>
Message place holder