FME Form

trying to extract all Ldap users name and email etc.. but i am getting following error msg COM.safe.fme.jdbc.TableProbablyDoesntExistException: com.octetstring.jdbcLdap.jndi.SQLNamingException: Sizelimit Excif any can help me and advise. i am new in FME

I have a workspace with dozens of Readers & Writers that all point to the same database, all using the same connection. How to point all the relevant Feature Types to a single Reader/Writer definition, and then delete all the duplicates?(and then I'll need only one User Parameter!)  An output Feature Type let's me select which Writer to use, but input Feature Types have Reader field disabled. Why? How do I enable the UI control? 

We are wanting to check one feature service and one field in that service and whether it changed from "Sampled" to 3 other options. If it did change we want to send an email to let us know what the unique ids that did change. How would we use change detector to accomplish this task? We would like to schedule a task each night in FME server to send the email.

Hi,I haven't yet seen this - I cannot connect 2 transformers. It seems like there is something downstream the flux that prevents the connection.I captured the behavior in gif: I have Workbench 2020.0.1.Thanks in advance for any suggestions!

We have a CSV located in the following directory on our FME Server. We receive the following warning whenever we run a job that utilizes the CSV: USERNAME FME Server: SSL certificate verification failed for host 'MACHINENAME.DOMAINNAME.com:443'. HTTPS connections may not be secure. Disabling verification of SSL certificates. Message: HTTPSConnectionPool(host='MACHINENAME.DOMAINNAME.com', port=443): Max retries exceeded with url: /fmerest/v3/resources/connections/FME_SHAREDRESOURCE_DATA/filesys/FOLDERNAME/CSVNAME.csv?disposition=attachment&accept=contents (Caused by SSLError(SSLCertVerificationError(1, '[SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: self signed certificate in certificate chain (_ssl.c:1051)'))) We see a slightly different warning in Workbench: USERNAME FME Server: SSL certificate verification failed for host 'MACHINENAME.DOMAINNAME.com:443'. HTTPS connections may

I have developed a workbench in 32-bit FME 2021.1.1.2 which is reading ArcSDE DB with ArcFM (32-bit) and 64bit background processing installed. I have ArcGIS 10.6.1 installed. This workbench has been published to 64bit FME Server 2021.1.0.1. The error i am getting after setting up the scheduler in FME Server is "Could not open Enterprise Geodatabase. The error number from ArcObjects is : -2147.... The error message from ArcObjects is : {Underlying DMBS error [Unknown errorNo Extended error.]}" The workbench runs fine in a standalone mode without FME Server. Is the issue due to compatibility issues between 64-bit FME Server and 32-bit ESRI products or the the version difference between 2021.1.x between FME Desktop and FME Server ?

Issue: I can set the Alternative and retrieve data from that Smallworld alternative, but only once at a time.  Current work around: I have to clear the Alternative parameter, cache the Reader, and then re-enter the Alternative name and re-run the workspace. Potential cause: It seems to me like the Reader moves into the Alternative on the first run and then when I run it again it cannot find the Alternative because it is already in it. Which is why I need to cache it without a value in the Alternative parameter, effectively moving back out of that alternative. More details: In the smallworld environment I have moved into the alternative of interest ( mainly for testing ), do I need to stay in TOP?I am not writing back into Smallworld just reading out. Potential Fixes: I have tried messing around with 'Export Changes from baseline' but that does not seem to help.

Hello I am using FME 2021.2 on an AWS machine and am connecting to an Oracle DB on-prem, but the connection is very slow. I currently have SQL Developer setup on the AWS machine and its connection to Oracle is as expected (fast). Issue:When I test the connection in FME it can take several minutes to recieve the pop-up saying 'successful connection'.I am using TNS and have setup the tnsnames.ora file I dont get any warnings or errors in the log When I use the same file for SQL Developer its response is very fastDoes anyone have any suggestions as to how to speed up that connection?

I have a tester that checks if the user entered something into a user parameter. If they don't enter something then I want to create a new record. Currently it tests for the null and then it essentially stops as no data comes through. I want to create the data thorough a series of calculations. How do I do that?

Hi. I am trying to model some buildings' roofs in LoD2 using point clouds(las) and some shp files from arc gis, but I cannot find the right transformation. I have seen the sixth demo in this webinar, https://www.safe.com/webinars/gain-total-control-of-your-lidar-and-point-cloud-data/but they are just roofs in LoD1.Can someone help me how to do that?Many thanks

Hi, I have a workbench setup, it reads a database connection, does some transformations, then write to our Enterprise GIS Portal. The writer is setup to overwrite/truncate the feature layer data,  and it has been running successfully for months, but I have now noticed it is failing. I had some issues getting the workbench setup, I think I had some forums post about it as we had to rename some fields and use replace some strings as some characters were causing problems.  But all them got sorted and it was working fine. The error message is:ArcGIS Portal Feature Service Writer: Could not retrieve metadata for layer/table ID 0 of Feature Service at 'https://maps.middlesbrough.gov.uk/server/rest/services/Hosted/ReportIT_Firmstep/FeatureServer'. The error code from the server was '500' and the message w

Hello FME Community, I have a large FME workbench and I am trying to save the workbench canvas as a PDF in one page. does anyone know how to export canvas as PDF.  

I'm trying to write hierarchical XFM-elements, one parent with all the xml data, and two graphical child elements (a point and a text). This is the warning I get on every parent element:DESIGN WRITER: Feature found with igds_type of 'igds_xfmstore', that has unsupported 'Topology' information. Skipping XFM feature store element write Because of this, all parent elements are skipped.What is this 'Topology information'?

FME 2022.1 64-bit Personal Geodb Reader - Reading feature type as case-sensitive. Where as 32-bit Personal Geodb Reader in earlier versions used to read feature type name as case-insensitive. Is there a way to make FME 2022.1 64-bit Personal Geodb Reader to read feature type as case-insensitive? 

I am trying to create a pdf file using the straight line diagram. I have a data file with the Road reseals as lines and I would like to be able to show the distance or length of the Reseal, the Year Applied, and stone size as a stacked straight line chart. This will then show the overlaps as well. Many years ago we used to do the very same thing on paper, in a book, by hand so we could see the surfaces applied to the roads over time. I am currently reviewing or trying to, do some analysis and update what we had on paper into a modern approach. I have watched the video of it being used here https://www.youtube.com/watch?v=2tPhZMSrnYw at the end of the webinar but I am struggling to sort it out given it was a very short session at the end. I would like some more specifics or how to on setting it up, or even a sample workspace may be the one from the demo would be a good example to follow.

How to split a delimited string with a carriage return to create a stacked list. Example:Input = A:1-100+B:1-300+C:1-600Output = A:1-100 B:1-300 C:1-600 The output will be stored in a multiline attribute in AutoCAD 2017.

Hello all, I'm a newbie to the Azure Storage Connector and stuck at authentication. The file storage connector errors. The Hub readme link for authorizing access to my account goes to REST API documentation, not very helpful, I need to know what to do in the Azure portal console to make things work. Is there any doc out there? Thanks.

Hello,  I try to read the attribute"IFCPROPERTYSINGLEVALUE" with FME. Unfortunately this does not work,in the "list builder" I can see the attribute "IdentityData.Assembly Code" only it is empty. While in the data with GlobalId"0q2mDI5en2pRRKYDPxu88G" it does have an attribute. How can I make this data visible withina workbench so that it can be filtered.  I added the .ifc as a text file, thereis already some described on the forum of how to read the"IFCPROPERTYSINGLEVALUE" only I didnt get it working. 

Hi,How can I join each feature from one dataset to all features from a second dataset?Datasets aren't related to each other by any column.  Thanks in advance,Moisés

Hello FME community, I have loaded a text file as CSV into the workflow so that a table is created.This then looks like this:I need a process that can work independently of the number of attributes but according to a pattern. Therefore I have converted these attributes into a list. Here is an excerpt from it: (fme_basename: 102)_list{0}.col2   892_list{0}.col3   1448_list{0}.col4   48_list{0}.col5   70_list{0}.col6   874_list{0}.col7   1628_list{0}.col8   50_list{0}.col9   78 The pattern looks like this:col2 and col6 belong in one attribute (x)col3 and col7 belong in one attribute (y)col4 and col8 belong in one attribute (dx)col5 and col9 belong in one attribute (dy) So every 4th element belongs t

When writing a KML-file all characters with '&' are written as '& 'This also happens with '<' and '>' which will be exported as '<' and '>' This is the result<SimpleData name="sign">Electrical & hydrogene</SimpleData>But i need<SimpleData name="sign">Electrical & hydrogene</SimpleData> Is that possible?

 How can i get the data from this website via fme https://idpgis.ncep.noaa.gov/arcgis/rest/services/NWS_Forecasts_Guidance_Warnings/NHC_tropical_weather_summary/MapServer/1

I want to write a CSAR raster, metadata (.XML) and an additional layer (.GML) to one zipped file. If I add folder.zip to the path the first files are being overwritten and dataset fanout does seem like a way to split an existing output into multiple file extension to be zipped. Both options are not giving the desired result. 

I have created a workflow in FME desktop on my mac and want to run this job on the FME server. As I am using mac, I am running the Docker build of the FME server. When executing the same job on the server I get this error message "Module 'acad/ACAD' is unavailable for use with this FME edition". Looking at similar issues I suspected that the module was not supported for Linux (Docker container), however this was not the case. I have tried running different version of the FME server (22715 and 2263), this does not affect the result, still the same error message.  Any idea of what is causing the problem? Could this problem be avoided if using Windows OS and the modules made for Windows?​

Is it possible to DELETE files using the WRITER "File Copy" ?  UPDATE:I have created a custom transformer that uses the solution (FeatureWriter in MOVE to null) and uploaded to https://hub.safe.com/publishers/sigtill/transformers/filedeleter Feel free to send any feedback related to this.