Transformers

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 that clear,

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: 0 1 2 3 No 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 is IFMEFace (not shown on screen dump) Area:IFMEPolygon (see screen dump) Boundary:IFMELine (see screen dump) ............... Any suggestions most welcome ............... Regards Howard 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 network 13,539,080 From-to lines (these are all 2 point lines) Progress so far; 344 ShortestPathFinder_NoPath no 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 it If 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.

Good morning! My input data is a series of 3D polygons that represent Administrative Units stored in an ESRI Geodatabase. I've been tasked with calculating the area of those polygons. For that i wanted to use the AreaCalculator transformer with Type parameter as "Sloped Area". No problems there. Except the final user of that data wants the area to be calculated using the Simpson's Rule. I had no idea what that was, so I've been looking for info a little bit: https://www.emathzone.com/tutorials/geometry/simpsons-rule.html I still don't know how to translate that to FME. Could anyone give me any pointers, please?

I have a plsql script to perform some task on db. But it doesn't contain any code for returning output(results are stored in variables). I need to get these results into FME SQL executor or creator. Is there any code sample to start with this? All I need is a example plsql code to get results into FME SQL Executor.

Hello, I have an issue when using the linejoiner. I would like to merge lineear features, some of them are arc while other are segment line. I first use ArcStoker to transform all the arc features in to segment lines and then I use LineJoiner to combine the features.. It appears that the transformation with ArcStroker is creating a shift between the start/end point of consecutive features lines. Because of that it is not possible to merge the original arc features with the line segment features. Does anyone has an idea on how to overcome this issue? Thanks

Hi all, I've been playing around with the system caller, however, I've found that when I abort my FME process the process triggered using the System Caller keeps running. Part of the problem is that I'm also using the TempPathnameCreator as the output for the called process, if I kill the FME process and the sub-process keeps running then the temp files also don't get deleted. I have to manually kill and then delete the process Does anyone know of a workaround for this?

Hi all, With the SystemCaller I am kicking off an executable That executable is looking for a file with parameters in the working directory So if I use the Command Line in Windows, I go to D:\\TEMP That then is my working directory and it has the parameter file : parameter.ini When I start the executable it uses this ini file But when I use SystemCaller and I set the working directory, the executable seems not to find the .ini file somehow Anyone an idea? I now use the PUSD command to set the working directory Then starting the executable Then close the command string with POPD

This is my first question so do tell me if I'm missing anything in the description of the question. I currently have a workspace where part of the functionality includes the merging of 5 columns (two of which are always empty). The data that isn't merged should be preserved for each of the rows that are created or already in existence. Below is an Excel example of what I mean: This is the current situation This is what it needs to become As you can see the data from the first three columns are merged into one but the other three columns (ID, Type and Type 2) remain unchanged and are copied to the new rows. This causes for example the row with ID 500 to split into three rows, all of which contain all attribute information from the original that wasn't merged. I looked for similar questions but the solutions didn't work for me such as the Attribute Exploder, which does not currently have an option to select what you want to explode. The solution given in this question came close but did

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

Hi folks, I'm having 2 issues with my FME Server and the running workspaces. 1) The session created just like documented here https://playground.fmeserver.com/javascript/server-uploads/upload-file-in-session/ doesn't give me a session like a random number but as the username the token is connected to. What am I doing wrong? Or did I miss something with the token? Or in other words: How can I delete the uploaded data after the workspace ran successfully so that further job submissions don't get/take the data already uploaded?!2) One workspace in which I read a DWG-file adds quotes to the request-URL and though cannot find the uploaded data. When I strip the quotes everything works fine. How does this happen? The workspace has a FeatureReader to read the DWG to make it as an optional Reader (the parameter "Ignore Failed Readers" doesn't have effect). Why does FME Server takes it as a multiple set of files?! FME Server 2018.0.1 - Build 18310 - win64 Cheers, Maria

Hi, I have about 200K point and trying to find points within 100m and generate a list for each point by using NeighborFinder. But it is very slow as I expected. Does anyone know a trick to speed up the process? Thanks in advance!

Hello, I have a polygon and line data-sets. I would like to shift the polygon to the lines in a way that last edge of the polygon would touch the lines. Any ideas? Thanks a lot! Before shifting After shifting

Hi to all, I have following part of XML: <field name="ROZL_SK" conditionName="skrinNN"> <webEditable>0</webEditable> </field> <field name="CISLO" conditionName="skrinNN"> <webEditable>0</webEditable> <nullable>0</nullable> </field> <field name="SJZ_ZAR"> <editable>0</editable> <nullable>0</nullable> </field> <field name="DOD_ROZL" conditionName="skrinNN"> <webEditable>0</webEditable> </field> and prepared xfMap script: <?xml version="1.0"?> <xfMap> <feature-map multi-feature-construction="true"> <mapping match="field"> <feature-type><extract expr="@name"/></feature-type> </mapping> </feature-map> <feature-content-map> <attributes> <attribute><name><literal expr="ConditionName"/></name> <value><extract expr="@conditionName"/></value></attribute> </attributes> <mapping match="nullable"> <attributes><attribute><name><literal expr="Nullable"/></name> <value><extract expr="."/></value> </attribute> </attributes> </mapping> <mapping match="editable"> <attributes> <attribute><name><literal ex

Hi folks I've tried using ListBreaker to transform list indexes into attributes, it does exactly what I am searching to do my reader is a JSON file, depending to the file used, the workspace begins then stays in pause, without giving result i join the data and workspace I use FME 2019 last build 19214 64b regards

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)

In my workspace, I want to extract roofs from existing models and extrude them to a DEM raster hence creating newer and cleaner models. The running of the workspace was unsuccessful and this was shown in the Translation Log. RasterClippingFactoryPipeline::MaskRasterizer(VectorToRasterFactory): 54 input feature(s) processed. 0 input feature(s) with invalid geometry discarded. 0 input feature(s) not compatible with the raster interpretation discarded. 54 raster(s) output @ProcessRasterTiles: Invalid raster dimensions: 0 rows by 1 columns. This function requires rasters to have positive values for both rows and columns RasterBandMinMaxExtractor: A fatal error has occurred. Check the logfile above for details Clipper_5_Raster(RasterClippingFactory): A fatal error has occurred. Check the logfile above for details . How can I find the source of the problem and erradicate it? I guess it can be caused by complicated or problematic models as it does not occur all the time. Please help me, Takas