Transformers

Hi,is there any way to replace ALL big letters for small ones?Thanks

hello i create some autocad blocks in FME wich must go to an autocad_od fileBut those blocks must be linked with two different object_data tables.and i dont know how to do with the writer.sometime the result is two identic blocs at the same placethe first one linked to the first table and the second to th secondwith other technics the result is that my block is only linked to one tableso i need helpthank you

When writing georeferenced object to Sketchup and having the option "Move to Local Coordinate System" set to yes, it makes the model rotate a bit.If i do not set this option, then SketchUp will not be able to handle the coordinate system so well.  The coordinate system i am trying to move from is Sweref991330.The aim is to have the shadows correct and the rotation correct. It seems i can not have them both. Can anyone help?

Hi,we did install the FME Caller Widget into our Webserver Portal to run the workspaces from FME Server there.Unfortunately we were not able to run them due to: "You don't have permission to access this workspace."We checked all permissions, repositories where are the workspaces and it seem to be everything fine. Also user names and passwords. when we create an Server App from the same workspace, we can successfully run it in our Portal.Anybody any idea? Are there maybe other things to think about?Thanks a lot 

Hi, I've got a GDB file which contains over 1 million polygons and I'd like to merge/dissolve every polygon under 3000 suqare meters into their smallest neighbours. I've tried to use eliminate tool in ArcGIS toolbox, it will only meger to the biggest polygons, not exactly what I want. Then I got it working by using Spatial Join and other tools, but the process took too much time, about 5 hours. So I'm hoping FME got some transformers can make this happen, at least some transformer like the tools in ArcGIS.Here's an example below, I'd like to merge the selected polygon into the one with 795.67m2 rather than the one with 9798080.13m2.@takashi

Hello, I would change the value of an attribute in a table depending on the value of other attributes group of records. Concrete example :INPUTNameColorAreaAAAYellow150AZARed56BDEGreen29ABABlue298CDEGray8AZABlack76ABAOrange84BDEPurple162AZAWhite65 Sort by "Name" and "Area"NameColorAreaAAAYellow150ABABlue298ABAOrange84AZABlack76AZAWhite65AZARed56BDEPurple162BDEGreen29CDEGray8 and give the same Color value as the record with the highest areaOUTPUTNameColorAreaAAAYellow150ABABlue298ABABlue84AZABlack76AZABlack65AZABlack56BDEPurple162BDEPurple29CDEGray8 Thanks for your help.

With MapBox Styler I can apply a color thematic to my data and view it how I want the output with an inspector. However, If I try rendering it with a Mapbox Leaflet in an HTML Report generator I lose the styling. Why?

Bonjour, Je souhaiterais ajouter dans le nom de mes fichiers de sortie le jour et l'heure du traitement. Soit : PO1_ADR_20200107_1021.csv CE1_ADR_20200107_1021.csv Adresses_ADR_20200107_1021.txt .....J'ai commencé en utilisant le transformer AttributeCreator placé en début de traitement avec en valeur de sortie : "@DateTimeFormat(@DateTimeNow(),%Y%m%d)_@DateTimeFormat(@DateTimeNow(),%H%M)" afin de ressortir l'information de la date/heure du traitement au format YYYYMMDD_HHMM. J'utilise ensuite ce champs dans le nom de mes fichiers en sortie.Le problème c'est que j'ai rajouté des traitements qui ont ralenti mon workbench du coup je n'ai pas toujours la même heure de sortie (les minutes changent). J'ai donc essayé de créer un Paramètre publié avec cette formule afin qu'elle ne soit lancée qu'une fois et utilisée pour toutes mes couches en sortie. En terme de paramètrage j'ai l'impression que la formule e

During runtime, I wanted to read the log file for messages that contain 'START - ProcessID, 'FME Session Duration', END - ProcessID' and a few other messages (in the red boxes) into my workspace so I can include each message as a feature in my translation.I can get most of this information from a shutdown script like below. However, I need the information back into my translation so I can write it to a database table that records translation metadata.# Import modulesimport fme, datetimefrom os import path# Get current date and timedateToday = datetime.date.today().strftime('%Y/%m/%d')timeNow = datetime.datetime.now().time().strftime('%H.%M.%S')print(dateToday)print(timeNow)print(fme.processID)print(fme.status)print(fme.elapsedRunTime)print(fme.totalFeaturesRead)print(fme.totalFeaturesWritten) 

IM trying to read a lmgrd9.log file, i can see most of what i need, but need to group the time stamps into 24 hour blocks and the assign the correct date to that to give a date/timestamp - Then i wish to join the OUT and IN with the user name to give a duration - this will end up in a powerbi report so can do some there.

Has anyone else had problems with writing to an Inspire GML with CRS EPSG 3035? For me, the X and Y is switched causing my data to be rotated and over the UK (should be over the Netherlands).

Hi all,I have a list of POI names that I'd like to abbreviate using an a Excel file that contains the keywords. I only like to abbreviate the words found in the string that match with the keywords - not the whole string.Basically what a StringReplacer does, but in bulk.Thanks, Eduard  

Hi there! I wonder if it's possible to create a list from a matrix, very much like how I'd do this in excel (see this tutorial). I currently have field names as below (there are actually 20+ years) and what i need is a separate record for each year. Is there a way of doing it? I'd do it in excel but it's not working for me for some reason - plus I'd rather incorporate it into my work flow. I tried the attribute exploder but this became a bit of a mess.  Thanks!ReneeDistrictIndustry (short)20172018201920202021Herefordshire, County ofAgriculture etc171.2176.9182.2187.9192.3

Hi there, I have two attributes (i.e. date and a field called wastage). Wastage is numeric field. I want to calculate the Running total of field wastage. I am using statisticsCalculator. I have attached the configuration of the statisticcalculator. Date is organised w.r.t. date. The problem is that calculated running total is the same for all dates (i.e. sum of all values of wastage). I mean it just calculate sum, its not the cumulative sum. Could anyone guide me where am I making the mistake? 

I tried attribute exposer to view the material properties of building element after I export to IFC from Revit. But, after I run FME it shows missing item in material name. How can I fix it?

I have a csv file with 55 attributes for each feature, I'd like to join only relevant attributes to various shapefiles (using FeatureJoiner). For example my Farm shapefile may need only 10 of those 55 attributes, my Buildings shapefile could require 20 attributes from the csv. For each shapefile I have an excel list of required attributes. How can I read in the main csv and filter it based on the xls - so only the attributes on the xls are passed to the FeatureJoiner?Have tried Attribute Filter, importing the xls but I can't see how to filter on this?Any suggestions?ThanksChris 

Hi,I want to reproject a raster but I'm not sure which reprojector transformer to use: Reprojector or CsmapReprojector??Can someone please tell me the difference and which is better for rasters?Thank you

Hello, I have a polygon geometry in that format:[[[(6.240171999999999, 50.590275999999996), (6.239148999999999, 50.5886), (6.238637, 50.58772), (6.238766999999999, 50.587680999999996), (6.239457, 50.587494) ]]](This is only a short extraction, I have around 10000 points for one polygon)What is the easiest to build the geometry and display it in the inspector? As I have around 10 000 vertices I don't want to do a split, create a list and vertices. Is there a shorter way?

Hello,I have vector 3D (vx, vy, vz) from some triangle.How I can transform/project vector 3D to vector 2D?

I have a workspace that has a Workspacerunner transformer. I find that the 'append to logfile option' works for this workspace, but not for the workspace defined in the workspacerunner. The logfile of the workspace in the workspacerunner contains only the last run, where I hoped the logfile would contain accumulative messages from all previous runs.Am I right about this and is there a workaround?Thanx again for any response!Regards,Pim

Hi, I want to set a normal vector for a plane (surface - roof)I have 3d buildings in 3DCityDB I used transformer "Triangulator" and I calculated the area based on "TIN Surface" and it's OK, but I don't know how to set the normal on surface? 

i have a map and it has too many devices and lines and lines connected to different devices and i want to know for specific lines ,which lines connected to which device and show me the ID of this device ( i mean at end of the line or start from this line should be connected to device )i want to know exactly which device is it ? and how many lines get in and out from each device . how can i write function for this line .Thanks

Hi, I have been asked to mimic the NORM.INV formula in FME which, in Excel, calculates the inverse of the normal cumulative distribution for the specified mean and standard deviation. I have the required values for the calculation (mean, random number and standard deviation) but unable to work out how to replicate it. Quite a specific question, but any help would be very much appreciated.Thanks, John

I am trying to use a conditional statement to update an attribute if it is null with the value of another attribute . However AttributeManager does not recognise the null or empty string . it does not work if I change the output to text or @Value(CaseOfficer) either.What am I missing here? 

Hi guys,I have a long line of points that are 1 metre apart. At roughly each kilometre point there is a value, but it is not exactly 1000 metres between these points (sometime more, sometimes less). I'd like to count each of the points in sequence between the values, and then have the count reset itself to start at zero at the next value. I've tried the Counter and it will give me a zero at each row with a value but will continue the count, not resetting back to 1.Any help will be greatly appreciated.Cheers, Dave.