A space to discuss FME Form
Recently active
Hi,I would like to sent a shapefile that is created with the workbench. When i use it without attachment the mail is sent. An mail with the attachment is rejected. What goes wrong? I tried with authentication but no succes.Who can help me?
Hi, I have two files one containing the solid of the building top and another has the solid of Building foot prints. I would like to subtract the top view solid from building foot print solid. Can any one please help.
Hello Community I’ve made effective use of HTTPCaller to connect to an external secure FTP. I then download that data to process downstream in the workspace. But can I use FME Desktop to upload to a secure FTP, or perhaps to an external API? Thanks,
Hi there,I have a database containing a BUILDING table which is related to a BUILDING_FUNCTION table.A building can have 0-n functions associated to it (i.e. Schools, Public buildings, etc).But it's more complicated than that. The functions are timely (Origin, Intermediary, Present)And there are three levels of details in the functions (I-basic, II-medium, III-detail) Here is an example simplied dataset for only one building, number 14...I need to denormalize this table to get only one entry per building.Here is the desired result. Note that in INTERMEDIARY functions, there are two functions listed. This is due to the fact that the a building can have more than one set of functions for each timely period. In the example above, where the TIME attribute has "2 Intermediary", you have two sets of basic-medium-detail FUNCTION_LEVEL. I'm joining an excel spreadsheet as sample data.Thanks a ton in advance for your help ! PS. This is somewhat related to my previous post but
I'm getting the "Error running translation" when using a JSONExtractor. I checked my api call that is getting the JSON from Salesforce and the POST to get the token/Auth in Postman and they return the data/auth fine. I've attached a logger to the in between of API caller and the JSONExtractor and the data is there. Been staring at this for a few hours now, any help is appreciated.JSONExtractor Custom Transformer that the JSONExtractor is apart ofWhere the transformer is getting called in main
Hello everyone, I have a question with regard to preserving the pattern style of hatches in DWG files. I have a simple DWG file with two lines (blue), one text (yellow), a dimension (magenta), and a polygon (blue) which is filled with a hatch (cyan): If I now simply read the DWG file with a REALDWG reader and do nothing but write it again with the REALDWG writer, the hatching pattern looks very different in the result - which is basically because the lines of the hatching pattern are much closer together than they were in the original DWG file:More details below. Does anyone know how I need to parameterize reader and/or writer such that the pattern style of the hatch is preserved 1:1? In the REALDWG reader, I already linked the read-in DWG file as a "Template File". This helped to preserve the styling of the dimension but unfortunately not with regard to the pattern style of the hatch. Here some more details:Regarding the parameterization of the REALDWG reader, I only unch
Hello, Is there a way to read Garmin format TCX and FIT ? I can't find any info regarding readers for these 2 formats. Thanks
I'm using an ArcGIS Feature reader to read a layer with two tables. After reading the two tables, I join them. I add and remove many attributes. The last step of the workspace is to use an ArcGIS Feature writer to populate a layer. In the past when I've done this, the ArcGIS Feature writer created the ArcGIS feature service. Can I write to an existing feature service? ArcGIS Online (AGOL) field names must be 31 characters or less and not have spaces or other special characters (underscores are fines). Display names are also supported which can be longer than 31 characters and have spaces. Ideally, I'd like to specify a list of attributes with data types for the feature service. Questions:Can I create an FME workspace to write to an existing ArcGIS feature service? This is an ArcGIS question, but I'd like to easily create ArcGIS feature service based on a list of field names and data types. I think that I can do this in Python, but I don't know Python.
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 not be secure. Disabling verification of SSL certificates.
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 was: 'Connection to IT-ARCGIS-ENT.MBRODOM.NET:9876 refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections.'I thought it may be a firewall
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. This is a great tool as it can be used for many other things like Pavement, Road Construction by y
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.