Authoring

We have been running FME Desktop 2022.2 on Windows Server 2019 machines for over a year, but found out last week any function calls to datetime or datetime reformating fails with this error “Failed to load timezone data. current_zone() failed: A mapping from the Windows Time Zone id "" was not found in the time zone mapping database”. For example, in the AttributeCreator, an attribute creation with the value being @DateTimeNow() got the above error. Anybody experienced this before and knew of a fix? Unfortunately I don’t have the option to reinstall FME on those machines.

I have a dataset that contains the “_related_suppliers” field that contains either 1 or 0; I would like to add a counter that will increment, whenever the _related_suppliers field changes;  Is this possible?

Hi allFirst time poster, long time reader of all the great advice on this forum.using FME 2021.2.6 (work limitation)I am currently having issues regrinding my CSAR (Raster and Pointcloud) files while keeping the lowest value in its original XY position in the regirded area. Example of regirded squares with the smallest values being picked.Note: the gridded squares are just a visual example, I have potential looked at applying a Buffer to the soundings based on the (SCALE) area they fall into but have had no success yet. 

Hello, Here is what I need to do: I have a workspace that includes the Emailer Transformer. When a file is placed in a folder and email is sent to the recipients notifying them that there is a file in the folder. The workspace works great. But, if one of the email recipients changes or needs to be removed for whatever reason, I am contacted and must go into the Emailer Transformer and manually delete the recipient. I would like to allow a user to open a spreadsheet of the email addresses and alter/delete them there rather than having to contact me. I need some help in getting started: If I have a list of email addresses in a spreadsheet, how do I include it or reference it with the Emailer Transformer? For example, if an email address is deleted or added to the spreadsheet, when the Emailer is going to send an email it will send the email to the list of recipients in the spreadsheet. Looking for some ideas on what transformer(s) I would need

Hi!I would like to create a workbench with a lot of flexibility for the users. I use a FeatureReader with a spatial filter. I create a user parameter to chose the system of coordinates. So I would like to use it on the Featurereader but there are no option. Do you know a way to indicate to this transformer the system of coordinates? I suppose the spatial filter will work if the datas are in the same system but I would prefered to force it.Thanks !

What I try to do is to download a raster from a WMTS to use it as a background image for a report. I do not want to download the entire service, only a part to use as background. The result I get is only working on very zoomed out tile matrices, like 04, where the resolution is not useful: On deeper levels the FeatureReader is downloading a lot of tiles, which takes a very long time.The WMTS I use is a Dutch one, in epsg:28992. I wonder if I am doing something wrong, or this is never developed / tested for this coordinate system?The point is on 147513.92, 523126.09.The WMTS is 

Hi,I would like to merge polygons based on area up to a certain point. For example if I had 1000 polygons I would like to reduce that number to 100 keeping them as close as possible in size to one another. Does anyone know if this is possible in FME?Thanks for any help!B

Hello, I need to switch to a new machine. I save my workspace files under a designated directory, which has been transferred to the new machine. I am wondering if there is any important configuration file would need to copy over (e.g. some database connection, web connections, where those info stored?) and where usually to find the file?I am using FME workbanch 2023.2.3.Thanks. 

Hello Safe Software Community,I work for Riteway Towing INC, a leading towing company in Queens, NY. We're exploring ways to enhance our operations, particularly in managing our fleet of tow trucks and providing timely roadside assistance. Given the complexity of NYC's traffic and the high demand for 24 hour towing, we need a robust solution for real-time data integration and route optimization.Can FME help us integrate various data sources (like traffic updates, GPS data, and service requests) to streamline our dispatch processes and improve response times? Additionally, has anyone implemented FME for similar logistics and fleet management tasks? Your insights and experiences would be greatly appreciated!Thank you!Olivia Marie - Manager at Riteway Towing NYC

Is it better practice to use  import fmeparam = fme.macroValues[‘parameterName’]orimport fmeobjectsparam = FME_MacroValues[‘parameterName’]in Python scripted parameters and why?

Hi,I’m attempting to create attributes from an unstructured html table.Looks like this… The table is originally a Word .doc, that I saved as a .html file so I could read it in FME. For example, I’d like to create an attribute (AttributeCreator) that selects based on row number … eg “Survey Authority” = Col1 row4or“End Date” = Col2 row8This there a way I can do this ?thanks  

I have two table that I am trying to keep in sync. I want a target table to match a source table. But I am trying to avoid deleting all rows from the target and reloading it. The source table is in our CIS (customer information system) Oracle database and the target is in our GIS Esri Oracle database. I am using a CRC calculator to find rows that are identical. Then I have a writer to delete rows from the target that have been updated in the source and to delete rows that no longer exist in the source. Then I have a second writer to insert rows that exist in the source but do not exist in the target or have been updated in the source. The delete writer is based on a single key column.Okay, so it is important that the delete writer commits before the the insert writer. I have tested it and the delete writer does appears to commit first. The tables are synced properly and the FME logs show the delete writer committed first. So, my question is this: Can i count on the the d

We have several FME based solutions - At the moment they are mixture of workspaces, CustomTransformers and formats. I guess my question is are people thinking about a package as a single tool (like a API connector) or can it also makes sense to include a number of transformers and formats in a similar way to an FME Server Project?

Hi,I’m attempting to create attributes from an unstructured html table.Looks like this… The table is originally a Word .doc, that I saved as a .html file so I could read it in FME. For example, I’d like to create an attribute (AttributeCreator) that selects based on row number … eg “Survey Authority” = Col1 row4or“End Date” = Col2 row8This there a way I can do this ?thanks  

We have several memory intensive workspaces that normally return log file entries like:INFORM|ResourceManager: Optimizing Memory Usage. Please wait…Recently our IT department was sourced to a MSP, and it seems many security settings have changed. Now when FME tries to ‘optimize memory usage’, we receive Windows warnings similar to the screen shot below for ArcGISIndexingServer.exe and FNPLicensingService.exe. There does not seem to be any adverse effects in FME otherwise.Should we be concerned with these warnings? Will the memory available to FME be lower since access is being blocked? What can I ask the MSP to fix if it is an issue? 

1st file example:   2nd file example:dog                      dogcat                       birdbird                      cowhorse cowCompare and write what’s missing from file 2 to a 3rd file.  

In the 3D modeled buildings, some normal vectors on the exterior walls are pointing to the right while others are pointing to the left. How can I identify and reverse the vectors that are pointing to the right, so that they all point to the left?I attached sample buildings.

I have 2 datasets of roads, one is a whole of site polygon layer and the other layer is broken into segments for each section of road. I have manually edited the whole of site layer to match our property boundary layer. Now I would like to match the road segments to the whole of site possibly by snapping the segment layer to the whole of site layer. I really hope there is a way to do this as it would be a massive job to manually align each individual segment to the whole of site layer. It has taken me 3 weeks to do the whole of site layer alone.

Hi Guys, I have recently using FME and would like to know if anyone can help me explain how to extract the polygons from a JSON file. I intend to create a workspace, but it does not extract what I need. Also, I have read a few similar questions about this topic but still do not have a solution. The file is the following one:Also, I have attached my workspace with much of the work :( If there is anyone who can help me much appreciate it.

Using FME Desktop 2023.1 I am able to use a SQL Server Database Connection (None Spatial) and ETL from database with no issue. When I try to publish the same script to FME Server 2021 and attaching the database connection to the script I am getting this errors   Failed to add database type 'Microsoft SQL Server' - FME Flow encountered an error and reported the following message.Path not found I also tried to use an exiting same connection which I already published with FME Desktop 2021.1 and now I am getting this error message 

Hi,I'm trying to clip raster data using a 1k*1k grid shapefile. I'm not achieving the desired results as the clipping is imperfect, resulting in gaps or extra pixels. My goal is to clip the raster strictly within the boundary without any additional or missing pixels.Could someone please suggest a workflow for this?sample data: 

Hello Forum, I have a workspace which consumes an incoming geojson and then outputs three .tab files based on datestamp value combinations (via TestFilters): Active sites – where the start_date datestamp is in the past and the end_date datestamp is in the future Closed sites - where the start_date datestamp is in the past and the end_date datestamp is in the past Upcoming sites - where the start_date datestamp is in the future past and the end_date datestamp is in the future This workspace is doing exactly what I want it to do, so far. However, it’s entirely possible that there may be occasions when no object falls into one of the categories (e.g.: Upcoming sites). At the moment, if that happens then the workspace does not create an output. In this scenario I’m left with the most recent previously created output, where there were Upcoming objects. But in this scenario I need the workspace to create

Using FME 2021, and 2023 SQLExecutor, I am running a simple query to return data from a non spatial table in SQL Server, but I am getting an empty column in return The number of rows are exactly 145 and SQLExecutor result is showing that but the visual Preview just showing an empty column (again with correct 145 rows) I even added a AttributeManager to script but same result is happening Can you please let me know what I am doing wrong here?

Hi,I am trying to write a DWG file with the units set to US survey feet. I can’t get it to work, its is in completely the wrong spot. I’m not entirely sure you can, but I’m not enough of and expert with FME (or US survey feet).Looking at the help file for my FME version (2023.2) it doesn’t have us survey feet as a possible unit to set the insertion units to.I have the unit set in a template file and that doesn’t help when the help says it should use this when I don’t explicitly set it.I am writing to a 2018 DWG (as that is the newest). I know for older versions of DWG you could not set US survey feetDoes anyone have any ideas? Surely US survey feet is a more common unit than the parsec for a DWGThanks

I have a number of CustomTransformers which contain some python - this python may or may not include some third parts python dependencies. It’s not only python, they also use regular old FME transformers as well.I’ve been playing around with the package development guide and doing some testing. I can see how to import third party modules for just normal CustomTransformers. I’d really like to be able to use the package manager tools here to help with dependencies, however, it seems like from my experimenting that fme based custom transformers can not benefit from these tools.Does any one know anything or have any comments on this?