Skip to main content

- - Community Resources
Ideas
Product Updates
Events
Blog

EN

Home
Forums
FME Form
Authoring

Authoring

Creating and organizing workspaces. How to use Workbench.

2,996 Posts
12,389 Replies

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

2996 Posts

Recently active

Most replies Most views Newest first

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

asked in Authoring

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

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?

joneszeroContributor

asked in Authoring

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

dustinInfluencer

asked in Authoring

ResourceManager and security settings

We have several memory intensive workspaces that normally return log file entries like:INFORM|ResourceManager: Optimizing Memory Usage. Please wait…Recently our IT department was sourced to a MSP, and it seems many security settings have changed. Now when FME tries to ‘optimize memory usage’, we receive Windows warnings similar to the screen shot below for ArcGISIndexingServer.exe and FNPLicensingService.exe. There does not seem to be any adverse effects in FME otherwise.Should we be concerned with these warnings? Will the memory available to FME be lower since access is being blocked? What can I ask the MSP to fix if it is an issue?

jhawksContributor

asked in Authoring

Compare two excel files, write the differences to a third file?

1st file example: 2nd file example:dog dogcat birdbird cowhorse cowCompare and write what’s missing from file 2 to a 3rd file.

justynakrajewskContributor

asked in Authoring

In the 3D modeled buildings, some normal vectors on the exterior walls are pointing to the right while others are pointing to the left. How can I identify and reverse the vectors that are pointing to the right, so that they all point to the left?I attached sample buildings.

rustyContributor

asked in Authoring

snap polygons in one layer to polygons on another layer

I have 2 datasets of roads, one is a whole of site polygon layer and the other layer is broken into segments for each section of road. I have manually edited the whole of site layer to match our property boundary layer. Now I would like to match the road segments to the whole of site possibly by snapping the segment layer to the whole of site layer. I really hope there is a way to do this as it would be a massive job to manually align each individual segment to the whole of site layer. It has taken me 3 weeks to do the whole of site layer alone.

luisegutierrezcContributor

asked in Authoring

Extract Polygons from Json file

Hi Guys, I have recently using FME and would like to know if anyone can help me explain how to extract the polygons from a JSON file. I intend to create a workspace, but it does not extract what I need. Also, I have read a few similar questions about this topic but still do not have a solution. The file is the following one:Also, I have attached my workspace with much of the work :( If there is anyone who can help me much appreciate it.

bhkContributor

asked in Authoring

Issue on Publishing From FME Desktop 2023.1 To FME Server 2021

Using FME Desktop 2023.1 I am able to use a SQL Server Database Connection (None Spatial) and ETL from database with no issue. When I try to publish the same script to FME Server 2021 and attaching the database connection to the script I am getting this errors Failed to add database type 'Microsoft SQL Server' - FME Flow encountered an error and reported the following message.Path not found I also tried to use an exiting same connection which I already published with FME Desktop 2021.1 and now I am getting this error message 49 2024-7-23 11:04:25 | SQLExecutor_<Rejected> (TeeFactory): Feature specification `NO_LOGGING' in mapping file row `FACTORY_DEF * TeeFactory FACTORY_NAME SQLExecutor_<Rejected> INPUT FEATURE_TYPE SQLExecutor_<REJECTED> NO_LOGGING OUTPUT FAILED FEATURE_TYPE * @Abort(ENCODED,SQLExecutor<space>output<space>a<space><lt>Rejected<gt><space>feature.<space><space>To<space>continue<space>tr

mahapandianContributor

asked in Authoring

Raster clipping

Hi,I'm trying to clip raster data using a 1k*1k grid shapefile. I'm not achieving the desired results as the clipping is imperfect, resulting in gaps or extra pixels. My goal is to clip the raster strictly within the boundary without any additional or missing pixels.Could someone please suggest a workflow for this?sample data:

scarterContributor

asked in Authoring

Forcing FME Form to write out an empty .tab file based on null TestFilter results

Hello Forum, I have a workspace which consumes an incoming geojson and then outputs three .tab files based on datestamp value combinations (via TestFilters): Active sites – where the start_date datestamp is in the past and the end_date datestamp is in the future Closed sites - where the start_date datestamp is in the past and the end_date datestamp is in the past Upcoming sites - where the start_date datestamp is in the future past and the end_date datestamp is in the future This workspace is doing exactly what I want it to do, so far. However, it’s entirely possible that there may be occasions when no object falls into one of the categories (e.g.: Upcoming sites). At the moment, if that happens then the workspace does not create an output. In this scenario I’m left with the most recent previously created output, where there were Upcoming objects. But in this scenario I need the workspace to create a tab output , but with no objects within it. Is it possible to programme this in into t

bhkContributor

asked in Authoring

FME SQLExecutor Returns only an Empty Column

Using FME 2021, and 2023 SQLExecutor, I am running a simple query to return data from a non spatial table in SQL Server, but I am getting an empty column in return The number of rows are exactly 145 and SQLExecutor result is showing that but the visual Preview just showing an empty column (again with correct 145 rows) I even added a AttributeManager to script but same result is happening Can you please let me know what I am doing wrong here?

james_c_452Supporter

asked in Authoring

Write DWG with US Survey Feet units

Hi,I am trying to write a DWG file with the units set to US survey feet. I can’t get it to work, its is in completely the wrong spot. I’m not entirely sure you can, but I’m not enough of and expert with FME (or US survey feet).Looking at the help file for my FME version (2023.2) it doesn’t have us survey feet as a possible unit to set the insertion units to.I have the unit set in a template file and that doesn’t help when the help says it should use this when I don’t explicitly set it.I am writing to a 2018 DWG (as that is the newest). I know for older versions of DWG you could not set US survey feetDoes anyone have any ideas? Surely US survey feet is a more common unit than the parsec for a DWGThanks

virtualcitymattEvangelist

asked in Authoring

Python in fme packages for other custom transformers?

I have a number of CustomTransformers which contain some python - this python may or may not include some third parts python dependencies. It’s not only python, they also use regular old FME transformers as well.I’ve been playing around with the package development guide and doing some testing. I can see how to import third party modules for just normal CustomTransformers. I’d really like to be able to use the package manager tools here to help with dependencies, however, it seems like from my experimenting that fme based custom transformers can not benefit from these tools.Does any one know anything or have any comments on this?

qubbiewuContributor

asked in Authoring

How to Upgrade the Version of FlexNet License Server

Hi, We are deploying FME Desktop 2022.2 in our server (it’s a virtual machine). The security team had done a security scan and expected us to upgrade the FlexNet Publisher to version 11.19.6.0 or later. However, the FlexNet installer downloaded from this link (https://fme.safe.com/downloads/) is Build 11.19.2. And it looks like bonding with FME Desktop so that we cannot upgrade FlexNet Publisher individually. How can I upgrade the version of FlexNet to version 11.19.6.0 or later? Thanks in advance. Best Regards,Qubbie

jp12212Contributor

asked in Authoring

Two dynamic surfaces find volume cut fill calculation

Hi, I was hoping to create a workbench that has a base surface and a target surface and finds the volume between the two, is there any way to do that with the below transformer ie. make the base a surface with elevation differentials?Any suggestions appreciated!Thank you.

sammySupporter

asked in Authoring

Traditional Versioning & GlobalIDs with Esri ArcGIS Portal Feature Service Writer

I know in the Esri ArcGIS Portal Feature Service writer there are parameters to control writing out with branch versioning.Is there similar functionality for traditional versioning?If yes, is there a way to have traditional versioning and preserve Global IDs using the Esri ArcGIS Portal Feature Service writer?

fme_can_do_itSupporter

asked in Authoring

To and From attributes in Line Feature

Hi, I'm trying to populate the "To" and "From" attributes in the Line feature. I have points snapped to the line feature, causing the line to split at the point. I need to fill out the "To" and "From" attributes. I tried a certain approach, but it didn't work:I buffered the point feature and used LineOnAreaOverlayer, and then the Coordinate extractor to find the start and end points of the line.If there is any other way I can use to accomplish this task, please advise.Thanks!

antheatungContributor

asked in Authoring

ArcGIS Feature Service Reader - how to auto renew token in workbench

Hello, Using FME Workbench 2022.2 and am able to connect to ArcGIS Feature Service (10.9.1) via the reader with a supplied token (manually). Is there a way in FME workbench to automatically regenerates the ArcGIS token everytime the workbench is run? ThanksAnthea

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?

armando_amadorContributor

asked in Authoring

Building Areas bounding endpoint vertex from lines

Hi all,I have a set of input street lines with certain attribute (POSTAL CODES), and I would like to create area polygons from unique values of such postal code attribute. Street Lines with postal code attributeI have utilized AreaBuilder for such purposes and this is an example of the output: Inner polygons created by AreaBuilderThis is the params I have for such transformation:What I would like to have as an output is the area covered by all the street lines with unique postal codes, something more like this: Desirable Polygon from street linesIs there any other param customization I have missed or something else to do about? Regards.

helmoetzContributor

asked in Authoring

Generic reading GML on a web yields http 404

Hello, I am trying to read data of different formats, controlled by a resource list. I isolate web services with a separate WFS FeatureReader, I do not have database resources and for the other resources I use a Generic FeatureReader, with the REAL_FORMAT parameter set to:<Guess format name from extension>Some resources include gml files on a web location (URL). The Generic FeatureReader usually reads them correctly, with one exception that gives an http 404 error (Not Found). I can avoid the error by choosing OGC GML (Geography Markup Language) for the REAL_FORMAT parameter. But I cannot control this from my resource list, only with a published parameter. I have tried adding an OGC GML resource reader, but this does not help. The Guess format parameter apparently does not make the right choice.Does anyone have an idea how to solve this, without adding a tester with a separate FeatureReader or using a WorkspaceRunner?I'm using FME Form 2022.2.4 (Win)Below an extract of the worksp

bhkContributor

asked in Authoring

How to Call a SystemCaller based on Selected User Parameters

I have a script that is supposed to run some .bat files base on calling defined SystemCallers. I have 3 System caller as each for DEV, HUB, and PROD environments. and I want to control which to run with User Parameters as belowCan you please let me know how I can control which SystemCaller to run based on user selection (For example: if user select the DEV then only the SystemCaller-DEV)

lifalin2016Contributor

asked in Authoring

Hacking schema features for dynamic output ?

Hi list.I'm tasked with importing a lot of feature sets, each with its own set of fields/attributes. So I'm using dynamic output mode, utilizing the schema features read.Unfortunately the request is to add a "job ID", so I tried to append an entry to the attribute list of the schema features, but suddenly the proces fails, not recognizing the schema features anymore. And this without changing anything in the data features flow nor the writer.An example of the error message is:Microsoft SQL Server Spatial Writer: A feature has arrived with 'fme_feature_type' of DAF_DAGI.afstemningsomraade_908308, but the feature type is not recognized. Halting translationMy writer setup is shown in the attached image. Why does the writer suddenly confuse the fme_feature_type with the requested table name ?Or is the error message false/misleading ?The "fme_feature_type" of the data features are the exact same, I just manipulated the schema features in a parallel "stream".Any insights are appreciated.Chee

1
2
3
4
5
6
7
...
120

Page 4 / 120

Badge winners

matt.stullhas earned the badge Teacher (Grey)
matt.stullhas earned the badge Welcome Back
baunrauhas earned the badge Spanish Speaker
baunrauhas earned the badge English Speaker
User16432242553744913124has earned the badge Welcome Back

Show all badges

29,835: Posts

Powered by Gainsight

Terms & Conditions Cookie settings

Sign up

Already have an account? Login

An FME Account is required to contribute

Login

Login to the community

An FME Account is required to contribute

Login

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.

OK

This file cannot be downloaded

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

OK