Transformers

I have hunted through docs but am struggling with dates. I can't do date comparisons in the InlineQuerier (see q linked below) so need to change dates to integers to compare using SQL, but can't figure out how to do that. I also want to be able to convert dates to months for comparison e.g. testing 15 September 2022 vs 30 September 2022 should return TRUE. Still new on the FME journey and any help much appreciated - or a pointer to docs. Thanks, Philip Q. on dates in InlineQuerier using SQLLitehttps://community.safe.com/s/question/0D54Q000080hMJ7SAM/testing-for-between-dates-supplied-by-external-file

Hi, at the FME UC last year there was discussion about a the potential to create a Custom Transformer and in the process consume a swagger/OpenAPI definition. I've been looking at the FME Transformer Designer in the FME 2023 beta and so far I can't see anything which would indicate that this is doable.  Am I missing something? anyone else know anything more about this?

I am going through a list of CAD files, how to keep running the workspace even if it hits an error?

Dear Sir/ Madam, I have two indoor map data. One is the indoor network for the entire floor. Another one is the POI (My interested points A & B). I would like to use ShortestPathFinder to see if the network is routable.  However, I am not sure why I am not able to use the "ShortestPathFinder".  My ultimate goal is to check all my POI points are routable. Could someone please give me a hand? Since I cannot upload the zip file in this forum. I have upload my data on Google drive. https://drive.google.com/file/d/1nYZaHHyXM6DhMzfH_abuBgPPtc55Jpkk/view?usp=sharing Thank you and I am really appreciate your help.  

Hello,is it possible to write an Excel file to a SharePoint site? I don't believe I wish to create a SharePoint list or a lookup but simply overwrite an existing file in a folder sat in SharePoint.I can read a file from SharePoint in just fine using a Reader and just need the equivalent to 'write' I have tried the SharePointOnlineConnector but it's not outputting a file like I would expect.Thanks.

I was surprised using FME 2021 in BATCH mode to find, that DataInspectors (which were active by mistake) wrote all their data to FME_TEMP, and to make it worse the data was NOT removed afterwards. This way my FME_TEMP got filled up with 250 GB of trash and broke my workflow due to lack of disc space. Is this supposed to be normal behaviour lately, or is it a BUG ?Remark: I use Windows 10

Wondering how the schemaMapper can replace the field name for 165 Census fields within the Attribute Manager environment? Seems the examples require remapping the entire list? Is this kind of like a tabular Join in GIS?

I'm trying to load a vector tiles from the URL below but keep getting workspace generation errors. Can anyone tell me if this is possible please? I'd like to load at z=14 for the area of England and then merge the tiles into a single file to save locally.https:\\t1.mapstack.org\tilesets\trees-lidar-2022-ds\tiles\{z}\{x}\{y}.pbfMany thanksRob

For a studie assignment I was free to choose a topic and I chose this. At the moment I have (shp) files with:Property data (e.g. how much solar panels per property with how much WP)Electrical Grid (for the area of interest I have all grid lines - like a road network. Not included are the lines to the properties themselves, but the lines that run under the sidewalk in a neighbourhoud).Transformation Stations (on the gridlines there are a number of transformation stations that are connected). For each property I want to determine a point on the grid lines where the would be connected. And If I have that point I want to determine which transformation station is closest. I thought about LRS and Network Service Area, but after a few night looking for clues on the Internet and trying I have been able to figure out how to start.  Is there someone who can give me tips on how to start en proceed? I have only had a basic leasson in FME and I am having a hard time finding my way. Any help is app

Hello. I have a question about one solution. I have duplicate points with the same name, but with at least different geometry. I need to filter these duplicate points relative to this one coordinate. Passed will be the point with the same name that is closer to this coordinate. I am attaching the fmwt. Thank you very much.

Is there any way to extract only the exterior wall boundary along with its door, window, and other related elements? Please share some ideas I really appreciate your kind support.

Hi there! I have a point cloud representing a dense forest. I am trying to get the 3D convex hull of the point cloud (as a mesh). I have already tried PointCloudToPointCoercer (individual points) into HullAccumulator but the results are unexpected and do not contain the whole point cloud:  Using the Minimum Bounding Volume tool in ArcGIS Pro does the trick, but since the rest of my workflow is in FME, I would like to avoid this option. Is there an FME alternative to this tool? Here is the result produced by Minimum Bounding Volume in ArcGIS Pro:  Hope someone with knowledge of 3D models in FME can help. Thank you!

Hi guys,i have different excel files which i have to split in separate excel files (fanout with row C), name them as Row C input (PA9-BK.....) and keep the formatting...first two columns (the grey ones should stay in all files) and the rest (green colours and so on) should also keep in the new files. how is the plan for that? i have searched some articles but not found the right one.....sry cheers, thx and greetz FRanco

I have an issue trying to get a DGN file into Revit for placing rebar and steel detailing. I've tried the following:Import an IFC from designer - model breaks and has strange behavior.Convert DGN to a DWG file via FME and import to Revit - broken model no resembling original. Has anyone developed a workflow or know a good way to achieve a stable DGN to Revit workflow maintaining most of the original integrity without bugs etc.? Thank you!

Hi, guys, i'm new here. When i make a hatch in Autodesk CAD, and then translate it into GDB via FME, then i use FME exporting to .dwg file, when i zoom in to a very large scale, the new geometry's boundary line doesn't fit the original one, the area of the hatch also changed a little, but the line or arc don't change when i do the same. Can anybody tell me how to make it right? THANKS!!

I am using InlineQuerier to lookup a value and add it as an attribute to my base table (Cities). For audit purposes I want to lookup multiple values and add multiple attributes before performing calculations. Currently I am using a separate InlineQuerier for each additional attribute. Can it be done in one? or using other tools? As an example say the base table is Cities, and I want to look up several different price indexes in a CityIndex table based on specific dates, and add these to the base table. See pictures. To add one attribute I can use an InlineQuerier function:Select Cities.*, CityIndex.IndexValue as Index_at_20210630from Cities Join CityIndex on CityIndex.City = Cities.Name where IndexDate = "20210630" But how can I add multiple attributes - see desired state screenshot attached? Many thanksPhilip (6 month FME user)    

Hi everyone,I am trying to split a large table into multiple files and was playing around with the dataset fanout feature. My table has multiple header rows that contain explanations of each attribute that I wish to keep in each file created by the fanout but I cant seem to make it work.  An alternative that I can also see working is to add a static Sheet to each fanout-file which then contains these explanations. I wasnt able to make that work either though. Any help would be much appreciated.

Hi, we have some PoylgonZ geometries with multipe polygons per building. For each polygon we have different heights. Now we are creating building models in citygml with citygml_lod_name = lod1Solid. This is working already with this workflow:But now we have for each solid one building element. Then I thought on the transformer aggregate to aggregate the solids for each building (by gmlid).But then I have MultiSolids which I can´t write to CityGML (lod1Solid). How can I create only one Solid for each building?Or do I have to use lod1MultiSurface?

Hi, I am using the Email(Send) action within an Automation but am unable to get it to work. I am using: smtp.office365.com on port 587 and StartTLS encryption.The office365 email account has MFA enabled and so I am using an App password.I am able to use the same configuration within the FME Desktop Emailer transformer just fine - but the same parameters do not work within the FME Cloud automation.Error message is:"com.microsoft.aad.msal4j.MsalInteractionRequiredException: AADSTS50126: Error validating credentials due to invalid username or password"My FME Cloud instance is running "FME Server 2022.2.1 Build 22776 - linux-x64"I have also supplied an App Client ID by registering an App within am Azure AD as described in this article but it does not resolve this issue:https://community.safe.com/s/article/How-to-use-Microsoft-Modern-Authentication-with-FME#ForServerAny Ideas?Thanks

Task: Transpose speed sections along a section of road that is provided as 5m point layer, this is to be done for multiple roads with multiple speed sections. Road Layer : 5m Points with ChainagesSpeed Zone Layer : Sections of road with Chainage From and Chainage To When you have one road this task can be executed using TestFilter and manually entering the speed sections using Chainage From in creating the speed attribute. Question:Is there a transformer or a way that I can import the parameters from the Speed Zone Layer, without having to enter the filters manually? As I will need to do this task for multiple roads with multiple sections. Entering different testfilters manually is very time consuming and inefficient and tedious, hoping I can import in bulk?  Appreciate all the advice :) 

While running the FME script I am encountering the following error message :No SCHEMA dataset name was specified (couldn't find a value for `SCHEMA_2_DATASET' or `SCHEMA_DATASET') We have upgraded to new FME version 2021.2 from old fme version (2016). The script is running fine on the old fme version but having some issues in the new FME version.The script has multiple shape file parameters  The data set in the FME script code are in the following format :#! <DATASET#! NAME="SCHEMA_1"#! OVERRIDE="-SCHEMA_1_DATASET"#! DATASET="abc.shp"#! />#! <DATASET#! NAME="SHAPE_1"#! OVERRIDE="-SHAPE_1_DATASET"#! DATASET="def.shp"#! />#! <DATASET#! NAME="SCHEMA_2"#! OVERRIDE="-SCHEMA_2_DATASET"#! DATASET="ghi.shp"#! />#! <DATASET#! NAME="SHAPE_2"#! OVERRIDE="-SHAPE_2_DATASET"#! DATASET="jkl.shp"#! />#! <DATASET#! NAME="SCHEMA_3"#! OVE

Hi All, Hope you are well, I'm trying to upgrade an FME workbench made in FME 2020.2 to FME 2022.2 but keeps giving me a Python error while running,  I assume is something to do with Python 2 (FME 2020) and Python 3(2022) but can't figure out the workaround to update the workbench Would you be able please provide me with the steps to upgrade the workbench without re-creating it in 2022? Thanks in advance 🙂

Hi,I am trying to practice "Generate workspace" module but I don't have "FME Training PostGIS database" connection available. I tried to add database connection, but I don't understand what URL to enter in the "Host" parameter.?

I am having no trouble reading the parcel polygon portal service, its just not bringing over the shape column, so I am unable to write the data to our SQL database.

Hello! When converting DWG/DGN v8 files to DGN v7, the coordinates in the v7 file are rounded, which causes the file to end up a few centimeters in the wrong place. I want the v7 file to have the same coordinates as the v8. How can i solve this?/ What is happening with the transformation that casuses this? The image is very zoomed in, but there is a difference.  Regards,Gustav