Skip to main content
  • EN

Data

Using readers and writers to extract and load data.

  • 6,667 Posts
  • 24,610 Replies
6667 Posts
S
subrat
asked in Data
Problem in returning SDO_GEOMETRY from oracle function/procedure

I am able to read geometry from oracle but how can i return geometry from oracle function and expose it in FME 2012?

2
S
11 years ago
bo
Contributor
boContributor
asked in Data
Case for exposing output ports in Writer?

I consider myself a veteran in spatial IT but newbie in using the FME tool - less than a year.  In my limited practice using FME, I increasingly feel the need to access "output ports" of Writers.  I saw some discussions dismissing such needs which for the most part I understood.  However, since ETL processes often times are synchronous in nature, picking up the "committed" results from database transactions for the following process will allow us to author fewer workspaces.  For example, feature elements of different types from ACAD files are extracted and processed before they are stored in several Oracle QC tables.  Without accessing the output ports of the QC tables just generated, I have to write a different workspace to Read from the tables for the subsequent process.  To piece automate the entire process in the sequence, I will need to use Python...  Any comments or advise is highly appreciated!  Bo 

5
bo
Contributor
11 years ago
S
subrat
asked in Data
TextStroking Issue in 2013

How can i pass stroking text to text stroker in FME desktop 2013?

0
S
11 years ago
U
ug
asked in Data
Running a Workspace with FME Server and Silverlight

Hi everyone,  i am trying to run a Data Download Workspace from a Silverlight Application and i really dont get any futher. I tried it with the WebClient class and the DownloadStringAsync Method but i have absolutly no success. Does anyone have experiences with Silverlight and FMEServer?  Thanks in advance!  Ulf

4
U
11 years ago
jhawks
Contributor
jhawksContributor
asked in Data
passing parameters from a web form to fme server workbench.

I've built six custom web form to pass variable to publicly available workbenchs. But I can't quite figure what the url should be in the webform so that the user input gets passed to the workbench.     Webform: http://fmeserver.ncd.noaa.gov/encdirect_extract_overview.html     Workbench:     https://fmeserver.ncd.noaa.gov/fmeserver/repositories/encdirect_extract/orapub2multiformat_overview.fmw

0
jhawks
Contributor
11 years ago
S
sv
asked in Data
Authorization Error - FMEServer 2013 SP1

I have a java application which uses the fmeserver api methods to run a translation. The code runs without error on our development server and produces a dataset as requested.  When  I run the application on the production server I get the following error when it tries to initialse the server session;   Error initialising FME Server: COM.safe.fmeserver.api.FMEServerException: QSInvalidRequest: Authorization Error: Unauthorized request by user  due to lack of proper permissions.   I have checked the entry in the Security/Resources tab for the  application with the appropriate clientid and roles assigned.   My question is how does FME Server know which box the request comes from ( requesterHost value listed under ‘Transformation Manager Directives’ in the Jobs/request data tab) ?

0
S
11 years ago
F
fme_89
asked in Data
KMLPropertySetter bug?

I have recently been trying to use the KMLPropertySetter to create KML from TAB, as per the documentation I enter the correct values for the Navigation Tree, Description Ballooon and Geometry. However when viewing the KML the properties I have set do not appear, for example I want the Navigation Tree name set to my Area column (ie Controlled Parking Zone A).  Please have a look at my KML and let me know if I am missing anything. In my workbench the only KML transformer I am using is KMLPropertySetter  https://maps.google.co.uk/maps/ms?msid=217615190311347014347.0004df7ec96af6fe732ac&msa=0&ll=51.558503,-0.090122&spn=0.077909,0.154324&iwloc=0004df7ec9ace9d65ef59  Any advice would be very much appreciated.

0
F
11 years ago
M
markd
asked in Data
Apostorphe in excel field name - how to remove

When I generate an excle table as an output in FME, the field name appears to have an apostrophe as the first character in each of the field names but you can only see this when you click on the field cell...... 'TOTAL NUMBER OF BUILDINGS. I say appears, because you can not do a search and replace in excel to remove it.  The only way I found to remove it is by running a trim function in excel to remove blanks. Is it possible to produce an excel table, in FME, without this apostrophe/blank as the first character in a field name?

5
M
11 years ago
A
aquamarine
asked in Data
Creating MS Access files

Hi,  I want to write to an MS Access File - which I have been able to do successfully.  However, it requires me to create the blank Access file manually before running the workspace.  Is there a way inside FME to create a blank MS Access File?  Thanks,

3
A
11 years ago
P
pat8037
asked in Data
Method to mirror a shape object?

Hi,  I'm currently trying to create a mirror copy of a set of rectangles. Each rectangle needs to be mirror on one particular side to create its other half.  So far, my method has been to identify a centerpoint on the side I want inorder to use rotater transformer, but I've had limited luck getting the procedure working in the correct order when I attempt to aggregate the original rectangles with the centrepoint.  Are there any other methods or transformers I  could potentionally use?  

2
P
11 years ago
J
jamesstott
asked in Data
Only drop dataset if reader suceeds

I am reading data from 5 WFS feeds and writing them to the same PostGIS database table. I schedule the FME workspace to run once a week so I get fresh data.    I only want to drop the data from the PostGIS table if the WFS readers complete. At the moment it is dropping the table, and then writing it as it reads the new data. If the WFS feed reader fails, I am left with a partial dataset.    So I have two questions:    1) I would rather that FME didnt write the data until after it had downloaded all of the data from the WFS readers. Is this possible?    2) Is it possible to make FME continue with the other WFS readers in the workspace if one reader fails?    I have found this page, is this the best way to achieve what I want?    http://safe.force.com/articles/How_To/Rolling-back-a-database-load-in-one-transaction

2
K
11 years ago
A
aquamarine
asked in Data
DGN to CSV

I am trying to extract x, y and z values out of a DGN file into a CSV file.  I used the following transformers: CoordinateConcatenator, AttributeSplitter and ListExploder.  Everything works except that the output has each x, y and z value in a separate row rather than all in one row.  Does anyone know how to change this?

7
takashi
Contributor
11 years ago
rudy_v
Contributor
rudy_vContributor
asked in Data
Add New Attribute to Dynamic Properties in writer

Hi,  I've worked through all the various schema mapper examples but could not find one on how to add a new attribute to the writer schema.  I would like to read the source and add a attribute called  CadLayer as varchar(30) with value of autocad_layer from the source autocad drawing  The source can have various object data attribute fields  one example i have in source dwg MCCID_INT     integer MCCID_STR   char  255 NAME               char  255   i also would like to change them to char 50  I'm writing to arcsde 10.0 feature class  tx Rudy     

7
takashi
Contributor
11 years ago
A
aburns
asked in Data
Easy Translator service

Hi  I have created a easy translator service using the available workbench from FME. I have also copied over the code from FME Server Playground using the '''full data upload'' example making the required changes to the code to look at my FME server.  The issue is i can see the call go to upload the data but on the return call   /*       Create the XMLHttpRequest object       */      var xhReq = createXMLHttpRequest();      // Request Variables      pHostName = "fmeserver.com"      pUrlBase = "http://" + pHostName + "/fmedataupload/Samples/easyTranslator.fmw?opt_extractarchive=true&opt_pathlevel=5&opt_fullpath=true"      pHttpMethod = "POST"     xhReq.open(pHttpMethod, pUrlBase, true);      xhReq.onreadystatechange = onResponse;      xhReq.send(null);     }   my return is blank...however if i copy the call directly into a url it works.  I am sure the code is correct...not sure why the return is blank as the document

2
A
11 years ago
M
magdalena_n
asked in Data
Creating x- and y-label, WebCharter

Hi,  I wonder if someone know how to put axis-labels on your bar chart that's created with the WebCharter. Is it possible?  Is there ways to control the axes in a better way? My chart has the months on the x-axis, but the WebCharter automatically puts a zero instead of 1 where my data begins. Can I deside that the x-axis should be shown from 1 to 12?  Thank you!

3
david_r
Influencer
11 years ago
P
paul21
asked in Data
Transferring Google Earth Images to Smallworld

What is the best way to bring Google Earth into Smallworld? I have been saving are capturing the image and spotting the 4 corners Lat-Longs to be used in configuration in Smallworld.  Thanks! Paul,

0
P
11 years ago
M
mfantin
asked in Data
Coordinates rounding issues: from GDB to SHP

Hi all,  is there a way to make sure that data from a shape file transfered to a gdb file using FME have the exact same coordinate values?  I happen to have to rounding happening in some features. This means that when I compare features from the shp and the gdb feature class, there will be some geometry discrepencies flagged up even though there should be.  I don't know when the rounding occurs (i.e. when it's written the first time to the gdb or when it's read the following time from the gdb)  Any idea? Anything I can set on the GDB writer or FeatureReader to make sure this doesn't happen?  Thanks in advance,  Maryse

9
david_r
Influencer
11 years ago
A
alang
asked in Data
Fetch & Read OSM

This should be simple but I’m ready to throw up my hands.  I have a workspace that fetches an OpenStreetMap chunk of XML for a requested area.  I can save the data and then read the data using the FME OSM reader, a two-step process.    What I want to do is pass the OSM data it to the OSM reader in a single workspace.  I guess I could call the OSM fetcher in a startup Python script but that seems more convoluted than it should be.  Am I missing something obvious?  Thanks, Alan 

1
david_r
Influencer
11 years ago
dustin
Influencer
dustinInfluencer
asked in Data
Logging input parameters to log file

I would like to log the parameters that the user inputs to the log file.  I realize that the information can be found throughout the log file, but I would like to have a list of the inputs in a central location.  At the moment, the user is taking a screenshot of the input screen for QC verification.  If QC could simply check the log file, the user wouldn't have to worry about screenshots.  What I've tried so far in the Startup TCL Script is:           FME_LogMessage fme_inform {FME_MacroValues(inputParameter)}  This was really just a stab in the dark, and didn't return what I was hoping for.

2
dustin
Influencer
11 years ago
A
anandak
asked in Data
Read 0..Many occurences of any element in FME.

I am reading one XML file. An element can have zero or multiple occurences. When I am reading one XML there are multiple occurences and after flattening the element it is recognized as a list in FME. e.g. VectorScaleRange.CompositeTypeStyle.CompositeRule{}  However When I am reading another XML (based on same XSD), there is only one occurence and after flattening the element it is recognized as an attribute in FME. e.g. VectorScaleRange.CompositeTypeStyle.CompositeRule.LegendLabel (CompositeRule element again contains some other elements e.g. LegendLabel  In case the element is non-existent, I am using TestFilter to check the condition if the attribute is present or not. How to check if the element occurs multiple times in the XML. ListElementCounter is not working, since if there is only one occurence it is not showing up as a list.  I am trying to create a custom transformer which should be able to read all occurences of data. Kindly suggest an approach.  Regards, Ananda

5
david_r
Influencer
11 years ago
S
seesee
asked in Data
AUTOCAD .DWG to ESRI raster/symbols

Hi guys,   I am trying to migrate some .dwg file to ESRI raster/symbols.  1) when i use inspector on the .dwg reader, the colors for polygon or hatches are missing from the drawing.  May I know how resolve this?  2) How should i migrate .dwg file to geodatabase raster dataset or symbols?

1
fmelizard
Contributor
11 years ago
D
dpavlicek
asked in Data
Writing compound polygon to Oracle

Hello, is there any way how to write compound polygon (lines + arcs) to Oracle with FME? When i try to write this kind of geometry i always get "ORA-13347 Description:the coordinates defining an arc are not distinct". But arcs seems fine to me (no redundant points, distance between them is larger than oracle tolerance).   FME 2013 (Build 13261 - WIN64) WIN 7 64bit Oracle 11gR2   Thanks for any advice, David  

8
D
11 years ago
I
ian_mitchell
asked in Data
CSV Reader (in FME Server 2012 SP4)

Using the CSV reader. Encountering an extremely annoying problem ... the columns by default get named col0, col1 .. etc. up to col20 and are output in the same order which is fine EXCEPT that col9 is added at the end and not where it should be ... between col8 and col10.  Can't see how I can re-order.  Any ideas? Am I doing summat wrong.

16
ebygomm
Contributor
11 years ago
M
mike_gale
asked in Data
PostGIS to CAD Conversion - problems with autocad_text

Hi  I'm having problems translating POSTGIS text into Autocad_text. I have a project set up for originally converting GML to DWG and the process works fine. I am now changing the input to a postgis database and all layers work  fine except for the text translation.  I have the AutoCAD_entity set to: Autocad_text but I get the error message:  The following feature is not valid because its entity type of 'autocad text' and its  geometry type of 'IFMEPoint' do not match. The geometry failed to be converted to match the type, so the feature will be skipped.  Any help appreciated,  Mike

3
fmelizard
Contributor
11 years ago
J
jaslee
asked in Data
Is there MITAB Writer support for Korean Language?

Hi, I have a workflow which outputs MITAB in several languages: Arabic, Hebrew, Japanese  and Chinese Simplified. These come out fine when I check them in MapInfo using the Microsoft AppLocale tool.  Now I want to add Korean to the workflow but I can't find any option in the MITAB writer Character Encoding list for this language. Could anyone help confirm this is a limitation?  Thanks, Jason

3
J
11 years ago

Badge winners

Show all badges
29,628
Posts
Terms & ConditionsCookie settings