Home
Search

Unanswered questions

19740 Posts

Recently active

Most views Most replies

fmelizardContributor

asked in FME Hub Alerts

Getting Started with FME Form: Tabular [Microsoft Excel to Microsoft Excel]

FME Hub user lizatsafe just uploaded a new template to the FME Hub.Purpose & ObjectivesThis workspace demonstrates how to read data from a Microsoft Excel workbook containing employee information, filter for active employees using a transformer, and write the filtered data to a new worksheet in the same workbook.Key TransformersTester: Used to filter the data based on conditional statementsData Source(s) - Reader Feature TypeEmployeeRecord.xlsx Microsoft Excel - Employees worksheetData Output - Writer Feature TypeEmployeeRecord.xlsx Microsoft Excel - Newly created Active worksheetParameters:Drop Existing Sheet set to Yes (the sheet will be dropped and recreated each time the workspace is run)CustomizationTo customize this workspace, it is recommended to build the workspace from scratch as your dataset will have different attributes and schema (structure). Instructions to build this workspace: Getting Started with FME Form: Working with Table/Tabular Data. Additional ResourcesMicros

hawaiialexContributor

Writing one field from GIS Feature Class to API Table PUT Request

Hi everyone,Curious if I could pick your brain on the workflow below.I would like to just write the asset_id field values from the GIS feature class into the corresponding assetID field in the API table. I’d want to write the asset_id from the GIS FC to the assetID field in the API table only if the assetID doesn’t exist in the API table. They have different field names.Curious where I would place the HttpCaller transformer with the PUT request in the workspace.The GIS EGDB reader would be at the start of the workspace exposing the relevant fields. Once I rename the asset_id field from the GIS feature class to match that of assetID for the API table, what would I do? Could I hook up the output from an AttributeManager directly to an HTTPCaller without a Creator?

solyContributor

how to find all possible paths in network ?

Hello , i have points and lines are topology connect together .i would like to find all paths possible in the network .i have used shortest path finder but it finds only the shortest path ,so i am looking for other solution to find all paths in the network between all points.i appreciate any help .Thanks in advance .FME 2021

take_vfParticipant

Python Exception TypeError: init() takes at most 2 arguments (4 given) Portal Feature Service writer

After upgrading FME Server from 2022 to 2023.1 my existing workspaces have started failing due to the following error:Python Exception <TypeError>: init() takes at most 2 arguments (4 given)ARCGISPORTALFEATURES writer: An error has occurred. Check the logfile above for detailsThe same workspace runs correctly locally on FME Desktop (both 2022 and 2023) and I have tested reuploading the WS from FME Desktop 2023 to the Server but without success.I tried creating an entirely new workspace in FME 2023 that should just write a single object using the Portal Feature Service Writer. It failed with the same error on both Desktop and Server when writing to a referenced feature service but was successful with a hosted feature service.In summary:Original workspace (writing to referenced feature service with Portal writer) FME 2022 FME 2023 Desktop Yes Yes Server Yes No New workspace in FME 2023 with Portal writer Referenced feature service Hosted feature service Deskt

alsherrenContributor

asked in Integration

Salesforce connected web app - web service configuration issue

Hi,I am trying to configure a web service to use the Salesforce Connector. When trying to test the connection, I keep getting error:error=redirect_uri_mismatch&error_description=redirect_uri%20must%20match%20configuration I believe this relates to the callback URI syntax, but I don’t know what it should be.. any ideas?

raymondbrunnerContributor

asked in Community Q+A

Where can one find the Release Notes for each Build?

I have visited the https://fme.safe.com/downloads/ page and found some items of interest in the “Change log” - but would like to know a little more than the very short description provided.The product updates page https://community.safe.com/product-updates offers Feature Highlights for certain builds, but some of the items I want to know more about are not discussed.Is there a location on the website containing release notes, or slightly longer descriptions of the “Adds”, “Bugs”, and “Updates” mentioned in the Change log?~Ray

dellerbeckContributor

Data Inspector crashes with Python Caller

I am using a Python Caller to create new features based on counts from a REST Endpoint. I want to verify the output in Data Inspector, everything acts normally until I click on the record in the table (there is not geometry)When I click on the record, the Data Inspector immediately hangs then crashes and closes.I am using FME(R) 2023.1.0.0 (20230825 - Build 23619 - WIN64)

galigisEnthusiast

asked in Transformers

Run ArcPy RepairGeometry through PythonCaller

Hi All,I’m testing a simple workbench to fix the geometry of a SHP thought ArcPy RepairGeometry in FME PythonCaller. Here’s is the simple code to run in FME but for reason fails:FME_MacroValues['SourceDataset_SHAPEFILE']The idea is running the script before writing the data into a GDB,Any idea how to make it to work?Thanks :)

ejrcarsonObserver

asked in Automation

Pyhton Caller not able to read enterprise feature services

Hi, I’m new to FME, looking to setup a python caller to manipulate some feature services on our Enterprise portal.Is it possible to call feature services from within a python caller inside a workspace hosted by FME Flow?The script below works fine in FME Workbench and prints True, the FME Flow prints false. import fmeimport fmeobjectsimport arcpyfrom arcgis.gis import GISfrom arcgis.features import FeatureLayerdef ProcessWebhook(feature): # URL to AGOL or Portal url_gis = "https://<servername>/portal" # URL to AGOL or Portal user = "xxxx" # AGOL or Portal username pwd = "xxxx" # user password gis = GIS(url_gis, user, pwd) id = feature.getAttribute('webhook_feat_id') whereclause = 'field_3 = ' + "'" + str(id) + "'" in_feat_url = r"https://<servername>/hostedserver/rest/services/Hosted/service_3c55880fb4112b08f2af29c22e/FeatureServer/0" in_feat_fl = FeatureLayer(in_feat_url) in_feat = in_feat_fl.url

markrmunozParticipant

asked in Integration

CityWorks Web Connection

While attempting to set up a web connection to cityworks via FME/ESRI’s data interoperability externsion, the connection continues to result in “Unable to authenticate using the specified connection information”. We are on CityWorks Server 15.4.2 so the authorization token is set to be passed by query string. Any other changes or tips that we should try?

parhatboraniParticipant

asked in Community Q+A

How do I read dynamic attribute(s) from same file type but in different folder

Hi there,Can you please help me with this? Every time when a new report came in, I’d have to manually open the “FreatureReader” dialogbox and hit “Ok” (to close) so that the new attributes that are added in new report at the new folder location are emerged. Otherwise, it would just read previous attributes from the new report (in below case, up to the end of June, not the July columns). I’m just trying read an MS Access file that is stored dynamically in different folder each month.

monitotierContributor

gml to ifc probems with the transformation

GML2IFC translation/conversion warnings I created a very simple model where I added a GML reader and I want to transform it to IFC.When I run it, numbers appeared on the connectors. These numbers match with the number of features per feature type. I would assume that the transformation was made, although a couple of warnings appeared during the run of the model (see second image) Nevertheless, when I look for the transformed files, there is nothing on the folder. When I try to inspect the resulting data using the eye, a windows pops up asking for information that was set when i first set the "writers/translator" (see third image) and when I look for the data, nothing was done. I checked about these “warnings” among the FME community, and between not-updated information and broken links, there was nothing there that could help me to find out the reason or meaning or ground for this issue.I have also checked in https://support.safe.com/hc/en-us/articles/25407793929229-GML-Writing and he

How to emulate the "Create Routes" tool from ArcGIS?

I have three lines coming from CAD, I have read them and I would like to use “Create Routes”, instead I have used the measure generator. However, the measurements are wrong, and I suppose because on the way the vertices of the line were drawn (in an illogical order).By using “Create Routes” I could select the coordinate priority (lower left, lower right, upper left, upper right) to tell it to start counting from that point onwards (because the coordinate priority will be different per line). Is there a way that the same can be done in FME? Thanks!

vimva679Supporter

asked in Transformers

CLIPPER not working

It was all working properly just few days back , today clipper is just crazy. I have IFC 3D Model and Excel file with XYZ coordinates, all i trying to do is clip all those coordinates are inside / touching the boundary of 3D Model.

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

joneszeroContributor

asked in Authoring

Unstructured data, 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

asked in Automation

Automation issue - no jobs being triggered

Hi all, We upgraded from FME Server 2021.1.5 to 2022.1.1 a little while ago and since then our automations no longer seem to be triggering jobs. Each of the automation logs shows a scheduled trigger event at the correct time, but no jobs are getting queued. Manually triggering an automation also does nothing, apart from showing a green 'Automation triggered' message in the web interface and adding a successful event to the automation log. Everything else about the server seems fine. Schedules run at the time they're meant to and queue jobs up properly, and I'm able to run all of the workspaces that should be automated with no issues at all. All of the server logs I can find show no obvious errors and fmeserver.log shows no hint of any of the jobs being run due to automations. I've tried uploading a completely fresh workspace to the server and setting up a new automation. The logs show the automation being assembled and actions being linked, etc. but this is subject

galigisEnthusiast

asked in Transformers

AreaOnAreaOverlayer Bad Performance - Painful Hours to process 1,300,00 records

Hi All,I have created a workbench that includes a few AreaOnAreaOverlayer transformers. For some reason one of the AreaOnAreaOverlayer takes hours and hours to union cadastral data (1,200,000 records) with some protected areas PHI (100,000 records). I have checked the log file and the AreaOnAreaOverlayer transformer always accomplishes the following 4 steps: Performing low-level intersection at phase #1 Performing low-level intersection at phase #2 Searching for topologically significant nodes Breaking curves at topologically significant nodesI have attached the log file as .TXT for reference. For some reason the AreaOnAreaOverlayer_3 slows the process at Breaking curves at topologically significant nodes. This transformer is at the middle of the workflow which means is being fed with data that comes from other transformers. here is an screenshot of the log file:...and here another screenshot of the settings of the problematic transformer:I have also run it with the quick translator an

fmelizardContributor

asked in FME Hub Alerts

RasterInpainter

FME Hub user dmitribagh just uploaded a new transformer to the FME Hub.The transformer uses OpenCV’s inpainting functionality to fill in missing or damaged parts of a raster image. This transformer is useful for tasks such as repairing damaged images, or filling in Nodata values in aerial/satellite imagery. "Inpainting" is a term used in image processing to fill in missing or damaged parts of an image by interpolating the surrounding pixel information.Installing OpenCV Python libraryThe transformer needs OpenCV Python library installed. Use the following syntax to install the library:On Windows:<your_FME_install_path>/fme.exe python -m pip install opencv-pythonOn Mac/Linux:<your FME install path>/fme python -m pip install opencv-pythonInputThe raster image(s) to be inpainted. The transformer will try to inpaint black pixels only, that is those having the RGB value set to 0,0,0, interpolating the new values based on the surrounding pixels.The transformer works with RGB24, R

jp12212Contributor

asked in Integration

DWG to GeoJSON

Hi, Just was hoping for tips on Converting DWG to GeoJSON - is there any one who can lend an explanation I’m attempting the below and it’d be great if someone could offer a high level understanding / approach.

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?

carmijoContributor

Reading ArcGIS Online Feature Service shared with the organization - not owned by the user or shared with a group.

Using an Esri ArcGIS Online connection and the Esri ArcGIS Online (AGOL) Feature Service reader, I'm unable to read a feature service that has been shared to our organization.When looking at the select form, i’m only provided my user folder and a groups folder. The feature service i’d like to read isn’t owned by me or shared with a group. Is this as-designed or is there another way to read it? Thank you

lisaonmsnContributor

Writing SQL Server views to Excel works with database connection A fails with database connection B?

I have an .fmw that reads a series of SQL Server views then writes the returned values to a templated Excel spreadsheet and it worked while using our DEV SQL server (A). When I replace the existing database connection to verify it works on our Production SQL Server(B) the value in one cell is missing in the Excel spreadsheet. I get 0 errors, 0 warnings using (A) or (B) connection. All the remaining view results are there and correct. Verified that the SQL VIEWS exist on both servers and refreshed both just in case-same results. I can select the views via SSMS and get the correct data on (A) and (B). I tried deleting the one failed writer and re-adding it: same results.I tried deleting the reader supplying the view information and re-adding it: same results.Thoughts? Using FME Form Desktop Version 2023.1

asked in Transformers

Fill UAV Raster No Data with Texture

Hello,I have an ortho image from a drone flight and looking into filling in the square in the middle of the pond (underestimated the correlation between the area of the pond and flight altitude). Photoshop is the last resort. I looked into using aerial images from the past as a background but the pond change dramatically so it's a no go.Cheers,

bpoffetParticipant

asked in Community Q+A

Default background Map Authentication - Connection failed

When i try to “inspect feature caches” or “view sources data” it does not work and i get this error message : I am not able to use any defaut background map. When I click on “OK” then the software crash. Any suggestions ?

1
2
3
4
...
790

Page 1 / 790

Badge winners

82vnxyzhas earned the badge English Speaker
fallingdoghas earned the badge Welcome Back
gis_galhas earned the badge Integrate Spatial Data
saravananhas earned the badge English Speaker
saravananhas earned the badge Student (Grey)

Show all badges

29,355: 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

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.