Skip to main content

Authoring

Creating and organizing workspaces. How to use Workbench.

  • 3,195 Posts
  • 13,113 Replies
3195 Posts
vxn43
Supporter
vxn43Supporter
asked in Authoring
Create Mailing Labels?

I have a spreadsheet with Address, Street Name, City, and Zip Code fields with 500 addresses. I need to create mailing labels for each address in this format: Occupant 1234 Main St City A, 54433 The output would be a Word/Text doc with the list of labels. What Transformer(s) would be used to create these?

132
j.botterill
Influencer
louielou1234
Contributor
louielou1234Contributor
asked in Authoring
How to create user parameters from supplied CSV

Hello, parameter newbie here apologies... but could anyone provide a link or information on how to configure parameters dynamically from a csv so that users can identify the Address column they want to use for the geocoder in the app-- as users will typically bring their own csv schema to the app for geocoding. Thanks for any help here!!

211
j.botterill
Influencer
milo89
Enthusiast
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.

47723
milo89
Enthusiast
james_c_452
Supporter
james_c_452Supporter
asked in Authoring
Autodesk writer error

Hi, I’m getting thrown this error by my feature writer when trying to write to a dwg. I have not changed my workspace and used it a hundred times with no issue, except this one case. I am getting this error: AutoCAD Writer: An error occurred for dataset '.\QHPRW_Tiles11,12_QA.dwg', in function AutoCAD2004Writer::writeBlockHeader. Exception thrown: 'Invalid Symbol Table name' (Invalid Symbol Table name) I have no symbols/cells/block to write. I am using a template file to set the right colours and display. I am able to write the file if I remove the comma from the name. However, I have another file the works fine that has a comma in it. So that can’t be the real issue. Does anyone have any ideas? I am using FME 2023.2.1 Thanks

284
james_c_452
Supporter
ebygomm
Influencer
ebygommInfluencer
asked in Authoring
Directory and File Pathnames - Path Filter now case sensitive?

In 2024.1 it appears that a Directory and File Pathnames reader with a Path Filter set to *.tab only reads tab files with a lowercase extension. In 2021.2 both .tab and .TAB files are read A MapInfo TAB file reader pointing at a folder path such as "E:\Mapinfo\**\*.tab" still reads both .TAB and .tab files Is this expected behaviour?

1074
DanAtSafe
Safer
tva
Contributor
tvaContributor
asked in Authoring
Connecting to azure with managed identity for azure key vault (FME Form)

Hi, IT is storing our passwords in azure key vault and they are rotating on a structural basis. We don’t have FME Flow. There is an FME app registration in azure, so i have tenant id, client id and client secret that can be used for like blob storage and sharepoint. Is there a way to connect in FME to azure key vault? Also IT is talking about using managed identity, are there any examples on how this can be implemted to fetch passwords from key vault?

372
j.botterill
Influencer
iamprem
Contributor
iampremContributor
asked in Authoring
How do I identify all the connected conductors of an electric device in FME?

I want to identify if there is a way to identify all connected conductors of an electric device using FME. All the points (Electric Device) and lines (Electric Line) in the attached screenshot are actually all connected. This is actually connected in Smallworld and I want to establish the same connection in FME but in ESRI this is not graphical connected as depicted in the screenshot. I can trace connectivity form Electric Line to the device but not the other way around. I want to correctly merge Electric Line data with Electric Device records. More than one electric lines can be attached to one device and so far I have tried List Based Feature Merger, Feature Merger and Spatial Relator with Intersect Predicate. Buffer will also not work in this scenario as it may take into consideration some other nearby line. There are no associated or connected features in Electric Device which may link it to Electric line, hence List based feature merger is also failing. ESRI : SMALLWORLD:

472
hkingsbury
Celebrity
vxn43
Supporter
vxn43Supporter
asked in Authoring
Switch from External Monitor to Laptop screen makes fonts and icons really tiny

I disconnected my external monitor to work on my laptop (not external monitor) from a different location. When I open up my FME Form workspaces, the transformer parameters font and icon sizes are really, really, tiny. I saw the way to fix it was in FME Form go to Tool - FME Options - Appearance - Advanced Option and check “Enable automatic scaling for High DPI Monitors”. I have enabled this, closed FME Form, and re-opened it. I have unchecked it and did same. Nothing seems to make a difference. Is there another way? I am using FME Form 2021.2.0.1.

231
milo89
Enthusiast
cruzh
Contributor
cruzhContributor
asked in Authoring
Creating a web page based on excel data and user input from a drop down.

Hello: This is probably a simple use case to many of you, but I only have basic experience with FME Form and Flow. One of our programs has the ability to generate standard excel spreadsheets which contain reservation data (Date, Name of Room, Description of Room activity, Organizer contact info) GOAL: We would like FME to take that excel spreadsheet and post that data as a table on an html webpage. However, before that html webpage is generated, we would like the user to visit an FME Flow App (? I think) that will allow them to select from a dropdown list of rooms culled from a column in the excel spreadsheet. Once selected and submitted, the app would only show the list of active reservations Things to note: This excel spreadsheet data is updated once a day and will only show the current day’s data and will need to be uploaded to FME Flow each day. It’s being stored on a network location. I’ve managed to create a FME Desktop app that uses Excel Reader > HTMLReportGenerator > HTML Writ

1412
cruzh
Contributor
fme_can_do_it
Enthusiast
fme_can_do_itEnthusiast
asked in Authoring
Excel formula

Hello all! I am stuck and unable to create a formula in FME. It involves an Excel formula that I can't seem to replicate in FME. I know there's likely a simple way to achieve this. I need to subtract values. Here is a screenshot for reference: I would greatly appreciate any help!

1125
nielsgerrits
VIP
juliarozema
Contributor
juliarozemaContributor
asked in Authoring
Feature Reader from Esri FGDB with a where clause based on a last_updated (date/time) field

Using an Esri FGDB Reader (an Esri FGDB FeatureReader) in a Workbench, I would like to apply a where clause using the last_updated field. I believe that because this is a date/time field that it is causing me troubles as I am able to run tests on other fields. What is the correct syntax to enter a where clause on a date/time field from a FGDB?

644
ebygomm
Influencer
mcgregrr
Contributor
mcgregrrContributor
asked in Authoring
Custom geographic transformation from ESRI - steps to use in FME workflow

Hello, I use a custom transformation in the ArcGIS platform. It is a two step projection which uses the Ontario NAD83 grid file to project to NAD83 CSRS and then the second step is projecting from NAD83 CSRS to WGS84 geographic (LL). The two tranformations are: ON_NAD83_NAD83CSRS_CustomTranf, (custom transformation set up in ESRI) NAD_1983_CSRS_To_WGS_1984_2 (chosen ESRI transformation). This two step process was recommended by ESRI Canada to import data into their ArcGIS Online format. I have seen various articles for parts of this process in the FME Community but I guess I am looking for a stepwise list (e.g. obtain grid shift file from authority, create custom transformation in ESRI, etc.) to get the pieces of the puzzle in the right location to use in an FME workflow. Thanks

351
kailinatsafe
Safer
aawad.93
Contributor
aawad.93
asked in Authoring
Issue with Updating/Truncating AGOL Feature Service via FME Flow – "413 Request Entity Too Large" Error

Hi everyone, I am working with a large dataset (over 500,000 records) stored in PostGIS, which I am reading into FME and writing to ArcGIS Online (AGOL). My goal is to automate this process by publishing the FME Workbench to FME Flow, so the AGOL feature service updates every few hours. When I overwrite the data, the Workbench runs without any issues. However, I want to truncate the existing data instead of overwriting it. When I attempt to do this, I encounter the following error: 413 Client Error: Request Entity Too Large Occasionally, I receive other request size-related errors as well. I tried adjusting the Features Per Request parameter to 500, but the issue persists. I’d like to ask if anyone has experienced this issue before and what possible solutions or workarounds exist to efficiently truncate and update the AGOL feature service without running into request size limitations. Any insights or recommendations would be greatly appreciated! Thanks in advance.

631
nielsgerrits
VIP
crutledge
Enthusiast
crutledgeEnthusiast
asked in Authoring
Scripted Selection List Choice or Dropdown Form vs Flow

Hello Everyone, I wonder if folks might be able to help with troubleshooting ideas for a Scripted Selection that I am trying to put together. I am trying to dynamically read a SharePoint List using a web connection. When the sharepoint is read users get to choose from the list of records. I can get his working in Form but when published to Flow I do not get a dropdown[v] or list selector [...]. Am I missing a trigger or something? Thanks a bunch for reading.

642
crutledge
Enthusiast
winklerj
Participant
winklerjParticipant
asked in Authoring
Script to Move Pdfs to folder location based on the name of the file

Hello, Newbie to FME here, trying to create a simple script to move multiple pdf files all located in one folder to multiple folders which match the name of the folder. Tried using File Copy Writer but had no luck.

452
davidlee
Supporter
jacintasomers
Contributor
jacintasomersContributor
asked in Authoring
Lag on adding transformer to canvas

Has anyone had any issues with the speed at which the list of transformers appears when you start typing? For example, if I start typing Creator it can take 20 seconds or more for the list to appear for me to select the transformer from. All of the transformers are the same.

191
svantepanter
Contributor
joepk
Influencer
joepkInfluencer
asked in Authoring
Dynamically create suffix to newly copied gdb

Hi all, I am using the Overwrite Existing Geodatabase/Template Geodatabase functionality: This creates a new copy of my gdb with a “_yyyymmdd” suffix. However, if my users run this multiple times a day, they have to delete the output of the previous run. I would prefer there to be a “_yyyymmdd_N” suffix, with N being incremented for every time the workspace has finished running that day. What is the sleekest way to implement this? I now have built something with a Path FeatureReader and a combination of Testers and StringConcatenators to filter out and manipulate the different filenames with either no suffix, a date suffix or a date+N suffix. Then FeatureJoiners to join the different path features into one: It works but its bulky and it feels overengineered. Any inputs? Kind regards, Joep

587
bwn
Evangelist
vxn43
Supporter
vxn43Supporter
asked in Authoring
Issue Token from Portal for ArcGIS

I have provided a consultant with the URL to one of my geocoder services. In order for them to access it, I need to issue a token. The token is issued in the Portal, which means it is valid for a maximum of two weeks. Currently, I have to issue a token every two weeks, a manual process. I would like FME to issue a token and then email it to the recipient. I know how to do the email part, but is it possible for FME to contact the Portal and issue a token? My ultimate goal would be to add this workbench to an Automation and have the token automatically issued every two weeks.

191
hkingsbury
Celebrity
mkh.rcjy
Participant
mkh.rcjyParticipant
asked in Authoring
how can I read points that created curve in dwg

Good morning, I want to read the points the created the curve in DWG civil 3D file so the reader will draw the curve with the same accuracy.

322
hkingsbury
Celebrity
ebygomm
Influencer
ebygommInfluencer
asked in Authoring
Warning message: Resetting a database that is still referenced.

Since upgrading to FME Flow 2024.1, we see these warning messages in the log files. Is there a way to get rid of them?

3359
AliAtSafe
Safer
virtualcitymatt
Celebrity
virtualcitymattCelebrity
posted in Authoring
Linked Custom Transformers - A foolish realization

So I made a previous post this week asking about CustomTransformers For most of the time I’ve been working with FME I’ve always seen linked CustomTransformers as tools where Global. That it they should live in Resources>Engine>Transformers on FME Server. I’ve always wanted to keep this clean and so most of the time I try to embed transformers wherever I can. But silly me, I just noticed that when publishing a linked transformer from workbench you’re prompted for a repository to choose… How have I not realised this before. This makes so much sense - it means that I can create linked CustomTransfomer that are project specific and keep them in their respective project. I never got this in I think in part because FME Desktop/Form doesn’t support this. The Transformers always need to be in a known/central location. I created an idea so that the same kind of structure can work with FME form as we can on FME Flow: To me this kind or structure just allows keeping everything together - for exam

280
virtualcitymatt
Celebrity
fme_junior
Contributor
fme_juniorContributor
asked in Authoring
Calculating population from point located in a buffer/surface

I have a first shapefile with points indicating the number of inhabitants. I have a second shapefile with surfaces. I would like to know the number of inhabitants for each surface in FME. What is the process?

321
nielsgerrits
VIP
tamadur
Contributor
tamadurContributor
asked in Authoring
How convert (.fme) file to (.fmw) file

Hi FME teachers and users, I have files in (.fme) formats, how convert them to (.fmw) formats?

453
danilo_fme
Evangelist
virtualcitymatt
Celebrity
virtualcitymattCelebrity
posted in Authoring
Linked Custom Transformers - looking for feedback

I have a number of workspaces, lets say 5, but this could expand. Each of these workspaces is like a validation check / test. There is a lot or duplication between the tests and I’m thinking about creating some linked customer transformers in order to not have to make changes 5 times in a row. I know this is usually good practice in programming in general. I’m a little hesitant though because adding linked custom transformers can add complexity (passing attributes 7 parameters etc etc) and makes testing/edits kind of annoying. I’m interested to hear others experience with working with linked customer transformers -pain points, whats great, when you use them over when you don’t

505
virtualcitymatt
Celebrity
fme_can_do_it
Enthusiast
fme_can_do_itEnthusiast
asked in Authoring
quick question about excel writer settings

Hi! I am currently writing data into an Excel spreadsheet. I have added two feature types that are configured to truncate existing data and overwrite it in the spreadsheet. Now, I need to add another feature type that includes charts and some formulas. These formulas have been set in Excel to sum data from one of the tabs I created in the spreadsheet, and I made a chart based on that data. Is there a way to keep the third tab intact when I overwrite and truncate the data in the first two sheets? Thank you!

422
fme_can_do_it
Enthusiast

Helpful Members This Week

Badge Winners

Show all badges

Popular Tags

Community Stats

31,153
Posts
118,100
Replies
38,771
Members

Latest FME

Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

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