Best Answers

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?

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 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

 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

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

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 the same AGOL Layer/table. See this photo, it 

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 ?

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

Hi, I have a parameter in my workbench that I want to lock down to expect a 10 digit phone number. Here in Australia they all start with 04, so I am hoping to make my parameter restricted to between 0400000000 and 0499999999. It doesn't work if I use integer, because it drops the leading zero. Does anyone have any tips on how I can achieve this? Ultimately this will be published to server and be a web form input field. I am hoping the user cannot press submit until the mobile number is in the range I mention above. Cheers

I see this new UPSERT functionality...Where can I find help docs for upserting to file geodatabase gdb?  Thank you, TylerSAFE FME 2022.1

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

Hallo , i have lines data and I have only start point and end point of line .but I would like to get all geometry of points from start till end point.,so I have used chopper to convert lines to points but my problem .I am not sure ,how could i add all geometry of points from start till end point in new attribute for the same id of line .FME 2021Thanks for help .

Hi I am trying to connect to a public S3 bucket and have tried multiple times to connect and download files in the bucket. I just keep getting an error message. I'm probably entering something wrong but I've tried multiple different things and no luck so hoping for some guidance here. S3Connector: There was an error connecting to Amazon S3: 'Parameter validation failed:Invalid bucket name "shaking-layers/": Bucket name must match the regex "^[a-zA-Z0-9.\\-_]{1,255}$" or be an ARN matching the regex "^arn:(aws).*:s3:[a-z\\-0-9]+:[0-9]{12}:accesspoint[/:][a-zA-Z0-9\\-]{1,63}$|^arn:(aws).*:s3-outpo...'. Confirm that your credentials and region settings are correct. Some regions are not publicly available - contact AWS for more information. I have attached a screenshot of what I am entering in the S3 Connector.

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 parcel data with various years in the postgis database and I need to executed topology year wise to find out the topology errors across the years. I have query to filter out the data in year wise and the query is (column1 < Year and column2 >= Year). My first question is how to retrieve the various years in DB for that particular area and my second question is how to pass the years to fetch the data pertain to that particular year and pass it on to the dissolver transformer, kindly let me know.     

I have two sets of points, A and B. I would like to create lines between them, only if the distance of this line is < 500 meter.  Currently I achieve this using a 1-on-1 join in the FeatureMerger. For each point in A there is a list element with the coordinates stored for point B. So if I have 300 points of A and 200 of B, I would have a list with 300 features, with each feature having 200 elements. I then explode the list, and then for each point of B, create the feature, and then check if the distance is <500 meter. This is unfortunately very bad performance-wise, since there are a lot of unneeded connections (> 500m) being made. When running the workspace with big sets of points in A and B this can really effect efficiency. Is there a way in which I can check the distance between two points before I create the feature?

I'm looking to make a query which uses the spatial data in the planning brief to search cadastre, duct, duct_route and SL layers. So that I can change each planning layer can become searchable and have an output. We are currently working with MapInfo.

Hi,  I'm trying to run an FME process from the command line like I have many times before (fme example.fmw) However, it is opening the wrong version for the workspace. The workspace is in 2022 but the command line is opening 2018 (which is also installed on my computer). Is there a flag or something I could add to my code to ensure it opens 2022? My workspace has newer transformers than 2018 so it crashes everytime I open it I have tried adding it to the system path variable, but this doesn't do anything, unless I'm doing it wrong Thanks

Hi, I am trying to expose an attribute from the _response_body returned from a http caller. This is the response: <s:Envelope xmlns:s="http://schemas.xmlsoap.org/soap/envelope/" xmlns:u="http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-wssecurity-utility-1.0.xsd"><s:Header><o:Security s:mustUnderstand="1" xmlns:o="http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-wssecurity-secext-1.0.xsd"><u:Timestamp u:Id="_0"><u:Created>2022-11-24T11:20:34.572Z</u:Created><u:Expires>2022-11-24T11:25:34.572Z</u:Expires></u:Timestamp></o:Security></s:Header><s:Body><CreateWorksheetResponse xmlns="http://webservices.whitespacews.com/"><CreateWorksheetResult xmlns:a="http://webservices.whitespacews.com/API/" xmlns:i="http://www.w3.org/2001/XMLSchema-instance"><CodeDescription>Success</CodeDescription><ErrorCode>