Transformers

Hi, I'm having problems with the JsonFragmenter. When I supply de HTTPCaller output to the Defragmenter some values are adjusted. I can't explain why.Anyone with a solution? Regards,Eddy FME InformationEdition: FME Database Edition (floating)Version: FME(R) 2018.1.1.2 (20190121 - Build 18586 - WIN32)

Hi All.I am having a problem while converting a CityGML file to shape file. In CityGML i have polygons in Counter Clock wise direction. After converting them in to shape file all are converted in to Clock Wise direction.Please some body help me how avoid this.Thanks,Kumar.

For one user, SQLExecutor is correctly changing to connect to DEVSQL\\High at run-time. For another user, the default parameters specified in the SQLExecutor (QASQL\\High as shown above) are being used. What user configuration setting needs to change in order to correctly grab the same database as user #1 is getting?

I'm completing a government return which will need to be sent daily and they require the file to be named as below:"File naming: CAZ-yyyy-mm-dd-XXXX-#.csv where:yyyy-mm-dd represents the date the file was generatedXXXX is the agreed identifier for each Licensing Authority (to be confirmed)# is the total number of records included in the file."The date is easy enough to solve, but I'm hitting a brick wall trying to insert the feature count into the file path. So far I've got:CAZ-@DateTimeFormat(@DateTimeNow(),%Y-%m-%d)-XXXX-#Could anyone help with the #?

If no Vendor port is specified in the safe.lic file, a random port is used. Is the random port really random or is there a specific port within the range of 1700 to 8000 which is used ?

I am looking to tilise aerial imagery tiles into circa 10 zoom levels to go into a map server. The porcess I have at the moment, outside of FME, is struggling. It is GDAL2tiles using python but it is not multi threading and only using one core. Therefore running for 8 days and only producing one level of zoom from 10. I suspect FME can do it but I am not sure how.

Is there a way to tell an SDE reader to forget the spatial? I can read as SQL Server Non Spatial, but I lose the SDE ST.Area attribute, which I need. However, I don't need the actual geometry and reading it wastes 30 minutes.---- Hoping for an "opposite of Geometry Only".Thanks,Jake

The texture image displayed by the Appearance Setter converter is correct, but the texture map written in 3dtile format is incorrect. It should be due to the loss of texture coordinates. When will 3dtiles improve? Currently, it can only be used simply

Good morning, friends. I have the following FMW. I want to cut the different geopack entries so that the top one cuts the one immediately below, creating a sort of pyramid that corresponds to the building's heights. I don't know what I have wrong with the custom transformer.In this case, there are this number of heights; in others, there are more or less, meaning they vary.Thank you.

Dear all,I'm quite new with FME and I'm facing my first issue on my workspace.I would like to retrieve a BLOB from an Oracle DB.This BLOB contains a ZIP file of a DXF file.I would like to read this DXF file with autocad_extended attributes. Currently, I'm stuck at this point: I read the BLOB, I create an attribute (for future transformations), write the file on the file system and extract the zip file.Now, how can I read the DXF file extracted from ZIP with autocad_extended attributes? Thank you for the support!Best Regards,Michele 

Hi,I have some points (boundary stones) that should be aligned on the contour of boundary polygons. Since the field location accuracy is known to be inaccurate, I want to snap the points to the contour of the polygons.I supposed that AnchoredSnapper was the transformer to do this. And it seems to work fine. However, when I further apply a PointOnAreaOverlayer transformer, although all the points visually seem to be on the polygon contour, some points have 0 _overlaps.when I check the output of PointOnAreaOverlayer some snapped features have _overlaps = 0I was careful to link the snapped output of AncoredSnapper to PointOnAreaOverlayer.What am I missing ?

Hi all. I'm having some trouble reading the Feature Types in the Microsoft SharePoint List reader. I've uploaded an XML file for the Web Connection and successfully tested it. When attempting to read the Feature Types it throws the error in the attached image. I have permissions to access the site and I can open the same URL to the SharePoint site when it throws the error. What have I missed? It's my first time working with SharePoint lists in FME so any information is appreciated. Thanks,Michael  

Hi, When I export a revit project to .rvz, the linked files aren't exported. I have forgotten to check off an option, or the plugin is not able to export the linked files ?

Recently it occured to me, that I have to solve a set of seemingly similar control flow problems in FME quite often.Starting point is a workspace which is re-used for different scenarios. A generic approach to solve a family of similar tasks.Basic problem usually is the behaviour of transformers like Clipper, AppearanceSetter, and similar ones which need two (or more) different streams of features and produce a result which combines the data sets.Clippers clip Clippees, Geometry is textured with rasterdata, ... you get the ideaProblem starts whenever one of the necessary datasets is missing.E.g. the result stream of a processing may need clipping and goes into the Clippee port of the Clipper. If there are no Clippers available no output is produced.So as a workaround I need to fumble around with a FeatureMerger and several helper transformers to let the resulting stream pass by the Clipper whenever there happens to be no clipping feature.Or I need to avoid the AppearanceSetter if eithe

I'm having trouble using AttributeSplitter to split everything with a semicolon as delimiter, EXPCEPT skip seimcolon's that are within parentheses. Please help! Thanks! Example 1424462 (EXT: 1488296; 1491537); 1428106; 1436651; 1436653 What I need is:1424462 (EXT: 1488296; 1491537)142810614366511436653 

In Attribute Manager I have created 3 fields (Borough Code, Block_Leading, Lot_Leading), 2 of which have leading zeros in them. I need to concatenate the three fields into a 10 digit string while retaining the leading zeros in the order listed above. My formula for for Block_Leading is @PadLeft(@Value(Block),5,0) and the formula for Lot_Leading is @PadLeft(@Value(Lot),4,0). Can I concatenate all three fields in a single formula in a new field in Attribute Manager and if so how? 

I have a dataset of approximately 3.5 millions points that I pass in a pointOnAreaOverlayer and send to a MapInfo Writer.  However, I have a bunch of warnings that say: Below feature has too few coordinates -- a region feature needs more than 3 coordinate pairs  It seems, the writer is mixed with the geometry type, and is trying to write them as area, but there is only points. I even do a geometryFilter before the writer to filter only the Points.  What is the problem? What can I do? I am using FME 2014 SP4 build 14430 Win 32 

I would like to write features into the versioned feature class which is participating in the geometric network. Unfortunately, if I good understand https://knowledge.safe.com/articles/34856/working-with-esri-geometric-networks.htmlthis is not possible unless I drop geometric network and recreate it on the end of the process(of course this requires de-versioning of feature classes).In my current project, de-versioning of feature classes and dropping of geometric network is not an option. This will require daily posting of all versions which is impossible in the current process workflow.Does somebody have an idea how I could implement solution in FME which would give me possibility to write records into a versioned FCL which belongs to geometrc network? At the moment I am thinking on implementing python caller which will perform this task...Thanks in advance,Dušan

Hello,to simplify/reproduce my problem:  I added a User-Parameter on my Attribute-Remover: Which grants me a choice to select which to ignore, but (same as here Attribute Remover does not work with User Parameter | Community 8 years ago) it only removes the values and not the attributes, so when I write it into my database or even a new excel, it creates unneeded columns.Manually selecting attributes in the Attribute-Remover works fine, this only happens when using user parameter. Am I missing something or is there another way?P.S. I also tried AttributeKeeper with User-Parameter, but then they’re unexposed, so I would have to iterate via AttibuteExploder, which simply seems unnecessary complicated...

No real question, but I want to share some insights for my Belgian colleagues. In FME, there are two 31370 coordinate systems: EPSG:31370 and Belge_72.Lambert_72_FME. They are exactly the same, except for the Esri WKT Description. The first one contains false easting and northing up to 5 decimals, the second one only three (like the OGC WKT). Until ArcGIS 10.6, you have to use the EPSG:31370, with the additional decimals.Starting from ArcGIS 10.7, ESRI changed the description of the coordinate system and applied the OGC values with 3 decimals.  Opening a filegeodatabase with EPSG:31370 in ArcGIS 10.7 leads to a 'custom coordinate system', not recognised by the software. Using the Belge_72.Lambert_72_FME coordinate system in FME avoids this issue. I hope this post will help some people saving some time.

Hi everyone,Noob here.I want to translate (move) the red lines in order to have the ending (or initial point) on the red line over the blu line. The length of the red line does not have to change. I tried with anchored snapper, but I think I need an anchored mover?!The red lines can also have many many vertices. Thanks,Have a nice day. 

String text = "John.Davidson/05051988/Belgrade Michael.Barton/01011968/Krakov Ivan.Perkinson/23051986/Moscow";

I'm reading an ArcSDE polygon layer (British National Grid), running it through the Aggregator, then writing to a TDE. But I get a warning in the log "TDE does not support geometry on feature". I can't see much in the way of parameters to change to try and fix this. Any ideas? FME 2018.0.1.0 (20180518 - Build 18310 - WIN64)

Hi, Is there a way to change the color of the font for the part of the text that matches regex? In the scenario below I would like to put in red only the double spaces in Excell At the moment is highlighting the whole text in excel 

Hi All,I often encounter difficulties when attempting to select specific raster values using FME. I am currently working with a raster dataset that contains two bands, and I need to isolate the following values:Band 0 (GRAY8) = 3 Band 0 (GRAY8) = 4Could you please advise on the appropriate expression to use within the RasterExpressionEvaluator to achieve this selection?Thanks :)