- - Community Resources
Ideas
Product Updates
Events
Blog

EN

Home
Search

Unanswered questions

19433 Posts

Recently active

Most views Most replies

fmelizardContributor

asked in Transformers

Using SchemaMapper to Map Data into an Existing Schema

Hi, I'm able to figure out how to map a single feature coming from one schema to an existing feature of another schema using the Schema Mapper tranformer. The problem that I'm having is how to map the rest of the features using the same SchemaMapper transformer without having to create one for each feature that are within the two schemas. Here is schematic of what i'm trying to do. Note that the Out feature already exist in the output schema. RoadL ------------------------> | |-------------------------> RoadL_Out RiverL --------------------------> | SchemaMapper |-------------------------> RiverL_Out SandA ------------------------> | |-------------------------> SandL_Out What's happening for me is that the total number of features from the incoming schema are being inserted into each of the output features. That is, if the total number of the road (200), river (700) and sand (100

sigtillContributor

Removing FFS extended dataset files from the directory '' left no remaining datasets likely due to naming conflicts.

Removing FFS extended dataset files from the directory '' left no remaining datasets likely due to naming conflicts. Try renaming the source dataset files to avoid names like <basename>_<number>.ffs to avoid conflicts. Note that the FFS reader is sensitive to all files in the source directory and not just the selected files Not sure how to solve this. I have split the 500 files into 5 subfolders with 100 files in each, and that seems to solve the problem. Is the problem the number of files selected per Reader? If the Reader could not open all the files it should abort - and not let me "think" that all files are selected. Not easy to discover when you merge many files into one large one.

jdhContributor

asked in Authoring

Palette Name

How do I change/or add a Palette Name of a raster?

writing features to a postgis database after using FeatureMerger

I want to merge a shapefile and a dbf file joined by an attribute and write them to a postgis database. Is FeatureMerger the way to do this? How do I extract the merged feature information (i.e. all the merged attribute metadata) and provide it to the postgis writer so that the correct table structure is created for the merged feature type?

asked in Authoring

How can I View my stored data on Oracle with FME Universal Viewer 32 bits

Hello Im trying to View my stored data on Oracle with FME Universal Viewer 32 bits. I have installed Oracle_Client 11g 32 bits on my PC. Also I have Win 7 64 bits When Im Trying to did it, it sent this message: Error connecting to Oracle database: message was `ORA-01017: invalid username/password; logon denied'. (serverType=`ORACLE8i', serverName=`orcl', userName=`itu', password=`***', dbname=`') Failed to open database with username='itu', retrying using uppercase username Environment variable ORACLE_HOME is not set.

asked in Transformers

Adding centroid fields

I want to compute a centroid for polygons then add the X and Y fields to my features. I could not find any way of doing this in FME desktop as I have it. Can anyone suggest how I might do this please?

fmelizardContributor

asked in Authoring

FME truncate fails

Is there a known issue concerning FME (in my case 2011SP4 and 2012SP3 aswell) about not being able to truncate Oracle base, stating: Truncating table `EESTITOPO.HYB_VOOLUVEED_75T_J'... Failed to truncate table `EESTITOPO.HYB_VOOLUVEED_75T_J'. Table may not exist However, when truncate is defined in the "SQL To Execute Before Translation" under advanced writer properties, then truncate operation succeeds. Thank you, Raivo Alla Estonian Land Board

fmelizardContributor

asked in Transformers

FME 2013 DWG additions

Hi, I was going throught the whats great in FME 2013 and came across this: "Added new template files to (FME_HOME)\\autocad directory, both of which have AutoCAD standard line type definitions loaded in them (PR#36706)" Does it means that FME 2013 will have the ability to create line types other that continous? as is the case with FME 2012. Also will I be a able to set the dwg line type from input attributes stating the desired line type? That would be great! Cheers, Itay

asked in Authoring

Warning: not all FMESessions that were created were destroyed before shutdown. This may cause instability

??Windows?????????: fme.exe wb-xlate-1353554731187_5952 --SourceDataset_MapGis6x """""C:\\Documents and Settings\\Administrator\\My Documents\\1.WT"" ""C:\\Documents and Settings\\Administrator\\My Documents\\1.WP""""" --DestDataset_MapGis6x "C:\\Documents and Settings\\Administrator\\My Documents" ???? ... Feature Manipulation Engine 2012 SP2 (20120417 - Build 12238 - WIN32) FME_HOME is 'C:\\Program Files\\FME\\' FME Desktop Professional Edition (floating) Permanent License. Machine host name is: fangjun START - ProcessID: 904, peak process memory usage: 26024 kB, current process memory usage: 26020 kB FME Configuration: Command line arguments are `C:\\Program Files\\FME\\fme.exe' `C:\\DOCUME~1\\ADMINI~1\\LOCALS~1\\Temp\\wb-xlate-1353554731187_5952' `LOG_STANDARDOUT' `YES' `LogCount' `C:\\DOCUME~1\\ADMINI~

asked in Authoring

Dynamic Reader Based on Today's Date

Hi, is there any way we can bring in an input file based on today's date? For example, if we save a file from a database every day, and today's file is called "20121114_Switch_Data.xlsx" can we have a default input (reader) to prepend today's date and grab the latest file?

asked in Authoring

Trace a single feature through a workbench

Hi, I'm trying to debug a workbench and was and was wondering if it's possible to see the flow of one particular record. About 85k records (all with a unique ID) go into the workbench and flow through a network of transformers before all coming out via a single writer. I have identified several features that have been processed incorrectly but in order to work out what went wrong I need to work out the path they took through the transformers. Any suggestions on how to achieve this? Thanks

asked in General

FME justification

Hello FME Community, I have been looking at FME for some time and have been contemplating putting together a purchase justification for management. So, I have searched all over the website and done many Google searches, but I am having a hard time finding any concrete quantitative benefits or value statements to use in my justification. As well, I could also benefit from some information on ownership stats. For example, I work for a city gov't in Vermont. Does anyone know if other local cities own FME or if there are any other FME installs in Vermont ? So long story short, I want to buy FME but need some ammunition to justify the purchase. My bosses have no idea what I do (or really care) as long as they get their maps. So, any simple / high-level ammunition would be greatly appreciated.

jdhContributor

asked in Authoring

Custom transformer dynamic attribute name

What is the best way to specify the output attribute name on a custom transformer? I can add a paramter , but the logical transformer (AttributeCreator) let's me link the value of an attribute easily enough, but not it's name.

asked in Transformers

coordinateConcatenator bug?

Hi, is there a bug in the ouput of the coordinateConcatenator ?: last 2 couple of coordinates are glued together in the output string attribute whatever the delimiter is. Other coordinates pair (or trio) are well delimited though. This is very annoying for further pyhton operation (seems awckward to put a test or an error checking for something that's aobviously a bug). On FME 2013 beta but also 2012. Did anybody else seen this ? Thanks

How can I migrate Intergraph Warehouse data to Oracle Spatial Object with FME ?

Can you have a Step by Step manual that explains How can I migrate data (Intergraph Geomedia Warehouses) using FME to Oracle database (Oracle Spatial Object) ? Remember that Intergraph use GOOM Package for storage on Oracle. Have FME an alternative ? I appreciate your valious time. Regards, Iturbides

sidraParticipant

Formatting attributes when converting from an ArcGIS dataset to KML

How do I set attribute symbology when converting from and ArcGIS dataset to KML? Can it be done during the conversion process through FME, or do I need to format the KML file after conversion?

Converting ArcMAP text to AutoCAD Multi-line text

Hello folks I trying to find away to convert ArcMAP text to AutoCAD Multi-line text. Is this possible with FME?

Update a file geodatabase using dynamic readers and writers

I have an 'update' file geodatabase and a 'destination' file geodatabase. I want to replace an existing feature class in my destination file geodatabase with the updated version from my update file geodatabase. I am using dymanic readers and writers. Usually when I do this with shapefiles I chose to truncate the table and it works fine. However, this doesn't seem to be working for my file geodatabase. The new features from the update file are being added to the existing features (i.e. the existing features remain in the file geodatabase). Is this to do with using file geodatabases (the writer mode can't be set for file geodatabases as it can be for SDE writers), or is it to do with using dynamic readers and/or writers? Can this be resolved?

mark2atsafeSafer

asked in Architecture

FME Server Download Humouring

Hi all, Less a question, more an answer. I know this came up on FMETalk, so I wanted folk to know that we added a "humouring" device to FME Server in 2013. Whenever you run a data download/job submitter process, you get a spinny wheel thing with an elapsed time counter. Hope this is useful Cheers Mark

michaelParticipant

ArcGIS Data Distribution demo issue

I'm attempting to standup the demo ArcGIS Server data distribution application. I configured the workspace and can successfully run it from Desktop and from the FME Server Web User Interface. However, when I attempt to use the web application itself (arcgis.html), the Step 2: Set Parameters form which is supposed to be dynamically generated based on the REST API is not populating. For reference, this is what I'm tying to do: http://fmepedia.safe.com/articles/Samples_and_Demos/Standalone-data-distribution-demo-ArcGIS-Server Michael

fmelizardContributor

Proper use of the OSM reader?

I'm trying to load OpenStreetMap using FME. This works great with small datasets in 2012, however as soon as I start playing with large datasets (millions of features) I hit the problem that the FME OSM reader acts as a grouper - it reads the entire dataset in before it actually trys to translate everything. Does this have to happen? Is there a way to disable it or is this a limitation of the XML reader? It's massively slowing down everything because even with 32GB of RAM, FME is still filling it up and then writing to temp disk space (despite the original dataset only being about 7GB uncompressed). Using 2012 SP4 64bit. 2013 13206 is 5.5 times slower on the small dataset, so not using that despite changes in #13082 to make "it better with large datasets" - not sure what that means.

asked in Transformers

Oracle/SDE sequence increment

I have an SDE environment with Oracle and am trying to append rows to an existing table. The primary key is defined in the database by an auto-incrementing Oracle integer sequence. Normally for a Postgresql or Oracle writer, setting the key to strings like 'DEFAULT' or 'MYSEQUENCE.NEXTVAL' act like they would in SQL. However I have not been able to get the SDE workbench writer to operate in a similar manner. When using a 'MYSEQUENCE.NEXTVAL', FME tries to be smart and do a schema check -- it won't allow writing a string to an integer field. If I try not populating the attribute, FME complains that the NULL constraint on the PK would be violated. I also was going to try a hack to read in the max key value with the intention of having an FME counter set each subsequent value. However that won't work because the equivalent of a mapping file @SDEsql call doesn't exist in workbench. Suggestions on how to do this or other approaches to try out woul

jdhContributor

Exclude files from batch

Hi all is there anyway to setup an exclusion filter on a reader? I need to run a script about a thousand times with each file in a seperate directory. Normally I would just put a merge filter on the featuretype (*) and have the reader parameter be rootdir\\**\\*.xml. However in this case each directory contains two xml files, one always called metadata.xml and the other is different for every directory. I only want to read the xml file that changes, not metadata.xml. Ideas?

asked in Transformers

Merging Polygon Data

What transformer(s) do I need to merge two polygon layers together where the coincident polygons would have both their original attributes and the attributes of the other polygon? Thanks!

asked in Transformers

SQL Executor

Hi! I'm having a hard time getting SQLExecutor to interpret a SQL string from published parameters. However if I paste the exact same string directly into the transformer it executes without problem. Any ideas why??? The WHERE clause looks like this when i execute the workflow WHERE ST_Contains(ST_GeomFromEWKT('SRID=32633;POLYGON ((183044.6766 6488587.2041,172720.1045 6526144.3677,205500.5582 6546330.9112,215416.0671 6503714.6016,183044.6766 6488587.2041))'),the_geom32633) and date >= driftsutslipp.date_to_int(date '$(date_from)') and date <= driftsutslipp.date_to_int(date '$(date_to) And the Error is: Error executing SQL query: ............................[edited ] WHERE ST_Contains(ST_GeomFromEWKT('SRID=32633;POLYGON ((183044.6766 6488587.2041,172720.1045 6526144.3677,205500.5582 6546330.9112,215416.0671 6503714.6016,183044.6766 6488587.2041))'),the_geom32633) and date >= driftsutslipp.date_to_int(date '$(date_from)') and date &lt

1
...
773
774
775
776
777
778

Page 776 / 778

Badge winners

tivixiaomigiatohas earned the badge English Speaker
olympiadoshas earned the badge Student (Grey)
nicol.riccihas earned the badge Teacher (Grey)
syahrastaniahas earned the badge Teacher (Grey)
b-radhas earned the badge Teacher (Grey)

Show all badges

28,809: Posts

Powered by Gainsight

Terms & Conditions Cookie settings

Sign up

Already have an account? Login

An FME Account is required to contribute

Login

Login to the community

An FME Account is required to contribute

Login

Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.

Username or e-mail

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.

OK

This file cannot be downloaded

Sorry, our virus scanner detected that this file isn't safe to download.

OK

A product of

Company Products Giving Back Careers Contact 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.