Transformers

Hello there I have an attribute with values concatenated, I am looking to add character for each value Before Attributephoto1,photo2,photo3 looking to get this after : attributehttp://photo1/text,http://photo2/text,http://photo3/text

Can FME do a bulk rename of all attributes to combine the original name and the first row. See picture for example. The left side is the input. The right side is the desired output.

I am using FME 2018.1 32-bit and while reading an .accdb file, I am encountering this error "WARN |Microsoft Access Reader: The epoch time is out of range. Please ensure it is specified in seconds, and not in milliseconds or microseconds". Translation stops after this with a Fatal Error message. There are more than 2.5 million records in the table i am accessing. If I give a where condition an extract 100 odd records, it does execute. When i run the same Workbench in FME 2017.0 32-bit without any WHERE condition, it executes successfully. Any info on how can i troubleshoot this error ?

Hi I'm getting this error a lot: Resampler: Failed to process raster with invalid dimensions: 0 rows by 1 columns. This operation can only be performed on rasters with positive values for both rows and columns@ResampleRaster: Failed to resample raster to cell width '0.032' and cell height '0.032'RasterResampler_2_RasterResampler: A fatal error has occurred. Check the logfile above for detailsClipper_Raster (RasterClippingFactory): A fatal error has occurred. Check the logfile above for detailsA fatal error has occurred. Check the logfile above for details. I'm getting this in a workbench that reads tiff tiles and blurs some parts of them.The workbench works in most cases and sometimes I'm getting this error. Is it possible to detect which tiles are bad? 

Hello There During a cleaning process, our work space failld process due to the reader attributes with value are 0.we need to add a process to set the width and type of the atribute in order to avoide such issue

I am trying to upload an excel file onto GoogleDrive. However, when connecting the GoogleDriveConnector to my Reader, the transformer uploads multiple copies of the same document onto my drive How do I make it so it will only upload the one copy?

Hi! How to add custom 7 parameter geographic transormation (for example between MGI-C and WGS84)? Reason why i want add new transformation is because parameters in FME is not accurate enough for surveying purposes, so i want add new geographic transformation with official parameters released from state surveying administration

Hi all,I have in an excel sheet something like:I would like to determine the score according to my attribute value. So for example I hav an attribute with value 10 the score would be 1,5. The AttribueValueMapper could do this I know, but I would like to point to the excel so I can 'manipulate' the scores in excel and not in FME workbench. Is there a way to achieve this? Greetings,Arno

Hi, I upgraded FME Desktop on our Citrix environment to 2020.0.2 but as soon as I open any FME program, I get the following error: Licensing looks ok: Any tips on how to troubleshoot the installation? Thank you in advance!

How can I get multiple output based on unique attribute. I have 50 diffrent brand names in my input file & want to get 1 out for 1 brand, so for this input file I need 50 outputs.@david_r

Hi there, I hope anyone can help me, thank you in advance, Juan.I have an excel file where I define how polygons must be created .I have a Lines feature as spaghetti dataset, with an attribute feature name.The excel goes: Feature name / Feature required to make polygons Buildings / Buildings Sidewalk / Sidewalk, Building, Roads, Fences Roads / Roads,Fences,BuildingsNow I need to combine the excel rules and the spaghetti dataset to make my polygons?   

Steps to migrate data from intergraph gtech technology electric to fgdb.In Fme is their any gtech specific feature reader which makes migration easier.

Hi there I have a viewer https://maps.greydc.govt.nz/intramaps90/default.htm?configId=2f6f83a4-782b-45eb-9b60-d5819e718428 where I wish to extract the water assets including water, stormwater and wastewater. I would like some guidance in how I can scrape/extract this data. Can it be done?

HiDue to performance issues I had to roll back my fme from 2019.1 to 2018.1 (see post here).However, going back in versions appears to have thrown up a problem. I am trying to run about 5500 features through the AreaOnAreaOverlayer and it is giving me 80000+ features on the output. This was never a problem with the previous version (I was only getting about 7500 features output). Does anyone have any idea why this would happen? I've attached the log file if that is any help.Thanks for any help you can give.B

Hi, sorry for this newbie JSON extractor question but I am using the JASONExtractor transformer and I am trying to populate a column called 'Temperature' and populate it with the value, such as '50' shown below. My query is this: json["beds"].["Weather"].["Temperature"] but this and many, many other variations also do not work. Can someone please, please help me? [ { "id": 3009, "beds": { "Time": "Morning", "Weather": { "Temperature": 50 },{ "id": 2969, "code": "STPAL", "name": "Acme Co." }]

Hello,I have a DWG file with rooms drawn as closed polylines (all on one layer), and within each polyline, there are 2 text labels (on 2 different layers). I'm trying to transform these 3 layers into a single GeoJSON file, where the room polylines would populate the "geometry", and the 2 text labels would populate 2 different "properties" ('id" and "label"). I tried doing this using the FeatureMerger tool, however this doesn't produce the result I'm looking for, as the attributes from the Supplier ("id") are merged. The current result is that all the features in the GeoJSON have the same value for "id", which is not what I'm trying to achieve. I simply want to transform all the rooms to geometries and the 2 text labels to properties of the geometries. I'm sure I'm missing something simple, but is there a way to get the result I'm looking for? Here's a screenshot of my current workflow below:

Hi, I have a .obj file and a geotiff file, the .obj file is in xy space and the geotiff file is in UTM-48N projection. I am looking for a way to "align" and reproject the .obj file. Is there a way to reproject the .obj file to geospatial coordinates?

Hi,Is it possible to place 3D created objects with the creator transformer, on specific xy coordinates from a point dataset?Thx,Mark

Hello,I'm wondering about data showing in the Visual Preview.  Below an example. Two flows of data going to two Inspectors. When I select the SRC_RAW Inspector the Visual Preview shows the SRC_NORMALIZED data. I will have to use the drop down menu in the Visual Preview to retrieve the SRC_RAW data.  That has annoyed me for quite some time now - why can't I just select the Inspector and see the proper data straight away?      Cheers, Ed 

Hi FME community,  I need help to do one little thing: I have a request to simplify the geometries I processed with a tolerence of 0.5 meterThe geometries come from two tables and at the end they are saved as Geometrycollection (with aggregator).  Thanks for you help...  

Hi!I have a file with only one block put repeated a lot of time. Each block have a 5 labels with a different rotation for each of them.On FME, I change the name of the block and I add attributes. I have a template with the block for the writer.I succeed to export my blocks, but on Autocad, when I do the command BATTMAN, all my rotations are reseted. For me that don't work because the orientation is on the label, and the label of the block on the template have an orientation by default defined on the block.So I would like to recover the rotation of each label and put it on DWGstyler to keep these rotations.Fisrt problem : on the reader, the label is not join to the block.There are 2 differents entities. So I need spatial join on the workbench, but I would like to avoid it, because I should have to check each value to be sure that the join is correct.I try with exploding block and autocad_block_number to have an unique value on common but it don't work.Do you know an other metho

Hi All,I'm attempting to extract rendered data from a web page that is embedded in an ESRI dashboard. I'm in search of the map itself. I can get all the surrounding data from the attributes of the feature classes. I am in need of just the rendered map to put into a jpg, tiff, pdf, or whatever.Has anyone had any luck with doing such a thing? I've been working with HTTPCaller, ImageFetcher, ArcGIS Server and Portal Services (the real one is internal data, but this will work too for learning).Maybe use HTTPExtractor?If there is a way of extracting the map only, then I'd also be interested in being able to specify coordinates as well in order to grab specific areas of said map for other images.Thanks,Jazmateta

Hi!I'm trying to write a regular expression into StringSearcher so I can extract specific attributes. Those are numbers looking like this:1234/123 or 1234/1234I can't just use a filter with "contains /", because there are some other attribute values also with /. They have to be specifically looking like in my example (well, the numbers can be any). It's mainly the aspect and structure that has to be like this. Any help? I don't have much idea on how to write expressions...Thanks in advance!!

How do I copy the data in the Table view and/or export to a spreadsheet

Hello guys.What i am trying to do is to get tiles from S2 on AWS inside FeatureReader. So far so good but i want to adjust the range of dates by incoming attributes from another input (eg. Excel table). Start date is a specific date minus 5 days, and end date is the same specific date + 10 days. Everything seems ok till i click OK on the FeatureReader. Then i got this screen:So in the end of the day i don't have the start/end date defined by the incoming attribute. Is this somehow possible because i don't want any manual inputs in this flow. Thanks and keep safe!