- - Community Resources
Ideas
Product Updates
Events
Blog

Home
Forums
FME Form

FME Form

A space to discuss FME Form

27670 Posts

nathContributor

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 :-)

12412

8 months ago

siggisParticipant

asked in Data

problem reading WFS 2.0

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

909

8 months ago

rishi1804Contributor

asked in Transformers

Feature Reader doesn't recognize UTF-8 encoded filename/filepath

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 gelöst as gelo?st. This word is in my filename.

231

8 months ago

gisrewards

asked in Transformers

Converting AGS file to Standard Format

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.

652

8 months ago

me.aelmoContributor

asked in Transformers

How to extract distinct values?

HiI need to extract the distinct attribute values of each field/column. An example is provided below: Input Owner Building_Type Building_ AgeRow 1: Steve Office 1970-79Row 2: Adam Office 1980-89Row 3: Steve House 2001-5 Output: Owner Building_Type Building_ AgeRow 1: Steve Office 1970-79Row 2: Adam House 1980-89Row 3: NULL NULL 2001-5 Any help will be appreciated.

10584

8 months ago

raaijennielsParticipant

asked in Data

Help reading attributes from multiple dwg. files

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

441

8 months ago

j.m-vismaContributor

asked in Data

A little help exposing attributes in a JSON

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 objects might be one, or a hundred, in this case it's three.How do I make FME turn that littl

1182

8 months ago

galigisEnthusiast

asked in Transformers

FeatureReader Performance Improvement

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?

10811

8 months ago

siguseider56Contributor

asked in Transformers

SQLExecutor Not Inserting All Rows

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_ROLE_ID)SELECT @Value(CA_ID), '@Value(BA_ID)', @Value(CONTRACT_ID), @Value(CA_ROLE)WHERE NOT EXISTS (SELECT 1 FROM CONTRACT_ASSOCIATE WHERE CONTRAC

160

8 months ago

dallas2011Contributor

asked in Transformers

Calculation of IRI by integration for a colliding surface

How to calculate the IRI between two points in FME if we know the distance and the slope?Thank you.

Unable to load a library in the folder: C:\\Program Files\\ArcGIS\\Pro\\bin. The error number returned from GetLastError is: 126

After upgrading to ArcGIS Pro 3.0.3 i get the above error when writing to an Esri Geodatabase (File Geodb). Does anyone know what the reason could be? I've also upgraded to FME 2022.2. Thanks in advance!

2216

8 months ago

ottadini

asked in Transformers

Is there a way to use a python virtual environment?

In FME 2018, I want to use a custom python interpreter, and a specific python virtual environment (conda environments).How can I do this?

1919

8 months ago

lsugumarContributor

asked in Transformers

Convert Excel to pdf

Hi! I am trying to convert an excel spread sheet (no spatial data involved, just plain data) into a pdf file with pagination based on a field in the spread sheet. Can somebody help me through the steps of this conversion? I have seen posts about using table adder, text adder, pdf styler, pdf page formatter etc. but I am trying to understand the high-level steps to start developing this process.I was hoping SAFE would have some webinar or tutorial on simple excel to pdf conversion, all I can find is extracting data from pdf and converting to excel.Any help is much appreciated.Thank you,LSugumar.

1291

8 months ago

filipovitzContributor

asked in Transformers

Custom HTML automatic value addition

351

8 months ago

pdorioContributor

asked in Authoring

Custom Coordinate System Monte Mario Italy 1-2

Good evening at everyone.I have a shapefile of buildings in the reference system Gauss Boaga Italy Monte Mario 1 (EPSG:3003) [1]If I reproject these data in ETRS89 UTM 32N (EPSG:25832) using the proj4 library (with QGIS or PostGIS) and I obtain a very valid result [2], which overlaps with the orthophotos in coming from the WMS. [3]I tried to configure a custom SRID [4] by entering the 7 reprojection parameters used by the proj4 library contained in QGIS or PostGIS [5]I tried to reproject with FME using my custom srid, but the result is very different [6]. Is something wrong with the custom configuration [4] or fme transformer [7]?Thank you!In the zipfile: [1] original.shp[2] reprojected_with_qgis.shp[4] MyCoordSysDefs.fme[6] reprojected_with_fme.shpother references:[3] http://pubblicazioni.provincia.fi.it/geoserver/wms?request=GetCapabilitieslayer=orto2016[5]"+proj=tmerc +lat_0=0 +lon_0=9 +k=0.9996 +x_0=1500000 +y_0=0 +ellps=intl +towgs84=-104.1,-49.1,-9.9,0.971,-2.917,0.714,-11.68 +u

493

8 months ago

marta.podsiadSupporter

asked in General

List of layers from Esri webmap

Hi,I am trying to produce a list of all layers that are in Esri webmap. I have the private url of the webmap and I found this Python codefrom arcgis.gis import GISfrom arcgis.mapping import WebMapgis = GIS('home')# if running this from Notebook for ArcGIS in AGOL/Enterprise, replace this line with gis = GIS('home')wmItemId = "myid" #put the id of the webmap in herewmItem = gis.content.get(wmItemId)wm = WebMap(wmItem)for lyr in wm.layers: print(lyr.title) print(lyr.url)Could some please tell me how to use this code in FME?

2835

8 months ago

benvkContributor

asked in Integration

Failed to submit job. Error: 404

Hey, I have FME Server running great, my workbenches are running fine on schedules etc. I have several that are 'job submitters', and I am now trying to use the mobile app to trigger them manually, each time I connect to my server, navigate to my Repository and open the workbench, I click "Run Workspace" and I am immediately thrown an error: Failed to submit job. Error: 404 I am not finding any help articles etc, has anyone seen this issue before?

483

8 months ago

alisonsepContributor

asked in Data

AGOL writer-is there a limit?

Hi, I have one Form workspace that writes to a hosted feature service on AGOL fine. It is set at insert and Truncate. It writes a little more than 9,000 features and I run it every week without issue. However, I now have a different hosted feature service on AGOL that has +23,000 features. When I try the same process to update it, it drops all the data and only ends up writing out 15,000 records at most. The number of records diffs as well. I have tried adjusting the timeout and features per request, but have not been successful in achieving the full write out. Any suggestions would be appreciated.

1116

8 months ago

filipovitzContributor

asked in Transformers

List of special characters in Text Editor

Hi, I'm looking for a list of special characters used in a text editor. Is there a description of their function? Are there any others available that are not listed in the window? For example, I use the MSWordStyler transformerThanksFilip

2005

8 months ago

fme_hansContributor

asked in General

Esri Geodatabase (ArcSDE geodb) readers gives an error only on FME server. (The item does not have a definition.)

Hi, With FME I want to read a sde geodatabase. (feature class). For this I use the reader: “Esri Geodatabase (ArcSDE geodb)”. Until recently this worked. With ArcGis Pro an Attribute rule has been created for 1 field and since then the reader no longer works if the workspace is on FME server. If the workspace is run in FME desktop (not FME server) the reader will still work properly. The message I get when the workspace is running on FME server is: An error occurred while attempting to open the table, feature class or relationship class 'My_TABLE'. The error number from ArcObjects is: '-2147211773'. The error message from ArcObjects is: {The item does not have a definition.} What could be the cause of this. FME server and FME Desktop are the same version. Greatings, Hans

Connect to FME Server using OAuth

Is it somehow possible to receive a connection from another party using OAuth2?Do I need to add a specific user to the user list? Do I need to create an application?Could it be done using a webhook or an automation? Or should i build a webhook or automation and use that as a trigger to connect to another location using OAuth2? The other party does not want to send data to my FME Server without using OAuth as a security measure.

971

8 months ago

fmesafe.podporaContributor

asked in Data

Sequence of points

Hey. I need some advice, or at least direction, on how to solve a complex problem. See attachment: I have a track. The track consists of waypoints, the waypoints are minisegments which consist of a startpoint and an endpoint and these minisegments form one big segment and these big segments form one complete track. The direction of the "flow" of the points is determined by the number of startpoints and endpoints, see below, where we see that the only possible direction is from A to E, since it must connect startpoint to endpoint between the minisegments, which form one segment out of three. The waypoints of one of the segments at the level of the points that make up the minisegments look like this - A, F, C, E: Startpoint: AEndpoint: FStartpoint: FEndpoint: CStartpoint: CEndpoint? EThe problem I'm solving is that some segments have this sequence of startpoint and endpoint reversed in the source data, so that the sequence of points of one of the segments would look like this: E, C, F, A

19617

8 months ago

asabhinavgreats

asked in Transformers

Scheduling workbench on local system

Is there a possibility to schedule the workbench on our local system rather than putting it on the server due to data confidentiality issues?

1816

8 months ago

alejacdContributor

asked in Transformers

Count if event occurred consecutively

Hello,I have some data which shows if an event occured per month. Events 202301 202302 202303 202304 202305 202306 a 1 1 0 0 1 1 b 1 1 1 1 0 0 c 0 0 0 1 1 1 d 1 0 1 0 1 0 I want to count the events which occurred 3 or more times consecutively. So I want to get thisEvents More than 3 consecutive events? count b yes 4 c yes 3 Not sure how I should do this in FME. Can someone help me?Thank you!

531

8 months ago

thiruppathirajsContributor

asked in Integration

image fetcher

Can Imagefetcher download the images from a excel thst have google drive image link

824

8 months ago

1
...
60
61
62
63
64
65
66
...
1107

Page 63 / 1107

Badge winners

nassimkabbouthas earned the badge Welcome Back
nassimkabbouthas earned the badge FME Certified Professional
maniyhas earned the badge Student (Grey)
umutonihas earned the badge Welcome Back
kjsmith1has earned the badge Welcome Back

Show all badges

30,371: 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.