General

 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



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?

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 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.

Good morning, I would need to do a spatial join on FME. On QGIS, the tool is called "Join attributes by location". I would like to find an FME transformer that does the same as the QGIS tool. Thank you for your reply

Hello I have a file in xml format. Although I selected many xml formats in the addreader section of fme, I could not open my file. Can you help me?

I'm missing the Beta-Download:"There are no betas currently available to download. Please check back again in the future."

FME Desktop 2022.2.3

Hi, Just after a bit of advise. Within my organisation i am trying to request an app to connect to sharepoint. When this work on FME desktop i have to authorise with my own identity and it works fine. However, as my organisation has a 2 factor authentication policy which requires me to enter a text message password, i need to reauthenticate every 2 weeks. Would this be the same with FME server, requiring me to reauthenticate every 2 weeks (as not useful for a process i want to leave on a schedule)? or when i authenticate the app from FME server, would remove this reauthentication requirement? if not is there anyway around this? I would do trial and error to find out, but its taking me along time to get through internal processes, and want to ensure after the effort it take to get there, its going to work as hoped. Many thanks, Andy

I'm finding that the LineCombiner is causing issues when combined with an AreaBuilder. The non-combined lines in a workspace I have created successfully create areas but, when the lines are combined, they then make up incomplete areas. You can see in the below image that, once one of the line datasets go through the LineCombiner, they do not successfully create the areas. Is this a bug?

Hi,With FME(R) 2022.2.4.0 (20230303 - Build 22792 - WIN64) I am trying to load 1730 DWG files with attributes. The feature reader reads all the files and generates more than 81 million elements. The next step would be to expose the attributes from the DWG files. When I try to Import the attribute list from feature cache I receive the following error:An error occurred. Here is the information that FME was able to find on the errorbad allocationFailed to open the dataset 'C:/Users/csernak/AppData/Local/Temp/wb-cache-readalldwg-cKcBRr/Main_FeatureReader -1 3 fo 1 _lt_OTHER_gt_  0  4cd4d7e49164af1f4967e8da9131f3594634062d.ffs'DATASET INFO:    DATASET: C:/Users/csernak/AppData/Local/Temp/wb-cache-readalldwg-cKcBRr/Main_FeatureReader -1 3 fo 1 _lt_OTHER_gt_  0  4cd4d7e49164af1f4967e8da9131f3594634062d.ffs    NUMBER OF PARAMETERS: 0The files are there, the disk is half empty, the memory usage is just 400 MBs.With a single file it just works fine.Is there anykind of limitation around that?

When I am reading the files which are of size 192 MBit is working fine but when I am reading the file which is of the size 958 MB , getting an error. I am getting error in fme server while reading the particular file . Is there anyway to solve this error?

HI All, Any workaround to convert a date string (YYYY-MM-DD format) to DD/MM/YYYY ? The field type needs to stay as date string see below:  I've tried a few transformers (StringReplacer + ListExploder+ String Concatenator) but couldn't get it to work and show 21/04/2023 Thanks

At first, it successfully connected to the database, but later on, it started encountering errors that were resolved after some time. However, for the past four days, it has completely stopped functioning, rendering me unable to continue with the tutorial.

I have a script that was written for us by a consultant and it’s very intensive. The FeatureReaders are pointing to a connection file to read our SDE, as well as some file geodatabases that are stored locally on the server. The script uses a WorkspaceRunner to access a child script to then do some calculations. However, when I run this from FME desktop on our server, it never completes. It doesn’t throw an error, but it just gets hung up at the WorkspaceRunner. If I try again, the same thing will happen. There’s no common point in the script where this happens. It’s very random.I’ve also attempted to run this script from my desktop, and it works. It’s very very slow, but it does work. However, we need to be able to run this from our server, not my desktop.Any ideas on what I should be looking for in our Server environment? Our server has much more resources than my desktop, so I’m surprised it’s not working – so I must be missing something. Any leads on this would be greatly appreciate

I have a case where I need to determine which wells (polylines) belong to which unit (polygons) based on spatial relationships. I need to be able to know the percentage of those relationship (wells and units) and some key data associated with the unit. I need to determine percent of overlap and produce two outputs.  One to show only the relationships (between wells and units) with the highest percent of overlaps (including their percent overlap value) and an another containing all relationships (between wells and units) and their percent of intersect. Thanks!

Using FME workbench and fme.exe file. Both was working earlier. Suddenly both are not able to open any .fmw file. Only if run as Administrator it is working. What could be issue.FME version : 2016Server : Window 2008

The distance between the road and the plots are not fixed, so we can't use a buffer