FME Form

Has anyone ever used the Wrike API in FME? I'm reading the docs and trying to figure it out but could use some help on how to get a token and then query data within tasks: OAuth 2.0 Authorization | Develop your own integration on the Wrike API

I've built an AutoCAD based automation in FME Form and use blocks with text for some of the output features. The text aligns how it was designed in the block in the FME Form output.   However, when running in FME Flow the text shifts. If I move the block slightly or edit the text in AutoCAD then it snaps back to the correctly designed position.I'm using the same template dwg in FME Form and FME Flow. 

Hello,I have a main table called "Documents". I need to create a table called "List" based on data from the "Documents" table. Within the "Documents" table, I have a column called "ElaborationType," and within it, the number 1 represents the main document. Numbers 6, 14, 33 represent documents related to the main document, i.e., they are lists. My goal is to generate results in the "List" table where the "RecordID" in that row matches the "ElaborationType" equal to 1, but it also repeats or duplicates that number based on the numbers 6, 14, 33.(EXAMPLE: 2302(6), 2304(MAIN DOCUMENT NUMBER 1), 3177(14) belong to the same group because they are in the same cadastral municipality KO_ID).Within the "List" table, I need to have 2304, 2304 because they are lists for the main document 2304, and they must have their corresponding year from the "FromYear" attribute.I

Hello,I am currently working with FME Desktop 2022 and I have encountered an issue while trying to generate sequential numbers in a column based on attribute values. I have two tables, "Dokumenti" and "KatOperat," and I need to create a connected table called "ListKatPlana." In the "ListKatPlana" table, I have two columns: "ID_KatOperat", "ID_List" and "creationDate".The challenge I'm facing is generating the values for the "ID_List" column based on the "Koliko" attribute in the "Dokumenti" table. The "Koliko" attribute represents the number of records that should be associated with each "ID_KatOperat." For example, if I have an "ID_KatOperat" of 2304 and the "Koliko" attribute is 9, I need to generate numbers from 1 to 9 in the "ID_List" column for that specific "ID_KatOperat."I have tried using an a

I am receiving a JSON file that's around 85 MB. The file contains a large around of elements in a single nesting. I want to extract a given value by looking at the neighbor key.  In the example below it could be that I want to extract the value "2.000" from the section where "field" has the value "Frontside heights interval".         "field" : "Frontside heights interval",         "value" : "2.000",Can this be done using the built in JSON transformers?{   "stackId" : "d9a5ba5e2a00407ca52b68f902e43393",   "departmentId" : "5f4adeebe93b46368e6451f8b43ba914",   "registrationPosition" : null,   "measurementPosition" : {      "longitude" : 9.6567316353411,      "latitude" : 56.30290238191994,      "height" : 29.993129805661738,      "accuracy" : 6.213567568298807   },   "stackNumber" : 0,   "polterId" : null,   "registrator" : null,   "surveyor"

Hi, I have features about vegetation observations with many attributes like Date, ObservationId, Latitude, Longitude, IdTaxon and IdTaxCompl.I did the following workflow obtaining successful results: 1) buffer features to a specific distance; 2) Dissolve buffered features grouped by IdTaxon (obtaining what I call "stations"); 3) Renamed IdTaxon to sIdTaxon on the Dissolver resultant table; 4) Add a UniqueID for each station; 5) using a combination of PointOnAreaOverlayer, ListExploder and TestFilter I manage to join the corresponding StationId to the original observations table. To do this I set up PointOnAreadOverlayer to produce a list On Output 'Point' with the selected attributes "_ulid" and "sIdTaxon". I need the exploded list because observations of one species may also intersect stations from other species (so my TestFilter select the overlayed data using the condition "IdTaxon like sIdTaxon".My problem is that alt

Hello , i have 2 dataset with different geometry points has the same id (points id at dataset 1 is the same points id at dataset 2 (same color as picture) but each point has different geometry and lines also has different geometry. probably , there are few points Id at the middle of network at dataset 1 are not the same point Id at dataset 2 . Lines in each dataset has different id , but they connect with same id point in different dataset but with different geometry .i would like to compare between two dataset and find which line id from dataset 1 equal line id from dataset 2 .my target to get specific attribute from lines at dataset 1 to provide for each lines equally at dataset 2 . FME 2021

This is the URL i'm trying to access. https://qpublic.schneidercorp.com/Application.aspx?AppID=1048&PageTypeID=4&KeyValue=450070160000It's a public link. If I try to access it via the HTTPCaller, it throws a 403 error. Why would accessing the link via HTTPCaller throws an error? Thanks

Is it possible to establish a connection to the Government of Canada's open data portal. From there I would like to be able to pull certain layers of interest and then transform them to output products I can share to staff/public.

https://engage.safe.com/support/downloads/fme/2023/win64/fme-form-2023.0.2.1-b23339-win-x64.exe

Hello, I have a client who just installed the latest version of FME Form 2023.0.2.1 Build 23339 WIN 64 and when he runs a workspace, nothing shows up AT ALL in the translation log window. It remains completely blank. We tried using the Log File in the logging section of the Workspace Parameters and when we open this file in a text editor, it is not empty and shows the translation log as expected. I am starting to think it might be just a weird visual bug with FME Form 2023.0.2.1. Did anyone else experienced this bug in the past with 2023.x or any other version of FME Form? I added pictures to show what I mean by a "blank" translation log window and also my client's log settings and log file. Thank you.  

Hello , i would like to understand in detail more about anchored snapper segment type .what is difference in segment type instead of others ? my case : I have end points but there are a little bit far away from lines and they should intersect with lines .when i use vertex point type ,with specific distance (0.2) nothing happened but when I use segment type with same distance (0.2)I found the lines changed the position and the points to let the point intersected with lines .i am only afraid if using segment type ,May be let some lines intersect with wrong nodes.what is the best method to Snap some end points to vertex of lines without problems ?i have used points as anchors and lines as candidates (Anchored snapper transformer )2.will be possible to let end point intersect with vertex of lines with out changing the position of lines ? Bcs segment types cause changing of position of lines i am thinkin

hi community, I need some help.I would like to connect my information system to Planning PME via API. For that, I need to get a token.With a OAuth 2.0 protocol, I know how to do but the protocol is not a OAuth 2.0 protocol. I just have a API key and my login ID Perhaps I have to enter these parameters in a HTTP Caller?I attach the API Documentation. Thanks for your help   

I ask I have checked subtype/Assetgroup but the data still displays coded values instead of description

Hi, I’m trying to add into a pdf (PDF2D) an image. I have created it as a png with transparent background. However when the pdf is created the background is black. I have tried different things but can’t figure it out how to remove the black background. This is what I’m doing: CreatorRasterReaderRasterGeoreferencerPDFStylerPDFPageFormatterPDF2D Writer  I played with the PDFStyler but it doesn’t change the result. Can somebody guide me? Thanks,

Currently I am moving from FME 2018 to FME 2022, but during the FME Desktop Advanced trailhead training it says that some transformers only have cosmetic changes. I want to know what the main, commonly used transformers which I can advise my team to always upgrade in their workbenches. Thank you in advance

I need to convert: { "keys": [ <ordered list of field names>], "values": [ "<ordered list of field values, matching the keys field order> ]} What is the best way to do this in FME? Input example: see attachment  

Currently we have the following where clause for the database connection which works well: Need to add additional parameter which is [transactiondate]= CONVERT (date, GETDATE()) . Tried the following but no results returned:[PartDate]= CONVERT (date, GETDATE()) AND [transactiondate]= CONVERT (date, GETDATE()).Ran in SQL and for sure there are data based on the above where statement. Please let me know what did i do wrong. Thanks.

Hi! I have a big Workbench which does a slope and aspect calculation on roofs to evaluate the potential of solar panels.  I have solved everything except setting different colours on my faces based on the calculated effect by a colour-range. I want to export the extruded 3D polygons to Cesium ION as Cesium 3D tileset to minimize loading time.  See print screens on my workspace below, i have tried maybe 100 different settings on AppearanceSetter and AppearanceStyler without result the only colour visible in the Inspector is the default grey.

HelloI am converting .gdb files to dwg format and want to add autocad object data from the gdb file.Can you help me to get there?

Does anyone know if it's possible to suppress or otherwise fix the following warning which comes up when writing features to an MS SQL server database? The column in the database is "nvarchar(max)" but FME always flags this warning when the workspace runs, because it uses "nvarchar_max". It's only a warning, but when we then deploy this to FME Server/Flow - we regularly check the job logs and these always show the exclamation icon - so just an annoyance as it's not actually an issue.

We updated our FME server from 2022.0.1 to 2023.0.1, ButWhen I try to convert a FGDB file to another format. I get the error screen as belowWe installed Arcgis pro 2.9.3 already.But it is working fine in FEM server 2022.0.1

When the published workspace is unable to connect to database or ArcGIS services via feature reader, then the translation fails but the FME server job status is success. I would like to know if there is a way that FME server status can be marked as failure when specific condition are not met with in the FME workbench workflow??

Logs: OpenAICompletionsConnector_2 Input Input Collector (TeeFactory): Cloned 3 input feature(s) into 3 output feature(s)OpenAICompletionsConnector_2_Input1680804321 Input Splitter (TeeFactory): Cloned 3 input feature(s) into 3 output feature(s)OpenAICompletionsConnector_2_ParameterFetcher (TeeFactory): Cloned 3 input feature(s) into 3 output feature(s)OpenAICompletionsConnector_2_EmptyNumericValues (TeeFactory): Cloned 3 input feature(s) into 3 output feature(s)OpenAICompletionsConnector_2_HTTPCaller (HTTPFactory): [3]: Starting HTTP upload to 'api.openai.com'. Expected transfer size: 411 bytesOpenAICompletionsConnector_2_HTTPCaller (HTTPFactory): [3]: HTTP Upload: sent 411 bytesOpenAICompletionsConnector_2_HTTPCaller (HTTPFactory): [1]: Starting HTTP upload to 'api.openai.com'. Expected transfer

I am reading in 89 TAB files (geology polygons) doing a bunch of stuff, combining them and writing them out as TAB, GDB & SHP. I'm extracting both HEX and RGB values and adding them as attributes to the datasets to facilitate attribute based styling. The output RGB, HEX values match the input values. Unfortunately, the MapInfo writer(s) are outputting the incorrect colours i.e. mapinfo_brush_background and mapinfo_brush_foreground values. An inspector just before the writer has the correct values, but the final TAB file does not. The strange thing is that when I filter out 3 polygons for testing they output with the correct colours. It just goes wrong with 158,000 polygons. Any ideas?