Transformers

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  

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

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?

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?

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?

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.

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. 

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

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

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

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?

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.

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 ?

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

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): 

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.

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)

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 

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?

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

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.

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.

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

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!

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!