Transformers

I have a workspace where I am trying to read and write to a SQL table (ArcGIS line feature class). The reader is an abandoned line feature class that contains a length column (double, 38 precision, 8 scale). The writer is an active line feature class that contains the same length attribute set to the parameters listed above. When trying to write features from one to the other I get the message "Column 'length' of type 'double' specified in mapping file but not defined in existing table". There is an older post regarding this topic but it did not provide an answer, it dealt with creating a new feature class. My workspace is simple, it contains two readers one is the abandoned lines and the other is a cad file; I use a NeighborFinder to select only the abandoned lines that match the cad file; I have a TimeStamper and AttributeManager after the NeighborFinder; then the writer. I have tried using the length calculator and setting the value to that in the attribut

Salesforce Reader/Writer in FME don't support read type base-64 data from Salesforce. So except salesforce reader, is there any way to read type base-64 data from salesforce by FME?

Hi, I'm fairly new to FME and am hoping to tap into your knowledge! I'm trying to score roads depending on their safety record. The criteria is 4 KSI (Killed or seriously injured) collisions within a 1000 metre stretch of road in a rural environment, and over 500 metres within in urban area, over the previous three-year period. I have a dataset containing collisions across the county over five years, which includes coordinates, severity and date (so i can easily filter out those that are too old or not serious or fatal - 820 collisions after filtering). I have a Mitab file containing the roads (with a unique reference and a field for urban / rural) - but the lines indicate the centre line of the road and as such they do not join at junctions. We're talking about 27,570 links so I can't change this. I can conjure up a way of seeing how many collision points have another 3 points within a 500 or 1000m cluster, but I'm stumped as to how I can link it to stretches of

Hi,I need to find the gaps between two polygons (not auto - correction). Kindly let me know which transformer I have to use?Thanks in advanceRegards,K.Jayakumar

How do I get the version of the transformers in my FME-Version?I'm using FME(R) 2016.0.1.1 (20160224 - Build 16177 - WIN32) and I just got a workbench that someone else made. When I try to open it, I get the following errors: Found transformers in this workspace that are not on your system: 'Dissolver (version 13)' and 'AreaOnAreaOverlayer (version 5)'Both this transformers do exist in my FME-version, but they are probably of an older version. So how do I know, what versions I'm using? What version of FME are the transformers with the above versions part of?thanks, Vera

Hi there,I am trying to write text values imported as attributes to a PDF, and want my text within the 'description' attribute to wrap when it reaches the edge of the page. I have tried to use the TextWrapper transformer, using the bounds extractor values, but no luck. Screenshot below shows the resultant PDF from the above workbench, with title text (Site Diary) and the description as per the transformer below. I've tried adding in the PDFPageFormatter but this doesn't seem to make any differenceAny suggestions?Many thanks

def processFeature(feature):    roleList = feature.getAttribute("tag{}.k")    print(roleList)    if roleList!=None:        for feat in roleList:            print(feat)Above is my quite simple python code that successfully prints all key-values for the tag-list of OSM features. This works the same way in 2.7 and 3.4, as expected. However, if I change the attribute to print the member list instead, I get different behaviors between the two.With the following code:def processFeature(feature):    roleList = feature.getAttribute("member{}.ref")    print(roleList)    if roleList!=None:        for feat in roleList:            print(feat)It prints nothing in Python 3.4 compat-mode, but does in 2.7 mode.How come this happens? My initial thought was that since the member-list only contained one member, it would not treat it as a proper list, but even on features with several members, the behavior is the same.My current workaround is to quite simply use Python 2.7, but this might not always be a 

Hi,We want to capture a view or clip contents (just like clipper tool works for 2D objects) inside a 3D solid object of an 3D AutoCAD file. That's way, we want to take screenshots or directly copy objects individually (they are generally made by block references) to visualize every office department with its floor plans. I tried to read DWG file and then support clipper tool with a geometry extractor, which is extracting 3D solids from same DWG file. Somehow, clipper tool rejects 7 of 8 individual parts and extract only one.Do you suggest any other solutions or workflows for my issue? Floor Plan made by block references inside a 3D solid geometry:A part from my workflow in FME:Also i added clipper log below:Clipper_Vector(ClippingFactory): Processed 1 input feature(s), of which 1 feature(s) were clipped, 0 feature(s) were totally inside and 0 feature(s) were totally outsideClipper_Nuker(TeeFactory): Cloned 0 input feature(s) into 0 output feature(s)Clipper INSIDE Splitter(TeeFactory): 

While reading arc geometry from smallworld, FME converting geometry as a linear, Could any one help us to resolve the issue ? The conversion of the geometry is done by FME internally?

Hi,I would like to create a csv file and set that to Schema mapper.. cause I have a requirement which will generate data dynamically from the folder which contains multiple zip files..Looping through Folder --> FeatureReader(Merging all shape files)-- > Generic --> Schema Mapper (My idea is to create a schema mapper dynamically and setting here)--> Dynamic writer or Featurewriter ..At the same time i have to run through all the folders and then through zip files and set the data to one fgdb.Requirement is.. Here shape files don't have consistent names..1.zip Folder-->1.shp-->Point2.shp-->Polyline3.shp-->Polygon2.zip Folder-->2.shp-->Point2.shp-->Polyline2.shp-->PolygonWill go the FGDB.XXXFeatureClass(Point)XXXFeatureClass(Polyline)XXXFeatureClass(Polygon)Please help me on this...Cheers,Srikanth Dasari

I'm working on a workflow that uses the PythonCaller to extract coordinates from a source file of my choice and puts them in a results attribute. My plan is to replace the existing geometry with the one extracted using the GeometryReplacer with the OGC WKT encoding.As an example:This format needs to go into the GeometryReplacerLINESTRING(161274.467 453784.372,161277.253 453785.924,161279.958 453787.131,161280.921 453787.508)What i got is something like this, but it could be longer or shorter but always has a x and y coordinate but rounding after the comma could be different:161274.467 453784.372 161277.253 453785.924 161279.958 453787.131 161280.921 453787.508 How can you replace every second space with a comma without making it too static?This example contains four coordinates but it could have 8, 100 or more. After this stap i use LINESTRING(@Value(result)) to add the linestring text.

Hi, I have a table with values that I would like to map to different values via an external file. I can kind of make the AttributeValueMapper work the way I want, but only on one "source attribute" at a time. I've been trying to read about the SchemaMapper but the documentation is a little confusing and I'm not sure how to relate the help files to my example. So if I have a table with multiple names and "M" columns like below:And an external file with related values like below:What is the easiest way to map the number values to the letter values of the external file to result like below?Is the SchemaMapper the correct transformer for this? It seemed like it would need the attribute column names to match between the table and the external file, but I cannot rename the table headers. Seems like there should be an easy way to do this that I'm missing. Hopefully I've explained this well enough, any help would be appreciated thanks!

As all we are know there is two type of raster: 1) color raster (e.g. satellite Image) and 2) numeric raster (e.g. DEM). I am find in FME, there is tutorial available for converting numeric raster (DEM) to polygon but I want to precisely converting agriculture crops field which is almost rectangle shape from satellite Image to polygon.Until here, i am segmented NIR image by using new tools in ArcMap Segment Mean Shift. out put of that 8 bit RGB image which has mean value of input RGB NIR image based on spatial and spectral parameter. Now in FME, i want to make pure shapefile of natural rectangle shapes like field in image. i think there is fme raster expression which can done my job. Now in FME i have to design expression based on segmented raster value RGB and once again they marge apropriyetly and make pure one rectangle segment.. Last using RasterToPolygonCoercer we should achieve our goal.Attached file “Sample_Data.rar” has 2 sample file: 1. Originals Image (NIR_Originals.tif)

Hi, I have a work space that creates an error report for a dataset, that I would like to amend. The current error report brings back the error "Area of Outstanding Natural Beauty (AONB)' fails check for case is 'FULL_TITLE", however this isn't an error as the of being lower case is to be expected. In FME, for strings like the above, how can I allow 'of' to be lower case and not be included in the error report please?I think it might be require a regular expression of some sort, but not sure if \\bof\\b would do the trick.Would really appreciate your help. Thanks,JB

Hello,  I am trying to join parcel number to parcel in FME. I am importing geodetic plan in .DWG but I decomposed it in layers in .SHP to manipulate it easily.  I am facing a few problems. My plan is consisted of few layers. All parcels are made of lines and points and first thing I need to do is to make polygons(area) of these lines and points but LineBuilder and LineCloser are not helping me. I also tried with NeighborFinder but that doesn't work for me neither.  What transformer could I use to make area because after that I know how to join attributes (parcel number) to an area.  Thank You in advance, MaliodPalube

I have a CAD file that looked to be in local coordinates and I finally found the handy tool 'Local Coordinate System Setter' and I reprojected it into state plane and almost got the CAD drawing in the correct location but it is still off by a bit and not sure what I am missing. I've tried the Affiner tool to get the direction correct since i noticed in the CAD drawing it has _xdir_x and _ydir_y and so on.Adding those directions into the Affiner tool, it rotated at least correctly but not quite in the right location (blue CAD, green GIS):Is there another tool that i need to use to make it align better or at least get the CAD drawing in the exact locations?Thanks!

i am developing on an offline GIS application and i'm using open street map as my map source .at first i was using postgreSQL but i had to switch to oracle . now the problem is in osm schema . i used osm2pgsql for converting osm data to postgres database with schema in the links below using osm PBF filehttp://wiki.openstreetmap.org/wiki/Osm2pgsql/schemabut the problem is when i add a reader of pbf file in FME , the schema is different as you can see in the image belownow what should i have to do to get the right schema as you see in the link above , cause that schema has more flexibility and references in geometry communities

Hello: I have a surveymonkey survey responses that I have to loop through to capture all of the responses from 1 page. I capture the number of responses from an attribute returned from the GET from the API endpoint and I use that as my loop counter. My question is can I loop through the response body and pass the loop counter to capture the next survey response on this page? For instance, if I have data{}.id as an attribute, in a JSONFlattener can I dynamically set the value within the {} to @Value_count? Any help is greatly appreciated.

Hi! I would like to extract the middle coordinate of a three point arc. With the ArcPropertyExtractor I only get start, end and center point coordinates. The mid point does not necessarily be in the middle of the arc, but helps to describe it, together with the start and end point.Thanks a lot!!

I have the geometry of the route. And a list of stops on it. The length of the path to each of the stops is known. How do I create a point with this data?  In total my task is to apply Z to my 2D route. I have Z for each stop and a route-based distance. As I can understand TopologyBuilder can accumulate that in one 3D route, but do not know how to create that points or how to get XY for them.  Thanks for any hint!

Thoughts on creating an arbitrary number of equispaced lines between two reference lines? If there is an odd number of lines I could probably do something iteratively with thiessan polygons, but I'm a bit stymied with an even number of lines.

Folks,Wondering if anyone else has had this problem.I have previously been successful with passing data to CAD attributed blocksI have a CAD attributed block where the TAG is called XX:8.5However when I configure this as a USER ATTRIBUTE in my AutoCAD writer layer the decimal point is converted to an underscore.XX:8_5Unfortunately when the block is generated a new attribute is added to the block(which I didn't know could be done) called XX:8_5 in parallel with the EMPTY XX:8.5 which is actually a visible attribute. Is there an escape character or something I can add to the attribute to point it at the correct block attribute?