General

Hello,Does anyone have experience automating the download of data packages from the BC Data Catalogue (https://catalogue.data.gov.bc.ca/dataset?download_audience=Public)? There are dozens of provincial datasets I would like to automate the download of on a weekly basis to keep the data updated for my organization, the problem is that they require submitting a AOI (or mapsheet) and an email before receiving the zipped data package in an email.Thanks! 

Dear FME community.I try to calculate distance between a suit of points like that :For that I make a sorter > counter and I try an AttributeCreator without success.Have you got an idea ?Thanks for your help

want to do something like this in FME Original Table Age  Number 0-10 5 10-20 10 20-30 230 plus  4 Create new attribute with range values or group values in Name field by ranges. The only way I can think of is to use Attribute Creator and use conditions to set up each category range. I am hoping there is an easier way of doing this. Lee!

Hi, i'm trying to run a simple workbench with @DateTimeNow(local) on FME 2018 (build 18578)  / windows 7 French but i get this error: DateTimeStamper: Failed to load timezone data. current_zone() failed: A mapping from the Windows Time Zone id "Romance standard time" was not found in the time zone mapping database.. Please visit http://www.safe.com/supportDateTimeStamper: Failed to evaluate expression '@DateTimeNow(local)'. Result is set to null It works with FME2017.1 running on  Windows 7 fr or FME2018 running on windows 10 fr. Do you know what to do to avoid that?Thank you,David  

Hi Can i know how to convert TIFF into JP2 format in FME. i just created one workspace and it's working, but the problem, i am not able get input filename as in output. 

I've put my list up here https://twitter.com/DaleAtSafe/status/1075887910677766144 -- yep, there's some exciting things in store... 

After the success of the competition last year, we have decided to run the 12 Days of FME Hackathon again for 2018! What is the 12 Days of FME Hackathon?The 12 Days of FME Hackathon is where we give users (that's you) 12 days (starting right now!) to work on and submit your project as a reply to this question. Your project can be anything that you've built with FME. For more ideas and inspiration, you can check out the submissions from last year.Anyone who enters this Holiday Hackathon will be in with the chance to win a one-of-a-kind FME prize pack - containing a Temperature Controlled Ceramic Mug, FME Slippers, FME Sweater, FME Grill Set and FME Tie.To win - your submission must have the most votes when we close the voting on Tuesday,

Hi All,I am doing the feature matching. wherein I have two sources [Line feature] and I am using a distance chopper to chop the line feature at a specific distance and then neighbor finder to find the nearest feature. but I am getting some falls positive in my final output. not sure what is going wrong.In input layers, there is no common attribute which can be used at later stages.Can someone suggest a solution to this? Please Find the attached screenshot herewith. in this screenshot blue line is one source, the green line is another source used for matching. and red lines are output. 

Hello all, I'm just trying to automate a process by creating a DEM with a shapefile which has elevation attribute to it. Once I've got it working with one shapefile I'd like to add further shapefiles. I've tried using the DEMGenerator and the RasterDEM but when checking the output (.tif) in the inspector instead of seeing a raster with a value from 0 to 100 for example it has a value of 0? I can see the data looks fine before it goes into the DEMGenerator and after selecting the attribute with the elevation it appears to then have a value of 0 for some reason so perhaps I'm missing something from the configuration?I can do this in ArcMap fine but I'm just wanting to streamline this process. Thanks in advance

Hey there,I recently tried to run a workspace I created a month ago where I download the latest Sentinel-2 image via the FeatureReader (Sentinel-2 on AWS format) based on an intersection with a shape file. The workspace used to work out fine.Now, the workspace fails early at the FeatureReader with the following error message:Imagery on AWS Reader: Error listing 'http://sentinel-s2-l1c.s3.amazonaws.com/?delimiter=/&prefix;=tiles/32/U/MC/'. Check the reader filters or try again later. The error was 'FMEException: 931363: Imagery on AWS Reader: Error downloading 'http://sentinel-s2-l1c.s3.amazonaws.com/?delimiter=/&prefix;=tiles/32/U/MC/'. Check the reader filters or try again l

ColA ColB 2 a 3 a 3 a 2 b 1 b 4 b 3 c 4 c  I have this above input where I would like to delete the whole group (a, b, c) from ColB, if there is a '2' in ColA in the specified group.For example, if there is a 2 in ColA, the whole group 'a' is removed from ColB (and not just the specified row).

Hi,Hoping someone can help with this. I have installed both 32 and 64 bit FME Desktop on a machine. The UAC settings and some of the local policies were not set properly when I installed, they have since been changed. I was able to register my Desktop FME for my user, but another user account that also has admin rights on the machine shows that the FME still needs to be registered. I have in the past done this and FME was available for all users after registration. What gives? Do I need to uninstall and reinstall now that the UAC and Local Policies have been modified? All other software on this machine works for either user. The reason for two users is that we want to have a service account run scheduled tasks for FME. Which there are currently 5 scheduled tasks set up with the service account and 2 run, the three with FME in them don't.Thanks

How to auto run FME jobs after changing/updating source EXCEL file?

I have a task that need extract several excel workbook , then rename and combined based on a key; The result also write to an Excel workbook which I have a template; My question is how to order the results based on Template columns Names. I can manually re-order them, but I am handling excel sheet with 100 and 300 columns source tables, if I manually re-order, that needs every time to re-order again; See attached image: Template has " ILI Reference Girth Weld"; FME has "NDE Report Issue#" after "Dig Phase #"; I also can read the Template and get the order, but I don't know how to merge to the workflow, also feel redundancy since Writer already reference the Template. Any solution to this issue? Thank you.

Hi All,we are converting SDO geometry to SDE geometry using FME workbench, it working as expected, but sometimes we are facing this issue."An error occurred while attempting to open the table, feature class or relationship class 'SDE.SP_ALL'. The error number from ArcObjects is: '-2147216011'. The error message from ArcObjects is: {The SQL statement was not a select statement} "If anyone come across the issue, please let me know why and when this will occurs and how to fix. Thank you.

How can i run fme quick translator using cmd and perform conversions without defining fmw file.

Hi,I've installed FME Desktop 2018 and have a script that uses DonutBuilder to intersect areas with each others. Before this transformer I have a sorter to sort my areas to get the lowest symbol first. It works OK in 2017, which I just tried on my laptop. The problem in 2018 is that it seems that the DonutBuilder can't handle all the areas that overlap. Does anyone have a solution for this?Regards and thankful for help!/Ann

I need to ensure that the polygons created are in ascending order from the first polygon which is known or can be found. I think there is a transformer in 2018 that can do this but I am using 2016. I have tried using NeighbourFinder and sort by ascending distance which is OK as long as the polygons do not turn back towards the first one.

Hi everyone. Is this a bug in FME Desktop 2018.1.0.3 Build 18552 Data Inspector?p, li { white-space: pre-wrap; }Failed to initialize the reader in the temporary rendering processFailed to create the reader in the worker process for 2D renderingIt happens every time I use the Data Inspector out of Desktop Feature caching. It will load the file and display normal for about 30 seconds but then errors to this message.Thanks,Todd

Newly installed FME Desktop Oracle Edition 2018.1.0.2 Build 18547 - WIN64 crashing on exit. fmeworkbench.exe remains in Task Manager. Event Viewer error shows ucrtbase.dll as a faulting module.FME is installed on Windows Server 2008 R2 Standard SP1. I tried repairing and also reinstalling FME but nothing helps.

So I've asked this question of the FME server team, but I'm hoping someone has a work-around I can try. I want to specify, I don't want to use a table with locations, I don't want to use python to map to the right location either. Maybe there isn't a way to do what I want.So I have some workspaces that run nightly. I want to test them on desktop as well as our development fme server. There's a production fme server as well.For .sde connections: I created a folder (sdeConnections) on the E drive of each of the server environment and the connection files go in there. on desktop, I am mapping E:\\ to a network shared location. The E drive on desktop and the dev server both have connections to development databases. fme workspace authors will use these connections to test their workspaces. They can publish them to any of the environment and data will be read from the right database and will write to the right database. Only issue is that whenever yo

I just discover when choosing to read from an Access database with MAX_FEATURES_PER_FEATURE_TYPE set it still reads the whole dataset before selecting my number of inputs:2018-10-11 12:31:58|   0.5|  0.0|STATS |Storing feature(s) to FME feature store file `C:\Users\paalp\AppData\Local\Temp\visual_inspection_123158\inspector.ffs'2018-10-11 12:36:40| 284.2|283.8|INFORM|Microsoft Access Reader: Database read complete.  Retrieved 1561980 feature(s)2018-10-11 12:36:41| 284.3|  0.0|INFORM|Microsoft Access Reader: Closing `C:\Users\paalp\OneDrive - Geodata\Prosjekter\MD-darwin\BarentsVisual\BarentsVisual.mdb' . Read operation complete2018-10-11 12:36:41| 284.3|  0.0|INFORM|MULTI_READER(MULTI_READER): Done reading 1000 features from 1 readersThis seems very backwards, it first read all 1561980 features, and then it reads 1000 of those. While I'm waiting several minutes for the read to finish. Is this a bug in the reader?FME 2018.1

I am experiencing difficulty while transforming data from ArcSDE or FGDB to MITAB. Reading a <Null> or no value from the reader, MITAB writes it as '-9,999', which is unacceptable in my operations and queries.My addressing database contains approx. 4.5million records where majority of records contains <null> for various attributes (e.,g., <Null> for numeric attributes and blank/no value for string attributes).While writing to MITAB, FME converts represent the value as '-9,999' whereas, I expect the values same as reader (<Null> or blank). I tried using all parameters in 'NullAttributeMapper', that worked well on 'String' values but not on 'Numeric' values.

i'm unable to read coordinate system for some gml files using inspector.srs is also mentioned in the gml file(urn:ogc:def:crs,crs:EPSG::2180,crs:PL-KRON86-NH) but the inspector is unable to read the projection.What could be the reason.

And when you ask a question on Talk Like a Pirate Day (19th September), then you do get to plunder some awesome booty, in the form of an FME pirate badge:So heave to and give three cheers to these old salts: @franco69 @mjoarder_pln @joukojarnefelt @stalknecht @daveapegg @peteralstorp @brianapeters @aron @daniel30enero44 @jayd3vl @AndreaAtSafe @edhere @tirg @kimo @jake @NathanAtSafe @san and @us In short, you all have been awarded the FME Pirate badge for asking a question on September 19th. You are now one of a select group of FME Pirates. It's so select that I don't even have that badge yet.Thank you for taking part in the FME community and for helping to make it what it is. I hope your questions all received great answers.