Best Answers

Hi All,I develop a workspace to transfer the mdf to gdb but the feature class in file geodatabase have the same name of the feature in mdf.For example I have mdf “B” containing five feature class when I transform them into file gdb as you can see belowIs there any way to change the name of feature class from “dbo_COMMUNITIES_point” to “communities” by adding a transformer to my workspace? Best Regards,Rawan

I recently just upgraded to the newest beta version and noticed that some of my FME Hub transformers were stated as "incomplete". I looked at the parameters and couldn't tell why it wasn't working anymore. I then rolled back to the latest release version and had the same issues as well. Is there an easy way to trouble shoot why some functionality would break? I just ended up rolling back to a previous version that works correctly for the time being.The transformers that are giving me issues are the RegexAttributeSplitter and AttributeConcatenator.

I've got some CSV Writers from FME 2016.1 and I obviously want to take advantage of the new CSV2 Writer. I thought I could make life easy by editing the Feature Type properties and changing the Writer from CSV to CSV2 but FME ended up crashing. So I presume creating things from scratch with the new Writer is recommended way...?

Hey Folks,how do you set an output attribute in a custom transformer. I could always just use an attributecreator after and set attribute a to the output field. but would rather handle it in my custom transformer.Attribute A = 1 before transformerAttribute CustomOutputValue = 2 after transformerAttribute A = 1 After transformerbut I want Attribute A = 2 after transformer.note - the numbers in above example are simplified.Thanks,Doug

Hi,I'm wondering how to modify this so that output schemas match those input?Regards,Richard

Hello, Is there a way to limit the time or number of GET requests on the HTTPCaller so that I'm not overloading the server I'm requesting data from? I'm envisioning something like:Only send 10 requests every 60 seconds until all records are complete

I have a KML writer with dynamic attribute definition. The writer always writes a KMZ file but I want it to write a KML file. When you use a static writer you can specify the filename and extension in the writer as either ".kml" or ".kmz" but when it is dynamic you just give the path to the folder and "fme_feature_type" as the feature type name. Also there is no suffix on which to fan out.How can I get the writer to write KML?Thanks

Hi, I am trying to automate a process whereby I download a CSV from an opendata site (a list of schools from our UK Department for Education) and process it to create a shapefile for the area I'm interested only. I can download the data manually then run my workflow which creates the geometry and clips to my area, etc... but the automated download via the url is the bit I'm struggling with.The source data is uploaded daily and posted as a link which url is dynamic to reflect today's date. This is today's link: http://www.education.gov.uk/edubase/edubasealldata20170502.csvI wanted to create the workflow and run the it every week or month as scheduled task but it needs to know the date it's running.I've tried to use :1. CSV reader with the url in the path -it works fine when all as above. Then I amended it in the text editor to replace the date with @Timestamp("^Y^m^d") * . It reads the schema and have all fields / columns "green" but fails on

Hi, I have a large number of space delimited XYZ files (*.xyz) and I would like to find a way to determine the extent of the files. I don't want the minimum bounding rectangle, but the actual boundary as it would be if I were to join all the outer points of the file together.I thought about buffering every point in the file, then dissolving the resultant buffers, but that is very time consuming so I would like to find an alternative method if possible.Thanks,

I'm working on a test setup that compares two polygon data sets with each other. The end result should be a match on geometry within a 10% tolerance (bigger and smaller) and the centerpoint (inside point) should not be more than 2 meters away. The one on one match with matcher is quite easy and also the test for the 10% tolerance and 2m centerpoint works but i'm getting stuck on the next step. I have one data set that is leading (red is more detailed) and i would like to know if there is a match with the blue set when you combine two or more polygons of the red data set and do the same test (10% and 2m). Is there a way to loop the results at the end so i can use the output from the unreferenced featurmerger and and match them with mutiple polygons from the attributecreater '3 = no 1on1 match' and do the same tests as before. If there is a case that there are two or more matches, how can i use the best match in size?In the end i want to use it on two maps that both have

I want to automate the closing of FME Quick Translator when I run a .fme file. I have a .fme file that is triggered by windows scheduler to run a .fme file. This obviously opens Quick Translator and runs the routine. At the end of the routine the quick translator stays open. Is there a way I can set the .fme file to close quick translator once the routine has finished successfully?Many thanksSeb

Hi i am new to FME,we are trying to set up 2 tier architecture.Is that mandatory to have the file system installed on a separate server (please refer the attached image for the instruction i found online) or it can be on the same web/Application server itself? I assume that this file server is a shared directory and can be anywhere on the network.Thanks,Mari... 

Hello Everyone,I would like to build a workflow that would prompt users to enter a range (or ranges!) of time (HH:MM:SS to HH:MM:SS) that would be used as a filter an Excel sheet for rows within the ranges. Unfortunately, the AttributeRangeFilter will not permit this time format and I do not want to ask the user to convert to Epoch Time themselves. Any helpful advice will be appreciated

Hi,What's the proper syntax for using math functions in XmlTemplater expressions and/or files ?I have an RGB value that I need to split into its R, G, and B components, but I don't want to have to create 3 extra attributes for each of the 4+ color values.I need an output like this: <Color R="red" G="green" B="blue" />I've tried (with attribute "mapinfo_brush_foreground" as my RGB - value = 0xFFFFFE):<Color R="@Evaluate(floor({fme:get-attribute('mapinfo_brush_foreground')}/65536))" G="floor(fmod({fme:get-attribute('mapinfo_brush_foreground')},65536)/256)" B="@Evaluate(floor(fmod(@Evaluate({fme:get-attribute('mapinfo_brush_foreground')}),256)))" />But this yields: <Color R="" G="floor(fmod(16777214,65536)/256)" B="" />So neither none, one, or multiple "Evaluate()" calls produces the desired result.Please help me out in this.And PS: it seems like such math functions are no-go when using file based templates. Is this true ?Cheers.

Greetings to everyone.I need to rasterize some different cartograms.  That means I got some polygons and need to place them on a map and then get image as a result.  Different cartograms means different sizes on real map (in meters), but in result I need equal-sized images (in pixels).  My idea was to use Raster Properties in MapnikRasterizer by changing Cell Spacing parameter dynamically.  For each cartogram I calculate a new Cell Spacing value using Aggregaror -> BoundingReplacer -> BoundsExtractor -> AttributeCreator with some math inside. AttributeCreator add Kmax attribute that contain exactly what I need - how much meters in one pixel and two values for buffer. Then I clip source map (from SASPlanet if you know) using Clipper and 2DBoxReplacer - adding needed buffer to each x and y value at both sides because I need exatly asked width and height no matter of cartogramm geometry. That is my Raster for Mapnik.  At this step all is fine - including all calculated values, th

Dear FME-Users,I've a problem with "RasterCellCoercer", because this transformer don't write pixel values into an attribute.It only works with "RasterToPolygonCoercer" (attribute "_label").What I'm doing wrong?Thnak you very much and best regards.Konrad

I have set up an email notification to fire me an email when the workspace has successfuly run.  I am curious as to how I get the name of the workbench that has run to be my subject line?   Do I need to creat a seperate email notification for everyworkspace I want published?  NOTE: I do not want to use python.

I'm using five Excel readers that are pulling the spreadsheet data from a REST endpoint (URL). The purpose of the model is to combine all five spreadsheets into one output. They have the same schema. The issue I'm running into, is that the spreadsheets will all have a variable number of rows from week-to-week and when I specify the Cell Range in the Reader Parameters as (*:) the writer is still including all of the blank rows below the data for each spreadsheet, so the final output has a chunk of data, blank space, chunk of data, blank space, etc. Is there any way around this?

Is there a way to export a list of scheduled jobs from FME Server to a txt file or some other format?Thanks in advance.

Is it possible to add extra z-value to a point cloud (las) with 3D affiner? I need to add extra 0,507m to my already existing z-values. I'm changing from a local to an national height system but i don't know the parameters from the local one.regards, Anton

Dear FME-users,  I’ve created a GeoTIFF-file based on NetCDF-data.   The problem is the spatial reference. A compare to OSM-data in the attachment shows you, that the GeoTIFF-file is not placed right. The second picture is from Copernicus and right placed.  Do you have an idea?  Thank your very much.  Best regards.  Konrad

Hi all,  I have a vector layer of polygons, and a single band raster. I would like to add a field in the vector layer, and for each of its poygon, fill its value with, for instance, the mean of the pixel value that are inside each polygons. Any way to do this with FME?  Best regards,  Asher

Not long ago, I updated the FME from 2017.0.0.1 to 2017.0.0.2, But today I found that it can't use Esri Geodatabase (File Geodb ArcObjects) format. If I choose Esri Geodatabase (File Geodb ArcObjects) format, FME prompts the error and automatically shut down. And I open workspace that include reader or writer with Esri Geodatabase (File Geodb ArcObjects) format, I try to change reader or writer's parameters, also can appear the same problem. FeatureReader and FeatureWriter have the same problem. I remember in the previous version?FME 2017.0.0.1 64bit?, there is no problem .Also installed the FME 2016.1.3.2 64bit on my PC?Use FME 2016.1.3.2 64bit can read and write with Esri Geodatabase (File Geodb ArcObjects) Without any problems.I also refer to the following URL?I confirm that I have installed [ArcGIS for Desktop and 64 bit Background Geoprocessing].Notes on FME and Esri Versions and CompatibilityDon't know if anyone had experienced the same problem with me. I want to know