FME Form

I'm trying to connect to and access an MS Access database that has a password and I am getting the following error.   592021-12-20 15:02:42 | COM.safe.fme.jdbc.TableProbablyDoesntExistException: net.ucanaccess.jdbc.UcanaccessSQLException: UCAExc:::5.0.0 user lacks privilege or object not found: VIP I can connect and access another MS Access database that is not password protected without any issues. For what it's worth, I can connect and access data in the password protected database from FME Workbench on my local PC, just not from FME Server.  Thanks in advance for any suggestions.

I have an issue with my workspace using an Interlis Writer (ili2fme).It is running fine on my local machine, but not on a server where FME Server and ArcGIS Server is installed. Following error is listed in the logs: Writer `ch.ehi.fme.Main_1_FANOUT' of type `MULTI_WRITER' using group definition keyword `MULTI_WRITER_DEF'Creating writer for format: Swiss INTERLIS (ili2fme)Trying to find a JAVA plugin for writer named `ch.ehi.fme.Main'The class 'COM/safe/fmeobjects/FMEObjects" could not be located. Check your classpath and later in the logs: Translation FAILED.## A fatal error has been detected by the Java Runtime Environment:## EXCEPTION_ACCESS_VIOLATION(0xc0000005)at pc=0x00007ffd43921c11, pid=29404, tid=16240## JRE version: OpenJDK Runtime Environment (11.0.6+10) (build 11.0.6+10)# Java VM: OpenJDK 64-Bit Server VM (11.0.6+10, interpreted mode, compressed oops, g1 gc, windows-amd64)# Problematic frame:# C 0x00007ffd43921c11  FME Desktop Version:FME Desktop ES

Hi, does anyone know how to fix the "Geom" field and turn it into appropriate coordinates? I downloaded the CSV file from the city of Vancouver open portal and ran it in the FEM workspace without changing any parameters, but I couldn't see any point features after. I was wondering if I should fix the attributes as the coordinates are within the same field? Thank you!

I have a list of codes (over 100) in a CSV and want to use a test for each code in a TestFilter. Is there a way to load them all at the same time rather than cutting and pasting individually?

Hi everyone I'm trying to make a web app that will be situated on our company VPS which is off course on remote server. We are running FME Server 2019 on local machine inside our company local network and is accessed through IP address. For the web app, I'm using some REST API code (I'm not an expert I must say) found in your "data-distribution-with-web-maps" demo where you set fmeserver url and token. Off course, setting those two is not a problem. I have also enabled CORS on FME Server. When opening webpage, web app triggers workbench but nothing happens and web developer error appears : Cross-Origin Request Blocked: The Same Origin Policy disallows reading the remote resource at https: ...As I have defined in JS file in web app, fmeserver url should start with http and by no means https protocol. I don't know if I'm doing something wrong. Has anyone tried anything similar and made it work?When using this app on local network, it works (CORS disabled). T

Hi Folks - I am looking to use the API to get a list of all the Web Connections on the FME server. Has anyone done this before? Thanks

I know that the SharePoint List reader and the SharePointOnline connector are quite different from each other. Using a registered app on Azure worked fine for the SharePointOnline connector and its attached web service - but for the list reader, the web connection only required us to exchange the [TENANT] with our sharepoint tenant without changing anything else. This was working fine on our testing SharePoint platform using a non-personal user account to logon with. However, on our actual SharePoint platform, this trick does not work when using my own user credentials (it notifies me that the app needs admin rights) - and I am asking myself why. Does the user need to have certain rights in order to use the web connection? Then, as a second attempt, I followed the workflow here https://community.safe.com/s/article/How-to-create-a-Sharepoint-Web-Connection and it let me successfully test the connection as we have a registered app on Azure. But this failed when I tried to actually use th

I am trying to create an individual HTML file for each 'grouped by' polygon. I have the Fanout Expression set as per below with the attribute that is used in the 'group by' but I just get a single HTML file.  The attribute seems to be available to select but does not appear to be used during output. Is there something different I should be doing to get individual HTML files?

Well, it's time for all the latest FME news for the week. The FME World TourThere are many World Tour events still to come, as well as completed. The 1Spatial UK Tour visited London and tomorrow (perhaps today by the time you read this) is in Cardiff. They have upcoming events in Leeds and Glasgow too. Everyone was happy to be back in person again and to be presenting in front of others.  Also coming up, there are World Tour events in Brazil with Solutial (São Paulo and Rio de Janeiro), Austria with Axmann (Vienna), and Japan with Pacific Spatial (Tokyo). You know where the full list is. Don't you?! Of course, as some events are completed, their presentations appear online. Here we have some user presentations from con terra España. I don't speak Spanish but I do see mention of CityGML, Cesium, and FME Server Automations. I don't speak Dutch either, but even I can tell what "snel, sneller, snelst" means on Red Geographics world tour page. I think you can still

I would like to see if a value from a specified column/attribute can be counted into another column based on how many times it appears across multiple columns. I hope to do this for every feature/row of a dataset. Example of the data below : In this case, I would like specify the value in the DominantValue field, and I would like to see how many times this value appears in fields: AreaCount1, AreaCount2, AreaCount3, AreaCount4, Areacount5, and AreaCount6. The number of times it appears would be stored in a field called dvcounter. For example the desired output would look something like the below table: Does anyone have any recommendations as to what transformers or workflows can provide this "count" field? I've attached a portion of the csv data that I am working with and the workspace that I am working on. This workflow builds on top of question that was recently answered by @Takashi Iijima​ :https://community.safe.com/s/feed/0D54Q00009RcXusSAF  

Hello, newbie here. I'm using AttributeManager to rename and remove some Attributes - and to add a new Attribute using a Conditional Value based upon (among others) an Attribute named IATA, which contains airport call letters. For San Francisco International Airport, IATA contains "SFO" but for Nadi International Airport, the IATA Attribute contains "NAN". No matter how I try to force FME to treat those call letters as a string, it eventually becomes "if NAN != null... and I get "nan" as the result. Pretty sure that's a bug (2019.2). Note: Set Value with @Value(IATA) works fine with "NAN". It seems to be only the Conditional Value code that has the problem. Does anyone have an idea how to conditionally process an Attribute that may contain the value "NAN" (or other values that might also be mathematical constants)?

I think this is an easy one, however i am stumped.  I have a set of data with 3 columns.  Fieldname, Fieldval, RecordGroup.  I simply want to aggregate by recordgroup and then rename attribute names to the value that is stored in the Fieldname.  Where i am stumbling is how to rename the fields to the values in the input field.  Thanks in advance.   

Is it possible to get an additional attribute from a las file in FME. Indeed I have an input point cloud in las format with a vertical distance attribute on each point.I need this attribute to make statistics.How to get this attribute directly when reading the las file (or other) without passing "PointCloudCoercer"?

Hi, Is there a way to test if a polygon geometry contains curve? I dont find any transformer that explicitely achieve that. Thank you!

I have a workbench to process some raster imagery, each image is stand alone in the processing done, so a clear candidate for parallel processing. The workbench now looks likeI've set the group by to the image name (all unique), and run in both modes with the following outcomes:'Process when group changes (Advanced)' - Task Manager shows only only a single FME instance processing, act as blocking, processing all files before it begins writing results. 'Process at End (Blocking)' - Task Manager shows multiple FME instances launched, but only one is doing any work, acts as blocking, processing all files before it begins writing results. Both paths are giving correct results, I have removed any 'group by' within the custom transformer, I'm trying to understand what is going wrong in running in parallel. Thanks!

Currently, we have a very curious problem. A workspace is made in FME Workbench desktop which runs without any problem. In the workspace, geometry in a ESRI file geodatabase is repaired by a Python script (arcpy). However, when deployed on FME Server, this process results in an unexpected error, see attached file. The account which starts and runs the process on FME server has sufficient read and write persmissions on the location where the geodatabase is stored.  What could be the cause of this problem?  Kind regards,Pim van der Zwaag.

A very simple workspace using ArcObjects Esri FileGeodatabaseReader and output to an Inspector. Duration 16.5 seconds with FME2022 and similar workspace duration is 10.5 seconds with FME2021.2 Logfiles attached and a Excel spreadsheet with output from FME_PROFILE_RESULT_CSV bestPål Herman

Is there a work around to be able to import Datamine, gOcad and Leapfrog 3D objects within FME to be able to automate queries and manipulations on these objects?

Hi,Does anybody have any experience writing GDB metadata images into SDE?I can update just about anything but inserting an image to the item description needs to be in a specific ESRI binary format (EsriPropertyType="PictureX") and the AttributeFileReader transformer does not support this encoding type. Cheers, Itay

I'm using an ArcGIS Feature reader to read a layer with two tables. The two tables have 9257 and 9606 rows. After reading the two tables, I join them. At this point (with feature caching) I can see that I have 9606 rows. This is correct. The last step of the workspace is to use an ArcGIS Feature writer to populate a different layer.  The ArcGIS Feature Writer has the following Parameters for Layer: Writer Mode: Insert Truncate First: Yes Currently, my destination Feature layer has 10584 rows. How could this be? How can I exceed the number of rows in my source layer? I just ran the workspace up to the Writer and can see 9606 items going into the Feature Writer. then, I ran the entire workspace and the destination layer now has 9752 rows. I'm perplexed. This is a public facing dashboard and I need accuracy. I do run this workspace from a batch file and schedule it to run at 3:00 AM with Windows Task Scheduler. I'm not sure if that matters. Any ideas? I suspect that the destin

XML Document is: http://vocab.nerc.ac.uk/isoCodelists/sdnCodelists/gmxCodeLists.xml

Hi guys, I have DTM files in ASCII GRID format and I need to generate contours from this files. Everything works fine untill last step. When I am generating contours with contours generator transformer everything works fine, but I have in the area few lakes where I don't want to generate contours.  I've tried to use breaklines but when I am using it generally nothing change - contours still looks the same. I have layer with lakes where I don't want to generate contours. Before connect it to Breaklines arrow in ContourGenerator transformer I am using geometry coercer and 3DForcer. Can you guys tell me what I am doing wrong? I have no idea how to manage with this. Screnshot below. Brown polygon is a lake. Thank in advance. 

A few years ago I created a FME-hub custom transformer InlineGeoJSON. It creates a GeoJSON file with FeatureCollections. The transformer works fine in fme 2020, but does not work in versions starting from FME 2021. This has something to do with the dynamic schema setup. The current error is:  GEOJSON writer: Unknown feature type 'GeoJSON' passed to the JSON writerInlineGeoJSON_FeatureMerger (ReferenceFactory): GEOJSON writer: Unknown feature type 'GeoJSON' passed to the JSON writer I tried many different solutions, for example:replacing the schemasetter with the new schemascannerchanging the schema definition namechanging the feature type nameI added my workspace with the current test workspace. Does anyone have an idea how to solve this?

In what way can I control the behaviour of SqlExecutor concerning transactions. I'd like to perform several inserts and updates as a single transaction (by putting the "commit"-command at the end). But this commit always results in the warning "there is no transaction in progress".Database = PostgreSQL

Curves has many vertex.