General

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.

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:

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 227

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 C

 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 __i

Hi,Does anyone know why a shapefile generated in FME would not work in lastools? I am using lastools to clip a point cloud using a buffer from FME but it can't read the shapefile. I don't know why it is invalid, only that my command line has the following errorAny help would be appreciatedThanks

Hi Community, Classic issue with the PointOnAreaOverlaye where I have got one location where the same centroid is shared between two parcels and want to bring the information from point to area. Attached two screenshots that explain the situation. In theory...by creating a list and exploding should work but doesn't give me what I want as the output contains 2 parcels overlaps where there're two points Example 1) I need to bring the assign the point info to each of the parcels. As you can notice the point on the left is shared between two parcels.Example 2) Also, I need to bring the assign the point info to each of the parcels. As you can notice the point on the right is shared between two parcels.

Hi I have two datsetes containing gps time and I need to join but non based on distance but based on timeIn short I need to find the point A with the time more close to the time in table B can you help please ?thx Francesco 

Hi all.An I correct in assuming, that FME cannot handle non-point geometries, i.e. with multiple nodes, when some nodes have Z values, and some don't ?I'm seeing that GeometryReplacer adds dummy Z values (0) where they're missing when importing from WKT og GeoJSON.Is this a problem with the transformer only, or a more general problem with the handling of Z values ?In a system we're running on FME Server, I need to replace any missing Z values with an official fixed value: -99. This is done using the 3DForcer. But if I can't control missing Z values during import, things are very problematic.I made a small test workspace, and ran it in 2020.2 and 2022.2, and both exhibited the same behaviour.Cheers

Is there any guidance/documentation available on the best approach to take when upgrading an distributed installation of FME server based on the Azure marketplace images?

Hi all,I wish to extract some objects from GESW to Shp file. In this I want to extract some of objects which all present in the internal world in GESW.All the suggestions are welcome!Thank you in advance ! Regards,Saravanakumar.

I have a layer of assets in 1 layer and another layer of assets of ours in another layer. I need to find out which assets arent touching eachother. Spatial filter? use the failed ones that come through? how do i make a new layer of the failed ones?

I have hundreds of shapefiles in different folders and subfolders. I would like to create an excel file that shows three columns: ​Col1 = Name of .shp fileCol2 = Geometry of .shp fileCol3 = Directory/Path of .shp file For Transformers, I think I need to start with Creator - FeatureReader, then I get stuck.

Hello,I would like to creat a server app in version beta 2023 and I have some user parameters in my workspace that use the conditional visibility. After publishing the workspace in FME Server 2023, the order of user parameters get wrong (using conditional visibility, after selecting an option, the next parameter should be displayed under or after the first parameter but it displays before the first parameter and it is confusing)Do you have any idea how can I fix the order in FME Server? Thanks

Hi all, I try to use the ArcGISOnlineConnector to update an existing Survey123 Form item on ArcGIS Online, but no success this far.  When I choose Request type 'Update' and upload a zip-file with the same contents as downloaded via the 'Download' action I get the fme_rejection_message:"file must have AGOL item type 'Form'" and fme_rejection_code INVALID_FILE. When I slightly adjust the downloaded zip file by removing the folder 'esriinfo', leave its contents intact and zip these files again with the same file name, it still shows this rejection code. This latter file structure is actually the same as in a blog post by Esri that demonstrates how to use the AGOL REST API and update the item in a Python script. So I expect this to work:

Hello everyone, Allow me to ask you because I would like to set up an alert system based on this urban furniture file.I create two filters one for the condition of the furniture and the second for the management department.It does send an email the problem is that if I have two entities it makes me two emails.  How can I transform to group my entities to send only one email?help, please =)

Is it possible to change the name of a repository on FME server (2022 to be specific)? If so how?