FME Form

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.

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.?

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

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

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.

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?

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

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

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?

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   

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)

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)

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?

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.

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. 

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> 

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.

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

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

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.

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/

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 :

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: 

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!

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!