Transformers

I got a dilemma Iam trying to solve, but after 2 days of constant hacking I cant figure out how to do it. The script should run on fme serverUser adds an excel-file that constantly changes, the column names containing the coordinates can be named whatever, the sheet can also have different types of coordinates.Vertex creator to create points from coordinates so the workspace need to handle those scenarios. I tried adding two published user parameters where the user needs to type in the exact name of x or lat column and y or lon column. So my idea was to get the values from those columns and then clean the coordinates, replace . with , and other things. But the problem is I dont know how to get the values inside those columns. I know fme cant know what attributes the file has but in this case the user already specified 2 columns so that should work? Any ideas on how I can solve this problem? If its not possible, the alternative must be 2 workspaces but I cant find any tutorial on how to

Hello, for some reason, I'm unable to find EPSG: 6428 on FME Desktop when using the reprojector transformer. Is it considered a custom PCS? if so, how can I add it?

Hi, I'm currently trying to create a line between my lines. As you see in the image, I would like to create a line in the middle of the lines that respect the angle of that group. I've tried to select the longer line of the group and move it to the center point of the group with the offsetter, but it only "offset" the line and not move to the specify coordinate. Thank you in advance

Hi I want to know why this happens so I can correct it in the feature. I attached the example file "Excel" containing only one row so you can test for yourselfs.  In Excel both coordinates have comma. When I use Excel Reader in FME it changes only attribute value for attribute aa to a dot. But for bb its still a comma.This is maybe why I cant create a point using vertex creator, even tho I use string-replacer to change both values to dot or comma it refuses to create a point. This happens fairly often so It would be nice to know what cause this issue and how I can solve it. It might be a bug or something to do with Excel. If I create a new excel file and manually enter every value then it suddenly works. But this is not something I can do with an Excel containing thousands of rows. Iam using Fme 2020.2.5.0 Build 20827 - WIN64   

Hi everyone, I just started out using FME Desktop for my job. I am trying to find out how it would be possible to use group by based on a combination of attributes. The example is just something I thought of, so not based on real data. Initially, the source data in this imaginary case would just have an overview of all the shops. First, I would like to have an overview of the amount of shops per mall. So first I have to group by based on which mall the shop does belong to. Thereafter I would like to group by based on what type of shop it is. E.g. Clothing store, ~department store etc. So for example from the 100 shops that belong to mall A 10 are clothing stores for example , 4 restaurants e.g. i tried it with the StatisticsCalculator, however when I put put all these attributes in the group by field, I don't get the result below. Instead of grouping first on the type of mall and thereafter looking at the type of shop, all attributes are considered in the grouping equally. So

Hi. I have a FGDB (esri) table and i want to reorder column. I try attribute manager to redorder column and it not seem work. Can you help me. Thank

Below software were installed...ArcMap & Arc Catalogue 10.8 with ArcFM 10.8.1ArcGIS Pro 2.864Bit Background Geoprocessing toolsFME 64Bit 2021.1.2 Build 21627 Data has been restored using SQL Server 2016 in server and I tried to add the writer using ArcSDE Geodb in client workstation. After selecting the writer format and entering all the required parameters and last by selecting the feature class name, neither writer is added nor error is prompted in FME environment. On the other end, I'm able to add feature class in ArcMap and add features but I'm not able to add feature class in ArcGIS Pro. Can someone suggest what is missing in my process... Thank you

I have a workspace that's reading in some data and I've added a counter after it. The Counter is giving me some valid count numbers, but a lot of the attribute are a weird string like this: `@Value(__fme_ft_return_valuebbc4ad18-5750-4f14-a514-caca849d5cc2)'

I am trying to download a Revit file from Azure Storage and pass it to a FeatureReader so it can process it, but I am getting fatal error```FeatureReader_rvt_2_<Rejected> (TeeFactory): FeatureReader_rvt_2_<Rejected>: Termination Message: 'FeatureReader_rvt_2 output a <Rejected> feature. To continue translation when features are rejected, change 'Workspace Parameters' > Translation > 'Rejected Feature Handling' to 'Continue Translation''FeatureReader_rvt_2 (QueryFactory): Termination Message: '%0'AttributeFilter_3_Filter (AttributeFilterFactory): Termination Message: '%0'A fatal error has occurred. Check the logfile above for detailsPythonFactory output feature was rejected downstream. Check the logfile above for detailsA fatal error has occurred. Check the logfile above for detailsError encountered while calling method `input'AzureBlobStorageConnector_CALLER (PythonFactory): PythonFactory failed to process fea

My first question is regarding the GeographicBufferer. There is a documentation page here on this transformer but I cannot find it in the FME Workbench (2021.0.3.0). Has this transformer been removed and/or its functionality incorporated into the regular Bufferer ? I was hoping the GeographicBufferer would be able to correctly handle the buffering of polygons across the antimeridian (180° E/W). The Bufferer seems to have a problem if the buffering crosses the antimeridian. Does anyone have an idea how to handle this case - maybe with additional transformers?  Attached please find a zipped geojson file which contains the coverage polygon of a navigational chart. Using the Bufferer and trying to buffer this polygon by 1200 metres results in an error on my side. What can I do to properly buffer this polygon?

Hello Community, I need to write objects in a versioning complex feature class, but FME gives me the following error: An error occurred while attempting to store a row into the table 'UTARC.FCL_S_MESSPROJEKT'. The error number from ArcObjects is: '-2146233079'. The error message from ArcObjects is: {Der Erfassungsmaßstab wurde nicht initialisiert.}

Hi everyone, I am experimenting with using the new BIM360 Docs transformer on Desktop to search trough a specific folder and download some files. The first step I want to perform is to use the list command in the transformer to get a list of available files so I can find the id of the files I actually want. Unfortunately I cannot get the list command to actually work. I can browse through my Hub, Project and Project Folders so I think the connection is working correctly. I have also tried the download command which is working correctly and letting me download a prespecified file. I am using FME Desktop 2021.1.0.0 and the workbench is a simple creator with Null geometry which is connected to the BIM360 Docs transformer. Action is set to List, I can select both the Hub, Project and Folder and the include subfolders is set to No. I have currently set the 'Attributes to add' to empty but this doesn't fix the error. The Error in the logfile:2021-09-17 12:06:22|   0.5|  0.0|FATAL |The below 

Hi! I need to thin out a uniform(?) point cloud where the points are spaced out evenly, the result should also be spaced out evenly. I tried the PointCloudThinner but it does not seem to do what I want. See attached pictures. The circled objects are the ones that need to be removed. I Hope I explained the problem clearly enough😊

Please vote if you need the 3d Studio Max format and you use it in your projects. https://community.safe.com/s/idea/0874Q000000TkuyQAC/detail

Hi! I am working on trying to automate a fanout for individual maps based on one point layer in ArcGIS Online. The maps should show one point per PDF with parcels and streets labeled in the background. So far I have been able to have a one page write out per point feature but the scale in the PDFs is extremely zoomed out to the point where all the point features would be shown. Additionally, the parcels and streets don't show on every page unless the _order field is set to the same number as the point feature. I am new to writing out PDFs and PDF transformers. I have tried using the PDFStyler, PDFPageFormatter, both Bounding Box transformers, and the sorter so far. I have tried to use the MapFormatter and was hoping if someone could tell me if that would be my best shot at getting the scales fixed. My two questions are: How do I set the scale for each individual PDF to be zoomed in to each point feature? How do I Include the streets and parcels in the background with labels? Than

I am working in an ESRI SDE geodatabase (SQL). I have a table with X/Y coordinates I successfully transformed to a point feature class. SDE is the owner of the feature class. New records have been added to the table but I am getting an error that the new records can not be added to the point feature class.I wonder what parameters I have incorrectly set that the new records are not being translated.

Hi, today I get a little bit of confused by the new Sorter Mode "Natural":Please, can somebody explain me, why the Mode Natural work like this?Thanks!

Hello everyone!My problem:I have a list of points, each point (of course) has coordinates and a timestamp. I would now like to create individual lines from the points and each line should store the two timestamps of the two points it was created from.I've already tried the LineBuilder, but there I get a polyline.  Source:Point a, b, c, d Result LineBuilder:Line 1: from a to b to c to d Result I want:Line 1: from a to b, Attributes: Timestamp_A, Timestamp_BLine 2: from b to c, Attributes: Timestamp_B, Timestamp_CLine 3: from c to d, Attributes: Timestamp_C, Timestamp_D Any ideas?

Hi. I have a geotiff (.tif) and i want extract the cell with value >50 and create a new goetiff with the selection.Can you help me. Thank you

I'm new to FME.I just installed the workbench.I've run Exercise 1 in "FME Desktop Basic Training Manual - Exercise Exploring FME" and the run succeeded.I encountered 2 unexpected phenomenons:1.After the run, I wanted to see the preview, so I cliked on "View Written Data" but instead of seeing some preview, I got error message (with duplicated lines...):File C:\\Program Files\\FME\\metafile\\.fmf could not be openedFile C:\\Program Files\\FME\\metafile\\.fmf could not be openedThis FME edition does not recognize the `' reader. Please ensure that the current platform supports this reader, the reader name is spelled correctly, and that you have installed all required plug-insThis FME edition does not recognize the `' reader. Please ensure that the current platform supports this reader, the reader name is spelled correctly, and that you have installed all required plug-insFailed to open the dataset 'C:\\FMEData2019\\Output\\Training\\LibraryReport.ht

I have filtered out polygons and in several cases when using snapper turned two polygon into a new one which lays on top of the old ones. Attached is a workspace and data and an example is an polygon with "externid" "0331>JULMYRA>1:33>1>>>>1" which there are two of but one is a combination of two polygon (mentioned before+"0331>JULMYRA>1:63>1" and hence covers a larger area, (33k sqm vs 15k sqm). I would like to be able to filter out the duplicates and save the smaller polygons.

As a developer completely new to this topic, with very little understanding of how these files work, what would be best way to create a pipeline that could convert .rvt/.dwg/.dgn files (only interested in 3d data) to cesium 3d tiles?Any learning direction is appreciated as well, since I dont know much about these files, I just have to create a workflow that could solve this issue 

I am trying to list the feature classes in a gdb as well as the fields in each feature class. I would also like to know which fields have a domain and if possible what the domain is. I have managed to do create the list as I want using the FeatureReader and ListExpoder tranformers but I cant figure out how to include the domains. Tried ticking the "Resolve Domains" box in the FeatureReader but it doesnt work. I am writing to excel and would really appreciate some assistance.Thank You!

I have 2 shapefile with route ids.I want to select the unique route id and selct by location another shapefile whose route id is same and then it share the bsegment with first shape file and then invert selection , so that missing edges can be found. The problem here is the 2nd shape file has multiple overklapping lines.

I have a legitimate workspace with rows deleted using sql scripting, (delete from table where field = value).I want to confirm the deletion so I'll be using a simple select statement. For my initial testing:I've set up my SQLExecutor as I would to read from LIVE, ran the statement and have a row returned which is what I'd expect from an unmerged workspace.I've repeated the process, this time plugging in the workspace name. Running the statement with the workspace param returns the same row which is not what I would expect. I then added an Oracle Spatial Reader to replicate the process. Running with no workspace, (LIVE) returns row as I would expect.Running with workspace, returns no row as I would expect. Has anyone else seen this behavior since the bug in 2015? Thank you in advance!