FME Form

Hello:This is probably a simple use case to many of you, but I only have basic experience with FME Form and Flow.One of our programs has the ability to generate standard excel spreadsheets which contain reservation data (Date, Name of Room, Description of Room activity, Organizer contact info) GOAL: We would like FME to take that excel spreadsheet and post that data as a table on an html webpage.However, before that html webpage is generated, we would like the user to visit an FME Flow App (? I think) that will allow them to select from a dropdown list of rooms culled from a column in the excel spreadsheet. Once selected and submitted, the app would only show the list of active reservations Things to note:This excel spreadsheet data is updated once a day and will only show the current day’s data and will need to be uploaded to FME Flow each day. It’s being stored on a network location.I’ve managed to create a FME Desktop app that uses Excel Reader > HTMLReportGenerator > HTML Wri

I have a JSON-schema. A part of it looks like this:     "dct_license_sm": {      "type": "array",      "items": {        "type": "string"      }    } I feed data into a featurewriter pointed at the schema-file. The corresponding data from the input looks like this:dct_license_sm (string: UTF-8): https://creativecommons.org/licenses/by/4.0/So - a string, but in the schema it is declared that this is to be an array with string-items. Then I would expect the output to be like:  "dct_license_sm": [    "https://creativecommons.org/licenses/by/4.0/"  ],Obviously declared as an array containing a single string. But my results in FME via the FeatureWriter comes out like this:"dct_license_sm" : "https://creativecommons.org/licenses/by/4.0/",In the FeatureWriter I can't change the datatype.What would be a good way around this?   

Hi ,I am ussing a sqlexecutor for update or insert data in tables. But how do i get the rows updates, inserted ??so i use this in a Emailer ??  

I am outputting many rows to an excel table, some of my columns are numeric, I am hoping to add a total row at the bottom of my table, to sum these columns. I have found the Statistics Calculator, but I have no idea how to apply it (if at all possible). Any thoughts?

Hi All,I have read a few posts on the community already but can’t understand why the area calculated using Area Calculator is different to the SHAPE_Area in the Feature Class after exported to a GDB.An example below:Any ideas why does this happen?Thanks :)

Hello,I have a csv-file with the position of trees and additional information like the height of the trees. Further I have a sketchup model of a tree which I want to place at the position of each tree and scale it using the height of the trees.I can manage all steps from the different files, but not the scaling of the trees. If I use the example from https://hub.safe.com/publishers/con-terra-lab/templates/citygml-create-solitaryvegetationobject-with-implicit-representation and export the workbench to CityGML, the scale of each tree is right. If I want to export my data to Cesium tiles, the scaling is missing.Where can I set the scaling of the tree models for a proper output to Cesium?Thanks in advance and best regards,Andreas

I have a multitude of ring buffers and polygons for which I need to figure out what polygon intersects with what buffer. The task should be easy, but I am stuck here.All data come from the same feature dataset in a file geodatabase (so the spatial reference system is by default the same), however, to be absolutely sure I projected all data before they get into the SpatialFilter to the same EPSG.The settings for the SpatialFilter can be seen hereand to show that there are certainly intersecting areas and buffers that contain candidates I add the graphics view of the ‘Passed’ port and from the ‘Reprojected’ port of the Tester and the Reprojector.The candidates are in red…I did try an AreaOnAreaOverlayer, and that one finds overlaps but the request of merging the attribute data is unsuccessful. Meaning all the attributes are in the attribute table, but values from the buffers are not merged to the intersecting polygons, or the other way around. The list I create to check for what buffers

I was trying to compute the distance between a TINSurface and some horizontal polygons (which have a z value, but they are horizontal). I have been trying multiple things to try and get the distance between this two objects. I am kind of surprised that there is not a given transformer to compute the distance or the intersection between 2 given 3d polygons. Maybe a TINSurface is a little complex, but the triangles that compose them should not be complicated.I am a programmer and I think I can program a solution to this problem in a PythonCaller transformer, but I am really surprised there is not a simple answer for this.So if someone knows the answer to this I would appreciate it. If not I think I’ll be forced to program it myself.

I have added an FME Web connector towards Autodesk Construction cloud and have managed to access folders from my project. The list request seems to work in the AutoDeskDocsConnector-transformer, but fails when I want to download a file from the folder. I get the following error when translating: I use an ordinary Creator to connect to the AutoDeskDocsConnector. Does anyone have any tips what I’m doing wrong?

Hello all! I am stuck and unable to create a formula in FME. It involves an Excel formula that I can't seem to replicate in FME. I know there's likely a simple way to achieve this. I need to subtract values. Here is a screenshot for reference: I would greatly appreciate any help!  

This is probably a simple question, but I'm having difficulty rounding values within the xml editor of the XMLTemplator.With the root template set to:<feature>    <number>{fme:get-attribute("NUMBER")}</number></feature>The NUMBER value is written in the output. But when I use:<feature>    <number>@round({fme:get-attribute("NUMBER")},3)</number></feature>or even:<feature>    <number>@Evaluate(@round({fme:get-attribute("NUMBER")},3))</number></feature>the xml returned contains an empty string:<?xml version="1.0" encoding="UTF-8"?><feature>    <number/></feature>I could round with an AttributeRounder prior to the XMLTemplater, but although that rounds the values in Visual Preview, the xml output can and does contain the floating point representation errors.I'm guessing this might be a syntax thing but I've had no joy yet implementing this in the editor.(FME 2020.1 b20620)

Hi everyone,I am working with a large dataset (over 500,000 records) stored in PostGIS, which I am reading into FME and writing to ArcGIS Online (AGOL). My goal is to automate this process by publishing the FME Workbench to FME Flow, so the AGOL feature service updates every few hours.When I overwrite the data, the Workbench runs without any issues. However, I want to truncate the existing data instead of overwriting it. When I attempt to do this, I encounter the following error:413 Client Error: Request Entity Too LargeOccasionally, I receive other request size-related errors as well. I tried adjusting the Features Per Request parameter to 500, but the issue persists.I’d like to ask if anyone has experienced this issue before and what possible solutions or workarounds exist to efficiently truncate and update the AGOL feature service without running into request size limitations.Any insights or recommendations would be greatly appreciated!Thanks in advance.

Hi, I have a Civil 3D CAD model and need to extract information from the Drawing Settings. However, the available data comes from the Drawing Units window instead, which can be very different from what’s in the Drawing Settings   

Using an Esri FGDB Reader (an Esri FGDB FeatureReader) in a Workbench, I would like to apply a where clause using the last_updated field.  I believe that because this is a date/time field that it is causing me troubles as I am able to run tests on other fields.   What is the correct syntax to enter a where clause on a date/time field from a FGDB?  

I'm fairly new to IFC and the PythonCaller transformer.I have an IFCReader and want to use PythonCaller to convert an IFC file into an Esri file geodatabase using arcpy, allowing me to upload a scene layer package. Any tips on how to get started?  

   how can i turn this in FME????  login and get cookie: curl -k -i -X POST -d j_username=xxx -d j_password=xx -c cookies.txt https://<host>/Webcontrols/xmlsql login with cookie: curl -k -i -X POST -d j_username=xxx -d j_password=xx -b cookies.txt  https://<host>/Webcontrols/j_security_check echo "Get data from iprotect"query results to get data:curl -k -X POST -d @$base_dir/sql/acceskey.xml -b cookies.txt https://<host>/Webcontrols/xmlsql  --output acceskey_iprotect.xmlin the acceskey.xml is an xml format query select * from <table>output gives the data in xml format 

Hi,Could anyone please guide me on how to preserve the domain as it is when a feature class with domain for multiple fields is read using SDE reader, and then when it is written to a SDE Writer.When i look at the fields of the output feature class, the domain is empty. How can i overcome this?

Hello, I use a custom transformation in the ArcGIS platform.  It is a two step projection which uses the Ontario NAD83 grid file to project to NAD83 CSRS and then the second step is projecting from NAD83 CSRS to WGS84 geographic (LL).  The two tranformations are:ON_NAD83_NAD83CSRS_CustomTranf, (custom transformation set up in ESRI)NAD_1983_CSRS_To_WGS_1984_2 (chosen ESRI transformation).This two step process was recommended by ESRI Canada to import data into their ArcGIS Online format.  I have seen various articles for parts of this process in the FME Community but I guess I am looking for a stepwise list (e.g. obtain grid shift file from authority, create custom transformation in ESRI, etc.) to get the pieces of the puzzle in the right location to use in an FME workflow.Thanks

Hi. I’ve built a data cleaning workspace that performs a number of different tests, creating or retaining different attributes for each. I’ve created an ‘error type’ attribute to fan out by, have added schema scanners and have followed the gist of this. However, I cannot seem to get the writer to respect the varying schemas for each tab. Set up like this:   Pointers appreciated. Many thanks

Hi everyone,I am working with a large dataset (over 500,000 records) stored in PostGIS, which I am reading into FME and writing to ArcGIS Online (AGOL). My goal is to automate this process by publishing the FME Workbench to FME Flow, so the AGOL feature service updates every few hours.When I overwrite the data, the Workbench runs without any issues. However, I want to truncate the existing data instead of overwriting it. When I attempt to do this, I encounter the following error:413 Client Error: Request Entity Too LargeOccasionally, I receive other request size-related errors as well. I tried adjusting the Features Per Request parameter to 500, but the issue persists.I’d like to ask if anyone has experienced this issue before and what possible solutions or workarounds exist to efficiently truncate and update the AGOL feature service without running into request size limitations.Any insights or recommendations would be greatly appreciated!Thanks in advance.

Hello,So I have been trying to INSERT a ‘0’ value date using a FeatureWriter with MariaDB/MySQL compatible format into our MySQL DB, but I can’t seem to be able to do it. I keep getting the message the row is skipped because an “Invalid date/time value”.I have tried using many different values for the ‘0’ date like ‘0000-00-00’ , ‘00000000’ with and without the single quotes but I keep getting the same behavior. I’ve also tried using different types of fields (varchar, date, datetime) in FME (but always keeping datetime in the DB) and still the same.I tried using 00010101 and that one was accepted and it did actually loaded into the DB without problems. In the DB the field is Nullable and also accepts cero values, but I can’t seem to get it to work from FME.Any ideas?.Thanks in advance.RZ.-

Hi All,I am attempting to walk an FME script (using desktop 32 bit) over a large folder of specialised access databases called gINT files (.gpj) and move the data to various CSVs. However it will terminate after several hours with "MDB_ADO reader: An unknown exception occurred", and only write several of the CSVs for the files it has read. It works for smaller sample sets, so I don't believe it is a flaw in the script.I have a copy of the log, unfortunately it is a bit large to attach. Any help appreciated.Thanks-Jack Collins

Hello, I have seen similar threads but i cannot seem to get what i need to work. New to FME and I have a .img file with 1440 bands. Trying to rename the bands to dates as each band is a dataset a month apart. I have an excel spreadsheet with the original band names and the new names i want but after a lot of trying have not been successful.  Please could I have some help with this.  thank you 

I need help to make like something called monitoring directory.I have folder, its network based folder, and using FME form or FME Flow or both, i need to make next: Users will add CSV files in that folder, then that file or files will be add in postgreSql database.When users change file, it need to be changed in database too.When users add file , if the file with that name already exists in database  , it needs to be replaced with new one  

Hello, i am working on project and i need help.I want to copy multiple csv files from my pc, to postgreSql database.I have a folder on my computer and i want all files from that folder just to copy on postgre.I dont know how many files will be in  folder on pc, so i cannot predict, but they all have some column names sames, some diferent, and some of them even have diferent  number of columns  So basically, i have set up a reader in  FME workbench, in reader i selected which folder i want to read all csv files from, then reader is connected to schemaValidator , and that is connected on writer,  that wrriter should write in postgresqlMy problem is that, when i run that workspace , in my postgre database writer writes right names in right schema  with right data, but with columns from all files I need help, what can i do that if its exactly 5 files in folder that i read , that all 5 files in exactly how they are in folder to be copied on postgresql ? I have been try transformer FileCopy,