Using readers and writers to extract and load data.
Recently active
I simply want to import a drawing from a client which has the DGN extension; into AUTOCAD 2017. It says " DGN must be in version 7 or 8" and closes the dialog with an error. This FME software is far too complex for such a mundane purpose. I can redraw the entire project in less time than it would take to learn software such as this. Does anyone know of a simple tool to convert non supported DGN files to AutoCad 2017?
I have a directory of PDF files scanned in 1996, I have feature dataset linked by PDF filename the with another attribute field with correct document creation date. How can change the PDF filename properties of creation data?
I'm having an issue using the schema mapper to remap the schema of a Oracle 11g database and write thte data into a file geodatabase using FME 2017.0.0.0 Build 17236. I have succesfully mapped the SQL Server version of the same schema and data with no problems. If I set up the Oracle mapping I can get it to map successfully but it will fail to output to the geodatabase and will automatically output to an .ffs file. I can then open up the .ffs file and everything is mapped properly, just not outputting to the right location. Any advice regarding this issue would be much appreciated.
Hi, I'd like to create a inspire GML-file (using the inspire GML writer) without the <gml:boundedBy>-tag. <gml:boundedBy> <gml:Envelope srsName="EPSG:28992" srsDimension="3"> <gml:lowerCorner>96465.102 471796.29 0.00</gml:lowerCorner> <gml:upperCorner>145855.225 563146.105 0.00</gml:upperCorner> </gml:Envelope> </gml:boundedBy>Is there a way to generate such a zipped gml (with the INSPIRE gml writer) without the above text/tag. How do I prevent my workbench from generating this tag. Thanks in advance.Bas Boers
I have a series of workspaces that sync an Oracle Database with an SDE database every hour (ORACLE_SPATIAL and GEODATABASE_SDE Readers > GEODATABASE_SDE Writer). I created several relationship classes in the SDE database (via ArcCatalog), and now my workspace fails to update any of the feature classes that are involved in a relationship class.I am receiving the following error: Error while retrieving an ArcObjects update cursor for the table/feature class 'DBO.EL_SERVICE_POINT'. The error number from ArcObjects is: '-2147216556'. The error message from ArcObjects is: {Objects in this class cannot be updated outside an edit session}If I delete the relationship classes, the Feature Types update as expected.I tried setting geodb_feature_has_relationships to 'yes' before writing to SDE, but I still received the same error.Also, the Transaction Type on the SDE reader and writer is set to "Versioned Edit Session", as I am updating a versioned SDE databa
Hi All,I need to automate the process of cutting up an image file into approximately into 11,500 separate images.I have my image file. I have my grid shape file that contains attributes that I want to use as my output image file names.I can get image outputs using clipper that are exactly as I expect (correct dimensions etc) but cannot figure out how to name them correctly.I'm convinced that I'm missing something quite simple here.I have been searching through the knowledge center but can't find exactly what I'm looking for.Has anyone had experience with this? I'm using FME Desktop 2015
Hi ,is it possible to set a timeout-Parameter for writing in a Postgis-DB to ensure, that the connection will be closed.
Hello FME's geeks !I am looking for writing outputs as shapefile to a path that is derived from the concatenation of an input parameters, a given string and a timestamp.In other words, the path should look like $(input_parameter1)/$(string)-$(TimeStamp)In my case,The input parameter is a folder given by user (Main_Input_Folder)The string is the basename of an input file given by the user without extention (eg : C:\inputFolder\myfile.shp => basename = myfile)For now, I am able to concatenate the input parameter and the Timestamp (creating a Python scripted private parameter for creating the string) giving something like $(input_parameter1)/$(TimeStamp) and use it to the "Destination Esri Shapefile Folder" parameter : However, to add the basename, I created another Python scripted private parameter to extract the basename (used code below) but when I try to add it to the "Destination Esri Shapefile Folder" parameter I get this error : Undefined macro `AOI_basebame' dereferenced in fi
Hello, My reader is a MapInfo table and my writer is a PostGIS database. I tested the database and I was able to successfully connect to the database. However, when I run the workbench only 1 record goes through and I get the following error: Error executing SQL command ('select * from "databasename"."tablename" where false limit 0'):'Writer failed in write() callAny idea of what is going wrong?
2017-03-15 19:46:42| 131.8| 0.0|INFORM|ORACLE Reader: Using Oracle Reader to read tables from database `', server type `ORACLE8i', server name `bebop', user name `importantuser', password `***'
I'd like to report what I suspect might be a bug with the MySQL data writer. Applies to FME 2015 Workbench.I have a simple workspace consisting of a SQL Server data reader and a MySQL data writer. It reads a MS SQL table with some fields being a BIT data type. This then gets pushed out to a MySQL database (using a drop command first). I observed some problems with this, specifically to do with the BIT datatype. (1) - The MySQL data writer dialog lacks support for BIT type. The nearest type FME can use is TINYINT. See screenshot below. Even if I choose Manual attribute definition, there is no "BIT" datatype in the dropdown list.(2) - You would assume that there shouldn't be any difficulty writing a Bit (1 or 0) to a Tinyint. However FME reports errors during the write process. Even trying various different types: int, smallint, varchar produced same results.Insert failed on table 'lynx_animals'. Error was 'Incorrect integer value: 'Yes' for c
I'm new to FME, and I need to transform a Packbit compressed geotiff file to a LZW compressed geotiff file. I'm using a geotiff reader and a geotiff writer, the later configured to use LZW compression. The output file is still in packbits
I've looked around and I can't seem to find anything that covers the applications of coordinates/ applying a location to a 3D element. The idea being that I can extract a list of points into a csv file then represent the list of coordinates as a 3D element within a DWG/DGN/IFC.Any help would be great thanks.
Please see https://knowledge.safe.com/questions/41408/smtp-relay-not-installed-with-fme-server-2017.htmlSounds like either an error or lacking information.
I am using the latest build of Fme desktop and I am trying to use an autocad block that has dynamic content in it and is not working. If I take the dynamic parts of it out it works just fine. Does anyone know if Fme supports Autocad dynamic blocks?
I am trying the point cloud simplifier on a point cloud with 11 million points, but it is taking a very long time . It hasn't finished yet and it looks like it could take days to finish. Is it possible to speed up the transformer based on the parameter values?
Hi All,I want to draw a polyline that is defined in a layer of my template file. but dwgstyler has only got lines as options.How do I draw a polyline using 'DWGstyler' or any other transformer?Thanks in advance.
I need to be able to set the row for the field names to Row 3 for a folder of excel files. The only way to do this I have found is to read each excel and set the row to 3 in the Parameters dialog. This is very time consuming and I am guessing there is a way to set Row 3 for all Excel files read in from a folder. Any ideas welcome.
Dear All , We try to convert anything to Shape file, We have problem with file geodatabase , we upload the file as zip but it did not work , even if we give it as separate files is not working , how can we upload file geodatabase to generic reader format
I have a format, which is unknown in FME. It stores hexadecimals, (I can open it with hexinator). I want to know how I can read it with FME, so that I can start trying to convert it into something nicer! (I have the data structure, so I know what the hexadecimals tell me, but I don't know how I can read it with FME). can someone give me a hint?with kind regards,Ine De Cubber
I am experiencing a problem displaying mulipatch features read from Esri geodatabase. The features lose the ability to be rendered with shading. The problem is best demonsrated using the following workspace. On the top, a shape file multipatch feature is read, the (default) appearance removed (for consistency with the geodatabase operation), the appearance is then set to green and then displayed on the left. On the bottom row, a geodatabase multipatch is read, appearance removed, appearance set to green and then displayed on the right. The box on the right is not shaded. An identical problem re-occurs if saved to a geodatabase and viewed in ArcScene.How do I get the box on the right to look like the box on the left?
Hello,I am trying to download a small extent of OSM data using the OSMDownloader but the output osm file is empty (except for the header). The transformer generates the following call (which also specifies my bbox extent): http://overpass.osm.rambler.ru/cgi/xapi_meta?*[bbox=50.83,4.49,50.85,4.51]The download action seems to be successful however because the outcome of the transformer comes out of the Success port.Thanks for your help!Best regards,Olivier
Hi, I'm trying to write to a linked table in an MS Access database. I'm using FME Desktop 2015, the access database was created with Access 2016, and the table is linked to a SharePoint list. My Access writer in FME is using version 2007 and set to INSERT. When the access table is local (same attribute schema), it works fine, but when the table is linked to the SharePoint list, I get the following Invalid pointer error. Any ideas how I can try troubleshot?Microsoft Access Writer: Data type `autonumber' of attribute `ID' of feature type `Daily Changes' is not supported for writing. Attribute will be ignored by writerMicrosoft Access Writer: Failed to write attribute `Title' of feature type `Daily Changes'. Provider Error `(-2147467261) Invalid pointer'A fatal error has occurred. Check the logfile above for detailsA fatal error has occurred. Check the logfile above for details