Skip to main content
  • EN

Best Answers

10389 Posts
oliver.morris
Contributor
oliver.morrisContributor
asked in Authoring
dynamically create attributes from list

I have a range of features e.g. coastlines, country borders each with different attributes. These attributes are currently available in a table under the following structure:Each feature type has a different set of attributes and I can tie the attributes to the geometry using the gsa_shape_set_id.How do I turn this flat table in to attributes dynamically adjusting for the schema of each feature? There are thousands of different features and I don't know the schema before this point.Many ThanksOliver 

51012
oliver.morris
Contributor
F
fluusha
asked in Data
Workspace Runner runs only with Source of Child Workspace

I want to run a Workspace with each run a different Shapefiles as Source.I Use the "Directory and File Pathnames" Reader and set it to *.shp.Then i set the Source of the Shapefile in the Workspacerunner to windows_path. And here is the Problem:Now the Child Workspace runs with the Child Workspace Source Shapefile.But so many times as the "Directory and File Pathnames" Reader from the Main Workspace has.It doesnt get that he needs to Change the Source to another Shapefile in the Childworkspace.It only runs 8 times with the Child Workspace Source instead of Using the 8 different Shapes from the "Directory and File Pathnames". What am i doing wrong?

1310
F
mark2atsafe
Safer
mark2atsafeSafer
asked in General
FME Weekly Quiz: December (2) Results (Don Murray)

Hi FME'ers,Well, here are the quiz answers for this week. I think Don posed more of a challenge than Dale did last week. You would have needed a perfect score to beat him. Did you do that?First, the answers...Answers1) What is the name of the site for publishing and sharing FME functionality such as templates, transformers, and web services?FME User CentralFME OnlineThe FME StoreThe FME HubFMEpediaIt's the FME Hub:At one time it did used to be called The FME Store, and this community itself has been called FMEpedia and FME User Central at one time (in fact fmeusercentral.com and fmepedia.com will both lead you to this site).FME Online sounds like fun, but has never been a thing, as far as I'm aware.Don's Answer: The FME Hub (Correct) 2) Which of these actors is the odd one out?Eric BanaArnold SchwarzeneggerPeter O'TooleTim RobbinsAnne HathawayDon's Answer: Anne Hathaway (Correct) I know Don is a bit of a movie buff, but I think this one was a pure guess on his p

811
milo89
Enthusiast
bwn
Evangelist
bwnEvangelist
asked in Transformers
InlineQuerier: Location of SQLite DB?

This may or may not be only answerable by the good people at Safe, but does anyone know where the SQLite database generated by InlineQuerier is created? Is is a temporary physical file, or instead uses SQLite's temporary in-memory (virtual) instance option?Just thinking ahead to some workspace performance tuning options. My workspace InlineQueriers work fairly fast but then the underlying storage is my local PC's SSD so that performance may not translate when executing where the read/write to the SQLite DB involves a different physical file storage environment.

114
bwn
Evangelist
charry
Supporter
charrySupporter
asked in Integration
1st parameter `XZJ' is not a floating point number

Execution error? 1st parameter `XZJ' is not a floating point number?BUT I can't XZJ type

41
takashi
Celebrity
kidega
Contributor
kidegaContributor
asked in Transformers
ListCombiner, no attribute

Hello @takashi I have an AreaBuilder before the ListCombiner. If areas are built they are then checked if they touch/ intersect via SpatialRealtor. After that the ListCombiner will group on the spatial settings. The problem is that if no areas are built (incomplete), I get the error message "PythonFactory failed to close properly". Is that probably because there is no attribute from built area to compute on in "orderByGroup"?So I wounder if there is a way to not activate ListCombiner (PythonCaller) if AreaBuilder returns incomplete? Please see attached image for log message.Thanks.

104
kidega
Contributor
charry
Supporter
charrySupporter
asked in Integration
rename feature attribute with python

how rename feature attribute with python 

20110
takashi
Celebrity
fikusas
Contributor
fikusasContributor
asked in Transformers
2D points with elevation interval to 3D lines

How this can be achieved in FME?https://support.esri.com/en/technical-article/000011817Source data – 2D point geometry with attributes 'FROM' and 'TO' (elevation values stored). The goal is to create 3D lines from those values.

874
fikusas
Contributor
bwn
Evangelist
bwnEvangelist
asked in Transformers
What geometries do Paths get written as?

Stupid question, but I'm wondering how much post-processing I need to do on the output of a ShortestPathFinder before writing it into say, an FGDB.So, a Path is not a Line feature in FME, it seems to be really an aggregate of its component segments, and each segment has a direction indicator on it so that the Path "knows" how to virtually act as a line with the correct virtual Vertex order, regardless that the component segments that are its aggregate, could alternately be running in opposite directions from each other, and one of a Path's segment's start vertex be an adjacent segment's start vertex as well (ie. The adjacent segments run in opposite direction to each other)However, if I put the output straight to say, SpatiaLite or FGDB, then the writer needs to downconvert the Path to Line. Fine, this is desirable behaviour in my case.My question is though: In what order do the vertices get written? In the direction of the Path, or does it depend on the orien

92
bwn
Evangelist
salvaleonrp
Enthusiast
salvaleonrpEnthusiast
asked in Transformers
Exploding a multi-nested XML file using XMLFragmenter to build a lookup table

I can't seem to line up my elements/attributes on this lookup table I'm creating. Thanks in advance!Below is the screenshot of the XML attribute I'd like to create a feature from.Below is the parent-children tree of the elements I want to retrieve from my XML file.This is the screenshot of my workspace and configuration. Enable Flatenning is checked and all options are default.This is the result I'm getting from the workbenchBelow is the expected result  DomainNetworkNamenetworkSourceIdNetworkSourceNameAssetGroupCodeAssetGroupNameAssetTypeCodeAssetTypeNameElectricDistribution6ElectricDistributionDevice1Arrester1Distribution ClassElectricDistribution6ElectricDistributionDevice2Breaker1Air PoweredElectricDistribution6ElectricDistributionDevice3Capacitor1Fixed CapacitorElectricDistribution6ElectricDistributionDevice4Circuit Breaker1Air PoweredElectricDistribution6ElectricDistributionDevice5Elbow1Load BreakElectricDistribution6ElectricDistributionDevice6Fuse1Automatic Secti

1343
salvaleonrp
Enthusiast
kidega
Contributor
kidegaContributor
asked in Transformers
Make list "ID" of touching building footprints within an area.

 Hello,I am trying to find a soultion of workflow in FME, as to the attached image.My first attempt was to use the "NeighborFinder" and check if a footprint touches another. Then group/ list those (light blue circle). Then perhaps do another "NeighborFinder" check within a i.e. distance of 15, and make that a merged list (dark blue circle).I appreciate any idéas. Thank you!

138
kidega
Contributor
aguan
Contributor
aguanContributor
asked in Integration
A huge bug in 2019.2?

Just downloaded 2019.2, and quickly run into a big issue - the HTTPCaller query parameter does not save. For example, if I set a pagesize parameter and its value to be 1000, click OK, reopen it, the value is empty. If I open a similar workbench previously saved in 2018.1, which has pagesize = 1000, change it to be 10000, click ok, reopen it, it is still 1000. I am on windows 10.

144
aguan
Contributor
tomjerry.vl
tomjerry.vl
asked in Authoring
select more than one special character in a string....

i have HSN field and some times those are having special characters, if it is not having any special character and it having single special character no need to select. But here which string having more than one special character then select.Special characters: /- HSN1-11-11-11/22/21-2/21/2-2/2 In above table i need to select on yellow highlighted data only \\

10512
erik_jan
Contributor
G
garydlester
asked in Transformers
Is there a way to create polygonal viewport in autocad?

I would like to create some viewports that are circular and also one shape like this  Is there an autocad attribute I can set to make viewports in irregular shapes?

446
jovitaatsafe
Safer
M
mgharrop
asked in Data
Cannot read WFS

Hello. I cannot seem to run any workbench invokving a WFS. It seems to workan extent where it reads the get capabilities to give me the feature list but when i try to run preview or run the workbench, i get the error "HTTP transfer error: 'Couldn't connect to server'" We work behind a proxy but i have configured this in the s, and it works fine for wms, arcgis featur services. Just not WFS. the WFS service itself is fine, i can connect via other software such as QGIS just not via FME http://geoportal.ancpi.ro/arcgis/services/AU/AU_WFS_STEREO/MapServer/WFSServer?request=GetCapabilities&service=WFS Working on desktop 2019.2 Many thanks

525
M
F
fluusha
asked in Transformers
Inspectors within the Transformers are gone

with the new 2019 Version there is a new Feature:  i had these and worked with it then the IT reinstalled FME.I still have 2019 but now these Inspectors within the Transformers are gone.Is there an Option to activate or deactivate these?

51
nielsgerrits
VIP
connecter
Contributor
connecterContributor
asked in Transformers
Lines at the same location, cut and input a new segment

Hello, here is my problem I can´t get solve: I try the "LineOnLineOverlayer" but I don´t want to touch the red, blue and green line. I have many lines at the same location with different attributes and nodes (black point in the image). After the transformer, the red, blue and green line have new segments I don´t want. Thanks for help!

911
connecter
Contributor
T
tigerwoulds
asked in Integration
Contour shapefile to LandXML for use in Geopak

What would be the best way to convert a contour shapefile to a landxml for use in Geopak? I am not very familiar with LandXMLs or Geopak. I tried creating a TIN from my contours using TINGenerator transformer and output the Triangles to LandXML. If there is a better/more correct way to accomplish this I could use some help. I also have the DEM used generate the contours in ESRI grid format.  I also found this template for creating a LandXML but am lost as to where I need to input my contour data. 

1072
T
G
garydlester
asked in Transformers
How would you get the x,y coordinate of leader tip, Multileader AutoCAD

I would like to find the coordinate for the tip of a leader line in autoCAD I tried extracting coordinate at vertex 0 but the point is not at the exact same location as it is in AutoCAD is there an autocad attribute that represents this information? I have used aggregation method and coordinate extraction on the line feature to get really close but the point is not at the exact location after processing.It looks like the location I am getting is actually the center of the arrowhead and not the location of the tip on the arrow.

4492
jovitaatsafe
Safer
A
alamberthampton
asked in Data
Salesforce Reader: Can a soql Select statement include Relational object like Parcel__r.Streetname

The query below works in Dataloader and the Pentaho Kettle tool. But the Salesforce reader ignores the Parcel__r.xx fields. I see where @schatt15 posted here saying he used Dataloader in his SF Reader. But I don't see any option like that in SF reader. I'm using FME Workbench in ESRI 10.7 FME(R) 2019.0.0.0 (20190328 - Build 19238 - WIN32)Thanks for your time.AllanSelect Parcel__r.MUSW__Street_Number__c,Parcel__r.MUSW__Street__c,  Parcel__r.MUSW__City__c,Parcel__r.MUSW__State__c,Parcel__r.MUSW__Post_Zip_Code__c,CreatedDate,NAME,Ordinance__c,MUSW__Status__c,  MUSW__Corrected_Date__c,GRASS_SQ_FT__C,Age__c,Code_Enforcement_Area__c,Safe_Clean__cFROM MUSW__Violation__cWHERE CreatedDate = LAST_N_DAYS:100

123
J
aron
Supporter
aronSupporter
asked in Transformers
X & Y distance between two points

This seems such a simple thing but I can not find a transformer to achieve it. I want to measure the distance between two points along X and Y. I could of course do this with a LineBuilder, LengthCalculator, a AzimutCalculator and some math. But surely there is a simpler way?

14195
david_r
Celebrity
J
joe_gerner
asked in Data
AutoCAD DWG/DXF read as merged featuretyps and write as single featuretype

Hi, I have different DXF File with a lot of layers. I read them with the AutoCad DWG/DXF reader, filter and editing them. For the better handling I read the files as merged featuretypes, but I need at the end the data with single featuretype. That means I need all layers from the file and not the merged.How can I manage this with the Autocad DWG/DXF writer? Thanks and best regard

52
J
W
watts
asked in Authoring
fme_feature_type not coming through to writer (excel table)

Hi everyone, I am relatively new to FME and am seeking assistance for a minor issue I am having. As part of a project I need to create an excel table that contains 9999 from various attributes and from multiple SDE feature classes. My excel table works but I want to include an attribute that indicates which feature class the record is from. I exposed the fme_feature_type attribute but am not table to get it to export out into the Excel table. What might I be missing? Please see the below screenshot. Thanks in advance for your advice and suggestions!

1574
W
jess
Contributor
jessContributor
asked in Automation
{workspace} and {repository} email template macros return _undefined_

I'm attempting to use the following email template with FME Server 2015.1.3.2 :<fmeblock>This notification e-mail was generated automatically from FME Server (PROD). Please contact your system administrator or submit a service ticket for support. Do not reply to this e-mail. FME transformation job {id} has FAILED. Workspace: {workspace} Repository: {repository} Status: {StatusMessage} Submitted: {timeRequested} Job Start: {timeStarted} Job End: {timeFinished} Logfile: {logFullPath} </fmeblock>{workspace} & {repository} are both returning "_undefined_". All the other macros seem to work fine. Any suggestions?

215
H
M
mdumka
asked in Transformers
Create lines from points for all unique pairs of points in the same attribute

Hello, my input csv is as follows (it was output from a 3 point shapefile using CoordinateExtractor):A,1,2B,3,4C,5,6I would like to output csv as follows (which will ultimately be used to generate a 3 line shapefile from LineBuilder):A_B,1,2A_B,3,4A_C,1,2A_C,5,6B_C,3,4B_C,5,6I'm trying to use various list transformers but I can't get there. Any ideas would be much appreciated!

336
M

Badge Winners

Show all badges

Community Stats

31,821
Posts
120,862
Replies
39,452
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.