FME Form

I have lines , I have used coordinator extractor with index 0 , coordinate extractor with index 1 so I got start point and end point for each line .but I have still few lines ,although I see them in inspector as lines but the coordinates that I extracted for each line of them by coordinate extractor transformer ,has same coordinate for start and the same coordinate for end of line as attributes what is the reason of that ?how could I get coordinate of start Point and end point for theses few lines but it should has different geometry in start rather than end FME 2021Thanks for help

Hi, I have a question, I would like to ask if it is possible to insert a column that contains the character encoding of the previous column.Do you think it is possible to do this?

Hi,  I've automated daily uploads of certain files to the Autodesks BIM360 platform - through the use of AutodeskBIM360DocsConnector. Everything went fine the first 6 months, but as the files grew larger in size I've had issues with files bordering 500+ MB. Around 500-600 MB FME starts delivering an UPLOAD_ERROR. Is this a known issue, and does anyone have any insight regarding potential solutions or work-arounds? Attribute(string: UTF-8): `fme_rejection_code' has value `UPLOAD_ERROR'Attribute(string: UTF-8): `fme_rejection_message' has value `'

Hi, I have a parcel data with various years in the postgis database and I need to executed topology year wise to find out the topology errors across the years. I have query to filter out the data in year wise and the query is (column1 < Year and column2 >= Year). My first question is how to retrieve the various years in DB for that particular area and my second question is how to pass the years to fetch the data pertain to that particular year and pass it on to the dissolver transformer, kindly let me know.     

I have two sets of points, A and B. I would like to create lines between them, only if the distance of this line is < 500 meter.  Currently I achieve this using a 1-on-1 join in the FeatureMerger. For each point in A there is a list element with the coordinates stored for point B. So if I have 300 points of A and 200 of B, I would have a list with 300 features, with each feature having 200 elements. I then explode the list, and then for each point of B, create the feature, and then check if the distance is <500 meter. This is unfortunately very bad performance-wise, since there are a lot of unneeded connections (> 500m) being made. When running the workspace with big sets of points in A and B this can really effect efficiency. Is there a way in which I can check the distance between two points before I create the feature?

Dear Altruist, I have a consistent series of excel files but saved under different folder in respect to model_run no. Now I would like to add a column in each of the excel files as per the folder name that file is situated in. I have used 'Directory and File Path' transformer to expose all those excel file and used stringsearcher to create a column that extracted the folder name from the path. Can anyone please tell me how can I add the folder name as an attribute to the individual excel file?regards/  

Hi all, I've been tasked with trying to connect to a Sharepoint list and have the appropriate security (read-only) applied to the sites and file/lists. When I try to read in the Sharepoint URL with FME, I am presented with errors, be it for Web Auth, Basic, NTLM or Kerberos. I've attached screenshots of the errors. Any help is appreciated. I do also have another URL which is formatted as "https://<site>.sharepoint.com/sites/<subsite>/_api/web/lists" which I have tried as well, but to no avail

Dear Sir / Madam, Actually I am trying to match two excel table values (attributes name from two different samples). In the excel, I have one matching table and two models attributes in two tab sheet. I would like to compare the value with Model 1 and Model 2 based on the matching table. For example, apple matching apple. However, some of the naming are not exactly matched with wording and are slightly different, such as Pineapple in sample 1 is equal to USA_Pineapple in sample 2. Is it possible to do that? Also, if possible, could it be not case sensitive? Then, I would like to perform a value check on two samples based on the matching table I provided. The result that I want to get is on the "Output Sample" tab in orange colour. I have attached my sample data here. I hope you understand what I said and I hope it is possible to do that. Thank you all and have a good day!

Hi,  I'm trying to run an FME process from the command line like I have many times before (fme example.fmw) However, it is opening the wrong version for the workspace. The workspace is in 2022 but the command line is opening 2018 (which is also installed on my computer). Is there a flag or something I could add to my code to ensure it opens 2022? My workspace has newer transformers than 2018 so it crashes everytime I open it I have tried adding it to the system path variable, but this doesn't do anything, unless I'm doing it wrong Thanks

Hey there,I'm struggling with the RasterCellValueCalculator. As I have raster files which are not congruent to each other and not of the same resolution (but overlapping), the transformer doesn't calculate properly. It's just a simple substraction.I already tried to bring the rasters to the same resolution.Can anybody help?I added a sample workspace. Cheers,Maria

Hi, I have some points and they have an attrobute called code. I want to create a polygon around the points with the same code ( similar to Voronoi).  Can some one help on how to do that. Thanks and Regards, Krishna

I have a sql server table that I do not own but have full permission on.I can setup a GEODATABASE_SDE Reader and read it no problem the table qualifier is "abc\\username" When I try to setup a writer for it the Table Qualifier gets set to _abc_username_ When I try to write to it I get an error message statingGeodatabase Writer: Feature Class or Table '_abc_username_.table_nm' must exist when Table Handling is set to 'Use Existing' Unfortunately using FME2018.

Seems like exposing elements in AttributeSplitter doesn't work in FME 2020.0.1 (build 20218). Even exposing attributes after splitter with AttributeExposer is broken.Or maybe it's Data Inspector's fault for not displaying them. Any thoughts on this?

As a rookie of FME, i have an attribute call JEAN i want to create in the attribute , two choices of values in a string to use it in QGis Attribute : JEAN string : Yes or No How can i do please ? Thanks

Hi. Could someone advise how to write the attributes to the postgres DB, but at the same time write the coordinates in the geometric data type? I have postgis extension in postgres DB. I don't see any such data type in the user attribute tab on the postgres writer. Thank you

Greetings,I have selected the Esri ArcGIS Python 3.7 option, in Translation.I am getting a Python symbol error??Any ideas how to resolve this issue?? The error msg is:PythonFactory failed to load python symbol `FeatureProcessor'Factory proxy not initializedPythonCaller_2 (PythonFactory): PythonFactory failed to process featurePythonCaller_2 (PythonFactory): A fatal error has occurred. Regards,Clive   

I have a table (BKR2) with x and y coordinates, but no address.There is another table (GBA_address) with x and y coordinates with address.i would like to search with x and y coordinates from table BKR2 for nearest x and y coordinates in table GBA_address.Is that possible and how? 

Hi I need to sort in ascending order and only keep the first 4 rows of the result. So I used a sorter but I can not find how to limit the number of rows in output. Thank you

In the Manage Automations page I can select and automation and then select Actions, but the Trigger Automation item is greyed out. Do I have to trigger each schedule in the automation manually?

I have a writer that creates a CSV file to a folder on my computer. How do I write this CSV file to AGOL (ArcGIS Online account)? I already understand how to write data to an AGOL Feature Service. I need to create a CSV file to my AGOL account. I plan to update this CSV file every night (via the Task Scheduler) and share it with others. I'm using FME Desktop (not FME Server). Thanks.

Hi, I have a contour dataset which has been clipped incorrectly and has produced errors in the resulting polylines. There are numerous breaks in it, for example, the 0.8m contour line (see attached image) and I would like to join these together. A straight line is fine. I have tried Snapper and LineCombiner with no success. Any suggestions would be great!Thanks.

I have workspace that currently has one choice dropdown input parameter that lists regional utility companies. The parameter dictates where the input data is read from and where the output data is written. On FME Server, I have setup separate Users for each region. The client has requested that I limit access of each regional User to it's own region. So, say we have Region1 and Region2. Region1 shouldn't be able to run the workspace by selecting Region2, and vice versa. My thought is, if the FME Server User accessing the workspace is available at run time, I could essentially do away with the drop down, and let that dictate which data is processed. Is this possible? If not, what would be my best course of action to accomplish that separation. My second thought was create separate repositories for each region, but then I would need to make copies of the workspace only allowing a single choice in the dropdown. This doesn't seem very efficient, and would pose an issue when upd

Hi!I have a problem with a Json Templater and an Aggregator. I would like to have this result :In my data, I have two items (Json_fragmenter_19) and I need to aggregate them to match with the result I want.I do this :I tried different code in the JsonTemplater but it doesn't work.Can you help me?Thanks Laura

Hi all,Just a quick question:What I try to do today is to write a hyperlink from my workspace to a word document. I am compiling a Word document with a bunch of MSWordStylers and one of the paragraphs contains a hyperlink... I have been looking around, and it looks like it is currently not possible to insert a hyperlink to a word document using the MSWordStyler. Is that still true, or did I miss something? And: would there be an alternative route to accomplish this? Any insights will be highly appreciated. Cheers, Egge-Jan

Dear FMEI want to connect a series of points that follow a certain road alignment.I have a set of point data that are snapped to a road alignment. The point data were registered by different equipment several times in a year. Unfortunately, the point data do not distinguish between different equipment. However, there are two registered dates for each point data that follow the from-to principle. I used these dates to find the sequence and then use them to connect the related points to each other. Even though I was able to create convex from the related points, the built convex were linearly connected.What I would like to attain is to find a method that can link the points based on the road alignment. I gave the point-to-line-overlay transformer a try, but it was not successful! I think the problem was basically because of not having attributes that could be used for grouping!If that was the case, does anyone know how I should assign an ID counter for the features that fulfill a certain