Transformers

When running "my" workspace I get an error at the end of the translation, after writing the output, with the message: "Error running translation." No further errors are given. The tail of the output:==============================================================================Total Features Written                                                      32=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-Translation was SUCCESSFUL with 773 warning(s) (32 feature(s) output)FME Session Duration: 1 minute 10.3 seconds. (CPU: 40.2s user, 6.5s system)END - ProcessID: 1680, peak process memory usage: 320516 kB, current process memory usage: 172000 kBError running translation. The workspace converts a DWG to GML. It uses an Excel sheet for some mapping rules/lookup tables. Other DWGs do not have this problem, only two DWGs cause this. The DWGs are not corrupt, at least AutoCAD complain that t

I know this can be done, but can not find the right way:How can I add the current Date and Time in the name of the Log file?Preferred format is: YYYYMMDDH24MIAny help is appreciated.

Hey,Since a day or two I can no longer read my data. I always get the same error, even when I try it in another workspace. Does anyone know what it could be?I use FME 2021.0 and i'm trying to read a postgis table. ThxNathalie

Below is an example JSON response body for a single feature. What I want to do is extract all of the "points" elements (in bold) as a list. Which transformer should I use?How would I write the syntax to extract the detail in bold through a JSON query?Can it be parsed as an attribute? If so, how? {  "id" : "feature1",  "name" : "Feature 1",  "length" : "5,000 km",  "points" : [   {     "id" : "loc1",     "name" : "Location 1",     "country" : "CountryA",     "is_tbd" : null   },   {     "id" : "loc2",     "name" : "Location 2",     "country" : "CountryB"

Hello there, So I have two attributes: "Floor" and "Purpose". Floor Purpose1 Lobby2 Restaurant3 Swimming pool So I want to verify the dataset. If the "Floor" is 1, "Purpose" must be lobby. May I ask what kind of transformer I should use? Thank you very much.

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