FME Form

Hi all!I would like to write my data to a format called .geo which is used in Sweden but is not supported by FME.I attach some sample how the format looks like:FileHeader "SBG Object Text v2.01","Coordinate Document","UTF-8"begin   FileInfo "Application","Geo Professional"    FileInfo "SerialNo","123456789"   FileInfo "Author","Abcdefghijklmnopqrstuvwxyz"   FileInfo "Company","Abcdefghijklmnopqrstuvwxyz"   FileInfo "Description",    FileInfo "Coordinate System","Sweref 99 18 00 / RH2000"endPointListbegin   Point "123456",6580210.000,155715.000,,,,"rör i mark med däcksel"   Point .....   Point....endLineListAttributeList I have a list with points and want to fill in the list in the "pointlist" section.Would this be possible with FME right now?Any ideas or help is appreciated. 

Hi, guys, i'm new here. When i make a hatch in Autodesk CAD, and then translate it into GDB via FME, then i use FME exporting to .dwg file, when i zoom in to a very large scale, the new geometry's boundary line doesn't fit the original one, the area of the hatch also changed a little, but the line or arc don't change when i do the same. Can anybody tell me how to make it right? THANKS!!

I am using InlineQuerier to lookup a value and add it as an attribute to my base table (Cities). For audit purposes I want to lookup multiple values and add multiple attributes before performing calculations. Currently I am using a separate InlineQuerier for each additional attribute. Can it be done in one? or using other tools? As an example say the base table is Cities, and I want to look up several different price indexes in a CityIndex table based on specific dates, and add these to the base table. See pictures. To add one attribute I can use an InlineQuerier function:Select Cities.*, CityIndex.IndexValue as Index_at_20210630from Cities Join CityIndex on CityIndex.City = Cities.Name where IndexDate = "20210630" But how can I add multiple attributes - see desired state screenshot attached? Many thanksPhilip (6 month FME user)    

How to connect fme server to the network drive?

Hi everyone,I am trying to split a large table into multiple files and was playing around with the dataset fanout feature. My table has multiple header rows that contain explanations of each attribute that I wish to keep in each file created by the fanout but I cant seem to make it work.  An alternative that I can also see working is to add a static Sheet to each fanout-file which then contains these explanations. I wasnt able to make that work either though. Any help would be much appreciated.

Hi, we have some PoylgonZ geometries with multipe polygons per building. For each polygon we have different heights. Now we are creating building models in citygml with citygml_lod_name = lod1Solid. This is working already with this workflow:But now we have for each solid one building element. Then I thought on the transformer aggregate to aggregate the solids for each building (by gmlid).But then I have MultiSolids which I can´t write to CityGML (lod1Solid). How can I create only one Solid for each building?Or do I have to use lod1MultiSurface?

Hi, I am using the Email(Send) action within an Automation but am unable to get it to work. I am using: smtp.office365.com on port 587 and StartTLS encryption.The office365 email account has MFA enabled and so I am using an App password.I am able to use the same configuration within the FME Desktop Emailer transformer just fine - but the same parameters do not work within the FME Cloud automation.Error message is:"com.microsoft.aad.msal4j.MsalInteractionRequiredException: AADSTS50126: Error validating credentials due to invalid username or password"My FME Cloud instance is running "FME Server 2022.2.1 Build 22776 - linux-x64"I have also supplied an App Client ID by registering an App within am Azure AD as described in this article but it does not resolve this issue:https://community.safe.com/s/article/How-to-use-Microsoft-Modern-Authentication-with-FME#ForServerAny Ideas?Thanks

I have to assign line IDs to bus stops (point on the line). All lines are splitted at junctions. Desired result: S1 IDs: 001, 002 (but not 025)S2 IDs: 003M1: 015, 016 (but not 031)M2: 017 Any thoughts?

Task: Transpose speed sections along a section of road that is provided as 5m point layer, this is to be done for multiple roads with multiple speed sections. Road Layer : 5m Points with ChainagesSpeed Zone Layer : Sections of road with Chainage From and Chainage To When you have one road this task can be executed using TestFilter and manually entering the speed sections using Chainage From in creating the speed attribute. Question:Is there a transformer or a way that I can import the parameters from the Speed Zone Layer, without having to enter the filters manually? As I will need to do this task for multiple roads with multiple sections. Entering different testfilters manually is very time consuming and inefficient and tedious, hoping I can import in bulk?  Appreciate all the advice :) 

While running the FME script I am encountering the following error message :No SCHEMA dataset name was specified (couldn't find a value for `SCHEMA_2_DATASET' or `SCHEMA_DATASET') We have upgraded to new FME version 2021.2 from old fme version (2016). The script is running fine on the old fme version but having some issues in the new FME version.The script has multiple shape file parameters  The data set in the FME script code are in the following format :#! <DATASET#! NAME="SCHEMA_1"#! OVERRIDE="-SCHEMA_1_DATASET"#! DATASET="abc.shp"#! />#! <DATASET#! NAME="SHAPE_1"#! OVERRIDE="-SHAPE_1_DATASET"#! DATASET="def.shp"#! />#! <DATASET#! NAME="SCHEMA_2"#! OVERRIDE="-SCHEMA_2_DATASET"#! DATASET="ghi.shp"#! />#! <DATASET#! NAME="SHAPE_2"#! OVERRIDE="-SHAPE_2_DATASET"#! DATASET="jkl.shp"#! />#! <DATASET#! NAME="SCHEMA_3"#! OVE

I am trying to setup oAuth. When I test the Web Service, I get this:The endpoint does not support the provided HTTP method I have setup oAuth 2.0 in postman with success. One difference I see is that postman sends a POST for Authorization while FME sends a GET. Any workarounds for this?

Hi All, Hope you are well, I'm trying to upgrade an FME workbench made in FME 2020.2 to FME 2022.2 but keeps giving me a Python error while running,  I assume is something to do with Python 2 (FME 2020) and Python 3(2022) but can't figure out the workaround to update the workbench Would you be able please provide me with the steps to upgrade the workbench without re-creating it in 2022? Thanks in advance 🙂

Hey there. Im trying to use the good'ol Creator->HTTPCaller->JSon'er method for the data here:https://www.fega.gob.es/atom/es.fega.sigpac.xml Where I am basically sending requests to fetch certain part of the data and then do some analysing on it before exporting to a format. But there is a problem here which is that the service requests you to accept to terms and conditions before you can start fetching.  Doing this through browser ain't a problem as you just click on the "LEER Y ACEPTAR LAS CONDICIONES" button and read through the document that pops-up and then press "ACEPTAR LLAS CONCIONES" which brings you to the data. It is using the HTTPCaller where i have the problem, cause just fetching the data (through the same URL) gives me the _response_body:<html><body>No has aceptado las condiciones y no puedes ver los ficheros</body></html> or basically "You have not accepted the conditions" Does anyone have suggestions how to include accepting the terms and

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

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)