Connecting FME to web services. Use of APIs. Mobile Apps.
Recently active
Hi all,I’m working with a Feature Service containing approximately 1,000,000 sensors stored in a spatiotemporal big data store. I need to update 10,000 of these sensors based on their unique string ID, like sensors-0x21222.Currently, I'm using the FeatureWriter for the 'Esri ArcGIS Portal Feature Service' with the 'Use Global IDs' option enabled and 'Upsert' set as the 'Feature Operation' in the Feature Type. However, 'Upsert' requires a global ID.This approach feels very constrained, as it requires importing all 1 million records, merging them, and finding the global ID for each update.Is there a way to update a Feature Service using a primary key or unique field (such as upserting with a where clause) rather than relying on global IDs? This current method doesn’t seem ETL-friendly, as it requires importing parts of the dataset just to make updates.Thanks in advance for any guidance! Edit:Maybe I don't understand it. But for every featureservice/layer/featuretype I need to add, to fi
I’m trying to discover why my stand-alone python script cannot now ‘import fmeobjects’ after an upgrade of FME Desktop 2022.2 to FME Forms 2023.2.2.The sys.append path that worked previously had a python version subfolder inside the installation’s fmeobjects folder, like this:if os.path.isdir(rf"{FME_HOME}\fmeobjects\{python_subfolder}"): os.add_dll_directory(FME_HOME) sys.path.append(rf'{FME_HOME}\fmeobjects\{python_subfolder}") sys.path.append(FME_HOME) os.chdir(FME_HOME) import fmeobjectsbut those python subfolders are no longer there inside the fmeobjects folder in the Form current installation, but rather are outside in their own ‘python’ folder now. Is this correct? It seems that most of the searching I’ve done has the path to the python version as a subfolder of fmeobjects folder.No amount of appending sys.path versions of the python_subfolder will allow python to correctly ‘import fmeobjects’ and not stop producing:ImportError: DLL load failed
Hi,I’m wondering if it’s possible to create a list of layers included in an online application like Geoportal Map. I tried using the HTTP Caller, but I’m only getting general information about the webpage and no details about its content.Do you have any suggestions for extracting this data?
Hi everyone,I am brand new to FME and created my first workbench. In a nut shell it does this:Brings in 6 different enterprise geodatabase feature classes using 6 ESRI Geodatabase (ArcSDE Geodb) readers Each reader is connected to a tester to only select ‘active’ values in a status field Because I selected ‘resolve domains’ in the reader, an additional field for every field that had a domain was created. It was suffixed with “_resolved”, so I used 6 bulk attribute renamer transformers to rename the fields without the ‘_resolved” I then did 6 attribute removers and removed any fields I did not need when it came to exporting (note, many of the fields between each feature class were the same, but there were some differences) Finally, I used 6 different feature writers to export each feature class into a single geodatabaseAs you can see, I repeated the process 6 different times for every reader/feature class that I had. I was thinking to myself while doing this, ‘this cannot be the right w
Hey all, I’m wanting to snap existing meter points in a Water Utility Network, to field-verified points collected in the field by a contractor. Currently, I am just using an anchor snapper to snap the points, however… the service lines attached to them are not moving, as I believe an “edit” has to be done on the lines to get the network topology to stay intact. I have tried using the anchor snapper on the lines to snap the endpoint to the meter location… but I am not getting the same results I am getting with the points. Is there something I am missing/a better way to ensure the line attached to the meter also moves its endpoint to the new meter location? CS is State Plane, 100 feet is the setting I am using for now. The endpoint of the service line is coincident with the meter location, if that information helps at all.
Hi Everyone, Looking for some assistance, I’m using FME 2023.1.0.0 trying to migrate some existing Survey-123 forms and data with attachments from ArcGIS On-Line to our new Enterprise portal.Our survey-123 form has a singular photos field for tracking a picture of the bus stop, it also has a repeatable photo’s field (table) where the inspector is able to take and attach multiple deficiency photos to the stop if one exists. In FME, I’m able to read in the AGOL feature service that hosts all of the survey information, I’m also able to write out the tabular information from the point layer to the new Enterprise feature layer that was created when I saved the Survey-123 form in Enterprise.The part that I’m currently struggling with is getting the singular photos to attach when writing the tabular information out to the Enterprise feature service so when I view the points in ArcGIS Pro, they appear in the attachments tab of the attributes editor like they currently do with my AGOL service.
I am having a simple workspace; just a reader and writer (see screenshot below).The FeatureReader reads from a Microsoft SQL Server Non-Spatial and the FeatureWriter writes to Microsoft SQL Server Non-Spatial. The datamodel in both databases is the same and in the target database the table already exists.When writing it to the database there are warnings about the field type. For example (see also screenshot below)Microsoft SQL Server Non-Spatial Writer: Attribute `.....' of feature type `.....' has specified type `varchar(1)', but existing database table field has type `varchar(2)'. Information may be lost during conversionIt seems to double all the varchars; and also getting messages about bigint vs numeric. The data is correctly written in target but I want to get rid of all the warnings. I have tried various thing with reading the schema from both the source and the target table. Also tried with 'normal' readers and writers. And also tried with JDBC reader and writer.Does anyone ha
Hi,Some parameters of the coordinate system on the screen are not compatible with Türkiye. I know what the values are and I want to edit this file. Especially, it seems that just changing the delta x y z section in the datum parameters section will be enough. can you help?
