FME Form

Hi FME'ers,I have trying to parse and analyse the log file from our ArcGIS Licence Manager. I have managed to exact the user, the date/time, licence type, machine name and check-in/check-out. I am now trying to determine how long a user checked a licence out for. This would require aggregating or joining the in and out records for a particular user (I think). The difficulty I am having is identifying a unique session, e.g. user A check out the licence at 0900 and checked in at 1700 on 01/01/2019. There is no unique session identifier, just a series of in's and outs and these may span over more than one days. My best guess would be to isolate the user (group?) then do some kind of 1:1 join.....maybe. You help would be greatly appreciated.Thanks,David

Hello,We are slowly getting new users into using FME and building a catalogue of production level FME Workbenches . As a result, we need to start properly documenting them beyond bookmarks and annotations. I am looking for a template, advice or best practice. Things like description, reader/writers, data sources, FME Server components.  Many Thanks, David

Hello Group, I'm wanting to see if I can can create lines from what may be well known binary (WKB) strings (e.g.: 0xE61000000114297C137101D7B2BFE65D8A76C0BF494030842DCBFFD3B2BF70EC7899C0BF4940). To be honest I'm not 100% certain that they are WKB. I have a csv containing these potential WKB values. The workspace is... Creator>FeatureReader (reads in the csv setting the field called 'sp_geography', which contains the WKB value to varchar>GeometryReplacer (with encoding as OGC Well Known Binary and the geometry source set to 'sp_geography'). When I run it all 171 records goi to the Rejected port. There's a curious blue message in the log:  "Invalid WKB encountered.... Last line repeated 170 times ..." This is odd as the WKD values in the csv are, as far as I can see, all unique.

HiSee attached my e-mail report generated by Emailer & HTMLReportGenerator.How can I modify the layout/appearance under HTMLReportGenerator. Tried to look for custom HTML coding under HTMLReportGenerator but couldn't find it. Please kindly provide instructions. Thx.

I have read pretty much all the articles on getting arcpy working on FME, but somehow I keep getting the message that a compatible ArcGIS application could not be found. I have FME 2022.1 installed. ArcGIS Pro v2.9.5, which ships with Python 3.7. In the Navigator, Esri ArcGIS Compatibility is set to Esri ArcGIS Pro, and Python Compatibility to Esri ArcGIS Python 3.7+In the Options, Preferred Python Interpreter is set to Esri ArcGIS Python 3.7+. I also tried C:\\Program Files\\ArcGIS\\Pro\\bin\\Python\\envs\\arcgispro-py3\\python37.dll I have a 1-line Startup Python script: import os, but it still keeps giving me the same error: "ERROR : A compatible ArcGIS application could not be found or is not licensed for Python Compatibility 'Esri ArcGIS Python 3.7+'The workspace has Python Compatibility set to 'Esri ArcGIS Python 3.7+', which requires an appropriate version of ArcGIS Pro or ArcGIS Server. ...Pr

Hello all,I had one file which contains some null values and some state values. So in that case I am using the tester to filter null and non null values .but another file contains all the null values in the same column.so in the both cases we are getting the output in failed port as both files contains​ some null values. So how to differentiate whether a particular file contains all null values in the column or only few null values. So that if file contains all null values then we can send the error message.

I've created a custom transformer which I think can be of use to other FME enthousiasts. I want to upload it to FME Hub as described here Publishing an Item to the FME Hub (safe.com). It states that it is best practice to upload an test workspace as well, but the information provided on how to do that is minimal. Is there somewhere a template available?

HiI noticed a strange behaviour of Esri reprojection transformerI don't have fields with date/time formatsee picturecan you help ?  thx Francesco

Hi, Can anyone help me with process to extract schema from a GDB format

Hi, I have created a view in SQL and brought that on as a reader to FME. The SQL view has done all the filtering and grouping that I need and usually provide more than one row of results.When I attach this reader to an Emailer directly, as you know it will send an individual email per row of data. I tried to add an aggregator, but it needs grouping which has been done on the SQL side already. Is there anyway that I can email out the result of this SQL view, in a table format with all the rows included?

Hello all, I'm trying to get a json templater setup so that I can use an API to ingest some data. The challenge is syntax related, but perhaps I'm not organizing things quite correctly. I have some nested structure, and I've attempted to use sub templates for those parts. I've got body of those three expressions in the three attached text files matching the sections. error message is: 2023-02-22 13:28:33|  0.1| 0.0|WARN |JSONTemplater (XMLTemplaterFactory): The following error occurred near line 29, column 17 of the query:2023-02-22 13:28:33|  0.1| 0.0|WARN |JSONTemplater (XMLTemplaterFactory): invalid expression: syntax error, unexpected ExprSingle (missing comma "," between expressions?)2023-02-22 13:28:33|  0.1| 0.0|ERROR |JSONTemplater (XMLTemplaterFactory): An error occurred while parsing the ROOT template2023-02-22 13:28:33|  0.1| 0.0|ERROR |JSONTemplater (XMLT

Hello,I want to know what features from the little red diamonds feature class don't match the big red triangle's number (seen in FME1 screenshot).  FME2 screenshot shows the null attribute values for the little red diamonds that should read T-9623 from the big red triangle. These features participate in a geometric network connected by line segments.  I'm trying to do QA/QC to clean up the data but first need to filter out the incorrect values.  

If I am not mistaken there is no direct FME reader for XYZ tiles in FME Desktop. Do you see a convenient method for reading raster data being served via an api looking like http://<url>/{z}/{x}/{y}.png ?I need to read such data on the fly. These are Terrain RGB files which I need to convert into some GeoTIFF DEM format for different resolutions.What are possible workarounds or solutions? Could a HTTPCaller help in this case?Thanks!

I'm trying to convert a CSV file of MULTILINE STRINGS for 'road centerlines' to Geometry. I've been able to do so for the 'address points' using "stringsearcher + vertex creator" but am struggling with the 'roads' as there are multiple pairings of coordinates; MULTILINESTRING ((-41.2762718167 173.2862863, -41.2762702333 173.2867388167, -41.2762720167 173.28681425))

Hello all,I would like to know about the difference between the count of values of one column initially while reading and count of values of the same column after filtering. If difference between the count of values is same then ​we will send an email. so how can we achieve this in fme

Hi, trying to manipulate points components in a points Cloud with PythonCaller to make some calculation but can't find any method to reach components like classification or user_components. Is there any way to make it? Thx Nicolas

Hello, I would like to transform LAS files to LTF files using FME. I read that LTF format isnt supported in FME unless i install Leica Geosystems TPS Reader extension. Can someone tell me how to do that? thanks

Some features got invalid when using FME File Geodb Opeam API to import to PostGIS, while they are valid using the GDAL OpenFileGDB.  These features are arc circles. When using FME File Geodb Opeam API, these features become NAN, eg with some coordinates being null. Is there any way to fix this issue when using the ME File Geodb Opeam API to import to PostGIS?  

If I use a PostGIS Reader, to inspector, on a table, it shows the geometry. If I use a SQLCreator using POSTGIS format, doing a select * from same table, it shows fme no geom, is that normal for a SQL to not show the geometry ?

Hi,I´ve created a point-based dataset which includes an attribut (value, distance in meter from the point to a school using OSM routecalculation). I now want to create lines between the points with the highest value (if that makes any sense) adding up to some kind of "service area" to the school (how much area does the school cover if the distance is max 2500 meter). Is that possible and if so, how can it be done? Regards Christian

In SQL, it's possible to select all your data starting with "2023" like this : -------------------------------------SELECT *FROM mydataWHERE date LIKE "2023%"--------------------------------------Is there a way to do it with FME? I have already apply a "DateTimeConverter" to convert my data in FME format (20230223). I see on FME Workbanch that there is a "SQLCreator", but I need to import my data from a url and not from an DataBase like PostGIS

Dear members of the FME community, I am currently facing an issue with my FME workbench 2020, which is running on FME Server 2020. The workbench includes an Excel Writer (latest version) that fans out data into multiple sheets within a single Excel file. This process has been functioning well on a weekly basis for the past two years on FME Server 2020. However, when I attempted to run the same workbench on FME Server 2022, the output was split into two Excel files instead of one, with the data divided between them. Additionally, the file naming convention in FME Server 2022 has changed, with the file name split into two halves, one for each file. For example, in FME Server 2020, the correct file name for the output would be "20230101_filename.xlsx." However, on FME Server 2022, the file name has been split into two parts, resulting in two separate files named "20230101_.xlsx" and "20230101_filename.xlsx." 

I had a solution to this problem using a FeatureJoiner and a Test Filter that worked for smaller data sets (previous solution below). But my datasets have grown and this process is too slow now. I tried InlineQuerier but couldn't achieve success. I suggestion was to write a python program to do this but I am not experienced enough with python.  Is the a way to join to tables as described in the title of the message?  https://community.safe.com/s/question/0D5Dm000006cuXDKAY/categorizing-data-based-on-external-table-with-unique-lookup-minmax-values

Please can someone help me to group points and assign a unique ID to each cluster? I have a large feature containing several groups of points taken from a line (see attachment) but I would like to rebuild the line and make sure they don't all join up together.So far, I am using a vertex extractor to break the line into points. I have played around with neighbourhood finder and it's telling me the distances between points in proximity, but I need to group them to result in something like the attached image.Thanks in advance

I'm working with American Community Survey (ACS) data and would like to rename the attributes in a demographic table with the corresponding values in the metadata table but I'm at a loss. This seems like something that should be less complicated than I'm making it so I'm looking for any thoughts or guidance.