Transformers

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/202010/01/2020 417/01/2020<missing> <missing> <missing> &l

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 solution for me dwg to postgisBe specific in your answers

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 out when the Exploding Typ

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.

Hi there, I would like to use a Conditional Region Growing algorithm from the PCL library (See tutorial) inside a workbench. I make some point cloud preprocessing using vector features and then, at some point, I would like to introduce this algorithm and go further with my processing. How can I make use of that? I have tried with Python bindings using PythonCaller but it is not so helpful in this case.Is there a chance that this solution will work? :-> Preprocessing... -> SystemCaller(call .exe file triggering C++ algorithm) -> grab results (still within FME) -> process further Would you like to share some other possible solution?The biggest advantage of FME is that you can construct pipeline from A to Z and you do not have to interrupt it. I can, of course, export results after preprocessing and then that get back to FME but it is not what I would like to have at the end.

Bonjour,J'ai deux tables qui ont des noms de colonnes identiques et j'aimerais ajouter l'une en dessous de l'autre et pas à la suite. merci.exemple: tableau premier: nom prénomville paiemax romainParisFrance  deuxième tableau: nom prénom villepaielucievernLondres Royaume-Uni J'aimerais avoir ce résultat: nom  prénomvillepays maxromainparisFrance lucievernlondresUK

Hi, I have date and time value in a column which look like '19960108031100'. Now I want to split into two columns i.e. date and time. Could anyone guide on how to do that? RegardsYasir

Hi, On FME Cloud I tried to execute the statement "FME PYTHON" and a python script. I am using a SystemCaller, which works on my Windows FME Desktop. The Python script is from a third party that should be run over the outcome of a workspace, and I don't intend to adapt it. However, the workspace did not run on FME Cloud. After some experimenting I learned that - since Cloud runs on Ubuntu - this still works, however, the path to the FME executable should be /opt/fme-engine-2019/fme. My question: Is this a correct way to run a Python script? Or is there a way to just run Python script from the PythonCaller?

Hi guys,I have a line file (1 line) and a point file (Multiple pairs of start/end points). I'm trying to clip multiple line segments from a single line based on a start and end points with matching ID attribute. I have been trying PointOnLineOverlayer but it adds the attributes from only the first point to every line. When I generate a list based on the ID the list includes every point ID on every line, not just the points that the new line intersects.  Is there another way to achieve this? Any help would be greatly aprreciated. Cheers, Dave.

Hi I am new to using FME.  I have imported an IFC file in a reader.  I would like to take the ifcSpace geometry (an Aggregate Solid) and break it down to its constituent faces.  Any ideas please?  Thanks  Gareth