Data

Hi Guys,I've trying to write a LAS file (Creating a TIN surface with TIN Generator) to IFC file. The final purpose is add this TIN surface to a BIM Platform. I've tried, but I dont get it. I appreciate any help. Cheers!

I'm writing information with geometry in Postgis table. It is currently in UTM, (SA-SIR-22S), before I need reproject for EPSG 4674 (SIRGAS 2000 LL). A failure occurs: The bulk copy failed in the 'public.amb_app' table using the ':' delimiter. Error was' ERROR: new line for relation "amb_app" violates verification constraint "enforce_srid_geom"CONTEXT: COPY amb_app, line 1: "8.34: 4: 461: 0400046100001: etn.sao francisco (flavio): 010300002042120000010000008503 ... 'A fatal error has occurred. Check the log file above for details... Last row repeated 2 times ... How to solve this?

Hi All,Hope you are doing good.I have an excel sheet containing a set of data wherein i wish to read only a specific set of rows. Test Excel.xlsxIn my case, i wish to read the data below the string (in mass percent) in row 280 from 281 to 296 with 281 as the column names. The whole table is supposed to be read below the above mentioned string. These row numbers may change with different excel sheets. So i need a generalized solution.Please help. Thanks.

I am returning a variable string from oracle stored plsql function. Function is executed successfully in sql creator without an error. I need to know how/where to see/populate the output returned from stored function.

Hi guys,I have this point cloud that I have filtered and clipped so that only vegetation areas remain. These areas I want to build a mesh of so that I can import this as a 3D-model into another software. I use the pointcloudsurfacebuilder for this purpose. Using construction mode "simple triangulation", everything works fine, a separate mesh is created for eache area of vegetation.This mesh is quite coarse so I want to use constrouction mode "poisson" instead. This creates a much smoother mesh, only problem is that it also creates a rectancular surface around the whole extents of my pointcloud thus making the mesh useless for me.Anyone here who can help me sort this issue? See attached screenshots of both results.  

Hi,From a vb.net program, we need to create a MI Table like MITAB. We are having problems with MITAB so we are looking for an alternative.Can you help us? Thank you.Alejandro

There are a plethora of discussions on the "Error running translation" error, but none seem relevant to my simple workflow, as shown in the attached image, that writes a simple point geometry to an ArcSDE layer. The error msg was misleading as the point had been successfully written.I turned on the debug log and found a "BADNEWS" error in the log - - which I was not sure of its relevancy.

Dear Users,  I am trying to save a single polygon as a dxf file with a given file name out an array of polygons. My Array is 28 rows by 350 columns, this makes 9800 polygons.  Rows are numbered +14 to -14. they are divided by a centre line, north of this line numbers are positive, south of this line numbers are negative. Columns are labelled Alphabetically, i.e.: A, B, C ... Y, Z, AA, AB, AC ... AY, AZ, BA, BB, BC and so on until ML.  My goal is to save each polygon in a separate dxf file. the name of the file should correspond with the "coordinate" within the array, i.e. "AA_+01" , "BO_-13" , "ML_+11". I am completely new to the FME environment and I ahve no idea where to start this task. I do believe that this action is relatively straight-forward for an experienced user.I am grateful for any help regarding this task.  Kind regards,Till  

Hi, we use Infraworks at work to bring OSM/OSNI to create quick contextual design for our sites. As of now, the heights of buildings are adjusted manually and it takes really long time applying height to each building. I was wondering is there anyway FME can extract this out?

Hi FME Experts, I am trying to write a Geodatabase relationship class between feature class and stand-alone table but it could not be created, it gives me a below error :"Unable to create table/feature class/relationship class of type 'geodb_invalid'. Creation of this type is not currently supported by FME, and must be done through Esri toolsGeodatabaseRelationshipFeaturesPipeline::GeodatabaseRelationshipFeatures(SortFactory): A fatal error has occurred. Check the logfile above for detailsA fatal error has occurred. Check the logfile above for detailsSome error has occurred closing the pipeline factory, see previous warningTransaction #1 rolled back. Rerun translation specifying transaction #0 for the keyword 'TRANSACTION'Some error has occurred closing the pipeline factory, see previous warningA fatal error has occurred. Check the logfile above for details" Note :I have followed the steps and recommendation points in the article https://knowledge.safe.com/art

I am trying to simply read a featureservice that I need to make periodic downloads of. This featureservice needs authentication. I can pull a token using part of this example (arcgis-server-feature-service-reader-token-authent) but I cannot seem to figure out how to hold the token as a parameter to feed to "ESRI ArcGIS Server Feature Service" transformer. I have also tried using a FeatureReader (using username/password) but am having issues not seeing the attributes. I do not fully understand using lists (if that is the issue).So, I need some help with either being able to create a token and save as parameter to feed to another transformer or pull attributes from the featureservice using a FeatureReader transformer.If you have any suggestions, I would be very appreciative.

0 I am running a script in FME SQL Creator reader. Script looks like,set serveroutput ondeclare var1 a;BEGIN dbms_output.enable(); dbms_output.put_line ('TEST LINE'); END;Script runs successfully in Oracle SQL Developer. But If I run from FME, it returns nothing.

Hello FME Community!I'm having following issues: my transformation schema generates CityGML Feature Type TIN Relief, and I want to drape ortophoto image over it. Also, i have generated buildings and want to drape roof textures over the roofs from the same ortophoto image. When I try to open draped TIN relief within the transformation schema (with an inspector in the end) it works. However, when i want to open cityGML later, the textures don't show. Also, TIN Relief refuses to import into 3d city database. SRID for the data is 31277.I am uploading my schema, data and generated cityGML that I'm getting from the schema (https://mega.nz/#!hY9QRIyT!0rfDxD5mvrMFr0hoZyUp8PjCrebtuDUYhglsIMH-NAA). I need help with this issue and maybe correct the schema in order to make TIN Relief available to import to database with textures. If anyone has an idea how to add only roof textures to RoofSurface from the ortophoto i'd appreciate help with that too.Thank you in advance,Stevan

Hi,I would like for my workspace to run automatically each time a row is added to a postgis table, but can't figure out how to do this.I took a look at the Directory Watch Publisher and also at this article: https://knowledge.safe.com/articles/806/push-data-out-of-databases-to-fme-server-in-real-t.html but I don't really understand how to proceed.Thank you

Hello I have tried to replicate one demo application from FME Server Playground. I have replaced repository name and workspace name and initialized my FMEServer with my host and token values. As can be seen from the screenshot after modifications, the HTML page opens correctly, and I am receiving works parameters. “Choose File” and “Upload Files” buttons do they work but after hitting “Run Works Space With Data” I getting an error. Can you please help me to fix this issue?

Hello, I am having problems with Mongo reader/writer. First I read from Mongo, it works fine and I add several transformers (Clipper, spatialFilter - comparing with other datasets) and then I want to write back to mongo. When I check the output from the Data Inspector, it seems to be fine, geometry is the way I expected and the result looks good. But the Mongo Writer gives back the original geometry. in writer settings, I put "Document Source":JSON Attribute -> mongodb_jsonThanks!

My workspace uses a Microsoft SQL Server Spatial reader to extract its source data and all has been working fine until told my source database is moving to a new server. Fortunately I still have access to both existing and the new one to migrate and confirm the db connection is working. The server name I was given is of the format: server\\instance,port (eg. SVRxxxx\\INSxxxxx,51433). I am using Windows authentication and have confirmed my credentials using Sql Server Mgmt Studio. When I attempt to Add a database connection in FME options, I enter the database name into the Server field of the Connection Parameters in exactly the same format as I did in SSMS (and which I had always done successfully in the past when my source db did not have a comma port number in the server name), but when I press the ellipsis to obtain the list of databases to which I can connect, I receive an error: Connection failed. Connection string `Provider=SQLNCLI11;DataTypeCompatibility=80;Data Source=WCx

The SQL Server database I'm connecting to won't support database authentication (policy), so I got a AD service account created, but I can't find an option where I can use Windows Authentication, but I can still enter in the credentials (they are greyed out when you choose Windows Authentication).FYI: I'm using FME 2018.1

(V2015). I have a V8 dgnlib I would like to output to an excel sheet the list of levels. There is no geometry in the file. Any suggestions? I have tried the reader but i think it needs geometry on the level. I think someone suggested an additional step or action but i cant remember what it was or find the post again sorry. many thanksB 

I have downloaded the transportation file with pbf extention through hotosm. However, FME throws error while reading the file.The error I get as it is in the following: "Failed to obtain any schemas from reader 'OSMPBF' from 1 datasets. This may be due to invalid datasets or format accessibility issues due to licensing, dependencies, or module loading."Thanks in advance.

 Hello,I am doing simple analysis selecting lines which are Within Supplier (Area) basically crated buffer followed by dissolved and the SpatialRelator for selecting features. I have use SpatialRelator for that but tacking too much time (features count 1000000). Can anyone have solution?

Hi everyone, I'm a new user of FME Desktop and I want to populate an existing database starting from a shapefile, which contains both geometries and attributes. I want to keep both of them when I create the workspace in FME Desktop, so firstly, I started adding the shapefile feature type as "Reader". To understand the geometries involved, I used "GeometryFilter", selected all the geometries, and for each one I used the "inspector" transformer.I found out that I have only "Surface".Secondly, I used "PostGIS" as "Writer" and run my workspace. The translation was successful, however, when I open the database, I have two different types of geometries: "Multipolygon" (without the "Z") and "GeometryCollection", and I cannot see both of them in the map.If I inspect with Data Inspector my output file (PostGIS), I see the geometries and the attributes. What could be the problem?I hope I have explained

HiGetting the following Tunnel error - reading online seems it might be an SSL issue - Can this be looked at in the Database connection parameters and the reader and writer for MongoDBSeems only to be an issue if using the hosted serviceMONGODB writer: Cannot connect: DBClientBase::findN: transport error: mydatabase-shard-00-00-ch90m.mongodb.net:27017 ns: admin.$cmd query: { ismaster: 1 } MONGODB writer: Unable to locate or open database 'mydatabase-shard-00-00-ch90m.mongodb.net'. Please ensure the database exists and is accessible. Note that the MONGODB writer does not have the ability to create a new database. However, creating the database manually in advance allows for subsequent data insertion

Hello,When will fme 2018 desktop or server have the ability to read / write ecw3 files?cheers

Hi there!  I'm new to FME, so I apologize if I ask for a commonplace. My task is to create a 3D PDF, which will be a sequence of geological layers. Each layer is described by two files in the geotiff format - one corresponds to the top of the geological layer, the second to the sole.I converted them to TIN-surfaces, afer which I tried to convert them to mesh, but the Mesh-builder transformer rejects them. I also tried to go the way of creating 3D polygons as in this example, but, again, I could not convert polygons to mesh. Output example and 2 layers are attached. Thanks!