Best Answers

Hello, We're experiencing issues with google sheets v4 writer adding large amounts of blank rows to the bottom of google sheets. It eventually causes the writers to fail due to size.  Thank you!Robyn

Is is possible to expose a shapefile's FID field?Shapefile readers do not list it and I can't find how to expose it.I need to store that field's value in a control field to keep track of the original features.

Hi,I imported a .DWG file with 2500 area features and want to assign them a colour to get, lets say, grey areas. I found this article and tried to apply this solution with the DWG styler in FME Desktop 2021. However, only my lines get the chosen colour, the areas remain the same without any colour. See attached my DWG Styler settings and a screenshot of my dataset. Any ideas? Current output:DWG Styler:

Dear smarter people than me -I have a cad files with layers that start with either A- or C- and then one basemap layer called Mad_PARCELS. In my reader I only want to read the A- and C- layers. How would I query this out in the Merge feature type using regular expression. Or how do you combing two wildcard expressions? I can't really find any good documentation on regular expression examples. TIA 

how to change coordinate min extent and max extent to new coordinates ?i would like to move polygon from his coordinate to new coordinates .i have used attribute creator to change x min and x max and y min and y max ,but i found it changes the coordinate as attribute but i want to move the polygon from his main coordinate to new coordinates.could someone help me ,how i do that ? FME 2018

I am trying to update an ESRI SDE database with data from an ESRI GDB. The matching key between the two datasets is GlobalID. I use an ArcSDE writer and FME 2019.1.Settings in the Writer:When I try to update or delete data in the SDE, I get an error like the following:No rows matched UPDATE query to table/feature class 'XXX' where upper(GlobalID) = N'{C1BD1C13-4C4F-4C05-B3D8-F051F7B0A33F}'The GlobalIDs do exist in the SDE database! I have checked this multiple times.I can update data between two GDBs with the exact same data without problems, so I suspect there is something in the way GlobalIDs is read in GDB vs. SDE databases that do not match. I have tried adding/deleting the brackets {} on the input data using AttributeTrimmer with no luck. The "N" before the GlobalID in the message is not present in the data, and I have no idea why it shows up here.

I am hoping someone may have suggestion as to why a FeatureJoiner fails to join on 1 attribute only.Left input: table of records, including CouncilRegion attributeRight input: polygon feature class with Region's NameThe transformer successfully joins all records from the left input table, to the feature class..., apart from the table records in "Hawke's Bay"The join is successful for all other records. I have trimmed any potential white space at the end of the attributes.Anyone can think of where the problem may lie, what test I could do to ensure Hawke's Bay records do join?Many thanks

I'm trying to read data from attribute enabled feature classes, but FME is defaulting to using my ArcGIS 64bit background geoprocessing installation to read the data, instead of my arcpro installation. This is solved by un-installing 64bit background geoprocessing, which means FME can only find the arcpro installation, which it then uses and reads the data. Is it possible to tell FME which to use manually, so background geoprocessing does not need to be un-installed?

Hello, I am having difficulty getting the SHAPE field in Oracle to populate correctly. Features are 3D in FME, but the features SHAPE in Oracle are displaying as 2D not 3D after FME translation. How can I resolve this?

A customer defined a project in SoapUI. In the documentation, everything is explained to setup the connection to a keystore, using a password for the JKS certificate. This works well in SoapUI. Does anyone have experience with setting up this keystore in FME? How can I setup this web connection?

Hi there,is ther any possibility now (i saw the idea about a 3d Slicer) to slice a solid with a planar area (e.g. a bounding box) a few times with different elevations?For example ....one slice after 1 meter, 2 meters and so on....?Any helps? GreetzFranco

Hello, I need to uninstall tjhe earlier version of FME 2017.0.1.1 but the uninstaller in windows requires the fme_eval.msi file which I do not have anymore. Where can I get it?

Hi,I'm trying to color a raster based on slope angle values.I want to color the raster in intervals of 0-19, 20-25, 26-30, 31-35, 36-40 and 41-60. Low value = Green, High value = Red.So far I have used the RasterSlopeCalulator to calculate slope angle, and then the RasterExpressionEvaluator to color the points, but I can't seem to color more than one interval at a time. Is there away to merge the different colored rasters with the RasterMosaicker, or can I just tweak my IF-expression? OR, does anyone have a better solution for this?

I am using a pythoncaller to access Zoom API to download unique meeting IDs. The code is:import ssl import http.client import zipfile import fme import fmeobjects # Template Function interface: # When using this function, make sure its name is set as the value of # the 'Class or Function to Process Features' transformer parameter def processFeature(feature):   pass   # Template Class Interface: # When using this class, make sure its name is set as the value of # the 'Class or Function to Process Features' transformer parameter class FeatureProcessor(object):   def __init__(self):     pass   def input(self,feature):     self.pyoutput(feature)   def close(self):     pass   #Setting User Parameters MeetingID = "?????????"   conn.request("GET", "/v2/past_meetings/"+ MeetingID +"/instances", headers=headers)What I would like to do is set MeetingID to feature.getAttribute('SCO_Zoom_Meeting_ID__c') where that is a value returned from a query from my database.  I would appreciate any help. If 

I have a pointcloud.las and I would like to apply some R functions on it using the lidR package. I'm having some hard time figuring out on how the pointcloud should be formatted, or passed on to the data.frame within the R Caller?Same goes for grabbing the output.Any clues are much appreciated

We are using FME desktop 2020 and server 2020. We have a fme server job submitter transformer that creates child jobs to perform a data load. Each of these creates a warning in the system messages "Job 3117686 specifies a priority, but job priority is no longer supported. Use job queue priority instead. Please see: http://fme.ly/KB72058"Looking in the transformer the job priority still exists (although we use job queue specification) and i cannot remove this value. I noticed that at some stage it had been set to 75 but I cannot remove it, only set it to 100. Is this sufficient?

I have used snipper to get the starting points of the lines, then I used NeighbourFinder to find the nearest line to the starting point, but i want to exclude lines with same id as my point.. It is possible with Postgis, but know that I got a license I prefer FME if possible.

PL.shp with attribute 1 Excel with Attibute 1 and Attribute 2Attribute 1s relateI have AttributeFilter set for Attribute 1 to extract Attirbute 1 from PL.shp I need to relate Attribute 1 to Attribute 2, which was not in PL.shp, but is in a related Excel Once the relate is attained from 1 and 2, I need to create a shp that retains the name of Attribute 2 which is then written into a folder with Attribute 2 name.  This will have to be done 200 times, so how can I efficiently get from reader to writing 200 shps that need to be in attribute 2 named folders?  Then from there, the shp needs to be created into an excel that is placed in attribute 2 named folder.

I'm writing and IFC file and I am writing objects into IfcProxy as there's no other fitting IFC Type at the moment. To better define the type, I am using the default ProxyType attribute. When I write ProxyType as attribute in FME, the IFC file breaks. I can see the information added in the file but apparently the syntax is wrong. The FME output looks like this:#674=IFCPROXY('b4I2bLVTRhe0Uu99isXLTw',#24,'Stone | CCC','Wastewater asset ID: cac582d1-373d-4ff8-bada-9727e139562a',$,#673,#672,.Sewer.,$);In this case ".Sewer." is the ProxyType value. Then I change the IFC file to contain this instead:#674=IFCPROXY('b4I2bLVTRhe0Uu99isXLTw',#24,'Stone | CCC','Wastewater asset ID: cac582d1-373d-4ff8-bada-9727e139562a',$,#673,#672,'Sewer',$);After this change (replacing . with ') the IFC file works and the ProxyType information can be read. Is this a bug or a mistake on my side?

Hi everyone,we have installed the 2021 Version already but now we don't know how to select multiple attributes in StatisticCalculator. In earlier versions i.e. 2019 it has been possible to select multiple attributes by clicking on the 3 points, unfortunately I can't find this option in 2021 Version. Do I have to select all my 100 attributes if I need a statistic about them? 😖  Is there any possibility? Kind regards,Sandra

Hi all,I'm looking for a way, to build a report using the HTMLReportGenerator, but the workflow must first kick off with a parcel of land being selected. Is there any way to do this via the FME Server? I know there is the ability to draw a polygon to initiate, but if we were wanting to start it by selecting a specific parcel of land, which is within our Cadastre dataset (or any other dataset for that matter). Any thoughts? The theory is to be able to specify a parcel of land, for it to go through and perform a series of checks against various datasets so that it can speed up the manual process of our users checking it against Environmental factors, planning zones etc.   

How do I avoid "Unexpected input" error when I change a shapefile in the reader? The message I get in part reads, " During translation, some features were read that did not match a reader feature type in the workspace".

Are FME Desktop and FME Server 2021.0.2 compatible with MSSQL Server 2019? Thanks for any reply!

We have a set of DWG files covering our geographical area. Sometimes we need to supply contractors with a subset of these files. The files are named by their map reference. We can generated a list of the required files using our GIS. So we have an Excel file with a list of these tiles in, which are also the file names of the DWGs. I have built a Workspace in FME 2020.1 to read the Excel file, construct the path and filename, and pass it to the FileCopy Writer. This successfully copies the files to a folder, but when I try to get it to ZIP the files, I only get some of them, and this message appears in the log: 2021-05-17 17:22:04| 13.4| 11.2|WARN |MULTI_WRITER: Skipped adding of some files to zip file 'X:\\SomeFolder\\selected_DWG_files.zip' because they already exist I don't understand the error because all the DWG file names are unique. I assume it's referring to the ZIP file, but I don't understand why I get varying numbers of DWG files in the ZIP each time and w

Hi with a floating license setup, is there a way to manage licences in use? I.E kick specific, known inactive sessions off to free up licenses?