Skip to main content
  • EN

Best Answers

10379 Posts
D
dewan
asked in Transformers
Group-by and Increment in MDB (Non-Spatial)

Hi,  I have an MDB file with a SourceID, its SequenceNumber and PositiveResponse as in the below image:  SourceID SeqNum PosResI want a new column OUTPUT having the sequence 1,2,3,4,5,... But, the count should start where SeqNum=1 and PosRes=0. So, it would be like- SRCID SEQNR POSRES COUNT 5126350015700451 01 1 5 5126350015700451 02 1 6 5126350015700451 03 1 7 5126350015700451 04 1 8 5126350015700451 01 0 1 5126350015700451 02 0 2 5126350015700451 03 0 3 5126350015700451 04 0 4  I have tried using Sorter, Matcher, StatisticCalculator, Tester but I am not able to collect the output.   Thanks in advance. 

98
takashi
Celebrity
T
tomcrumbleholme
asked in Data
Batch load files of different types perform different action depending upon type

Hello I am brand new FME this week and am intrigued by it's non spatial data integration possibilities. I have a variety of csv files to process. I know explicitly how the header of each file is setup so would like to be able to test for certain conditions i.e. 1st two rows blank and (row 3 column 1 = 'Datetime') is Filetype A if successful this will go forward to relevant workspace runner for that filetype so I can do the required processing. Is it possible to test the structure of CSV before determining how to process it? Thanks and kind regards

611
mark2atsafe
Safer
L
loren
asked in Transformers
Is there a transformer to calculate the maximum enclosed rectangle? MER for label placement?

I'm not looking for bounding box.  Rather the largest, axis-aligned rectangle that fits within the polygon.  Does this transformer exist?  If not, I can provide logic to implement.  Please let me know.

313
gio
Contributor
K
kouri1986
asked in Data
I get an error saying saying my shapefile writer cannot be over 2gb

How do I write a shapefile that is larger than 2gb? It has to be possible right?

133
fmelizard
Safer
erik_jan
Contributor
erik_janContributor
asked in Architecture
Is the license server for FME 2016 going to change?

I heard the license server for FME 2016 is going to change from FlexLM to Docker. Is that correct? And how is that going to affect plugins running on FlexLM licenses?

23
fmelizard
Safer
A
aburns
asked in Transformers
XML accessing attributes at parent level

Hi All XML Format as follows: <?xml version="1.0" encoding="UTF-8"?> <Flows><SCN> <SystemCodeNumber>N11111J</SystemCodeNumber> <FlowType>Scoot</FlowType> <ShortDescription/> <Northing>0.00</Northing> <Easting>0.00</Easting> <Flows> <Flow Date="2015-05-03 05:08:35">1.0</Flow> <Flow Date="2015-05-03 05:13:35">4.0</Flow> etc. I am accessing an XML file as a single merged feature type as i would like an output as follows: SystemCodeNumber,Northing,Easting,Speed,Flow,Date N11111J,0.00,0.00,,1.0,2015-05-03 05:08:35 N11111J,0.00,0.00,,4.0,2015-05-03 05:13:35 N11111J,0.00,0.00,,1.0,2015-05-03 05:18:35 N11111J,0.00,0.00,,0.0,2015-05-03 05:23:35 as so on. I am getting the elements i want: and flattening the elements: not the output is fine, im getting what i require out: I have my SystemCodeNumber, Easting and Northing ou

106
takashi
Celebrity
J
james_websoft
asked in Transformers
Matching an ID to another data set

So,  I have one data set that has some attributes that match another data set, I simply want to find out what records in data set 1 have a matching record in data set 2.   So I have used the "matcher" transformer and a bunch of matched results get spit out of the "Matched" port but only about 60 of them are from data set 1 and when i look at the data and manually search for a match in data set 2 there is not always a match.   This seems to happen in "NotMatched" also. The matcher is clearly doing something i dont understand.  What is that matcher doing to end up with this result? Is there a way to just have FME report back that X record from data set 1 has a match in data set 2?

3403
B
A
aquamarine
asked in Data
Migrating Access Database to Oracle

Hi,   I have an Microsoft Access 2002 database with a number of look up tables and was wondering how I would go about migrating this to Oracle using FME 2015 while keeping the relationships between the main table and the look up tables.  Thanks 

122
takashi
Celebrity
K
kouri1986
asked in Transformers
Exposing attributes from Spatial Relator

I used a spatial relator for a project to show counties that state parks are in. After the spatial relator complete it gave me attributes _relationships(0).name and so on and the I have a few names for each park since the parks go into multiple counties. But when I write the end files out the _relationship().name attributes are emplty. On the FME data inspector it has values 

311
roland.martin
Contributor
A
arjanvanzutphen
asked in Architecture
Publishing 32-bit workspace to a 64-bit FME server

Can you publish a 32-bit workspace to a 64-bit FME server

41
david_r
Celebrity
lavairye
Contributor
lavairyeContributor
asked in Transformers
Generating large amounts of random numbers

Hello, I have a file with a huge number of feature (points) and I want to affect random values for them. I use the TrueRandomIntGenerator transformer to do that, but this transformer is limited (no more than 10000 feature). How can I do to handle the file by blocks of 10000 elements?

118
david_r
Celebrity
E
ersc
asked in Transformers
Alphanumeric sorting in ListRangeExtractor

I have list attribute list{}.lbl, where lbl has these (alphanumeric) values 3A,5,7,9,11,13,15. I need the smallest (3A) and largest (15) value. ListRangeExtractor give Resulting Minimum Attribute 3A and Resulting Maximum Attribute 7. I suppose ListRangeExtractor and I don't fully agree on sorting order of alphanumerical values, it seems like it prefer to sort it either numerical (3...15 works fine) or alphabetical. Does any expert user have a suggestion or workaround to solve this list issue? Thanks! 

445
E
V
vijai
asked in Data
Extracting XYZ for linestring and writing to excel

Kindly need help to extract XYZ for each vertex of linestring (CAD) to a excel file along with the attributes (layer name, first point, end point, color, )

509
V
A
Anonymous
asked in Data
Save images folder in KMZ output

I am using the KML writer to save output as KMZ by specifying Destination KML Dataset as "myoutput.kmz". This works, but I have an icon referenced in the KML output in the Icon->href tag as: images/D2.png  How can I add the images/D2.png folder and file to the output KMZ?  Thanks

905
A
G
goatboy
asked in Transformers
remove attributes via where clause on read in

Morning All,   Im reading in very large esri featureclasses but just need the geometrys, not attributes, It has 24 attributes that are read in with the geom. Is it possible to limit the reader to just bring in the geom not the attributes. Will this provide better reader speed/performance than using a attribute remover as my first transformer?. i was thinking of some sql in the reader "where clause" ?? thoughts/ suggestions , thanks Steve

103
mark2atsafe
Safer
K
kouri1986
asked in Data
How to break down a JSON message

So i have been going through tutorials and JSON documents on safe.com and I cannot figure out how to bring out the attributes I need from this for my workbench. I am getting this http call in json format and I want to get this down to working with these attributes  action, custom_1, height, class, MATL_TYPE , F_ID, POLETYPE, F_ROUTE, F_O, F_Y, EMINY, EMINX, DATABASE_NAME, DESIGNATION, objectType  I cannot figure out the procedure to be able to pull these attributes out and their values to work with in my workbench. Any help would be appreciated. The original message is below.  MESSAGE:  {"action":"CreateOrUpdate","instance":{"fields":[{"allowNull":false,"allowUpdate":false,"targetField":"custom_1","value":"5b8e3770-cf35"},{"allowNull":false,"allowUpdate":false,"targetField":"height","value":"2"},{"allowNull":false,&

135
K
sigtill
Supporter
sigtillSupporter
asked in Transformers
Buffer question

Is it possible to create a negative buffer from an line (not area)? And is it possible to create a left-buffer from an area? 

71
takashi
Celebrity
E
egaru
asked in Data
After removing arcs: Automatic simplification of the geometry (for PostGIS etc.)

Hi FME community  Spatial objects in FME that include arcs consist of several segments, each belonging to an arc or a subsequent series of straight lines. When you use the transformer ArcStroker to get rid of the arcs, you still have these separate segements (whereby each of them belongs now to a series of straight lines).  When you write these objects (polygons in my case) into PostGIS, they are automatically stored as "CurvePolygon" which cause problems. It needs a lot of transformers to decompose (donut-)polygons into their individual buildings blocks and to rebuild them.  My question therefore is: Is there a transformer or parameter to set so that the required simplification of the object's data structure after removing arcs happens automatically? If not, it would be desirable that Safe Software introduces this Feature in future Versions of FME. I mean are there any reasons to keep the polylines separated by segments after the removal of arcs?  Greetings, Andre  

1122
E
nic_ran
Contributor
nic_ranContributor
asked in Authoring
FMX file default open behaviour

The default behavior for double-clicking an FMX file is to "install" the custom transformer. It seemed that for a while I had double-click set up to open the transformer for editing, rather than installing it, but now it's reverted back to installing with my latest FME (2015.1.2.0 (20150911 - Build 15538 - WIN64)).  Can this behavior be changed? I never need the custom transformer installed because I keep them all in a shared directly. If I double-click it I'm always going to want to edit it. Additionally, because the default behavior is to "install" I can't open alternate versions from our version control system for editing because it always tries to "install" the version, rather than editing. 

1014
nic_ran
Contributor
jorge_vidinha
Contributor
jorge_vidinhaContributor
asked in Data
PostgreSQL and materialized views.

Is there something needed to be done on db side so that FME can read PostgreSQL Materialized views , or this is something not possible to do ? Thanks, Jorge Vidinha

606
jorge_vidinha
Contributor
peteralstorp
Contributor
peteralstorpContributor
asked in Authoring
Using the PythonCaller to extract substring between two known substrings

  Hello, fellow FMEers.   I'm very new to Python and to the PythonCaller, but we all need to start somewhere. I have wrestled with this problem basically all day and I still don't get it to work.   I have a textstring "A=0,5m, B = Bredd 0 m, C= Reduktionstal". From this string I want to extract the value between "Bredd " and " m" - in this case it is 0, but in can be 10, it can be 10.2.  I'm attaching an image of my progress so far... And the PythonCaller script so far: import fme import fmeobjects import re  def FeatureProcessor(feature):  substr = re.search('Bredd (.*) m', feature.getAttribute('text'))  feature.setAttribute("substr", substr)  I have often come across this problem and I really want to learn how to solve it. Pls help!  Peter

2211
david_r
Celebrity
Q
qaisarz
asked in Transformers
DB2 Connectivity

Hi I am running FME 2015.1. 32 bit on Windows 10, 64 bit I want to connect to IBM DB2 Non Spatial database, is there any special configuration?  regards Nadeem 

161
david_r
Celebrity
R
rodscott
asked in Automation
How is file deletion of data download service in default result directory configured?

DataDownload service zip files are being deleted from the DefaultResults directory before users have downloaded them. How can the file deletion time be configured to allow longer to download the file?

61
sigtill
Supporter
S
smurf
asked in Authoring
How can I force a workspacerunner to output through the failed port?

I have a workspace that is run from a workspace runner, the final thing it does is fire off a soap message to a web service, as long as it gets a response it determines the workspace to have been a success. I want to look at the response and if it isn't what I was expecting I want the workbench to output through the failed port of the workspace runner. I am hoping there is some kind of flag on the workspace that I can change to cause it to output through the fail port?  Any help much appreciated  Regards  Jim

132
sigtill
Supporter
offermann82
offermann82
asked in Authoring
Why doesn't FME 2015 (64bit) use more memory on a virtual machine with dynamic memory management?

I am running fme 2015 (64bit) on a virtual machine. The Hyper-V server works with dynamic memory management, this leads to nearly 80% memory "blocked" by the hypervisor. In theory, the hypervisor should unblock more memory to the virtual machine, when a process like FME needs more memory. But instead, the FME optimizes its memory before and this leads to FME.exe process running with a limit of 200 MB on a virtual machine with 8 GB RAM. This only occurs using FME 2015, I did not have this behaviour running FME 2014. May be the Resource Manager improvements in 2015 are a problem?  UPDATE following @david_r 's suggestion, the fme.exe process gets more memory when using "FME_ENGINE_MEMORY_REDLINE 1", but a smaller value than 1 does not work to get more memory. Let's see what happens when the process hits the ceiling...  UPDATE Our IT has risen the minimum RAM of the virtual machine to 4 GB, this seems to solve the problem. The FME process is now using more RAM w

5611
fmelizard
Safer

Badge Winners

Show all badges

Community Stats

31,796
Posts
120,781
Replies
39,411
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.