Creating and organizing workspaces. How to use Workbench.
Recently active
1st file example:Β Β 2nd file example:dogΒ Β Β Β Β Β Β Β Β Β Β dogcatΒ Β Β Β Β Β Β Β Β Β Β Β birdbirdΒ Β Β Β Β Β Β Β Β Β Β cowhorseΒ cowCompare and write whatβs missing from file 2 to a 3rd file.Β Β
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.
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.
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.
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
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:Β
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
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?
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
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?
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.Β Β
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?
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!
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
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.
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)
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
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?
I'm using a path in an Esri geodatabase writer that contains a space in the path name - \\\\xxxxx\\gis\\SheriffsOffice\\Camera Information\\SO_Camera_Info.gdb. The workbench completes successfully (2019.1). When the workbench is published to FME Server and run, the path is truncated at the space form '\\\\xxxxx\\gis\\SheriffsOffice\\Camera.gdb' Is there a way to fix this?
Hello,I am new to FME but have some overall experience with coding and I know there has to be a simple way to solve the issue of automatically creating the file name based on an attribute. I am trying to create an excel file with multiple sheets andΒ I have tried using the fan out parameter (along with anything else I can find online) but its been making multiple files or crashing,Β instead of just one file with multiple sheets. I have been researching this issue for far too long with absolutely no head way so any help will be greatly appreciated. I will also need to create a kmz/kml file with the same namingΒ parameters if that changes anything.Thank you in advance,Sam
Hi All,Am attempting to read a feature service (actually several) that are open to the public on ArcGIS Online (AGOL).Β I have created a new web connection using an existing user in AGOL for our organization (getting a token, client id, etc).The data that I am attempting to read is the ACS Census data (several different feature services).Β When entering the copied URL from the AGOL website, and then attempting to select a layer from the feature service, I get the following errors.Β I see that that it is looking in the content of my user, but this data is open to all.Β This used to work for me before the changes in the web connections.Β Where do I look from here?Β I have tried this in FME 2022 and Flow 2024.Thanks,LorindaCreating reader for format: Esri ArcGIS Online (AGOL) Feature ServiceTrying to find a PYTHON plugin for reader named `ARCGISONLINEFEATURES'Using Python interpreter from `C:\Program Files\FME Flow\fmepython312\python312.dll' with PYTHONHOME `C:\Program Files\FME Flow\fme
βHello, Would anyone know if there is a way to use the Search Envelope by updating from a choice parameter? For example, I have these certain polygons that delimit the area I want to analyze:Every time I want to analyze an area I have to change the values ββof the X,Y parameter (min and max):Β Β To solve the problem, I created a choice that shows the area number on the Display but the values ββread are the bound coordinates.Β And I created hidden parameters called Xmin, Xmax, Ymin, Ymax, These parameters look at this choice in the following way: @GetWord($(Choice),0)Attributes read from parameters with the expression aboveBut even if the combination is a number, FME does not accept using this value in the search envelope, as it tries to read the entire written parameter.Β Below is the error log:Β Invalid search envelope specified: GEOTIFF_1_SEARCH_ENVELOPE keyword must be followed by four numeric values (minX minY maxX maxY). Got '@GetWord(-42 -20 -40.5 -19 454,0) @GetWord(-42 -20 -40.5 -19
Curious if I could pick your brains on how to achieve the workflow:I am connecting to an asset via API as well as another separate GIS Feature Class in an EGDB.Β The workflow will start with a user editing the GIS Feature Class. When a user updates or creates a new record in the GRI_TEST1 Feature Class, I am pulling it into the Change Detector, and wanting to write to the API table only if the assetkey does not exist in the API table. The assetkey in the GIS FC = unitid in the API Table, as the field has a different name than the same column has in the GRI_TEST1 Feature class.Would I be going the right route here in using the PythonCaller to achieve this? Right now my writer is writing to a xlsx document and not the API table yet so I could test out the logic.Β # Import necessary modulesfrom fmeobjects import *# Function to check if asset keyΒ exists in feature classdef assetkey exists(assetkey, feature_class):Β Β # Implement the logic to query the GIS feature classΒ Β # Assume 'feature_c
Hello, I am working on a project which will fetch information and save to local machine, then I use xsd-driven-xml reader to read in the files to parse data down streams.Β I noticed that reader activate before HTTPCaller task and caused the httpcaller failed to create file in the designated location. How to specify the reader to activate only if my HTTPCaller successful?Β I have already have the tester set up and will be able to tell either failed or success, but xsd-driven-xml reader did not have condition parameter setting or anything for me to make sure it activate after tester passed.Β I can separate this into two workspace, or create custermized transformer to encapsulate some condition tester and xml reader together, but thought there might be better way and would like to ask for help here.Β Any information is appreciated.Β
Hi !I donβt know where to post that so sorry if itβs the wrong placeΒ πWhen I use the button βalignment Middleβ the alignment is vertical andΒ when I use the button βalignment centerβ the alignment is horizontal. The action seems to be the opposite of the picture on the button.Do you have the same thing? On FME 2018 is the reverse and it look more logical.FME version : 2024.0.1.0Thanks !