- - Community Resources
Ideas
Product Updates
Events
Blog

Home
Search

Unanswered questions

20232 Posts

Recently active

Most views Most replies

lukeg199

asked in Transformers

How do i use the Geodatabase_SDE Writer? (It's greyed out)

I am trying to use the Geodatabase_SDE writer to publish some content on Workbench to our Enterprise Geodatabase environment. However, when i add the writer to my workbench and browse the list, i find that the Geodatabase_SDE writer is greyed out and there is a popup that indicates i do not have sufficient licensing. For reference i have an ArcGIS Advance License that i use on the daily, and both FME and ArcGIS are using the same License Server. The message doesn't specify if i am missing the ArcGIS or FME licensing to use this writer. Any help is appreciated so that i can move in the direction of progress. *I am not our ESRI software Admin, but want to make sure that when i reach out i don't slap myself on the forehead because it was something i missed.

763

1 year ago

scarterContributor

asked in Transformers

Detecting and creating new polygons where parts of A do not overlap parts of B

Hello Forum. I have two polygon datasets (see attached image). I'd like to create a third polygon dataset showing me the sections of A that do not overlap with B. So, it would create me the polygons as highlighted in C in attached image. I could do this via a few steps in a desktop GIS but I need to include it as part of a larger automated data flow in FME Desktop (Form). Thanks,

1 year ago

mathikuContributor

asked in Transformers

Calculation of mean

I have authored a workspace that creates bills for a lot of customers. The item price on the bill has to be returned with 2 decimals, so I take the mean of all the item prices and ceil the number to 2 decimals. Because of an occasional outlier I can't rely on normal rounding function.In the case below I have 1.173 measurements with an item price of 0,43. The min and max is 0,43 and the range is 0. But the mean value is != 0,43. And since I have to use the ceil function the price changes to 0,44. I understand this must be caused by the internal handling of 32 to 64 bit conversion, but in this case a seemingly very simple operations doesn't work. Why can't I rely on the mean calculation?What can I do to rely on it in the future?

MDB_ADO update reader - An error occurred while updating the reader

Hi All,I'm trying to update MDB_ADO reader in existing workspace - it's new data delivery with the same structure as the previous one. I'm getting "An error occurred while updating the reader". I tried also open some random tables in blank workspace, and I was able to do it, but after ran workspace I got "Error running translation" or FME has been closed "automatically".At first I tried to do it in FME 2022.1.1.0 (64 bit), MS Office is 64-bit as well.Then I installed the newest version of FME 2022.2.5.0 - at first everything worked fine - I updated mdb reader and I was able to run the whole workspace. When I closed FME and opened it again I wasn't able to update reader or open any other random tables in blank workspace - so same errors like in older FME version.I tried clean all temp files, I created new temp folder, I tried to repair mdb via "Compact and Repair function in AccessDB. After all of these changes I was able again to work

242

1 year ago

redgeographicsCelebrity

asked in Architecture

Is FME23 compatible with Windows Server 2012?

This article only goes up to FME 2022, which did support Windows Server 2012. Is that still the case for FME23?

121

1 year ago

lfergContributor

asked in General

I have a workbench which has the GoogleDrive Connector in it which downloaded files to a local folder for me however it has stopped working and I get an Authorisation Error 400. When I go to authenticate my web service I get the attached message

and error message below. Not sure where to from here. It was working but I am a total novice at web connection stuff. 2023-06-01 15:11:03| 0.9| 0.0|WARN |Request to update access token failed. HTTP Error: HTTP/1.1 400 Bad Request2023-06-01 15:11:03| 0.9| 0.0|ERROR |Python Exception <FMEWSException>: Type: 3, Number: 1, Message: Failed to get authorization header.2023-06-01 15:11:03| 0.9| 0.0|ERROR |Traceback (most recent call last): File "fmegeneral\\plugins.py", line 500, in input File "webserviceconnector\\fmewebfs.py", line 1096, in receive_feature File "googledrive\\gdrivefs.py", line 569, in handle_operation File "webserviceconnector\\fmewebfs.py", line 699, in handle_operation File "webserviceconnector\\fmewebfs.py", line 856, in handle_download File "googledrive\\gdrivefs.py", line 466, in get_item_info File "googledrive\\gdrivefs.py", line 241, in get_file_metadata File "C:\\Program Files (x86)\

Reading/writing from Saleforce

I would like to be able to use FME to bulk upload data to salesforce. We currently manually upload csv files with awareness that there is a limit of 50,000 rows per file (salesforce import wizard). I have seen it should be possible to automate this using the salesforce reader/writer. I have the API credentials for salesforce and I can see all the table objects available in FME. The issue is that the object we are trying to write to appears to have different fields than expected when read (these look to be metadata fields) - see image. When we run the process to manually import using the wizard the attributes are those in the csv uploaded (see image). Both of these tables are the custom table 'property(_c)', the saleforce URL indicates that this is the case. Do you need to change permissions on the object salesforce side or do anything specific with the reader/writer in FME to get this working? Kind regards, Antony

11316

1 year ago

clives_online

asked in Transformers

Convert 22770 (metric) to Lat/Long

Greetings, I have tried several formulae, but no convert metric to DD??Any suggestions appreciated.@Value(_inside_x)(@CoordSys(EPSG:4326)) @Value(_inside_x(@CoordSys(EPSG:4326))ThanksClive

1 year ago

jon_y

asked in Transformers

Excel output with a cell that contains a picklist.

I would like to output an excel template with one of the columns having cells containing values from a pick list. From my understanding I don't think FME is able to output the picklist, but a possible solution is to have the pick list already defined in the excel template. However, even if I have the cell defined, I do not know how to have it replicated for each row that is outputted from the FME template. Do I have to just fill the entire column with the picklist and than delete the extra rows after the fme template is run or is there a more elegant solution. Thanks

121

1 year ago

mzuer

asked in Transformers

Set user parameters from Excel file / 'Read Form Control as Cell Value' parameter ?

Dear All, I would like to read an excel ''configuration input file'' which contains the values that will be used to set the ''User parameters'' (2 columns table : first column giving the variable name, second column the value that the variable should take). Is it possible to that ? Can the ExcelReader parameter ''Read Form Control as Cell Value'' be used for this purpose ? What does this parameter ? I found no information about it in the help and tried a lot of things without success... Any help would be welcome !

281

1 year ago

spidermanContributor

asked in General

How to convert from Esri Arcsde into File geodatabase ?

Hello ,i need to convert from EsrI Database Arcsde Geodb to write into Geodatabase (File Geodb Open Api)Feature reader :to read all feature classes in Arcsde feature write :file geodatabase my target to write specific feature classes that belongs to one Feature dataset from Esri Arcsde into file geodatabase i need exactly sample of feature dataset to test in ArcGis pro . FME 2021 Thanks in advance

283

1 year ago

inkaduiker

asked in Transformers

How to calculate median or center of gravity from points in WGW84?

I have points in WGS84, collected with a gps on one single point (static). I would like to determine the median of these points. Or the one point with the less deviation.Thank you for your comment.

10011

1 year ago

kiptas

asked in Transformers

We have recently implemented a new version of the ESRI ArcGIS platform and are running the old geodatabase with the new one as well. Is there any functionality in FME to sync the old geodatabase with the new one. As of right now the two are out sync.

How to pass only the value of a manual key from a webbook or manual trigger automation to the next action?

When I create a manual trigger automation and pass in a single key value pair as a manual Key, the complete json for the key seems to be pass to the next action in the automation. The next action is a submit job action that takes a single published parameter (VERSION). Is there a way to bind just the value from the manual key to a published parameter in the next action (Run a workspace action)? I created a manual trigger with a manual key called MANUAL_KEY. In subsequent actions, I apply the MANUAL_KEY from the trigger to a parameter in the action using the pattern “Manual.MANUAL_KEY” the resulting value is complete JSON and includes KEY name and value. This results in the full json passed in as the published parameter in the workbench action : { "MANUAL_KEY": "Example value"} Is it possible to bind only the value? Something like “Manual.MANUAL_VALUE.Value” ?? Which would pass only “Example value” into the published parameter of the next action? I have tried

101

1 year ago

dor1411993Contributor

asked in Transformers

AutoCAD -attributes and block issues

Hello every one,I have a cad file with lines and block on to on them.The block have some attributes, and one of the is Length.for some reason, there are a lot of blocks that instead of having the length properly, it have #### marks.I tried to fixit of course with FME, I managed to recover the length from the line which the block is belonging to, but- when i'm writing it to dwg, it is get mess again!I tried to use Attribute Output in the writer definition, 'Inserts' or 'Limited' got the right length number, but they destroy a lot of other definitions in the cad file.can someone please help me?I'm attaching here small sample..Thanks!

1726

1 year ago

tammydovey

asked in Transformers

CAD to GIS Spatial Join: One to One , is it possible?

Hi, I am trying to asses assets that are in CAD and not in GIS. Using the Spatial filter or the SpatialRelator i am getting results of one to many. I.e. the results are relating one candidate to many filters. What transformer can i use that only spatial joins one candidate to only one filter? Please help!

1 year ago

fruby

asked in General

separately missing, null and empty values

Hi, I want to separately identify missing, null and empty values in a data array.I tried with the TestFilter, the sorting does not seem to be done correctly.Because, my file contains null and missing values but here all data exits in one place. Do you have a solution ? Thanking you in advance

131

1 year ago

gmu

asked in Transformers

How to configure Proxy with FTPCaller on sftp

Hi, I'm encountering issues to connect to an sFTP server through a proxy.With my ftp client I'm able to connect with the following configuration.But I don't know how to configure my FME Desktop environnment and FTPCaller transformer to access to it.Here is how I tested it.Configure proxy settings on Windows Configure FME Desktop environnementConfigure FTP CallerI have the following error See log file attached.I alswo tried with pythonCaller but I didn't yet figure it out. Any tips to solve my case ?Thank you,

Creating a Network Using 'From' and 'To' Columns with Specific Conditions

Dear Safers,I am trying to create this network using the 'From' and 'To' columns.So, the number in 'From' is connected to 'To', and then find this 'To' number in 'From' and find it's corresponding 'To', and again find the second 'To' in next 'From' and get it's corresponding value in 'To'.The catch is, the value in 'To' has to be greater than 'From'.I can think of a go to solution in SQL, but can't think of something using transformers.Thank you for the support.

1 year ago

jkh

asked in General

How to assign values of a row to attribute name

Hi everyone, I am new to FME, please help me with the following issue. I am reading an excel file using FME. The name of the attributes (columns) is not right, and its in row 5 of the file. I was wondering how I can assign values in that row (5) as attribute names. I know that I can use a tool like AttributeManager to rename the attributes, but its too many attributes/columns (>100). I need a way that could assign the values from row to attribute name.Thanks

913

1 year ago

arsiContributor

asked in General

PDF2D (PDFWriter): Unable to successfully read the font

Using FME Desktop 2022: When attempting to write to pdf the following error occurs 'PDFWriter: Unable to successfully read the font from 'C:\\Windows\\Fonts/._TravelingTypewriter.ttf'. This font will not be available. Internal error code was '2'' FME has reading rights to this directory and the file exists. I haven't selected this particular font in the preceding PDFStyler-transformer. Any ideas why this occurs?

317

1 year ago

abdullah83Contributor

asked in General

CityJson cant read in Qgis

Hi i convert IFC to cityjson using FME. in FME everythink is ok like below: But when i open this cityjson file using Qgis, iit cant work like below: anybody can help me?tqvm

312

1 year ago

babin_t

asked in Transformers

CityGML to Cesium, Conversion Issue. While converting ananymously showing ERROR RUNNING TRANSLATION, no other explanation or error. Please look into it and give suggestion.

Please refer snapshot, creating texture Atlas using CITYGML data FME 2022.1.2 version

1 year ago

swachContributor

asked in Data

Connecting to Smallworld 5 with FME 2022

I am trying to connect to my Smallworld 5 database with FME 2022. I can connect successfully with 2021. I have FME Smallworld edition and have copied the needed connection files to the installation folder. What have changed between the two versions? It says 'This FME edition does not recognize the 'SWORLDSWAF' reader.

523

1 year ago

vn1Contributor

asked in Automation

Automation 'Run a Workspace' Retry Default Settings

Is there a place from the web interface or configuration files where default values can be modified regarding Automated Retries? Number of attempts Wait between attempts Backoff multiplier Randomization factor Maximum wait between attempts

1 year ago

Page 116 / 810

Badge winners

alena_thas earned the badge English Speaker
alena_thas earned the badge Welcome Back
khadijahbhas earned the badge Webinar Watcher (Grey)
ivanbakkerhas earned the badge FME Form Basic Training
jd.bakerhas earned the badge Welcome Back

Show all badges

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