- - Community Resources
Ideas
Product Updates
Events
Blog

Home
Forums
FME Form
Authoring

Authoring

Creating and organizing workspaces. How to use Workbench.

3,034 Posts
12,550 Replies

When you subscribe we will email you when there is a new topic in this category

3034 Posts

narinderContributor

Update Fanout expression name with date

Hi,I have a FME workbench and in the Fanout Expression, i have to manually amend the date (YYYY-MM) in the file name each month from 2024-06 to 2024-07 when running at the start of the month for the previous months data.E.g. the fanout expression will look like this:R@Value(ba_id)-2024-06-filename.xlsx So at the 01st August I would amend the above filename date to 2024-07. Is there a way to automate or code the date so I don’t have to manually change from 2024-06 to 2024-07 etc.

10610

3 months ago

abinashroutvParticipant

asked in Authoring

How to add attribute of one shape file which is a building footprint to multipatch gdb file LOD3 Building model.

I have a LOD 0(BUILDING FOOTPRINT) file and a LOD 3 Building 3d model file. Lod 0 is in shapefile format and Lod 3 is in gdb format. The gdb file have no attribute value and lod 0 have. so i want to add its attribute to gdb. How to do it?

331

3 months ago

louis_boekhoudtContributor

asked in Authoring

Density

How can be determined (estimation is all right) if a polygon feature (A) fits within another polygon feature (B) and count how many. thnks

User choice parameter using read data as choices

Hello!I'm trying to create a tool in Data interoperability (FME for ArcGIS) that gives the User a list of attributes to choose from based on the read source. I'll make things more clear.Let's say i have X.X= People infoI'm reading X and filtering out with a tester based on a criteria and it returns me 3 entries. Next i want the user to see those 3 entries and have the possibility to choose which ones continue along the process of the tool.I can't make the user choose the parameter beforehand because he does not know what the first tester will end up with.Is it possible to accomplish this in FME? If so how would you recommend to do?

782

3 months ago

helmoetzContributor

asked in Authoring

FME Schema from XSD for INSPIRE not complete?

Hello, I am struggling with the INSPIRE GML writer and the new version 5 of the ProtectedSites xsd schema.Earlier this year, the XSD schema was adjusted, among other things for the following:Correction of spelling error in inspireID Converting enumeration to code lists Adding attribute "thematicIdentifier" Datatype of legalFoundationDate to 'Date' Changing multiplicity of the elements legalFoundationDate and legalFoundationDocumentSee https://github.com/INSPIRE-MIF/application-schemas/releases/tag/2024.1 and underlying links.When I retrieve the attributes of the old version 4 schema, I get the list from appendix 1, which includes:inspireID.Identifier.localId inspireID.Identifier.namespace legalFoundationDate legalFoundationDocument siteDesignation{}.nilReason siteDesignation{}.xsi_nilThis worked well for my application.However, when I now retrieve the attributes of the new version 5 schema, I get the list from appendix 2. In it:I do see the corrected inspireId attributes. I also see th

803

3 months ago

vxn43Supporter

asked in Authoring

How to convert Lat and Lon fields to a Feature Class

I am trying to finish my workspace. I have gotten as far as the Attribute Manager which has Lat and Lon fields in it. Currently the data being fed into Attribute Manager_10 (screenshot below) is Lines. I want to use the Lat Lon fields in the AttributeManager_10 to create Points and not use Lines. Any ideas on what Transformer(s) I need to add after AttributeManger_10? Seems like VertexCreator would be the most appropriate Transformer to use in this situation, correct?

vxn43Supporter

What is the best way to convert Lines to Points? I would like the points that are created to fall in the middle of the line and include all non-geometry attributes of each line. I am hoping there a LinetoPoint Transformer out there somewhere.

1081

3 months ago

waterbeemdsContributor

asked in Authoring

Workspace run crashes on Arcpy

Hi,I have a workspace that executes a piece of python in a PythonCaller which uses ArcPy. However it crashes the ArcGIS application that is running the ArcPy(Not FME Form), giving the following popup The log doesn't have any errors and only two warnings: Python: There is a known Windows bug that may cause instability when using Python in the current locale. Please update to Windows 10 version 2004 and greater, or to Windows Server 2022. See http://fme.ly/nw5 for more details I have seen this warning a few times and in articles. So far this is the first time it gives me a crash. Articles say you need to update your windows version. At the moment I have Windows Server 2019 Datacenter, Version 1809.So there is an update possible here. Another warning is: PythonFactory script changed the current FME process locale from 'Dutch_Netherlands.utf8' to 'Dutch_Netherlands.1252' and FME has restored it back to 'Dutch_Netherlands.utf8'. It is undefined behavior to change locale and doing so may c

290

3 months ago

01011010Contributor

asked in Authoring

OData FeatureReader and Reader Operate differently with same parameters

Why does the FeatureReader transformer using OData operated differently (slower or not at all) with the same parameters used with the “regular” Reader, which performs as expected https://data.environment.alberta.ca/Services/EDW/waterwellsdatamart/odata/filterCreateTimestamp%20gt%202024-08-04T00:00:00-06:00 Table/FeatureWells Thanks.

Issues converting raster/geotiff cells to ESRI polygons

Hi All -I have been trying to convert a GeoTiff (also converted to ESRI Raster to try it too) and write to ESRI polygon feature class. I have used the steps below….. However, the translation fails and I get the following error:“Cannot write a non-point feature to a point feature class”There are no point features at play in any steps. RasterCellCoercer output cell geometry is set to ‘polygon’ and writer is set to polygon too. Does anyone know what is wrong here? Is another step in terms of geometry replacement or definition needed? Steps: Reader to read the GeoTiff (or Raster). RasterCellCoercer to convert the rastercells to polygons. AttributeCreator to convert the raster cell value to attribute. In this case _band{0}.value. Relevant writer to write the result to polygon FC.Thanks in advance!

434

3 months ago

bhkContributor

asked in Authoring

How to React and Email bases on PythonCaller Return in Automation

I have a Simple PythonCaller code to delete all .gdb files is a directory import osimport time# Define the directory and the age limitdirectory = r"../../../10_9_1"age_limit_days = 1current_time = time.time()# Calculate the age limit in secondsage_limit_seconds = age_limit_days * 24 * 60 * 60# Iterate through the files in the directoryfor filename in os.listdir(directory): if filename.endswith('.gdb'): file_path = os.path.join(directory, filename) file_age = current_time - os.path.getmtime(file_path) # Check if the file is older than the age limit if file_age > age_limit_seconds: try: os.remove(file_path) # Delete the file print(f"Deleted: {filename}") except Exception as e: print(f"Error deleting {filename}: {e}")Now using FME Flow(Server) I want to send an email based the Result of this code If there was a .gdb file to be deleted! then I need to get and expose the name of the delet

150

3 months ago

aguanContributor

asked in Authoring

Failed to call any datetime functions

We have been running FME Desktop 2022.2 on Windows Server 2019 machines for over a year, but found out last week any function calls to datetime or datetime reformating fails with this error “Failed to load timezone data. current_zone() failed: A mapping from the Windows Time Zone id "" was not found in the time zone mapping database”. For example, in the AttributeCreator, an attribute creation with the value being @DateTimeNow() got the above error. Anybody experienced this before and knew of a fix? Unfortunately I don’t have the option to reinstall FME on those machines.

581

3 months ago

thomastupuivaoContributor

asked in Authoring

Increment a value based on field value changing

I have a dataset that contains the “_related_suppliers” field that contains either 1 or 0; I would like to add a counter that will increment, whenever the _related_suppliers field changes; Is this possible?

462

3 months ago

davethebraveParticipant

asked in Authoring

Regriding data (CSAR -raster/pointcloud) and keeping smallest value in true postion in regrid.

Hi allFirst time poster, long time reader of all the great advice on this forum.using FME 2021.2.6 (work limitation)I am currently having issues regrinding my CSAR (Raster and Pointcloud) files while keeping the lowest value in its original XY position in the regirded area. Example of regirded squares with the smallest values being picked.Note: the gridded squares are just a visual example, I have potential looked at applying a Buffer to the soundings based on the (SCALE) area they fall into but have had no success yet. I also have an Area file (Shapefile1) that contains the regrid values (SCALE) I would like the effected CSAR file to be regirded too.Example: Of the desired regrid areas (Shapefile1) overlaying the CSAR file. I really have 2 issues currently affecting me that I need help with. 1) I need to be able to regrid my CSAR files (RASTER or POINTCLOUD) by keeping the lowest values in the regrided area.2) I have a Area file (Shapefile1) that contains the regrid values I

790

3 months ago

vxn43Supporter

asked in Authoring

Email addresses in spreadsheet and Emailer

Hello, Here is what I need to do: I have a workspace that includes the Emailer Transformer. When a file is placed in a folder and email is sent to the recipients notifying them that there is a file in the folder. The workspace works great. But, if one of the email recipients changes or needs to be removed for whatever reason, I am contacted and must go into the Emailer Transformer and manually delete the recipient. I would like to allow a user to open a spreadsheet of the email addresses and alter/delete them there rather than having to contact me. I need some help in getting started: If I have a list of email addresses in a spreadsheet, how do I include it or reference it with the Emailer Transformer? For example, if an email address is deleted or added to the spreadsheet, when the Emailer is going to send an email it will send the email to the list of recipients in the spreadsheet. Looking for some ideas on what transformer(s) I would need to use before the Emailer.

483

4 months ago

alc33Contributor

asked in Authoring

FeatureReader use user parameter for the coordinate system

Hi!I would like to create a workbench with a lot of flexibility for the users. I use a FeatureReader with a spatial filter. I create a user parameter to chose the system of coordinates. So I would like to use it on the Featurereader but there are no option. Do you know a way to indicate to this transformer the system of coordinates? I suppose the spatial filter will work if the datas are in the same system but I would prefered to force it.Thanks !

Read from WMTS based on bounding box.

What I try to do is to download a raster from a WMTS to use it as a background image for a report. I do not want to download the entire service, only a part to use as background. The result I get is only working on very zoomed out tile matrices, like 04, where the resolution is not useful: On deeper levels the FeatureReader is downloading a lot of tiles, which takes a very long time.The WMTS I use is a Dutch one, in epsg:28992. I wonder if I am doing something wrong, or this is never developed / tested for this coordinate system?The point is on 147513.92, 523126.09.The WMTS is https://service.pdok.nl/hwh/luchtfotorgb/wmts/v1_0?The Layer is Actueel_orthoHRAttached the 2023 workspace.

bjudesEnthusiast

Hi,I would like to merge polygons based on area up to a certain point. For example if I had 1000 polygons I would like to reduce that number to 100 keeping them as close as possible in size to one another. Does anyone know if this is possible in FME?Thanks for any help!B

983

4 months ago

chelseawuContributor

asked in Authoring

switch to a new machine, where to find FME Workbanch configuration files to move over?

Hello, I need to switch to a new machine. I save my workspace files under a designated directory, which has been transferred to the new machine. I am wondering if there is any important configuration file would need to copy over (e.g. some database connection, web connections, where those info stored?) and where usually to find the file?I am using FME workbanch 2023.2.3.Thanks.

272

4 months ago

oliviamarieParticipant

asked in Authoring

How Can FME Help Optimize Towing Logistics in NYC?

Hello Safe Software Community,I work for Riteway Towing INC, a leading towing company in Queens, NY. We're exploring ways to enhance our operations, particularly in managing our fleet of tow trucks and providing timely roadside assistance. Given the complexity of NYC's traffic and the high demand for 24 hour towing, we need a robust solution for real-time data integration and route optimization.Can FME help us integrate various data sources (like traffic updates, GPS data, and service requests) to streamline our dispatch processes and improve response times? Additionally, has anyone implemented FME for similar logistics and fleet management tasks? Your insights and experiences would be greatly appreciated!Thank you!Olivia Marie - Manager at Riteway Towing NYC

1362

4 months ago

jdhContributor

asked in Authoring

Accessing MacroValues

Is it better practice to use import fmeparam = fme.macroValues[‘parameterName’]orimport fmeobjectsparam = FME_MacroValues[‘parameterName’]in Python scripted parameters and why?

57014

4 months ago

joneszeroContributor

asked in Authoring

Unstructured data, selecting by row number

Hi,I’m attempting to create attributes from an unstructured html table.Looks like this… The table is originally a Word .doc, that I saved as a .html file so I could read it in FME. For example, I’d like to create an attribute (AttributeCreator) that selects based on row number … eg “Survey Authority” = Col1 row4or“End Date” = Col2 row8This there a way I can do this ?thanks

434

4 months ago

fallingdogContributor

asked in Authoring

Commit order of two writers targeting a single table

I have two table that I am trying to keep in sync. I want a target table to match a source table. But I am trying to avoid deleting all rows from the target and reloading it. The source table is in our CIS (customer information system) Oracle database and the target is in our GIS Esri Oracle database. I am using a CRC calculator to find rows that are identical. Then I have a writer to delete rows from the target that have been updated in the source and to delete rows that no longer exist in the source. Then I have a second writer to insert rows that exist in the source but do not exist in the target or have been updated in the source. The delete writer is based on a single key column.Okay, so it is important that the delete writer commits before the the insert writer. I have tested it and the delete writer does appears to commit first. The tables are synced properly and the FME logs show the delete writer committed first. So, my question is this: Can i count on the the delete writers a

WorkspaceRunner does not work on Data InterOperability extension of ArcGIS Pro 3.2

Hi there,I recently installed ArcPro 3.2 on my machine with the data interoperability extension. Looking under the hood, the data interoperability extension uses this FME version, FME(R) 2022.2.1.0 (20221202 - Build 22776 - WIN64). When I use the WorkspaceRunner transformer to run a simple workspace (read a text file and view in inspector), the transformer fails to read the published parameter, is says "Specified workspace has no parameters or could not be read". If you run the workspace using the workspacerunner, it gives you an error, "2023-08-03 14:20:14| 2.3| 0.0|ERROR |WorkspaceRunner_ExecutorAndRouter (TestFactory): An error was encountered evaluating a TestFactory test: An error occurred while evaluating a test parameter: @Tcl2 -- failed to evaluate expression `WorkspaceRunner_df4bad67_c886_4b16_8145_a18050c02ff01_runner {} {F:\\ETL\\TEST\\Workbench\\TESTING/workspace1.fmw}' -- unexpected token "END" at position 0; expecting VALUE". Is this an

1326

4 months ago

virtualcitymattEvangelist

asked in Authoring

FME Packages: best practive?

We have several FME based solutions - At the moment they are mixture of workspaces, CustomTransformers and formats. I guess my question is are people thinking about a package as a single tool (like a API connector) or can it also makes sense to include a number of transformers and formats in a similar way to an FME Server Project?

532

4 months ago

Page 5 / 122

Badge winners

cmkenned7has earned the badge 12 Days Participant (2024)
vvvhas earned the badge 12 Days Participant (2024)
olivierlhas earned the badge 12 Days Participant (2024)
cmkenned7has earned the badge Welcome Back
dylan.at.safehas earned the badge 12 Days Participant (2024)

Show all badges

30,232: Posts

Terms & Conditions Cookie settings

Sign up

Already have an account? Login

An FME Account is required to contribute

Login to the community

An FME Account is required to contribute

Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.

Enter your e-mail address

Back to overview

Scanning file for viruses.

Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.

This file cannot be downloaded

Sorry, our virus scanner detected that this file isn't safe to download.

A product of

Company Products Giving Back Careers Contact Privacy Feedback

Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.