Transformers

Hi,I have a bunch of JPEGs taken with a drone that contain spatial information within the embedded exif.I am trying to enable each JPEG with the end goal of georeferencing them so that they can be made into a mosaic. I have tried combining transformers such as the PhotoCoordinateExtracter, CoordinateSystemSetter, RasterGeoreferencer, and the RasterMosaicker to no success.Also tried FeatureWriter to GeoTIFF then FeatureReader to no avail. When I drag them (JPEG or GEOTIFF) to ArcGIS for example, they all occupy the same space.What is the best workflow for this?Cheers

Hello,I would like to tranpose my data into a new table format. I found a similar post here https://knowledge.safe.com/questions/88862/transposing-data-into-a-new-table.htmlBut I am not able to get the result I want. The main difference is that I have much more columns and rows than in the post I mentioned above.The dataset I have:DBKAlCl...10.151.1...20.201.2...30.251.3...............With the 3 dots I want to indicate that it is a large amount of data. So much more columns and much more rows as well.I would like to get the following format:DBKParameterValue1Al0.151Cl1.11......2Al0.202Cl1.22......3Al0.253Cl1.33............... So the three dots indicate that there are much more parameters for each DBK and there are also more DBK's.In the post I mentioned above they use an AttributeExposer at the end. But I d

Hello!I am wondering how can I use FME to analyse graphe?I have points that represent a surface and I would like to analyse these surfaces with local maximum and/or minimum. But the surfaces are not always simple, some of them is almost like a line, but some of them are like a roof - as represented on the picture.Is there any way to fit a line to these points, and analyse the parameters of these lines, like determinant. Or is there any algorithm that could compare these generated lines with sample functions?Do you have any advice?

This one is already solved. Writing is for documentation only as I could not find the solution here.I had to debug a workbench from a coworker which was failing with the following error:WARN  |ChartGenerator: Non-numeric input provided.  Please validate that the values of the "X Attribute","Y Attribute" and "Error Attribute" (if supplied) are numericFATAL |f_24(PythonFactory): PythonFactory failed to close properlyERROR |f_24(PythonFactory): A fatal error has occurred. Check the logfile above for detailsDue to the log pointing to non numeric input in the ChartGenerator it took me some time to find out that the error was caused by something different: One of the attribute names used in the ChartGenerator in the "Y attribute" contained a space.I tested this in desktop 2017.1.1.0 / 2017.1.1.1 / 2018 beta (build 18220).This is a known issue and filed under C133238.

Hi there, I am applying a filter on record using tester transformer. My test clauses contains multiple And/OR conditions. I have attached screenshot of the test clauses. The problem is tester does not filter the record the way I wrote the condition. For example, I dont want to include the record in which CAUSE attribute has value 2A or 2B. However, in the tester passed category contains the record that has CAUSE value of 2A or 2B. Similarly, I do want to include the record in which the description attribute contains the value "BLOWN LV FUSE". However, passed category does contain those records. Could anyone guide me where am I making the mistake?

I would like to use an attribute value for a new attribute name using the Attribute Creator transformer, but this just not working. The new attribute is not created even if we can parameter the Attribute Creator to do so:I am using FME 2018.1.0.1 64bitsI have found this old question with the same issue. According to the accepted answer, the issue was suppose to be fixed in FME 2017. So is the problem fixed or not?

I am working on a project where I have to create maps. I have a file gdb and a personal database .mdb. Everytime I have to create a map I have to join them. Is there any way that the .mdb file can be just linked to the .gdb file so I dont have to do the join operation? Is there a way where the attributes that are stored in the .mdb file are just incorporated in the file geodatabase without doing the join operation?I further intend to convert the file geodatabase to a shape file, such that each feature layer has its own attribute table.Any help willl be much appreciated. Thanks in advance!@takashi @david_r @redgeographics

Hi All, I have date values in five columns, however, not all rows have date values in all five columns. For example, row 1 has values for columns 1, 2 and 3; row 2 has values for columns 1, 2, 3 and 4; row 3 has values for columns 1, 2, 3, 4 and 5; row 4 has value for column 1 only; and row 5 has values for columns 1 and 2. The rest of the columns not mentioned in each row have <missing> values.I want to create a new column called DATE and populate it with the last date before a column value of <missing>. For example, row 1 will have the date value from column 3; row 2 from column 4; row 3 from column 5; row 4 from column 1; and row 5 from column 2. Thanks for your help in advance.RowDate1Date2 Date3 Date4Date5 DATE114/01/201815/10/201916/01/2020<missing><missing> 16/01/2020219/01/201513/01/201711/01/201801/01/2020<missing> 01/01/2020 318/01/201415/10/201511/01/201601/01/201910/01

Hellosorry for my EnglishWe want to create a modifiable client web so that the departments are able to create, modify or read on a single map which will be fed by the drawing departmentWe create layers and attributes in qgis to be able to create and modify it's addition in the client web.The dwg is only for reference in the web client editable web client (lizmap) Other departmentsqgis connects lizmap with linux server ..postgisautocad map (drawing dwg) Drawing department I would like to take a dwg which is still in production by the drawing department ... which will be visible in the client web ...My problem is that the dwg is not compatible with qgisIs it possible to send dwg in postgis .. so that I can retrieve it in qgis .... for which can be displayed in the web clientUnless you have another alternative I don't know if FME products will be a solut

Hi, I'm trying to extract the table from http://skpos.gku.sk/en/stanice.php with HTML table reader or an HTML extractor but in the output I only see the column headers and there is now list I could explode further. How can I get the complete table? Thank you for your help!

Hello,I would like to extract attributes from a text file. The texfile contains different attributes separated by comma (,). It is like:104.474,104.474,649621.0654572968,245370.49979405673,0,0,146I tried this regex , but it gives back . delimited values (like: 474,104)(\\d+)(,\\s*\\d+)*Thanks!

Hello,I am overlapping a set of points on a combined raster from 200 previous ones and then exposing obtained values as attributes. However I want to get the attribute names as FME_Basenames (fig 2) and not as shown in (fig 1). Is there somehow how to to do ? Thank you very much(fig.1)(fig.2)

Hi,Any ideas how to generate a 3D footprint of a 3D object (e.g. solid)? Z value of the vertices of the footprint not zero.Something like deaggregating a 3D object to all individual surfaces and selecting only the locally lowest faces...Jasper

Hello everybody!I have a process that on ine libe calculates some values and write out in a text file. On an other line a system caller usues these files as an input data (with lascontrol command).I would like to know how can I define to delay these seconfd line until the file writer is not ready. 'Cause now the command gives back an error like: there is no input data (so the textfile).Here is a screenshot of the process.

What I want: changing temp location on the server with the FME Server express installation.  Last week, I installed FME server "express installation" on windows server and added a seperate engine also on a windows server.I added on both servers an FME_TEMP environment variable with a reference to another "temp disk", and restarted all the services on both servers. The seperate engine machine is writing the temp files verry well to this location, but the server with the "express installation" not. What can I do more to changing the temp location for this machine?

How to remove spaces in between numeric values.like belowBeforeI need like this0 909a 1 2 ga 12 ga125a125a 1 ba 1 ba 12 5 ba 125 b  

Hi there, I have a record that consists of 10 attributes/columns. I want to remove duplicate from the record. The duplicate would be based on the value of 5 attributes. When I say duplicate, it means that reduce the number of duplicate records to 1. I read the existing thread on the forum where someone recommended to use Matcher. However, Matcher categorizes the record into duplicate and non-duplicate. I don't want categorization. I want to reduce the duplicate records to 1 record. I also tried to use ListDuplicateremover, the problem in that was it only showed the name of one attribute. Any suggestion

Hello!I have some problem, how I can transform 3D surface (roof) to 2D surface? I want to do something like that:I used 2D forcer but I got different results area surfacace (3D and 2D), Maybe I'm using this function incorrectly??  

The AttributeExploder transformer exposes nonexisting list attributes when newly added to the canvas (using the default settings with Exploding Type = 'Features' instead of list)For this transformer I would guess that the Exploding Type would regulate which features should be exposed at the output port. I.e. using the default names (_attr_list, _attr_name, _attr_value);Choosing the Exploding Type = 'Features' should only expose the attributes '_attr_name' and '_attr_value', while choosing the Exploding Type = 'List' should only expose the list attributes _attr_list{}._attr_name and _attr_list{}._attr_value.This is only not the case when the transformer is newly added to the canvas, but is the case when the Exploding Type attribute is altered... Furthermore, I would guess that when the Exploding Type is set to features the Attribute Name/Value Label field should be greyed out, similar to how the List Name field is greyed ou

Setting the option 'Remove Source XML Attribute' to 'yes' within the XMLXQueryExtractor transformer only clears (but doesn't remove) the attribute.It would be nice if the behaviour would be similar to an 'AttributeRemover' transformer, that truly removes the attribute from the 'set of exposed attributes' 

How do I remove/filter out the column that says "ADRESS_ID"/ETC?

Sorting happens mostly by one attribute across a set of features. I would like to sort multiple attribute values (all of type datetime) across one feature and pick out the most recent date (of that particular feature) and assign it to a new attribute. I can imagine a lot of complex Testers, but it seems so obvious to use sorting of some kind. Any suggestions?

Is there a way to control the size of labels within AutoCAD blocks during DWG rendering? The text looks smaller and is misaligned when rendered by FME (and therefore the inspector and, more importantly, the PNG writer), but it's the right size and aligned properly in AutoCAD.Bad in FME (for Linux):vs. Good in AutoCAD: 

The DateTimeParse function is driving me mad (in FME 2018.1)!What is the problem with this...?Failed to evaluate expression '@DateTimeParse(3-Jun-2020,%Y%m%d,repair)'. Result is set to nullI have also tried @DateTimeFormat and @DateTimeCast and things like putting quotes around the input etc. Nothing works.I want to use the function because I want to convert a value of "3 June 2020" to 2020-06-03 to write into a date field in SQL Server. I have already use the string functions to extract the substrings for day (3), 3 character month (Jun) and year (2020). I could go the long winded way and write these to separate attributes then use the DateTimeConverter transformer, but why should I?

mes données de départ  Tableau 1  numéroheure 1 11302124031850414005153069307155081530  ce que je veux obtenir Tableau 2numéroheure1 11:30212:403 18:50414:00515:30609:30715:5083: 30 J'ai essayer avec le transformer StringRemplacer @Left (@Value (heure), 2): @ Right (@Value (heure), 2)et j'obtiens :j'aimerais que quand y'a 3 nombre, il ajoute les " : " derrière le premier nombre ex: 930 devient 9:30 merci.