FME Form

I have encountered a strange issue with FME web connections via OAuth2 which does not seem to be resolved yet.On one of our company’s networks physical Windows 10 PC, there are three versions of FME Desktop / FME Flow installed in parallel (we need these to cater to our different customer’s needs). When I routinely tried to check and update an FME workspace, I ran into the problem that authentication with an OAuth 2 Web connection (via Microsoft 365 account) did not work anymore. At first, the web connection window took more than 40 (!) seconds to appear with the logos sometimes not even fully appearing. When I entered my credentials, it takes another 20 seconds and then gives me an error not to have found it. The credentials are tested and correct. There are no proxy connections.Resetting FME Options has not worked, and neither has setting up the web connection completely from anew.Tests on a different machine within the same network (but on my W

Attached are simple FME-Workspaces from version 2017 and FME-Form with GeometryPropertySetters and Aggregators and the xml outputs. The 2 workspaces are exactly the same.FME 2017 writes the aixm Marking Element Geometry as expected, but FME-Form does not - the MarkingElement Geometry Feature is missing (Workaround is to use XML-Templater).Any idea, is this a bug?

Hi All,I’m getting the following error in the FeatureWriter transformer:A field type of 'number(20,version;1;cell_border_formatting;NO;text_alignment;NO;cell_protection;NO)' was specified, which is not valid. Please check the documentation on the Reader/Writer for information on valid field types...the normal GDB writer works perfectly fine with the same data...I had a look into the field types but couldn’t find the error,Any ideas?

I wish to extract a sample from a table where each attribute from some field should be represented x times. For example see below where x is 1, and the fields I want to sample from are House, Priority and Injury. Input:ID      Name    House       Priority    Injury 1        Draco   Slytherin    Medium  Head  2        Harry    Gryffindor  Low        Hand3        Ron      Gryffindor  Low        Head4        Cedric  Hufflepuff  High       Chest Output:ID      Name    House       Priority    Injury 1        Draco   Slytherin    Medium  Head  2        Harry    Gryffindor  Low        Hand4        Cedric  Hufflepuff  High       Chest

I want to style vector by “Mapbosxtyler” and write to .mvt (Mapbox vector tile).I try to make style for line, point no problem. But with the polygon file, Mapboxstyler , I use checked fill style and stroke style to make it, But they can’t. Could you tell me why? Thank you

Hi, I have a text string that looks something like this…LOT 4-6 DP 287 SEC 2-3 SO 345152 I have a regex “(LOT \d+[\s?&-]\d+ DP \d+ ){1,}”  that grabs the LOT 4-6 DP 287 from the text line.How can I split the 4-6 into separate attributes so I end up with Lot 4 DP 287 Lot 5 DP 287 Lot 6 DP 287I could do it with a testfilter but there are unknown combinations. 1-12, 60-62, 78-82 etcAny help is greatly appreciated.Regards, Paul

Hi,I am just wondering if you know the way to get the list of the layers that are chosen in particular Layer List widget in ArcGIS Web AppBuilder. I have used:ArcGISOnlineConnector to get into the web appandHTTPCaller with Request URL that have following structurehttps://YourPortalUrl/portal/sharing/rest/content/items/YourItemId/data?f=jsonUnfortunately t the only infrmation that I got in _response_body in relation to this widget is the label given for the widget in the app"id": "widgets_LayerList_Widget_20","index": 5,"label": "Layer List_2","name": "LayerList","uri":

Hey.I need to count the number of characters in all text fields of my dataset.Any simple way to do this to avoid using multiple StringLengthCalculator ?

Searched for possible solutions here, but nothing yet. Have : col0 col1 col2 col3 col4 Region A BU02851 BU02852 BU02853 BU02854 Region Value A 50 55 40 10 Region Value B 7 11 4 15 Region Value C 60 70 10 25  Need : Region A Region Value C       BU02851 60       BU02852 70       BU02853 10       BU02854 25

Hey. Do you have any idea how to solve the sequential processing of input elements on HorizonAngleCalculator? If I have several elements on the input of the Horizontal Transformer, I need one element to be processed and then the next element to follow after that element is processed. After that, I would put a featureholder after the HorizontalAngleCalculator and it might work. I've tried testing the featureholder with counter and filtering features that have already been processed, but somehow I can't get it to work. Thank you very much

Hello,I have two questions about the HorizontalAngleCalculator transformer. 1) I simply need the AutoCAD Angle property of a line as shown below. Is HorizontalAngleCalculator the best transformer to use?  Or, better yet...is there a way to expose this property in the reader?2)  The install message for the HorizontalAngleCalculator says it’s not not created by Safe Software, but rather by “safe-lab” implying Safe Software Lab which is kind of confusing. Can someone clarify what this means and whether the transformer is trust worthy?Thank you,Tyler

Hello,I am trying to create a workflow in order to transform a dwg to a cityGML file and later to import it into a 3D citygml database.I have tried to find an example online doing something similar but I had no luck.I wanted to ask if something like this is possible with FME and if there is an available example to get a first impression of how to implement it.

Hi.I have a file of text strings that have multiple ‘parts’ that I have split into a _list. Example text string... LOT 9 DP 19723 LOT 12 DP 384274 LOT 8 DP 30287 LOT 9 DP 2402 PT RS 17343 17491 BLK VII X XI TENGAWAI SD-TIMBER NOT ASSESSEDUsing string searcher, I have formed a list of the formatted string to push into the list using regex: (LOT \d+ DP \d+){1,}The result is a list containing the:appellation:LOT 9 DP 19723 LOT 12 DP 384274 LOT 8 DP 30287 LOT 9 DP 2402 PT RS 17343 17491 BLK VII X XI TENGAWAI SD-TIMBER NOT ASSESSED matches: LOT 9 DP 19723  LOT 12 DP 384274  LOT 8 DP 30287  LOT 9 DP 2402  What I want to be able to do is remove the matched part from appellation on the way through leaving me with both the matches as individual features, and a subset of appellation with the matches removed. The resultan

I have an FME workspace that sends me an email during certain error conditions. This works great on my remote laptop, but fails on my onsite desktop machine. The FME workspace needs to be run nightly on my desktop machine. This means that I won’t get the email (and won’t be notified of the error conditions). On my desktop machine, I get this error message: ERROR_DURING_PROCESSING<class 'requests.exceptions.SSLError'>: HTTPSConnectionPool(host='graph.microsoft.com', port=443): Max retries exceeded with url: /v1.0/me/sendMail (Caused by SSLError(SSLCertVerificationError(1, '[SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: certificate has expired (_ssl.c:1000)'))) The only difference I can think of is that my laptop use a VPN connection and my desktop machine is on the company network. I contacted someone in our IT department and they want to know the name of the certificate which I don’t know.Does anyone have ideas on how to r

Hi Community,I have a workspace with some python in to create a container within a blob storage account (something the blob storage connector was not able to do). The problem i’m having is that as soon as i use the blob storage connector in my workspace the package is installed in C:\Users\%username%\AppData\Roaming\Safe Software\FME. This then seems to force FME to use this directory in my python caller. The problem is i’m using newer python packages where BlockBlobService no longer exists and is replaced by BlobServiceClient so they stop working despite being installed as per the instructions for installing python libraries. Does anyone have any suggestions? 

Hi,I am trying to use the RasterObjectDetector for an object detection task using FME Form 2024, but translation fails and I get following error messages:-Library 'C:\Program Files\FME\plugins/opencv/rasterobjectdetectfactory.dll' was found but could not be loaded. Ensure that all the dependent modules exist for this library.-Could not load module 'C:\Program Files\FME\plugins/opencv/rasterobjectdetectfactory.dll' : 'The specified module could not be found'-Module 'opencv/rasterobjectdetectfactory' is unavailable for use with this FME editionI downloaded OpenCV 3.4.9 and added the installation location to the system path, as specified in the documentation of the transformer, but it is still not working. Does anyone know how to solve this?Thanks!

I'm using the ESRIReprojector transformer. When converting between NAD83 and NAD27, I get one option for Geographic Transformer. In ArcGIS, I get several options for Geographic Transformer. Is there any way to get the same multiple options in FME without recreating them? Thanks.

Hi I have a very simple question but it seems i can’t do it . I just want to make a point from an excel list with x y coordinates, but not by writing it to a writer because I have to do a lot of other operations with it. I have already tried different things, I first used a coordinateSystemSetter and then a vertexCreator. But during further edits I always get rejected and my model crashes. It can't be that difficult :-)

WFS 2.0 services are available on the Geoportal Baden-Württemberg. It is not possible for me to view/download the contents of the objects (BP_Plan) with the WFS Reader using FME 2023.Does anyone have any idea what the problem might be?Example:https://geodienste.komm.one/ows/services/org.165.d5516855-2ef7-4512-92f7-68d208f6f722_wfs/org.165.15f5882e-891a-4ce4-b2fc-000a45978e11?SERVICE=WFS&Request=GetCapabilities

In my workbench I download ffs file from azure storage and assign the path in attribute _download_path then try to read the file from the same path using FFS reader but it’s not recognizing the path and in the error even showing wrong name like it’s replacing some characters like it’s considering the wrod gelöst as gelo?st. This word is in my filename.

Hi all, I am trying to convert a AGS File to a standard format to view such as Excel or Shape. I seen something like this online using leapfrog https://www.youtube.com/watch?v=OtyrYsx9teE but struggling to find a simple solution in doing this with FME. Any useful tips would be great.

Hi there,I am fairly new to FME. I have around 6000 dwg. files regarding the same industrial drawings and the data is roughly found in the same place in each file. I would like to know how i can extract the attributes that i need out of these files.I have started using a wildcard function to read multiple files. I know this question is fairly vague, still I was wondering if anyone has the time to help me with this, or knows any recomendations for explanation (youtube or similair examples/workspaces) Like I said, FME is still pretty new to me so any advice would help. Thank you

I am making a call to an API and getting a JSON in return. With the JSONFragmenter and it's flattening options, I can expose most of the attributes in the JSON into FME attributes, but I am getting stuck on a particular structure. Sometimes there's a little table within a single attribute in the JSON like so: "related_objects": [                    {                        "relation_name": "verbinding",                        "relation_id": 1,                        "objects": [                            "randomid1",                            "randomid2",                            "randomid3"                        ]                    }                ] This indicates objects that are related in a particular way to the object in my query. I would like to generate a list of all of the related objects (randomid1, randomid2 etc.). I want to use that  list in my FME flow. The number of related ob

Hi All,I have created a workflow that reads a few large GIS datasets in vector format across different areas. To avoid reading all the records in the dataset and reduce time I have used the FeatureReader transformer which is connected to the layers and an Area of Interest. The Spatial Filter option is ‘turned on’ as Boundary Boxes OGC-Intersect to read only those records within the Area of Interest. The problem is still takes ages to read,I have got a few FeatureReaders within the workflow and I was thinking to use only one FeatureReader (as all the data comes form the same GDB) to improve the performance, Any ideas to improve the performance of the workflow?

I have a SQLExecutor that inserts data child records for contract IDs. It does fine if it’s a one-to-one but if it’s one contract ID with many children, it only inserts one. Nowhere in my workbench does it group by the contract ID though. If there are 2 contracts and each has 2 children, there are 4 individual rows of data to insert. I managed to resolve the issue by adding a select statement after the insert to produce a result. I don’t understand why it’s behaving this way though. Note that I’m using a SQL Executor instead of a writer because of the need to set the audit user for each insert. Below is the sql statement I’m using. Why does the select statement at the end make it work?  FME_SQL_DELIMITER |EXEC sp_set_session_context 'AuditUser', 'SNOW Sync' |INSERT INTO CONTRACT_ASSOCIATE (CONTRACT_ASSOCIATE_ID, BA_ID, CONTRACT_ID, CONTRACT_