- - Community Resources
Ideas
Product Updates
Events
Blog

Home
Search

Best Answers

9935 Posts

Recently active

Most views Most replies

rdcagale

asked in Transformers

copy an attribute from one record with another. Where the another reference is the same value

I have a table of data below which I need to copy the property number to the null fields in the other records for that uprn? Any ideas?

525

7 years ago

femoContributor

asked in Data

writing csv-file, unwanted type conversion

Hi,I am facing a problem while writing into a csv.file:FME converts the string '2-4' into 02.Apr., no matter what field type is set.E.g. '17-19' remains as it is since it cannot be changed to a date Format.Is there any smart Workaround or do I have to avoid/replace these strings?

142

7 years ago

taojunabcParticipant

asked in Transformers

How to convert uppercase to lowercase use regular expression

FME 2017.0.0.0I try to use StringReplacer to uppercase letters to lowercase letters, but failed. Attribute:attr (has a value "ABCD") Mode:Realace Regular Expression Text To Replace:([A-Z]) Replacement Text:@LowerCase(\\1)I also tried the @UpperCase,@Format,@PadLeft,@PadRight..., but those function seems does not work for regular expression groups (\\1) too.String functions cannot be used in a regular expression group?

how can i get Microstation v8 cells from library into new dgn

Hello. Is it possible to change the name of the logfile a workbench writes by using a workbench in batchmode?Regards Eduard

1592

7 years ago

adamsjhoskins

asked in Architecture

WIndows Authentication on FME Server 2017

HiI'm having trouble using connections to SQL Server since upgrading FME server to 2017. I'd like to use windows authentication, and got this working on 2016.1 by changing the account that one of the FME services ran as (using a service account), and giving that service account access to my database. I've tried this in 2017 and it doesn't seem to work - it stops various parts of FME Server from working properlyAlso I can't seem to find any documentation for FME Server 2017. Is there any?ThanksAdam

145

7 years ago

johannesbloemen

asked in Transformers

Counting features based on difference in line overlay

Hello,Im new to FME, I can't find the solution to this problem in the knowledge base.Im trying to count the purple horizontal lines in the picture as following: 5, 10, 15, 25 etc. I think this can be achieved with the counter transformer.But when the underlying vertical line feature changes the counter has to reset. Any advice would be of great help.

7 years ago

rkcha

asked in Authoring

problems reading layers from ArcGIS Server Feature service, getting Python exception

Hi,I´m trying to extract data using an ArcGIS Server Feature service reader which is going okay. For some of the layers I´m getting the following error:Python Exception <UnicodeDecodeError>: 'ascii' codec can't decode byte 0xe5 in position 10: ordinal not in range(128)I´m guessing the problem relates to some characters in the tabel of the layer which can´t be read by the ArcGIS reader? Or could the problem relates to the transformer being programmed in Python 2 instead of Python 3 (which i´ve been told is handling encoding-problems better)?I only need the geometries (and the layer names), so is there a way for me just to be able to read the those?If that´s not possible is there a way for me to encode the tables so that I wont get the error-message?Thanks in advance :) Christian

Are features ran through pythonCaller sequentially or with multi-threading ?

Everything is in the title.

344

7 years ago

mdumka

asked in Transformers

I have polygon shapefile A and polygon shapefile B, and I need to cut holes in shapefile A polygons using polygons from shapefile B. Is there a way to explcitly set the hole cutting to occur on shapefile A only?

173

7 years ago

sigtillContributor

asked in Transformers

Format number from: 1000000 to 1 000.000

Can you convert, with the Stringformatter frominteger = 1000000integer = 1234567integer = 234567to1 000.0001 234.567 234.567? Or do you have to do some dirty python?

536

7 years ago

ccomeauContributor

asked in Transformers

Number Notation

Good morning,How could I transform a number into French Notation?Ex: 1000000.00 into 1 000 000,00This information represents surface area on a map. I have already worked out the calculations and the placement transformers and am stuck on the customer's desired presentation.Thank you,Chris

588

7 years ago

davideagleContributor

asked in Authoring

Problem with OBJECTID clash when writing FGDB

Hi - I'm reading in one Esri File Geodatabase using the ArcObjects Reader (not the open source API reader) and writing out another with a subset of the data in it. The Writer uses a 'Reader as a Resource' to control the schema dynamically and also uses an empty Geodatabase with the same schema as a template file, to ensure that featureclasses that are sent no features by FME still exist (but are empty) in the exported FGDB.My problem is that I am getting a warning that I can't engineer out of the process:WARN |User field name 'OBJECTID' conflicts with value of feature type parameter 'Object ID Field' ('OBJECTID') for table/feature class 'd_y_n59'. User field will be ignoredThis appears for every featureclass I'm trying to write, so 105.I know that the incoming data has the OBJECTID and I know that the FGDB needs to create it. On my dynamic writer the FeatureType sets the field and the alias to 'OBJECTID' by default. I'm pretty confident that the result is good, even with the warnings

1237

7 years ago

redgeographicsCelebrity

asked in Data

MySQL date/time field

Hi,I'm writing data to a MySQL (non-spatial) database and have some problems getting datetime fields filled. Checking a sample table in phpMyAdmin shows the date format to be ^Y-^m-^d ^H:^M:^S, e.g. 2017-02-28 13:09:00, so I've set up my TimeStamper to output that. But when I write to the database it fails every feature with a message saying it's an invalid format.If I enter the same value directly through phpMyAdmin it's accepted.Any idea what I'm doing wrong?

315

7 years ago

poncetaContributor

asked in Data

Bulk / auto connecting Reader to writer

Hi,Is it possible to autoconnect or bulk connect readers to writers?I could choose "copy from reader" option for attributes but I would be happy if I haven't to link my 139 tables by hand!If you have a trick to easy lowercase all schema and table names it would be be so great!

25816

7 years ago

danilo_fmeEvangelist

asked in Integration

Using the FMe Objects API in Python to Raster

Hello All,Has someone been to use in the edition FME Deskto 2017 the API in Python to manipulate Raster files?I need to create a example to share this news to my customer, but my Workspace has a Error when i write the code inside the transformer PythonCaller.import fmeimport fmeobjectsclass FMERasterProperties(object): def __init__(self): pass def input(self,feature): begin = fmeobjects.FMERasterProperties() begin.getNumCols() def close(self): passAtttached my Workspace, * the Reader can be any Raster file

Possible bug in FME 2017 RC on OS/X

Hello, please see https://knowledge.safe.com/questions/40453/invalid-scale-reduction-specified-error-when-openi.html?

7 years ago

david_r

asked in Data

@username links not always working in forum posts

Hi, can you have a look at this forum-related issue and see if there's anything to be done?https://knowledge.safe.com/questions/40222/why.htmlThree issues:@username not always clickable@xxx does not always produce a dropboxTyping @ sometimes marks the text as a heading rather than inserting "@"

7 years ago

fmelizardContributor

asked in Transformers

Easy way to dinamically count number of attribute of feature types

I'm reading (only for example) a xls file with 3 sheets by reader using "Single merger Feature tipe" option. So this is result in inspector:I would like to count number of attribute for each feature type (2 for tab_A_in , 4 for tab_B_in, 3 for tab_C_in) obtainig features with a new "attribute_count" attribute (I don't know obviously first number of feature types and number of attributes so I have to find a dinamic way to obtain result):

1892

7 years ago

taojunabcParticipant

asked in Transformers

Extract band to new raster by Python API in FME 2017

I was learning Python FME Objects API for Raster, I tried to extract a band to generate a new raster, But it didn't work out. What's wrong with my code?import fmeimport fmeobjects class ExtractRasterByBand(object): def __init__(self): pass def input(self, feature): rs=feature.getGeometry() rp=rs.getProperties() rb=rs.getBand(0) newfeature=fmeobjects.FMEFeature() rsnew=fmeobjects.FMERaster(rp) rsnew.appendBand(rb) self.pyoutput(newfeature) def close(self): pass

112

7 years ago

danilo_fmeEvangelist

asked in Data

Get a screenshot from Web

Hello Team,I`m try to take a screenshot from a Webpage with FME, but i didn`t find a transformer that make this.The website: http://www.ipmet.unesp.br/index2.php?menu_esq1=&abre;=tempo/boletimdotempo.htmlScreen that i want:Thanks in Advance,

734

7 years ago

jonContributor

asked in Transformers

Split line with points but not at intersections

My goal is to split lines when there is a point within a tolerance (i.e. 20ft) but NOT at intersections (they are already split at intersections. I've been using the PointOnLineOverlayer which works great everywhere except at intersections since the points are close to the intersection but not at them. Here's an image to try and explain the situation:Any thoughts on how I can ignore the points near the intersections when splitting?

313

7 years ago

goro13

asked in Transformers

Write OBJECTID attribute of Oracle Spatial registered feature class

I’m trying to create an FME process that reads a FGDB andwrites the data to an Esri registered feature class stored in an Oracledatabase. I have issues in finding the proper way of doing it using the OracleSpatial Object writer. The trouble is caused by the OBJECTID: how to populateit?I’vetried using an SQL statement (Overrides Feature Operation) like INSERT INTO FEATURE_CLASS (OBJECTID, COL1, COL2) VALUES(sde.gdb_util.next_rowid('OWNER', 'FEATURE_CLASS'),:COL1, :COL2)With this approach the OBJECTID column gets populated but I’mfailing in writing the geometry (the geometry in Oracle is stored asSDO_GEOMETRY). As a workaround I’ve defined another process using the same writerto update the geometry column only (Feature Operation = Updated instead ofusing the SQL Statement Overrides Feature Operation option).Is there a way of doing this in one step only?I know it can be done by using Esri Geodatabase (ArcSDEGeodb) writer but for some reason the process takes about 20 minutes incomparison

1585

7 years ago

mzaff

asked in Transformers

Assign bounding extents to Reader (Search envelope)?

Hallo!I'm curious if and how it is possible to assigne max/min extents which come from the "BoundsExtractor" to the search envelope of multiple data readers.The first step of the workbench is to make a buffer around an area. This buffer is extended to the max min boundaries with the "BoundingBoxReplacer. This generated square is used to clip different input sources on the area inside the bounding box.Because it's quite an amount of data, i'd like to preselect the region with an search envelope so that not all data has to be loaded to be clipped.Is it possible inside one workbench to generat the min/max extents and hand it over to the search envelope of other readers?I've tried to assigne the values as private parameter, but this seems to late for the reading process of the input sources. Thanks in advance! Mark

IfcSpace to 3D geometry in PostGIS

Hello,I am trying out how IfcSpace elements in Building Information Models can be transformed to 3D geometry in PostGIS. I have made a simple building model in Revit in which a few spaces are defined. The model is exported to an IFC file. When I open the IFC file in an IFC viewer (Solibri) I see the spaces and they can be drawn on screen as 3D geometries. So somehow it is possible to derive 3D geometries from the IFC file. However, if I do a (default) translation from the IFC file to PostGIS, I see no geometry for the spaces being created. All space have the same geometry value (in WKT): GEOMETRYCOLLECTION(GEOMETRYCOLLECTION(GEOMETRYCOLLECTION EMPTY)).Is it possible to transform IfcSpaces to 3D geometries or even 2D geometries in FME?

623

7 years ago

Page 330 / 398

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.