Skip to main content
  • EN

Transformers

Using transformers to modify data.

  • 10,000 Posts
  • 52,714 Replies
10000 Posts
A
akozielec
asked in Transformers
Is there a way to Sort by Field A but only if the first row in Field B is missing?

I have a sorter, but I do not want it to sort if the first row in Field B has a value. I am guessing this will need a combination of transformers.

150
A
H
hanj
asked in Transformers
Errors when running FME Desktop workspace in scheduled task - MS SQL connection related

Hi,I have created a FME Desktop workspace that imports data into the MS SQL database which runs successfully as a scheduled task if I am logged in the server. But it fails when I'm off the server and gives me this kind of error message. (I got a blank SQL provider error)2020-05-07 22:00:21|  11.5|  0.0|INFORM|Microsoft SQL Server Non-Spatial Writer: Trying to connect using SQL Server 2012 Native Client...2020-05-07 22:00:22|  12.3|  0.8|ERROR |Microsoft SQL Server Non-Spatial Writer: Failed to connect using SQL Server 2012 Native Client. Provider error ''. Connection string 'Provider=SQLNCLI11;Data Source=;Initial Catalog=cadasdb_equalizer;User ID=;Password=********'2020-05-07 22:00:22|  12.3|  0.0|ERROR |Microsoft SQL Server Non-Spatial Writer: A suitable Microsoft SQL Server Native Client is not found. Install Microsoft SQL Server 2012 Native Client from http://www.microsoft.com/en-ca/download/details.aspx?id=29065 . Please expand 'Install Instructions' and download 'sqlncli.msi'2020

460
H
G
gobucks02
asked in Transformers
AutoCAD Map3d Expose Misc Attributes

How do I expose (or what Format Attributes contains the info) the AutoCAD Map 3D Misc data "Annotative", "Block Unit" and "Unit Factor" so that it appears with the OD and other attributes I exposed on the Reader? Thanks.

130
franco69
Contributor
koenvdw
Contributor
koenvdwContributor
asked in Transformers
test tiff files on filesize

Hi I cant seem to find a way to test files on filesize. It's not a format attribute or something you can import with the files... You can do it with python probably, but I'm not a programmer. (I tried and failed :) ) All I want is: TESTERfilesize > 1 183 000 bytes    

2330
koenvdw
Contributor
checcosisani
Contributor
checcosisaniContributor
asked in Transformers
Python caller

HiI would like to run this script that need Selenium using python callerAnyone can help me ? thx Francesco

600
takashi
Celebrity
bernarddinon
bernarddinon
asked in Transformers
How can i fix the precision of 3 with StringFotmatter for all the values (.3f) ?

Hello,  In my workspace, I use LenghtCalculator to have the "Distance" from line. I'd like to have three Numbers after .  I use Stringformatter on this attribute with Format String .3f but all value not have this setting.  Someone can help me to fix this?  I have also tried Attribute Manager with Math Opérator "ROund (Distance, 3). It's the same things.  Best Regards  

28717
bernarddinon
R
rjwillshear
asked in Transformers
How to copy attribute based on related columns

Hello,I have created a workspace to download attachments from Survey123 for ArcGIS which works perfectly, apart from one thing. Some of the attachments are stored in related tables and as a result don't pull have the sample ID field included and this is causing issues further down the workflow.I need to create a workflow that compares the parent ID field against the whole globalID column. If it finds a match, then it copies the sample ID field to the appropriate line and replaces the NULL field.Does anyone know how to do this? GlobalIDParentIDSampleID1234NULLSamp 14564NULLSamp 2548441234NULL54564844564NULL45848545NULLNULL

140
R
sigtill
Supporter
sigtillSupporter
asked in Transformers
Write Sketchup with colors

It seems FME supports reading Sketchup and colors - through attributes like RenderingOptions.GroundColorRGB . However it does not seem to write these attributes if you have an fme_color on an object. I have tried creating an RenderingOptions.GroundColorRGB = 0.59999999999999998,0.74117647058823533,0.56470588235294117 - however it does not seem to work. How do you set colors properly in FME for them to be displayed within Sketchup correctly?

200
kidega
Contributor
D
dina_dodo
asked in Transformers
how seperate specific line from network

 i have three lines intersected in the same point the intersected point and the three points known for me ,i want to make barrier at the third line at right side .so the third line will not be part of the network id by network topology builder .the point in the third line has special attribute and i can recognize it so i did buffer on this point but i found the line above this point connects to the another two lines and i do not want that . i want the whole third line seperated from this network id and it will connects to another network that third line connects to . each line has his own ID if i used topology builder ,it create extra intersected node but with id only one point above for the three line how could i solve that  Any suggestion ,thanks

70
D
D
danielhamngren
asked in Transformers
FME AR: Using google drive on iPhone

Hi,I am able to use iCloud as data provider in the FME AR app, but when I try to open the same file in Google Drive the file is greyed out.Does anyone else have the same problem?/Daniel

100
D
david_r
Celebrity
david_r
asked in Transformers
Possible bug with DateTimeConverter rejected output

Hi, can someone please take a look at the behavior of the <Rejected> port of the DateTimeConverter and check if it's as expected:https://knowledge.safe.com/questions/113416/different-date-formats-in-the-same-date-column.htmlThe behavior is described in my answer and the comments below it.Possibly the same issue: https://knowledge.safe.com/questions/91296/datetimeconverter-rejected-port-null.html 

620
mark2atsafe
Safer
rich90599
Contributor
rich90599Contributor
asked in Transformers
Different date formats in the same date column

Hello,I have multiple invoice CSVs I pull in every month with about 300 records each. It eventually goes into a database table that is used as a lookup.The CSV has an invoice_date column and at first I thought the invoice dates were all the same format (M/D/YYYY >> 2/1/2020), however, some invoices have dates coming in the following format: (YYYY/MM/DD >> 2020/02/01).I was wondering if there was a way to standardize this so I don't get NULL date values in the translation when the date format I'm looking for isn't recognized. I'm having a hard time doing a condition because both the date type use the "/" character as a separator. If it was a "-" or something then I can use a condition to search out the special character and parse those dates using a particular format. Any help on this matter would be very helpful!Thank you.

1470
mark2atsafe
Safer
J
jlbaker2779
asked in Transformers
VariableSetter and VariableRetriever bug? - FME 2020.1.0.0 Build 20510

When using a SQLCreator or Creator, I can't get the VariableRetriever to attach attributes to the created data. It works correctly with any other data but not the creator(s). Can anyone else replicate this behavior? FME 2020.1.0.0 (20200305 - Build 20510 - WIN64)  Works correctly with a shapefile input _value is left null for the creator and SQLCreator records

210
J
G
ged
asked in Transformers
Point In Polygon

Trying to use the PointOnAreaOverlayer to merge points and bounding polygons. While I suspect some points may be outside the polygons most should be inside. The result I'm after is that each point will inherit the polygon attributes, but it seems that no matter how I configure the Transformer the Polygon attributes are always <null>. Any help or examples would be well appreciated.

120
erik_jan
Contributor
L
lmoeller
asked in Transformers
Conditional statement in XML templater

Hello there, I tried to comment on content of post https://knowledge.safe.com/questions/52852/seperate-a-single-field-values-into-two-xml-elemen.html# but for some obscure reason wasn't able to do so.My question is a follow-up to the remark of @takashi in the other post concerning the tokenizer function:Note: <bnr:foreignKey> elements would not be created if fme:get-attribute($fkey) was empty.I ran into exactly that kind of situation. What would I do to avoid this?I'm thinking about an if then else conditional statement but fear I am not capable of doing that. Assuming that $anykey is empty - would such a construct work?{    if ( fme:get-attribute($anykey) ne "" ) then    {    for $k in fn:tokenize(fme:get-attribute($anykey), '#')    return         <mri:keyword>              <gco:CharacterString>{$k}</gco:CharacterString>         </mri:keyword>    }    else    {    return         <mri:keyword>              <gco:CharacterString/>        </mri

982
L
crowleyb
Contributor
crowleybContributor
asked in Transformers
SSL Certificate Verify Failed

Hello:I created a workspace with a python caller to access a Zoom api endpoint. I copied the same python code from Zoom's code generator and the code runs fine. I copy the same code into a python caller and I receive the following errors. I have no proxy I am going through. I have very limited python experience. Any help would be appreciated.Errors:Python Exception <SSLCertVerificationError>: [SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: self signed certificate in certificate chain (_ssl.c:1076)Error executing string `import<space>http.client<lf>import<space>fme<lf>import<space>fmeobjects<lf>#<space>Template...Factory proxy not initializedPythonCaller (PythonFactory): PythonFactory failed to process featureCode:import http.clientimport fmeimport fmeobjects# Template Function interface:# When using this function, make sure its name is set as the value of# the 'Class or Function to Process Features' transformer par

2904
crowleyb
Contributor
pratap
Contributor
pratapContributor
asked in Transformers
Count of Attributes with irrespective of schema

Hi Guys,Can any one guide me on how to perform "INPUT" I have to as "OUTPUT" I require...Input will be GDB object class tableOutput will be excel spreadsheet.Schema of the table will be dynamic as I will use different tables. I have provided spreadsheet as an example to understand better...Thank you

250
bwn
Evangelist
souryana
Contributor
souryanaContributor
asked in Transformers
Remove lines on polygon

I have a tabfile that I want to migrate to a database. But first, I need to correct som geometryerrors. I have a polygon layer with some lines on polygon, please see picture below. I want to have them removed. One other thing that is weird is that when I use the transformer GeometryFilter the line object won't filter as lines. They will filter as areas.I Appreciate all the help I can get.

3410
souryana
Contributor
A
andreasb
asked in Transformers
3D solid Clipper boundries leaving a thiny edge

Hello, Currently I'm trying to get a 3d model out of a 2d drawing. Now when extruding different areas and clipping those with each other to get the right solids i encounter a problem. When the boundaries of the different polygons are overlapping (for example: walls and rooms) I encounter the problem that FME sees a very tiny difference between them which leaves me with this very small boundaries where the overlapping lines are.Is there a way of solving this problem? I have messed around with the clipper parameters but for now I didn't manage to get any success. I also thought about buffering the certain areas by a very small amount to just get over the edge but I don't really like that solution; as this makes the model inaccurate. Also I guess this has to do with the floating point problem? When extruding i don't get the exact length but something that differs 0.00000001.Do i have to use the topologybuilder in this case? If yes where do I put it in? I'm still search

180
A
brianatsafe
Safer
brianatsafeSafer
asked in Transformers
New Community Update - Upcoming Changes

Hi All,I hope you are well and healthy! I wanted to drop a quick message to give you some updates on our move to a new community platform. As mentioned long ago (far too long -- sorry for the lack of updates!) we plan to migrate to a Salesforce-based platform and we've been working hard behind the scenes to make this happen.  We are getting close (estimated release date of June 15) so I wanted to start the conversation with you all on what might change and how you can be involved.Firstly, revamping the community means we can take a chance to highlight your efforts. I've been working with our design team to do just that. We should have some special recognition for you that will live publically on the community.  Secondly, we love for you to get a chance to see it firsthand before we go live. We'll look to allow some beta testing and we'll set up a private group for feedback.Lastly, I want to expand the program and add a few new members (we'll be reaching out to a few

100
redgeographics
Celebrity
N
neilhellas
asked in Transformers
JMSReceiver credentials for Solace JMS

We currently use a JMS service that we connect to as a client, via some simple Java code (a Solace JMS service, that we are not the administrators of).We are struggling to connect to the service using a JMSReceiver in FME Desktop. For simplicity, we have copied all of the relevant JAR files into the FME /plugins directory.If we specify the Username in the transformer property, it is not recognized by the initial context factory (the context class returns a "Username must be specified" error). Instead, we have to use the "Additional Provider Properties" and specify:java.naming.security.principal=myusernamejava.naming.security.credentials=mypasswordUsing my network traffic monitoring tool of choice (Wireshark), I can see the initial connection to the URL. However, the server returns a "The username or password is incorrect".Questions:What is the JMSReceiver doing with the Username and Password fields?Is this the correct format for Additional Provider Properties? The documentation is not 

336
steveatsafe
Safer
alexlynch3450
Contributor
alexlynch3450Contributor
asked in Transformers
How does the AttributeValidator transformer process unique feature? Specifically, cloned attribute values.

Is there a way to reject or fail all features containing same value? Right now I would ideally like a way to route all features containing same value to failed port. Currently, for example, if I clone 1 record 3-time, two features fail and one feature pass. How do I route all features that have non-unique values to failed port?

80
alexlynch3450
Contributor
G
geodesman
asked in Transformers
PostGis - SQLCreator does not show geometry

Hi everybody,I have problems to show geometry after SQL statement.Inputs:-PostGIS public database: geometry (polygons) & table I am using the SQLCreator transformer and my query (SQL Statement) works properly but in Data Inspector only the table result of my query is showed but not spatial elements.I´ve tried to use 'GeometryExtractor' in order to extract the geometry column, It does but neither shows spatial elements. Any idea? I don´t know what I am doing wrong?Thanks,Juanjo

1160
M
Y
ymor_v
asked in Transformers
Create lines from Neighbourhoodfinder results

Hi,  I try to make lines from points to the nearest polygon. I used Counter as unique ID for the points, and a geometry remover because I thought is necessary to obtain points from the vertex creator. However, it still does create lines. Also the result I want (LineBuilder) are obviously weird. Whats going wrong here?  Thanks! 

60
Y
lifalin2016
Supporter
lifalin2016Supporter
asked in Transformers
My FME Workbench crashes when adding certain transformers

Hi.I originally had some issues with 2019.0 om my home pc with a home license. It crashed every time I added a Tester or a TestFilter transformer: https://knowledge.safe.com/questions/90340/fme-20190-problems.html These problems were solved in later builds, and neither 2019.2 nor 2020.0 crashes like this anymore. However, I just accidently ran into other similar problems with both 2019.2 and 2020.0 (and even 2018.1) on the same pc.Now it's the transformers AttributeFilter and AttributeValueMapper that makes FME crash immidiatedly.And I noticed that the Sorter transformer doesn't provide any attributes for the sort value either.Luckily both versions work on my office pc, but I would very much also like FME to work properly at home. Are there any information I can provide that'll help find the source of my problems ?I did check the "Improve FME by reporting ...", but I suspect it doesn't work when FME crashes.The pc in question is Windows 10 Pro version 1903 bui

880
lifalin2016
Supporter

Badge Winners

  • Teacher (Grey)
    sredarhas earned the badge Teacher (Grey)
  • Welcome Back
    leonietreblehas earned the badge Welcome Back
  • FME Form Basic Training
    skill_72has earned the badge FME Form Basic Training
  • Student (Grey)
    ibrucehas earned the badge Student (Grey)
  • Welcome Back
    satyam17has earned the badge Welcome Back
Show all badges

Community Stats

31,813
Posts
120,832
Replies
39,444
Members

Latest FME

Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.