Skip to main content
  • EN

Best Answers

10385 Posts
R
rob_f
asked in General
force table creation if table is empty

Hi,I export from Oracle (Spatial) to SDF. No tables are created in the SDF file if the table/view in Oracle doesn't contain data. The target application which consumes the SDF files expects a certain table structure - even if tables are empty. Can I force the creation of emtpy tables in writer?Creating a dummy data set in Oracle is not an Option.Many thanks, Rob

3497
R
F
flix
asked in Automation
FME Server 2013: Workbench name in e-mail notification

Hello  Before we got the FME server we used a Pyhton script in our FME workbenches to send email notifications to our customers. We sent information like: workbench name, input parameters, error logs, … FME Server has the built in email Notification. By modifying the Email template I was able to send the Job ID, number of written features, time started & time finished, … but wasn't able to send the workbench name. This would be the most important information. Is there a possibility to send the workbench name with the email notification tool?   Thanks for any advice. felix 

235
fmelizard
Safer
C
cg_ne
asked in Data
How can I create multiple tabs in an Excel Spreadsheet

Dear All, I am new to FME and have little experience but I am stuck on the below and hoping somebody will be able to point me in the right direction.Firstly, I have about 14 geo-database datasets that I am running through a clipper (for a particular boundary) and a number of other transformers before writing into an XLS. I want to find out which datasets apply to my area and produce a spreadsheet with multiple tabs, one for each dataset. Secondly I want to know how to select only certain attributes from the applicable layer in the geo-database.I would be greatful for any help offered.Thank you

4292
erik_jan
Contributor
C
chad
asked in Architecture
Connecting to FME Server PostgreSQL database repository

Hi,I would like to connect to FME Server PostgreSQL database repository throught pgAdmin.I could not succeed in making a connection. Is there any configuration changes required before being able to connect? Your suggestions would be appreciated.

2563
davideagle
Contributor
B
brianc
asked in Architecture
Export Schedule

Is it possible to export the FME Server schedule? I have looked through multiple FME Server folders, but have not found a file with the schedule. Adding such a feature could be beneficial. Thanks.

352
erik_jan
Contributor
sdepriest
Contributor
sdepriestContributor
asked in Authoring
How do FME users version their translation files?

We have FME ESRI Desktop edition, no FME Server, and want to start versioning our files so we can go back and see how an older version of a translation is configured.  Other than manually doing a save as in Workbench and renaming files, does anyone use a tool for versioning their translation files?  We have SubVersion in house, but are in the process of seeing if this will work for FME files.  We used Visual Source Safe in the past and Team Foundation Server, but both were clunky and we don't own them anymore.  I'm open to suggestions!  Thanks.

102
S
S
siriosus
asked in Data
What does mean "LOG: automatic vacuum of table "fmeserver.public.fme_jobs": could not (re)acquire exclusive lock for truncate scan"?

Hello,I faced with a problem while working with one workspace that I published on FME Server. Job aim is to accept mails with xml files and process them with extraction particular data and putting this data to a database (in my case Oracle). Everything works fine except that after some time job execution begin slow down, miss emails and even stops until you restart FME Server Database and FMEServer. I began to monitor Event logs and found that problems begin estimately after this event "LOG: automatic vacuum of table "fmeserver.public.fme_jobs": could not (re)acquire exclusive lock for truncate scan". If this could be a reason, is it possible to fix this issue? Thanks!

309
fmelizard
Safer
hermanlouie
Participant
hermanlouieParticipant
asked in Authoring
Transformer exposing file properties

I know there is a File/Directory Reader but I don't want to read the whole directory of files.I'm trying to find a transformer that I could use in the work flow that exposes file properties ie date created, date modified. Reading a polygon with an attribute "ABC123.PDF" and test with a FME Store FileExistenceChecker filter. If exists get the modified date of "ABC123.PDF" and push in an attribute.This should be possible with a PythonCaller or TCL but is there a Transformer I missed before I try to write one.

1121
takashi
Celebrity
D
dimmihel
asked in Transformers
Write logfile "ERROR" and "WARN" messages to a database table

Dear community,  My aim is to use FME desktop 2015 in our back-end infrastructure to perform quality control (QC) for data which remote users will be uploading to our server using our front-end infrastructure. To inform the users who upload the data on preliminary QC measures (i.e. are all necessary files present in a *.zip file which represents ESRI SHAPE?) I need to:(a) Collect the error and warn messages produced during the preliminary QC translation(b) Write the collected error and warn messages into a database table.(c) Use the data stored in the database table to dynamically inform the users on the fly on whether they need to re-upload the data (i.e. failed preliminary QC), or the data are good to go the next stage (i.e. passed QC).I want to achieve (a), and (b) using FME.I would appreciate any insights!

17713
david_r
Celebrity
E
ericarmitage
asked in Transformers
Search regex in Python caller

Hi. I'm trying to use a regex in the Python Caller transformer to search a string and return the search result to a new attribute. The regex works fine in the StringSearcher transformer but i'm getting a but stuck with the Python code. So far I have the following code. My table has an attribute called "text_line_data" which contains the string to search. I'm trying to extract the result of the regex search into a new attribute called PyTrackExtents but can't work out how to complete the code. Can anyone help?import fme import fmeobjects import re def AttributeExtractor(feature): TextLine = feature.getAttribute('text_line_data') feature.setAttribute("PyTrackExtents", TextLine) p = re.compile('.{13}\\..{8}\\..{8}\\..{4}') m = p.search("PyTrackExtents")

428
david_r
Celebrity
A
anete
asked in Authoring
AttributeFilter - possible attribute values - multiline

I have to filter out data based on a lot of values. Lets say, 50 values out of a 1000. I am using AttributeFilter for that and it works great, BUT it takes a lot of time and is extremely inconvenient to enter every attribute value and connect it. I could manage to copy many values from Excel, and when pasting them in I get something called 'multi-line' and I could connect only that one. It would be great if that would work. However, it doesnt. Plus judging from documentation Im not sure its designed for this purpose, but its not clear.Can somebody advice me something, please. Or explain the purpose of multi-line within AttributeFilter. Thanks a lot! P.S. I work with CityGML data.

435
fmelizard
Safer
G
gouthami
asked in Authoring
In the FME ,we have included python startup script. When we run it in FME 2014 version, it showing an error like : name 'dbCursor' is not defined.Could you please temme what would be the reason?

In the FME ,we have included python startup script. When we run it in FME 2014 version, it showing an error like : name 'dbCursor' is not defined.Could you please temme what would be the reason?

117
G
fmelizard
Safer
fmelizardSafer
asked in Data
KML Folders name, specials characters

I'm creating KML folders by using KML IDs approch (kml_parent and kml_id). The folders name are in French, so I would like to use characters like : é, è, à... but it doesn't work. I can change the folder name directly in the KML file but I would like to do it directly in FME. Is there a way to do this directly in FME?

282
fmelizard
Safer
M
marko
asked in Transformers
Feature reader Geotiff GCP interpolation NO data values

In the feature reader there doesn't appear to be a way of setting all values outside of an image to nodata whilst performing GCP transformations. I'm using a geotiff within a featurereader to read mapinfo projected tiff files. However, the resulting image (they are old maps so need to be re projected) should have a border of no data where the image is no long square. However, the feature reader fills this space with 0's not nodata. Is there a way of making the featurereader asign no data values during affine transformations?

84
M
M
m3
asked in Integration
FME objects api documents for java or .NET

Where can I get FME objects API document for java or .NET for development.I can only find the python API documents.Is anyone can help me? Thanks!

412
M
ebygomm
Influencer
ebygommInfluencer
asked in Data
.TAB rather than .tab

Does anyone know if it possible to get fme to write out tab files as .TAB rather than .tab

236
erik_jan
Contributor
J
james_rutter
asked in Transformers
How do I remove a non breaking space from an attribute?

Morning, I've had some feedback that an XML file produced using FME ( the file can be downloaded here )has created a problem whilst being parsed by Lxml. The error that's getting returned is "Unicode strings with encoding declaration are not supported. Please use bytes input or XML fragments without declaration." I've been told that this is referring to a non breaking space character.The XML file is a list of recent planning applications and for planning case 15/0779 the <casetext> tag seems to contain the offending character after the full stop at the end of the casetext description.I've tried the attributetrimmer to remove this but with no luck. Just wondering if anyone has come across this before and has worked out how to remove these characters.Thanks

4002
takashi
Celebrity
J
jhuillery
asked in Transformers
Extract z-values from TIN to points

I'm trying to extract z-values from a TIN surface to points where they intersect the TIN surface. This is a simple process in ArcGIS but I'm just wondering if there's a way to due it in FME without calling ARCGIS tools in my workbench.Thanks

1192
J
D
dimmihel
asked in Data
"Join" SQL statement in PostGIS reader

Dear FME community, Problem description: Attempting to run an inner table join between two tables using SQL within the FME PostGIS reader (i.e. under the "Format Parameters" tab in the "SELECT statement" form) does not output the correct number of records expected; in contrast to running the same query in the PgAdmin III Query window which outputs the expected number of records.Data: I use the Ordnance Survey (OS) AddressBase Premium data (EPOCH 36) which are stored in nine tables according to the OS documentation within a test environment PostGIS 9.4 database (localhost). A "geom" column including not null values and representing points is stored within the blpu table while the other tables although they have a "geom" column the values stored in them are null.SQL statement:SELECT DISTINCT dvp.uprn, dvp.dependent_locality, dvp.double_dependent_locality, blpu.geomFROM public.abp_delivery_point AS dvp, public.abp_blpu AS blpuWHERE dvp.uprn = blpu.uprn AND dvp.dependent_locality != ''Fe

485
D
andrew_r
Contributor
andrew_rContributor
asked in Data
FME2015 64-bit and ArcSDE30 Reader fix

Can someone help me with the best process for getting FME 2015 64-bit working with the ArcSDE30 reader?The process outlined in the knowledge base article on this issue (here) is rather cumbersome for a general FME user (one that isn’t also the SDE administrator).The knowledge base article calls for one to install the SDE SDK, however when I search the ESRI site I don’t see where I can get this.The only solution I could find was to download and install the ArcGIS Server for Windows software on my local PC. I was lucky enough that I’m high enough in my organization to have access to the ESRI downloads for their products, otherwise I wouldn’t have been able to do this.Does ESRI still make the SDE SDK?If so where is the download for it? Is there a plan to make this more streamlined with FME 2016?I would think that ArcGIS Pro would have the 64-bit DLL’s that FME needs so maybe you all could plug into that instead of requiring this rather hard to find install.

72
fmelizard
Safer
H
hughloughrey
asked in Architecture
Run fmeobjects on linux

So I have an FME workflow i need to run on a linux machine. I've managed to get the FME engine installed and i can run workbenches via the command line, however when i try to run a python script to run my workbench i get the following error:ImportError: libfmeobj.so: cannot open shared object file: No such file or directoryDoes anyone have any experience running FME workspaces via python on ubuntu?I've copied my python script from a previous post from Ken's. Although i have a small amendment to check the OS which the script is being run on:import sys, os, platform# Set variables based on operating system:operating_system = platform.system()if operating_system == "Windows":    sys.path.append("C:\\Program Files\\FME\\fmeobjects\\python27")    directory = "E:\FME_Workbenches\PythonTesting"else:    sys.path.append("/opt/fme/fmeobjects/python27")    directory = "/opt/PythonTesting/"import fmeobjects#initiate FMEWorkspaceRunner Classrunner = fmeobjects.FMEWorkspaceRunner()#Full path to Work

363
H
T
tstpierre
asked in Data
How to write multiple lines into a text file using CSV writer?

I would like to write a text file and put the information on multiple lines using the CSV writer. I see how to put multiple fields but I cannot find how to put my information on multiple lines.Thanks for your help!

592
mark2atsafe
Safer
B
ben
asked in Integration
Get coordinate system at first run

Hi everybody,   I have a weird problem with my reader.   My reader was written in C++ and requires a coordinate system for the reading procedure. So, the FME user clicks "Add Reader", selects my reader as format and a coordinate system (for example EPSG:3493). Afterwards he chooses all remaining parameters and clicks "Ok". The translation process starts automatically.  Next, my reader`s open() method starts and fetches all parameters. I use the keyword "_COORDINATE_SYSTEM" to receive the entered coordinate system.    gMappingFile->fetchWithPrefix(readerKeyword_.c_str(), readerTypeName_.c_str(), "_COORDINATE_SYSTEM", outputString) My problem: This line only works, when the reader is already added to user`s workspace and the user click on the button "Run or Resume translation of the workspace" (green play button at toolbar). It does not work at the first translation, when the user clicks "Ok" on the "Add Reader" dialog (again, the translation start automatically after the dialog is cl

86
B
parashari
parashari
asked in Transformers
JSON Output Not Written

Hi,I am new with JSON. I am actually fetching dats using HTTPCaller and saving the output in csv format. I have used Creator-HTTPCaller-JSONValidator-JSONFormatter-JSONFlattener-Writter(csv). Everything seems correct till formatter, but when I use flattener, the elements are not getting exploded in the csv output or even inspector.

3618
takashi
Celebrity
sclkimly
Contributor
sclkimlyContributor
asked in Authoring
Optimizing point in Polygon overlay operations

I am trying to optimize a large collection of "Point in Polygon" overlay operations. The work flow is this:  1. The user selects a point on the screen (will be publishing to an FME Server solution, once successfully prototyped).  2. Workbench will accept the point, and then "drill down" through all of the attached data sources and report on the findings, in the context of a PDF report.  My question is this: some of these data sets have a very large number of features. The assessor parcel layer, for example, has 350,000 polygons to process. Power poles (for proximity searching) number in the 130,000 records range. Is there a way to "pre-process" these data sets so that I am not searching through 350,000 parcels when looking through a few city block's worth would go much faster? More simply put, is there a way to restrict the overlay operation to a smaller geographic subset, like constructing a special geometry (a polygon?) that the PointOnAreaOverl

628
sclkimly
Contributor

Badge Winners

  • FME Form Advanced Training
    maz.ghasemihas earned the badge FME Form Advanced Training
  • Welcome Back
    nataliarojashas earned the badge Welcome Back
  • Integrate Spatial Data
    dezuviriamhas earned the badge Integrate Spatial Data
  • FME Form Basic Training
    johnrochehas earned the badge FME Form Basic Training
  • FME Form Advanced Training
    sahan969has earned the badge FME Form Advanced Training
Show all badges

Community Stats

31,801
Posts
120,804
Replies
39,418
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.