FME Form

Hi all, I am trying to convert a CSV file generated from IoT censors to file GDB. The table got a geolocation field in which X and Y values were separated by comma. I wanted to get the data on LL-GDA94 projection. Although I was able to create a feature but it was not projected properly and appeared out of map extent in ArcGIS. Can anyone help me with the script that I have added here? I am attaching the CSV also. Thanks in advance.

Hi,I am trying to create From-To lines from every point in a shapefile to every other point. I have 45,989 points, so (in theory) each point should have 45,988 lines coming off and attaching to every other point. I have attempted to use both the FromToBuilder and the LineBuilder, but neither seem to work.Does anyone have any ideas that might work?Thanks

I'm making a custom transformer at the moment which I intend on putting onto the Hub at some stage soon. With my transformer there are two possible output streams. One adds certain attributes to the input, and the other makes a list instead of the attributes.  I would like this to go to the same output port but only expose the relevant attributes depending on which stream. I'm finding that if I have the transformer settings so that it makes a list attribute then the other attributes will still be listed, but as <missing>. I would like there not to be empty columns.  I can't seem to work out how to get into to only expose the attributes that exist and not just all possible ones from both streams. Changing the settings in the screenshot to the relevant selected attributes will look fine for one of the streams but not the other. As a side question, I have a <Rejected> output port. I'm trying to make the documentation

I have a workspace set up to terminate based on parameters that it has failed on. Is there any way for a message to come up as to why it failed that isn't in the log? Primarily for users running it that don't understand the log file and how to read through it so that they know why it failed?

I am bringing in an excel table and then adding some different attributes to it and writing it out to a geodatabase. I need to create a unique ID when writing it out to the geodatabase. I have brought in the original table and determined what the largest ID number is. I can't figure out though how to add it to the workspace without each row getting the same ID number.

Hi,I have a kml file that is created from a MapInfo Tab file that has 9 polygons, the polygons are all the one colour and will change to another colour if you hover over it. Now I want to remove the old outline colour and assign a different colour to each polygon using the Asset_Mgr_Region field to filter by, but still retain the highlight on hover. I am not sure where to place the Attribute Filter to achieve what I want, how do I use this? I have attached my workspace. Thanks

HI guys, I have a question. How can I generalize points in FME Desktop?I have like 10 points, each point is very clos to other and I want to make from them like less number of points like 3-4 maybe. I've tried with generalizer but it's not working, any suggestions?Screenshot below.TIA

Hi,I need to denormalize rows into repetitive numbered columns. Here's an example.Here is the normal version as it is in the relational db. Note that the three rows all have the same value in ID_DETAIL field.Here is the desired result. Note that for this one DETAIL, we end up with three groups of columns (ID_MENTION, MENTION, PRECISION).How would one do this in FME ?The number of repetitive groups of columns would be defined by the detail in the dataset having the most mentions (in my example it was 3).I was thinking of some kind of grouping on ID_DETAIL and some kind of "for-each-loop". But any better suggestion appreciated !

I have thousands of photos, under multiple sub folders, which i have been attempting to extract the photo date. I have used the jpeg reader together with option to search sub folders, however, none of the exif options allow me to append the original file details. I'm new to fme so it's probably something simple as if i pick a single file then the filepathextractor works a treat. 

I need help to figure out how to reorder the field "Shape". I tryed multiple things has these three options and also tryed to use the Attribute Menager transformer :But has soon as I play workspace, the "shape" field always appear at the end of the table. The problem is that it has to ben at the second place like on the image below.Thanks a lot in advance :) 

I am trying to view the DXF file using cesium, for now, I succeeded to convert the DXF (2D) file to MVT/GeoJson ( a format that can be viewed using the cesium), but the MVT does not contain style (colors, hatch, line type/width, dashed, font.... ), all the style of the DXF is missing, any suggestion/ideas to view the DXF including the style using the cesiumJS?

Using the circle below as an example. I would like to close the gap, doesn't really matter if it is by snapping or adding a vertice. I have tried both Snapper and LineCloser, but they don't seem to work when there is only one geometry.  How can I connect the start and end points in the example below? I would rather not use the LineCloser of fear of self intersections (real world features are more complex than my example), and the HullReplacer is to slow.   

I have a python script that reads a set of values that we want to expose out of PythonCaller as a list; however, after several attempts, we are having issues outputting the list out of the Transformer. Running the script works outside of workbench, but having issues incorporating the script with FME. Debugging the script and writing to the log, we know the code is calculating the values for the list consisting a several attributes. And, the thinking is we are not formatting the list correctly or defining it. I have attached a simple workbench that contains a slimmed down script that we are trying to utilize to determine how to output a list at all. Any help in this regard is much appreciated. Here is a part of the slimmed down script listing the nested loop we want to use and the List name we want to output:   def input(self,feature):         npts = 3         # do a bunch of stuff with other input attributes to populate D

Hello there using the parameter $(WORKSPACE_NAME) to get the workspace name not working if the works[ace is saved as template, we get a different name as an example the workspace saved as a template with the name ( cad_to_gis.fmwtwhen use the parameter $(WORKSPACE_NAME) we get getting this name ( wb-late-1653463418287_7640)Any idea Please Thanks

I have a WMS feed that I want to include in an HTML report but don't understand how to to get the HTMLReportGenerator to use it. I have a polygon layer that I group by, buffer it slightly and then user the feature reader on the WMS layer.  If I user the Map option the base map is present but no WMS. Any suggestions?

Hi,I created a FME workspace in which I connect to a web service published on AGOL. The service consists of a point feature layer (inventory layer) and a linked table (inspection table), used with the Field Maps application to perform regular inspections. The main objectives are among others:Extract the weekly inspection results in Excel formatArchive inspection data as an existing file Geodatabase, but keeping only inspection table results for all subsequent inspectionsThen truncate the inspection table in AGOL.The first goal has been successfully achieved, unfortunately I am struggling to complete the next steps of copying the data from the inspection table to the File Geodatabase and then truncating the results from the inspection table after the execution of the first step.Could someone show me how to implement the steps to copy data from inspection table to file geodatabase and delete da

I have a CityGML file with some attributes containing numbers, but also strings. But for example, the folllowing attribute is supposed to be a float or integer in the 3DTiles format, but is written as a String, no matter what I specify as datatype in the writer's user attributes. <gen:stringAttribute name="DatenquelleDachhoehe">   <gen:value>1000</gen:value></gen:stringAttribute> What could be the reason for the 3Dtiles writer ignoring the specified datatypes?

I am creating a FME server app that reads shapefiles, applies some spatial analysis and then writes the results out to shapefile and an excel. Input shapefiles however will have varying schemas/attributes. The source I have set as a user parameter, that will prompt the input shapefile path. How do I get my reader to process/read varying schemas? I have ticked 'Merge Feature Type' on the reader. I assumed this would adjust the user attributes dynamically based on the input, but the schema remains fixed to the shapefile I set the bench up with.

Hi everyone, Is there and options for i would like to download data from OSM witch based on secondary property of the lines this time show that is it a roundabout or not. Or is there any transformer witch able to find them(roundabout).  Thanks :)

Greetings- I am trying to have a FeatureReader (set to format 'Directory and File Pathnames') fetch file properties for a list of 'Dataset' paths and 'Path Filters' which are incoming Attribute Features but have been unsuccessful in getting it to recognize them as valid. . only 'fixed' values seem to work. I've been through the help and Community posts on this and haven't found anything so far. Thanks in advance for any input.

Hi all,I'm trying to merge two separate excel spreadsheets. Both worksheets have the same names and number of columns. However, they do not have a common primary key to perform a join. All I'm looking for is to append the contents of the second spreadsheet to the end of the first so that I have a single spreadsheet at the end. How can we achieve this kind of merging without using the FME transforms inheriting from the SQL language (FeatureMerger or FeatureJoiner) in FME Desktop?

Hello to everyone,i am working on my master thesis and for that project i try to bring CityGML data into Revit. In the end I want to use the data in Dynamo. Therefore I search for a workflow for CityGML to Revit integration. Unfortunalety I can find a lot of information for BIM to GIS, but not the other way round. Does anyone can help me with advices, recommendations or ideas? Kind regardsMartin

I recently had my SMTP Gmail subscription start failing over the weekend and had been wracking my brain on how to solve this and found a difference in SMTP Server Settings that Google recommends vs what is on the template. Google recommends using smtp-relay.gmail.com. The template is still using smtp.gmail.com and is failing on the connection.  This may have been fixed in a more updated version of FME Server.  Thanks 

can anyone tell me if FME can convert Revit file to IFC file?

Hello,I'm using FME SDF Writer, but I also need to write some non-spatial data to my SDF file.However in the SDF writer I seem to be forced to always specify a Geometry column name in the Format Parameters section of the writer.If I specify the default: "Geometry" Autocad still recognizes the feature as a spatial feature but without a geometry and it complains about this, if we want to edit such features.In the "Feature Type Properties" section of the Writer, I have used "fdo_null" for the geometry.The difference between an original SDF (with a non-spatial feature) and one generated by FME SDF writer can also be seen in the FME inspector.The features written by FME have an extra attribute