General

Welcome to the last What’s Up Wednesday of September! Google SheetsV3 of Google Sheets was scheduled to shut down today, but has been extended to January 26, 2021. Even with this extension, it is still a good idea to update your workflows to V4. For more information see this article. If you are creating a workspace with 2020.1 or newer, the Google Sheets reader/writer will automatically use V4.  Gartner Peer Review SurveyDo you love FME and love earning shiney badges on the community? For a limited time we’d to offer you a special community badge for sharing your experience with our products on Gartner Peer Insights. Get started by visiting http://fme.ly/CommunityInsights and entering your community username. That earns you the special badge, and from there you'll be forwarded to the Gartner web site for the actual survey process. If you missed the announcement back in August, Safe is now on the Data Integration Magic Quadrant from Gartner! Read all about it here.  FME Data Express

The first writer feature was done by connecting the list of wanted attributes to the attributes template I have done. So I run it and wanted to proceed to a new translation which involved transformers. Is there any possibility I can just connect the writer to feature so I don't have to run it twice?

Hi, I am currently trying to create a new attribute based upon a number of sub-string matches. Currently this is using the attribute creator and a condition statement (lots of else if's). This is currently works, however, I need to extend this to provide all the matches rather than just the first match. Some of the original values may meet one or more of the conditions for the new classification. I know I could do this in a series of subsequent attribute creators, but there would need to be over a hundred individual ones. Does anyone have any advice on how I could do this more streamlined! Thanks!

Please help me regarding issue in float the license in another machine.My floating license is up in one machine and static IP assign to it. When we assign floating license in another machine we are getting error regarding port. I ask network team ,all port open for server.

Hello everyone! I'm trying to get to know if it's possible to cluster (combine with the same e.g. cluster_id field) points that are lying within some distance to each other and additionally have the same, selected attributes.For example I have PostGIS data containing buildings as points. Some of them have the same elevation and are very close to each other, due to the fact that someone entered them like this. I need to make my data smaller by grouping them, but only if they are close to each other AND have the same elevation (to be sure that I've grouped points standing for the same building.Here's example which I've been able to achieve for now using PostGIS only:select geom, point_id, height_ft, elevation_ft, obstacle_type, clst_idinto output_table_namefrom(SELECT geom, point_id, height_ft, elevation_ft, obstacle_type,       ST_ClusterDBSCAN(geom, eps := 0.0003, minpoints := 1) OVER() AS clst_idFROM   (select geom, point_id, height_ft, elevation_ft, obstacle_type from input_table whe

I want to know how FmeServer sets the relevant parameters of ESRI Reprojector

ESRI Reprojector failed in FME Server

I have features that I'd like to create one row per Precinct and the create an attribute for each Contest values assigning the Votes value to each of those new attributes. I have looked at the Attribute Exploder, the Aggregator, the List Exploder, etc. I'm a bit stumped. Any suggestion on how to accomplish this?  Something like this: Thanks for any help!

Hi everyone! Is FME 2013 compatible with Win Server 2016 or 2019 ? Thanks in advance.

Hi, I've written a very simple FME script to add a field to a feature layer in ArcGIS online. When I run my FME file it say my translation was successful however, the field does not get added to my feature layer. I've tried both the 'INSERT' and 'UPDATE' options in my writer.  I recieve the following warning message in my log: "ArcGIS Online Feature Service Writer: Attribute 'MyField' on feature type 'MyFeatureLayer' does not match any field on the corresponding layer/table. The attribute will be ignored". Does anyone know what I'm doing wrong? FME file attached. Regards, Damian

Hi there,I'm trying to figure out how VariableSetter/Retriever works.  I found this article which is very helpful:https://community.safe.com/s/article/converting-multi-line-records-into-single-features However, I'm a bit confused that there're 48 records when setting VariableSetter, while there're 450 records when using VariableRetriever...How could VariableRetriver work to detect&input those 48 rows' attributes into the 450 records?  Great thanks!

I'm using a PythonCaller to derive a database instance string to be used to populate an attribute.  The caller works fine until I introduce a python script derived private parameter which outputs an sde connection string.  The string works if I plug it directly into a reader, but fails if I use it as a macro value in the Python Caller.  The error references a dll but I am using the correct interpreter and all my python scripts (including this one until now) are running fine otherwise.  Any thoughts?   Thanks *note all location specific text is changed to "!@#$%"Error snippet:2020-09-17 13:30:18|   3.4|  0.7|ERROR |Python Exception <ImportError>: DLL load failed: The specified module could not be found.2020-09-17 13:30:18|   3.4|  0.0|ERROR |Error executing string `import<space>arcpy<lf>import<space>fmeobjects<lf><lf><lf>#<space>Template<space>Function<space>interface:<lf>#<space>When<space>using<space>t

In FME 2017 format "Esri Legacy ArcSDE" available but in FME 2020 i am not able to see Esri Legacy ArcSDE.

Hi, I have and ArcGIS Online account containing around 100 directories (Sp1, Sp2, Sp3,...). Each directory contains a feature layer (Sp1_WFL, Sp2_WFL, Sp3_WFL,...). I'm trying to figure out how to create an FME script that will batch process all of my feature layers. At the moment I want to add a new field to each of my feature layers and populate the field with a particular value. I recently watched an FME webinar that suggested using a DIRECTORY AND FILE PATHNAMES reader and a WORKSPACERUNNER transformer however I can't seem to get it to work. Is this the best option to use for batch processing in ArcGIS Online? If anyone could get me started I would really appreciate it.Regards, Damian

I have a few thousand points for which I need to build a line that connects a point to another point or two, based on location.For example, if a type A point is far from a type B point at a certain distance, then build me a line that connects them.Do you think this is possible?Of course I tried with theLineBuilder and could not reach a desired result. 

I'm using Filtertype: Contains, and I would like to add muliple string values to Match Expression, like "string A" OR "string B" OR "string C". I've tried creating a User Parameter, but it didn't work... any idea's?

Hello and welcome to the first What’s Up Wednesday of Fall.  New Trial ProcessNew FME users can download FME and start up a free 7-day trial without having to wait for an emailed activation code, which means they can get up and running in a matter of minutes. After the 7 days are up, they can activate another 30 days by just simply clicking a link in their email. We’ve also updated our trial page on our website, so check it out! FME AR BlogThe world of augmented reality (AR) is rapidly expanding. We just posted a new blog post highlighting 5 ways to view data in AR, including AR x-rays!  WebinarDo you often work with Excel? Watch the webinar tomorrow about 5 ways FME can improve your Excel data.  While you’re on the webinar page, sign up for a webinar offered by one of our partners! FME HackathonThe voting for the FME Hackathon is now closed. Thank you to all who submitted projects and voted. The results will be out shortly! If you want to see the awesome projects, check out a recordin

I am using FME Desktop. For my data source I am using MSSQL_JDBC_NONSPATIAL_2. I am reading the data from the data source and copying it into the Socrata platform using the Socrata writer. I copied the first four lines of command line code, pasted into notepad and saved it in the same location as the FME file. When I run window task scheduler. In command prompt, it reads. Reading...Emptying factory pipline...Translation was Successful Then get the following message directly below it.C:\\drive........etc.''--SourceDataset_MSSQL_JDBC_NONSPATIAL_2' is not recognized as an internal or external command, operable program or batch file.C:\\drive.....etc.'--DestDataset_SAFE.SOCRATA.SOCRATA2' is not recognized as an internal or external command, operable program or batch file. I cannot tell, if that is an error message and the task scheduler failed or if that is normal? Thoughts

Hello, I have an FME Desktop workflow within which I have a Counter that is set to start at 700,000, but the final three entries are not rendering with a correct value as per the attached screenshot. The Counter scope is local and I do have a second Counter within this workflow that works fine, although I was having this prior to introducing the second Counter (this has a different transformer name, is also local and starts from 1). I have run this workflow a few times now with Feature Caching On and Off, plus have closed all other FME sessions, but am still getting the issue. Has anyone experienced this before? Thanks, RB

 I have a layer with polylines that intersect with polygons where I use the method intersection (Spatial filter). I want to remove those lines where bigger parts of the line is outside than inside a polygon. How should I proceed?BR

HiI have 2 datasets and I want to do an intersection operation after 2 attributemanager transformers. How to do this ?Thanks select ... intersect select ... ==> sql like

Hi all, I have a number of shapefiles covering a range of dates, with each date recorded in the file name. I also have a number of area of interest polygons and I have been tasked with finding out how much overlap there is with each area of interest and each date period.  For each area of interest I was going to create a spreadsheet with the date taken from the corresponding file used as a field heading populated with an area value for amount of overlap. There are instances where there is no overlap between the two files. Is it possible to still take the date from the file name and attach it to the area of interest polygon and populate the field with 0? I have attached some sample data below Many thanks, Matthew 

Hello,I have a program to make that require the use of a PythonCaller. But unfortunately, it looks very different to what I am used to, doing Python work.I have looked up for some tutorials on how the input/output woks, but I have not found anything really useful, or even understandable.Do you have any link for a tutorial that goes further than just launching a PythonCaller ?I need to modify a SHP file, deleting some lines/geometry points and adding some, as well as features. All in 3DThank you

Hi, I have some troubles reading a Feature service within ArcGIS Enterprise Portal, and I get the message: ArcGIS Portal Feature Service Reader: Encountered an unexpected error. The error code from the server was '500'. If the screenshot here is to small I have also attached it. I believe the error happens when requesting metadata from the service as it calls att http instead of https (https is correct for the feature service URL). However, I don't know how to control this, as the connection to the Portal seems fine inside the Reader. I am also able to publish at new feature service to the Portal (which makes me eliminate connections problems). Has anyone experienced the same thing?

Is there any way to create Document Set using SharePointOnlineConnector ?