while importing data from XML file, more than one root problem

T

Tarandeep Singh

hi,

I am new to Infopath.
I am using infopath to make a form by using existing XML file.
Whli moving forward it is showing me a problem of more than one root( in my
case 5 roots) and allowing me for to specify one root only.
I want the whole data on one form
Please guide me how to have the data of all the five roots on a single form

regards
Ankit
 
S

S.Y.M. Wong-A-Ton

Hi,

Post the structure of your XML. Perhaps we can get a better idea then of
what you mean and are trying to do.

Regards,
S.Y.M. Wong-A-Ton
 
S

S.Y.M. Wong-A-Ton

Hi,

Could you just copy and paste your XML structure into a message here in the
newsgroup? Thanks.

Regards,
S.Y.M. Wong-A-Ton
 
A

Ankit Tyagi

<?xml version="1.0" encoding="UTF-8"?>
<!-- This is a sample file-->
<eanucc:envelope xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:eanucc="http://www.ean-ucc.org/schemas/1.3.1/eanucc"
xsi:schemaLocation="http://www.ean-ucc.org/schemas/1.3.1/eanucc
CatalogueItemNotificationProxy.xsd" communicationVersion="1.3.1">
<messageHeader creationDate="2001-08-02T12:00:00">
<userId>OJGROWER-12345</userId>
<password>SECRET</password>
<messageIdentifier>MSG-123</messageIdentifier>
<to>
<gln>0012345000065</gln>
</to>
<from>
<gln>0614141000012</gln>
</from>
<representingParty>
<gln>0012345000065</gln>
</representingParty>
</messageHeader>
<body>
<eanucc:transaction>
<entityIdentification>

<uniqueCreatorIdentification>OJGROWER-TRANS-12345</uniqueCreatorIdentificati
on>
<contentOwner>
<gln>0614141000012</gln>
</contentOwner>
</entityIdentification>
<command>
<eanucc:documentCommand>
<documentCommandHeader type="ADD">
<entityIdentification>

<uniqueCreatorIdentification>OJGROWER-ITEM-12345</uniqueCreatorIdentificatio
n>
<contentOwner>
<gln>0614141000012</gln>
</contentOwner>
</entityIdentification>
</documentCommandHeader>
<documentCommandOperand>
<eanucc:catalogueItemNotification contentVersion="1.0"
documentStructureVersion="1.3.1" lastUpdateDate="2003-03-21"
creationDate="2003-03-21T09:30:47-05:00" documentStatus="ORIGINAL"
isReload="false">
<catalogueItem>
<catalogueItemState state="IN_PROGRESS"/>
<tradeItem>
<tradeItemUnitDescriptor>CASE</tradeItemUnitDescriptor>
<tradeItemIdentification>
<gtin>61414100000012</gtin>
</tradeItemIdentification>
<replacedTradeItemIdentification>
<gtin>00123456555334</gtin>
</replacedTradeItemIdentification>
<nextLowerLevelTradeItemInformation>
<quantityOfChildren>2</quantityOfChildren>

<totalQuantityOfNextLowerLevelTradeItem>10</totalQuantityOfNextLowerLevelTra
deItem>
<childTradeItem>

<quantityofNextLowerLevelTradeItem>5</quantityofNextLowerLevelTradeItem>
<tradeItemIdentification>
<gtin>00123456556331</gtin>
</tradeItemIdentification>
</childTradeItem>
<childTradeItem>

<quantityofNextLowerLevelTradeItem>5</quantityofNextLowerLevelTradeItem>
<tradeItemIdentification>
<gtin>00123456556997</gtin>
</tradeItemIdentification>
</childTradeItem>
</nextLowerLevelTradeItemInformation>
<tradeItemInformation>
<allowanceCharge allowanceChargeType="ALLOWANCE_GLOBAL"
sequenceNumber="1" allowanceOrChargeType="ALLOWANCE"
settlementType="CHARGE_TO_BE_PAID_BY_CUSTOMER"
effectiveDateType="EFFECTIVE_DATE">
<allowanceChargePriceBracket>
<bracketIdentifier>TOP</bracketIdentifier>
</allowanceChargePriceBracket>
<monetaryAmountOrPercentage>
<amount currencyISOCode="USD">20</amount>
</monetaryAmountOrPercentage>
<baseAmount>
<amount currencyISOCode="USD">20</amount>
</baseAmount>
<description>
<description language="EN">
<text>Qt. of Yummy Cola</text>
</description>
</description>
</allowanceCharge>
<informationProviderOfTradeItem>
<informationProvider>
<gln>0012345000065</gln>
</informationProvider>
<nameOfInformationProvider>ACME
Drinks</nameOfInformationProvider>
</informationProviderOfTradeItem>
<paymentTerms paymentTermsType="BASIC_(NET)"
paymentTermsEvent="ANTICIPATED_DELIVERY_DATE">
<netPayment>
<paymentTimePeriod>
<timePeriodDue timePeriod="DAYS">
<value>30</value>
</timePeriodDue>
</paymentTimePeriod>
</netPayment>
<installmentDue>
<percentOfPaymentDue>3.14</percentOfPaymentDue>
<paymentTimePeriod>
<timePeriodDue timePeriod="DAYS">
<value>30</value>
</timePeriodDue>
</paymentTimePeriod>
</installmentDue>
<discountPayment discountType="PRE">
<discountDescription>
<description language="EN">
<text>Discounted to preferred customers.</text>
</description>
</discountDescription>
<paymentTimePeriod>
<timePeriodDue timePeriod="DAYS">
<value>30</value>
</timePeriodDue>
</paymentTimePeriod>
</discountPayment>
<proximoCutOffDay>
<value>30</value>
</proximoCutOffDay>
</paymentTerms>
<targetMarketInformation>
<targetMarketCountryCode>123</targetMarketCountryCode>
<targetMarketDescription language="EN">
<text>France, Auvergne</text>
</targetMarketDescription>

<targetMarketSubdivisionCode>ABCDEFG</targetMarketSubdivisionCode>
</targetMarketInformation>
<classificationCategoryCode>
<classificationCategoryCode>1000222</classificationCategoryCode>
<classificationCategoryDefinition>Includes any products that can
be non-perishable, carbonated beverages that has
etc...</classificationCategoryDefinition>
<classificationCategoryName>Juice Drinks
(perishable)</classificationCategoryName>
<eANUCCTradeItemClassification>

<eANUCCClassificationAttributeTypeCode>20000345</eANUCCClassificationAttribu
teTypeCode>
<eANUCCClassificationAttributeTypeName>Carbonated non alcoholic
beverage</eANUCCClassificationAttributeTypeName>
<eANUCCClassificationAttributeTypeDefinition>Includes any
product that can be described as non-perishable, carbonated beverages that
has etc...</eANUCCClassificationAttributeTypeDefinition>
<eANUCCTradeItemClassificationValue>

<eANUCCClassificationAttributeValueCode>155</eANUCCClassificationAttributeVa
lueCode>

<eANUCCClassificationAttributeValueName>Drinks</eANUCCClassificationAttribut
eValueName>
</eANUCCTradeItemClassificationValue>
</eANUCCTradeItemClassification>
</classificationCategoryCode>
<tradeItemDescriptionInformation>
<brandName>Yummy-Cola</brandName>
<descriptionShort>
<description language="EN">
<text>Liters</text>
</description>
</descriptionShort>
<functionalName>
<description language="EN">
<text>Drink</text>
</description>
</functionalName>
<tradeItemDescription>
<longDescription language="EN">
<longText>Yummy-Cola Classic Diet</longText>
</longDescription>
</tradeItemDescription>
<additionalTradeItemDescription>
<longDescription language="EN">
<longText>Yummy-Cola Lemon scented big size</longText>
</longDescription>
</additionalTradeItemDescription>
<invoiceName>
<description language="EN">
<text>Yummy-Cola Classic Diet</text>
</description>
</invoiceName>
<productRange>Waist Watchers</productRange>
<subBrand>Classic</subBrand>

<tradeItemGroupIdentificationCode>033200011101</tradeItemGroupIdentification
Code>
<tradeItemGroupIdentificationDescription>
<description language="EN">
<text>Yummy-Cola Classic</text>
</description>
</tradeItemGroupIdentificationDescription>
<tradeItemFormDescription>Liquid</tradeItemFormDescription>
<variant>
<description language="EN">
<text>Lemon</text>
</description>
</variant>
</tradeItemDescriptionInformation>
<tradingPartnerNeutralTradeItemInformation>
<tradeItemUnitIndicator>
<isTradeItemABaseUnit>1</isTradeItemABaseUnit>
<isTradeItemAConsumerUnit>1</isTradeItemAConsumerUnit>
<isTradeItemADespatchUnit>0</isTradeItemADespatchUnit>
<isTradeItemAnInvoiceUnit>0</isTradeItemAnInvoiceUnit>
<isTradeItemAnOrderableUnit>0</isTradeItemAnOrderableUnit>
<isTradeItemAVariableUnit>0</isTradeItemAVariableUnit>
</tradeItemUnitIndicator>
<barCodeType>RSS_14_STACKED_OMNIDIRECTIONAL</barCodeType>
<brandOwnerOfTradeItem>
<brandOwner>
<gln>0012345000065</gln>
</brandOwner>
<nameOfBrandOwner>ACME Drinks</nameOfBrandOwner>
</brandOwnerOfTradeItem>
<manufacturerOfTradeItem>
<manufacturer>
<gln>0012345000065</gln>
</manufacturer>
<nameOfManufacturer>ACME Drinks</nameOfManufacturer>
</manufacturerOfTradeItem>
<materialSafetyData>

<materialSafetyDataSheetNumber>ag34784</materialSafetyDataSheetNumber>
</materialSafetyData>
<organicTradeItemCharacteristics>
<organicClaimAgency>XYX Agency</organicClaimAgency>
<organicTradeItemCode>05</organicTradeItemCode>
</organicTradeItemCharacteristics>
<packagingMarking>
<isPackagingMarkedAsRecyclable>1</isPackagingMarkedAsRecyclable>
<isPackagingMarkedReturnable>0</isPackagingMarkedReturnable>

<isPackagingMarkedWithExpirationDate>1</isPackagingMarkedWithExpirationDate>
<isPackagingMarkedWithGreenDot>1</isPackagingMarkedWithGreenDot>

<isPackagingMarkedWithIngredients>1</isPackagingMarkedWithIngredients>
</packagingMarking>
<packagingMaterial>
<packagingMaterialCode>GL</packagingMaterialCode>

<packagingMaterialCodeListMaintenanceAgency>String</packagingMaterialCodeLis
tMaintenanceAgency>
<packagingMaterialCompositionQuantity>
<measurementValue unitOfMeasure="g">15</measurementValue>
</packagingMaterialCompositionQuantity>
<packagingMaterialDescription>
<description language="EN">
<text>Glass</text>
</description>
</packagingMaterialDescription>
<packagingTermsAndCondition>707</packagingTermsAndCondition>
</packagingMaterial>
<packagingType>
<packagingTypeCode>123</packagingTypeCode>
<packagingTypeDescription>Bottle</packagingTypeDescription>
</packagingType>
<priceOnTradeItem>
<retailPriceOnTradeItem
currencyISOCode="EUR">36</retailPriceOnTradeItem>
</priceOnTradeItem>
<tradeItemColorDescription>
<colorCodeListAgency>PTO</colorCodeListAgency>
<colorCodeValue>PMS</colorCodeValue>
<colorDescription>
<description language="EN">
<text>Dark burgandy</text>
</description>
</colorDescription>
</tradeItemColorDescription>
<tradeItemCountryOfOrigin>
<countryOfOrigin>CA</countryOfOrigin>
</tradeItemCountryOfOrigin>
<tradeItemCoupon>
<couponFamilyCode>513</couponFamilyCode>
</tradeItemCoupon>
<tradeItemDateInformation>
<effectiveDate>2003-01-10</effectiveDate>
<lastChangeDateTime>2002-11-20T12:00:00</lastChangeDateTime>
<publicationDate>2003-01-10</publicationDate>

<startAvailabilityDateTime>2003-01-15T12:00:00</startAvailabilityDateTime>
<canceledDate>2002-10-05</canceledDate>

<consumerAvailabilityDateTime>2001-12-17T09:30:47-05:00</consumerAvailabilit
yDateTime>
<discontinuedDate>2003-12-18</discontinuedDate>

<endAvailabilityDateTime>2003-12-15T12:00:00</endAvailabilityDateTime>
</tradeItemDateInformation>
<tradeItemHandlingInformation>
<handlingInstructionsCode>
<description language="EN">
<text>DFN</text>
</description>
</handlingInstructionsCode>

<minimumTradeItemLifespanFromTimeOfArrival>35</minimumTradeItemLifespanFromT
imeOfArrival>
<stackingFactor>2</stackingFactor>
<stackingWeightMaximum>
<measurementValue unitOfMeasure="kg">500</measurementValue>
</stackingWeightMaximum>
</tradeItemHandlingInformation>
<tradeItemHierarchy>

<quantityOfCompleteLayersContainedInATradeItem>3</quantityOfCompleteLayersCo
ntainedInATradeItem>
<quantityOfLayersPerPallet>5</quantityOfLayersPerPallet>

<quantityOfTradeItemsContainedInACompleteLayer>20</quantityOfTradeItemsConta
inedInACompleteLayer>

<quantityOfTradeItemsPerPallet>100</quantityOfTradeItemsPerPallet>

<quantityOfTradeItemsPerPalletLayer>20</quantityOfTradeItemsPerPalletLayer>
<quantityOfInnerPack>2</quantityOfInnerPack>

<quantityOfNextLevelTradeItemWithinInnerPack>6</quantityOfNextLevelTradeItem
WithinInnerPack>
</tradeItemHierarchy>
<tradeItemMarking>
<hasBatchNumber>1</hasBatchNumber>
<isNonSoldTradeItemReturnable>1</isNonSoldTradeItemReturnable>
<isTradeItemMarkedAsRecyclable>1</isTradeItemMarkedAsRecyclable>
</tradeItemMarking>
<tradeItemMeasurements>
<depth>
<measurementValue unitOfMeasure="cm">10.2</measurementValue>
</depth>
<grossWeight>
<measurementValue unitOfMeasure="lb">800</measurementValue>
</grossWeight>
<height>
<measurementValue unitOfMeasure="cm">25</measurementValue>
</height>

<isNetContentDeclarationIndicated>0</isNetContentDeclarationIndicated>
<width>
<measurementValue unitOfMeasure="cm">18</measurementValue>
</width>
<diameter>
<measurementValue unitOfMeasure="cm">50.6</measurementValue>
</diameter>
<drainedWeight>
<measurementValue unitOfMeasure="g">225</measurementValue>
</drainedWeight>
<genericIngredient>Paracetamol</genericIngredient>
<genericIngredientStrength>
<measurementValue unitOfMeasure="mg">15</measurementValue>
</genericIngredientStrength>
<ingredientStrength>15 mg</ingredientStrength>
<netWeight>
<measurementValue unitOfMeasure="lb">300</measurementValue>
</netWeight>
<pegHorizontal>
<measurementValue unitOfMeasure="cm">17</measurementValue>
</pegHorizontal>
<pegVertical>
<measurementValue unitOfMeasure="cm">15</measurementValue>
</pegVertical>
</tradeItemMeasurements>
<tradeItemOrderInformation>
<orderingLeadTime unitOfMeasure="d">3</orderingLeadTime>
<orderQuantityMaximum>5000</orderQuantityMaximum>
<orderQuantityMinimum>2500</orderQuantityMinimum>
<orderQuantityMultiple>100</orderQuantityMultiple>
<orderSizingFactor>
<measurementValue unitOfMeasure="cm">15</measurementValue>
</orderSizingFactor>
</tradeItemOrderInformation>
<tradeItemPalletInformation>
<palletTypeCode>201</palletTypeCode>
<palletTermsAndConditions>7E</palletTermsAndConditions>
</tradeItemPalletInformation>
<cataloguePrice>
<effectiveStartDate>2002-11-15</effectiveStartDate>
<value currencyISOCode="EUR">350</value>
<effectiveEndDate>2003-06-15</effectiveEndDate>
</cataloguePrice>
<suggestedRetailPrice>
<effectiveStartDate>2002-11-15</effectiveStartDate>
<value currencyISOCode="USD">280</value>
<effectiveEndDate>2003-06-15</effectiveEndDate>
</suggestedRetailPrice>
<tradeItemSizeDescription>
<sizeCodeListAgency>EDI</sizeCodeListAgency>
<sizeCodeValue>36X</sizeCodeValue>
<descriptiveSize language="EN">
<text>Maxi</text>
</descriptiveSize>
</tradeItemSizeDescription>
<tradeItemTaxInformation>
<tradeItemTaxAmount>
<taxAmount currencyISOCode="USD">6</taxAmount>
<taxAgency>
<taxAgencyCode>X1</taxAgencyCode>
<taxTypeCode>21233403910392</taxTypeCode>
<taxTypeDescription>VAT</taxTypeDescription>
</taxAgency>
</tradeItemTaxAmount>
</tradeItemTaxInformation>
<tradeItemTemperatureInformation>
<deliveryToDistributionCenterTemperatureMaximum>
<measurementValue unitOfMeasure="FAH">60</measurementValue>
</deliveryToDistributionCenterTemperatureMaximum>
<deliveryToDistributionCenterTemperatureMinimum>
<measurementValue unitOfMeasure="FAH">54</measurementValue>
</deliveryToDistributionCenterTemperatureMinimum>
<deliveryToMarketTemperatureMaximum>
<measurementValue unitOfMeasure="FAH">60</measurementValue>
</deliveryToMarketTemperatureMaximum>
<deliveryToMarketTemperatureMinimum>
<measurementValue unitOfMeasure="FAH">54</measurementValue>
</deliveryToMarketTemperatureMinimum>
<storageHandlingTemperatureMaximum>
<measurementValue unitOfMeasure="FAH">60</measurementValue>
</storageHandlingTemperatureMaximum>
<storageHandlingTemperatureMinimum>
<measurementValue unitOfMeasure="FAH">54</measurementValue>
</storageHandlingTemperatureMinimum>
</tradeItemTemperatureInformation>
</tradingPartnerNeutralTradeItemInformation>
</tradeItemInformation>
</tradeItem>
<sourceDataPool>0712345000002</sourceDataPool>
</catalogueItem>
<catalogueItemNotificationIdentification>
<uniqueCreatorIdentification>CIN-12345</uniqueCreatorIdentification>
<contentOwner>
<gln>0012345000003</gln>
</contentOwner>
</catalogueItemNotificationIdentification>
</eanucc:catalogueItemNotification>
</documentCommandOperand>
</eanucc:documentCommand>
</command>
</eanucc:transaction>
</body>
</eanucc:envelope>
 
S

S.Y.M. Wong-A-Ton

Hi,

I'm not sure what the problem is that you described, since I was able to
successfully create a new InfoPath form ("New from xml document or schema..."
option) based on the XML you posted. The only error message I got was that of
a missing schema.

Regards,
S.Y.M. Wong-A-Ton
 
A

Ankit Tyagi

R u having Service Pack 2(SP2) of Office 2003 or Service Pack 1(SP1)?
Becuse on my system i am having SP1 and in my case i am able to create New
Infopath FORMS(multiple forms) because of subroots in the main root and what
i want is one single FORM.
But now what i am going to do is , i am going to use the schema file and
from that i will be creating the detail form, whose link can be provided on
the main form.
Now my main job is to place a LINK on the main form.
I hope that i will be able to do that.
Thanks for ur precious help.
This was for first time i was using the microsoft newsgroup and i am really
influenced by the group and i will try to contribute effectively to the
group people wherever i can.

Thanks &
Regards

Ankit
 
S

S.Y.M. Wong-A-Ton

I have Office 2003 SP2 installed. Maybe that's the reason for not being able
to reproduce your problem. It still sounds like a strange problem, though. Oh
well, it was a pleasure trying to help you and good luck with your endeavours.

Regards,
S.Y.M. Wong-A-Ton
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

multiple forms data on one form 0
InfoPath 2003 unable to add XML file as secondary source 0
Adding data to MS Access from csv file 0
multiple forms data on one form 1
Is it Possible to create Infopath forms from existing XML and XSD 3
Synchronization problems while moving folders to new email 1
2 or more XMl files as a data source? 1
Editing Infopath Form Programatically 1

Top