General

How can I delete an AGOL table with FME? Thank´s

Hello, I noticed that in the Coordinate System Gallery it is missing the EPSG:3794 for Slovenia. Am I correct or I am looking for something wrong?

I would like to reuse some parts of a workspace in such a way that the combination/module of transformers is only written once but used by "many". I would like to reuse these "modules" so that it can be used by different streams. A simple example to explain what I am after: Imagine that I have created a group of transformers that conducts some wizardry, a module of sorts. How can I use this in such a way that it makes copies of a Feature, applies different amounts of "something" and then fans out the result in a file for each "something"? I understand that the question is vague, I was hoping for suggestions for further reading so that I could try and understand the principles for this. Should I be looking at custom transformers? Child workspaces? Or is there an other way to achieve this?

Hi FME'ers,Have you ever - as I have - wondered why some software installers are different? For example, some software is just a standalone file that runs by itself without installation; some have an installer that simply installs the software to a specific location; some ask you to extract the installation files first; and others install a manager that then downloads and installs the actual software. Well this week I found out a few secrets about installers, and that happened because I discovered that the FME Desktop installer is changing for Windows in 2021. Current vs New InstallerThe current FME Desktop installer is a .msi file that simply installs FME where you want. The new installer will be a .exe file that first asks you to extract the contents to a temporary folder. It's a "bootstrapping" technique, to use the technical term. The process extracts the installation files and then automatically runs them. But this technique adds an extra step in the installation

Hello everyone, I recently tried to install the paramiko library in my FME environment using the command: fme.exe python -m pip install paramiko --target C:\\Users\\NMI\\Documents\\FME\\Plugins\\Python On my local machine it works as expected. When I try to install it at the customer however it fails with the error message: Installing build dependencies: finished with status 'error' Further in the log it returns the following information (newline characters have been added to improve the readability): Expected an even number of command line arguments, instead got 9 for command line: >> `pip' `install' `--ignore-installed' `--no-user' `--prefix' `C:\\Users\\NMI\\AppData\\Local\\Temp\\pip-build-env-ilnw8_md' `https://files.pythonhosted.org/packages/c3/a9/5dc32465951cf4812e9e93b4ad2d314893c2fa6d5f66ce5c057af6e76d85/setuptools-49.6.0-py3-none-any.whl#sha256=4dd5bb0a0a0cff77b46ca5dd3a84857ee48c83e8223886b556613c724994073f' `https://files.pythonhoste

Have the same issue in FeatureMerger, all remains unmarked. So the data which looks identical and should merge is invisibly different (did trim it)

Hello, I am trying to retrieve lat/long/rotation attributes from jpegs sitting on Azure but can't get it working.  My workflow is as follows:I read features from AGOL with attachments, attachments get stored on Azure Blob Storage, then I try to retrieve lat/long/direction of jpegs and write these data somewhere else.Attachments coming from AGOL or Azure come in binary format; which makes exposing jpeg's metadata tricky. I have no problem getting lat/long/direction if jpegs sit on my harddrive. I've tried to use BinaryDecoder, got (TextEncoderFactory): Invalid Base64 character 'ÿ' error. I've tried RasterReplacer. It shows the actual photo but AttributeExposer doesn't expose metadata this way. Below are screenshots of my workspace as well as attachments' attributes:  Please help.

Hi, so there may have been a bug in my SQL (I'm not convinced) I tried to fix it and it still didn't work then I cleared the sql in the Where clause and it still reported a error. I then created a new sql reader from the same DB connection and got an error. next I replaced the DB connection. the older reader that had the sql in the where clause still reported an error. the newer reader that never had sql in the where clause works. both report that they are using the DBconnection 'GISDW_test. the older one has the error:Microsoft SQL Server Non-Spatial Reader: Query failed, possibly due to a malformed statement. Query Text `SELECT [mirn], [year], [state], [readingType], [maxFlow], [janDays], [jan], [febDays], [feb], [marDays], [mar], [aprDays], [apr], [mayDays], [may], [junDays], [jun], [julDays], [jul], [augDays], [aug], [sepDays], [sep], [octDays], [oct], [novDays], [nov], [decDays], [dec], [slope], [intercept], [r2], [count], [regressionComment], [qualityFlag] FROM Syne

Dose the FME template support setting permission to run

I am trying to merge some data with the FeatureMerger. There are two datasources. Merging should be done when: AttributeA = AttributeB OR AttributeB = AttributeA(It skips ahead if I only use one of these) How do I do this? I guess I could use the text editor, but am unsure of the syntax. Or should I use the InlineQuerier for better results? Same thing there though, I don't know the correct syntax.

Hello everybody,I was wondering if FME can build a network starting from an xls file containing nodeID with its coordinates (x and y) in one sheet, and arcID with its start and end nodeIDs. Wich transformer should I use? (tried with topology builder but seems I'm missing something)This is part of the node sheet: and this is part of the link sheet:The final aim is to write an .shp file with the nodes and one with the links, and .dxf file with the entire network, but so far I managed to process the nodes only.Any advice?

Hello FME'ers,Here is the chosen Question-of-the-Week. As always, to view these regularly, hit the Follow button in the top-right of the forum. This week, I'm looking at a question about JPEG files and how to get their info from an online blob storage... Question of the WeekIn this question, user @alex.west​ asks...Q) I am trying to retrieve lat/long/rotation attributes from jpegs sitting on Azure but can't get it working. Attachments coming from AGOL or Azure come in binary format; which makes exposing jpeg's metadata tricky. I have no problem getting lat/long/direction if jpegs sit on my harddrive. A) I'm assuming that the metadata you need are what we call exif tags. It's true that if you read a JPEG file directly, then you get these tags as attributes. But if you read the file as a binary attribute, then it's not as simple. So let's see how we can do that, plus how my new favourite transformer - the TempPathnameCreator - will help us. My ScenarioI do

I have +30 million records in one PostGIS database, and a few thousand in a GeoPackage, the latter of which are in the same geographical area (a few square kilometres). Is it possible to get the MBR of the GeoPackage and automatically populate the search envelope field of the PostGIS reader? This would make my FeatureJoiner a lot faster. Thanks in advance.

I want to use LineBuider to connect pairs of points. Thing is that they need to be grouped such that Attribute_A equals Attribute_B. All features contain both Attribute_A and Attribute_B. I am sure that there is a clever workaround for this, but I cant figure out how.

Hi, Regex help please. I'm trying to replace the last space character in a list of names with a comma. Some of the names have multiple spaces in them: Example:John DoeJohn Charles DoeJohn Jimmy Charles Doe The result I'm looking for:John,DoeJohn Charles,DoeJohn Jimmy Charles,Doe Thanks! 

Hello FME-friends :) I want to use WorkspaceRunner to run a workspace containing one reader with multiple shapefiles in it. I can't get it to work. To me it seems this is a limitiation in the workspacerunner. WorkspaceRunner works fine if it runs a workspace containing one reader with only one single shapefile. General question: Is this a known limitation? I can't find anything on this topic.

@david_rI am using fme server 2018, have a simple workspace to send an email but I am getting this error I had tried to change the description to all option there ( SSL,TLS , NONE )but still getting this error  Report_Emailer_2: <class 'smtplib.SMTPNotSupportedError'>: SMTP AUTH extension not supported by server.The below feature caused the translation to be terminated

Both the Matcher and the ChangeDetector will compare all list items if the AttributeMatchingStrategy is set to 'Match All Attributes' or 'All Except Selected Attributes'. It doesn't appear to be possible to select an entire list as a selected attribute however, the interface always asks to specify elements, is there no way to specify all list elements? Assume the list length is unknown so it's not possible to specify a range

Welcome to What’s Up Wednesday!  This week features FME Hackathon news, the Gartner Magic Quadrant, classic geometry and the Dissolver transformer.  FME Hackathon: ConnectionsHave you been thinking about creating a project for the FME Hackathon? If you have, you have one week left to submit your projects. The submission deadline is Monday August 31st at 11:59pm PST.  Join us on September 9th at 8am PST to help us judge the winners!  Safe Software NewsAfter a long process, we are now featured on the Data Integration Tools Magic Quadrant from Gartner! To learn more check out fme.ly/gartner-2020  FME TrainingLooking to brush up on your FME skills? Our live online training schedule has been posted for the fall. Can’t commit to a live course, our courses are recorded so you can watch at your own pace.  FME WebinarsThere’s still time to sign up for our webinar tomorrow about Working with Spatial Data at Scale in the Cloud.  We also have lots of upcoming webinars in September about Excel, cha

Bonjour,Je suis débutant et je voudrais fusionner ou joindre 400 fichiers de formes (shapefiles) en un seul fichier. Toute aide serait très appréciée!merci beaucoup

What affects the size of an INSPIRE gml file and how to reduce it?

I got my Looping Transformers working but it feels wrong to do it the way I solve it now. How would others solve my problem? I do a webrequest and in my result I recieve a value I need for my next request. At this moment I use a CustomTransformer with a published parameter set to AttributeName. Then I use an AttributeCreator to move the value to the AttributeName I use in my customTransformer. Right before the looping port I write the Value back to the Published parameter. For information about the Api: https://docs.ndw.nu/api/trafficsigns/nl/index.html My goal is to download the dataset from a specific date to now.     

Can the httpcaller reference a pfx cert for authentication?

Hello all,I am attempting to create a published parameter within a custom transformer that prompts the user to state which is the primary key field from the input database table. Is there a way of creating this published parameter, whereby it provides the user with a list of all available feature attributes (i.e. database fields) from their input table, so that they can select which is to be nominated as the primary key? ##Update, it looks like I have managed to answer my own question - you can use the Type: AttributeList within the the published parameter to achieve this As a follow up question, does anyone know how I can then use the user chosen parameters within a stringreplacer transformer to update a field? Basically, using the data example below, if the user, via published parameters, the user has nominated colA as their primary key field, and nominated colB via another published parameter, is there a way of then using the values within these fields to then replace colA as a conc

I would like to ad identifiers to pairs of "touching" endpoints. So if two endpoints touch (or are within a given buffer) they are to be tagged with an identifier that is unique to this pair. Lets say that the first two touching endpoints both are tagged with 1 (or A), the next pair with 2 (or B) and so on. How can I achieve this?