- - Community Resources
Ideas
Product Updates
Events
Blog

Home
Search

Unanswered questions

10000 Posts

reservoirdogSupporter

asked in General

Gas network analysis - network trace with stop object

According to the current political situation here in Europe, we want to work out a plan B if gas supply will end, and for that case, how to get our gas network back working. For that task, we would like to analyse our gas network (trace?) in dividing the network in zones/branches. The idea behind that is to use major valves as "stop-object" for the network trace, because you need to get back the gas network in little branches. (vent these parts, before going back on pressure) Our Gas network is topologically correct, and I would use the specific stop-objects (disconnect slides/valves) to divide theses network parts/areas. Is there any way I could use FME transformers to get these resulting network-parts? thx in advance, Christian

320

2 years ago

datablueContributor

asked in Transformers

How to create a string attribute with a specific length?

I'd like to create a string attribute with a specific length. I'm using an Esri AGOL writer to create and write to a feature service. In AGOL, I want the Field length of this string to be 12. In a PythonCaller, I'm using: objText = '00123' feature.setAttribute("TextField_test", 'ABC' + objText) In AGOL, this creates a field of string type with a length of 254. In an AttributeCreator (before the PythonCaller), I created the 'TextField_test' attribute with a value of @string(12). This creates an attribute a value of '@string(12)' which is obviously not what I want (the python overwrites that value). In AGOL, this creates a field of string type with a length of 200. I understand that I could the User Attributes in the AGOL Writer to Manual and change the attribute to Width to 12, but I also have an Excel Writer and would have to set the Cell Width to 12 as well. During development, I'm adding and removing many attribute

Read password protected excel file

Hi Everyone, I'm looking to read a password protected Excel file and copy specific data to another Excel file. Is this possible?

1260

2 years ago

aronContributor

asked in Transformers

Query table names (feature_type) when importing database?

I have a Geopackage with lots of tables and would like to speed things up by only reading the needed tables for later processing. The 'Where' field only applies to table content, I want to filter on table names. I would like to use a wildcard to import layers containing a certain string. ExampleIn a dataset all hydrographic layers might contain the string 'hydro'I would like to use sql to only import these layers by using something similar to 'LIKE %hydro%' edited by including an example Edit 2: I realise I made a huge, and embarrassing, typo. The file I am working with is a geopackage, not a gml... *facepalm*

Pushing points and "dragging" snapped lines along with them

Hello! I have a basic scenario where I need to batch move point features, while also dragging line features snapped those original points. The model is a network of split lines with a "station" at every line endpoint. We can assume every endpoint or intersection has a singular station. The sequence of lines and stations make up the backbone of the model. Maintaining that consistency is critical. Now let's say I've received GPS data which places these points more accurately. A subset of stations now have fields for "Current XY" and "New XY". I need to physically push the points to the new location and this part is simple. Looks like I can use VertexCreator to reset their geometry. But I also need the line endpoints to automatically move with the station. Any thoughts on making this happen? Note that the stations and line endpoints generally have the same XY coordinates, but we assume a tiny spatial buffer is needed to catch everything.

240

2 years ago

malavikavenu96

asked in Transformers

I need to convert csv to shapefile. How can I get the file name of the csv in the the attribute of the shapefile? I tried the fme_feature_type but its not working.

Distribution grid analysis

I am trying to understand differences between FME and smallWorld and what can one do with them. It's the first time I have touch with smallworld and I am especially interested in analysis of the distribution grid. To be more specific, I am interested if and how would be following possible: 1) Distribution grid operator exports part of it's grid to some file2) This file is provided to me3) I can open this file to access distribution grid details What I need for this, is it possible to do it with FME?

2 years ago

billybobContributor

asked in General

Has anyone seen this error before: ArcGIS Portal Feature Service Writer: Encountered an unexpected error. The error code from the server was '403' and the message was: 'Forbidden'. Details: 'Request denied due to lack of license.'?

I'm using FME Desktop version 2022.1. I'm not sure what the "request denied due to lack of license" is referring to. The workbench is writing to a hosted feature service. The writer is configured to truncate the existing data and insert new features. The web service and connection have been verified as well. Thanks,Frank

680

2 years ago

philippebEnthusiast

asked in Integration

Merge a jpg with a png

Hello,I want to merge a jpg with a png over it.How can I replace this Paint.Net function (Merge Layer Down)?https://www.getpaint.net/doc/latest/LayersMenu.htmlThank you.

2 years ago

ingallaContributor

asked in General

Point on Area where point is on dividing line of two polygons

I know that I am missing something obvious, but if I have a point that is on a line dividing two adjacent polygons, how do I select both polygons. At present I am using the point on area overlayer transformer and just getting one picked up?? The image below should make this clearer..Regards...

2 years ago

leentreuren

asked in Transformers

How to use the FME custom transformer PDF2TextReader in combination with the pdftotext application(v. 4.04) from XpdfReader

I like to use the PDF2TextReader_custom transformer to convert pdf files to text files in FME 2022. I downloaded the pdftotext application(v. 4.04) from XpdfReader and followed the installation instructions. Trying to run the transformer it gives the error 'Error opening pdf file'. Using the command-line executor of windows I'm able to convert the pdf to text(including a xpdfrc-configuration file in the same directory as the pdftotext-file, as advised by XpdfReader). My question, what can be wrong when I use the FME-transformer?

1110

2 years ago

deanhowellEnthusiast

asked in Transformers

Fill in missing years in chart

I have some data that I have run through the statistics transformer in the format shown below i.e. ID, Year, Count I want to create a chart but need to include the years that have a zero value in a five year period i.e. 2015 to 2019. How do I manipulate the data to add in the missing years with a zero value? Any assistance would be greatly appreciated.

2 years ago

qlddrones

asked in Transformers

RasterMosaicker not merging two TIF files

I am trying to merge two TIF files using the RasterMosaicker, but for some reason all it writes is the first file, not the merged files. Can't figure out what I'm doing wrong. I have not uploaded the TIF files because they are 380MB each, but anyone wanting to test it can access them at https://drive.google.com/drive/folders/1T_lRY4zRAJDSOYRAaqic4bHLwoe4VGfT?usp=sharing.

180

2 years ago

tb09114Contributor

asked in Data

How to publish a choice parameter from script?

I need to have a choice parameter offering all the database tables of a specific database for the user to choose from before running the workspace.I do have the Python code ready, and created a scripted parameter, returning a list of all table names.I referenced the scripted parameter as input for the choice parameter, but that only gives me a dropdownbox with the name of the parameter linked to it. Is it possible to populate a choice parameter from a Python script (scripted parameter), and if so how?

How many ports does FMEProcessMonitorEngines use at any given time?

I've been digging into issues with an Engine running on a separate host in a distributed setup. Service looks to be running but is no longer chatting with Core and is not longer showing up under Engines in the web UI. After ruling out some of the obvious causes on this troubleshooting page. I've started logging running processes and ports being used on that Host to understand at what point the service goes silent or inactive. That's when I noticed what seems like large number of TCP connections FMEProcessMonitorEngines uses with multiple ports open. The Architecture Diagram and Documentation are really helpful. So I recognize the 7070 for FMEEngines services and the 7082 for Database Server but then there are a bunch of ports that I assume are what FME dynamically picks. If I only have one job executing on that engine at a given time, how many of those ports/connections will be in play? Is having 3-5 or so that I don't recognize an indication that something may not be

134

2 years ago

simidContributor

asked in General

Duplicate ESRI Create Watersheds tool in FME ?

Hi allTrying to generate watersheds based on input points and a DEM. The ESRI Create Watersheds tool does what I need but I haven't been able to figure out how to do it in FME. Any pointers? Inputs: DEM + PointsOutput: Watershed areas per pointESRI tool https://doc.arcgis.com/en/arcgis-online/analyze/create-watersheds.htmThank you

Issues with room tags and door swings not importing into ArcMap using the FME converter for Revit files.

Below as a screenshot of the Revit project (what i am trying to export) followed by what i am able to convert and export into ArcMap. Missing room tags and door swings.

2 years ago

pmcphersonContributor

asked in Data

Has anyone experimented with connecting to "Databricks on AWS" data sources? If so, which reader format or transformer should be used to make the connection and browse the available data?

490

2 years ago

carmijoContributor

asked in Data

Writing Vector Data for Use with OpenCV

What format can I write to using FME so that my vector data can be read/processed with OpenCV?I'm in the early stages of an image segmentation project to identify impervious cover data from aerial imagery but we're having some early issues getting my vector impervious cover data into a format that my computer science counterpart can use in OpenCV. It seems like XML or GeoJSON would work, but I don't have any experience with OpenCV. Any ideas?

2 years ago

tslack

asked in General

Data Downloading with User Parameters allowing users to draw box or clip by existing layer

Hey there, So I recently set up a Data Distribution service on FME Server using this tutorial https://community.safe.com/s/article/data-distribution-fme-server-app . Everything works fine and I can use the area of interest box to draw an area and download all the relevant layers. I am trying to add a second option in the User Parameters to allow the user to either draw a selection or choose a layer to clip by.In user parameters I added a 'Choice' option and added a layer as an option to clip by my thought was I could add a second geometryreplacer, set the encoding to OGC well known text and the source as $(LAYERCLIP) by when I run it and select the City Boundary to clip but FME gives me the error INVALID_PARAMETER_GEOMETRY_SOURCE. Is it because FME doesn't know what GISOWNER.city_boundary is? Its a layer in our enterprise SDE. I tried adding in a featurereader to read the layer before it goes to the replacer and had no luck. Thanks!

290

2 years ago

ryanParticipant

asked in Integration

Non-Blocking FeatureWriter Output For Real-Time integrations?

Using a RabbitMQConnector in Stream mode to continuously listen for change events. It is set to not Auto Acknowledge messages as we do not want that to happen until confirmation it is written to the database. Was thinking to use a FeatureWriter as it chains outputs after writing. Doing this with Transaction Type of None and it inserts/updates the features in real-time fine. But the output from the FeatureWriter seems to always be blocking. We ideally want to use that output to acknowledge the message in RabbitMQ. Would try a SQLExecutor but also need to write the shape to an ESRI geodatabase. Worst case can probably use a PythonCaller using arcpy. But would be nice to have a persistent connection with an actual writer. Any thoughts on how to do something like this while keeping a data steam going?

194

2 years ago

mferwerda1111Participant

asked in General

Multiple Editions (not versions) of FME Desktop, Lic Server

I am wondering about how it works if you want to have mulitpled editons of FME Desktop using the same Lic seerver, so floating lic. So say if we had 10 floating lic, and had 8 ESRI Editions, and 2 professional Editions how does that work on a Lic server, can users pick an edition when they start FME Desktop ?, or do you have to set up user groups for specific edtions, or would you need 2 lic servers, one for each edition ? Just trying to understand how this would work and what the options are for users to be able to choose an edition.

620

2 years ago

sharbel

asked in Architecture

hey guys, I'm installing FME Desktop 2022 on a linux operating system (ubuntu 20.04), but it does not install the sdk! any directions on how to install the sdk on that system? i can't find any sufficient documentation about it

2 years ago

alicia.kennedyParticipant

asked in General

Can you migrate users in FME Server from Directory Server to Azure AD? Or do you have to re-import all your users and assign roles.

My organization is upgrading to FME Server 2021 (from 2018), and we'd also like to update our authentication method from Windows Directory to Azure. I restored the backup configuration from our FME Server 2018, so all our user profiles are coming from the Windows Directory. I have successfully set up a connection to Azure and can import new users (the user says Type = Azure AD), but is there a way to migrate my existing users from Type = Directory Server to Type = Azure AD? Alternatively, I could re-import all my users from Azure AD and re-assign roles, but I was hoping there would be a way to switch the authentication. Thanks

240

2 years ago

fme_hansContributor

asked in Transformers

Expose attributes with a wildcard

Hi,I'm looking to see if I can retrieve all tables with the same prefix and then save the table content with a dynamic writer in shape format. For this I start with a SQLCreator with the query:select TABLE_NAME GV_TABLEfrom colswhere TABLE_NAME like 'AB$_%' escape '$'and TABLE_NAME in( select object_name from user_objects where object_type = 'TABLE') The result is then picked up in a SQLExecutor:select *from @Value(GV_TABLE) Attributes to Expose is left empty in the SQLExecuter. The result of the SQLExecuter looks like empty records but if you look with Visual Preview the attributes per table are present. With a dynamic writer I try to write to a shape file per table. The writer does not write anything. So is it possible to make the attributes visible after the SQLexecuter? Attributeexposer does not have a *.* wildcard.

280

2 years ago

Page 176 / 400

Badge winners

ian_1spatialhas earned the badge 12 Days Participant (2024)
spalroberthas earned the badge Teacher (Grey)
ablkhas earned the badge Welcome Back
joeluhlinhas earned the badge Student (Grey)
sguru7667has earned the badge FME Form Basic Training

Show all badges

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