FME Form

Hello! FME newbie here 👋 I have 100+ Excel workbooks, each of which has 2-4 worksheets in them. To prep to do some schema mapping, I'd like to read out all of the attribute names to a new spreadsheet (Excel or CSV, doesn't matter). Could anyone give me some guidance on how to do this? I've played around with the following transformers, but haven't had much luck figuring out how to use them to do what I'm hoping to do:Sampler (with no header on Excel reader)AttributeTransposerFeatureReaderAttributeExposerAny help, guidance, or links that might point me in the right direction would be much appreciated!

Will FME work on a file-system-based control such as Visual Source Safe (VSS)?

I have numerous shapefiles in numerous folders. While I can parse through all of these and convert directly into a GDB I will have 203 separate classes. I would like to use the parent folder name as my feature class name. Each folder has a varying number of SHPs in it but they all belong to their parent folder.

Hello there we are a series of building points in each side of the road we need to move all the points to the same distance on each side of the roadActual Status   Target  

I have to read and process features in several File GeoDatabases and was going to use the FeatureReader to do so. I expect not more then a single feature class in each gdb, and you can see the parameters dialog in the following. It does not matter if I change the output ports from 'Single Output Port' to 'One per Feature Type', all the features in the feature class are read, but their attribute table only returns a single column, labeled <no schema>, while the Schema output port of the FeatureReader contains the structure of the initiator, and an attached ListExploder shows the correct schema. Yet, I do not get any attributes of the objects, due to <no schema>. How do I get the proper schema of the GDBs returned, so that I have the correct attribute values to work further?

Firstly, I have 10 .gml files and want to convert these files to cesium 3d tiles, then want to show this model with cesiumjs. However, in result of my workflow, I got several errors and warnings.1- I want to show my workflow in FME :2- I want to share errors which I get :Finally, This workflow has been completed, and then b3dm file and tileset.json have created. However, tileset.json file has created erroneously. For example, bounding volume is not created correctly.3- I got screenshot in order to examine:I want to complete these steps efficiently.Which transformators should I use in t

Hello everyone, I have a drawing in the picture. There are many polygons drawn on top of each other in this drawing. In some of the polygons I have extra drawings. Place 1 is correct, place 2 is correct, but place 3 is wrong. In a layer with grouped holes, I have a drawing on the bottom with the same shape, but some of the holes are hollow. How can I detect empty spaces? ( see ex. 3) 

Hello,I would like to make an FME Server app which allows the user to download data from Resources folder from FME Server (these files are html files generated by another automation).Now, in my workspace I am using "Directory and Files pathnames" to get the path to all these .html files located in different folders. I am blocked now because I have no idea how to continue my workspace to download the files. Any ideas? Thank youNicu

I'm inserting data into an Oracla Spatial with FME Desktop. I see that the data is written correctly when used or when I see SQL Developer, when showing that a resource is not designed by ArcGIS, but it shows that a resource is not designed correctly and does not open in ArcGIS, what will be done?   Thank´s

I have a set of lines and I would like to find the lines that intersect but where the end node do not touch. For instance, I have two lines L1 and L2, L1 touche L2 at the midpoint of L2. In this case, I would like to extract L1. Any ideas?@Takashi Iijima​ @jdh​  and others

I'm looking for the FME transformator equivalent to QGIS Minimum Bounding Geometry in order to extract the orientation (azimuth) of the feature shape. This topic is not relevant as it refers only to hull because the concern is about the angle of bounding rectangle, i.e. main direction of the geometry (polygon).

When running a Data Inspector to read a mvt tile ，I got Error message like this "No geometry mapping entry found for 'wkb_geometry_collection' in metafile 'C:\\Program Files\\FME\\metafile\\MVT.fmf'. Please visit http://www.safe.com/supportNo geometry mapping entry found for '%0' in metafile '%1'. Please visit http://www.safe.com/supportFailed to specify the feature index as constraints on the reader"I tried to use QGIS ,it works fine.  

I have a scenario where I have a CSV reader which reads in values of specific types. On occasion there is unexpected data in the input that does not match the type (such as a negative number where a UInt32 is expected, or character data where numeric is expected). The CSV reader generates a warning message and substitutes the offending value for missing or null, but I would prefer if it generated an error so I could terminate translation and look at the data myself to see if it is either bad data (which I need to fix) or if my input types are incorrect and need to be expanded. Reviewing the logs every time is possible of course, but sometimes the processes are automated, and sometimes I need the workspace to terminate on error before it gets to the point where it writes the final data. In these cases using the logs to check warnings isn't great. I can set the CSV reader to read in only string data, but I still want the type checking as a first data va

Hello Experts,I have two polyline files. Both have name attribute . The condition of validity is if the line name is in continuity then its valid, if not then its invalid.

Facing an issue while trying to connect Oracle 19c instance using FME 2020.2.3 with oracle client 11 and 10 and jdbc driver 5,6,11. We tried adding below lines in sqlnet.ora file but getting error like" no authentication protocol".

I am running into something I have not ran into before: I have an XML_fragement attribute with a WKT. For example (direct copy): POINT (154791.869730325 463171.926750512) When I use the geometry replacer, set to WKT, I get a rejected feature: INVALID_PARAMETER_GEOMETRY_SOURCE When I use an attribute creator, than manually paste the value (POINT (154791.869730325 463171.926750512)) and connect the geometry replacer to the new attribute it works flawlessly. Also when I try the featuremerger and merge on 'new atribute' and 'xml_fragement', nothing merges/matches. Why? They are exactly the same values (ctrl c + ctrl v), there is also no space or enter at the end of the value. FME Desktop 2022.1

I want to create multi-level JSON (nested) with a specific attribution. I have followed this article. I need to get this structure:Following the tutorial I'm not able to add more attributes to the top layer as is written also in JSONTemplater help. I need to get something like this:[{ "category": "kategorie1",    "caption": "A", "features" : [      {         "name" : "A1",         "rotation" : "0",         "bbox" : [ -733690, -1024463, -732733, -1023916 ]      },         {         "name" : "A2",         "rotation" : "0",         "bbox" : [ -733093, -1024114, -732939, -1023902 ]      }, ...   ]},{   "category": "kategorie2",   "caption": "B",   "features" : [      {         "name" : "B1",         "rotat

So, I'm looking at this question on StackExchange.The user has color blindness and has trouble reading error messages in the FME log, because they are colored red.I've filed an enhancement request and we'll work on adding those to our special color blindness theme.But, in the meantime I was wondering if we could do something else to help. They don't want to have to copy/paste the log to check for errors. So I was thinking perhaps a shutdown python script that automatically extracted error messages? Or even a script that just popped up a dialog saying "there has been an error"?Any thoughts? My Python skills are pretty limited. And yes, I just tweeted recently how I never needed them, because of FME. Ironic (or perhaps moronic) is the word you're looking for!NB: I'll treat it as a challen

Hi folksI am working on a database that has multiple fields that could contain a part of an address, I want to merge these fields and then split them into the specified fields eg House number, Street name & type, Country, Suburb, State and Postcode.  Some records may only have 2 of the fields populated whilst others may have all populated. I've managed to do this using a very convoluted sql script in the past but was hoping that there might be an easier way to do it in FME See attached for before and after   

is there any way to KMZ and Shape file reader get the link automatically when file or link change from website  for Examplehttps://www.nhc.noaa.gov/gis/forecast/archive/al012022_5day_latest.zipits today may be tomorrow file name change with lk015856.zip and anything is there and parameter if i need to use

I want to update an ifc file with attributes. For a reason I don't know, the element to be linked is not displayed in the ifc reader. That's why I created an extra Ifc Reader with Dataviews and linked the missing attributes via the Elementid. Then I linked the attributes of the Excel list with the added attributes. The output on the second FeatureMerger is correct. Only the ifc is not written correctly. What could be the reason?

I have a Autocad Dwg file which needs to be converted to imdf file format. I have an active Autodesk Autocad account to work with Dwg files. Please guide me on how I would proceed with FME on converting the cad file to imdf file.

Hello there we are using the staticImageFeatcher transformer in order to get a satellite image that fit the bounding box of vector the bounding box changes based on each vector's data is there any way to extract the right value for the  Height/width in the image to set the parameter of the staticMapfetcher dynamic? Thanks 

Hey community!Question: How can I intersect 3D building multipatch features with 3D lines? tnkx a lot!