FME Form

For example, I have a "Description" attribute, and I want to create a new attribute called "Categories". Features in the description attribute containing the word "gardening", for example, would go into the "Gardening" feature type of the new attribute.

Hello Experts..I need your Guidance and Help.. would like to transpose the information available in the FME template i have attached ..In attribute Keeper Transformer - I have 2 fields name JSON index and Data ..I want to JSON Index in Row as heading and Data is its corresponding Value.. I have attached workspace ..Also , I have tried to follow this Article " https://community.safe.com/s/question/0D5Dm000006Zdi5KAC/transpose-a-table"I want to transpose this and aggregate itThe results Comes in this way Kindly Support and Guide Thank You

The data that I have is like the following: I would like to substract the information within the brackets, so I get the following result: Can anyone help me how I can achieve this within my workbench?

HelloI am generating a json file for photographs metadata.At the start and end of the file I have an open bracket and a closed bracket. I don't want to have this square brackets in the generated json file.Thanks

Why is Microsoft System CLR for SQL Server 2012, still a requirement for FME to work with SQL Serve Spatial - We are on SQL Server 2019, and we have CLR 2019 and 2017 installed. Surely it should use the CLR that is installed. Without 2012 CLR installed - FME does not work. 

I try to intersect a line with 3d coordinates and a polygon with 3d coordinates. How can i calculate the intersection point (the two screenshots may help)? Are there some properties that i have to use? Thank you for help!

Hi !Any idea how to create a 2D grid with hexagons instead of squares?I would like to reproduce this tool : https://pro.arcgis.com/en/pro-app/latest/tool-reference/data-management/generatetesellation.htmI tried HexBinner transformer but it works with points. So when I try with a grid of points I created, there is some holes in my grid, as you can see... Thank you !

Hi, I need to validate if the TFW file content corresponds to the associated TIF file.Therefore, I'm reading the TIF properties (with RasterPropertyExtractor) and I'm reconstructing the 6 TFW-paramaters, to compare them with the content of the TFW file.But... the problem is that the Reader reads the TIF file with the parameters coming form the TFW file. Hence, if the TFW is wrong, then the TIF properties extracted with RasterPropertyExtractor are also wrong.Is there a way to force FME to ignore the TFW file when reading a TIF ?Thank you for your help.

The SFC (Scadec Feature Comment file) file is a format for Japanese specifications; it is used to store CAD data and is included in the SXF (Scadec data exchange format) format, a CAD data exchange standard.

I have a Data collected using Survey123 but sending data has issue and it was stored in android device only , so the format will be in sqlite database.. I want to extract the data from SQLite database and im able to read and see the data but not able take it into XML Fragmentor ..May be im doing some wrong.. I have attached screenshot and workspace ..Need Guidance and advice to fix this Thank YouNeed expert advice 

Hi ! I have a workspace with the version 2018. I would like to launch with workspacerunner with an other workspace with the version 2022. That doesn't works but maybe there is a way to make it works. Do you have an idea? Thanks !

I need to filter by date. Its a CSV: that I need to filter by both Open and Closed status. But I need to find the Closed work orders that have been closed in the last 60 days. I am using TESTER to do the filter.

I keep getting an error in my Python caller transformer trying to convert dates in the format '%Y%m%d' to Python 'datetime.datetime' format. The transformer works for the first 236 features and generates the following error:Python Exception <TypeError>: strptime() argument 1 must be str, not NoneTraceback (most recent call last): File "<string>", line 38, in inputTypeError: strptime() argument 1 must be str, not NoneError encountered while calling method `input'I have examined the input data and nothing seems out of place or wrong with the data. I am not sure what's causing this.

I'd like to divide my 3D polylines by 3.28084 (feet to meters) - I think I'm close with 3D Forcer, using Arithmetic Editor but it's not quite working... @ZValue()/3.28084

Is it possible to write an AutoCAD Map 3D dwg with an attached FDO connection?I have a library of predefined .layer files containing the connection prepared.

I am migrating data and are using a dynamic workflow. When I am using the PostGIS writer it run smoothly. But since i need post processing after writing to DB I sat up the FeatureWriter identical to the PG one. But the writer fail du some encoding issues on attributes with Nordic characters in their nameFeatureWriter (WriterFactory): POSTGIS writer: Internal Error: Failed to copy attribute 'FØRSTEDATAFANGSTDATO' to 'fã˜rstedatafangstdato'I cant see this being about case sensitivity since there is no issues using the regular postgis writer.Any ideas how this can be solved? Looks like a bug to me? 

In FME Desktop 2019.2 b19825, the Microsoft SharePoint List Reader/Writer offers SAML as an authentication method for reading from our corporate SharePoint sites.   This method is now absent in 2021.2 b21784 and none of the other authentication methods seem to be working for me. Why was this option removed and is there a workaround to getting FME Desktop to connect to SharePoint sites using normal SPOL credentials.  

I need a polygon or closed polyline of the extents of this data; using max and min (x,y) gives a bounding box which means further down my pipeline, data is being written to areas that should take "No Data". How can I grab extents from the point cloud to use it as a breakline? Pictured; point cloud, and point cloud overlaid raster output, showing data written outside the point cloud extents

Hi, We have tables of values with colors in Excel that we would want to integrate in a mxd.I though to export them automatically in jpeg files. It would be easier after to integrate images in mxd.How could I do that with FME? Thanks !

i want to merge multiple pdfs in order sequence and in one booklet how i can do please help me

I was following to do a tutorial on "Extracting Data within a Clipping Polygon using FeatureReader" but I do not know how to create published parameters from the Navigator. I am knwe to FME. Can you please help.Regards 

Hi all, I have a very simple requirement, find the closest location on a polygon to some points then move the points to that location, this has been achieved using the NeighborFinder and VertexCreator transformers. Further on in the workspace I need to use a PointOnAreaOverlayer to transfer the polygon attributes to the point layer (I realise that this can be done in the NeighborFinder step but for the sake of this post, lets assume this is not possible). The issue I am coming up against is that even though the new location of the point is determined by the NeighborFinder, in some cases the point and area are not considered to be overlapping by the PointOnAreaOverlayer. This is my very simple demonstration workspace:The initial features do not overlap:Once run through the workspace they appear to overlap:However, according to the PointOnAreaOverlayer, one of the points does not overlap:The point that does not overlap (according to the PointOnAreaOverlayer) is the southern most point (

Hi. I"ve a XLSX files. The XLSX files contain 2 sheets. Each sheets have common field (sample_ID). The first sheet is a description of the sampler, like the report name. In the second sheet it's the result of station. For each station it'S have many result ( 1 to M relation). I want to update a field in the second sheets with the value of the first sheet. But i have a error message (check the Capture files). Thank for help :)

So I have created a work space with an SQL Creator to query a table of inspections I am interested in. It seems to have the proper number of results showing, but I am not sure how to actually view the queried table in the FME interface. I also have a feature class from our SDE in the workspace as well as the table of ALL the inspections. What I want to do is only use the related features that would match to records from the SQL Creator query to export to ArcGIS Online. I also want the full inspection table to also be exported to ArcGIS Online, so that a user can click on the feature and see all related inspections (which should include the one from the SQL Creator). Hopefully that makes sense. Here is what I have so far...what do I do next??  

Hello,I am creating a josn using the json Templater. In my setting i have a subtemplate that must to be an "object" and contain a lot off nested attributes that are "list".In the situation where only 1 attribute is populated, the final result is good (Topology1record.jpg screenshot) but when I have more attributes populated the result is an array and not an object (Topology2records.jpg screenshot). I also attached the templater to show what I did.My final result should be: {  "type" : "FeatureCollection",  "features" : [     {         "id" : "rfs:7BBE13D625241D58",        "properties" : {            "topologyCharacteristics" : {                  "isPaved" : [                    {                       "range" : {                          "endOffset" : 1,                          "startOffset" : 0                       },                       "value&