Best Answers

Dear FME community,I have a CSV file containing points (longitude and latitude for properties) and a neighborhood shape file containing nested polygons. There are three types of the polygons from the smallest to the largest: Sub-neighborhood, Neighborhood and Macro-neighborhood.I would like to join the points to the polygons and append only one polygon ID to each property. If a property falls within multiple nested polygons, I would like to get the ID from the smallest polygon. For example, if a property is in a Sub-neighborhood which is nested in a Neighborhood, the Sub-neighborhood ID should be appended to the CSV file.Currently, I am using the PointOnAreaOverlayer, and I always get the IDs from the largest polygons when there are multiple polygons matched.Which transformers should I use to always get the IDs from the smallest polygons (based on the polygon type) when there are multiple polygons matched?I appreciate your help.Thao 

Hi, Is it possible to download/read an excel file from SharePoint? I can read the contents of the site using the SharePoint list reader, but unsure if I can then actually read a spreadsheet stored there?  Thanks, Sam

I am attempting to use the arcpy module in the python caller transformer in FME workbench 2019. I am using 64 bit FME 2019.1 build (19643), ArcGIS Desktop 10.6.1 with 64 bit background processing installed. I am wondering if there are any suggestions to getting my workbench to successfully access the arcpy module so I can use Esri GP tools inside my PythonCaller transformer. I have tried the following settings for preferred python interpreter and python home:when using this setting it appears that it defaults to FME Python 3.7, the following messages appear to show this in my translation log:0.0|INFORM|Loaded module 'PythonFactory' from file 'C:\Program Files\FME_2019.1.3.1\plugins/PythonFactory.dll'0.0|INFORM|FME API version of module 'PythonFactory' matches current internal version (3.8 20190621)0.0|INFORM|Using Python interpreter from `C:\Program Files\FME_2019.1.3.1\fmepython37\python37.dll' with PYTHONHOME `C:\Program Files\FME_2019.1.3.1\fmepython37'0.0|INFORM|Python version 3.7 

I have a workspace that is trying to upload a bytearray into an existing PostGIS table, into a ByteA column. The data is generated in a python caller.Using INSERT, this works fine. There is no problem, and the resulting data can be read from a different client as expected.However, using UPDATE it fails, stating:Error executing SQL command ('update "public"."mesh_test" set "ogc_fid" = 694,"mesh" = E'\003\000\000\000\212\032\005H\004\362\336H33C@g\032\005H&\362\336H\205\353\021@\354\031\005H\004\362\336H\205\353\021@\001\000\000\000\000\000\000\000\002\000\000\000\001\000\000\000' WHERE "ogc_fid" = E'694''): 'ERROR:  invalid byte sequence for encoding "UTF8": 0x00I can circumvent the error by encoding it into base64, but that yields data I can't interpret from another client.It seems that the update statement is done using a different method than the insert statement, which is odd. Has anyone seen this before?EDIT: Added example workspace, plus sqlfile to create and populate table. Y

Hi,Unfortunately I am still forced to use FME 2014. A lot of webservices that I frequently use have now moved to TLS 1.2, and I find that FME won't connect to them anymore, returning an error "SSL connect error".Based on this: https://knowledge.safe.com/questions/73167/what-http-client-does-the-httpcaller-use.htmlIt looks like the version of FME shouldn't be a problem, since FME uses what the OS provides (in which case I need to get my sysadmin working - we're on Windows 10). But based on this:https://knowledge.safe.com/questions/85353/esris-arcgis-online-is-removing-support-for-tls-11.html It might not be supported, although this sentence "FME has supported TLS 1.2-based connections to ArcGIS Online starting with FME 2015.1.1" could also reference AGOL instead of TLS, I'm not sure about that.Can anyone clarify for me what the problem could be? If the upgrade is the only solution, then I'm out of luck for at least the next few months I'm afra

Hi, Im trying to write data to an xlsw writer where i want for each partner a seperate excel file with a sheet for each municipality.So i tried to create a writer where i set my sheet name to an variabel attribute (gemeente) and then by the fanout option i tried the variabel attribute "gegevenspartner". But is doesn't work, what am i doing wrong?

Hello FME Community,  i need help to understand how i can solve my problem.   The outcome should be a Excel-File where all Adresses on a parcell should be stored.  1.)i got Points(Adresses) and Areas  2.) Use the PointonAreasOverlayer and make a List on the Areas.  3.) Use the ListExploder: Take the List and Create a _element_index (rest is standard)  now comes the part that i dont really understand.  4.) i use the AttributeCreator for Creating Attributes like "@Value(_element_Index)Adress" = "@value(Adress)" then i use the "centerpointreplacer" and a "pointonpointoverlayer" to merge the "new" attributes  then comes the duplicatefilter(group = ID) to get the unique Adresspoint with all the AdressesStored in a parcell.  and then comes the tricky part: after i use the AttributeCreator my Created Attributes where gone but when i redirected it to the datainspector my attributes where stored an the "Areas"  and that was it. I tri

Hi I have been using the NetworkTopologyCalculator in conjunction with the Aggregator to combine numerous individual lines segments into larger 'single merged' line segment with limited success.  I have noticed there are a few line segments that either fall short from touching and a gap can been seen or overlap. See image 1 below. The gaps are generally less than 0.2 meters.Image 1 Detail view of image 1 below:Image 2Having read a few threads on the forum I inserted the Snapper transformer, setting the parameters to Segment Snapping and the Snapping Distance to 0.2. When I inspect the data I can see that the gap has been closed.Image 3 I assumed that as the gap had been closed that the NetworkTopologyCalculater would have then included this 'connected' line segment into the 'single merged' line. Unfortunaltly it didn't. The image below shows that the majority (99 lines in total) of line sections have successfully been converted into a single line that all s

Parameters and Attributes seems like two really confusing concepts sometimes. Can we have someone clarify the main differences between them? Thank you!

Good morning,I am trying to come up with a way to generate lines where the starting locations are contained in one data set and the end points are contained in another data set. I have 19 "start" points and 4 "end" points; I need a line from each start point to each end point - So I should end up with 76 lines. Any guidance on how I should accomplish this would be greatly appreciated. I've been toying around with lists and trying to loop through them to create all the pairs of points that I need to feed into the LineBuilder, but I've been struggling with how to get it done. Thanks,Brian

So, what would be the easiest way to do this. Lets say we have generated 2 separate, but parallel Lists like this (say from ListExpressionPopulator):Colours{}Precincts{}And it is desired to combine these into a single list with the original list names as instead the component names like this:Report{}ColoursReport{}PrecinctsAs far as I can tell, this can't be done with either ListRenamer or AttributeRenamer, and the closest got to is using BulkAttributeRenamer.

Hello,If I load a file .osm downloaded from OSM in Qgis I can see in the table all traslation present for admin boundaries.I tried to do the same in FME but I am not able to see these attributes.Sombody can help me to understand how to do?ThanksMaxthis is what I see in Qgis and what I would see in FME.

I have an access database that gets updated when data is checked in from a mobile device.which is set up as a FME Server workspace with directory watch protocol set to modify . I was hoping that adding new records would change the file size and the workspace gets triggered which in-turn triggers a child workspace. Unfortunately the size does not change every time data gets checked-in.Im looking for help on how to check for updated records in an access database since the SQL executor doesn't work on access database.The access database has valve exercising information ,which is used to create inspections in cityworks using the Cityworks API. The child workspace uses the API to make the API calls to Cityworks.

Hi All,We're looking at setting up a PostGIS database on a PostGIS database sitting on an AWS Serverless RDS and are unclear whether our desktop FME will be able to successfully interact with it.Our main concern is with some of our existing FME workspaces that we would want to read from the PostGIS database, process for 2-3 days then write the output back to the database. During this processing we'd expect the AWS Serverless RDS to switch itself off as all the processing is happening on my desktop, but will FME "wake-up" the Serverless RDS when it's time to write to the database? Cheers Rich   

Hello,I have a set of lines that I converted into points using snipper. I want to find one neighbor of every point, so I used Candidate Only feature of NeighborFinder. However, I receive the same point as closest candidate.I tried the same workflow for other set of points which I hadn't converted from lines and it works fine for this input. I'm not sure why I'm not able to find neighbors of points I created from lines.Please provide some suggestions. I've added screenshot and workbench for reference.  

I need to create a workspace that I can use to find groups (brands) that are wrong or do not fit with the majority of what is in my existing shapefile. For example: If 1000 Boston Pizza have group of 'Boston Pizza' and 5 have a group of 'Boston Pizza Restaurant and Bar' - then the logic should replace those 5 with the majority group.

I am trying to write to an Inspire GML writer using the Habitats and Biotopes xsd but I am not getting any geometry. If I preview the output from the last transformer I can see that the geometry is polygons:But the written GML just contains the attributes and no geometry.Does anyone have any clue what I am doing wrong?

Hi!  Im having trouble producing a 3D mesh from my point cloud (.las). I'm using the PointCloudSurfaceBuilder which seems to be just what I'm looking for, but the process halts after some warnings in the translation logg."PointCloudManipulatorFactory: Converting 'x' from type 'Real64' to 'Real32'. If this conversion is undesired, consider changing the type explicitly." (seen below)This line is said for x,y,z and a similar line for "color_xxx" and is undesired.  The PointCloudCoercer > Output Geometry: Singel multipoint makes these warnings go away, but instead redirects the process into "Rejected".Does anyone know how to proceed with this?  Any clues is much appreciated!! 

Hello,I noticed a difference in attribute handling in my FME workbench. I hope anyone can explain what is causing this.I have the following data:With the AttributeManager I want to convert the numbers from meters to millimeters (see below).The outcome of the AttributeManger is:Why is the bottom value of the first row different than the other two rows?It is luckily not an obstructing issue in my workbench, because I solved it with the AttributeRounder. But I am curious how this happens, and what the options are to prevent this from happening.Thanks in advance!

Hi there, I am trying to calculate the four date fields related to the start and end of the current and previous regulatory year based on the current date. The regulatory year starts from 1st of April and ends on 31 March of next year. So in this way current regulatory year starts from 1st April 2019 and ends on 31 March 2020. Here is my logic :Current_regulatory_year_start: @DateTimeFormat(@DateTimeFormat(@DateTimeAdd(@DateTimeNow(),-P9M),%Y%m)01,%Y%m%d)Current_regulatory_year_end: @DateTimeFormat(@DateTimeFormat(@DateTimeAdd(@DateTimeNow(),P2M),%Y%m)31,%Y%m%d)Previous-regulatory_year_start: @DateTimeFormat(@DateTimeFormat(@DateTimeAdd(@DateTimeNow(),-P21M),%Y%m)01,%Y%m%d)Previous_regulatory_year_end: @DateTimeFormat(@DateTimeFormat(@DateTimeAdd(@DateTimeNow(),-P10M),%Y%m)31,%Y%m%d) However, it does not produce the desired result. Current_reulatory_year_end and previous_regulatory_year_end produce null value, whereas the other two do not produce the right date. Could you please guid

Hi,  I would like to create 72 features with predefined ID and NAME attributes for instance:  ID    NAME 689  Kativic 711  Monts et marées 712  Charlevoix ...     ...  So far I used the creator (1 instance) followed by AttributeCreator where I added all IDs separated by a coma into 1 attribute. Then I used the AttributeSplitter to create a list on the IDs and finally the ListExploder.    The result is ok, I have one feature with the ID, but I cant find a way to have the NAME attribute also attached to those features. Instinctively, I would use a JSON key:value list, but I am not sure how and if it is the correct solution.  Thank you for your help 

Hi Everyone, I am fairly new to FME, so please be patient with me! I have some As-Builts in PDF format that I need to convert to TIFF format as part of a monthly update to an external stakeholder (individual PDFs to individual TIFFs). I have attempted to use the Adobe Geospatial PDF reader and translate it to the TIFF/GEOTIFF writer, but to no avail. I keep getting an error message "Failed to obtain raster from feature. Only features with raster geometry are expected"; this is despite having 'Read Rasterized Pages' set to 'Yes'. I would appreciate any help and suggestions that can be offered!  Thanks in advance!

I need the following:Every line has to have two numbers, the rest will be the same.  Is there a simple way to do this?With kind regards Remco

We're upgrading our servers and databases to ArcGIS 10.6, Oracle19c and FME 2019 I'm installing the new machine for FME, but 'm unable to connect to our database with the ArcSDE Geodb reader. I'm using a sde connection file(which works in ArcCatalog), but when I try to open the Table List I get the follwoing error:Failed to retrieve feature types.Could not open the Enterprise Geodatabase. The error number from ArcObjects is: '-2147216072'. The error message from ArcObjects is: {Underlying DBMS error[Unknown errorNo extended error.]}Here's the additional logfile:  My Setup:Server: Microsoft Windows Server 2016 StandardFME Desktop 2019.2.2 64-bitArcGIS Desktop 10.6.1ArcGIS Desktop Background Geoprocessing 10.6.1 (64-bit)Oracle Client 19cOracle instant client 19.5 64-bitDatabase:Oracle 19.cArcSde 10.6.1 Connecting to the database with an Oracle Reader does work. Any idea what the problem could be?

Hi all,  I have something weird going on in my StringReplacer.E.g. a simple string goes in. StringReplacer settings: RegEx captures whole string in capture group 1, then as a replacement I use capture group 1, followed by the string "finished"  In the output the string "finished" is somehow duplicated. Magic / bug / am I doing something wrong? Cheers, Ed