Skip to main content
  • EN

General

A read-only category for lost FME Form topics. We hope to move them shortly.

  • 4,042 Posts
  • 13,932 Replies
4042 Posts
F
firsttube
asked in General
Read/Update Enterprise Geodatabase Metadata for Each Table in Database

I've created a workbench in FME Database Edition 2022.1.3 that reads the existing metadata of a feature class in an ArcGIS Enterprise Geodatabase (SQL Server), and updates certain components of the metadata based on a table in another database where the feature class name matches the "Name" field in that table. This works for one feature class in the GDB at a time. Is there a way to iterate over all feature classes in the GDB and run the workbench against each one, one at a time? I've tried adding multiple feature classes as a Single merged feature type, and as individual feature types, and it is not updating the metadata as expected. It seems to update the metadata to the same values for all feature classes. thanks

2390
F
dbryantgeo
Contributor
dbryantgeoContributor
asked in General
FME Server does not think the source file for FileCopy Writer is a file

I have a workbench that uses the FileCopy writer to move and rename an uploaded excel sheet, this works well when testing through desktop but when run via FME Server (the file is uploaded into a parameter) the following Warning is thrown and the file doesn't get moved; 2022-12-8 13:48:54 | File Copy Writer: Ignoring the destination filename 'DummyFile.xlsx' because the source dataset '""C:\\ProgramData\\Safe Software\\FME Server\\resources\\system\\temp\\upload\\Data Updates\\Geo-CustomerServices-TradeEffluentImportToSQL.fmw\\dbryant\\DummyFile.xlsx""' was not a file. Destination file names are only used when the source dataset is a file Is this a known limitation of FileCopy? I could use a SystemCaller and/or Python to get the same result but equally feel that this should work.

1170
dbryantgeo
Contributor
A
aburowah
asked in General
Convert Quick Capture Latitude and Longitude

How to convert ArcGIS Online Quick Capture Latitude and Longitude coordinates to a projected X and Y coordinates?

90
egge
Contributor
paul_m
Contributor
paul_mContributor
asked in General
How to create a count that changes based on preceding empty values in a dataset?

I'm trying to create a count that changes whenever it sees an empty row in a dataset. For example, I have the first 3 columns and would like to create a column similar to Test2 (see image below) that has a new count whenever there is an empty value in Test in the preceding row. Any ideas would be greatly appreciated!

120
paul_m
Contributor
tcronin
Contributor
tcroninContributor
asked in General
How to setup a folder that can be written to from FME Server

I created a Service account called svc_fme, and it has write access to a folder. The service account is what is setup for running the FME Server components except DB. Thinking same logic as Esri Service access for FME Service. I have an ETL on FME Server that is not writing to the desired location. How do I set this up?

1070
tcronin
Contributor
nitinshahane
Contributor
nitinshahaneContributor
asked in General
I am getting following error while executing the workspace on FME server. The error number from ArcObjects is: '-2147221230'. The error message from ArcObjects is: {}

I am getting following error while executing the workspace on FME server. However, workspace is working fine on the Desktop. Please suggest.The error number from ArcObjects is: '-2147221230'. The error message from ArcObjects is: {}

3200
nitinshahane
Contributor
H
haris
asked in General
Unable to see Authentication Services under User management in Admin console.

I am trying to setup SSO/SAML on FME server. We already have https enabled and I am able to login using the AD credentials.We are following below documentation and for FME server setting, it says to go to Authentication services which I am unable to locate under user management. Is there anything that I am missing or anything that I have to enable ? https://docs.safe.com/fme/html/FME_Server_Documentation/WebUI/SAML-Configuration.htm Thanks

190
richardatsafe
Safer
A
awieckowicz
asked in General
Can I create a FME server app that allows the user to select from a dynamic list?

Can I create a FME server app that allows the user to select from a dynamic list of gdb version names. I am able to create a workbench with a reader that reads the SDE_VERSIONS table but I don't know if its possible to use the version table create a pick list as a user parameter that would allow the user to select the version name to be used down stream. Thanks,Ali

360
A
A
asadamjad
asked in General
how can i Read data from API log File

I want some data from the log, and I am using API to get this data anyone knows which format I use in feature reader to get the data from log file 

950
A
arnaud.leidgens
Contributor
arnaud.leidgensContributor
asked in General
Failed to retrieve feature types

Hello. I'm working for a client on FME desktop 2018.1. My workbench was working fine, reading SQL tables and writing Arcgis Portal Features Services. Since we  changed the authentication system (IWA), I don't have access to the layers anymore. I'm able to connect successfully to the Arcgis Portal Feature Service (through NTLM, domain\username), but I cannot access to the features themselves anymore ("Failed to retrieve feature types error"). If we disable IWA, it's working fine but this is not an option. Thank you in advance.Merged 0 schema features read from 1 datasets into 0 resulting feature types UniversalReader -- readSchema resulted in 0 schema features being returned Failed to obtain any schemas from reader 'ARCGISPORTALFEATURES' from 1 datasets. This may be due to invalid datasets or format accessibility issues due to licensing, dependencies, or module loading.. 

4330
lau
dave_oppd
Contributor
dave_oppdContributor
asked in General
What format to export SSL Certificate as for FME server setup?

The instructions available for using PFX (step 6 in this document https://docs.safe.com/fme/html/FME_Server_Documentation/AdminGuide/configuring_for_https.htm#Using) says to export as a Base-64 encoded X.509 (CER) file. Appears newer versions of Chrome and Edge only have following options. Which would I use instead of CER file and are there differences with importing with keytool into cacerts keystore?

630
richardatsafe
Safer
R
radek.cervenka
asked in General
Check the extension on input files for FME apps

How can I check the extension on input files for FME appsFor example a file with a DWG extension Thank you for answer

1970
richardatsafe
Safer
D
dj_huisman
asked in General
Difference date format output in Feature writer between upload from client and post by API

I have a problem when uploading a workspace to FME server using the API. There is a difference in the date output in feature writer in CSV format. I have a datetime formatter which change the date to %d-%m-%Y %T.When run the job on FME server after publishing from FME desktop the output CSV has the espected value "29-05-2016 11:36:03.553" (%d-%m-%Y %T).When run the job after POST by the API the output in the CSV is "20160529113603.553" (date format FME).In the featurewriter the output is manual and the date field is set to string.I don't understand this behaviour.

280
richardatsafe
Safer
R
robshawuk
asked in General
Can use a formula to change the RGB values in a raster?

I have a large number of images, some of which have a colour range that is different to the rest. I have a csv file that lists each filename and whether it requires adjustment or not.I would like to be able to modify the red, green and blue for those images using a quadratic formula, something like: set Red=if([needsadjustment]=1,max(min(Red^2*-0.004+Red*1.78+57,255),0),Red)and similarly for green and blue channels.Can anyone advise if this is possible using FME please?ThanksRob

230
danilo_fme
Evangelist
T
tanmat
asked in General
Hi, I use httpcaller, but in the bodyresponse I don't have the full answer. Here it's the link : https://webapp.csrs-scrs.nrcan-rncan.gc.ca/CSRS/tools/NTS/031I10746649 I have this answer with a browser :

031I10746649, UTM18, E 674600, N 5164900, N46 36 54, W72 43 11, 46.6149, -72.7197 and with htppcaller, I have : 031I10746649, UTM18, E 674600, N 5164900, N46 36 54 Why I don't have the same thing ?Thanks,Matthieu 

00
danilo_fme
Evangelist
fmesafe.podpora
Contributor
fmesafe.podporaContributor
asked in General
writing the aggregate shapefile geometry

Hi. I would like to ask for advice. I have one airport geometry and I have for example three runways to this airport (for example BENESOV). I need to write this data into a shapefile including geometry = 3 x BENESOV airport geometry with runway number see printscreen. 204 elements are correct for the input of the shapefilewriter, but we only write elements that have one runway to one airport. Can someone please advise how to solve this? I am also attaching WS in the attachment. thank you very much

967
nielsgerrits
VIP
A
atc
asked in General
Test multiple FeatureCounters with one Tester

Hi,I need to test multiple FeatureCounters with one Tester so that if any of the counters have a value of zero then the test fails. Unfortunately the tests always fails because some of the fields are missing when the counters appear in the Tester's results. The test below is supposed to pass. Is there a way to set this up so that I can get the results that I am looking for?

260
dustin
Influencer
spiderman
Contributor
spidermanContributor
asked in General
How can I write point with text in gdb ?

I have created by text adder for polygon .point with text name of polygon but I have noticed after writing them in gdb Esri api or in Esri shape file .when I try to read the output again , I read only points ,i see it but I do not see any text with point ,why ?i would like to have point with text as I have written ,Does it possible ?Thanks in advance FME 2021

200
spiderman
Contributor
mark2atsafe
Safer
mark2atsafeSafer
asked in General
What's Up Wednesday (12-October-2022): Certification Program Updates, Community Surveys, Feature Order, Raster Mosaicking, Hub Updates, Data Mining, and so much more...

Hello FME friends,After a week away, here's a very full edition of What's Up Wednesday.  Certification Program UpdatesAs of this week, you'll notice major changes to our FME Certification program. Firstly, there is a new trail on the FME Academy to help you learn the required skills to pass the exam:  Yes, that says 62 hours, but that's if you are starting from scratch with no FME skills. If you're considering certification, I expect that you would have completed many of these modules already, or have the equivalent amount of training and/or experience. Secondly, the FME Certification exams are now being "proctored". This means that automated software monitors your exam to ensure the right person is taking the test and does not receive outside help.  It's not that we don't trust you, but we think certifications have more value when carried out under secure conditions like this. It also lets us process your applications quickly and provide interacti

440
danilo_fme
Evangelist
spiderman
Contributor
spidermanContributor
asked in General
How to merge two layers to create single layer

 I have used text adder to create name of polygon at the middle .So i have points geometry as name of each polygon at middle of polygon and polygon borders.i would like to merge both of them and have point and borders in one layer .How could I do it ? i would like to keep only attributes and rows of polygon borders .there is id common between polygon borders and points  Fme 2021 Thabks in advance

3680
spiderman
Contributor
casheddy
casheddy
asked in General
Is there a way to keep duplicate stacked points but offset only the duplicates' z-value by value of 1?

I have migrated data into Utility Network but have a large amount of duplicate stacked point features. They all need to remain but the network topology will remain dirty unless I find a way to make these duplicate XY's unique. After testing a few manually, it seems to work if I add a z value of 1 to only the duplicate points and revalidate topology. So if I could add a z-value of 1 to only the duplicates using FME, it would solve my issue. Any help is greatly appreciated!

400
casheddy
P
potatocomputer
asked in General
Writing JS file with JSON writer

I am trying to read in a csv and write the contents into a javascript file. It works at least 90% of the way and looks like this when I export the features:[ { feature1: value1, feature2: value2 }, { .... } ] I would like to insert the text "var data = " at the beginning of the file, like so:var data =[ { feature1: value1, feature2: value2 }, { .... } ] Is it possible to insert this text in the file before the JSON writer writes out the contents?  Another detail is that this CSV file has over 5 million rows. It is difficult to open the file and write in the text or use powershell commands. Any help is appreciated!

354
P
A
anthonycorbeil
asked in General
Hey everyone I am completely new to FME capabilties. We currently use Civil 3D 2023 and were looking for a simple way to create a geospatial PDF from a Civil 3D Drawing (DWG) file. Just wondering what solutions FME offers for this? Thanks everyone!

Hey everyone I am completely new to FME capabilties. We currently use Civil 3D 2023 and were looking for a simple way to create a geospatial PDF from a Civil 3D Drawing (DWG) file. Just wondering what solutions FME offers for this? Thanks everyone!

120
danminneyatsaf
Safer
jimsco
Participant
jimscoParticipant
asked in General
Has the way the vertex creator processes data changed in v2022?

Hi, we're getting an out of memory issue running a workbench in 2022.2 that runs fine on the same computer in version 2021. Has the way the vertexd creator processes data changed?

410
M
T
thierrymeessen
asked in General
How to fefine MySql DB table as parameter

Hello I have to migrate a MySQL DB to a Postgres DB. The input DB contains about 200 different tables. Some fields of these tables contain url. Before migrating these urls, I would like to validate them. I have created a workspace which works perfectly fine using a sequence of transformers HTTPCaller transformer.Before publishing it to FME Server, I would like to define some parameters amongst which the name of the table and the name of the field containing the url to check. Is there a way to do this? I have tried to use published paramaters which is ok for the fieldname but I cannot see how to do it on reader feature type. Thanks in advance for your help.I would like to create a workspace using a MySQL DB containing about 200 tables as input to let user define the table (and the field)

110
T

Badge Winners

Show all badges

Community Stats

31,773
Posts
120,715
Replies
39,396
Members

Latest FME

Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.