Transformers

I'm working with CodePoint Polygons (areas for Postcodes) and have developed a Workspace to count addresses in each Postcode that are inside and outside a certain area. I'm using AreaOnAreaOverlayer to split the polygons into 2 where they cross the border of the other area. However, the consquence of this is that Vertical Street* polygons get merged (I think the Tolerance parameter is doing this), which causes one of the Postcodes to be lost. This means I don't get an address count for it.I've tried using Group By Postcode, but this crashes the process because there are too many unique Postcode values. A WorkspaceRunner to process each Postcode separately seems overkill. I can do it by Using Attributes From One Feature, creating a List of Postcodes, then using ListConcatenator etc to re-create the deleted polygons after AreaOnAreaOverlayer has merged them. But this seems a rather tortuous way of doing it.Any suggestions?* a Vertical Street is something like a tall

I am attempting to remove extra spaces and other characters from a attribute entries. I was able to find small script that does the job but in python. For Example:point_NAME (Before Processing)A B C Bank , DreamTownpoint_NAME (After Processing)ABC Bank, DreamTownI am able to detect the points which have these extra spaces and I am attempting to pass these on to pythoncaller transformer.I want to use this syntax in python caller. Can someone help me out? import restring4= "POI_Name"print (re.sub(' +', ' ',string4))  Thanks for all the help in advance!! :)@takashi @david_r @Mark2AtSafe @MarkAtSafe

Hi All,I'm trying to apply geotiff imagery to 3d roof geometry with the Top Down Georeferenced method (using Attribute Join within the transformer). The geometry is rejected and encoded with the MISSING_REFERENCEE_KEY string.Any help is much appreciated!Thanks,Charles

I have built a workbench where I do some processing on a set of features and then test the result. If the result is not what I want I would like to go back to the original feature and send it down a different path. How do I do this? I know how to find duplicates, set counters and such, but how can I compare the attributes from features in two separate "data streams" and then output one of those "streams"? Apologies in advance for what is probably a very simple answer, but my Google-Fu failed me this time.

Hi all,  I need to build a nested Json structure similar to a folder structure. Is it possible to do with the JsonTemplater wihtout a lot of sub-templates? I want something more dynamic or alternatively I have to post-process the Json.  Thanks!  /Jacob

I am using a FeatureReader to connect to our SDE GDB. I want to add a query (WHERE Clause) to the FeatureReader so that I am only pulling in records within the Feature Class that were edited within the last month (or sometimes edited in the last 5 days).When I look at the SDE data via MS SQL Server Management Studio (SSMS) vs within FME's Data Inspector I see the data in different formats:Within SSMS - LAST_UPDATED field is a DATE field:  last_updated (datetime2(7), null)  2018-12-01 16:23:56.0000000Within Data Inspector - LAST_UPDATED field is STRING field:  last_updated (string)  20181128133118My questions:1) is there a way to specify which attributes I want to be brought in? Right now I am using an attribute manager to remove the unwanted attributes.2) How do I only at a WHERE Clause so that I only pull in the data I want within the specific time range? I have tried "last_updated" > '20180500000000' but this brings in nothing. I a

Hi all,I have a question a bout spatial join.I have 2 folder data. Folder 1(GA Folder) and Folder 2 (CHANGE REGION).I want to join spatial each file in folder 1 with a file in folder 2 which the same date.Actually, I can use testFilter for each date but it's manual. So I want to use other way to make it automatically. Could you show me how to the way to make it?Thank you

Hi,I am trying to flatten information stored in XML into a tabular structure. Some attributes can be repetitive (for instance a water area name can be provided in different languages or different alphabets). My guess is that the XMLXQueryExploder transformer should be able to play a role there or maybe simply a ListExploder. I guess using a XQuery would be more appropriate but I didn't figure out the appropriate syntax yet. Basically I would need to extract the name information from the attached XML and populate these into a tabular structure such as shp or gdb table. The desired layout would look like: FeatureIdNameTypeISOLanguageCodeLanguageCodePrimaryNameIsoScriptCodeNameTextNotationAlphabetGeoActionTypeGeoView93e05831-25b5-4df2-b264-179c9b7914b2StandardNameENGEnglishTRUELatnPersian GulfLatinRemoveZAL93e05831-25b5-4df2-b264-179c9b7914b2StandardNameENGEnglishTRUELatnArabian GulfLatinAddZAL93e05831-25b5-4df2-b264-179c9b7914b2StandardNameARAArabicFALSEArabاÙ?Ø®Ù?Ù?ج اÙ?عربÙ?A

Hi I am trying to run an SQL to select records in past 10 mins from OracleI have tried various methods in my sql, but none seem to workselect * from table name where updatedtime >= sysdate - interval '10' minute select * from table name where updatedtime >= to_char(sysdate - (10/24/60), 'DD-MON-YYYY HH24:MI:SS')I am thinking of setting a parameter to the required datetime and use it in SQL ServerCouple of queries:1) Is startup script best place to create this parameter2) Will SQLCreator query work with a parametere.g. select * from table name where updatedtime >= to_timestamp(fmeparameter, 'DD-MON-YYYY HH24:MI:SS')where fmeparameter ='14-DEC-2018 14:00:00'

I don't see any readers or writers for Mapbox datasets and was wondering how you can manipulate. Trying to manipulate the vector data in the map opposed to the Tiles. Any help would be great, thanks.

I have a mesh example which I'm trying to simplify with the MeshSimplifier. When using certain different Settings I get either a mesh or a rejection message. In the attached example the mesh passes when using 0.5 as the Relative simplification amount. When set to 0.2 I get an invalid mesh. Also when using the result form the MeshSimplifier.Can anyone tell if my mesh is invalid or if this is just FME behaving badly? If it is the mesh does anyone know if there is a way to fix it?  Example:

HiI wanna try to convert building footprint shape file to cesium 3dtilesBuilding footprint shape file has attribute of Building Floor informationAttribute field name is 'GRO_FLO_CO' Check it under imageand i need to attach shape to DEMI use 'SurfaceDraper' and Extruder from floor attribute.I want to display different color of 3D building surface according to building floor.I use appearanceStyler and AppearanceSetter but they didn't work.Only AppearanceSetter Work.This is my Workbench<Workbench overview> <AppearanceStyler Setting> <AppearanceSetter Setting> <Result cesium3dtile> - Though i set 3 different condition and color but only one color applied

I'm trying to convert ISO datetime to FME DateTime in 2015 version. Have tried using DateFormatter transformer but gives wrong output. It is strangely displaying Expected datetime+02:00 hrs. It looks like it may work in other versions, but not in 2015. Not sure what the issue is.For ex: The value 2018-12-13T22:05:36.000Z (ISODateTime) gives 2018-12-14 00:05:36 instead of 2018-12-13 22:05:36Any suggestions please? Thanks in advance.Tagging @takashi, @david_r.   

I am converting a kml to shp and trying to calculate the area of the resulting polygons. It seems to run okay, but I don't see the calculated result. The field that should have it is blank in the attribute table in ArcMap. Here is the AreaCalculator transformer: This is Inspector:Is it actually doing the calculation? Where is the result?Thank you..

HiI am trying to create drive time zones for a data set with 2-5 starting points, much like image #2 here, http://desktop.arcgis.com/en/arcmap/latest/extensions/network-analyst/what-is-network-analyst-.htm. I read https://knowledge.safe.com/articles/30048/creating-time-and-distance-isolines-using-the-netw.html and I managed to create drive time zones for a single starting point:Each zone is 3 minutes of travel. However, I am looking for a solution for using multiple starting points. The idea is to see what happens to drive time when adding or removing points (clinics, in my case). Any suggestions on how to achieve that?Currently, the workspace looks like this:Regards,Magnnus

Result of duplicatefilter unique port is always 5000 features, irrespective of the number of input features.Is there a kind of FME default value of maximum features I have to change/increase?

Hello,We are trying to connect to a Naviline billing system that is used for water billing for the first time that has an IBM DB2 database with an i IBMDA 400 server. I saw this web page that was posted on June 1, 2016. https://knowledge.safe.com/articles/675/creating-an-odbc-connection-to-an-ibm-db2-database.html After reading this I am thinking this is the process to make this connection. The post is a couple of years old. Has anyone tried this process recently? The .exe file mentioned in the article is v9.7fp1_nt32_client.exe. Is this still the case or is there a newer one?Thank you in advance for your consideration.Laura 

Hi FMErsIs there a way to extract the bottom-left coordinates from an output geometry using the Tiler transformer?The reason is that I'm tiling/filing a geometry (to CAD format) and would like to use the bottom-left coordinates as file names, like for example "x=12000 - y=3000.dwg".Please let me know if you need me to elaborate or if it is not clear.Many thanks

Hi,I am a fairly new FME user and I don't have a lot of experience with it so I was hoping somebody could help me out.I have two shapefiles and I want to update field values from one table with values from another. The "Line table" had fields From and To Node ID that matches with the "Nodes table" Node ID.I have sorted out all the nodes that have no Z value and I want to update that filed with values from the "Line table" with the condition that the lower value is chosen if From and To Node_ID_Z are different. So for example for Node ID = 3 I would like to have a value 1,8.But I don't know how to properly join these two tables and set this condition. Any suggestions?

Hi FME'ers,I have two network datasets, one for all streets and one for footpaths only. There are instances where the footpath and the streets follow a similar path. This is never exact and they often weave around each other, intersecting each other at multiple points. I need to find a way of identifying sections where the street network and footpaths are similar. The goals is to reconcile their geometries but the decison over which geometry take precedent is not mine to make. I have attached an example. The green is the street network and the turquoise is the footpath. Thanks,David

Hi. I have data in postgres server and I need to fetch the polygons from there. The data is like, Country-State-District-Town-Locality. There are association ids in a separate column for each level. So, one country has one association id. The state has multiple association ids attached to that country id, the district has multiple association ids attached to the state and country... etc. I have extracted(SqlCreator) the data using the list in spatial relator, but not sure how to extract using association ids. Any solutions? Thanks!

If I wanted to hide a transformer so that it couldn't be added to the canvas in an FME workspace, can it be done? I don't want to do anything drastic, just tuck it away so that another transformer would be used instead. Lets say I didn't want anyone to know the 'Reprojector' existed in order to ensure they always used the CSMapReprojector, is there a file I can edit somewhere to 'comment out' the Reprojector...?I've tried editing \\transformers\\fmesuite.fmx to no avail.Many thanks...

Hi, I need help …..  I have an infrastructure-network with points and lines/polylines in 2D  and I want to transform it in 3D.  For the points I used the transformer „3DForcer“,  to assign them „Z_value“ to the z-coordinate,  there is no problem.  But to transform the lines (add the Z_value),  I don’t know how ?  Thanks for Your help …..

Good day, I have a list of warnings that I want to write to a database. I am using MSSQQL_JDBC_NONSPATIAL writer to write to our SQL Server database. One of the table attribute is the WarningTimestamp. (I set the type to datetime in the writer.) It is in ISO datetime format. When I want to write the records to the db, I always get an error telling me "MS SQL Server (JDBC) Writer: Error writing feature. Error: Attribute 'WarningTimestamp' does not contain a valid timestamp" even thought the WarningTimestamp is '2018-10-08T00:00:00'. If I use the DateTimeConverter to convert the ISO datetime to FME datetime, the import is working. Why? Please help.  

HiIs there a size limit for the "Search in"-string of the StringSearcher-Transformer?Regards, Tobias