Skip to main content
  • EN

Transformers

Using transformers to modify data.

  • 10,000 Posts
  • 52,714 Replies
10000 Posts
sameer
Contributor
sameerContributor
asked in Transformers
Capture and log error using Workspace (SystemCaller) + SFTP using Automation

Hello Just need some guidance:  I'm currently using SystemCaller + AttributeFilter (0 & 1 for error logging) as a workspace to run a batch file daily which does the following:- Delete existing log files- Create WinScp log file- After setting some variables then log in to SFTP server using WinSCP commands- Upload a file, check its existence on remote server and if exist then upload the respective ".Done" empty file from local server. Exit with Code 0. If failure then abort and always exit with Code 1.- Catch error in case of failure and output it to error.txt (it will tell me which file failed)- Script repeats the same process for the remaining 4 datasets.E-mailer attached to attribute filter 1That's working. I want to:Option 1Use automation to achieve the same result albeit SFTP "External Action" fails to validate the connection and states "Invalid - Path not found". For now I've given up on trying to understand so will skip that option.Opt

460
virtualcitymatt
Celebrity
A
aymanmthabet
asked in Transformers
convert scanned jpg drawing to dwg

hi sirgood daykindly could you confirm if you have software to transfer scanned drawing from JPG to DWG; so i can re modify the drawing. if yes, can you tell me the price of licencing.

1150
J
A
aquamarine
asked in Transformers
Microsoft SQL Server geometry issues

Hi, I am trying to read point geometry from a Microsoft SQL Server database and the geometry is displaying in the 'Geometry' attribute like the following example: 'C0FFD20FBC8CCF11ABDE08003601B769D9CEF75331C9F0405EBA490C1EABE44015AE47E17A746140'.I would like this geometry to display in the inspector but am having trouble working out how to do this.I have tried using the 'GeometryExtractor' transformer, first setting the 'Geometry Encoding' to 'FME Binary'. But this results in '3160A883220000000000' being output for every single record in the _geometry attribute and no geometry in the inspector.When I tried setting 'Geometry Encoding' to 'Microsoft SQL Server Binary' I got 'FFFFFFFF' for very record in the _geometry attribute and again no geometry in the inspector.Does anyone know what else I could try? It's my first time reading from Microsoft SQL Server in this way..Thanks!

4566
A
johanb
johanb
asked in Transformers
Can I use PythonCaller for Coverage/annotation import?

Hi! I hope you can help with this very basic problem of mine..(although too much to handle for me). So, what I want to do is load data into a sde database. It´s annotations, in coverage format. And what I have seen so far of the result when I only use a simple ”in-data to out-data”-workspace in FME is that the texts don´t end up in a correct way. There are overlaps for example. Then I thought that the only way to do it correctly is with the ”Import Coverage”-tool in ArcGIS. So I created a simple Model Builder model which I then exported to a python script. Below is a screen shot of the model and further down is the script. Script from model export:# Import arcpy moduleimport arcpy # Local variables:tx_24_annotation_tx_24 = "D:\\\\Vagkarta\\\\Shape\\\\vk_24_Sweref_99_TM_shape\\\\vagk\\\\24\\\\tx_24\\\\annotation.tx_24"tx_25_annotation_tx_25 = "D:\\\\Vagkarta\\\\Shape\\\\vk_25_Sweref_99_TM_shape\\\\vagk\\\\25\\\\tx_25\\\\annotation.tx_25"sde_gsd_GNG_vk_tx_anno_modelb

90
johanb
F
ferorelatum
asked in Transformers
Lookup table to find nearest smallest value

Hello!I have two tables:Table 1:NameBasevalueaaa0bbb0bbb5bbb11ccc0 Table 2:NameValuebbb3bbb8bbb10ccc8 Now I want to get for each feature from table 2 the nearest smaller 'Basevalue' from table 1 compared to the 'Value' of table 2.The Result should look like this:NameValueResultValuebbb30bbb85bbb105ccc80 Any ideas how to do so?GreetingsStefan

174
F
fme_hans
Contributor
fme_hansContributor
asked in Transformers
Convert Lat/long coordinates to EPSG:28992

Hi, I have a csv file with some coordinates in the following form: Cordinaten gps longitude ; Cordinaten gps latitude 4.438.469 ; 5.186.713 How can I convert this to EPSG:28992? I've already tried the Reprojector, AttribureReprojector and CsmapAttributeReprojector but that didn't help. Thank you in advance.  Greetings, Hans

2490
fme_hans
Contributor
ebygomm
Influencer
ebygommInfluencer
asked in Transformers
Character encoding - ANSI = iso-8859-1?

The shapefile writer (2015 vintage) used to have an option of character encoding - ANSIWhat did this actually mean, iso-8859-1?

13997
ebygomm
Influencer
nicholas
Contributor
nicholasContributor
asked in Transformers
WGS4 epoch?

Does FME recognise different epochs for WGS84?

120
kailinatsafe
Safer
G
georiki
asked in Transformers
how to convert ESRI annotation to Line feature

Hi, I want to convert ESRI annotation (ESRI geodatabase ArcSDE) to line. (I don't mind if I get the underline insted of the centerline)I've try the EsriAnnotationRenderer transformer and even if the annotation have underline, it only return the text. I've also try the GeometryCoercer transformer but it doesn't work with text.is there a way to do this ? Thanks   

330
gio
Contributor
S
smcd84
asked in Transformers
Break Line into Segments and Assign Sequential Order Attribute from Start

Hi,I would like to break a line into segments and then assign a sequential order attribute starting at the start of the line.For example, in my screenshot, if I break the line into 500m segments, I would like section 1 to go from the start point to 500m, section 2 to go from 500m to 1000m, and so on to the end of the line.I've tried using the iterative snipper and the chopper to break the line but the problem is that they both output the line segments in a random order.Would anyone know how I might do this?Thanks. 

4640
S
J
johsflesj
asked in Transformers
Tester based on inputs from file

I have a FME project reading information from an API and writing to an excel file. In the project i have a tester that tests if the data belongs to a certain organization. The organization list might expand, so I want the tester read this data from a (excel) file. How can I do this? Can I loop the project from the tester and write to different files?Thank you for any views on this.

250
J
lambertus
Enthusiast
lambertusEnthusiast
asked in Transformers
LineOnLine overlay - 1 milion lines versus 1 line

 First datasetI created about 1 million lines between 1565 points. These points are locations and the lines are possible routes over a network between the locations. Many of these lines (=routes) overlap each other. This is my first dataset.Second datasetMy second dataset consist also of lines. Part of these lines have an attribute value for attribute 'VWH' = 1. The other lines have a value of 0, VWH = 0.AnalysisWhat I want to do now is to perform an intersection between the first and second dataset. For the second dataset the features are used where VWH = 1. Using the VWH =1 features I want to intersect dataset 1 and attach the VWH value to overlapping lines. See the figure below for the main idea.First I dissolved dataset 2, for VWH =1, into one multipart feature using the LineCombiner followed by the Aggregator. The length of this multipart line feature is 7684 km.Then I used a SpatialFilter to check which features of dataset 1 intersect the multipart feature.Then I tried di

140
lambertus
Enthusiast
sfb
Contributor
sfbContributor
asked in Transformers
Using regex select a full single line of text before a match

I have a block of text separated by newline characters, e.g:Some TextSome More TextEven More TextPERIOD: 01/01/1990 TO 12/12/2020What I'm attempting to do using regex is grab the entire line of text preceding the row beginning with PERIOD (i.e. "Even More Text"). In an online regex editor, the following expression successfully returns just the line containing "Even More Text":^.*$(?=\\nPERIOD)However, when I attempt to do the same in FME, it returns all lines above PERIOD. It seems as though in online editors the . includes all characters except newlines, whereas in FME it includes them? Is there a way to adjust multiline regex flags (or some other workaround) in FME to get the desired output?

13755
sfb
Contributor
D
dmesserich
asked in Transformers
Looking for simple templates

I am new to FME. Is there somewhere I can download basic templates of FME projects? I am currently looking for something to count the number of files / folder in a Windows directory. I assume that is pretty basic, but I have no idea how to start. After I locate a simple template I can take it apart and learn more on how to create my own.Thanks,Dan

120
chrisatsafe
Contributor
M
marekszczepan
asked in Transformers
Raster band combine two rasters

Dear all,I need help with task. I have two rasters grom the same place: NIR 1 channel and RGB 3 channel.  I need to replace on RGB raster Red channel with NIR channel and save raster.  How can i do this? Thank you on advance for help

870
M
benvk
Contributor
benvkContributor
asked in Transformers
Can we move centerPointReplacer points to a common end of the polygon that created them?

Hey, currently I am using a centerPointReplacer to create points in the middle of cemetery plots (polygons), that meet a certain criteria (they have a photo attached to them). The points are being created in the 'Centre of Gravity Point', it works well, see black dots below, they are all in the middle of our graves:As you can see, the labels of these cemetery plots are covering the dots (or close to), and I am wondering if there is a way I can consistently move these dots to be offset, towards a common narrow end of the polygon? I dont want to use a random spot, as these will not be visually appealing, so I am hoping to move the dots to be along a common side, something like these red dots:If I can achieve this, the labels will all fall back in line and be more visually appealing.To make thinks even more difficult, I should mention that our plots are not all rotated to the same angle, they can face any which way you can think of: Has anyone had any experience doing something li

170
M
P
pascalfilippi
asked in Transformers
Problem Installing FME Desktop i have this error " pascal.filippi is a invalid short name files"

i have a Problem with the Installing of FME Desktop i have this error " pascal.filippi is a invalid short name files"

410
fgiron
Supporter
nedwaterman
Contributor
nedwatermanContributor
asked in Transformers
Generate Same Random number for sample of data

I have an odd request. My user has a data set of 758 records. They want to sample 450 of these randomly.I've completed this using a sampler with a random sampling. However, the client wants to add further columns of data to the existing random sample.If I rerun this workspace.I'll generate a new random set of data than before. How do I add a random number to a row, but keep this created number so that when I run the workspace again I get the same sample as before? Thank you!N

110
jdh
Contributor
T
tkngoualadjo
asked in Transformers
SVP j'aimerais récupérer le résultat json de cette API insee via le transformer HTTPCaller @david_r

  j'ai débuter sur ce workbench mais qui ne marche pas exactement

1340
david_r
Celebrity
1
123beaches
asked in Transformers
How to add a new attribute showing an existing attribute as a percentage of that columns total value?

I have a table with integer values as one of the attributes. I need to add an attribute to represent these values as a percentage of the total of these values like in the table below. have thisneed thisvaluepercentage of total617.64705882411.76470588617.6470588238.82352941225.882352941617.64705882720.58823529  I figured ExpressionEvaluator is correct approach but Im pretty new to fme and cant see how it's done. Any help much would be much appreciated, Rgds

980
1
dvanriel
Contributor
dvanrielContributor
asked in Transformers
Any idea why FME can't read this AutoCAD file?

I have an AutoCAD file with many layers and some object data tables (ODT). FME crashes when I try to read it as a Map 3D file. I can't find out what the reason for the crash is, and it reads fine when using a regular AutoCAD reader. When I export out the objects that are just on the layers I need (most of the PR_* layers) I can then read the file as a Map 3D type. I can't tell what is causing FME to crash on the original file. I can't even read the file contents as a Map 3D type.I don't want to have to export out the needed layers all the time, what if the issue is on the needed layers next time, and I am setting up a Server app for users to use and I can't expect them to create separate files all the time.My current FME version is 2020.0.0.1 (20200316 - Build 20202 - WIN64), but I was testing an old AutoCAD file for the Server app, and it ran successfully through an older FME version back in February, but can't now.Can someone tell me what is causing FME to cra

1960
chrisatsafe
Contributor
M
majdi.turkman
asked in Transformers
How to Populate Values of a Published User Parameter of Type Choice Using Scripted Python Parameter

Hi,Is it possible to populate Values of a publish user parameter of type choice at runtime using scripted Python parameter or using any other approach?

100
M
philippeb
Enthusiast
philippebEnthusiast
asked in Transformers
Modify a survey list automatically from a file with values

Hi there, With Covid, all our employees going to work need to fill a survey about their health status now. Every day. It's the same for kids going in summer camp for activities. So we've been asked to develop a survey that could change in time, depending on the kids that subscribed to the activities. The subscribed kids are exported into an Excel file every week. For the same activity, one week it could be 40 kids, the next one it could be 80. I thought to read the file with FME and push the kids into the survey every week. That way the list of kids in the survey could change without our help. And the kid (or his parent) could select his name to fill the survey. The issue is that we don't know any survey plateform able to change automatically from a script. Do you know if any kind of plateform could change when FME push new values into it? Survey123, Microsoft Forms, SurveyMonkey or something else? Thanks.

280
mark2atsafe
Safer
aron
Supporter
aronSupporter
asked in Transformers
Retime gpx-files

I need to set new timestamps to a set of polylines that is to become gpx files and have two questions:1. How do I set what end is the begining of the line?2. Is there some way to start the timestamp at a specified time? Say I wanted it to begin at 01-01-2000?

100
danilo_fme
Evangelist
J
juanrodriguezso
asked in Transformers
Polygon to Multipolygon (FME 2018.1)

Hi. I have seen a thread in which they explain that for converting from polygon to multipolygon you only have to choose the geommetry type in the writer parammeters (on FME2019). The thing is that I can't see that option. Is multipolygon not available on FME 2018.1? If not, how can I convert a polygon to a multipolygon? Thanks! 

3880
J

Badge Winners

  • Student (Grey)
    ibrucehas earned the badge Student (Grey)
  • Welcome Back
    satyam17has earned the badge Welcome Back
  • FME Flow Authoring Training
    alyssauatsafehas earned the badge FME Flow Authoring Training
  • Integrate Data with the FME Platform Training
    satyam17has earned the badge Integrate Data with the FME Platform Training
  • Welcome Back
    lizsanderson21has earned the badge Welcome Back
Show all badges

Community Stats

31,813
Posts
120,830
Replies
39,443
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.