- - Community Resources
Ideas
Product Updates
Events
Blog

Home
Forums
FME Form
Authoring

Authoring

Creating and organizing workspaces. How to use Workbench.

3,046 Posts
12,621 Replies

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

3046 Posts

kniggeContributor

Out of a huge number of Polygone couples finding the nearest cuple part along a line

Hello there,I got 3 tables. There is one table with polygones (A) and two with lines (B and C).The lines in table B are going through my polygones. With the LineOnAreaOverlayer I cut the polyonges (A) in two. Now I need to know which part of the cuttet polyone is further away from my lines out of table C (in a max distance around the lines in C from ± 10 meters).For each cuttet polygone couple I need the furthes away one from the lines out of C.So along my C Lines are a lot of cutted polygone pairs. For each pair I need just the polygone which is further away.Any ideas?I tried the NeighborFinder alrdy, but dont geht my result. Thanks a lot!!!

373

7 months ago

kelvin.jenkinsContributor

asked in Authoring

DWG Writer with Thumbnail

I’ve been trying to write a DWG that includes a thumbnail preview.Selecting Write Thumbnail Image hasn’t made any difference to the files in windows explorer.Is there a tick to making this feature work?I’ve also looked at other options to generate thumbnail images using tools like the image rasteriser or MapnikRasteriser, but they’ve struggled to generate a good representation of the DWG vector content.Any ideas on an easy workflow to generate thumbnails for DWG content?I’d love to just pull an image from the 2D graphics preview within FME...

660

7 months ago

kmc5678Contributor

asked in Authoring

What is the best way to stop a workspace if a NULL value exists in field?

I have a workspace that sends data to a url through the HTTP Caller transformer. I want to terminate the workspace if a NULL value exists in a field that is in a table on a SQL database before the data is sent. What is the best way to do this? Do I still need the Creator transformer if I use a Tester?

793

7 months ago

schulte.aContributor

asked in Authoring

Want to split an attribute, then make new rows that insert the separated values into the new rows

I have a table where I have emergency meeting points. Each building has a meeting point, some buildings have many points, here is an example:Building Meet_Points 123 11,12,13 124 16 I would like the table to look like this:Building Meet_Points 123 11 123 12 123 13 124 16 How would I separate those meet points, and make numerous rows of the same building that has each meet point and all the other attributes carry over to the newly made rows and are the same?

742

7 months ago

scarterContributor

asked in Authoring

Where do custom transformers get installed?

Hello forum, This is probably a very silly question, but where do custom transformers (ones downloaded from the Hub) get installed? I ask this because I have downloaded the What3WordsEncoder and What3WordsDencoder transformers from https://hub.safe.com/publishers/safe-lab/transformers/what3wordsencoder and https://hub.safe.com/publishers/safe-lab/transformers/what3wordsdecoder.I’ve transferred the files to the server hosting FME Form, I’ve gone to the folder they’re stored in within in File Explorer, right-clicked and selected Install. A message appeared saying it installed. But now if I search in the Transformer Gallery in FME Form they are not found. So, can I instead browse to them? If so, where do they get installed? Thanks,Stuart

711

7 months ago

t_hohenstraterContributor

asked in Authoring

JSON file that is dynamic and separated between data and headers

Hello, I have the following JSON file (sample) where by te attributes names are under “Channels” while the data values are under records. This JSON come to me as a API call and have no way of modifying the source. Using FME 2019 { "deviceID": 12345, "channels": [ "RecordTime", "Status", "Current Total Average Main", "Current Total Average Load1", "Voltage Total Average Total", "PhaseAngle Total Average Main", "PhaseAngle Total Average Load1", "Voltage Total Instantaneous Total", "Current Total Instantaneous Main", "Current Total Instantaneous Load1", "PhaseAngle Total Instantaneous Main", "PhaseAngle Total Instantaneous Load1", "ModemSignalStrength Total Average Total" ], "records": [ { "recordingTime": "2002-03-03T00:00:00", "status": "None", "values": [ 2.781, 0, 237.95, 37.4, 0, 238.27, 2.804, 0, 37.66, 0, 14.82 ] }, { "recordingTi

3916

7 months ago

charryContributor

asked in Authoring

why read two obj, the one obj texture display another

I read two obj models, but one of them has a texture displayed as a blend with the other model

251

7 months ago

tnarladniEnthusiast

asked in Authoring

RegEx to get the first letter of each word. Works in search, but not in SubstringRegularExpression

I’m trying to create a new value based on the first letter of each word in a string. I tested the regex ‘\b(\w)’ and the returned value is correct, but when I used that regex in the @SubstringRegularExpression(), it only returned the first letter of the first word.@SubstringRegularExpression(@Value(ID),\b(\w)) where ID is “MARKHAM RD/ORANGE BLVD, SANDFORD”. You can see in the regex editor, it is correct. This is the result of the substring

1172

7 months ago

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.

1195

7 months ago

p_c_20Contributor

asked in Authoring

Sampler and looping - chunking up inputs to SQL Executor

I am running a call to an Oracle DB based upon an input ID as a feature attribute value coming in from a CSV. There are upwards of 2000 ID’s to process. Initially, that call was running on a per-feature basis; I am now trying to make this more performant by using the IN statement e.g. WHERE ID IN (‘1’, ‘2’, ‘3’). I am doing this by aggregating incoming ID’s into one attribute value. Where this falls flat is that there appears to be a limit on items that Oracle can cope with in an ‘IN’ statement, so I figured I would chunk it up into more manageable numbers. My first thought was to create a looping transformer. My conception of this would be that a Counter would increment a Sampler to take the first 500 records (X), then the X+1 group of 500 (e.g. values 501 to 1001), X=2 and so on, until the _matched_records result coming out of SQL Executor was 0, at which point a tester in line would fail. However, Sampler doesn’t support that kind of expression building (as far as I can see). Any id

362

7 months ago

dannymatrangaContributor

asked in Authoring

FME 2024.1 Beta Bug: Choice Parameters

My workspace is not keeping my user parameters settings. It creates extra blank parameters when I close the User Parameter Editor window, and then my choices become useless at runtime. I’m also not able to delete these extra blank parameters. Downgrading to the stable version of FME Form but wanted to note the bug here.

621

7 months ago

liamfezInfluencer

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.

442

7 months 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?

210

7 months ago

larueContributor

asked in Authoring

Need Help with Batch Processing Using Workspace Runner

I have been trying to set up a batch process to create dwg files, adding a template based on the respective input file. I have tried to follow the advice from the links below, but am missing something or what I am doing isn’t quite the same. At any rate, my workspace fails after trying numerous different configurations. Published ParametersBatch processing I have attached the two Workspaces. The goal is to apply a CAD template to it’s respective output file, with the inputs controlled by the WorkspaceRunner parameters. The Workspace that outputs dwgs takes inputs from three sources: Two different folders of CAD files (one of which also happens to be same as the template but used for a different purpose), and a spreadsheet . Any insight is appreciated. Thanks.

Measuring distance between polygons

My dataset contains some river basins polygons, with 1 forestry polygon falling into each one. Each river basin also contains multiple habitat polygons. I am trying to measure the distance (edge to edge) between the forestry polygon and each of the habitat polygons falling within the same river basin. I’ve done some spatial joins to associate each forestry polygon and each habitat polygon to it’s respective river basin, but I’m unsure how to measure the distances between them, while grouping by river_basin_id. Any help would be greatly appreciated.

491

7 months ago

virtualcitymattCelebrity

asked in Authoring

Get a list of filenames based on the user selection?

I’m working on an upload process via REST call and I want to use FME to do the upload.For the API I need to provide a list of file names in advance. I want this to just work and I want to be able to use FME’s multiple file picker to allow the user to pick folders, multipler files or just a single file. etc.Does anyone have a good/robust method for getting a full list of the files (and filenames) that this input could be.My initial plan is to split up the input parameter into a list and then figure out what are folders and what are files and for folders I would use a PATH reader to get the files.I guess I need a “MultiFilePathResolver” kind of thing.

502

7 months ago

buchsteiner_24Participant

asked in Authoring

Snap line endpoints to points in the z-direction only

Hi everybody!I have a point layer and a line layer. The line layer consists of connected lines, and at the lines endpoints there is a point from the point layer in the exact same location. I moved the points in the z-direction because their height had to be corrected (new z-values were derieved from a point cloud). Now i also want to move the corresponding line endpoints in z-direction as well so that they again match the points in x, y and z. I guess the AnchoredSnapper with Group Processing could do the job but don’t know how to prepare the data for that. Can anyone help me with this? red: original position of points and lines; green: points moved in z-direction due to height correctionQuestion: How can I make the lines follow the points in z-direction? I am grateful for any advice!

521

7 months ago

redgeographicsCelebrity

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

1159

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

chlaw2001Participant

Hi, as a newbie in FME, I am using a FME ISO8211 reader to expose some of the attributes for further transformers. However, if all records have to be read, a message “Message #706501 is not present in the message file: Parameters are >< and FME HOME is >C:\Program Files\FME\<” was prompted and the whole process was halted. The FME version I am using is FME2018. Thank you for the kind response!

380

8 months ago

liamfezInfluencer

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

362

8 months ago

olivier2Contributor

asked in Authoring

How to connect all the right points while not including the

Dear, I want to link all the lightposts to the nearby road segment. I used a buffer around the road segments and then Neigborfinder to do this. Now I am afraid that some lightposts are not linked to the roadsegment but I am not eager to increase the buffer or neigborfinder because maybe lightposts that should not be linked will be included. Is there maybe another way to bypass this? Or some tips you could give me?

1065

8 months ago

tnarladniEnthusiast

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 🤡

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

36614

8 months ago

liamfezInfluencer

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.

872

8 months ago

Page 10 / 122

Badge winners

farshidprohas earned the badge Integrate Spatial Data
gautammotvanihas earned the badge Expert (Grey)
gautammotvanihas earned the badge Teacher (Grey)
gautammotvanihas earned the badge Student (Grey)
nfrihas earned the badge FME Form Basic Training

Show all badges

30,382: 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.