Transformers

I have a metadata string in a file and want to export this to its own attributes so I can export it to a database. If i use the fragmenter it gives only <missing> as output. I have elements to match: gmi:MI_Metadata and expose gmd:fileIdentifier. Same happens when i use the XMLflattener. I can't figure out what i'm doing wrong. Being stuck at this for a few days already. Only solution what worked for me wasExport to XMLOpen XML in Sublime text to Replace < for < and > for >Open the XML in a new workflow to extract to databases Sometimes i get this messagemessage:prefix 'gmi' can not be resolved to namespace URI Example:<?xml version="1.0" encoding="UTF-8"?><!-- BAG Metadata - Created with: -vSABER_5.2.0.9.5ISO TC211 schema --><gmi:MI_Metadata xmlns:gmi="http://www.isotc211.org/2005/gmi" xmlns:gmd="http://www.isotc211.org/2005/gmd" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:gml="http://www.opengis.net/gml/3.2" xmlns:gco="http://w

I don't know if this can be done consistently. But if anyone would know how it would be you. I would like to connect lines A and B and remove the "appendix" from line C. An AnchoredSnapper was my first thought, but there are probably plenty of occurrences where B would connect to C instead of A. Is there a way to only snap to something that is in the "forward" perimeter? If I could get the below working it might be a better idea to extend the lines and then cut away the surplus.Removing the appedix could be done with a LineOnLineOverlayer, but how do I find out which one is the shortest of the resulting lines? How would you solve this? What is the "cleverest" solution? 

Hello I would like to find the following part in a text file (originally xml file style) :<userData code="viPartListRailML" value="1">            <partRailML s="0.0000000000000000e+00" id="0"/>            <partRailML s="2.0000000000000000e+01" id="1"/>            <partRailML s="1.2000000000000000e+02" id="2"/>            <partRailML s="2.2000000000000000e+02" id="3"/>            <partRailML s="3.2000000000000000e+02" id="4"/>            <partRailML s="4.2000000000000000e+02" id="5"/>            <partRailML s="5.2000000000000000e+02" id="6"/>            <partRailML s="6.2000000000000000e+02" id="7"/>            <partRailML s="7.2000000000000000e+02" id="8"/>            <partRailML s="8.2000000000000000e+02" id="9"/>            <partRailML s="9.2000000000000000e+02" id="10"/>        </userData> Can you suggest me a regex that gives back this?It's like anything between <userData and </userData>

I am fairly new to FME and Python. I have written the python script to extract emails from our outlook server. It is successfully pulling down each email from a mailbox and separating out the body, subject, attachments , etc. These I have placed into attribute elements without any issues ( code below ). The problem I have is returning each email in the transformer as a separate row. I only get the details of the last email I am downloading. I would like each email to be returned as a dataset - eg the data inspector should show 7 rows for 7 emails. Any assistance on how I do this thru the pythoncreator transformer would be greatly appreciated.Many thanksOlly import fme import fmeobjects import sys import email import imaplib import os import base64 def processFeature(feature):  emails = FeatureProcessor()  emails.getEmails(feature)class FeatureProcessor(object): mail_server = FME_MacroValues['Pop3Host']   deletefromserver = FME_MacroValues['DeleteFromS

Hi, I have to insert some data from an ArcSDE GeoDatabase to a SAP Hana database.  The next step should be to add a second Geometry columns with another geometry that will contain a reprojection of the current geometry.  Don't ask me why they want that.  Here my ID Was to insert the "normal" data, then reproject and update the table with a new name but I don't have the possibility to give another name.    First of all is it possible to do that in SAP Hana ? I'm not SAP Developer so it's not my business ...  Thank's for your help.

XY tolerance in FME,  As the end product of my workbench is ESRI feature class, I couldn’t figure out which option allows me to select the XY tolerance (resolution) of this feature class.      Thank you  Best  Jamal

I need to combine the attached drawings following this procedure:drawing A contains geometry);drawing B contains some attributes defined in AutoCAD with the ATTDEF command, but doesn't have any geometry featuresHow can I build, inside FME, the drawing C using the geometry stored in drawing A and the attributes defined in drawing B?How can I extend this kind of workflow to have in input an entire directory (in which there are hundreds of .dwg files) instead of a single drawing A?So far I tried toconnect directly a reader and a writer, setting drawing B as template file but it didn't work.Thanks for your help.

How would i go about converting single tiff and multipage tiffs to pdf?

Hi, I need to convert some heights from WGS84 (GPS) to CGVD2013. I am trying to use CsmapReprojector and for vertical handling I used Geocentric or ellipsoid height -> Orthometric height and selected BCGG2013-ITRF2008_CGVD2013.gdc height grid. But I have no idea if this is the correct way to go.  Thanks!

HiI use FME mostly for conversion of dwg/dxf/Shape files and changing their coordinate system with the help of GtransReprojector In Sweden all the county’s have different types like, SWEREF 99 15.00, SWEREF 99 14.15 SWEREF 99 16.30 SWEREF 99 18.45 and so on and we use SWEREF 99 TM Sometimes I haven’t been told the source coordinate system and I have trouble finding (guessing) what it isIs there a way that I can identify the source coordinate system with the data inspector or any other tool?

Hi,I have multiple GeoPackage files with different schemes.I want to store them in a zip folder, but in separate GeoPackages not in one.Which transformers can I use for that? Thanks and best regards? 

I am trying to create a simple scripted parameter that creates a unique random id to insert into a DB for reporting purposes.I am following step by step the example in the FME help pages:https://knowledge.safe.com/articles/60080/python-scripted-parameters.htmlI create a variable and I assign to it a UUID using the python module (interpreter 3.4+)https://docs.python.org/3.4/library/uuid.htmlimport uuidimport fmecustom_uuid = str(uuid.uuid4())# I tried both with and without conversion to string # custom_uuid = uuid.uuid4()return custom_uuidFME workbench does not read the parameter as the result of what is returned in the script, but reads the text of the script (adding some custom FME tags).See from logger:Logger: UUID is: import<space>uuid<lf>import<space>fme<lf><lf>custom_uuid<space>=<space>uuid.uuid4<openparen><closeparen><lf><lf>return<space>custom_uuid<lf>what I am doing wrong for FME not reading the retur

Hi, I have polygon datasets, where I would like to filter one object based on id and I would like to set the parameter of Search Envelope based on this filtered object. I will extract the bbox of the polygon. How can I pass these values to Search Envelope? Thanks in advance.  Best, N

Is the naming of EPSG 29903 incorrect? On the website https://epsg.io/ , EPSG:29903 is labelled as TM75/ Irish Grid. Whereas within FME EPSG:29903 is labelled as TM65 (See below). I understand the epsg.io is correct (but I may be wrong). Thanks for the help. Bepsg.ioFME

  ID DIESEL last 1 2 2 23 5  4 5  5 3 1 1 1 6 5 10 3 2 1    i want to check for every id ,if it has a value in last attribute or not if it has soit should check also if this id is repeated in same attribute ID or notif yes so it will check which value in last attribute that it hasbcs both of them has the same id so i want to take the two values that it has found as example above 1 and 2and search in Diesel attribute which contains 1 and 2 and change to new value say 15 but it is important the new value not include in Diesel attribute any number does not matter but new value not include in diesel attribute but if the id has only one value in last attribute and no common id in id attribute soi want to take this value and change all value that has the same number in Diesel attribute to new value not included in diesel attribute . I spent too much hours with if condition in attribute manager and attribute creator and null attribute mapper but no success .could u guide me ,how could i do th

I have census data in csv format and would like to rename several fields. Basically I want to rename fields by renaming specific words Private to Pvt, Dwelling to Dwlg. I also want each word in Proper case so the fieldnames aren't so long. Hopefully someone can help me with how to tackle this.

I have a road network where I have to find intersections with more than 2 streets. I used Intersector to find nodes and filtered nodes with more than 2 overlaps, eventually finding intersections with more than 2 streets. But this approach has resulted in finding undesirable intersections marked as cross in attached image.To avoid those intersections I decided to find angle between lines. I cannot use AzimuthCalculator as I don't have a previous WB referencing this transformer. I used PolylineAnalyzer but it outputs angle between segments and not lines. Is there any way I can filter out these undesirable intersections?

Hi  i'm trying to pivot (transpose) some data, but all the examples i can find on here turn rows into columns, and i want to turn columns into rows.  DATA   RegionUnder 1616-1718-1920-2425-3435-4445 and overDurham572025263520Darlington351827284425Gateshead8152535262835 what i want it to look like RegionAge BandValueDurhamUnder 165Durham 16-177Durham18-1920Durham 20-2425Durham 25-3426Durham 35-4435Durham 45 and over20DarlingtonUnder 163Darlington16-175Darlington18-1918Darlington20-2427Darlington25-3428Darlington35-4444Darlington45 and over25 etc. Any help in much appreciated.  ThanksMark 

The gist of the problem was defined in this question. https://knowledge.safe.com/questions/46298/how-can-i-easily-expose-attributes-from-xmlflatten.html In my case the JSON has the schema (name, alias and field type of a feature). Shown below.Sample attached.I got the schema array in rows.I have feautes JSON fragmented with json["features"][*]["attributes"] with the following output.Instead of exposing each attribute one at a time or importing a temporary csv file created by aggregation, i'd like to use the schema from the fields array for the features output.Hope to get some ideas to use using derived schema in my workflow.Thanks!

Hey,I have polygons with a height information (in meter) in the attributes. (Those are buildings) How can I use this z value (height) and create a 3D model from my polygons?  For some Objects i dont have the height information, could I set some default height for all of the Objects which do not have any hight information? - if yes, how?  Kind Regards!

I am trying to find a string with regex and put it in an attribute. I have used the stringReplacer, but this means I would have to search for what I don't want to capture and replace it with nothing so that what is left is the string I want to capture.It seems as though capture-groups do not capture strings for subsequent use in fme.     

Hi,For my current task I have a road network (purple lines) and 2 datasets with points.Dataset 1: green pointsDataset 2: red pointsWhat I want to do now is to select points from dataset 2 which intersect or are close to dataset 1. See the attached figure for examples.However, I want to limit my search for the test 'are close to' within a single line. The FME method/tool should not look at points which are postioned at parallel running lines. In the figure below I do not want to select the red point indicated as 'not intersecting'. There are green points closeby. However, they aren't postioned at the same line which should be the case to be considered as a closeby points.I tried something with the NeighborFinder. This works fine. Only situtations like the one below I did not solve yet. Any suggestions? 

I have started testing of translating our data from GDA94 to GDA2020 in preparation for Australia's new datum change. I have tried a simple translation however have a 'Warning' in the FME translation process saying "MapInfo does not support datum/ellipsoid GDA2020 -- assuming default of WGS84", why?? How do I correct this?

I am new with FME and I have been testing several GIS software to add elevation data to a GeoPackage. No luck so far and I was wondering if FME had the capabilities to do it. Thank you

I am trying to pass a list of API and Date values from a StatisticsCalculator to a SQLExecutor to execute a joint query from a SQL Server database, and it does not work for me. The following is my query inside SQLExecutor, and I cannot get any results. Please help. Thanks in advance.SELECT a.PROPNUM,LEFT(a.API,10) as API100, a.WELL_NAME,a.AREA AS [MGY_AREA],a.RSV_CAT,a.STATE,a.COUNTY,a.OPERATOR,b.[D_DATE],b.[GAS],b.[OIL],b.[WATER],b.[FTP],b.[CSG],b.[CHK]FROM [dbo].[MAGNOLIA_AC_PROPERTY] a, [dbo].[AC_DAILY] bWHERE a.PROPNUM = b.PROPNUM and a.API = 'value@(API10)'