Best Answers

The documentation for Mapbox MBTiles MVT writer says the tiles are generated in WebMercator (EPSG:3857). Does this mean that you have to reproject first or the writer does this for you?

My httpcaller results in a response body that is made up like a csv: lat,long,timea,b,ca,b,ca,b,c I want the response body to be in seperate columns (lat, long etc..). I tried attributesplitter (both with , and carriage return as delimter)> listexploder > atributrenamer (attr_@Value(_element_index)). But I can not get it to work (it just makes a new column attr_@Value(_element_index)).  

I have attempted a few different techniques to get my desired output.1.) Reader->AttributeExposer->JSONTemplater2.) Reader->AttributeExposer->ListConcatenator->JSONTemplater3.) Reader->AttributeExposer->JSON Writer4.) Reader->AttributeExposer->ListKeyValuePairExtractor->5.) Reader->AttributeExposer->ListExploder->JSONTemplater6.) OthersI am working with values such as:objid | fme_attrib_info{}.field_name | fme_attrib_info{}.field_value |-------+--------------------------------------+--------------------------------------|1       | SERIAL_NUM                       |          12345                          |2       | TYPE                                     |          SOME_TYPE              |  My desired output would be as follows:{    "SERIAL_NUM": "123456",    "TYPE": "SOMETYPE}I've used the tutorial on site here for extracting attributes from CAD blocks. Now, I would like to take these attributes and make a json payload per unique block to be wri

Is there a way to extract the hyperlinks from a pdf using the pdf reader. At the moment I can see the text but not the underlying hyperlink. Thank you for the help in advance.

Is there anyway to read information using an FMW reader about a workspace that has been uploaded to FME Server without downloading first? I can automatically download to a temp location via the API if needed just wanted to check I wasn't missing an alternative

Hi community, I could use some help.I'm reading an xml, doing some geometric and attribute manipulation before writing out to OGCgeopackage format. I'm having trouble with the writer truncating the attribute values. My understanding is that by default, FME takes the character width from the reader however this seems to be too short for my final values so I've switched over the attribute definition from automatic to manual in the writer and increased the width. It seems to be ignoring this and coming up with a lot of warnings. Anyone know how to fix? Images attached.

Hello everyone, A customer of mine has created a lot of XSLT stylesheets which we want to apply to our XML documents. We would like to use FME for the automation part (download XML, apply stylesheet, write result and push to server). However I seem to receive an error when applying XSLT stylesheets of version 2.0. Version 1.0 stylesheets work as expected but the workflow throws an error as soon as it encounters a function that is only present in XSLT 2.0 (like lower-case or upper-case).The stylesheets that I used to test the workflow both work as expected outside of the FME workflow. Is XSLT 2.0 currently not supported? Or am I missing something?I am using FME 2020.0 - Build 20238 - WIN64.

Is there any way to rename attribute from  Proper Case to Underscore with BulkAttributeRenamer? Here is a few examples OrgNameComment -> Org_Name_CommentTaxRegNumber -> Tax_Reg_Number  Ideas? ThanksYarko

I am looking to merge into a list selected attributes from nearby points and output a single feature for each group of nearby points. PointOnPointOverlayer perfectly finds the nearby points and generates the list I want, but outputs all the input features with a list of all the other features. Thus for say 4 nearby features it will output 4 features each with a list which identifies the other 3 features in the group, but without anything like a group ID with which you could select just the first in each group with a DuplicateFilter.This is almost exactly the example given in the PointOnPointOverlayer manual page which creates lists of crimes at common locations... but doesn't explain how to not have multiple copies of the same list at the same location. Am I missing something obvious? It seems that PointOnPointOverlayer has done all the hard work!The closest I could get to generating a group ID is to give all my input points a unique ID field, then set "Merge attributes"

Hey there, I have a few workspaces that make use of the Esri File Geodatabases readers and writers. Processing a huge amount of data comes with some issues. In the past i had noticed a huge slowdown of my performance once i hit the last few transformers in the line. Last week i noticed the log line that comes up during the negative performance switch.  The line states: Optimizing Memory Usage (something something)Ram usage stabilizes from ~2,7 GB down to about 2,4GB and does not rise anymore. I have more than 10GB of available space left but it will not use more, probably because its the 32bit version. After that point, i will only be able to process around 5-10 objects a second! This is extremely slow if compared to before that point, which was around the thousands a second or even more. I am looking for a solution to this issue and came up with the following idea:If i export the data from the file geodatabase in FME 32bit to something supported by FME 64bit, do the processing on that

Hi all, I have a question about FME Cloud and the Temp folder.  I have found that the results from the DataDownload and also when data is uploaded to FME Server it goes into the System/Temp resource and not into the Temp resource.  Is there a specific reason for this? I've just been looking at this article and have bumped up my temp space. But when looking and the usage on the FME Cloud console it seems it's never really used.  By contrast the Primary disk is getting used constantly for tasks like writing out DataDownload results and Upload results.  Any thoughts? Should I just reduce my temp again? @gerhardatsafe​ what are your thoughts? Thanks in advance

Hi, how is my community account linked to my webinar subscriptions? Maybe by the e-mail address? Thanks

I have successfully used readers that point to download links for datasets in the past. I have a situation I am up against now where using this method does not work. I have two different links I am trying to read from: Link 1:http://gis.co.slope.nd.us/This link takes you to a map viewer with a button that allows you to download either a geopackage or a shapefile of the dataset. However, when I try to right click on the download button, there is not an option to copy the URL of the button itself, so I am not able to use a reader to download then process the data. Link 2https://adams.offroadsoftware.com/php/downloadShape.php?isbnai=4e57016981c3155bb6834af1ce0389aed3460eb0343d94d01e8379a88138b68e When I click this link it downloads a zipped geopackage without taking me to a web page. Similarly, I cannot get a reader to successfully read this link. Does anyone have any advice/tips/solutions for either of the above two items? Thank you in advance!  

Hi,i'm wondering if someone knows which mix of transformers i can use to 'align' (extend or trim) polygons along lines? I have polygons of road area and i have a line which is the separation between the road and the sidewalk . the point is that the polygon edge of the sidewalk is not align along the line and i'm looking for a way to do this for thousands of them. In Arcmap, the tool 'Align to shape' is the key to that but definitely not an option for thousands of areas...  thank you for reading this. Hope that someone will help me! Max

I have a transformer that Lists a set of companies in a database schema and then fires off a set of workflows. These end in 5 SQLExecutors which migrate the data into another database. I want to be able to run a final tidy up process after these are all finished. The input must come from the List_Company_Schema process, not the SQLExectors but it must wait for them to finish. How do I do this?

I have fed it into a NullAttributeMapper to make sure all Nulls, Missing and Empty fields are uniform. That's fine, and so is the Date transformation when inspected. However it still rejects any of the Null fields, and when it outputs to the AttributeManager, all of the fields are then Null. Even the ones with a date value. I've checked the "Passthrough Nulls, Empty and Missing" values to "Yes", but still no luck. It seems to apply the null to everything in the DateTimeConverter.I've tried with a new Transformer/rebuilding that section, and have also restarted the workspace, as well as clearing any temp files. Any help? Thanks

The statistics Calculator gives this error when trying to count the sum of an attribute: 2020-08-11 12:49:59|2233.8| 2.3|ERROR |Python Exception <MemoryError>: 2020-08-11 12:49:59|2233.8| 0.0|FATAL |@Python failed to execute function `StatisticsCalculator.recordFeature'2020-08-11 12:49:59|2233.8| 0.0|ERROR |StatisticsCalculator_2_InputProcessor (TeeFactory): StatisticsCalculator_2_InputProcessor: @Python execution failed2020-08-11 12:49:59|2233.9| 0.1|ERROR |StatisticsCalculator_2_InputProcessor: @Python execution failed There was approx 2.5M features passing through each one having a value of 1. So the sum operation should not be exhaustive. What could cause this? A bug?

I have two featureWriter fed by same feature. I want to write on a PostgreSQL database. I specify one with a schemas (Table Qualifier) and the other not.After that I want to use the result who was write to manage my foreign keys. The summary is the same (2 features written). Is it normal that when I specify a table qualifier, any of my feature can't be used after the FeatureWriter ?

Hi I am trying to find the features that has attachments.So far I tried Tester and ListSearcher but I couldn't get any results.Tester Parameters:Left Value: arcgisonline_attachment{0}.content_typeOperator: Attribute Has a Value ListSearcher Parameters:List Attribute: arcgisonline_attachment{}.dataSearch Type: First to contain regular expressionSearch For: .(also tried ^$)

I have a spreadsheet derived from a pdf report containing dates/times tickets were purchased in a number of car parks. Unfortunately, the car park name is not a separate column, but instead it appears as a heading before the data. Is there a way to split the data at the end of each section? Eventually I would like the car park name as a separate column, but I guess to start with I need to split the data into different sections? Any ideas how this could be done? Many thanks

I have a simple workbench that read data from a table and produce a number of Excel files. Depending on the config, the output can be 2, 3 or more Excel files (via FeatureWriter). At the end, I want to send the result by email. If I use Emailer and put my attachment manually, it works perfecly, but if I want it to be more flexible, I want as many attachment as my workbench produce. Is it possible to concatenate the output dataset produced ? I tried but failed... any Idea ? No zip please!

When I have created a CityGML writer and add another one with the same specs except for the file name, running the process ends in an error. Both writers are separate. So it's not one CityGML writer writing two Feature Types (that won't work).  Those are the warnings and the only error I get:2020-08-10 10:38:15|  13.3|  0.0|WARN  |Duplicate XML Schema attribute declaration found -  QName: 'xml:lang', schema URL: 'file:///C:/Program Files/FME2020/xml/schemas/CityGML/CityGML/2.0/3.1.1/smil/xml-mod.xsd'2020-08-10 10:38:15|  13.3|  0.0|WARN  |Duplicate XML Schema attribute declaration found -  QName: 'xml:space', schema URL: 'file:///C:/Program Files/FME2020/xml/schemas/CityGML/CityGML/2.0/3.1.1/smil/xml-mod.xsd'2020-08-10 10:38:15|  13.3|  0.0|WARN  |Duplicate XML Schema attribute group definition found -  QName: 'xml:specialAttrs', schema URL: 'file:///C:/Program Files/FME2020/xml/schemas/CityGML/CityGML/2.0/3.1.1/smil/xml-mod.xsd'2020-08-10 10:38:15|  14.1|  0.0|WARN  |Duplicate XML Sch

I change FME Proxy Settings from "Use system proxy settings" to "No Proxy". But FME is still using the system's settings. So I edited the systems's settings and disabled proxy, and removed proxy settings from environment variables. FME still uses proxy settings. I restarted FME, and it still uses proxy settings. I can't connect to the proxy right now, so the transformation crashes. Snapshot below. How can I get FME to not use any proxy? FME 2020 here. Thanks in advance, Mike 

It appears I now need to add all the _match_id(s) with their correlating unique _line_id by length.. Any tips on how to do this?  Thanks in advance,  Fred

I have the FME Server Core running in a CentOS instance in AWS and a number of engines on separate instances. The shared resources folder is in an Elastic File System mounted to all the engines and the Core. I noticed that when new folders are created from the FME Web UI, they are created by the root user and not by the fmeserver user as I was expecting. This is causing the engines to have problems writing into those new folders because the fmeserver user (which is the user that runs the workspace) lacks the necessary permissions.  I can't keep modifying every new folder's permissions to allow for the fmeserver user to be able to write to them. What could be a more permanent solution? Can the Core be changed to use the fmeserver user instead when creating new directories?