Transformers

I want to put the coordinate value in the obj file modeled on the 3D building in FME Desktop and print it out as a City gml file. I'm going to upload the printed file to the website of 'CESIUM ION'. I'm curious about how to put the exact coordinate value and print out City gml and upload it. I would really appreciate it if you could tell me the process sequentially. 😂

Hi, I published a workspace to the FME Server (2018) of my client that allows to import a specific sheet of an Excel file in Postgres.But when the input file has zero feature or when the specific sheet doesn't exists, the Workspace doesn't log any error and says that translation was successfull.Of course, we could open the Excel file to check the data but this workspace is running with automatic processes.Is there a way to log an error when there are no features in the input file or when the awaited feature type (Excel sheet) not exists ?Thanks for any help.

I am trying to create a workbench which will read in the data from a table in an ArcGIS Online feature service, where the feature service is determined by input User Parameters at each run of the workbench. The output will be an excel export of the data from the ArcGIS Online feature service table. I have hundreds of different feature services, identifiable by a unique alphanumerical code and feature service ID. The aim is for the user to input the alphanumerical code for the data they want to export when running the workbench (e.g DA019). This code will act as a look up to a table that contains the feature service ID for the required data. I have then attempted to reconstruct the syntax of the AGOL connection as seen in an ArcGIS Online Feature Service Reader.E.g [AGOL Group Name]/[Feature Service Name]([feature service ID]) I then have passed that as a field called fsid_search into a Feature Reader under the 'Feature Service:' constraint. I've included a screenshot of my

Hello everyone, I am new to FME and I would like to do automatically the task described in the photo, which is an "unmelt"s . I went and check the transformers "ColumnToRow" that did not work for me, and AttributeCreator that works but needs to add one by one every attribute "Thing1", "Thing2" ... Or maybe I missed something ?Thanks for your help !

I am taking a feature reader (ESRI geodatabase) and putting a feature class through an attribute manager. The feature reader shows the guid fields correctly as guid.However, the attribute manager shows them guid fields as buffer.This is happening for all guid field. I've tried "reset table" and import from dataset in the attribute manager. I've also tried recreating the attribute manager. How can I fix the attribute types to be accuate?

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?

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

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

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 :)

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&

This seems as though it ought to be really simple but I can't figure out how to do it.I have a number of text files which each define a polygon by listing the coordinates of its vertices. I'd like to build polygons from the coordinate lists.Usually I'd use the VertexCreator to build points/polygons but I can't figure out how to get it to iterate through a list of variable length.Some of the lists are also quite long (20+ coordinates) and it seems there should be an easier way than adding 20+ VertexCreators in series!

I have been trying to implement a similar solution to that posted by SAFE around HTML reporting and the java accordion feature as referenced in https://community.safe.com/s/article/how-to-customize-html-reports The different is that I am using the group by function in the HTML Report Generator The accordion is appearing as expected  but only ever second category is able to expand  I know this is not truly an FME issue but more likely a HTML formatting issue but just wondering if anyone has had success with using the accordion functionality with the group by option in the transformer. The transformer is set up as follows:and the results of each HTML report seem correct Any insights would be greatly appreciated. Thanks Dean

After LineJoiner some lines are joining in the way of making self closing line geometry with start and the end point in the same spot.Is there the way to identify and repair such lines or maybe there is option in LineJoiner to avoid such situations?

Is there a way to read in the data and keep the address field in one column? Any help appreciated.

Hi I have installed GoogleCloudPubSubConnector from the hub but I am unable to use it since it keeps failing the test for web service authentication.https://hub.safe.com/publishers/safe/packages/google-cloud-pubsub I can't proceed further, I always receive this error message:Error 401: disabled_clientSign in with Google temporarily disabled for this app. This app has not been verified yet by Google in order to use Google Sign In.  Does anybody encounter this before? Thank you 

Hi there, I'm running into an issue where an attribute that was initially numeric ('counts') is being converted to a character type after I sum 'counts' for each 'tree_type' per 'area_unit' using AttributePivoter (example left to right in image below). Note: These attributes/data are just an example. This is a problem as I'm trying to write the results as a shapefile, which won't work properly for analysis in ArcGIS Pro as it recognises these fields as text rather than integer. Here are more details about my process for summing counts of tree types by area unit.  Input = CSV and 'counts' is read in as UInt32. 1.) I used an AttributeExploder with exploding type set to List, Keep Attributes = Yes, and Keep Geometry = No (Geometry is added later).2.) AttributePivoter, Group Rows By: = 'area_unit', Group Columns By: = 'tree_type', Attributes To Analyze: = 'counts', Pivot Summary Statistic Types: = Sum, Row Group Su

I can't find a way to do what I want.I got a certain number of features. I want to find the max(date) on attribute date for those features, but I want the max(date) to be in relation to a condition on a value from an another attribute status.  So I want the max(date) to be calculated and returned first from feature where status = completedif no features have a status=completed then returned max(date) from the other features 1 20230330 completed2 20230329 completed3 20230331 running4 20230329 waitingwould returned max(date) from feature 1 : 20230330 1 20230330 waiting2 20230329 running3 20230331 running4 20230331 waitingwould returned max(date) from feature 3 or 4 since no value set to completed :20230331