We are trying to extract the feature_classes metadata and save it as csv. With the help of this code we are extracting Abstract, Title, Purpose, Spatial Ref, Extent without any hiccups. But in addition to that we need "Lineage" info and i don't see any lineage info in xml files converted using "ARCGIS2FGDC.xml" translator. But lineage details are getting exported when ARCGIS2ISO19139.xml translator is used. The problem is, i couldn't able to extract any of the details (Abstract, Lineage, Title etc..) from the output xml translated using ARCGIS2ISO19139.xml. This is the code i am using import os import arcpy import csv from xml . etree . ElementTree import ElementTree from arcpy import env arcpy . env . overwriteOutput = True def inventory_data ( workspace , datatypes ) : for path , path_names , data_names in arcpy . da . Walk ( workspace , datatype = datatypes ) : for data_name in data_names : yield os . path . join ( path , data_name ) AGSHOME = arcpy . GetInstallInfo ( "Desktop" ) [ "InstallDir" ] translatorpath = AGSHOME + "Metadata\\Translator\\ARCGIS2ISO19139.xml" #These two variables need to be updated each time this script is run on a new workspace outfile = r "D:\QAQC\Metadata\GIS_Data_Inventory.csv" xmlfile = r "D:\QAQC\Metadata\GIS_Data_Inventory.xml" with open ( outfile , 'wb' ) as csvfile : csvwriter = csv . writer ( csvfile ) #You need to update workspace in the line below for feature_class in inventory_data ( r "D:\QAQC\Metadata\Test" , "FeatureClass" ) : try : desc = arcpy . Describe ( feature_class ) sr = desc . spatialReference arcpy . ExportMetadata_conversion ( feature_class , translatorpath , xmlfile ) tree = ElementTree ( ) tree . parse ( xmlfile ) try : title = tree . find ( "identificationInfo/MD_DataIdentification/citation/CI_Citation/title" ) . text except : title = "No Title" try : abstract = tree . find ( "identificationInfo/MD_DataIdentification/abstract" ) . text except : abstract = "No Abstract" try : lineage = tree . find ( "dataQualityInfo/DQ_DataQuality/lineage/LI_Lineage/statement" ) . text except : lineage = "No Lineage" csvwriter . writerow ( [ desc . path . encode ( 'utf-8' ) , desc . file . encode ( 'utf-8' ) , desc . dataType . encode ( 'utf-8' ) , sr . name . encode ( 'utf-8' ) , purpose . encode ( 'utf-8' ) , title . encode ( 'utf-8' ) , abstract . encode ( 'utf-8' ) ] ) except Exception : e = sys . exc_info ( ) [ 1 ] print ( e . args [ 0 ] ) All i am getting in the output csv is "No Title, No Abstract, No Lineage". But the output xml file has these parameters (image attached below).

It may be easier to find out what's wrong if you don't just silently pass errors, but report what the error was (for debugging purposes): try : title = tree . find ( "identificationInfo/MD_DataIdentification/citation/CI_Citation/title" ) . text except Exception as msg : print ( "Error parsing for {}:" . format ( feature_class ) ) print ( str ( msg ) ) title = "No Title"

I don't use "import csv" , but I'm wondering if you need to close you csv file. Here is a sample of how I write to a csv file, including added a header record first. This does an inventory on feature classes, but is similar to your code. As Dan mentioned, make sure to format you code in the future. It is hard for others to debug since python spacing is critical for looping, etc. My close statement is on line 51 below # snippet of writing to csv file...this inventories feature classes import arcpy import os theWorkspace = r "c:\__temp" outFile = "FCInventory" outFileCSV = os . path . join ( theWorkspace , ( "{0}.csv" . format ( outFile ) ) ) csvFile = open ( outFileCSV , 'w' ) # my headers csvFile . write ( "FType, FCname, recCount, FullPath\n" ) def inventory_data ( workspace , datatypes ) : for path , path_names , data_names in arcpy . da . Walk ( workspace , datatype = datatypes ) : if "tic" in data_names : data_names . remove ( 'tic' ) for data_name in data_names : fcName = os . path . join ( path , data_name ) #print("Show for debug: " + fcName) if not arcpy . Exists ( fcName ) : # workaround for raster folder name duplicating fcName = os . path . dirname ( fcName ) desc = arcpy . Describe ( fcName ) count = arcpy . GetCount_management ( fcName ) . getOutput ( 0 ) #print("debug, desc it to me: " + desc.dataType) yield [ path , data_name , desc . dataType , count ] #, desc] i = 0 for feature_class in inventory_data ( theWorkspace , "FeatureClass" ) : if i == 0 : print ( "{0}" . format ( feature_class [ 0 ] ) ) #print(' ' + feature_class[0]) outText = ( " {0}\n" . format ( feature_class [ 0 ] ) ) # ' ' + feature_class[0] + '\n' path0 = feature_class [ 0 ] i = + 1 elif not path0 == feature_class [ 0 ] : print ( ' ' + feature_class [ 0 ] ) outText = ' ' + feature_class [ 0 ] + '\n' i = 0 print ( " " + feature_class [ 2 ] + ": " + feature_class [ 1 ] ) outText = ( " " + feature_class [ 2 ] + ": " + feature_class [ 1 ] + '\n' ) csvFile . write ( "{0},{1},{2},{3}\n" . format ( feature_class [ 2 ] , feature_class [ 1 ] , feature_class [ 3 ] , feature_class [ 0 ] ) ) #csvFile.write("{},{}, {}\n".format(feature_class[2], feature_class[1], feature_class[0])) csvFile . close ( ) print ( "File {0} is closed? {1}" . format ( outFileCSV , str ( csvFile . closed ) ) ) print ( '!!! Success !!! ' )

nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

How to extract metadata of feature classes and save it as a csv, using ISO19139 translator in ArcGIS environment ?

saravanaganesh

We are trying to extract the feature_classes metadata and save it as csv. With the help of this code we are extracting Abstract, Title, Purpose, Spatial Ref, Extent without any hiccups. But in addition to that we need "Lineage" info and i don't see any lineage info in xml files converted using "ARCGIS2FGDC.xml" translator. But lineage details are getting exported when ARCGIS2ISO19139.xml translator is used.

The problem is, i couldn't able to extract any of the details (Abstract, Lineage, Title etc..) from the output xml translated using ARCGIS2ISO19139.xml. This is the code i am using

<SPAN class="keyword token">import</SPAN> os
<SPAN class="keyword token">import</SPAN> arcpy
<SPAN class="keyword token">import</SPAN> csv
<SPAN class="keyword token">from</SPAN> xml<SPAN class="punctuation token">.</SPAN>etree<SPAN class="punctuation token">.</SPAN>ElementTree <SPAN class="keyword token">import</SPAN> ElementTree
<SPAN class="keyword token">from</SPAN> arcpy <SPAN class="keyword token">import</SPAN> env

arcpy<SPAN class="punctuation token">.</SPAN>env<SPAN class="punctuation token">.</SPAN>overwriteOutput <SPAN class="operator token">=</SPAN> <SPAN class="token boolean">True</SPAN>
 
<SPAN class="keyword token">def</SPAN> <SPAN class="token function">inventory_data</SPAN><SPAN class="punctuation token">(</SPAN>workspace<SPAN class="punctuation token">,</SPAN> datatypes<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">for</SPAN> path<SPAN class="punctuation token">,</SPAN> path_names<SPAN class="punctuation token">,</SPAN> data_names <SPAN class="keyword token">in</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>da<SPAN class="punctuation token">.</SPAN>Walk<SPAN class="punctuation token">(</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; workspace<SPAN class="punctuation token">,</SPAN> datatype<SPAN class="operator token">=</SPAN>datatypes<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">for</SPAN> data_name <SPAN class="keyword token">in</SPAN> data_names<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">yield</SPAN> os<SPAN class="punctuation token">.</SPAN>path<SPAN class="punctuation token">.</SPAN>join<SPAN class="punctuation token">(</SPAN>path<SPAN class="punctuation token">,</SPAN> data_name<SPAN class="punctuation token">)</SPAN>

AGSHOME <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>GetInstallInfo<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"Desktop"</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="string token">"InstallDir"</SPAN><SPAN class="punctuation token">]</SPAN>&nbsp; 
translatorpath <SPAN class="operator token">=</SPAN> AGSHOME <SPAN class="operator token">+</SPAN> <SPAN class="string token">"Metadata\\Translator\\ARCGIS2ISO19139.xml"</SPAN>

<SPAN class="comment token">#These two variables need to be updated each time this script is run on a new workspace</SPAN>
outfile <SPAN class="operator token">=</SPAN> r<SPAN class="string token">"D:\QAQC\Metadata\GIS_Data_Inventory.csv"</SPAN>
xmlfile <SPAN class="operator token">=</SPAN> r<SPAN class="string token">"D:\QAQC\Metadata\GIS_Data_Inventory.xml"</SPAN>

<SPAN class="keyword token">with</SPAN> open <SPAN class="punctuation token">(</SPAN>outfile<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'wb'</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="keyword token">as</SPAN> csvfile<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; csvwriter <SPAN class="operator token">=</SPAN> csv<SPAN class="punctuation token">.</SPAN>writer<SPAN class="punctuation token">(</SPAN>csvfile<SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="comment token">#You need to update workspace in the line below</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">for</SPAN> feature_class <SPAN class="keyword token">in</SPAN> inventory_data<SPAN class="punctuation token">(</SPAN>r<SPAN class="string token">"D:\QAQC\Metadata\Test"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"FeatureClass"</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">try</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; desc <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>Describe<SPAN class="punctuation token">(</SPAN>feature_class<SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; sr <SPAN class="operator token">=</SPAN> desc<SPAN class="punctuation token">.</SPAN>spatialReference
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; arcpy<SPAN class="punctuation token">.</SPAN>ExportMetadata_conversion<SPAN class="punctuation token">(</SPAN>feature_class<SPAN class="punctuation token">,</SPAN> translatorpath<SPAN class="punctuation token">,</SPAN> xmlfile<SPAN class="punctuation token">)</SPAN>&nbsp; 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; tree <SPAN class="operator token">=</SPAN> ElementTree<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN>&nbsp; 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; tree<SPAN class="punctuation token">.</SPAN>parse<SPAN class="punctuation token">(</SPAN>xmlfile<SPAN class="punctuation token">)</SPAN>&nbsp;&nbsp; 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">try</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; title <SPAN class="operator token">=</SPAN> tree<SPAN class="punctuation token">.</SPAN>find <SPAN class="punctuation token">(</SPAN><SPAN class="string token">"identificationInfo/MD_DataIdentification/citation/CI_Citation/title"</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">.</SPAN>text
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">except</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; title <SPAN class="operator token">=</SPAN> <SPAN class="string token">"No Title"</SPAN>

&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">try</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; abstract <SPAN class="operator token">=</SPAN> tree<SPAN class="punctuation token">.</SPAN>find <SPAN class="punctuation token">(</SPAN><SPAN class="string token">"identificationInfo/MD_DataIdentification/abstract"</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">.</SPAN>text
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">except</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; abstract <SPAN class="operator token">=</SPAN> <SPAN class="string token">"No Abstract"</SPAN>

&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">try</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; lineage <SPAN class="operator token">=</SPAN> tree<SPAN class="punctuation token">.</SPAN>find <SPAN class="punctuation token">(</SPAN><SPAN class="string token">"dataQualityInfo/DQ_DataQuality/lineage/LI_Lineage/statement"</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">.</SPAN>text
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">except</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; lineage <SPAN class="operator token">=</SPAN> <SPAN class="string token">"No Lineage"</SPAN>

&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; csvwriter<SPAN class="punctuation token">.</SPAN>writerow<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">[</SPAN>desc<SPAN class="punctuation token">.</SPAN>path<SPAN class="punctuation token">.</SPAN>encode<SPAN class="punctuation token">(</SPAN><SPAN class="string token">'utf-8'</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">,</SPAN> desc<SPAN class="punctuation token">.</SPAN>file<SPAN class="punctuation token">.</SPAN>encode<SPAN class="punctuation token">(</SPAN><SPAN class="string token">'utf-8'</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">,</SPAN> desc<SPAN class="punctuation token">.</SPAN>dataType<SPAN class="punctuation token">.</SPAN>encode<SPAN class="punctuation token">(</SPAN><SPAN class="string token">'utf-8'</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">,</SPAN> sr<SPAN class="punctuation token">.</SPAN>name<SPAN class="punctuation token">.</SPAN>encode<SPAN class="punctuation token">(</SPAN><SPAN class="string token">'utf-8'</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">,</SPAN> purpose<SPAN class="punctuation token">.</SPAN>encode<SPAN class="punctuation token">(</SPAN><SPAN class="string token">'utf-8'</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">,</SPAN> title<SPAN class="punctuation token">.</SPAN>encode<SPAN class="punctuation token">(</SPAN><SPAN class="string token">'utf-8'</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">,</SPAN> abstract<SPAN class="punctuation token">.</SPAN>encode<SPAN class="punctuation token">(</SPAN><SPAN class="string token">'utf-8'</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN>

&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">except</SPAN> Exception<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; e <SPAN class="operator token">=</SPAN> sys<SPAN class="punctuation token">.</SPAN>exc_info<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">]</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">print</SPAN><SPAN class="punctuation token">(</SPAN>e<SPAN class="punctuation token">.</SPAN>args<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN>‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

<SPAN class="" style="color: #303336; border: 0px; font-size: 13px; margin: 0px;"><SPAN style="color: #242729; background-color: rgba(248, 248, 248, 0.6);">All i am getting in the output csv is "No Title, No Abstract, No Lineage". But the output xml file has these parameters (image attached below).</SPAN>
<IMG __jive_id="296563" alt="" class="image-1 jive-image" src="https://us.v-cdn.net/6038851/uploads/legacyfs/online/296563_T0CHM.png" style="width: 786px; height: 408px;" />
</SPAN>

Encuentra más publicaciones etiquetadas con

Accepted answers

All comments

curtvprice

Could you explain what you are trying to do here? Metadata is very complex structured data (for example, the lineage is a collection of objects (one or more), each that can have different properties). CSV by contrast is a simple text table.

Could you show what your goal is here, what your output text file should look like?

saravanaganesh

We have to QAQC 100's of feature_classes and one of the checks is to check the metadata description. So we are trying to extract Abstract, Title, Extent, Lineage Statement of the feature_classes and save it as a csv file, so that we can easily check the things using filter options in the csv(excel) sheet.

Using the ARCGIS2FGDC.xml tranlstor, we can't able to extract "Lineage -> Statement". But ISO19139.xml is doing the job. The problem is, the code i've mentioned in the question doesn;t extract any of the details. All we are getting is a empty csv file.

Output text should be like (w.r.t the image attached):

250K Spot height, Bolivia Borax Geographic rtzbolnew (SPOT39P), Extent details, Migrated from ________________ (Lineage Statement)

DanPatterson_Retired

perhaps you could format your code so that potential errors could examined... it would separate those from other problems /blogs/dan_patterson/2016/08/14/script-formatting

JamesCrandall

Do you get the same result when you run the Geoprocessing Toolbox? (note: I had the same nothing/no output result as you when I simply ran the existing GP tool from ArcCatalog).

bharold

Once you have sensible output from Export Metadata you could try the Data Interoperability extension to create CSV.

A free trial is available. You will probably need to inspect the structure of the XML to get the paths right. If you need help ask your account manager to assist.

RebeccaStrauch__GISP

I don't use "import csv" , but I'm wondering if you need to close you csv file. Here is a sample of how I write to a csv file, including added a header record first. This does an inventory on feature classes, but is similar to your code. As Dan mentioned, make sure to format you code in the future. It is hard for others to debug since python spacing is critical for looping, etc. My close statement is on line 51 below

<SPAN class="comment token"># snippet of writing to csv file...this inventories feature classes</SPAN>
<SPAN class="keyword token">import</SPAN> arcpy
<SPAN class="keyword token">import</SPAN> os


theWorkspace <SPAN class="operator token">=</SPAN> r<SPAN class="string token">"c:\__temp"</SPAN>
outFile <SPAN class="operator token">=</SPAN> <SPAN class="string token">"FCInventory"</SPAN>
outFileCSV <SPAN class="operator token">=</SPAN> os<SPAN class="punctuation token">.</SPAN>path<SPAN class="punctuation token">.</SPAN>join<SPAN class="punctuation token">(</SPAN>theWorkspace<SPAN class="punctuation token">,</SPAN> <SPAN class="punctuation token">(</SPAN><SPAN class="string token">"{0}.csv"</SPAN><SPAN class="punctuation token">.</SPAN>format<SPAN class="punctuation token">(</SPAN>outFile<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN>

csvFile <SPAN class="operator token">=</SPAN> open<SPAN class="punctuation token">(</SPAN>outFileCSV<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'w'</SPAN><SPAN class="punctuation token">)</SPAN>

<SPAN class="comment token"># my headers</SPAN>
csvFile<SPAN class="punctuation token">.</SPAN>write<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"FType, FCname, recCount, FullPath\n"</SPAN><SPAN class="punctuation token">)</SPAN>

<SPAN class="keyword token">def</SPAN> <SPAN class="token function">inventory_data</SPAN><SPAN class="punctuation token">(</SPAN>workspace<SPAN class="punctuation token">,</SPAN> datatypes<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<SPAN class="keyword token">for</SPAN> path<SPAN class="punctuation token">,</SPAN> path_names<SPAN class="punctuation token">,</SPAN> data_names <SPAN class="keyword token">in</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>da<SPAN class="punctuation token">.</SPAN>Walk<SPAN class="punctuation token">(</SPAN>
&nbsp;&nbsp;&nbsp; workspace<SPAN class="punctuation token">,</SPAN> datatype<SPAN class="operator token">=</SPAN>datatypes<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<SPAN class="keyword token">if</SPAN> <SPAN class="string token">"tic"</SPAN> <SPAN class="keyword token">in</SPAN> data_names<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;data_names<SPAN class="punctuation token">.</SPAN>remove<SPAN class="punctuation token">(</SPAN><SPAN class="string token">'tic'</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<SPAN class="keyword token">for</SPAN> data_name <SPAN class="keyword token">in</SPAN> data_names<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;fcName <SPAN class="operator token">=</SPAN> os<SPAN class="punctuation token">.</SPAN>path<SPAN class="punctuation token">.</SPAN>join<SPAN class="punctuation token">(</SPAN>path<SPAN class="punctuation token">,</SPAN> data_name<SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<SPAN class="comment token">#print("Show for debug: " + fcName)</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<SPAN class="keyword token">if</SPAN> <SPAN class="operator token">not</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>Exists<SPAN class="punctuation token">(</SPAN>fcName<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<SPAN class="comment token"># workaround for raster folder name duplicating</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;fcName <SPAN class="operator token">=</SPAN> os<SPAN class="punctuation token">.</SPAN>path<SPAN class="punctuation token">.</SPAN>dirname<SPAN class="punctuation token">(</SPAN>fcName<SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;desc <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>Describe<SPAN class="punctuation token">(</SPAN>fcName<SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;count <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>GetCount_management<SPAN class="punctuation token">(</SPAN>fcName<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">.</SPAN>getOutput<SPAN class="punctuation token">(</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">)</SPAN>&nbsp; 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<SPAN class="comment token">#print("debug, desc it to me: " + desc.dataType)</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<SPAN class="keyword token">yield</SPAN> <SPAN class="punctuation token">[</SPAN>path<SPAN class="punctuation token">,</SPAN> data_name<SPAN class="punctuation token">,</SPAN> desc<SPAN class="punctuation token">.</SPAN>dataType<SPAN class="punctuation token">,</SPAN> count<SPAN class="punctuation token">]</SPAN> <SPAN class="comment token">#, desc]</SPAN>

i <SPAN class="operator token">=</SPAN> <SPAN class="number token">0</SPAN>
<SPAN class="keyword token">for</SPAN> feature_class <SPAN class="keyword token">in</SPAN> inventory_data<SPAN class="punctuation token">(</SPAN>theWorkspace<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"FeatureClass"</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<SPAN class="keyword token">if</SPAN> i <SPAN class="operator token">==</SPAN> <SPAN class="number token">0</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<SPAN class="keyword token">print</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">"{0}"</SPAN><SPAN class="punctuation token">.</SPAN>format<SPAN class="punctuation token">(</SPAN>feature_class<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN>&nbsp;&nbsp; <SPAN class="comment token">#print(' ' + feature_class[0])</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;outText <SPAN class="operator token">=</SPAN>&nbsp; <SPAN class="punctuation token">(</SPAN><SPAN class="string token">" {0}\n"</SPAN><SPAN class="punctuation token">.</SPAN>format<SPAN class="punctuation token">(</SPAN>feature_class<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN>&nbsp; <SPAN class="comment token">#&nbsp;&nbsp; ' ' + feature_class[0] + '\n'</SPAN>

&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;path0 <SPAN class="operator token">=</SPAN> feature_class<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;i <SPAN class="operator token">=</SPAN><SPAN class="operator token">+</SPAN> <SPAN class="number token">1</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<SPAN class="keyword token">elif</SPAN> <SPAN class="operator token">not</SPAN> path0 <SPAN class="operator token">==</SPAN> feature_class<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<SPAN class="keyword token">print</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">' '</SPAN> <SPAN class="operator token">+</SPAN> feature_class<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;outText <SPAN class="operator token">=</SPAN> <SPAN class="string token">' '</SPAN> <SPAN class="operator token">+</SPAN> feature_class<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">+</SPAN> <SPAN class="string token">'\n'</SPAN>

&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;i <SPAN class="operator token">=</SPAN> <SPAN class="number token">0</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<SPAN class="keyword token">print</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">"&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "</SPAN> <SPAN class="operator token">+</SPAN> feature_class<SPAN class="punctuation token">[</SPAN><SPAN class="number token">2</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">+</SPAN> <SPAN class="string token">":&nbsp; "</SPAN> <SPAN class="operator token">+</SPAN> feature_class<SPAN class="punctuation token">[</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;outText <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">(</SPAN><SPAN class="string token">"&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "</SPAN> <SPAN class="operator token">+</SPAN> feature_class<SPAN class="punctuation token">[</SPAN><SPAN class="number token">2</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">+</SPAN> <SPAN class="string token">":&nbsp; "</SPAN> <SPAN class="operator token">+</SPAN> feature_class<SPAN class="punctuation token">[</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">+</SPAN> <SPAN class="string token">'\n'</SPAN><SPAN class="punctuation token">)</SPAN>

&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;csvFile<SPAN class="punctuation token">.</SPAN>write<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"{0},{1},{2},{3}\n"</SPAN><SPAN class="punctuation token">.</SPAN>format<SPAN class="punctuation token">(</SPAN>feature_class<SPAN class="punctuation token">[</SPAN><SPAN class="number token">2</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN> feature_class<SPAN class="punctuation token">[</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN> feature_class<SPAN class="punctuation token">[</SPAN><SPAN class="number token">3</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN> feature_class<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<SPAN class="comment token">#csvFile.write("{},{}, {}\n".format(feature_class[2], feature_class[1], feature_class[0]))</SPAN>


csvFile<SPAN class="punctuation token">.</SPAN>close<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN>

<SPAN class="keyword token">print</SPAN><SPAN class="punctuation token">(</SPAN>&nbsp; <SPAN class="string token">"File {0} is closed? {1}"</SPAN><SPAN class="punctuation token">.</SPAN>format<SPAN class="punctuation token">(</SPAN>outFileCSV<SPAN class="punctuation token">,</SPAN> str<SPAN class="punctuation token">(</SPAN>csvFile<SPAN class="punctuation token">.</SPAN>closed<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN>


<SPAN class="keyword token">print</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">'!!! Success !!!&nbsp; '</SPAN><SPAN class="punctuation token">)</SPAN>

<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

saravanaganesh

Done. Thanks for the link

curtvprice

It may be easier to find out what's wrong if you don't just silently pass errors, but report what the error was (for debugging purposes):

<SPAN class="keyword token">try</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; title <SPAN class="operator token">=</SPAN> tree<SPAN class="punctuation token">.</SPAN>find <SPAN class="punctuation token">(</SPAN><SPAN class="string token">"identificationInfo/MD_DataIdentification/citation/CI_Citation/title"</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">.</SPAN>text
<SPAN class="keyword token">except</SPAN> Exception <SPAN class="keyword token">as</SPAN> msg<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">print</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">"Error parsing for {}:"</SPAN><SPAN class="punctuation token">.</SPAN>format<SPAN class="punctuation token">(</SPAN>feature_class<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">print</SPAN><SPAN class="punctuation token">(</SPAN>str<SPAN class="punctuation token">(</SPAN>msg<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; title <SPAN class="operator token">=</SPAN> <SPAN class="string token">"No Title"</SPAN>‍‍‍‍‍‍‍‍‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

Únete a la Conversación

Los miembros registrados pueden publicar, seguir actualizaciones y más. ¿Nuevo aquí? Regístrate gratis.

Enlaces Rápidos

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.