Transformers

I have an xml with my metadata profile and another xml which matches my profile and have data but not all metadata elements are present.I need to get my metadata profile filled with the metadata information in my second xml.This is what I've done so far:I have 2 XML readers each pointing to each xml and with "Elements to match" parameter set to MD_Metadata (the parent tag). I've set my profile xml into the Document port of an XMLUpdater transformer and my second xml into it's Update port but I don't know what to do next. What should I set in the Updates section?EDIT: I'll try to expand my question a bit more.On the left you see a very simplified version of my metadata structure (my master XML), and on the right you have the xml I want to obtain completing my profile with the data I actually have (center xml code).As you can see there may be repeated xpaths, which make it a little more tricky, at least for me.The XMLUpdater transformer seems the way t

Hi,I'm trying to send an email with an attachment where the attachment comes from a shared resource.$(FME_SHAREDRESOURCE_DATAADA)/Rapporttoattach.xlsxI'm using this workflowI receive the email but without the attachment. The shared resource does exist. Any ideas on how to troubleshoot why the attachment doesn't arrive?Thanks,Annette

Hi,I am trying to insert a record into a table when the workspace starts and before any features are read to indicate the job has started. I couldn't get it to work without using a workspace runner workaround and I'm wondering if anyone could spot why.SQL statement to insert:INSERT INTO DM_GEO.NG148B_PROCES_LOG (WORKBECH_ID, RUN_STATUS, WORKBENCH_NAME) VALUES ($(WORKBENCH_ID), 1, 'Clipper_Perf_POC')Attempt 1: SQLCreator added to workspace. Record is still inserted after all the records are read and processed.Attempt 2: Use SQL Statement to Execute Before Translation - this doesn't work as the SQL statement is executed before the first feature hits the writer and it seems after the records are read.Attempt 3: Sample one of the features from the first reader and use a SQLExecutor. Record is also inserted after all records are read and processed.I've read about how multiple SQLExecutors and Creators can be ordered but this doesn't help here.Any thoughts woul

I'm very new with FME and there's a few things I cannot get to work.I have a feature with an URL as an attribute and it's like this: http://serverName//document?searchText="section3"&start;=1&max;=1&f;=pjsonI want to read the JSON in it with it's attributes (which I don't know) separated to do something with them.I've been playing with some JSON transformers like JSONFlattener and so on, but I can't get the JSON.Any idea?

I want to read 3D geometry definitions from a new file format not supported by FME line by line, and create 3D AutoCAD geometry. For example, I have geometry definitions for cone, base center, point coordinate, etc. Is there an example of how to read the file and pass the input to the DWG writer?

Hi, I have an area featureclass without gaps or overlaps. I use the Generalzer within FME 2018 Desktop Beta to change the scale. To "preserve the Shared Boundarys" this Parameter ist set to "yes". However some areas are split in two parts by the Generalizer as documented in the attached screenshots. I do not want to alter the count of the areas. I tried other algorithms and parameter settings. Same outcome. Any ideas? Thanks Herfried

Im trying to extract geo-coordinate information from a BIM model, with the intention to plan a drone path using these coordinates. Can safe FME help with this, if yes then can you tell me how. Thanks.

I'm trying to process MODIS data that is provided in the Sinusoidal projection. The World Sinusoidal projection that is provided in FME Workbench doesn't seem to be the same, and I can't figure out how to set it for this data. I don't want to use GDAL to do it manually as there are quite a few hdf files.After scouring the internet, there is a reference to the following proj4 string on StackExchange:"+proj=sinu +R=6371007.181 +nadgrids=@null +wktext"However, I'm unsure how to utilize this in FME. Is there any way to use a proj4 definition in FME Workbench?

Hi all, FME amateur here! I'm trying to increase the performance of my model. The performance is vastly improved when I use the Group By setting and Parallel Processing in my SpatialRelator. The SpatialRelator is followed by an Attribute Creator which uses a conditional query (combination the number of related_candiates and dataset name) to set a value. Without the Group By and Parallel Processing FME will correctly tell me the number of related features in the related_candidates field. However when I put the Group By setting on - every value in the related_candidates field is 0. Does anyone how to fix this?Ta

Is there a way to create a table of attributes from a geotiff? I would like to create a table of pixel values where each pixel has an associated elevation. Elevations can be negative or positive and are from LIDAR. The table can be a .txt file. Zonal Spatial statistics with ESRI can create a table of attributes but the geotiff cannot have float values. The elevations for my geotiff range from about -10.00001 to 24.00001 so these valuse will not work with spatial analyst. I would also like to create statistics for specific elevation classes. any advice welcomethanks

I am trying to add a custom transformation using a NTv2 grid shift file.I have defined this .fme file in \\Documents\\FME\\CoordinateSystems\\ :XFORM_DEF Stereo70_to_ETRS89_NTV2 \\  SRC_DTM PULKOVO42/58 \\  TRG_DTM WGS84 \\  DESC_NM "Stereo 70 to ETRS89 using grid shift file generated from TransDatRo grid" \\  GROUP Romania \\  INVERSE Yes \\  METHOD GRID_INTERP \\  GRID_FILE NTv2, fwd, .\\GridData\\Romania\\stereo70_etrs89A.gsbNow FME wont start. I get the error mesage: Xform 'Stereo70_to_ETRS89_NTV2' contains invalid GRID_FILE value of 'NTv2,'

Hi,I have a number protected areas that is partly overlappingareas. I want to investigate how many och och much of these areas that are influenced by different corridor alternative, that is partly overlapping. I am using a Clipper transformer with the corridors as clipper and protected areas as clippee. Is there a way of solving this without a attribute filter for the corridor? Overlapping polygon Intersect/clipp Overlappling polygon? Looping through the corridor FeatureType Thanx in advanced

Hi, I have a shp-file with 99 buslines. the Attribute is line and the Features are 141,166,171..etc.(devided by a comma) my output should be 99 shp-files whose each includes one single line. The problem is on the inspector i can find any single value, but with the attributefilter i only find some where my value is at the beginning or stands alone. Any ideas how i can manage that issue? Thx

Hello, I try to read my existing data model into a new empty data model with domains set up already when I built the new data model. After setting up the transformers at the FME workbench, the data got pushed over just fine from FME Inspector. When I open up ArcCatalog to check the data, the fields which have domains set up are all empty. I would assume it is because of the domains so it will not allow any other value to be in the dataset. In order to resolve this issue, do I need to manually clean up my existing data (lots of data!!) on ArcMap, in other words, to fix my existing values to match the new domain code for the new model? Or should I try something else?

Hi,  I would like to read a csv file (zipped) from a https site and expose the "date modified" value. I found this thread explaining how to use the Directory and File Pathnames - Reader but that does not work for https sources. https://knowledge.safe.com/answers/32678/view.html Is there any workaround without downloading the file first? Thank you for your help.

My FME job is failing & I am trying to troubleshoot. I found in desktop log file server type `ORACLE8i' when I use oracle client & server as 12.1.0.2. Why it is showing me server type "ORACLE8i' when I am using oracle 12C database server & client?

I am writing a custom writer that has a special date format. I would like to detect when a string has the native fme_date, fme_time, or fme_datetime format and convert the internal YYYYMMDD etc. format to my internal format. I am using the C++ SDK, and am unable to find any function that tells me what native format is being used. The best I can find is getAttributeType() and getAttributeEncoding(), but these functions only return FME_ATTR_ENCODED_STRING (an FME_AttributeType enumeration), and 'utf-8'. For a regular string attribute that does not have the 'date' format in the reader (I'm using the oracle reader and connecting it to my custom writer), the attribute type is FME_ATTR_STRING rather than encoded string. Is there any way to detect on the custom writer side what native FME format was used by the reader? And if so, are there convenient format conversion functions available in the SDK? Using the DateTimeConverter transformer in the workbench is not an i

Hello Safe,PROJ.5 has just been released, and it seems to be a great improvement to PROJ.4.It looks like all manner of "difficult" projection will be supported (with polynomials and Helmert), so is Safe planning to take advantage of this, and implement PROJ.5 support e.g. in the next major release ?I know for a fact, that Danish legacy projections will be implemented shortly (if not already), with full accuracy, and henceforth will be maintained here. This enables centimeter accuracy in reprojections.Cheers

I need to export several hundred MapInfo files into a single shapefile that retains all the individual geometry and attributes. Which transformer would be best?

So I've been playing around a bit with this new transformer (check out this great post by @Mark2AtSafe https://blog.safe.com/2018/01/data-join-with-fme-evangelist171). When using the FeatureMerger, one trick I use a lot is to simply type the same string or a single character for the supplier and requestor in order to force a join, irrespective of whether the two have any common data. I learned this trick at last year's FME World Tour in Houston if I recall. However this doesn't seem possible with the new FeatureJoiner as it won't accept a text input. You have to instead create a new left and right attribute and supply some common value, then remove the attribute after joining (which is what I used to do before learning that quick trick!).Is the new FeatureJoiner going to get the ability to input text instead of being forced to pick an attribute? Thanks.

I´d like to know how can I convert the shapefile into (formated) asc file.

Hi, I am using the translators PhotoCoordinateExtractor to VertexCreator and then writing to a shapefile in order to get points from photos. The problem is that the shapefiles then don't have a spatial reference.Is there any way of getting what the spatial reference / projected coordinate system is from the EXIF information or any FME feature attribute?Or should I just assume that its WGS84?Here are the attributes I know exist, but I dont think any of them can answer my question: exif_brightnessvalue (string) exif_imageuniqueid (string) fme_basename (string) fme_dataset (string) fme_feature_type (string) fme_geometry (string) fme_type (string) jpeg_exif_aperturevalue (string) jpeg_exif_colorspace (string) jpeg_exif_componentsconfiguration (string) jpeg_exif_datetime (string) jpeg_exif_datetimedigitized (string) jpeg_exif_datetimeoriginal (string) jpeg_exif_exifversion (string) jpeg

Hi, I'm trying to evaluate if multiple columns in a single row are populated with values and then count how many columns have a value.For example:COLACOLBCOLCCOLDCOUNT0000042010276210030001571I used the ExpressionEvaluator with the following expression:COUNT = (COLA/COLA)+(COLB/COLB)+(COLC/COLC)+(COLD/COLD)But obviously dividing by 0 is throwing the whole result off. Is there some form of COUNTIF in FME?Are you able to suggest a better solution / fix my expression to ignore dividing by zero?Any help would be greatly appreciated. My brain has decided to give up today...

This SQL works in Toad, plsqlDeveloper, sqlplus etc.. but not FME transformers that accept SQL statements. SELECT permit, mon, quantity FROM isf UNPIVOT (quantity FOR mon IN (jan, feb, mar));I tried this SQL with an Access database, and connections to a non spatial Oracle database. Connections to the data with simple SQL work just fine. Must be that "UNPIVOT" is not supported. Error message is Provider error `(-2147217900) Syntax error in FROM clause. Any help, or workaround is greatly appreciatedlink to example SQL to try in FME: http://www.orafaq.com/wiki/UNPIVOT