Best Answers

UnderGroundCable and OverheadTransmissionLine Line are two feature classes. some part of circuit A-B is UGC and and some is OHTL.Both feature classes are related with the Electric Line Table.In the ElectricLine table should be one record with the Circuitname= A-B and other common attributes and length should be UGC=OHTL .Relation is one to many by CircutName field.how i can do this by FME without creation duplicate record.Thanks & Regards, AZA

In ArcGIS there is a tool called "Hot Spot Analysis (Getis-Ord Gi)" under Spatial Statistics Tools > Mapping ClustersI am wondering if it is possible to replicate this in FME ? The example I have concerns "delay minutes" based on incidents on the UK rail system, so it is the "Delay_Minutes" value I wish to be evaluated.

Dear FME Users,  I’d like to process 73 input NetCDF-files. The files describe 3 days (73 hours). Every single file stands for one hour. The NetCDF-files don’t include any useful time attribute.  What I need is the timestamp for every single input written in an attribute .The data type should be “date”.  In the following you can take a look to the assignments (input files -> time):  - HRES_ENS_2017062200+019 -> June 22, 2017 “07:00 p.m.” - HRES_ENS_2017062200+025 -> June 23, 2017 “07:00 a.m.” - HRES_ENS_2017062200+071 -> June 24, 2017 “11:00 p.m.”  What I can do in FME is to extract the substrings I need (e.g. “2017-06-22-19”).  I’ve tried following transformers too: “DateFormatter”, “DateTimeCalculator” and “TimeStamper”.  Do you’ve an idea how to solve it?  Thank you very much and best regards!  Konrad

Hello, I have a cad file that contains lines, points, poligons and surfaces and i want to filter the geometry and in the same time to merge all the line on a single feature class, the the poligons , points, etc . I haven't found any transformers that can help me with this. Can you tell me if there is any transformer like "Merge" function in ArcMap? I was using a model builder to merge the features after the translation. Also the same model was used to calculate fields or to add a new one. Is this possible in FME?

Good morning!I've been given a sample of data to create aggregates from them (I have attached that data)The only attribute of the features is type. I have to build aggregates using features of the same "type".For example, these lines and point must be an aggregate:Or these lines and polygon:I've been messing around with the transformer NeighborhoodAggregator, but I'm incapable of adding the proper settings to make it work for all the types. Looking at the data, I'm not really sure if it is even possible to make it work for all of them.I've been trying with spatial relationships, but I can't make it work either.I'm out of ideas. I'm starting to think that I will have to treat every type on its own. In the data sample there are only 4 or 5 types, but in the real deal there will be more than 60.I need to create the aggregates, because in the database the aggregate will be stored as a point feature.I'm in need of another point of view, so thank

I need to create a csv-file with a special structure. I 've two problems which I haven't an idea how to solve:1. How can I add a file-header before the actual content (The yellow part on the picture)?2. If an element has more than one coordinate pairs (in case of a line) how can I add the vertexes and the end-point on the same row (The part witch is in blue on the picture)? Yellow: File-header Orange: Column-Header Shades of Blue: Element coordinate(s)

I am searching for a transformer where ITopologicalOperator.ConstructUnion in ArcGIS..

When I run an FME Script in one repository containing a custom transformer, FME Server will sometimes incorrectly use a custom transformer with same name from a different repository.  I have separate repositories on FME Server for a set of workspaces. I would like to extract some logic into custom transformers that would be loaded into these repositories. Unfortunately, it seems that FME Server sometimes loads a transformer from a different repository. I can run the same workspace in one repository twice in a row and get a different result because it will grab a transformer from different folders on different runs.

Hi there,I can generate Token from FME Server2017 using C#, tested with postman, see attached image, but when I try to use same method from FME Server2016, it gives me error: Both user ID and password need to be specified for viewing/generating token. So what's the correct way to generate Token in FME Server2016.1 using postman or C#. Thank you very much.

Since I upgraded to latest Build 17650 I first had problems with a corrupt FME Installation where e.g. StatisticsCalculator outputted only NULL-values (see this thread).Now I executed all our statistics batches finding out FME is now writing data in white font color with white borderlines, you can say as "white boxes". It ignores formatting of the template-Excelfile. The data itself is there, but not visible because of white color. The XLS-Template used (since 4 years unchanged) has standard formating in black with light grey borderlines...Are there any known bugs in the excel writer since Build 17291?If you change font color and borderline color manually you can see the values:

Hello everyone,I´m still thinking about issue when after successful translation all folders in some path will be zipped. I have no idea, how to do this via simple workspace. Maybe only one possibility is to do that via Shutdown Python script. Unfortunately I´m not a huge expert in Python, could anybody help me please?Thank You so much!Lubo

Hello...I would like to sort the output of the Attributepivoter. Is this possible? For example, one of the group by rows is month and I want to sort this output based on the calendar year months (Jan. to December). Thanks.

Hello FME-Community, I'm trying to find a workaround for the non-existing feature type TransformerInputPorts at the FME Workspace Reader.I would like to know whether it is possible to detect which input ports of a transformer are connected with other FME transformers within my workspace.The FME Workspace reader has among others feature types TransformerOutputPorts, Transformers and Connections.I tried to combine the information from these feature types, but without the desired resultsHow can I detect which input ports are (un-)connected for a specific transformer in my workspace ?

Hello everybody!I try to solve one big problem... I work with workspace which export some spatial data and all I need to do is to create envelope around exported data. BUT, I need the envelope which is composed by predefined AUTOCAD BLOCK in separate DWG drawing (e.g. frame or drawing stamp; block is everytime centered into 0,0 coordinates)... To better imagination I attached picture, where I decribed my aim.I would appreciate every help. Thank You so much!Lubo

Hello,I try to solve two problems. Database in my project contains many types of geometry - points, lines, polygons. I need to do bulk conversion of every coordinate by 2 decimal places. E.g. One point feature has X coordinate 152,125 and Y coordinate 696,745. I need to convert these values to X coordinate 15212,5 and Y coordinate 69674,5. Does anybody idea how to solve this problem please? Second problem is about work with lists. I have met many times situations when I use list in XML templater. I had to divide values of any attributes in list, so I have to specify index of feature in list, e.g. {fme:get-list-attribute("_indices{0}.x")}. But how can I specify, that I want to put there all values without index 0 please?Thank You so much!Lubo

I hope someone can help me out. I have some curb lines that are poorly drafted. I tried to use Snapper (with various snapping tolerance ranging from 0.1 to 5) and then LineJoiner to join them together, but had no luck so far. I attached the file here so if you want to give it a try, please go ahead.Thanks in advance.

Hello All,Using for the first time knowledge center (to post questions). I'm little bit new on HTTPCaller, not on FME :). I'm trying to get data from this page (source): http://www1.kaiho.mlit.go.jp/TUHO/keiho/navarea11_en.htmlSo far I'm not able to get any data, probably I'm using the wrong method (POST Vs GET), I've been doing some research and checking similar questions like: https://knowledge.safe.com/questions/42386/how-to-get-information-from-website.htmlMy idea is to be able to download all those records under "NAVTEXT" section (see attached image) and get at the end a result like this: http://www1.kaiho.mlit.go.jp/TUHO/keiho/cgi/disp_warnings.cgi?TYPE=NAVAREA11&TANA;=170795⟨=EGThe above link is the "OnClick" response when you click on a record under the title columnI can't pass them manually because those records change in a daily basis. Any idea on how can I accomplish this?Thanks in advance for your helpCesar

Hi,I would like to export images from a geodatabase attachment table to JPEGs. In the process I would love to write the geoobject feature attributes to name the jpeg.The attachments are joined to geoobject features by a Global ID. I would like to name the jpegs with attributes from "Stadsvandring" and "ID_nr" columns. I appreciate tips on what translators could be used!/Sofia

hello!!I am trying to build a model to find roadless area with FME.Firstly, I want to do a buffer with an esri-file geodatabase format file which is highway feature, then I want to dissolve it by 1 km with some attributes. then I want to erase the layer from the administrative boundary layer. Can I do this in FME ?Is anyone have any suggestion? thank you

I have made an aggregation of lines that I have saved in MS SQL. when I then make a STGeometryType () on the table I find that a GeometryCollection has been formed. I want to avoid this and instead save it as a MultiLineString. However, I do not find any settings where I can control this. (then I will do the same for points and spaces to completely avoid GeometryCollection.)

A direct utf-8 text file to utf-8 text file works perfectly but when I try to write to a system character encoding text file I get an error after a while.I include the log file in the workspace (https://goo.gl/DF46Yx)Any suggestions?

Hi all,I'm trying to process one DWG and create another DWG. There are some blocks inside and I used DWGStyler to make it all right. And that works. But there are also a number of zero-length lines for which I want to stay lines in the output DWG. Instead, they are turned to points and converted to blocks. I've tried to set the advanced parameter "output zero length lines as lines" but it is not working. No matter what I do, they become points and convert to block in output. Their position is identical to block position. I need them to stay there, and stay as lines or points but not to convert to blocks. Any advice what to do? Thanks.