Best Answers

When I create a tunnel from a long connection line than the first annatation is the same length as the connection line.

Hi,it may be a stupid question, but if you add a writer/reader/inspector in fme2018 to a transformer that is in a bookmark, he always puts it out of the bookmark. My model is very large and has a lot of bookmarks that run into each other so that is not so convenient. Is there a way around it?ThxNathalie

Hi,I'm using the SQL Executor transformer to pull back the most recent records from a SQL server DB  since the ETL was last run.  The last run datetime will be held in in a Postgres table and pushed through as a parameter to the SQL Executor, the issue here arises when I push the datetime parameter through to the SQL Executor As a test and to trap the error I've used the attribute creator transformer to generate a datetime attribute which would mimic the last run datetime from Postgres, and hence push this through as a parameter. I've set the value = '2018-01-14 09:18:00'If I run SQL Executor with a set datetime ('2018-01-14 09:18:00') the SQL executor runs successfully  and returns records. However if I run the same query replacing the specified datetime value with the the parameter I get the following error message, despite the value and format being identical?--'. Provider error `(-2147217900) Incorrect syntax near '09'.'The error message points to an issue with the time element of 

I can't seem to activate the floating license, any help would be appreciated.

Hi,I always use RasterToPolygonCoercer to convert Rasters to Polygons (which, by the way, takes much much longer than the ArcGIS counterpart). However, RasterToPolygonCoercer no longer exports the raster values, although it did before. The Label Attribute no longer shows up in subsequent transformers.Is this intentional or a bug? If intentional, how do you extract raster values into polygons?

I have created a very simple list using the list builder that contains multiple values of the same key (stationId). the list looks like this in fme inspector: I want to pass all the statonIds in this station list into the sql executer transformer into my WHERE statement.  The sql executer recognizes this list however, it only allows me to specify a specific element number in the list like this: where originstationId in (@Value(StationList{0}.stationId))The problem is I don't know how many values will be in the list each time so I can't hard code the list element number in it. I would like to pass all values in this list into my query.

Hi, I am attempting to feed an attribute value into a published parameter WHERE Clause in a WorkspaceRunner (the workbench reads an AGOL feature service, which i want to limit the number of features it has to read as its very slow).FeatureReader is not an option as I need to read attachments.In the error log it shows that instead of using the attribute value @Value(SQL), it is the actual text @Value(SQL) that is getting used. Am I doing something wrong? Or is this a bug?Thanks

Hi, I am trying to read some data that is stored in several subfolders in the FME share resource data folder. It seems like the process didn't like the wild card ie.. Data\\foldername\\**\\*.csvAny pointers/ work arounds?Thank you in advanced for any help you can provide.

How do I retain my header rows when I fanout my Text File Data Set? It seems I need to replicate the same number of features with the header row so the fanout can group-by the expression/attribute (that is only available in the data itself). I could see a possible FeatureMerger (with hard-coded values and a List) and then a ListExploder, but this seems overkill.Ideally, the writer would support an additional header row(s) port - I need multiple header rows - that can be supplied before Fanout is processed.

I am new to FME. Although I can deduce how to use @value(Attribute) in a text editor in the workspace, I am not sure how the $ symbol is used and how it can be chained to say @value. Also are there other keywords with the @ symbol. Where in the documentation are all these symbols and their usage comprehensively defined and illustrated? Thanks.

Hello,I am trying to export vertex coordinates from mesh to the attribute, but I am getting this error:TypeError: Failure to convert list values to native values.And here is the code:class FeatureProcessor(object):    def input(self, feature):        mesh = feature.getGeometry()        vp = mesh.getVertices()        feature.setAttribute('VertexPool', vp)        self.pyoutput(feature) 

I went through an express install on and Amazon EC2 instance, upgrading it from FME Server 2016 (and cunningly skipping 2017). Everything went smoothly until I went to startServer and it complained about [ec2-user@ip-10-140-151-106 fmeserver]$ Mar 21, 2018 9:00:05 PM org.postgresql.Driver connectSEVERE: Connection error: org.postgresql.util.PSQLException: Connection to localhost:7082 refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections.   This looks like a problem with the default FME Server database, but I don't know enough about postgres config or Red Hat to know what to do to appease it. I got as far as opening port 7082 on the instance through the AWS/EC2 control panel and when that made me cringe, I determined I no longer know what I am doing and need help.   If you can, please help! -Fuad

Hello,I have a network where this are many connected lines on nodes I wanna make from the ones having the same value of an attribute to get connected and became one feature. Is there any way to do it ? Thank you

Hi Everyone,I am writing to the AVF writer and then using the AVF reader in separate workbench. However, I noticed that there are two different naming conventions for Level _Ids under Sections category. See attached pictures. Is there a reason why they are different? I know that in the AVF Writer, it is a list, but the AVF Reader does not show it as a list. When I run the AVF reader in my workbench, level_id does not exist. I am using FME 2018. Thanks!David

Hi,We have a proces, that converts some schema-less XMLs into MS/SQL. The output definition is set to "Automatic".It now seems, that later versions of the XML files include more attributes than the original versions. These new attributes are output as-is, but cannot be seen in the workspace.I've tried to update the reader feature types, but even though the attributes are present in the data files, they don't show up in the workspace.How can I by default remove all "unknown" attributes coming from the XML files ?Oughtn't the Attribute Manager have an option for this ?Cheers.

Hi FME'ers when creating a list with the following Python script:import fme, osimport fmeobjectsfolder = os.path.dirname(FME_MacroValues['Folder'])def get_filepaths(feature):    """    This function will generate the file names in a directory     tree by walking the tree either top-down or bottom-up. For each     directory in the tree rooted at directory top (including top itself),     it yields a 3-tuple (dirpath, dirnames, filenames).    """file_paths = []  # List which will store all of the full filepaths.    # Walk the tree.for root, directories, files in os.walk(folder):        for filename in files:            # Join the two strings in order to form the full filepath. if '.dwg' in filename and '_georeferenced.dwg' not in filename:                  filepath = os.path.join(root, filename)                file_paths.append(filepath)  # Add it to the list.feature.setAttribute('file_paths', file_paths)I cannot easily retrieve the list of folders in FME.I tried AttributeExposer with v

If we use a shape file reader in FME desktop we only need to pick the shp-file but not the other parts like dbf, shx etc. FME desktop recognizes all parts of the shape file and we can start our workflow.If we publish the same workspace to the server and use a published parameter for the shape file then we need to upload all parts of the shape file as a temporary data upload to FME server. If one of the parts is missing then our workflow will not run. How can we check (in advance?) if all necessary parts of a shape file were temporary uploaded to FME server?Best regards,Frank

Hi,I've encountered a problem when using a GeometryReplacer With LineStringZInvalid WKT encountered: LINESTRINGZ(541502.5560000000 152585.6960000000 583.544, 541502.4660000000 152585.4560000000 583.775, 541501.2901908699 152581.1464218800 0.0)I do assume that LinestringZ is not an OGC WKT recognized format yet, although it is recognized as a valid OGC WKB format.http://portal.opengeospatial.org/files/?artifact_id=25355My goal is to check the geometry validity from my linestringz features before sending these to my postgis database.SELECT ST_ISVALID(ST_GeomFromText('LINESTRINGZ(541502.5560000000 152585.6960000000 583.544, 541502.4660000000 152585.4560000000 583.775, 541501.2901908699 152581.1464218800 0.0)'))Any idea how I could deal with this on FME 2018?

I have FME Cloud setup to run a workspace when it receives an e-mail. The workspace was previously in another repository that is now deleted, but still tries to run the deleted one as well as the current one. I have rebooted the server but have not been able to figure out why the workspace that no longer exists is trying to run.The workspace in the current repo will run successfully, but it will also try to run the deleted workspace as well.statusMessage File Field Data Processing/FileNameValidation/FileNameValidation.fmw could not be opened 

I am having a problem with the TopologyBuilder transformer. I have "Assume clean data" set to "No", but it is not cleaning the data properly. Some of the edges are broken up according to the other lines, but others are not. These images are the result of my TopologyBuilder transformer, with the vertical line in the middle starting as one long line before being sent to it. As you can see from the highlights, some of the lines are not being split properly.I have zoomed in on these features as far as I can go with QGIS and I do not see a gap between them. I would assume that this is due to some imprecision in the snapping tolerance but I cannot find such a parameter to adjust.This is the transformer as seen in the workbench:

Hi everybody, ik am trying to read an url that gives me json-format answer.the url is like: https://geodata.nationaalgeoregister.nl/locatieserver/v3/suggest?wt=json&q;=Nieuwe Steen 1 Hoorni want to read the values of the attributes "type" "weergavenaam" "id" "score"regard,Bert punt

Hi,I created an FME workbench which reads an esri line feature class thethen assigns a color based on an attirbute to create a KML file that is color coded. I want t to put this up on my fme server. at the moment it only reads a specific feature class file from a folder on my c:. In future I would like to run my workspace on FME server and throw any feature class or file GDB into my C: folder and if it has the attribute field to assign colors then the process will run and create the color coded Kml.I'm not sure what transformer to use for the input and what other options I have in FME server to upload the file.any ideas would helpthanks

Hello,I have a Feature and I am using a FeatureWriter to output a final GeoJson, until there everything is working fine when it's about direct attribute.How about automatically looping a nested list, to get a list of one specific attribute and attach it to my FeatureWriter as a json property (an array) and keeping in the mean time the already well defined relation between the main object and it's list Basically I want this attribute "classification" (see the screenshot attached), to be output at the end as a json property of a type array using a FeatureWriter Geojson.Bellow the final output expected, of course without building the GeoJson by myself but letting the FeatureWriter (GeoJson) to do the job:{ "type" : "FeatureCollection", "name" : "SomeName", "features" : [ { "type" : "Feature", "geometry" : { "type" : "GeometryCollection", "geometries" : null }, "properties" : { "someProperty" : "someValue", "classification": ["value1", "value2"] } }, { "type" : "

Hi all.I've got a tab file that I run a few queries against it to pull out some values which based on a published parameter used for the query. The results are then written into an Excel tableIn this case the publish parameter ‘LEASE NAME’ used in the query has extracted the Collingwood 3 data from dataset. Seven records were extracted however I’d like to make those into a single record that contains data from each attribute where present. Additional I want to sum the values in the length columns.At the moment it looks like this.But I want it to look like this.What should I be doing to get this result? Thanks a heapMichael