Transformers

Hello therewe have an ESRI geoDB with 244 table there named based on the dataset type, City name and Zone as you see on the attached excel we want to combine them based on the dataset and Zone then use the reproject them in one coordinate system, in order to get all those tables only by dataset nameI did manage to extract the table name and build the excel in order to make groupsAny idea

Hey,If I have a datetime, I'm wondering how I could convert it to a string.

Hi all,Working to parse some sections out of a webpage. I need to associate some values with their heading. I can get the h3 values I need or all the ul or li elements on the page but trying to get just the ul and li element under each h3 to keep them grouped. Seems like using a h3 ul li selector should work but it doesn't return anything. Changing the space to a comma (,) returns all the values not just those ul and li within the h3. I've also gotten the values for the h3 and can get each h3 individually using "h3:nth-of-type(@Value(part_idGEN))" but again trying to get the ul or li element under this doesn't work either.Using FME2018.0.0.1 Build 18295Webpage is https://www.thewindpower.net/windfarm_en_182_gent-zeehaven.php Thanks,Andrew

Hello everybody,I´m trying to solve problem with using REST API on FME Server. All I need is to generate new session ID for every data upload to FME server. Is there any special function to generate new session ID?Now, if I upload new datafile, the FME Server still keeps the same session ID, e.g.:{"serviceResponse": { "statusInfo": {"status": "success"}, "session": "DDDB81451D5F0192DE8292DD71A0EF46", "files": { "path": "", "folder": [{"name": ""}] }}}I tried to use getSession function (meant there: https://knowledge.safe.com/questions/57605/javascript-rest-example-keeps-sessionid.html) but i doesnt work, because it returns still the same session ID. How to generate new one please? Thank You so much for all tips!Lubo

Do you know what's the difference between RGB24 and RGB48? I know a byte is added to the pixel, but what's the real impact on the image?

Hi,I have an FMW file that runs various SQLexecutors and produces an excel file. Once the file is created I would then like to open it for the user to view/edit/save etc. I have the transformers to do all this, the problem I have is delaying the opening of the file, calling the SystemCaller transformer AFTER all the SQLexecutor transformers have been run and the excel file has been created.Thanks

Hello, How can I remove all blank lines from an attribute values. Blank lines are as shown in next screenshots Thank you very much.

Encountered an issue with the DateFormatter in 2016.1I'm reading a date/time from an Oracle DB and using the DateFormatter to set the destination date format as FME Date (%Y%m%d) using automatic detection on the source date format. However,every date is returned as invalid.If I set the source explicitly as %Y%m%d%H%M%S it works fine.If i copy and paste a DateFormatter from a 2015 workspace, it works fine with exactly the same data input.Is this is known issue, all the dates are valid and auto detection worked fine previously?

I'm trying to transform a Revit file, also using his IFC file, into a CityGML format file. After TestFilter is being used to get the different parts of the building, i have to preserve the hierarchy between the openings of the building, the walls and then the windows and doors.At first i'm using the Openings as the requestor in the Transformer FeatureMerger and the result Walls from TestFilter as the supplier. Then the merge from the first transformer is being used as the supplier to a second FeatureMerger and the result from TestFilter, Windows_Doors, is set as the requestor.The thing is, although i get all the possible merged features from the first FeatureMerger, the second will list all the features into UnmergedRequestor and UnusedSupplier.Should i change anything in the geometry of the windows_doors factor or is it something completely different from what i'm thinking, that is actually missing?

Hi,I have an SQLExecutor that uses some Public Parameters in the WHERE condition. If the user leaves the Parameter blank then the query look for blank "" fields. How can I dynamically control what goes into the WHERE condition, so when the parameter is blank we exclude that condition?Thanks

I have signs along a road network and need to add a measure value attribute. I have gotten as far as Measure Extractor with valid measure values. I can't figure out the next steps. I can't use the ID field in Feature Merger as it does not know which segment belongs to which sign.

Hi,3D Tiles Writer writes default values of baseColorFactor, metallicFactor, roughnessFactor and emissiveFactor. How Can I change their default values ? Is there any Material Transformer in FME?

I need to add an attribute with a running counter to each row in a CSV-file. However, by using @Count() or i.e -4400+@Value(L_SAG_PK) or other similar attribute values, it seems to stop working when the resulting value exeeds 127. How do I generate bigger numeric values.

I am using the GeometryReplacer with the "OGC Well Known Text" Geometry Encoding. The Geometry Source is "CIRCULARSTRING(@Value(StartX) @Value(StartY),@Value(MidX) @Value(MidY),@Value(EndX) @Value(EndY))". It nicely creates curves from the StartXY, MidXY and EndXY coordinates. But 5% of the curves show the remainder of the curve, not the curve as it is defined by the input coordinates. What is the reason? 

Hi,  I have a diffcult time grasping the differences between FME Cloud and FME Server.  Mainly I want to use REST API to interact with FME Cloud via web forms but I can't seem to get anything to work 100%.  I trying to duplicate some of the upload examples on the demo page and it seems I must be missing something. https://playground.fmeserver.com/demos/  

Hello,  I have an attribute that has values like this (the attribute itself is RegEX expression):^[1-9]{1}[0-9]{1-3}[1-9]{1}[0-9]{5-7}$In this attribute I want to replace all - that are within {} with a ,  I tried using the String replacer by first selecting all curly brackets with dashes, like this : \\{\\d-\\d\\}And then replacing it with this:\\{\\d,\\d\\}But of course it does not work cause you cannot replace with regex.  Any ideas?  Thanks ! 

We often re-segment our Road Segment data (polygons) with GPS collected points. The points do not necessarily fall within the polygon. Is there a way to split the polygon with the point data? The image shows the result I'm after.

I am trying to use FME to remove road allowances from a feature with multiple polygons, I've tried sliver remover and dissolve with no success Please refer to the attachment for a picture of one feature that has gaps between ploygons. I would like to remove the gaps and just have one ploygon per feature.

Hi,We are getting new hardware. Our production FME server from 2013 has just 4Gb RAM.Our idea is 28Gb RAM, 4 cores, 56 Gb storage SSD for OS, 250Gb second SSD disk for FME Server installation, data such as the database and repositories and the temp scratch folder. It will be an on premise virtual machine based - sizing I have based on the D12 Azure sizing. We are an electric and gas utility with 2 engines for our FME Server. We are running predominately jobs in and out of Oracle Spatial / SDE. The FME Server is not used at the moment for Smallworld to Oracle conversions. This is carried out by the Smallworld Sync manager product.Anything you would change with the specification?Thanks,Annette

Hi,We have recently added a second FME Server for acceptance and to test upgrades etc.For now I have restored a backup of production content to the acceptance server.My idea is first create the workspace in acceptance and then bring it into production by changing parameters using named database connections or the path to the SDE connections. The acceptance workspace will be the principal workspace that is edited first for changes and then just pushed to production. Pretty straight forward. Are there any other best practices that we should be aware of? I see that there is limited Git Hub integration. https://knowledge.safe.com/questions/57930/publish-workflows-from-github-to-fme-server.html We are going to implement Git Hub via Team Foundation Server in the future but it appears you can just check the history and not overwrite a workspace. Do people store 2 versions of the workspaces in Git (one for acceptance and one for production)?We have 3 teams using the FME Server so it wil

DonutBridgeBuilder transformer works fine when output is a file geodatabase but it does not create correct polygons when output is a feature class in the enterprise geodatabase. Any idea?

I'm facing a strange situation in v2017.1 I have a fairly complicated JSON Templater, using several sub-templates, joining several inputs on a "group sub-features by"The output have most sub-templates outed as "None", and as I watched it processing, I realized the JSON Tempater started outputting some features even before receiving a single input from some of the sub-templates inputs streams. (those are quite longer to process, retrieving several additional data from the database, then using python to pivot some data and generate list of json elements itself to nest in the main json) How is that even possible ? Is it not waiting for everything being provided to it like any other junction transformers ?

I have pointcloud data for a group of buildings ( see screenshot).I would like to convert the pointcloud into a 3d model which can be used in a CAD System. The rooftops need to be converted to extruded polygons. Could anyone briefly give some ideas regarding how to do this? I have already tested the model created here on the FME youtubne channel (https://www.youtube.com/watch?v=_HCkyrS3ukY) and got some pleasing results, but the model uses simple flat polygon geometries for the rooftops. I would like to somehow create sloped roofs derived from the pointcloud. Any help would be much appreciated.

Hello everyone,I have two software that accept geometry in two different format. Software A uses WGS84 and B uses GDA94. I need to translate geo data on the fly between two system (e.g. A SQL trigger exists that updates record in other system's database table when data is updated and vice versa).I want to know how can I convert geo data from one format to other using *within SQL*. I cannot use FME Desktop and FME API since that would require solution to work outside SQL Server.Any help is appreciated, thanks in advance.Regards, Bhargav

I've figured out how to get the vertex info (Coordinate Extractor for Vertex (0) & vertex (-1)) but there doe snot appear to be a simple way to do this. What I am looking for is functionally similar to NeighborFinder. I'm in the telecom industry & I have fiber that is running down a line of poles At each end of the fiber I need to get the PoleID for the nearest Pole & add it to FromPole & ToPole fields. If NeighborFinder would work off of vertex references or X/Y Attributes it would be simple BUT it does not so I need some help.Any Ideas - preferably using native FME 2017.1 only