Creating and organizing workspaces. How to use Workbench.
Recently active
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 support Francesco
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.) Hopefu
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. So, I was considering going the "Dynami
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! :-)
After installing FME on my computer, all of my files have defaulted to open in FME. For example an xlsx will now open in FME unless I specify that it should be opened with excel. Any suggestions on how to resolve this issue?
Find the points on a polygon that are perpendicular to a line as in the screenshot.Existing features are the polygon(s) and line A. Pts a and b are required.Thanks very much for any help and ideas.
Upgraded to FME 2023. When writing to SQL server database, Bulk Insert = 'Yes' results in features dropping and not writing to DB (even though the correct amount of features are listed in the Total Features Written message). If I set Bulk Insert = 'No', the correct number of records write to the DB but one of the nvarchar attributes is empty in the database. Everything looks correct in the final inspector prior to writing. This is using workbenches originally created on 2022.1.2.0, Build 22627. New version of FME is 2023.0.0.3, Build 23319. I reran workbenches on 2022 and it's working correctly
Hi I need to download data for difernt municipalities but when I have a name with single quote (like Catsell'Arquato) the tester In failed So how can escape single quote ThxFrancesco
HiI would like to filter/resample (I don't know the FME terminology) a point cloud based on spatial distance.In short I would like to obtain a new point cloud where I have 1 point every 2 cmWhich is the best transformer ? thx Francesco
Hello. We have floating licenses in our office so they keep rotating time by time.I have created a batch file for running a workbench with multiple workspace runners in it. Now, when I run the batch file and if by chance, no licenses are available that time, what will happen? Will my workspace go in an infinite loop till a specific timeout or will it try to trigger for acquiring the license every 1 minute or so and then start running the workbench?This actually matters more because there is an AWS machine which turns on on a scheduled time and triggers the batch file on startup. The workbench starts running by itself. Any suggestions/ideas on this? If this is not possible, any alternatives other than FME server since it is the last approach that we will go for as of now. Thanks,Shivam
Hello everyone, I am trying to use a SQLExecutor with embedded connection parameters provided by some published user parameters. Here's an exemple:After saving the SQLExecutor parameters and reopening it, it seems that the last parameter (password param, i.e DB_PASSWORD) is not being persisted:At first i thought that it would not affect the connection parameters (i.e. maybe an small UI bug), but that's not the case since the SQLExecutor did not use the provided $(DB_PASSWORD): This is a local test, but i have similar results when targeting prod servers.Interestingly, this happens on FME2022.2 (Build 22765) but not on FME2018.0 (Build 18312) Do you notice the same behavior on your workbenchs ? Is there's an workaround for that? (I tried using an ParameterFetcher, same results)Thanks in advance!
I get status 502 when trying to publish a workspace to FME-server. The script works perfectly fine when running it locally on my computer. Have tried searching but can't seem to find any helpful information. What could be the problem?
I'm working with some large DTM datasets and am killing my machine with the clients requested settings. I wanted to see if this "Surface Model" file could somehow help me process the data in batch. The documentation looks promising, however, I've not really had much luck when testing it and there are no examples anywhere I can find of how to actually use it properly.
Hi, this question has been asked previously in the old forum but I couldn't find any answer. I have a workspace that writes an Excel file. The destination dataset uses the value of a published parameter to set the output filename. e.g. DEST_DATASET = $(PROSPECT).xls When running the workspace on the desktop the replacement works as expected. e.g. the output filename becomes "my_prospect.xls". When the workspace is published up to FME Server (2013 sp2) as a data download service the workspace runs but the XLS file returned inside the .zip file is called "$(PROSPECT).xls". ie. no parameter substitution is occuring. Does anyone know how to do this? thanks, Nic
i have two input tables and i am trying to find all matches that start with attribute 'partial' from the first inputin the attribute 'TAG_ID' from the second inputso i converted all 'TAG_ID' to a list 'tag_list{}.TAG_ID' but when i tried to iterate to do so the error'NoneType' object is not iterableappear to mehere's my code s = str(feature.getAttribute('partial')) d =feature.getAttribute('tag_list{}.TAG_ID') matches = [i for i in d if s in i]
I am using FME 2022. When I tried to publish data to ArcGIS Porta, I had the error message as below: ArcGIS Portal Feature Service Writer: Encountered an unexpected error. The error code from the server was '409' and the message was: 'Item 'tmps4rtbkh5.zip' already exists.'. Details: '' Translation Failed.I checked my portal site and found FGDB named 'tmps4rtbkh5.zip' has been published but the feature service hasn't been created, but I can download 'tmps4rtbkh5.zip' file to my local drive. Seems FME already publish the data into portal but failed to generate the feature service from the data. Does anyone have any ideas about this?I used FME2019 to publish data to ArcGIS Portal, never had this problem before.Thanks