Best Answers

Hi all,I've got a question about integrating ArcPy in FME. It would appear that FME won't let me to read in multiple features and process them using ArcPy functions through PythonCaller. This can be easily done outside FME with one line of code such as:arcpy.LocateFeaturesAlongRoutes_lr(feats, rts, rid, tol, tbl, props)What I would hope to achieve with PythonCaller is that it can be used just like one of the transformers like clipper and buffer. Not sure anybody else has experienced the same issue?Thanks!

Does anyone know how you merge lines with the same ID together but hold the attributes from the line with the longest length?

Hi, MapInfo writer is populating -9999 to attributes which have been manually set as integer or float and is empty. Cant figure out why?  Thanks,Ashish

Dear FME friends,I am using FME 2016 64-bit 16174. My workspace throws up an error with the following message.0.0|ERROR |No specified layers were found in MapInfo Dataset I removed the readers and inserted them again. Still do not read. Any idea?Thanks in advance.

Hi,  We are writing to a new geodatabase with FME 2012.  Geodatabase Error (-2147219115): The row contains a bad value. FileGDB Writer: A feature could not be written.  Has anyone experienced this error before. Basically the schema is written but no content is populated.  The data is viewable mid-translation in the Universal Viewer.  Thanks,  Annette

Hi guys,I am trying to find a way to get a list of matched and unmatched fields between two datasets. The situation is our agency needs to reguarly download data from external sources and after download we need to check if there is any schema changes on the newly downloaded data.Thank you!

I am attempting to make a spatial relation between a point and a polygon file. The point file holds unit level address information. This is a point feature class that will have a point location for a street address. For example, 234 First Street will have one point representing it. However, in this point file, if there are many Units at a single street address, there will be many points lying on top of each other. Say there are two units at 234 First Street, there will be two points directly on top of each other, say, A-234 First Street and B-234 First Street. The polygon file holds all of the parcel information. This parcel information has the zoning and parcel information attached. Say, Parcel A is zoned R1, Parcel B is zoned R1 and RR2, etc... We want to surface this information in our Web GIS at a unit level. Displaying all pertinent info for each unit address individually. We would like to join each single address point to a single parcel. Essentially creating a many to one relati

I regularely see the following line in my log-windowprocessing [#####] elements with mode CLASSICSometimes I stop and wonder about this, so now I thought it time to ask 'the world':What does this mode CLASSIC mean, and are there any other modes?Kind regards,Martin

Hello there, I am trying to set up a workbench that will send automated emails via fme server. We "publish" data daily and I am looking to create a script that will basically read from a database (that has details of publishing) and send emails to a recipient depending on the destination (folder) where the dataset had been published.The issue is sometimes multiple datasets are published to the same location. I don't want a separate email for all of them. If there are 10 datasets published to one folder, I want one email sent detailing the 10 datasets. Here is what I have set up for the workbench. The top part (outside of the red box) sends email by reading from SQL with some modifications along the way. The information in the email is a combination of the following attributes DATRECORD, FILENAME and DIRECTORY. In the example below, 91 emails were sent. I want only 15 emails send based on the grouping by the DIRECTORY attribute with the same information (all the DATERECORD

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 } }