Best Answers

Hi,I have a simple workspace. I read a file (interlis2) and have 4 parallel transformers attached (GeometryReplacers, followed by GeometryFilter and AttributeRenamer).When I run the workspace it crashes at exactly the same data row in my input file without any further error message except "fme has stopped working". Nothing in log file either.If I disable two of the four parallel transformers and run the workspace and afterwards disable them and enable the two remaing ones all data is read and written (Autodesk sdf3).Memory is no issue - FME just uses 500 MB, there is plenty left.Any ideas why that happens? I would like to run the workspace in one go.Thank you, Rob

Hi.I have the following .json file:{    "0": {        "0": {            "Group 1": {                "Sub 1": 0,                 "Sub 2": 70            },             "Group 2": {                "Sub 3": 0,                 "Sub 4": 29            },             "Group 3": {                "Sub 5": 136,                 "Sub 6": 120            }        },         "1": {            "Group 1": {                "Sub 1": 0,                 "Sub 2": 76            },             "Group 2": {                "Sub 3": 1,                 "Sub 4": 35            },             "Group 3": {                "Sub 5": 157,                 "Sub 6": 115            }        } },"1": {        "0": {            "Group 1": {                "Sub 1": 5,                 "Sub 2": 72            },             "Group 2": {                "Sub 3": 51,                 "Sub 4": 2            },             "Group 3": {                "Sub 5": 16,                 "Sub 6": 20            }        },         "1": {           

My desktop administrator has installed the FME on the PC with Esri ArcGIS desktop. I'm not the administrator of the PC. After FME desktop installed, the FME Data Interoperability is listed in the Esri ArcGIS desktop extension for the administrator. When I login, my ArcGIS extension list doesn't include the FME data Interoperability. I'm not the administrator on the PC. Thus I don't have right to install any software. How can I use the FME Data Interoperability installed by the administrator in the ArcGIS desktop? Thanks in advance.Helen

Hello Team,I want to extract a direction of driving between address points using the API from gogglemaps. First i have the Origin Point and i need to find the next address ( point b for example ) from xls file. After from the point B find the next address ( point C ) and repeat this process 10 times. I believe the best way to do this is a loop in python. Attached my template file.Thanks in Advance,Danilo

Every time I open Esri ArcCatalog, I noticed that it is pulling an FME License from my floating license pool - this is quickly using up all available licenses!

@DeanAtSafeI saw your article on using KMLTourBuilder linked below. It is very helpful however I'm getting stuck creating my tour. I would like my tour to orbit over a single point. I have created a buffer around my subject point and set my tour to follow the buffer circle. This seems to work but I need to adjust my heading as I work my way around the circle. Ideally this would be a heading adjustment of thoroughly 7 roughly 51 times (360 degrees) so my camera view (heading) is always facing the middle of the circle. http://fmepedia.safe.com/articles/Samples_and_Demos/Climbing-Sydney-Harbour-Bridge-with-FME

Hello, How do I automatically create a unique digital sequential value for each record, unrelated to the record number? Thank you

I would like to count the number of input files and return this number to be able to use it in an arithmetic calculations afterwards.To be more precise, I have X Excel files, each containing values that are regularly repeated, but each with a different frequency. I calculated how many times each value occurred in all the files (so I have 2 attributes: value and count), and now I would like to divide each count by X (number of files) to get the frequency as a 3rd attribute.I tried using Aggregator, Statistics Calculator and Counter to get the number of input files, but I get 'missing' or 'null' values when I try to save it as an attribute. How can I 'save' or return this number?

Hi All,  I'm starting to use FME server and notification service. I managed to publish a workspace notifying some information by email when it's completed (with a TextFile writter...). It works when I manually run the workspace from the FME server.  Now I would like to send the same notification when the workspace complete, but on a scheduled way. It seems to ignore notification information specified when publishing the workspace. And in the schedule parameters page you can define what Topic it should post to but not what data to post (and so you cannot specify that you want to post the output of the TextFile writter), it posts the standard information (job id, time infos, etc.).  Is there a way to solve this problem ? Maybe I missed something... Thank you!

I'm looking for a solution to make my workspace a lot more dynamic for my use. I'm working on a easy to set up workbench where MariaDB (MySQL-compatible) Spatial reader and writer are connected with an AttributeManager in between. I would like to add my fmw to the server with some parameters that can set the Table list as prompt input data. The SourceDataset_MYSQL is already a prompted parameter but i cannot find a way to set the Table list/table name as a parameter. Any idea how to set this?http://docs.safe.com/fme/2017.0/html/FME_Desktop_Documentation/FME_ReadersWriters/mysql/MYSQL_reader.htmConstraints -> Table List

Hi,We are building a data extraction tool based on FME Server. This application build a form dynamically based on the published parameters. It needs to work in french and in english. Since i18n isn't possible on parameters descriptions and alias, we need to rely on a custom format that we put in the descriptions. The application has an additionnal step of parsing the descriptions to get the french or the english names/descriptions depending on the current language of the user.Is there any plan to support i18n on parameter names and descriptions?Is there a different way to manage that then the one we use?Thanks!

Hi,  I cann't use the Adobe Geospatial PDF writer to output Chinese or Japanese text.  I have tried modify my font file's name and it's name show in FME's font window to non-Chinese; also flow the help's instruction to modify the fme_text_string to rich format, like "你好", and set the parameter of Writer "Text in Rich Text Format" to yes. But both failed.  If you can output some special non-English characters to PDF?  Thanks

Hi users,I have a script that create a route between two points ( start and end ) using library googlemaps.The return is going well to attribute in format JSON.The idea is extract the route information in 'html_instructions'. In PyCharm is work when i execute it:I configured my Workspace and execute ( attached template file), but it brings only the last route between two points.How can i get inside my Workspace all route and turn a attribute? Attached the JSON generated by request googlemaps and Workspace.Thanks in Advance,

I'm pretty new to FME so I may be missing something obvious, but here goes: I have two AutoCAD layers, a text layer and a line layer. I need to find which text entities have the same rotation as the line entities. Then I need to take these line & text entities that share the same rotation and find which among them are within X units of each other. I've found the rotation of the lines using the custom transformer AzimuthCalculator, but when I feed both the text and lines into a single tester to see if their rotations are equal, the tester passes nothing, even when the rotations are equal (as verified with the inspector). The text rotation is a 64 bit real and the line rotation is encoded as utf-8, but from what I gather that shouldn't matter. Why is the tester not passing anything? My plan if the tester would work as desired is to then GeometryFilter the passing tester results into line & text and feed them into a NeighborFinder.

How can I convert .shp to .csv and include Postal code as well as lat/long? I am able to make the conversion, but only Postal code is exposed in the .csvThe original shape file has x and y axis and is using EPSG 102015, the .csv would preferably convert to EPSG 4326 and include lat/long

Does anyone know if FME can write / read / interact with MongoDB?   

I would like to snap the blue line to the red line. End goal is to merge attributes. I tried using AnchoredSnapper, the problem is that as you can see in some cases especially where the line bends lines can be closer to the 'wrong' red line. Any advice would be greatly appreciated.

Folks,Still on that learning curve.I have a table where there are two filtering criteria based on two different columns in the source.Initially I thought to use two Attributefilters one for each criteria and then re-combine the result like a UNION for the output.However it's possible the criteria will allow the same record through twice. Once for each criteria.What is the best way to filter out data based on multiple criteria?I was thinking if I stuck with multiple parrallel Attributefilters I'd need some kind of Merger to eliminate the duplicate records.Advice apprciated.

Hello,I implemented a changed detection on oracle table.Now I would like to be able to create a json for each change per object. For instance, for an object where changes were detected on 5 attributs, below will be the json that I would like to obtain:{ "ATTRIBUT1": { "OLD_VALUE": "OLD1", "NEW_VALUE": "NEW1" }, "ATTRIBUT2": { "OLD_VALUE": "OLD2", "NEW_VALUE": "NEW2" }, "ATTRIBUT3": { "OLD_VALUE": "OLD3", "NEW_VALUE": "NEW3" }, "ATTRIBUT4": { "OLD_VALUE": "OLD4", "NEW_VALUE": "NEW4" }, "ATTRIBUT5": { "OLD_VALUE": "OLD5", "NEW_VALUE": "NEW5" }}How can I proceed to obtain this in fme?I was tinking of the agregator to group all the changes from the same object (based on an objectid) and then build the json but I don't know how to proceed.Please keep in mind that the number  and names of attributes will change from one object to another one.Thanks,

I want to read the csv file for my SchemaMapper via a published parameter. This however does not seems to be an option. I can not select a parameter and when I try to type $(published_parameter), I get in parameters the notification "No dataset found in $(published_parameter)". How can I solve this issue?PS: using FME 2016.1 build 16492

Hi everyone ! I'm trying to create an advanced boundbox from multiple input (.dgn) using a group by closis on fme_basename and I would like that my boundbox be oriented !I tried the BoundingBoxAccumulator and Replacer but with the Accumulator there is no OrientedBoundBox and with the Replacer there is no group by ...Does someone has an answer ?Thx =)

Is there a transformer that will assign an elevation value interpolated from a set of contour lines?

I have to determine the direction of a closed curve (a line where start and endpoint are the same) because I want to derive a gpx in the right direction (clockwise) from the polyline. Is there a way to do this? So I want to test if the polyline has a clockwise direction and, if not, reverse the direction. I tried the Polylineanalyzer and the azimuthcalculator, but both don't give me a solution.

Hello,I don't know the best way to go about this, I've been trying to set some conditional statements in my AttributeManager but I'm unable to get the results I'm after. I'd like to identify the duplicate serial numbers (API NUMBER 10) in my data and then only keep the duplicate that has the most recent date (WELL STATUS DATE).Thanks in advance for your help.

I am sing FME 2016 and have polygons dataset that are spread in an irregular fashion. I want to create a fishnet(grid) wherein the geometry is as per the density of the polygons. So, first of all, I have to convert the polygons to points, so that the original polygon file is not occupied by 2 different grids and then create the tiles thing and save the output in multiple polygon gdbs (outputs as per the tile). it would be really amazing if the number of polygons in one grid could be controlled.Thanks.