Best Answers

Greetings!I would like to set an attribute of my feature as the value returned by a pl/pgsql function. Currently, I use the SQLExecutor for every feature. It's much slower than using the pl/pgsql function in the INSERT.The expected result would be that FME produce the following insert statement.INSERT INTO my_table VALUES (17, 'abc', MY_FUNCTION(17));I'm using fme build 16716 with postgreql version 9.5.Kind regards,Jean-Denis

Hi, very new to FME, and I cannot solve how to use this:I have about 100 ESRI shape files, containing map data for different geographica areas. I would need to rearrange the data, so that new files are created, where each new file contains all data with a specific attribute in one of the data columns. For instance, small roads have the attribute 11015 in column "CLASS" in all this input files, and the data for all small roads should from all the files should be exported to a new files 11015-all-areas.shp . What transformer do I use, how and how do I get the new created files to adopt their names from the attributes used? Thanks!!  Benjamin

I uploaded a workspace to a FME Server using the Datadownload service.I call this service and workspace from a custom webpage.All is working as designed, but I would like to skip the download link that is returned by the service.I would like the Datadownload service to start downloading the file as soon as the file is generated.I can't find the right option for this.My URL looks like: http://localohost:8080/fmeserver/fmedatadownload/myrepository/myworkspace.fmw?Can anybody help?

Dear all,I Have a schema mapper transformer that is defined based on an external oracle tableThe external table have a column_name destination_attribute_type where I defined the data type of the file to be translated.Is there any specific reason why "fme_int32" of the oracle table is not converted to "long integer"For the shape files, the field data type of "fme_int32" yields to a data type "double" with length equal to 11.Thanks

Hi I am in the process of creating a bunch of workbenches and would like to use Python scripts to create a custom log file for each workbench, each with specific name and in specified location. I would like to log only specific outputs, e.g. count of features failing geometry validation, Total count written, Total count failed etc..Any suggestion what's the best practice to achieve this. Should I be using startup/shutdown scripts or python caller? I would also like to create the log file with a datestamp.Thanks

I am generating reports using the HTMLReportGenerator and would like to have a hyperlink within the HTML output that links to a pdf, shz, csv..... I can generate the url address as an attribute, however I have not been able to output the HTML with the hyperlink.Anyone been able to do this? Ideas?

Hi, I am trying to run a series of transformations using the FME Rest API. Sometimes it works just fine, however, sometimes I get the message "Authentication failed: Failed to bind to Active Directory". (401). I created a token valid for 10 days and used a HTTPCaller to POST to the URL "http://ourserver:8080/fmerest/v2/notifications/topics/LDR_Trigger/message/raw?token=123456&detail;=low". Sometimes it looks like if I login to the FMEServer UI, it remembers the token and the result is as I expect. Has anyone any experience using FME Server REST service on Active Directory?

Hello everyone,I want to draw a polygon that crosses the 180th meridian and obtain this geometry (created manually, splitting the feature into two separate polygons): Instead I obtain this: I don't understand why the geometry won't generate properly. FME creates the polygon with the greatest distance between points instead of the shortest. I have to do this for many polygons and also lines, with much more complex boundaries, so I can't do this manually like this one.  Any idea on how I can achieve this?Here is the workspace I used to generate these geometries: Thank you very much

Hi allI have the edges of a road and want to be able to measure the distance between the two edges perpendicular to the left hand edge at a distance every 10 metres.Any suggestions on how to complete this as I can not get my head around it.Thanks in advance.

I am using Sampler to grab fisrt 1000 records but it reads all 2 million records that I am dealing with before grabbing first 1000 values. How do I avaoid it? Thanks.

Hello,I execute query on my postgresdb to get result as a json: description is here http://rextester.com/ZULI42144It looks nice but now I would like to convert it to xml. I decided to use fme to query postgres just like in example and now I have noe idea how to convert the result to xml and write it to file.Also talking about json which I also need (I need result in JSON and XML format) what I achieved is that I simply executed postgres query end then wrote results using simple text writer so I suppose that fme doesnt really know that the query result is a JSON :)Structure and content of the database is as described here:http://rextester.com/ZULI42144and there is sql that is used in below sqlExecutorThis is prototype of my workspace that I have right now and the question is how to format nice xml from this list exploder (if its possible).And here is output of the logs. Of course in the result xml I would like to have structure ike <person>...<car>...<wheel>...</whe

Hi,this time I need to rotate a svg-symbol based on an attributive value. I have set the parameters asfollows:The parameters in the screenshots for rotation (e.g. 30 degree) and the optional coordinates of the rotation point are hard coded. In the real application they will be filled based on attributes.Well I get this error:Invalid Mapnik style configuration. The error was: Failed to parse transform: 'transform="rotate(30,427000,5670000)"I have tried different Syntax, without success. Do you have any ideas? Maybe the integrated mapnik engine does not support rotation?

Hi,I'm continiously acquiring tasks for internal FME execution that previously was done by a mix of command lines and t-sql. One of the tasks involved was dispersing points with identical coordinates to unique positions in the vicinity. This task is currently kept in a stored procedure.I would like to also transfer this functionality to FME proper.Before I venture into recoding the stored procedure into a custom transformer, I'd like to hear, if anyone has encountered a similar problem, and has found a good solution ?Cheers.

I have a simple translation setup in FME to check if certain points are within a proper postcode polygon.The guidelines I am checking against is that there should be one point per postcode and if the postcode of the point is "12555" then it should be in the "12555" polygon. Easy enough to check. However, the problem I'm running into is there are PO boxes which have a postcode but do not have a polygon to go with it. I need to somehow filter out the points that do not have a matching polygon and then send the rest on to the PointOnAreaOverlayer and the tester.I originally thought this would be possible with a TestFilter or Matcher but I'm not having any luck getting the result I need.Anyone know what I need to use for this?Thanks.

When reading very large amount of spatial data from a Database within the FeatureReader, the process could take a very long time. Is it possible to pause the reading, while reading within some time intervals?In fact, I have a database locked at night for updating daily changes and I would like to pause the FeatureReader (if currently running) during the night and resume the next morning.In advance thanks.

Hi there, I am trying to digest multiple CSV files from within a certain directory. To do this, I have created a CSV Reader that has a Source CSV folder with the parameter: _"<my file path>\\*.csv"_. I need to remove the processed file from this directory after processing which I would do via python shutdown script by getting the filename that has to be removed (actually - it would be moved into a directory). In the past when I only processed one file, I was able to grab the file location directly from the reader, which is of course now the <filepath>*.csv . I have used an Attribute-Exposer to get the filename- but I haven't figured out how to use it in my shutdown script? Am I missing something obvious here? Is there a way to either: - set a Python variable with the filename (I would be surprised) or - set a publish parameter at run-time? Thanks in advance!

Hi,  I've just run into a curious problem with a conditional expression in the AttributeManager.?  I'm comnparing two dates in the "FME Date" format (%Y%m%d), setting an "expired" value to either "true" or "false" based on the conditional expression: @Value(dt1) > @Value(dt2)  But it seems like the expression is always satisfied, so my output is always "true", regardless of the values involved (and some should definitely yield "false").  As a workaround I added a Tester transformer, with the exact same expression, and that worked as expected.  Has anyone else run into this, or have any insight into why the conditional value errs ?  Cheers

In a previous question I asked how to translate a custom line style from one Microstation file to another and the answer was add the lines with the custom styles to the seed file save it delete the lines and don't compress. It worked brilliantly. Now I need to translate from Smallworld into Microstation and have a chain that I am translating from Smallworld use a custom line style in Microstation. I tried using the same seed file as before and the same methodology or at least as close as I could when creating the fmw file and it did not work. I guess the question is, can I create a line in Microstation using a custom line style from a Smallworld chain object? and if so how?Any help would be appretiatedThanksRobyn

Hi.I have these polygons:I want to clip the big one with the small one and keep the rest. They are in different layers.I use the Clipper transformer:- Clipper: layer with the small polygon (DGN) - Clipee: layer with the big polygon (DGN)The result should be in the Outside port, but it is in the Inside one. Why is that? I have cut thousands of polygons this way and this is the first time somathing like this has happened.  I can't use the Inside port, beacuse I would get a lot of data I don't want.Thanks for any help provided!FME Desktop 2016.

Hi,I'm faced with a task, where I need to duplicate some elements with regard to several attribute values (if they have one). It's not a filter since any of the attributes may or may not have a value, so each oruginal element may yields between 0 and N copies of itself.I can't seem to find a suitable transformer for such a task. Can anyone point me towards one.I would prefer not to have to hard code this with multiple transformer paths with several transformers.Cheers.

I'm working on a project for FME Server where a user will be able to pass variables into a URL and get a download of a dataset. One of the requirements that I'm hitting a snag on is how to create a parameter that can be used to name the output file (geodatabase, pdf, or shapefile). Right now it's defaulting to dataset.gdb.TIA,David

Hello,in the picture there are lines and polygons. Both have a code attribute. The idea here is to clip the lines with polygons having the same code! E.g. for polygon 791238(one the left of the picture), lines within yellow block having the same code as this polygon, and they need to be clipped. So I thought the process will be:  for each polygon:      select the lines having the same code as the polygon    clip selected lines with the polygonHow can I do this in FME? Or are there approaches?Thanks!

Hi all,I am updating a cell of an Excel sheet using a SQLExecutor. The update of the cell works fine but I have a formula links to this cell that doesn't update.I check in Excel and the Woorkbook Calculation parameter is set to automatic.As I have more than 1000 formulas, I don't want to clik on them and press enter (the only solution I found for now) to update them.I put in attached the workspace.

Hi I'm not very familiar with ESRI software. I have created an update/insert process on a Layer I created in AGOL and I noticed even though I specifed 500 char for a field in FME writer, it is truncated to 254 when written to AGOL. Does AGOL adhere to the shp limitations of 254 char max or have I missed something ? ThanksCiara