FME Form

Hi,​I am very new to FME and I've run into some troubles I can't figure out how to solve. I've got a dwg file that I'm trying to write to a file gdb. The geometries vary, but the features containing text are the ones I'm having an issue with. When I try to write these I get the error: "GEODATABASE_FILE writer: An unknown exception occurred" and "Error running translation" which leaves me a bit clueless. Some features works fine, most don't I can't seem to figure out why. The writer's geometry parameter is set to geodb_annotation. Does anyone recognise this problem and know how to solve it?

I am running a workspace converting DGNs to gdb with no errors but it gets to this message: "FME API version of module 'GEODATABASE_FILE' matches current internal version (3.8 20190621)" and does not proceed anymore any ideas?

Hi all, Im trying to automate a process done in mapinfo and requires a table update.  The update in question-Hope this make sense with the censoring however this shouldn't effect the process.  Ive tried a few different ways but i never get the outcome Im looking for. Thanks.

 AddressID "AddressID" true true false 4 Long 0 0,First,#,AgencyNotifyParcelPtStep2_LargeAgencies,AddressID,-1,-1;APN "APN" true true false 9 Text 0 0,First,#,AgencyNotifyParcelPtStep2_LargeAgencies,APN,0,9;SubType "SubType" true true false 4 Long 0 0,First,#,AgencyNotifyParcelPtStep2_LargeAgencies,SubType,-1,-1;AddressType "AddressType" true true false 13 Text 0 0,First,#,AgencyNotifyParcelPtStep2_LargeAgencies,AddressType,0,13;FullAddress "FullAddress" true true false 62 Text 0 0,First,#,AgencyNotifyParcelPtStep2_LargeAgencies,FullAddress,0,62;StreetNumber "StreetNumber" true true false 4 Long 0 0,First,#,AgencyNotifyParcelPtStep2_LargeAgencies,StreetNumber,-1,-1;StreetNameFull "StreetNameFull" true true false 50 Text 0 0,First,#,AgencyNotifyParcelPtStep2_LargeAgencies,StreetNameFull,0,50;PrefixDir "PrefixDir" true true false 2 Text 0 0,First,#,AgencyNotifyParcelPtStep2_LargeAgencies,PrefixDir,0,2;StreetN

I can read this geojson below in fme.  In this example (I & J) at the end of the string Fjson&I=800&J=422It will give me back a responds.However looking to loop through all possible values of I & JImax=1073&Jmax=571 = 612683 values. where I and J is a variable in the geojson string. xxx/geoserver/ows?SERVICE=WMS&VERSION=1.3.0&REQUEST=GetFeatureInfo&BBOX=50.46754657502329877%2C-1.82577500000000015%2C51.03245342497670123%2C-0.76422499999999971&CRS=EPSG%3A4326&WIDTH=1073&HEIGHT=571&LAYERS=public%3Axxxxxxx&STYLES=&FORMAT=image%2Fpng&QUERY_LAYERS=public%3Asolent_currents_direction&INFO_FORMAT=application%2Fjson&I=800&J=422

Hello , i have to write my output from ArcGis sde to excel file .but I have empty fields at many columns. i would like to have only fields that have only values .so how could I remove empty fields ,?i have read many topics about that but it does not work with me .could someone provide me with template workspace to remove the empty fields .Thanks in advance FME 2021

Hello i am reading many tables from oracle non spatial tables name Table_ATable_B Table_Ci have around 30 table and I would like to get the Output from all tables when Id= 45 i am not sure ,how to write the condition in where clause to test it in all tables and In case it did not find the id in any table so I will not get any output from this table .But in case also ,no id as attribute name in any table so I get nothing better than error ,if it is possible .Fme 2021 

Hi.I'm having trouble with a workspace, that outputs a number of GeoTIFF files to a folder.I'm using a FeatureWriter to output the GeoTIFF's. The FW has no option whether to overwrite existing files.When I save the workspace as a mapping file, and run fme.exe with this mapping file, no files gets overwritten, i.e. older versions remain in the output folder.If I run it manually (i.e. the workspace in Workbench), it seems like files are getting overwritten.Is this the WAD behaviour, or is there a difference between running *.fme and *.fmw files ?How come there isn't a setting in FeatureWriter to control this ? Or is there, somewhere hidden ?Cheers.



Dear altruist, I have a datasets of soil moisture values in array system. So, for each grid cell, I have values for each day for certain years (image 1 shows the structure of array). However, for some cells we have consistently a constant value ( e.g. 1). For these cells I have to recalculate the soil moisture based on the average of neighboring cells as per the formula in the second image. I have tried with Attribute manager and conditional statement in setting values, which is not sufficient to do this job. Can anyone kindly suggest and explain how conveniently it can be done in FME? 

Hi all, Not sure if this is even the place for this question, but this arose recently in my workplace and it would be good to get some thoughts. I work in a consultancy, and use FME daily for spatial and non-spatial data analytics. Sometimes I create workbenches that are re-usable for different clients to achieve the same goal. My question is, when I am working for a client and develop a workbench on a project they are paying for, who owns that workbench? Is it me (the author), my company (who owns the FME licence), or the client (who is paying for the project)? It's worth stating that the contract we have with the client is only asking for outputs such as reports and visuals, and does not explicitly cover the workbench itself.  Any thoughts?

@takashi I have a list of Hotels. I need to check spelling is correct or not. As I am new for FME & Python, could you please help me. Thanks

I'm not sure whether this is a bug or not. I have a number parameter configured like this - However, there seems to be some sort of floating point issue when accepting a value at input -A few weeks ago this was working fine on the same machine running the same FME server version. Not sure if anyone knows what could be causing this?Thanks

I'm creating a cruciform for biodiversity monitoring and I'm having trouble setting the distances from the centre. I need to do this for 50+ areas so it would be good to get some batch processing going.The inner nodes start at 5m from the centre. From then onwards, they are set at 10m intervals. Each arm of the cruciform is 45m long. So there are five nodes on each arm resulting in a 90m total length on the x & y axis.Node labels are as follows: 5m, 15m, 25m, 35m, 45m.The problem is, the southern, eastern and western arms are showing the distances backwards i.e. 45m label starts at the inner node and the 5m label is at the outer node.The workbench works as follows:Calculate centre point of areaCreate vertices around centre point so LineBuilder can create 4 x arms of cruciform( N,S,E,W)Create points on lines using DistanceMarkerLabel points based on Counter The northern arm always seems to come out correct so it must be something to do with line/point orientation. I have tri

Hello, I am just a month or so into using this tool. I have a task that requires me to transform Geojson to the Mapbox Vector format so we can use on our mapbox tileserver - min zoom 15/18 with about 4 or so attributes. I am told Mapbox requires a uniqueId and so I am providing it in an integer format. Within this task, there are only 10 simple 'house shapes' from the GeoJson dataset.I am required to provide the unique id for each parcel within so I am perplex why 10 rows of data convert into 15 just using the following base design (omitted functional details)NOTE: Id 10 is duplicated and the smaller shape is created out of thin air.If there is a generalizer that can remove that I have not been able to find it. However, if I change my min/max zoom - remove the generalizer it works with 10 rows. Min/Max 7/15The min/max requirement is solid and they want it rendered exact.Am I over complicating please let me know. Thank you,   

I have shapes that butt up against each other and I need to create labels at the edge where the two shapes meet. These shapes could contain up to a large number on incalculable edges that meet, for example the edges of state polygons. I figure my best guess is to take the shape and create a center point in the middle of the shape that is always inside the polygon. I then take the polygon and chop them so I have individual lines. Then I can take the points and compare them where they have different names and identify the point of intersection between these points along the edge lines.​I am probably overthinking but trying to figure out the best way. See simple example explanation below.​Example.​The left shape I call Shape A. The right shape I call Shape B. I have identified the centers of each shape creating points. I want to use an imaginary line between the two points and identify the edge where this imaginary line instersects. At that intersection, using a CenterPointRepla

I need to create lines between points. I had seen an article for similar in a different post saying a PointConnector was the way to go (Draw lines between points (safe.com)) but when I try to insert the PointConnector it puts in a LineBuilder which doesn't work. I need the end result to be something similar to the screenshot below where an individual line is drawn between every single point. How can I do this? 

I have got 8 coordinates and I wanted to extract mid-point / center point that has XYZ of EACH side of surface of 3dCube .  Please highly obliged with your help or input  

I would like to select only tables with certain strings in their table names when running a FeatureReader. So something akin to:WHERE TABLE_NAME LIKE '%searchstring%'Is this doable? And if so, how?

I have a large data set that has been read from multiple autocad drawing files. At the current stage each feature has an attribute "project_num". There are many feautres (usually lines) for each project_num. I would like to get this down to a single "centroid coordinate" (preferably center of gravity) for all of the lines from each project_num.  CentrePointReplacer will generate a single point for every feature.I tried FeatureMerger but am having problems. Both the Supplier and Requestor are set to "project_num". I have set the Feature Merge Type to geometry and checked "process Duplicate Suppliers" (build polygons) but get the same number of merged features as the input. If I use the "group processing" option, I still get the same number of merged features. My current workaround is to use the DuplicateFilter before sending it to CenterPointReplacer. I have also tried creating a point cloud from all the resulting CenterPoints and

Hello, See picture below for example, I wish to remove the green vertex while ensuring that the end point vertexes remain.  I need to remove these as they are treated as being stacked, which is causing major issues with my ESRI Utility Network Model.  These points are within < 0.001m of each other. I have tried using a generalizer, which is not appropriate for this situation, as the lines become much too generalised. I wish to only remove these vertexes that are treated as being stacked upon each other.  I have also tried using the geometryValidator -> issue to detect: remove consecutive points without success.  What other ways can I remove these points? I have thought about creating a custom set of transformers that could do the job, i.e. Find all vertexes -> identify any vertexes that are connected to other Line st/end points or any devices (as I want to keep these) -> find vertexes that are within 0.001m of each other -> single match these -> output. Although with

I am playing around with FME to see if I can use it to convert autocad dwg files that use colour based plot styles to named plot styles (CTB to STB). I have attached a simple workspace that has an autocad reader and then sends it to a writer. No transformations. The writer uses a template file that uses our standard STB file for plotting. The converted file is mostly okay, but for some reason some of the leaders are way out of place. After some investigation, I found out that they are mirrored on the X axis. If I insert the converted drawing over the original with X scale factor set to -1 those leaders end up exactly where they should be. What's going on?

I am trying to use a "Where" clause for the reader but it does not identify the field in the existing geodatabase. I have a Esri Geodatabase connection named vg_esri and I wanted to select a table named vg_esri.sde.mm_poly_gh and select a polygon wíth its id polygon_id = 852364, I have used SELECT polygon_id FROM vg_esri.sde.mm_poly_gh WHERE polygon_id = '852364';Could not find the features in the table 'sde.mm_poly_gh'. One possible reason is that a WHERE clause was specified that references a column/field that does not exist in the table. The error number from ArcObjects is: '-2147216081'. The error message from ArcObjects is: {Invalid SQL syntax [ERROR:  syntax error at or near ";"LINE 1: ...FROM dg_esri.sde.mm_poly_gh WHERE polygon_id = '852364';)But I get this above error, What am I doing wrong, I cannot figure it out. Any input will be very help. Thank you... 

Hello, I have configured FME-Server for httpS. following this description https://docs.safe.com/fme/html/FME_Server_Documentation/AdminGuide/configuring_for_https.htm. But now is the file upload no longer working. "There was an error uploading the file"(https://docs.safe.com/fme/html/FME_Server_Documentation/WebUI/Uploading_data_files.htm) Any help is highly appreciated. Thanks.