General

I'm an FME newbi. Feel like it's something very basic but couldn't come up with a solution on my own.What I want to achieve is to get 80% of the value from column B to column A, but some of the features have multiple values separated by a comma, soo they come out as NULL. I went through previously asked questions but couldn't find anything. Appreciate any help! 

I would like to buffer certain sides of a polygon. My polygon as in the image below and I would like to buffer them in the direction of arrows. How can I do it with FME?  

I tried to convert an RVT to CESIUM 3D Tiles in FME 2022. Coordonate set to WGS 84 .Allthough i set coordonate in the start and at the end . When i upload in cesium the coordonate still set to (0,0).IS ANYONE CAN HELP ME?

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?

 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,

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 a

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

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.