Best Answers

I have two datasets:1) DBF1 - It contains demand and patterns corresponding to a particular ID2) DBF2 - It contains the factor corresponding to each PATTERNI need to create a new column for each type and add the factor corresponding to PATTERN_ID, otherwise the default factor is 0.The output result result would look as follows:I tried using Feature Merger, but I felt that it would require multiple Feature Mergers to achieve the same.I even tried Inline Querier but it does not permit more than one SQL statements.Is there an alternative of doing the same

Hey Everyone,  i am trying to read some INSPIRE uk Land Registry data (.GML)  i have read this very helpfull doc http://cdn.safe.com/training/course-materials/fmeuc/Complex-GML-manual.pdf  in this file, it says i need to load a local Custom .XSD i have downloaded the FMEDATA2014 folder but i cant seem to find the Schema they use as the example.  can anyone point me in the right direction to use the .XSD that they use in this example,.  cheers, thanks alot for your help  For your reference https://www.gov.uk/government/collections/download-inspire-index-polygons

I have data stored across multiple DBF files.DBF1 contains data stored as follows (sample):ID ---------DEMAND-------PATTERN1123-----------5---------------0.34553456-----------3---------------0.32122322-----------2---------------0.2112DBF2 contains data stored as follows (sample):ID----------------ZONE1123------------ZONE13456------------ZONE22322------------ZONE1TOTAL_DEMAND for a particular zone is calculated as the sum of products of the demand and pattern for all the ID that lie within that ZONE.Ex. for ZONE1(which contains 1123 and 2322), TOTAL_DEMAND= 5*0.3455+2*0.2112I need to create the final results tabulated as follows:ZONE-------------TOTAL_DEMANDZONE1-----------(calculated as above)ZONE2-----------(calculated as above)The task is easier with VLOOKUP in excel, but I am not able to find suitable transformers to do the same in FME. Please suggest a suitable method.Suggestions regading use of a programming language(such as python) to achieve the same are also welcome.PS- Hiphens

Hello,I was testing some stuff on the latest version of FME Desktop (2017.1) with the twitter transformer but all the results where redirected to the "error" port. I automatically checked ou the log file to find the following error comment in red: Tweeter_Tweeter(TwitterFactory): Due to a change in the Twitter API, all Twitter transformers are non-functional. Updated transformers will be released with FME 2017.1.1Well with all the frequent changes in the API's I believe we have no choice but to wait for 2017.1.1 .CheersLyes 

Hello, I have a script that is creating an email notification via FMEServerEmailGeneration. I am feeding that to a topic through the FmeServerNotifier. Works perfectly fine. I have monitored the topic and the notification comes up. I set up an email Subscription using the following information: https://knowledge.safe.com/articles/1455/configure-fme-server-services-to-use-gmail-1.html I keep getting this error when I try to save the subscription. I have checked if firewall was blocking port 465. No problem thereFunny thing is. This worked once. I was able to save the subscription. I tested it out by running the first workspace and an email was sent correctly. I opened the subscription up and made a change to the subject line only. Ever since then, it stopped saving. And no email is being sent. Can anyone shed light on this temperamental issue? Any help is appreciated. Thanks :)

Hi, I'm creating a transformer and getting an XLS output starting to write on row 2. I've successfully set a template for the header and format, however I need to write specific data such as date or file description in the top row.  How can I write the Document title on cell A1, Author on cell B1, DDMMYY on cell C1?

I recently noticed that the beloved Logger transformer – number 49 on the popularity list, as of this writing – also has a very interesting alias.Behold,.. the Lumberjack transformer!Next time you are debugging your workflow, why don't you try throwing some Lumberjacks at the problem?Which has me wondering... Are there any other aliases out there which are equally amusing? Or what transformer do you insist referring by its alias rather than its "proper" name? What alias do you want to see!?

Hello,I have some data in Shape File format that when read into FME the field type changes from Double to an encoded attribute. See the below screen shots from both Arc Catalog and FME's reader transformer. Below is the printout from the log file. So my end goal is to use the "getAttributeType()" type method to perform some data renaming using the attribute type. So is there something I'm missing with the Shape File Reader or Shape File specification in FME?If I import the data into a File Geodatabase it works fine where FME will maintain the field types.Attribute(encoded: fme-system): `Length__fe' has value `10'Attribute(encoded: fme-system): `Width__fee' has value `3FME Build information below:FME Database Edition FME 2017.1.0.0 Build 17488 - WIN32.Any help or information as to why FME does this would be very helpful!

I have a set of data that contains on each row a highway, start_mp. I want to find, for each highway, the min(start_mp) and the max_start_mp and combine them into a single row of data ordered like: HWY, MIN(START_MP), MAX(START_MP), other attributes.

I converted FME server DB from default to Oracle in FME server 2017.0.1.1. Due to a notification bug in this version, I am upgrading to the latest 2017.1. I am wondering if I still need to do the restore from the backup. I would think I just need to back up the config files, particularly fmeCommonConfig.txt, uninstall 2017.0.1.1, install 2017.1, change Database connection in fmeCommonConfig.txt, restart the server/core/db, everything will just magically work fine. Is this correct?

Hello,   Is there a way to check if a feature class exists in a file geodatabase . If not , throw an error .   Is this possible ?

I'm trying to create (FME-)features from a JSON-ouput (source: JSONFragmenter).I am not able to subtract/expose "geometry" and can't figure out why.My JSONFragmenter parameters are:JSON Query: json["features"][*]Attributes to expose: id geometryCan someone help me out ?Example of JSON-output:{    "type": "FeatureCollection",    "totalFeatures": 1681523,    "features": [        {            "type": "Feature",            "id": "GBG.23662",            "geometry": {                "type": "Polygon",                "coordinates": [                    [                        [                            134465.638337,                            192310.473928                        ],                        [                            134465.881025,                            192308.624072                        ],                        [                            134470.076353,                            192309.29684                        ],                        [                     

Could really use this function extensively, but almost all our data is Date variable - eg Groundwater and chemistry. Is there any news about fixing this bug? Eg FME 2018.Gecko On. Gecko Up.

Hello... What transformers would I need to extract the Well-known text (WKT) from the following oData entry? Thanks!{ "id":"97051464","GeoInstance":{ "Geography":{ "CoordinateSystemId":4326,"WellKnownText":"POLYGON ((-111.854 54.5259, -111.738 54.0571, -111.738 54.0571, -111.086 54.219, -111.086 54.219, -111.145 54.4751, -111.145 54.4751, -111.854 54.5259))","WellKnownBinary":null } }

Hi FME'ersI am pulling together a dataset containing the nearest three of each POI to an address from a list of addresses. E.g nearest three schools, nearest three recycle centres etc.I have used the NeighborFinder with the address feature type (Base) and the Schools feature type (Candidate). All works well but as I said, I need to find the nearest three of different feature types. Is there a way of passing multiple feature types into the candidate port of a single NeighborFinder or do I have to use a new NeighborFinder for each POI feature types? Thanks,David

Hi,I am using FME2016 1.0.1 Desktop, and have encountered, on random occasions, a strange occurrence with the TestFilter transformer.I can't replicate it as it only happens randomly, but sometimes, after I have added a couple of tests into the TestFilter, a yellow right-pointing triangle appears on the top section of the transformer as well as coming out of the TestFilter streams. Whenever this happens, the workbench fails when I try to run it. I then have to delete the TestFilter and recreate it. Usually the second time it is recreated with just with the yellow triangles coming out of the different streams, as expected.Is this a bug? Has anyone else experienced this?Thanks

Folks,Pardon my nomenclature, I suspect that's part of my problem.I've been adding Mapinfo Readers as I've needed certain tables to be converted to CAD. That's left me with a list of 10 separate readers in the navigator.Previously when I did something similar for MI > GML I just added ALL THE TABLES in a single Reader as a group.Changing data sets is snap you just open the new set.With the individually added one-reader-per-table I need to go into each Reader and open the corresponding table.Is there a way to "group" these readers so I can open the referenced tab files as a set?

Hello,I have our own FME plugin which works fine on FME 2016 and 2017.On FME 2017 I see "Where Clause" and "Select statement" added to Parameters tab of Feature type dialog (dbl click on Reader). See the pict below:Question: do you know what changes / additions shall I make to my plugin .fmf file (or any other file(s)) to enable these "Where Clause" and "Select statement" settings for my custom plugin as well?I checked "oracle_spatial.fmf" but do not see what exactly code causes Oracle Spatial plugin to enable these two settings.Thanks!

Hi There,  I am using the UpdateDetector to update an ArcGIS Online feature service that is part of our open data catalogue. My workbench is fairly simple and just reads a dataset out of SDE runs it through some transformers to reproject it and then rename/drop some fields. It writes this dataset to a staging file geodatabase as an archive. Using this archive as the 'Original' input in the UpdateDetector and the features from SDE as the 'Revised', everything gets sent throught the 'Updated' port despite no changes occuring. I poked around with the parameters and found if I removed the geometry matching condition things got sent through the 'Unchanged' port as I would have expected.  Would anyone be able to enlighten me as to why this is happening?  Warren

Hi,I am trying to build a network using the OSM roads dataset. From this i would like to extract all roads within a set distance from a point. This should not be a simple as the crow flies buffer selection but by road distance on each road from the point.Thoughts?

When using the FME Quick Translator to convert CAD from Autodesk AutoCAD Map 3D Object Data to Esri Geodatabase (File Geodb ArcObjects) as raw relational static schema conversion, tables with "_od_table" are created. When using FME Workbench using the exact same settings, the "_od_table" are not created. How can I replicate the production of these tables using FME Workbench?

Hi,I'm trying get a workbench to load 1000000+ features from a WFS version 1.1.0 with a download restriction of 10.000 features. Currently version 2.0.0 is not supported by this service.I would like to know if it's possible to download those features in a similar way 'pagination' does for version 2.0.0. I understand this is not suppported in version 1.1.0. I have tried to set parameters 'Max Features', 'Start Index' and 'Count' within my WFS reader with no luck. Same features are downloaded every single time.Is there an alternative way to achieve this ?**EditWhat am now trying to do is to achieve this with HttpCaller + a custom 'Loop' transformer.However I'm stuck trying to configure this looper...