Skip to main content
  • EN

FME Form

A space to discuss FME Form

10000 Posts
A
asadamjad
asked in General
Sperate Columns

I have excel file where i need to separate all columns please help me out

140
redgeographics
Celebrity
ravibansal
Contributor
ravibansalContributor
asked in Transformers
Can I use some other transformer instead of DatabaseDeleter? How about using a SQL Executor?

I have FME workspaces deleting and writing records to the StagingAddress table in an ESRI GeoDatabase. For every agency, the STAGINGADDRESS table is purged using the DatabaseDeleter transformer and then the subsequent workspaces insert records into the STAGINGADDRESS table and then transferred to the ADDRESS table. This process is repeated for multiple agencies.For every cycle, the purging part with the DatabaseDeleter transformer takes the most time.Can I use some other transformer to speed up the purging part? How about using SQL Executor? I am not sure if it will cause any issues, hence asking.

720
ctredinnick
Supporter
I
ionveronica87
asked in Transformers
I have a geodatabase that I want to upload to arcgisonline. I set the projection to be 28992 but when I check the projection in AGOL, it will always be Spatial Reference: 102100 (3857). I would like it to be 28992. Is there any way to do this from FM

I have multiple layers in my GDBI know I can get the correct projection using share from arcgis pro, but I don't have an arcgis pro subscription for this account, only arcgisonlineI will need to keep updating the layers keeping the projection in arcgisonline 28992 thank you in advance for your help

854
I
tcrossman
Contributor
tcrossmanContributor
asked in General
How do I determine the domain name assigned to a feature class in a file geodatabase?

I have read many posts and articles about FME and geodatabase domains, and nowhere can I find any mention of reading the domain name. I can resolve the domain code for any given feature, getting the <attribute>_resolved value. I am pretty clear on how I have to go about extracting all of the domains in a geodatabase. Given a full domain definition, I can create the coded_value(...)-formatted native_data_type value for a schema feature; however, I can find no reference to how to extract the associated domain name for a feature class in an existing geodatabase, at least with pure FME. This seems nuts, and I feel I must be missing something fundamental. Anyone have any pointers here? Any help is much appreciated.

1512
tcrossman
Contributor
markcoopersdc
Contributor
markcoopersdcContributor
asked in Transformers
Spatial Relator: List issues with multiple suppliers and multiple predicates

HiI am using fme to work out the spatial relationship between two polygon datasets. Some requesters will have multiple suppliers and I have enabled the list to store the references for each supplier. Following this transformer, I have use a list concatenator to show these references in one field. This works great when I have only one predicate selected. Where multiple are selected, I have created a second list concatenator for the relationships{}.pass{}. Unfortunately, both these can contain different number of values. For example, there could be two suppliers, but one of these could pass intersect and within and the other just intersect. My difficulty id knowing which pass attribute relates to which supplier. Please can someone let me know what I am doing wrong? Many thanks 

1470
M
J
jryan
asked in Authoring
Renaming an attribute name to a parameter value

Is there a simple way to rename a attribute name so a user defined field name set in a customer transformer parameter?

11616
sashal
Supporter
greatdata
greatdata
asked in Data
I've looked at many posts, but still don't see this answer. I have a Geodatabase that should be in EPSG:4326, but when I use Coordinate Extractor to try to derive the lat/long, I get numbers with 7 places to the left of the decimal point.

I've tried Attribute Reprojector, but that doesn't seem to help. I just need the lat/long.

70
greatdata
kumarkannan1980
Participant
kumarkannan1980Participant
asked in General
In my FME workbench with PostGIS reader , snapper , PostGIS writer. Before reader reads the data from database I need to check whether that workarea is finished in the previous production activity in a standalone table. Kindly let me know how can I c

109
redgeographics
Celebrity
nielsgerrits
VIP
nielsgerrits
asked in General
Single quote (apostrophe) in published parameter when submitting a job through FME REST

We have a workspace on FME server (2021.2.6) with a published parameter ProjectName.We're submitting jobs through the REST enpoint, using json for the parameters.Now we have a project name with an single quote (apostrophe), like:A'damThis results in a code 400 - bad request. So, what is the correct way to send this string in the json? What we have tried:A%27damThis works, but then we need to decode the string in workbench.A\'damThis works, but server interprets this as as a double quote.A"damWe also tried to replicate this in submitting a job from the fme server interface but then the parameters are sent as form data, not as json...

892
nielsgerrits
VIP
mathew.cooper
Participant
mathew.cooperParticipant
asked in General
FME Desktop (2022.1.0.0 (20220704 - Build 22618 - WIN64) hangs after changing anything in AttributeManager

My workspace isn't complex yet if I make a small change inside and AttributeManager, FME Desktop hangs for a good minute. The CPU does spike while it hangs.Has anyone else run into this issue before? This is a clean install on a beast of a machine so I shouldn't think its resource related.

355
danminneyatsaf
Safer
A
au.dhdbsysadmin
asked in Integration
Hi, I'm new to FME. I have created a basic workspace using the Esri ArcGIS Portal Feature Service Reader and are having issues with authentication.

When I select NTLM the workspace successfully runs on FME Desktop and FME Server with all features read as expected. When I select Kerberos, the workspace successfully runs on FME Desktop but not FME Server.  The following error is observed in FME Server: “ArcGIS Portal Feature Service Reader: Using authentication ‘Kerberos’ ”“ArcGIS Portal Feature Service Reader: Logging into ‘https://<my ArcGIS Portal host>/portal/’ as user ' ' ”"ArcGIS Portal Feature Service Reader: Could not log into https://<my ArcGIS Portal host>/portal/sharing/rest/generateToken as user ' '. Check your credentials and try again. The error code from the server was '400' and the message was: 'Unable to generate token. 'username' must be specified, 'password' must be specified." Ideally we would like to use a more secure authentication method than NTLM. ArcGIS Portal is not currently setup to use OAuth and I’ve attempted to use the other authenticati

1200
rahulsharma
Safer
featuremichael
Enthusiast
featuremichaelEnthusiast
asked in Authoring
FME 2022.1.0 - Points + Attribute: Radius add a Bufferer INVALID_PARAMETER_BUFFER_AMOUNT Error

I use FME 2022.1.0 - if i use a Shape-File with x Points + Attribute: Radius then add an Bufferer Transformer + the right settings for Circles. I get an INVALID_PARAMETER_BUFFER_AMOUNT Error In 2021.2 FME 32bit it is working flawless. Is this fixed in FME 2022.1.1 ? Greez Michael

540
whkarto
Contributor
jasonc
Contributor
jasoncContributor
asked in Transformers
I am trying to terminate a process after using a Change Detector if the number of features that are unchanged is below a threshold. What is the order of operation for fme_db_operations when sending the results to a writer?

What is the order of operation for fme_db_operations when sending the results to a writer?  If I have a feature counter attached to the Unchanged Port of the Change detector and test the number of records, can I analyze and terminate the workbench before the Deleted, Inserted, and Updated records get processed in the Writer?

272
caracadrian
Contributor
michiedem
Contributor
michiedemContributor
asked in General
Problems reading XML

I have a large XML (4GB+) I have trouwble to read. I need all elements, however: pand_bagpandid (2) only becomes a feature when it's the only element selected. If I check 1, I get alle elements execpt pand_bagpandid, when I select individual elements (3) I still get all elements except pand_bagpandid, if I only select pand_bagpandid I do get it, but I don't get any of the other elements. I am inexperienced with xml and have ben struggeling with this for quite a bit now. The xml fragements show the same behavior. Flattening, fragmenting or exposing attributes didn't work for me either

70
danilo_fme
Evangelist
mark2atsafe
Safer
mark2atsafeSafer
asked in General
What's Up Wednesday (7-September-2022): Scavenger Hunt Results, Hub Updates, Server API v4, More FME Conference Follow-Ups, Transformer Friday, and more...

Hello FMEers,Here's your weekly dose of news from the world of FME. Scavenger Hunt ResultsThe Scavenger Hunt just finished and the results could not have been closer:  Team Nordend won from Team Zipster by just 65 points. And it wasn't just close in points, it was also close in time. Team Nordend made the winning submission just seconds from the game closing. I thought that was a deliberate tactic, but it appears that they really did get the winning solution at the last second:  So congratulations to them, Team Zipster, and Team Transformer - in fact, to anyone who participated. And thank you all for taking part. The whole idea was to learn a little about FME while having fun and to help build teamwork. It seems we succeeded:  If you want to have a go at solving the problems for yourself - or just check out the answers - then you can find most of them on the community: Fun with Flags Puzzles/Solutions (easy level)Where in the World Puzzles/Solutions (medium difficulty)Brain Teaser Puzz

90
danilo_fme
Evangelist
N
nel
asked in Transformers
How can I update/change specific PropertySet values (IFC)?

Hi everyone,I’m struggling to change/update values of an IFC-file. Example:old PropertySetIfcPropertySet VolumePosition: 1Unit      : m3Quantity: 15  new PropertySetIfcPropertySet VolumePosition: 1Unit      : m3Quantity: 350 I used the GeometryPartExtractor to extract the IfcPropertySets from a IfcBuildingElementProxy geometry. Then I tried to adapt this https://community.safe.com/s/article/updating-ifc-example into my workspace. I used an AttributeCreator:ifc_property_set_name = VolumeQuantity = 350 After that I configured the GeometryPropertySetter and GeometryPropertyRemover. Unfortunately, the original PropertySet Volume will be deleted after writing. In the updated one, Position and Unit are missing. Is there a way how I can keep the traits of the original PropertySet and only change/update one specific value? thxNel 

620
evieatsafe
Safer
M
manca_ent
asked in Data
Group features by week number

My dataset contains date attributes per day that work was completed. My output needs to have the count of attributes that fall within any given week - example week 40 has 25 attributes - going back to the start of the year. I'm new to working with dates in FME so any help would be appreciated.

16611
david_r
Celebrity
thijsknapen
Contributor
thijsknapenContributor
asked in Transformers
What causes my attribute values (in this case CASnumbers) to be distinct?

Hi, I encountered something peculiar last week. I had to compare two datasets about chemical substances measured in groundwater.To compare the datasets, I used the ChangeDetector. While doing so, for one substance an update/change was found for the value of a CASnumber. However, when I look at the originalValue and the revisedValue, I don't see any difference. Also, when I perform a compare using (a plugin of) Notepad++, it also detects a difference in the two CASnumbers. So there seems to be a difference, I just can't seem to spot the difference ;) Maybe some people here can help take a look and provide an explanation? Any feedback is appreciated. The CASnumbers are:CASnumber_1 = '‎483-63-6'CASnumber_2 = '483-63-6' See also the screenshots below for a dummy workspace and the comparison using (a plugin of) Notepad++; 

75
geomancer
Evangelist
arash_hokm
Contributor
arash_hokmContributor
asked in General
overwrite existing Shapefile and FGDB

Hallo FME community,I want to know how to overwrite existing shapefile file and FGDB. With CSV it's clear but with shapefile and FGDB I can't find an option to overwrite.  

1280
david_r
Celebrity
D
dvandommelen
asked in General
Designating band names with RasterBandCombiner

This is likely a simple question: I have a workspace set up to read, sample, clip, sort and combine Sentinel-2 data into a single raster with 9 bands. It works fine. The default band numbers generated by RasterBandCombiner are 1-9, but I'd like to name the bands based on the original Sentinel-9 band numbers as displayed in the original rasters. Is there a simple way to designate the raster band names using something like the fme_basename?

400
D
jhawks
Contributor
jhawksContributor
asked in General
An error occurred while attempting to insert a row into the table 'UNSARE' using a cursor. The error number from ArcObjects is: '-2147216063'. The error message from ArcObjects is: {Spatial index grid is too small [HARBOUR.UNSARE]}

An error occurred while attempting to insert a row into the table 'UNSARE' using a cursor. The error number from ArcObjects is: '-2147216063'. The error message from ArcObjects is: {Spatial index grid is too small [HARBOUR.UNSARE]}

3220
jhawks
Contributor
T
tslack
asked in Data
Reconciling SDE Database in workspace using FeatureWriter

Hey guys, https://community.safe.com/s/question/0D54Q000080hBYOSA2/reconcile-and-post-issue Just following this here to reconcile our versioned ArcSDE in a workspace. I have the basic flow set up: Creator --> AttributeCreator --> Writer and i've set the parameters based on the thread above. My question on the writer is what geometry type and row selection information I need to fill in to get it to trigger? I didn't see this addressed in the two threads on this I found searching.Thanks

290
T
robertr
Contributor
robertrContributor
asked in General
Feature Reader - Read Excel Data that doesn't have the header on the first row

Hello,I am trying to read multiple excel files that unfortunately don't come very clean, meaning that the headers are starting on the third row while the first two rows are mainly blank. So I used the "Directory and File Pathnames" reader to pull all the excel files that I need and then connected it to the Feature Reader but the "Attributes to Expose" doesn't work as I don't have headers on the first row. I attached a snip of how the .xls files look. Basically I would need to somehow skip/delete the first two rows and read from there. Not sure.  Can anyone advise on this one? Many thanks!

2410
geomancer
Evangelist
cruzh
Contributor
cruzhContributor
asked in General
Does FME server or desktop use JAVA to perform any functions? If so, what JAVA is used? Oracle Java or Open Java?

We have been asked to audit all of our systems to confirm whether JAVA is being used. We want to confirm that we are compliant in licensing regarding anything Java. Thanks!

3412
cruzh
Contributor
edward_skanska
Participant
edward_skanskaParticipant
asked in General
What would be the correct tool for removing data from from a file while maintaining the columns it came in?

Quick a simple question but one that has stumped me.I am trying to remove all of the data that has been pulled into FME from a shpfile on AGOL. The aim is to later replace this removed data with new data in same shpfile before reuploading this to AGOL. So I was wondering whether there was a tool that was able to be used just to remove the data while leaving the columns itself.

460
edward_skanska
Participant

Badge Winners

Show all badges

Community Stats

31,846
Posts
120,959
Replies
39,476
Members

Latest FME

Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.