Skip to main content
  • EN

FME Form

A space to discuss FME Form

10000 Posts
A
alanrcrawford
asked in Transformers
I am new to FME and am having trouble with a CADRG exporter. I need to limit the number of colors to 216 on the export however FME exports at 217 rendering the image all black on avionics software.

I am new to FME and am having trouble with a CADRG exporter. I need to limit the number of colors to 216 on the export however FME exports at 217 rendering the image all black on avionics software.

100
daveatsafe
Safer
giuseppecfgeo
Participant
giuseppecfgeoParticipant
asked in Transformers
How I use "point cloud combiner" and keep the colour in output?

Hello community!I have 4 point clouds that I would like to aggregate. By aggregating the clouds with the "point cloud combiner" I lose the color information, why?

360
hkingsbury
Celebrity
aegman
Contributor
aegmanContributor
asked in Data
Unable to use ListSearcher on NetCDF Readers netcdf_coordinate_variable list

I'm encountering an issue reading NetCDF files I got from here:https://dap.ceda.ac.uk/badc/cmip6/data/CMIP6/CMIP/AS-RCEC/TaiESM1/historical/r1i1p1f1/day/pr/gn/latest/ When attempting to use a ListSearcher to search the "netcdf_coordinate_variable" list for an element with axis = T, I get no matches, even though its the first element.I also get no results using a ListExploder and a Tester to test the axis attribute.In fact the only attribute from the list that will match is "name". Looking at the list there are 2 elements, and the second element only has a "name" attribute and no others.I could see why this might trip up the ListSearcher, but I don't understand why the ListExploder + Tester method also fails to match? This is with FME 2022.1.2 on MacOS. I've attached a workspace (data linked above) and a screen shot showing the list has an element with an axis value of "T".

112
aegman
Contributor
fme_hans
Contributor
fme_hansContributor
asked in General
Run is diabled

Hi, I have a workspace where run is disabled when "Prompt for user parameters" is on. When i disable this option run is active. This is the only workspace where this happens. Any ideas?  

1275
albinepro
Supporter
smfks911
smfks911
asked in Transformers
Workspace runner or Looping?

Hi altruist, I have a very large datasets of daily records of soil moisture data which a FME workspace is getting failed to process. So, I have broken down by Financial Year by using testFilter and intend to produce average SM value by FY (as you can see in the image). Now I have to use a series of other transformers on each of the FY output that need to be repeated for each FY output port. Can anyone suggest which process would do it faster so that I can do like a batch process for each FY without manually changing the trigger etc? Looking for kind response.

740
tomfriedl
Contributor
spiderman
Contributor
spidermanContributor
asked in General
How to test to find the values that contain two parentheses and extract string inside it

Hello , i have attribute contains may values as streetname (park: mo (beside))street name (park: far away )How could I use test filter at first to find which value contains parentheses inside it ,I mean as (beside) which value has no parentheses inside it then the values that include parentheses after string as ( park: mo (beside))i would like to extract only the word beside at new attribute .all values include parentheses ( at the beginning but I am interested in the second parentheses ,how could I get the all values that contain two parentheses then extract the string inside the parentheses as beside word .thanks for help FME 2021

305
danilo_fme
Evangelist
A
andre00000
asked in Transformers
Problem with ListExploder with Version FME Desktop 2022.2

Hi,I've got a problem with the ListExploder. I am trying to divide a well-formed XML based on a XML-tag. This itself works fine, but the problem is, that all Object, wich get rejected lose there geometry information. I can see it in the DataInspector, the Min and Max Extent shows "nan". Leaving out the ListExploder, the geometry is visualized, so it seems clear, that the objects loose their information at the <Rejected>-Output-Port of the ListExploder.This problem appears since we installed FME Desktop 2022.2. I tried the same workflow with an older version (2020.1.3.0) and there it works as expected. I put on a screenshot to clarify the situation in FME 2022.Does anyone know about this problem? Any solution would be helpful. Thanks in advance and greetings,André

630
danilo_fme
Evangelist
spiderman
Contributor
spidermanContributor
asked in General
Reges expression problem

Hello , I am not sure how to use Regex expression First example :street name 34 (56)street name 56 ( 44 )street name 55(70) or street name 55( 70 )I would like to extract the number between parentheses and add - before the number so it should be street name 34 - 56 second example : street name 56 (text)street name 40 ( text )street name 10(text)street name 40( text )i would like to extract the text between parentheses and create it in new column  third example :street name 20 ( GdR 20 ) street name 22 (23-50)I would like to extract it and add - before the value in parentheses So it should be street name 20 - GdR 20thanks in advance FME 2021

173
danilo_fme
Evangelist
A
alanl
asked in Transformers
What is the default behavior of AreaOnAreaOverlayer for a single feature class, when using the Use Attributes From One Feature accumulation mode?

Hello, I have a feature class from an geodatabase that contains larger and smaller features that overlap one another. I sort these features to have the larger features come before the smaller features. The attributes of the feature class are: Id and date The goal is to union the smaller and larger overlapping features, but only keep the attributes of the larger overlapping features. Since there is one feature class the overlapping areas share the same attribute names.  Therefore, I use the AreaOnAreaOverlayer transformer, with accumulation mode set to Use Attributes From One Feature.  However, I am unsure of the behavior of Use Attributes From One Feature accumulation mode. Which attributes are copied over to the resultant feature when the overlapping features are unioned? The document mentions the following for the Use Attributes From One Feature accumulation mode: "Takes all attributes from one representative feature" How does the AreaOnAreaOverlayer determine which of the

202
A
laila72
Contributor
laila72Contributor
asked in Data
Local low points

Hi,I want to find local low point in the point cloud. It is to bring out possible locations for water accumulation. Does anyone know a solution to this problem?

12121
dmitribagh
Safer
peteralstorp
Contributor
peteralstorpContributor
asked in Transformers
Problems with the FMEServerJobSubmitter Version 4

 Workflow description·        FMEServerJobSubmitter Version 3 in Desktop starts a sub-script with for instance published parameter /GeoBIM/Konfiguration styrfil·        If I run the script FME Server runs the script with parameter /GeoBIM/Konfiguration, styrfil So as you can see there has been input a comma sign which is not correct·        And furthermore - if I try to change the FMEServerJobSubmitter Version 3 published parameter the transformer automatically (without me telling it to update) updates itself to FMEServerJobSubmitter Version 4 leading to:·        When I then try to run the script with FMEServerJobSubmitter Version 4 it ends up in Rejected with error ERROR_INVALID_INPUT_PARAMETERS and Reason - invalid input parameters for workspace X'Hence I will now create a library with FMEServerJobSubmitter Version 3 preset transformers in version 2021.2.4 (where editing parameters works fine) so that I can copy these into our scripts in 2022.2 to make this work I'm surprised

1710
danminneyatsaf
Safer
sebastianolaf
sebastianolaf
asked in Data
How to map FMEDataReader GEOMETRY column to another GEOMETRY column name in FMEDataWriter using FMEObjectsDotnet4.dll

Hi FME team I started on using FMEObjectsDotNet4.dll and started reading CHM helpand I started to write some simple code, and I'm stuck on mapping FMEReader GEOMETRY column to another GEOMETRY column in FMEWriter FMEReader is from shapefile but the target database oracle table has 2 columns and I want to directly update to 2nd column, and seems cannot find the right "keyword" in CHM help, also the samples is not really helping with this problem C:\\Program Files\\FME\\fmeobjects\\dotnet\\apidoc\\FMEObjectsDotNet4.chmC:\\Program Files\\FME\\FMEObjectsDotNet4.dll Also in IFMEOWriter seems lacking IsOpen method to check whether the connection still open or notso we can do something about it. Maybe like manually commit ..    on another topic:1) is there a NUGET feed from you for this library like Telerik nuget feed https://docs.telerik.com/devtools/maui/get-started/install-nuget https://nuget.telerik.com/v3/index.json2) is there a link/resource/forum/video/training/repository

81
daveatsafe
Safer
steveflo
Contributor
stevefloContributor
asked in Transformers
Importing a GDB relationship from an existing GDB

I'm not sure what I'm doing wrong, but I'm trying to move data from a editing GDB environment to a production GDB. Everything else works fine, except when it comes to importing the relationship class for my attachments. I get the error:  "Unable to create table/feature class/relationship class of type 'geodb_invalid'. Creation of this type is not currently supported by FME, and must be done through Esri tools" Does this mean I can't import the relationship in FME and should be doing it in ArcGIS Pro? Thank you.

690
danminneyatsaf
Safer
tcrossman
Contributor
tcrossmanContributor
asked in General
When reading a geodatabase relationship class, is there any way to determine what are the origin and destination feature classes?

In a file geodatabase (GDB) to GDB translation, I am writing dynamically to a blank (unpopulated) template GBD that has relationship classes. From a source GDB I am reading features both from feature classes that participate in relationships and from the relationship feature classes themselves. I get the usual geodb_feature_has_relationships and geodb_oid format attributes on the participant features, and I get the usual geodb_type (= geodb_relationship in this case), geodb_rel_origin_oid, and geodb_rel_destination_oid format attributes on the relationship features; however, to keep the workspace generically dynamic and reusable, I need to determine--during translation--the names of the origin and destination feature classes for the relationship classes being read. Of course, I know what those feature classes are before runtime, but the dynamic, i.e., non-prescient, workspace does not. Is runtime determination of the origin and destination feature class names of an existing relatio

872
tcrossman
Contributor
mtm102582
Contributor
mtm102582Contributor
asked in Transformers
I'm working with a geometry in wkt. I would like to convert to lat, long and elev using FME. I can do conversion using SQL using "select ST_AsText(geom)". I've tried the geometry extractor translator and it just gives errors. There is an example be

Line:01020000A0E610000005000000E040A17B843554C0C987F51E7593414000000000000000006CDB4900853554C0AFD3A0F17893414000000000000000002D2683FB813554C0D677B1BD8E93414000000000000000005A484B8E7F3554C025457646AB9341400000000000000000C4B449797B3554C01A0A32C8AC9341400000000000000000 Using SQL the wkt converts to these 5 points:  -80.83621111628918 35.15201174725332 0,-80.83624274456605 35.15212841370464 0,-80.83605850036174 35.1527936092895 0,-80.83591039039439 35.15366440558345 0,-80.83566124151099 35.15371038859685 0 Lat and long are also reversed in the output. I would like to do this conversion in FME for spatial analysis of the full data base. Thank you,Matt 

4315
mtm102582
Contributor
aska
Contributor
askaContributor
asked in Transformers
how to use current calculated feature in the next step.

I have this equation in Excel:=A2-($A$2-$G$2)*B4/SUM($B$4:$F$4)this A2 and B4 has to change every row. so that the value I just got from the current row calculation needs to be used in the next step.9.83,8.82,7.56,6.41,5.41,5minus0,1.01,1.26,1.14,0.99,0.4it starts with 9.83-0, then 9.83-1.01, then the result which is 8.81-1.26 and so on.how can I write this equation? or how can I get the result of previous row calculation in the current row?

97
nielsgerrits
VIP
vince_j
Contributor
vince_jContributor
asked in Transformers
'Validate output file'-setting in GML writer doesn't appear to be validating (FME Desktop 2021.1)

Hi community, A client I am working for recently upgraded their FME Desktop/Server installation from version 2018.1 (20180717 - Build 18520) to 2021.1 (20210730 - Build 21619). I upgraded the workspaces and I am currently in the process of testing. I noticed that a workspace ("gdb2gml.fmw", attached to this thread) behaves differently in FME Desktop 2021.1. The purpose of this workspace is to read a File Geodatabase, map the attributes to a specific format and write to a GML. The output file (GML) is validated against an XSD file (XSD-file and input GDB also attached to this thread).  The validation in the GML writer should fail. The File Geodatabase contains an illegal feature (a multipart polygon) which is not allowed as a geometry for this feature class. In the GML writer, the setting 'validate output file' is set to Yes. In FME Desktop 2018, this multipart feature is detected by the validation and the workspace fails. This is the expected behaviour. In FME Deskt

271
martinkoch
Supporter
rmpayaby
Contributor
rmpayabyContributor
asked in General
Removing all spaces in an attribute

Hi, I am working on two excel-files that I wanted to merge with address. Unfortunately I am struggling to merge with the address since they are formatted differently for each excel file. For example: Alex Olssons Road 50 - Alex Olssons road 50 There are more strange cases where there are lower and upper case letters between each spaces. I wanted change the attribute for addresses in both files so that all the letters are in uppercase and all spaces are removed to make it easier to merge. For example: ALEXOLSSONSROAD50 Any ideas what transformer I should use?      

4881
dustin
Influencer
lifalin2016
Supporter
lifalin2016Supporter
asked in Data
OGCGEOPACKAGE writer ... primary key attribute 'ID' has unsupported type 'mediumint'

I need to revisit this answer, that I find to be a limited work-around, not a proper solution.The offending and unsupported type "mediumint" is not from the MS/SQL database, where data are sourced, so it has to be something that FME itself generates on the fly. Aka a bug.The database table has a field named ID, which is an "int" (32 bit), and it uses an identity value.This is how the schema feature sees the field:I really cannot understand, why FME cannot transfer this to a table in a Geopackage. The very same schema and data feature are used to create a GeoJSON with any problems.Please advise.Using 2022.1

2780
lifalin2016
Supporter
J
jdaswani05
asked in Transformers
With FME upgrade to 2021.2.0.1 my workbenches are failing . I have used aggregator and geometry Validator . Also it gives application error if I try to run it from Command prompt.

With FME upgrade to 2021.2.0.1 my workbenches are failing . I have used aggregator and geometry Validator . Also it gives application error if I try to run it from Command prompt.

240
J
townest
Contributor
townestContributor
asked in Data
AutoCAD Reader > Parameters > General > Layer Name, Allowed Geometries.....greyed out

Greetings,I am finding the settings...AutoCAD Reader > Parameters Tab> General Section > Layer Name field, Allowed Geometries field.....greyed out. How can I access and change these settings? Thank you,Tyler FME 2022.1

260
daveatsafe
Safer
R
rhodesjd
asked in General
Is it possible to retain images within an e57 after thinning?

Currently reading in e57s, filtering the geometries to point cloud and raster. Running some routines on the point cloud to reduce the number of points and would like to combine the original rasters back into the e57 writer. So far, point cloud comes out fine, but no images. Thanks

310
danminneyatsaf
Safer
dilip
Contributor
dilipContributor
asked in Transformers
I am looking to use the Attribute Value Mapper to set a series of numerical ranges, which output specific values, was wondering if this is the correct way to do this, any assistance is appreciated

92
dilip
Contributor
townest
Contributor
townestContributor
asked in Transformers
What is the best way to duplicate a writer?

Greetings,What is the best way to duplicate a writer? Using copy/paste only duplicates the annotation. Thank you. TylerFME 2022.1

623
philippeb
Enthusiast
zentnerfabian
Contributor
zentnerfabianContributor
asked in General
Is there any chance to convert Timestamp Date format into an ISO Date format?

Hey everybody,I have a huge csv file with the attribute field "modify_date" and the date is in "Timestamp" - format (so for example 746841600000).I would like to have it in ISO Date format (1993-09-01 02:00:00).Is there any transformer which can do that? The Date/Time Converter is not able to do that... Thanks in advance.Cheers,Fabian

1734
zentnerfabian
Contributor

Badge Winners

  • Online Training
    owskihas earned the badge Online Training
  • FME Certified Professional
    stuart_misohas earned the badge FME Certified Professional
  • English Speaker
    pwalshhas earned the badge English Speaker
  • Webinar Watcher (Grey)
    pwalshhas earned the badge Webinar Watcher (Grey)
  • Welcome Back
    clewishas earned the badge Welcome Back
Show all badges

Community Stats

31,849
Posts
120,957
Replies
39,476
Members

Latest FME

Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.