FME Form

I can read this geojson below in fme. In this example (I & J) at the end of the string Fjson&I=800&J=422 It will give me back a responds. However looking to loop through all possible values of I & J Imax=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_A Table_B Table_C i 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 area Create vertices around centre point so LineBuilder can create 4 x arms of cruciform( N,S,E,W) Create points on lines using DistanceMarker Label 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 tried f

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/15 The 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 CenterPointReplacer f

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 then running CenterPointReplacer on the resulting point

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 this custom method I h

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've got a really challenging question received from a customer ! The domain is Heritage buildings protection. An architect/historian evaluates the value of buildings and gives them a mark. He then presents his proposal in a PowerPoint : Identification info Description Mark Label etc. Pictures The proposal is reviewed in several sessions, with different people. The mark may be upgraded or downgraded, the label changed, etc. Once validated, the data is to be captured in an SDE geodatabase. Presently, this is done in two different ways : Manually Manually copying the data to Excel and it is imported in GDB with FME But in both cases, there is a non profit-adding step, which is to manually copy the data. Does anyone out there have an idea how to skip this step ? Could the PowerPoint presentation be structured in such a way (with keywords for instance) that could make the content recognizable and importable directly ? I have thought of different ways but I'd rather keep it open for

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.

I'm currently using the 'change detector' transformer to compare incoming data with an existing database, and my challenge is that the comparison always seems to spit out the features as being 'updated', even though I am testing by comparing essentially the same exact datasets, so I expect it should be exiting out as 'unchanged' instead. The inputs are coming from a Portal feature service and a geodatabase When I toggle the 'Check geometry' off, it seems to work correctly and detect the features were 'unchanged', so I'm guessing it's some slight changes to the geometry that may be causing features to be seen as 'updated'. I'm already using the 'coordinate rounder' to alleviate some slight variations, but are there other approaches I can try to help figure this out? Thanks!

Hi, We have been trying to set up a process where our users can email their files to a shared mailbox and FME can extract the attachment & process the attachment from emails in our FME server fault tolerant deployment without success as neither STMP nor IMAP option is possible. Our IT tech lead wanted to check if we can use EWS with FME server. I have read an old thread that this can be done through XML & httpCaller but I couldn’t find any further details of how to set this up. I also saw there is the Microsoft Graph API option and wonder if it’s recommended. Our IT Tech lead prefers EWS as we have another application that was already using EWS. Would be much appreciated if you could point me to the right direction. Many 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