General

Hello.I have some data like this:123 m32 m56 m...and I want to keep the numeric part and ommit the unit (m). Which way is the best?

I have self interaction in line .line has id but it make circle and intersect itself .how could I remove the intersection point at same line ? my problem : after using intersection lines ,I found this line divide to 3 lines ,because it intersect itself in point .will be possible to let intersector Transformator to create find intersection lines but between different id and ignore the intersection lines for line that has specific id .Could I specific it in parameter ,to find intersection lines only for different id ?

Hiwhich is the correct css to extratc only the first div  this not work #tabella > tbody > tr:nth-child(-n+30) > td.text-left > div:first-child thxFrancesco

Is there a way to dynamically set the "Attributes to Expose" option in the Feature Reader Parameters dialog box.  I've set a variable equal to the attributes I want, and I've created a user parameter pointing to a .csv file containing the attributes (one on each line), figuring I could update the .csv each time through a loop with the attributes I want from the next file.... but neither of these worked (at least in the form I tried them): I apologize for asking so many questions. I promise to answer some when I get better at this.

I'm using the CSV Reader to import a file that contains all of our AD users information so that they can be imported into other systems.  I've noticed a strange thing on the nightly Job I set up on the FME server with my workflow, that the output file doesn't have newly added rows from the day before (new employees). Though running the workflow manually seems to pick up the users, hence some of the confusion. I've refreshed the reader with a new one, that sets the datasource as a parameter and have tried tweaking some of the advance setting with issues still continuing.  I did try the AD Reader, but it was extremely cumbersome with my lack of knowledge of AD structure and required me to map multitudes of OU's to just get the users, and even then I was still missing some. Thoughts on how to get this thing to "re-read the file for each job run on the FME server?

Have anyone managed to correctly set up FME Desktop (not FME Server - this is OK) to use Azure AD when logging in to an FME Server with Azure AD? I have changed the template and the TENANT_ID and OAUTH_SCOPE and set the redirect url to http://localhost . However I get an error. Not sure where to go from here The scope set is: scope=openid+profile+offline_access

I made a workbench which takes a .zip folder as a source, which contains .csv files, and sometimes an 'attachment' folder which contains images or videos. The output is an xlsx file, a dxf file and if there is an 'attachment' folder, this 'attachment' folder. This workbench will be used through a workbench app in FME Server, the xlsx and th dxf data can be retrieved from the 2 featurewriters via the data downlaod service, but I have no idea of how to read and write a folder with file extensions I can't know. The only solution I see is to move the folder. So I made a python script which unzip the entry file, check if there is a 'attachment' folder, and if so, move it to 'FME_SERVER_DEST_DIR', so it can be downloaded from the url with the xlsx and the dxf. Here's my problem. With a .zip file with only .csv file and no 'attachments' folder, there is no problem, I get my url to download the data and I ge

I seem to be running into the same problem again and again. That problem is how do I pass a series of attributes to a transformer using what would be considered a variable in a scripting language. I can generate an attribute or variable containing a list or string containing the attributes, but I can't seem to figure out how to pass that value into a transformer and have it produce the desired result. I know it has to be possible (you can't know every attribute you want to keep/expose/use in every workflow every time, so passing them dynamically has to be a thing), I just can't figure it out. Plus, I can see having to use dynamic inputs in a hundred different ways I can't imagine yet, so I have to get this bit. Can anyone point me to a resource where I can learn the technique? Thank you.

I'm trying to have a distributed deployment of my standard engine & the dynamic engines in azure kubernetes. I created 2 nodepools and referenced the tag of the 2nd nodepool in the values.yaml file. The dynamic engine has a nodeSelector: {agentpool: nodepooldynamic} field that says this engine has to go on a specific nodepool. However, when I update my deployment it says the pods affinity rules are not met since it only wants to schedule engine pods on the same nodepool as there is a core pod available. Although, the engine pod immediately launches even before the core pod is available. Is the presence of the core pod hard coded or is it possible to change this?

I have previously downloaded (using SharePointOnlineConnector)a file to my local PC storage, and I know that it is possible to use an S3Connector to upload attributes or files, but, how can I directly upload a file from Sharepoint to FME Server folder in the same Workspace without storing it at C:/?

My keyboard input to FME has suddenly changed. If I use another application I get my normal response, but when I try to type in FME, it seems the keyboard layout has changed (probably to another language somehow). I cannot find anything in the settings that fixes this. Has anyone got an idea what might have caused this and how to fix it?

I am in process of migrating FME to a new windows machine and to run in the latest version (FME 2023.1). I have found that the workbenches run faster in the version we have upgraded from (FME 2018.1) Checking the log files for some of the processes, the SQL creator processes take longer in FME2023.  FME 2023 takes 2:06 minutes to connect and run a query ODBC Driver 17 for SQL server installed on new machine Version 2017.1710.03.01 2023-07-27 12:10:05 Microsoft SQL Server Non-Spatial Reader: Trying to connect using Microsoft OLE DB Driver 19 for SQL Server... 2023-07-27 12:12:11| 105.0|103.3|INFORM|140521: Database read complete. Retrieved <default parameter> feature(s) FME2018 takes 38 seconds for the same query2023-07-28 02:17:26 |Microsoft SQL Server Non-Spatial Reader: Trying to connect using SQL Server 2012 Native Client... 2023-07-28 02:18:04| 40.7| 36.9|INFORM|Microso

We are connecting to an SDE database via and SDE file in server, we would like to use Windows Authentication and the service account the server runs under. But when I load an SDE connection file with Windows Authentication selected it does not pick up the windows credtiasl of the service account. Error Message:Could not open the Enterprise Geodatabase. The error number from ArcObjects is: '-2147216118'. The error message from ArcObjects is: {Bad login user}Please ensure the connection parameters are correct (server=`egisdev-db.tnad.tasnetworks.com.au', instance=`sde:sqlserver:egisdev-db.tnad.tasnetworks.com.au', user=`', password=`***', database=`EGIS_UNMaster', version=`sde.DEFAULT') I have tried reading from the DB using a database connection set to Windows Authentication, but we need to to use SDE connection as these are esri geodatabases. Any thoughts?

One of the main pain points I've been having so far with using Python with FME is getting datetime attributes from features as datetimes in Python. FME datetimes normally have a sub-second precision of 7 digits, up to 9, but Python stops parsing after 6. "When used with the strptime() method, the %f directive accepts from one to six digits and zero pads on the right. %f is an extension to the set of format characters in the C standard (but implemented separately in datetime objects, and therefore always available)."        #        # Unzoned        #                a_timestamp = feature.getAttribute('a_

Hello All, I'm working on a workbench to convert IFC to CityGML. Before writing out CityGML, I'm trying to add some CityGML attributes, e.g. class, function, usage, etc.. According the section "Setting CityGML attributes and properties in FME" from Writing CityGML from FME (safe.com), I used these two transfermors "AttributeCreator" and "GeometryPropertySetter" to add the attributes. However, the output CityGML cannot identify the attributes as the ones in CityGML schema. Foe example, I opened the CityGML with notepad, the attribute

I have two point datasets, GPoints (~100 points) and OPoints (~1000 points), and I want to find the nearest neighbor for each GPoints entry. However, the nearest neighbor from OPoints must have an ID that matches the values from 2 possible columns in GPoints. In this case the column names are id1 and id2. E.g.The first entry in GPoints has values of id1 = 9001 and id2 = 9005. Therefore the nearest neighbor from OPoints must have an id of 9001 or 9005 (whichever is closest to the entry in GPoints current being analyzed). In SQL this would be WHERE OPoints.id = GPoints.id1 OR OPoints.id = GPoints.id2.

After it begins running, I have this message: Error: The log file for job ID "19099" does not exist.However, I can see it (only the job id and the workspace number) in the running jobs section.

I have workspaces looking a data quality which are automated on fme server. I am looking to record the monthly number updates from the workspaces and was wondering is there a way a writer can create a new file with a new name (e.g jan 2023 or Feb 2023) instead of just overwriting the current one?

I recently upgraded from FME Server 2022.1.3 to 2022.2.7.  Since the upgrade, the JobHistoryStatisticsGathering.fmw workspace (which runs on a daily schedule as part of the built-in FME Server Dashboards) is failing.  The error message is:+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++Feature Type: `JobHistoryReader_LoopHere'Attribute(32 bit integer)      : `Loop to JobHistoryReader_LoopHere1691186519 Input Splitter.BranchingFactory.Count' has value `1'Attribute(string: UTF-8)       : `_min_job_age' has value `20230803000000'Attribute(64 bit integer)      : `_offset' has value `0'Attribute(string: windows-1252): `fme_feature_type' has value `Creator'Attribute(string: windows-1252): `fme_geometry' has value `fme_undefined'Attribute(string: windows-1252): `fme_type' has value `fme_no_geom'Coordinate System: `'Geometry Type: IFMENullCoordinate Dimension: 2=======================

Hi all, I'm wondering if it is possible to preserve the order of (unexposed) attributes when they come out of the Generic port of a FeatureReader. The attributes are coming out ordered alphabetically, I want them to remain in the order they appear in the schema. My process involves a dynamic FeatureReader to grab data records, a SchemaMapper to map (some) attributes to new names, a SchemaScanner to determine the new schema and a dynamic writer to write features out in the new schema. The problem I have is that the new schema is coming out with attributes in alphabetical order, rather than in the original order (with the old attributes mapped to their new names). Is it possible to preserve the attribute order from the Generic port of a FeatureReader? Thanks!

I am right now struggling to understand this issue. I have read XML several time with FME several times and never encountered this problem. I have an XML file that just lists a couple of airports with some basic information. The xml file looks like this: I read it like this: But when I read it in, this is what I get out of it: What is going wrong here?

Hi, we have several workbenches deployed to FME Server that use the ArcSDE Queirier, which is deprecated. It was reading data from an .sde and deleting the data based on a WHERE clause, and the translation was continued on the output ports of the transformer. What is a transformer that I can use in its place that meets the above requirements?

I'm using FME Workbench 2022.2.24. In the window title and startup screen, it shows Workbench 2022.2, not the full version 2022.2.24. (I also have Workbench 2022.2 installed so this is confusing.) I would prefer seeing the full version number in both of these places. I haven't starting using FME Form 2023.x yet. Does anyone know if the behavior is the same?Should I post this as an Idea? It seems like a vey minor issue.

I have a database table that contains many attributes, one of which is controlled by a domain of acceptable values. I have a list containing a unique list of these valueI want to step through this list and each time through the loop select just the records from the table that would be selected if the unique value were inserted into in query:SELECT * FROM Table WHERE AttribInQuestion = WhateverColorFor instance, "Red" the first time through the loop would return:I've setup my Reader to read the SQL table I want to query, generated a List of my unique values, and created a TestFilter. The T

Can anyone suggest a really good changedetector tutorial or documentation? I'm having difficulties understanding the output where a change in attributes and/or geometry is found. I can't tell which attributes changed (before and after) and I'd like to see exactly where the geometry change is instead of only seeing which features have changed. Hope that makes sense. I'm still learning.