- - Community Resources
Ideas
Product Updates
Events
Blog

Home
Forums
FME Form

FME Form

A space to discuss FME Form

27707 Posts

asked in Transformers

How to get max(date) from conditional attribute value

I can't find a way to do what I want.I got a certain number of features. I want to find the max(date) on attribute date for those features, but I want the max(date) to be in relation to a condition on a value from an another attribute status. So I want the max(date) to be calculated and returned first from feature where status = completedif no features have a status=completed then returned max(date) from the other features 1 20230330 completed2 20230329 completed3 20230331 running4 20230329 waitingwould returned max(date) from feature 1 : 20230330 1 20230330 waiting2 20230329 running3 20230331 running4 20230331 waitingwould returned max(date) from feature 3 or 4 since no value set to completed :20230331

1280

1 year ago

james007

asked in Transformers

I am a newbee, I have a spreadsheet that I need to have the data sorted by closed status and date column based on a particular date. Thanks for any help to where I can start.

1 year ago

bozboswellContributor

asked in General

Summarize events from Google Calendar - combine data that is split across multiple lines into 1 line

I am trying to summarize Google Calendar events from the text output of Google Calendar. The export breaks the Description attribute across multiple lines (kinda like a permanent word wrap). Do you know of any way to walk through a text file and put relevant text back together (anti-word wrap)? I realize there is a Google Calendar reader but we are having some issues with connecting using 2FA. I was hoping the text output would allow me to get around fighting with the Google connection. For example, I want to eventually get the DESCRIPTION into 1 line: DESCRIPTION:Training Document Rollout\\n\\n-::~:~::~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~::~:~::-\\nJoin with Google Meet: https://meet.google.com/we-m2dbz-xvc\\nOr dial: (US) +1 443-23471-4874 PIN:8were6975#\\nMore phone numbers: https://tel.meet/wje-mebz-xvc?pin=2freaag3037362148&hs=7\\n\\nLearn more about Meet at: https://support.google.com/a/users/answer/912345620\\n\\nPlease do not edit this sect

1 year ago

sveamarc

asked in Transformers

I have a database table with about 5 million objects. Each object has positions (lat, long in two fields). I want to read only the objects that lie within polygons (features read from a spatial source). Is it possible without reading all objects?

1 year ago

michaelContributor

asked in Transformers

Buffer left/right only

I'd like to buffer only one side of a line. According to the FMEpedia articles below, in FME 2012 and later the Bufferer transformer should have this as an option. I'm using FME 2013 sp4 (13547) and the transformer doesn't have it as an option. Am I missing something? http://fmepedia.safe.com/articles/Samples_and_Demos/Buffer-On-Left-or-Right-Side-Only http://fmepedia.safe.com/articles/FAQ/Whats-Great-2012 I did find the MultiBufferer from the FME Store but I can't get it to output a polygon, just a line that is offset the distance I wish the buffer to be. Michael

3620

1 year ago

checcosisaniContributor

asked in General

How to read json

HiI need to extract from json the info reated to each run "Name": "Run 1","Start Time UTC": "","Stop Time UTC": "","Duration (hh:mm:ss)": "", I tried to use the json transformer but no success thx for help Francesco

1 year ago

freddy17Contributor

asked in Transformers

dwg - workspace didnt generate any output

Hi Everyone I am slightly bamboozled and wanted to know if someone knows where I am going wrong or if this is a potential bug.I have had used the FME Cloud and FME Server for loads of FME Server Apps, and havent come across this issue so far. I get the following warning after running a fme server app I am converting a .dwg file to an excel file. If I use a feature_reader set for readings dwg:Autodesk AutoCAD DWG/DXFI get the warning, that the no output can be generated. But if I read an ifc and convert it to excel, all is well. Is there maybe a problem reading dwgs? Why is there no output generated? The FME Server Jobs show that the job is completed without any errors. I have uploaded a .dwg and .ifc and the workspace regardsFred

220

1 year ago

fmejameslContributor

asked in General

Attribute getting set to null

I have a custom transformer. One of the incoming attribute values contains a comma separated list of strings. As soon as the record passes through any subsequent transformer, the value is set to null. Here is the incoming data with WOTEMPALTEIDs as the value that's getting dropped.After passing through any transformer (AttributeManager in this example), WOTEMPLATEIDs values are dropped to null. The other values are unchanged.Thanks

370

1 year ago

thomastupuivaoContributor

asked in Transformers

Is there a transformer that will convert a multilinestring to a linestring object?

Is there a transformer that will convert a multilinestring to a linestring object? I'm trying to load road centrelines in an oracle spatial database, but the road centreline table in oracle uses GTYPE 2002 (line). Multilinestring is 2006, so I can't apply a spatial index. Any suggestions please?

2560

1 year ago

mlufkinContributor

asked in Authoring

Creating Bingo cards?

Hi there,Slightly off the wall here, but has anyone created a workspace that can create Bingo cards? Ideally a 5x3 grid of random numbers between 1-90, but no repeating numbers...?Obviously, RandomNumberGenerator can give us a way to actually play the game...but I'm thinking whether FME can create the cards for users to play with..?Thanks!

i want to create excel is group by complexFolder name same (complex Folder) value have each excel

1 year ago

mhprawiro

asked in General

Google BigQuery Authentication Return 401 disable client

Hi, It's been a while that I couldn't Add Web Connection for using GoogleBigQueryConnector. Previously it's working well, but after re-install my FME desktop, it's always return Error 401: disabled_client when I try to add web connection using my google account.Error 401: disabled_client Sign in with Google temporarily disabled for this app. This app has not been verified yet by Google in order to use Google Sign In. Request DetailsThe content in this section has been provided by the app developer. This content has not been reviewed or verified by Google.Could some one help me what's wrong here?

2230

1 year ago

jasoncContributor

asked in General

How to dissolve polygons based on an attribute where a dissolved record will include non touching polygons with the same attribute? Using Multi Polygon geometry

960

1 year ago

arturgustowskiParticipant

asked in Data

Writing cell to dgn writer

We noticed that the speed of data writing to the DGN format depends on the type of objects. If we set the cell object at the beginning the writing was fast, then at the end, the speed slowed down several times. And the question is, is it a writer's trait or an object's trait?

180

1 year ago

kzkjcContributor

asked in Transformers

Excel Writer - Multiple Row Number Attributes?

Hello, I am writing to an excel sheet with an existing template. Before the writer, I am using a counter (starting at 0) and attribute creator to then use "Use attribute names as column positions" and "Row number attribute". My attributes are B, C and D which are various strings and B_row_number (@Evaluate(16*@Value(_count)+10)) and CD_row_number (@Evaluate(16*@Value(_count)+16)). I would like the output sheet to look like the image below:Unfortunately, I can't assign different "Row Number Attributes" to arrange it this way (B using B_row_number, and C,D usin CD_row_number). I get the feeling there is a simple workaround I'm not seeing. Any help is appreciated! Thank you.

690

1 year ago

jonvelcoContributor

asked in General

FME Server can't open Oracle client libraries but Desktop can

On the FME Server VM I have setup, the 64 bit Oracle Instant Client isn't being recognized by FME Server. I have the PATH environmental variable set to the folder. I also installed Desktop on the same VM and it has no problem connecting to Oracle databases. What else can I try? This is the error I get when running the workbench in Server:Oracle client libraries (e.g. oci.dll) could not be loaded. Ensure that the 64-bit client is installed and properly configured, and the PATH environment variable includes the file path to your Oracle client. Refer to https://community.safe.com/s/article/how-to-setup-an-oracle-instant-client-for-use-with for more informationThe Oracle Instant Client setup is the "Basic Package" Version 21.9.0.0.0 FME Server2022.2.4 Build 22792 - win64 FME Desktop2022.2.4.0 (20230303 - Build 22792 - WIN64)Database Edition

950

1 year ago

clairecoContributor

asked in Transformers

How to name an output json file with the value of an attribute?

Good morningI want to generate a json file that accompanies a photograph and I want the name of the json file to be the name of the photo which is contained in a 'Photo' attributeI also want as many json files named with the name of the photo as there are photos in my source directory.I tested in the json output to put the Photo attribute in the entity name but it doesn't work.Thanks

300

1 year ago

galigisEnthusiast

asked in General

How to Write features in a specific order / Hierarchy?

Hi Community, I'm working on a workflow that needs to write a final Feature class based on a particular hierarchy. The workflow includes a few 'AreaOnAreaOverlayer' steps + ListConcatenator to indicate which parcel overlaps which, below a screenshot with the desired hierarchy:1 - Most important parcels A2- Middle important parcels B3- Less important parcels C I can't run dissolve + clip as need to keep the overlapping information to be 'listconcatenated' so decided to use a Sorter (alphabetical order) to obtain the desired order but isn't working 😞 as there's areas where the parcels C are on top of the parcels B. Below an example where the overlap in the middle between 2 parcels (B + C) should be assigned to B but for some reason is CThere must be a way to tell FME please write parcel A on top of parcels B and then parcels B on top of parcels C and parcels A on top parcels C. A>B>C Thanks a lot in advanced 🙂

1620

1 year ago

limoSupporter

asked in Data

How to get geometry from bridge modul in citygml?

Hi, we have a citygml file that contains a bridge. The validation by "citydoctor " showed no errors. Now we wanna extract the geometry. FME can read the file without error. But only a core element is shown and I cannot get the geometry!By the way we got the same result with the template bridge from the university (KIT)! Does anyone have any ideas or tipps for me?Thanks in advance.

160

1 year ago

femoContributor

asked in General

Hi, i want to read a compressed file within a python caller. It works fine, as long as i reference to a *.gz file located in the file system of my pc.

However, I would like to directly read the same file from a URL.Therefore, i have changed the published parameter accordingly (see screenshot attached). The following error messages is produced:Emptying factory pipelinehttps://www.opengeodata.nrw.de/produkte/geobasis/hm/dgm1_xyz/dgm1_xyz/dgm1_32_372_5714_1_nw.xyz.gzPython Exception <FileNotFoundError>: [Errno 2] No such file or directory: 'https://www.opengeodata.nrw.de/produkte/geobasis/hm/dgm1_xyz/dgm1_xyz/dgm1_32_372_5714_1_nw.xyz.gz'Traceback (most recent call last): File "<string>", line 24, in input File "gzip.py", line 58, in open File "gzip.py", line 174, in __init__FileNotFoundError: [Errno 2] No such file or directory: 'https://www.opengeodata.nrw.de/produkte/geobasis/hm/dgm1_xyz/dgm1_xyz/dgm1_32_372_5714_1_nw.xyz.gz'Error encountered while calling method `input'PythonCaller_3 (PythonFactory): PythonFactory failed to process featureAn error has occurred. Check the

190

1 year ago

james_c_452Supporter

asked in General

Shapefile generated in FME doesn't work in lastools

Hi,Does anyone know why a shapefile generated in FME would not work in lastools? I am using lastools to clip a point cloud using a buffer from FME but it can't read the shapefile. I don't know why it is invalid, only that my command line has the following errorAny help would be appreciatedThanks

1 year ago

koenvdwContributor

asked in Transformers

I have a XYZ point cloud. I need to simplify the point cloud in such a way that I have a point every meter.

So the result should be a point cloud that has points in a grid of 1m x 1m. Personally I would make a DEM with cell size 1m, but that's not what they want. So I have a boundary of the project area. I make a 2dgrid with cell size 1 meter. I clip the grid, because it's made on the hull of the project area and not the project area itself. Then I use the grid to make points in the center of each cell and also use the grid to clip my point cloud. I use the pointcloudstatisticscalculator to get the mean of the z values within one cell of the grid. So I can use the X en Y from the center point and have to add the Z from the statisticscalculator. I merge the data together based on the counter I added. Then I use the vertexcreator to make points with the correct X, Y en Z. If I inspect these, everything looks good. In the data inspector we see that the points have the correct X, Y en Z.The problem is that I can not write the data as point cloud. Not as xyz file and not as las file. I

1200

1 year ago

aaronContributor

asked in Transformers

How to check/uncheck multiple attributes in a transformer

There are many FME transformers that allow you to select one or more attributes for analysis. In this case, I have about 350 attributes in a CRCCalculator and I would like to select about half of them. It would be much easier if could select them in a group rather than individually. Is this possible? I've tried using the standard shift-click - clicking the first checkbox and then doing a shift-click somewhere down the list on another checkbox to grab everything in between - but no luck. Is it done another way? I'm using FME 2020.1.2.1 (Build 20624).

1 year ago

arsema

asked in Transformers

Linebuilder

Hello everyone, I need help with the graphs below. I need to maintain the original structure for the graphs. Using the line builder changed the output structure, as you see below. I have an extensive dataset, some lines are correct, but some created their structure and direction. IMG 1.0 and IMG 2.0 are the original graphs. Some lines have around 500 vertices each, but I used a generalizer and changed from 500 to 2 vertices per line. I don't want them to reduce that much. I am looking at around 200 vertices maximum for each without changing the original graph formats. Which transformer can solve this? Thank you so much.

190

1 year ago

galigisEnthusiast

asked in General

PointOnAreaOverlayer Help - One Point shared between two polygons

Hi Community, Classic issue with the PointOnAreaOverlaye where I have got one location where the same centroid is shared between two parcels and want to bring the information from point to area. Attached two screenshots that explain the situation. In theory...by creating a list and exploding should work but doesn't give me what I want as the output contains 2 parcels overlaps where there're two points Example 1) I need to bring the assign the point info to each of the parcels. As you can notice the point on the left is shared between two parcels.Example 2) Also, I need to bring the assign the point info to each of the parcels. As you can notice the point on the right is shared between two parcels.I have tried to 'Generate List on output Area' and then explode but the 'element_index' and '_overlap' are different so can't use a tester to filter the list.I have also tried NeighborFinder to filter only those centroids at the middle of the parcel . Thanks

260

1 year ago

1
...
165
166
167
168
169
170
171
...
1109

Page 168 / 1109

Terms & Conditions Cookie settings

Sign up

Already have an account? Login

An FME Account is required to contribute

Login to the community

An FME Account is required to contribute

Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.

Enter your e-mail address

Back to overview

Scanning file for viruses.

Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.

This file cannot be downloaded

Sorry, our virus scanner detected that this file isn't safe to download.

A product of

Company Products Giving Back Careers Contact Privacy Feedback

Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.