FME Form

Good morning. I have a table with two geometry fields in a SQL Server database. The coordinate system for both of them is EPSG:25830. I've followed this article to be able to write both columns at the same time: https://community.safe.com/s/article/writing-to-tables-that-contain-multiple-geometry-c It works great; but, when I check the SRID of both fields with the function STSrid, I get the 0 value for both of them instead of 25830. Before writing, I set the coordiante system with a CoordinateSystemSetter, so I don't know why it's not stored properly. That doesn't happen with tables with just one geometry column. 

Main workspace:LoopingAndBlocking.fmxThis gives me error: > Custom transformer 'LoopingAndBlocking' does not have a port named 'PrivateInput' which is suitable for parameter 'LOOPBACK_INPUT_TAG' Settings:Enable blocked looping: YesMax iterations: 100Attribute to hold iteration count: FME_LOOP_ITERATION_COUNT Using ALWAYS LINKED Publishing the PrivateInput Port does solves the LOOPBACK_INPUT_TAG problem, but then my feature are outputed through the Incomplete port. That suggests they could not be looped at all? Any thoughts appreciated. Attaching fmw + fmx

Hi all, I am trying to find an FME solution to an optimisation problem. I have ‘x’ polygons of varying sizes, the combined area of these polygons adds up to ‘y’. I need to allocate these polygons across ‘z’ number of groups, each of which require a different proportion of ‘y’. For example:·        10 polygons (x) of varying sizes with a combined total area of 62ha (y) that need to be proportionally allocated across three groups (z) ·        Group 1 – needs 60% of y (37.2 ha)·        Group 2 – needs 30% of y (18.6 ha)·        Group 3 – needs 10% of y (6.2 ha) Possible solutions: I am after an optimised solution for the groupings of these polygons (in the above example, the first solution would be considered the closest to the allocation requirement).

I have a script that strips a bunch of feature layers out into a GDB database that is then zipped. I then made a Creator that attached to ftpCaller. I set in the properties 'create at end' to be yes. This seems to work, however i notice it seems to still be doing the upload while other features are writing to the gdb. how can i say that i want to run the creator and the ftpcaller after every other feature has been written to the gdb? thanks

Select RD_ID, RDWY_ID, MLGE_TYP, OVLAP_MLGE_CD, MAX (YR_TXT) as LAST_YR_DVLfrom IMAGE_CTLGGroup By RD_ID, RDWY_ID, MLGE_TYP, OVLAP_MLGE_CDOrder By RD_ID, RDWY_ID,MAX (YR_TXT)

Hello FME'ers,Here is your weekly update on all the news related to FME. New 2021 (2021.2.4)Of course, we're all looking forward to the release of FME 2022, but fixes are still made to 2021. In fact, a new version of FME 2021 was released last week, 2021.2.4. As usual, there are few highlights (because it's not meant to be a spectacular release) but you should consider looking into this if you have experienced problems with either the ArcGIS Portal Reader or Excel writer. The changelog file has more information. Dmitri and Lena's AR SpectacularOtherwise known as the Exploring Outdoor Infrastructure with AR webinar! This took place yesterday a

Hello there we have a set of points getting to the line builder, not in sequence how we could organize them to build them straight line we are getting this from the line builderI think the line builder is connecting the point in the order they enter the linebuilder Any ideathanks  

I am reading a JSON file and converting into File GDB, here using Attribute Manager, but in Attribute Manager list of attributes are not updating accordingly when ever I change the JSON files. In order to update is manually update the reader and feature type, then only it is updating. So. requesting you please suggest a way to auto update this.

We need to move our FlexNet License Server for FME Desktop to a new machine. What is the best way to move the licensing from the old license server to the new? Thank you.

Hello,  I have a shape with points and a shape line. I want to create the shortest path between my points which have the same trip_id with the stop_seque field but the shortestPathFinder doesn't work.I don't understand ? Please do you know what is a problem ?Thank you

Hello, I need your help please my pdf after conversion is too heavy. do you have an idea to compress these pdf please? 

How would I go about copying the name of a column and using it as an attribute?

What is the best way to join 2 ArcSDE layers and then add a whereclause on the joined data?

Working with ArcGIS SDE Enterprise and feature classes. I am looking to create a back up of feature classes every month. The gdb changes every month and feature classes get added. Is there a way to automatically add readers based on those additions?

Hello, I am looking to convert RGBI (four bands) tiff files into JPEG2000 format and maintain the RGBI data. I cannot seem to work out how to maintain the infrared band as the write format seems to allow for that.

Hello there we are building line from multiples point using line builder we get this using line smoothness we get thisas you can see still there is some pics there the line is not very street how could we improve the result to get a straight lineI played with the tolerance but still the same result 

Hello Friends, I'm new to FME. I have two shp (Line) files. one with old data and another one with new attribute field data. in the new file its falling on exactly on the top of old lines, but some places its little shifted approx. less than one meter.  I would like to transfer All attribute data to the old file from new one, and copy new lines where ever old data is not their.Not sure which are the transformers to use for this string. Hope someone can help Regards, Ps. Old data is in black color and new data in orange color

Hello please advice. How do I view these attributes? They are not visible in the workspace. I only see them in the data inspector. Thank you

Is there a work instruction to sort a text file then export as a Excel? I have attached my current workbench and file as ZIP. I need to sort into 0-500, 501-2000, 2001+ sections.

Where can I store my FME AR model? Does the FME AR model need to be in FME Cloud or can it be in any public location?

Hi All,I am just starting with FME and so far it is amazing! I downloaded a CityGML file for the sidewalks of NYC (see attached) and want to export it to Unreal Engine. ( I already did the same with another cityGML file and it worked great) Yet with this particular model (it is 800 mb, so I have to use google drive link here: https://drive.google.com/drive/folders/1Ov3Y_y2IVs_MPiazpZO1o2xNnMWiTEju?usp=sharing ) it exports empty file and the geomerty is not showing up in FME Workbench, while I can see it in FME Inspector. At this point I am pretty desperate and cannot find any solution on how to address this..Please let me know if you know how to resolve it! I really appreciate your time and help!    

Hey - I have to transform a lot of DWG Files into a custom coordiante system. The transformation works, but I have a problem doing so when a file has external references (in this case the reference points to another DWG in the same directory, which therefore has to get transformed as well). Following my first thought, I tried to transform all files but leave the insert points for the references untouched, but this didn't work. Even when discarding the RealDWG reader Option "Read External References" or trying to filter out everything that has the value "autocad_xref" for autocad_entity with a test filter and letting these objects bypass the transformation process in my workbench, I'm getting the same result: The insert points for the references are transformed too and therefore seem to be shifted double the distance in comparison to other objects. Do you have any advices for me how to solve this problem? Thanks a lot! :-)

When trying to use the SQL Azure SQL Database (JDBC) database connection, can that be used with the ActiveDirectoryPassword authentication type? I have a service account in the Azure Active Directory, but that is not the user our FME Server runs with, to be able to use the ActiveDirectoryIntegrated option. I have successfully used FME Desktop with my personal account as well as the service account (using RunAs) with the ActiveDirectoryIntegrated authentication. Any help you can provide would be very much appreciated.

Hello! I need to open a raster and use it as a reference to create a larger one (a few inches bigger on the height of the initial image). This procedure must be done for a set of images of varying sizes and not georeferenced.Later on combining the two files, the original and the other that was created (I thought use the RasterMosaicker), I would have an additional blank area at the bottom of the image where I could add a text box. I'm having trouble with:- creating larger images that have as reference a set of images of varying sizes- adding the text box with message in the fixed position (the bottom border that were added in each resulting image). Does anyone know any transformer or transformer set to solve this problem? Thanks for help!

Now i receive errors, as a workaround i tried to save each web page as html file, how can i bulk read inside info of