- - Community Resources
Ideas
Product Updates
Events
Blog

Home
Forums
FME Form

FME Form

A space to discuss FME Form

27552 Posts

Recently active

Most replies Most views Newest first

winnie

asked in Transformers

Extract cell rows to individual columns

Hi, this is probably a very simple question but the brains not working this morning. I can do this in excel but want to know how to do this in FME.I have a cell with an address split by new rows (Char(10) and I want to split this cell and put the outputs into new, individual columnsexampleDetailsNameOfficeRoadTownCountyPostcodeJohn Smith Corporation Building Common Road London City of London W1 2DEDetailsNameOfficeRoadTownCountyPostcodeJohn Smith Corporation Building Common Road London City of London W1 2DEand I want this DetailsNameOfficeRoadTownCountyPostcodeJohn Smith Corporation Building Common Road London City of London W1 2DEJohn SmithCorporation BuildingCommon RoadLondonCity of LondonW1 2DE

612

7 years ago

khalid_omer

asked in Transformers

Chop line from the beginning

Dear All , We have a line with two vertices , we try to to shorten the line from the beginning to 10 meter using choper by length but not effect , Can someone help us archive this . Thanks ,

7 years ago

kirsten

asked in Data

Is there a way to add an additional value to absolute value in the KMLPropertySetter Parameters?

For example, I would like to add 40 meters to the current absolute value height.

7 years ago

mitra

asked in Transformers

creating kml file from sketchup model

Hi allI have a sketchup model where I need to place one tree at certain xyz points. The thing is I already have the point where the tree need to be placed as shape file and a model of a tree in sketchup.Has anyone tried replacing a point data set with a sketchup model and then exporting the whole thing as a kml file.Any ideas would be appreciated

132

7 years ago

mark2atsafeSafer

asked in Transformers

FME Community: Flavour of the Month (May 2017)

Hi FME'ers,It's that time again when we get to recognize the contribution to our community by one particular user, and in this case that user is @itay Congratulations Itay. You are the "Flavour of the Month" for May. That's quite an achievement when you were also at the FME User Conference for a week.As a quick reminder, the Flavour of the Month badge is awarded to the community member earning the most reputation points over a calendar month. Itay wins for earning 615 reputation in May, and joins the list of previous winners: @takashi, @david_r, @jeroenstiers, and @jdh Points are earned for all manner of actions, but mostly from the votes gained on questions you have asked, and answers you have posted. So, please, do keep voting when you see a question or answer worthwhile of recognition.It was great to meet so many of you at the recent FMEUC, and to take part in the Hackathon with you. I can't wait to do that again, and I have a few ideas for our comm

7 years ago

gnawali66

asked in Data

Printing infrared images on the top of point cloud?

I am working with FME 2017. I am quite a new user, now i tried to colorize point cloud with infrared color (i.e. integration of thermal images with 3D point cloud). LAS file has the local co-ordinate system but Jpg thermal images does not have any co-ordinate system. How can i integrate them on single file?

7 years ago

max

asked in Transformers

Take off the Georeferencing - 3d Sketchup Model

Hello Friends. Recently I have downloaded a 3d sketchup model to put on my kml file. However that 3d sketchup model came georeferenced (http://sketchup.google.com/3dwarehouse/details?mid=1568c242397cda99752ea028d9049dd3&prevstart=0). So what I am trying is to pass my coordinates x and y and place the .skp according the coordinates, converting it into a kml file. I see that is possible but I am working with many OffSetters, what is really confusing. I would like to know if there is a way to take off the georeferencing in the sketchup model to after I just put my coordinates. Could you help me? Thanks in Advance

7 years ago

oaralb

asked in Transformers

Replace point dataset with sketchup tree components

Hi allI am creating a large sketchup model where I need to place a large number of trees at ertain xyz points. The thing is I already have all the points where the trees need to be placed as GIS table in a local Postgis database and a model of a tree in sketchup.Has anyone tried replacing a point dataset with a sketchup model and then exporting the whole thing as a new sketchup file.Any ideas would be appreciated/Morten

7 years ago

florena1

asked in Transformers

How to add decimal to a Pointcloud

Hello,i have to thin out a few Pointcloud files. I tried with PointCloudThinner, and it works fine. But i have problems with the decimals. In the original File are all Coordinats with two decimals ,but in the edited file some coordinates have only one decimal. How it add a zero to the coordinate, i tried it with round, and format, but it dosent work.

7 years ago

fmelizardContributor

asked in Authoring

Moving Workspaces between FME installs - tips and tricks

I've heard that there are some users out there doing really cool things with python scripted parameters to help move workspaces between different FME Desktop installs and FME Server as well!!I'd love to know what FME users have been up to on this front! Please share your solutions.

305

7 years ago

salvaleonrpEnthusiast

asked in Transformers

Clone a polygon x times

I have one polygon intersecting a pole. There are 2911 features on this pole feature class, there's only one polygon. After the pole feature class reader, I have a counter that counts the features, I want to use the max count of the counter to pass to the polygon cloner. See workspace below. My cloner number of copies is manually typed. I know I can use the statscalculator, but I'm looking for other options. The rest of the workspace - offsetting coor0 of each cloned polygon to a pole already works.

7 years ago

grishmash

asked in Data

How to create FME workbench so it reads excel Formula? it needs to read columns with no formulas and give the values in that column and then also columns with formulas and give back those formulas

113

7 years ago

jaygis

asked in Transformers

Missing Polygons

Hi There, I am in process of troubleshooting a workspace (2016 64 bit). The workspace sources data from oracle database and then matches the keys with few spatial layers followed by clean up and merging based on key attributes. The output of this process is a shapefile (approx. 100K records). I noticed that FME run misses some polygons that it should have included in the output. I ran the process with just the problem area and it works fine. The problem shows up when I run the full process. I am curious if someone has come across this issue and had any suggestions for me. ThanksJay

Finding all shapefiles nested in one directory

Hello, I have a bit of a problem that I can't find a solution to. I have a list of directories and sub directories. Some contain shapefiles. Some contain tables, gdbs etc. Eg: S:\\NEW\\170530\\test.shpS:\\NEW\\170529\\NewData\\NewTest.shpS:\\OLD\\170428\\test.xlsxS:\\OLD\\170428\\MoreData\\MoreTest.shpThere are more folders within those dated directories. The root drive is always the same "S:\\"The root data directories (eg, OLD, NEW) will be provided by users as a user parameter. There won't be any navigating to those specific directories. How can I have a workbench that reads all the shapefiles nested in all those different directories, once the root data directory has been passed to it? Everything from the PATH reader up to the FeatureReader only specifies up to the dated directory based on user input. Eg:S:\\NEW\\170530I saved the directory path and passing the following to the FeatureReader: S:\\NEW\\170530\\**Now it works.. but with a couple of drawbacks. For on

AGOL Writing - Limited to ~20 seconds

Hi I am trying to use FME to update data on AGOL. This works with small data sets, however on larger datasets I get a timeout error (see below), when the process takes more than about 20 seconds.I am using FME 2015.1.1.0 and can't upgrade at the moment :-(I have tried using system proxy settings (but this did not make any difference)If I process the updates in batches this works (but is messy), and I can't truncate a large tables (as this is one large transaction)Has anyone else had a similar issue with a known work around? FME Error: "The error was 'HTTPSConnectionPool(host='services2.arcgis.com', port=443): Read timed out"

125

7 years ago

fmelizardContributor

asked in Data

My workspace cannot write to File Geodatabase due to Geodatabase Error (-2147024894)

I have set up my Geodatabase Writer but can’t write to it. The log file gives me this message: “Geodatabase Error (-2147024894): The system cannot find the file specified.” even though I’m creating a new file geodatabase within my workflow.

Handling FME Service call failure

Hi,I have published a workbench to FME server(2016) as job submitter service.This service will be called from an oracle table trigger (using utl_http.write_text(req, message)) and then the FME webservice will call the workbench(2016) in which i am sending a message to another webservice using HTTPCaller transformer's Post method.Now the question is:1.How to handle in case my FME call from the oracle trigger was failed for any reason like the FME server down or something else?2.How to handle if the HTTPCaller to the webservice from the workbench is failed for some reason?Is there a proper way to handle this issues? Any help would be much appreciated.Thanks,Mari...

133

7 years ago

franco69Contributor

asked in Transformers

sort lines after clipping

I have a route and clip it against areas....but i need the result in order of the flow direction of the route.....which parameter sorts me that because now the result is in no order and when i put a count on it it is no logical order.So please help me... i think its no t abig problem for u guysThx Franco

7 years ago

aquamarine

asked in Transformers

Composite Test AND OR order in TestFilter

Hi, I am using the TestFilter with a composite test set up. However, the results are not what I am expecting. I believe it is something to do with my use of brackets and the AND and OR operator order.I can't get the following composite test to work:(1 OR 2 OR 3) AND (4 OR 5 OR 6)Can anyone explain the order of precedence for OR and AND in the TestFilter composite test and whether the brackets are even recognised?Thanks

7 years ago

rob_f

asked in Data

FME crashes without error but runs if tasks are done separately

Hi,I have a simple workspace. I read a file (interlis2) and have 4 parallel transformers attached (GeometryReplacers, followed by GeometryFilter and AttributeRenamer).When I run the workspace it crashes at exactly the same data row in my input file without any further error message except "fme has stopped working". Nothing in log file either.If I disable two of the four parallel transformers and run the workspace and afterwards disable them and enable the two remaing ones all data is read and written (Autodesk sdf3).Memory is no issue - FME just uses 500 MB, there is plenty left.Any ideas why that happens? I would like to run the workspace in one go.Thank you, Rob

7 years ago

oscardInfluencer

asked in Data

Split JSON into several features

Hi.I have the following .json file:{ "0": { "0": { "Group 1": { "Sub 1": 0, "Sub 2": 70 }, "Group 2": { "Sub 3": 0, "Sub 4": 29 }, "Group 3": { "Sub 5": 136, "Sub 6": 120 } }, "1": { "Group 1": { "Sub 1": 0, "Sub 2": 76 }, "Group 2": { "Sub 3": 1, "Sub 4": 35 }, "Group 3": { "Sub 5": 157, "Sub 6": 115 } } },"1": { "0": { "Group 1": { "Sub 1": 5, "Sub 2": 72 }, "Group 2": { "Sub 3": 51, "Sub 4": 2 }, "Group 3": { "Sub 5": 16, "Sub 6": 20 } }, "1": {

FME Data Interoperability does not show in the extension list after installed by an administrator

My desktop administrator has installed the FME on the PC with Esri ArcGIS desktop. I'm not the administrator of the PC. After FME desktop installed, the FME Data Interoperability is listed in the Esri ArcGIS desktop extension for the administrator. When I login, my ArcGIS extension list doesn't include the FME data Interoperability. I'm not the administrator on the PC. Thus I don't have right to install any software. How can I use the FME Data Interoperability installed by the administrator in the ArcGIS desktop? Thanks in advance.Helen

7 years ago

fmelizardContributor

asked in Transformers

How to split section polygons into quarter sections

We have polygons that represents sections. We want to use FME to split all these polygons to subsections. i.e. quadrants. Any good ideas?

1825

7 years ago

danilo_fmeEvangelist

asked in Integration

Direction using Python

Hello Team,I want to extract a direction of driving between address points using the API from gogglemaps. First i have the Origin Point and i need to find the next address ( point b for example ) from xls file. After from the point B find the next address ( point C ) and repeat this process 10 times. I believe the best way to do this is a loop in python. Attached my template file.Thanks in Advance,Danilo

295

7 years ago

fariyafarhad

asked in Transformers

Last two records in a column

Hello all!This seems like it should be a very simple thing to do but I am drawing a blank. I have an attribute column full of numbers (Dates). I just need to sort it and get the latest two records and put them under separate attributes. This is what the column looks like (already sorted descending). I need to assign "170503" to one attribute (let's call it "DATE")I need to assign "170331" to "previous_DATE"Any help will be appreciated. Thanks!

134

7 years ago

1
...
862
863
864
865
866
867
868
...
1103

Page 865 / 1103

Badge winners

alkamelgishas earned the badge Integrate Spatial Data
giohas earned the badge Student (Bronze)
giohas earned the badge Student (Grey)
giohas earned the badge Expert (Gold)
giohas earned the badge Expert (Silver)

Show all badges

30,133: Posts

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.