FME Form

Which Fme Transformer will enable me write an Excel Output Data to accept Large Numbers (e.g. No1 below) No1 4111101101005601100102002 No2 Instead of this Scientific Notation of Enconded Number (e.g. No 2 below) 4.1111011010056E+24

Hi, Has anyone had any issues placing in 3D symbols via cell file into FME DGN styler? It seems as soon as a solid or surface is involved the symbol dies not show correctly i.e these elements are missing. any advice thanks?

Hello, Sorry for the inconvenience. We've never installed a floating license. Is there a process, or do I just need to specify where it's located? Thank you for your help. Regards.

Hello, I am looking for additional insights on File Copy Is it possible to copy folder structure without copying files inside ? How do I set the writer ? What is the filecopy_type parameter ? and what are it’s possible values ? The parameter exists on the writer but I can’t find any information. Thank you

Does anyone know how to delete an FME Flow connection in FME Form 2025+? FME Flow connections used to be configured in the FME Options dialog under the Web Connections tab but they are no longer there in FME 2025. Instead, they are now available from the main FME Form toolbar. Using the toolbar I can create a new connection, select and edit an existing connection, but I don’t see any option to delete an existing connection. Even the FME Form documentation does not provide any help.

I want to Create a choice User Parameter that will show column list details from database, This will enable me to select my choice column field that when I run the workflow, I will be able to get the output result for only the column in a fanout dataset.

Hi All, I’m not able to transpose rows to column and complete a count in the end of the workflow, I have followed the technical article but couldn’t make it to work: https://support.safe.com/hc/en-us/articles/25407761369741-Transpose-a-Table-Using-FME Also below an screenshot of the requested output which a excel pivot table: Attached a sample of the raw table that needs to be transposed (or pivoted!) Can I achieve this with the AttributePivoter? Thanks

Bonjour, Je souhaite calculer une statistique zonale afin d’obtenir la moyenne des valeurs de pixels d’un raster, sur une couche polygone (vecteur), comme on a l’habitude de le faire dans un logiciel SIG (voir capture ci-dessous). Merci pour votre aide.

Hello Folks, I have been presented with an interesting issue.I have a CSV which consist of data with multiple headers and related data for those headers. #header 1 and valuesobservationId,broid,_response_body_new,_http_status_codeid_01682157639,GLD000000036023,"""BRO-ID"",""bronhouder"",,""kwaliteitsregime"",""datum eerste meting"",""datum recentste meting""GLD000000036023"",""50200097"",,""IMBRO"",""(2005-11-27, JJJJ-MM-DD)"",""(2025-04-10, JJJJ-MM-DD)"",,,,, #header 2 and values""put BRO-ID"",""put buisnummer"",,""monitoringnet BRO-ID"",,GMW000000074173"",""2"",,,,,,,,, #header 3 and valuesobservatie ID"",""start observatieperiode"",""eind observatieperiode"",""observatietype"",""mate beoordeling"",""observatieproces ID""id_OMO_95135"",""(2024-07-18, JJJJ-MM-DD)"",""(2025-04-10, JJJJ-MM-DD)"",""reguliereMeting"",""volledigBeoordeeld"",""id_OP_95135"",,,,, #header 4 and values""tijdstip meting"",""waterstand"",""status kwaliteitscontrole"",""censuurreden"",""censuurlimietwaarde"",""in

Hi, I am using FME workbench 2024.1 to read an SDE database, every ting looks good, but tables can not be loaded. SDE database works in ArcGIS Pro, and the testing data connection in FME are also good. Anyone has experienced the same?

I wonder if there’s a way for me to hack the web connection during run time to expose the AGOL Organization URL and token so I can use this URL downstream. The ArcGISOnline Connector returns these as format attributes but I have the extra overhead of running the right action item to expose them. Submitted an Idea related to this:

Hi. I built a workspace in 2024.1, that fetches a number of files from a customer Sharepoint site. It works (in 2024.1) without problems. I just installed 2024.2, and ran the workspace (with no changes). Now it issues an error with a SyntaxWarning from the package “safe.microsoft-sharepoint”: C:\Users\xxx\AppData\Roaming\Safe Software\FME\Packages\24783-win64\python\safe.microsoft-sharepoint\stringcase.py:247: SyntaxWarning: invalid escape sequence '\W' return re.sub("\W+", "", string) Is this something that I should worry about ? SharepointOnlineConnector is not listed as an upgradable transformer in 2024.2 Cheers.

SOLVED - I found the error Hello! I've been working on a script that has 56 columns (client needs all the fields of information), and now I need to write it using an Esri File Geodatabase writer. I have double- and triplechecked whether there is an invalid character (since gdbs are quite strict with field names) or a duplicate of one of the fields, but I cannot find it. Is there a tool in FME that let's you identify a duplicate of a whole column in the attribute table? Or a duplicate field name? Or does anyone know if there is another common solution to this error? This is the error code: ERROR |An error occurred while attempting to create the feature class 'Test'. The error number from ArcObjects is: '-2147220649'. The error message from ArcObjects is: {Cannot create a table with a duplicate column. [Test]} I am using FME form 2024.1. Thank you in advance!

I am using a python caller to read paths for files from my Input folder. Files in the input folder are ordered in a ClassName and AssetName folders. There is a variable number of AssetName folders under each class name folder. I am transforming data and using a schema mapper to read transformed schema A series of shapefiles is written with a dynamic writer. How can I copy the input ClassName and Asset Name folder structure when writing the output ? I tried using shp dataset fanout but I can’t get the configuration right.

Hello! Is there a way to change the displayed date in a datetime userparameter as DD-MM-YYYY? The chooser interface is helpful to check if it is the right date, but it can still be quite confusing, especially in Flow, when not every user knows about the picker and just enters the date. Is there an option I am missing or is a text-field instead my only alternative? Many thanks in advance!

I have a large PDF that has bookmarks set up. So far I have not figured out how to access. Thanks

I want to download a PDF with the HTTP_Caller and then write it to a directory on the local computer.

Hi, I have a dynamic workspace where I am reading in multiple csv update files for multiple feature types to upsert into our database. I had set the primary key dynamically dependent on the target table in the database. I cannot set a where clause on an UPSERT (which I do use with other feature types that have the ability to do I, U, or D) so went to use the "Row Selection: Columns:" section instead. This parameter does not work in the normal way with attributes. It presumes the selected attribute is the primary key field (no orange left arrow in front of the name), rather than using the value. I tried manually adding @Value(primary_key) (the attribute that stores the primary key column name) in the parameter but the feature writer also presumes it is literal and obviously can't find a column called "@Value(primary_key)" and errors. This is something that I would like to do, and is very much a part of a dynamic workflow. Otherwise I will have to create one dynamic feature writer for ea

Hi everyone! Today I’d like to share a new approach to building reports in FME, along with an entire family of custom transformers I’ve created to support it. Why I built BRG I’m a long-time fan of the HTMLReportGenerator. It lets me craft reports quickly, and I love the versatility of HTML compared with, say, PDF. I even demo it in every Intro to FME course as a great example of “let FME handle the code.” But as much as I love it, I’ve always hit three pain points: 1. Plain styling – it could really use a dash of CSS/Bootstrap.2. Hard-coded content types – adding a new chart or HTML element isn’t trivial.3. Cumbersome feature ordering – managing Sorters and AttributeCreators just to control layout can get messy. Earlier this year I had to build a highly procedural report with lots of HTMLLayouters, AttributeCreators, and Sorters, and the workspace quickly turned into spaghetti. That’s when I thought: I already improved SystemCaller with BetterSystemCaller … why not do the same for rep

Hello FME’ers, I am currently comparing FME and PostgreSQL/PostGIS when transforming some line geometry. In each scenario I need to round the coordinates to 3 decimal places. This has thrown up a anomaly when rounding coordinates ending .4999. For example, the coordinate 104269.57149999999 will be rounded to 104269.571 by ST_ReducePrecision but 104269.572 by the FME CoordinateRounder. I believe this is due to different rounding techniques like round-to-even or half-round-up. Can anyone explain this behaviour? Is there any “right” answer? Thank you, David

We currently have an .asp script that builds a url/uri based on a selected prefix and document ID. When the OK button is clicked, the url/uri is opened in a new browser tab. The server where the asp script is located is being retired so we need to come up with an alternative. The parameters are Plan Type and Plan Number. The parameters are used to generate a path to the document to open. Eg. \\sample.file.path\resources\SCIMsPlans\pm12345.pdf I have converted the ASP to Python and made a self contained executable that works well but staff are used to accessing the plan search via a web link. I thought a FME web app may be suitable for this. Can anyone point me to the correct transformers to use for this or even better, a sample workspace. In case it helps, below is a snippet from the python script that builds the file path and opens the document. # The Plan document ID number name = self.plan_input.text().strip() # If 'dp' is selected, use 'DP_DepositedPlans' to build the path. folders

We just started integrating data to GCP BigQuery by adding a system environment variable called ‘GOOGLE_APPLICATION_CREDENTIALS’ and pointing that to the service account key file. I am anticipating a need to integrate with a different BigQuery and would like to know how to run parallel integrations to two different GCP accounts. Any thoughts? Thanks.

Hi everyone, I’m pretty new to FME and I’m using FME Workbench 2024.2 to move data from my sde gdb schema to an Esri Parks and Grounds solution fgdb schema. I’m having trouble with the SchemaMapper and moving my domains(attribute values) to the fgdb’s schema. Currently they are not mapping. Previous SchemaMapper parameter settings moved the source attribute value over to the target attribute, but kept the same source attribute value (MULTI-FEATURE STRUCTURE should’ve changed to Jungle Gym but instead it stayed as MULTI-FEATURE STRUCTURE). Can anyone help provide more instruction on how to get the source attribute values to move to the target attribute name and change to the target attribute value? Here’s the .xlsx I’m referencing Here’s my SchemaMapper Parameters

I’m stringing together a bunch of HTTPCallers, each of which has several query string parameters. From what I can see, you are only able to see two parameters at a time in an HTTPCaller transformer (see screenshot). Is there a way to enlarge/expand the dialog box so I can see all or most of them at once? Should be easy; I feel like I’m missing something. It would be so much easier, helpful, and efficient so see all query string parameters at a glance. (FME Desktop 2023.2.0.0, Build 20231201).

I am using FME Workbench 2022.1 along with ArcGIS Pro 3.0. I recently noted an issue when copying data from an AGOL MapService to a local GDB - if the feature class does not exist in the GDB, the Workbench will fail, only reporting "Error running the translation" and no further details in the log file. However, if I create a feature class in the GDB, even without any attributes, and change the writer to "Drop and Create" from "Create If Needed," the Workbench runs. Any Ideas? Log File attached