Best Answers

Is it possible to upload a zipped File Geodatabase into a specific folder in an AGOL user account using FME? if yes, what would be the best transformer(s) to use?

Nel livello in cui devo selezionare i dati, devo applicare l'espressione Area >1

Hello! FME Novice here, running Workbench 2021.1.3.1I'm trying to update a multipoint feature class in AGOL using FME, but am receiving the following error: <class 'fmeobjects.FMEPoint'> cannot be converted to esriGeometryMultipointI tried using Aggregator to ensure the points are multipoint but receive this error when I try this method:  0.0|ERROR |<class 'fmeobjects.FMEAggregate'> cannot be converted to esriGeometryMultipoint 0.0|ERROR |ARCGISONLINEFEATURES writer: A fatal error has occurred. Check the logfile above for details Can FME handle multipoint  updates for ArcGIS Online? It has no problem with polylines, so I was hopeful on multipoints. Any advice is welcome and appreciated. Thank you in advance!  

I used the ArcGIS Online Feature reader to read a hosted arcgis feature layer that has attachments. I can use the AttributeFileWriter to write the attachments to files. But when connecting the reader to a file geodatabase, the feature layer writes to a feature class, but the attachments are not included. Is this the expected behavior? I am at FME 2020.1.3.

Relatively recently we've acquired FME Server and are in the process of converting workbenches we had run previously via task scheduler. We have quite a few already and I am interested in suggestions (or articles) that anyone has on how to best document or organize the workspaces. There might need to end up being some trial and error regardless, but I would like to avoid some pitfalls on the front-end if possible. The most relevant search result I found was this, but doesn't seem to apply directly to what I'm looking for: https://community.safe.com/s/bridea/a0r4Q00000HbsC7QAJ/best-practices-document-for-fme-server Thank you!

I hope this message finds you well. I am reaching out to the FME community to ask for suggestions on how to map transmission lines data using sub1 and sub2 columns. Our goal is to find the node mapping between transmission lines and substations, and we have the necessary data in these two columns.I have been working with FME for a while now, but I am not sure about the best way to approach this mapping task. Any advice, tips, or best practices you could share would be greatly appreciated.Attached the piece of data for understanding.Thank you in advance for your time and expertise. I look forward to hearing from you soon! 

Hi, I am using the census bureau's API to gather population data for a county, and the data returns in the response as two separate arrays. One array contains the headers, and the other contains the data:  [["NAME","B01001_001E","state","county"],["Spokane County, Washington","546040","53","063"]] I am mainly having issues with transforming the data in this format as it isn't what outputs normally look like when using other REST APIs. Using a JSONfragmenter will correctly assign these as two distinct arrays, but I can't seem to figure out how to associate the corresponding values to build a table from these arrays.

Hi, I'm trying to run a python script that accesses python modules in an arcpy cloned environment. But I'm having trouble setting FME to use the conda python interpreter.  I have set the preferred python interpreter in the FME options to the cloned interpreter.However FME looks to default to the standard arcpy interpreter. And returns the following error after running the workbench: Python Exception <ModuleNotFoundError>: No module named 'untools' Also tried the following, but that does not seem to work:import syssys.path.append(r"C:\Users\markv\AppData\Local\ESRI\conda\envs\arcgispro-py3-clone\python39.dll") Python compatibility: Esri ArcGIS Python 3.9 - Would have liked to see the custom interpreter here, but it does not. ESRI ArcGIS compatibility: Auto Does anybody have any idea what I am doing wrong?Thanks,Mark

What transformer can I use to snap the red line to the black line keeping the intersection point (blue circles) in place? Anchored Snapper would snap the edges but shortens the red line while Affine Warper works only for short lines. Thanks!

I have loaded some features from an Open Street Map file (.OSM). Some features have the attribute "oneway" and "oneway:bicycle". I'm a able to create a test clause targeting "oneway". When I try to do the same for "oneway:bicycle", I get an error: "Specified attribute does not exist" (see image at the end). This causes the software to show a warning before running the workflow. Strangely enough, the filter is applied perfectly fine! Am I doing something wrong? Or can the warning maybe be a bug? 

I have a workflow where I use the schema port of a FeatureReader (format Geopackage) to check if the schema of the input gpkg is correct. This works fine for a single file, fme_feature_type_name provides the table name, and I have the list of attributes.However, if the input is more than one file, the schema is a 'global' schema combining the schemas for all input files, avoiding double tables. As a result I cannot check each file separately.I found out that using the FeatureReader with type Schema (any Format) gives on the generic port all tables as feature, with the attributes list, for all files. But here is the problem: when using Schema (any Format) on a geopackage, these tables as feature on the generic port do not expose the table name. I expected fme_feature_type_name, but this is not available in the output. fme_feature_type gives 'schema' as value.Is there any way I can get these table names ? Thanks,Marc 

Hi, I have a host feature layer on Portal 10.8.1 and want to use a date where query. Documentation from ESRI point to being able to use Intervals in the query but when I try to use in the Portal Feature Service reader the server returns a 400 error.  https://www.esri.com/arcgis-blog/products/api-rest/data-management/querying-feature-services-date-time-queries/ It appears you can only use a proportion of a day in the FME query. The help page FME desktop points you to from ESRI isn't exactly that informative. https://doc.arcgis.com/en/arcgis-online/reference/sql-agol.htm  Is this a Portal versus AGOL difference? This works:"created_date" >= CURRENT_TIMESTAMP() - 0.015 This doesn't:"created_date" >= CURRENT_TIMESTAMP - INTERVAL '15' MINUTE If anyone can point me to a definitive page with the documentation for where datetime queries for hosted Portal feature layers.... 😀  Thanks,Peter   

Hi FME community,I am still fairly new to FME. I'm getting stuck with date/time fields in csvs and excel documents. I've attached the field I'm trying to convert into DD/MM/YYYY HH:MM (%d/%m/%Y %h:%m ?), but it writes out empty if I try the DateConverter or AttributeManager> Text editor > DateTimeFormat. It's likely I'm using the transformers incorrectly. Is anyone able to point me in the right direction?

The request URL looks like this:https://reportapi.application.com/dashboard?from=YYYY-MM-DD&to=YYYY-MM-DD&state=XXXXXX&api-version=1.0 How can I create some kind of setup (or loop) where I can easily retrieve the data from an entire year per month per state? The data itself doesn't have some kind of timestamp, so I'll have to retrieve each month separately. So for example:2022-01-01 till 2022-01-31 for Ohio2022-01-01 till 2022-01-31 for Florida2022-02-01 till 2022-02-31 for Ohio2022-02-01 till 2022-02-31 for Floridaetc...

In the attribute manager, I would like to create a new field called ('Age') and calculate the attribute value from another field called 'Date of Birth'. This is within an automated process that will be run multiple times a month, so I need it to take the time that the process is run and use that for the age calculation. How can I do this? This is my attempt at this : (GETDATE() - @Value(Date of Birth)) / 365 (although there is no GETDATE function as far as i'm aware of.)  Thanks in advance!

Hi,I have a rail network, featuring multiple polylines. I need to snip 50m from the ends of each line.Using the Snipper transformer, I use the Distance (Value) mode. The Starting location is 50, the Ending Location is the length of the line -100 (accounting for the 50 already removed at the Starting Location... maybe?!).The results are mixed: A dead straight line has 50m removed from each end, this is what I want.Any other shape of line only removes the starting 50m, but NOT the end, as shown by the red "X" below. The blue lines indicate the Remnants.What am I doing wrong? Can anyone help please?

I have 15 .csv files with different names but the same fields and a total of 1406 records. They are in the same directory. I want to merge all 15 files together and append the source file name to each record. I've tried FilenamePartExtractor, FilePathExtractor, and FeatureReader but haven't been able to to get the desired result. I usually get back more records than I put in. Is there a straight forward method to append file name to each record?

I have followed the tutorials available and also tried following other questions on the forum on this topic. Workspace template with data cache included.

I have 12 netCDF files downloaded from https://data.ceda.ac.uk/badc/ukmo-hadobs/data/insitu/MOHC/HadOBS/HadUK-Grid/v1.1.0.0/1km/tasmin/day/v20220310. Each contains 1km-1km grid values of the minimum temperature for each day of a specific month. I would like to create a single combined file that counts the number of days where the temperature was below zero. I've tried RasterExpressionEvaluator but I can't get it to generate anything sensible. Can anyone help please?

Hi , i have path file name in attribute C:\\*\\*\\*\\filename.dwgi would like to extract only the (filename.dwg) Please , I want to remove C:\\*\\*\\*\\Thanks in advance

We are about to install Server for the first time on a dedicated virtual machine. Since our subscription now includes floating Desktop licences, does it cause any problems to have the Desktop licence manager installed on the same box? Thank you.

BonjourJe souhaite à la lecture de ma couche commune, exclure les communes d'une dizaine de département identifiée par leur nom ?Merci

Hello,I'm working with FME Desktop 2015 with a WorkspaceRunner transformer calling several workspaces where i have to use an environment variable in the path of some private variables.For example: %ENVIRONVAR%\\dat\\myfile.txtThe problem is that the called workspaces don't recognize the value of the environment variable defined by the Windows System. I have tried to assign the value to the environment variable inside the workspace but it is not a good solution in this case because every PC could have a different value.Is there some example about to do solve this problem?Many thanks in advance!A.

Hi list.I got a curious error in a workspace, which I needed to update.I needed to update some schema references (from .../1/... to .../2/...) and thought that it was a good idea to create a private user text parameter, containing the "2" needing to be inserted.However, this yielded a strange error when applied to the root expression in my XMLTemplater. Something like this: "... can not expand namespace prefix to URI"Is it correct that XMLTemplater cannot use user parameters replacements ?And if so, why not ?Aren't these applied to whatever parameters a transformer may have, prior to its execution ?Cheers.