- - Community Resources
Ideas
Product Updates
Events
Blog

Home
Forums
FME Form
Transformers

Transformers

Using transformers to modify data.

12,686 Posts
50,752 Replies

When you subscribe we will email you when there is a new topic in this category

12686 Posts

jerome

asked in Transformers

simple summary report

HelloI am looking to write a simple execution report in a file with the name of the writer / table name and the number of records written. I don't want to use summaryReporter or FME_END_PYTHON. How to do this simply? Thanks in advance

260

4 years ago

luckyphil78

asked in Transformers

Is there an alternative way of meeting the last requirement of the Professional Certification?

So the last requirement for the professional certification states:Once you’ve completed the exam and have a grade of 75% or higher, you are ready to submit your application. Before submitting your application, please review the sample documentation. Your application must include: 2-3 workspaces from projects which conform to FME best practices as outlined in FME Desktop Basic Best Practice section. Your sample projects should demonstrate an advanced level of FME expertise. Any related files or information should be provided just as if you were delivering a solution to a client. Source data or output data is not required for your sample projects.Workspace documentation in a PDF, Word document, or Text file. Here is an example of workspace documentationReferences from 2 clients whose projects you’ve been involved with within the last two years.All parts of your application must be in English with the exception of your workspaces. At the moment, I'm only using FME that comes shipped

4 years ago

harmen_kampinga

asked in Transformers

Recreate raster but with smaller cell size

Simple need, simple question.I have a raster with 1 cell size 25x25 meters (geotiff)Just want to have the cell split up to a 5x5 meters raster with having those new 25 cells with a 5x5 meters raster having the same value as the original 1 cell of 25x25 metersAnd nothing else should change! But whatever Transformer I use or in combination with each other, it doesn't let me succeed in my goal.For example: with the RasterResampler it recreates a new raster with my desired resolution, but it doesn't keep the original values. It also seems to shift my raster. I have also tried to create a new raster and then use the points from that raster to extract the desired values. But that takes so much time to process... What am I missing? What do I not understand?

350

4 years ago

joseotaviobisca

asked in Transformers

COnvert format

Is it possible to transform a RASTER file into MBTiles format using FME? For example GEOTIFF raster to MBTiles format.Is there a tutorial on youtube?

150

4 years ago

ravibansalContributor

asked in Transformers

How to configure SQLExecutor to connect to correct database at run-time?

For one user, SQLExecutor is correctly changing to connect to DEVSQL\\High at run-time. For another user, the default parameters specified in the SQLExecutor (QASQL\\High as shown above) are being used. What user configuration setting needs to change in order to correctly grab the same database as user #1 is getting?

110

4 years ago

boringhannah5

asked in Transformers

How to convert excel Gauss Kruger coordinates to UTM?

Hi, not sure where else to ask this (first time poster).I have a large amount of coordinate data (only know the coordinates in Gauss-Kruger and the zone (zone 3)). Is there any way I can mass convert these coordinates to UTM? I've been researching this all day and have came across a few helpful research articles and one finished with a website that was created by a team of researchers using R and Shiny software, but the link was dead and I don't have time to recreate their work.I do not need to put them into a GIS, this data is being recorded in an rdb for analysis purposes, but is still very reliant on LOCIIDs.

3090

4 years ago

daniele

asked in Transformers

Rigid anchored snapper

Hi everyone,Noob here.I want to translate (move) the red lines in order to have the ending (or initial point) on the red line over the blu line. The length of the red line does not have to change. I tried with anchored snapper, but I think I need an anchored mover?!The red lines can also have many many vertices. Thanks,Have a nice day.

4 years ago

fmelizardContributor

asked in Transformers

Can I have Harris Geospatial FlexNet License Server and FME Server on the same computer?

Are there any known conflicts between Harris Geospatial FlexNet License Server and FME Server?

130

4 years ago

fgironContributor

asked in Transformers

Converting UTC datetime to CET/CEST

Hi,I'm trying to convert UTC datetimes to CET/CEST but can't find the way of getting a datetime that takes into account the Daylight Saving Time differences. The local settings of the DateTimeStamper or @TimeZoneSet function are of no use because the workspace is run in an FME Server where the local time is UTC.Thanks a lot in advance! Francisco

8024

4 years ago

nedwatermanContributor

asked in Transformers

convert json datetime to sql datetime

Hi, I'm using a JSON reader to grab data from an API. It's reading the attributes, but the datetime is formatted like so: 1587896100000 Firstly, what is the format of this? Is it JSON specific? And how can I convert to this to a SQL datetime,. which is where the output is going to be stored? ThanksN

1620

4 years ago

inframanContributor

asked in Transformers

Can I rename or remove duplicate field names?

I have a dynamic workbench that reads shapefiles and exports them to a FGDB. I have a .shp that had a few duplicate field names and wouldn't export to FGDB until I removed them. Is there a Transformer that will flag these duplicate fields and remove or rename them?

740

4 years ago

fikusasContributor

asked in Transformers

Zipping files: libraries, compression levels

I have multiple shapefiles (total size is 8.4 GB). Those need to be zipped. When using FME's ZipArchiver, compressed file size is 4.43 GB. But when using third party app – 7zip, the result file is ~11% smaller (3.94 GB). My guess woul be that ZipArchiver uses different libararies for compression. Maybe it is possible to use 7zip libraries in ZipArchiver, when compressing files?LZMA compression won't work in this case, because I need to be able to extract archives with built-in Windows extractor.

1100

4 years ago

pavelpostnov

asked in Transformers

Issue when I trying to build a lines

When I trying to build of lines from points, I get some thing like this:I am using LineBuilder, and group by attribute (each group of points has a different name), but I don't understand why I also get connect line (green one) between them ?

110

4 years ago

arnaudfouch

asked in Transformers

Specify which point is used for colorization with NumericRasterizer

Hello,I've made a FME to raterize some point cloud into elevation raster but I'm not satisfied with the result. I would like to be able to specify in the transform parameters which point is used to color the raster (min z, max z, etc ...). Indeed when we have power lines for example it is desirable that the point used for coloring is that of the line and not that of the ground. This makes it possible to highlight it in the Raster.Do you know if there is a way to control the coloring in this way? Example :That is what FME give me (left) and what I want (right)You'll see the difference on wire and tree Regard,Arnaud

4 years ago

s.k

asked in Transformers

Read a file containing user variables

I'd like to read a text file containing several lines of user defined variables given in the following format:var_name = "var value"There are many lines, each one contains one single variable with one single value:var_name0 = "var value0"var_name1 = "var value1"... I read the text file using an AttributeFileReader to which I connected an AttributeSplitter. My results come as one single concatenated line which is obviously not what I want. In the Delimiter field of the latter, I tried inserting `\n` `\r` or`\r\n` without any success. I also tried inserting a single newline by pressing one time enter in the "Editor" as discussed here (2013): https://knowledge.safe.com/questions/2361/use-attributesplitter-with-a-carriage-return.html without much success. I'm using FME(R) 2020.0.0.1 (20200316 - Build 20202 - linux-x64) on Ubuntu 18.04. Thanks.

210

4 years ago

clickingbuttons

asked in Transformers

How to write 3D SHP polygons as 3D CAD hatches?

I'm trying to convert a bunch of building wall tiles from SHP to DWG. The tiles are already polygons, but I coerced them into fme_polygon anyway. Then I use the DWG styler, with Area: Hatch, Fill Pattern: SOLID. The Inspector shows what I expected, however when I write the data, what I actually get in AutoCAD is just line-thin hatches, with some even missing. Also, when I open the file in the inspector, it just shows the lines on the ground, or everything got flattened.. do I need to manipulate the data further? I figured I could leave it as polygons, but AFAIK AutoCAD still interprets those only as the boundary lines, i.e. not opaque surfaces.

140

4 years ago

fikusasContributor

asked in Transformers

Find empty folders

I need to find all empty folders. Any hidden system files do not count (for example, Thumbs.db). I tried using Python, but unsuccessfully. Can someone help me on this?import fmeimport fmeobjectsimport osif len(os.listdir(feature.getAttribute('path_directory_windows)') ) == 0: feature.setAttribute('Value', 0)else: feature.setAttribute('Value', 1)

468

4 years ago

louis_c3

asked in Transformers

FBX file read with texture mirrored

Hi all,I'm trying to read an .fbx model exported from Infraworks. It appears in the data inspector with textures mirrored and the following warning : "FBX_1: A texture used by mesh in node 'Mesh N' references a UV set named 'default', which doesn't exist"I've tried to re-mirror the appearance but nothing seems to work and I don't know how to reference the UV set ... Do you have any idea what am I doing wrong ?The area in Infraworks :The area in DataInspector:the fbx file and others : Regards,Louis

380

4 years ago

agelfert

asked in Transformers

SDE Versioned Edits - INSERT vs. UPDATE

I have inherited some older workbenches/server workspaces and am noticing some issues with writer parameters, specifically where ArcSDE connections are concerned. For examples, I found that "accidentally" saving an old FMW in FME 2018 Desktop when the FMW leveraged fme_where without the explicit setting in the WHERE field, wreaked havoc by turning some updates into inserts. I have fixed that by cleaning up the workspace.1) Now, I'm looking at a workbench that is doing versioned editing in SDE and has the Writer set to 'INSERT' and 'CREATE IF NEEDED'. Yet it's doing updates. How is that possible - what am I missing?

570

4 years ago

itayContributor

asked in Transformers

Formatting the resulting interval (ISO Duration)

Hi,I am currently calculating date time intervals via the DateTimeCalculator that result is ISO Duration format (PT28M20S for example)I would like to format the result into a FME datetime but havent found a way to do it with the DateTimeConverter. I can split the value into its parts and then combine them but there should be an easier way...I am surprised that FME doesn't recognize and can parse this date time notation, after all FME is producing it....Using FME 2019.2.0.0 build 19801Could be I am missing something, any assistance would be appreciated.Cheers,Itay

7110

4 years ago

ronmak

asked in Transformers

DBF reader problem with Character Encoding

I am able to open a dbf with excel with no prompts, and with libreoffice it prompts me to use Arabic (ibm864) coding and then opens fine. But when I specify that with FME, the table is scrambled. Sorry - I tried to upload it but dbf are not allowed.

750

4 years ago

richard_che

asked in Transformers

How to compare whats different using Change Detector?

I have two datasets with 30 columns and after running the changedetector to compare 20 of these columns it states 0 are unchanged, how can I figure out which of these columns is the cause for the datasets not being the same? Would I use featuremerger or is there a simpler solution? to compare the columns to see whats different based on 1 shared unchanged column.

3330

4 years ago

mr_fmeEnthusiast

asked in Transformers

Import Survey123 information to FME Desktop

Hi,I need to extract information, responses from a survey123 form, into the FME Desktop, but as information there is no geographic information. How can I do this? It seems that the AGOL reader only reads feature services ... Thanks

4 years ago

kat

asked in Transformers

compare field attributes (of same table)

Hello,I would like to compare two attributes of the same table: e.g. a table of features with the following attributes: UID, old name, new name.I would like to know for which features the old name is the same as the new name and identify the features whose name has changed. Afterwards I would like to create new tables for all (and only) these features whose name has changed, one with the UID and the old name and one with the UID and the new name.Which transformers should I use ?Thanks for you help!

3520

4 years ago

ymor_v

asked in Transformers

Line extender with different length each side?

Hello! After trying different options with LineExtender, Snipper, PointonAreaOverlayer, I don't get the result I want. What I want: to be able to extend a line with an attribute. However, this value is different for each side of the line. Vertices on each side of the line contain this information for the particular side. How do I get this to work? Thanks a lot!!! Stay safe!

240

4 years ago

Page 207 / 508

Badge winners

viviantanghas earned the badge Welcome Back
ohagand1has earned the badge Welcome Back
holdsyhas earned the badge 12 Days Participant (2024)
ibeezumahas earned the badge FME Certified Professional
stefan_kutachas earned the badge Welcome Back

Show all badges

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