Skip to main content
  • EN

Best Answers

10435 Posts
danilo_fme
Evangelist
danilo_fmeEvangelist
asked in Transformers
M
mger1974
asked in Transformers
How to retieve data from text file that resides on multiple lines

Hi, I have a problem extracting data from my text file.The file looks like this:******************************************#Textlimiter=;#Decimalsign=.#ProvadmColumn1, Column2...ColumnX;"Value1";"Value2"...""ValueX";"Value3";""Value4"..."ValueY";#ProvdatColumnA, ColumnB...ColumnZ;"ValueXX","ValueYY"..."Value11";"ValueQQ","ValueRR"..."Value22";#End******************************The ProvAdm-section can contain one or more rowsThe ProvDat section can also conrtain one or more rows I want to read ProvAdm section into one table (SQL Server) and ProvDat into one table (SQL Server) but I dont reaaly understand how to find out where ProvAdm section ends (how many rows should be read) or where ProvData starts (where should I start reading) An additional dimension to the problem is that I need to read multiple files at one go... Perhaps my explanation is not complete b

2665
geomancer
Evangelist
S
sseth2011
asked in Security
How to call a FME workspace (as webhook) without passing security token in header?

We have a use case where we need to implement a webhook using FME. This will be called by a partner application.This webhook has a predefined URI (in partner application side) like:https://fmeserver/repo/worskapce1.fmw?attr=?attr2=?Names of parameters cannot be changed and partner application is not willing to update the webhook to pass security token in the header. We are planning to do security by only whitelisting the ip addresses of the partner application. In this case, how we do call the FME workspace? Everytime I try to call my workspace, it returns an following error"401-Unauthorized. The request has not been applied because it lacks valid authentication credentials for the Target resource" Is there no way to call FME workspaces without passing tokens in the header of the call?Is there a way to change the name of the token attribute in the header to something else? I can repurpose attr2 for this and provide a static token to the application.

1353
hkingsbury
Celebrity
jasperwis
Enthusiast
jasperwisEnthusiast
asked in General
FME SERVER - FILE COPY WRITER - Invalid source dataset

Hi, I have a workspace that runs successfully on desktop, but fails on FME Server. I want to annotate/highlight validation errors in DWG files. So I created a second workspace, that's being triggered by a WorkspaceRunner/FMEServerJobSubmitter, to write these annotations using the correct original DWG as a template. To collect this output in the output of the master workspace and make it available in the download service, I was thinking of using a File Copy Writer. This writer can then be included in the download service when publishing. As said this works perfectly on desktop. But when running on FME Server, I get the "File Copy Writer: Feature contains an invalid source dataset" error.Though this file is definitely created on FME Server:This file exists and is not corrupted, so I don't have an idea why it's invalid. I tried shortening the paths and filename, but no solution.I also tried to add filecopy_dest_filename and filecopy_type, though these don't seem

1562
jasperwis
Enthusiast
J
joelavigueur
asked in Transformers
ronnie.blair
Contributor
ronnie.blairContributor
asked in General
antoine
Enthusiast
antoineEnthusiast
asked in Flow Hosted
M
mala.soni
asked in Architecture
surbhi
Contributor
surbhiContributor
asked in Authoring
S
stevens
asked in Transformers
JSONTemplater, double counter in for loop

Hi All,Helped by info in this forum I constructed a loop in the JSONTemplater, to loop through a list and make a json array based on info if a certain condition is true. This works, I use a $i to reference to the index in the list. In a different counter $c I would like to keep up with how many values are entered i the array and use this value in the array as wel, but I can't get the $c counter to count up.This is what I have so far:[{let $top5s := fme:get-list-attribute("_prio{}.top5")let $themas := fme:get-list-attribute("_prio{}.thema")let $deelthemas := fme:get-list-attribute("_prio{}.deelthema")let $c := 0for $top5 at $i in $top5swhere xs:string($top5s[$i]) eq "Ja"let $c := $c + 1return {"titels": "Projectambitie " || $c ||": " || $deelthemas[$i]  ,        "teksten": "Op basis van de locatie vraagt " || $deelthemas[$i] || " aandacht in je project."    }}]It works, only $c stays at value 1...Anyone got any tips, I probably am overlooking something Regards,Steven

602
S
f.kemminje
Contributor
f.kemminjeContributor
asked in Automation
system caller running for ever

I used rets-connecter runner to download the source data(CSV file) from vendor , and after that fme will read this file for further process. But My System Caller running forever, it's not coming out, executing continuously.. But in command line , it executes immediately and come to the Drive prompt(i mean E:\temp>) fmw file attached.Can Anyone pls help     Command line to run this workspace:        "E:\Program Files\FME2021\fme.exe" E:\FME_TEMP\wb-xlate-1647675806459_11696          --FME_LAUNCH_VIEWER_APP "YES"    Starting translation...Current FME version: FME 2021.2.1.0 (20211203 - Build 21797 - WIN64)FME_HOME is 'E:\Program Files\FME2021\'FME Database Edition (node locked-crc)Serial Number: Z6XB-SJY8-15LXPermanent License.Machine host name is: PXLLTPRD276Locale: en_INSystem Encoding: windows-1252FME Configuration: FME_BASE is 'no'FME Configuration: FME_MF_DIR is 'E:\FME_TEMP/'FME Configuration: FME_MF_NAME is 'wb-xlate-1647675806459_11696'FME Configuration: FME_PRODUCT_NAME is 'F

812
f.kemminje
Contributor
O
osdev
asked in Authoring
D
dominikl
asked in Transformers
lifalin2016
Supporter
lifalin2016Supporter
asked in General
Z
zacharylee1204
asked in General
C
chris28
asked in Transformers
Spatial filter not giving the correct result.

I have a spatial filter that isn't giving me the correct result. I am trying to determine if a feature falls within a polygon. If it does it should pass. If it doesn't it should fail. I know the feature is within the polygon and therefore should be 'passing' but instead it keeps failing. I'm assuming I have something set incorrectly. These are my parameters: Filter type: Multiple FiltersPass Criteria: Pass against one filterSupport Mode: Support aggregatesSpatial Predicates to test: Contains candidate, touches candidate, intersects candidateUse bounding box: noCurve boundary rule: Default rule Merge attributes is selectedAccumulation mode: Merge FilterConflict resolution: Use candidate Preserves Feature Order: Per output port

3176
C
S
samuel.wsp
asked in Transformers
chrbalm
Contributor
chrbalmContributor
asked in Transformers
T
tadaskiskenas
asked in General
tcrossman
Contributor
tcrossmanContributor
asked in Transformers
Would multiple, simultaneous SurfaceDraper transformers significant decrease processing time for a workspace?

In your experience, would splitting the feature flow and directing it into multiple, simultaneous SurfaceDraper transformers significantly decrease the processing time for a workspace, all else being equal? Let me explain what I am dealing with and why I ask ...I have 730K points (center points of square grid cells) and 2.1K triangular 3D polygons, overlapping with each other in both 2D and 3D. For each point, I must identify the triangles it intersects (in 2D) and identify the triangle that is lowest at that point's location, extracting the triangle's z-value as an attribute. For that, I use a SurfaceDraper -- see the screenshot above. Points and triangles go through a PointOnAreaOverlayer with output of both points and areas, and those two flows are directed through ListExploders to end up with two matched sets of equal size as input to a single SurfaceDraper transformer. Functionally, the workspace works fine, but the processing time is massive. The SurfaceDraper appea

181
nielsgerrits
VIP
T
tfsrichard
asked in General
lorenrouth
Contributor
lorenrouthContributor
asked in Transformers
philipwhitten
Supporter
philipwhittenSupporter
asked in Transformers
How to edit the FME TopoJSON output so that it will open correctly in Microsoft Power BI's Shape Map visualisation?

I would like to make a custom map for Power BI's Shape Map visualisation: https://docs.microsoft.com/en-us/power-bi/visuals/desktop-shape-map When I make a TopoJSON with FME and open it in Power BI I see a completely filled square (basically the bounding box is filled). When I take the TopoJSON generated by FME and process it using the default paramaters of the online mapshaper tool (https://mapshaper.org/) by exporting as a TopoJSON the mapshaper TopoJSON file open's without a problem in Power BI.  When I compare the FME TopoJSON files to the mapshaper TopoJSON file using a text reader the only obvious difference that I see is that the parameters are in a different order, but the scale and transformation parameters are similar. I have attached the files to this message. Any ideas on what I need to do with FME so that the outputted TopoJSON files will open in Power BI?

2702
philipwhitten
Supporter
warrendev
Enthusiast
warrendevEnthusiast
asked in General
lifalin2016
Supporter
lifalin2016Supporter
asked in Transformers

Badge Winners

Show all badges

Community Stats

31,951
Posts
121,336
Replies
39,561
Members

Latest FME

Terms & ConditionsCookie settingsAccessibility statement
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.