FME Form

I am in the process of converting a large Excel file to separate JSON documents for each column in the Excel, keeping a common ID column that each JSON document must contain. The hard way of doing things is using an AttributeKeeper to preserve the common ID column that I need and the specific column that I want to make a JSON document for, with a separate writer for each JSON document. Is there an easier way to do this, similar to a Fanout but instead of grouping by rows of similar feature types I can do it by column?

The documentation for the counter transformer references parameters that are no longer available in the latest counter version. How should the new counter be configured to pickup the count start from another counter in the same workspace?

I have a workbench that reads multiple Microstation files, and for some of the files, I need to remove some of the cell's so they are not written, and I have done this. I then have to write all the files to one Microstation file.  My issue is the remaining cells are not coming through into the Micostation output file. Each file being read has a different cell library and I have not had any luck combining them to 1, for the writer to read. so in the documentation I read that  "the cell members are assigned a unique cell sequence number in the igds_cell_sequence_number. This number can be used to later regroup the cell components if that is required." But I can not find anything in documentation on how to regroup them. I would like to try this to see if it helps me once I expand the cells. Has anyone done this before, and can offer some help? As this is my first time working with FME and Microstation files

I have several polygons in my workspace and I want to consecutively clip a subset against each other (see attachment). Of course I can do that all manually but if the input changes, then the workspace has to be adapted each time. I thought of using the aggregator to have the features on "first level" with a list of all features of the second level. Next step could be a custom transformer with a loop. Do you have any other suggestions? I am also not to deep into custom transformers and looping, so any advice is welcomed ;-)

Hi,I have FME Server 2021.1.2 Build 21627 - linux-x64.I have a problem with the filter jobs by user.It's impossible to find some users. For example with the user "generic".It's very embarrassing... As you see, it's works fine in the menu User Management 

-Because while the new data coming from httpCaller should be written to AttributeFileWriter, first the file starts the parse process. In this case, it causes old data to be processed instead of new data. -If I delete this file from desktop then run the workflow from fme server;-Fme server run workflow and see engine logs;Why do it works first parsing file then httpCaller ? True way that is it gets httpCaller new data firsly and write to file.

Error: An error occurred while installing package 'C:\\Users\\<accountname>\\AppData\\Roaming\\Safe Software\\FME\\Packages\\21789-win64\\PackageFiles\\safe.emailer': An error occurred while installing Python package with 'pip install --force-reinstall --no-deps --no-index --find-links C:\\Users\\<accountname>\\AppData\\Roaming\\Safe Software\\FME\\Packages\\21789-win64\\PackageFiles\\safe.emailer\\python --target C:\\Users\\<accountname>\\AppData\\Roaming\\Safe Software\\FME\\Packages\\21789-win64\\python\\safe.emailer --upgrade --no-compile fme-emailer' : Process crashed. Done both as a std user or an admin. Same issue. Any assistance greatly appreciated.  

I have a very old file while contain contour lines. And then I obtained a new DEM from which I generated new contour lines. Visually I can see that between 2 files, the contour lines of the same elevation differ in distance and they differ from one elevation to another. Is there any way I can get a statistical result about max, min, mean between these files? And is it possible to visualize this?

Hi!, How to create geometry from x,y coords received in .shp file? we need to migrate these coordinates as geometry in smallworld. Thanks

related to https://community.safe.com/s/question/0D54Q00008q2P5rSAE/fmeserverjobsubmitter-unable-to-connect-to-fme-server?t=1638881772264

How to Identify if an intersecting route is from Left or Right . I have my routes data as polylines whichever which i am testing out. How can I achieve this in FME? Thank you!

On our machine running FME Server, we have both ArcGIS desktop 10.6.1 and ArcGIS Pro 2.7 installed.  When we run workspaces that require an ESRI license, FME Server can get a license, but pulls a license from the ArcGIS desktop 10.6.1 license pool (As shown below). The same thing happens when the same workspace is run in FME Desktop. 2021-12-14 01:10:07 | The ArcObjects license 'Advanced' is being selected from the Windows registry2021-12-14 01:10:18 | FME has checked out an Esri license. The product checked out is 'Advanced'2021-12-14 01:10:18 | Installed ArcGIS version is '10.6.1' How can I configure FME server to check out a license from the ArcGIS Pro pool? Preferably the advanced concurrent use license. We followed the step by step instructions for using ArcGIS Pro with FME server in this article without succes:

I am loading in a large address data set in CSV format The reader has wrongly classified my coordinate columns as "time". This causes the VertexCreater transform to add incorrect geoemtries When I click "User Attributes" on the Reader I cannot change the column type from time. Everything is greyed out. How can I best override this  

Hi FME altruist, I am a new member of this community and trying best to strive on using FME for my new job. In a task, I am asked to assign a percentage value (computed by area on area overlayer) of a parent lot to its child lot. For example, in this image, I have first dissolved the two child polygons (1 and 2) and computed the percentage value. But now I cannot assign the value to its child lots. I have tried different tools (e.g. SpatialRelator, NeighborFinder) that can return like 'select by location' and then create a field :)

I have FME Small world Edition license on my system but I am unable to read the data as it shows below error. Please help me with this.

Hi FME communityI have successfully added a web connection to my Sharepoint site following this tutorial https://community.safe.com/s/article/How-to-create-a-Sharepoint-Web-Connection using the Client ID multitenant method.Then when I browse the Site: parameter (image below) only a subset of all sites in my organisation are showing. My goal is to read files hosted in Sharepoint just as if they are sitting on my hard drive. Anyone have any suggestions on my issue above or know of an alternative way to connect to Sharepoint?Thanks

XMLUpdater is changing all " to " when I'm updating a single path within an xml document. Is there a way to prevent XMLUpdater from doing this?

MapInfoStyler parametersFor a Region, how do I set the Fill Background Color to be transparent?For example, Fill Pattern 30 is diagonal lines. I want the spaces between the diagonal lines to be transparent, so I can see the layer underneath.

I want to make sure that I have the same number of records in each group. What transformer to use? btw I want to preserve each record's attributes values as I want to write the records to a db later on.

Hi Everyone I have come across an ifc file where the Feature Reader does not find all IfcSpaces when reading a file.  Both ifc Viewers DeSite and Solibri manages to read the files, but the Feature reader loads maybe only a third of the objects. My suspicion is that there has been some post editing of the Ifc file by some third party software or created with a plugin EDM? EDM Software:https://jotneit.no/express-data-manager-edm Example of Ifc FileStructurehttps://essxnce.wordpress.com/2019/07/31/190731-searching-how-to-make-ifc-file-from-non-ifc-file/ If someone know how to read there files with success, please give me a shout out! If not, I imagine this needs to become a feature request to be able to r

I'm reading a number of json files each with their own set of records. I can see I need to expose many attributes but without adding hundreds of lines (the index goes to 142). Is there any easy way to go from screengrab below to web site structure at http://reg.bom.gov.au/products/IDT60801/IDT60801.94850.shtml:

Hi I would like to use a new line as a separator in the list concatenator but I do not know what I need to actually type into the separator box. The help suggests a sequence of Ctrl+Shift+j (^J) but if I CTrl+Shift+j, nothing happens. I have no idea about the ^J. I have tried pasting this in as text too but no combination works. Please could someone explain what the help file is suggesting I do? Thanks

Hi there,I have many roads (lines) and many areas (polygons) of a city. Within each area there are let's say 20 roads. Each road has a grade based on its condition stored in an attribute. I would like to calculate the average of this grade for all the roads within an area, so that I can compare the average grade for each area in the city. I have not yet found a transformer that can calculate the average in a way like this. Anyone got any idea? Thanks a lot in advance

I've been given some data - 10 KMZ files which seem to comprise multiple named layers (so over 70 in total) with only occasional data in the Name field, which I want to convert to TAB format. I'm struggling with it - below are 3 views of the data - in Google Maps, in QGIS and in FME Data Inspector. I also attach one of the KMZ files here. I'd like to generate a workspace to produce 10 MapInfo tables of points, lines and polygons, to correspond with the KMZ files and named as the KMZ files, but with an attribute column populated with the layer names, for example, "J Garden Terrains" (in QGIS appears to be the Layer names) and a Name field for the occasional data that has. The only way I can see of converting the data at the moment is to click on each layer in QGIS and Save As a MapInfo table. I'm sure I must be able to do this in FME - I hope so! If anyone can help I'd be very grateful. Thanks, Jane

So I'm trying to reproject the data in a DWG file from one projection using the ETRS89 datum (ETRS89 / NTM zone 11 [EPSG:5111]) to another (ETRS89 / UTM zone 32N [EPSG:25832]). I've set up a feature reader to read using the RealDWG reader to a single output port. I've set up a RealDWG writer from that same port, writing to a different coordinate system. I've tried three different versions of this: One without any projector transformer, just writing to a different CRS, one with the PROJReprojector and one with the Reprojector transformer. As far as I can see the results look the same from all three.  The input data is located nicely along a corridor as seen in the inspector:In the output fi