Data

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

I am trying to use the FeatureReader to undertake a spacial intersect query against a MongoDB. The feature hits the FeatureReader and the log states that it has connected to the MongoDB, it even states the projection it is in. It then just does nothing. The MongoDB does not register any connections with FME. If I use a MongoDB reader it reads the database find. It is just when I use the FeatureReader. Does anyone have a similar issue with this? I am using build 17259 as the RC Desktop version.

Is there a way to call a pipelined function with parameters and then read the results as a table in FME desktop? I am only interested in non-spatial attributes being used.Thanks in advance...

The post titlePOSTGIS Writer: Fanout for feature type [postgis_table_name] failed to find feature type template ''is the error I'm getting in the FME log when I try to run a workbench which has already worked flawlessly a lot of times.It looks to me a database-related issue (template?) but I can't understand it and can't find any solution. I have no fanout and database configuration has to my knowledge not changed. I did not even change writers configuration.My FME version:2015.1.1.0 (20150715 - Build 15515 - WIN32)Any ideas on how to handle that?

Hi,I would like to add 100m to all the elevation values in a DWG file. However, how do I do this if the file contains polylines? I want to add 100m to all the vertices along the polyline.I am using FME2016 Desktop.Thanks,

Hi all!I want to read an xls-list without the first row to be the attribute-namer. As a result I will have attributes A, B, C, D, etc. I couldn't see a setting for that. Is it even controllable?Cheers, -Maria(I am using FME 2016)

Hi Guys,I have excel table with Road Names. There is a column that contains Names of all the streets and there are instances where they are repeating number of times. I tried using Testfilter to parse out the Roads that I am interested in but it didnt work for me. I am wondering what is the best way to go about doing this in FME.Any feedback would be greatly appreciated.

We are using 2016.1 (Build 16492) and I noticed that we no longer have the option to rollback on failure with the AGOL writer. Is this enabled by default or is it something that got removed purposely?