General

Trying to convert data to XLS where each layer is a separate sheet. I was able to do this in FME desktop but unable as FME Form. Is there something special I need to do with FME Form?

I am importing a project into FME Form that contains two automations, associated workspaces, and the repository for the workspaces. The repository for the workspaces already exists in the FME Form environment I'm importing into and it has other unrelated workspaces in it. The Preview Import page states that I will overwrite the exisiting repository during import. What, exactly, does "overwrite" mean? I only want to add the two new workspaces to the existing repository. Is that what happens? Or does the import process completely replace the repository, wiping out any existing workspaces and keeping just the two new ones? Something else? I'm trying to figure out if I should include the repository during import or not. I can't find any documentation that provides an answer. If anyone has one or can point me in the right direction I would greatly appreciate it!

Hi All, I have put a workbench together to populate some GIS metadata but I need to have the <CreateTime> automatically populate every time I run the workbench, below an example of the XMLTemplater transformer settings:Currently the time if fixed as 00:00:000, How can I set it as variable parameter ? I have tried the ROOT Template Functions but didn't work. Any advise more than welcome :)Thanks 

Hi, I would like to read all the layers published to Esri Portal/Enterprise that are shared with particular group. I use Esri ArcGIS Portal Feature ServiceIn the Parameters I would like to change the Feature Service so instead of reading one layer will read all layers from that group; A9 WTC in this case

I have created a workspace which takes multiple zipfiles as a user parameter and reads them with a FeatureReader containing an Directory and File Pathnames Format. If I run this workspace in FME Desktop 2021.2 it works fine.My next step is publishing it to FME Server 2021.2 and starting it there.I add the same files to the user parameter and request the workspace to run.It starts like it should and gets the filenames as parameters but then it gets weird. FME Server seems not able to process the parameter it created itself.On the FeatureReader it gives an error which tells me the FeatureReader (QueryFactory): The clause '@EvaluateExpression(... is in correct.I asked several colleagues and searched the internet on this specific error but  I can't find anything that looks like this. So did anyone ever run into this error and does one know how to fix it? The complete error (without the file paths which are formatted like "D:/ProgramData/Safe Software/FME Server///resources/system/temp/uplo

Hello,Can I use the same FeatureWriter transformer to write lines and polygons into the same GDB? I know how to do it in a normal writer but can't get it to work with the FeatureWriter. Below an example of the workbench which filter the geometry by areas and lines and then go into two different ports in the transformer Below an example of the FeatureWriter settings where I have included two feature types (polygon and lines)  Do I need to set a Dynamic Schema Definition? I have tried that option with 'Schema From Schema Feature' option but failed, Any idea more than welcome, thanks! :)

The goal is to make the shortest paths for the first salesman for first day of work, then the second salesman for the first day of work, then the third salesman for the first day of work, then move to the second day, and repeat.  Days = User Parameter on # of days to iterateSum_Total_Time= the work + travel time for the combine paths for that salesman for that day.Each salesman can work a maximum of 3 hours per day (total_time).I have calculated the work, travel, and combined time per path per salesman. Set Work_Date = todaySet total_time = 0Set Sum_Total_Time = 0Set day = 0If Day =< Days Then     For Salesman in Salesmen:     Set WorkDate = WorkDate + Day         If Sum_Total_Time =< 3               From_Node = Salesman_Location               TestFilter = Days_Since_Visited > = Target_Days_Since_Visited               Spatial_Filter Topology Nodes inside Salesman Boundary               NearestNeighbor From_Node to Topo_Nodes               Shortest_Path               AttributeC

Hello , i would like to remove the arrow symbol from the lines how could I test in data which lines has arrow then remove it .as info :arrow symbol and line connects to has the same id FME 2021 

I have two FME Flow servers and I'd like to be able to change this color to easily be able to tell them apart when I have multiple tabs open.

i need to extract the Geometry traits that are in the picture. any clue how?

Hello everyone According to the rule, when digitizing objects, we need to place the object 0.50 cm above the red line. My question is: How can I find objects that are not 0.50 cm above the red line? Thank you in advance for your help 

Does FME support moving data from an on-premise database (MySQL or SQL Server) to Databricks? We're looking to potentially replace StreamSets.

This is an FME Server that has recently begun to cause problems. One of the scheduled jobs fails but there is no information in the log. Any leads on how to proceed and solve this problem? FME Server 2022.2Build 22765 - win64

Hi All, Does anyone have experience installing ArcGIS Server with ArcGIS Server Basic license on the same Windows Server hosting FME Server? Do I need to complete our ArcGIS server Setup Wizard? Or as long as I have ArcGIS Server installed with ArcGIS Server Basic license...I am ready to have automations accessing enterprise level SDE and read/write data from our enterprise GDB without creating a new site? or do I need to "Join Existing Site"? Please help :)  Many thanks,Reno 

Hi guys i just need to find a way to identify the areas on a dataset which is not covered by each of the field values from another dataset..  I also need this inspection to be done by one of the fields. e.g. my input layer A needs to get scanned through to find out areas not covered by Layer B. but on layer B there is a field and each field value will need to be scanned separately and identified at the output.. Im trying clipper - outside - group by attribute but doesnt seem can give me the output i need.. Thanks!

Our customer has data located in Romania, and has provided a proj string that includes non default correction and datum shift grids. I have tried to install these in FME Form (2021.2.4), yet the workbench complains it cannot locate the grid file (“PROJ: proj_create: Error -38 (failed to load datum shift file): hgridshift: could not find required grid(s).”). I have found some links in the docs (also related to install this in FME Flow), however I'm not yet able to run this transformation in my local FME Form.  Any help is appreciated. For reference, I have included the example proj string, grids, test data and workbench. Run it with the following parameters:

Hi All, This post is primarily seeking guidance, or advice rather than answering a definite question. I am trying to figure out the best method to automate 2D files into 3D buildings and load them into an SDE database buildings table. Though possibly also receiving 3D files from said developers.  These files would be received by planning from developers and planning would share them with GIS (me). Would an FME App work better? Can it be dynamic and recognize all sorts of 2d or 3d files? Do I need a separate FME app for each file type? I created a PDF document that I want to share to my planning team so that developers can abide to for my future automated process. from my understanding, it should work, but I've noticed the tutorials (that use CAD) have an accompanying CSV with the building info. This has casted doubt on how i envisioned on using FME. I am very open to criticism as I am very green with FME still.   

I have some FME translation files (4 or 5 of them) that I use regularly on different datasets. These have worked without issue for some time, and are still working now except for one strange thing that's changed. The process runs, ends with "Translation was Successful" in the log as normal, then about 5 seconds later "Translation Failed" appears in red.  As far as I can tell everything has worked fine, there are no errors in the rest of the log (usually if it fails I get good detailed error messages to help me fix my data problem). I think my data is good to go. But I'm not sure why I'm getting this delayed "Translation Failed" message in the log. One of the blue warning type messages (so not an error) says that my ArcGIS Pro v3.2 isn't supported, but this isn't shown as an error and my data appears to be translating fine. I think this ArcGIS Pro update is the only recent change that might affect FME though, so is that the culprit? 

Hi there, We have a workbench that takes as input a KML file, processes it and outputs a zip file.  After testing, this workbench has been uploaded to FME Server, and has data download capabilities. We want this workbench process to be run via python, with the inputs of the workbench  defined by the user.  We are using Python to upload the user file to the Data folder (FME_SHAREDRESOURCE_DATA)import requestsfolderConnectionURL = "https://xxx/fmerest/v3/resources/connections/FME_SHAREDRESOURCE_DATA/filesys/pvDesign?createDirectories=false&overwrite=true" uploadedFile = "zzz.kml"os.rename(outKMZFileClipped, os.path.join(os.path.dirname(outKMZFileClipped), uploadedFile))outFile = os.path.join(os.path.dirname(outKMZFileClipped), uploadedFile) headers = {'Authorization':'fmetoken token=token','Content-Disposition': f'attachment;filename={uploadedFile}','Accept': 'applicaton/json',                    }    with open(outFile, 'rb') as kmlFile:files= {'file':(outFile, kmlFile, 'application/

I was reviewing the article "Build Topology and Calculate Route Length" and had a question left unanswered. The dataset ends with a fork in the route. How would we set the topology builder to allow traffic from segment A to B, A to C, B to A or C to A, but to not allow traffic from B to C or C to B?

Hi,  I have just signed up with an FME account in order to access the FME Academy. When I follow the links through the Academy I end up at a SalesForce specific TrailHead. Foolishly, I created an account there to see if that would give me access to the Academy. Is the Academy functioning at the moment? Thanks,Chris

Hello Forum, For a project I need to create WFS feeds for several datasets. Looking at https://community.safe.com/s/article/how-to-create-a-wfs-service-using-fme-server I see that this may be possible. I’ve opened the example workspace provided in https://community.safe.com/s/article/how-to-create-a-wfs-service-using-fme-server. It wouldn’t open in v2023.1, so I opened in v2021.2 instead. Is creating a WFS in FME Form really this complicated?…  Or is there a more straightforward way of creating one? I have FME Form and FME Flow. Are there other pre-requsistutes I need to consider? Note that at the moment I do not need the WFS to be externally accessible. Access should be internal only for the moment. Thanks,Stuart

Hi All,  I'm working on a workbench to create smooth arc/ polygons from N, S, E, W and NW readings. I was able to calculate the lines & point based on the readings but need help to draw the spline lines/polygons in FME.Below an example of the point and lines extracted from N, S, E, W and NW readings:...and the following screenshot shows the desired output: spline lines made the polygonI'm wondering if there's any way to create those splines to make the final polygon? Thanks 🙂   

Doesn't appear as an option now on the website

@david_r​ Hello David, Need your help on the issue related to distributed engine setup with FME standard trial license where single engine is installed separate machine and remaining FME components on another host including Flow database on same. Kindly refer below link with example#2 that has been followed.https://community.safe.com/s/article/A-Guide-to-Choosing-your-FME-Server-Deployment-Architecture#FTEx2I have attached the log snap for your reference.Thank you.