Best Answers

Hi all, Not sure if someone could help me with this doubt.I'm trying to convert from SHP to MAPINFO a polygonal layer. I fill the Advance property from the Writer to be used the File Version = '300'. Once finished the conversion I see the file has taken '800'. Other layers maintain '300'. Not sure why some layers stick to the fixed '300' value that I give and others no.I'm using 2022.1 FME Desktop version. Thanks,J.

Hey everybody,​I would like to define the hierarchy from the first administrative level into the second administrative level, and I would like to do that with the spatial reference. So for example I have a shapefile of the first administrative level which is called "Central". The second shapefile are the districts, so the second administrative level, which are all in the Central state. Lets say we have 4 districts (south, east, west and north). The name of the Central state, so "Central" should get automatically get written in the attribute field "hierarchy" of the 4 districts. I would like to use the spatial reference as transformer. But it was not working. Has anybody an idea how to solve that problem?Thank you in advance.Cheers,Fabian 

I am not that familiar with the Emailer, but I experimented a bit with it and I find it a bit worrisome that I can send a mail from one mail adress (not necessarily mine) to another mail adress. I tested using my colleague's mail adress to send a mail to my own mail adress and I don't need to authenticate that I am the colleague.You can choose yourself to have the sender's authentication on, but I would prefer that it's always required so you will be sure that the person who sents the mail is indeed the sender and not someone else.

Hi, Is there a transformer within FME that could format CSV into plain text with formatting, see the attachment? The original file can also be in another format, for example excel. If someone can think of another writer that will facilitate the solution of the problem, it can be. file original - source datafile required - required data Thank you

Hi, I've a workspace where I process a series of point feature classes within a single geodatabase (see pic). I'm manually adding/removing connectors to process each feature class on it's own, however, I'd like to simply run the process once and it loops through ALL of the features.I've experimented with the Directory and File Pathnames Reader, however from what I can tell it only processes multiple files within a directory NOT a a geodatabase and the features within. Any thoughts would be appreciated.

If you use the feet to meters conversion of 1 foot = 0.305m instead of the 1 foot = 0.3048m conversion, will there be a significant difference in the elevation information, and therefore, in your analysis?

I have FBX files with various textured 3D objects.The FBX includes file names for these texture files, eg. "textures\\asphalt2.jpg" and when FME loads the FBX, those textures are created as local JPG files in a folder .fbm. Essentially I need the texture name (filename) within FME. I can pull the individual textures as rasters as per the attached, but they dont have a name, specifically the filename. The closest I can find is the ShareItemID for each texture. How can I link the SharedItemID to the texture filename? Example attached.

I have a file geodatabase and a feature class called "Boundaries".I am using the Esri Geodatabase (File Geodb Open API) reader and I would like to apply this WHERE Clause, but the WHERE Clause is disabled."COUNTY" = 'Will County, IL' Is this a way to use the "SQL To Run Before Read" to achieve this? It can be found when you click on 'Parameters' and in the 'Advanced' section of the Esri Geodatabase (File Geodb Open API) reader.

Hi,We have recently upgraded fme server from 2020 to 2022.1.Now i want to upgrade it to 2022.2. May i know the procedure for it?i mean am i need to reinstall it or can i use any pacth installantion for it

A quick question on “LineonAreaOverlayer” Transformer in FME. I am using this transformer to connect WW pipe data from a council (in line format) with some environmental data (in area format in GIS layer) to analyse integrated data. However, when I am connecting this two layers in FME…I have originally 14, 000 WW pipesBut, when I am connecting this pipe layer with the environmental data layer using above transformer in FME… the number of pipes get almost 50% more say about 21,000 pipe recordsThis makes sense to me as per the description of this transformer which says: “The LineOnAreaOverlayer compares lines and polygons, splitting the lines where they intersect with a polygon boundary. Each resulting piece receives the attributes of the area(s) it is contained in, and each containing area receives the attributes of the line(s) that either fall within or intersect it (a spatial join). Features also receive a count of the number of overlaps encountered”But still wanted to double check wi

We have a custom application that calls and polls telephone numbers using an analog modem on COM1 port. I would like to port this application to FME and I have been unable to find any native transfomers/readers/writer that can communicate with COM Port1. Question:Can FME natively communicate with COM Ports ?If so, how is this done.If not, any suggestions on how to make with work

I have a time series with ambiguous dates due to the daylight savings time change that I would like to convert to unique datetimes with time zone information: 2021-10-31 02:00 > 2021-10-31 02:00:00+02:002021-10-31 02:15 > 2021-10-31 02:15:00+02:002021-10-31 02:30 > 2021-10-31 02:30:00+02:002021-10-31 02:45 > 2021-10-31 02:45:00+02:002021-10-31 02:00 > 2021-10-31 02:00:00+01:002021-10-31 02:15 > 2021-10-31 02:15:00+01:002021-10-31 02:30 > 2021-10-31 02:30:00+01:002021-10-31 02:45 > 2021-10-31 02:45:00+01:00I tried to do this in FME with the "TimeZoneSet"-function as described in https://community.safe.com/s/article/converting-time-and-date-fields-to-local-timezones. This works for all datetimes except the ambigous ones above (I get null values). In Python this can easily be done by using pandas and the option "ambigous='infer'":import pandas as pddf = pd.read_csv(file, sep=';', parse_dates=['dt'])df['dt'] = df['dt'].dt.tz_localize('CET', ambiguous='infer')For thi

I'm beta testing the new FGDB 'preserve GlobalID' parameter in 2023 build 23215. It does not seem to be preserving the values. In the test dataset I've attached, the GlobalIDs are used for relating the attachments table to the feature. Is there something else that needs to be done to ensure the values are preserved, besides setting the parameter to Yes?

Hello, Are there still no plans for FME2022 to support Ubuntu 22.04 ? In other question it was mentioned that FME2023 will support Ubuntu 22.04. When is the release planned ? Thanks!

I have 3 datasets that are fme_time schema type and I want to use the AttributeManager Conditional Value to set if/else statements depending on which time values are missing. When I do this, the resulting attribute type is fme_varchar and not fme_time. If I create a new attribute and point to just any one of these attributes, the new resulting attribute is still fme_time. So it appears the conditional value setting is changing it and I can't figure out how to change it back to a time. I have tried parsing, formatting, casting and nothing changes the varchar back to time. Are there any ideas to fix this?    

I have too many points A and too many points B and I have many small polygons . every small polygons contain point A but some of them include point B . i would like to to find each point B that close to point A but it should be at the same small polygon if point A does not find point B ,at same small polygon so it will be better if i can mark it .that no point B close to point A .FME 2021Thanks in advance

I have a 3D meshes of buildings in a Rhino file that can be exported as a .obj or .fbx and want to use the fanout expression to put each building into an individual file/folder. The exported file (both .obj and .fbx) dont have any attributes and is read as one cohesive mesh so I am unable to assign any attributes to them to split up. How would I go about this workflow?

In the attributemanager, I declare the igds_model_name which is an atttribute for the model name and is determined by feature_type. Therefore in theory every feature should be written to their respective model. I also declared the model names in the seed file of the dgn, but for some reason the specific features are not written to their respective model. I was wondering whether it's possible to write features to different models in a dgn file and how one is able to do that. 

I have a simple workspace to generate some web tiles.   I first used WebMapTileClipper to break the data into vector tiles.   I next ran each vtile through MapnikRaster and grouped by _tile_column & _tile_row. I next sent each raster to WebMapTiler. See my attached workspace image. It seems that WebMapTileClipper and WebMapTiler do not agree on column and row. WebMapTiler generates an extra tile for many of the same tile coordinates. In my attached example you can see that MapnikRaster generated 1 image for _tile_column: 978 and _tile_row: 1655 however WebMapTiler generated 2 tiles. Any advice would be greatly appreciated. Richard Carmel 

Hi all.I'm trying to update single values in a table, which has 3-4 keys. The three keys are mandatory, while the 4th is optional.A writer will apparently only update records which has a value for the 4th parameter, erroring when this value is NULL.Why is that ?I tried to test for the NULL value, but that didn't work. Apparantly the value needed to be tested as being an empty string, not a <null> value, even though that was what it contained.Is that a bug ?And lastly you - again apparently - cannot simultaneously have a writer/update and a SQL Executor (to handle the NULLs), the writer blocks the SQL Executor. I had to ditch the writer and go with two SQL Executor's.Why does a writer block transformers ?All this a s a warning to y'all. Can anyone confirm these findings ?Cheers.2020.2 / MS SQL Server

I've created an excel sheet with a series of dataset names and different equations to run against them e.g. @Value(COV_LEVEL)-@Value(INV_LEVEL) Using fme_feature_type and FeatureMerger I am able to get my datasets and the required equations together. How do I tell FME that to use the content of my Feature Attribute as an equation and action it rather than as seeing it as a text string? thanks

I normally run FME Desktop at the office, where I'm storing named connections and associated files on an office network share, in order to facilitate sharing these between the development and production desktop licenses.These files are backed up to my local drive every day.Now, when I'm trying to run FME offline, without access to the office network, FME refuses to access the named connection, and even bars me from reading from a local SQL database although all connection data is entered manually.This also happens after I change the references in under options to point to the local backup copies of the files in question.WTF?Why is FME refusing to work normally in this manner ?Version 2022.2.2

I have tried all the ways I could think of to do this but cannot find anything on how to change a text field to an integer field like in ArcGIS Pro. Please help! This is what I have tried: @int(USER_Price)@int(@replace(@replace(USER_Price, "$", ""), ",", "")) I have also tried @Trim which produced a 3 digit result.

Hello.i have simple workflow to update Access MDB content.it starts with SQL creator to define the queries and end up with SQL Executor to write down all the attribute manipulations and the end.Works fine in workbench as it updates existing MDB file and therefore there is no Writer placed at the end. Im seeking an advice how to update this to be able to publish it to FME cloud so the Cloud returns the updated MDB file.as this MDB file is uploaded at the beginning, it still exists and being updated somewhere in the temp folder of the FME Cloud so it should be easy just to request it with some transformer at the end and provide it as a result. can you advice me what transformer can do it for me?

I am trying to simply export results with a Writer into a .shp. If I do not use a GeometryValidator most of the features are present in the final attribute table, but not shown in a ArcGIS map. If I use the GeometryValidator and then use both the good and the repaired features as inputs for the Writer, some results are missing from the final attribute table, but all the result in said table are also displayed in an ArcGIS map. The log gives following warning "Dropping heterogeneous aggregate feature for the SHAPEFILE Writer, due to feature type allowed geometries restriction". How do I solve this? Thank you!