FME Form

 I have FME Desktop 2022.2 and have pre-installed the Google BigQuery FME Package 1.1.1. I've been trying to move some spatial data from File Geodatabase to Google BigQuery (in Google Cloud Platform). This was working around 3 months ago (back in August 2022), but then after Google changed their authorisation process in September 2022, for some strange reason FME Desktop refused to move any data into Google BigQuery. Below is a snapshot of the error I get in FME Desktop when creating the Google BigQuery Writer. I've already authorised my GCP account using the FME Options >> Web Connections, so not sure what more I need to do? Any help would be greatly appreciated!  

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.

I have a MicroStation file with level names, colors, and line styles and would like to convert it to an AutoCAD file that have different layer names, colors and line types. I'm using the "AttributeValueMapper" to determine "Source" and "Destination" values. I'm also using "AttributeManager" to set color and line types. An example of the "Destination" values in "V-TOPO-BRKL". It appears that it doesn't like the "-" since when I run the workbench it changes the Level-layer to the first name in the destination list. How van I resolve this?

I am using Systemcaller to send the request and getting error Thi is the code where i need to exxucteGET https://maps.earlyalert.com/server/rest/services/System/SpatialAnalysisTools/GPServer/OverlayLayers/submitJob?inputLayer={"url":"https://maps.earlyalert.com/server/rest/services/Hosted/Master_Client_Areas/FeatureServer/0","filter":"clientid=283"}&overlayLayer={"url":"https://maps.earlyalert.com/server/rest/services/Hosted/Power_Outages/FeatureServer/0"}&overlayType=Intersect&snapToInput=false&outputType=Input&tolerance=null&outputName=&context=&context=&env:outSR=&env:processSR=&returnZ=false&returnM=false&returnTrueCurves=false&f=pjson 

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!

Hi all. First post for me here. I have a workbench where I want to overlay a point dataset on a single band geotiff elevation raster dataset. This workbench will be published to FME server where ppl will uploaded their point dataset and terrain Info will be calculated. The GeoTiff dataset is large >10 gb. To speed up the process I have tiled the dataset into smaller tiles and created a shape file index. I only want to load the tiles which overlap the point dataset. I find out which tiles overlap the point dataset and then, using a feature reader transformer, I’m selecting the tile to load. My question is, what would be the best way to load multiple tiles if the point dataset overlaps more than one tile. Is it best to use multiple feature readers with each tile being passed to one feature reader. But I’ll never know how many feature readers I need. Any thoughts. TIATK

Hello! It is possible to add a CGXML file into ArcGIS Desktop via data interoperability? Also the CGXML file can be converted to a shapefile via import? I can also add or send a cgxml file if needed. Thank you!

Hi, We are posting as a RAW POST Body large JSON content.....however, it is not receiving any of the JSON into the workspace. When we use a small JSON, it works fine.On inspecting the JobSubmitter log file, we see the following: WARN https-jsse-nio-443-exec-52 413010 : POST request received. Redirecting to GET method. Is there a reason why this is happening? I assume that the POST body is getting lost when it is redirecting as a GET request. Thanks,Steve

I have a raster for which I am trying to reduce the resolution. Each new cell should hold the average of all the previous cells that it contained. I am using the RasterResampler, but the output raster have holes in it. Any ideas on how to overcome this? All of my larger, new raster cells contain some data that are NoData, could this be a problem? 

I have a feature service link from which I extract data, but I cannot see the latitude and longitude in the tables. When I inspect the data, I can see the details. Can anyone tell me how I can extract the location details?

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 

I have a workbench with two public parameters, start_date and end_dateI want to filter records on a date attribute. Values like "20220509213856"Except, I want the actual range to be two days before the chosen start_date and two days after the chosen end_date.How do I set up the Tester?

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   

Hello Sir/Madam, So I have many models in CityGML formats. I would like to put it on the Cesium to view the data. However, as some of the models (CityGML) are huge, I guess it have more than 300 features for each models. Hence, the FME cannot convert the CityGML to Cesium 3D tiles format.  I am sure my citygml model is fine, as one of the model is able to convert to Cesium 3D tile and able to view it on the Cesium. Is there any way I can convert all the models successfully? Thank you.

I have a CSV with coordinates. I've put a vertex creator in the workspace and outputting it to an ArcGIS Online feature service. I can successfully write out into ArcGIS Online, however when I open up the feature service in AGOL and Pro, I can't see the points. Yes, I've checked the transparency and visibility range. When I open up the attribute table all the data is there. When I select all, it shows the points are there. Only when selected though. Why is this?

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?

Hi when I run the exercise-workspace-prototyping.fmw I received this error  can you help ? thx  Francesco 

Hello, we have a SDE-Reader with an integrated "whereclause". The data themselve has string-values with mutated vowel (ä, ü, ö), which could be a value for the whereclausee. In that case, the reader execute no result. Any idea?

Hello ,I have multiple lines connecting to each other in shape file and each multiple lines has different id with increment 1 ,as example : multiple lines include id ‘s : 250 ,251 ,252,253 ,….and different multiple lines include id ‘s : 4090,4091,4092,4093,….I would like to combine the lines together that connecting to eachother and increment with one from others id  my target : to convert each multiple lines that looks like square to polygon and also the street lines to be together as seperate another polygon . i am not sure how to achieve that,so i have thought that may be i combine id with increment 1 , i hope if someone has idea ,let me know please  FME 2021Thanks for help