General

Hello, I use FME to generate a PostGIS table from a Shape file.When the value of an attribute type real is set =NULL, FME displays it as =0.I don't know if the problem is due to : A bug of FME (misunderstanding of NULL attribute)A problem of the input Software that generate Empty string value : It should not be possible to generate empty string with numeric attributes?Thanks  

after saving the output of my workbench (Geospatial pdf ), i found it is too slow to show the included data inside the pdf and sometimes it is not responding .so my question how could i save pdf file and let the output file working quickly without any problem ?should i change sth in parameter of pdf writer?my expected output as several lines and points inside polygon .another question relates to the output ,lines are not clear at pdf file ,how could i change the scale of output to show lines clear in pdf without zooming . Thanks for help

I upgraded a workspace in versionFME(R) 2019.2.1.0 (20191202 - Build 19813 - WIN64) Reason was to solve a sudden problem concerning fan out on a autocad writer.When scheduled and called trough a windows scheduled batch file it fails to complete the fan out. If i run it direct, the fan out works. So i decided to upgrade transformers,.   Now i get this error related tot the feature ordering across or over all ports. This error is given for all the testers in my workspace! Wh..wh..why? THis does not happen if i run the workspace directly (not trough a windows batfile) Here is the error:                 FME 2019.1.1.0 (20190801 - Build 19617 - WIN64)                    FME Desktop Oracle Edition (floating)                              Permanent License.                      Machine host name is: LDNPVWAPP07

Hi everybody,I'd like to manage FME scripts to GIT or GIT LAB whitout FME Server.First question : is it possible ?Second question : what kind of way to try it ? Thanks for your response. Nicolas

I am trying to Read, and eventually Write, to an ArcGIS Portal hosted feature layer using ArcGIS Pro/Data Interoperability FME(R) 2020.0.1.0 (20200407 - Build 20218 - WIN64. I believe I was successful adding a new service using the ESRI ArcGIS Portal (Template) (see image 1). I tested, which connected to the Portal. When I try to add a Web Connection, I select the service I just created, Authenticate (successfully) (see image 2), but after that, I close the authenticate window and nothing is added to my available web connections, even after restarting FME (see image 3) I'm not sure if I missed a step, but I can't figure out what's going on/not working.

This article:https://docs.safe.com/fme/html/FME_Server_Documentation/AdminGuide/Configuring-Datum-Shifts.htmexplains various methods of configuring FME to work with USA and Canadian grid shift files. However, the company I'm working for routinely works with both USA and Canadian data, so it's not practical to set this value for all of FME. Rather than performing a manual CSMapReproject everywhere it's needed in the workspace, is it possible to define the grid shift file to be used just once for an entire workspace? It would be great if this was available as a setting under Workspace Parameters but there doesn't seem to be anything there....

Hi, I have a few sql executor transformers in a sequence. They are using sql server jdbc driver connections. When I run I get the following notices usually from either the second or the third executor in the chain. com.microsoft.sqlserver.jdbc.SQLServerException: The query has timed out. I have in the past got round this by putting in feature holders which seem to close the existing connection session but it doesnt appear to be working and is affecting workbenches in desktop and cloud. I dont get these issues with using the native sql client but because I need them to run in cloud they need to be on jdbc. Does anyone have any suggestions as to work arounds for this. thank you

I tried running the Class Interface example on this page:https://docs.safe.com/fme/html/FME_Desktop_Documentation/FME_Transformers/Transformers/pythoncaller.htmBut the code as written, (after correcting the indentation) gives me the same area for each polygon.To get the expected result I have to remove the 3rd & 4th from last lines (and re-correct the indents) i.e.:import fmeobjects class FeatureProcessor(object):     def __init__(self):         self.featureList = []         self.totalArea = 0.0           def input(self,feature):         self.featureList.append(feature)         self.totalArea += feature.getGeometry().getArea()         feature.setAttribute("total_area", self.totalA

I'm trying to find an effective way toread in a feature classuse an area on area overlayer with another feature class to split some geometries and inherit attributesupdate the feature class that I read in in the first place with the updated geometries and attributesSo there are two datasets, blue and red. Blue is the data I want to read in, edit and then write out. Red is the data I am going to split it by.I somehow want to take the blue data and edit it and then write it back out to the same feature class. In the below, the green squares are not needed as there will be no change. The orange squares in the centre will stay identical except that one of their attributes will be updated to include the "BOX_ID" of the red box (in this case, the OBJECTID) with which they intersect. The yellow squares n

Welcome to your weekly dose of FME news! FME UC Postponed to 2022For the safety of all our attendees as well as everyone involved, we have made the difficult decision to postpone the FME User Conference to 2022. Save the date for August 23-26, 2020. For more information on tickets or refunds, please see our FMEUC FAQ.  FME 2020.2.2 ReleasedDownload the latest version of FME 2020. Some improvements include:Upgraded CityJSON to 0.7Added Python support for ArcGIS Pro 2.7Shortened generated temp file paths Also, check out the

I need help trying to create 3D lines with slopes. I do have 2 points to create a line but 2 points have different elevation. the VertexCreator and LineBuilder use only one elevation to the whole line. Is it any way to create this line? Jairo Castillo

I have several fmw files that read and/or write to a particular folder structure. But sometimes the location of the folder structure changes servers. So i'm wanting a way to set a root variable for readers/writers so i only have to update the one variable instead of updating all fmw readers/writers. --------------------UPDATE--------------------I need to add, my intention is to have one variable/setting/config that is globally available across all my workspaces. So changing one configuration would affect all workspaces.For example, in a shapefile writer, the dataset location is d:\\folder\\to\\file.shp, but I'd like to change the location to something like $(GlobalVar)\\folder\\to\\file.shp. Where GlobalVar is available across all workspaces.

Example of my database :   I am a beginner in FME, thanks for help !

Hi, I have a generic reader in my workspace which allows me to read in all types of file formats. However, I believe that in order to set the parameters for the different types of file formats, I need to add to my workspace, a reader for the particular file format I want to set the parameters for. I have done this, but I want to now remove the reader from the canvas but keep it in the Navigator window. I managed to do this once awhile ago, but now I have no idea how I did this. Any ideas?

FME 2020: The “GeometryFilter” tool fails to detect objects of “circle” type in AutoCAD, I couldn’t figure out how to filter objects of “circle” type in AutoCAD. The “GeometryFilter” tool fails to catch them. Then how to filter the CAD circles? The data is attached         

To put this into context I have a google sheet which has hyperlinks to photos. It shows the shared link but not the filename. I need to be able to extract the filename (and ideally the directory path from Google drive) so I can relink the photo to the new location. Hope this makes sense

FME 2020: Which tool can be performed to display where the lines overlaps (duplicates) are, I couldn’t figure out Which tool can be performed to display where the lines overlaps (duplicates) are. For example, in the screenshot below, there are 4 lines and overlapped in the place marked in orange. How this overlap can be displayed? the data is attached  

FME 2020: How to get lines extended to centers of circles? In the screenshots below, this is how surveyors draw parcels. What I wanted here is to extend the lines that touch the circles to their centers so that all lines get connected at these centers How this might be performed in FME? Which tool can help on this?Sample data is attached   

I have a shapefile, it is all lines with only two points in each line. Ultimately I'd like to expose the X and Y, start and end, of each line. CoordinateExtractor seems to be able to expose the X and Y of all the points but is there a way to filter that list, like Start X, Start Y; End X, End Y?

I'm trying to create a validation routine that tells me what points are not in their expected polygon. I have two tables with an areaid common to both- one has point geometry (building b) and the other has polygons (area a). something along the lines of the following badly phrased pseudocode!select * from building where building point does not exist in area and a.areaid = b.areaidAll help appreciated! Thanks in advance

Hi Community, I have a road network where roads are defined in road classes (1-5). While comparing the road from two different geometries(local and client), I need to upgrade my road network on the basis of client's road class. In the image attached, the yellow lines are road class 4 and grey ones are road class 5. So, I need to upgrade road class 5 to class 4.In the image shared, the one selected road element (in cyan), needs to be upgraded from the top (hanging geometry) to till the yellow line in the down south, and rest all data remains same.In other situations, one side of the road can be a hanging geometry, so the road selection can be unidirectional to bidirectional. But, the upgradations has to be limited to only one road class update (4 to 3, 3 to 2 etc.,) This is because road class 1 (road of international importance) can directly only be connected to class 2(national/regional importance) and so on. So there has to be a

Hello, I'm trying to extract data from Oracle database with several thousand tables to CSV files.Because of the number of tables, extracting each table to CSV file is not an option. Is there an automated way to read the list of tables from Oracle DB (non-spacial) and extract each table to CSV files? I haven't been able to find any articles or forum questions to do that. Any help will be appreciated. Thanks.

Hello,I am extracting data from a sql DB and exporting as file geodatabase. But when I compare them in Arcmap the data is not aligned it is next to each other but not on top of each other why would that be? I have same projection on both the data sets. ThanksNikki

 I have a .csv table with 35 numeric values in increments of 5 (5, 10, 15,..). I need to create a table that list all possible unique pairings of these values in two columns ((5,5), (5,10), (5,15),...) . I've tried joiners, mergers, and combiners but can't get the output I need. Is there a transformer that would do this?