Transformers

Hi, is it possible to hide the systemcaller cmd line when using it inside a workspace being run from workspace runner. At the moment my screen looks like this and it is a touch annoying!Thank you   

I have two tables, one which hold records of planning cases that need to be monitored (Table A) and another which is the master list of all planning cases (Table B). In Table B, there is a string field called 'Proposal' which contains a description that may include the reference number of one of the cases in Table A (there may in fact be many records that relate to a case in the Table A).I would like select all of the records in Table B that contain the case reference from Table A in the Proposal field. I don't think I can use the feature merger as the information in Table B is contained within a Proposal field and is not in a field itself. I thought about trying to extract the case number from the Proposal field but, whilst it is normally at the end of the string, this is not always the case. It is also not a standard length.Can anyone think of a different transformer I could use to achieve this?

Hi FME ninjas,I'm using the HTTPCaller to call a website containing multiple URLs in its HTML. I'm trying to extract all the URLs that have below format, based on these I'd like to create and attribute (URL) that shows all unique urls as features. What I have: What I want:  Does this make any sense ;-) ?  Thanks,Eduard

I created a workbench which reads an ECW (which I call current imagery). I then read GeoTIFFs (which I call new imagery), mosaic the rasters together and then write to a new ECW, which becomes the new current imagery ECW.I've noticed contrast changes in locations which are not being overwritten each time I've added new imagery and recreated the ECW.What could be happening here?The below image is a location which hasn't been overwritten by new imagery. I've run the new workbench 4 times now and you can see its getting darker each time.  More notes: I have done some further analysis.By using the PointOnRasterValueExtractor I was able to get the RGB band values at a location before the mosaic and after the mosaic.Before the mosaic: 82,92,82 After the mosaic: 93,100,94I also used the RasterBandMinMaxExtractor.Before the mosaic the min max was R: 0,251 - G 0,253 - B 0,251 After the mosaic the min max became R: 0,254 - G 0,253 - B 0,254 I expected the min max to change, I jus

Many years ago, the swedish National Land Survey issued topographical maps on CD-rom, using a self invented raster format known as RIK. Lately, these maps have been published as Open data. But this resurrected format is not known to FME.There is open source code to read this format, and it is supported in GDAL. Thus, it can be read and displayed in Qgis but not (as far as I have found) read with FME. What would it take to create a custom reader in FME using information in the links below? Apparently, the 'custom reader' ability in FME desktop needs a supported format to begin with.https://sourceforge.net/projects/trikpanel/https://github.com/OSGeo/gdal/tree/ab9e80368ef662712c963191fd86fde2c5b75600/gdal/frmts/rik

I have two tables.One is a dataset of points, each point has a unique IDThe other is a (attribute only) dataset of pairs, each record refers to two points, via their unique IDHow do I construct a feature dataset of lines? Each line consisting of two points. To re-phrase, how do I add line geometry to the dataset of pairs, using the appropriate points from the point dataset, based on the unique ID of the from and to points?

Hi FME Community,I'm trying to create an arc from two Points and a radius:The radius can be concave or convex depending on the radius sign (negative or positive)Anyone got any ideas how that can be done using FME?Thanks in advance

Hello,  I'm trying to replace my overdose of RegEx StringReplacers with a single AttributeManager that should contains multiple RegEx functions.  I've set up a short test:The first part of the test works fine: change: "world" to "WORLD" The second part doesn't seem to execute: change the "99" to "100"I'm now wondering: Can the AttributeManager conditional value hold multiple RegEx functions or just one? Thanks, Ed   

Since upgrading to FME 2018, I've noticed my available hard drive space has decreased considerably. Poking around in my Local/Temp folder, I see there is a folder called FMETable that contains over 35GB of files.Diving deeper, there are gigantic files in there related to the FeatureJoiner:So my question: Is this supposed to be happening? Do I need to manually clean this stuff up on regular intervals?

I am trying to read in some pdfs, unfortunately when the pdf reader fails to open the pdf (if say it is corrupt) the workbench stops:2019-03-07 15:40:24| 391.6| 0.0|FATAL |PDF Reader: Failed to open document '\\xxxx.pdf' because the file is not in PDF format, or because it is corruptedI have set the workbench to ignore failed readers and continue transaction is setup under the Rejected feature handling. Is there any way I can keep it running?Thank youOliver  

Hi, I am reading text from a pdf using the PDF reader and in the text I see xEF, xBF, xBE - what are these and how do I remove them.Thank you

Hi all,I'm trying to download all zip files from the URL below, keep a copy of the zip in one local folder, and a copy of the extracted csv in another local folder. http://www.nemweb.com.au/REPORTS/CURRENT/Daily_Reports/Using the workspace attached , I can successfully download and extract a single zip file and csv content.I believe there may be a list of all zip files available from the URL hidden somewhere in the response, but how would I go about extracting all available zip files and storing the resulting csv ?Thanks

Hi, I am a true knownothing on this, so here it goes: are there any people that have experience with processing in FME of file resulting from Hexagon's 3D SmartPlant application? Any answer would be greatly appreciated.

I'm having trouble locating a clear answer because of some of the upgrades to the tools that have occured in the 2017 version. PointConnector was superceded by LineBuilder, which works well when I have multiple features with the same value in one field, but sequential values in another field.What I can't figure out is how to create lines from points by specifying certain fields to connect. For example, I have around 30,000 point features in two different point layers (60k total), which need to be connected based on shared values in a shared field.I know I can combine these as Suppliers in the FeatureMerger, join them with a requester, and build lines from points, but the tool seems ambiguous on exactly how this works. In other words, I don't know how the tool knows how I want to build lines.The concept of what I need to do is as follows:VertexCreator A --> Points A (created from A field) --> VertexCreator B --> Points B (created from B field) --> ---> Connect

Hello,I am reading my oracle non spatial database with an SQL query containing couple of dates. When inputting the dates directly in the query, there is no problem and it runs smoothly.I would like to make user parameters from these dates. So I have created published user parameters choosing 'date' as type.I then try to use the parameter in my SQL query (where clause) but I get a type error over and over. I have tried couple of different notations but it doesn't seem to work... This works (without parameters)  AUTO_START_DATE <= TO_DATE('15/12/2019', 'DD/MM/YYYY')Then I tried several variation to use :  $(START_DATE)but I can't seem to find the right syntax. Thank you

Hi!Newbie here so i'll start by introducing. I work at a government organisation in which we use a management system and have a need for FME. I wish to learn to use it myself, to help our department and I think a lot of my 'work' can be done by FME.  My question:I have a DWG of a road in which all the objects have their own layer. So all the asphalt have the same layer, grass has same layer, and so on and so on. But for the management system we need different information for the asphalt in comparison to, for example, grass. So we need shapefiles of both with different information. Is it possible that I take the DWG file and let FME translate the layers to shape, and give the different objects their needed feature table. So a asphalt DWG polygon turns into a asphalt shape with a feature table that includes thickness and year, and the grass line turns in to a shape with feature table type of grass and year. And they both will be in the same DWG. My apologies if it is not all

I have got a shapefile and I only want to extrude the boundary layer and leave the centre hollow. Any tool to help me do this? If not is there a way to do this by calculating normal vector and then using appearance setter to make the centre transparent?

See attaches screen dump.Is it possible to expose the 3d face boundary coordinates ?ie coordinates:0123No luck with GeometryPropertyExtractor (Traits) but I could be missing something.<FME Inspector does not suggest these are traits but I tried it anyway>.............Geometry Heirarchy isIFMEFace (not shown on screen dump)Area:IFMEPolygon (see screen dump)Boundary:IFMELine (see screen dump)...............Any suggestions most welcome...............RegardsHoward L'   

Hello,I have data set that I need to join attributes from csv file. I am joining with ID that is combination of letters and number e.g. tk14b.Problem is with letters because i have mix of upper and lower case but tk14b is, for me, same as Tk14B and every other possible mix.Is it possible to set FeatureJoiner to be case insensitive? Or, is there any other way to join my data set with attributes from CSV file? Thank you in advance.

For 48 hours now, I have been running an ShortestPathFinder transformer, and I am worried that it is not making any progress.For context;643,312 features in the road network13,539,080 From-to lines (these are all 2 point lines) Progress so far;344 ShortestPathFinder_NoPathno other output My expectation is that ShortestPathFinder should be sending lots of output to ShortestPathFinder_Path but there is none. Is this normal behaviour? Does the transformer save up the output until the end of the process?Should I kill the process and try to tweak it? I would lose 48 hours of processing time if I kill itIf there was a constant stream of output to ShortestPathFinder_Path then I would be comfortable that progress was being made, but there is not

My name is Pelwinderpal Singh and I am currently working for AGI. We currently support the cesium 3d tiles format here in FME. Would appreciate if I could get some help on this issue I am experiencing. Thanks. I opened an esri shapefile using the shapefile reader. I then used attribute creator to create an attribute with a value. I then converted it back to a shapefile using the ESRI writer. When i open the new shapefile, the attribute is still not shown. I tried adding in an extruder after the attribute was created. I extruded vertically and for direction, I put attribute name that I created. I then converted to a shapefile using writer. When i inspected the new shapefile, i could see that the extrusion worked. This means that the attribute was created. My only concern here is how to get the created attribute to be shown?

I have a csv containing point data for series of paths so each point contains a pathID attribute. I want to run the points through a workspace but for groups of the points by path. ie run the workspace for path one, output a feature, run the workspace for path 2, output a feature for path 2 etc. Whats the best way to do this? I'm thinking its by using the variable setter and retreiver but not really sure that is the best way.

I have a dataset of local roads, which I want to use for ShortestPathFinder. The road network includes roads on islands, and those roads are not connected to the roads on the mainland.Is there a transformer that can output only those roads that are part of the mainland road network? I want to eliminate the islands.

I've been struggling with this for quite some time now, but without success...I need to write a pdf-File for each feature of my data, containing only a table with it's attributes (Attribute Name: Attribute Value), no geometry.As suggested here https://knowledge.safe.com/questions/74002/attribute-data-to-pdf.html, I first tried to write excel-Files with this tables, using a featurewriter / fanout (https://knowledge.safe.com/questions/46550/dataset-fanout-for-featurewriter.html)But my problem is, how can I write a table with the names of the attributes on the same lines as their values ? (When I'll have succeeded in writing the excel files, then I'll try to read them with a featureReader and write pdf-Files, using the TableAdder...)Thanks in advance, Vera 

I have downloaded the OpenStreetMap file for Australia and successfully extracted the road geometry (tagged as "highway").I want to use this as the Network input for the ShortestPathFinder transformer.What other transformations should I do to clean up the dataset? For example, the line geometries are typically not broken at intersections, but I think that they should be.