Skip to main content
  • EN

FME Form

A space to discuss FME Form

10000 Posts
E
erul1998
asked in General
Hi FME, we would like know more details on minimum requirement for fme server and fme desktop. I already read the tech spec but it is too general for the information. Appreciate if you could share morea about this. Thank you

Hi FME, we would like know more details on minimum requirement for fme server and fme desktop. I already read the tech spec but it is too general for the information. Appreciate if you could share morea about this. Thank you

120
E
magi
magi
asked in Transformers
How to obtain Fixed decimal values ?

Hi  i have values as example as below and would like to round upto 3 decimal evenly. 1968.741344 5977.675803 1968.93 5983.1  Am using above transformer to round up but it returns 1968.7415977.6761968.935983.1 AND i want  1968.741344 >>>>>>>> 1968.741 5977.675803 >>>>>5977.676 1968.93 >>>>>>> 1968.930 5983.1 >>>>>>. 5983.100

1310
magi
K
kael112
asked in Transformers
Merge two lists with multiline string

Hi all,i would like to concatenate values from 2 lists (maybe 3 later) from 2 fields. The values are in multiline. I can get values with attributesplitter and a listconcatenator but after that, i don't find the solution! After the 2 listconcatenator, I tried the featureMerger but It don't gives me the two new values -concatened and _concateneddate.If someone could help me, it would be very nice!Thank you!

433
K
magi
magi
asked in Transformers
HOW to insert EXCEL data in EXCEL TEMPALTE keeping or having 1st two rows same in output.

FME workbech READER (raw excel file) TRANSFORMER WRITER ( Desired or Expected RESULTS) SETTING1st row is merged 2nd row id columns names I want the data to be inserted / updated from ROW 3 keeping the first 2 rows same.  Note : Everytime i run FME the number of ROW records will change so results should dynamicaly upated and NO APPEND . WRITER SETTINGS TEMPALTE :

170
magi
juanmahere
Supporter
juanmahereSupporter
asked in Transformers
HTTPCaller does not work with a simple GET url

Hi,Could I have some explanation why HTTPCaller does not bring any data from a simple GET from this website: https://www.puntopack.es/buscar-el-punto-pack-mas-cercano/?codePays=ES&codePostal=32005 Not sure if there are any parameters that I'd need to add.The REJECTED ERROR value: "HTTP/2 503"_fme_rejection_code: "NO_RESULT" Uploaded a screenshot of the HttpCaller.Many thanks in advance!J. 

2147
juanmahere
Supporter
marcoroose
Contributor
marcorooseContributor
asked in General
trace a route

 I have a question.I have the network below, but I only have the data.i want to know which section to go through to go from endpoint to endpoint. in this example I want to get 3 answers.which sections to go through to get from:1) from 1 to 52) from 1 to 83) from 5 to 8 how can i solve this?the solution should be:1) sections 21,22,25,272) sections 21,22,25,26,23,243) sections 27,26,23,24 

830
geomancer
Evangelist
checcosisani
Contributor
checcosisaniContributor
asked in Transformers
Hi I noticed that the epsg code 7791 is missing in FME 2021.1.2.0. How can read the EPSG database to add it? https://epsg.org/home.html thx Francesco

Hi I noticed that the epsg code 7791 is missing in FME 2021.1.2.0. How can read the EPSG database to add it? https://epsg.org/home.html thx Francesco

450
j.botterill
Influencer
E
elpinguino
asked in Data
Writing shp file data to an existing feature service in ArcGIS Online - error code '1000' - Data is null.

This is the error I'm getting- ArcGIS Online Feature Service Writer: 'addResults' error for a feature in 'Tracklogs'. The error code from the server was '1000' and the message was: 'Data is Null. This method or property cannot be called on Null values.'.  The data has run successfully through the workspace until I try to write into the existing feature service in ArcGIS Online. As a side note, I made sure to Import Feature Types... The table looks populated to me. There aren't any empty rows, however there are some empty fields. I didn't think this would make the workspace abort though. In the visual preview, I can see the geometry has populated too.  Thank you in advance for your help.

1780
rahulsharma
Safer
geogaard
Contributor
geogaardContributor
asked in General
FME 2022 Build 22337 - WIN64 - TimeWindower does not accept Attribute name with a space

I've been using the TimeWindower for the first time and could not get it to work like expected. Fiddling around I tried changing the name of the attribute to remove the orignal <space> in the name. And rest assured it now worked just as expected.

80
geogaard
Contributor
alexortziply
Contributor
alexortziplyContributor
asked in Transformers
Could you offer help with CTGENIE?

I'm running a transformer created specifically for some middleware (CTGENIE) that was created for Frontier Communications. It is crashing during translation; the translation log reports that the job succeeded, but there was nothing that was written to the database. It also crashes FME when the transformer is present in the workspace and I try to save it. I have attached the log, but it doesn't seem to offer any clarity on how to get this to work. Best, Alex

10
alexortziply
Contributor
nath
Contributor
nathContributor
asked in General
Connections completely mixed up after open en closing bookmarks

Hi, I have a annoying problem. I have made a very large FME model with lots of bookmarks and connections. If i want to run the model with caching i get the message that i can't because its too large, that i can understand and if i close a few of my bookmarks it works. But the unpleasant consequence is that some bookmarks and transformers outside a bookmark are moved and now there is a jumble of connecting lines. Closing of opening the bookmarks again doesn't help. It's not that simple to move everything again to the right place. Am i the only one with this problem and is there a quick solution? Closing without saving is one but i have made al lot changes. The image added is just a little piece... Thx!Nathalie 

5410
jovitaatsafe
Safer
mark2atsafe
Safer
mark2atsafeSafer
asked in General
FME Scavenger Hunt Megathread

Hi FMEers,I hope you've signed up for the FME Scavenger Hunt, or are putting together a team to take part. It should be a great event. This post is just to set up a place to ask questions, add comments, or for teams to organize themselves. If you comment here, I should be notified.  I may also post a short daily update here too. Cheers Mark

90
danilo_fme
Evangelist
alc33
Contributor
alc33Contributor
asked in General
parameter "Choice (multiple)" with attributes that appears

Hi !I observe a very strange behaviour of a personnal parameter.I create a parameter with Type = Choice (Multiple). I define the others blanks, everything is ok, but when I click on "Default value : " news values (that are attributes) are added by FME.I don't understand why. It's normal? How can I ovoid that? Thanks !

800
alc33
Contributor
M
miikamakela
asked in Transformers
Dissolve adjacent polygons based on sum of an attribute

Hi all, I have a situation where I want to dissolve adjacent tile polygons based on a count value. For the example below I would expect the total sum to be no more than 100. Less is fine. The less polygons I end up with the better, but optimization (doing several passes) to figure out the best possible result is not that important. It's sufficient to start from one corner and simply add until all polygons have been dissolved. Also there could be a situation where the polygon has a larger count (110 for example) than expected. In such a case it would be left single - as it is.So any ideas on the simplest approach in doing this? I expect some kind of loop function in needed. Not very familiar yet with those...Thanks for any advice!Attached is an example shape file to play with...

11815
M
J
jmterrettaz
asked in Data
PostGIS writer looses Z dimension when writing 3D points

HiI am migrating data from an Oracle Spatial database to PostGIS with FME.One table has a 3D geometry column. The features are read correctly as 3D from Oracle, in the visual preview graphics view the are shown under "3D". In the PostGIS table the features are only 2D, if I query the geometry column as text it contains only POINT(2532341.58213 1155047.32385) geometries.Is there a was to force the writer to write 3D points?Thanks,Jean-Marc 

540
J
lifalin2016
Supporter
lifalin2016Supporter
asked in Transformers
Updating a SQL Server geometry directly - howto?

Hi all.I'm tasked with updating a table that contains 10+ geometry fields. I'm opening it as a non-geometric table, extracting one (of two) geometries, and reprojecting this to a variable projection, based on other field data and/or coordinate values.This all works well, but when I try to update the targeted geometry field in the database table, all hell breaks loose in FME.I've tried to use the formats "Microsoft SQL Server Binary", "OGC Well Known Binary", and even "OGC Well Known Text".I usually get an error message about mixing image and geometry field types, but now it just times out all the update commands.I've tried using a writer with "update", and the DatabaseUpdater, but both errs, so I've ended up with a SqlExecutor (with an UPDATE command), which unfortunately times out.What is the proper way to accomplish this task ?

2914
lifalin2016
Supporter
dhaulagiri
Contributor
dhaulagiriContributor
asked in General
Copy PDF files with CopyWriter

Hello,I need to copy files in PDF format from an office location to a web server, so that they are accessible in a mapping application.Each file corresponds to a point feature in a database table. Each entity has a serial number that corresponds to the name of the PDF file.I have built with FME the path and the name of each PDF file but I don't know how to go about copying it. I plugged a CopyWriter into the output of my processing but I can't seem to use it with an attribute-based destination. Can you help me, please? Thanks

660
nielsgerrits
VIP
lifalin2016
Supporter
lifalin2016Supporter
asked in Transformers
Understanding how to handle multiple geometries in a single table ?

Hi.When reading multiple geometries from a single table, they're joined together in a single aggregate geometry collection.The individual geometries can be extracted by using a Deaggregator, with each separate geometry having its original field name as its "name". Writing multiple geometries back to the table requires the geometries to be aggregated, and a MultipleGeometrySetter set to Yes.If updating such multiple geometries, I assume that FME extracts each geometry from the aggregate, and updates the (geometry) field values designated by the individual "geometry name" as field name ?So, if I have a table with 3 geometry fields (A, B, and C), and want to use geometry A to update field C with a new geometry, should I create an aggregate with all 3 (original A and B + new C), or can I just include the new C value in the aggregate when updating ?Cheers.

1622
lifalin2016
Supporter
lifalin2016
Supporter
lifalin2016Supporter
asked in Transformers
Comments in END_SQL statements ?

Hi,I just added an end-sql statement to some workspaces, each with a comment on the preceding line. The comment is a T-SQL line comment on a separate line, i.e. with prepended "--" (two dashes).This fails, as it seems FME gobbles up the first dash before execution, rendering the complete statement invalid.If this WAD og a bug ?Is it possible to add comments as "/* ... */" instead, or would "--- ..." (i.e. 3+ dashes) work ? It also doesn't look like line-feeds in the statement are respected, so maybe line comments are a complete no-go ?CheersLars

884
lifalin2016
Supporter
J
ji_zhang
asked in General
How to use batch deploy to translate CityGML attributes to individual JSON files?

I have several CityGML files put in the same directory, each having several features: such as address, building, buildingPart, cityModel, groundSurface, roofSurface, wallSurface, etc.   I can convert them into OBJ files using Batch Deploy, which creates a new folder for each CityGML file and in which separate OBJ files are created for some of the features containing 3D geometry information, such as roofSurface and wallSurface, respectively, as shown below.   However, when I replicate the same approach to write out the other features that don't contain 3D information, such as address, building, and cityModel, I don't get individual JSON files for these features put in the same folder with other OBJ files from the same parent CityGML file. Instead a single text file is created for each CityGML file, and I have to manually add the .json suffix for each of them.  Another issue is that a JSON file name needs to be provided when converting CityGML attributes/features to JSON file, in

120
J
G
gispert
asked in Data
How to Write Metadata To MapInfo Tab File

Hi,  I have a shp file I convert and style to a Mapinfo Tab file. I now want to add the below metadata into the Tab file to set up a hotlink. I am not sure how I use these attributes, mapinfo_metadata{}.name and mapinfo_metadata{}.value to write to the Tab file, How do I do it?  begin_metadata"\\ActiveObject" = """\\ActiveObject\\Expr" = """https://aims3d.geomatic.com.au/#/home?username=username&password=Password&PanoID=""+Pan_ID+"" """"\\ActiveObject\\Mode" = "HOTLINK_MODE_BOTH""\\ActiveObject\\Relative" = "FALSE""\\ActiveObject\\Enabled" = "TRUE""\\ActiveObject\\Alias" = """Click to view Km_Post Images"""end_metadata  RegardsAndrew

1104
G
L
lemfor
asked in General
I have 2 excel sheets. One with much data and the other with the xy coordinated of the data, both with a common key the measuring points. I am a beginner in FME and his been struggling with this for days

How can i join and have only the attribute having xy coordinates in the output file?

50
j.botterill
Influencer
A
anguswarfield
asked in Transformers
Save outputs with identical name and folder structure but in a new directory

Hi FME wizards, I am trying to do a datum transformation on multiple files in a nested folder structure and save the outputs using an identical name and folder structure, but in a new directory location. I've created a replica of the folder structure using DOS commands and trying to replace the existing root folder with a new one.  I'm reading the source files in from a CSV, then creating a new 'outpath' attribute in AttributeManager using the StringReplacer to replace the source root level directory, e.g. the part in bold C:\\Project\\CurrentDatum\\Model\\file.ext with C:\\Project\\NewDatum\\Model\\file.ext. The source and destination directory are Published User Parameters and I use the following in the text editor: @ReplaceString(@Value(_dirpath),$(Source_dir),$(Destination_dir)). When I view this as a new attribute, the directory appears correct. I've used similar logic in Python and it works great but not sure how to link it to my outputs in FME. This is my cur

1990
A
O
osdev
asked in General
Automatically Set Writer Location/File Name

I built a simple workflow that converts a DWG to KML. I'd like to write the KML file back to the same location I read it from. For example, dwg from path C:\\Users\\admin\\Downloads\\test.dwg, writes to C:\\Users\\admin\\Downloads\\test.kml It's simple to manually select the Reader file and Writer location dynamically using User Parameters, but I want to only have to select the Reader file and automatically set the Writer location/file name. Doing it this way would save a step if possible.

176
chrisatsafe
Contributor
G
geoabacus
asked in Transformers
Writing dynamically several feature types (each one from a shapefile reader) into one unique Geojson file with as many layers as feature types, and where the name of each layer is given by the value of an attribute (called 'layername')

I am trying to do what is described in the question with a dynamic Geojson writer set as shown in "screenshot_1,jpg". However I get an error (screenshot_2.jpg).  

350
G

Badge Winners

  • Conversationalist
    engstromhas earned the badge Conversationalist
  • FME Form Basic Training
    matthias1116has earned the badge FME Form Basic Training
  • Online Training
    capocci_nrshas earned the badge Online Training
  • Online Training
    ssghas earned the badge Online Training
  • Online Training
    matthias1116has earned the badge Online Training
Show all badges

Community Stats

31,842
Posts
120,952
Replies
39,474
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.