Skip to main content
  • EN

FME Form

A space to discuss FME Form

10000 Posts
F
fdh12316
asked in Transformers
How can I construct valid geometry for CSG Builder

i am currently working on a task, extracting geometry from IFC file and point cloud and building solid meshes and compare them getting the differences. but as I use generated point cloud solid meshes and IFC solid meshes from IFCwall IFCdoor IFCwindows and IFC Column. but the geometry is always invalid when i put them in to CSG builder. how can i compare difference of two big geometry and what kind of geometry accept CSG builder ?

190
F
mr_fme
Enthusiast
mr_fmeEnthusiast
asked in General
Rounder values

hi, how to round values, for example: 5.1 = 6, 7.8 = 8 and so on... Thank´s

133
david_r
Celebrity
V
vandijkjoostjan
asked in Transformers
List attribute created in custom transform by a python caller can not be used after the custom transformer

I try to make a custom transformer to do linear referencing of point features to a maximum of 10 polylines. Inputs are point features and polyline features with or without measurements. The custom transformer would output a list with the combination _kp{0}.KP, _kp{0}.DCC, _kp{0}.selectedRoute. The KP is the distance along the polyline, DCC is the perpendicular distance to the polyline (negative values on LEFT side of the polyline, positive on the RIGHT side), and selectedRoute name is the name of each polyline. At the end of the custom transformer FME shows the list being created for each feature, but it can not be used in the attributemanager following the custom transformer.

224
K
aaron
Contributor
aaronContributor
asked in Transformers
FeatureReader: Dynamically expose all attributes from multiple AGO feature services

I am feeding all feature services in an ArcGIS Online group into a FeatureReader. I don't know the services or their attributes ahead of time. I can read all the records from these feature services but how do I dynamically expose their attributes? I can see them in an Inspector so they are there. I want to compare each feature service and its attributes with a corresponding feature class and its attributes in an SDE geodatabase.

470
evieatsafe
Safer
gogopotter90
Contributor
gogopotter90Contributor
asked in Transformers
How could I find the relationship between classes from xml workspace

Hello ,i am struggling with get the relationship between classes .i have Exported xml from arc catalog and I would like to find the relationship between classes .I have used the workspace here https://community.safe.com/s/article/geodatabase-xml-workspace-document-schema-readerlist exploder for data element ,I have chosen relationclasses but it seems for me , it does don’t show all relationship classes with others ( some are missing ) My target to find name of feature class and the feature classes related to it FME 2021 please if someone has sample workspace ,I will be appreciated .Thanks in advance

170
evieatsafe
Safer
kmc5678
Contributor
kmc5678Contributor
asked in Transformers
How do I join a CSV to an Esri feature class in an oracle dB and write out the matched records to a feature class in a file geodatabase on my local machine?

I'm currently using a CSV reader, Database Joiner and ESRI Geodatabase Writer. The join is working perfectly:  But when I connect the joined output to the geodatabase writer no records are written to the feature class in the file gdb and I get an error saying "Cannot write a non-area feature to an area feature class": I have tried both Drop and Create and Truncate Existing for Table Handling.  Any suggestions are greatly appreciated.

276
kmc5678
Contributor
colasamk
Contributor
colasamkContributor
asked in Transformers
Dynamically converting datetime format from Oracle to BigQuery (SchemaScanner)

Hello, I'm trying to convert datetime format with SchemaScanner dynamically but I haven't been able to. I have Oracle tables (thousands) and am trying to migrate the data to Google BigQuery.Since it's nearly impossible to create an individual reader for each table and the corresponding writers, I'm using a dynamic Oracle reader and a dynamic BigQuery writer.In the data migration process, I need to convert datatime from Oracle to a different format so that BigQuery can ingest the data. When I was researching for an automated way to convert the datetime data, I came across the SchemaScanner transformer which in theory can detect datetime columns and convert the format dynamically. I've tried to place a SchemaScanner between a dynamic reader and a dynamic writer but it doesn't seem to do anything.In the "Date Handling" section of the SchemaScanner Parameters, I chose "Convert Input Date Format to FME Date" and I chose "Yes" for "

290
colasamk
Contributor
philipwhitten
Supporter
philipwhittenSupporter
asked in Transformers
Is there an easy way to import a reprojection from the ESPG library

The ESPG library contains some reprojection methods. Is there an easy way to import a reprojection method from the ESPG library? For example, can you copy the text from https://epsg.io/8450 to create a new reprojection method in FME?

80
daveatsafe
Safer
virtualcitymatt
Celebrity
virtualcitymattCelebrity
asked in Authoring
Has anyone used the "Surface Model File" in the surface modeller?

I'm working with some large DTM datasets and am killing my machine with the clients requested settings. I wanted to see if this "Surface Model" file could somehow help me process the data in batch. The documentation looks promising, however, I've not really had much luck when testing it and there are no examples anywhere I can find of how to actually use it properly.

220
hkingsbury
Celebrity
charry
Supporter
charrySupporter
asked in General
how generator snowflake id, use FME desktop, uuid generator result is long

how generator snowflake id, use FME desktop,  uuid generator result is long 

120
evieatsafe
Safer
H
hola115
asked in Transformers
question relate to how to split a cell with text and numbers

Hello everyone, I am trying to split a text with the attribute splitter. The text is formatted this way : text1 ( number1), text2 ( number2), text 3 (number3)… I want to extract only the value of the numbers to put it in another attribute. Can you help?

72
H
lorenrouth
Contributor
lorenrouthContributor
asked in Transformers
Using Feature Writer to generate single .dwg file from two processed .dwg files.

I am trying to read in two separate .dwg files, make changes, assign layer names with Feature Writer inputs, and then output to a single .dwg file. But, the data is not combined and it outputs two files from their respective reader instead.My hunch is that the Feature Writer is seeing different schemas coming in, but I can't figure out how to combine. This is one of those "seems easy, what am I missing" issues..I guess?

133
lorenrouth
Contributor
francis_m
Contributor
francis_mContributor
asked in Data
Oracle xmltype and ArcGIS sde

Hi,I read an Oracle Database with "esri SDE" connection file. I need to update the reader. We now have a new Oracle table that contain a new column and the datatype of that column is "xmltype". With a Oracle Reader or SQLExecutor, I can read the "xmltype" data. But if I read the data with "SDE", the column is not there. Like SDE don't understand "xmltype". Any idea ?

100
trentatsafe
Safer
jaygrg111_
Contributor
jaygrg111_Contributor
asked in Data
Can Geospatial PDF Reader Transformer read pdf maps as pdf maps (no spatial feature or table) from SharePoint and publish it as PDF on ArcGISOnline?

I want to be able to read a list of PDFs from SharePoint and publish them on AGOL as PDF.

110
jaygrg111_
Contributor
L
leif
asked in Data
Read XYZ tiles

In QGIS I can open Google Street View coverage using this URL as XYZ tile:https://mts2.google.com/mapslt?lyrs%3Dsvv%26x%3D{x}%26y%3D{y}%26z%3D{z}%26w%3D256%26h%3D256%26hl%3Den&style%3D40,18 The result is following: I can't get it to read into FME Desktop. Any suggestions?

3865
natalieatsafe
Safer
J
jeremielemarcha
asked in Transformers
How to transform a raster into a cross-section-like 3D object (vertical plan) ?

Hi everyone, I have some seismic cross sections that are in bitmap format. I would like to transform them into vertical georeferenced cross sections, something like this (https://gis.stackexchange.com/questions/295586/displaying-cross-sections-3d-volumes-in-qgis-3-x), and export them as 3D object if possible (I'm not sure wich format would be suited for that). I can create lines that represent the acquisition lines for those seismic images but I have no idea how to "hang" them vertically below the line. Does anyone has an idea if it's feasible in FME ? Thanks

670
J
arash_hokm
Contributor
arash_hokmContributor
asked in Transformers
Run FME with Batch-file

Hello FME community, I would like to use batch file and FME to create a tool that is able to export an Excel file to a shapefile and transform the coordinate system at the same time.with batch file i get parameters from user. The sheet name and name of the columns can be different for each transformation. when I try to run the process for different file, Sheetname and Column name should be same as previous file and create shapefile without column or empty columns. I need my Read and Writer to automatically recognize new sheetname and Column name   

410
arash_hokm
Contributor
mwoods
Contributor
mwoodsContributor
asked in General
How to export final output to a zip file?

Hi all. I currently have a workspace that simply downloads some data from a SQL server, puts it threw some geometry checks and then finally uploads the .gdb to an S3 bucket. I would like the final output to be a zip file rather than the .gdb but cannot get it to work. If i change the final output in the S3 connector a zip file is created but it is blank. Any help would be greatly appreciated. Here is a screenshot of my process: 

303
nielsgerrits
VIP
K
khairilariffin
asked in Transformers
Merge 2 PointClouds of samew building but different coordinates and x, y, z together

I have 2 PointClouds I want to merge their components using PointCloudMerger, however their x,y,z and coord values differ. They both represent scan of same building, but one has been set with global coordinates. I have applied Reprojector/CommonLocalReprojector but their location still differ. How do I change one of the PointCloud x y z values to be same other than forcefully changing it? And if I must change them by force what type are their in (Real64, Uint64, Int64, ...) ? Alternatively, how can I pass the component value from each point to other point cloud through an index method as both Point Cloud have same number of points and should have same index.   

542
K
J
judywatsonn
asked in General
FME Desktop Installation Issue on Ubuntu 20.04.1 Intel Evo Laptop - Need Assistance

Hello fellow forum members, I am currently facing an installation issue with FME Desktop on my Intel Evo laptop [https://www.lenovo.com/ca/en/faqs/intel-evo/] running Ubuntu 20.04.1, and I am reaching out to seek your valuable insights and assistance. I have been trying to install FME Desktop, a powerful data integration and transformation tool, but I have encountered some challenges in the process. Here's a brief overview of the problem: After downloading the FME Desktop installer for Linux from the official website and following the installation instructions, I am unable to launch the application. Whenever I try to run FME Desktop, nothing happens, and there are no error messages or indications of what might be causing the issue. I have checked the system requirements and ensured that my Intel Evo laptop meets all the necessary specifications for running FME Desktop. I have also made sure that my Ubuntu 20.04.1 is up to date with the latest patches and updates. I have attempted t

421
debbiatsafe
Safer
gcarmich
Participant
gcarmichParticipant
asked in Transformers
Serial tabular data to parallel Join

I need to take serial tabular data and join or pivot it to columns joined on the common field UniqueID. I've been reviewing joins and mergers but cannot determine how to create this transformation.The resulting data columns should be UniqueID, longitude, latitude, Cat1,...Cat9 Thank you,Gilbert

70
gcarmich
Participant
tomcolley
Contributor
tomcolleyContributor
asked in Transformers
Read part of Cloud Optimised Geotiff (COG)

Hi Is it possible to read a portion of a Cloud Optimised GeoTiff using a bounding box? I'm trying to use the GeoTiff reader with the search envelope set but just get an "Error occured during translation" message after the Geotiff is opened.  Thanks Tom

1580
tomcolley
Contributor
candacel
candacel
asked in General
Is there a transfer size limit with multiple httpcallers in a workspace?

We have a workspace in our cloud that pulls data from our own api.We do one get call per table/api endpoint in parallel, and have about 10 httpcallers that run at once. We are finding that when we reach about 750mb of data in transfer, we get failures. The last table before failing looks like it has a very small amount of data, when in reality it has a significant amount more (see Containers in the logfile).Is there a limit on transfer size in FME? We figured we could try offsetting each call but it's strange that it just fails. I can provide more details but thought I'd start here. Message is "An error occurred while accessing the url"...Note, pulling any table individually through the api is perfectly fine...Pulling all at once through the API causes this error when we reach about 770mb + of data being transferred.... 

110
saraatsafe
Safer
J
jberneathy
asked in Transformers
I am needing to create a polyline from an excel spreadsheet that does not contain any Coordinate Information but has measures.

The output needs to be a horizontally flat line that is built on the values from the measure field. I would also like to insert a vertex at every measure change.

280
DanAtSafe
Safer
mechilders11
Contributor
mechilders11Contributor
asked in General
Using a private SSH key with FTPCaller to authenticate an SFTP Connection hangs in FME Server

As the directions in this topic detail: https://community.safe.com/s/article/Using-a-private-SSH-key-with-FTPCaller-to-authenticate-an-SFTP-Connection-on-FME-Server-and-FME-Desktop I am using a SystemCaller to launch Pageant and load the private keys so the FTPCaller can successfully authenticate a SFTP connection. This is working great in FME Desktop. However, when I load the workspace to FME Server, the SystemCaller just hangs. I have gone the extra step of even loading the keys in Pageant on the server, but still didn't help. Is there something extra that I must do to get this process to work on FME Server? I am using FME Desktop and Server 2022.1 Build 22618.

2465
mechilders11
Contributor

Badge Winners

  • Integrate Data with the FME Platform Training
    gisplanhas earned the badge Integrate Data with the FME Platform Training
  • Welcome Back
    julian_talahas earned the badge Welcome Back
  • Online Training
    gisplanhas earned the badge Online Training
  • Integrate Spatial Data
    daanhas earned the badge Integrate Spatial Data
  • Student (Grey)
    User15904968838663764003has earned the badge Student (Grey)
Show all badges

Community Stats

31,853
Posts
120,989
Replies
39,486
Members

Latest FME

Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.