- - Community Resources
Ideas
Product Updates
Events
Blog

Home
Forums
FME Form

FME Form

A space to discuss FME Form

27505 Posts

Recently active

Most replies Most views Newest first

p_c_20Contributor

asked in Transformers

Hull Accumulator - what decision making is it doing?

I’m looking at an area of survey points that can be divided into east and west areas by grouping with an attribute value. I have used Hull Accumulator to draw polygons around a) the whole area (light purple) and b) the two subdivisions (darker purple). The point population remains the same overall, but I get different external boundaries in places, when I was expecting the same. Alpha = 0. What would be useful is any description about how the transformer makes its drawing choices. I also end up with a donut hole. Again, am trying to understand how this occurs, as I assumed the transformer would create an external boundary only.Many thanks

393

18 days ago

areyiContributor

asked in Data

Append data iterative to a FGDB

Hi together We have a problem by writing mulriple cable data into a fgdb. The process runs once per cable and writes their information into a fgdb, the process is repeated for each cable, stored in a csv list. Now we have the problem, that the next cable in the list is overwriting the previous one in the fgdb, instead of getting appended. We assume, that the problem lies in the writer configuration, but we don’t find a solution to our problem. Is it possible to append data to existing data in a fgdb or do you have any ideas (like Python skripts, other transformers that could append the data of each run etc...)? Thanks for your support

191

18 days ago

ed-progresContributor

asked in Data

How to sort column names in Table View (Visual Preview)

Hi FME folks,Is it possible to sort the column names in the Table View in the Visual Preview alphabetically?It's frustrating to have to scroll all the way to the right to find a column that starts with an “a”... Thanks!

996

18 days ago

pknoContributor

asked in Transformers

String Pair Replacer inner workings

Helly everyone,I am working with data that consists of abrreviations/code items that are strung together in a single field which I am trying to convert to full text. For that I am using a string pair replacer which contains thousands of mapping pairs, but I have encountered a problem which I can’t seem to solve without knowing how exactly the String Pair replacer does its thing. The problem arises when multiple codes share letters. Here`s an example: I have the following pairs somewhere in my replacement pair string**gn green**bn browng gravelF mudSo F:**bn**gn should map to Mud:browngreen but whats happening is this: M:brown**gravelr.I figured that the transformer probably checks its list from start to finish and ordered my list by string length in hopes it would transform longer strings first. The order of replacement items definetely has a big impact on the result and I was succesful of ironing out most errors in doing that but this particular translation and a few others still dont

331

18 days ago

alegatParticipant

asked in Integration

Orientation de symbole

Bonjour, Je souhaiterais trouver un moyen d’orienter un ponctuel (des supports électriques) par rapport à l’orientation de leurs ligne.

392

18 days ago

vkiContributor

asked in Authoring

Error connecting to Oracle-DB, but only on FME Form (FME Flow ok)

We recently updated to 2024.1 (FME Form and Flow).We have some jobs, that run daily on FME Flow, that read features from an Oracle-db and write to a PostGIS-DB.I downloaded one of the workspaces to FME Form to change something. But in FMEForm I cannot connect to the Oracel-DB anymore. I get this error:Error connecting to Oracle database: message was `OCI_INVALID_HANDLE'. (serverType=`ORACLE_NONSPATIAL', serverName=`xy', userName=`xy', password=`***', dbname=`')I uploaded the workspace again to FME Flow and there it ran successfully.Any ideas, what could be the problem? Thanks in advance.Vera

322

18 days ago

philippebEnthusiast

asked in Data

FileGeodatabase - Coded Domain into Coded Domain ?

Not sure why this is possible, but in the FGDB Writer it is possible to create a coded domain into unlimited coded domain.No idea what is the point of being able to do this, because in ArcGIS this is not supported at all. Well, maybe there is something new I missed from ESRI. But yet I can’t see in ArcGIS Pro the SECOND_CD I created.Anyone could tell me what is the purpose of doing this ? What am I missing?I’m on FME 2024.1.Thanks!

324

18 days ago

mr_fmeEnthusiast

asked in Data

PolygonToCoercer very slow

Hi,I have a workspace that uses some RasterToPolygonCoercer, but the performance is very low.I need to improve the performance. I'm trying to convert some clouds detected in my raster image into polygons.How can I improve that? Thank´s

492

18 days ago

fei2000Observer

asked in Data

Failed to add CSV to ESRI ArcGIS Portal in one process

I am new to FME Workbench and I am using the latest 2024.1 version.When I tested to add CSV to ESRI ArcGIS Portal as a new point feature layer, it succeeded to create a new feature service in portal but failed to insert CSV data into the newly created feature service with following error message: “ArcGIS Portal Feature Service Writer: UPSERT failed for feature service 'Sample_Test': Append job failure: 'Operation rolled back.'”Then I have to re-run my workbench again, and this time it will insert all CSV data into the portal feature service without any issue.BTW, I am using “Create If Needed” as Feature Service Handling parameter.Could someone help me out to make this workbench adding CSV data to ArcGIS Portal in one process? Thanks.

18 days ago

llin

asked in Transformers

DGN Custom Line Style

Started this this help article which is written for V8i and not CONNECT but believe I've added the line styles to the seed. Drew lines set to the appropriate layer and the line styles are correct. Seed is in a ProjectWise workspace and exported for use with FME:Workbench clip:DGN Styler configuration:DGN writer:Translated DGN shows the correct line style in properties but not in the display:Re-importing line styles warns of duplicates:But afterwards the line style is correct:

1043

21 days ago

poonam21Contributor

asked in Data

Create ESRI Shapefile from CSV

Hey,There is one blog on support.safe.com on working with esri shapefile data. There is a scenario and below explained the workspace attached to it.I am not getting how the Shapefile is created in below scenario. The shapefile was already given in the template file.Below is the link of the article - https://support.safe.com/hc/en-us/articles/25407430413837-Tutorial-Getting-Started-with-FME-DesktopHow the esri shapefile used in the reader is created? Thanks in advance

892

21 days ago

mr_fmeEnthusiast

asked in Data

How to filter pixel value - other way

Hi,I understand that the Raster Expression Evaluator transformer doesn't work properly, only in the new version 2024.2.I would like to know how I can proceed with my workspace, as I want to keep only the raster pixels with values greater than 0.3. How can I solve this? Please find my sample attached: https://drive.google.com/file/d/1Yil9aZj5mkiTQi7lbvDJfFejWKQE4YTl/view?usp=sharing Thank´s

332

21 days ago

lsugumarContributor

asked in Data

Load column name as an attribute value and column values loaded into another attribute

Hi, I have an excel spread sheet that i have to read and load into a database table. The structure of the excel sheet is different from that on the database. Sample screen shot of the excel spread sheet is seen below. Columns J-S are county names, and the values associated with it are the cost for each county.I need the 10 county column names loaded as values into COUNTY_CD column in the database and its associated county cost value loaded into database column COST_PER_SQFT. So, for every row in the excel spread sheet I will have 10 rows in the database and each row represents data for each county. The database columns and the values to be loaded should like belowI had looked into several post that does transpose of columns, pivot tables etc, but I couldn’t find a solution that works for me. Any help is much appreciated! Thank you,lsugumar.

342

21 days ago

jaosakkeimrObserver

asked in Transformers

Creating new points/nodes along a line that bends.

So, in the context of pipelines we run camera inspections registering different damages and features along the pipeline. We have registered pipelines by ID in a larger gis database. I already have a script running that reads the information and returns all the registerd freatures in the camera inspections and draws it in a arcgis. The issue is that sometimes the lines have bends even with the same ID. making it hard to create new points at the specified distance. So what i need is something that creates a point at a specific length from the starting point ID, that takes into account the geometric changes of the line. in the example picture under, i want to draw a point at the POI. I have the distance(70m) from start. But there does not seem to be obvious functionality for this in FME. Any ideas?

283

21 days ago

markothorenParticipant

asked in Transformers

DPS-file

Hi!Is it possible to create (writers etc) a Data Pump Script (DPS) file for store in Oracle in FME Form ?

WorkspaceRunner tutorial update

Hi folks, I think this very useful article on the WorkspaceRunner could use some love:https://knowledge.safe.com/articles/1469/batch-processing-using-the-workspacerunner-1.html"Article created with FME Desktop 2013"I believe FME has evolved somewhat since those screenshots were made :-)

995

21 days ago

simonlrContributor

asked in Data

DGN reader not reading all of the drawing.

HiI have a DGNv8 3D CAD drawing of a bridge i want to load into FME since i have been tasked with converting it to a different format.The issue is that not all parts of the bridge loads/reads properly, most notably the deck of the bridge is missing. Most of the bridge is drawn using smart solids.Here is the bridge in MicrostationHere is the bridge in FME. All i have done is add a reader and an inspector.And if u look at the feature information for those missing parts it says nan. I have attached the dgn file in a zip file. I hope some can help me or confirm that it is not possible in FME.Thanks for taking the time to read my question.

382

21 days ago

ldreyfussContributor

asked in Transformers

Extract all line segments between many pairs of points

Hello,I have a set of pairs of points that each have a uniqueID_start and unique_end field. I am trying to extract all of the line segments between each pair of points. The tricky thing is that the pairs can be several line segments long, and have other pairs intersecting them:There could also be several points on a single spot, but corresponding to different pair sets.It’s a mess! Any help would be wonderful!

482

22 days ago

pgammieContributor

asked in Transformers

Shapefile to DGN (V8)

Hello, I have a reader with a shapefile that has contour lines in it. I have connected that to the ContourLabeller transformer. I have taken the label output port of the ContourLabeller and run it to a DGN Styler where I have styled it. These parts are all working but when I write it using the DGN (V8) writer the label level is not created. What am I missing here? Thanks!

200

22 days ago

ienesaglam60Contributor

asked in Data

open kmz file error coordinates wgs84 latlon degree to decimal

I have a kmz file. There is a point in it. When I open the kml file with fme, the screenshot is attached where it converts the geographical latitude and longitude from degrees minutes to decimal. Additionally, degrees have been converted from minutes and seconds to decimals by Tubitak, the leading institution in Turkey. The screenshot is attached. Does anyone know the reason for the difference?

191

22 days ago

bkorsagerObserver

asked in Data

I need coordinates of intersection of two lines that intersect

I need the coordinates of the intersection, where lines cross the railroad geometry.With SpatialFilter/SpatialRelator I can isolate the lines (from a larger dataset than shown here). But I cannot identify the coordinates of the intersection.In the drawing the red dots are the points I need, they are handdrawn for explation.Any ideas as to what I could do?Thank you :)

191

22 days ago

mariakaContributor

asked in Transformers

Swap/Rotate profile onto XY-space

Hi there,I have severale profiles, which fly somewhere in 3D space.The elevation always follows the z axis. The direction varies, but follows one direction in XY level.I started like this:BoundsExtractor get the bounds (aka rotation axis) GeometryRefiner do some geometry refining 3DRotator rotate around the axisResult:3D view2D viewred: rotation axisgrey/black: original geometrygreen: rotated geometryI expected the green geometries to be rotated around the axis, but instead they are rotated into 3d space 😵‍💫 I also tried to set the axis through the geometry (z = zmax-zmin), but with no success.Can somebody help?Cheers,Maria

Update sharepoint list

Hi FME fans, I am using the MS Sharepoint List writer to update values - this is using Feature Operation 'Update' using Row Selection 'sharepoint item id'.This works fine when I give it a new value, eg a different date, however if I set the value to null in FME the value in sharepoint doesnot change. How can I set the value to null?Thanks, Owen

568

22 days ago

zkovacs

asked in Transformers

HTTP call JSON parsing problem

I have a problem with parsing JSON which is the result of an HTTP call to get what I need. (See json files attached.)If I download the .json file and simply put it in a JSON reader with a query,filter for type:"Update Feature Attributes" and explode some of the lists, it gives me what I need:My problem is that I have loads of transactions to go through the same way, so I'd need to use an HTTPCaller. I've managed to get that far that with a JSONExtractor I can get "type", "ID" for example, but struggling to break down lists "attributesAfterChange" and "changedAttributesNames" - ListExploder doesn't recognise them as lists for some reason. Any ideas what should I do to get the list values/break down the arrays? Maybe it's very simple but I just cannot find a solution right now. NB: the attributes in these lists vary and not exclusive to what's in the attached json files, so somewhat making it a bit more complex...Any h

mr_fmeEnthusiast

Hi,I have a dataset with 8 images. Look below at the images together: After using the Raster Mosaicker, the output is 1 image like this: What could I have done wrong in the transformer, or what else is necessary?Thanks.

492

22 days ago

1
...
4
5
6
7
8
9
10
...
1101

Page 7 / 1101

Badge winners

sultanbaguduhas earned the badge FME Form Basic Training
msaradahas earned the badge FME Form Basic Training
msaradahas earned the badge Integrate Data with the FME Platform Training
rbrownhas earned the badge Teacher (Grey)
troybum72has earned the badge Welcome Back

Show all badges

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