Transformers

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)'

I know i am missing something obvious here, but i need to select all of the polygons containing points. I have tried the point on area overlapper which works fine for those polygons containing only one point, but if it contains more than one point it will only select the polygon once.How can i export the same polygon with the merged data for each point the is selected?I.e. 3 points = 3 polygons albeit the same geometry but different attributes.Thanks for your help?Andy

I am reading from a postgresql database. Attribute [publication_time] has a primary key and type timestamp. In the postgresql database this attribute has values, but FME 2018.1 inspector shows no (blank) values.Can timestamp as primarykey be the cause? Kind regards Kees 

I'm new with FME. I have one attribute with this value "Zonne-energie in woonplaats vermogen 0,2394 MW, beschikte productie per jaar 227,43 MWh, looptijd 15 jaar. Het project is nog niet gerealiseerd (peildatum januari 2020)."I want 4 values out of this values and put them into 4 attributes.- 0,2394 MW into VERMOGEN- 227,43 into PRODUCTIE- 15 into LOOPTIJD- januari 2020 into PEILDATUMI want to use StringSearcher but i don't what Regular Expression to use. CWho can help me?

I have IFC data that originally used a local cartesian coordinate system. It originated in Navisworks and I used Intergraph Smart Interop Publisher to convert it to IFC format so I could use it in FME. I want to use the data in GIS software (ArcGIS Pro/Online) so will likely convert to multipatch/revit.What is the best approach for georeferencing this data/working out control points, etc.? Some of the IFC files are quite large (500MB+). Any suggestions appreciated!