FME Form

Hi, I'm looking for a way to generate a random 6 character alpha code. SequenceGenerator looks like it would work but it only uses numeric values.

I don't understand why I'm getting a failure to transform the projection system and save it in another format.jpeg - ecwundefined - 25830 

Is there a way to copy to excel user attributes table? I need to reproduce the table of writer attribute names, data type, width, value, precision. Figured there must be a way to extract those fast? 

Hi I'm using FME 2022.2.5 it crashes at the start and before loading the main window, sometimes it happens when I enable/disable cache. the issue with Qt6Sql_fme.dll ! appcrash event in the the log file.. anyone with helpful tips it does start after 5-6 tries. this log is from the start up crash------------------------------------------------------------------Felet uppstod i programmet med namn: fmeworkbench.exe, version 2022.7.45.22795, tidsstämpel 0x6424fcdc, felet uppstod i modulen med namn: Qt6Sql_fme.dll, version 6.2.4.0, tidsstämpel 0x6254adbaUndantagskod: 0xc0000005Felförskjutning: 0x000000000000edbfProcess-ID: 0x7968Programmets starttid: 0x01d98ca438014579Sökväg till program: C:\\Program Files\\FME\\fmeworkbench.exeSökväg till modul: C:\\Program Files\\FME\\Qt6Sql_fme.dllRapport-ID: 4320bc12-2030-4046-b3b8-63e036810fb4Fullständigt namn på felaktigt paket: Program-ID relativt till felaktigt paket: ----------------------------------------------------------------------------

Hi, i am using this structure to generate solid meshes from a LAS, extruding the point from x,y and z and then building the mesh of each small cube. But I found that the solid mesh was moved in the space (there is an offset) when I use cloud compare to viz it, and I don't know why it is occurred.Very grateful for the answer!! thanks:) ! 

Have and excel spreadsheet, roughly 90 mb, if II make a workspace that simply reads that excel file and writes it, the size of the written excel file by FME is about 179 mb. I am just using the defaults on both the reader and writer. If I open the file in excel and clear all cell formatting, and save, it drops the file size down to about 109 mb. Any Ideas why FME is writing a file that is almost double the size of the source file? and is there any way to clear out any formatting, assuming that is where the bloat is coming from ?

FME training and tutorials appear to be a 'spatial first' - ie they assume that any new user wants to work with spatial data. But FME is fabulous for non-spatial data as well and this spatial-first approach is overly complex and off-putting for new non-spatial users. Does anyone know of any introductory tutorials, videos, etc that teach new users how to use FME without dragging them through complex (and irrelevant to them) topics such as spatial formats, coordinate system, geometry processing algorithms, etc?Thanks

Has anyone tried using FME to connect CityWorks to Kronos time keeping? We'd like to have the time codes sent directly to Kronos instead of having someone manually enter them in.

Hopefully this doesn't ramble too much... I've been tasked by my Organization to standardize our development processes and implement clean, repeatable deployment processes across all of our environments. This means storing all of our integration configurations in version control (git), and being able to use pipelines to auto deploy to any environment at will. Over the last 6 months, I've built a PowerShell module that:Deploys Workspaces (if they have changed against the server version)Registers ServicesDeploys/Updates TopicsDeploys/Updates SubscribersDeploys/Updates PublishersDeploys/Updates Schedules The process is getting much better, but still has a few dependencies:A "sandbox" FME server environment, where all of our work is deployed manuallyDevelopers create a "Project" on the Sandbox FME server and adds all the dependencies for their integrationA workspace is run that exports that Project into JSON format, along with all settings, parameters and op

As you see, I connect separate inputs to the two duplicates of my custom transformer. But all the data goes into one of them. Why is it like this?

I'm using FME serverI got a dataset with only one feature inside.I converted it to fgdb with ignore schema selection as attached fmw.But the output is zero feature.It can be success if I duplicated the feature to make it become 2 features.The attached is dataset, log and fmwIs any other thing I can do on fmw for this situation

I want to loop number of times (22), so, created Custom transformer. Tried embedded, didn't work, so now Linked Always with fmx.1. Unable to work out whats the issue, it works if just run for only one iteration (test purpose), so, seems no issue in both main & fmx (custom). 2.But an issue to loop, or going to next iteration 3.Could not change CustomTransfomer>Transformer Pramaters>Advanced > Maximum number of iterations or Attribute to holdl iteration count !? 4.However, I have used 'LoopRecs' for iteration from main to loop transformer and added 'MyCounter' for loop test. 5.Please note, added sampler, just to run 3 times for testing, but actually wanted to loop based on 'LoopRecs' variable, which is passed thru main to custom. Whats issue here ? I have spent a lot of time figuring out . . is this a bug ? tried to get help from our FME tech support here , no response.. Can anyone help PLEASE , getting really frustrated to figure out the issue ! 

I have a workflow that needs to run completely offline, where the customer wants to be able to navigate using a map, and then once at a given location, click on a feature on the map, and pull up a specific model in an AR environment to illustrate what the future conditions at that site would look like. The model would need to be geolocated/anchored for a simplified experience for the user.   It would be very easy to create a url within the mapping app to send to FME AR (to include the model name, even an insertion point, etc.) I am curious if FME AR supports a deep linking capability that many other mobile apps support. I cannot seem to find any documentation on this topic, so any insight is appreciated.

Greetings,My Spatial Transformer is not working, none of the records are captured.The ListExploder fails, the error message is: MISSING_PARAMETER_LISTAny advice to capture the List?? ThanksClive 

The problem I am facing is I cannot figure out how I can send Answer value for Observation Question to the FME Server. I have been using this syntax: {"Address":"~~Location~~", "InspectionId":"~~InspectionId~~","Observation_Id":"~~ObservationId~~","Facility_Id":"~~Facility_Id~~","AnswerValue":"[~~AnswerValue~~]"} Also, I can find API documentation for the InspectionAnswer, but I am having trouble setting the right Syntax, so it will send Answer Value to the FME Server. Can someone help, please?Thank you

Has anyone worked with spatial indexing using GDB/SDE as output format? The spatial indexing function only appears for SQL Spatial formats. Any response is very much appreciated. Thank you!

I tried to create a global temp table in an SQL database to bypass limited database privs. Here is my FeatureWriter setting:No errors were given, but the temp table was not created on the SQL server tempdb. I tried using the fully qualified name tempdb.dbo.##MyTempTable for example to no avail. Appreciate any suggestions! 

I have an FME workspace in which input from an DWG file is read and exported into an FGBD file. I am using a dynamic FeatureWriter. For the layers, this has the following result: If there is a layer named 'xyz', and this layer contains e.g. text, line, and point features, the FGDB writer will create three layers 'xyz_text', 'xyz_line', and 'xyz_point' for the features. Is there any possibility to tell the FGDB writer to group the layers such that in e.g. ArcGIS Pro, all the layers 'xyz_text', 'xyz_line', and 'xyz_point' are already grouped below a parent layer/group layer 'xyz'? Or is this something which necessarily has to be achieved by another tool, e.g. using ArcPy?

hello, I'm having several java.lang.NumberFormatException: warning when writing to MS Azure SQL database. It does not prvent the workspace to run properly however, it create a very long log file with hundreds of thousands of warnings. Is there a way to correct that so that I won't have such warning anymore? Thanks

How can I calculate in FME the mean amount of a layer in a given distance (from another layer)?

Hello , i have many excel files and each excel file contains name of table and name of relationships table .some of relationship tables are common in different excel files .i would like to create pdf and draw the relationships of all tables in all excel files as example :at one excel file contains :First column table name : Product Second column contain relationships tables : table Name | relationships tables product |xx |yy |zz |kkAt Second excel file table Name | relationships tables client | cc |zz |aaAt third excel file table Name | relationships tables big |xx |bb |yy |ffmy target to create pdf and connect all table names and relationships table together I have no idea ,how to build pdf as data model to make it easy to show all tables connected together fme 2021  

Hey there. I'm going through the FME academy course on becoming a certified desktop & server professional and I'm running into an issue with the training when I get to exercises. My organization only has FME 2019 since that's what our server is currently running in, which means that whenever I download an exercise the format is for newer versions of FME (2022+, I believe). Some transformers are preserved whenever I open the files, but others are not (AttributeManager is always incompatible, for example). Are there ways to access older modules for the same course that I can use, at least when it comes to the exercises?  Thanks!

 The  excel "xml spreadsheet 2003" based on SpreadsheetML (XML schema for Microsoft Office Excel 2003)

Source

Unable to use Windows/IWA to login to FME Server Web Interface. Have followed all the steps, ensured the SPN is correct, ensured the service account is set correctly, done all the browser checks, and confirmed the Tomcat properties are right.Going to the URL <server name>/fmetoken/sso/generate throws a 403-Forbidden with a description "The Server Understood the request but refuses to authorize it". Going to the URL <server name>/fmetoken allows me to generate a token by using userid only. Adding the domain to the front of the username causes the token generation to fail. So it appears that it's something tied to the domain and how the users credentials are being passed but that leaves me unsure of how/where I missed a configuration that strips the domain during passing of the credentials in order to get a good token returned.Here is the message that appears when attempting to login:Here is the message from the sso generation