Data

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!

Hi all I'm sorry probably my SQL knowledge is too less but I tried to append some records to an existing table postgresql but I received this error  Bulk copy failed on table 'Slist_ITA.List_StreetName' using delimiter ':'. Error was 'ERRORE: un valore chiave duplicato viola il vincolo univoco "List_StreetName_pkey"DETAIL: La chiave (id)=(3554) esiste già .CONTEXT: COPY List_StreetName, riga 1'A fatal error has occurred. Check the logfile above for details... Last line repeated 2 times ... I attach also the picture of wb (very simple)  Thx for help Francesco

I have csv file and want to convert it in text file.

As an additional source for a transformation I need an xml-File with a given name. This file can be located online (url-adress). If its not online the XML-Reader should use a local file (with the same name). How can I implement this in a Workspace? Thanks for your help

Hi,I'm wondering if you can help. I'm using FME to interact with the https://app.traveltimeplatform.com API using the HTTP Caller which returns a field with the below JSON:[{"shell":[{"lat":51.5050330184,"lng":-0.145035260000001},{"lat":51.5054826584,"lng":-0.145484900000001},{"lat":51.5072812184,"lng":-0.145484900000001},{"lat":51.5077308584,"lng":-0.145035260000001},{"lat":51.5077308584,"lng":-0.143236700000001},{"lat":51.5081804984,"lng":-0.142787060000001},{"lat":51.5090797784,"lng":-0.142787060000001},{"lat":51.5099790584,"lng":-0.143686340000001},{"lat":51.5108783384,"lng":-0.143686340000001},{"lat":51.5117776184,"lng":-0.144585620000001},{"lat":51.5144754584,"lng":-0.144585620000001},{"lat":51.5153747384,"lng":-0.143686340000001},{"lat":51.5162740184,"lng":-0.143686340000001},{"lat":51.5167236584,"lng":-0.143236700000001},{"lat":51.5167236584,"lng":-0.142337420000001},{"lat":51.5158243784,"lng":-0.141438140000001},{"lat":51.5158243784,"lng":-0.139639580000001},{"lat":51.51492509

Hi thereI have a question relating raster/point cloud. I have a zip file with a variable number of rasters.The boundaries of each raster can be different and there could be non common cells.I have a worksheet where I can create separate csv files with x|y|z lines.Bit I need to create one single csv with a combination of all the rasters.The lines for this csv must follow this schema: x|y|zraster1|zrster2|....for non common cellsx|y|z||zraster2||zraster4| etc How can I do it? I´ve figured out a way with feature readers and concatenating strings but it´s painfully slow for big rasters (it takes days) Any help would be appreciatedThanksOskar

I'm able to run a drawing that has one Pipe network with Civil object Pipe and Pipe3d readers. When I have a drawing with Design and Existing water networks it only reads the existing. I've tried adding attribute manager and exposer which helped reading blocknames in the structures workbench. I've tried adding (importing) two layer features as all pipes are on C3D Pipes layer and Ex-Water and D-Water layers but I think using two different types of readers (objects and layers) is not working. Hello FME Community thank you for looking at my question. I'm new to FME, this is my first series of workbenches. Any suggestions would be greatly appreciated.

HelloI would like some suggestions for a task I have.I have several different shapefiles each of them with a different table structure.What to want to achieve is to merge them to a new shapefile with a new table structure that will 'pick' certain features from the columns of the shapefiles and populate the new table:Example