Transformers

How can i convert date from dd.mm.yy to yyyy (4 digit only ) in column in excel as example 01.02.2000 to 2000 only Thanks

i want to show filter on the header of column and change size of line and do the words inside cell in the center and each celll has size 50 .i mean rrange the cell and show fiolter that exactly what i needif it is not possible to apply filter in the output ,at least my input excel has filter on header ,i want to keep the filter as input i mean do no action on it .thanks

Hi there I am trying to write a Python script which should change the value of an attribue based on the occurence of different substrings int the attribute. This is what i managed to create so far:import fmeimport fmeobjectsclass FeatureProcessor(object):    def __init__(self):        self.featureList = []            def input(self,feature):        self.featureList.append(feature)            def close(self):        substring1 = 'blabla'        for feature in self.featureList:            if  feature.getAttribute('TestAttribute') == substring1:                feature.setAttribute('TestAttribute', 'value1')            else:                feature.setAttribute('TestAttribute', 'value2')            self.pyoutput(feature)            This script can be executed but isn't doing the job right. Whith this script de Attribute value has to be exatly the same like (==) "string1".I tried to do it like this, but the script isnt working:    def close(self):        substring1 = 'blabla1'        for fea

I have a line that I've chopped up and intersected with perpendicular lines to be labeled with odd and even numbers on either side.I used the counter transformer to label the perpendicular lines, but I encounter a looping sequence numbering that doesn't quite work for what I intend. See the image below.  What I would like is to have the sequencing start at the label 45 and 46 and end at the current endpoint. Any suggestions will be appreciated.Please see my workspace below.@takashi@sander@lizsanderson@david_r

With the help of a number of posts on the forums, I've taken a large dataset and been able to evaluate the total time, within a range of days, pool cars have been used. What I'm now struggling with is to calculate the hours used as a percentage of a "working day"eg;Car One used for 04:20:00 hours, what percentage use is this against a working day of 07:00:00? Do I need to calculate this out in seconds and convert back or is there another way? Thank you.

Situation: Raster (georef. Tifs) that either have no NoData value assigned or a NoData value outside the spectrum (for example, the value 256 for 8-bit). When transforming these grids from one coordinate system to another, white wedges appear on the edge. How can these NoData values be found in the implementation with FME transformers and how can these transformation wedges be eliminated? The position of the NoData values is unknown.

Hi there, I have a python script that I want to run on FME2019 desktop. I tried to google it but unfortunately, couldn't able to hold any link that explains how to run Python script. Could anyone point me to the relatively easy to follow the link that explains how to run Python script?

Right now I am using a python runner transformer to run the arcpy dice function but was wondering if there is an easier way to limit the number of vertices?

I want to find a way to pull out the first 13 characters in each list element until the list ends (identified by ItemsInList attribute). I currently have this:@Left(@Value(_list_UAIDs{@Value(ItemsInList)}),13)However this only returns the last entry. I want it to return every instance within the list.I wasn't sure if it was that simple of if I could create a looper to resolve this?

i used linecombiner transformer but it is able only to connect two lines but i have sometiems 3 or 5 lines are connected so which transformer should i use .Thanks

Hello,I have a 3D surface (mesh) and I am looking to extract point coordinates on a 5 X 5 Grid of this mesh.A conceptual workflow in my mind would be:Create a 5X5 Grid based on the bounding box of the surface (?)Extract the coordinates of the points that are on the surface using a spatial filterThis is not much to start, but any suggestions would be welcome. Thank you, George 

Hi there, I am trying to use Python code (which is written externally) in FME by using Python Caller. The purpose of the python program is to create two new attributes after performing manipulation on existing attributes. For this purpose, I create a data frame in the ___init__ of the Python caller, then I use the input function to capture the data that come from different blocks of FME transformation and then do the data manipulation in the close function of Python caller. Now the problem is that this structure slows down the program. I suspect it because of the way I capture the data in the data frame. I have two questions:1) am I following the right approach to populate the data frame? Is there any better way (quicker) of the populating data frame?2) Could you please also comment on my general structure of the Python code in Python caller i.e. defining data frame in __init__ function, populating data frame in input function, and final calculation is done in close function? RegardsYa

I am trying to create a point feature class within a polygon feature where the two line features intersect/touch (photo below)The to and from in each polyline is inconsistent    In some cases, the two lines do not intersect, but will touch if the line is extended (below)  

I'm trying to take points that are identical in geometry and attributes (except for a duration attribute: number of seconds) and make them into a single point with the same attributes, but sum the duration attribute. The points need to be grouped by account number. I have tried using Aggregator, which is almost what I want, but that produces multipoint features, whereas I need single points.

Hello,I have recently upgraded from version 2016 to newest version 2019. I noticed some strange behavior of 'Save data as' functionality in Data inspector in new version.When I want to make some quick 'one time' procedure to check something and don't want to lose to much time for polishing, I usually just add Inspector and later if needed export the results from inspector to excel... For example, I have 2 txt files, one containing data: 1 2 3 5 7 (each in its own row), and the other containing data 1 3 7 8 9 (again each in its own row). I want to match those data and inspect the differences:Everything works well but when I open Data inspector and want to save the data to excel I get this error:+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Feature Type: `Inspector' Attribute(string): `text_line_data' has value `varchar(255)' Attribute: `text_line_data' is sequenced Geometry Type: Unknown (0) Number of Coordinates: 0 -- Co

Hello,I'm trying to georeference some non-geospatial PDF files. I have the corresponding GEOTIFF and a shape of the desired bound for each one. I need a PDF output in CMYK and a reasonable file size (that's why i'm not using GEOTIFF directly in the first place).Here is what I have tried so far:1) replace the boundingbox geometry of the pdf by the shape, but the pdf bondingbox get rejected2) use raster georeferencer with known upper left coodinates, but I don't know how to find the appropriate cell spacing, and using raster is part of my problem (as explained above).Any ideas ? Thanks

I have an axis-aligned sphere and a plane that's rotated. Both have the same origin point. I want to rotate the sphere using the plane's RPY (in degree) attributes using the 3D Rotator, with Origin XYZ equaling the plane's XYZ, and the Direction XYZ = plane PRY. The rotation (for which I use the plane's R) works, but neither in the right direction or by the right amount. I tried switching the values around but so far I can't get it to work. Here's an illustration (current / goal): 

Hello,I would like to count the amount of cells that contain a value for each row in my dataset. It is basically the COUNTA function of Excel. But I don't know how to apply it in FME. I have a large table with 100+ columns which looks like this:DBKAlCaClPbZn10.10.15 1.2 2 0.11  1.330.20.130.41.52.1 Can anyone help me to get the below outcome?DBKCount132235 Thanks in advance.

Hi folks, I'm searching some documentations upon :installation and desinstallation of FME Desktop on SILENT mode and COMMAND LINE mode.can you help ?Regards.

I need to build something in FME where it automatically selects all ID entries and then looks at another column with values and selects the row with the highest value, and delete the other rows with the same ID. in the screenshot i have 2 columns: Risicoprofiel_BEREK and ID, in ID there are multiple entries which i need to select and then find the highest value from the Risicoprofiel_BEREK column. 

Hi there,I am creating a data frame that has two columns i.e. date and time on Python caller (at init function). I used the "attribute to expose" field to display the value of data frame. When I ran the translation, it made the dataframe column in the output but values were missing. I also tried to display the data frame value using column-wise but no luck. Could anyone tell how to add data frame at the output using Python caller?

Hi!TLDR: Writing a 3DS from a IFC with scaling of 0.001 and reprojecting from a local coordinate system to SWEREF99 12 00 I loose model quality, scroll to last pic. Info:I'm trying to convert a IFC model to a format I can use with GIS and Specifically import into ArcGIS PRO / Online. Shape Multipatch writes fine and the quality is there, but file size get big quickly and I loose textures with this writer.  Writing from IFC to 3DS without any other transformers yeilds a good result on my model: This quality pretty much looks identical to my INPUT IFC.If I Scale it 0.001 it also looks acceptable:if I only reproject I can see some small artifacts, why does this happen and can I fix it?if I both scale and reproject my output 3Ds is a mess:Why does this happen and any ideas how to fix this?Thanks in advance JJ

Hi,I am trying to use the LengthToPointCalculator in 3D mode however whenever I run my workflow I get the following warning message: WARN |@Length -- Cannot calculate length to a point in 3D. Continuing using 2DThe line geometry is definitely 3D as I can see the elevations for each vertex in the Inspector. Has anyone else experienced this and if so, do they have a solution?I am using FME Desktop 2019.1Thanks, 

We are converting 100s of DGNs to DWGs. All of our complex shapes (that have an arc as a component of that shape) in DGN are being converted to splines in DWG. We want to drop all splines to polylines, while still maintaining the arc information. Is there a way in FME to do that?

Hi guys,I have three Excel files which need to be converted into a Esri file gdb as three tables.As a schema for each of these tables I want to use three other tables which are stored in a gdb. I imported the last mentioned tables as readers and tried to implement their schemas in the writer of the first three tables using 'Schema definition'.However, I got an error when running the translationI am doing something wrong?