Data

Hi I have a CSV file with X,Y coordinates. I am loading this to a point feature class. However the XY coordinates sometimes come in quotes and have a comma, e.g.GLOUCESTERSHIRE,ST BRAIVELS COMMON,GL15 6SD,"355,280","203,644"Any suggestions what's the best way to handle this when using the CSV reader.

INSERT INTO `stations`.`observation` (`station_id`, `date`, `time`, `energy`, `power`, `average`, `temperature`, `voltage` ) VALUES ( 1, @Value(interval_start), @Value(_timeOutSubstring), @Value(_dataEnergyOutString), @Value(_dataPowerOutString), @Value(_dataPowerAvgString), @Value(_dataTempString), @Value(_dataVoltString) )

Hey, I'm getting a unique constraint error coming from an indexThe error number from ArcObjects is: '-2147216072'. The error message from ArcObjects is: {Underlying DBMS error [ORA-00001: unique constraint (FACILITY.A17846_IX1) violated]}Is there a switch in the writer I can set?? I have tried GRID 1 = Nothing and GRID 1 = 0 and both fail.Thx Brian

Hi, I'm trying to read data from this server:https://geodata.nationaalgeoregister.nl/bag/wfs?request=GetCapabilitiesbut only a 1000 features (the same ones it seems) come through. I've tried switching some parameters around, like what was suggested in previous questiosn about WFS on this forum (ignoring the schema etc. ). However, nothing has worked so far.

Hello,FME 2017.1.0.0 64-bit, FME 2017.1.1.1 64-bit / Windows 7, Windows 10I encountered this error when adding the Esri ArcGIS Online (AGOL) Feature Service Reader to the workspace.Logged Message:ArcGIS Online Feature Service Reader: Encountered an unexpected error. The error code from the server was '500' and the message was: 'Unable to get user.'. Details: 'Unable to get user.'The Feature Service list has been retrieved correctly, but I cannot get the Layer List from any service.The AGOL account has been provided by a client in order to test collaboration between their AGOL site and FME Server. I can access their AGOL site with the account using a web browser. The error occurs only when accessing the AGOL feature service via FME AGOL reader. (I also have my own AGOL account, and the reader can access the feature service in my AGOL site with no problem)Question: How can I resolve the error and read the layers from the feature services?Thanks.

Hello,I have a shp file with ZIP code level polygons. I need to combine all of them to give me polygon for the state, is it possible to do in FME?I tried to use the Aggregator, which took all my polygons and showed 1 output, but when inspecting the file, there was no geometry.Thank you!

I have a lot of .fmw files with Oracle readers pointing to sources outside my control. Sometimes, the names of the tables I'm reading from will change, or they'll get dropped, or my credentials will lose permission to them. When this happens, FME just reads 0 features, and says the translation was successful.How can I make FME output an error instead when this case happens?

Couldn't write to MongoDB with multi-polygon geometry. I get this error.MONGODB writer: Bulk write: OperationException: { index: 890, code: 16755, errmsg: "Can't extract geo keys: { _id: ObjectId('59fcc51628de9b19a60bf281')Any parameters to be changed for bulk write/multi-polygon geometry type?Thanks.

I'm having a frustrating hit-and-miss writing a handful of non-spatial feature types to sqlite non-spatial. Regular row-column tables, no relationship between the features or anything else. And sometimes it works, and sometimes one of the feature types will FAIL  SQLite 3 Writer: Failed to write to table `myFeatureTypeName' in the database. SQLite3 Engine error: `SQL logic error or missing database'  Removing the feature and then adding it manually will SOMETIMES fix the problem. And sometimes not...   I've tried fiddling with the writer parameters (different modes of writing, No luck there.   Finally, just now, I fiddled with the "Initialize Tables" - setting and changed it from FIRST FEATURE => IMMEDIATELY.  This did the trick for me -- for the time being, at least. Hopefully this will make my problems go away for good.   Anyone else having these kind of problems? Other sqlite / spatialLite hints and tricks I should know about?   Oh, and running FME desktop 2014 Build 14235 win32.

Hello I am new to FME and I am trying to bring in spatial data from SQL server by adding where clause in the reader using function "SQL to Run before Read". I am not sure what query do I use?I am using the following statement but it is giving error. select * from SDEDBO.Services where Date>=Dateadd('day', GETDATE(),-30)thanks for your help!

Hi,I need to tile a 3D city model. I have the model in formats .obj, .dxf, .dwg and .gdb. I drawed polygons (shape) which i intend to use as clipping/cutting/splitting boundaries, whatever helps. After hours of googling and trying in FME with different formats and with clipper boundaries as shape as well as 3D obj, and trying in NetFabb and other software, i really dont know how to address this problem. I found a thread in this forum:https://knowledge.safe.com/questions/5061/splitcut-3d-solids-and-surfaces.htmlBut the links to the example workbenches are unavailable. Can anyone point me in a direction or maybe even provide an example workbench? Many thanks for any type of help!

Hello,I am trying to generate a *.tif-File with certain tags. I found that setting the Photometric Interpretation parameter in the writer leads to the tag of the same name being set (eg. to "YCbCr") in the resulting file. However, I am looking for a FME way to set the XResolution, YResolution and ResolutionUnit tif tags so that they are included in the resulting tif file. thank you,Ludwig

Greetings!I'm using the INSPIRE GML reader to create a GML for the CadastralParcel theme.My FeatureCollection tag looks like this:<gml:FeatureCollection xmlns:xsi="..." xmlns:gml="" xmlns:cp="..." xmlns:base="..." gml:id="MY_ID" xsi:schemaLocation="...">Is there a way to change the position of the gml:id attribute. I would like to obtain the following:<gml:FeatureCollection gml:id="MY_ID" xmlns:xsi="..." xmlns:gml="" xmlns:cp="..." xmlns:base="..." xsi:schemaLocation="...">Maybe I'm missing a setting of the Reader to do this.My FME version is 2017.0Thanks for any help provided!

Hello,  I have a GML in WGS84 coordinate system (EPSG:4326). The GML contains CircleByCenterPoint element, which has its radius set in kilometers. However, if I open the file with Universal Viewer, FME interprets the radius in degrees of latitude/longitude and the circle is therefore extremely huge.  I would appreciate a suggestion how to convince FME to take the units of measure into account. Thanks  Example:  <gml:patches>                                     <gml:PolygonPatch interpolation="planar">                                        <gml:exterior>                                           <gml:Ring>                                              <gml:curveMember xlink:type="simple">                                                 <gml:Curve>                                                    <gml:segments>                                                       <gml:CircleByCenterPoint interpolation="circularArcCe

Hi allIm trying to set up a gml writer to write to a gml file that matches the attached gml. Im new to GML writing a have been trying to get FME to use this xsd schema: http://soap.plansystem.dk/pdk_schemas/PLANDK2_KommunePlanRammeType.xsd as a baseI anyone has an idea where to start making a working writer i would be very happy :)

I'm currently mosaicking 600 geotiffs, these amount to 400mb. Everytime the writer gets to between 80%-90% completed I get the following error: FATAL |Insufficient memory available -- error code was 2 - please read the FME Help section 'Adjusting Memory Resources' for workarounds.Out of memory. Program terminating. Please read the FME Help section 'Adjusting Memory Resources' for workarounds.I have run several others mosaicks with geotiffs in the same workbench except smaller amounts (between 150mb-350mb) and there has been no issues. The smaller mosaicks also seem to complete at a much quicker rate. Anything seemingly over the 350/400mb mark seems to crash the program.I have FME 2017.1 (64bit). I have 8gb of ram. Thanks very much for any help!!

Wher can I find the result url if I run a download service by rest call in async mode?  The async call url is build like this: http://<serverName >:<serverPort>/fmedatadownload/<repositoryName>/<workspaceName>?opt_servicemode=async&opt_responseformat=xml&token=<token>  The result query is build like this: http://serverName>:<serverPort>/fmerest/jobs/<jobId>/result.xml?token=<token>  The xml response of result query does not contain the result url. If I run download service in sync mode, I can find the result url in xml response of sync call.  What I have to do to get the result url when I call a download service in async mode? 

Hello,I have 3 shp files which I need to joinFile 1Postal code and nameFile 2Admin code and nameFile 3Admin code and stateName in File 1 and File 2 has identical listAdmin code in File 3 is first two digits of Admin code in File 2I need to create single file which would have the Postal Code, Name and State.I tried to create Reader for File 1 and a Reader for File 2 and write them into the same file. The transaction was successful, however it first listed all items from File 1 and below all items from File 2.

I need some help with a problem I have about sending out log files from FME server jobs. I have a workspace that runs a bunch of jobs using the fmeserverjobsubmitter. if it fails, I capture the log file from that job to a network location. then I send an email with the log files attached using the Emailer. only problem is if multiple jobs failed. it will send multiple emails which I don't want it to do. i also do not want to bundle up the logs files as 1 zip file. I used the featureWriter to write out a txt file of all the log file paths and then the featureReader to read it back, but not sure how to attach it as the attachment parameter expect just 1 file path. TIA!

Hi! Im trying to make a simpel .dwg (only the outside is what i want) from a more complex .ifc model. Are there any workspaces or seminars that describe how this is done? Any help is appreciatedBest/ Johan

I have posted something related to this same reader before, but this error is new. I am using a path reader to unzip an archive containing multiple subfolders/subdirectories and look for geodatabases, before then sending them to a geodatabase feature reader. I am using the glob pattern **/*.gdb and leaving path type to 'any', although I have tried (and got the same error) with 'folder'. This works fine on desktop, but on server I am now getting the following error:I'll save any further details for comments, just to keep this question simple. Previously this was working, and neither the desktop build I am using for this (2016.1.1 build 16674) nor server version (2016.1.3.2 build 16717) have changed.

Hi,  Can it really be true that I can't update block attributes in a dwg file that already contains minus signs because I can't write minus signs in the attribute names of the writer? For example; If I have an attribute called "BLA-BLA", it automatically converts it to "BLA_BLA", which means the attribute in the file won't be updated in the file since it exists as "BLA-BLA".  Is there a way around this? Thanks!   /Jacob

Hello FME Experts,I need some help in figuring out how to use a return value from a stored function in oracle. Stored function:create or replace FUNCTION TestReturnFunction(inputval in varchar2) return NUMBER IS countnum number:=0; BEGIN  IF( countnum = 0 ) THEN select count(*) into countnum from TestTable where MyVal is not null and TestID=inputval; END IF; IF( countnum >= 1 ) THEN RETURN (0); ELSE RETURN (1); END IF; END TestReturnFunction;  How I call it:FME_SQL_DELIMITER / declare result1 number; begin result1 := TestReturnFunction('TestThisValue'); end;   While this runs successfully, no value is returned in the "result" section of sqlexecutor. Any help on how to get the output would be greatly appreciated!

Moin.I think there is a problem with the PostGIS-writer and the new PostgreSQL version 10. In PostgreSQL 9.6 there were no problems. Since I installed the version 10 of PostgreSQL (with PostGIS 2.4.1) the following error is thrown:Error executing SQL command ('SELECT AddGeometryColumn('test', 'myTableName', 'geom', 3034, 'GEOMETRY', 2)'): 'ERROR:  Schema 'test' is not a valid schemaname"test" is not the schema name, it is the database name. The schema isn't recognized in this command.Matthias

Hi,I'm trying to import a Microstation cell library as symbology in QGIS. I've managed to change the .cel files (the cell library) to a dxf file. I've also managed to convert that dxf file to xml in FME, with just a reader and a writer (no transformers). The translation went succesfull acooording to FME. However, when I import the symbology in QGIS, I get an error:Incorrect root tag in style: fme:xml-tables.What am I doing wrong? Should I use some kind of transformer? I just applied the default parameters/settings when translating. Should I change a setting in order fot the translation to succeed?