Best Answers

Hi all,  After some investigation I found out my Excel reader file contains "line breaks" causing FME to write the content of a single Excel cell to multiple lines.  Is there a way in FME to clean line breaks?  Thanks, Ed

I'm looking for a way to set a datasource based on where the workspace is run.My current setup:Private Parameters PathDev, PathTest and PathProd.AttributeCreator creating Path. Value is conditional:if $(FME_ENGINE) has no value then PathDevelse if $(FME_ENGINE) contains test then PathTestelse PathProdFeatureReader reads from Path / FeatureWriter writes to Path.This works well but it has a disadvantage when writing. I can assign Path in the beginning of the workflow and have to keep the Path attribute through the entire stream. Or I can assign just before the FeatureWriter but then it has to run the conditional for all features, which is useless expensive.Can someone give me a pointer how to do this? My Python is nonexisting...I hoped something like this:if FME_MacroValues['FME_ENGINE'].str == "":    return FME_MacroValues['PathDev']if FME_MacroValues['FME_ENGINE'].str like "test":    return FME_MacroValues['PathTest']else:    return FME_MacroValues['PathProd']Thanks in advance.

Generate Unique id in ArcGIS for Sql database.

Hi, I have a problem with writing components to a pointcloud (.csv) file. I made a workbench that merge 2 pointclouds using the pointcloudmerger. The pointclouds contains depth information of a river and represent 2 different periods. There is partly geographic overlap of the information so a made a merge that results in 3 outputs (merged based on X and Y, not merged and unreferenced), with a pointcloudCombiner the 3 outputs will be combined to 1 pointcloud and a pointcloud writer write the new created pointcloud (.csv). The problem is that in the new pointcloud only a few components (x, y, z and z_last) were stored. The original pointclouds contains a lot more components (depths from every measuring period and more) and I see these components in the data inspector but not in the new created pointcloud, is there a possibility to store the original components also in the new created pointcloud? The attached picture shows the output of the new created pointcloud and the data as shown in

I use Raven GPS systems for tracking industrial assets. Can I connect to the API using FME? How can I use FME to make my life easier?

I am using a FeatureReader to connect to our SDE GDB. I want to add a query (WHERE Clause) to the FeatureReader so that I am only pulling in records within the Feature Class that were edited within the last month (or sometimes edited in the last 5 days).When I look at the SDE data via MS SQL Server Management Studio (SSMS) vs within FME's Data Inspector I see the data in different formats:Within SSMS - LAST_UPDATED field is a DATE field:  last_updated (datetime2(7), null)  2018-12-01 16:23:56.0000000Within Data Inspector - LAST_UPDATED field is STRING field:  last_updated (string)  20181128133118My questions:1) is there a way to specify which attributes I want to be brought in? Right now I am using an attribute manager to remove the unwanted attributes.2) How do I only at a WHERE Clause so that I only pull in the data I want within the specific time range? I have tried "last_updated" > '20180500000000' but this brings in nothing. I a

Why do i have to specify the source en result data in the Jobsubmitter while that`s already in the workspace

Hi all,I have a question a bout spatial join.I have 2 folder data. Folder 1(GA Folder) and Folder 2 (CHANGE REGION).I want to join spatial each file in folder 1 with a file in folder 2 which the same date.Actually, I can use testFilter for each date but it's manual. So I want to use other way to make it automatically. Could you show me how to the way to make it?Thank you

I'm trying to convert ISO datetime to FME DateTime in 2015 version. Have tried using DateFormatter transformer but gives wrong output. It is strangely displaying Expected datetime+02:00 hrs. It looks like it may work in other versions, but not in 2015. Not sure what the issue is.For ex: The value 2018-12-13T22:05:36.000Z (ISODateTime) gives 2018-12-14 00:05:36 instead of 2018-12-13 22:05:36Any suggestions please? Thanks in advance.Tagging @takashi, @david_r.   

HiI am trying to create drive time zones for a data set with 2-5 starting points, much like image #2 here, http://desktop.arcgis.com/en/arcmap/latest/extensions/network-analyst/what-is-network-analyst-.htm. I read https://knowledge.safe.com/articles/30048/creating-time-and-distance-isolines-using-the-netw.html and I managed to create drive time zones for a single starting point:Each zone is 3 minutes of travel. However, I am looking for a solution for using multiple starting points. The idea is to see what happens to drive time when adding or removing points (clinics, in my case). Any suggestions on how to achieve that?Currently, the workspace looks like this:Regards,Magnnus

I have a template that I call and run with parameters but one of the parameters can be like this "something - else", but it only read "something", I need the whole word. any ideas?Thanks

Hello:I have an external resource that has an API that utilizes basic authentication using a token.When I run the api call using postman or other REST API testing software, I get an OK response.When I try running it using the httpcaller, I get a:HTTPCaller(HTTPFactory): Received HTTP response header: 'HTTP/1.1 403 Forbidden' message.Inspecting the response body gives:{"code":"rest_forbidden_context","message":"Sorry, you are not allowed to view entries","data":{"status":403}} I know that the api is working because it works in POSTMAN and other REST API testing software. What am I missing to get http caller to work?I'm new to APIs and to FME. I'll be happy to provide any info needed.Thanks! Herbert Cruz Here's the input on FME. And here's the RESTLET testing input   Thanks everyone!

Hi,Just wondering if anyone had any success reading data from the ArcGIS Online Living Atlas? Thanks

Dear FME community.I try to integrate data into ORACLE but FME say me : error was `ORA-29875: failed in the execution of the ODCIINDEXINSERT routineDo you know what does that mean ?Thanks

I have a table with three attributes: NAME, LOCATION, and AREA. I want to get the row with the largest area, for each name. In Oracle, I can do so with this query: select    name,    location,    areafrom (    select        name,        location,        area,        max(area) over (partition by name) as max_area    from mytable)where area = max_area I could put this into a SQLExecutor, but I'd like to be able to do this even if my data source isn't Oracle.  Can I accomplish this using FME transformers instead?

Is it possible - if my translation fail, user will get an email with fail message, if translation is successful, in that case user will get an email also with successful translation message.

Hi FME'ers,I have two network datasets, one for all streets and one for footpaths only. There are instances where the footpath and the streets follow a similar path. This is never exact and they often weave around each other, intersecting each other at multiple points. I need to find a way of identifying sections where the street network and footpaths are similar. The goals is to reconcile their geometries but the decison over which geometry take precedent is not mine to make. I have attached an example. The green is the street network and the turquoise is the footpath. Thanks,David

If I wanted to hide a transformer so that it couldn't be added to the canvas in an FME workspace, can it be done? I don't want to do anything drastic, just tuck it away so that another transformer would be used instead. Lets say I didn't want anyone to know the 'Reprojector' existed in order to ensure they always used the CSMapReprojector, is there a file I can edit somewhere to 'comment out' the Reprojector...?I've tried editing \\transformers\\fmesuite.fmx to no avail.Many thanks...

Hello,Can someone please help me to understand the topology builder attributes : right_edge and left_adge with some concrete examples and illustrations ? I've tried to understand and apply just from the description in the transformer docomentation but couldn'tThank you very much in advance

Hi,I have two datasets of line features which I want to check individually for duplicate line features. However, the output containing the duplicate line features of both datasets should be combined in one dataset. I used a Matcher transformer on each dataset. When combining the output I of course get similar match_ids for features, that aren't always matches of each other. How do I adapt my workbench to avoid this? Is there a way to set the match_id attribute of one of the Matcher transformers to start counting at a specified number? I also can't send both datasets to the same transformer, because for my datasets that would result in unwanted matches. a simplied version of the workbenchAnd a simplified version of the generated output 

Morning all I am trying to check some DGN files are to a correct standard, i have to check each dgn file has the correct level names, Even if the level names are not used. Is this possible, or does FME only see the DGN Levels (fme_Featue_type) that are used.  I have used an excel list that contains all the level names, added the DGN file to check. Hooked these up to a feature merger, that outputs two excel lists. Missing Levels and used levels.  however a empty DGN that just contains a line on "Default" level, fails the test, even tho it has all the correct levels set up, Even tho they are not used? I hope this makes sense. Any help would be greatly appreciated.  Using FME Workbench 2018.1Reading DGN V8 Files and CSV

The Extruder's error I recently used the Extruder to process the floor plan and expect to be able to stretch it into a 3D building model, but I have encountered many problems. In the process, I used 3dsMax to generate the same model at the same time, and compared it with the model generated by Fme. I used Fme Inspster and VS Code to view the Fbx model and compare them. I got some of the following points and discussed them together. 1, The Location Is Wrong When viewing the model with FME Inspster, the model's position is correct. However, when using VSCode's 3D Viewer for VSCode module for single display, the position of the model is tilted and inconsistent with the position of the origin!I judge that there are two parameters "Geometry Instance Local Origin" and "Geometry Instance Matrix" missing! Because from the Fbx file generated by 3dsMax, both parameters are valued and the location is correct.My question is, why does FME not calculate the attribute

Hello,I would like to know if there is a syntax in the XML reader “Elements to exclude” option for excluding a node when it has a specific attribute value. For instance I would like to skip reading all nodes "complexAttribute" which have an attributeType equal to "TTOM-Name:Name.Body" such as in this example node:<complexAttribute attributeId="ee823867-532f-4fca-83ad-6dd9f8df7524" attributeType="TTOM-Name:Name.Body">…</complexAttribute> Such nodes could be present at different levels inside the XML. If these are skipped (because they contribute for a significant part of the XML volume and are not necessary for my process), then it will be easier for me to flatten the XML structure using a series of ListExploders for the remaining nodes.Thanks for your hints!Olivier

I am using FeatureWriter to ouput a text file.It does not put quotes around string attributes like it should.I want"2018-12-07 09:30:00","Canungra (Defence)",0I get2018-12-07 09:30:00,Canungra (Defence),0The third column is numeric and should not have quotes

I have defined a custom transformer, and it is outputting more attributes than what I want. I just want to output these two attributes (network_id and lower_network_id): But when using it in the main workbench, it is also outputting attributes from the original input features: I assume this is is because they automatically propagate all source attributes forward, but I want to avoid this, I just want the two-column list. How can I achieve this?