Skip to main content
  • EN

FME Form

A space to discuss FME Form

10000 Posts
I
ingridantonsen
asked in General
Multiple SOAP requesta

Hi all!I want to request the monthly average exchange rate for a whole year. So far, I have transformed the soap request to xml and pasted it into the xml templater. I then post the request by the HTTPCaller and extract attributes by means of the XMLFragmenter. This works fine as long as I request the monthly average exchange rate of one month of a specified year at the time.However, here is were I am stuck: To get all monthly average exchange rate I would need to post 12 request, one for each month. My idea was to do this by means of sub templates, but I have not succeeded in doing so. I tried to import a file containing a list from 1 to 12 (1= january...12=december) and connect this list to the sub port. I could add 12 xml templater and httpcaller instead, but this does not seem very effective. Is it possible to achieve this by sub template?Or is there a way to dublicate requests or is it in some way possible to loop through the request?Any ideas and help are welcome!Thanks in adva

152
I
K
kamranrizvi602
asked in Transformers
Hi, I am trying to practice "Generate workspace" module but I don't have "FME Training PostGIS database" connection available. I tried to add database connection, but I don't understand what URL to enter in the "Host" parameter.?

Hi,I am trying to practice "Generate workspace" module but I don't have "FME Training PostGIS database" connection available. I tried to add database connection, but I don't understand what URL to enter in the "Host" parameter.?

150
redgeographics
Celebrity
gogopotter90
Contributor
gogopotter90Contributor
asked in General
Question relates to Neighbor Finder

Hello , i have question relates to neighbor finder .i have two different data of lines as input of neighbor finder .lines A lines Bmy parameter : no. to find (keep empty ) without value so as possible and distance 1 meter .my target to find which lines from lines A close to lines B within distance 1 meter .i have got the expected output with id .But does it possible to find ,which part exactly of lines that has distance 1 meter from other lines and save geometries with id for each part of lines .thanks in advance fme 2021

110
gogopotter90
Contributor
lapriverside
lapriverside
asked in General
testing

https://community.safe.com/s/

20
lapriverside
tjc_cows
Contributor
tjc_cowsContributor
asked in Transformers
Esri ArcGIS Portal Feature Service Reader not reading shape column so I am unable to write to SQL arcsde featureclass

I am having no trouble reading the parcel polygon portal service, its just not bringing over the shape column, so I am unable to write the data to our SQL database.

290
tjc_cows
Contributor
K
kasobczyk
asked in General
Expose attributes using Python FME API

Hi all,Recently, I've been trying to load an Excel file using Python Creator.reader = fmeobjects.FMEUniversalReader('Excel', False)reader.open(FME_MacroValues['SourceDataset_XLSXR'])feature = reader.read()while feature:               attributes_list = feature.getAllAttributeNames()               for attr in attributes_list:                      attr_value = feature.getAttribute(attr)                      feature.setAttribute(attr,attr_value)               self.pyoutput(feature)               feature = reader.read()reader.close()Unfortunately, the above reading process loses the feature schema.Is it possible to use Python FME API to expose all attributes or load a feature schema from a source file?

1330
daveatsafe
Safer
gustav
gustav
asked in Transformers
DGN v7 writer rounds coordinates, which causes the file to end up a little wrong in the world

Hello! When converting DWG/DGN v8 files to DGN v7, the coordinates in the v7 file are rounded, which causes the file to end up a few centimeters in the wrong place. I want the v7 file to have the same coordinates as the v8. How can i solve this?/ What is happening with the transformation that casuses this? The image is very zoomed in, but there is a difference.  Regards,Gustav

130
daveatsafe
Safer
gogopotter90
Contributor
gogopotter90Contributor
asked in General
How to convert lines to many points ?

Hello ,how could I convert lines to too many points ? i have used chopper with max vertices 1 but it seems to me a little points that I get .i would like to have too many points as possible for each line .what should I do ?thanks kn advance FME 2021

1430
gogopotter90
Contributor
ebygomm
Influencer
ebygommInfluencer
asked in Authoring
SchemaMapper - catching partially matched features

I'm using a schema mapper to update a number of attributes that have string values to a corresponding code. I'd like to catch features where one or more of the attributes to be mapped have a value that isn't in the schema mapping table.  There doesn't appear to be an easy way to do this, since some of the attributes on the feature are mapped, the feature exits the mapped port. Has anyone come up with a good solution for this?

160
ebygomm
Influencer
gogopotter90
Contributor
gogopotter90Contributor
asked in Transformers
How to use feature reader to read ArcGis geodatabase sde and show the content of each table

hello ,  how could I use feature reader to read Esri ArcGis geodatabase sde to get the content of tables . i have tried it but the output has no content of table .it shows me only the amount of table .could some one explain me ,how to get the content of tables by using feature reader ? and also show the output ports with name of each table ? i will be thankful if someone could show me the parameters that I should consider in Festure reader .FME 2021   

730
gogopotter90
Contributor
ebygomm
Influencer
ebygommInfluencer
asked in Transformers
Schema Mapper and embedded PostgreSQL connection parameters

When using the schema mapper and connecting to a postgres table and choosing embedded connections there are no options to choose a parameter that holds the relevant value. For host, port, database and username, I'm able to type e.g. $(STAGING_DB) and create the link to my user parameter that way. However this doesn't work for the password field.Is there any trick to link the password parameter?  (FME 2021.2.0.0 Build 21784)

210
ebygomm
Influencer
ares
Contributor
aresContributor
asked in Transformers
When using an SQLCreator and writing to a dynamic Excel-file for multiple queries I get the error the fme_feature_type does not exist. I've tried adding it with an attributeCreator with the value 'test' but the message keeps occuring. Any thought

FME version 19.1.2Warning message: Cannot define schema for 'test' as the feature does not contain schema information, and schema source is set to 'Schema from Schema Feature'. Please verify writer feature type configuration.Error message: XLSX Writer: No DEF line could be found for feature type 'test'. If you are using dynamic schemas, ensure that the fme_feature_type attribute exists on the incoming feature and corresponds to a valid feature type definitionWorkspace included below (I've tried 1 query now, but I'd like to add multiple using a conditional value for the sheet name)

1390
ares
Contributor
virtualcitymatt
Celebrity
virtualcitymattCelebrity
asked in General
Can I get the dataset saved in FME Server from a POST request?

In the JobSubmitter (and DataDownload etc) service you can have the body of your POST request be treated as an input dataset.  I'm trying to run a bit of a post process to create a summary of the previous job and as part of that I want to be able to access the file saved on FME Server. I can see the file in /system/temp/requestdata folder but I can't figure out how to get the actual file name for a given job.  The only place I can see this is in the actual job log which I really don't want to have to parse.  each file has a prefix which looks to be some number which is increasing overtime so I'm guessing it's related to a timestamp.  Anyone know of a way to know which file goes with which job?

100
david_r
Celebrity
joy
Enthusiast
joyEnthusiast
asked in General
FME Server 2022.2.2 When sheduling a script password changes itself automatically

In my colleague'script there is an ArcGISOnlineConnector and my colleague made a parameter of the password for the ArcGIS Online connection.At FME Server, we first filled in the parameter for the workspace and made a testrun. The script ran and it works. However when I make a shedule of this script, fill in the parameters, after triggering once, then for some reason the value of the password gets the following string (see image below). I am not sure why that happens. Then I change the value to the correct pasword, however after triggering the schedule, the password changes itself again into that long password, while this long password is not defined in the script itself. Since the password is not correct, the script will fail since no connection can be made with ArcGIS Online. Does anyone might know why this happens and what I can do to get the original password all the time instead that it changes itself after running once succesfully.

466
joy
Enthusiast
A
antoniodltm89
asked in Transformers
Mathing X, Y, Z in PointCloudMerger

Hello everyone! I'm trying to combine the components of two point clouds from their x,y,z coordinates but they never match 100% of the points... The help of the tool says that it may be necessary to round the coordinates but the transformer "pointcloudexpressionevaluator" does not have the "round" function... How could I round the coordinates of the x, y, z components to match and match? I would really appreciate any kind of help. 

32
A
I
ingridantonsen
asked in General
SOAP API not working in FME

Hi all!I want call a soap service in FME. I use this link:https://swea.riksbank.se/sweaWS/wsdl/sweaWS_ssl.wsdlI used the program SoapUI to generate and test the xml request. In SoapUI the return works fine. This is the request I use:<soap:Envelope xmlns:soap="http://www.w3.org/2003/05/soap-envelope" xmlns:xsd="http://swea.riksbank.se/xsd">  <soap:Header/>  <soap:Body>     <xsd:getMonthlyAverageExchangeRates>        <year>2022</year>        <month>1</month>        <languageid>en</languageid>     </xsd:getMonthlyAverageExchangeRates>  </soap:Body></soap:Envelope> However, in FME I only get a list of function as a return.Any help is welcome.Thanks in advance! 

440
I
J
jeaner
asked in General
Calculating County Left (or any other polygon) and County Right to road centerlines.

I'm trying to calculate the county left and county right of a road centerline based on it's direction of digitization and position within or along county boundaries. Someone had suggested the TopologyBuilder transformer but I must be doing something wrong. The right and left face fields are <missing> on the centerlines edges but not on the edges that were converted from polygon. I hope this makes sense. I'm using the same projected coordinate system on both datasets and the roads were split at the county boundaries in a prior transformer (LineOnAreaOverlayer). Please help! I've been at this for some time now.

330
caracadrian
Contributor
K
kamranrizvi602
asked in General
Hi, Is Longitude and Latitude information being necessarily for FME to work?

Hi, Is Longitude and Latitude information being necessarily for FME to work?

90
caracadrian
Contributor
T
tanmat
asked in General
I would like to know which is the closest hospital to each address by the road (not Euclidean) and get the distance

Hello, I have a dataset of addresses (points) and another dataset containing the hospitals (points).I have a dataset for all the roads in my study (line).I would like to know which is the closest hospital to each address by the road (not Euclidean) and get the distance. I tried with "shortestpathfinder" but I have to put a line as input, which I calculate with "Neighborfinder", but it gives me the shortest euclidean distance and not by road. Thanks

180
DanAtSafe
Safer
jp12212
Contributor
jp12212Contributor
asked in Transformers
Move all data to zero

I'm new to FME and want to create a workbench that translates 3D data to zero. I have IN (reader) -> CenterPointExtractor -> Affiner -> OUT (writer). Within Affiner have: 1, 0, @mult(@Value(_inside_x),(-1))0, 1, @mult(@Value(_inside_y),(-1)) I've tried a bunch of variants of this but am struggling to get the data to move to zero. Workbench attached. Thanks for the assistance.

210
jp12212
Contributor
candacel
candacel
asked in General
Internal Server error on your website

Hello, I wanted to share training resources with some new people at my org, but I'm getting an internal server error on your website https://engage.safe.com/training/live-online/

740
samatsafe
Safer
N
newsafeuser
asked in Transformers
How to send form data through httpcaller transfomer?

Hi,In Postman:I have setup a POST request to https://xxx.com/loginIn Body as form-data or x-www-form-urlencodedusername:user@test.compassword:Test123And I get my response back OK In my httpcaller I am setup like this : But now I got a server error, just like my request is malformatted, as you see I even tried to put the form data into a specific attribute instead of passing directly inside the httpcaller. I got a feeling that fme httpcaller is having a problem with the "@" in the username, because in cURL I would put username in double quote to make it work just like : curl -X POST -F "username=user@test.com" -F "password=Test123" "https://xxx.com/login" What am I doing wrong there? 

2340
danminneyatsaf
Safer
jhawks
Contributor
jhawksContributor
asked in Transformers
Using wildcards in Attribute Filter?:

Workbench is S-57 .000 files to File GDB. I only want to write Soundings that meet that meet the criteria SORIND where it's equal to US,US,graph,Chart * (for any chart number). Is this the correct transformer, syntax etc: 

3130
jhawks
Contributor
L
lopes8
asked in Transformers
How to export an XLS of my GDB data model?

I need to export the Data Model of our entire Geodatabase for an external consultant without the Data and it needs to vendor agnostic format (cant export an Esri XML Workspace for example). In the past I used a package call Geodatabase Diagrammer but it is no longer compatible with current releases of Esri let alone Pro. I was hoping to get some tips on how someone would be able to use FME to do this. I am hoping to be able to produce an XLS with a tab for each featureclass that lists the fields in one column, data type in another, field length, alias, perhaps domain. Any tips would be very appreciated!

1240
salvaleonrp
Enthusiast
K
kotrynav
asked in Transformers
Bentley writer (DGNV8) adding description

I am trying to find a way to identify the date when the workspace was run in the resulting Bentley files. According to the end-users, that can be specified in the file description.  Is that the best practice? If yes, how could I add the description from the FME DGN V8 writer?  Any pointers would be greatly appreciated!

20
K

Badge Winners

  • Integrate Spatial Data
    dezuviriamhas earned the badge Integrate Spatial Data
  • FME Form Basic Training
    johnrochehas earned the badge FME Form Basic Training
  • FME Form Advanced Training
    sahan969has earned the badge FME Form Advanced Training
  • Student (Bronze)
    marionmahothas earned the badge Student (Bronze)
  • FME Form Basic Training
    dezuviriamhas earned the badge FME Form Basic Training
Show all badges

Community Stats

31,799
Posts
120,800
Replies
39,417
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.