FME Form

DEBUG: urllib3.connectionpool Retrying (Retry(total=7, connect=2, read=2, redirect=None, status=2)) after connection broken by 'SSLError(SSLCertVerificationError(1, '[SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: certificate has expired (_ssl.c:1129)'))': /?format=json&q=Willow+Street%2C+Vancouver%2C+British+Columbia%2C+V5Z 

Hello FMEs, I wanna know how I can switch the license call variable.Can machine B be like machine A to read gdb? 1）Both have ArcMap 10.2.2 and ArcGIS Proin machine A & machine B2）machine A has FME x64 but can read gdbcurrently.3）machine B also has FME x64 but can not read the same gdb

Aside from 2 sparse mentions in FME docs and a video discussing how to use the JSON Reader to parse a STAC that might be hosted out on the net somewhere I don't see anyone talking about FME and STAC - Spatial Temporal Asset Catalogs. Is anyone been working on tools, in or out of FME, that build said catalogs? We've got ~20 years of imagery stashed here and there on our servers. It would be good to get them indexed in a STAC to increase discoverability within our org. (And for those which are not contemplating building Stacs, what are you doing instead?)

I am just starting to test out 2022.2. Using a ODBC 3.x connection with SQL executor and getting errors I have never seen before. .....was skipped as it was not a valid SELECT statementBADNEWS: Attribute name 'fme_type' removed from schema feature as it doesn't have a type. Current value is 'fme_no_geom'(C:\\code\\fme\\foundation\\framework\\control\\metamap.cpp:1872) class StatusInfo *__cdecl STFMetaMapper::mapFeature(class STFFeature &,bool,bool,bool)BADNEWS: Cannot convert null string into an integer(C:\\code\\fme\\foundation\\framework\\util\\stf\\stfutil.cpp:347) class StatusInfo *__cdecl STF_stringToUInt(const class ObsoleteString &,unsigned int &)... Last 2 lines repeated 40 times ... The query still runs and I get results. The query works fine in 2021 with no problems.The job runs multiple statements and I don't want 1000+ errors every time the job runs.If I switc

I have a non-overlapping dataset of polygons. I change some attribute values around and dissolve on one of those attributes. Now my dataset has overlaps. Dissolver is on automatic accuracy. Changing this value manually did not change it for the better. The resulting overlap is small (approx. 1mm width), the dataset is only in the scale of several 100 meters though. So this is not some sliver in the nanometer range. How does this even happen, and how can I avoid it?

We see the below error in logs most of the times.NV-FME-P0001_Engine1  FME Engine failed to register with FME Server 'localhost' on port 7070: Could not establish connection to hostWed-22-Feb-2023 10:46:24.831 AM  INFORM  Thread-13  KNV-FME-P0001_Engine1  Program TerminatingWed-22-Feb-2023 10:46:24.831 AM  INFORM  Thread-13  KNV-FME-P0001_Engine1  Wed-22-Feb-2023 10:46:24.831 AM  INFORM  Thread-13  KNV-FME-P0001_Engine1  Translation FAILED.Wed-22-Feb-2023 10:46:24.831 AM  INFORM  Thread-17  KNV-FME-P0001_Engine2  Wed-22-Feb-2023 10:46:24.831 AM  INFORM  Thread-17  KNV-FME-P0001_Engine2  FME Engine failed to register with FME Server 'localhost' on port 7070: Could not establish connection to hostWed-22-Feb-2023 10:46:24.831 AM  INFORM  Thread-17  KNV-FME-P0001_Engine2  Program TerminatingWed-22-Feb-2023 10:46:24.831 AM  INFORM  Thread-17  KNV-FME-P0001_Engine2  Wed-22-Feb-2023 10:46:24.831 AM  INFORM  Thre

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 ?