General

I have the 2023 beta and authored a workspace that I would like to use in your latest official version (2022.2.5) which came out after. It looks like a number of updates that were in the beta are also in the official one. Before I try to open my beta workspace in 2022.2.5, I had a few questions: If the updated transformer versions match, should the prod version accept them?What is the best way to back up or document a workspace to use in an earlier version? Any insight is appreciated, and yes, I learned my lesson.

HelloI am generating a json file for photographs metadata.At the start and end of the file I have an open bracket and a closed bracket. I don't want to have this square brackets in the generated json file.Thanks

Why is Microsoft System CLR for SQL Server 2012, still a requirement for FME to work with SQL Serve Spatial - We are on SQL Server 2019, and we have CLR 2019 and 2017 installed. Surely it should use the CLR that is installed. Without 2012 CLR installed - FME does not work. 

Hi !Any idea how to create a 2D grid with hexagons instead of squares?I would like to reproduce this tool : https://pro.arcgis.com/en/pro-app/latest/tool-reference/data-management/generatetesellation.htmI tried HexBinner transformer but it works with points. So when I try with a grid of points I created, there is some holes in my grid, as you can see... Thank you !

Hi ! I have a workspace with the version 2018. I would like to launch with workspacerunner with an other workspace with the version 2022. That doesn't works but maybe there is a way to make it works. Do you have an idea? Thanks !

I keep getting an error in my Python caller transformer trying to convert dates in the format '%Y%m%d' to Python 'datetime.datetime' format. The transformer works for the first 236 features and generates the following error:Python Exception <TypeError>: strptime() argument 1 must be str, not NoneTraceback (most recent call last): File "<string>", line 38, in inputTypeError: strptime() argument 1 must be str, not NoneError encountered while calling method `input'I have examined the input data and nothing seems out of place or wrong with the data. I am not sure what's causing this.

I am migrating data and are using a dynamic workflow. When I am using the PostGIS writer it run smoothly. But since i need post processing after writing to DB I sat up the FeatureWriter identical to the PG one. But the writer fail du some encoding issues on attributes with Nordic characters in their nameFeatureWriter (WriterFactory): POSTGIS writer: Internal Error: Failed to copy attribute 'FØRSTEDATAFANGSTDATO' to 'fã˜rstedatafangstdato'I cant see this being about case sensitivity since there is no issues using the regular postgis writer.Any ideas how this can be solved? Looks like a bug to me? 

In FME Desktop 2019.2 b19825, the Microsoft SharePoint List Reader/Writer offers SAML as an authentication method for reading from our corporate SharePoint sites.   This method is now absent in 2021.2 b21784 and none of the other authentication methods seem to be working for me. Why was this option removed and is there a workaround to getting FME Desktop to connect to SharePoint sites using normal SPOL credentials.  

Hi all, I have a very simple requirement, find the closest location on a polygon to some points then move the points to that location, this has been achieved using the NeighborFinder and VertexCreator transformers. Further on in the workspace I need to use a PointOnAreaOverlayer to transfer the polygon attributes to the point layer (I realise that this can be done in the NeighborFinder step but for the sake of this post, lets assume this is not possible). The issue I am coming up against is that even though the new location of the point is determined by the NeighborFinder, in some cases the point and area are not considered to be overlapping by the PointOnAreaOverlayer. This is my very simple demonstration workspace:The initial features do not overlap:Once run through the workspace they appear to overlap:However, according to the PointOnAreaOverlayer, one of the points does not overlap:The point that does not overlap (according to the PointOnAreaOverlayer) is the southern most point (

Hi,When I try to run a workspace on the FME server, I receive this error. On my machine, I have ArcMap and Pro installed with 64-bit background geoprocessing. I am also reading data from File Geodb using the Esri Geodatabase (File Geodb) readerArcGIS Enterprise 10.9.1 has been upgraded to ArcGIS Enterprise 11.0, and I am running FME Desktop 2022.0.1.0 and FME Server 2022.0.0.2. It is unclear why I am getting this error. Is it because we have upgraded ArcGIS Enterprise and are using FME Desktop 2022.0.1.0?  Thank you,

I am looking extract data from a csv file, (1) all open orders and (2) all closed orders within the last 90 days. Any recommendations. Thanks

I have the following XML:<?xml version="1.0" encoding="UTF-8"?><MyProblem> <Maat Name="MyName1" Description="LetsDoIt"> <Status_Maat Value="Open"/> </Maat> <Maat Name="MyName2"> <Status_Maat Value="Open"/> </Maat> <Procon Description="FinalCheck"/> <Precon Description="StopAndCheck"/> <Maat Name="MyName3" Description="LetsDoNothing"> <Status_Maat Value="Open"/> </Maat></MyProblem>I can extract the Maat with XMLXQueryExtrator by the following expression:/MyProblem/Maat Notepad++ XMLTools says the path to the Description is /MyProblem/Maat/@Description but this gives an error. And no results. What am I doing wrong?

How to read/write ODS files? Thanks

I'm having a bit of trouble understanding how to extract data from this JSON file my client sent me. It came from Insomnia and I'd be really grateful if anyone could lend me a hand with this.

i use transformer Testfilter to filter type of mutation. Ultimately, I want to know how many mutations there are per type. For that I use StatisticsCalculator.This works fine, except when no value comes from TestFilter. How do I get the process to continue and StatisticsCalculator returns a value of 0?

I have have a set of polygons (actually they are buffers of a point) and I want to buffer these again to leave a ring - just keeping the buffer outside the original polygon. I can do this easily in arc/arcpy by using the buffer type "OUTSIDE_ONLY". How can I get the same effect using FME? I have created the buffers but when I use the clipper to clip one out of the other it clips all the overlapping buffers (which is what I expected) but I can't seem to figure out how to get the result I would like. I feel like I need to split each of the the buffer datasets so that it does the clip on each pair of polygons separately but - I'm new-ish to FME so.... Can't seem to find anything to help online either. This is what I have - the attribute managers are just to fill in an attribute so I can put the two buffers back together in one layer and be able to identify which polygon is which type.This is what I would like to end up with:Not this:

I am trying to summarize Google Calendar events from the text output of Google Calendar. The export breaks the Description attribute across multiple lines (kinda like a permanent word wrap). Do you know of any way to walk through a text file and put relevant text back together (anti-word wrap)? I realize there is a Google Calendar reader but we are having some issues with connecting using 2FA. I was hoping the text output would allow me to get around fighting with the Google connection. For example, I want to eventually get the DESCRIPTION into 1 line: DESCRIPTION:Training Document Rollout\\n\\n-::~:~::~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~::~:~::-\\nJoin with Google Meet: https://meet.google.com/we-m2dbz-xvc\\nOr dial: (US) +1 443-23471-4874 PIN:8were6975#\\nMore phone numbers: https://tel.meet/wje-mebz-xvc?pin=2freaag3037362148&hs=7\\n\\nLearn more about Meet at: https://support.google.com/a/users/answer/912345620\\n\\nPlease do not edit this sect

HiI need to extract from json the info reated to each run  "Name": "Run 1","Start Time UTC": "","Stop Time UTC": "","Duration (hh:mm:ss)": "",  I tried to use the json transformer but no success thx for help Francesco

I have a custom transformer. One of the incoming attribute values contains a comma separated list of strings. As soon as the record passes through any subsequent transformer, the value is set to null. Here is the incoming data with WOTEMPALTEIDs as the value that's getting dropped.After passing through any transformer (AttributeManager in this example), WOTEMPLATEIDs values are dropped to null. The other values are unchanged.Thanks 

i want to create excel is group by complexFolder name same (complex Folder) value have each excel

Hi, It's been a while that I couldn't Add Web Connection for using GoogleBigQueryConnector. Previously it's working well, but after re-install my FME desktop, it's always return Error 401: disabled_client when I try to add web connection using my google account.Error 401: disabled_client Sign in with Google temporarily disabled for this app. This app has not been verified yet by Google in order to use Google Sign In. Request DetailsThe content in this section has been provided by the app developer. This content has not been reviewed or verified by Google.Could some one help me what's wrong here? 

How to dissolve polygons based on an attribute where a dissolved record will include non touching polygons with the same attribute? Using Multi Polygon geometry

On the FME Server VM I have setup, the 64 bit Oracle Instant Client isn't being recognized by FME Server. I have the PATH environmental variable set to the folder. I also installed Desktop on the same VM and it has no problem connecting to Oracle databases.  What else can I try? This is the error I get when running the workbench in Server:Oracle client libraries (e.g. oci.dll) could not be loaded. Ensure that the 64-bit client is installed and properly configured, and the PATH environment variable includes the file path to your Oracle client. Refer to https://community.safe.com/s/article/how-to-setup-an-oracle-instant-client-for-use-with for more informationThe Oracle Instant Client setup is the "Basic Package" Version 21.9.0.0.0 FME Server2022.2.4 Build 22792 - win64 FME Desktop2022.2.4.0 (20230303 - Build 22792 - WIN64)Database Edition

Hi Community, I'm working on a workflow that needs to write a final Feature class based on a particular hierarchy. The workflow includes a few 'AreaOnAreaOverlayer' steps + ListConcatenator to indicate which parcel overlaps which, below a screenshot with the desired hierarchy:1 - Most important parcels A2- Middle important parcels B3- Less important parcels C  I can't run dissolve + clip as need to keep the overlapping information to be 'listconcatenated' so decided to use a Sorter (alphabetical order) to obtain the desired order but isn't working 😞 as there's areas where the parcels C are on top of the parcels B. Below an example where the overlap in the middle between 2 parcels (B + C) should be assigned to B but for some reason is CThere must be a way to tell FME please write parcel A on top of parcels B and then parcels B on top of parcels C and parcels A on top parcels C. A>B>C Thanks a lot in advanced 🙂

 However, I would like to directly read the same file from a URL.Therefore, i have changed the published parameter accordingly (see screenshot attached). The following error messages is produced:Emptying factory pipelinehttps://www.opengeodata.nrw.de/produkte/geobasis/hm/dgm1_xyz/dgm1_xyz/dgm1_32_372_5714_1_nw.xyz.gzPython Exception <FileNotFoundError>: [Errno 2] No such file or directory: 'https://www.opengeodata.nrw.de/produkte/geobasis/hm/dgm1_xyz/dgm1_xyz/dgm1_32_372_5714_1_nw.xyz.gz'Traceback (most recent call last): File "<string>", line 24, in input File "gzip.py", line 58, in open File "gzip.py", line 174, in __init__FileNotFoundError: [Errno 2] No such file or directory: 'https://www.opengeodata.nrw.de/produkte/geobasis/hm/dgm1_xyz/dgm1_xyz/dgm1_32_372_5714_1_nw.xyz.gz'Error encountered while calling method `input'PythonCaller_3 (PythonFactory): PythonFactory failed to process featureAn error has occurred. Check the