Transformers

Hello all,I have a problem with catching Turkish Unicode characters in StringReplacer and StringSearcher transformers. "\\w" function doesn't catch " Ç ç ? ? ? ? Ö ö ? ? Ü ü" letters. It works when I put these letters in the search bar. Also, I checked the same letters on www.regexpal.com and it didn't work too. Is there any solution to catch these letters with "\\w"? Otherwise, I need to change these letters with other special characters which don't exist in Turkish Alphabet at the beginning and the end of the Workspace. ThanksDeniz

Is there an easy way to populate an entire column (I have multiple columns) based on the value in that column that has a comma in it?Basically, if I have a column named pole and all attributes in that column have the value of "pole_status" except for one value that has this value: "Con, PLA, MRC, MRE". How can I populate the entire column with "Con, PLA, MRC, MRE".I've tried Attribute Manager using a Conditional Value to filter out all records that don't have comma in it but then I'm not sure how I can actually use the "Con, PLA, MRC, MRE" value as the output value. Maybe there's a better option. Custom Python might do the trick - but I want to exhaust all of my transformer options before I go that route. Note: I cant simply write "Con, PLA, MRC, MRE" in the AttributeManager since these values will change and there's multiple columns - si it wouldn't be sustainable I also know I can probably accomplish this by us

I am trying to troubleshoot why a cloud workspace won't run with data and I am getting this response from the server."request": "\\"DataProcessing/FieldDataLineCreator/FieldDataLineCreator.fmw\\" -XML_PARAMETER {\\"remote-addr\\":\\"127.0.0.1\\",\\"host\\":\\"production-tgs.fmecloud.com\\",\\"user-agent\\":\\"Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:59.0) Gecko/20100101 Firefox/59.0\\"}C:\\\\fakepath\\\\1801116-012618RF(TGS_Export_v2).csvhttps://production-tgs.fmecloud.com/fmedatadownload/DataProcessing/FieldDataLineCreator.fmw?detail=high{\\"opt_responseformat\\":\\"json\\",\\"SourceDataset_CSV2\\":\\"C:\\\\\\\\fakepath\\\\\\\\1801116-012618RF(TGS_Export_v2).csv\\",\\"detail\\":\\"high\\",\\"opt_showresult\\":\\"true\\",\\"token\\":\\"\\"} --FME_SECURITY_USER \\"\\" --FME_SECURITY_ROLE

Hi,I was wondering if it's possible to connect to Azure Stream Analytics and from the output, create a dynamic KML URL and/or a GEOJSON source to connect other applications to. If so, at what cost?Thanks

Hello,I have around 200 rasters (in ascii format, all in the same folder) that need to be converted into polygons based on a certain threshold pixel value (as an example, for one of the rasters the final polygon should include any pixels above 0.4). Unfortunately, the big issue is that the threshold value changes for each raster (0.4 in my example, but could be 0.5, 0.6, etc for other rasters). I have an excel table with the raster name and associated threshold value but I can't figure out how to make a workflow where the raster name is then used to lookup the matching value in the excel table and then use that value in the RasterExpressionEvaluator and subsequent RastertoPolygonCoercer transformer.Thank you for any help!

Hi everyone,  I was wondering whether anyone had strategies for automating the georeferencing process. I have a raster displaying parking lots and am trying to create a dataset that shows the painted parking space lines. In the past, I've manually drawn the parking space lines, but was wondering whether anyone had any suggestions on how to automate this process.Basically, I've been thinking about how to draw a rectangle over the entire area of the parking lot and then somehow divide the parking lot into a specific number of spaces. However, since each parking lot has a different number of spaces, I'm stuck on how I'd automate this process.Any ideas?Thanks

how tow convert dxf to gbxml

Hi, I just jumped into FME world and get stuck with it. I have a data file of location based network and need to do analyzing with it. The file looks like thisUserID VenueID VnueCat VenueName Lat Long Offsetminmute UTC Time470 49bbd 4bfds Arts & Crafts Store 40.719810 -74.0025 -240 Tue Apr 03 18:00:09 +0000......1. I need to convert the UTC into local time zone2. How can I create a new dataset with specific UserID3. How can I find any 2 different UserID which have same Lat, Long and LocalTime attributes and create a list of them come along with same attributes.I have attached a small sample of the datafile below. Please let me know if you need full data file

Hello,I have a complex xml file and have created a xfMap to translate it. However the reader terminated the whole process when it failed to translate one feature due to it doesn't have the required geometry info (Line0008 as in the code below).I'm wondering if there's a way in xfMap to handle errors by using something like try...catch or if..else. Or should I validate and fix the invalid features using something like xmlvalidator and updator before translating it using xfMap? thank you.<PlanFeature name="Line0007"><CoordGeom><Line oID="Line0007_0001"><Start pntRef="TPS0021">5813350.321246 317541.885870 2.430529</Start><End pntRef="TPS0022">5813350.289701 317542.164240 2.460172</End></Line><Line oID="Line0007_0002"><Start pntRef="TPS0022">5813350.289701 317542.164240 2.460172</Start><End pntRef="TPS0023">5813349.458068 317542.315624 2.497628</End></Line></CoordGeom></PlanFeature><PlanFeatu

Hi all, I have an oracle SDO geometry table containing multiline features. These features should be contiguous collections of point-pairs. i.e. all endpoints should touch another point-pair from the same feature. the features can form a string of point pairs ('~'), but also a 'Y' type of topology, or something more complex. However, the feature should not consist of sub-parts that are not connected to each other (e.g. '~ ~' ).How can I test for this requirement to be met ?I think I should somehow be able to count what Oracle calls the parts of the multiline object, but it is not clear to me if I can call these oracle constructs from FME, or what FME equivalent to use. Can you point me to some example or helpful bit of information for this type of tests in FME ?Regards, Ronald

Hello,I am trying to insert vertices at the end of lines, using the vertexcreator and 'insert point at index'.To do this I am using -1 for the index, but this adding the vertex at the point one before last (see image). How can I get the extra vertex to be at the end?Thanks, Owen

Hi, I'm executing the following queryselect 'PT' as TEST, sdo_geometry (2001, 9999999, sdo_point_type(1673919.702, 513986.296, NULL), NULL,NULL) as geom from dual;which returns (in sql developper) a geom value of MDSYS.SDO_GEOMETRY(2001, 9999999, MDSYS.SDO_POINT_TYPE(1673919.702, 513986.296, NULL), NULL, NULL)How can I add such query in sql executor so that the field geom will be considered as the geometry of the feature?  Rigth now there is no 'geometry' in the inspector   Thanks

I have two line datasets. Dataset A was created by using the snipper on dataset B (attributes BeginMeasure and EndMeasure), resulting in 15 segments in dataset A. They are both saved in SDE. Now I want to use the LineOnLineOverlayer to segment dataset B (only 1 segment before segmentation). I would expect that there will be 15 segments with _overlap = 2, and attributes from dataset A at each segment. Except that is not what is happening. There are only 10 segments with _overlap = 2, the rest are 1, which indicates that the two datasets do not overlap completely which is weird since A was created by B. I'm attaching the ffs for each dataset as well as the result ffs. What is going on and how do I fix?

Hello,I am starting using FME Workbench and it's amazing!A quick question as I can't manage to achieve what I would like.Basically I am starting with 2 features, Airports and Runaways. I have a OneToMany relations between those 2 features.What I would like to do is in that my final GEOJson looks like bellow, meaning that the list of my runaways with their properties + geometry if needed are nested into the Airport feature.I managed well using InlineQuerier to have the data I need and execute the join I need the thing I don't know is what is the flow to build properly the GEOJson as I want. { "type" : "FeatureCollection", "name" : "Airports", "features" : [ { "type" : "Feature", "geometry" : null, "properties" : { "someAirportProperty" : "someAirportValue", "runaways": [ { "someRunawayProperty": "someRunawayValue" } ] } }, ]}

I have a workspace that can generate a table with permutations of rows = 1 to x and rows = 1 to x to possibly create table variations from 1x1 up to at most 10x10 (see pictures). I'm looking for suggestions on how I can create images out of the table created. I'd like to see the format similar to the picture I attached. My 3rd sample is a 12x12. I'm using this pictures for a underground conduit inspection form. Sequence as well as matching picture matter to the users. Attached is my workspace to generate each table. I'd love to be able to create all 100 pictures using one workspace.

I have several hundred TIFFs that I want to load in to a File Geodatabase (FGDB) raster mosaic. ArcGIS allows you to load one image, then mosaic additional images into the same raster. I'm trying to do this with FME.So far, I have tried the following:1) RasterMosaicker, but that seems to create the mosaic in memory or temp before writing one huge raster to the FGDB.2) Read several TIFFs (e.g. select 2 TIFFs or specify *.tif in the Reader) and send to the same FGDB raster dataset (i.e. no fanout on the Writer) with Drop Table set to "No" for obvious reasons. This loads the first image then fails on the second with "ERROR |Failed to write raster data tile when writing to raster dataset 'TIFF2'. The error number from ArcObjects is: '-2147467259'".3) Using the Path Reader to get the TIFF names, then sending these 1 at a time to a second Workspace using the WorkspaceRunner (Wait for Job to Complete = Yes). The second Workspace loads the TIFF into

FME People, I'm trying to limit the number of source values I use in the AttributeValueMapper by using the following statement as my Source Value: @Value(LAYERTYPE) Ends With _Wd, In other words I have many different attribute values ending with "_Wd" and I want to reassign all of the those to one new value. The destination attribute ends up being an empty value. I moving data from SDE (oracle) to a file geodatabase.Gary

Can we write Xattributes to dgn elements in Bentley V8i Select Series 3 ?

Hi there,I have a table (lets call it TableA) which contains a field (lets call it Types). I need to compare each value in the Types field with ALL of the values in another field (lets call it OriginalTypes) which is in another table (lets call it TableB). If there is a match a value gets updated, if not nothing happens. Currently I have these 2 tables feeding AttributeManager which has a Condition Statement checking if Types In OriginalTypes but this is not producing my expected results. Any thoughts on what I am doing wrong here or what might be a better approach?Regards

I want to extract XFM data from the attached dgn file. I have tried using the Bentley Map V8XFM reader in both FME 2017 & 2018, but am unable to do so. I have exposed the igds_xfm* attributes as well. Is there a way out ?

I have a SystemCaller that simply deletes a file. I would assume if the deletion is successful, it would give code 0, otherwise 1. However, it always gives 0 whether the deletion is successful or not (for example, I keep the file open before hand to cause the deletion to fail). Any workaround? I could use PythonCaller to do the deletion and generate an exit code, but would be nice just do this simple operation in the SystemCaller.

Just want to convert from string containing fractional numbers (e.g., 4 1/2 2 7/8...to decimal doubles 4.52.875...Anyway to not use multiple transformers for this? ( I know I can separate the fraction from the whole number, then value map the fractional segment to decimal segments, and then patch the number back together via concatenation...). However, I thought I'd check to see if I'm missing something less bulky.Many thanks, Pete

I have a raster dataset stored in a file geodatabase and when I read this into a workbench the nodata bit masks for each band are merged into a single additional alpha band named geodb_nodata as default and stated in the help documentation.When I view the grid in the inspector Band 0 contains data values and a value of 0 or -3.40282e+38 for nodata cells. Band 1 (ALPHA8): geodb_nodata contains a value of 0 for nodata and 255 for cells containing data. My question is how can I set the values in Band 0 as nodata using Band 1 (ALPHA8)? I assume it's a combination of using the RasterSelector with the RasterBandNodataSetter transformers, but no combination has worked for me so far.Specifically, I want to set the values in Band 0 to nodata using Band 1 and then sending the output to a RasterCellCoercer transformer to create points for all raster cells containing a value i.e. excluding nodata cells.Thanks

Hi there,I'm exporting rvz files to a esri file geodatabase. When I want to open the multipatches in ArcGIS pro I have to adjust the elevation to make the features visible. In Revit it is possible to built storey /levels and give them a height or elevation value. How can I transfer Z-values to arcGIS and use them as an attribute field for the elevation source?  Thank you. I hope my question makes sense.

I am using FME to convert ESRI Raster Dataset orthophotos to an .ecw file and there are some very ugly black pixels added to the border.