FME Form

HI All, Any workaround to convert a date string (YYYY-MM-DD format) to DD/MM/YYYY ? The field type needs to stay as date string see below: I've tried a few transformers (StringReplacer + ListExploder+ String Concatenator) but couldn't get it to work and show 21/04/2023 Thanks

At first, it successfully connected to the database, but later on, it started encountering errors that were resolved after some time. However, for the past four days, it has completely stopped functioning, rendering me unable to continue with the tutorial.

I have a script that was written for us by a consultant and it’s very intensive. The FeatureReaders are pointing to a connection file to read our SDE, as well as some file geodatabases that are stored locally on the server. The script uses a WorkspaceRunner to access a child script to then do some calculations. However, when I run this from FME desktop on our server, it never completes. It doesn’t throw an error, but it just gets hung up at the WorkspaceRunner. If I try again, the same thing will happen. There’s no common point in the script where this happens. It’s very random. I’ve also attempted to run this script from my desktop, and it works. It’s very very slow, but it does work. However, we need to be able to run this from our server, not my desktop. Any ideas on what I should be looking for in our Server environment? Our server has much more resources than my desktop, so I’m surprised it’s not working – so I must be missing something. Any leads on this would be greatly apprecia

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 have a case where I need to determine which wells (polylines) belong to which unit (polygons) based on spatial relationships. I need to be able to know the percentage of those relationship (wells and units) and some key data associated with the unit. I need to determine percent of overlap and produce two outputs. One to show only the relationships (between wells and units) with the highest percent of overlaps (including their percent overlap value) and an another containing all relationships (between wells and units) and their percent of intersect. Thanks!

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

Using FME workbench and fme.exe file. Both was working earlier. Suddenly both are not able to open any .fmw file. Only if run as Administrator it is working. What could be issue. FME version : 2016 Server : Window 2008

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.

The distance between the road and the plots are not fixed, so we can't use a buffer

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?

File error! Couldn't open file. any idea what will be reason ?

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}.pbf Many thanks Rob

I have an excel file with lat/long coordinates and I'm trying to create points based on them in a file geodatabase. The geometry is being created but I keep getting an error when trying to view the attribute table: "A column was specified that does not exist." I've checked that all the columns are green in the file gdb writer. ​ If I replace the file geodatabase writer with a shapefile writer everything works fine. Can anybody tell me how to figure out what is going on? Using FME Workbench (Form now?) 2020.1 Thanks, Mike

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 ap

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!

Hello, I am using FME Server 2021.2.3 deployed on couple of machines in a fault tolerant configuration We have an Oracle database 19c. I have tried to connect to the database in FME Server, but getting the error message below (see attached also). I can connect to the database from SQLDeveloper on the same server. A similar issue was reported in https://community.safe.com/s/question/0D54Q000080heRDSAY/not-able-to-create-a-new-database-connection-on-fme-server However the solution needed a reinstall of FME Server. Does anyone have other suggestions ? 929028:SQL Query SELECT NCID FROM fme_nc_namedconnections WHERE connectionname = ? AND username IS NULL failed. Error: Unsupported feature

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 all! I would like to write my data to a format called .geo which is used in Sweden but is not supported by FME. I attach some sample how the format looks like: FileHeader "SBG Object Text v2.01","Coordinate Document","UTF-8" begin FileInfo "Application","Geo Professional" FileInfo "SerialNo","123456789" FileInfo "Author","Abcdefghijklmnopqrstuvwxyz" FileInfo "Company","Abcdefghijklmnopqrstuvwxyz" FileInfo "Description", FileInfo "Coordinate System","Sweref 99 18 00 / RH2000" end PointList begin Point "123456",6580210.000,155715.000,,,,"rör i mark med däcksel" Point ..... Point.... end LineList AttributeList I have a list with points and want to fill in the list in the "pointlist" section. Would this be possible with FME right now? Any ideas or help is appreciated.

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_20210630 from Cities Join CityIndex on CityIndex.City = Cities.Name where IndexDate = "20210630" But how can I add multiple attributes - see desired state screenshot attached? Many thanks Philip (6 month FME user)