Transformers

I have created a polygon layer from a numeric raster. RastertoPolygonCoercer shows a _label attribute to be created and this appears in inspector as the values from the raster. Perfect - but - I want to ensure this is carried through and written out to shapefile - except I can't "see" the attribute in subsequent transformers. So I thought attribute creator and map the attribute to a new field, or attribute exposer and ensure it appears, or even attribute mapper sounds a possibility. Except when it comes to picking the attribute you want to make available (_label) it doesn't appear in any list of available attributes. It doesn't appear in a shapefile written out and I don't know how else to access it - Help.....

Hi all, I'm running into this error when I try to run some queries inside SQLExecutor. Select * into * not allowed in sql executoris there any other way around? Thanks.  

I have been trying to use transformers Sorter and ListSorter to sort multiple attributes with numeric values without success. Any help will be deeply appreciated. Thanks!

I need to check a lot PDF file with energy bills, look the barcode and get the numbers to make the payment.So, with FME is it possible? Check this barcodes and convert to a text file or xls with all the numbers in a column.

X, Y, Z coordinates of point cloud.

Hi guysI am looking to create a buffer where I have a rectangle. I would like the north and south to have a scale range of 1km and the east and west to have 2km. Then to have it all in one shape to show the buffer area. What would the best way to do this with the buffer tool in fme. I have seen something with python which is possible but is there anything similar in FME.Thanks

I'm having an issue writing vector data and an image together into a pdf. The vector data is coming from a sql database, the image is from a web source. I'm using the ImageFetcher to clip the piece of image I need. The bounding box of the image comes from a buffered of all the vector data I'm writing to the pdf layer.The vector data are pushed off into the corner when I attempt to write both the image and the vector together. I'm following the example of how to create the pdf from a sample workflow from Safe. The only difference is that the image in the sample comes from a file and mine comes from a web source. Would appreciate help with this. Below are the workspace image, and the image of the pdf with and without the background image.

Hi,I'm having this error sometimes (not always, that's the weird part) when I try to convert an attribute that has 3 possible values (0, 1, null). what is the best way of solving this problems.Value of attribute 'isReg' could not be converted to type 'int2'. Feature will be logged and skipped... Last line repeated 1229 times ...

Hello everyone,I have a workspace where I'm trying to extract the two different 'styles' out of two attributes. In both attributes there are some strings that have 9 values, and some that have 11. I tried to use a TestFilter to extract these four separate styles into their own output. I've attached a photo of the statements I used. One problem I was noticing was that there was no attributes being cached at one of the outputs, even though the prior transformer output had the attributes present. Inspecting some of the cached features seems to be misleading, and sometimes shows missing values. Could someone tell me what I'm doing wrong? I can attach the workspace if needed. Thanks,Reid

Hi all,  I have two different datasets and both are consist of line string. I would like to insert new nodes in the green line at the projection of the last/first node of the red lines. The desired new nodes are presented by red points in the following picture. Any idea? Thanks in advance.  

Enterpirse geodatabase in oracle. Exisiting column has a datatype of double with values of 1,2,3 etc. I want to use ValueAttributeMapper toremap these values to sphere, board, cube etc. If I change the datatype in arcmap from Double to VarChar2 does it need to be empty or will the workbench take care of this? TheWriter currently has Drop Table: No and truncate Table: yes

I have got an amount of points which are the locations of fire hydrants. Each of it can deliver a certain amount of water (Liters / Minute) in a radius of 300m for firefighting purposes.I have created a buffer around each point and now I want to calculate the amount of water for firefighting purposes in the buffers an in the overlap areas and in the non-overlap-areas.  Example: I have Hydrant #1, which can deliver 2000 l / Min, and I have Hydrant #2, which can deliver 3000 l / Min. In the overlapping area, I have 5000 l/min of water supply, in the non-overlapping-area I have a water supply of 2000 l/Min (Hydrant #1) or 3000 l/min (Hydrant#2) respectively. Of course, there are many more hydrants to look at, and in some cases we have a dozen or more hydrant areas which are overlapping. I have used the "area-on-area-overlayer", which seems to work properly, but I don't know how to calculate the sum of water supply in the overlapping area. Is there anyone who can help? 

recently?i have tried translate revit model to cesium tiles?but donot know how to translate with texture?how to set it in right geolocation which set in revit,anyone konws how to do this? Thanks in advance.

Fun fact, is that FeatureWriter writes to a database path of ":memory:" for SQLite and SpatiaLite formats (or seems to at least). For SQLite buffs, this is a virtual database instance written entirely in RAM so cuts down on disk/temporary file overheads and is highly performant. It is a feasible way of combining in an FME workspace non-SQL, procedural type transformers together with the power and lower overheads of the SQL engine contained in SQLite when your features also happen to be highly data relational and can be indexed (plus take advantage of the extensive spatial library functions that come with SpatiaLite as well)However, for the life of me I can't figure out any way to use an in-memory SQLite DB from there in a workspace, say with an SQLExecutor. It seems as soon as FeatureWriter finishes it closes the connection to a database written to ":memory:" and no further reference is held to it (and because the DB is volatile then the Transformer essentially

Per SQLite documentation, Real and Numeric are supported and Real is of a Float type. However in InLineQuerier Numeric is not an option, only Real and Float to pick. Due to precision issues of floating point, we would prefer to use Numeric in several cases. Please advise.

Hello!I've been having some issues with the cumulative output from StatisticsCalculator - it seems to be giving me the complete sum rather than cumulative sum of the chosen attribute. Simplified example:Anyone come across similar issues? Suspect this might be a bug.Cheers!

What does the "Blank Attribute Value" do? I am having a hard time finding it in the docs... 

Hi FME'erI have created a shape file of crime data and I also have a boundary shape file of the neighborhood. I want to create a heat map to analyze which neighborhood has the most number of crimes for which i will be needing the count of total number of crimes that have taken place in that particular neighborhood. But i don't know how should I proceed to be able to do a spatial join and to calculate the count of crime points in each neighborhood polygon such that the output polygon will have an attribute field of the sum of the crime count. Any help and guidance will be much appreciated. Thanks in advance

How do I transform from NAD83-Original (1994) to NAD83-CSRS for areas which don’t have a provincial grid shift file? (e.g. Yukon, NWT).All new incoming data are NAD83-CSRS and I want to bring our older holdings up to match. I don’t have confidence in the automatic methods chosen by ArcMap/Pro/others in project-on-the-fly situations. I’ve seen too many instances where different coordinates are reported for same points from different methods.With csmapReprojector the process fails with:CS-MAP Reprojector: Transformation will be automatically selected for 'UTM83-8' -> 'CSRS.UTM-8N', and is not guaranteed to remain the same in future releases of FMECSRS :: Referenced grid file does not exist or cannot be opened for reading.A fatal error has occurred. Check the logfile above for details...CsmapReprojector (TeeFactory): CsmapReprojector: Reproject: Could not reproject the geometry of the preceding feature: CS-Map Reprojector: Unable to load grid file for 'NAD83_to_CSRS' | CS-Map Reproject

@takashi Hello!I'm having difficulty to update a network lines with new survey points. I want to shift each vertex point of a line (in red) with unique nearest point (black). Can someone help me please? Thank you.

Hi, Having trouble describing my problem to Google it, so apologies if I've used the wrong term or missed something obvious here. I'm just starting to use FME so please be nice! :D I have a spreadsheet which contains owners of properties in this format:PropertyOwner 1 NameOwner 1 Addr1Owner 1 Addr2Owner 2 NameOwner 2 Addr 1Owner 2 Addr 2 And so on for up to 4 owners per property. Properties with one owner have blanks in the Owner 2/3/4 columns. I'd like to reformat this to individual records for each owner, like this: PropertyOwner 1 NameOwner 1 Addr 1Owner 1 Addr 2PropertyOwner 2 NameOwner 2 Addr 1 Owner 2 Addr 2 PropertyOwner 3 NameOwner 3 Addr 1 Owner 3 Addr 2 PropertyOwner 4 NameOwner 4 Addr 1 Owner 4 Addr 2  In the real file there are several property columns that I'd like to copy down to all other rows for that property, and obviously if there is blanks I don't want to create new rows.Is this possible in FME? Can anyone point me in the right direction? Thanks,

Hi,I know that numeric count only count the features which are integer or floating point, but I was wondering if an attribute has no value (only empty cells), does the numeric count return a zero?I'm trying to count the number of instance when a given attribute has an empty cell has a feature. thanks

Hi all. I'd like to populate a new attribute D with attribute C value from a feature of my table, where its attribute B is the same as attribute A of my target feature. So attr D and A, target feature, attr B and C referent feature. Is it possible? Im use to work with 2 readers, not sure how to do it with one. Many thanks!

Hi,I want to convert 1000 jpeg files to pdf format. I have almost managed to finish the script but the one thing that i smissing is that the PDFpageformatter that I am using cannot be adjusted for each jpeg picture. What I am trying to say here is that i want the pdf to be the same extent as the jpg file without doing this manually (since I need to convert 1000 files).Heres a picture of my script in FME

Hi,I would like to read data from a WCS service in a way that it reads only the part of my projectarea. It seems that the way to do this is using a Feature Reader and use an spatial filter in the Feature Reader. Unfortunatly this is not working. The URL created has the wrong bounding box value. The error I get is: "returned Content-Type 'application/vnd.ogc.se_xml; charset=UTF-8' is not supported". I can read the exact data using the WCS reader by using the search envelope, but this is not what I'd like.Another way is to compute the extents in one workspace and call another workspace with the workspace runner with the extents as parameters. But it should also be possible withe the Feature Reader.Anyone any idea how to fill the bouding box within the Feature Reader for a WCS service? Greetz,Arno