- - Community Resources
Ideas
Product Updates
Events
Blog

Home
Forums
FME Form

FME Form

A space to discuss FME Form

27691 Posts

neaContributor

Attribute discrepancy between both sides of AttributeManager

I have an AttributeManager in a custom transformer (may be part of the problem but thought I would start simple with the AttributeManager) that has the following data (correct) on the input but the name of the attribute (not the attribute values) is assigned in the output.Input Attribute “Public_Water_System_ID” with correct values and output with wrong values:Settings in the AttributeManager is as follows:For data type I’ve tried buffer (default), varchar(20), and char(20). None of the other types seemed to make sense since the values are string.Perhaps a related problem is that this attribute (“Public_Water_System_ID”) is passed as a parameter into this custom transformer and is seems like there might be an issue with the transfer. However, that being said, the correct values are appearing at the input port of the AttributeManager which is downstream from the custom transformer input.

413

10 months ago

robertgilleyContributor

asked in Transformers

In FTPCaller, downloading a file transfer as Attributes rather than a physical file and accessing/referencing the Attribute data

I have been tasked with connecting to an FTP site, retrieving a csv file, parsing that file into multiple Excel worksheets within one workbook and then FTPing the Excel spreadsheet back to another FTP site.I have all the component pieces working, in 6 different workbenches, the download of the original csv file, the parsing and writing of the data for each Excel sheet and creation of the four individual worksheets and the upload to the destination FTP site. However, I have been advised by the local FME Admin that the process should be housed in one FME workbench. And in order to achieve that, instead of downloading a physical csv file, I should be downloading the data as an attribute so that all of the subsequent processes could be housed within one FME workbench and the attribute data shared by each subsequent process, leaving no artifacts at the conclusion of processing.I have created one FME workbench and copied all of the processes into it and made all the adjustments to User Par

933

10 months ago

dhideoContributor

asked in Data

Compatibility FME Descktop with pluggin Smallworld 4/5

Wich versions FME desktop are compatible with pluggin Smallworld 4/5?

511

10 months ago

s.jagerInfluencer

asked in Authoring

Getting values from a list that is one element of another list

Hello,I have objects, that have a list with a number of different attributes. One of the attributes on that list is another list with a few attributes. Both lists contain 1 - n elements (if either one of the lists is empty, the object is not valid). So, a bit more visual: Object1.list1[0].attrib1Object1.list1[0].list2[0].Attr1Object1.list1[0].list2[0].Attr2Object1.list1[0].list2[1].Attr1Object1.list1[0].list2[1].Attr2Object1.list1[1].attrib1Object1.list1[1].list2[0].Attr1Object1.list1[1].list2[0].Attr2Object1.list1[1].list2[1].Attr1Object1.list1[1].list2[1].Attr2 And so on. What I want to do is check all list2.Attr1 for a certain value, then add list2.Attr2 as an attribute on Object1 (for easier processing and reporting). Due to a large volume of data it isn’t really feasible to use ListExploders (I’m already running into memory issues as it is), so I thought I’d try the Pythoncaller. So far this is what I’ve tried: def input(self, feature): first_list = feature.getAttribute(

5073

10 months ago

alc33Contributor

asked in Authoring

Change a value from a list based on the fme_attrib_info.field_name

Hi!I would like to change a value from a list based on the fme_attrib_info{}.field_name.For example I have :fme_attrib_info{0}.field_name : PROJ with fme_attrib_info{0}.field_value : value1I would like to do : If fme_attrib_info{x}.field_name = PROJ so change value1 by value2.I have a lot of attributes so I have to call the attribute by his name and not by the index manually.I thought to PythonCaller but maybe it exist a transformer for that. Thanks!

1562

10 months ago

harryfuentesContributor

asked in Transformers

Linear Referencing: Calculating new From-To values after segmentation

Hi I’m trying to combine some linear events with a routes geometry. The segmentation works fine. The only problem I have is that the from-to values are no longer correct in the new geometry. How can I update them?

432

10 months ago

mattwilkieSupporter

asked in Integration

Publishing feature services to ArcGIS Enterprise Portal from registered data store

I want to publish feature services to arcgis enterprise portal not using ArcGIS Pro [Share ribbon] tools. Is FME an appropriate tool for this or is it better to use arcpy and the arcgis python API?The source feature classes are in SQL Server in Enterprise Geodatabase. The GDB is registered with Portal as a datastore. We do not want to copy the data to Portal (the resulting feature services should not be hosted).

1001

10 months ago

harishContributor

asked in Transformers

Attribute Exposure in SQL Executer

I am using SQL Executer but in the output port I am not getting the attribute exposed automatically. My SQL expression I am only counting the inputs so I cannot expose the attribute using “Populate Attribute from SQL”. I cannot use Attribute exposer every time I am using the SQL. Is there any other way to do this.

492

10 months ago

arsiContributor

asked in Transformers

Shortest path between multiple from and to locations

I have about 20,000 adresses and 10 locations of the same sort of destination (eg. a doctor). I have already a network.I'd like to calculate the shortest path between each adress and the nearest doctor over the network.Is there a way to utilize the shortestpathfinder for this?I tried the fromToBuilder to create from-to-lines. However, the fromToBuilder requires a join field for each from and to location. Which I would then have to create manually for each adress (and so create 200,000 paths; 20,000 * 10). The shortest path could then be recalculated after the shortestpathfinder to get the closest doctor for each house.Is there perhaps a more efficient way to do this?

674

10 months ago

reservoirdogSupporter

asked in Transformers

DatabaseJoiner looses curly brackets in joined attribute

I am using FME(R) 2022.1.3.0 (20220928 - Build 22630)I noticed while working with ArcGIS Data (FileGeodatabase), that when I usethe “DatabaseJoiner” Transformer to join attributes with curly brackets inside its values, the curly brackets are gone after joining. e.g. Original Attribute value: {12C300A2-64C3-4494-A1E2-430CC5C5C7A9}joined value by DatabaseJoiner: 12C300A2-64C3-4494-A1E2-430CC5C5C7A9It this a known behaviour? Why would it get rid of the curly brackets? Anything to do against it?

282

10 months ago

salahedContributor

asked in Data

Error '-2146232832' while insert or delete

Hello, i’m triying to insert / delete data in a table using Geodatabase connection in the writer but it shows this error message while insert : An error occurred while attempting to store a row into the table 'FCL_EQUIP'. The error number from ArcObjects is: '-2146232832'. The error message from ArcObjects is: {ArcGIS-error creating a new feature !(BaseUserSession::Application not initialized.)} and this while delete : Error while deleting feature in the table/feature class 'FCL_EQUIP. The error number from ArcObjects is: '-2147217402'. The error message from ArcObjects is: {}All edits made during the edit session were savedA fatal error has occurred. Check the logfile above for details

985

10 months ago

mark2atsafeSafer

asked in General

Question of the Week: Running a workspace with Windows Scheduler

Today I cover a frequent issue: how to run FME from the command line, specifically with Windows Scheduler. Question of the WeekThis question was asked in Live Chat by a user with a problem with database connections and Windows Scheduler. Q) In my workspace I use a writer that connects to SQL Server via a SQL Server account. In Workbench, the workspace runs and data is inserted. But run through Windows Task Scheduler, it fails with SQL Server issues. I've set the username and password in the writer, but in the log file it appears to be not set! A) This type of issue appears quite often. In short: if a workspace works in Workbench, but fails in a different environment, it's 95% likely to be a permissions issue. Let's look at a few sticking points and - in particular - this scenario, which is harder because there's a database connection involved. Who Are You?The absolute number one issue when running a workspace from a command line is the account used to do that. It's important to realize

1412

10 months ago

dmitribaghSafer

posted in Data

The AI Geographer: Converting Text to Geographic Features

Hello everyone!I am beginning this conversation with two goals in mind. First, I would like to share and discuss my new transformer OpenAIGeographicCreator, and second, we at Safe would like to see how a post of the new type, “Conversation” performs in the community. The idea is to have a way to expand conversations beyond simple “question-answer” style and have meaningful discussions among multiple participants about problems, solutions, functionality and everything FME related. Here, we could run our ideas by the whole FME community, get advice or inspiration and share our successes and even failures - together, we may be able to help.So, the story of this transformer began with @bruceharold’s idea here: I quickly made a working prototype and realized that OpenAI can really create geometries in the form of GeoJSON from a free-form text description of a location. For example, we can ask the API to give us a center point and a bounding box of Vancouver or a much smaller town in Finlan

2781

10 months ago

galigisEnthusiast

asked in Transformers

Issue Writing 'autocad_oriented_arc' to DWG

Hi All,I’m working on a workflow to project a DWG from one coordinate system to another. The workflow works fine but am having issues to write autocad_oriented_arc into the DWG final output. I did some test to write it to GIS format and those autocad_oriented_arc write ok but for some reason can’t get them to work in DWG format,I’m sure that am missing some settings in the writer because the visual preview shows those arc fine, see below: I’m using the following:FME(R) 2023.1.2.0 (20231110 - Build 23641 - WIN64)Writer Autodesk AutoCAD DWG/DXF parameters as follows: Thanks!

1474

10 months ago

sunsilk11Contributor

asked in Authoring

Escape @ in pythonCaller

Hi I am using FME Form 2021I am passing a ArcGIS portal login (including domain) as a user parametere.g. username@sss.co.uk When I try to get the value in pythonCallerportalAdmin = str(FME_MacroValues['ArcGIS_Portal_UserName']).strip() It is coming asusername<at>sss.co.ukI am unable to use this to login to my portal in pythonCaller. Any idea how to escape the @ sign ?

462

10 months ago

robertgilleyContributor

asked in Transformers

FTPCaller Login Rejected

Five months ago, I created a small FME application that would login to a state controlled secured FTP server and download a file to a local drive. Putty was used and files were generated for local use and for the state. That application was working fine, however, the agency that made the request was not able to approve the process in the interim.Now, five months later, when I run the application in FME, the login is rejected.If I use the exact same parameters to manually download the file with WINSCP I am able to login and download the file without a problem. Nothing has changed in the setup of the FME.In the attached image, I show the three transformers and their parameters that I used to download the file. Five months ago it worked. Now it does not. Manually, it works. Via FME it does not.I am not sure if this is problem in the FME, an issue with my local network security or an issue at the State ftp site.The error message is as vague as described in the documentation.

612

10 months ago

jeroen_hackContributor

asked in Data

Combining two tables without a common field

Hello FME community, I have an issue I'm working on and can't seem to figure out the solution. I have two Excel tables. One with different kinds of certifications and the score each is given.Certification Score Certification_A 1 Certification_B 5 Certification_C 7 The second one contains Applicants with fields defining the various certifications and links to said certification. One applicant can have multiple certifications. We need to determine for each applicant which is the highest scoring certification.Applicant_ID Certification_A Cerification_B Certification_C 1 URL to file 2 URL to file 3 URL to file URL to file In the second table I want to add the scores and then determine the highest score for each row (this i can do in a new field with the max(Value1, Value2 etc) function) and write out the applicant_id, the highest scoring certification name, it's URL and the score.Can anyone give me some pointers how i can solve this case?T

1243

10 months ago

yagami9Contributor

asked in Transformers

Repeating the same process on each group of features

I’m trying to repeat the same process on each group of features that represent each door (every door consists of many features having the same value of door_id) . on the other hand , the process that i want to create is detecting that line on green for each door and drawing it using the LineBuilder .So for exemple ,if in my input i have : 200 features , every 30 or 40 features share the same door_id value (so there are say 6 doors in total )my output : 6 features (each feature is that green line , with the attribute door_id)

HTTPCaller Multipart/Mixed PUT Request

Hi FME-community,I want to use the HTTPCaller to upload two JSON-files in one multipart PUT request. Just using two HTTPCallers separately works fine with Headers defining content-type application/json and Upload Data to Specify Upload Body with the JSON-content in the Upload Body. However, in future it will be convenient to also add different file-types in one PUT. Therefore I have the following Multipart PUT request:As you can see in the example I leave the Content Type blank, because there's no option "multipart/mixed", but consequently it interprets the upload body as plain text resulting in a binary file uploaded. Without success I also tried to set Upload data to multipart/form data with two separate String Uploads which results in the following error: "This FME edition does not recognize the `' function. Please ensure that the current platform supports this function, the function name is spelled correctly, and that you have installed all required plug-ins&

1204

10 months ago

galigisEnthusiast

asked in Transformers

Write to AutoCAD Civil 3D

Hi All, Is there any writer for AutoCAD Civils 3D (.dwg)?There’s definitely an AutoCAD Civils 3D and Autodesk AutoCAD Map 3D Object Data Readers but can’t find the same writers?

421

10 months ago

galigisEnthusiast

asked in Transformers

Autodesk AutoCAD Civil 3D / C3DReader::processAeccAlignmentEntity ERROR

Hi All, I’m trying to read an Autodesk Civil 3D file in FME(R) 2023.1.2.0 (20231110 - Build 23641 - WIN64) but gives me the following error, see below:AutoCAD Reader: An error occurred for dataset 'filename.dwg', in function C3DReader::processAeccAlignmentEntity. Exception thrown: 'Invalid input' (Invalid input) I have left the default setting to read Autocad Civil Files, see below:

421

10 months ago

jasoncContributor

asked in Data

Nightly Change Detector Process inserted more records than Expected

I have a process that uses a change detector transformer to compare address data from one database and update the data in a second database based on differences in the dataset. It works great normally but the other night it updated, but I had an extra 85000 records that ended up being duplicates of existing records. Both these databases are SQL server ESRI Geodatabases and are using the same SQL server instance. What I think happened is that the database instance was failed over while the FME process was in the middle of running, which disconnected the session temporarily and when reconnected started reading records again which looks like it started reading the records from the start but still included the records that were already read in addition. Is there something I can do or set when a database is failed over in the middle of running a process to prevent this issue?

382

10 months ago

limoSupporter

asked in Transformers

How can I convert colorscheme from rgb to hsv for an aerial image (tif-file)

Hi, we have tiff files with rgb values. Is there an easy way to transform this tiff file in hsv color space?Something like inside the transformer “rasterexpressionevaluator”? thanks in advance

797

10 months ago

agelfertContributor

asked in General

What could be the reason for a SQL Server Truncate to take so long? (FME 2022)

I recently upgraded to FME Server 2022. As I'm creating new workbenches for publishing or modify existing workbenches, I'm transitioning to Desktop 2022 as well.I have a process with three (3) identically configured Feature Writers (ESRI SDE/SQL Server) that first truncate three (3) tables and then insert into those tables. I have updated and republished this in 2022. When I try to run it in my new environment, it stalls at TRUNCATING one of the tables... literally sits there for almost 2 hours, then resumes. I should add that this is not a super large table - 150K records maybe. My understanding of TRUNCATE does not suggest this size would have an impact, nor have I seen this before. Nothing has changed about the database/table. Nor the Writer configurations or workbench "logic". What could be causing this hang-up? Has my Writer gone south?

4493

10 months ago

chandramohanvContributor

asked in Authoring

SMB Version for FME Desktop

Hi everyone,An inquiry concerning the FME Forms(Formerly FME Desktop) supported SMB (Server Message Block) version was sent to me by an infrastructure technician. Since the word was unfamiliar to me at the time in FME, I started looking it up in our community as well, but I was unable to discover any information.At last, I retrieved the SMB2-enabled version from the FME Forms installation server and distributed it to them. Are there specific details available regarding the FME desktop supporting version?I'd like to share this here in order to gain some clarification on this, and others who are in a similar circumstance might find it beneficial.🙏🏼Explore, Learn and Share it with all..

450

10 months ago

1
...
77
78
79
80
81
82
83
...
1108

Page 80 / 1108

Badge winners

hyperxhas earned the badge Teacher (Grey)
judithhas earned the badge FME Certified Trainer
lundg1has earned the badge Integrate Data with the FME Platform Training
bezearvhas earned the badge English Speaker
bezearvhas earned the badge French Speaker

Show all badges

30,410: Posts

Terms & Conditions Cookie settings

Sign up

Already have an account? Login

An FME Account is required to contribute

Login to the community

An FME Account is required to contribute

Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.

Enter your e-mail address

Back to overview

Scanning file for viruses.

Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.

This file cannot be downloaded

Sorry, our virus scanner detected that this file isn't safe to download.

A product of

Company Products Giving Back Careers Contact Privacy Feedback

Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.