Authoring

So i have a sheet that contains a bunch of unsorted rows, and i want to read the most recent file, create separate tabs within the existing file for each unique attribute value and then copy all of the rows with that value into the associated tab. So i've got an excel reader to read the directory, then i'm sorting the files to get the latest one, sampling just the newest one and using featurereader to feed into the writer. i've attached a copy of my workspace for reference, as well as an input file. i've been trying to use this article as a guide:https://community.safe.com/s/article/fanout-1 but what is happening right now is the writer is creating a new file, with NULL as the filename with the new tabs, and, then editing the original file with an empty tab named "fme_blank_sheet" instead of writing them all back to the

Hi I would like to make a REST call using FME HTTPCaller to Validate Network Topology as defined in https://developers.arcgis.com/rest/services-reference/enterprise/validatenetworktopology-trace-network-server-.htmI have obtained the token in the first call, and would like to pass all required parameters in the second call. (see attached)I am getting error:This FME Edition doe not recognise the '' function Any suggestions how the required parameters, inc the token can be passed to fmecaller

I am trying to create a webhook for a sheet in Smartsheet (https://www.smartsheet.com/ ). API documentation on webhooks can be found here: https://smartsheet-platform.github.io/api-docs/?shell#creating-a-webhookAs you can see in the diagram for creating a webhook, the webhook needs to be enabled after creation: this is where I'm having a problem and need some help! The "subscriber" (the callback URL, which for my test case I'm using a topic posted to FME cloud) has to respond with a 200 status and also echo back a "challenge" random number that comes in the response header by including it in the response header "Smartsheet-Hook-Response". Or it can respond with a json that contains this value in "smartsheetHookResponse" attribute.As you can see above, when

Dear all,You have an article explaining how to create a WMS Service. Two operations are explained: GetCapabilities and GetMap (https://knowledge.safe.com/articles/19640/how-to-create-a-wms-service-using-fme-server.html).However, we also need the GetfeatureInfo operation. Is it possible with FME? I have not found information about this operation. It would be very helpful to have a .fmw for the GetfeatureInfo operation, in case it's possible to create it.Thanks in advance and best regards,Montse Marco

Hi, I'm trying to run the attached workspace on a series of files to check the coordinate system then output the filename and whether it's georeferenced or not.  I want to extend this functionality later, but am struggling to just run it on files instead of the features within. Can someone please explain the best way to achieve this - my current way is to run a separate workspace runner and direct it to this, I don't think I'm quite getting it though still. I'm also running a different workspace for internal feature checks, and assume this would be the way to go - to break to an internal feature check, and file check workbench (can't think of clean way to organise the data otherwise.) Thanks!  

Hi all, I need a hand integrating this python regex script into the python caller, I basically want to run as per below. I have it all working in python but now have been asked (as work uses FME) to do it here. I'm struggling to understand how to integrate python into the FME workflow. if you could assist setting this up in a basic manner I'm sure I will get the hang of it, but have been struggling for a day or two. (Also I know I could not use python, but I want to extend beyond this functionality later and prefer python) My python script is around the lines of: def check_filename(filename):    pattern = r'^([A-Z]{3}-\\d{3}-[A-Z]-[A-Z]{3}-MOD-\\d{2}-[A-Z]{3}-[A-Z]{3}-\\d{4})(-[A-Z]-\\d{2})?(\\.\\w{3,4})$'    match = re.match(pattern, filename)        return bool(match), filename if not match else "" def check_all_files():    for filename i

I have an FME workbench that writes to multiple Excel files (all contained within a single zip file) with the intent that the generated files will not really be stored, but merely returned as the output of an FME web app and discarded soon after. Having to write these files on-disk first means I have to consider "hygiene" between runs so that there's no risk of file name collision/overwriting, while also saving them in a location that is available for the FME Flow server to expose to the user via HTTP. None of the documentation I could find really addresses where to save files meant for use with the "data download service", nor how to ensure that file paths cannot overlap between runs. Is there an FME Flow parameter for this purpose, like a unique run identifier I could add to my file names, or a private directory created only for the output of this run? I'm thinking of something like what TempPathnameCreator outputs, but not as a transforme

This is a simple one but I'm new to this, I just want to output a CSV of the feature data as shown in the image one, in the other image (CSV writer) there is only three showing up. How do I get all to show up so I can export all of them? Can someone please explain what I'm doing wrong here?Thanks!

When reading a PostgreSQL table with FME Workbench (2023.1) that has been droped (or renamed) before, the error in the logfile looks like: "Error executing SQL command ('select * from "schema"."table" where false limit 0'): 'ERROR: Relation »schema.table« does not exist".Despite of this error the logfile says that the "Translation was SUCCESSFUL". (The parameter "ignore failed reader" is already set to NO.) I need to know, if a table has been deleted (or renamed). So, how can i make the translation fail on missing input PostgreSQL table instead?  

Hello, quite difficult to find the right section for my question, so moderators, please move it in a more suitable one if it is necessary.  I create a FGDB with a feature class and a table. The table shall use the OBJECTID of the feature class, so this one shall be created first to be able to use the OBJECTID in the table. Is there a way to create the FGDB in one wb? Thank you, Corina

Hello, I need to update the location of a point in an SDE database from UTM's. Is there a way to write an updated location to the Shape* field? Thank you.

Hello all, I have a point feature shape file and road center line. I need to create the orientation of those point feature w:r:t the road center line .

Hi can yu hep me to understand where I can find the result of this website ? I supose I have to search for a json  https://egovjesolo.jentecloud.net/jalbopretorio/AlboPretorio https://www.comune.roma.it/gedalbonet/albo/listaatti thxFrancesco

I was able to create a Portal Web Connection from the Template but after I 'Authenticate' nothing happens--the window does not close and I can not proceed to the 'OK' stage and move forward. What is the problem?... this process works fine when creating an ArcGIS Online connection because the Authentication window closes automatically and you can finish the process, but with Portal it just stays open and shows my portal and there is no way to finish the process. Any help would be much appreciated! !

I use FME to extract geometry from 1000's of cad files and save the results in a single SHP file. The source files are listed in a CSV file, and they exist on servers in three different citiies which are all connected with a VPN. It takes a bit of time for FME to read each cad file, filter out the layers and geometry required, and then save them to a SHP file with attributes that point to the original source cad file. Last time I did this, it took about 6 hours to complete, and we have added a lot of data since then. I am worried about what would happen if the VPN connection to a server goes down. Will FME time-out and loose all the data that may have been written to the SHP file?  I am thinking that perhaps I should add a counter and create a new SHP file for every 200 or so source files. That way if something goes wrong, I can figure out where to re-start the process.   

Why might I be getting a 401 or 404 when creating a web connection to FME Server from FME Workbench?

Hello All, I have a Tester transformer that ideally produces no Failed outputs but I want to count the number of Failed outputs, even if its zero. I've tried a few things with no results. The Failed output from the tester doesn't seem to produce any data or if it does, I don't know how to access it. Thank you,Kevin

I have one dataset that has overlapping polygons. I want to advise the data owner of this and ask guidance for what to do when I come across these overlapping areas. I think the best way to do this is to show them all the overlapping areas. I was able to add on the overlap counts to each polygon (AreaOnAreaOverlayer) which is great, but what I really want is to create a new dataset with the overlapping areas. I have had a look at the AreaOnAreaOverlayer and Clipper. Is anyone able to provide further guidance or point out if I should be using a different transformer combination?

Hi, I'm trying to built a webscraper tool for italian website using CSS (NO API available) and since each website has a different structure I put the css selector in a POSTGRES table and then in the HTML extractor I use these selectors as parametersThe probelm occurs when in a website an attribute is missing eg normally I extract data_inizio and data_fine but in some case data_fine isn't present.So I suspect that the html stop if th css for a specif parameters is missing, I tried to use the conditional value butthe only possibility is stop So the question is how can tell to the HTML if the css selector in a parameter is missing proceed ? Hope the explanation is clear thx for

I'm struggling to find documentation or an article for this problem I am running into. I have a validation tool I created that checks for all sorts of different errors within a GDB. The errors that are caught are then written to ArcOnline where the data can be visualised. The validation tool handles mostly missing/null data. Once the null/missing data is found or fixed, you run the validation tool again to update the ArcOnline data. What I am trying to achieve is that the updating of the data is replaced based on a specific attribute- 'Project_ID'(PID). The ArcOnline layer could have entries for 'PID_1', & entries for 'PID_2'. If the tool is ran again and some existing errors have been remedied for 'PID_1', only those with 'PID_1' will be removed and updated, and those with 'PID_2' are left untouched. (When running the tool, the input data will never have conflicting Project IDs. So it is ran on a project to project basis.)

Has anybody tried using a Loupedeck with FME? I just got myself one, primarily for my Illustrator work and photo editing (hobby) but since it's programmable I figured I'd give it a try with FME too. Basically it's a little thingamajig that connects via usb and has a bunch of programmable buttons and dials. It comes with presets for various applications like Photoshop, Illustrator, video editing etc but you can also create your own mappings for any application. I've mapped most of my often-used transformers to it as well as some general tools (zooming, running etc).

Good morning, I'm trying to achieve the following: Read DWGs from all folders one level down but no further sub directoriesCurrently have: Directory and file pathnames -> tester (= dwg) -> tester for depth = 1? Was previously using a wildcard but it was going to far into directories and picking up a lot of irrelevant files. Thank you for your help.

Good afternoon! Our organization recently realized that we will not be able to make lots of copies of our data into hosted feature classes to AGOL using ArcGIS's Collaboration, as we cannot turn on versioning for our data.  Therefore, we are exploring other ways to make nightly copies of our SDE data up into ArcGIS Online as hosted feature classes. I know that FME can do this, but I am curious if anyone has experience doing this or has any tips. I am relatively new to FME, so I've been looking into a few things but I'm not sure the best route.  For some context: We currently have about 120 or so layers we'd like to update nightly. Only a few of them are heavily edited, some of them are only edited about 4 times a year at most. There are also several layers that have thousands of edits a day.  My thought is to push edits via Change Detector, but the thought of setting up a change detector for over 120 layers is quite daunting.

Hi, After creating a simple Geopackage (one Table named '01004nnu') with the OGCGEOPACKAGE Writer with FME Desktop, I want to UPDATE Attributes in this Geopackage with a second workspace using the SQLExecutor. Error message:"OGCGEOPACKAGE reader: In ExecuteSQL(): sqlite3_step(UPDATE '01004nnu' SET col1 = '1' WHERE col1 = '8'):  attempt to write a readonly database" The Geopackage ist not used by another process. SELECT Statements do work with the SQLExecutor.     

Ok, I've been all around the Interwebs, SAFE Forums, Reddit, etc... I'm stuck with what seems to me a simple problem. I have a bunch of photos taken with a DJI Mini2 and I want to creat a mosaic with FME (without any third party apps or program). My photo all have x,y coordinates because I can create a point cloud with ArcMap (raster to point) and every point land in the right place.  Now in FME... I've tried lots of transformers and the results is always the same; all the photos are in the ocean and on top of eachothers. Isn't that what "RasterMoasicker" should do??? ArcMAp 10.4.1 (but have access to ArcGIS Pro)FME 2021 32/64 bits SO... I'm sure it's doable in FME... Can you guys help me? Thanks in advance! :-)