- - Community Resources
Ideas
Product Updates
Events
Blog

Home
Forums
FME Form

FME Form

A space to discuss FME Form

27679 Posts

Most replies

Most views

Newest first

spalkarContributor

asked in Transformers

Provide range to 'distance' parameter in NeighborFinder

Hi All,I am new to the FME Software and have a small question related to NeighborFinder.We have points and contour tables in Arcsde Geodatabase. We are finding points near contour by providing specific distance say 20 in neighborfinder In actual case distance is varies like in some cases nearest contour is at 30 , some contours at 40 etc. How do I tell to neighborfinder that select a point which is near by contour having distance in between 10 to 40 ?. In SQL if we use between operator then we are getting values so similar I want to use this for neighborfinder Below is the screenshot : What I tried so far : Creating Custom parameter On Web found below useful posthttps://www.baooytra.com/knowledge/questions/52143/using-neighbor-finder-with-condition-neighbors-att.html?smartspace=automations-fme-serverAny inputs/suggestion on above would be great !!thanks in advance !!

581

6 months ago

takanakaContributor

asked in Transformers

FeatureMerger turns nulls/missing into asian characters

Hi,Unfortunately i cannot provide the test data due to confidential data. I also cannot encode/dummify the data because then the issue no longer occurs. It is likely related to the large amount of data being processed. What I can include is the image you see here. My question is: how can the following happen? Is this a bug? I merge two flows, both have a lot of attributes. Requestor is 1.9m features. Supplier is 6k features. Supplier has only in ~1% of cases a value for attributes ‘X’ and ‘Y’ - the other 99% is <missing>. But supplier also has a lot of other data and attributes.After merging, for attributes x and y a lot more values are found. They are chinese or japanese characters. They are supposed to be numbers or english words.. Also I think they are getting also values from other attributes entirely, but then the actual value instead of random chinese or japanese characters. How is this happening? I am sure that: the attribute I test is the same (I duplicated the statistic

1296

6 months ago

jackydContributor

asked in Transformers

Customer transformer converting string to integer

I am using customer transformers in a work space, but they are converting a string value to integerThe values are 002 and 003, they need to stay this way for the http calls inside the custom transformer but are getting converted to 2 and 3 (without the 00)As read from dbAfter entry into the custom transformerAny thought on how to prevent this?I would like to have to avoid having do something in each custom transformer to revert the values back to the strings

422

6 months ago

ienesaglam60Contributor

asked in Data

Cut the fme polygon from fme aggregate

How ı Cut the fme polygon from fme aggregate?You can find the photo attachedturquoise color object is fme aggregate .purple colored object is fme polygon .I want to cut below the yellow line.

452

6 months ago

bayramContributor

asked in Transformers

shp to Citygml

Hello,I'm having trouble converting shp file to City Gml, can you please help?

1101

6 months ago

lorenrouthContributor

asked in Authoring

Should this be a Batch Process or...?

I have a large Workspace that processes multiple .dwg files along with a single Excel and .dbf file to generate one Excel file with multiple sheets. This works fine when I have feature caching on, but obviously takes a long time. When I try to run it without feature caching, the feature output is a fraction of what it should be, but still gets data from all the multiple dwg files selected, as opposed to grabbing from one file. The only thing that comes to mind is that without feature caching, it does not wait until all features are processed. So, what am I missing? Is there a ‘WaitUntilAllFeaturesAreProcessed’ transformer or setting? Or, should my approach be some flavor of batch processing? I haven’t seen anything in this forum that matches my situation. Any insight is appreciated. Thanks,-Loren

1084

6 months ago

nathan.levelingContributor

asked in Transformers

Removing Null Columns by geometry with dynamic output

Hello, I have an input dataset, that has numerous fields which are Null, and only a handful of fields that are useful. I want to completely remove the attribute fields that are Null, only leaving the useful data. Input is a geo-package, and output is a file geodatabase. I have actually achieved the goal to 90% but have hit a snag, which this post is about. The geopackage has numerous layer I am doing this for, but for this post I will focus on the OBSTRN layer. My current work flow is:Reader (OBSTRN) > NullAttributeMapper (Sets Nulls to Missing) > SchemaScanner (Removes Empty Attributes) > Dynamic Writer The dynamic writer settings: Feature Class/Table Name: fme_feature_typeGeometry: From Schema DefinitionSchema Source: “Schema from Schema Feature”Schema Def Name: fme_feature_type_nameAs mentioned , this output gets me to what I want about 90-95%. The problem is. Within the OBSTRN object class, there exists Points, Lines, and Polygons. I have noticed in other objects that have

785

6 months ago

bkggContributor

asked in Authoring

Utilizing Deployment Parameters in Form workspace

Hey ya'll, I've been playing around with deployment parameters in Flow and Form but I have been wondering if it's possible to use an existing deployment parameter in Form, without a database connection that has the same credentials? So for example accesing database X through deployment parameters without having database X defined in your local database connections. I've tried to but to no avail.

504

6 months ago

goldsteinContributor

asked in Data

Add Timestamp to text file, written using FeatureWriter

Hi,I am trying to add a timestamp to a file, which is being written using feature writer. The workbench is on a shared data directory with a Flow Environment.I have seen other options of using fanout option but seems like they are limited to writers only.I just need a simple timestamp on my text-file when its written so that I can keep records of what is being written.I also have made a timestamp attribute using DateTimeStamper and DateTimeConvertor but don't know how to add that to the file name.Any pointers will be appreciated.Thank you

harishContributor

I have Here Maps Data in XML format. I want to extract the data to CSV in FME. If I am directly adding XML there are issues in reading the file. Currently I am using an XML Flattener tool built using python. Is there any option in FME to do this?

353

6 months ago

ncc

asked in Transformers

Dynamically filter unique values? Attribute-based probability sampling?

Hi all, I am relatively new to FME, it would be greatly appreciated if someone can shed some light on a couple of problems I can't seem to figure out. 1. Is there a transformer similar to the attribute filter transformer but would enable me to route unique value to the output port dynamically? I understand that I can using the import value function to bring in the unique attributes values, but sometimes I would only like to only filter a portion (which could be about 50 unique values) of the total number of unique values. Inputting the required attribute value manually is laborious and prone to mistakes. What I would like to achieve is a 2 step dynamic filter of features, each feature has a Local Government Area (LGA), and a Suburb (suburb is a subset of LGA) attribute. Depending of the first LGA filter (ideally a check box list), the second transformer would route filtered features with unique suburb attributes to an output port. Is this possible? 2. I am currently trying

2113

6 months ago

robinso1Contributor

asked in Data

Creating header lines

I’m attempting to automatically add three lines to the start of a processed data set, in order to create a batch file.There is probably a very simple solution but any help would be appreciatedThanks

642

6 months ago

jennychuContributor

asked in Data

gml_id and geometry issues in extending citygml 3

Hello everyone,I am a beginner with CityGML and am currently trying to convert a dataset to CityGML 3 with generics extensions using FME Workbench. However, I am encountering a couple of issues:Warning about inheritance relationship: The output gives a warning indicating no inheritance relationship. I have used AttributeMerge to add gml_parent_id, but the system does not seem to recognize it.<GML_2 Writer> - '12482' orphaned features found, XML comments representing these features will be present in the output file: Geometry export issue: It does not export correctly after setting up the geometry. In the Inspector, the data appears as a table without geometry.Additionally, the original dataset complies with the CityGML 3 standard, and its geometry's encoding is Name (encoded: UTF-16LE). Could this encoding be affecting the process?My settings and the transformer export are shown in the attached image.I would g

200

6 months ago

jennychuContributor

asked in Transformers

gml_id and geometry issues in extending citygml 3

230

6 months ago

woltersContributor

asked in Transformers

Minimum value per pixel in a multiband raster

Is it possible to get the minimum pixel value, per pixel, in a multiband raster? Rasterstatisticscalculator seem to only do single bands. But what I want is to find the minimum value of a pixel in a raster of 20+ bands. Thank you

744

6 months ago

proteveContributor

asked in Data

Is it posible to create esri file geodatabe with DATASETS with Esri Geodatabase (File Geodb Open API)

Title!i’m trying to import shp files into a gdb database in separate dataset based on the folders that the shape files are located. i know i’ve read somewhere in the help to set dataset/feature name for feature name but its not workig.i get an error that its not possible without coordinate system. so i’ve added coordinate system to writer but i still get the same error.the error isFileGDB Writer: Cannot currently create feature datasets with unknown coordinate systems. Please specify a known coordinate system, or do not write to a feature dataset. Failed to create feature class 'B10/Shape_Z'so is it possible to write datasets in esri geodatabae with Esri Geodatabase (File Geodb Open API) writer? if so can you post an example.

491

6 months ago

wlsuhrContributor

asked in Integration

Esri ArcGIS Portal Feature Service Not Preserving GlobalIDs on Insert

I'm trying to write new (Insert) features to a Utility Network feature service using the Portal writer and it doesn't appear to be preserving global ids despite my parameter setting to do so. The issue appears to exist on all layers in the service. I've tried connecting to Portal via 'Web Connection' and with 'Generate Token' parameters and see the same result. I am connecting to a branch version and not DEFAULT. I can confirm that Globals are not coming over as expected on the version.I've got some Fiddler screengrabs as well if that's helpful.Thanks all.

634

6 months ago

leroyContributor

asked in Transformers

Define parameters in database which use as JSON query in JSONExtractor

Hi folks,In my situation, I am using JSONExtractor but the JSON queries differ between the testing and production environments. Rather than creating and maintaining two separate FME scripts, I prefer to define the target attributes and JSON queries in a database. This way, the correct configuration is used based on the environment's database.However, the challenge is that multiple rows of configuration records are retrieved (with target attributes and JSON queries as table columns). Is there an example that shows how to convert these database records and assign them to the JSONExtractor in a generic way?Thank you very much!

611

6 months ago

mariasContributor

asked in Authoring

How to run SQL executor after translation has failed?

Hello,Hope for your advice how to implement my idea.I have an FME workbench that is triggered by web application. In case workbench failed, I need to update a record in PostgreSQL database. I wander how I can implement this, because if process already failed, how I can run SQLexecutor transformer after that?I thought about Automation, but what would be the trigger in this case? I don’t see anything suitable in the list. Taking into account that I don’t need to run workbench by trigger, since it is triggered by user in web application.The main need is to let application know that FME workbench has failed. There might be some obvious solution for this which I don’t know :)

9014

6 months ago

scarterContributor

asked in Authoring

Copy entire folder from location A to location B in FME Form

Hello Forum, What is the best method for moving an entire folder (which includes subfolders, each containing files) from location A to location B? I’ve looked into File Copy, but that doesn’t seem to do the job. Well, I couldn’t see how it can told to do so. In addition there didn't appear to be a writing option (to set the destination location) within it. I’ve also look into the ‘Select Multiple Folders/Files option in FeatureReader. I can see that I can select an entire folder but it’s asking for a Format. Typically when using a FeatureReader, say for reading in a shapefile, I’d choose ESRI Shapefile. But this is different. Here I’m picking an entire folder with contents. So, what ‘format’ would I choose, if indeed this is the right approach? I’m keen to get this sorted as I need to place a schedule on to it through FME Flow. Thanks,Stuart

1738

6 months ago

vimva679Supporter

asked in Transformers

HOW to assign RED Colour to CELL in Excel File ?

How to assign RED colour to this cell in final output of EXCEL file. Because TESTFILTER have filtered this Column, whatever Rows are there, irrespective value inside the cell i would like to assign RED colour to the CELL marked with a Blue circle inside final excel file, this is default OUTPUT This is how I WANT

gjaguilarContributor

Hello,I am trying to write several files in NetCDF format with FeatureWritter; but after writing the first one it gives me this error: NetCDF writer: Failed to define variable. The error was 'NetCDF: String match to name in use' If anyone has experienced this and can help me First of all, Thanks

722

6 months ago

mhabContributor

asked in Authoring

FME 2024 Bufferer attributes confusion

When I open an “old” FME workspace in FME 2024 I get the following confusing dialog:attributes unsupportedIt is related to a Bufferer and what I want to do is use fme_geometry in a subsequent Tester to find out if the feature has become a donut.So I wondered if “fme_geometry” is deprecated, but it doesn’t seem so.What is this all about ? What are disabled attributes ? If I leave them enabled: why can I do so ? Who disables the attribute ?I use FME for 20 years now and I am completely confused.

443

6 months ago

bark0sContributor

asked in Transformers

GDB Reader browsing slowness

We’re currently experience FME 2 minute+ freezes when we add an Esri GDB reader to a workbench, then press the ellipses to browse to the location. This only happens in the dialog if we have selected Esri Geodatabase (File Geodb) as the Format. We have found a work around of pasting the GDB path into the dialog box but we still experience a 30+ second pause when we hit Parameters/Tables. This takes a substantial time to load. The issue is decreased when a gdb reader is added to a brand new workbench.

537

6 months ago

timotheebeckerContributor

asked in Transformers

geodatabase polygon geometry issue related to PointOnAreaOverlayer

Hey there,I’ve been struggling with a geometry problem. Here’s the thing :)I’m merging two datasets of building polygons. Both come from SDE geodatabases and both appear fine in Esri ArcMap and ArcGIS Pro.When I put theses geometries through a PointOnAreaOverlayer, some polygons, when written to a file geodatabase have weird behaviours in ArcMap and Pro.Their contour draws OK but they don’t fill ! 🤣 The way I solved the problem was by using a GeometryExtractor before the PointOnAreaOverlayer and GeometryReplacer after it. To me this is weird, eventhough I know there are problematic geometries in there. Besides, I tried to solve the problem with a GeometryValidator but that create many more errors. 🙄 If you have any insights about this, I’ll be happy.

231

6 months ago

1
...
45
46
47
48
49
50
51
...
1108

Page 48 / 1108

Badge winners

zehranihfhas earned the badge Expert (Grey)
zehranihfhas earned the badge Teacher (Grey)
zehranihfhas earned the badge Student (Grey)
ravinahas earned the badge Expert (Grey)
ravinahas earned the badge Teacher (Grey)

Show all badges

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