Transformers

I have hundreds of html tables based upon a year/month selection. I have figured out out to generate the html files. The problem I am having is converting the html to a usable tabular format. Example url. http://bbnet.gein.noa.gr/alerts_manual/2006/01/manual_alerts_01_2006.htmlAny Ideas?Thanks Frank 

Hi,I'm having problems using the Clipper transformer with 19 las point clouds as the input / clipee and a MapInfo tab file as the clipper, with the output being written as LAZ files. The workspace works fine if I just run it in isolation, as shown below:However, in addition to the output from the Inside port of the "OSTile_Clipper" being written as a series of LAZ files, I also want to put this output this through a 2nd clipper (ControlSurfaceClipper) as the Clippee and have it clipped against another MapInfo tab file.On enabling the ControlSurfaceClipper tranformer and it's associated Clipper input port, all outputs from the 1st transformer are now output via the "Outside" port and no data is output, as shown below:

Hi, I am using FME Desktop 2016.1.3 on a Windows 8 computer with 12GB RAM. One of the readers I am using is the MSACCESS_JDBC reader. While initialising that reader (it seems even before starting any reading) FME throws the error "java.lang.OutOfMemoryError: Java heap space" and cancels the translation. How can I tell FME to give more memory to Java?Many thanks!!!

Hi, I have two GDB schemas, one is the original design (empty) and the other came back from our contractor with data added in it. They sometime play with the schema to fit the data in it, for example originally Non-Nullable columns have been changed to Nullable or changed the width of the column, etc. I need to compare only the schemas of both the GDBs (original and contractor's) in such a way that FME should report the differences in Field Properties (Allow Null Values, Length etc.) and other normal comparison of number of column, their types etc. Matcher and ChangeDecector does not go that deep into the schema. Please let me know the easiest solution as I am not FME expert. Additinally, just to give another direction to thinking, I would like to say if XMLs of the GDBs of any use for this purpose. Regards AsifM

I'm using the Tiler transformer to split individual polygons by a specified number of horizontal and vertical tiles. This overall works perfectly for polygons that are generally horizontally or vertically oriented. However, this functionality is lost when attempting to tiler polygons with "irregular" orientation (see image). Any suggestions for how to account for this? It'd be great if the Tiler transformer had an option to use the the polygon's geometry and tile starting from the longest measured side?

Hi AllI have raw data like this. line_idnumberXYTypeLINE01144.0756.38anchorLINE012--interLINE01344.0956.4anchorLINE014--interLINE015--interLINE01644.0956.37anchorLINE017--interLINE018--interLINE019--interLINE011044.1256.39anchorLINE02144.2356.4anchorLINE022--interLINE02344.2456.5anchorThis is poles which form electric lines. As you can see I have only coordinates for anchor poles. The question is - how to calculate coordinates for intermediate poles? with assumptions:intermediate poles located on the line between two anchor polesdistance between poles in one span is equalThanks in advance

Hello,I have a job that reads data from a MSSQL database. The date format comes in like this.%Y-%m-%d %H:%M:%SI am writing the data out to a csv file in this format %Y%m%dI am running workbench and server 2017The job works perfectly fine on my workbench but fails with this error when published to FME server.AP_Latest_Survey_Date_Formatter_<Rejected>(TeeFactory): AP_Latest_Survey_Date_Formatter_<Rejected>: Termination Message: 'AP_Latest_Survey_Date_Formatter output a <Rejected> feature. To continue translation when features are rejected, change 'Workspace Parameters' > Translation > 'Rejected Feature Handling' to 'Continue Translation'' AP_Latest_Survey_Date_Formatter_<Rejected>: Termination Message: 'AP_Latest_Survey_Date_Formatter output a <Rejected> feature. To continue translation when features are rejected, change 'Workspace Parameters' > Transla

I have a line shapefile, can I convert this to a csv file displaying a column of well-known text?

With XMLUpdater I am changing values in an XML-file. I'd like to generate the xpath dynamically based upon a column ('Attribuut') in an Excel file. However, when I select this attribute in the text editor for the XML Path, the generated code is wrong. It is://*:featureAttribute[*:name/text() = 'fme:get-attribute("Attribuut")']/*:definitionwhere it should be://*:featureAttribute[*:name/text() = '@Value(Attribuut)']/*:definitionI can change this myself and everything works fine, but I'm just curious: Is this a bug, or does FME generate the xpath as one might expect? Is it something I do wrong?

My aim is to update the creation date in the metadata of a feature class in ArcSDE using XMLUpdater.However, with the workspace I've build so far, the value is not changed.At first I thought I might have the XML path wrong. But I did some testing and found that when I simplify the XML (leave some nodes out that are further on in the XML file) everything works fine.So my attached workspace works fine when I use the attribute geodb_metadata_string_simplified as the XML input, but it doesn't when I use geodb_metadata_string. Do you know what might cause this problem?

The python api has a method for checking whether or not any part of a feature's geometry contains measures. http://docs.safe.com/fme/html/fmepython/api/fmeobjects/geometry/_general/fmeobjects.FMEGeometry.hasMeasures.html#fmeobjects.FMEGeometry.hasMeasuresIs there a non python transformer equivalent? I don't need to extract any measure values, just check whether or not they exist.

Just wondering if anyone has tried the (very) new DICOM reader in 2018.1 Desktop.I would like to process several folders of NON-MEDICAL DICOM CT images in an engineering application, using the raster (relative density) data returned in x,y by z slices to create a fully dimensioned 3D model suitable for viewing in a standard browser.Being able to project the DICOM x,y,z coordinate system into a real world coordinate system would be a distinct advantage, as would being able to contrast and window to observe specific features.Any experience people have with this greatfully appreciated.

I want to take a DEM with a 1 foot resolution (horizontal) calculate slopes and output two polygons 1 with the slopes drom 12 to 17 degrees and the other with slopes above 17 degrees. the rest can be discarded. Is there a sample workspace I can study to perform this?Thanks

Hi there,I have a workspcae on FME2018 reading 2 shapefiles one has point geometry (1.7million) one has line geometry (7.5million)I am trying to find the distance to line geometry and this workspace was working fine until I changed the line Geometry shapefile to ESRI File GeoDatabase.I have the following error on 220 lines now. what is this mean? Can I ignore this error and use my results?NeighborFinder(ProximityFactory): Processing 1.09% completeIFMELine was given an index beyond its current range... Last line repeated 55 times ...NeighborFinder(ProximityFactory): Processing 1.1% completethanksPushpa

Hi,I would like to know if FME provides a transformer or a logic allowing to derive the similarity between 2 shape geometries. There are concepts such as the Hausdorff distance which could probably be used to some extent for that purpose. This similarity could be for instance expressed as a ratio but I don't know exactly of what yet. Basically I would like to be able to determine if 2 overlapping shapes are similar enough and can be considered as representing the same object in reality.Thanks in advance for your hints!Olivier

Hi,  I am looking a transformer that could work like the XY to line tool in ArcGIS.  For each spot I have a beginning lat/long and an ending lat/long on the same row.  I would like to connect the lat/longs on each row as a line and then move to the next row as a new line feature.  I have tried pointconnector which works great for sequential rows but I have not been able to get it to work in this manner.  Thanks.

HiI'm trying to use the anchored snapper to snap polygon boundaries to cadastral lines. However, it only seems to snap the vertices of the canditates and doesn't create extra vertices in between to make the polygon boundary align to the cadastral. Is there a way to force it to create additional vertices where necessary?

We have a number of AutoCAD files that contain geographic information through a Geographic Marker placed in the file. The geographic marker contains enough information to project the XY data into latitude and longitude, but I cannot work out how to access the XY position of the marker, nor the rotation of the XY axis from North (these are embedded in the AutoCAD file). Any help describing how I can reproject the AutoCAD files to lat long (for output to GeoJSON eventually) is greatly appreciated.Thanks!

Hi does anyone know how to use RegEx to extract a URL from a tweetexample have this: #Birminghamfloods This is Aston at 5pm https://t.co/XDDVtexNdT need to extract this into a new field - https://t.co/XDDVtexNdT

Hi,I am trying to figure out how to insert disclaimers/metadata from one folder to all zipped folders within another folder?  My setup involves Reading from an SDE connection, an InlineQuerier transformer to definition query various private data fields out of the data, an Attribute Keeper transformer to keep only the pertinent fields for public viewing before 6 different writers take the data and convert and zip to file geodatabase, kml, shapefile, AutoCAD, CSV, and GeoPackage. With each feature class/dataset being converted into 6 different formats into a single export folder. The naming convention will be standardized (Parks_KML.zip, Addresses_shp.zip, Water_FGDB.zip etc), I need to insert a text disclaimer file into each of the zipped folders. I thought using the FileCopy Writer from this example (https://knowledge.safe.com/arti

The question is:Which areas have more than two points in it.So I want to make a selection of points in a lot of area..Visualize if there are more than one point in a polygon (a lot off points and polygons)

Hi all,Is there a way to trigger a topic if a job is cancelled or just send a email? I have a script running in on a schedule with a Running Job Expiry Time. Sometimes my job exceeds this time and is cancelled, but that does not result in a failure (or success). Thanks in advance 

Hey! I've been troubleshooting an issue with FME for a couple of days and I thought I would reach out to y'all to see if anyone has any insight into the problem. Our office publishes lobbyists datasets to a socrata data portal from tables in an oracle database. We use FME workbench to push the data from oracle to the data portal. The problem is, all of the dates are displayed as one day behind the correct date in oracle. The dates in oracle are stored as a Date/Time value and I've fiddled with the date formatter in FME, but no such luck on resolving the issue. I noticed that the dates in the data portal are stored as Date/Time (with timezones), so I have a theory that the issue has to do with timezones, but I can’t figure out to switch the socrata column’s data type to Date/Time in FME. Does anyone have a suggestions or advice? Thanks!

I have a complex geometry which contains one vertex that I want to remove.The 'offending' vertex is in the first element, the PolylineGeometry(35):The vertext I want to remove:I tried using something like @takashi suggested in my previous post, but obviously the arcs were lost.I would like to ONLY remove that one point (and similarly in other complex polygons) and have the rest of the geometry unchanged. I'm an FME neophyte, so is there a way to do that?Thanks for any help!

hi everyone ? have polygons and point cloud. ? use Clipper after that ? change point cloud z data ? need this math fonction (( all point cloud z value - polygon z value)) can you help me pleasersvp.