Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It only takes a minute to sign up.
Sign up to join this community
How to get a list of attributes in FME when there are no records in the table?
I try use a PythonCaller but when there are no records, FME passes over this table.
In PythonCaller I write:
import fmeobjects
def FeatureProcessor(feature):
print feature.getAllAttributeNames()
Is it possible to get attributes when there is no record?
This may possibly do what you want.
After your oracle reader, put in a NullAttributeReplacer factory. Connect the reader to that factory. Also put in a Creator factory and connect that to the NullAttributeReplacer factory. Replace all NULLs with 0.
So that any features that may come from the table do not get NULLs replaced, disable the connection between it and the NullAttributeReplacer. It still needs to be in place so that the NULL replacer knows what attributes to use.
This guarantees that at least a single feature goes through with all the attributes and should be discoverable by pythons getAllAttributeNames. That feature can then be thrown away.
For FME2014 using the NullAttributeMapper You will need to ensure that you are using Selected Attributes and the ones you want to appear are selected.
For the first condition make sure that Missing is selected.
The Map To: value can be anything other than Missing.
Logger_LOGGED' Attribute(32 bit unsigned integer): _creation_instance' has value 0' Attribute(string) : fme_feature_type' has value Creator' Attribute(string) : fme_geometry' has value fme_undefined' Attribute(string) : fme_type' has value fme_no_geom' Coordinate System: ' Geometry Type: IFMENull ============================
An alternative approach is to use the fmeObjects.FMEUniversalReader() as follows:
First point it to the workspace by invoking the .open() and including the dataset name. Next, use readSchema() which returns a feature-looking result for each workspace element.
(Its odd, but you get a feature that represents the schema of the featureclass.)
Finally, loop through the readSchema() and parse out the attribute names for each new workspace element. You explained that you want a 'list' so outputting them into XML or other context seems appropriate.
Sometimes, the simpler answers are most effective...please give FMEUniversalReader.readSchema() a try.
FME 2014 NullAttributeMapper
For the specified attributes, check the value of the attribute in the input feature and if it is one of the specified values, take the action specified by the Map To parameter. Values that can be matched are:
Empty – The attribute exists and has an empty string as its value.
Null – The attribute exists and has a value of null.
Missing (Selected Attributes Only) – The attribute does not exist. This choice does not apply if the Map parameter is set to All Attributes. We can only know that an attribute is missing if it has been explicitly specified through the Selected Attributes parameter.
http://docs.safe.com/fme/html/FME_Transformers/Default.htm#Transformers/nullattributemapper.htm
Example: http://fme-memorandum-takashi.blogspot.com/2014/01/nullattributemapper-use-case-assign.html
