FME Form

I've got a set of polygons from a PostGis DB and want to write them to DGN. On one level, I've got the polygons and on another level, named label, I want to put out a text string from an attribute. Some of the polygons have more than one entry here, which leads to stacked texts - I've used a centerpoint replacer, labelpointreplacer and dgnstyler. I guess when only having two or three entries, I could solve the problem by subtracting a fixed value from "igds_insertion_y", but I don't know how many entries will be there in advance and already encountered some cases where a polygon had 40 to 50 entries I have to write one below the other.

I have a series of PDF documents that contain a map that came from the ArcGIS Map Series tools (over 2000 in all). I am reading each of the PDF's in and converting to BMP and saving the images to a local drive so I can use the images in a HTML report. Rather than store the images locally, I was wondering if there was a way to convert the images to base64 and save the base64 as an attribute and then just use that attribute in the HTML document? Is this possible? Any suggestions would be very much appreciated.

I have simple workbench, which pulls data from Oracle Spatial and writes the data into Postgres Dynamic Writer. The workbench when ran, throws the following error, "Esri Geodatabase Writer: Feature Type Definition 'd_y_n' was requested, but not defined. Please visit https://www.safe.com/support GEODATABASE_SDE writer: A fatal error has occurred. Check the logfile above for details FeatureReader (QueryFactory): A fatal error has occurred. Check the logfile above for details" The attribute manager is used to match the name of the fme_feature_type_name and the dynamic writer featureclass name , The dynamic writer has the following parameters as shown in the image, I couldn't figure out what mistake am I making here. Could any one please help ? Thanks in advance.

I have a Python script that cleanses a specified document and then creates a logfile in a local directory. I am trying to embed this Python script to run out of FME via the PythonCaller, so instead of creating an independent log file, it will print out as an attribute and I can create additional functionality via FME based on the content. I was able to successfully run the data cleansing side, but I'm getting stuck with the logging side. That is, I was able to print characters inside the FME Validation Log, but I don't want that as I can't use additional transformers on that log content. Can someone provide an example file or structure of how I can add this feature to my existing PythonCaller? I'm currently running FME(R) 2021.1.1.0 (20210730 - Build 21619 - WIN64) and Python 3.8.

Hi there, can anyone please help me how can I filter some record that have a particular word. For example, I would like to filter all the road name starts with 'The ' (e.g. The Meadow but not like 'Theodor road'. If I use contains/begins with in the tester, it gives me all that have string part 'The'. I never used Regex editor. A good response will be highly appreciated. Thanks in advance.

Hi , Recently we have upgraded our FME Desktop version from FME 2021 to FME 2022. Since then to Fetch data from Esri ArcGIS Portal Feature Service (Reader) is very low. Even to fetch around 10k records it takes about 10 mins, However in FME 2021 it was working very well and it takes about only few seconds only to fetch the same size of records. Is this a known issue with FME 2022?

I am reading some data from a database in, using the DGNStyler I set the color type to color index, define the color index; and set the line style with weight and style. Than I am forcing all data through a 2DForcer and finally I am using a DGNV8 writer to write to disk. I guess the problem starts with me not being used to DGN and/or the viewer, but essentially I am not getting the styles I defined. As you can see, the color index is the same in both viewers, but the color shown differ from each other (The left should be a mirror of the right.). Also, the level weight should be 3, and was also as such defined in the DGNStyler. Overrides have I defined within the writer: but the overrides are entirely neglected. Finally, there is the thing with 3D vs 2D. I thought my file is generated as a 3D file because of my data and added the 2DForcer. However, that does not change anything on the output. Maybe that's just me not knowing my ways around in the viewer... However, I have to get the sty

I have a DWG file I'd like to read into FME to extract certain information from. When I add the file in a Reader and choose to read Individual Feature Types, I get >100 different Feature Types, but almost all of these are empty (ie have no features in them when I run everything). Is there a way to easily select and delete these empty Readers, or alternatively to tell FME to only add those which have features in them in the first place? I have tried using the PURGE command in AutoCAD to clear any layers with no features in prior to reading the file in FME, but this doesn't seem to have done anything - I have very little CAD experience so it could definitely be that I've done this incorrectly.

With the help of the following request url in the Httpcaller, it was possible to get a returned xml output with information about one feature. However instead of retrieving information about one feature, ideally I would like to retrieve metadata of all the items from ArcGIS Online. Does anyone might have an idea how that can be achieved? This url gets me metadata of one feature. https://<companyname>.maps.arcgis.com/sharing/rest/content/items/<Item Id>/info/iteminfo.xml

Hai dears i am new to the FME please guide me to explore. here, I have a file geodatabase in that some feature class having physical status and others not, here i need to transfer physical status is null feature and the same other feature class also to be transferred which is not having physical status with in the AOI. which transformer is best please guide me.

To transform a 3d model into a straight line, need matrices and quaternions? Who has a good method, I hope to explain, thank you

I'm trying to add a esri sde geodatabase reader to a workbench without an sde connection file. I have an example workbench I got from someone else, (but who left the company) with a geodatabase reader where I can just fill in the user credentials and server instance, and then it will read the database. So in te example above a new connection file is not needed. However, if I try to add a new reader I can only add one when I provide it with a sde connection file. Can someone tell me how to get parameters like in the picture with an esri sde geodatabase reader?

Hi all, Does anyone know the expected release date of FME Desktop and Server 2022.1? We are planning our next upgrade from 2021.1 and I want to assign the upgrade to a quarter in our Life Cycle Management planning. I don't want to risk that the software is not available. Thanks, Annette

Example. I have 1 linestring going into the object and 1 linestring coming out from the object. Use case 1: I should simply shorten both linestrings so that there will be a buffer around object. So I should shorten linestring 1 from the end and linestring 2 from the start Use case 2: I should cut both linestrings using area and then shorten all 4 a bit next to the area. But how do I know which way the linestrings are and how to shorten specifically from the end or from the start?

We translated a GML file to GDB, Then we get two problem: FeatureColleation layer induced, how to remove it layer name with geometry, how to remove it Thanks

Can I use polyline (.shp file) and convert them to 3d display them with AR(FMEAR) ?

Is there an easy way to remove accents from characters that are contained in an attribute?

Hello all, I am trying to replace a macro in Access that makes a series of SQL queries to update a table used in more processing afterwards. I am pretty new to creating work benches and wanted to get some input as far as how I might construct a workbench to do this and the transformers I would use. I am getting lost in whether I can create a more linear process with transformers in sequential order, or if it will take a different way of thinking to build it that incorporates different pieces at different times. I am more used to ArcGIS Modelbuilder and this is just different enough get me second guessing all ideas. Here are all of the SQL queries the macro executes, in order with a couple of notes I added for clarification: NOTE: I know this part can be done with the truncate option in the writer: DELETE StagingTable.*FROM StagingTable;________ INSERT INTO StagingTable (PIN, MailingTo, FullAddress, CityState, ZipCode)SELECT SourceTable1.PIN, "" AS MailingTo, SourceTable1.StreetAddress

I have created 3d tileset combining many tilesets. I can see the parent geometry error, but for child tilesets geometry error is missing. How can I add geometry error for child tilesets? Please help me if someone have resolved this kind of issue.

I have a WMTS that works fine in QGIS, but which I can not get to work in FME Desktop (2021.2 and 2022.1). I start the WMTS-reader, use the following address: https://tiles1.geoserve.eu/Mosaics/tieserver/20220531_20220416_SV_RD_8bit_RGBMosaic_50cm_Nederland/wmts and than I get this error: .tmp' exists but could not be opened. File contents may be invalid, or the file format may not be supported Worker 1780 > Failed to obtain any schemas from reader 'WMTS' from 1 datasets. This may be due to invalid datasets or format accessibility issues due to licensing, dependencies, or module loading. See logfile for more information Parameter settings are chosen from the layer itself: format: Image/png Tilematrix: Gooflemapscompatible Tile resolution: 18 I did try other resolutions. Again: It works fine in Qgis

Getting an error when running a translation from LAS to LAZ format. Could not load module 'C:\\Program Files\\FME\\plugins/LIDAR_FME.dll' : 'The specified module could not be found' Don't think it affects the output. Just wondering if it needs to be fixed? FME(R) 2022.0.0.1 (20220505 - Build 22339 - WIN64

I have a dataset containing 10ish attributes. Most of the fields are empty (if an item has a value in attr1, it has no value in attr2, attr3, attrN, etc), and I want to have a single attribute containing the value of all the others.

Post upgrade of desktop --- should we replace all the reader and writers or are these upgraded to latest version automatically?

I have two geodatabase. I used "AreaOnAreaOverLayer" to have the intersections of features for the one of the geodatabase and then, for the second geodatabase. It creates for both, a field named “Overlaps”. It works correctly. After that, I wanted to join the two geodatabases The two geodatabase overlap but they haven’t the same name so I can’t use « feature joiner » because I haven’t a common field. With the transformer “clipper” I haven’t all fields (It misses the field “overlaps” of one of the geodatabase) With “AreaOnAreaOverLayer”, “SpatialRelator”, “SpatialFilter” and NeighboorPair” one of the field "overlap" is null That’s why I want a transformer to make a spatial join and not a attribute join with all fields of two geodatabase. Thank you !