Transformers

I have got a school's spatial data (point data) with capacity information in the attribute table. I have set up the Transformers to allocate the students to particular schools. But after allocating, I need to go back to the school's data for the next student. But after looping back, the data should show 1 less number in the capacity (because that seat got allocated to the student).  I am stuck here on how to go back and start the process again with reduced capacity.  Datasets I am usingSchools Feature ServiceMaster Spreadsheet with Students Data Thank you

I need these translation log info to be part of my translation canvass so I can include them into the header of my report. I used to have this solution in place but I'm hoping to find a more efficient way to include the info in my canvass and not the shutdown. https://community.safe.com/s/question/0D54Q000080hedASAQ/using-the-processid-and-timestamp-as-my-log-name-failing-on-rename-with-py3x-but-not-27  

I'm setting a variable via a variable setter as one of the first transformers in my workspace (after an sql creator) so I'm sure the variable is set.However when fetching that same variable downstream in the workspace in a custom transformer (or a custom transformer in a custom transformer).The value is empty. I'm pretty sure that the variable name in setter & retriever is exactly the same (see screenshots). I've tested it by setting the first transformer in my custom transformer to be the VariableRetriever, but the output is empty.I don't cache the data so it's not related with data caching. If I do a VariableRetriever in the main it finds the variable. When I do it in a custom transformer it doesn't find it. What am I overlooking? In other workspaces this works without an issue

I have a chain of workspaces (connected with workspace runners) and would like to set a few initial settings, from attributes, that are to be carried on through all the child workspaces, also in and out of custom transformers.Example: Say I want to fetch a scale setting from dataset Z, and then not use that source any more. This attribute can of course be saved to a separate "settings file" and be used in the child workspaces. But how do I set values on transformers that are not "naturally" connected to the settings file? I have been trying to get user User Parameters to do the job, that works sometimes, but requires extra steps in custom transformers. And sometimes I can't get them to work at all.What is the best practise in order to get this working? And what are the unintuitive settings that one needs to know about beforehand?

Hi, I am writing to a Non spacial SQL Database, using a FeatureWriter.When INSERTing new rows in the table, a UniqueID is created by SQL database.Is there a way to retrieve that UniqueID after INSERT completed sucessfully ?I would need the UniqueID for the next step of my Workbench.I do a SQL Executor to select the last inserted row, it will work, but, if multiple rows are inserted simultaneously, there is a chance that I won't get the right UniqueID. Any Idea ?Thank you.

ho un dato vettoriale in cui per ogni entità ho diversi valori e devo prendere il dato con il valore massimo

I apologize if this has been asked before but I couldn't find anything related.I have a csv with the following data:With no header names. And I'm trying to get the following:I'm not sure which transformer to use, I thought BulkAttributeRenamer could help me here but I can't manage to make it work.I appreciate all your help before hand.

I am trying to transform a the KML within a KMZ file to MapInfo format using gentrans. The following works in the CMD:"C:\\Program Files\\MapInfo\\Professional\\UT\\fme.exe" GENTRANS OGCKML "D:\\Workplace\\Projects\\Acciona\\MI_read_KMZ\\testing\\UT\\PARQUE1.kmz" MAPINFO "D:\\Workplace\\Projects\\Acciona\\MI_read_KMZ\\testing\\UT\\tab"  I have used FME GENTRANS GUI GENERATE_CMDLINE to generate a command line. If I run the result on the command line with: fme.exe gentrans <generated commandline> it fails. The command line I use is the following:"C:\\Program Files\\MapInfo\\Professional\\UT\\fme.exe" GENTRANS OGCKML "D:\\Workplace\\Projects\\Acciona\\MI_read_KMZ\\testing\\UT\\PARQUE1.kmz" "RUNTIME_MACROS,\\"KML21_LOG_VERBOSE,No,KML21_RASTER_READ_MODE,GroundOverlay,KML21_SCAN_SCHEMA,Yes,KML21_FAIL_ON_NETWORK_ERROR,No,KML21_DELETE_DOWNLOADED_FILES,Yes,KML21_TRAVERSE_NETWORKLINKS,All,KML21_MOVE_TO_KML_WORLD_COORDSYS,Yes,KML

Hi,I am creating a table in Oracle SDE with FME. Is there to uncheck the Allow NULL property of a field via FME Desktop? Or even a way to uncheck it after the table is created with FME within ArcGIS Pro Catalog? See screenshot below. Thanks, Annette

Is there a way to automatically set the datetime within a parameter and use it to fanout a dataset so that does not then create a folder for every minute the workspace was running.  I just want the initial date time the workspace was run. The default date time parameter is not really ideal for this as it defaults to midnight and requires user input. I'm hoping to not have to use a workspace runner. Using DateTimeNow seems to create multiple folders as the outputs are written.

So far, I tried two approaches.Read pointcloud--> extract bounds-> tile point cloud into 1mx1m raster-->extract number of points per point cloud-->sort the number of points--> aggregate the number of points into groups-->write to csvread point cloud-->extract bounds-> calculate density by PointClouddensityCalculator--> rasterCellCoercer to extract the number of points into z--> coordinate extractor to get 3d points--> aggregate z (which corrsponds the number of points-->sorter-->write to csvThe problem with both approaches: it takes a lot of time (more than 1 h) . Does anyone have an idea how I could calculate the density quicker?I add a screenshot of my workspace.I appreciate any help. Thanks in advance!Kind regards,Ingrid

Hello everyone,I'm very new participant in this community and FME as well. Please can everyone help me to convert data from .gdb files to .xml file I would be very grateful if someone could write me the steps and some of the important details in the transformersInput (reader): geodatabase file (with extension .gdb). For example, this file can be read in ArcGIS ArcMapOutput (writer): one .xml file Thanks in advance.

Hi, How can you see if a line is a multiline or a polyline?I have a shapefile where i have both but it's creating problems so i have to detect the multilines en make polylines of them.I would think that i should use de deaggregator?

Hi all, I'm using the AmazonAthenaConnector to query an Athena database.In the Translation Log I'm seeing:  "2023-03-10 09:04:27| 6.1| 0.0|INFORM|AmazonAthenaConnector: Query ran successfully. Run time: 5.225 seconds. Data scanned: 27694.09 kB" I'd like to use the info on the file size / Data scanned to do some cost calculation. 1: Is there a way to incorporate the output of the Translation Log as attributes in the workbench? Alternatively I guess I could load the .log file in a workbench and use that for the calculations... 2: I am wondering , can I run the main translation AND the .log file in the same workbench? (wait for the main translation to have finished so it can read in the log file and perform operations on that.)   

I plan to use this method after a transformer "AttributeFilter".So the the number of cases the valeu of an ttribute varies define the repetition number the transformer . 

Morning all,I have points (A) at the intersections of streets/lines. Also I have points (B) scattered everywhere. I need to keep location points A at intersections but would like to bring attribute information from points B. Point A can get all other points around it and stacked at this location.

Hello everyone.I used this tutorial in order to convert 2d Polyline with Z value (for example, polylines of rooftops), in order to transform them to 3DML file.I succeed to do that, but I have a small problem.The exported 3dml's height is penetrate the terrain surface because the FME don't know what is the absolute ground height. The question is how can I fix this problem? There is an option maybe to insert height surface? (You can see that the problem may accrues because Extruder don't know what is the absolute ground height)  This is my schema:  Thanks a lot! 

Hi,The listsearcher makes it possible to search in a list for a certain value on 1 Attribute.Is it possible to do this (without listexploder) to search in a list for values on different attributes?list example:_names{0}.LC = Arabic_names{0}.NA = Latin_names{0}.PN = true_names{1}.LC = Arabic_names{1}.NA = Arabic_names{1}.PN = true I want to search in names list where PN = true & NA <> Latin and get that indexback. In this case it would be 1If it's not possible in FME, how would I do this via python in FME then?

Hello.I've read in 52 gpkg files into one featureReader. I now want to translate the 52 gpkg files to 52 tab files. But to avoid creating 52 separate featureWriters I want to do this in one featureWriter. Is this possible? If so, how? Thanks.

Hello, could i get some tips for Validating IFC files.

I am trying to reproject coordinates that are in NAD27 to NAD83. I am not sure about what I am doing wrong?I am using the FME Desktop 2021 version.

I am using an HTTPCaller to return some XML which I then want to turn into attributes. I can extract the Project fragment below using the XMLFragmenter (with Projects/Project in the Elements to Match parameter) but I haven't figured out how to directly extract the children into fragments or directly into attributes. Using Projects/Project/* doesn't work. For instance, I want to extract ProjectNumber and Status more directly into attributes. So far my solution has been to use a StringSearcher and SubstringExtractor to get each attribute. That's a tedious way to do it. Any advice on a better way? <?xml version="1.0" encoding="UTF-16"?><Project ProjectId="508DKDS6B2KA" ProgramId="YAK0C5V4UNVH" ProjectNumber="EST-00001" Status="Cancelled/Archived" StatusTimestamp="2021-04-01T12:23:55-06:00" LastChangeTimestamp="2021-06-29T14:15:01-06:00" ></Project> 

Does anyone have an example of how to successfully write out to 12d XML? 

I have a polygon .kmz over a portion of New Jersey USA setup as LL-WGS84. I need to create a 3m x3m grid across the polygon. I am using a Reprojector to *XY-MT* and then a 2DGrid Accumulator to build the grid. The resultant process only creates 1 grid. What am I doing wrong?

I haven't changed anything to these Excel writers, but after having added some transformers to the workspace they suddenly all start writing to column E instead of A. Even after having disabled the new transformers they still do that. I can't find any setting explaining this (I haven't set a start column, for instance).