Transformers

I am trying to find shortest distance from all points to all other points in my dataset. I have used a topology builder and a network topology calculator to verify my network data. I don't get any features coming through the 'Path' output port. All of them exit via unused and no path found.I have attached a screenshot of my workspace.

Hi SafeI've been experimenting with the XSLTProcessor and transforming a XSL derived document to Word format. All the information comes across to the Word doc however the formatting of text (eg, font size, font color, font type), page margins, (table) column widths and some other document elements are not retained. Does the XSLTProcessor honor the formatting elements associated with XSL or in-line HTML formatting? - there's very little information associated with the XSLTProcessor 'Help'ThanksConch

I am trying to translate a SHP file with NAD83 coordinates in meters to MIF/MID LL WGS84 degree data. Is this possible?

Hello Guys I am trying to extract data from table in HTML page containing links to download file,This is the website https://www.stats.gov.sa/en/160

Hi I ran this yesterday and I got geometry and today no geometry. I can't figure out what is going on. I am trying to bring through a TLA boundary layer. Feature Type shows allowed goemetries as xml_area but when i run the inspector it just has a table and no geometry in this view. Not sure what is going on so hoping someone can help.https://datafinder.stats.govt.nz/services;key=1cc31ed95b0f4fd8ac0f29950daf656d/wfs?service=WFS&request;=GetCapabilities

Dear all,newbie question regarding the below.Context: I am downloading a GDB from a drobBox each night. If the schema has not changed I wish to load the tables into SDE, along the way add a field with the download date (timestamper).Specific question : My idea is to use the Tester to check if the "Unchanged" fme_feature_type_name from the ChangeDetector matches the fme_feature_type_name value from the TimeStamper , if so write to SDE. But it is not working as i imagine it.Any suggestions for how I can solve this would be most appreciatedthanks in advance

Hello. I have a problem with AreaBuilder. Exactly I want to create 3D building from dgn. data with 2 layers – the first is the ground (lines) and the second is the shape of roofs (lines and shapes). I made the surface, draped roof points on it and I took coordinates. After I merged feature of points with the same x and y coordinate, I calculated height of buildings using z-coordinates and extruded them (I received vertical lines of walls). In that way I generated vector models of building. But when I am creating area of walls by AreaBuilder, one wall in each building is missing and I don't know why? The lines are still there, the AreaBuilder didn't reject anything. I’ve already checked topology and tried different options but it's still the same.It's look like that:Here is my workbench (v. 2017.0) and small part of my data.

I have a task microstation 3d model building to shape file. buildings are generated from las data.  Above shown building converted from dgn to shp which is looks fine.  But, below show screen shot there is a wall polygon below roof. need to remove. is there any soultion. Please suggest...  Thanks in advance.  

Can I read multiple geometry using sqlexecutor. In my case , i dont have two geometry in one table. i am extracting/constructing multiple (2) geometry from different tables and the sql gives resultset with two geometries in one row. two geometry from sql resultset not from one tableand later i will deaggregate this and use these geometries for different purposes.how can i achieve this using fme?

Hi All,  Is there any way to remove from Straight Polyline unwanted vertices.  I have so many Polylines like this  Please guide me and suggest.  for ex:  cyan Color marks are nodes Red Color mark Vertex are need to remove Green Color Vertex is important need to keep.  If possible need to set tolerance  Thanks in Advance  Venu  

Hello,I have a FeatureMerger and use the Merged output port to pass data on to an Attribute manager. If I run the translation, the data does not reach the AttributeManager:If I no connect an Inspector to the Merged-Port and run the translation again to see what leaves it, the data also flows to the AttributeManager and everything works as expected!?!?!?To me, this is very confusing and I hope to be enlightened...regards and thanks,Ludwig

I had various tweeting workspaces working fine (for about a year) up until about 5 days ago and now I get the routines failing to send the tweets showing the Error in the log:2017-07-11 14:02:01| 8.3| 0.0|INFORM|HTTP/FTP Transfer: Downloading resource 'https://api.twitter.com/oauth/access_token' to internal memory buffer2017-07-11 14:02:01| 8.3| 0.0|INFORM|HTTP transfer summary - status code: 403, download size: '130 bytes', DNS lookup time: '0 seconds', total transfer time: '0.296 seconds', url: 'https://api.twitter.com/oauth/access_token'2017-07-11 14:02:01| 8.3| 0.0|ERROR |Received HTTP response header: 'HTTP/1.1 403 Forbidden' from 'https://api.twitter.com/oauth/acce

Hi Safedoes the XSLTProcessor supports XSL-FO? Will it in the future?...(I'm investigating current and future solutions for automated document creation).Regards,ConCh

Hello, me again, I am doing my first fme steps and need to ask so much... I have this workspace (PATH > AttrbuteFilter > FeatureReader > Tif writer):1. I runs nicely, but if I add a coordinate system to the writer in the navigator, the translation takes 10 times longer. 2. Why is there no Coordinate System to be set in the FeatureReader? If I add a normal reader, it can/has to be set!?3. Why can a Coordinate System be set in the navigator in the Directory and File pathnames reader? I thought it only reads pathnames and not the data itself which would have a Coordinate System....thank you!

Hi all,I want to figure out the best way of summarising data by date.I have a workspace that creates routes for journeys using the ShortestPathFinder, and then explodes the routes into their constituent segments, with the attributes below plus Road Name, SegmentID:What I need to do is sum the total number of vehicles per day on each segment.I have a solution that works but is slow and I need to optimise it. Currently I merge a date list to each route, then explode the list so there is a sepreate feature per day per route - and then test to see if it is within the date range. Finally I sum the number of vehicles using an aggregator (most efficient?) per road segment, per day.The problem is the journeys occur over a number of years, and over a large area so this results in many many features and is not quick.I would be grateful for a

I am trying to connect to AGOL using FME Desktop 2015 but can't get it to connect. Attached is the error I am getting. Hopefully someone out there is familiar with this error. I have tried opening port 443 but hasn't made any difference.

I want to find each line of the string below with a regular expression in StringSearcher that looks like this .*\\r\\n, i.e., I expect each line to end up in the all matches list produced by the StringSearcher.METER_NUM,PRODUCTION_DATE,FLOW_TIME_MINUTES,VOLUME,ENERGY,DIFF_PRESS,STATIC_PRESS,FLOW_TEMP,MOL_CO2,ENERGY_FACTOR1006-2001307,20170829,132.283,13.8851,,9.45286000000001,1088.28,83.9825000000001,,1006-2001283,20170829,1440,311.974,,27.9496,162.085,88.4964,,It works in my regex testing tool Expresso, but StringSearcher doesn't seem to recognize \\r\\n.

I have a series of point, from each point, I would like to create a specific rectangle with height and width specified. The point provided are treated as centroid of the polygon (rectangle). Or, even better, the polygon would be in a specified angle, but this is not required...Is there a workflow for this process? Thanks!

Hi,I wish to calculate some parameters values based on tables in my database, i need the max value of the pid field. These value would then be passed to the counter transformer to start the counter off from this max value.Currently i do this by using a sql executor to calculate the values then a feature merger to add these values to the records, this how ever is very memory intensive and causing the workbench to crash.Is is possible to calculate the sql and store the value in a parameter?

HiI am brand new to FME so this is probably an easy question to answer. I have used AttributePivoter to get a sum value into the field I entered in Row Group Summary Line Descriptor. I would then like to use the value in this field in an SQL calculation using InlineQuerier in the next step, but InlineQuerier does not recognize the Def_points_Sum table field.Any ideas?Thanks

Hello,I am using a path and directory reader followed by an attribute filter on the file extension and a FeatureReader and, finally a Writer. I want to use the path_rootname as the basename for the file to be written, but the path_rootname is not available anymore after the FeatureReader (I can see it after the Attribute filter). I have exposed path_rootname in the FeatureReader Reader Parameters and under Output-Attributes to expose but if I add an Inspector after the FeatureReader, the values of path_rootname are <missing>.Would be happy about any hints!

Hi,I have two tables in file geodatabase and both are the same structure.Both tables are having around 140 columns and 4000 rows.In table 1 there are many fields are "null" and "0" and remaining fields are filled with some values.In table 2 filled with some values and also few fields with "null" and "0" valuesIn both table is having "ID" common unique value field available.Condition is.I need to update Table 1 based on below scenarios1. If fields values available in both then no need update2.If table 1 is having "null" and "0" values then update new values if available in table 2.3.if table 1 is having some value and if table 2 is having "null" and "0" then no need to update Thanks in AdvanceVenu