Best Answers

Hello everyone, is there any way how to generate next letter of alphabet? E.g I have feature with value "A" and I wanna generate next letter in alphabet, so letter "B". Is there any function for that? Thanks a lot! Lubo

Does any one know how to read the latest file from a One Drive folder. I'm able to select a file from the One Drive folder using a Microsoft OneDrive (Graph) web connection, but I can't find a way to read all the files in the folder and then find the latest. I have read the question regarding reading the newest file for a folder https://knowledge.safe.com/questions/65203/read-only-the-newest-file-from-a-directory.html. It's very helpful condeptually. I would appreciate an thoughts or insight. Thanks,Frank

Hello everyone,Is there a way to drap a 2d surface or polygone into a 3d surface (like in the picture joined). If there is in which format do we need the surface and polygone to be? Thank you in advance

I am using a SchemaScanner to prepare a dataset for dynamic writing to a PostGISWriter. How do I write to the columns for PrimaryKey and Geometry in an dynamic environment?

Hi there,We have an excel file with an easy table. Just 2 columns: Position and Id. The file has about 100 lines.We want to read the file and process each line. We have tried with a custom transformer but we are not able to process the lines individually. If we read the Excelfile we get the 100 lines and all lines will be process at the same time. If we convert the lines into a List, we get the error "Transformer/Factory test_loop_2_ListBuilder is blocking and cannot be used in a loop, but was found between 'Loop to test_loop_2_Looper1697190238 Input Splitter' and 'test_loop_2_Looper1697190238 Input Splitter'".  Has anyone an idea to make it?I have found this link (https://docs.safe.com/fme/html/FME-Form-Documentation/FME-Form/Workbench/transformers_custom_looping.htm) but it helps me only with the loop. Not how I can process the ids separatelly. Many thanks in advance!

I have a point array of addresses, and a line geometry layer of streets, and I need to be able to get the ID of the nearest line to the point that also has a couple matching attributes. What are the best options to consider?

I want to move files from one folder to another. I have added the FileCopy Writer to my workbench and set the parameter to Move, not Copy. I am using FME Desktop 2021.  I think I am missing something because when I run the workbench it runs successfully but no file gets moved. I have included screenshots of my workbench.

I have about 1,000 KMLs in a folder, all with the same schema and only one feature each (line features). I want to bring in each KML into a single feature class in a file geodatabase in ArcGIS Pro and populate a field in that feature class with the unique name of each KML. Is there a way to even do this in FME? Thanks!

id,v1,v2,v3,v4,v522,hi,hi,1,2,322,hi,hi,1,2,322,,,,,33,hi,hi,2,3,433,hi,hi,2,3,433,hi,hi,2,3,433,,,,,44,no,no,5,5,544,no,no,5,5,544,no,no,5,5,544,no,no,5,5,544,no,no,5,5,544,,,,,

I have a bunch of points that fall on or near a linear features (routes/roads). Is there a way to use the Locate Features Along Route tool in FME to identify which route those points fall on?

Using the FME Server REST API repositories I am able to retrieve items for every repository using the HTTPCaller , but I have a difficulty retrieving an actual item (the .fmw to download or put into a parameter)As in this exampleI tried Accept=contents and disposition=inline in the Headers section of HTTPCaller, but all I get is information about the items and not the item itselfCan someone give me an example of configuration of the HTTPCaller in order to retrive de item itself. Thanks in advance!

The data lod-2 is available for public download from the servers of the bavarian Opengeodata platform at: <https://geodaten.bayern.de/opengeodata/OpenDataDetail.html?pn=lod2> here is the direct link to a 2x2 km square that is downloaded as citygml: <https://download1.bayernwolke.de/a/lod2/citygml/704_5322.gml> I have a whole workflow for processing that data, which stopped working without any changes to the workspace. Then i realized that i can not even read the data into a brand new workspace with the same basic error message being shown:'http://repository.gdi-de.org/schemas/adv/citygml/1.0/cityGMLBaseLoD2.xsd' mapped to 'C:\\Users\\mutzh\\AppData\\Local\\Temp\\FME_XSD_CACHE\\fmexsd_1696954419928_14896.xml'Parsing schema document 'C:\\Users\\mutzh\\AppData\\Local\\Temp\\FME_XSD_CACHE\\fmexsd_1696954419928_14896.xml' ...XML Parser error: 'Error at file: 'http://www.w3.org/TR/xhtml11/DTD/xhtml11.dtd' line: 126 column: 22 message: unable t

Could someone please provide a dead simple "Hello World!" example of using the FILECOPY writer? Try as I might I can't figure out how to get this to work. Thanks. This is what I've done so far:FME Workbench >> File new >> Blank workspaceWriters >> Add >> FILECOPYDataset: \\\\server\\share\\source folder >> OKOpen "user attributes" and set:filecopy_source_dataset = "\\\\server\\share\\source folder\\filename.ext"filecopy_dest_dataset = d:\\tempfilecopy_dest_filename = xx-my-filename.ext At this point "Run Workspace" doesn't work. "Run to this" does work, but aside from filling the log window nothing appears to happen.Workspace and log are attached.  

Hello FME Community, I am using a 'StringConcatenator' and a 'Text Writer' to create a text file. I intend to add two separate texts as the header and footer.  Is there a way to add these texts without duplication? 

Hi I'm trying to create a workspace that takes in multiple Esri GDB files from a specified folder. For some reason though, only the original GDB file I started with seems to be able to pass (MyProject1.gdb).  Any other GDB when passed through my FeatureReader is automatically rejected, but the log file doesn't say anything useful beyond that I need to save my GDB files correctly, even though the process has been identical for the various files. For some reason, if I were to copy my original gdb and put it in the same location as the original file, the workspace seems able to process the original file, but not the identical copy of it at all.   There might be a chance that MyProject3.gdb is corrupted but that's highly unlikely since I did it in the exact same way as MyProject1, but I can't understand why the exact duplicate of MyProject1.gdb cannot be read and gets rejected.

I am trying to add the following WMS in FME Desktop:http://gis.rijeka.hr/geoserver/At/wms?service=WMS&version=1.1.0&request=%20GetCapabilities&srs=EPSG:3765&format=image%2Fpng I have no problems loading this map service in ArcGIS Pro but can't seem to get it to load in FME Workbench or Data Inspector. The WMS contains two layers, I have tried adding them individually as well. Not sure what I am doing wrong. Any assistance here would be great.

Good morning!I need to call a stored procedure of DB2 from FME. If I use the IBM Data Studio this script works fine:CALL TESTING.TEST_PROCEDURE('input1','input2',?,?,?,?,?);It has 2 input parameters and 5 output parameters.But when I use the same script in the SQLCreator of FME i always get this error: Literal replacement parsing failed for procedure call to DB2 for z/OS. Failing SQL text {my_script}. ERRORCODE=-4463, SQLSTATE=42601 Does anyone have any experience calling DB2 stored procedures in FME? Any help would be appreciated.I'm using FME 2021.1. 

FINAL UPDATETurns out the problem was that the hatch fill in my block is incompatible with colors for some reason. Having a standalone circle for a block was ok. What I ended up doing was typing • via Text and then saving that as a block and now my CAD looks like a proper point layer.  2nd UpdateI added my template file to my writer parameters and I am now able to generate blocks for my individual points, but I can't seem to get the colors from my attributes to stick to my blocks.UPDATE This is my current workflow, but it still doesn't seem to produce a cad file with data inside all.  **Original Post below**I have a point layer in an Esri GDB file I'm using workbench to convert to DWG AutoCAD data while maintaining color data. I have no issues with lines and polygonal layers but my understanding is that CAD uses blocks while Esri uses points. I tried a direct conversion where I just had a reader with my GDB and a writer with my DWG and the end result was a file with the poi

Helllo everyone, I´m quite struggling about loading files to MS Sharepoint on-premise. I´ve found some tutorials, but just for Sharepoint Online. Any ideas please?Lubo

This seems easy but I'm not sure how to go about it. I want to do an initial match on ID1 and then detect if ID2 has different values. So A has different values in ID2, and B does not. Initial dataRequired Data   

I'm trying out FME Flow 2023.1 and need to run my workspace with breakpoints. When I reach a breakpoint, the Feature Inspector pops up, as expected, but I'm unable to inspect the attribute values. A new column containing the Data Type of an attribute has been added and the Value column has dissapeared. The only thing I can adjust is to show the Data Type column or not. This makes the usage of breakpoints and feature inspection almost useless. I'm interrested in viewing the values for each attribute, the data type is rather irrelevant.

I am trying to set up a KafkaConnector to read from a topic. For the SSL certificate, I provide a keystore that I've used to connect through OffsetExplorer, but it is unable to retrieve the topics. Does FME expect a different type of certificate? I get the following error: An error was encountered while retrieving existing topics: 'Failed to create admin client: ssl.ca.location failed: error:0B084088:x509 certificate routines:X509_load_cert_crl_file:no certificate or crl found'. Please check host names and ports, security settings, and credentials

Hi,I have a workbench that is using an azure blob storage connector. It runs fine on form but when I try to run it on flow I get the following error: I've tried to manually upload the ABSC.fmx file to flow, and to the workspace file repository but nothing seems to get me past this error. I can see the .fpkg file in the resources>engine. I've looked through documentation but can't find where I should placing this package. Any help would be much appreciated. Many thanks, Sam

Hi,Is it possible to halt the normal data flow (preferably with a transformer), and ensure that a certain transformer receives and processes one feature at a time before the next feature is provided to it ? Some sort of "semaphore" or "street light" functionality ?I have a custom transformer that works perfectly, but its logic is only valid on a single feature.Plan B is to redo the logic, but if the above is possible, it would be much simpler.Cheers. Lars

I have a HttpCaller that reads different kinds of information depending on the user input and therefore the attribute column names are all the time different. With the JSONFlattener you can import the column names that you want to expose, but ideally I would like to expose them dynamically. I was wondering if something like that is possible.