Best Answers

Hi Folks,Is there a confirmed release date for 2019.2?I understand that this version support ArcGIS Pro 2.4 Python.Kind regardsSteve

I have an input table that looks like this(input table):Important here is that this table can change in terms of number of rows and names. So the next time the model runs it could have 5 points or 10 or 1, with random names. Names are never duplicated. Based on the input table my fme model then creates an output table as this(table2):I want to create a new table based on the same parameters, with a schema like this(table3): So each row in table3 is a unique date form "DateProcessed" and each value from the coulumn "Name" from input table will get an own column in table3, containing the corresponding DistanceToIce value. The tricky part here is that I want this to happen dynamicly, so that the number of columns that will be created in table3, and their names will follow the input table.  The data will never get large, maximum 10-20 points/names and 14 dates. So recreating Table3 from scratch each time the model runs would be fine. Have read a couple of other answers

Hi guys, I have the following attributes:783784AYHI would like to add 1 in front of any attribute starting with 7 and avoid adding to another field. What would be the best transformer to use for this? I have tried and tested the stringpadder but can't seem to get it working. Any help would be great.

Hello all,I have a TestFilter that directs my input data into multiple branches for further transformation and I have dozens of test conditions within this TestFilter, similar to below:If Test condition @Value(field1) = A to Output port 'Road'Else If Test condition @Value(field1) = B to Output port 'River'Else If Test condition @Value(field1) = C to Output port 'School'etc, etc..... Is there a way i can then use these port values to replace the original input attribute value for this field? For example: Replace all attribute values of 'A' with 'Road'Replace all attribute values of 'B' with 'River'etc, etcI'm trying to find a way of avoiding having to create dozens of repetitive transformers after each port to make this attribute value change and hoping to reuse the effort made thus far with in creating the existing TestFilterDoes anyone know if this is achievable?TIA,R

Hi,I have updated my FME Desktop 2018.1 to FME 2019.0 and my workflow writing excel files based on a template file stop working. I was able to go around missing conditional formatting with few ExcelStylers. However, I am still missing the print layout which I have defined in the template. All required formatting stays in the template sheet, but is not distributed to the sheets written by FME. What have 2019 version changed and how can I use my template file again?

As stated in the title,I want to compare two schemas to see if they have duplicate field names.My idea is to use the Change Detector, but i do not know how to expose field names from an reader Any thoughts?  

the problem when i see data in pgadmin i cant perview data correct . however it is shown in fme inspector fme2019.1

Hello Team,While downloading a file from trimble cloud connect through HTTPCaller we are getting following error,SSL connect errorcan somebody help me to get out of this issue. Till yesterday it was working fine all of sudden today all the scheduled jobs were failed due to this issue.Trimble side we have a valid SSL certificate.Thanks...

Hi,I have 2 shapefiles. One file contains road names and another contains locality name. In Road name file the names contain Locality names as well. is there any way I could identify if the names of the locality file. is available in road name file Please note that the words may not be exact. Here the reference file is locality and the target is road file. Any help is well appreciated. Thanks in advance

Hello, have a excel sheet with more then 20.000 records and only two columns.  I want to divide the two columns into 7 columns: The problem now sits in the PART_COLOR, not every row has a color, see my result: Is there anyone who can help me with this "little" problem? I will explain what my workflow now is:StringSearcher: I search for the string "SET NR001" in the Description column. So I only get this value's instead of all the other ones. (about 90 different parts).AttributeSplitter: split the Description column on every "space" and put them in lists.AttributeManager: create outputs for every list.AttributeCreator: create the different outputs for the different inputs, for the "Name" output I use list5 + list6.  Perhaps I am using the wrong tools, but I am a starting user at FME.

I am wanting to publish around 60 workbenches to FME Server 2019 to run sequentially as a single scheduled task, however cannot find any configuration in the interface which would allow me to do this.Ideally, I would want to be able to select the repository I publish the workbenches to and configure to run on one of our two engines of FME Server. This would save a lot of configuration time instead of having to create a unique schedule for every workbench.Can anyone suggest a solution or advise if this is possible? (Maybe an idea for a future release of server?)Thanks

I have a workbench that writes three mapinfo tables to a folder on one file server which I then want to filecopy the mapinfo tables to a folder on a different file server.I think I've got it to work, but I wanted to confirm.I use three FeatureWriters to write the mapinfo tables to a folder on the first file server. Then all three FeatureWriters go to a single FileCopy transformer.The parameters for the FileCopy are;Destination File Copy Folder = folder on first file serverfilecopy_source_dataset = folder on first file serverfilecopy_dest_dataset = folder on second file serverfilecopy_dest_filename = <blank>Is this correct?I have the address of the first file server in twice, once for the Destination File Copy Folder and again for filecopy_dest_dataset. Do I really have to enter this twice?filecopy_dest_filename is blank, which means I get a red arrow. But it runs anyway. Should I really leave this blank?It all seems to work, but it feels like I have not configured it correctl

I'm building a workflow that has error handling system in it. The idea is to send a message to the client about some specific error. To do that I've created a Custom Transformer that sends message. It would be very handy to extract the Transformer Name and send it as a Error Code. In that way I can avoid typing an Error Code as a parameter value.  On the attached image you can see an example where ER000n are instances of the same Custom Transformer. I wonder is it possible to extract whatever was used as a Name of the transformer (ERR0006, ERR0007, etc.) form inside transformer? Extracted name will be a part of the Error Message that I'm sending to user.  Thanks  

Hello. I have a b/w raster with only one band but in each band there are 255 palettes with a RGB combine each one. Is it possible extract each combine like a RGB combine value?Thanks a lot.This is the example of the issue.

Hello, I wonder if it is possible to choose which tab will be the active one after the creation/update of a Excel workbook with the Excel Writer.In my workspace I update a Excel workbook in which I have an 'history' tab. This one seems to be the last updated by FME because every time I run the workspace it is this tab that is active when I re-open the file in Excel.What I want is to set active my first tab with the actual data in it so the final user won't need to change tab every time the file is updated by the workspace.Hope the question is clear enough.

Hi all.This is occuring on FME Workbench 2019.1.I'm using an HTMLReportGenerator to create a table that should have 10 rows. However, I get the 10 expected rows, plus many more that simply say "None." (see attached photo). The 10 features come from a SQLExecutor and I've checked the output with an inspector and have confirmed that there are only 10 rows. The HTMLReportGenerator output isn't very telling, but here's a snippet of where the "None" values begin:             <tr>               <td>Point Loma</td>               <td>108</td>            </tr>            <tr>               <td>None</td>               <td>None</td>            </tr>I've tried replacing all instances of<tr>               <td>None</td>               <td>None</td>            </tr>with empty space but that didn't change anything. How can I completely remove these rows from the table? Example photo:

I need to filter out IfcSpace polygons whose Other.Area Scheme Id values are shown as Sections. I can able to filter out these in Inspector's Query tool but I cannot able to filter the same in Workbench after extracting IfcSpace Geometry traits with GeometryPropertyExtractor transformer.

Hello,I want to resize an image. Per example 1000*1000 pixels to 200*200 pixels.I tried RasterResampler, but I only get a degradation of the image, with the same size.Is there a way to do that?This is not my family : legacy from Google Images. In M$Paint I would use this.

I have a dwg file (AutoCad) with apparently no coordinates system. It looks like it is using a sort of arbitrary coordinates.I am looking for a way to Aling that drawing on a CanQ-M8 coordinates system.I know that I will probably need to offset the coordinates, rotate the map and maybe strech or shrink the drawing to make it fit.Is there any tools to do it ?Attached is the dwg drawing that I want to align on the base map (also attached)I only need the layer 41 of the dwg map.Thank youMathieu. 

I have a chain of WorkspaceRunners that I need to bring to FMEServer, but it should still be possible to run them in Workbench as well. So, I created a TestFilter where '$FME_JOB_ID' NOT has a value. If it does not have a value, a WorkspaceRunner is triggered. It fails with the message:Undefined macro `FME_JOB_ID' dereferenced in file `ReferencedWorkspace.fmw'An error occurred during the batch file execution, 1 translation failed. The following error message was raised: #2 : Undefined macro `FME_JOB_ID' dereferenced in file `ReferencedWorkspace.fmw'The parameterFetcher in the 'ReferencedWorkspace.fmw' causes this error.  The Workaround I made was to put a value 'N/A' in the 'FME_JOB_ID' of the ReferencedWorkspace (which also contains a TestFilter but with '$FME_JOB_ID'  NOT has a value or = 'N/A'). So two questions:why do I get the Error message in the first place? The Main procedure does not require the 'N/A' value for the FME_JOB_ID. It seems that the WorkspaceRunner does not resolve

Hi Trying to read an Oracle table containing one (Oracle limit) "Long" datatype field The field only brings through the first 8000 characters into FME (these are typically upwards of 9800 characters in this DB) As an aside into Access (ODBC) it reads more (8135) but not all of the field Does anyone have any idea how to bypass this limit and bring in the huge field? Thanks Adrian

The reader IFC with data view for Revit greturns an error message when used on fme cloud:Could not load module '/opt/fme-engine-2019/plugins/writer_keyword.so' : /opt/fme-engine-2019/plugins/writer_keyword.so: cannot open shared object file: No such file or directoryIt's working just fine on desktop FME(R) 2019.1.2.0 (20190829 - Build 19630 - WIN64)But not on FME Server 2019.1.2 Build 19630 - linux-x64Any idea?Cheers

Hello, Is it possible to configure auto resubmit job after fail on fme server using fme 2019?

Hi,I try to use the Rcaller in FME to perform zonal statistics. My input is a shapefile and a Geotiff, however i read that the Rcaller reads it as a dataframe when imported into R. I tried to convert it in the Rcaller back to a shapefile and raster (with rasterFromXYZ('dataframe) and SpatialPointsDataFrame() ), but i got a error that the X and Y coordinates are missing and I cannot figure out how to include them?In R would normaly perform a zonal statistics in the following way:setwd('location\\files) library(raster)  library(rgdal) shape <- readOGR(dsn = "Shapefile.shp") DEM <- raster("Elevation")#extract raster cell count (sum) within each polygon area  ex <- extract(DEM, shape, fun=sum, na.rm=TRUE, df=TRUE) My FME canvas looks at following:Can somebody help me with an example or url reference to one? Thanks for considering my request!

Hi there,I'm trying to get grid locations from a polygon fgdb feature class attribute for the start and end of a fgdb line feature class. The attribute I need to put into the line data is a GRID ID (shown below). I've created two different scripts that seem to work, although all the writers have null values in both GRID_ID columns. I've attached a screenshot of the data in arc, and my workspace. In the second attempt of the workspace, the clipper doesn't output any features inside it.