Best Answers

Based on the unit of "Find Your Way Around the FME Academy""Show Off What You Know""You've worked hard to earn points and badges, and your profile is the place to show them off. Click your profile image in the top-right corner of Trailhead and click Profile to see all the badges and points you've earned so far, and a breakdown of skills you've learned." However once I click the profile in the top right corner of trailhead, I can't click my profile to see the badges and points that i achieved.  Do anyone know the reason why please? Thank you 

I have an SDE with a point feature class that has 120k locations across the entire US. I can read those points in with a normal reader, but it takes a long time ~5 minutes and I really only need to return 100 out of those 120k points.  Which 100 changes depending on the input of an excel reader. I pull in a list of 10 or 20 points from an excel sheet, take a 2 mile buffer around those points, and then spatial join that to the big list from SDE. Those 10 to 20 points could be anywhere in the US.  Is there a transformer that will let me read in my 10-20 points, then make a query to SDE/SQL with a transformer based on the location, so that I'm only asking the database for the records I need? That way I am not pulling in the rest of the 100k+ records.  Right now I am thinking I can take the lat long coordinates from the excel input and create a bounding box of sorts to query the SDE point feature class. But I don't see a transformer that can read from SDE 'inline' with the

I have followed this pattern of a workflow for years, where I maintain attribute names and data types in a spreadsheet for different databases, and I import those names and values using the Import... dialog within the AttributeCreator as one of the last steps of a data workflow.​When I import values, here's what I usually have in the AttributeCreator:​Output Attribute Valueattribute{0}.name AreaNameattribute{0}.fme_data_type fme_varchar(64)​Now that the AttributeCreator has a data type in the dialog, should I still follow this pattern?  How does this new data type parameter work with dynamic workflows?

Trying to install on my mac, silicon version. Have uninstalled one version completely. New version still has the same bug. When loading a package, going to database connections etc: Failed to install web service '/Users/xxx/Library/Caches/Safe Software/FME/Packages/23319-macosx-aarch64/PackageFiles/safe-lab.genai/web_services/OpenAI.xml'. Reason: Unable to read from file '/Users/xxx/Library/Caches/Safe Software/FME/fme_publicKey.fmeks', No such file or directory (Code 2) I checked for the folder and it doesnt exist. 

I have multiple site template polygons, with various dimensions. Let's say I have 2 polygons that are 100' x 100' and 200' x 200'. I then have multiple parcels that I need to see if any of the site templates fit inside the parcel polygons, no matter the orientation of the site. What would be the best method to determine this? The outcome would be finding which site template, if any, would fit and the orientation within the parcel polygon.

Hello i would like to create new feature class and write into Arcsde .will be automatic add into arccaralog ?how to write it into specific feature dataset ?new feature class includes lines .which parameter should I do for Arcsde writer ?FME 2021

Hello,  As part of an application I am developping, I am using the FME Flow API to submit a job asynchronously (using the webservice POST /transformations/submit/< repository >/< workspace >).  I have also created a specific webservice used in the workspace runned on FME Flow so it can communicate specific information about the result of the workspace to my application.  I would like to know if there is a way to use the jobid returned in the response body of webservice POST /transformations/submit/< repository >/< workspace > in my workspace so that it can be passed as a user parameter in the HTTPCaller used to call the webservice I have developped.  It would be very usefull for me so that I could create a link between the job sumitted on FME Flow and the information it sends back to my application using the webservice I have developped.  I remain at your disposal for any additional information.  Best regards,

Hello , i have xml document schema ,that includes subtypes .I have exported it from arc catalog  in FME my input is arcsde ,i have used quick translator to convert it from arcsde to file geodatabase ,in configure parameters I have used the schema xmlI have read in article this is the way to get subtypes in file geodatabase to use schema xml .But after checking the file geodatabase by ArcGis pro ,does not include any subtype . How could I get file geodatabase include subtypes ? FME 2021

Brand new to FME server, and i've only really worked with outgoing REST API calls before in general. What i have is a workspace that is parsing emails and picking out specific data that is then packaged based on conditions and sends out an REST POST request to another platform. The packaged data going out becomes an actionable item in the other platform, and i want to have users be able to click a button to respond to the action item and have that come back to FME Server (i assume it'd be a post request) where i can write to a table some related data. i'm not sure how to "listen" for incoming REST requests? i've read through the v3 documentation and it is pretty likely that i missed it, but i'd love it if someone could help me out?

how can I arrange attribute in assending order like: 5,6,3 = 3,5,6 also i have check FME python caller but its not work.output is not generating.  import fmeimport fmeobjects  class FeatureProcessor(object):    def __init__(self):    """Base constructor for class members."""    pass   def input(self, feature):         cell_value = feature.getAttribute('Address Component Type')    cell_value2=sorted(cell_value)     feature.setAttribute('sorted',cell_value2)     self.pyoutput(feature)   def close(self):    """This method is called once all the FME Features have been processed    from input().    """    pass

Hello All,  Please have you got an idea how i could store more then 100+ records ? When i run the WB it should compare or find the value and do the needful.    thank you all

I'm having a custom transformer that needs an URL as input for API calls, so I made it a user parameterHowever if I take the value from an attribute, that value is lost after another custom transformer that contains a list builder. If the value comes from another user parameter (set in the main), there is no issue:This is the setting by taking the url from an attribute (table shows the output from a parameter fetcher inside the custom transformer after the list builder CT) This is how it is by taking the value from another user parameter (+ output from same parameter fetcher): Is this a bug? Am I missing something?How could I solve this in a performant way?Is there a way to change a value from a user parameter to an attribute value? Say I define user parameter "URL" as private one and leave it empty. After I deduct what the URL should be (fetched from a database), can I add the fetched value to the empty user parameter?   

Hi,Does someone have a workspace example how to collect all files in a folder for creating a ZIP-file to send to the Mailer-transformer?I am using FME Desktop 2022

I want to create blocks from the lines in each layer and give the new blocks the last 5 digits from the original layer name. so lines in layer 12345xxxx1 will be a single block with a name xxxx1 and the block placed on original layer 12345xxxx1I got the block created and placed in the correct layer but couldn't figure out how to name it.    output blocks

I have a csv with start and end lat longs and other attributes like road name and road number. I want to snap it to the route (road network) polyline dataset based on matching attributes (road name/road number) and then generate the line geometry of that road network from start to end coordinates provided.  Is this possible to accomplish in FME?  

Hi FME Community..Need your guidance , I'm receiving different dates in a particular column called "date_1" total records 401 including null when im using date time convertor to standardise it , Give me all null values to that column..Need expert GuidanceI have attached the templateThanks

I want to reproject DWG files with Pipe Network features from UTM Zone 17 NAD83 (Original) to MTM 10 NAD83 CSRS  using ON83CSv1.gsb.when I use ArcGIS data interoperability and EsriReprojector, it reproject all feature except Pipe Network features.is there any sollution for it?

Hello,I have a json response body that I am trying to get into a table. Using the JSONFragmenter I have gotten each record to populate as a different fragment. I have a long string with all the key value pairs. See below, {"ActualFinishDate":"2023-06-01T18:00:00Z","DateSubmitTo":"2022-05-02T13:37:46Z","Description":"FLT - Service Requirement","InitiateDate":"2022-05-02T13:37:46Z","StatusDescription":"Completed","WOCost":0,"WorkOrderId":"3006845","Comments":null,"Instructions":null} Now what I would like to do is create a table that would have each of the value keys as an attribute column and to have that tabled filled out with the corresponding data.  What would my next steps be?     

I am able to use AttributeValueMapper to translate single values (ie if col1 == 1 then col2 = 'A') but I need to get it to map ranges of values, something like if (col1 > 0 AND col1 <= 50) then col2 = 'A' I keep getting 'Invalid Test Expression' errors so it sounds like I'm not writing the conditional tests correctly but I cannot see where I'm going wrong. Here's an example: Can anybody help me fix this, or point me at another way of setting a value in one column based on more than one possible value in another column? Thanks, Mike

When writing to a hosted feature layer in ArcGIS Online we are getting duplicate features on occasion. In the latest run where this happened, there were 15,304 features in the dataset which were reported as written to ArcGIS Online, although the feature layer actually had 16,304 features written to it. Features with OBJECTID 9001 through 10000 were exactly duplicated making it seem like a batch of 1,000 features were written exactly twice during the process. OBJECTID 10001 was an exact duplicate of 9001, 10002 was a dupe of 9002 and so on.... After this batch of duplicates, subsequent features were not duplicated (features before OBJECTID 9001 were also not duplicated).

Hello "Safers" Migrated from latest 2022 build to 2023 2 days ago.Noticed that some of my scheduled Automations failed and the issue is linked to the Excel Writer (The Writer itself or FeatureWriter) These workspaces have, obviously, worked prior to the upgrade for some time now.The Server log outputs the following for one of the workspace (Same error for the other workspace):-----------------------------------------------------------------------------------------------59 2023-6-19 10:01:01 | Emptying factory pipeline60 2023-6-19 10:01:02 | OneDriveConnector: Downloading file "MO-Emails.json" to specified folder "E:\\FME Workbench\\Planning Support\\LetterOfRepresentations\\JSON-Input"61 2023-6-19 10:01:02 | Creating reader for format: JSON (JavaScript Object Notation)62 2023-6-19 10:01:02 | Trying to find a DYNAMIC plugin for reader named `JSON'63 2023-6-19 10:01:02 | Loaded module 'JSON' from file 'E:\\FMEFlow\\Server\\fme\\plugins/JSON.d

Context:The overarching goal is to extract certain categories of areas from GeoPackage files and then write the output as images with the R, G and B channels containing specific grouped categories.I've gotten this all to work nicely as long as the geographical area that we collect the data from contains all of the categories that is written to each of the channels. The issue now being that when one of these categories doesn't exist in the selected area - then the connections for that color channel wont be ran and I end up with a broken output. So what would be the best way of making sure the ImageRasterizer leading into the RGB channel creation is ran regardless of input data or not?Or would I be better off doing something completely different? I am currently working with a RasterNumericCreator to try and generate blank data to be supplied when other data is missing but all I've gotten is a mess trying to get the coordinates accepted by the nodes down the line.Using this me

I have 2 DWG files are working with FME. How to FME transform automatically Block attributes to point (Block attributes in DWG file and tags in Microstation)File 1: FME transform automatically block to point with attributesorginal file 1: File 2: its not, FME is not transform block to point automaticallyOriginal file 2:How do i get the point with the attributes of block attributes like file 1 ?By the way with these 2 files i don't use "Preserve insert points" in FME

I have a workbench that uses the chartgenerator to create a simple chart graphic that goes into an automated daily email. image below:Blue line is the recent readings and the orange line is a limit (it looks static but it fluctuates throughout the year). I'd like to add a ten-day outlook to the orange line but the chartgenerator can't handle null values on the blue line, it throws the error:​ChartGenerator: Non-numeric input provided. Please validate that the values of the "X Attribute","Y Attribute" and "Error Attribute" (if supplied) are numeric​the htmlreportgenerator can handle the null values but when it's embedded in the email as html content the chart is not in the email, I am assuming it's being scrubbed out by outlook and am left wondering if there is a way to covert the html output to an image which can be embedded in the email. Desired output:​