- - Community Resources
Ideas
Product Updates
Events
Blog

Home
Search

Unanswered questions

20235 Posts

Recently active

Most views Most replies

laurentbruning

asked in Transformers

Why do my Excel writers suddenly skip the first 4 colums in the Excel sheet?

I haven't changed anything to these Excel writers, but after having added some transformers to the workspace they suddenly all start writing to column E instead of A. Even after having disabled the new transformers they still do that. I can't find any setting explaining this (I haven't set a start column, for instance).

1 year ago

james_c_452Supporter

asked in Transformers

Create a center line from two original lines and resample all three to have matching (perpendicular) vertices

Hi, I'm wondering if something is possible at all in FME. I have two parallel 3D lines on a railroad. A "left" line and a "right' line. I want to create a new line at the center of these two lines (the railroad center)Once this is done I would like to resample all three lines together so that they all have vertexes that are perpendicular to the center line. This is exactly what the Topodot tool "center line extraction" does if you adjust element vertices. I was wondering if it is possible to do in FME so I can automate it. I don't have any python skills to make something The result would look like this Any advice would be appreciatedThanks

416

1 year ago

bhkContributor

asked in General

Overwrite Existing Geodatabase When Using ArcGIS SDE Geodatabase and FME Writter

When working with a File Geodatabase Writer, FME gives us an option(FME Parameter) to "Overwrite Existing Geodatabase" or not! Can someone Please let me know if there is such a option when dealing with a SDE Geodatabase?So how we can prevent duplicating (appending data again into existing dataset) when we want to load data into? Thanks

881

1 year ago

bhkContributor

asked in Authoring

How to Author A User Parameter to Select Which Writer to be used when having same Data source and many end point

I am writing a WS which is reading an Excel sheet for two Writers which are supposed to write in two different environments (DEV and TEST) As you can see since the source data is same I am using only one stream workflow instead of duplicating the transformers for each writer (DEV and TEST) I have created a User Parameter like this Now, can someone please let me know where and how should I assign this into the workflow to select the endpoint (Which Writer to be used)? Thanks

122

1 year ago

arthyContributor

asked in Data

Python Exception <KeyError>: 'esriGeometryMultiPatch' when writing to Arcgis Portal

Hello I would like to truncate and write data to a feature layer on arcgis portal.I'm getting the following error and I don't know what's wrong with the workbench.

172

1 year ago

hasant1973Contributor

asked in Transformers

No error message when having a typo in XSD driven XML Writer.

When working with XSD Driven XML Writer I noticed that I don't get an error message when I have a typo in the feature_type name or attribute name. It simply does not add it to the output. And this makes it very difficult to find bugs and problems. Also the validation of the XML ends with a message that "something went wrong". But no details where and what. Is it possible to list all items that could not be found in the XSD?Maybe some setting in the FME Desktop general settings? Thanks.

1 year ago

freddy17Contributor

asked in Flow Hosted

Low code front-end options for displaying FME Cloud Output, focus on graphs and 3D model viewers

Hello everyone, I'm looking for recommendations for a low-code front-end solution to display data transformations from the FME Cloud. The front-end needs to be able to display graphs, as well as linked GLTF and JSON files, with the best-case scenario being the ability to interact with 3D models. I am aware of the option to use Esri, but I am looking for other, more independent and cost-effective technologies. Can anyone recommend any low-code or no-code front-end solutions that would be a good fit for this use case? The FME Server Apps are great and simple to get the user to upload data. But at the moment I have an Html that returns information, with javascript graphs. But this is quite a static approach and I would like to be able to send the data to a databank and then just display the data for the user and let them make simple alterations. I know my around FME, but have very little or no experience with front-end development. I am just curious if there are solutions, without do

322

1 year ago

hendriksdaanContributor

asked in Data

What happens between FME PostgreSql writer and postgreSql running a query?

Hi, In my workspace I work with coordinates in different projections. I store them as numeric values. E.G. Geolat: 52.0324234. I want to write this to a PostgreSql database, which has the same type as is required for the value. Seems all good. But. When I start writing I get an error where it complaining about the input syntax is not of type 'numeric'. I see a query inside the log, Where it changes the value 5.2023617 from Longitude to " E'5.2023617' ". Which is a string. Which I dont require. Does anybody know where to look at or how to solve it?

125

1 year ago

jhawksContributor

asked in General

Web Stats / number of logins?

Is there a way thru the admin interface to get number of logins per users? or do we need to check the Tomcat logs?

1 year ago

mauliem

asked in General

please guide how to convert pdf file to excel

The information in the pdf file has the same columns as the attached excel file

1163

1 year ago

townestContributor

asked in Transformers

Table View: Failed to read rows due to 'No query Unable to fetch row'

I recently received the subject error. The error occurs when inspecting any downstream table of an AutoCAD dwg reader. The workspace appears to run successfully, then while scrolling down the transformer inspection table (in visual preview), the inspector suddenly throws an error and breaks out of the visual inspector table into the translation log showing the subject error. Clicking back on the table, and no records are shown past 100 (there are actually 1000s of records). Any ideas about what is going on? Thank you,TylerFME Workbench 2022.1

541

1 year ago

mferwerda1111Participant

asked in Data

SharePointOnlineConnector Type: 3, Number: 1, Message: Failed to get authorization header.

Any thoughts on why this Transformer would work, and then just stop working with this error when trying to browse Sites in the transformer ? Nothing has changed on eh FME Side, and I do not think anything has changed on the SharePoint side

Hello All , we have the FME scripts to translate RVT to OBJ files . while checking the OBJ files we are able to see the unwanted hidden feature , like scope box and etc .

We have remove the object from Categories à "Scope Boxes" OR "Levels" OR "Grids" from (Categories).Need to search for the Hiding Temporary Items>> Search for: "temp" from Attributes: Workset, Comments, Mark.please let us know how can we remove the above feature , thanks for your support .

1 year ago

tforward

asked in Authoring

How to pass a user parameter to a custom transformer and used in a pythonCaller?

How does one pass a user parameter to a pythonCaller that's inside a customTransformerimport fmeimport fmeobjects def processFeature(feature): p = FME_MacroValues['SomeUserParameter'] print p I read here "If you put your pythonCaller inside a custom transformer, the parameter name changes to {customTransformerName}_SomeUserParameter. "I tried then doing this below but still does not work.import fme import fmeobjects def processFeature(feature): p = FME_MacroValues['{customTransformerName}_SomeUserParameter'] print p What am I doing wrong?

2264

1 year ago

koenContributor

asked in Data

Access parameter from PythonCaller in Custom Transformer

I'm trying to create a custom transformer 'FeatureCountLogger' which logs the number of features inputted into this transformer. The custom transformer contains a PythonCaller with the following code: import fmeobjects class FeatureProcessor(object): def __init__(self): self.featureList = [] def input(self,feature): self.featureList.append(feature) def close(self): logger = open(FME_MacroValues['Summarylog'], "a") message = FME_MacroValues['Message'] + str(len(self.featureList)) + '\\n' logger.write (message) logger.close() I want to use the logger multiple times, so I created a published parameter 'Message' in the custom transformer, so I can submit the text logged to each instance of the transformer. When I'm running this I get the following error: Python Exception <KeyError>: 'Message' It seems like the PythonCaller can't a

368

1 year ago

tim.rastall1Contributor

asked in Flow Hosted

WorkspaceRunner fails in cloud

When running a workspace runner in FME cloud, it fails silently with the following error. "FME license system failure: FME is not licensed for this machine. Contact your Distributor." How do you use a workspace runner in cloud?

FTP CALLER How to use the transformer to list all .zip on sftp and download

@Andrew.griffin@gmail.com

27812

1 year ago

boubcherContributor

asked in General

incident detector from steaming data

Hello Guys need your support with this case we are getting car position from streaming data 30 thousand points every 30 seconds, we use time windower to get the position of each car every 5 min, then we use a filter to check if this car entered the delivery zone,what we are looking for is to store the event when the car gets in and when it gets out and we have to store only one record for each event this event will be stored in the database as follow Crad_id start_time End_time StatusTK256 14:20 14:35 within when we store the event in the database the first time there will be no end time since the car is still within the delivery zone as soon as it gets out we will update the end time Any Suggestions we want to achieve something similar to this connector Thanks

115

1 year ago

arthyContributor

asked in Transformers

How can I publish images to arcgis server image using FME?

How can I publish images to arcgis server image using FME? I'm newbie on arcgis server image. Thanks

905

1 year ago

edstrat

asked in Transformers

How to transform change detector results into the same row.

Hi,I am having an issue where I want to remove duplicate values from the results of the change detector and merge them all in to a single row to remove duplicate entries. I have provided an example below.If you need more information just ask. Thanks.

1 year ago

miladahmad

asked in Data

How to convert from SQL Server geometry BLOB to shapefile?

Hello,I'm trying to create geometry from Sql Server geometry Blob to shapefile. I'm trying geometryextractor but it is not working.(I can not create geometry in Sql server; I can only read data).Thanks for help

23919

1 year ago

jugoslaviaaSupporter

asked in Transformers

Remove newline space

Hi all, In the attribute of my data, there is sometimes newlines and I want to trim them. I am using the AttributeTrimmer however it is not working. The data looks like this: {33}SCHOOL, BUS ONLY 8-10AM 12-4PM EXC SAT-SUN-HOL SEPT THRU JUNE,I want to trim it like this: {33}SCHOOL, BUS ONLY 8-10AM 12-4PM EXC SAT-SUN-HOL SEPT THRU JUNE, Is my setting not correct? Best

5306

1 year ago

viviancfhungContributor

asked in General

Translate from shp to gpkg

I want to translate a dataset from shp to gpkgThere is a id field in attribute table in shp file. I added the transformer "attributeRenamer" to rename "id" to "shp_id"It is success on 2022.0.2 versionWe can't see shp_id field in gpkg and the value in id field is keptBut in 2022.2.3 vesrionIt throw the error as 627 2023-2-28 13:03:03 | OGCGEOPACKAGE writer: OGCGEOPACKAGE writer: For feature type 'd_y_n40', primary key attribute 'id' has unsupported type 'mediumint'. Primary key must have type 'int,PrimaryKey' Is any way can I fix it?Thanks

624

1 year ago

mariakaContributor

asked in Transformers

Raster RGBA to RGB with NoData

Hi y'all,I don't get it: I have a raster file with 3 bands: RED8, GREEN8, BLUE8, ALPHA8. The alpha band is either 0 or 255. There is no gradient. I need to hava a RGB24 raster with NoData, where Alpha is/was 0. The RasterInterpretationCoercer with "Apply the alpha band" will return these areas white. 🤷🏼‍♀️I already tried other solutions, but couldn't get what I wand.Can anybody help?

townestContributor

Greetings,I am getting thousands of warnings, and would like to understand more about them. Let's take these two for example and go from there. Can someone help explain what these warnings are and how to correct them?Also, are these warning slowing the run time down? The run is quite slow, and it's unclear to me exactly why.Thank you,TylerFME Workbench 2022.1

273

1 year ago

Page 139 / 810

Badge winners

ali.hojjathas earned the badge Welcome Back
hamadshammakh97has earned the badge English Speaker
hamadshammakh97has earned the badge Arabic Speaker
mishgun1476has earned the badge Welcome Back
samvernonhas earned the badge Student (Grey)

Show all badges

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