General

Hi, I'm new on/to FME. How to check CVS header spelling. Example I have one CSV file and it contain name and location as it header. Header should be spell as name and location, if it spell as Name/NAME or Location/LOCATION it will return false/incorrect. Thank you.

Hello FME'ersHere's your weekly round-up of FME news, and there is a lot of content this week! FME2021.2 ReleaseYou'll have noticed that FME2021.2 was released yesterday.  What's new in that version? Well, we have a newly added CKAN reader/writer. Because it's delivered as a package this isn't totally new. It was added to the hub in August I think, and can even be used with older FME versions. But it's new enough to count!  What's definitely new is a reader/writer for Esri Knowledge Graph. I know very little, so luckily we have a full tutorial on what the format is and how to use it.  FME 2021.2 also has the usual amount of bug fixes - remember the What's New changelog is your friend there - and for FME Server a revamped Geometry Picker.  I believe the new part is the menubar at the top, a search tool, and you can now also change the background map to another provider. On a related note:The GeoCoder transformer was removed from FME in 2021.2 and repl

I have also a folder with many features shp .My goal ist to make at once a loop that for each features in the folder , i want to transforme in cad format , and eah feature will be store in differentes folders with the same name (the name oft he feature) 

I have a folder with many features shp .My goal is to make at once a loop that for each features in the folder ,  i will use one feature(a chosen feature) to clip each , and each feature will be store in differentes folders with the same name (the name oft he feature)

Hello everyone!I'm pretty sure it's a simple problem, but I could not resolve the matter.We have a dxf file of cloud points, very loaded with points.I want to do generic filtering by square meter.For example he would leave me 4 points per square meter.All the transformers of the point clouds do not work for me, and even if I do, I do not know with what method to do it.Would appreciate help!Thanks!

i am using vector on rasteroverlayer transformer ( Lines over topological map) and also Mapnikrasterizer transformer ,i have got the output that i need but it takes long time .do we have method to increase the speed of process ? or what should i think about to reduce the time as possible and get the same output Thanks in advance FME 2018

Hello there, So I have two data set.(1) LL84 Coordinate system (in degree minute, etc)(2) Hong Kong80b.Grid System (in meter). ​I want to ask how do I know which measuring unit I am using in my fmw file. It is because I am using Anchored Snapper transformer and I want to set the snapping distance in 0.001m, yet I dont know what unit the transformer is in. Thank you in advance. Zach

Each month I have a spreadsheet I would like to split into several separate spreadsheets based on values in one of the columns. This column contains peoples names and I would like a spreadsheet per person to be written out. To complicate matters the values in the name column can change each month so the process would need to be dynamic. How would you achieve this in FME?

I have a right-of-way polygon (ROW) that I generated a 3-foot buffer with the intention of selecting all parcels within this buffer. When using a SpatialFilter in FME not all of the parcels with in this buffer are selected as they should be. A sample of the parcel and buffer data is attached and the Parcel with OBJECTID 85 does not select. When using the same data in ArcGIS Desktop the parcel does select. Note, the buffer is created at 3 feet, a larger buffer results in false positive results. I also noted that when viewing the data in ArcGIS Desktop and FME Data Inspector the parcel is clearly within the ROW buffer; however, when viewed in the Visual Preview in FME desktop, the parcel is not within the buffer. Screen shots below of the same area in all three viewers. ArcGIS Desktop:  FME Data Inspector:  FME Desktop Visual Preview:Note the parcel crossing the ROW buffer when view in FME Visual Preview and not in ArcGIS desktop or FME Data Inspector. Sample data demonstrates the

I am using FME joiner to join tables. the joined tables do not show all fields from the source table. I was wondering what could be the reason. Any help would be greatly appreciated.

Is there a reader which will locate all the JSON URL endpoints on a webpage for me? I wish to acquire all the attributes related to spatial features contained within the webpage.

I am working on a project that involves sending an email notification to a series of email addresses with a text body and embedded map of the area impacted. I am having a hard time pulling together examples to get this done. The embedded map would include:a background image (either ESRI basemap or using our internal ESRI raster mosiacs)a series of ESRI SDE points, lines and polygons (some having labels)both the image and vector data would be clipped to a specific boundary (usually no more than 1500 acres (~600 HA) I am assuming that the embedded map within the email would need to be a jpeg, png, etc. But I could be assuming incorrectly... The main item that I am struggling with (at least now) is the creation of the map. I am also struggling with bringing in an ESRI basemap or connecting to our mosaics without it reading the entire mosaic. I am running FME Desktop 2020.0 and have a FME Server 2020.0 newly stood up and running some automations. I would appreciate any help that you are wi

We have been using AthenaConnector for awhile and have about 75 mappings developed. Last summer while using FME 2019, the AthenConnector automatically updated to version 1.0 of the connector.  A lot of mappings started bombing. Also see FME Hub Comments. Here is one such error message:2021-11-02 11:18:02|  3.6| 0.0|INFORM|AmazonAthenaConnector: Query ran successfully. Run time: 6.417 seconds. Data scanned: 640595.24 kB 2021-11-02 11:18:02|  3.6| 0.0|INFORM|AmazonAthenaConnector: Query results saved to: 's3:/...' 2021-11-02 11:18:03|  3.8| 0.2|WARN |Python Exception <ValueError>: invalid literal for int() with base 10: 'client_num' 2021-11-02 11:18:03|  3.8| 0.0|WARN |Traceback (most recent call last):  File "plugins.py", line 447, in input  File "...\AppData\Roaming\Safe Software\FME\Packages\19822-win64\python\safe.amazon-athena\fmepy_amazon_athena\connector.py", line 168, in receive_feature   first_feature_row = next(result, None)  File "...\AppData\Roaming\Safe Software\FME\Pa

I'm looking for some help on what I am sure is a common problem hwoever being new to the software I'm not too sure what the correct terms are. I am using the RasterTiler to split a large DEM into smaller tiles and write them to a new format. This is working fine but I would like to have the a coordinate of a corner of the raster written to the filename of the output. You've probably seen similar below, which is what I'm trying to achieve:For reference, this is what my workspace set up looks like:Thanks for your help getting me to understand this new software.

I upgraded OSX to version 12.0.1 last night (Monterey) Now when I try and create a new Reader in Desktop I get the error as follows. Is anyone else seeing this? I am running FME version 2021.1.2.0    

I have a .dgn that has a lot of 'blocks' that are made up by Smart Solids (they consist of only fme_lines as far as FME Desktop sees it) and they show up like thisOf all the other parts (Free Forms which are fme_areas) Im building with MeshBuilder and they show up just fine, but these parts are missing. I managed to separate these parts from the working ones because clearly I have to deal with these differently but I dont know how. SurfaceBuilder/SolidBuilder seems to just reject everything, only AreaBuilder (which if Im correct is not for 3D stuff?) outputs something but it is far from what I want, for example:For this inputMy AreaBuilderOutputs something different

My reader contains two features: 1 line, 1 point.My output writer is set as Generic and with User Parameters to choose the output options. But the attributes/fields I pick are captured only in SHP/FGDB/KML but not Autocad Map 3D Object Data. Any clue how I can include the attributes I want in the autocad output?

Hi,I have problem creating an excelfile in a script that I published in FME server. I get an outputfile with type "file" and not ".xlsx". I can use the file to drag and drop it to an empty excel sheet. However what I really want to do is to create an excelfile. I am using a published parameter in my writer that looks like this . Also please check my parameters for the excelwriter.Am i missing something important? The version on FME desktop: 2020.1.3.0The version on FME server: 2020.2.3

Hi, We have a very basic workflow where a user enters a value into a parameter, and we write that value to a CSV which is stored on a network share drive. We have an external facing website that we would like to have access to this CSV so that it can publish the latest value found in this CSV.  I am not a web developer, I am a GIS Guy, so I am a little out of my depth. Is there some way I can save this CSV on the FME server so that it is available via the Website to read?  I am unsure if that is the best way to explain it, sorry for the n00b terminology.

Whenever running a workspace the log start with pointing out how to run the workspace at the command-line. No doubt it works when I open the command-line and run the workspace.My issue though is that I have a little ui in C# where I do not call cmd.exe, but go with Process.Start() and start directly fme.exe.My approach works as well, however, it takes 4 minutes to run the workspace in cmd.exe and 30 minutes when calling directly fme.exe. Is there an explanation why it takes so much more time when calling fme.exe instead running it through cmd.exe?

So the problem is that I have a hard time to refresh my updated data. The 1st time I run the data is fine. When I tried to edit the source data and click "RUN" again, the data doesn't update the data. However, if I click view source data, it is the updated one. I tried "Reader => update feature types" and it doesn't work as well. I have to close the program and reopen the fmw file in order to get the newest version of data.  Is there any way that I can update the data inside the FME environment? Thank you very much. Zach

Hello Sir/ Madam,​I am trying to check if the input "units" and within " floors". ​There are two floors and many units, which they both have "base level" attribute.​The following are what I would like to find out separately.​1) units that are completely outside of each floors2) units that touch the floor boundary yet part of the portion is outside the floors I am not sure how to do ​let FME know how to process each baselevel ( 4.53 and 10.3) in this case one by one. The attached documents are in shapefile. I also attached my fmw in here.​Could someone please tell me what I did wrong? Thank you in advance. 🙂 Zach

Hi,I created an FME workbench which contains python script at FME shutdown. This python script uses Arcpy library to make database connection. The workbench execute successfully and insert the data in database when executed manually. However, the script fails when we publish the FME workbench in FME server. It shows transaction is successful with message as 'FAILURE'. The FME job fails to insert data in database. Please advice.

I have been using the neighbour finder to create a line between an existing point and road line, which works fine up to a point. I am sure the below is fairly straightforward but have been racking my brains to no avail. I have tried the group by which is giving some strange results too... Both the Road and Point Datasets have a RoadID attribute meaning that all points should be linked to the correct road, this is not currently happening with some points being linked the shortest distance to the nearest road and not to the correct road. Any suggestions how i can get the points to link to the correct road via the RoadID field? The image below shows the results i am getting with the Yellow lines drawn on where the links should be going. Thanks in advance...

Hello, I have created a list of one specific attribute (Listbuilder), which I have finally cleaned from duplicate entries (ListDuplicateRemover). So the list contains several elements, but they cannot be duplicated. As a next step I want to select all geomtria from another dataset which are contained in the list. When trying to do this with the FeatureReader, it seems that I can only specify one element in the WhereClause query. How can I select all geometries contained in the list in one step? I would like to avoid the detour via the PythonCaller 8-). Thanks a lot.