Transformers

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 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 ideas on this.

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 can't get the RasterExpressionEvaluator to accept my nested if statements and write many different colors. Any suggestions on how to achieve what I am after? Color my raster based on the matching valu

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.

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 as follows: Question: Is there something wrong with my FME? Or am I using the wrong parameters. Thanks.

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

Hello everyone, I searched a lot about this topic but nothing matched the same problem. I have a functionnal ftps URL that return the good file in filezila. But when using it with the FTPCaller, it return a timeout. Whatever the parameters are.But if I declare the URL as a SFTP, it does the job.  It work here because the server do accept the query with sftp but if not, I am afraid I'll be block with the ftps only.Does someone face the same problem ? Did you find why and how counter it ? Thanks in advance ! Have a good day.

I have tried a bunch of different coordinate combinations to find one that may work. Using the one that I have always used the objects translate in the correct location, but the scaling is incorrect. Other coordinate systems the text is the correct scale but not in the correct location. I am translating from NAD27 mm to NAD27 ft. looking for an answer so we can move forward with a software upgrade. See below for coordinate info that I am using. # KB 01/11/2013 - SRP database projectionCOORDINATE_SYSTEM_DEF SRP_AZ_Central_mm               \\ DESC_NM     "SRP Arizona Central NAD27 millemetre"  \\ SOURCE     "SRP GIS"                 \\ DT_NAME     NAD27                   \\ PROJ      TM                    \\ UNIT      MILLIMETER                \\ PARM1      -111.9166666666667            \\ ORG_LAT     31                    \\ SCL_RED     0.9999                  \\ X_OFF      152400305.0                \\ Y_OFF      0                     \\ MAP_SCL     1.0 # KB 01/14/

I have an Excel file (table). How do I prevent it from reading the 1st row of the table?

I am reading in an ESRI File GDB, and using several attribute transformers to populate existing fields. Everything is working the way that I want it to (looking at the inspector), however the changes are not being committed to the tables when the translation completes.  Do I need to have a writer in place to commit the attribute changes to the table? Is there something else that I need to add to tell the process it is complete, and the changes can be committed?  I am not looking to create any outputs just update the attributes that I have targeted.

I could make a simple workspace that can convert from shape file to kml, but it is only allow to covert one specific shape file, due to the Name/attribute value differences for each shape files. Therefore, I would like to make a workspace to available to convert various shape file having different Name/attrbute value that can automatically read/extract each file attribute values, beyonds files and allows to select to show in output Kml file. i.e.) set varrious attirbute value available in Kml property setter. I'm very beginner, so my question is bit silly, but if you have some suggestions, idea, method, that would be really helpful. Thank you for your reading.

I'm trying to Create 3d polygon with a center polygon and a buffer around it, I need to have an incline of 1.2 percent from the center polygon towards the edge of the "buffer". Hope someone can help, and thanks in advance. I've come this far, but I'm missing something:

Hello. Is it possible to create straight labels along curved lines with MapTextLabeller? Usually this transformer creates curved labels spread out to every single letter that I do not want. Lukas

I have lines , I have used coordinator extractor with index 0 , coordinate extractor with index 1 so I got start point and end point for each line .but I have still few lines ,although I see them in inspector as lines but the coordinates that I extracted for each line of them by coordinate extractor transformer ,has same coordinate for start and the same coordinate for end of line as attributes what is the reason of that ?how could I get coordinate of start Point and end point for theses few lines but it should has different geometry in start rather than end FME 2021Thanks for help

Hi, I have a question, I would like to ask if it is possible to insert a column that contains the character encoding of the previous column.Do you think it is possible to do this?

Dear Altruist, I have a consistent series of excel files but saved under different folder in respect to model_run no. Now I would like to add a column in each of the excel files as per the folder name that file is situated in. I have used 'Directory and File Path' transformer to expose all those excel file and used stringsearcher to create a column that extracted the folder name from the path. Can anyone please tell me how can I add the folder name as an attribute to the individual excel file?regards/  

Dear Sir / Madam, Actually I am trying to match two excel table values (attributes name from two different samples). In the excel, I have one matching table and two models attributes in two tab sheet. I would like to compare the value with Model 1 and Model 2 based on the matching table. For example, apple matching apple. However, some of the naming are not exactly matched with wording and are slightly different, such as Pineapple in sample 1 is equal to USA_Pineapple in sample 2. Is it possible to do that? Also, if possible, could it be not case sensitive? Then, I would like to perform a value check on two samples based on the matching table I provided. The result that I want to get is on the "Output Sample" tab in orange colour. I have attached my sample data here. I hope you understand what I said and I hope it is possible to do that. Thank you all and have a good day!

Hey there,I'm struggling with the RasterCellValueCalculator. As I have raster files which are not congruent to each other and not of the same resolution (but overlapping), the transformer doesn't calculate properly. It's just a simple substraction.I already tried to bring the rasters to the same resolution.Can anybody help?I added a sample workspace. Cheers,Maria

Seems like exposing elements in AttributeSplitter doesn't work in FME 2020.0.1 (build 20218). Even exposing attributes after splitter with AttributeExposer is broken.Or maybe it's Data Inspector's fault for not displaying them. Any thoughts on this?