Skip to main content
  • EN

FME Form

A space to discuss FME Form

10000 Posts
dor1411993
Contributor
dor1411993Contributor
asked in General
Sde and Postgres database writing problem

Hello everyone.I have a problem with writing an SDE database that sits on top of postgis DB.I manage to connect in the FME to the database both from the postgis / postgres readers and from the sde reader.I can read the data, the problem is that I can not write properly.I want to update the database, and no matter what I do, I do not see the changes in th database.It is divided into two parts:When I write directly to postgis, I have a lot of warnings, but I was told that Total Features Written 1As it should be.But in practice I do not see the changes in the database at all!And when I write down to sde, it gives me lots of Errors, but Total Features Written                            1 as it should be,but still no change in the DB.I tried every possible variation in feature operation, insert, update- and nothing changed.Only when I did an experiment with delete, it managed to delete the features for some reason.Does anyone have an idea how to overcome this and write directly to the datab

1464
J
f.kemminje
Contributor
f.kemminjeContributor
asked in General
calculate Perpendicular distance between road centerline to property polygon

I have a road center line and private properties beside(left and right) to road center line.I want to find out the distance between the road centerline and private properties (perpendicular to the road centerline)both the sides(left and right) for every kilometer. Generate points along the road centerline for each kilometerCalculate perpendicular distance from a point to private property polygons(left and right)Add attribute left1=min distance (left property polygon and right1=min distance to private property right side

15210
ladisrikanta123
Participant
zentnerfabian
Contributor
zentnerfabianContributor
asked in Transformers
How to set colour value automatically for polygons in a ESRI Shapefile?

Hi everybody, I have 6 values which are standing for colour values for making maps. So each number is standing for a colour. The values are always the same and the numbers are 59, 63, 70, 72, 76 and 77. I have a lot of polygone ESRI shapefiles which are showing the administration of each country (OSM Data for example the states of India, which is the first administration level of India). To have the same style in each map for printing, I would like to use the colour values (59, 63, etc.) for every administration of each country. So each shapefile has a attribute field which is called "colour value". Now the tricky part is: the polygons (so the states of India) should have always one of the values, but the direct neighbour state should have always another value. Otherwise the colour of the states are the same of maybe two of them, which are neighbour states, and you can't see directly the difference on the map after colouring. I put some picture in the attachment, where y

2226
zentnerfabian
Contributor
L
leif
asked in Transformers
Resample raster - problem with rotation

Hi, I have lots of large raster datasets that I want to resample and save as PNG. The problem is that their rotation is wrong, and trying to modify the angle according to the image properties gives incorrect result. The images are oblique images.The raster in geotiff format read into FME:Doing no rotation gives this result in the final png: The image after rotating it.  RasterPropertyExtractor gives _rotation_x=222.30258951435636 and _rotation_y=223.52422211966618. None of these values give the desired result with a straight image. Does anyone have any suggestions? Or is there a simpler way of doing this? Reading the image and disregarding the rotation?

1006
L
B
bertd
asked in Transformers
turn a IfcGlobalUniqueId to a normal GUID and back

I have a question; how can we turn a IfcGlobalUniqueId to a normal GUID with FME?And is it possible to turn it back in a IfcGlobalUniqueId with FME, because of the buildup of a IfcGlobalUniqueId. I am hoping someone can help me by either passing a bit of Python-code or maybe Safe can create a Custum Transformer to help with this problem? We want to use a IFC for our asset applications and our 3d city-model.So, we can use the IFC from our engineering-team to fill the other applications with attributes. And when we need to develop new streets, we can give them the information back. Beste Regards,Bert @Takashi Iijima​ @daveatsafe​ 

670
daveatsafe
Safer
fdmutiajr
fdmutiajr
asked in Transformers
I have an ArcMap MXD file with data driven pages to create a map book. I want to use the map document as my reader. What transformer can I use to export the map book in PDF in FME?

I have an ArcMap MXD file with data driven pages to create a map book. I want to use the map document as my reader. What transformer can I use to export the map book in PDF in FME?

920
kailinatsafe
Safer
gogopotter90
Contributor
gogopotter90Contributor
asked in Transformers
How to write text and add values from different attribute in one cell

Hello , i would like to combine different values from different attributes then add them in one cell and write string text +value of specific attribute 1 then add new line and write string text + value of other specific attribute .How could I achieve it ?thanks in advance FME 2021

7391
dustin
Influencer
ladisrikanta123
Participant
ladisrikanta123Participant
asked in General
Water Network Analysis

Hi! I'm desperately trying to find a way to identify the impact of disabling a specific network on the surrounding networks. So far by using the NetworkTopologyCalculator, I've been able to isolate all my water networks, separated by water valves. But here is an example of what I'm trying to do:If I have to replace the water pipe on the network A, I will close the water valves to isolate it. The impact would logically be that there would be no water reaching networks B-C-D-E. Is there any way for me to dynamically identify this in FME?Thanks in advance for your help!

640
ladisrikanta123
Participant
ireen
Contributor
ireenContributor
asked in Transformers
Update metadata of a feature class in an ArcGIS Pro File Geodatabase

We have some automatic data-updates on an ESRI File Geodatabase. I also want to update some parts of the metadata also automatically as part of the update procedure. I want to change Edition, Publication date, Revision date and dataset ID. I succeeded getting the right information to insert in the XML updater, but the XML updater doesn't seem to do anything in the metadata. I don't see any result. Could anybody help me out? I added the workspace to this question.  Addition 9/12/2022:I just discovered that, if I fill out these fields manually in ArcGIS Pro, that this information is not found in the metadata that is read by FME. This is what's filled out and seen in ArcGIS Pro:I used the mehod with the XML Formatter to see what's in the metadata, and this gives the log attached. You'll see the information shown in ArcGIS Pro, can not be found in the XML read by FME.Exporting the metadata out of ArcGIS Pro to XML, contains other (and right) information: <identificat

3468
boydfme
Contributor
joy
Enthusiast
joyEnthusiast
asked in General
how to define pathnames in FME server?

I am fairly new to Fme server and I have mostly only experience with FME desktop. I was running succesfully a script with Fme desktop. However when I published the script to fme server and I run the script, then I get the following error: I have slightly changed the names of the path due to security issues. DESIGN WRITER: Failed to copy the seed file '\\\\NotRealdomainName\\aplroot$\\A-APLDATA\\FMESERVER\\repositories\\Notrealrepositoryname\\Seed.dgn' to the destination data file 'C:\\Klic_Tijdelijk\\_Bomenanalyse.dgn'. Either the path to destination does not exist or the file is in use by other program I think the issue lies that I wouldn't be have to use hard pathnames in FME Server. Does anyone know how I should define the path names in FMe server? 

1850
sanaeatsafe
Safer
R
robeesafe
asked in General
Using PointOnAreaOverlayer, I would like to know how to extract polygon IDs and assign them to corresponding points that are within each polygon.

Using PointOnAreaOverlayer, I would like to know how to extract polygon IDs and assign them to corresponding points that are within each polygon.

112
R
albinepro
Supporter
albineproSupporter
asked in Data
Force UPPER CASE on MSSQL writer

I have comprehensive worskpace to write many tables in PostGIS, where all the target attributes are in lower case. Now I need to migrate this workspace to work also on MS SQL. I was able to change the writer and bulk update feature types table qualifier. The schemas are just similar to Postgres DB, but I'm getting errors because of the lower case of the attributes while writing to MS SQL.Importing new feature types from schemas is not a way because I need to maintain the attribute mappings on every feature type. For example, the table name in lower case is not an issue but column names are. I would need that the writer forces UPPER CASE on writing to DB or bulk change all the attribute names in all writer feature type to UPPER CASE. I´m not feeling to do all the mappings again from the scratch, if the schemas are the same.On the attached picture you can see the attributes from changed writer feature type (PostgreSQL->MSSQL, left) and new imported feature type (right). There is j

230
albinepro
Supporter
tb09114
Supporter
tb09114Supporter
asked in Transformers
How to run the entire workspace as an iteration?

Sorry if the question does not express what I want to achieve, but of the top of my head I did not know how to ask differently.The issue I have is, that features provided by the very left reader are used to identify raster files they intersect with, which afterwards are mosaicked and processed. There are a lot of raster files and a lot of features coming from the reader, and I would like to run this entire process rather feature by feature, instead of feeding all the features into the process.What is the best way to achieve that? 

70
tb09114
Supporter
smfks911
smfks911
asked in Transformers
How to convert string to date format in FME?

Happy New Year all. Can anyone please how can I change a date column (dd/mm/yyyy) from string to date time format within a workbench. The column is originally coming from a CSV file but after reading in FME, its getting converted into string. I want to apply test filter to get values within a certain date period but because the date is in string, I cannot do it. Do you have any idea how to resolve the issue? Thanks in advance.

14364
smfks911
kidega
Contributor
kidegaContributor
asked in Data
Install Rhino Module for Pyhton.

Hi, I wounder how I could manage to install the Rhino module for python (external package)? I have tried to look up info from:https://docs.safe.com/fme/html/FME_Desktop_Documentation/FME_Desktop/Workbench/Installing-Python-Packages.htmand:https://community.safe.com/s/question/0D54Q000080haVOSAY/how-to-install-external-python-packages. What I seem to manage to do is to install the module with the following command:fme.exe python -m pip install rhino --target C:\\Users\\*\\*\\Documents\\FME\\Plugins\\Python\\python37 The module seem to be installed at the directory, but when I try to import it (import Rhino) using python caller I get the error msg:|Python Exception <ModuleNotFoundError>: No module named 'Rhino'.The Rhino module is a non-universal package and I have tried to verify python interpreter to both 3.7+ and 3.9+ when running pyhton caller. I am using FME v2022.1.2.0 64-bit. When I used to command line it prints; "INFORM: Using python interpreter **\\python39.d

2290
kidega
Contributor
f.kemminje
Contributor
f.kemminjeContributor
asked in General
http caller rejects the request

I must use the http caller transformer to obtain the token value from the rest end point.However, I am unable to connect via FME. postman returns valid output. I get a notice that reads "invalid clientid or secret," but when I use the identical parameters, Postman returns the response body. Why is FME unable to make it happen?I made numerous adjustments but in vain. kindly assist

372
david_r
Celebrity
jasperwis
Enthusiast
jasperwisEnthusiast
asked in Transformers
DWG Dimension - Read text height of annotative dimension

Hi,  I am looking for a solution to read the correct text height of a dimension from the Model Space. If the dimension is not-annotative, you can simply use the fme_text_size attribute. When a dimension is set to Annotative, the fme_text_size is rescaled.In AutoCAD:While in FME:--> Scaling factor = 10However, I noticed that most of the time in the autocad_extended_data_list{} , you can select the last "real:" value in the list to find the actual text height.So far so good, but now I have a new input file, where I cannot find a correct real value in this list. I have attached this DWG.--> scaling factor = 5 I have disabled the "Explode Dimensions" in the reader parameters, butI have checked an this has no effect.  For dimensions I can't find some kind of annotative scaling factor to multiply the fme_text_size. Any ideas? Jasper

300
jasperwis
Enthusiast
nedwaterman
Contributor
nedwatermanContributor
asked in Transformers
Extract key value pairs from XML

Morning, I'm trying to extract logger data from an api returning XML. I can use the XMLFlattener to match my message element and return the pt element as an xml fragment. However I need to then expose all the key value pairs in the <pt></pt> element into attributes and if I try to use the AttributeExposer there's a huge list, which will change when i run the api with different data ranges (ie more key value pairs to manually expose).Is there any way I can automatically expose all of the elements within the <pt></pt> xml element one column each of time, value, ch, chtype etc to insert into a db table? Cheers!  

2785
nedwaterman
Contributor
M
matthew.boyter
asked in Transformers
How to group features based upon count and distance?

I have a linear asset, such as a road, that needs work done to it. The work group can only travel 5 miles per day and can only do a maximum of 5 jobs per day. I am trying to group the locations using these constraints. Some groups may be 5 miles with 5 work locations, some may be 5 miles with fewer than 5 work locations, and some may be less than 5 miles with 5 work locations. I have both the linear asset and the work locations as spatial data with all the appropriate attributes (road name, mile points, etc). The linear asset has measure values that correspond to mile points. What is the best way to dynamically group the work location data based upon the above mentioned constraints? 

260
stefanh
Contributor
saravanakumar
Supporter
saravanakumarSupporter
asked in General
how to control the translation of each layers in workbench?

Hi all, I have doubt or I wish to know that, can we control the sequence of translation of each layers one by one (here I used .dwg file) like conditions in normal programming languages .suppose if FAT boundary layer complete, then I want to start manhole next to it.is there any options for that ? Regards,saravanakumar

120
saravanakumar
Supporter
tanushree03
tanushree03
posted in General
Community Discussion

20
tanushree03
R
robshawuk
asked in General
Calculating percentiles using RasterStatisticsCalculator or other tool

I have a very large (~90 gigapixel) single band geotiff file and a vector layer of ~16m polygons. For each polygon I would like to calculate the 10th percentile of the band of the raster within it and output to a table (e.g. csv). I've set up a Clipper which seems to successfully cut the raster for each polygon and I was hoping to use the RasterStatisticsCalculator to get the 10th percentile. However, percentiles do not appear to be an option. Can anyone suggest how this might be possible please?

1120
egge
Contributor
charlesdollat
Contributor
charlesdollatContributor
asked in Transformers
change the coordinate system

Hi, I would like to change the coordinate system in Lambert 93 EPSG: 2154 for shapefiles.  But i can't find the good one in the coordinate system Gallery. (i have a tamplate to compare(PRJ file))  do you know if i can add this .PRJ to reprojector maybe ? because i need to change a lots of files Thanks,  Charles.

2440
egge
Contributor
boubcher
Contributor
boubcherContributor
asked in General
Dynamic Filter

Hello there we have the geo-location of the car and we do have multiple users we need to create a notification based on the geofence value set by each user, The car location is streamed in reel time, we don't know in advance the number of users is there any way we could create a dynamic filter that will notify the users based on their setting to be more specific user 1: notified when the car is within 500 m user 2: notified when the car is within 1km....the only problem we have is we don't know in advance the user and the value of the geofencecould we send those values to the filter as for example JSON ??Thanks

1180
richardatsafe
Safer
A
atmoaura
asked in General
Hello, Is it possible to install FME Server on a linux distribution Rocky 9? For the moment, i found only a version on rocky8. I have a error when i tried to install the version 2022-2.2 on a linux rocky 9.1. Thanks! Yann

Hello, Is it possible to install FME Server on a linux distribution Rocky 9? For the moment, i found only a version on rocky8. I have a error when i tried to install the version 2022-2.2 on a linux rocky 9.1. Thanks! Yann

130
siennaatsafe
Safer

Badge Winners

  • Online Training
    tessmhas earned the badge Online Training
  • Teacher (Grey)
    alyssauatsafehas earned the badge Teacher (Grey)
  • Welcome Back
    ladeefhas earned the badge Welcome Back
  • Welcome Back
    ldrhas earned the badge Welcome Back
  • English Speaker
    cfc250has earned the badge English Speaker
Show all badges

Community Stats

31,846
Posts
120,958
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.