Best Answers

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!

Hello,in the past it was possible to set the options to no and still choose a template. Is there a workaround here? Why is that no longer possible? I would like to use a template and every time the workflow writes that this is done to the same file and not all spreadsheets are removed. 

I have rows of data with columnsenter/exit time andlicense plateI want to combine the rows so that there are rows of three columns:enter timeexit timelicense plateFor each license plate and enter time, I want it to choose the closest exit time which comes after the enter time. Attached is an image of the input data as well as an image of what we want to create on the output. The small dataset is also attached.Input: Output:How can I achieve this with FME?

Hi We are currently on FME Server 2021.2.2. There's a need to capture the login user ID for a server app and then insert into our database for logging purpose:Believe that's the FME_LOGGEDIN_USER parameter. Please advise whether it is possible to do so. Thanks.

I've got FME Desktop running under Linux. This works fine (after quite some steps), but now the Emailer does not work. It used to work with FME 2021 (on same Linux machine). But it does not work with FME 2022 anymore. The Emailer v 3.3.3 package is correctly installed, since it is listed in the package list using the command  sudo /opt/fme-desktop-2022/fme PACKAGE LIST.When running the workspace it mentions:2023-01-24 14:10:27|   0.5|  0.3|ERROR |Python Exception <ModuleNotFoundError>: No module named 'fmepy_emailer'2023-01-24 14:10:27|   0.5|  0.0|FATAL |PythonFactory failed to load python symbol `fmepy_emailer.Emailer'2023-01-24 14:10:27|   0.5|  0.0|FATAL |Factory proxy not initialized2023-01-24 14:10:27|   0.5|  0.0|FATAL |Emailer_transip_CALLER (PythonFactory): PythonFactory failed to process featureAny idea why this is happening? I tried to uninstall and reinstall the package, but without result. 

Hi guys,  I tried using IDENTITY_INSERT on several tables of single SQL Server Non-Spatial writer. There is a error I'm getting that says I cann't do that. I now for the rule that SET IDENTITY INSERT can only be used on a single table per connectio, but I wonder if there is some way to make my 4 tables use this feature with a single writer? These tables aren't beeing populated at same time, so can I do something with SQLExecutor for example or no?

I found that after using the Hyper File Writer, that I had no way to open the file and view it in FME, and could only use Tableau to open the file to see the data there. I could not find a Reader for Hyper Files as well.

I was trying to convert geoJSON data for one floor to IMDF. I saw a video regarding the conversion of YVR airport and was wondering is there was a template or existing workflow available that I could refer to to work on the same. Any help is appreciated!

I got a good one! I am working with the RCaller transformer and doing some good things on the workbench side. I decided to automate a process for non-R programmers to create ggplots of their sensor data. This process worked great on the ol' laptop, so I migrated to my FME Server. I have worked through the version of R (downgrade) to 4.1.3 per FME documentation. I had to change the default path of the libraries as well to make everything play nice. I have run this file on the SAME server as the FME Server install and it runs without error in workbench on that box. When I run the same file in server I am getting this message: 2023-1-19 14:40:45 | RCaller_2 (InlineQueryFactory): Encountered an error when starting R interpreter. Check that R is installed and that the R interpreter path is set in Workbench's "Translation" settings ( http://fme.ly/rcaller ). Message was: Process failed to start: The system cannot find the file specified.It is at least consistent. I&#39

If the Authentication - Credential Source: Anonymous why even require the additional Embedded Credentials - Account Name?

I have two tables. One with input data the other with unique high/low lookup ranges to categorize the input data. The lookup ranges and input data are numeric values. How can I append the associated data in the lookup ranges table to the input data based on where it falls between the min/max values? I considered AttributeRangeMapper but that will not allow comparison between two tables. Thank you, Gil

HiI tried to join two linear datatset using this approachI created (snipper) center point from one lines dataset and then I used the spatial relator to join the info to the 2 lines dataset but due to the mismatch of the coordsys of two datasets(I suppose) the center point doesn't touch the line (see picture)I suppose that this is related to the tolerance during reprojection do you have same experience ? thx PS I solved creating a buffer for the center points Francesco

Hi!I have a work process that writes into googlesheete, I get quite a few errors:Python Exception <ApiError>: API Error 400 INVALID_ARGUMENT: 'This action would increase the number of cells in the workbook above the limit of 10000000 cells.'I saw what was being done here:https://community.safe.com/s/article/Known-Issue-Cell-limit-error-when-writing-to-Google-SheetsWhat can solve my problem is the ability to delete the sheet by fme..Is there such a possibility?

is it home use license and 30 days trial are different ?

To populate in an automated way the json templater what I would to do is to add the string stored in 2 attributes that I created in the table of my source.The first one is to create the list of attribute name and the second one to run the command in Json templater to add the value of the same attributes present in the source. ( see picture)something like:{   "id":fme:get-attribute("id"),   "@ns:com:here:customer:$(CustomerName)": {                    "objectidOriginal": fme:get-attribute("objectidOriginal"),                   "toaddr_l": fme:get-attribute("toaddr_l"),                   "toaddr_r": fme:get-attribute("toaddr_r"),                   ..............................                   ..............................                   ..............................                   "filegdb_type": fme:get-attribute("filegdb_type")} I created this ROOT:{   "id"