Using readers and writers to extract and load data.
Recently active
I have to determine the direction of a closed curve (a line where start and endpoint are the same) because I want to derive a gpx in the right direction (clockwise) from the polyline. Is there a way to do this? So I want to test if the polyline has a clockwise direction and, if not, reverse the direction. I tried the Polylineanalyzer and the azimuthcalculator, but both don't give me a solution.
Hi, I am passing records from Postgis to Smallwrold. But when it takes half an hour working template I get this error.Know the cause? How long should the Smallworld server offline the workbench to make it happen? Thank You
Hi,I have insert polygons into a Sql Server server table, and for some reason polygons are converted to geometry collections polygon and or curved polygons circularstringFor this reason Geoserver and or ArcMap does not work, because it cannot view these geometry typesI have tried all the coercer and filter but cannot seem to make it an polygon and or mutli polygonrunning on SQL Server 2014, worked perfectly on 2008R2How can i force it to these 2 logical types?Rudy
Hi i want to Export LandXML Surface with boundary to PDF3D or DEM or 3DS I TRY to use a DGN for the boundary but the clipper don't look to work Is it possible to use the Boundary inside CIVIL 3D LANDXML ?
Hello everyone,Currently I am working on making a translation from CityGML to CAD and back. However, on the way back the attributes change drastically from the original.Original<imgeo:bronhouder>source</imgeo:bronhouder><imgeo:inOnderzoek>false</imgeo:inOnderzoek>Translated<gen:stringAttribute name="bronhouder"><gen:value>source</gen:value></gen:stringAttribute><gen:stringAttribute name="inOnderzoek"><gen:value>false</gen:value></gen:stringAttribute>Both the prefixes and the structure changes and I want them to be as similar as possible. Is there a way to do this? Enclosed you can find the fmw I use.
Hello FME users, I've added a new SDE connection in my Database Connections but my connection file path inside the Esri Geodatabase (ArcSDE Geodb) Reader parameters is still showing my old connection file. I've already deleted it from my ArcCatalog folder. I'm having to click on the (...) button and select the new connection file. Anyone else have this issue, and any thoughts on how to get the new file path to show up?Thanks in advance.
I want to convert citygml lod2 or 3 to ifc but it doesnt go i found no geometry , how can i do it please and why i get no geometry at the end ?
I'm am already way over my head on this on this one. I'm trying to create several hundred kml files each one showing a specific area and slowly orbiting abound that area to show a 360 view. I have created a sample kml in google earth. Please see the attached kml. I have also attached a copy saved as .txt so you can see the xml code the kml created. Is it possible to create similar kml files in FME. I have played around with the KMLTourBuilder and the KMLViewSetter but was unable to replicate. I'm not a programmer and can't wirte xml on my own but would like to somewhat automate the process so I don't have to create each one in the Google Earth UX. Any suggestions would be very appreciated. THANK YOU THANK YOU
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.