Skip to main content

- - Community Resources
Ideas
Product Updates
Events
Groups
Support
Knowledge

EN

Home
Search

Best Answers

10387 Posts

Recently active

Most views Most replies

asked in Transformers

Write OBJECTID attribute of Oracle Spatial registered feature class

I’m trying to create an FME process that reads a FGDB andwrites the data to an Esri registered feature class stored in an Oracledatabase. I have issues in finding the proper way of doing it using the OracleSpatial Object writer. The trouble is caused by the OBJECTID: how to populateit?I’vetried using an SQL statement (Overrides Feature Operation) like INSERT INTO FEATURE_CLASS (OBJECTID, COL1, COL2) VALUES(sde.gdb_util.next_rowid('OWNER', 'FEATURE_CLASS'),:COL1, :COL2)With this approach the OBJECTID column gets populated but I’mfailing in writing the geometry (the geometry in Oracle is stored asSDO_GEOMETRY). As a workaround I’ve defined another process using the same writerto update the geometry column only (Feature Operation = Updated instead ofusing the SQL Statement Overrides Feature Operation option).Is there a way of doing this in one step only?I know it can be done by using Esri Geodatabase (ArcSDEGeodb) writer but for some reason the process takes about 20 minutes incomparison

asked in Transformers

Assign bounding extents to Reader (Search envelope)?

Hallo!I'm curious if and how it is possible to assigne max/min extents which come from the "BoundsExtractor" to the search envelope of multiple data readers.The first step of the workbench is to make a buffer around an area. This buffer is extended to the max min boundaries with the "BoundingBoxReplacer. This generated square is used to clip different input sources on the area inside the bounding box.Because it's quite an amount of data, i'd like to preselect the region with an search envelope so that not all data has to be loaded to be clipped.Is it possible inside one workbench to generat the min/max extents and hand it over to the search envelope of other readers?I've tried to assigne the values as private parameter, but this seems to late for the reading process of the input sources. Thanks in advance! Mark

IfcSpace to 3D geometry in PostGIS

Hello,I am trying out how IfcSpace elements in Building Information Models can be transformed to 3D geometry in PostGIS. I have made a simple building model in Revit in which a few spaces are defined. The model is exported to an IFC file. When I open the IFC file in an IFC viewer (Solibri) I see the spaces and they can be drawn on screen as 3D geometries. So somehow it is possible to derive 3D geometries from the IFC file. However, if I do a (default) translation from the IFC file to PostGIS, I see no geometry for the spaces being created. All space have the same geometry value (in WKT): GEOMETRYCOLLECTION(GEOMETRYCOLLECTION(GEOMETRYCOLLECTION EMPTY)).Is it possible to transform IfcSpaces to 3D geometries or even 2D geometries in FME?

lifalin2016Supporter

asked in Transformers

XmlTemplater using Sub Templates with Expressions ?

Hi,I'm having my first go with the XmlTemplater, and of course it's given me problems :-)I want to add three tags conditionally in a SubTemplate, but it errs with this message:XMLTemplater(XMLTemplaterFactory): The following error occurred near line 2, column 8 of the query: XMLTemplater(XMLTemplaterFactory): invalid expression: syntax error, unexpected ExprSingle (missing comma "," between expressions?) XMLTemplater(XMLTemplaterFactory): An error occurred while parsing the 'SYMBOL' sub-template XMLTemplater(XMLTemplaterFactory): A fatal error has occurred. Check the logfile above for details A fatal error has occurred. Check the logfile above for detailsThe unconditionally expression "" works fine, but three tags fails on (apparently) the second opening tag.And what's with the "missing comma" ??Can anyone point me in the direction of a not-simple example of how to use the Sub Template expression in

asked in Transformers

Can FME Data Inspector handle layers with different coordinate systems?

Using version 2016.1.3.2In https://desktopmanualbasic.safe.com/DesktopBasic1Basics/1.Exercise3.html, there is some exercise showing how to inspect data from two different layers.Layer 1: a kml file (CRS: LL84)Layer 2: a MapInfo TAB (CRS: UTM83-10)In the exercise, the data inspector can handle the data with different CRS (there is a print showing the two layers mashup). (the data is available here: https://www.safe.com/training/recorded/fme-desktop-2016/)But if i try to do the same using version 2016.1.3.2, the data inspector draw the two layers but don't transform the coordinates (in the status bar is show the message "Multiple Coordinate Systems").Is some configuration necessary for the data inspector transform coordinates? Or the data inspector can not deal with layers with different crs?

jtn40764Participant

How can a Reader starts after Writer is finish

I have a question. I make a Projekt in FME Desktop and I want that a one of the Datareaders starts after a writer has finished his work. Is this possible? I need this, because the writer updated a table from the Reader

asked in Integration

Possible bug reading ArcGIS feature service with intl. characters

Possible bug in FME 2017 RC reader when accessing feature service containing international characters, I've asked him to contact you with details:https://knowledge.safe.com/questions/40233/problems-reading-layers-from-arcgis-server-feature.html

asked in Transformers

create new features within a python caller

Every exemple of python caller I see would only modify attributes or add new attributes to each input feature. Is it possible to output new features or more features than were received by duplicating some inputs ?

annette2Contributor

FeatureReader with Oracle Spatial Object - can't specify geometry

Hi,I am trying to query 40 Oracle Spatial tables within a bounding area using the FeatureReader where each table has multiple geometries but not all geometries have spatial indexes. Unfortunately only the geometries I am going to query have the indexes so I can't use the multiple geometries option. Adding the additional indexes is a lot of work for the complete electric and gas databases.It seems that with the FeatureReader transformer you cannot use Oracle Spatial Object and also specify the geometry column. Is this still correct or have I missed something? I'm using version 2015.0 as our FME Server is 2015.0 but I've also checked in version 2016.I see this post in 2013 but this is a lot of work as I have 40 tables with multiple geometries and I need information such as the oracle_orientation. I think I will have to resort to the WorkspaceRunner and somehow pass the AOI geometry into the second workspace as described here.Thanks,Annette

lifalin2016Supporter

Reading generic XML with variable content ?

Hi,How can I best accomplish reading a generic (any) XML file without specifying any initial root tags etc. ?I.e. return the whole XML document as a single fragment.Do I need to create some special XRS or xfMap templates, or can it be accomplished with the simpler Feature Paths ?Cheers

lifalin2016Supporter

asked in Transformers

Error when reading MapInfo TABs from ZIP ?

Hi,I'm trying to read a number of MapInfo tab files from a ZIP file, which errs in several mysterious ways.Here's what I try to accomplish:Here's the error in the translation log:Here's some of the content of the ZIP file (using 7z):Firstly, the translation log states that FME uses MITAB although I clearly have chosen MapInfo's own method (unless only MITAB is available nowadays and the original name is now an alias?).Secondly, why doesn't the opening of TAB files in the ZIP err at all ? Is there a limition wrt. the TAB format ?I've just the same notation to extract (large) XML files from a ZIP, which works nicely.Or is it perhaps the cipher-leading folder name ("1082") that is the cause of the error ?Cheers.Lars I.

Insert function as value to Postgresql instead of SQLExecutor

Greetings!I would like to set an attribute of my feature as the value returned by a pl/pgsql function. Currently, I use the SQLExecutor for every feature. It's much slower than using the pl/pgsql function in the INSERT.The expected result would be that FME produce the following insert statement.INSERT INTO my_table VALUES (17, 'abc', MY_FUNCTION(17));I'm using fme build 16716 with postgreql version 9.5.Kind regards,Jean-Denis

asked in Transformers

Shape files into new shape files based on attributes

Hi, very new to FME, and I cannot solve how to use this:I have about 100 ESRI shape files, containing map data for different geographica areas. I would need to rearrange the data, so that new files are created, where each new file contains all data with a specific attribute in one of the data columns. For instance, small roads have the attribute 11015 in column "CLASS" in all this input files, and the data for all small roads should from all the files should be exported to a new files 11015-all-areas.shp . What transformer do I use, how and how do I get the new created files to adopt their names from the attributes used? Thanks!! Benjamin

erik_janContributor

asked in Automation

Can a datadownload from FME Server start without returning the download link?

I uploaded a workspace to a FME Server using the Datadownload service.I call this service and workspace from a custom webpage.All is working as designed, but I would like to skip the download link that is returned by the service.I would like the Datadownload service to start downloading the file as soon as the file is generated.I can't find the right option for this.My URL looks like: http://localohost:8080/fmeserver/fmedatadownload/myrepository/myworkspace.fmw?Can anybody help?

arthyContributor

asked in Transformers

fme data types and esri data types

Dear all,I Have a schema mapper transformer that is defined based on an external oracle tableThe external table have a column_name destination_attribute_type where I defined the data type of the file to be translated.Is there any specific reason why "fme_int32" of the oracle table is not converted to "long integer"For the shape files, the field data type of "fme_int32" yields to a data type "double" with length equal to 11.Thanks

sunsilk11Contributor

asked in Transformers

Custom Python logging

Hi I am in the process of creating a bunch of workbenches and would like to use Python scripts to create a custom log file for each workbench, each with specific name and in specified location. I would like to log only specific outputs, e.g. count of features failing geometry validation, Total count written, Total count failed etc..Any suggestion what's the best practice to achieve this. Should I be using startup/shutdown scripts or python caller? I would also like to create the log file with a datestamp.Thanks

austinhContributor

asked in Transformers

Create an HTML document with a hyperlink using the HTMLReportGenerator

I am generating reports using the HTMLReportGenerator and would like to have a hyperlink within the HTML output that links to a pdf, shz, csv..... I can generate the url address as an attribute, however I have not been able to output the HTML with the hyperlink.Anyone been able to do this? Ideas?

asked in Automation

Failed to bind to Active Directory

Hi, I am trying to run a series of transformations using the FME Rest API. Sometimes it works just fine, however, sometimes I get the message "Authentication failed: Failed to bind to Active Directory". (401). I created a token valid for 10 days and used a HTTPCaller to POST to the URL "http://ourserver:8080/fmerest/v2/notifications/topics/LDR_Trigger/message/raw?token=123456&detail;=low". Sometimes it looks like if I login to the FMEServer UI, it remembers the token and the result is as I expect. Has anyone any experience using FME Server REST service on Active Directory?

asked in Transformers

Problem drawing polygon that crosses the 180th meridian

Hello everyone,I want to draw a polygon that crosses the 180th meridian and obtain this geometry (created manually, splitting the feature into two separate polygons): Instead I obtain this: I don't understand why the geometry won't generate properly. FME creates the polygon with the greatest distance between points instead of the shortest. I have to do this for many polygons and also lines, with much more complex boundaries, so I can't do this manually like this one. Any idea on how I can achieve this?Here is the workspace I used to generate these geometries: Thank you very much

ingallaContributor

asked in Transformers

Measure distance between two lines at specific interval

Hi allI have the edges of a road and want to be able to measure the distance between the two edges perpendicular to the left hand edge at a distance every 10 metres.Any suggestions on how to complete this as I can not get my head around it.Thanks in advance.

asked in Transformers

Grab first 1000 records

I am using Sampler to grab fisrt 1000 records but it reads all 2 million records that I am dealing with before grabbing first 1000 values. How do I avaoid it? Thanks.

convert json to xml

Hello,I execute query on my postgresdb to get result as a json: description is here http://rextester.com/ZULI42144It looks nice but now I would like to convert it to xml. I decided to use fme to query postgres just like in example and now I have noe idea how to convert the result to xml and write it to file.Also talking about json which I also need (I need result in JSON and XML format) what I achieved is that I simply executed postgres query end then wrote results using simple text writer so I suppose that fme doesnt really know that the query result is a JSON :)Structure and content of the database is as described here:http://rextester.com/ZULI42144and there is sql that is used in below sqlExecutorThis is prototype of my workspace that I have right now and the question is how to format nice xml from this list exploder (if its possible).And here is output of the logs. Of course in the result xml I would like to have structure ike <person>...<car>...<wheel>...</whe

femoContributor

asked in Transformers

MapnikRasterizer:how to rotate a Marker-Symbolizer

Hi,this time I need to rotate a svg-symbol based on an attributive value. I have set the parameters asfollows:The parameters in the screenshots for rotation (e.g. 30 degree) and the optional coordinates of the rotation point are hard coded. In the real application they will be filled based on attributes.Well I get this error:Invalid Mapnik style configuration. The error was: Failed to parse transform: 'transform="rotate(30,427000,5670000)"I have tried different Syntax, without success. Do you have any ideas? Maybe the integrated mapnik engine does not support rotation?

lifalin2016Supporter

asked in Transformers

Tool to disperse points around an identical position ?

Hi,I'm continiously acquiring tasks for internal FME execution that previously was done by a mix of command lines and t-sql. One of the tasks involved was dispersing points with identical coordinates to unique positions in the vicinity. This task is currently kept in a stored procedure.I would like to also transfer this functionality to FME proper.Before I venture into recoding the stored procedure into a custom transformer, I'd like to hear, if anyone has encountered a similar problem, and has found a good solution ?Cheers.

asked in Transformers

Any way to exclude entries from one reader that don't have a matching value in another?

I have a simple translation setup in FME to check if certain points are within a proper postcode polygon.The guidelines I am checking against is that there should be one point per postcode and if the postcode of the point is "12555" then it should be in the "12555" polygon. Easy enough to check. However, the problem I'm running into is there are PO boxes which have a postcode but do not have a polygon to go with it. I need to somehow filter out the points that do not have a matching polygon and then send the rest on to the PointOnAreaOverlayer and the tester.I originally thought this would be possible with a TestFilter or Matcher but I'm not having any luck getting the result I need.Anyone know what I need to use for this?Thanks.

1
...
346
347
348
349
350
351
352
...
416

Page 349 / 416

Badge Winners

-o3-has earned the badge Teacher (Grey)
bhavyagandhihas earned the badge Student (Bronze)
bhavyagandhihas earned the badge Student (Grey)
bhavyagandhihas earned the badge Teacher (Bronze)
bhavyagandhihas earned the badge Teacher (Grey)

Show all badges

Community Stats

31,807: Posts
120,823: Replies
39,436: Members

Latest FME

Powered by Gainsight

Terms & Conditions Cookie settings

Sign up

Already have an account? Login

An FME Account is required to contribute

Login

Login to the community

An FME Account is required to contribute

Login

Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.

Enter your e-mail address

Back to overview

Scanning file for viruses.

Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.

OK

This file cannot be downloaded

Sorry, our virus scanner detected that this file isn't safe to download.

OK

A product of

Company Products Giving Back Careers Contact Privacy Feedback

Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.