Best Answers

Hi,I very new to FME and I am trying to get a hold of things. Right now, I just need to make sure I can simply distinguish elements added to the workbench. However, I can't seem to be able to rename everything. This PATH reader for example, properties are greyed out. There is only one for now but I am planning to add many more and I will need to differentiate them. How can I rename them and that is shows up in the workbench? Kind regards,Anne-Marie

Here is another simple-yet-not question: I am working with a large pdf and want to populate pdf_document_info_metadata attribute values for every feature.  I have tried: FeatureMerger, Joiner, Aggregator, AttributeValueMapper, NullAttributeMapper, AttributeManager (trying to use Adjacent Feature) etc. This should not be that hard, but I'm at a loss. Any ideas? Thanks,@lorenrouth​ 

FME Desktop 2020: How to filter all features that “don’t contain” a particular value? For example, in the screenshot below, I wanted to select all records that their “concatenation” field doesn’t contain the value 10  

Hi, I'm still fairly new to this tooling ecosystem. I have "inherited" a workbench and have made some changes to it. At some point, one AttributeManager started to appear in the "Incomplete Transformers" section of the Navigator. It's missing the attribute called "subcontractista": What I don't understand is, this attribute is being consumed in the preceding custom transformer as well as in the other branch that leads from it. I mean, in the following image, the green transformer is parametrized by this attribute and in the Tester that is hooked to the output, this attribute is visible under the FME Feature Attributes tab.There is no other AtrributeRemover or AttributeManager that might affect the presence of the attribute "subcontractista". In fact, I'm quite positive that I haven't changed that part. 

Dear users, I have a string attribute stored in a field for >150k point features including addresses, numbers, and sometimes additives. Three examples of addresses:  Maria van Reedestraat 9-BSEduard Künnekehof 1Bucheliusstraat 11-BS What I would like to have, is a new attribute indicating only the street name (= everything before the last space) and a new attribute only having the street number plus additive, which matches everything after the last space.  I have found some tips regarding regular expressions, but I haven't found a way out yet.  Any help would be appreciated! Thanks in advance, Martin

On Download area (https://www.safe.com/support/downloads/#past-versions), there are only the Build 21635 and the Build 21627.Best regards,

I would like to apply an Excel macro to an Excel document which I have just written using FME Desktop 2020.2. Python Interpreter used is 3.7.This can be done using the library xlwings according to this post. According to the FME documentation I installed xlwings in the folder: C:\Users\<name>\Documents\FME\Plugins\Python Next step I tried to import xlwings using Python StartUp script in FME Desktop.import sys, six, numpy, xlwingsUnfortunately I got this error: Python Exception <ModuleNotFoundError>: No module named 'pywintypes' Is there an easy way to solve this? In case the answer is no, I will switch to another library which can apply a macro to Excel output. 

I'm using FME DEsktop 2020.1, version 20200605-Build 20573 on Windows 10 I have problem with the built in Webbrowser/web view in FME when trying to authenticate Webforum. The Web Service Authentication window(web page) is just white. It did work (rendered the web page) in the past, so Webforum must have added some html/css/iframe that does not work with FME's web component. I talked to Webforum about this and they say the problem is within the built in webbrowser in FME. (Webforum already support Chrome, Edge, Firefox and Safari) It's possible that the built in webbrowser does not support iframes or other html that Webforum use. Have anyone had a similar problem and managed to solve it somehow? FME developers, what web view/web component do you use to render html pages? FME developers, is it possible to use for example Chrome browser instead of the built in webbrowser to authenticate?  

Hey! I have a bunch of polygons (in 3D) that I want to create break lines between. My idea was to use Intersector but it does not create the break lines for some reason. I have attached my workspace. To clarify, the green lines in this image is the result I'm looking for.  

Hi, I have two shapefiles that represent two boundaries that are suppose to align in a perfect world but due to updates, they are now misaligned. The datasets are for the whole province and I need to find the area/ the specific part of the boundary that does not align with the other boundary. The boundaries are polygons but then are transformed into lines, and I need to find a way that the line that is misaligned with a 10 meter tolerance will get highlighted.  I have tried neighborfinder and spatial relator (+using buffer for 10m tolerance) but the softwares outputs keeps highlighting the entire polygon or an entire section of lines (even though one line might be misaligned).  Does anyone have any suggestions or ways to go around this? Any help will be greatly appreciated! Thank you.

Hello everyone! I have a really serious problem, which could ruin my show to an important client early next week, and I would really love to help. I have an automation that is operated by watch directoery. I use a file that comes to the folder in the next operation in automation, by filepath.The problem is that the next workbench, reads the filepath badly. (All files are on the server). Here is an example of the log files: The 1609, is from automation which I used {file.path}.as you can see,The system stops as soon as it does not recognize the dwg file.And in work 1610, I put the same file, but set it up manually.Then it worked wellI looked closely, and I think I know what the problem was,​When it reads the file in 1609, it reads it like this:​file_dwg: $(TiuomMaarhot) Petah_Tikva \\ kb-2021-5 \\ Received Files \\ tb400031528.dwg​But in 1610 he reads it like this:​file_dwg: $(TiuomMaarhot) / Petah_Tikva / kb-2021-5 / Received Files / tb400031528.dwg​The difference is in the direction o

FME Desktop 2020: How to delete All layers (feature classes) available in the destination esri file Geoddatabase before writing on it from a workbench? For example, in the screenshot below, I wanted first to delete all layers that are available in the destination esri file Geoddatabase before writing in it How this could be performed?  

I tried FTPCaller using the full path to the file I want but I am unsure of authentication as it seems undocumented. I am unable to use username and password and must use SSH key files. Setting to ssh-agent seemed like the way to go but how do you choose your key file? I am publishing to Cloud anyways so I thought I would look at what was there and seems there is upload capability for sftp using a subscriber and ftp watcher (no sftp). Am I missing something?

 I´m right now trying to learn the basics of FME and have been busy doing calls to open data in Sweden, primary published as json files. I have managed to read the, and explode a list and write back to an excel file. I now try a larger dataset of about 1 million rows. I can not figure out how to extract more than the limit 500 records. I have tried searching in the forum an Google without understanding how to proceed. I attach the links to the dataset below. I would realy appreciate if someone could show a setup that loops and writes all data to a csv for example.  Dataset:https://www.vgregion.se/ov/dataportal-vast/#esc_org=https%3A%2F%2Fcatalog.goteborg.se%2Fstore%2F6%2Fresource%2F1I try using this download URL: https://catalog.goteborg.se/rowstore/dataset/ce5b8afd-6721-49c7-9ebc-f1ad33fba266

Hi, I have a workbench that joins and manipulates data, then at a certain point it reaches an aggregator and creates two columns:Column 1 output sample:20688<br>1476<br>14633<br>14516Column 2 output sample:560 Hague Street LAVINGTON NSW 2641<br>449 Smollett Street ALBURY NSW 2640<br>601 Stanley Street ALBURY NSW 2640<br>599 Stanley Street ALBURY NSW 2640After this aggregator I am trying to send an email which includes a simple output body like: 20688 - 560 Hague Street LAVINGTON NSW 2641 1476 - 49 Smollett Street ALBURY NSW 2640 14633 - 601 Stanley Street ALBURY NSW 2640 14516 - 599 Stanley Street ALBURY NSW 2640Any ideas how to get it from the simple aggregator with these two outputs into an email?      

OK, here goes.  I have some data in a SQL Server database but it is stored in an object-oriented fashion which means a normal SQL query doesn't work, I have to pivot data in order to create a traditional tabular view.  Now that in itself wouldn't be a problem, but all data is stored in the same location with each asset class (e.g. door, window etc.) having a different number of attributes, so depending on how I pivot I get the relevant attributes as fields.  All good so far?  OK, so I want to push this data from the source database into the target database (Oracle in this case) and the method for doing this is currently using SQLCreator to create the fields by which I want to pivot (based on the asset class as a parameter) and then SQLExecutor to retrieve the pivoted table, which works, up to a point.  What doesn't work is that the attributes of the output from the SQLExecutor are not exposed, and I can't get them to be exposed without Populate from SQL Query option, which fails as it 

I am using FME 2019.2 to read multiple Autocad drawings (r.2018) and then write them out into a single combined DWG. I've referenced a template file with all of the block definitions in it for the writer, but cannot seem to get any of my CAD blocks to write. The log tells me that "AutoCAD Writer: 3189 feature(s) were rejected and not written to the destination dataset", but doesn't give any hint as to why they were rejected. I've tried this using both the RealDWG and Map OD readers & writers, and I've tried it both with and without a DWG Styler transformer. Why are my blocks getting lost in translation?

Hi, I want to create a dynamic workspace. I have an excel file and I want to execute everything from there. I want to send database information for sqlexecutor via excel. but I couldn't find how to add format and dataset information. Is such a thing possible? 

I work for a deck building company that consistently needs to find lot boundary markers, but due to lack of information sometimes we are unable to identify where the boundaries of a lot are. We are exploring and trying to find ways that we could easily find the part of the lot that is the physical boundary marker of the property. Assuming we are able to find longitude/latitude coordinates, we are looking for software that could allow us to enter that information in a smartphone in order to be guided to that point on a map on smartphone. Thanks for any input you may give!

Hello, I have a large workspace and there will be more developers that will develop it.I was wondering if we can use Git from inside the workbench. A visual diff that would identify changes in nodes and their properties, like e.g. Node-RED does, would be extremely useful.We already have the project in Git and treat it like a binary file.

Hi all.I'm trying to expand an existing workflow, that outputs Shapes and TABs (and FFSs) just fine with an option to output GeoPackages as well. This does not go well.I'm using dynamic schemas, and merges the relevant schema information onto each feature. Then I use FeatureWriter with "Schema from schema feature" to output the data to a file, to be attached to an email. I normally use ZIP, but in this case I just want to use GPKG.The first problem is, that the writer ignores the request for dynamic schema, and attempts to output any and all exposed attributes.The second problem is that each attributes gets the data type TEXT(200).Is there a trick to have FeatureWriter outputting a Geopackage with dynamic schema ?Cheers.

We have FME-Desktop and FME-Server installed on two separate machines.An external office is helping us setting up FME-Server and transferring our workbenches to the server.Our informatics department is very strict with granting access to servers and it's only possible for them to access to the server on which FME-Server is installed with a two step identification (SMS-Code).They can access to the server with FME-Desktop as well, but they cannot upload FME-Workbenches to the server, as they cannot establish a connection between the two servers. Our plan is now to install FME-Desktop on the same machine as FME-Server. Are there any arguments against this or can it be done without problems?Thanks, Vera 

I have to combine 30 sql tables into 1 while preserving globalID unique identifiers. These tables have slight differences in column names (i.e. GlobalID vs globalid or JobsiteGlobalID vs JobGUID). These need to be mapped during the insert. I want to be able to run this multiple times so I'm looking for an "if not exists" append transformer. Any recommendations? I've looked as FeatureMerger, but it doesn't seem to work with 30 readers. I've tried a simple append, but re-running causes issues.Thanks.

I have a layer with 75 parks. I need to buffer all of them with 300 meters. But after this I need to clip the buffers with roads and railways(barriers). When I done this I only want to keep the polygon that are on the right side of the road. Sometimes these areas intersect an other park. So if I go for spatialfilter areas are kept even though they should not be. On the pictures below I only want to keep the selected polygon(yellow) because that polygon are intersected of the orgianal park. I've tried group by i spatialfilter but get no success. Is it possiable to solve this? Have attached my workbench with orginal data.  best regardsJesper