FME Form

FME Desktop 2020: How to map excel table using “schema mapper”? I couldn’t figure out how to link the attribute table of a layer with an excel table. In the screenshot below, I wanted to link the attribute layer with an excel table based on the autocad_color and ColorNo fields in order to get the “type” field values transferred to the layer. How could be performed? The data is attached             

FME 2020: How to filter dwg file based on hatches and Areas (polylines)? I couldn’t figure out how to filter dwg file based on hatches and Areas (polylines).   

FME 2020: How to filter dwg file based on lines and polylines? I couldn’t figure out how to filter dwg file based on lines and polylines 

Have two workspaces that when I run it under my account or the service account on the server, it runs fine, published to FME Server and set up automation. It APPEARS to run (one workspace checks for the latest zip file in a directory on a file share and then copies to the resources directory and unzips on the server - this works as it should under both accounts and in FME server when run separately thru Run Workspace). The second workspace is to process the data that was unzipped and place in the resources directory - the files are separated into two directories due to how the vendor supplies the data for download - the script will read this data via either account. It will operate as expected when run with Workbench. Running via Server it processes, but when I look at the output data, not all of it is there! The csv files appear to be appending to the tables in the SDE. The graphic data doesn't even show that it attempted to write to the feature class. I'm stumped. The graph

12d has the ability to close polygon without making the last vertex sit on top of the first vertex. ( ie a square\\rectangular polygon has 4 vertices and 3 segments)When the last segment of this closed polygon has a radius, a 12dxml file when viewed in data inspector or workbench, does not show the last segment as curved. When compared against a polygon that the last vertex sits on the first vertex (ie 5 vertices, 4 segment polygon) then FME displays correctly. When I look at the properties of both strings in inspector, the two different properties are No. of vertices which is 5 and the field under IFME Polygon called Linear Boundary is yes for the scenario of not displaying the curve on the last segment. For the polygon that does display correctly, these two fields are 10 and No. Would appreciate anyone with any 12d knowledge to assist or what the linear Boundary field meansNote uploader wont accept 12dxml file format so you will need to rename the attached to polygons.12dxml to vie

Hi everyone, I'm currently trying to received form data via HTTP POST. There is a very good article on it which I follow every step (https://community.safe.com/s/article/send-source-data-to-fme-server-with-http-post). The connection between postman and FME server is working fine, but it look like I'm not receiving any data.  I've made a test workbench (PS) to see if my writer would received the form data, but the writer is empty as if my reader is not downloading the Data. When i published the workbench, the parameter "Send HTTP Message Body to Reader" is set to my current reader.  I have put the form data in the body section. Do I need to write it elsewhere?

Hi, I'm a bit stuck and would need some help.As you can see 2 point layers as shown in the image with different colors. All the points have same name 'iris' though their ids are different. I need to match the closest same name but the ids shouldnt repeat.For example: here in the below case iris id 11 and id 12 have iris id 2 as their closest. But what I'm wanting as the output is that if iris id 12 gets closest match as iris id 2 then for iris id 11 it should not consider iris id 1 and check for next point which hasnt got a match with any other point yet i.e. iris id 1.Let me know if there is any possible solutions for it.Thank you.

table 1table 2 Expected result is : table 3:actgeneric_id------- fNotam_id1.2.1.1.3.1 ---------- 1.2.1.1.31.2.1.1.3.5.1----------1.2.1.1.31.2.1.1.3.5.2----------1.2.1.1.3 .... .... ..... .....1.2.1.1.4.1------------1.2.1.1.41.2.1.1.4.2------------1.2.1.1.4............ 

I am trying to use SpatialRelator with SDE and GDB layers that are the same data but the data is not matching up. I am using "Requestor OGC-Equals Supplier" to compare the layers. The point is when we get new data we can uploaded only the changed data into the SDE but I am unable to get the layers to match up. Both are WGS 84 and line up in FME Maps and in ArcGIS Pro they also intersect when running tools. There is no errors in the FME work flows that pop up after running it.

The reason I am asking is, I am running out of memory when running my FME script.|FATAL |Insufficient memory available -- error code was 2 - please read the FME Help section 'Adjusting Memory Resources' for workarounds.

Table A:Table B:Result:How can i do it with Feature Merge transfomer in FME 2016 Build 16494 ? pls ..

Installed FME Server, Desktop 2021.1 version in AWS EC2 instance, After I published the WB and executed successfully in my machine. The same web URL need to be work at public network too (this is the requirement), but this is not working . Could some one guide/help me how to fulfill this requirement?What steps I have to follow to make this run.

Hi everyone, I am trying to download a set of files with the AutodeskBIM360DocsConnector and save them to a temporary location. The temp location is generated with the TempPathCreator. The BIM 360 connector does not have the option to pick an attribute for the "Download to Folder" parameter. Typing out @Value(DownloadLocation) seems to trigger FME to recognize that I want to use an attribute value, however during translation the attribute value is ignored and instead FME uses the string I typed in i.e. it creates a map named "@Value(DownloadFolder)".   

I have text where spaces between some words is missing. These spots are easy to find with regex because it is always something following by capital letter without the space. I can't workout how to add the space though. My String Replacer looks like this: @ReplaceRegEx(@Value(Speciality),([^ ])([A-Z]), \\1, \\2) The output it produces is:Anxiety, Panic & Phobia shildren & Adolescent selationships Outside work (ndividual counselling )eadership Original:Anxiety, Panic & PhobiasChildren & AdolescentsRelationships Outside work (Individual counselling)Leadership So it adds space, just not where I need it and removes the capital letter. I tried many variations, but none of them produces the needed outcome. 

My flow includes a looping Custom Transformer that gets records from a paginated API until there are no records left to get - unfortunately the API doesn't have a "last page" flag or anything, so the only way to check that the flow should end is to keep trying until we get a 400 Bad Request status code with a message like "Request out of range". When this happens, the loop should break and output all the features that have been created up to that point. At the moment, the only way I can get this to break is with a Terminator, which is (a) making the flow look like it failed, and (b) not allowing me to continue with the next steps of generating a HTML report. Is there a more graceful way to exit a loop? The transformer looks like this:The relevant part in the flow itself looks like this. The Tester is doing exactly what it's supposed to, but it doesn't seem to be reaching the HTMLReportGenerator.

Has anyone had any experience in the telco space with developing cellular / mobile phone coverage maps using FME? We want to be able to do near real time recalculations when towers are not operational to figure out any gaps in coverage areas.  

Hello,I'm attempting to write a dataset to AGOL. This dataset comes from another system with ~25,000 records. So far I've been reading this dataset and processing it with my workbench without error for a some time now. Last week it began to fail with the error:"ArcGIS Online Feature Service Writer: Encountered an unexpected error. The error code from the server was '400' and the message was: ''. Details: 'Field WORKDESC has invalid html content.'"The datset has a field WORKDESC that contains freeform text entry where staff describe the details of a building permit. I suspect from my troubleshooting that somewhere along the line a strange character has been entered that the AGOL writer is interpretting as html content.I'm looking for some tips/suggestions as to however to 'clean' this field so that this error doesn't hurl my workbench. However, I don't really want to manually dig through the dataset to find the specific chara

Hi FME Community,I have converted my Excel file into a CSV file. I would like the heading to be automatically deleted.In the picture I have shown with red marking which part has to be deletedI would be grateful if you could tell me whether there is a solution.Thanks in advance

Hi,I have a scripted python parameter which generates a unique id. This parameter is used in a lot of SQLexecuters to to create and insert into temporary with this id in the name of the table and such. When I run the workspace it works fine, but when I put feature caching on the value of the parameter seems to change each time it's used in a SQLExecuter. Is this a knwn issue? Is there a simple work around?I use FME 2021.1.3.0. I don't know if it worked before. Thank you,Arno

I have a basic project as shown in the screenshot. In this example there are 54 items that need data cleansing (at the rejected port), I am wanting to send ONE email at the conclusion of this run, with a list of all the Property Numbers that were captured here.  If I add an emailer at this 'rejected' port I will get 54 emails. I am assuming there is a simple way to list then expand into the body of a single email? 

I have created a "i3s_terrain_mesh" out of a DEM. Following the description on this page, the terrain mesh would replace the existing terrain in the scene viewer. In case we talk about the ESRI ArcGIS Portal/Online Web Scene Viewer, how would that work?  As far as I understood, only elevation layers can take over this job when being added to the scene. Even turning an input into an "i3s_terrain_mesh", we deal with an SLPK, that has to be shared and published on the Portal.In a web scene, such an added SLPK is not interpreted as a layer that can be added to the "Ground" - replacing the default terrain 3d elevation coming from ESRI. Have you any experiences with this?

Hello, so I want to find a missing value as all the "Unit" must be in sequence in each floor.​Here are my rules:All the units should be assigned sequentially to the corresponding floor, meaning 1/F: Unit = 0001, 0002, 0003, till to the largest number in the data2/F: Unit = 0001, 0002, 0003, till to the largest number in the data​I have "FloorNo_FromFloorPolyID", meaning the level of floors."Test_Unit_No" meaning the numbering of the unit.​I want to find out the missing unit number of each floor as the input data will have a lot of floors in the future. As the sample shown below, Floor 10 is missing Unit 0001 to 0004.​Could someone please give me a hand. Should I use python caller? Yet I have no clue how to write script ... please help.​Thank you in advanced.

How convert to complex XML to creating relational database tables ? using xml hieararchy

I have xml file and convert relatinal database tables for using xml hierarchy(parent-child) so is there any automation tool for this process ?