- - Community Resources
Ideas
Product Updates
Events
Blog

Home
Forums
FME Form
Authoring

Authoring

Creating and organizing workspaces. How to use Workbench.

2,845 Posts
11,908 Replies

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

2845 Posts

Recently active

Most replies Most views Newest first

liamfezSupporter

asked in Authoring

Excel Column Formatting

When using Manual Attribute Definition in the XLSX Writer or FeatureWriter, is there a way to copy the Column Formatting between attributes? I have noticed that if I manually add a new attribute beneath one already formatted it copies the Formatting of the one above. But I was hoping there would be an easy way to set one, and then have it applied to all attributes.

1 hour ago

cnorthContributor

asked in Authoring

HTTP caller Update Salesforce records

Hi, I am looking into a way to setup the HTTP Caller to Update a record in Salesforce, the writer is not suiltable as this is best for bulk, my JSON has the case ID and teh name of the field that nneds updating.I’m not sure how to setup for updating and not sure how to ensure refresh token works?I have followed this guide, https://support.safe.com/hc/en-us/articles/25407494166029-Connecting-to-Salesforce-in-FMEbut it doesn’t connect, coming up with a network error?

4 hours ago

larueContributor

asked in Authoring

cavarlyContributor

asked in Authoring

Writing null geometry features to ESRI file geodatabase

Is it possible to create features with a null polygon geometry and write to an ESRI file geodatabase?I have some features with known geometry which I write successfully.I would also like to write features with no geometry to the same table and update their geometry by manual editing later.I have tried modifying fme_geometry{0} and fme_geometry but nothing seems to work.I usually get an error like “can’t write features to and area feature type” I have read through similar questions but don’t seem to have a complete response. It appears it is possible to create a valid null geometry. Thanks go any help.

3 days ago

redgeographicsInfluencer

asked in Authoring

Importing database connections in FME on Linux, no gui

One of my clients is using FME on Linux with only the command line interface and is having some trouble importing database connections. Specifically: they don’t know how to do it on the command line.I can’t find much in the way of documentation for this. I suspect that if it is at all possible it may be through the APPLY_SETTINGS command, but other than that I can see that that exists, I can’t find any indication anywhere on what those settings may be and how to set them.Any clues? Anybody with an old manual somewhere? I do have old installation cd’s and dvd’s going back to FME 2005, but I don’t think I have a computer with a cd or dvd drive anymore 😅 Hoping one of the other long-time users has something stashed away...

3 days ago

scarterContributor

asked in Authoring

HTTPCaller and 'bearer token' authentication method

Hello forum, I am working on a new API integration. I’ll be using HTTPCaller. The provider has said that their authentication method is ‘bearer token’ However the options in HTTPCaller are Basic, Digest, NTLM, Web Connection, Single Sign-On. Is one of the those options equivalent to bearer token? Thanks,Stuart

4 days ago

liamfezSupporter

asked in Authoring

Writing Geometries to an Attribute in MongoDB3

I have a complicated collection of features stored in mongo db, where a given feature may have multiple unique geometries stored as individual arrays. I would like to use the “Put” Operation in the writer to replace specific features. However when I write to mongo I get two different results (see screenshots of dummy feature with just one example geometry).location.coordinates{} attribute type set to stringlocation.coordinates{} attribute type set to doubleThe desired outcome would look like this:Referencing other community posts on related matters:After reviewing those other community posts I think I am going to need an alternative method to what I had started to develop. But I wanted to see if anyone had any ideas or experience with mongo writers to say otherwise.Thanks

6 days ago

jeroenpetersContributor

asked in Authoring

FME 2024.0 Prompt button

A small follow-up question, the prompt button on the toolbar has vanished for me since FME 2024.0. It also disappeared from the Toolbar options. Same goes for the Stop at breakpoint button.Any ideas how to get it back?

7 days ago

tnarladniContributor

asked in Authoring

Hover menu gone and properties button hidden from transformers

Installed 2024 Form. Noticed that the mouse-over over transformers, readers/writers are no longer there. You have to click on the item to see the menu associated with the item. The properties cog is no longer on the transformer title, you have to click on the transformer to get to it. This doubles the amount of clicks to get to things. And the “hover” menu doesnt go away. You have to click off. What in the Windows 98 is going on here??????I would like to hear the focus group that said, please hide functionality and make us do more clicks to get to stuff. I normally wait until xxxx.1 to download but I decided to to try it out early. big mistake. huge. Please bring back mouse-over and put the properties cog back on the transformer banner because I did not save a backup on my workbenches 🤡

7 days ago

anamanvil

asked in Authoring

Writing attributes to AutoCAD User Properties

Hi All, I am trying to write attributes to AutoCAD User Properties (within the panel) instead of exposing them using XDLIST Command. I know how to do so manually in AutoCAD by using ADEDEFDATA Command and FME seems to be able to read these attributes, amend them or even add new ones and Write an AutoCAD File showing these attributes within the User Properties panel. However, it does not seem possible to write a new AutoCAD File with these properties or use a template with this table added to it. Is this functionality even possible with FME? Have any of you found any alternatives? Many thanks for the time, Ana

8 days ago

liamfezSupporter

asked in Authoring

LogFile Timestamp Format

Is it possible to change the timestamp information that is included in the log file to UTC? I have been looking for a setting, but have yet to find one. This would be for the log files created in Form/Workbench, which currently log the time as local computer time.

9 days ago

mferwerda3Contributor

asked in Authoring

Clipping raster- skipping cells on Inside port

I am clipping a raster by a polygon, but it sometimes seems to skip parts, I have the clipper set to Candidates on clipper boundary set to Output as Inside. I know this poly crosses 4 cells, so this is what I was thinking would come out of the clipper Inside port But instead I get this Any thoughts why it is skipping that one cell? This is a single band raster and all these cells have data

9 days ago

scarterContributor

asked in Authoring

Workspace returning 'failed to send request to URL' errors

Hello Forum. I’ve just run a workspace. It was successful and produced data as expected. No problems there. However it produced two errors never seen before… Is this anything to worry about? They didn’t seem to affect the workspace or outputs. Thanks,Stuart

10 days ago

dustinInfluencer

posted in Authoring

Best practice for SQL geometry edits

Would like to hear the opinions of the collective on best practices for writing features back to a SQL database. Specifically Intergraph SQL in my case, but I guess this could apply to many formats.I have a table with millions of linear features that need to go through a LineCombiner process before being written back to the same database. The big question….what is the best methodology for deleting the old geometry and inserting the new? Two methods I’ve used in the past, each with their own downsides.• SQLExecutor/DatabaseDeleter based on the unique ID. Main concern with this is if the translation fails after the Delete but before the writing of new features, those features are gone.• Let the writer do a DELETE/INSERT (fme_db_operation). To me this is safer, but can take twice as long due to number of transactions.I can’t simply truncate the table because we are sometimes only reading a subset of the features in a specific AOI within the database. Truncating would also delete the

10 days ago

arthyContributor

asked in Authoring

Visibility analysis with DEM

I would like to perform a visbility analysis as I’m used to with the esri’s fonction arcpy.sa.Visibility.I tried to build something and after goglling, I read this excellent post which is not working for me because I’m currently bound with FME 2021.2 and the script of this post uses a newer version.Is there a way to perform a visbility analysis with FME 2021?Currently it looks like the clipper is not able to work on TIN surface.Any ideas?

12 days ago

stuarmitagehomeContributor

asked in Authoring

How do I write to csv file, naming the file using the value of the first row?

How do I write a csv file and name it using the value in the top / first row?I want just one file to be created, (not multiple files like fanout creates) named after the entry in the first row.For example in the table here I have 9 rows and 2 columns. I want to create a csv of all of this data but named “20231207.csv” As a secondary question, you will see the first attribute column is sorted into date order. If this wasn’t sorted into order, what is the quickest way of identifying the closest date to the current date, and then using that identified value to name the csv file?Hopefully this is something really simple!Thanks in advance.Stu

13 days ago

hlynurContributor

asked in Authoring

WKB not becoming a Geometry

Hello yet again 😅I’m GET-calling a an online database through HTTPCaller which responds with giving me a feature in WKB code (in _response_body), then I run the respective code through GeometryReplacer and tried different WKB Encodings in attempts to get a geometry out of it (this should be a polygon), but no luck.The following encodings give me this:Hex Encoded FME Binary: Rejected (INVALID_PARAMETER_GEOMETRY_SOURCE) OGC Well Known Binary: Rejected (INVALID_PARAMETER_GEOMETRY_SOURCE) Hex Encoded OGC Well Known Binary: Ends up in Output and thus not in the rejected port but it does not create any geometry feature that can be inspected.The code is following, so if anyone has seen this before or is enthusiastic to figure this out with me then feel free to investigate:0010300002084080000010000000E000000931E86C64699244192E9D0891B741D41DBF97EF242992441C3F0110102741D41F4A963551A99244180F3E2341E741D41F4531C970F9924415EBBB401E0731D41AED4B380CF982441BF9A03840B741D41001E5119CB982441BB0A294FED73

13 days ago

rustyContributor

asked in Authoring

FME Form 2023 start page

Wondering if anyone can tell me how to clean up the recent files list on the fme form start page,Any clues appreciated, I have a long list of old files I was sorting out, now would like to clean up the recent files list on the start page.

13 days ago

hawaiialexContributor

asked in Authoring

Resolve Domains Function Replication of FCs in EGDB

Hi all,I am working on a script to replicate a set of feature classes from one enterprise geodatabase that we use for transactional editing purposes to another enterprise geodatabase that we use for publication purposes for the organization. This replication script would be scheduled in FME Server to run on a nightly basis.The issue is that the feature classes I plan on replicating have several domains and subtypes applied to them that don’t translate correctly.I’ve been advised to use the ‘Resolve Domains’ functionality and change the configuration from ‘coded domain’ type to ‘char’.My test workflow involves the below:Copying the feature class via the ‘Import Feature Class’ tool in ArcGIS Pro into the target Enterprise Geodatabase to have the feature class available in both geodatabases With FME:Selecting the ‘Resolve Domains’ checkbox in the Writer at the outset, and using the ‘Insert’ and ‘Truncate Existing’In the Writer configuration, changing the ‘coded domain’ type to ‘char’ and

13 days ago

arash_hokmContributor

asked in Authoring

Enter the values of a list into a column

Hello FME community,I would like to write the values of a list into a column. I would separate them with a minus. It may be that the list of a data set has 1 or 2 or three values.If a list of a data record has no value, no minus was written to separate it. I am attaching 2 pictures to understand it better.

14 days ago

milo89Enthusiast

asked in Authoring

Is it possible to return FME 24 to a Classic View?

I’ve been dabbling in the latest release of FME Form 2024 for a little while now and I’m just not getting the benefits of the new look, specifically the removal of colour from most icons.I could go into personal reasons why colour helps myself with attention to detail, concentration and focus but I’m just wondering if it’s possible to get a classic look while utilising any new functionality.

14 days ago

Page 1 / 114

Badge winners

rahulsharmahas earned the badge Enchanted by Attributes
tivixiaomigiatohas earned the badge English Speaker
olympiadoshas earned the badge Student (Grey)
nicol.riccihas earned the badge Teacher (Grey)
syahrastaniahas earned the badge Teacher (Grey)

Show all badges

28,810: 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 username or e-mail address. We'll send you an e-mail with instructions to reset your password.

Username or e-mail

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