Forum Replies Created
-
Posts
-
Hi,
I am trying to post my reply, but it does not get therough. maybe my message is too long, if you give me you email address. i will send you the files.
Ewa
Hi,
Here is the code of the proxy with SBDH, I called it InvoiceProxy_plusSBDH.xsd:
<?xml version=”1.0″ encoding=”UTF-8″?>
<xsd:schema xmlns:xsd=”http://www.w3.org/2001/XMLSchema” xmlns:ns1=”http://www.unece.org/cefact/namespaces/StandardBusinessDocumentHeader” targetNamespace=”urn:ean.ucc:2″>
<xsd:import namespace=”http://www.w3.org/2000/09/xmldsig#” schemaLocation=”xmldsig/xmldsig-core-schema.xsd”/>
<xsd:import namespace=”urn:ean.ucc:order:2″ schemaLocation=”ean.ucc/order/OrderLogisticalInformation.xsd”/>
<xsd:import namespace=”urn:ean.ucc:pay:2″ schemaLocation=”ean.ucc/pay/Invoice.xsd”/>
<xsd:include schemaLocation=”ean.ucc/common/AccountNumberTypeList.xsd”/>
<xsd:include schemaLocation=”ean.ucc/common/AdditionalPartyIdentificationList.xsd”/>
<xsd:include schemaLocation=”ean.ucc/common/AdditionalTradeItemIdentificationList.xsd”/>
<xsd:include schemaLocation=”ean.ucc/common/AllowanceChargeList.xsd”/>
<xsd:include schemaLocation=”ean.ucc/common/AllowanceOrChargeList.xsd”/>
<xsd:include schemaLocation=”ean.ucc/common/Command.xsd”/>
<xsd:include schemaLocation=”ean.ucc/common/CommunicationChannelCodeList.xsd”/>
<xsd:include schemaLocation=”ean.ucc/common/Contact.xsd”/>
<xsd:include schemaLocation=”ean.ucc/common/Country.xsd”/>
<xsd:include schemaLocation=”ean.ucc/common/CurrencyExchangeRateInformation.xsd”/>
<xsd:include schemaLocation=”ean.ucc/common/Description.xsd”/>
<xsd:include schemaLocation=”ean.ucc/common/DigitalSignature.xsd”/>
<xsd:include schemaLocation=”ean.ucc/common/Document.xsd”/>
<xsd:include schemaLocation=”ean.ucc/common/DocumentCommand.xsd”/>
<xsd:include schemaLocation=”ean.ucc/common/DocumentCommandList.xsd”/>
<xsd:include schemaLocation=”ean.ucc/common/DocumentLineReference.xsd”/>
<xsd:include schemaLocation=”ean.ucc/common/DocumentOrDocumentLineReference.xsd”/>
<xsd:include schemaLocation=”ean.ucc/common/DocumentReference.xsd”/>
<xsd:include schemaLocation=”ean.ucc/common/DocumentStatusList.xsd”/>
<xsd:include schemaLocation=”ean.ucc/common/EntityIdentification.xsd”/>
<xsd:include schemaLocation=”ean.ucc/common/Extension.xsd”/>
<xsd:include schemaLocation=”ean.ucc/common/FinancialInstitutionInformation.xsd”/>
<xsd:include schemaLocation=”ean.ucc/common/MeasurementUnitCode.xsd”/>
<xsd:include schemaLocation=”ean.ucc/common/Message.xsd”/>
<xsd:include schemaLocation=”ean.ucc/common/MonetaryAmount.xsd”/>
<xsd:include schemaLocation=”ean.ucc/common/NameAndAddress.xsd”/>
<xsd:include schemaLocation=”ean.ucc/common/PartyIdentification.xsd”/>
<xsd:include schemaLocation=”ean.ucc/common/PaymentFormatList.xsd”/>
<xsd:include schemaLocation=”ean.ucc/common/PaymentMethod.xsd”/>
<xsd:include schemaLocation=”ean.ucc/common/PaymentMethodList.xsd”/>
<xsd:include schemaLocation=”ean.ucc/common/PaymentTerms.xsd”/>
<xsd:include schemaLocation=”ean.ucc/common/PaymentTermsEventList.xsd”/>
<xsd:include schemaLocation=”ean.ucc/common/PaymentTermsTypeList.xsd”/>
<xsd:include schemaLocation=”ean.ucc/common/Percentage.xsd”/>
<xsd:include schemaLocation=”ean.ucc/common/Quantity.xsd”/>
<xsd:include schemaLocation=”ean.ucc/common/ResponseStatusList.xsd”/>
<xsd:include schemaLocation=”ean.ucc/common/ServiceLevelCodeList.xsd”/>
<xsd:include schemaLocation=”ean.ucc/common/ShipmentSpecialHandlingCodeList.xsd”/>
<xsd:include schemaLocation=”ean.ucc/common/ShipmentTransportationInformation.xsd”/>
<xsd:include schemaLocation=”ean.ucc/common/TimePeriod.xsd”/>
<xsd:include schemaLocation=”ean.ucc/common/TimePeriodList.xsd”/>
<xsd:include schemaLocation=”ean.ucc/common/TradeItemIdentification.xsd”/>
<xsd:include schemaLocation=”ean.ucc/common/Transaction.xsd”/>
<xsd:include schemaLocation=”ean.ucc/common/TransportationMethodTypeCodeList.xsd”/>
<xsd:import namespace=”http://www.unece.org/cefact/namespaces/StandardBusinessDocumentHeader” schemaLocation=”sbdh\BasicTypes.xsd”/>
<xsd:import namespace=”http://www.unece.org/cefact/namespaces/StandardBusinessDocumentHeader” schemaLocation=”sbdh\BusinessScope.xsd”/>
<xsd:import namespace=”http://www.unece.org/cefact/namespaces/StandardBusinessDocumentHeader” schemaLocation=”sbdh\DocumentIdentification.xsd”/>
<xsd:import namespace=”http://www.unece.org/cefact/namespaces/StandardBusinessDocumentHeader” schemaLocation=”sbdh\Manifest.xsd”/>
<xsd:import namespace=”http://www.unece.org/cefact/namespaces/StandardBusinessDocumentHeader” schemaLocation=”sbdh\Partner.xsd”/>
<xsd:import namespace=”http://www.unece.org/cefact/namespaces/StandardBusinessDocumentHeader” schemaLocation=”sbdh\StandardBusinessDocumentHeader.xsd”/>
</xsd:schema>You can use this one to generate the instance file. I use XML Spy and there are some issues with that tool (we tried to work it out with Altova, but the bug keeps coming back), so in the instance I removed the second schema declaration – in the element <pay:invoice…>, to maker it work. Perhaps you’ll be able to leave it as in the example if you use other tool. The file generation is rather cumbersome, because Spy cannot do it totally automatically with that design, but it works. I used the existing instance to make it quicker, but it can be done from scratch as well.
Do not get discouraged, we are really working on making this simpler to implement. This design was created 8 years ago and back then seemed like a good idea, but when people started to implement it on a bigger scale, we realized how confusing it sometimes is.
Here is the code of the sample Invoice.xml based on the modified proxy:
<?xml version=”1.0″ encoding=”UTF-8″?>
<sh:StandardBusinessDocument xmlns:sh=”http://www.unece.org/cefact/namespaces/StandardBusinessDocumentHeader” xmlns:eanucc=”urn:ean.ucc:2″ xmlns:pay=”urn:ean.ucc:pay:2″ xmlns:xsi=”http://www.w3.org/2001/XMLSchema-instance” xsi:schemaLocation=”urn:ean.ucc:2 ../Schemas/InvoiceProxy_plusSBDH.xsd”>
<sh:StandardBusinessDocumentHeader>
<sh:HeaderVersion>1.0</sh:HeaderVersion>
<sh:Sender>
<sh:Identifier Authority=”EAN.UCC”>8712345678913</sh:Identifier>
<sh:ContactInformation>
<sh:Contact>John Doe</sh:Contact>
<sh:EmailAddress>[email protected]</sh:EmailAddress>
<sh:FaxNumber>+1-212-555-1213</sh:FaxNumber>
<sh:TelephoneNumber>+1-212-555-2122</sh:TelephoneNumber>
<sh:ContactTypeIdentifier>Seller</sh:ContactTypeIdentifier>
</sh:ContactInformation>
</sh:Sender>
<sh:Receiver>
<sh:Identifier Authority=”EAN.UCC”>8812345678903</sh:Identifier>
<sh:ContactInformation>
<sh:Contact>Mary Smith</sh:Contact>
<sh:EmailAddress>[email protected]</sh:EmailAddress>
<sh:FaxNumber>+1-312-555-1214</sh:FaxNumber>
<sh:TelephoneNumber>+1-312-555-2125</sh:TelephoneNumber>
<sh:ContactTypeIdentifier>Buyer</sh:ContactTypeIdentifier>
</sh:ContactInformation>
</sh:Receiver>
<sh:DocumentIdentification>
<sh:Standard>EAN.UCC</sh:Standard>
<sh:TypeVersion>2.4</sh:TypeVersion>
<sh:InstanceIdentifier>100002</sh:InstanceIdentifier>
<sh:Type>Invoice</sh:Type>
<sh:MultipleType>false</sh:MultipleType>
<sh:CreationDateAndTime>2004-04-05T11:00:00.000-05:00</sh:CreationDateAndTime>
</sh:DocumentIdentification>
</sh:StandardBusinessDocumentHeader>
<eanucc:message>
<entityIdentification>
<uniqueCreatorIdentification>MSG-123-20040110</uniqueCreatorIdentification>
<contentOwner>
<gln>8712345678913</gln>
</contentOwner>
</entityIdentification>
<eanucc:transaction>
<entityIdentification>
<uniqueCreatorIdentification>TRA-041-66573058</uniqueCreatorIdentification>
<contentOwner>
<gln>8712345678913</gln>
</contentOwner>
</entityIdentification>
<command>
<eanucc:documentCommand>
<documentCommandHeader type=”ADD”>
<entityIdentification>
<uniqueCreatorIdentification>CMD-912-54618595</uniqueCreatorIdentification>
<contentOwner>
<gln>8712345678913</gln>
</contentOwner>
</entityIdentification>
</documentCommandHeader>
<documentCommandOperand>
<pay:invoice creationDateTime=”2004-04-05T11:00:00.000-05:00″ documentStatus=”ORIGINAL”>
<contentVersion>
<versionIdentification>2.4</versionIdentification>
</contentVersion>
<documentStructureVersion>
<versionIdentification>2.4</versionIdentification>
</documentStructureVersion>
<invoiceIdentification>
<uniqueCreatorIdentification>2005001</uniqueCreatorIdentification>
<contentOwner>
<gln>8712345678913</gln>
</contentOwner>
</invoiceIdentification>
<invoiceCurrency>
<currencyISOCode>EUR</currencyISOCode>
</invoiceCurrency>
<invoiceType>INVOICE</invoiceType>
<countryOfSupplyOfGoods>
<countryISOCode>NL</countryISOCode>
</countryOfSupplyOfGoods>
<remitTo>
<partyIdentification>
<gln>8712345679230</gln>
</partyIdentification>
</remitTo>
<buyer>
<partyIdentification>
<gln>8812345678903</gln>
</partyIdentification>
</buyer>
<seller>
<partyIdentification>
<gln>8712345678913</gln>
</partyIdentification>
</seller>
<invoiceLineItem number=”1″>
<tradeItemIdentification>
<gtin>08712345678906</gtin>
</tradeItemIdentification>
<invoicedQuantity>
<value>50.00</value>
</invoicedQuantity>
<transferOfOwnershipDate>2005-06-24</transferOfOwnershipDate>
<amountInclusiveAllowancesCharges>500.00</amountInclusiveAllowancesCharges>
<itemPriceInclusiveAllowancesCharges>10.00</itemPriceInclusiveAllowancesCharges>
<despatchAdvice>
<documentReference>
<uniqueCreatorIdentification>200506001</uniqueCreatorIdentification>
<contentOwner>
<gln>8712345678913</gln>
</contentOwner>
</documentReference>
</despatchAdvice>
</invoiceLineItem>
<invoiceLineItem number=”2″>
<tradeItemIdentification>
<gtin>08712345678883</gtin>
</tradeItemIdentification>
<invoicedQuantity>
<value>10.00</value>
</invoicedQuantity>
<transferOfOwnershipDate>2005-06-24</transferOfOwnershipDate>
<amountInclusiveAllowancesCharges>150.00</amountInclusiveAllowancesCharges>
<itemPriceInclusiveAllowancesCharges>15.00</itemPriceInclusiveAllowancesCharges>
<despatchAdvice>
<documentReference>
<uniqueCreatorIdentification>200506001</uniqueCreatorIdentification>
<contentOwner>
<gln>8712345678913</gln>
</contentOwner>
</documentReference>
</despatchAdvice>
</invoiceLineItem>
<invoiceTotals>
<totalInvoiceAmount>600.00</totalInvoiceAmount>
<totalAmountInvoiceAllowancesCharges>50.00</totalAmountInvoiceAllowancesCharges>
<totalLineAmountInclusiveAllowancesCharges>650.00</totalLineAmountInclusiveAllowancesCharges>
</invoiceTotals>
<invoiceAllowanceCharge>
<invoiceAllowanceChargeAmount>100.00</invoiceAllowanceChargeAmount>
<invoiceAllowanceChargeType>ALLOWANCE_GLOBAL</invoiceAllowanceChargeType>
<invoiceAllowanceOrChargeType>ALLOWANCE</invoiceAllowanceOrChargeType>
</invoiceAllowanceCharge>
<invoiceAllowanceCharge>
<invoiceAllowanceChargeAmount>50.00</invoiceAllowanceChargeAmount>
<invoiceAllowanceChargeType>CHARGE_GLOBAL</invoiceAllowanceChargeType>
<invoiceAllowanceOrChargeType>CHARGE</invoiceAllowanceOrChargeType>
</invoiceAllowanceCharge>
<paymentTerms paymentTermsEvent=”DATE_OF_INVOICE” paymentTermsType=”DISCOUNT”>
<discountPayment discountType=”Payment within 30 days”>
<paymentTimePeriod>
<timePeriodDue timePeriod=”DAYS”>
<value>30</value>
</timePeriodDue>
</paymentTimePeriod>
<discountPercent>1.00</discountPercent>
</discountPayment>
</paymentTerms>
</pay:invoice>
</documentCommandOperand>
</eanucc:documentCommand>
</command>
</eanucc:transaction>
</eanucc:message>
</sh:StandardBusinessDocument>Ewa
Ewa,
To be more specific, my question is how to generate the xml document out of GS1 schema package, that will contain both SBDH and Invoice? The same document as the one that is included in GS1 package, in the folder Instance Files and called Invoice.xml.
Whatever I try to do, I cannot generate similar instance xml file from GS1 schemas. How do I do it?
I will need to create this file (similar to included sample Invoice.xml) by mapping. Which GS1 schema do I map to to create Invoice.xml?
Thank you.
Hi.
Hmmm … I haven’t seen this error message before. But for me it looks like there are not enough rights for the groups and these are not correct installed.
Have you checked which groups and rights you have to build on the servers and for the AD?
Wolfgang
Hi,
I am getting error configuring the group. Here is some of the errors that I am getting.
2010-07-27 22:00:38:0227 [INFO] WMI CWMIInstProv::EnumerateInstances() try to acquire lock
2010-07-27 22:00:38:0258 [INFO] WMI CWMIInstProv::EnumerateInstances() lock acquired successfully
2010-07-27 22:00:38:0274 [INFO] WMI CWMIInstProv::EnumerateInstances(MSBTS_GroupSetting) started
2010-07-27 22:00:38:0274 [INFO] WMI CWMIInstProv::EnumerateInstancesWithQuery(MSBTS_GroupSetting) started
2010-07-27 22:00:38:0290 [INFO] WMI CAdmCoreInstance::Load() started for ‘Group’ DBObject
2010-07-27 22:00:38:0290 [WARN] AdminLib GetBTSMessage: hrErr=c0c024bf; Msg=The server has not been configured.
To configure the server, run the BizTalk Server Configuration wizard and configure the Group feature.;
2010-07-27 22:00:38:0305 [ERR] WMI Failed in RetrieveInstances in CWMIInstProv::EnumerateInstancesWithQuery(). HR=c0c024bf
2010-07-27 22:00:38:0305 [ERR] WMI WMI error description is generated: The server has not been configured.
To configure the server, run the BizTalk Server Configuration wizard and configure the Group feature.
2010-07-27 22:00:38:0321 [INFO] WMI CWMIInstProv::EnumerateInstances() finished. HR=c0c024bf
[10:00:38 PM Error BtsCfg] f:\bt\890\private\source\setup\prod\btssetup\btscfg\btswmi.cpp(1012): FAILED hr = c0c024bf[10:00:38 PM Error BtsCfg] The server has not been configured.
To configure the server, run the BizTalk Server Configuration wizard and configure the Group feature.
[10:00:38 PM Info BtsCfg] Leaving function: CBtsCfg::UnConfigureFeature
[10:00:38 PM Info BtsCfg] Leaving function: CBtsCfg::ConfigureFeature
[10:00:38 PM Warning Configuration Framework]Feature failed to configure: WMI.
[10:00:38 PM Info Configuration Framework]Configuration Summaries:
[10:00:38 PM Error Configuration Framework]Feature: [Group] Failed to configure with error message [Failed to create subscription database “BizTalkMsgBoxDb” on server “CC-DT-IT-01”.
Cannot find the object ‘bts_UpdateCopyTrackedMessagesJob’, because it does not exist or you do not have permission.SQL script file: “C:\Program Files\Microsoft BizTalk Server 2009\Schema\\msgboxlogic.sql”
SQL command batch: “GRANT EXEC ON [dbo].[bts_UpdateCopyTrackedMessagesJob] TO BTS_ADMIN_USERS
“]Can someone helps
Thank you
Thank you Ewa very much.
I am still struggling with this. Could you please send me the code of InvoiceProxy.xsd with SBDH included? This would really be helpfuld.
Thank you again.
Warm regards
Hi,
Save from yourself problem of copying and restoring BizTalk DB’s. Not sure it would work at all. Just unconfigure the existing configuration, and configure form the beginning.
If you don’t use BAM/BRE/EDI – don’t install – less parts installed – less stuff to deal with 🙂
Also pay attention for MSDTC – it must be configured properly.
Wow – ask for a hint and get a solution. Thank you very much for the effort. I am having issues when I add multiple persons, but I can hopefully get it from here. Again – thank you!
The file I am receiving is very similar to the raw flat file I show above. It has a HEADER line with a few fields, then there are one or more DETAIL lines that a children to the header. The DETAIL line does not contain any data which connects it to the HEADER. A DETAIL line may have a further child, SUBDETAIL. When the message is stored in the message box, the resulting xml needs to preserve the parent child relationship.
Hi,
I’ve built a sample according to your specs, and uploaded it to my account here in BizTalkGurus. Click on my avatar, go to My File section on the right and look for the zipped file named “People_Artifacts.zip”. Download it to your machine, and unzip it, it contains the following files:
People_FF.xsd (Flat file schema)
People_XML.xsd (XML schema)
People_Map.btm (Map)
People_XML_output.xml (XML test file used by Map for input instance)
People_Map_output.txt (Text test file used by Map for output instance)
The artifacts were built using BizTalk 2006 R2 version, so you can easily convert them to version 2009.
I hope this is a workable solution for you,
Daniel.
Thank you again.
One last question, I have create the Biztalk databases in the new SQL server right? can I copy/paste mdf from the local sql server to the new ones?
Please advise.
