- - Community Resources
Ideas
Product Updates
Events
Blog

Home
Forums
FME Form

FME Form

A space to discuss FME Form

27665 Posts

Most replies

Most views

Newest first

ivelineContributor

asked in Transformers

Create column from row values and transpose Attribute values

Hi, I need help I have this table ID Année Logements 20 2024 120 20 2025 210 20 2026 340 I would like to obtain this : ID Année_2024 Année_2025 Année_2026 20 120 210 340 Thank you so much for your help!

613

4 months ago

alex_briggs_mmParticipant

asked in Transformers

ProjectWiseWSGConnector - upload folder fails with python error

On 2023.1.0.0 i’m getting the following python error when uploading a local folder of dwg’s to projectwise. The files are uploaded, but i’d be keen to understand why this error is happening - i thought maybe it was a python version but based on this discussion, it might not be? Projectwise transformers gets 'NoneType' object has no attribute 'encode' error on upload | Community (safe.com) 2024-07-24 14:10:57| 5.9| 0.1|ERROR |Python Exception <TypeError>: WebserviceConnectorFactory.set_feature_attributes() missing 1 required positional argument: 'attr_dict'2024-07-24 14:10:57| 5.9| 0.0|ERROR |Traceback (most recent call last):2024-07-24 14:10:57| | |ERROR | File "fme-webfs/src/webserviceconnectorfactory\webserviceconnectorfactory.py", line 253, in input2024-07-24 14:10:57| | |ERROR | File "fme-webfs/src/webserviceconnectorfactory\webserviceconnectorfactory.py", line 1249, in _handleException2024-07-24 14:10:57| | |ERROR | File "fme-webfs/src/web

471

4 months ago

lavanyaneeruObserver

asked in Integration

Azure Devops integration for FME

Hi Team, Can we integrate FME flow and FME server with Azure Devops using pipelines?

721

4 months ago

marjan_nikoukarContributor

asked in Data

Expand address ranges including number and letter in FME

I have and CSV address data file. There are address number ranges that I could expand it with the help of bruttino. Using Cloner and attribute manager transformers.I need to do another clone and need your assistance.I also have 2 fileds: “Street Address Number Suffix From Code” and “Street Address Number Suffix To Code”. For example, from A to D I need to copy based on the number of suffix between From and To, then replace the current suffix. like A, B, C, and D for this example. I also have 2 fields: “Suite from Number” and “Suite To Number”, which are combination of number and letter. For example from 2A to 2D.I need to get a result like 2A, 2B, 2C, and 2D.Do you have any idea how to handle these fields? I really appreciate your assistance.

Regex preview highlight bug

The preview highlights the letters Op but the Regex only replaces the quotes (as expected): Result:‘Op. test ’ will become _Op. test _

242

5 months ago

zizou84Contributor

asked in Transformers

generate numbers between two values

Hello,I need to generate data by year (whereas I only have periods)To do this, I'll need to generate numbers between two values (typically years) to make a join with my existing data.I thought of using counter but I need input data, I just want to generate all the numbers between two values (for ex 1791 to 2024)thanks in advance for your help

koenvdwContributor

Hi I have a shapefile representing image footprints with as attribute the image name.I have a shapefile containing multiple polygons with an attribute ‘name’ representing buffered lines. I have a workbench that selects all the image footprints per line and copies the images to a folder, fanned out with the line name. It does that perfectly, but some images exist in multiple lines and my wb only copies the image to the first line and doesn’t copy it to the other lines. How can I solve that?

647

5 months ago

cpedronContributor

asked in Transformers

Selecting which data to run after a reader

I have a client who is requesting a feature in a workbench that I am unsure how to implement for them.They have asked for an ability to select which data to run after it has been read into the workbench, preferably with a drop-down menu or a tick box. The data coming in would be a multi-site .IFC file, and they are wanting to be able to choose only a specific site and run only that data. I know that to enable that, all data would need to be read, but how do I make it so that they can then easily choose which data to run without having to modify something like a dynamic filter each time?

715

5 months ago

topotomaContributor

asked in Integration

Embedding an HTML Iframe in Arcgis Online Popup

Hello, I have been trying to figure out how to embed a website in ArcGis Online popups but could not get it to work.I have tried the method to have an attribute with the Iframe code as some suggested in earlier version it was interpreted correctly but it seems this is not the case anymore.I have found that there’s a way to embed video for example but nothing for integrating a website. So if you have any suggestion that would be great. Thanks.Thomas

1633

5 months ago

justynakrajewskContributor

asked in Authoring

Normal Vectors

In the 3D modeled buildings, some normal vectors on the exterior walls are pointing to the right while others are pointing to the left. How can I identify and reverse the vectors that are pointing to the right, so that they all point to the left?I attached sample buildings.

591

5 months ago

rustyContributor

asked in Authoring

snap polygons in one layer to polygons on another layer

I have 2 datasets of roads, one is a whole of site polygon layer and the other layer is broken into segments for each section of road. I have manually edited the whole of site layer to match our property boundary layer. Now I would like to match the road segments to the whole of site possibly by snapping the segment layer to the whole of site layer. I really hope there is a way to do this as it would be a massive job to manually align each individual segment to the whole of site layer. It has taken me 3 weeks to do the whole of site layer alone.

464

5 months ago

vanessarapiorContributor

asked in Data

ORACLE_HOME is not set

Hello,I installed FME 2022.1.1 on my laptop and installed the Oracle client (11_2) but even after several reboots I cannot select any Oracle Database as reader. They are all greyed out. When I open a workbench that contains Oracle it says something about missing dependencies: ‘Oracle Non-Spatial’,Oracle Spatial Object’. When I want to run it, it fails and gives the error: ORACLE Home is not set. Does anyone has a hint how to fix that?

872

5 months ago

luisegutierrezcContributor

asked in Authoring

Extract Polygons from Json file

Hi Guys, I have recently using FME and would like to know if anyone can help me explain how to extract the polygons from a JSON file. I intend to create a workspace, but it does not extract what I need. Also, I have read a few similar questions about this topic but still do not have a solution. The file is the following one:Also, I have attached my workspace with much of the work :( If there is anyone who can help me much appreciate it.

802

5 months ago

bhkContributor

asked in Authoring

Issue on Publishing From FME Desktop 2023.1 To FME Server 2021

Using FME Desktop 2023.1 I am able to use a SQL Server Database Connection (None Spatial) and ETL from database with no issue. When I try to publish the same script to FME Server 2021 and attaching the database connection to the script I am getting this errors Failed to add database type 'Microsoft SQL Server' - FME Flow encountered an error and reported the following message.Path not found I also tried to use an exiting same connection which I already published with FME Desktop 2021.1 and now I am getting this error message 49 2024-7-23 11:04:25 | SQLExecutor_<Rejected> (TeeFactory): Feature specification `NO_LOGGING' in mapping file row `FACTORY_DEF * TeeFactory FACTORY_NAME SQLExecutor_<Rejected> INPUT FEATURE_TYPE SQLExecutor_<REJECTED> NO_LOGGING OUTPUT FAILED FEATURE_TYPE * @Abort(ENCODED,SQLExecutor<space>output<space>a<space><lt>Rejected<gt><space>feature.<space><space>To<space>continue<space>tr

461

5 months ago

bill7875Contributor

asked in Transformers

Duplicate records inserted using ChangeDetector when key is not present before running

My workspace is using ChangeDetector with two data sets original and revised. It appears that if the revised records contain two records with the same key and selected attribute and this key does not already exist in the original table then ChangeDetector will want to insert both records in the original table. This happens when the key is not already in the original table before the run. On subsequent runs, ChangeDetector finds the key and selected attribute in the original table, and it behaves as expected and does not insert a record. It treats it as an update or unchanged. How should I account for this? Attached is an image of my workspace. Thank you.

381

5 months ago

mar-garitaParticipant

asked in Data

Performing bulk Portal feature service updates using FME

I need help performing bulk feature service updates using FME.I would like to do what this blog post is doing, under the section "Updating AND Deleting Database Records with FME" but I can't recreate the steps with a feature service in Portal since there is no Row Selection option in these writers. The blog has steps to write to another geodatabase.Essentially, I need to update floorplans data by deleting the old version of the floor plan in the feature service and replacing it with the new floorplan data.The updated floorplans data exist in a geodatabase and it is used to update a feature service in Portal via ArcGIS Pro.Right now, I manually select all the floors that match the LevelID (unique ID we use for each floor in a building) in the update layers.Then, I delete all the features that match and insert the new features into the feature service, using the field mapper to populate necessary attributes.Any advice or help is appreciated. Thanks.

531

5 months ago

keithoContributor

asked in Data

Read Embedded OLE Object from DGN

Using FME Form 2024.0 and DGN v8Hello All,I have a DGN file with an OLE Embedded Excel Object. I am able to locate the element that represents the OLE object and can return all the typical IGDS information about the element itself, size, layer, model its in etc. What I would really like to do is investigate tabs, rows and columns content within that embedded Excel. Does anyone know if there is a way for FME to read an embedded Excel object from a DGN file?

352

5 months ago

mahapandianContributor

asked in Authoring

Raster clipping

Hi,I'm trying to clip raster data using a 1k*1k grid shapefile. I'm not achieving the desired results as the clipping is imperfect, resulting in gaps or extra pixels. My goal is to clip the raster strictly within the boundary without any additional or missing pixels.Could someone please suggest a workflow for this?sample data:

821

5 months ago

ekkischefflerContributor

asked in Transformers

How to write IFC Type Objects?

I am trying to re-write an IFC file including its Type Objects. The IFC reader can either output them as single IfcTypeObject feature type or as separate feature types (IfcWallType, IfcDoorType, etc). Reading the Type Objects works fine for me. After manipulating the data, I would like to write them back into their relevant feature types, e.g. IfcDoor together with IfcDoorType, related through the ifc_type_object_id and ifc_unique_id attributes (I'm unsure how the unique IDs should be created but I simply used the UUIDGenerator where required) I also tried reading and re-writing the IfcTypeObject features. However, the Type Objects seem to be missing from the outputs, giving me warnings like the below. If anyone could help out here? IFC: Unable to write objects of type 'IfcWallType'IFC: Unable to write objects of type 'IfcDoorType'IFC: Unable to write objects of type 'IfcBeamType'IFC: Unable to write objects of type 'IfcSpaceType'IFC: Unable to write

1434

5 months ago

hnahoulderContributor

asked in Transformers

Dynamically expose attributes

I have a workflow that includes transformers and a Python caller. The output of the Python caller generates CSV, GeoJSON, and SHP writers. The workflow has a user parameter called OUTFIELDS, which specifies the fields that should be written. How can I achieve this? I tried using AttributeExploder, but I couldn't dynamically generate the list of fields.

1705

5 months ago

scarterContributor

asked in Authoring

Forcing FME Form to write out an empty .tab file based on null TestFilter results

Hello Forum, I have a workspace which consumes an incoming geojson and then outputs three .tab files based on datestamp value combinations (via TestFilters): Active sites – where the start_date datestamp is in the past and the end_date datestamp is in the future Closed sites - where the start_date datestamp is in the past and the end_date datestamp is in the past Upcoming sites - where the start_date datestamp is in the future past and the end_date datestamp is in the future This workspace is doing exactly what I want it to do, so far. However, it’s entirely possible that there may be occasions when no object falls into one of the categories (e.g.: Upcoming sites). At the moment, if that happens then the workspace does not create an output. In this scenario I’m left with the most recent previously created output, where there were Upcoming objects. But in this scenario I need the workspace to create a tab output , but with no objects within it. Is it possible to programme this in into t

293

5 months ago

joe.fmeContributor

asked in Transformers

OGC Geopackage Writer and UNIQUE constraint failed

Hello dear Community,Despite having a Sorter, DulicateFilter and Tester right out of the gate in my model, I still seem to be experiencing this issue on the ID field of my model - OGCGEOPACKAGE writer: failed to execute insert : UNIQUE constraint failed If I run it one at a time, it seems to work, but I'm trying to write to make different Geopackages, with 4 tables in each (with spatial data). I've been racking my brain about this for some time, changing writers from manual to automatic, deleting any output data after each test run to ensure it's not conflicting, making sure there's no duplicates in the ID field that would trip up the writers, but to no avail - and wondered if anyone here may have a lifeline to throw me.Thank you

2636

5 months ago

jasperwisEnthusiast

asked in Data

DWG Writer - Raster - set img path as a proper relative path

HiI would like to add a raster to a DWG and have the path to this external reference set as a proper relative path.When you write a raster to a DWG file, the AutoCAD writer automatically writes a PNG in the folder of your output DWG.If you keep this PNG file next to your DWG, it will always open. However, if you insert this drawing in a new drawing, the link to the image breaks.This is caused by the path of the external reference (raster) that is not properly set a relative path.If we look at the created path from FME in Autocad, we see this:If you change the path type to relative in autocadThen the saved path changes to: I have tried to copy this in FME, but no effect:Any ideas?Jasper

522

5 months ago

bhkContributor

asked in Authoring

FME SQLExecutor Returns only an Empty Column

Using FME 2021, and 2023 SQLExecutor, I am running a simple query to return data from a non spatial table in SQL Server, but I am getting an empty column in return The number of rows are exactly 145 and SQLExecutor result is showing that but the visual Preview just showing an empty column (again with correct 145 rows) I even added a AttributeManager to script but same result is happening Can you please let me know what I am doing wrong here?

311

5 months ago

james_c_452Supporter

asked in Authoring

Write DWG with US Survey Feet units

Hi,I am trying to write a DWG file with the units set to US survey feet. I can’t get it to work, its is in completely the wrong spot. I’m not entirely sure you can, but I’m not enough of and expert with FME (or US survey feet).Looking at the help file for my FME version (2023.2) it doesn’t have us survey feet as a possible unit to set the insertion units to.I have the unit set in a template file and that doesn’t help when the help says it should use this when I don’t explicitly set it.I am writing to a 2018 DWG (as that is the newest). I know for older versions of DWG you could not set US survey feetDoes anyone have any ideas? Surely US survey feet is a more common unit than the parsec for a DWGThanks

191

5 months ago

1
...
33
34
35
36
37
38
39
...
1107

Page 36 / 1107

Badge winners

herahinahas earned the badge Expert (Grey)
herahinahas earned the badge Teacher (Grey)
herahinahas earned the badge Student (Grey)
adnanyazdanihas earned the badge Student (Grey)
adnanyazdanihas earned the badge Teacher (Bronze)

Show all badges

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