Data

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?

Fellow FME programmers. I have a large LAS and a DGN file that goes with it, is there a way to generate a clipped LAS file on the basis of a subset of features in the DGN ? I know I can overlay and view it, but I need to clip and produce a subset LAS file.

A question for the developers, I suppose:https://knowledge.safe.com/questions/41002/arcgis-online-rollback-on-failure-parameter.html

Right now it looks like I can write into "Esri ArcGIS Portal Feature Service" but I want to use this functionality on a hosted feature layer without involving portal in the mix, can we get a direct connector to write into a feature service?

It seems that the default behaviour for FME writers is to NOT write any records if an error is encountered, is that case? I want my writer to write the records that are good UNTIL the error occurs. This is for the Oracle Spatial writer, the SQL Server Spatial writer, and the Esri Geodatabase (ArcSDE Geodb) writer. Is it possible?Thanks

Hi,I am facing a problem while writing into a csv.file:FME converts the string '2-4' into 02.Apr., no matter what field type is set.E.g. '17-19' remains as it is since it cannot be changed to a date Format.Is there any smart Workaround or do I have to avoid/replace these strings?

Is there any way to have the Excel Reader read the contents of a shared workbook?

Hello everyone,  I've got a few AutoCAD blocks saved as Blocks.dwg (e.g. with the different blocks named "Block1" and "Block2"). Furthermore I've got some points out of a shape file.  Now I want to export the shape file as a dwg file and set "Block1" on some points with an attributive filter and "Block 2" on some other points.  My first idea was to read in the shape file, create a DWG writer, use the Blocks.dwg as Template File and fill the attribute autocad_block_name of the points with "Block1" or "Block2". That does not really work. Have you got ideas or hints to realize that.  Best regards, Felix

Hi all,I have dwg file exported from 12d Model. I need to match layers from exported file with template layers that we use.For example exported layer named X-SURVEYFENCE is a polyline and it has defined style, colour and line weight. It has to be renamed to layer Z-FENCE with settings, that are already predefined in template (eg. surveydata.dwt).If you have any experience in cad-cad transformation please assist me in resolving this issue.Regards,Maksym

Hello. Is it possible to change the name of the logfile a workbench writes by using a workbench in batchmode?Regards Eduard

my email is hosain.moh00@gmail.com

I have a workspace with an Excel Reader and I want to change it to read a new version of the file. I can run the workspace with the new file and features are read in, but the resulting output contains blank values. How can I fix this?

We are using FME Workbench 2016. Reading a table with land parcels in Oracle Spatial and want to create a dgn V8 with them, the single polygons look right. Also the objects with two polygons where one is defined as hole are correct in the dgn. But the land parcels which where split in two objects by a road for example are divided into two different objects. How can I force the writer to create a single object with two polygons from one object in the database? The "features written" summary shows 20 objects written (database count, correct). Microstation tells me there are 24 elements on this level, because 4 obejcts are now split int two different polygon.

I wonder if anyone has used the Python Caller transformer to create an ESRI feature layer using ArcPY or ArcRest to publish the feature layer in AGOL, Portal or ArcGIS server. I'd be interested to work together with anyone who has a use case for this. With Portal or AGOL writer I could create a feature service but I want my service to be rendered with the appropriate layer properties so all the user need to do is add the feature layer on a web map in Portal or AGOL. An appropriate SD file created from an MXD or lyr file would be necessary to store the layer properties.Per FME documentation: AGOL writer layer creation is not supported.

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?