- - Community Resources
Ideas
Product Updates
Events
Blog

Home
Forums
FME Form

FME Form

A space to discuss FME Form

27514 Posts

Recently active

Most replies Most views Newest first

syahirahContributor

asked in Integration

Transfer file from application website to FME using API

Hi communities, I need help for above post which has not been solved yet. I’m totally stuck on this.

161

1 month ago

syahirahContributor

asked in Transformers

HTTPCaller POST method to get FileUpload

Hello, I am configuring FME to receive file uploaded from website through API - POST method. We want the api to directly pass the uploaded file from website to FME for processing. Note that the file is not saved into any DB.The issue I am facing is the the configuration of HTTPCaller Transformer to receive file datatype. Anyone can help suggest on this? Would be very helpful if I can get any advice to configure it the correct way since I’m stuck with this. The logs: The api test through postman has give success response to upload file.The file type I am testing to upload is excel file. Later will need to test with CSV & Shapefile.

583

1 month ago

ed-progresContributor

asked in Data

Can FME read in data from Oracle SQL Views?

Hello,I was wondering if FME can read in data from Oracle SQL Views?If yes, great. How?

contains a Record Index file that is not a sufficient length to be useful and will be ignored.

Why i am Getiing this warning and error when i try to run workspace on desktop and on server

1115

1 month ago

joepkInfluencer

asked in Transformers

Attribute Accumulation question

Hi all, I am currently using a Dissolver with Attribute Accumulation > Accumulation Mode set to ‘Use Attributes From One Feature’.How does FME decide which feature's attributes are used? I assumed it would be the first one to enter the transformer, but I couldn't find anything on this in the documentation. Kind regards,Joep

595

1 month ago

aronContributor

asked in Transformers

Find the "corners" of irregular polygons?

The polygons below have corners that are 90 roughly degrees. I would like to split them at the corners so that I get four lines from each polygon for further processing.The two areas below are only examples, but the rest of the data have similar elongated, bent shapes. I tried finding the corners by intersecting against a bounding box but the result was not very useful because of the irregularity of the shapes. My guess is that I would get the best result by measuring where the vertex take a 80-100 degree turn. Any suggestions on how to achieve this? Or other clever ways to breake the polygons appart?

504

1 month ago

jackfanzhangContributor

asked in Integration

Potential bug in FME 2024.1.2.1 failed to support Databrick JDBC connection

Hello,I have a workbench which includes Databrick JDBC Connection. It was working fine with FME 2024.0.3.0. However, after upgrading to FME 2024.1.2.1, it starts throwing error “java.sql.SQLException: [Databricks][DatabricksJDBCDriver](500151) Error setting/closing session: Connection not obtained from this manager.”Feels like something is missing with the upgrade. Has anybody seen the same problem? Could Safe support team please check? thank you.Full error attached below.java.sql.SQLException: [Databricks][DatabricksJDBCDriver](500151) Error setting/closing session: Connection not obtained from this manager. at com.databricks.client.hivecommon.api.HS2Client.openSession(Unknown Source) at com.databricks.client.hivecommon.api.HS2Client.<init>(Unknown Source) at com.databricks.client.spark.jdbc.DowloadableFetchClient.<init>(Unknown Source) at com.databricks.client.spark.jdbc.DownloadableFetchClientFactory.createClient(Unknown Source) at com.databricks.client.hivecommon.core.H

251

1 month ago

ricardoaContributor

asked in Data

Create polygons from a string of coordinates

Hi there!I want to create polygons from an attribute that contains a string of coordinates and other information. My problem is that I don't know how to only extract the coordinates from the string and then create the polygons by their ID attribute. The string in the coordinates attribute looks like this:“{"type":"Feature","properties":{},"geometry":{"type":"Polygon","coordinates":[[[13.707920553133594,60.03475791657763],[13.708950521395312,60.03304306231432],[13.705474378512012,60.03160680337132],[13.702513219759567,60.02997753853561],[13.702255727694139,60.030577803349054],[13.703929426119434,60.03184261136259],[13.706161024019824,60.032571461785544],[13.707920553133594,60.03475791657763]]]}}” ID attribute 1 to 10 Regards, Ricardo :)

816

1 month ago

mgrimnesContributor

asked in Integration

Problems accessing stored web- and database connections in FME Form 2024

I have just installed FME Form 2024.0. Previously, I have added the option of sharing my connections by setting up the neccessary registry enties.When I open the Database Connections in FME Options I get this message:Which means I have no available Database connections. When I “upgraded” my FME Form installation from 2022.x to 2023.x, this was not an issue.I also see that my Web Connections have the same issue. Is this expected behaviour from FME Form 2024, have I missed some important steps when upgrading/installing 2024 or is this an error in 2024? My 2024 install is in parallell to my existing 2022.2.8, 2023.2.1 and 2023.2.2 installations.We have customers running different versions of FME, so I need FME Form installations in parallell.

1444

1 month ago

ricardohhdParticipant

asked in Data

How do I keep the attributes from a DXF?

I have a DXF file that consists of multiple geometries and attributes. I want to convert this DXF file to a file geodatabase with multiple layers based on each geometry type in the DXF. The different layers also need to retain the same attributes as the DXF files. I attached the file as a zip to this post.I tried loading the DXF file in FME using the Autodesk Autocad DWG/DXF reader and splitting the geometries using a GeometryFilter. That worked fine. However, the attributes disappear when I read the DXF file in FME. Do you have any suggestions on how to retain the attributes of a DXF file when reading it in FME and converting it to a GDB? The data was gathered with a Leica gs18T in case that helps.

161

1 month ago

lifalin2016Contributor

asked in Authoring

Python executable and site-package folder in various versions (e.g. 2022.2.6) ?

Hi.Is there an authoritative list somewhere of which versions of FME uses which versions of Python ?So far I have: 2020=3.7, 2021=3.8, 2022=3.9+3.10, 2023=3.11, 2024=3.12I’m assuming that the Python executable is located in [FME_ROOT]\fmepython###\python3.exe (or the dll’s). Is this correct ?And where is this executable’s site-packages folder located ?Is it at [FME_ROOT]\python ? Or [FME_ROOT]\python\python312 ? Or somewhere entirely different ?And is this location the same in an FME Engine for Server/Flow ?I’m contemplating adding a special Python package for use in both desktop and server.Cheers.

212

1 month ago

kalbertContributor

asked in Authoring

Replace JobWaiter with HTTPCaller

Hello,FME Flow announces the deprecation of the JobWaiter transformer:2024-9-2 10:59:42 | FMEFlowJobWaiter (ServerFactory): FMEFlowJobWaiter was deprecated in 2024.1.0. Its support lifetime is limited because the v3 FME Flow REST API will be removed in future FME releases. When the v3 API is removed, this transformer will stop working. Please update this workspace to use an HTTPCaller to call the relevant REST API directly instead.Question: Is there any ‘how-to’ with a sample workspace which REST call can be used to replace the JobWaiter functionalities? My sample scenario would be: You have 5 jobs running in parallel (wait to complete NO), JobWaiter polls every 20sec until all 5 job_ids are received and completed. all 5 jobs must have _status SUCCESS before Job #6 is called.I tried GET /transformations/jobs/id/{jobid}/result but it failed with 404. Any hint?thanksKlaus

1189

1 month ago

alpheusParticipant

asked in Transformers

Transformers not installed message - AttributExposer and Clipper

Why do I get the message: The following potential problems were detected in this workspace:Transformers are used that are not installed: 'AttributeExposer (version 2)', 'Clipper (version 16)' The install/machine that created this workbench, and the install/machine I’m trying to run it on are different, is it a version mismatch? How can I fix it?

1126

1 month ago

alicevdbContributor

asked in Data

WHERE Clause can read text with macronated o, but fails to read a User Parameter with same text macronated o.

Context: Feature Type with a WHERE clausePurpose: To only read records relating to a user defined Iwi (Maori Tribe).When the WHERE Clause is, for example: "IWI"='Whakatōhea', the transaction is successful and returns the expected records. However, when the WHERE Clause is set with a User Parameter "IWI"='$(IWI)'and the User Parameter is set with the value Whakatōhea, the transaction is successful but no records are found.This behavior is only affecting records with macronated vowels, which is common in Maori language. Users need to be able to input their Iwi of interest for this workbench.Can anyone suggest where the WHERE clause setup might fail?Many thanks

Translation fails when FME cannot delete temporary files

I am running a translation in batch and it is failing when it attempts to cleanup temporary files. Is there a setting that will allow it to continue when this is encountered? ERROR |Failed to delete the following files: 'D:\\Projects\\temp\\fctspatrel1688832115746_12608_1'. Please ensure that the files are not in use and that you have sufficient privileges to delete them. ERROR |Failed to delete the following files: '%0'. Please ensure that the files are not in use and that you have sufficient privileges to delete them.

673

1 month ago

jacklonsdaleContributor

asked in Transformers

JSON unexpected character and string replacing

Hi all,I have a set of JSON files which return an error upon trying to read them in - that it encounters an unexpected character "\\". If i open the JSON in a text editor and remove all the \\ characters it reads successfully in FME then.As i have a batch of 300 JSON files i cant do this manually. I have tried reading in each one as a text file and using a StringReplacer but it is incredibly slow.Has anyone got any suggestions or solutions?Kind regards,Jack

3255

1 month ago

mr_fmeEnthusiast

asked in Data

Problems with feature count server

Hi,Suddenly, the feature count in FME Desktop disappeared, even with the "Enable Feature Counting" option ON.The log shows: Cannot connect to feature count server "65051."Why does this happen?The problem occurs with all formats.Thanks.

392

1 month ago

arunkjContributor

asked in Transformers

AttributeManager with limited sets of attributes

I need something like the AttributeManager but it needs to work only on a limited set of attributes. What I need is a transformer that sets values (conditionally) to a handful of attributes. I need the ability to copy paste this box to various places in a workspace or to other workspaces. I’ve been using AttributeManager but the problem is it gets overwhelmed with other attributes and the transformer changes based on the input stream. I need something that’s sort of shielded from what’s in the pipe. These limited set of attributes are common to various workspaces or workflows (eg, datemodified, lastuser, datecreated etc) and are always guaranteed to exist. So naturally I need them handled in a simple, separate transformer that can be reused. Is there any way to achieve this? Thanks

Unable to convert value taken from Z_ORIGIN keyword to a float data type

Hello,I am writing to ESRI geodatabase that uses MS SQL. Every time I get "Unable to convert value taken from Z_ORIGIN keyword to a float data type". So far i have:Used a 2dforcer,changed the "z scale and z origin" to 0 or 0.00000under table creation parameters set "Contains Z Values" to No (also set to yes, and blank on other trys)Recreated the writersSet the writer geometry to table, not a point file.Nothing has worked. I am under the assumption that the writer is passing a "Null" value to the writer which in turn says that "null" cant be a float value.Finally I have looked at the other posts on this and nothing has helped. Any suggestions? Just to update, I used a vertex creator to make new geometry, and still didn't work, but i can insert all of this into a file geodatabase and then import that to my enterprise database. If anyone has any help please post it, this issue doesn't have a good answer on the forms yet.

9411

1 month ago

lambertusEnthusiast

asked in Data

PostGIS Reader - warning about 3D feactures

I created a 2D spatial point dataset in a PostGIS database.Today I tried to load them into FME, that works perfect. I get the right locations including the according attributes.I only get this warning:Dimension metadata is ambiguous for spatial column 'geom'. Reporting 3D when 2D+measures might be presentDid I forget to set some specific settings while creating this dataset? There should be no 3D data present, I only saved 2D data :)

281

1 month ago

stuart_misoParticipant

asked in Authoring

Use existing Oracle table schema for writing into csv

I have a whopping great big table in my workbench with 2100 attribute fields in it! 😯The data originates from JSON files, and I need to write it into several csv files.The csv files need to pick up the schemas of tables in an Oracle db. These tables have a couple of hundred attribute fields / columns in, so many of my attribute fields will be dropped from the massive table in the workbench when creating the csv. This is good!The Oracle tables do not feature in the workbench at all, so I just need to grab the schema of the existing tables, bring them into the workbench, and use them in the csv writers.I’ve tried to use Schema Scanner, and Schema Mapper but with no luck. I am sure the answer must be really simple and I am doing something wrong.Any help will be much appreciated.Stuart

363

1 month ago

robotixContributor

asked in Transformers

Install Package Manually

I have seen some partial answers to this while searching but nothing definitive.Can someone explain the best way to install a transformer [package] manually on Windows? More specifically, the emailer package from FME Hub. We don’t have internet connection to FME Hub so would need to download the package and install it. Does it have to be installed for each profile or can the users share a location for the package?Thanks!

743

1 month ago

mkov

asked in Transformers

Extract line segments between two points

HiI have a spreadsheet (see table below) with a start and end point coordinates for different road sections and I'm trying to extract the road segments between the start and end points from another dataset containing my road geometry. Unfortunately the start and end points do not always lie on the road so I would need to snap it to the closest road. The road directions (road ways) are stored as separate features in the dataset with a common road id.Section IdStart LatStart LongEnd LatEnd LongA-33.938..., 151.151.-33.935...151.131...B-33.949...151.138..-33.931...151.154...C------------E.g. For Section B, I want to extract the two segments in green from the underlying blue road. The eastbound (EB) and westbound (WB) road features have a common road id of 1.I tried using two vertex creators, a point on line over layer, a topology builder and feature merger, but I haven't had too much success. Any ideas on how this could be achieved?

19912

1 month ago

markotObserver

asked in Transformers

How to buffer a line?

How to buffer a line with different distances on the left and right side?The question is about road centrelines, where buffer needs to have different distances from centre line on left and right side.

512

1 month ago

tbarker1986Contributor

asked in Data

DWG Writer: Preserve Template File Paper Space Issue

Hi All, i’m having an issue writing to an AutoCAD DWG file, with a template file. I want to preserve the Model Space, but not the Paper space as i’m editing some attributes within the drawing title block in FME which I want to write back out in the paper space.Even though I am setting preserve paper space in the writer to No, the original blocks from the template file, including the original attribute values, are being written as well as a copy of the block with the new attribute values I have updated in FME. As a result I have 2 overlapping blocks, 1 with the new values I want to keep and 1 with the original values I am trying to replace. I just want a single block with my new values.In the attached, you can see the output from the writer, with the same block duplicated with the new value I have updated and the old value in the template (highlighted in yellow).Any thoughts/ideas/assistance with this would be greatly appreciated, whether this is possible or not possible. I have done si

401

1 month ago

1
...
8
9
10
11
12
13
14
...
1101

Page 11 / 1101

Badge winners

reidpinkertonhas earned the badge Welcome Back
gullinhas earned the badge Welcome Back
jipxhas earned the badge FME Form Advanced Training
ctmitchhas earned the badge Student (Grey)
edualarconghas earned the badge Spanish Speaker

Show all badges

30,080: Posts

Terms & Conditions Cookie settings

Sign up

Already have an account? Login

An FME Account is required to contribute

Login to the community

An FME Account is required to contribute

Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.

Enter your e-mail address

Back to overview

Scanning file for viruses.

Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.

This file cannot be downloaded

Sorry, our virus scanner detected that this file isn't safe to download.

A product of

Company Products Giving Back Careers Contact Privacy Feedback

Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.