FME Form

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  

I want to put a ZIP file on FME_SHAREDRESOURCE_DATA using the FME Server API:  The file gets copied, but the ZIP file becomes smaller and corrupted. Even a ZIP file of 1KB. Any ideas why this happens? I've tried on two different FME Servers, since I thought it would be the server configuration. If I do the same with an XML file or a TXT file, regardless the size, it works well.

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 an existing dataset with labels where I want to increase the font sizes of all features. This of course results in overlaps in places, and I am trying to figure out if parts of the repositioning could be automated with FME. What I have is the original placement and sizes of the labels. I would like to use these placements as starting points, increase the font sizes and then move anything that starts to "entangle".I have read up on the MapTextLabeler, as best I could. It should do what I need. But it comes at a price, I don't know how steep, and I only need parts of what it offers.Has anyone had any success building a workspace that spaces stuff out? My thoughts are:1. Create bounding boxes from the label, sized in ground units.2. Check if any of these are "to" close3. Move those in need further apart.4. Check to see that no new overlaps have occurred.  No 3 above would be the trickiest one me thinks. The repositioning distance would need to be calculated

Hi All, I have kml and image as input files. The requirement is to generate another image by merging both. I have merged both and able get the raster, but I'm not getting transparency in the area within the polygon.I have attached pdf file of requirements and workbench for better understanding... Thank youPratap

I have a raster that gets cut up to smaller sections in a clipper. Within these sections the cell values need to be identical. I have used a RasterStatisticsCalculator to get a mean value for each section. But how do I write these to the cells? My guess is that there is a step missing in my workspace below where the attribute need to be "written down" to cell level? Unfortunately I can't find a transformer that does this. I might ad that I have tried a different aproach where I wrote the mean values as a new band, and then removed the old one. This got half the job done, unfortunately, it also overwrites null values. Which means I end up with bounding boxes around everything, and corresponding stray values.  

I was wondering if it is possible to convert KMZ-files to CityGML? The KMZ-files contain a doc.kml file and a folder (models) which contains model.dae, model_textures.txt and a texture folder containing a .png. I´ve been searching for a valid solution but I can´t seem to find one. I have looked at the common data workflows (https://www.safe.com/convert/). Does anyone have any ideas how to solve this problem. To note: each KMZ file is representing a building, which we want to convert to CityGML so we can use 3DCityDB.  Thanks

Does anyone have any ideas on how to efficiently create a 3D feature similar to this image?(the cut away is just to help show the geometry, it will be completely circular)I can make a cylinder by buffering a circle and then extruding it vertically but the only idea I've had so far for this geometry is to layer a whole lot of circles on top of each other and dissolve them, which is taking a long time.

Hello everyone,I have been scouring these forums for a solution and found a few posts with similar problems but no solution seemed to work for me. Granted that might also be due to my limited experience with FME so here I am. I am trying to rework a table from this:to this: I have been trying out transformers such as AttributePivoter, Aggregator, AttributeExploder and a few more and also tried to create colums using AttributeCreator and AttributeManager (but I couldnt get it to automatically create colums based on the unique Methodology-Codes, there is too many in the original dataset to do this by hand) I would be thankful if anyone could push me into the right direction, as I cant seem to make progress on my own here. Thank you.

I want to read sevaral excel file that are inside a zip file.An excel file has the worksheest  Data 1, Dat2, ... Data n and the number of worksheet varies from one file to another.For a given zipfile, I first read the schema feature  using a featureReader to get the list of sheetname.Then, using a second featureReader, I read the attribute with the worksheet  The problem that I'm facing now is that when I enter manuall the values filename and filepath used within the first FeatureReader,  I'm able to get the reseults that I wanted. However, when I tried to read all the zip file with a python caller, the program stop and the only error that I have is ERROR RUNNING TRANSLATION.Storing feature(s) to FME feature store file `C:\Users\...\inspector.ffs'Storing feature(s) to FME feature store file `C:\Users\...\inspector.fsc'Error running translation.Creating reader for format: Microsoft ExcelTrying to find a DYNAMIC plugin for reader named `XLSXR'FME API version of module 'XLSXR' matches cur

Hello FME community, I created a conversion process(FME workbench) that converts my collada file to citygml. Now I want to be able to convert all my collada files (as many as 8000) at once but I don't know how to achieve that.Could you please let me know how to proceed ? many thanks.