Best Answers

Hello All,Is there a way in FME to transform the CSV table here below:into this:Thanks!

I am trying to use FME to create ArcGIS Online Feature Collections instead of Feature Services. I assume I need to write some Python script for it but wanted to see if anyone else had perfected this process.-Mark

I have a python shutdown script that works fine in FME Desktop but when I try to run it in FME Server it fails. The logs aren't showing me anything useful.I think the error may be due to my file path that I am trying to access. If I am trying to access a file via Python on the server, shouldn't I be using: r"//servername/directory/filename.cfg"?Or should I try something else?Thanks, Mark

Hi, trying to capture a 'payee' name from text attributes for each feature. The payee name always occurs on the line after 12 spaces. I use some software called Regex Buddy to build and test the regex so I know this works. However, when I plug the regex into StringSearcher in FME and put the same text into the test box, it doesn't work. There's a sample text file attached and the regex I'm using is at the bottom of the file. In this particular file I'm trying to pick up the words Hanover Housing Association. Any ideas anyone??ThanksJames

This seams rather easy but I'm not able to create is.Input: a lot of area features that are nicely touching each other (no overlaps nor gaps) (assume a 100 areas)output that I want: I want to have X clusters (to be defined by user) that contains 100/X areas and those areas are not intersecting with each other (see attached screenshot).The output can everytime be different as long as the areas in 1 cluster don't touch each other.ThanksVAT

We're trying to write data via "ArcSDE Geodb" writer in SDO_GEOMETRY format and make it readable for non-ESRI software. We're using ArcGIS for Desktop 10.3.1 on an ArcSDE 10.2.2 on Oracle 11g with FME Desktop 2015.1 (but the same problem apperas in different combinations of software versions as well).Our main problem is that in the oracle geometry metadata entries the axis-definition can't be set correctly no matter how we're trying it. SQL:select DIMINFO from user_sdo_geom_metadata WHERE TABLE_NAME = 'SDOTEST_FME_WRITERCRS';RESULT:MDSYS.SDO_DIM_ARRAY(MDSYS.SDO_DIM_ELEMENT(NULL,3447000,3467000,0.001),MDSYS.SDO_DIM_ELEMENT(NULL,5422000,5440000,0.001))As you can see, both axis are defined as "NULL" instead of "X" and "Y". Is there any way to tell the writer how to set this up correct?

I us a SQLEXEcutor in a workflow. The SQL statement - with an alias - is something like: SELECT   string_agg("History"."History_name", ';') AS lstHistory FROM   public."Pois_lines",   public."Pois_lines_history",   public."History" WHERE   "Pois_lines"."Pois_lines_id" = "Pois_lines_history"."Pois_id" AND  "Pois_lines_history"."History_id" = "History"."History_id" AND  "Pois_lines"."Pois_lines_id" = @Value("Pois_lines_id")In the last line I use a value of an attribute in the workflow. I want to pickup the value of the returned dataset and put it in an attribute. For that purpose I defined an alias, which name I define as an exposed attribute in the SQLExecutor. However the attribute remains empty .... The SQL statement is valid so it should return results. Am I overlooking something or doing something wrong?Kind re

I have an SDE Geodatabase (ArcObjects) data source and want to filter out all features with no name.I've used a tester with a test for 'has a value'.I've also tried testing for 'not null AND not emtpy string'I've also tried using a NullAttributeMapper and mapping Nulls to some value and testing for that.Whatever I do, 49 'Nulls' make it through to the output, even if I add more testers. Workspace obviously doesn't think these are Null/empty, but the inspector reports them as <null> after running the workspace.I can just manually delete these from my output later, but if anyone can shed some light on what is happening here, I'd appreciate it.I'm using Workbench 2016.1.1edit:if I query the oracle view in the geodatabaseselect name, road_type from PLAN.roads_src where name is not null order by name;I get a number of results with <NULL> for name.So it appears FME is doing exactly what it is asked. So I guess not an FME issue, but

I have a large KML file that I would like to split into several smaller equal size KML. My original KML file has 311,055 polygon records and is too large to open in Google Earth as is. I would like to create several sub files from this file (e.g. 5 KML files with 62,211 records each).

When I set a shapefile Reader , i found that it can only read the shapefiles which have the same Feature Type, but i want to load shapefiles with different Feature Type by one Shapefile Reader, how can i do ? By the way, i want to publish it to FMEServer, and i can read the shapefiles upload by website, which may have different Feature Type. How can i do??? Thanks!!

Hi, would you please help me to have these coordinates separately with their own attribute? Thanks in advance. photo is attached

Hey folks, I'm trying to accomplish a fairly simple thing, which is to create a workspace that can read, transform, and write different Spatialite files with different attributes. I'm pretty certain that I've been able to do this earlier with other formats, but I can't get it to work with this format. The problem is that when I add a Spatialite reader, selecting "Single merged feature type", the attritbutes from this file are read and added to the feature type. Then, if I change the file source to another Spatialite with a different set of attributes, i get the message SPATIALITE reader: Feature type 'natural' does not contain an attribute matching the schema attribute 'landuse', skipping attribute 'landuse'SPATIALITE reader: Feature type 'natural' does not contain an attribute matching the schema attribute 'leisure', skipping attribute 'leisure'SPATIALITE reader: Feature type 'natural' does not contain an attribute matching the schema attribute 'amenity', skipping attribute 'amenity'S

Hello Team,I would like to generate a PDF file and through the transformer PDFPageFormatter i setted the the Page Object:I would like to know if is possible the FME read my Source Data Polygon ( in meters ) and insert inside the above settings ( BoundingBox ) and calculate the scale automatic showing like a attribute.I saw the link https://knowledge.safe.com/articles/19757/creating-pdf-cartographic-output.html but the user choose the scale when run this Workspace.Thanks in Advance,

I want to extract information from a WFS service, but the WFS services has a limitations of 10.000 features. The WFS service is: http://afnemers.ruimtelijkeplannen.nl/afnemers2012/services?SERVICE=WFSThe number of features is around 40.000: http://afnemers.ruimtelijkeplannen.nl/afnemers2012/services?REQUEST=GetFeature&SERVICE;=WFS&version;=2.0.0&typename;=Bestemmingsplangebied&resulttype;=hitsSo I thought I could add multiple WFS readers to the workbench each with a different setting at the 'start feature' and 'max features to read' (see below)Parameters reader 1:Parameters reader 2However when I run the workbench the request is still limited to 10.000 features; as you can see in the screenshot below.Does anyone know how I can workaround this limitation?Another option would be to perform an attribute or spatial selection on the WFS reader, because I only need a selection of the features. For instance only the features where the attribute 'datum'

I used FeatureMerger to join two tables, but I didn't see any fields other than the KEY field were kept in the Mergered or Referenced ports. Is there a way to keep all Requestor's fields when using FeatrueMerger? Please help!

Hi there,I have a table with two columns: HEADERDATAHEADERDATAI need to write the information to a txt file which needs to be formatted as:HEADERDATAHEADERDATAThe headers are all unique. Any solution is fine - however would appreciate as much information as possible, esp if using Python. Thanks,Heather

Hi, I want to read only one Attribute(FGDB_ID) from a File Geodatabase with Python.The geometry is not required. The readout of the File Geodatebase works well, but no features are generated. The Attributes will be printed only in the log window, but no Features will be generated.How can I create features from the individual values?import fmeobjectsimport arcpy# Template Classclass FeatureCreator(object):    def __init__(self):        # Name der FC        fc = "\\\\path\\gdb.gdb\\GK_ANNO"        # Ergebnisliste        FGDB_ID = []        # ArcPy-Suchcursor erstellen und auf die entsprechende Spalte der FC        # ansetzen.        cursor = arcpy.SearchCursor(fc, "", "", "FGDB_ID")        # Spalte zeilenweise auslesen...        for row in cursor:        # ... und FGDB_ID an Ergebnisliste anhängen.            FGDB_ID.append(row.FGDB_ID)        #pprint(FGDB_ID)        for id in FGDB_ID:            print(id)        pass    def close(self):        feature = fmeobjects.FMEFeature()        se

Let's say I have a table like this:AttributeAAttributeBsome valuesome valuesome valuesome valuesome valuesome valuesome valueAnd I want to summarize how many nulls are in each column (attribute) of a table like this:AttributeA has 2 blanks / nulls.AttributeB has 1 blanks / nulls.What is the best way to count how many nulls are in a given column of a table?

HI, I want to join Table1 and Table2 and get Table3. should I use FeatureMerger or Joiner? both data sources are ESRI GDB tables. Table 1PropertyID100101Table 2TractIDPropertyID1000100100110110021001003102Table 3PropetyIDTractID100100010010021011001

I have a polygon shape file containing a few dozens of rows. How can I split the shape file into many shape files, each containing only one row?

HI, I have a table with a TractID field. The TractID field has duplicates. Can you please tell me which transformer can generate a list of distinct TractIDs? Thanks for your help!

Hello All, I have two tables like below. I want to know the difference (add, delete, unchanged) of the TractID field between these two tables. For instance, i want to have a output showing unchanged: 1001, 1003added: 1002, 1004, 1005deleted: 1009I didn't see the ChangeDetector transformer is able to compare two fields based on a string match. How to achieve this? I appreciate your help!Table 1 (old):IDTractID101001111003121009Table 2 (new):UniqueIDTractID1100121002,1003,100431005,1006

Hello All FME Users,I have a workspace and the KML generate a attribute above the icon ( i dont want this schow this attribute ):My Workspace has a transformer KMLPropertySetter.Attached my template file.Thanks in Advance, 

So I have multiple AttributeValidators and one Geometry Validator which creates a report from the failed features. What I need to do is have FME search through point features and report which features do not "Touch" another polyline feature class. If they do not then add those features to the report. Is there a way to set that up in the GeometryValidator?So add to my existing report the point features that are not touching a certain line feature.

Does anyone know what I need to do to read microsoft access db on fmecloud?I am getting the error message below, do I need to upload a DLL to the plugin folder? thanks in advance! Creating reader for format: Microsoft Access 45 INFORM 0.0 0.2 Today at 00:02:22 Trying to find a DYNAMIC plugin for reader named `MDB_ADO' 46 LD_LIBRARY_PATH is '/opt/fme-engine-2016/plugins:/opt/fme-engine-2016/fmecore:/data/fmeserver/Server/lib/fmeutil/fmecore:/data/fmeserver/Server/fme/fmecore:/usr/lib/oracle/11.2/client64/lib' Could not load module '/opt/fme-engine-2016/plugins/fme_ado.so' : /opt/fme-engine-2016/plugins/fme_ado.so: cannot open shared object file: No such file or directory Could not load module '/opt/fme-engine-2016/plugins/fme.so' : /opt/fme-engine-2016/plugins/fme.so: cannot open shared object file: No such file or directory Could not load module '/opt/fme-engine-2016/plugins/mdb_ado.so' : /opt/fme-engine-2016/plugins/mdb_ado.so: cannot open shar