Transformers

As input I have a csv file. The column names are dates. I use python to download it from an ftp and then merge with a spatial dataset to create polygons. I usually update an AGOL service but I don't know how to update an AGOL service if my column names (attributes) are changing daily. This would require to delete and republish, but FME cannot publish a service, can just do an update. Any help is greatly appreciated!

the ultimate goal is to have two outputs, the selected line or lines based on an attribute value and the neighbouring/adjacent lines within a 100m buffer. So am wondering what would be the best way to loop through the million records selecting features by attribute value then run the process and then the next batch so on ...? any help in decoding this will be highly appreciated.

Hi! For the transformation of a big data set I used the tiler. I now want to run the translation by picking one tile after another (run them sequential) but write the tiles into the same writer after the calculation,is there a tool I can use to fix this?

Dear Community, I would have a few questions for CityGML building.  I have a SHP file with building polygons (roof, wall, groundbase), and I would like to build a proper cityGML file. I read over the whole forum and also CityGML specification, but there is no description, WHICH attributes MUST be defined in case to have a proper CityGML output WITH geometry. In some of the forum topics here, there were good spots, and sample workspaces, which can be used to build simple buildings, but to build from SHP polygons, it's seems though for me. I'm trying to build a LOD 2 model. I have my walls, roof, ground, and the whole thing aggregated together (So I have the exterior shell and parts separately) They all have unique parent ID per building, set LOD name, feature role, geometry type and other attributes, which I found set inside related questions in this forum. But when I run the translation, I always receive a data set with no geo

Upgrade: If we're only upgrading from 2021.2.0.1 (21789) to 2021.2.1.0 (21797), do I still have to have my DBA wipe out the tables and create new?

I have a shape file which has several names in it. These names comes under 6 departments. So i want to create an attribute named as department. I have the csv file where it is mention which name comes under which department.

Overall goal: Pair-up respective wall lines from a CAD drawing floor plan.Challenge: NeighborFinder will return most wall lines properly, but if there is a condition of 4 equidistant lines, the interior ones will be picked twice, one on each side. I want to have 2 discreet pairs: For context:After trying FeatureMerger in various ways, I think that a loop is my only option. Here is what I have so far:What am I missing? Thanks,@larue​   

I am able to create separate Excel files for each data source processed in the batch routine (consecutively), but can't figure out how to append the output of each translation into one file. The schema is the same throughout. Thanks, @larue

Hello!I'm trying to use the following to find the position of a character/string in one of my attributes:@FindString(@Value(ColumnName),TEXT,1,caseSensitive=TRUE)When I replace TEXT with the text I am searching for, this works as expected, except for when the text to be found is a parenthesis, i.e. ( or ). In that case, the function interprets the parenthesis as the start or end of the function's arguments. I tried to escape the parenthesis using a forward slash (as suggested by the FindString() documentation to escape a quotation mark) as well as by surrounding it with quotation marks (as suggested by the FindString() documentation to escape a comma), but neither of these work.How can I properly escape ( and ) inside the function arguments?Thank you!

FME Desktop 2020.0.0.0: What is the best practice to fix issues identified by “geometry validator” tool? For example, in the screenshot below, I got 1 failed, 4 invalid, 5 locations. What could be the best practice to fix them? The data is attached      

I have a workspace with a single 3D model (a tree) and a point dataset of several thousand points. Is it possible to replicate the 3D model and geo-reference it for every point?

I'm trying to schedule a flow based on an end user's chosen start time (which they'd pick and submit via an FME Server app). To do this, I've built two flows: one that takes all the parameters (including a scheduled start time) and has a server app built in front of it; and a second one that actually does the heavy lifting and is either called via a webhook or is scheduled by FME Server. I've tried to be clever and set a HTTPCaller at the end of the first flow to initiate a new once-off schedule in FME Server, but it's always failing with this error message: "message": "Unauthorized request by user admin due to lack of proper permissions or the object does not exist."Any ideas? Or even thoughts on better ways to do this? 

Hello. I am trying to run a bunch of online and zipped INSPIRE GML's through a Feature Reader with the dataset parameter set to a URL defined in an attribute.  All is good and stuff is happening for most of the data except the URL's that have a space in them, for example: 'http://www.catastro.minhap.es/INSPIRE/CadastralParcels/02/02024-CASAS IBAÑEZ/A.ES.SDGC.CP.02024.zip' And those get sent to the reject port with the error message: XML Parser error: ''Error in input dataset: 'URL' line: 1 column: 50 message: whitespace expected'' I did check out this one here:

Hi,I'm looking for the best way to combine raster-DEM data with construction point cloud data (exists only at some places, not covering the whole DEM ) to output a new modified raster DEM. The point cloud data contains vertexes from the construction (which means it also has ground points - but I'm only interested in the surface, where it overlays the DEM). The point cloud has no info saying what type of point it contains. Can this be modeled in a way that only uses the surfaces from the two datasets or do I need more steps than one in this analysis? Any suggestions?

I have polygons on wich I want to calculate some edges infos. However, I want to do the calculation on generalized edges and after bring it back to all orignal edges. For instance:Polygon -> edge -> generalized edge -> chopped to 2 vertices lines -> calculate attributes on lines -> merge attributes to original edges Is there a way at the end I could merge attributes from the generalized line segments to the original line segments? 

It seems as though the SchemaMapper is setup for only If-Then statements. I'm wondering if there is perhaps a way to use the SchemaMapper by way of a Contains statement.  For example, if Attr1 contains 'xyz', make Attr2='123'. I don't believe this is possible, but was curious if anyone found a work-around to make it work.

Hi. I have a xlsx file with a field containt Path to a PDF. I want to validate if the PDF of the path exist. Can you help me. Thank you.

Hello, I am attempting to test if an input date exists between a date range - I'm struggling to find the correct syntax or transformers to do this (after 40 minutes of trying). Can anyone help? Currently my input is to AttributeCreator the time for now - @DateTimeFormat(@DateTimeNow(),%T)Then so far I have used a Tester to see if it was greater or less than two times e,g, >= @DateTimeFormat(09:00:00, %T) OR <= @DateTimeFormat(09:05:00, %T)But predictably this doesn't work as it will always be greater or less than one or the other. I would like to use BETWEEN (if I was using SQL).Is there an efficient way to do this in FME? Other than converting the time to a number (which would mean regex-ing the leading '0' up to midday) and then comparing numerical values in a (presumably) AttributeRangeFilter?Apologies if I am missing something basic! Help very much appreciated 🙇‍♂️ 🇬🇧

Hello, here is what I am trying to do in a workbench that is attached here:1) Input data are .xyz file with a list of 3D point coordinates, jpg + jgw files with DEM photo2) I need to create surface TIN + set an appearance to it3) I need to export it into a format that Trimble Connect is able to process.(https://community.trimble.com/viewdocument/supported-files) - There is a list of 3D supported formats The problems that I run into:1) Data need to have a defined coordinate system.1) I need to create a FME Cloud app, where customer is able to run this transformation themselves. 2) The formats that Trimble Connects do not support textured surfaces / solids3) FME Cloud does not support many writers that Trimble Connect would be able to process D

Hello, I am trying to convert text strings like Jan-2019 to date . The text strings don't have the day values. I have tried using DateTimeConverter transformer and the date time functions in AttributeManager but it doesn't work when I specify %b-%Y. However, with the DateTimeConverter, when I convert text values like Jan-05-2019 using %b-%e-%Y , it is correctly converted to 20190105 .  How can I achieve the same to convert the dates like Jan-2019 without the day value to 201901 ? Thanks

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?

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 ;-)

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 need to convert dwg to pdf and one of the line styles is "- x - x - x - x". I can create different dash line but not sure I can add x in between dashes. I hear there are possibilities of either converting it to raster when writing or keep the vector form. I would love to get some idea on how to do both. Thank you!