Can't insert with Webservices a CustUPSEmail row?

Yahoo Archive
1
Yes, if I do a trace when manually adding a new record, it does do a
Customer.GetNewCustUPSEmail method call to I assume populate the UI
with blank defaults before later doing an Customer.Update when the
save button it pressed.

If I call the Webservice Customer.GetNewCustUPSEmail, it returns
blank defaults with <UPSQVSeq>5</UPSQVSeq> and <RowMod>A</RowMod>

But passing in a 5 instead of a 0 for the UPSQVSeq with an A for
RowMod to the Webservice Customer.Update still does not insert the
record. (even after doing the GetNewCustUPSEmail webservice call)

Any ideas?

--- In vantage@yahoogroups.com, "Karen Schoenung" <kschoenung@...> wrote:
>
> Hi,
>
>
>
> Did you use the trace option in Vantage (when manually adding a new
> record)? Usually for a new record, you need a GetNew method...
>
>
> FYI,
>
> Karen
>
>
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
> Of vantagenook
> Sent: Thursday, August 20, 2009 8:34 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Can't insert with Webservices a CustUPSEmail row?
>
>
>
>
>
> I'm using Vantage 8.03.403C based on a Progress DB. I'm trying to
> insert a row for each customer into the CustUPSEmail table using the
> Vantage Webservices, but I'm unable to do so. I can update an
> existing row, but that doesn't help me much in getting the more than
> ten thousand rows intially in.
>
> I've tried setting the UPSQVSeq to 0 and also setting RowMod to A,
> but neither seem to generate an insert as expected. No error is
> returned. It just validates the packet data, then seems to ignore
> the CustUPSEmail part if that UPSQVSeq doesn't exist for that
> customer already.
>
> Is there a better RowMod setting than A? Would passing any RowIdent
> or DBRowIdent produce an insert? Should I use a different Webservice
> other than Customer.Update, perhaps Customer.SetUPSQVEnable (which
> I've tried with no luck) or another? The "Notify" checkbox that
> enables that section of the UI for the Customer UPS Emails is already
> set for that record so it's not something simple like that.
>
> Here's the packet (security header info removed):
>
> <soapenv:Envelope
> xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/"
> xmlns:web="http://epicor.com/webservices/">
> <soapenv:Header/>
> <soapenv:Body>
> <web:Update>
> <web:CompanyID>NOOK</web:CompanyID>
> <web:CustomerData>
> <CustomerDataSet>
> <Customer>
> <Company>NOOK</Company>
> <CustID>RICKTEST</CustID>
> <CustNum>12332</CustNum>
> <Name>RICK3</Name>
> <ServRef1></ServRef1>
> <ServRef2></ServRef2>
> <ServRef3>Our products make us market leaders.</ServRef3>
> <ServRef4>Our people make us world class.</ServRef4>
> <ServRef5>Thank you for choosing Nook Industres!</ServRef5>
> <UPSQuantumView>true</UPSQuantumView>
> <UPSQVShipFromName>Nook Industries, Inc.</UPSQVShipFromName>
> <UPSQVMemo>Regarding your recent order...</UPSQVMemo>
> <RowMod>[Clear=ServRef1,ServRef2]</RowMod>
> </Customer>
> <CustUPSEmail>
> <Company>NOOK</Company>
> <CustNum>12332</CustNum>
> <UPSQVSeq>0</UPSQVSeq>
> <EmailAddress>thecustomer@... <mailto:thecustomer%40email.com>
> </EmailAddress>
> <ShipmentNotify>true</ShipmentNotify>
> <FailureNotify>true</FailureNotify>
> <DeliveryNotify>true</DeliveryNotify>
> <EnableQuantumView>true</EnableQuantumView>
> <RowMod>A</RowMod>
> </CustUPSEmail>
> </CustomerDataSet>
> </web:CustomerData>
> </web:Update>
> </soapenv:Body>
> </soapenv:Envelope>
>
> Any ideas for a workaround to get rows in? We don't have
> ServiceConnect so we can't insert that way. Inserting via OBDC
> would violate our warranty. I don't know of another way so I'm stuck.
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
2
I'm using Vantage 8.03.403C based on a Progress DB. I'm trying to
insert a row for each customer into the CustUPSEmail table using the
Vantage Webservices, but I'm unable to do so. I can update an
existing row, but that doesn't help me much in getting the more than
ten thousand rows intially in.

I've tried setting the UPSQVSeq to 0 and also setting RowMod to A,
but neither seem to generate an insert as expected. No error is
returned. It just validates the packet data, then seems to ignore
the CustUPSEmail part if that UPSQVSeq doesn't exist for that
customer already.

Is there a better RowMod setting than A? Would passing any RowIdent
or DBRowIdent produce an insert? Should I use a different Webservice
other than Customer.Update, perhaps Customer.SetUPSQVEnable (which
I've tried with no luck) or another? The "Notify" checkbox that
enables that section of the UI for the Customer UPS Emails is already
set for that record so it's not something simple like that.

Here's the packet (security header info removed):

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:web="http://epicor.com/webservices/">
<soapenv:Header/>
<soapenv:Body>
<web:Update>
<web:CompanyID>NOOK</web:CompanyID>
<web:CustomerData>
<CustomerDataSet>
<Customer>
<Company>NOOK</Company>
<CustID>RICKTEST</CustID>
<CustNum>12332</CustNum>
<Name>RICK3</Name>
<ServRef1></ServRef1>
<ServRef2></ServRef2>
<ServRef3>Our products make us market leaders.</ServRef3>
<ServRef4>Our people make us world class.</ServRef4>
<ServRef5>Thank you for choosing Nook Industres!</ServRef5>
<UPSQuantumView>true</UPSQuantumView>
<UPSQVShipFromName>Nook Industries, Inc.</UPSQVShipFromName>
<UPSQVMemo>Regarding your recent order...</UPSQVMemo>
<RowMod>[Clear=ServRef1,ServRef2]</RowMod>
</Customer>
<CustUPSEmail>
<Company>NOOK</Company>
<CustNum>12332</CustNum>
<UPSQVSeq>0</UPSQVSeq>
<EmailAddress>thecustomer@...</EmailAddress>
<ShipmentNotify>true</ShipmentNotify>
<FailureNotify>true</FailureNotify>
<DeliveryNotify>true</DeliveryNotify>
<EnableQuantumView>true</EnableQuantumView>
<RowMod>A</RowMod>
</CustUPSEmail>
</CustomerDataSet>
</web:CustomerData>
</web:Update>
</soapenv:Body>
</soapenv:Envelope>

Any ideas for a workaround to get rows in? We don't have
ServiceConnect so we can't insert that way. Inserting via OBDC
would violate our warranty. I don't know of another way so I'm stuck.
3
Hi,



Did you use the trace option in Vantage (when manually adding a new
record)? Usually for a new record, you need a GetNew method...


FYI,

Karen



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of vantagenook
Sent: Thursday, August 20, 2009 8:34 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Can't insert with Webservices a CustUPSEmail row?





I'm using Vantage 8.03.403C based on a Progress DB. I'm trying to
insert a row for each customer into the CustUPSEmail table using the
Vantage Webservices, but I'm unable to do so. I can update an
existing row, but that doesn't help me much in getting the more than
ten thousand rows intially in.

I've tried setting the UPSQVSeq to 0 and also setting RowMod to A,
but neither seem to generate an insert as expected. No error is
returned. It just validates the packet data, then seems to ignore
the CustUPSEmail part if that UPSQVSeq doesn't exist for that
customer already.

Is there a better RowMod setting than A? Would passing any RowIdent
or DBRowIdent produce an insert? Should I use a different Webservice
other than Customer.Update, perhaps Customer.SetUPSQVEnable (which
I've tried with no luck) or another? The "Notify" checkbox that
enables that section of the UI for the Customer UPS Emails is already
set for that record so it's not something simple like that.

Here's the packet (security header info removed):

<soapenv:Envelope
xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/"
xmlns:web="http://epicor.com/webservices/">
<soapenv:Header/>
<soapenv:Body>
<web:Update>
<web:CompanyID>NOOK</web:CompanyID>
<web:CustomerData>
<CustomerDataSet>
<Customer>
<Company>NOOK</Company>
<CustID>RICKTEST</CustID>
<CustNum>12332</CustNum>
<Name>RICK3</Name>
<ServRef1></ServRef1>
<ServRef2></ServRef2>
<ServRef3>Our products make us market leaders.</ServRef3>
<ServRef4>Our people make us world class.</ServRef4>
<ServRef5>Thank you for choosing Nook Industres!</ServRef5>
<UPSQuantumView>true</UPSQuantumView>
<UPSQVShipFromName>Nook Industries, Inc.</UPSQVShipFromName>
<UPSQVMemo>Regarding your recent order...</UPSQVMemo>
<RowMod>[Clear=ServRef1,ServRef2]</RowMod>
</Customer>
<CustUPSEmail>
<Company>NOOK</Company>
<CustNum>12332</CustNum>
<UPSQVSeq>0</UPSQVSeq>
<EmailAddress>thecustomer@... <mailto:thecustomer%40email.com>
</EmailAddress>
<ShipmentNotify>true</ShipmentNotify>
<FailureNotify>true</FailureNotify>
<DeliveryNotify>true</DeliveryNotify>
<EnableQuantumView>true</EnableQuantumView>
<RowMod>A</RowMod>
</CustUPSEmail>
</CustomerDataSet>
</web:CustomerData>
</web:Update>
</soapenv:Body>
</soapenv:Envelope>

Any ideas for a workaround to get rows in? We don't have
ServiceConnect so we can't insert that way. Inserting via OBDC
would violate our warranty. I don't know of another way so I'm stuck.





[Non-text portions of this message have been removed]