Transformers

Hello There I don't know why the point on the same side of the centerline some show left and other show rightI have attached the workspace if some can help to understand this   

Hi!!! I have a project need to cut these (M)lines by lengthfor example: there are line 1 is 13 miles long and line 2 is 16 miles long.I need to chop these 2 line by every 5 miles. as I have picture below, line 2 begin measure at 3th mile not 0.any idea how to do this? thanks

Hi guys,I have a table with an attribute 'Ingebruikname'.This field contains a year, month and day and info in hours. For example: 2019-01-11T13:05:00.000. I created a regular expression to select only the part with information about year, month and day. Like:2019-01-11T13:05:00.000I would like to get my attribute 'Ingebruikname' updated to records with only date infromation as shown in bolt. Records with no data for 'Ingebruikname' should be included as well and left empty.Do you have any ideas how to solve?  

Hi all, I'm trying to determine how to remove the column header option when selecting Table as the content type in the MSWordStyler parameters. The reason for this ask is because I'm building a report and wanting to remove that blank space above my tables - since I'm not populating the header. If there was a option for this, these reports would look more professional.https://docs.safe.com/fme/html/FME_Desktop_Documentation/FME_Transformers/Transformers/mswordstyler.htmTable Parameters ClosedTable Style ClosedWidth Units OpenColumn Header The header text for the particular column. Format attribute set: msword_table_col_header*****Optional - ? COLUMN HEADER *******The header below is highlighted in grey.

So there might be already a way to do this, but will ask the question before submitting an idea.For complex Workspaces, especially those with high parallelism in the workflow, keeping a clean connector visualisation can be tricky. There are already several great enhancements that have been added that allow the user to route the connector line in different ways like Vertices, Tunnels and Junctions, however it all seems to get a bit manual trying to keep connectors routed around Bookmarks they don't actually interact with, especially if you drag a Bookmark box to somewhere else on the Canvas and then have to start shifting non-related Connectors around them again.I'm wondering if there is an option instead to NOT display the portion of a Connector that goes through a Bookmark, where it does not connect to any Transformer within that Bookmark? Tunnels kind of do this, but I find a different problem arises from using Tunnels because at higher zoom levels on the Canvas you start

Hi,I have a road network that I want to group on spatial basis. I want to group the roads on 3 valent or more junction on the basis of connectivity.I have tried using TopologyBuilder and ListElementCounter to calculate the node valency, but not getting how to group them.I have uploaded the data in the attachment. Thanks.

Hi community. I am looking to improve some workbenches and have them slightly more automated.The one I am currently working on revolves around some height of building data and is extracting the class from a string (example below). Currently I am using the AttributeValueMapper to convert this out manually but would be fantastic if there was a way to do this without setting it manually (if new data/classes are added we don't need to come back in and edit the Values to map.This is a screenshot of what is coming out of the AttributeValueMapper. The Condition attribute is the Source Value and the lay_class attribute is the destination value.The class I am extracting is the capital letters (one with number, but there will be more in the future) towards the end of the string. I know there is a regex expression to extract uppercase letters which is the closest to an automated solution that I have found (the condition includes more than one uppercase character) so it may be a combo of that

Hi, FME topics are not triggering from cityworks Action manager, FME throws a bad request error. I assume there is some special configuration required on Subscriptions / topics in order for Cityworks to work? Any help is appreciated. @nathanatsafe

I want to join multiple unit tables to one main geometry table based on one common_id field. The scenario as follows Main_Table1 ===> Unit_Table1Main_Table1 ===> Unit_Table2Main_Table1 ===> Unit_Table3 Main_Table2 ===> Unit_Table1Main_Table2 ===> Unit_Table3Main_Table2 ===> Unit_Table4Main_Table2 ===> Unit_Table5 Main_Table3 ===> Unit_Table1Main_Table3 ===> Unit_Table5Main_Table3 ===> Unit_Table6Main_Table3 ===> Unit_Table5 The main table is having the geometry and the unit tables are having the attributes. One unit table contains attributes of multiple geometry tables as shown above.

Hi A layer from cad has geometry and annotations. I need to convert this cad file to a shapefile and use the annotations as attributes. The annotations are delimited by points. For example: 3.-7.-9 ->should become: attribute 1= 3attribute 2= -7attribute 3= -9 What I already have: (check only the upper part)  I load in the layer from the cad fileI use geometry filter to split out the annotations from the polygons. On the annotation part I use a string searcher to only keep the annotations with points in them (delimiter)Then I use this string searcher to divide the string in parts delimited by a point:The I use the ListElementExtractor to put the parts in attributes: Then I put the annotation part and the geometry part together in an attribute creator, were I create some new attributes that I fill in with attribute 1,2 and 3 from the annotation part. But after inspecting the output of the ListElementExtractor I see 4 objects.2 geometries with non of the attributes filled in and 2 anno

Hi, I know there are already threads about inserting images into Excel spreadsheets but I could not find a solution for my problem yet. In my workspace I create an image with MapnikRasterizer and a table, both of which I would like to write to Excel. For that purpose I created a template that is used in the writer. I define the cell location for the image in an AttributeManager but in the output it overlaps the table instead of being inserted into the defined cell. I'm sure there is some writer setting I'm setting up incorrectly but I just can not figure out which one. Example workbench and template are attached. Thanks for any help!

Good evening at everyone.SINFI (National Information System for Italian Infrastructures) requires that the data be delivered to the reference system EPSG:6875 [1]The SRS EPSG:6875 is called "RDN2008 / Italy zone (N-E)", based on the "RDN 2008" Datum.The "Rete Dinamica Nazionale 2008", is the evolution of "European Terrestrial Reference Frame 2000" (ETRF 2000) . The RDN2008-ETRF2000 system is the new official Italian reference system since 2011 (D.M. del 10/11/2011) [2][1] http://epsg.io/6875 [2] http://geomappando.com/wp-content/uploads/2016/07/DM-ETRF2000-RDN.pdf  I have configured as follows a custom "DATUM_DEF" and a custom "COORDINATE_SYSTEM_DEF" in my "MyCoordSysDefs.fme" file:ELLIPSOID_DEF GRS_1980 \   DESC_NM "GRS_1980" \   E_RAD 6378137 \   P_RAD 6356752.314140DATUM_DEF RDN2008                                             \   DESC_NM    "Rete_Dinamica_Nazionale_2008"  \   SOURCE     "PROJ4"                                         \   ELLIPSOID  GRS_1980 \   USE 7PARAMETER    DEL

Hi,is there any way to replace ALL big letters for small ones?Thanks

hello i create some autocad blocks in FME wich must go to an autocad_od fileBut those blocks must be linked with two different object_data tables.and i dont know how to do with the writer.sometime the result is two identic blocs at the same placethe first one linked to the first table and the second to th secondwith other technics the result is that my block is only linked to one tableso i need helpthank you

When writing georeferenced object to Sketchup and having the option "Move to Local Coordinate System" set to yes, it makes the model rotate a bit.If i do not set this option, then SketchUp will not be able to handle the coordinate system so well.  The coordinate system i am trying to move from is Sweref991330.The aim is to have the shadows correct and the rotation correct. It seems i can not have them both. Can anyone help?

Hi,we did install the FME Caller Widget into our Webserver Portal to run the workspaces from FME Server there.Unfortunately we were not able to run them due to: "You don't have permission to access this workspace."We checked all permissions, repositories where are the workspaces and it seem to be everything fine. Also user names and passwords. when we create an Server App from the same workspace, we can successfully run it in our Portal.Anybody any idea? Are there maybe other things to think about?Thanks a lot 

Hi, I've got a GDB file which contains over 1 million polygons and I'd like to merge/dissolve every polygon under 3000 suqare meters into their smallest neighbours. I've tried to use eliminate tool in ArcGIS toolbox, it will only meger to the biggest polygons, not exactly what I want. Then I got it working by using Spatial Join and other tools, but the process took too much time, about 5 hours. So I'm hoping FME got some transformers can make this happen, at least some transformer like the tools in ArcGIS.Here's an example below, I'd like to merge the selected polygon into the one with 795.67m2 rather than the one with 9798080.13m2.@takashi

Hello, I would change the value of an attribute in a table depending on the value of other attributes group of records. Concrete example :INPUTNameColorAreaAAAYellow150AZARed56BDEGreen29ABABlue298CDEGray8AZABlack76ABAOrange84BDEPurple162AZAWhite65 Sort by "Name" and "Area"NameColorAreaAAAYellow150ABABlue298ABAOrange84AZABlack76AZAWhite65AZARed56BDEPurple162BDEGreen29CDEGray8 and give the same Color value as the record with the highest areaOUTPUTNameColorAreaAAAYellow150ABABlue298ABABlue84AZABlack76AZABlack65AZABlack56BDEPurple162BDEPurple29CDEGray8 Thanks for your help.

With MapBox Styler I can apply a color thematic to my data and view it how I want the output with an inspector. However, If I try rendering it with a Mapbox Leaflet in an HTML Report generator I lose the styling. Why?

Bonjour, Je souhaiterais ajouter dans le nom de mes fichiers de sortie le jour et l'heure du traitement. Soit : PO1_ADR_20200107_1021.csv CE1_ADR_20200107_1021.csv Adresses_ADR_20200107_1021.txt .....J'ai commencé en utilisant le transformer AttributeCreator placé en début de traitement avec en valeur de sortie : "@DateTimeFormat(@DateTimeNow(),%Y%m%d)_@DateTimeFormat(@DateTimeNow(),%H%M)" afin de ressortir l'information de la date/heure du traitement au format YYYYMMDD_HHMM. J'utilise ensuite ce champs dans le nom de mes fichiers en sortie.Le problème c'est que j'ai rajouté des traitements qui ont ralenti mon workbench du coup je n'ai pas toujours la même heure de sortie (les minutes changent). J'ai donc essayé de créer un Paramètre publié avec cette formule afin qu'elle ne soit lancée qu'une fois et utilisée pour toutes mes couches en sortie. En terme de paramètrage j'ai l'impression que la formule e

During runtime, I wanted to read the log file for messages that contain 'START - ProcessID, 'FME Session Duration', END - ProcessID' and a few other messages (in the red boxes) into my workspace so I can include each message as a feature in my translation.I can get most of this information from a shutdown script like below. However, I need the information back into my translation so I can write it to a database table that records translation metadata.# Import modulesimport fme, datetimefrom os import path# Get current date and timedateToday = datetime.date.today().strftime('%Y/%m/%d')timeNow = datetime.datetime.now().time().strftime('%H.%M.%S')print(dateToday)print(timeNow)print(fme.processID)print(fme.status)print(fme.elapsedRunTime)print(fme.totalFeaturesRead)print(fme.totalFeaturesWritten) 

IM trying to read a lmgrd9.log file, i can see most of what i need, but need to group the time stamps into 24 hour blocks and the assign the correct date to that to give a date/timestamp - Then i wish to join the OUT and IN with the user name to give a duration - this will end up in a powerbi report so can do some there.

Has anyone else had problems with writing to an Inspire GML with CRS EPSG 3035? For me, the X and Y is switched causing my data to be rotated and over the UK (should be over the Netherlands).

Hi all,I have a list of POI names that I'd like to abbreviate using an a Excel file that contains the keywords. I only like to abbreviate the words found in the string that match with the keywords - not the whole string.Basically what a StringReplacer does, but in bulk.Thanks, Eduard  

Hi there! I wonder if it's possible to create a list from a matrix, very much like how I'd do this in excel (see this tutorial). I currently have field names as below (there are actually 20+ years) and what i need is a separate record for each year. Is there a way of doing it? I'd do it in excel but it's not working for me for some reason - plus I'd rather incorporate it into my work flow. I tried the attribute exploder but this became a bit of a mess.  Thanks!ReneeDistrictIndustry (short)20172018201920202021Herefordshire, County ofAgriculture etc171.2176.9182.2187.9192.3