Skip to main content
  • EN

Transformers

Using transformers to modify data.

  • 10,000 Posts
  • 52,722 Replies
10000 Posts
jackfanzhang
Contributor
jackfanzhangContributor
asked in Transformers
FME showing hidden objects in dwg file

Hello, I have a dwg file as attached, for some reason when import to FME form/workbench, it shows some hidden objects where I couldn't find at all in the DWG file. I also loaded the same file to ArcGIS Pro which didn't show these hidden objects and matches what the dwg looks in AutoCAD. The only way I could fix it is exploding the whole dwg file which will get rid of the mystic hidden objects from the dwg. I'm anyone has seen this before and also if FME developers could enhance the software to simply ignore these hidden objects like how it does in ArcGIS Pro. thank you.

400
jackfanzhang
Contributor
C
cameron-m2
asked in Transformers
ServerJobSubmitter on FME Flow - Invalid input parameters.

I am trying to do a transformation basically summarizing the area of vegetation polygons within parcels of land. This involves a number of filters before the "Clipper" is used to 'cut' the vegetation polygons to the shape of the land parcels. Due to the complexity and number of polygons in each dataset this is run sheet-by-sheet. I have this working on my own PC using the WorkspaceRunner. The vegetation polygon sheets are stored as Feature Classes in an Arc Geodatabase and the WorkspaceRunner uses an Excel with a list of the vegetation polygon sheet numbers allowing them to run through the "Child" workspace one sheet at a time.The problems come when I try to replicate this with the ServerJobSubmitter. I can successfully connect to flow and have set up the workspace parameters similarly to those of the WorkspaceRunner above, however when I try to run this 'Parent' workspace I get the following error message.This error repeats for each of the individu

1470
takashi
Celebrity
J
jjcdejong
asked in Transformers
I am trying to generate measure along a line, including curves, read from DXF and eventually want to write this line, including measure to a GML.

I read the line from a DXF reader, generate measure using the measuregenerator and then write it to a GML. The line including the curve end up perfectly in the GML, but I do not see any measure.Any suggestions?

240
daveatsafe
Safer
joepk
Influencer
joepkInfluencer
asked in Transformers
Unexpected SpatialSorter behaviour

Hello everyone, happy monday to you all, I have a dataset of points on a road network which I am trying to assign to groups of max 300 points. There are two attributes which must be the same for all the points in a certain group.  Also, to make the work of our editing team easier, the groups should be sorted by location. For this I am using the SpatialSorter (Hilbert sort in 2D). I am however getting some unexpected results. In the screenshot below I have selected all points in group 1100, also note the scale below to get a rough idea of this dataset:These points seem grouped correctly but they are not all grouped together. These are the points in group 1101:There is a large gap between these points (about 25km). Group 1102 (and a lot more groups for that matter) show the same gap:I guess there is some spatial relationship between these points, since they seem to be on roughly the same vertical axis, but it's not as accurate as I would have expected. Any explanation for this? This

450
hkingsbury
Celebrity
lacy
Contributor
lacyContributor
asked in Transformers
Georeference rasters listed in a geodatabase field?

Here is my scenario: I need to very roughly georeference thousands of scanned air photos that are tracked in a file geodatabase. Oversimplifying things considerably, my fields look like: Filename (which contains location of the raster tif on disk)Center_X (map coordinate)Center_Y Rotation (always zero for my simple exercise)ground_resolution (in map coordinate units) I want to feed each "filename" to the rastergeoreferencer, using Center_X, Center_Y, rotation, and ground resolution. But I'm conceptually stuck... rastergeoreferencer obviously wants input from a raster reader, not a text string with the path to the raster. See the rub? Can somebody give me a push in the right direction? Thanks!!

150
lacy
Contributor
lorenrouth
Contributor
lorenrouthContributor
asked in Transformers
Error writing to Excel using Feature Writer

I have been getting this error a lot: Excel Writer: Failed to open the dataset 'FILEPATH\\FILENAME.xlsx'. Error message was 'No such file or directory.'XLSXW writer: An error has occurred. Check the logfile above for detailsExcel Writer: Dataset 'FILEPATH\\FILENAME.xlsx' contains no data and is therefore not a valid Excel file. No file will be createdXLSXW writer: An error has occurred. Check the logfile above for details It will happen a few times and then the workspace will run as normal. This occurs in any Workspace I use that has an Excel Writer. In the Task Manager, if there was a process I could end, I would do that. It still happens.  Any Ideas?Thanks,-Loren  

2505
lorenrouth
Contributor
pinkopo
Contributor
pinkopoContributor
asked in Transformers
Expose attribute from feature reader

Hi guys a silly question here, is there a way i can expose the attributes before use dynamic schema to write them out? I'm using feature reader to read a list of sde feature class from csv file but hope i can expose their attributes for further processing before write to the destination.. Thanks!

3880
j.botterill
Influencer
matt_ccc
Contributor
matt_cccContributor
asked in Transformers
FME - CSV writer - why can i only see vchar as a field datatype, when i need char?

Looking to create a csv output as a 'dat' file for import to another system. basically rows of text with the fields essentially defined by the number of characters they occupy in the row, padded as necessary. So, i need the output row length to be fixed for each field, and yet I only have the otpion of vchar.In online documentation I can see reference to a datatype of char, but this is not exposed in the fme writer.Why is it missing? / Why have I missed it?Help appreciated.Using FME Desktop 2022.1.2.0

120
takashi
Celebrity
aron
Supporter
aronSupporter
asked in Transformers
Filter/selective use of VectorOnRasterOverlayer?

I am trying to tint some terrain shadows (raster) with overlaying polygons of different colours (RGB). Thing is that the polygons are larger than the shadings so VectorOnRasterOverlayer colours a larger area than I wish. I only want to tint the "black/greys" in the raster, not the white areas. I have tried to filter out the unwanted areas using a RasterExpressionEvaluator, setting everything beyond break point to white. Unfortunately I have not been able to figure out a syntax that does not also change the hues. Any ideas on how to approach this? Looking at the example below I would like to keep the darker/shaded areas and shift the flat ones to white.  

140
takashi
Celebrity
pg.souque
pg.souque
asked in Transformers
Mongodb and date format

Hi,When i insert with the jsontemplater a date in the mongodb writer the type of date is always string even i choose isodate, fmedate......etc. Can i have a type date in mongodb via the jsontemplater ? Thanks a lot

896
pg.souque
ewb_fme
Contributor
ewb_fmeContributor
asked in Transformers
How define conditional "header" values in HTTPCaller?

When I specify an HTTPCaller with a defined header, then everything works as desired. However, as soon as I want to enter a conditional value (the same values that work alone), I get an error message: This FME edition does not recognize the `' function. Please ensure that the current platform supports this function, the function name is spelled correctly, and that you have installed all required plug-ins. Unfortunately it's the same behavior when I define conditional User Parameters and use them as HTTPCaller headers. Is there a way you can use conditional "header" values in a HTTPCaller or is this a bug? Best regards

460
ewb_fme
Contributor
marta.podsiad
Supporter
marta.podsiadSupporter
asked in Transformers
Selection with Python in gdb Reader

Hi, I am struggling to put a simple Python script in gdb Reader/Scripted Parameter Value that will allow me to read only polyline. Could someone please push me in the right direction?

160
marta.podsiad
Supporter
geouser97
Contributor
geouser97Contributor
asked in Transformers
Detect Topological errors

I have a dataset of curves (lines) automatically generated from the DTM. I have some topological issues that I want to detect automatically ( photo). I used the geometryvalidator transformer, but I can't seem to detect them. How should I proceed? Thank you for your help

150
geomancer
Evangelist
M
mazi
asked in Transformers
FME Form 2023 - Option Save As a .fme file is missing

Hi all, we have just updated from FME Desktop 2021 to FME Form 2023.1.1.2. I want to create a mapping file .fme, but the option .fme is missing in the Save As- dropdown menu. Has this option been removed by Safe Software? Or has this functionality been transferred to another menu? Does a workaround exist? Thanks for your help!

970
M
aklamwis
Contributor
aklamwisContributor
asked in Transformers
How can I edit my cityGML with specific attributes for specific builings

In the atrributes below I want to specifiy the usage of each building, for example building (_gebaeude) 504. Is there a way to do this in FME using the createAtrribute Transformer? There are over 40 buildings each with a specific usage and name

130
aklamwis
Contributor
galigis
Enthusiast
galigisEnthusiast
asked in Transformers
Multiple Selection in the ListConcatenator tranformer

Hi All, I'm working on a workflow to bring the information from 3 separate layers into my analysis output. SpatialRelator would do the work but also want to create the lists in order to concatenate values into the same cell. I need to concatenate different fields but ListConcatenator only allows one at time, Screenshot below shows the fields I want to concatenate with the following structure: ListConcatenation A = GM_SiteRef + GM_TypeListConcatenation B = LandOwner + LandOwnership_Status + LandOwnership_TITLE_NOListConcatenation C = LEP_Site How can I make it to work and have multiple ListConcatenators? I'm trying to avoid any filter or tester as won't work.... PD: I would also need to add a ListDuplicateRemover before the concatenator to avoid duplicates in the same cell. Thanks in advanced 🙂

260
galigis
Enthusiast
epro_admin
Contributor
epro_adminContributor
asked in Transformers
Excel worksheet to Sharepoint > How to hide fields

Hi there, I have a workspace that fills out an excel spreadsheet and then pushes this into Sharepoint. I want to hide the first five columns in the spreadsheet (so I can unhide them when I need to check, but the user doesn't have to see it). How do I do that? I tried hiding them in the spreadsheet in Microsoft 365/Excel Online, but they revert to showing every time the process runs. I tried in the FeatureWriter Paramaters> Edit Column Formatting> Cell Protection> Hidden in the first five columns, but that didn't work.Thanks in advance for any guidance you can provide.

1620
epro_admin
Contributor
B
blythesr
asked in Transformers
GeometryReplacer (from Microsoft SQL Server Binary) for Multi-Polygon Type

A workflow we use at work is as follows: Geometry data is stored in SQL Database (attached screenshot - SQL Geometry.png). It is a multi-part polygon and looks to be correct.I use a SQL Creator in an FME job to get the data from the SQL Database. We call a stored procedure to get this data but no transformations are performed in this GET.I use a Geometry Replacer in the FME job with the following settings:Geometry Encoding: Microsoft SQL Server BinaryMS SQL Server Format: GeometryAfter this Geometry Replacer the shape looks correct in FME Inspector, but the Type looks incorrect (attached screenshot FME Data Inspector.png)The shape looks rightIt is classed at the top level as an IFMEMultiArea type of 1 part which is not right. It seems to have classed it as a shape with 1 part (a donut) with an outer boundary and 2 inner boundaries.I'm pretty sure the data conversion into the SQL format is correct but I can't get access to that right now to double check.Has anybody got any ad

1300
david_r
Celebrity
vimva679
Supporter
vimva679Supporter
asked in Transformers
How to write attributes into PDF report ?

I want to create a PDF report like this , where i have HEADER and the value below   In this yellow boxes 'PDMS' column could go in this attribute values  this is my FME workflow to insert HEADER but , the values / attributes are coming from Excel output , so i need to insert them in this boxes like sum / average , total count etc. 

2990
redgeographics
Celebrity
mr_fme
Enthusiast
mr_fmeEnthusiast
asked in Transformers
Split polygon by lines

I need to split this polygon using as a reference the rows, how can I do this? These polygons are initially rows, which I transform into polygons using AreaBuilder. As a result it generates 2 polygons, however I need to fragment the polygon into more parts according to the rows.

12440
pdorio
Contributor
A
akshayvaidya
asked in Transformers
I have made user parameter with name ward, in workspace I am using tester transformer to filter the input data based on criteria. I want to run this workspace using linux terminal while providing filtering criteria dynamically to tester using termin

I have configured tester transformer with user parameter, such that feeding the user parameter through command line will automatically provide the criteria to tester transformer for filtering. 

70
redgeographics
Celebrity
galigis
Enthusiast
galigisEnthusiast
asked in Transformers
Odd behaviour for AttributeFilter, Tester, TesterFilter with Unfiltered values

Hi All,I'm facing some odd behaviuor with the AttributeFilter, Tester, TesterFilter. The screenshot below shows that my data includes 'g2a' values in the attribute table but I filters that value in any of the transformers cited above the values doesn't show up?  Here is another snapshot of the AttributeFilter (unfiltered) after importing all values From Feature Cache:  Why does it go into the Unfiltered values?  Any idea more than welcome 🙂Thanks

230
galigis
Enthusiast
giuseppecfgeo
Participant
giuseppecfgeoParticipant
asked in Transformers
3D VISIBILITY ANALYSIS

Hey community! How can I do a visibility analysis, from several observation points to several points or lines of sight?I can use 3D vector data, LiDAR data and DEM from LiDAR data. Anyone has a "script type" to explore?😊 TNKS a lot guys!

3030
kailinatsafe
Safer
tschoppenhof
Contributor
tschoppenhofContributor
asked in Transformers
JSONTemplater does not set double quotes for number values

My configuration in the JSONTemplater looks like this:  {  "type": "Feature",  "geometry": {    "type": "Point",    "coordinates": [      fme:get-attribute("X"),      fme:get-attribute("Y")    ]  },  "properties": {  "33064" : fme:get-attribute("33064"),  "33085" : fme:get-attribute("33085"),  "33103" : fme:get-attribute("33103")  }} As result I get: { "type" : "Feature", "geometry" : { "type" : "Point", "coordinates" : [ 7.61438690276304, 47.5603635244644 ] }, "properties" : { "33064" : "", "33085" : 94328460, "33103" : "2. von B Spezmast Nr.55" } } The number is not set in double quotes which results in error when I use the json string. Any ideas what could be the reason.

303
A
rzrnc
Participant
rzrncParticipant
asked in Transformers
Custom transformer error in linked mode

Hi;I created a very simplified version of my custom transformer.All it does is find the center point and define the layer name for the future dwg writer.Attached is a custom transformer and workbench example, where dwg writer creates a dwg file with point in the default layer that come from custom transformer.When I use the transformer in "linked" mode and start the entire workbench, I get an error.When I use it in "linked" mode but with the use of feature caching to the transformer, and then I only start the dwg writer with "run to this", then it's ok.When I use the transformer in "embedded" mode, everything works fine.The difference in the translation log is in line:"Using MultiWriter with keyword `PRIMARY_DEST' to output data (ID_ATTRIBUTE is `multi_writer_id')"in embedded mode and"Using MultiWriter with keyword `REDIRECTED_DEST' to output data (ID_ATTRIBUTE is `multi_writer_id')" in linked mode.Note tha

160
rzrnc
Participant

Badge Winners

Show all badges

Community Stats

31,819
Posts
120,856
Replies
39,451
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.