Help

XML Data Import (XPath issue)

Topic Labels: Importing & Exporting
205 2
cancel
Showing results for 
Search instead for 
Did you mean: 
gleb_mikulich
4 - Data Explorer
4 - Data Explorer

I am trying to import XML file but keep getting invalid Xpath (I copy it from XML reader or I modify it based on the requirements) or no results (I am sure that file has 200+ opportunities). Any suggestions?

gleb_mikulich_0-1733417625697.png

<?xml version="1.0" encoding="UTF-8"?>
<Grants xsi:schemaLocation="http://apply.grants.gov/system/OpportunityDetail-V1.0 https://apply07.grants.gov/apply/system/schemas/OpportunityDetail-V1.0.xsd" xmlns="http://apply.grants.gov/system/OpportunityDetail-V1.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<OpportunitySynopsisDetail_1_0>
<OpportunityID>262148</OpportunityID>
<OpportunityTitle>Establishment of the Edmund S. Muskie Graduate Internship Program</OpportunityTitle>
<OpportunityNumber>SCAPPD-14-AW-161-SCA-08152014</OpportunityNumber>
<OpportunityCategory>D</OpportunityCategory>
<FundingInstrumentType>CA</FundingInstrumentType>
<CategoryOfFundingActivity>O</CategoryOfFundingActivity>
<CategoryExplanation>Public Diplomacy</CategoryExplanation>
<CFDANumbers>19.040</CFDANumbers>
<EligibleApplicants>25</EligibleApplicants>
<AdditionalInformationOnEligibility>Eligibility for U.S. institutions is limited to not-for-profit organizations subject to 501 (c) (3) of the tax code. </AdditionalInformationOnEligibility>
<AgencyCode>DOS-SA</AgencyCode>
<AgencyName>Bureau of South and Central Asian Affairs</AgencyName>
<PostDate>08152014</PostDate>
<CloseDate>09042014</CloseDate>
<LastUpdatedDate>08202014</LastUpdatedDate>
<AwardCeiling>600000</AwardCeiling>
<AwardFloor>400000</AwardFloor>
<EstimatedTotalProgramFunding>600000</EstimatedTotalProgramFunding>
<ExpectedNumberOfAwards>1</ExpectedNumberOfAwards>
<Description>The Office of Press and Public Diplomacy of the Bureau of South and Central Asian Affairs of the U.S. Department of State, in coordination with the Bureau of European and Eurasian Affairs and the Bureau of Education and Cultural Affairs, announces an open competition for a cooperative agreement to implement the Edmund S. Muskie Graduate Internship Program (herein referred to as the Muskie Internship Program). The Muskie Internship Program is designed to promote mutual understanding and foster democratization and the transition to market economies in Eurasia through intensive professional education. Through this program, 35-40 Muskie Interns will begin a four-month professional internship in the United States immediately upon the completion of their Fulbright Foreign Student Program. These internships provide an opportunity to further professional development, as well as reinforce skills gained during academic study.</Description>
<Version>Synopsis 2</Version>
<CostSharingOrMatchingRequirement>No</CostSharingOrMatchingRequirement>
<ArchiveDate>10042014</ArchiveDate>
<GrantorContactEmail>DelageEM@state.gov</GrantorContactEmail>
<GrantorContactEmailDescription>Inquiries</GrantorContactEmailDescription>
<GrantorContactText>Ellen Delage, Bureau of South and Central Asian Affairs, Office of Press and Public Diplomacy &amp;lt;br/&amp;gt;</GrantorContactText>
</OpportunitySynopsisDetail_1_0>
<OpportunitySynopsisDetail_1_0>
<OpportunityID>262149</OpportunityID>
<OpportunityTitle>Eradication of Yellow Crazy Ants on Johnston Atoll NWR</OpportunityTitle>
<OpportunityNumber>F14AS00402</OpportunityNumber>
<OpportunityCategory>D</OpportunityCategory>
<FundingInstrumentType>CA</FundingInstrumentType>
<CategoryOfFundingActivity>AG</CategoryOfFundingActivity>
<CategoryOfFundingActivity>ENV</CategoryOfFundingActivity>
<CategoryOfFundingActivity>NR</CategoryOfFundingActivity>
<CFDANumbers>15.608</CFDANumbers>
<EligibleApplicants>99</EligibleApplicants>
<AdditionalInformationOnEligibility>The recipient has already been selected for this award. Please see attached Notice of Intent to Award for specifics.</AdditionalInformationOnEligibility>
<AgencyCode>DOI-FWS</AgencyCode>
<AgencyName>Fish and Wildlife Service</AgencyName>
<PostDate>08152014</PostDate>
<CloseDate>08222014</CloseDate>
<LastUpdatedDate>08152014</LastUpdatedDate>
<AwardCeiling>0</AwardCeiling>
<AwardFloor>0</AwardFloor>
<EstimatedTotalProgramFunding>0</EstimatedTotalProgramFunding>
<Description>Funds under this award are to be used for the eradication of Yellow Crazy Ants from Johnston Atoll National Wildlife Refuge.</Description>
<Version>Synopsis 1</Version>
<CostSharingOrMatchingRequirement>No</CostSharingOrMatchingRequirement>
<ArchiveDate>08232014</ArchiveDate>
<AdditionalInformationURL>http://www.grants.gov/</AdditionalInformationURL>
<AdditionalInformationText>http://www.grants.gov/</AdditionalInformationText>
<GrantorContactEmail>Connie_Sauer@fws.gov</GrantorContactEmail>
<GrantorContactEmailDescription>Connie_Sauer@fws.gov </GrantorContactEmailDescription>
<GrantorContactText>Connie Sauer, 503-490-0827&amp;lt;br/&amp;gt;Connie_Sauer@fws.gov&amp;lt;br/&amp;gt;</GrantorContactText>
</OpportunitySynopsisDetail_1_0>

 

2 Replies 2

Hmm, I'm assuming you're using the XML Import extension?  Maybe try converting the XML into a CSV first to verify the number of rows, and if that looks good import the CSV?

Yes, I am using XML Import extension. 

I don't really like the idea about converting in CSV (XML file is a bit heavy and gets generated on daily basis), so I'd prefer to use XML Import.