FME Form

Hi all, Good morning, The challenge we have is: to put a signature (image) in a particular cell in a table in an MS Word document. We have got something working, but we would like to have your kindly advice. Situation:The signature is read from an AGOL attachment as a blob and with a RasterReplacer and a RasterResampler it is turned into a JPEG (which is visible in the Graphics window). To put this image into the Word document we could use an MSWordStyler where we set Image Source to From Feature.But because of the very specific location of the image in the doc (in this particular cell in this particular table) we use a Python docx solution in a PythonCaller. Question:The solution we have now is to temporarily store the image and then retrieve it to put it on the right location in the doc. And this works... But, but, but wouldn't it be possible - inside the PythonCaller - to read the image "

counter_Expressions

Hello all, I am trying to merge two different layer data from DWG file. In that one layer is line geometry and another layer is point (text) . Here I wish to connect text to nearer line geometry but I tried different transformers but I could not !FYI - I tried spatialfilter, Neighbourfinder Thank you for advance!

Hello everyboy! I got two different point feature classes.  The neighbor finder lets me do the 1:1 and 1:n relation which is fine.  Now i would like to perform a spatial many to many (m:n) relation of the points of the two feature classes but i can't figure out a decent way to do this in fme. I really appreciate your help! Thanks a lot!René

Hi, I'm Pol and I'm quite new to FME. In one task I have created voronoi cells from points that share the same value of an attribute and at those points that have a unique attribute value I have created a buffer of a given radius. I did this in order to create an influence map for a certain attribute.The problem I've run into is with the overlapping buffers on the border of the voronoi cells. This is the current result:  this is the desired result:   How can I do it? I've tried the donut builder and the hole extractor but I can't get it to work. Any help is great, thanks in advance. Pol   

Wondering how to create a hyperlink that will show the blue underlined text value in a field and when you hover mouse over the text you will be able to click on a url. My Writer is to file geodatabase. I have a single url that I want to associate with the text values in a field. Attached is what I have done so far using the AttributeManager Conditional Parameters. I do not want the actual URL to appear in the field.  

I have been investigating replacing my use of SQLite Spatial (GDAL) with the new (FME 2022) SpatiaLite Native format.Previously I used to be able to start a workspace with a SQL Creator with a statement like:SELECT id, column, geometryFROM table With a script like that, the old SQLite Spatial (GDAL) format SQLCreator would read the geometry correctly from a database created by a SQLite Spatial writer. However, I can't get the same to work with a SpatiaLite Native SQLCreator selecting from a database created by a SpatiaLite Native writer. Instead of reading the geometry of each feature, it reads a blank string attribute called geometry.Is selecting a geometry with a SQL statement no longer supported? I can probably replace this sort of use with Readers, but would prefer to not.Thanks.

Hi, I have three features; each feature has a lat and long column. How do I read the lat/long to visualise the features as points on a map (e.g. HTML map or in the Visual Preview within FME)?

I have a bunch of CSV spatial data that have no street location allocated to them. I was wondering if FME can import a basemap of google earth or google maps of my location and using an attribute apply a street name to my csv points?

My Reader is Excel. My Writer is ESRI File Geodatabase. I use AttributeManager to rename the fields. How do I add field name aliases to the Writer in this situation?

I am struggling to convert a polyline ( 2d & 3d ) to Esri feature class. I have used a geometry filter + Elevation Extractor + 2d Forcer + Area Builder. However half of the result of Area Builder transformer appears to be incomplete. Any idea as to how to convert all the polylines in to a polygon successfully....?   Thank you

Hello, I'm using a string searcher to find "Dates" out of a "Comments" field. I have a column of all matches (Screen shot attached). How can i extract the most recent date out of all matches? Probably would help if I change "/" to another symbol.

I have an Excel spreadsheet in my Reader. I am using AttributeManager to change field names. I am writing to an ESRI Geodatabase.  FieldX has values of Type 1, Type 2, and Type 3. What is the best way to add a hyperlink to this field? so that values look like Type 1, Type 2, and Type 3 and when clicked the link opens. The hyperlink is the same URL for all the values. I am able to add the hyperlink URL to FieldX in AttributeManager, but the result is it shows the actual URL, not the linked value (Type 1, Type 2, and Type 3) in the field.

I need to scan an existing but unpopulated (i.e. no data) file geodatabase (GDB) and determine which feature classes have attributes whose names match a given regular expression. I then need essentially to extract the pairs of feature_class_name/matching_attribute_name and in some way to use those pairs subsequently in the translation. So:What transformer would I use to scan an unpopulated GDB for attribute names matching a regex?How best to configure and to capture information from that transformer to use subsequently in translation?[Related to the beginnings of a solution idea in my head ...] If I use, say, a FeatureReader to extract schema features from an unpopulated GDB with Ignore Relationship Info unchecked, will the schema features carry format attributes (similar to geodb_feature_has_relationships on data features) indicating feature classes and attributes that participate in relationships? Thanks, all, for your ide

Hi, I have a raster in GRAY8 that have cells ranging from 0 to 255. Additionaly I have a translation table with values as such: T pixelvalue≤ -22 0-21,92 1-21,84 2-21,76 3-21,69 4-21,61 5-21,53 6-21,45 7-21,37 8etc...I would like to replace every pixel value with its corresponding value in the T column. I have tried to do the following:1) Trim the "-" sign2) Round the attribute in the T column to remove the decimal values. My thought after that was to use the attributecreator with:if(A[0]=@Value(pixelvalue),@Value(T),And then the aggregator and merge them with concatenation. Then finish it of with brackets to something like this with nested if statements:if(A[0]==0,22,if(A[0]==1,22,if(A[0]==3,22,...And feed it into the RasterExpressionEvaluator. This workflow does not seem to work since I ca

I have JSON files that I am reading and using GeometryFilter to create points. GeometryFilter is looking for the coordinates as long, lat. Some of the points in the JSON input are incorecly entered as lat,long. Is there are way to read the JSON coordinates and switch the coordinates to long, lat if they are incorrectly set to lat,long? For example:CHANGE FROM"geometry":{        "type":"Point",        "coordinates":[ 29.32991754843333 , -82.16997782090549]TO"geometry":{        "type":"Point",        "coordinates":[ -82.16997782090549, 29.32991754843333 ]Thanks,David

 Value in Source Data:DWGNAME,OLDHANDLE,NEWHANDLE,X1,Y1,TYPE,NEW_IDBDCV.dwg,3F7,16354,2181887.040872167,12004078.93869873,ROUTE,1233345The String replacer is defined like $(DrawPath)@Value(DWGNAME)Output from transformer:If DrawPath Parameter=C:\\ClientMaps\\C:\\ClientMaps DEFAULT_MACRO FME_DATA_REPOSITORYBDCV.dwgif DrawPath Parameter=C:\\ClientMapsC:\\ClientMapsBDCV.dwg I need the output to be C\\ClientMaps\\BDCV.dwgThanks

I'm using the HTMLReportGenerator to display a map with points. In the "Label Attribute" setting I've combined several attributes. I want the points that contains a certain word to be in a certain color. In my example I have two different words that should determine the color, "KFF" and "SBF". The label attribute is a long string containing these and some other values ("Example: {3553} KFF). Is there a way you can achieve this with StringReplacer? If feature.properties.name contains KFF than set the color to red else set the color to green.

Hi all,I have an excel file. They have id, photo fields.The photo field include multiple url image. If I use ImageFetcher, I can't download the attribute include multiple link. Could you share to me how to fix it? Thank you  

I want to copy files from one folder to another in BIM360/ACC with AutodeskBIM360DocsConnector, and in BIM360/ACC there is a Default Attribute column for Description. And when I copy them in FME the Description does not come with.  In AutodeskBIM360DocsConnector there is no option in Attributes to Add called Description.  Any suggestions for how I can get the Description in the copy process? 🙂 

Im trying to change the crs of a shapefile. It needs to be in the same as below:When using the Reprojector transformer Im getting an error Transformer parameter:After running the workspace Im getting the following error:Reprojector (TeeFactory): Reprojector: Reproject: Could not reproject the geometry of the preceding feature: Unknown coordinate system 'EPSG4326' specified - abortingReprojector: Reproject: Could not reproject the geometry of the preceding feature: Unknown coordinate system 'EPSG4326' specified - abortingTranslation FAILED with 4803 error(s) and 2 warning(s) (0 feature(s) output) When using the EsriReprojector transformer the workspace runs succesful but the srs is a

EDIT:I have created a text parameter with value contractor_log and used that as the layer name in both, this seems to have fixed the problem (not fully tested yet). This seems to be more of  a hack than a proper solution. Is there a 'more correct' way I should be doing this? Hey, I have a workbench that manipulates some input data, then it checks an arcgis online table (contractor_log) to see if this particular mobile number exists in the AGOL table. I need the AGOL table to be UPDATED if the mobile number exists in the table, but if it is new (non existent in the AGOL table) I need FME to INSERT a row into this AGOL table, which is a dozen field to insert. I have inserted the AGOL WRITER into my workspace, setup my UPDATE writer which works perfectly, I now wish to duplicate this writer to setup my INSERT, but when I create a copy of this it must contain a unique layer (table) name, which is not ideal, as I want both writers connecting to t

I'm processing a point feature class (21 million approx points) I'm fanning them out into shapefiles, smaller than the 2G limit. It produces shapefiles, missing the .prj file. Any thoughts on why ?

Hello, I would like to ask how to solve this problem,that there are several databases. In line, polygon, point and text formats. The question is whether it is possible to create an excel file that contains all database names, as well as what attributes are there as well as attribute names and alias names. In addition to this, what are the results in the attribute table and the corresponding domain names.And export it to xlsThanks in advance