Best Answers

Hi,I don't find out how to transpose a part of a simple data table.I read a lot in the documentation and this kb about the AttributePivoter and AttributeTransposer transformers or other tips and tricks (with AttributeExploder and Aggregator) but I don't get to use these solutions with my test case.Here is a (simplified) sample of my input data:And here is what I want as output:As you can see, the switch has to be done between the "type" and "month" attributes but I have to keep the student column.I would really appreciate any help because I'm stuck...Thanks,Christian

i am trying to update xml column in oracle and getting errors which i am not able to resolve . need some help hereif the data exists there and $t/row/c178[@m=82]='USA' then only update the value or do nothing    update USER.TABLE t1set t1.xmlrecord=XMLQuery('copy $t := . modify (if fn:exists /row/c2 then replace value of node $t/row/c2 with concat("firstname",$t/row/@id) else(),if fn:exists /row/c3 then replace value of node $t/row/c3 with concat("lastname",$t/row/@id) else(),if fn:exists /row/c178[@m=83] and $t/row/c178[@m=82]='USA' then replace value of node $t/row/c178[@m=83] with ("NEW YORK") else() ,if fn:exists /row/c4 and $t/row/c178[@m=82]='USA' then replace value of node $t/row/c4 with ("Manhattan")else() ,if fn:exists /row/c5 and $t/row/c178[@m=82]='USA' then replace value of node $t/row/c5 with concat ("NY 10036, USA.",$t/row/@id) else(),)return $t'passing t1.xmlrecordreturnin

 XML fragmenter settings: (identical for v3 and v5). I have trouble getting the v5 of XML fragmenter to work - for some reason, it rejects ANY xml I throw at it. Even examples straight out of www.w3schools.com. The above examle is rejected with XML parser error: unable to open primary document entity '<xml version="1.0" ... The old trusty v3 works fine. In the above example, i used copy-paste from an older workspace I had lying around.Anybody else who has trouble with this?FME(R) 2018.1.0.2 (20180903 - Build 18547 - WIN64) 

I use FME Server 2018. I'd like to send the result of a job to the user that submitted the job. I'd like to retrieve the email from the users list inside fme server because there are synchronized with Active Directory. With the FME_SECURITY_USER I've got the user but there aren't others FME_SERVER variables that contains the email. How I can get this information? Thank you for suggestions.

Hello, I have a street centerline data set which has street width information. I would like to buffer the lines by using GeographicallyBufferer based on the width information (to be more precise sum(div(@Value(SURFACEWID),2),16.4042) is my buffer size). However I can not because the street width attribute has long type. Is there any way to change it so that I could use the value of the attribute and use aritmetics with it. Thanks in advance.

Good morning.I have a very simple workspace that reads some polygons from a SHAPE file, aggregates them depending on an attribute and dissolves them with a "Group By" using the same attribute.This is working fine with FME Desktop 2017.1 (32-bits)Today I wanted to update this workspace to FME Desktop 2018. I have tested it with FME Desktop 2018.0 (32-btis) and FME Desktop 2018.1 (32-bits). It always fails with this error:"Dissolver(PolygonDissolveFactory_base_factory): INDEX FAILURE - requested predicate not implemented"2018-10-17 11:47:04|   0.9|  0.0|STATS |Dissolver(PolygonDissolveFactory_base_factory): Dissolving 1523 input polygon(s) across 26 group(s)2018-10-17 11:47:04|   0.9|  0.0|INFORM|Dissolver(PolygonDissolveFactory_base_factory): If the input dataset is large or complex, the dissolver could run for extended periods of time without logging2018-10-17 11:47:04|   0.9|  0.0|STATS |Storing feature(s) to FME feature store file `C:\Users\OSCAR~1.DIA\AppData\Local\Temp\SHP_a_DGN_20

I am trying to simply read a featureservice that I need to make periodic downloads of. This featureservice needs authentication. I can pull a token using part of this example (arcgis-server-feature-service-reader-token-authent) but I cannot seem to figure out how to hold the token as a parameter to feed to "ESRI ArcGIS Server Feature Service" transformer. I have also tried using a FeatureReader (using username/password) but am having issues not seeing the attributes. I do not fully understand using lists (if that is the issue).So, I need some help with either being able to create a token and save as parameter to feed to another transformer or pull attributes from the featureservice using a FeatureReader transformer.If you have any suggestions, I would be very appreciative.

Hi all, I'm attempting to read this service:https://data.wprdc.org/datastore/odata3.0/f2b8d575-e256-4718-94ad-1e12239ddb92Attempting to supply a value for the Feed List parameter results in an error:Python Exception <ValueError>: Unrecognized content typeapplication/atom+xml;type=feed;charset=utf-8I'm using 2018.1.1.0 64 bit

Hi,I would like for my workspace to run automatically each time a row is added to a postgis table, but can't figure out how to do this.I took a look at the Directory Watch Publisher and also at this article: https://knowledge.safe.com/articles/806/push-data-out-of-databases-to-fme-server-in-real-t.html but I don't really understand how to proceed.Thank you

Hello, Let's assume that I have a series of 2D-points A1, A2, A3, A4, ... An.Can anyone tell me how to create a measure between such points so that:- the measure for A1 is 0- the measure for A2 is d(A1,A2) i.e. the distance between A1 and A2-the measure for A3 is d(A1,A2) + d(A2,A3)- the measure for A4 is d(A1,A2) + d(A2,A3) + d(A3,A4)and so one?Thanks,

Hello, I am wondering if its possible to implement Imageprocessing tools in FME? For instance: Lets say you have a LIDAR file and want to make presentable contours. You then take ur filltered LIDAR file, do some processing to it first, then you make contours, write the contourvector to a raster, and on the raster I would like to have to oportunity to do Image processing, with a convolution/kernel filter.  Can this be implemented i FME?   

Does anyone know if a "how to" article exists to instruct users how to setup and apply an FME Desktop FME ArcGIS Data Interop Edition licence? A description of how to add the licence to FME and then how to enable the licence over in ArcGIS as well as the requirements to ensure the ESRI Data Interoperability extension is licenced? It feels like something that 'should' exist but I can't find it. I've had a client ask for a reference document and I wanted to forward a link... It appears this might be an oversight from the docs and the KC. In Robyn's 2nd paragraph here she references it https://knowledge.safe.com/questions/21547/arcgis-data-interop-vs-fme-ext-for-arcgis.html.Thanks in advance, Dave

Hello, With help of you, I managed the read the osm transportation data that I have attached. However, I am puzzled with tag information. If I open the data in QGIS, I see other_tags attribute in linestring data. However, I can not see the attribute when I read in FME. I used AttributeExposer but I still am not able see this tag. I am particularly interested in this tag as it has additional information such as number of lanes,oneway and width etc. Thanks in advance.   

Hi,I want to split lines with points but I really need to keep all the overlaping segments. I tried with the PointOnLineOverlayer but, like the Intersector, in this transformer, all overlapping segments are reduced to one segment before being output.In the image below, you can imagine a road with a dead end. The result must contain 5 lines and not 4. Moreover, the Intersector isn't good for me because I don't want to split lines on all intersections (only on points).Sample of my data here : Thank you very much Julien

Hi , I am wondering if there is a way to change the field type change the field type from string to integer for all field in writers in one go.Like the screenshot below I manually changed the field type but sometimes I have a huge number of fields and need to have them in Int instead of string, Is this possible?Cheers,Rawan 

I'm trying to get a webhook up and running so that Microsoft Graph can write straight to a topic on one of my FME Cloud instances. I'm using the following: Go to https://developer.microsoft.com/graph/graph-explorer/, do a POST-request to https://graph.microsoft.com/v1.0/subscriptions using the following body:{   "changeType": "created,updated",   "notificationUrl": "the-topic-url from Message as Subscriber Content",   "resource": "me/mailFolders('Inbox')/messages",   "expirationDateTime":"2019-02-15T18:23:45.9356913Z",   "fmetoken":"token-goes-here"} However, I get the following response: {    "error": {        "code": "InvalidRequest",        "message": "Subscription validation request failed. Must respond with 200 OK to this request.",        "innerError": {            "request-id": "5b842b2b-6325-444e-890e-f9ff6eb61510",            "date": "2019-02-14T13:09:40"        }    }} Using Postman, I've verified that I get a 202-response if I make a POST-request to the topic URL. Is there a

Hi,I have 2 layers one representing lines and the other layer is polygons.I need to create a point at the center of the polygon when a line intersect a polygon,can this be possible. thanks for your help.

 Hello,I am doing simple analysis selecting lines which are Within Supplier (Area) basically crated buffer followed by dissolved and the SpatialRelator for selecting features. I have use SpatialRelator for that but tacking too much time (features count 1000000). Can anyone have solution?

Im new to FMe and Cityworks and came across this blogNew FME Tools for Cityworks Integrationsand curious to know if there is a custom transformer that creates a service request that reads data from an xml fileAlso can this be done in FME Desktop without FME server

HiGetting the following Tunnel error - reading online seems it might be an SSL issue - Can this be looked at in the Database connection parameters and the reader and writer for MongoDBSeems only to be an issue if using the hosted serviceMONGODB writer: Cannot connect: DBClientBase::findN: transport error: mydatabase-shard-00-00-ch90m.mongodb.net:27017 ns: admin.$cmd query: { ismaster: 1 } MONGODB writer: Unable to locate or open database 'mydatabase-shard-00-00-ch90m.mongodb.net'. Please ensure the database exists and is accessible. Note that the MONGODB writer does not have the ability to create a new database. However, creating the database manually in advance allows for subsequent data insertion

Hello Guyswe have wmts service we could open with no problem in ArcGis , but we are unable to open it in FMEAny suggestionhttps://tansiqsat.momra.gov.sa/tileserver.php?/wmts 

Hi FME Experts, I have a field, I would like to create a new field based on duplication of the records in this field . as the attached image, is there any way to do that?  Thanks in advance

I have some line-strings and I would like to create polygons with shape like in the images based on the line. It looks like hexagon but all edges do not have the same length. Can Bufferer create such polygon based on the lines? Or do you have any idea how i can create such polygon? Thanks in advance.

I struggle to find the link for the FMEAR including the Airplane from previous World Tour? Anyone have it or know where to look? Thx

Just recording this for anybody that needs it. FME Datainspector shows a CW/CCW (clockwise/counter-clockwise) direction for an arc under the geometry, but this value can't be extracted as a trait using a geometrypropertyextractor and the arcpropertyextractor doesn't list any attribute that return clockwise/counterclockwise.