FME Form

Hi Community,Based on the Figure 1 table, two fields exist as mentioned and I want to find the results as mentioned in Figure 2I tried so many transformers and had no luck.Figure 1Figure 2Please help me with how to get the results.

I created trees in citygml based on point data. The tutorial is described here:https://hub.safe.com/publishers/con-terra/templates/citygml-create-solitaryvegetationobject-with-implicit-representationWorkflow:Result: No I will set a color for this trees. Unfortunately it is not working with appearance setter. No appearance is set inside citygml file. In the description it is written: "tree models: can be any kind of 3D object (Sketchup, OBJ, DWG, ...) but currently does not work with geometry containing color appearances" So does anyone know if this is possible maybe? We need to color this trees Hope someone has ideas how to solve this kind of problem?

Hi friends, I would like to filter roads (Name) that passes through more than 2 suburbs (Suburb). I do not see a straight solution in Tester. Can anyone please give me a clue to about this issue? best regards,FS

This process used to work fine but I realised lately since updating the database connection due to SQL server moving I see it does not update the table like it used to. It stops working at the GeometryExtractor but no errors.  I do getEND - ProcessID: 888, peak process memory usage: 226836 kB, current process memory usage: 93912 kB Can that cause the issue and what would be a way around this issue? Regards, Josh

I m trying to get the data from KMZ and push it to the ArcGIS portal everything is fine but getting errors in the writer<class 'FMEobjects.FMEAggregate'> cannot be converted to esriGeometryPolygonanyone knows where I'm wrong

So I noticed that when using a parameterized INSERT statement in SQL Executor:INSERT INTO MYTABLE(FIELD1, FIELD2)VALUES ('@Value(FMEATTR1)','@Value(FMEATTR2)',)Any NULL becomes an empty string. How do I use logic like the above and still keep my NULLs? I've tried to wrap the entries in VALUES in case statements to catch NULLs and handle them differently - but to no avail. 

We want to convert a GDB to SHP file with field type string and length>254. How can we keep the data with maximum size 254, but not ignore the dataThanks

I have data in S57 format coming from the UK Hydrographic Office (UKHO) which I need to read into FME.When I try to read them in I get the following error message: DE4OS09G.000 isn't an S-57 data file, or catalog.Failed to obtain any schemas from reader 'S57' from 1 datasets. This may be due to invalid datasets or format accessibility issues due to licensing, dependencies, or module loading. I tried to read them with FME 2022.0.0.2 (20220518 - Build 22343 - WIN64), and as I point out in the question, the access to the files is restricted. There is at least an UPN (User Permit Number) needed to read the data. I do have one, but no possibility in FME to make use of it.

We have a FME server installation which has been active for a couple of years now without issues. Today I got a message from our sysadmin that the machine where FME server is installed is running out of disk space.It turns out that in the Postgress database that is installed with FME server large files were created. I can't find any logging that would explain how and why these files were created. Everything appears to be running smoothly. Does anyone know a possible cause for this and how to remove these files in a responsible manner? Edit: So, I have been able to connect to the Postgress database using PgAdmin4, installed with fmeserver. It appears that since some time every second a couple of error messages are written in the table fme_sysevent_history. That table is now 11 Gb. So that mystery is solved 🙂 (apparently it has something to do with https://community.safe.com/s/article/FME-Server-Engine-ERROR-Missing-or-expired-workspace-chaining-context ) So I'd like to t

BADNEWS: Cannot convert null string into an integer(C:\\code\\fme\\foundation\\framework\\util\\stf\\stfutil.cpp:346) class StatusInfo *__cdecl STF_stringToUInt(const class ObsoleteString &,unsigned int &)... Last 2 lines repeated 6 times ...​this error often display,when read excel 、shp 、 dwg file​

Hi all, I will create trees[citygml] based on point geometry. On the internet I found this tutorial: https://hub.safe.com/publishers/con-terra/templates/citygml-create-solitaryvegetationobject-with-implicit-representation Unfortunately *SKP format is not supported for my fme version. So I have tried it with obj models. But this doesnt work for me! I got this rejection code: INVALID_SHARED_ITEM(SharedItemIDSetter). How can I solve this problem? Workflow:

I am trying to create a new attribute for each element in a list. The tables below show the desired outcome. Here is an explanation.For every item in the MASTER list I am loading its corresponding detail list and saving it as a parameter. I want to take the corresponding list and transform it to the example below. I could accomplish this with a database view or query, but would like to be able to do it in FME. I can assume that all ITEM_NAME values are known, which means all the possible attributes that I need to add could be added ahead of time if needed. Note that for every record in the master list, it won't have all of the possible ITEM_NAME values. My process right now is very brute force, and I am thinking there may be a transformer I haven't found that does this or a variation of this easily.  MASTER ListIDNAME1Bill2Sally DETAIL ListMASTER_IDDETAIL_IDITEM_NAMETYPECOLOR1AShirtLongRed1BPantsJeansBlue2CShirtShortGreen2DPantsDressPurple2EHatBaseballRedTransformed Mas

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/supportGEODATABASE_SDE writer: A fatal error has occurred. Check the logfile above for detailsFeatureReader (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?