General

I have a dataset that has multiple records, each with a different types. Each of those types could have any number of records from 1 record to 5000+ records.  How can I write these records to individual files based on a limit of 50 records per file with no more than 10 types? For example: File 1 would consist of:Type 1 = 10 Records,Type 2 = 37 RecordsType 3 = 13 Records File 2 would consist of:Type 3 = 50 Records File 3 would consist of:Type 3 = 5 recordsType 4 = 45 records and so on... and so on... I've tried groupers, and I have tried building lists, I've also tried the modulocounter, but I can't seem to find a way to build this criteria with any of those. Any help is much appreciated! Thank you! I've built a sample set of data that could be used to do testing. My final output needs

Hi Guys, Lets assume below shown line has a certain distance , in that I need to generate line from 1.1 to 1.7. To do this can any one help me on this? Thanks and Regards,Prashanth  

ERROR |HTTPCaller (HTTPFactory): [1]: HTTP transfer error: SSL connect error.When I run a ws with a http-caller on a Remote desktop (and FME-server) I get the fault.When I run the same ws with a http-caller local it runs well (but very slow).There is no firewall issue running on the remote desktop and running on the fme-server.  Why do I get this error? and why is the same workspace running well lacally?Are there steps I can take to locate and solve this fault/message.

i have many PDF , that PDF i want to merge in single PDF  how can i do this 

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:

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.

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?