General

I have adress points representing persons and attributes for each point including a categorization into age intervals. I also have a polygon grid to which I want to sum up all persons in each age interval to each grid cell. My output should be the grid polygons with a sum for each age interval, like this:"grid ID" "age 0_5" "age_6-17" 1 12 56 2 23 109 3 4 13I've tried several solutions eg. with "point on area overlayer" combined with the "list summer" but havn't been able to make it work. I use the 'generate list on an ouput area' option but my resulting "sum_" from list summer returns only "0" for all rows. Do I miss something with the lists buidling? Or any other ideas how this can be done? Thanks 

Specifying password on excel feature writer, for instance 'XXX_X', not possible to unprotect the sheet with same password.Excel edited is already protected with the same password. If protect sheet specs are not informed, excel becomes unprotected. Seems weird behavior...

Hello,  Just want to ask what is the specific condition in order for Create as Needed in the table handling be triggered? Thank you.

Hi I am looking for information on how to appropriately use the FME Command in a python loop using subprocess.popen to call the argument. I am struggling to find info on how to achieve this. I am getting syntax warnings in my command when I use subproces.popen. But if I past directly to the cmd prompt I dont have issues. So Im missing something. Any help is appreciated. Please ignore all my comments :P

Hello,I'm converting a ESRI gdb (of 21 layers) to shp with FME Desktop. Seventeen of the layers contain map objects - they're all good. But four layers do not contain map objects (2 x points, 2 x polys). For a very good reason, that I won't go into detail about here, I need to force at least one map object into those four empty shp datasets (a point into the point layers, a polygon into the polygon layers). The point can be in a random location, or one I specify. The polygons can be absolutely tiny. The values can be null. Is this possible within a FME workflow?

Is there still fmeobjects package supporting python 2.7 in FME 2022.2?I need to run an FME workspace in ArcMap, which uses python 2.7 and realized there is no fmeobjects for Python 2 in the FME installation folder. Is there an alternative way to do the job?

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

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.

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

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!

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?

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: {}

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

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

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 

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.. 

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?

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

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.

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

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 

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

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?

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

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 softwar