FME Form

Hello i have Columnname A and B.I read the Excelfile with a FeatureReader. Get Columns A and B.Now i close FME. Rename Columname A to C in the Excelfile.Open FME. Read the Excelfile. Get Columns A and B instead of C and B.Why does FME cant see my renamed Column C and still sees Column A wich doesnt exist anymore?

Hello i want to change the Columnames based on the first value.Example:Column: Afirst Value: DognewColumname: Animal

While connecting to MongoDB Atlas I'm getting error TLS Handshake failed. However, when connecting via MongoDB Compass, the connection is successful.  Attached is the screenshot of the error. Could anyone please share MongoDB Atlas is supported via FME? If yes, how to connect to it? Best,Sarthak

I have DGN data with and without GRAPHIC GROUPS for Line,Point,Texts,Hatch,Polygons. I want to extract separately only graphics groups elements.

Hello,I am trying to convert from revit to cesium 3d tiles using the dynamic schema definition. I remember it working well before, but suddenly this issue comes up. When disabling the revit reader (only one in the workspace, see image below), the error doesn't pop up, but of course, the attributes are not written since no schema is found. Any idea on why this happens? Note: Revit's feature_type_names are separated by a dot character (e.g. Mechanical.MechanicalEquipment) Here is the error:The PERSISTENT_CACHE_NAME directive must be specified when creating a persistent cache.  It's value should be a valid string useable as a subfolder nameError fetching dynamic schema definitions from reader `REVITNATIVE_1'. Error reading from `D:\...\plant.rvt' reader.The PERSISTENT_CACHE_NAME directive must be specified when creating a persistent cache.  It's value should be a valid string useable as a subfolder nameMULTI_WRITER: Error fetching dynamic schema definitions from reader 'REVITNATIVE_1'Attr

Hi Guys, New to FME but really enjoying the journey to date. Today I hit my first confusing issue which although I have resolved I am pretty sure they must be a better way. I had:Created an MSSQL tableCreated an FME reader which detected the schema including attribute types and so forth.Did some processing and wrote to a file geodatabase. But:I then made some minor changes to the underlying MSSQL table i.e. changed text to decimal etc.However the reader would not detect these changes. I had to delete and recreate the reader for then changed to be detected. Is there some easier method which I am missing to get the reader to detect changes to the table schema in the database? Apologies in advance if the solution is simple but I am missing it! Thanks,Barry.

I have data that would need to be loaded into different tables. But I need to load them to load in a specific table order because of foreign key constraint. I have put on a connection runtime order which only controls the very next transformer. One of the data paths has a statistics calculator so i thought if i put a statistics calculator on the path that needs to be loaded last, this would give me the order I need but they are still going first.The first 2 are going in at the right order. The 3rd has the statistics calculator. It also has a tester where only the records that passed will be in the statistics calculator. The records that failed do not need to go anywhere. Also, all records can fail the tester. In that case, no related IDs are created for the 4th table so then the Foreign Key Constraint is not violated.I added 2 feature Holders and 2 statistics calculators on the 4th path hoping the 3rd path will finish first, but the statistics calculator for the 3rd path would stop, an

Hi, I'm wondering if anyone here has any idea why this is happening. When I open fmeworkbench.exe, four processes are created:QtWebEnginepProcess.exeQtWebEnginepProcess.exefmeobjectsworker.exefmeworkbench.exe But when I close the FME Workbench window, only the top three processes are ended. fmeworkbench.exe continues to run in the background. The number of fmeworkbench.exe processes keeps increasing the more times I open and close FME Workbench, which is quite often on a typical day. It ends up taking a lot of memory, so I'd like to figure out how get these closed properly. This behavior is consistent across the three versions of FME I have installed (2017.1.2.1 32 bit, 2021.1.2.0 32 bit, 2021.0.1.0 64 bit), and is only occurring on a Windows Server 2012 machine. FME Workbench (and FME Data Inspector) are the only programs on the server that are exhibiting this run in background after closing behavior. I've tested on a Windows 10 machine and the workbench processes are en

I'm trying to reproject layers that were built in CAD. The first 6 figures of the coordinates match up to british national grid 6 figure grid ref. BUT there are 9 figures in the grid reference almost like it used BNG in millimetres instead of metres. I'm sure it is a simple quick convert/reproject but I'm a bit stumped...?

Hey FME'ers. I've not been online for a bit recently (because of updating the FME training materials for 2017) but I wanted to throw out a new idea that is part challenge, but part crowdsourcing.I came up with the idea of an FME-driven service for assessing a workspace for best practices. Just now I found I wasn't the first to think of this, which shows there aren't any new ideas any more!Anyway, in my spare time I've been putting together a workspace using the FMW reader to test other workspaces for best practice. I've built about 20 different tests and can think of quite a few more. But I thought it would be great if we - the FME community - could work together to take this idea to completion.So, this is an open invite to take part in this project. I think there are a number of different ways you could contribute:Develop a best practices test and add it to the project workspaceDo some testing on the project workspace to look for faults or enhancementsImprove t

Hi All, I am stuck trying to figure this out. I am having trouble seeing feature classes inside FeatureDatasets using the FeatureReader. My Feature Types to Read is fme_feature_type_name and I am exposing fme_feature_type and geodb_metadata_string. All seems to work for feature classes but FCs in FeatureDatasets are skipped in Generic. They come across in the Initiator though. See screen cap below. I must be missing something simple. Any thoughts?

I have a workspace which reads rows from an excel file and writes the same rows to an other excel file using dynamic schema definition. Gets the schema from the excel file which is read. My problem is that the first row that is read is skipped in the writer. In the attached example the output will only contain the second row of TestExcelWriter.xlsx

I have a data that contains whitespaces at the beginning, between and at the end. I have used an attributetrimmer to trim out the spaces at the beginning and end, but I am left with the spaces in between. Please, does anyone have an idea of how I can go about it because I can't keep using a stringreplacer repeatedly for this large dataset?

I'm fairly new to FME Desktop. I have a FeatureWriter with three inputs. I'm creating an Excel file with three sheets. It works great except many of the column widths are much wider than the content. I have to open each sheet, select all columns and Auto Fit Column Width. Today I realized that if the data type is text(255) then the column width will be 255. If the data type is text(150) then the column width will be 150. My data source is an ArcGIS feature layer created from Survey123. The default length for a text field is 255 so, I have many columns that with a width of 255 in Excel. This doesn't seem like a great way to determine width. I'd rather go with the Excel default column width. In the User Attributes tab of the FeatureWriter parameters, I see that I can set the column width. I believe that I can use zero to auto fit the column width. The problem is that I have about 30 columns and 3 sheets so, I'd have to type '0' close to hundred times. Is there

i have seen numerous posts about this but i cant get a good working solution. i have a user parameter that i want to limit a second user parameter based on the selection of the first. so far i can get a filter on the first parameter but how do you link the second parameter to the first in order to present the user with only the attributes that match the first parameter?

Hi, How could I assign a value to a polygon based on the value of most of the overlapping points? Thanks in advance. 

FME Desktop: Attributes fails to be transferred to a file geodatabase, In the screenshot below, I wanted to write the result of the “geometry filter” into a file geodatabase having all fields transferred. However, the indicated fields are not transferred. What could be the issue here? The data and workbench are attached        

I just would like to convert xml files to json keeping the structure. I give you an example of my problem : My xml files look like that : <Organisme id="pmi-25047-01" codeInsee="25047" dateMiseAJour="2019-04-19" pivotLocal="pmi">  <Nom>Centre de protection maternelle et infantile (PMI) - Baume-les-Dames</Nom>  <EditeurSource>La Direction de l'information légale et administrative (Premier ministre)</EditeurSource>  <Adresse type="géopostale">  <Ligne>2 rue des Frères-Grenier</Ligne>  <CodePostal>25110</CodePostal>  <NomCommune>Baume-les-Dames</NomCommune>  <Localisation>  <Latitude>47.3492012024</Latitude>  <Longitude>6.36126995087</Longitude>  <Précision>8</Précision>  </Localisation>  <Accessibilité type="ACC">rampe d'accès</Accessi

I'm trying to convert a CityGML file into a 3d model that I could open with Blender, I was able to use FME data inspector to convert it to .obj, but it doesn't come with any textures. How can I convert CityGML to .obj or other 3d format with textures included? EDIT: And by the way I have never used FME before, and I'm not planning to use it for anything else than converting CityGML to 3d models, so explaining the process step-by-step would be really helpful.

I am creating a connection to an Access DB. The database has a username and password, and when I do the connections for the DB in FME it only asks for a password. After i set the connection up, i create a Reader for it, but after the reader is created it asks me for the username and password for the MS access db again. How do i get this to stop? Cause it is going to ask me that information everytime i run this query, which will be automated.

I build a .kml polygon from information contained in a .pdf file we receive for utility location planning print requests. The polygon has attributes with contact info, start date, bounding box long/lat coordinates, etc... I also have a utility locate app in ArcGIS Online that contains a survey 123 form, a webmap, and a dashboard for tracking the requests. I would like to auto populate the survey123 form with the data from the .kml including the polygon bounding box if possible. It sounds like it should be doable from this: https://support.esri.com/en/technical-article/000017982Could an httpcaller put transformer send the custom url to survey 123?Thanks for any insight you care to share.

Hi,is it possible to use the LineOnAreaOverlayer transformer to test all lines in an area against all areas step by step. That means i have 10000 areas and all should be testest one by one against the 15000 lines in the line port. As a result I need a list which shows me what lines are in every single area. And yes, the same line will be in more than one area. Maybe i colud use a second workspace and use the workspacerunner to bring the data in, but i hope there will be a smarter solution for that. 

Create polygon from point

Hello Dears,Im new to FME. I would like to convert SHP to TopoJSON. Is there any special transformers to use for this process or any customization required.I tried with simple attribute manager but the converted data is just a line. could you please help anyone SC attached  

In QGIS there is a useful tool that generates Random points on lines. It snaps the points to the lines whilst keeping an even spacing between all points. It also has a setting of points per line.Any ideas on how to achieve the same result in FME? Description of the function in QGIS:This algorithm creates a point layer, with points placed randomly on the lines of the Input line layer. The default behaviour is that the generated point features inherit the attributes of the line feature on which they were was generated.Parameters / options:For each feature in the Input line layer, the algorithm attempts to add the specified Number of points for each feature to the output layer.A Minimum distance between points and a Global minimum distance between points can be specified. A point will not be added if there is an already generated point within this (Euclidean) distance from the generated location. With Minimum distance between points, only points on the same line feature are considered, wh