General

I want to translate a dataset from shp to gpkgThere is a id field in attribute table in shp file. I added the transformer "attributeRenamer" to rename "id" to "shp_id"It is success on 2022.0.2 versionWe can't see shp_id field in gpkg and the value in id field is keptBut in 2022.2.3 vesrionIt throw the error as 627 2023-2-28 13:03:03 | OGCGEOPACKAGE writer: OGCGEOPACKAGE writer: For feature type 'd_y_n40', primary key attribute 'id' has unsupported type 'mediumint'. Primary key must have type 'int,PrimaryKey' Is any way can I fix it?Thanks

Greetings,I am getting thousands of warnings, and would like to understand more about them. Let's take these two for example and go from there. Can someone help explain what these warnings are and how to correct them?Also, are these warning slowing the run time down? The run is quite slow, and it's unclear to me exactly why.Thank you,TylerFME Workbench 2022.1 

I am trying to read cell A1 from an Excel file but FME Desktop seems to have a problem with that cell for any Excel. Example 1 (fail): Example 2 (success with other cell): What is happening with cell A1? Why can't I read it like the rest of the cells? Any help would be appreciated! Thank you!

I have 64-bit FME installed and want to read ArcFM'ised ArcSDE data. I have ArcGIS Pro v2.8 on the same machine and 64-bit Oracle client as well. I was able to generate the .SDE connection file in Pro. However using the same .SDE file, I am not able to view the feature classes in FME. I am constantly getting the following error message "Could not open Enterprise Geodatabase. The error number from ArcObjects is -2147216072. The error message from ArcObjects is {Underlying DBMS error[Unknown error No extended error.]}" We also have ArcFm ObjectReader for ArcGIS Desktop 10.6.1a installed as well. What could be the possible reason ?

Hi Support team, Could you please provide temporary license to test the FME server V2022. So that we can tell user to run jobs on FME server for testing purpose. Please provide if you have any manual instruction and document for FME server update and configuration on new server.

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

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

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 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

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." 

Hello everybody I want to know is there a way to convert my 3D shapefile to a 3d tiles cesium ( I don't know if I should transformt it to citygml then 3d tiles cesium) and if there is a way is there a workspace to do so. Here is my shapefile

I have a workbench script that makes multiple ggplots (graphs) for end-user reports. The Rcaller works great in FME Server without error, but it will not export the plots. The output excel files export, but not the plots.

I would like to combine 2 datasets: one containing about 500 monument_id's and one with about 20 types with scores and remark fields that should be added to this monument_ids (to create a list of about 10.000 items).  As there is no attribute value to match (so FeatureJoiner or ReatureMerger doesn't work); can these somehow be combined based on predefined matching attribute names? Or what would be a good idea in this case? Thanks in advance!

Hello there are vertex at equal distance (0.100) but these are unnecessary, only one vertex in 1m is enough. How can I remove the vertex in between, I looked for vertex remover, but I think I am doing something wrong, can you help me please? Additional information: There are always 10 vertexes in 1m.

I'm trying to run a python shutdown script and get this error - "The workspace has Python Compatibility set to 'Esri ArcGIS Python 3.9', which requires an appropriate version of ArcGIS Pro or ArcGIS Server" I've also tried calling the script from cmd line and get this in the engine log - "Thu-19-Jan-2023 10:02:35.348 AM  INFORM  Thread-1100  WP301_Engine6   File "createaprx.py", line 9, in <module>Thu-19-Jan-2023 10:02:35.348 AM  INFORM  Thread-1100  WP301_Engine6    import arcpyThu-19-Jan-2023 10:02:35.348 AM  INFORM  Thread-1100  WP301_Engine6   File "C:\\Program Files\\ArcGIS\\Pro\\Resources\\ArcPy\\arcpy\\__init__.py", line 77, in <module>Thu-19-Jan-2023 10:02:35.348 AM  INFORM  Thread-1100  WP301_Engine6    from arcpy.geoprocessing import gpThu-19-Jan-2023 10:02:35.348 AM  INFORM  Thread-1100  WP301_Engine6   File "C:\\Program Files\\ArcGIS\\Pro\\Resources

I am new to fme, I set up a processing chain to compare two shape files and I would like the output file which will be a renamed shape of the columns.for Example the file checked I have a column called depth_1 I would like the export ca to be depth_upstream.is this possible in fme ? 

Hi guys, I am fairly new in FME but have been working in a workflow and got stuck on something that might be simple solution for some of you. I need to be able of calculating the last calendar day of previous month from today's date. So today being 21/02/2023 my result should be 31/01/2023.  Can you please advise how I can do this ? I have been really struggling to do this and have attempted DateTime Calculator transformer.

Hi, How can I give 3d polygons the height of a base. The ground plane I created with the PointCloudSurfaceBuilder. The 3d Polygons have a z-axis with a value of 0.See the image, the polygons lie above the base and disappear below it.

Hi There, So I am using the: safe.microsoft-sharepoint.SharePointOnlineConnector to download and create .xlsx files in my organization's SharePoint site-- and this transformer is awesome save for one fatal problem...the problem is that the connector only appears to be able to Download or Upload/Overwrite files--but it can not Update existing documents at SharePoint. And the problem is that if a user has the .xlsx document open (in a browser session) the Upload will terminate / fail until all users have closed out of their browser sessions viewing the document. My question: is there a way to Update documents at SharePoint that are being viewed, or is Overwriting the only option. And if the latter is the case, is there a way to terminate all open user sessions of the document at Sharepoint so that the new version can overwrite the old version...Otherwise this transformer, great as it is, is somewhat useless. Any thoughts on this issue, or is it just another "Curse

 how can I separate the data into separate columns? E.gDate                         Information           result 2023-02-20 07:24:00         inform             Current FME version: FME 2022.2.0.0 (2022110)