Best Answers

Hi,I'm writing data to a MySQL (non-spatial) database and have some problems getting datetime fields filled. Checking a sample table in phpMyAdmin shows the date format to be ^Y-^m-^d ^H:^M:^S, e.g. 2017-02-28 13:09:00, so I've set up my TimeStamper to output that. But when I write to the database it fails every feature with a message saying it's an invalid format.If I enter the same value directly through phpMyAdmin it's accepted.Any idea what I'm doing wrong?

Hi,Is it possible to autoconnect or bulk connect readers to writers?I could choose "copy from reader" option for attributes but I would be happy if I haven't to link my 139 tables by hand!If you have a trick to easy lowercase all schema and table names it would be be so great!

Hello All,Has someone been to use in the edition FME Deskto 2017 the API in Python to manipulate Raster files?I need to create a example to share this news to my customer, but my Workspace has a Error when i write the code inside the transformer PythonCaller.import fmeimport fmeobjectsclass FMERasterProperties(object):    def __init__(self):        pass    def input(self,feature):        begin = fmeobjects.FMERasterProperties()        begin.getNumCols()            def close(self):        passAtttached my Workspace,   * the Reader can be any Raster file

Hello, please see https://knowledge.safe.com/questions/40453/invalid-scale-reduction-specified-error-when-openi.html?

Hi, can you have a look at this forum-related issue and see if there's anything to be done?https://knowledge.safe.com/questions/40222/why.htmlThree issues:@username not always clickable@xxx does not always produce a dropboxTyping @ sometimes marks the text as a heading rather than inserting "@"

I'm reading (only for example) a xls file with 3 sheets by reader using "Single merger Feature tipe" option. So this is result in inspector:I would like to count number of attribute for each feature type (2 for tab_A_in , 4 for tab_B_in, 3 for tab_C_in) obtainig features with a new "attribute_count" attribute (I don't know obviously first number of feature types and number of attributes so I have to find a dinamic way to obtain result):

I was learning Python FME Objects API for Raster, I tried to extract a band to generate a new raster, But it didn't work out. What's wrong with my code?import fmeimport fmeobjects class ExtractRasterByBand(object):    def __init__(self):        pass    def input(self, feature):        rs=feature.getGeometry()        rp=rs.getProperties()        rb=rs.getBand(0)                newfeature=fmeobjects.FMEFeature()        rsnew=fmeobjects.FMERaster(rp)        rsnew.appendBand(rb)        self.pyoutput(newfeature)                    def close(self):        pass

Hello Team,I`m try to take a screenshot from a Webpage with FME, but i didn`t find a transformer that make this.The website: http://www.ipmet.unesp.br/index2.php?menu_esq1=&abre;=tempo/boletimdotempo.htmlScreen that i want:Thanks in Advance,

My goal is to split lines when there is a point within a tolerance (i.e. 20ft) but NOT at intersections (they are already split at intersections. I've been using the PointOnLineOverlayer which works great everywhere except at intersections since the points are close to the intersection but not at them. Here's an image to try and explain the situation:Any thoughts on how I can ignore the points near the intersections when splitting?

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 

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

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?

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 "<!-- not implemented yet -->" 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

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?

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

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

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 ?

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

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

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.

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

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

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?

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

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