Best Answers

Hello,I have please a question about the "CombineOnAttribute" parameter for LineCombiner (FME 2019 Beta)Is the logical relation between selected attributes to combine on is "AND" or "OR". In other words, 2 lines will be combined if they have same values for all selected attributes together or at least one common attribute ? Thank you very much.

Hi all,I want to remove duplicate rows, keep only one.For example: An Vân 2 rows, keep only row. Could you tell me how to make it? Thank you

Lately I have been working a lot with Postman. One of the nice features of this tool is that you can define environments, e.g. development and production. For each environment you can define it's own set of parameter values. So when you switch between development and production, the values for the url, userid and password are automagically changed also.How can I achieve this same behaviour in FME? I would like to have a published parameter that lets me choose between development and production and subsequently sets the correct values for url, userid, password and possibly other parameters.

I'm having trouble building my DWG file again. I've done tests in several ways, using FeatureWriter, using template file, but nothing helped me.Follows my workspace:   I just need to read the file and write it to DWG identical to the input file. See the differences in the images below: the input filethe output fileinputoutputinputoutput Thank´s

Hi, I was wondering if anyone has created a dynamic update detector. Ideally where you pass the original table, revised table, key attribute and attributes to match as parameters to a workspace or custom transformer. something along the lines of:At the moment I would need to have all the tables dynamically popualted along with the key attribute and attributes to match. This is because when I tried to do it with defined tables I run out of memory, so it would be more ideal to do it one at a time. This could then be super reusable in all code.  Many Thanks for any help or pointers. Oliver

Thanks for the help in advance and happy holidays everyone.I am running the SystemCaller to undertake a particular task, it takes a while and FME runs it multiple times.The issues is I need FME to continue only after system caller has completely finished all the tasks.Can someone please suggest a work around, I have tried a counter but not having much luck with it at the moment.Thank youOliver

I've successfully written out text nodes to a DGN following the information in this article:https://knowledge.safe.com/articles/1539/writing-microstation-dgn-text-nodes-with-fme.htmlThe text nodes are displaying in the DGN and look correct, however, FME is generating warnings for each text node being written out and each feature is being logged as follows:Feature specified type fme_text, but did not have the appropriate geometry attributes for this type -- feature has been logged, and will be passed to the writer as-is+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++Feature Type: `__GO_TO_FINAL_OUTPUT_ROUTER__'Attribute(32 bit integer) : `Loop to MultiTextCreator_2_MultiTextElementBuilder_2_Input1545672846 Input Splitter.BranchingFactory.Count' has value `1'Attribute(64 bit integer) : `MSLINK' has value `364787'Attribute(string) : `__wb_out_feat_type__' has value `All Levels'Attribute(encoded: UTF-8) : `fme_feature_type' has value `Level 44'Attribute(string) :

Hello, I have in front a reader SpatiaLite composed of different layers (hydrographic basins, communal limits, regional limits ... "). I want to propose to the end user a list of extraction options (list of watersheds, list of municipalities, list of regions ...) according to a type of previously selected right-of-way ("watersheds", " regions ", ...).I arrive with a published parameter applied on a transform tester to select the type of footprint stored in the format attribute "fme_feature_type" and store it in a new field "Emprise" with the "conditional attribute values" in an AttributeManager.But I do not succeed after to chain a selection on the selection via a second published parameter. The selection of the right of way is not filtered according to the first choice. Thank you in advance for all your advice.

Can I use a Azure SQL Database (PaaS) as FME Server system database similar to how I use a on-premise Microsoft SQL Server Database?

Hi,I'm trying to combine two data streams based on keywords. (chain)   How can I do this? Thanks, Ed  

When use generic reader on dataset on local disk works fine but when hit through URL and workbench gives back this "Generic Reader: No valid reader name specified, guessing reader name from dataset" and failed to load dataset

I would like to use the Tiler transformer to create 100x100m tiles. How do I specify this? They only size option I see is listed as "ground units".

My goal is to provide a live updating KML file to be displayed in Google Earth for Chrome. My process is to create a KML file and then upload to Google Drive. The problem is that the new upload becomes a new file with a new location, so Google Earth doesn't know where the latest KML file is. Instead, I just want to update the existing file. Maybe GoogleDriveConnector doesn't have that functionality?One option would be to create a Google Drive API Python Script, but that doesn't seem very FME-ey. Thank you for your assistance.

I use attribute with extracted geometry in WorkspaceRunner and pass it to another workspace's user parameter. I then use user parameter in GeometryReplacer and get reject.I asume that problem accours when user parameter changes attribute encoding. I tryed to lab with AttributeEncoder with no success. Every time i use value from user parameter with geometry string, encoding is changed to utf-8 and GeometryReplacer seems to not like that.Is FME cabable av passing geometry to other worspace as attribute?

I have built a workbench where I do some processing on a set of features and then test the result. If the result is not what I want I would like to go back to the original feature and send it down a different path. How do I do this? I know how to find duplicates, set counters and such, but how can I compare the attributes from features in two separate "data streams" and then output one of those "streams"? Apologies in advance for what is probably a very simple answer, but my Google-Fu failed me this time.

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