- - Community Resources
Ideas
Product Updates
Events
Blog

Home
Forums
FME Form

FME Form

A space to discuss FME Form

27681 Posts

asked in Transformers

can FME support Nato Vector Graphics (NVG)

984

9 months ago

gogopotter90Contributor

asked in Data

How to detect zigzag -spike -dangle lines and fix them ?

HelloHow could FME detect unwanted spike and unwanted zigzag and fix it without changing geometry of lines ?I have used spike remover and zigzag remover but sometimes it catches data that has no relevant with spikes ,what is best angle for transformers?How to keep the original geometry without changing it ,after fix the problem with zigzag or spike remover ?what is the best method to detect dangle lines and fix it ?thanks in advance fme 2021

1333

9 months ago

nicholasContributor

asked in Data

Difference between MapInfo Writers?

Hello all,I want to understand the difference between two MapInfo WritersI am running FME Desktop version FME(R) 2022.1.3.0 (20220928 - Build 22630 - WIN64)The Writers are;MapInfo TAB (MITAB)Precisely MapInfo TAB (MAPINFO) Is one Writer better than the other?

373

9 months ago

kattContributor

asked in Transformers

add an if condition to the json templater

Hello, I am creating a JSON file using several fme attributes. I want to include an if condition. If the typ =’HC’, I want to have an additional attribute (the name) added to the JSON. is it possible? The way the if condition is written here is not correct but it gives you an idea what I would like to do.{"Device": {"Type": fme:get-attribute("TYP"),"latitude": xs:decimal(fme:get-attribute("LAT")),"longitude": xs:decimal(fme:get-attribute("LON")),if fme:get-attribute("TYP") eq "HC" then "Name": fme:get-attribute("NM")}}

1671

9 months ago

bskimParticipant

asked in General

Problem that material is not added to some obj when converting ifc

You are trying to parse the IFC file into Obj and metadata through your company's FME Desktop.I don't know why, but there is a problem that materials are not added to some objs. Please help in this regard.The attached file is the workbench file used at this time.Regards,Bongsup Kim

1267

9 months ago

jmcarthurContributor

asked in Authoring

Supress translation log

Is there a setting to disable the translation log window from automatically popping up when running a workspace? I’ve disabled all logging and hidden the window, but it pops up as soon as I run. I’m trying to record the execution of the workspace for a presentation, and the window keeps getting in the way.

703

9 months ago

chris_accContributor

asked in Transformers

Copy data from ESRI File Geodatabase to SQL

Hello, I am attempting to copy data from an ESRI FileGDB to a Feature Class in a SQL DB but no data appears to be copying.I have attached an example of a record from the log. I have pasted “etc etc.” into it to shorten it as it is very long otherwise.I also get this error-Microsoft SQL Server Spatial Writer: Could not commit row locally. Provider error 'Description: Unspecified error'. Try turning off 'Bulk Insert'Hopefully this helps you troubleshoot my issueThankyou in advance

1165

9 months ago

sylvainlContributor

asked in Transformers

Alignement LandXML, Put a Attribut of Station/Offset on XYZ Point.

Hello, I have many points in txt file in PtNum,Y,X,Z,Description etc.And i have Alignements Geometry in a (Civil3D DWG OR LandXML) I want to put Stationning / Offset value on each point.Thx alot!!Running FME 2023.1.1

1126

9 months ago

takanakaContributor

asked in Data

Efficiency of CityGML

Hi, I have some questions about how to make a CityGML more efficient. Context: I have about 1.8m pipelines and cables. I want to visualise these as 3D cylinder/pipes (not actual ‘FMEPipeGeometry’), regardless of the ‘is it necesary to do this’. All features also have attributes like diameter and such. I want to write this to CityDB and CityGML. This results in huge filesize (somwhere like 15gb or 20gb). What I did: My thought process was it would be more efficient to use relative geoetries (a circle) that I extrude/scale/offset/etc to the proper location using the transformation matrix. Of course I cut the original geometry into pairs of 2 vertices. I wanted to reaggregate this to 1 feature once I had the relative geometry up and working. This all worked just fine until I discovered that in CityGML schema the cardinality is 0-1 on features with relative geometry. This means I cannot gather all separate bits of the cables again, giving me an even more absurd amount of features. I also

1398

9 months ago

jd.fernandezParticipant

asked in Integration

Civil3d Multipatch - fixing attributes

Good day,Is there anyone here tried converting Civil3d Pipes and Structure into ESRI Geodatabase Multipatch in ArcGIS Pro?My issue is the original attribute from Civil3d doesn’t copy in the converted Multipatch - when I convert using ‘CAD To Geodatabase’Can FME translate Civil3d Pipe/Structure Property to change the incorrect Multipatch attributes?Please see image below:

120

9 months ago

geographixContributor

asked in Transformers

DateTimeConverter version 4 produces INVALID_INPUT

I have a datetime in the format YYYYmmddHHMMSS.SSS and want to convert it to any other format e.g. YYYYmmdd or DD-MM-YY or whatever. My super simple workspace is below. My FME version is Windows 2022.1.3.0 The DateTimeConverter version is 4 The result I get with every combination is INVALID_INPUT The Preview suggests everything is OK and what I expect: Any suggestions?

24812

9 months ago

fme_can_do_itSupporter

asked in Integration

FME and API

Hi, I am trying to make API requests to connect to an application. It requires OAuth1 authentication. It seems like FME does not have built-in support for OAuth1. Is there a way to set the HTTP caller in this case? I would be extremely grateful if you could provide me with your assistance!

573

9 months ago

jimmybowden29Contributor

asked in Data

Esri Utility network reader subtype layer

The Esri ArcGIS Portal Feature Service Reader has most of the capabilities needed to read from a Utility Network including being able to set branch versioning. However there doesn't seem to be a way to resolve domains that are defined at the subtype. The Utility Network uses the subtype layer concept where domains can be applied differently on each field by subtype. Is accessing the subtype domains something the FME can/will support?

19518

9 months ago

fme_can_do_itSupporter

asked in Authoring

ArcSDE geodatabase writer

When using the Transaction Type: Versioned Edit session in an ArcSDE geodatabase writer, all edits will be rolled back in the event of a translation failure. The geodatabase writer is set to Insert records in my workspace and I noticed numerous duplicate records after the translation failed due to conflicts identified during reconciliation. Do we need to modify anything in the writer? Thank you!

564

9 months ago

mariannyParticipant

asked in Authoring

Entering the same Attribute Value for multiple Input Attribute within AttributeManager

I’m a newbie using FME although I have also experience with SQL and GIS. I recently started working on a transformer using the AttributeManager. This contains ~ 40 attributes and the goal is to convert part of those attributes based on different conditions, and others attributes based on a same expression: @double(@CurrentAttribute())I was wondering if there was a method to apply the same attribute expression on several input attributes at once while keeping everything in one transformer.Thank you in advance!

981

9 months ago

kmc5678Contributor

asked in General

How do I attach and send the log file of a workspace using Emailer in Form?

I have workspace that's using Creator, Workspace Runner and Emailer to run a parent workspace. I would like to attach the log file to both the Successful and Failure emails?

424

9 months ago

pallapotu75Contributor

asked in Integration

PostgreSQL

how to remove these unwanted connections from PostgreSQL Reader (highlighted)

322

9 months ago

michaelapParticipant

asked in Data

Maintaining Trace Network when Editing Location of Features (SDE) from FME

I am trying to edit features (location) that are within a trace network from FME.When editing in ArcGIS Pro I’m able to move features and have the network adjust (example: Move a point connected to a line and the line moves with the point) but I am unable to replicate this behaviour when running from FME. It simply moves the point feature away from the line. Notably I did have this working in a geometric network but since completing a recent upgrade and moving to the trace network in ArcGIS Pro it’s not showing the same behaviour.Is it even possible to maintain the network structure using a trace network out of FME?

471

9 months ago

saravanakumarSupporter

asked in Integration

How to call quick translator using batch file?

Hi all, I want to run a workbench in quick translator mode instead of running whole workbench using .bat file

351

9 months ago

2eightContributor

asked in Integration

profile point creation

i want to generate profile point along the road both edges and paint lines inside the road edges , as shown in the picture , please suggest how to accomplish this , through out the road network.

615

9 months ago

dwillowContributor

asked in Integration

Specify schema name in PostgreSQL database writer (Arcsde)

I am attempting to transfer data from a file geodatabase into an enterprise geodatabase (PostgreSQL). By default, the writer copies it into either the "public" schema or the "sde" schema. However, I aim to copy the data into a schema of my choice (which is “test” in this example). Although I've attempted to add the schema name before my table name using a dot, as suggested in an older post on this forum, I am still encountering errors. Please see the attached image for reference. FME Workflow

611

9 months ago

rebeccagiannuzzContributor

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

624

9 months ago

vimva679Supporter

asked in Transformers

IFC 3D Room Clip and Buffer

I have IFC file with 3D Room and Excel Records with XYZ and i am trying to clip the XYZ coordinates that totally fall or touch the boundaries of 3D Room. I would like to confirm is that, i am following the right steps in Workbench ? I would like to ADD 10 cm buffer to 3D rooms, so that i don’t miss any XYZ records, so not sure what is equivalent value as there is UNIT in buffer :( Also i would like the EDGES to be SHARP after applying buffer not sure how to do PS: Attached is FME Workbench for further reference, as its does work if anyone would like to refer as well. But open for any enhancement as well.

341

9 months ago

wisegisContributor

asked in Integration

FME TEMP Configuration in FME Workbench 2024 on Ubuntu

I recently upgraded my FME Workbench install on Ubuntu 22.04. Everything had been running correctly before this. I had set up the .profile in Linux to point at a much larger hard drive (7 TB) rather than the small 50Gb drive they have configured as the HOME/default. When I am running processes on large data sets (hundreds of millions of records) the temp fills up with gigs of data so I needed that pointed to that larger drive. After installing FME 2024 it is acting like it doesn’t see the FME_TEMP setting and longer. I even went in the .profile this morning to check that it was still there. Have there been any changes made to the software related to this setting? If not, how do I get workbench to start playing nice again? Any information or guidance would be appreciated.

872

9 months ago

rrichterContributor

asked in Authoring

Right string function in attribute manager

I have a column of data with a 10-digit alphanumeric value. I need to keep those values and in a new column return just the last 5 characters of that columnI thought it would be as simple as creating a new column in the attribute manager and then in the attribute column I put in the string function @Right(NODE_NUM, 5)I have tried at least 4 or 5 different formatting methods, using quotes “ “ or extra parentheses while writing out the string function, but I am lost. I use this exact same string function in MapInfo all the time and it works like a charm. But when I put in these values in just inserts “e_num” into each row as e_num are the last from characters of NODE_NUM.What am I doing wrong?results inThanks in advance

1504

9 months ago

1
...
68
69
70
71
72
73
74
...
1108

Page 71 / 1108

Badge winners

wongyongbinhas earned the badge Teacher (Grey)
olysterhas earned the badge Student (Grey)
olysterhas earned the badge Teacher (Grey)
marygoldsteinhas earned the badge English Speaker
parmsinghhas earned the badge English Speaker

Show all badges

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