General

Hi I'm working with FME to write citygml document, I have 3D geometry features with attributes(class, function, usage...etc.) The table above shows the results after passing features to CityGMLGeometrySetter.I want to use them as attributes of citygml document. however When I generate citygml document, Only class attribute was written properly but function attribute doesn't show in the file. this is what i did.generated citygml document I guess I need to change function attribute(just string now) to list attribute because the writer says citygml_function{} required. But not familiar with that. I have know idea what to do next. Please help me doing this!

Hi,I have multiple CSV files exported by the same application in one export session and with the same delimiter. The CSV reader does recognize delimiter automatically for all but one file. Even when I enter the delimiter at the reader "delimiter character" it is not recognized. I'm wondering what might be different with that file.I noticed all files have UTF-8 encoding but not the one in question. When I convert to UTF-8 (Notepad++) it still doesnt work. I have no idea which other file properties cause that the file being treated differently. I also copied the delimiter character from the CSV file and pasted it to the readers "delimiter character" - still the same.Any ideas what the reason could be? FME 2019. Many thanks, Rob

Greetings,I am reading in Date/Time items in String format from an ESRI REST API. I have a field uploaded with values (below):1331249589000133124963400013312496460001331249638000  FME cannot identify/transform the values?? Any suggestions or pointers would be appreciated.Regards,Clive    

Hello, I would like to give the user the possibility to select a certain area when starting the script. The areas were previously recorded in a GDB and provided with a corresponding attribute. Furthermore a Published Parameter was configured according to the areas and their attributes.After starting the script, the user is asked which area is of interest to him and he can select it based on the predefined areas. So far this works wonderfully.My problem now is that my script only works as long as only one area is selected. If the user selects several areas, which should be possible, I do not get a correct selection. To test my result I have created a tester with the following configuration.My question now is, how can I successfully select multiple areas? Many thanks for the support.

I need to add two vertex (points) to one polygon. I need to join them to the nearest vertex of this polygon.  I have this:And I need this result:Thank you

I have about 3000 jpg and their coordinates in CSV format, I want to join the jpg and their respective coordinates saved on csv and create a ECW or Geotiff filehow can I do this

I am fining new ways to use Dynamic Schemas which are great. However, i do find it challenging to modify the schema especially when creating new attributes and working with Date/Time or float/int as FME defaults to strings. Is there an easy way to force FME to use a particular datatype ( float, int, date, datetime etc) during a translation. I was thinking that the within Attribute creator one could define the data type that is read by the Dynamic writer or use somethink like the SchemaMapper transformer to read and modify attributes instead of an external source. I know that you can dictate the final schema withi the writer, but i dont seem to be able define that before hand. 

I am writing a text file with the csv writer. How do I force it to write the file with the extension "xyz" instead of "csv"?

Welcome to your Thursday edition of What’s Up Wednesday. Yesterday we paused our weekly newsletter to remember the fallen.  5 Reasons Why FME Server is More Than Just SchedulingThis week in the blog, Rylan lists five reasons why FME Server can be used for more than just scheduling: Logic-Based IntegrationCreate Web ApplicationsPerform Application IntegrationSend and Receive EmailPerform Tasks Without FME DesktopFor an in-depth description of each reason and links to tutorials or videos, check out the post.  FME Hub October Round-upLots of new things published to the FME Hub in October, including our new Shopify transformers:EarthCacheConnector - Connects to the SkyWatch EarthCache™ platformKMLMultiTrackReader - Reads in the KML MultiTrack definitions and creates corresponding attributesTransformationMatrixExtractor & TransformationMatrixRemover - Extracts and removes the transformation matrices of root 3D geometries using FME's python API SnowflakeHave you tried to connect to S

Hi all, I have a huge dwg file I am clipping them by some grid. However my output get more textes than original dwg as you see in the images. I am not familiar with cad datasets. I believe it causes some sort of visibility? How can I make sure that my output is as same as the output? Thx in advance.

Is there a process in FME allowing for the creation of a seamless .tab file. In this case I have around 300 aerial imagery .tab files that need bringing togethere in a seamless .tab (note: not merging, but a seamless .tab). Thank you

Hi,thank you for your help in advanced.In ArcMap it is possible to export out a raster based on its currentl styling: https://pro.arcgis.com/en/pro-app/help/data/imagery/export-or-convert-raster-datasets.htmForce RGBCheck the Force RGB check box to export the output raster as a three-band RGB raster dataset with the current renderer.Additionally, while exporting to formats such as TIFF, JP2, PNG, and MRF that support alpha bands, you can use this option to export the data as a four-band raster dataset with an alpha band to preserve the transparency settings of the original data. Is this possible in FME? Thank you Oliver

Hello, I have some 3D Polyline (Polyline ZM) of which I am interested in the lowest/maximum height in order to be able to make a further query with this information. All polylines have a different height at each of their vertices. Is there an elegant solution in FME for extracting the min/max height of a line and then attaching it as an attribute?  Thank you very much for your support.

I have some excel files i am creating with coordinates in several columns. each time i create the files they will have different number of rows. i would like to put a label at the bottom of a group of columns for instance all the xy columns (merged columns) stating that they are NAD83 stateplane like...

How to inspect CSV data file containing line data instead of point data information?

Hi,  Where is the Parameter Presets saved? Is there a way to export and share presets with others?

Hi - I've set up a workbench to update a number of feature service layers in Esri ArcGIS Online. The feature services exist under my individual account within ArcGIS Online and the workbench therefore requires the appropriate web connection in order to run successfully. I've set the web connection as public and have ensured that the public key is in an accessible folder that is referred to in the workbench. However when a colleague opens the workbench it contains a reference to a different web-connection (one they have previously entered in another workbench). Is there any way to get the web connection that I have entered to persist in the workbench so that it is used when other colleagues open the workbench? Thanks very much for any advice.

I am creating a 'school catchment finder' so when a user types in their postcode, it brings up a list of schools catchments that their address resides within (i.e. essentially a point in polygon query). I want the result to bring up a table of 10 school types regardless of if that school type has a catchment at that address or not e.g.Primary SchoolJunior SchoolCatholic InfantsCatholic PrimaryAcademy School etc. The issue I have is when using ListBuilder, if one of the school types is not present at that address, the column headings still appear, but a different school type is listed under the school name. This sets the table information off kilter.E.g. If a Catholic Primary school is not present, they Academy School information appears under the Catholic Primary school headings which is obviously incorrect.From the images below, can anyone tell what I am not doing correctly?

Hi,  In FME Workbench Build 20252, if I add a prefix using the BulkAttributeRenamer, it also renames fme_basename and fme_dataset. This have not been the case before. In the "visual preview > table" the fme_ attributes are NOT renamed, but in the Feature Information they are renamed.  Have someone else come across this?I think this is actually a bug.  Regards,Daniel  

Below is the example file where I am getting all my data from. As you can see, each row has a unique ID and there are 4 sets of product information.What I am trying to do is create a single row for each set of product and ensure that the ID and User ID matches. Example below Any help will be greatly appreciated. Thank you

Hi!I would like to make a spatial join between two dataset. I usually use NeighborFinder but my problem is it duplicate each candidate each time a base is near. I would prefer for this time that each candidate can be used only once. So if a candidate match with a base then the candidate is not available for the others bases. In the example, the blue feature nearest the green, take the value "10" and the other blue feature, take empty value. Is it possible? Thanks!

I have a surface with a color/material, but the side of the color is different.How can I get the material/color on the same side of all objects? So all become grey in this example. thanks!

I will run a stored procedure (in a MySQL db) with the SQL executor but is doesn't generate output. I'm not so familiar with running stored procedures. See the attached picture, it seems the procedure is running correct. Is there a way to get output through the result port?

I have 5 original jpg orthophotos as follows and would like to have the same results but as one mosaicker file  I have the following workbench to merge all of the 5 files into one mosaicker   The output file on the writer I get the following final results with a black background which I don't want:  If I set the RasterBadnNoDataSetter to a value of 255, I then get a white background, which I also don't need. Any ideas as to why I can't get the desired mosaicker without any black or white background?Thank you for your time and any insights would be greatly appreciated.     

Hello!I need to randomly select 7 grids from the grid net including condition that selected grids cannot be self-intersecting and cannot overlap each other. See image below.  How to approach it in the most efficient way?