Data

I have a job that is reading from a file GDB and writing to an ArcSDE SQLServer versioned GDB.I believe I have configured the writer correctly, as the log has messages confirming that I am connecting to the correct transactional version.Connection made to server 'scggisdb1pw' for dataset 'SQLHydro' (transactional version '"BCC\\DJACQUES".DJacques_20170417') using Operating System's current user ArcSDE release: '10.0'. Underlying database: 'SQL Server'However I am getting the following error : Geodatabase Writer: Creating feature dataset 'ModelData' Geodatabase Writer: Creating feature class `ICPR_NODE' in feature dataset 'SQLHydro."BCC\\DJACQUES".ModelData' An error occurred while attempting to create the feature class 'ICPR_NODE'.  The error number from ArcObjects is: '-2147155515'. The error message from ArcObjects is: {Database user name and current user schema do not match. [SQLHydro

I'm trying to add a custom icon using the KMLStyler. The icon is saved on google drive. I used Attribute Manager to add a new attrubute called "Symbol_Icon" thats value is the google drive url link, then I used the KMLStyler to set the icon name to the newly created attribute. I'm getting the "red x" once I open the kml in google earth. Screenshots below, any suggestions?

Hi,I'am creating a workbench which uses a MSSQL database writer to delete certain records from a database. In most cases this works fine but sometimes I get the following error/Warning message:MS SQL Server Writer: Failed to write a feature of type <name of the table> to the database. Provider error `(-2147217871) Query timeout expired'. SQL Command `DELETE FROM <name of the table> WHERE <field within the table> = 6339404'Every time this error occurs there are exactly 50 seconds between opening and closing the database connection. In case the workbench runs without error the connections lasts shorter and is executed without any problem. The following changes did not solve the problem: - Change Command Timeout from 30s to 600s and even to 9000s (when executed directly in SQL server management studio the query takes about 1 minutes and 30 seconds to execute, so 600s should be more than enough). - Checked the time out settings of SQL server. They are set at d

Hi,I am new with FME. I have 3d lidar point data for a single house. Now, I would like to create 3d surface out of it. Would you please give me some advise?

Hi all I want to Check the presence of one or more layers (which I already know the names) and in each of the layers verifies the existence of one or more attributes (already known) when reading the data source.Thank for advance

This is somewhat related to another question of mine. I am using FME 2013 and connecting to Smallworld 4.3 via SpatialBiz' SBS plugin.I have had trouble getting the syntax straight to extract all elements from gt_pipe_segment that match a certain 'where'-clause (using FeatureReader). At some point then I decided to look at the results without any clause in place, and got the following results:FME returned me about 28.000 entries, while gt_pipe_segment.size is about 92.000.This problem seems to get bigger the bigger a table is. But already for a table of size roughly 1500 I had a deviation of six.Again, there was no clause in place, neither spatial nor on the attribute.Is this a known bug? Can someone confirm this? Could this be fixed in a newer version of FME/SpatialBiz? I have found another bug report on FeatureReader.  

Hi,Below screenshot show the SDE reader added and 45 features are read...But it is showing error between after the message of "translation was successful" and about to end.It is happening when "Read version differences" is set to "No".If I place "Read version differences" is set to "Yes" then reader is reading the "0 features".So I'm able to understand which setting I was left over. Could anyone kindly help me in this regard...

How to convert Revit file to 3D Max file?

I have Roofs and walls i dwg. But the walls goes 2m to deep in to ground.Is there any way I can cut the walls with a DTM-raster or TINsurface, or maybe extract new walls from roof to ground.I would also like to have every building as a solid. The floor dose not have to follow the ground. The floor could be level to the buildings lowest point at ground.Any ideas?

I am having trouble getting the syntax right for the FeatureReader using Smallworld.A small example: I would like to read all pipe segments that have certain status and a certain material (which could have been taken from an XML file, for example - here, for simplicity, I created the attributes with an AttributeCreator).I have tried every variation with and without quotiation marks, but cannot get it to run. I am using FME 2013 (upgrading is not an option, as it's not in my power) and the SpatialBiz plugin to access Smallworld.

Hello!I am new FME user and I trying to transform multiple dgn files fronm ED50 to ETRS89. I use Quick Translator to do it, and there is no problem if I tried with only one file. But if I tried to do it with multiple files at the same time the levels numbers are changed.If in origin, the information levels are 51 and 52, in the destination files are 14 and 15, for example.How can I keep the source information? Thanks Afp

Hello,I am processing data and write the results to Textfiles , using a fanout and the featurewriter.Now i want to add some headerlines (read and blue) in front of the exported lines (black). Plase, refer to the screenshot.The red lines are the same for any of the files. Only the blue line consistes of a constant part (file.) andthe filename which is individuel. The number of resulting Textfiles varies.Any ideas are highly appreciated!

Hi.I want to compare two 3D-models (Buildings) to see differences, visually and statistically.Any idea how to do it?The buildings is in .dwg at the moment but i guess i can transform them to any 3d format first if another format would be better for this project.The background is that i made 3D-buildings from lidar-data and want to compare the resualt of the model output to reference data (terrester lod2 buildings in .dwg).regards,Anton

Hello FME users, I'm a beginner in HTML code and need some help extracting tables from websites. I've been using the HTMLTable Reader and it has been great if I need to work with just one hyperlink. I'm currently trying to use the HTTPCaller to extract tables from 300+ attributes that have hyperlinks attached. I'm trying to only extract the 'WELL HISTORY' tables for each attribute.An example hyperlink is below:http://sonlite.dnr.state.la.us/sundown/cart_prod/cart_con_wellinfo2?p_WSN=199138Copy of HTML code is attachedAny and all help is greatly appreciated.Thanks

I've looked at a couple of similarly named questions and they're not quite what I'm after.I have a work space with many Mapinfo Tables being written to many GML feature types into a single output GML file. I'm getting varying orders of output. For example I have a GML Feature called "Header". I'd like that written first. Is there a way to prioritise the execution?In addition I have two GML Features that use the same MI table as a source. Oddly or perhaps obviously, the output order is "woven" together.egGML Feature 1GML Feature 1GML Feature 1GML Feature 2GML Feature 1GML Feature 1GML Feature 2GML Feature 1GML Feature 2While I know write order is inconsequential in XML\GML there is a process where somebody eyeballs the Header in a text editor to make sure the content is correct. Looking for the header buried in the files just adds time.Any advice appreciated.

Does someone have input on why I can't run my workspace due to this error message? Thank you

i have CSV file with given shape_area and shape_length. How can I convert it into closed polygon? thank you.

Folks, I'm having trouble getting an actual object out of my Mapinfo objects and getting them represented in GML. Being that FME is (Feature Manipulation Engine) I expected this was implicit but it appears not. The Mapinfo Reader doesn't present an "object" to perform some kind of process on. I'm taking a guess I need some kind of Transformer.  I tried a GeometryExtractor. I presume the Input is implicit in that I attached it to the Mapinfo table. I have some options on the output. I selected GML v3.1.1.(matches my schema) and named the output to match the GML tag I'm targeting. Running the conversion shows no errors but neither does it give me a "poslist". I did see a GMLFeatueComposer with enough sophistication to reference my XSD but this threw and error when the translation was run.BTW my attribute tagging works perfectly in the translation so at that minimal level I have a GML (that has no Geography)Any guidance appreciated.

Hi All,I develop a workspace to transfer the mdf to gdb but the feature class in file geodatabase have the same name of the feature in mdf.For example I have mdf “B” containing five feature class when I transform them into file gdb as you can see belowIs there any way to change the name of feature class from “dbo_COMMUNITIES_point” to “communities” by adding a transformer to my workspace? Best Regards,Rawan

I've got some CSV Writers from FME 2016.1 and I obviously want to take advantage of the new CSV2 Writer. I thought I could make life easy by editing the Feature Type properties and changing the Writer from CSV to CSV2 but FME ended up crashing. So I presume creating things from scratch with the new Writer is recommended way...?

Hi,I am new to FME. I currently have 286 old gdb that consist of 15 feature classes, they needs to be updated to a new gdb. Some of the updates includes: changing a point to polygon, merging feature classes, changing fields name, and also mapping value for subtype. I have already figure out how to update an individual gdb.Right now, I am playing around with Workspace runner and Directory and File pathnames reader. I am uncertain about some of the parameters. In my workspace, for my reader and writer, does it matter if I load any old gdb as the reader? and any new gdb as the writer? I have attached below what my current workspace looks like.Can you please help me out? It would be very much appreciated :-)Thanks,Vincent

Since every country in the world except The USA, The Gambia and Myanmar is now using metric units could we have a set of default templates in FME in metric units? Or at least an option to switch back to Imperial?Does anyone in a metric country have a set of default.dwg, (and 2007, 2010, 2013 versions) for FME that they could share?

I am using Smallworld 4.22 translating to Microstation V8i with FME version 2014sp4 The font in Smallworld is an old font Hershey-Roman-Narrow. I am adding a Character 127 which is the Degree symbol (0176 in Arial) . I have in the past been able to use the StringReplacer to replace a special character but this time it is not working. I am guessing that I am just doing it incorrectly. When I print out the line string in my Smallworld buffer is prints out as <delete> if I add a write statement in the code as it is generating the text if writes ^?. In the code I am adding the degree symbol as 127.as_charater() When I run the translation with or without the string replacer in the data inspector shows it as what appears to be a PIPE ( | ) character. In Microstation it shows as a Diamond with a question mark in it.I guess what I am needing is any help with StringReplacer and special characters.

I have a KML writer with dynamic attribute definition. The writer always writes a KMZ file but I want it to write a KML file. When you use a static writer you can specify the filename and extension in the writer as either ".kml" or ".kmz" but when it is dynamic you just give the path to the folder and "fme_feature_type" as the feature type name. Also there is no suffix on which to fan out.How can I get the writer to write KML?Thanks

Hi Everyone !For the purpose of my mission during my internship, i must convert a DWG file to a KML file.My boss told me using FME was the best choice. I didn't know FME before, I just begin using FME to solve this problem.I tried to convert the file with FME Quick Translatetor (following the FME Tutorial) using "Autodesk AutoCAD RealDWG DWG/DXF" for the DWG file in input and "Google KML" for the KML file in output.It failed and return this error :KML: Feature does not have a coordinate system specified+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++Feature Type: `0'Attribute(16 bit unsigned integer): `autocad_color' has value `7'Attribute(64 bit real) : `autocad_elevation' has value `0'Attribute(encoded: utf-16) : `autocad_linetype' has value `ByLayer'Attribute(string) : `autocad_linetype_scale' has value `1'Attribute(string) : `autocad_lineweight' has value `-1'Attribute(64 bit real) : `aut