Best Answers

I am working on an Excel spreadsheet that contains employee information from various markets. My aim is to extract this data and import it into the ArcGIS portal. However, the only transformer I know of that can accomplish this task is the ArcGIS Online Connector. The problem I am facing is that it requires a file to be uploaded, which is not very useful in my workspace. I do not want to save my output file; instead, I want to write it directly to the portal. I would greatly appreciate any feedback. Thank you!

I define a bounding box in JSON as UserParameter but when processing it, the JSONFragmenter fails when I refer to the UserParameter.Simply converting the UserParameter to an attribute, and reading the attribute into the JSONFragmenter works! There is no change to the JSON string done, and the source for the JSONFragmenter offers the use of UserParameters.The documentation for the JSONFragmenter though is pointing at "any string expression, including attribute values and workspace parameters."

A colleague recently installed Desktop 2018.0 and later on 2018.1. Workspace seems to run correctly but when the inspector pops up it logs the following error:Failed to create the reader in the worker process for 2D rendering We can see the tabular data but the geometry won't show up.  He does have a 2017 version of desktop installed, this installation seems unaffected by this problem. Any ideas where to look / what to do with these symptoms / logs?

I have read through the documentation regarding distributed deployment of FME Flow but I can't figure out if all of the distributed engines need an ArcGIS server license, or just the main server. Thanks

I would like to know how to build the JSON body for an HTTP POST request to pass in Published Workspace Parameters, opt_requesteremail (who to send an email to), and nm_jobsuccess_topic (which topic to notify on success) for the Data Download Service.  The goal is to interface with another web application where a user can  to submit an asynchronous "report request," that emails a download link when their report has finished processing. I am specifically looking at the POST to avoid any potential issues with large/complex geometries being passed in as a parameter and being too long for the URL. I had started looking into the FME REST API, and figured out how to define the parameters in a JSON body, but eventually ran into an article that states "A Web Service URL looks similar to the REST API Request URL; however, it exists outside of the REST API. A Web Service URL should be used instead of a REST call if you are intending on using the Data Streaming or Data Download Service. A job sub

I have a (FME Form 2023.0) workbench that generates three Excel files, where running locally via FME Form gets me a zip with this structure:my_data_$(TODAY).zipfoo_$(TODAY).xlsxbar_$(TODAY).xlsxbaz_$(TODAY).xlsxAll three XLSX files are generated by three separate writers and have very distinct structures and different template files. When I publish the workbench to FME Flow and try running it with the DataDownload or Data Streaming services, however, I get a completely mangled zip file with this structure insteadOutput8719176120317945288.zipXLSXW_1foo_.xlsxXLSXW_2bar_.xlsxXLSXW_4baz_.xlsxIt seems like both services ignore whatever path the readers are configured to write to, and instead use a XLSXW_1_DATASET override that gets set by FME Flow, whose value seems to be $(FME_SERVER_DEST_DIR)/MULTI_WRITER_KEYWORD{0} with the file name appended at the end, without parameter expansion. Is there anything I can do to control the file structure inside that generated zip file, or perhape have a

About the projectWe have individuals checking traps and bait stations (points) located on different properties (polygons).  Every time someone goes to visit a property they create a point record so we know who has been there and when. Output requirementsWe need to fill out a word document (template given to us by the client) for each property we visit. What I thought I could do to automate this process currently being filled out manually by the team lead:Set up an FME process using the property parcels (polygons) and trap and bait station records (points). Use a PointOnAreaOverlayer and add the important point data onto to the property addresses. Each property has one form (filled out with a list of visit dates and who was there). I watched this really useful webinar. It's gotten me far considering I've never worked with word in FME before, but I still have some questions.https://www.youtube.com/watch?v=5H1BsmXCTrY  QuestionSometimes there are multiple point records if multiple

Hello all, I've been trying to delete a folder containing some data after processing. I cannot use a temp folder so have turned to python to complete the task.I've tried following the comments in the following thread but it doesn't seem to work for me File Copy - DELETE (safe.com)I can get the process to work when 'hard coding' as shown below. But when I try to make it dynamic by replacing 'location' with feature.getAttribute('filepath') and dir with feature.getAttribute('directory') it fails.The filepath and directory attributes are shown below:'filepath' = C:\\Project\\FME\\processing\\data'directory' = 20230925

Hi everyone, I have split a pt cloud into 2 : Ground and Rest (Ceiling and Beams). and I would like now to calculate the minimum verticale distance (along z axis) between the 2 clouds. to avoid false results with the beams i want to eliminate any results smaller than 2meters. I am a little bit new on FME and i don't know which transformers would be best for this operation if it's doable. Thank you

Hello, I'm attempting to use an attribute with HTML as a value into the HTML2PDFConverter. What's odd is that said transformer asks where the HTML will originate from (a file, attribute, or URL), but when you select one of those options, it's still asking for the other two as a requirement. Is this a bug?     

Hello! I am trying to add an attribute to a table from a dataset that is specified by the user. This input data varies in attributes, so I don't know the format of them beforehand. However, I am consistently just adding 1 attribute to this data and writing it to another table. It looks something like this: The first dataset that I input works fine, but any dataset after that does not match the attributes of the first dataset will not go through properly. I've done some research on dynamic workflows in FME, but I'm still struggling a bit to find a solution to this. Any ideas?

Hi FME community, I am trying to start a job on FME Flow from another application by making use of a webhook and a token. The trigger results in succesfully starting a job on FME Flow, but the response is most of the time the following:502 - Web server received an invalid response while acting as a gateway or proxy server.It looks like this only happens when the job takes longer than 2 minutes. Does anyone have an idea where the 502 response comes from? This indicates an error while in fact the job is started as expected. Version 2022.2Build 22765 - win64

In a lot off my workspaces I need to fetch some 'global' values based upon user input. Example: user needs to provide project name: first check if projectname complies with the rules, once that is ok, use some api's to fetch global values for that project.Now those global values are in an attribute and need to keep track of those when using attributekeepers, list builders,...I can set them as a global variable with variable setter but it means that I need to use a lot off variable retrievers (10+).  Is there a way that I can put that value in a private parameter so that I can use it across the workspace without the variable setter and retrievers?

Hi Everyone, I am relatively new and in my current position I am replacing someone who was a bit more advanced than me. I understand a lot of what the workspace is trying to do (and it worked in FME Server) but once we migrated to FME Flow, the workspace no longer works. The premise is similar to the FME Demo "Map Based Data Distribution". The difference in our workflow has an Input Project Area instead of an Area of Interest which allows the user to upload a shapefile or use our municipal boundaries which is stored in our Repository. We also create a waiver for our Digital Licensing Agreements, but that's a User Parameter with "yes/no" and with either setting, the workspace/app fails. I've included images for the parameters for the FeatureReader (but not the connection parameters). For "Feature Types to Read", we have a User Parameter ($(FEATURETYPES_2)), which is Choice List. It's the FQN of our Feature Types in the database connection file (

I have geodatabases, which can contain strictly structured data of linear utilies and related objects, such as powerlines, utility poles etc. However, geodatabase sometimes contains only powerlines, sometimes only poles, sometimes powerlines, poles, power plants and more. So, one geodatabase may contain two layers of data with strict and specific names and attributes, the other may contain all of defined layers, and so on. I convert this geodatabase into an XML file through XMLTemplater provided with an input from XSD file. Since the structure of the geodatabase is always the same, XML Templater allows me to set the template beforehand, and XMLTemplater just writes the attributes afterwards. The reduced ROOT template looks something like this:<?xml version="1.0" encoding="UTF-8"?><geodatabase:Utilities xmlns:gss="http://www.isotc211.org/2005/gss" xmlns:xsi=  ... namespaces etc.>  <geodatabase:Data>    <geodatabase:PowerLines>   <pwrlns:GeneralInfo ... />  

I have switched from using a custom transformer to a linked custom transformer for the sake of reusability. While there were no errors when I ran it with the local custom transformer, I started encountering an error message randomly after seeing the "Translation was SUCCESSFULLY" message, which reads "Error missing translation." after I changed it to a linked custom transformer. Here's some additional information that may help:1) The number of records outputted by the custom transformer in both cases is the same.2) In both scenarios, they were executed in "Moderate" mode with parallel processing.3) Debug logs are enabled, and although there are some "BADNEWS" messages, they were present in both cases. Can anyone provide me with some hints or guidance to resolve this unknown error message?" Here below is the screen capture for the error message. 

How can I fix the texture that the 3D-tiles writer puts out? When converting from obj(including .png and .mlt) to 3D tiles, the writer makes the texture very dark when they are being viewed in Cesium. There is no problem converting to kmz, the textures is perfect there but we need to use 3D-tiles for its streaming capabilities. KMZ: 3D-Tiles:  I have read multiple posts on FME forum and on Cesium forum:including this idea: https://community.safe.com/s/bridea/a0r4Q00000Hbqi5QAB/options-to-choose-and-set-gltf-appearance-settings-in-cesium-3d-tiles-writer https://community.cesium.com/t/how-to-set-lighting-for-cessium-3d-tile/5140 https://community.safe.com/s/question/0D54Q00009cNpu2SAC/i-want-to-create-textured-models-to-cesium-3d-tiles-from-obj-files And more posts. Does anyone have an idea how to fix this issue? Right now I use this, this helps to fix a transparent issue I faced before.Here is the .mlt from the obj if it helps:newmtl SolidKa 1.0 1.0 1.0Kd 1.0 1.0 1.0Ks 0.0 0.0 0.0d 1.0N

I have a tree canopy coverage layer where tree canopies are overlaid. The layer contains around 5,000,000 entities and I need... :1) remove the overlapping area of the entities (I've tried with the space and overlap cleaner but it takes too long, I have 32gb RAM)2) merge all entities into one, and for display performance reasons, the resulting layer must be cut on a 1 km or 500 m grid. In attached an exemple of the layer  Any idea how to proceed? Thanks to all

I'm trying to setup a workspace that allows the user to choose what attributes to keep in the final spreadsheet. But AttributeKeeper seems to work wrong when passing User Parameters in the "Attributes to Keep" box. I've created a User Parameter of the type "Attribute Name" that allows to select multiple attributes, and I've setup AttributeKeeper to use this parameter. I'm facing the following:1- When selecting only one attribute: Schema gets lost, but the attribute is still retrievable by exposing it.2- When selecting more than one attribute: Both schema and attributes get lost.3- Noticed that AttributeKeeper has a comma delimiter when multiple attributes are selected, while "Attribute Name" User Parameters use a blank space as a delimiter. So I've created a third parameter of the type "Text" with the value "a1,a2" (where a1 and a2 are the attributes), to see if this makes any difference. This again results in no sch

I have 3 tables, a linear tables of sections, a non geometric table of bus lines, and a intermediate table between both, with relations N:M. I need to merge the sections to get the geometry of bus lines. but some of the sections belongs to many bus lines, so I need to "duplicate" some of the sections. Any idea of how to get the geometry of bus lines? Thank you again

@Dale Lutz​ @donatsafe​ Hi Guys - can someone tell me if the home use licence is still available. I have just tried to get a new licence and been told that the home use program no longer exists. However, when safe did their rebranding the question was asked about the home use licences and Don and Dale said it would continue. Can someone please confirm which is correct...

HelloIs it possible to create user parameters and save them for use in other workbenches?I have numerous workbenches that all load different data however some of the parameters will be the same and used in every workbench.I have looked at the documentation, but cant see anything obvious. If these created parameters could be saved to either a database, or file to allow sharing with others that would be even better...RegardsAndy  

Hello,on the SchemaScanner transformer, in the data types section, there is a parameter to define the action to be taken for attributes with the value Missing/Null/Empty.When ignore is selected, if an attribute has no entry, it is excluded from the schema. This seems correct for Missing. But is this the case for Null and Empty?In the latter case, shouldn't the attribute remain in the data model?If not, what other prossibility exists for retaining an attribute that has no value entry in the data model? Best regardsPatrick

I am reading into my workbench both dwg and dgn files using two feature readers. I am able to expose the fme_dataset for the dgn file by using an attributeExposer transformer, but the fme_dataset will not be exposed for the dwg files. I am able to get the fme_feature_type and fme_text_string for each FeatureReader. But I want to add the file name (fme_basename) as an attribute to each feature so I know what file it came from. Things I have tried:separate AttributeExposer transformers for each FeatureReaderThe same AttributeExposer transformers for both FeatureReadersAdding fme_basename to the <Generic> Port, along with $(SourceDataset_DWG)checking all of the needed options in Reader > Parameters > Schema AttributesWhen I open the inspector after the Exposer, all of the attribute fields are there but the values are empty. All of this information (file name, project name) comes from published user parameters. How can I add the value for these user parameters into my features

Hello,I have a dataset with 1000 categories (A, B, ...) (please see the following sample). For each category I want to calculate 3 points moving averages. I developed the following workbench that using a Tester filter data for each category and then calculating the 3 points moving averages for one category (here port A). However, for each port of the Tester I should repeat all transformers again (transformer after the Tester), which is difficult for 1000 categories. I created a custom transformer but again I should import the custom transformer 1000 times. In the custom transformer I used a Counter which for each port should start counting from zero. But it is added up after that it is applied for each port. I set the Count Space of the Counter on local. But still didn't work. Can someone please let me know a better way to calculate this moving averages without those all repetitions of transformer. FYI, I am using FME 2022.