Data

Hi ,I'm converting from Microstation V7 to V8 and I have a problem , the elements type 33 (Dimension element) are separated in diferent elements , Text + Line/s , and not are agruped in a unique element of type 33.thanks in advanced for your help ....!!!

Hello All,I am using Oracle SQL query to extract data of my interest from the Oracle database. Please advise. I am trying to use SQL Creator and SQL Executor but no luck. Please advise. Thanks

I want is create (even) an non-spatial index in the Oracle-spatial writer. So i tried the "SQL Statement to execute After Translation" with the next SQL: CREATE INDEX GBKN_ALLES_TST_INDEX ON GBKN_ALLES_TST(DWGLAYER, KLS_KLASSE)LOGGINGSTORAGE ( BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT )NOPARALLEL;But it failed... error was `ORA-00911: invalid character'What is wrong?

Hi everybody ,One question , anybody knows how could I create feature class that are included in the diagram FME but , like no transform elements of that featureClass , don't create the feature class in the output.I'll explain better , in my actual FME I have diferent feature class of output line VegeLin , etc. I have seen that if the transformation don't send elements to this feature class in the GDB of output I haven't this feature class , and only are created the feature classes that has take elements from the transformation.Thanks in advanced for your help.Regards !!!

Hello,I am reading in DGN files using the Bentley MicroStation Design (V8) Reader and am writing to PDF's. For some reason, FME is converting the dimension text to decimal numbers as it reads the DGN (i.e. 3'-6" is read as 3.5) - I can't even get it to appear correctly in Data Inspector. I tried bringing in the dimensions as an aggregate (Unchecked "Drop Dimensions" parameter on the writer), but when I exploded igds_dim_text{}, the text_string attribute was still a decimal number... I have attached screenshots below - the image on the left is viewed within MicroStation, and the image on the right is from FME Data Inspector. Does anyone know how I can get the dimension text to come into FME exactly as is appears in MicroStation? As seen in the images above, the lines are also in different locations in FME... If you can figure this out too, you get bonus points :-)Below is a screenshot of my reader parameters. I also tried changing input units to IGDS_UORS,

Hello all,I have a Excel file with dates and i would like to read this XLS and take the Min and Max values dates.I didnt find a transformer that make this.Thanks in Advance,

Hey all!You all have helped me out a lot last time and today I again came across a problem which is why I'm posting again. The situationBasically there is a report that has to be created through exporting data from a database and putting it into an excel sheet. I want to automate this through FME.So I added in two 'sqlcreators' which grab the neccesary data from the database. In the excel writer I want to write the data into specific columns. The issue is that again its going to stack the data on top of each other. I tried to use a featurmerger but obviously it does duplicating checks and thats not necessary. The only thing FME has to do is putting data from 'SQLCreator' in collumns A, B and C and putting the data from 'SQLCreator' into the columns E, F and G without stacking the data.So how fme does it like this now:How I want the resultNow I have a solution which is creating a workspace for each sql creator and using the output files of the previous sqlcre

Hi All, we are using Smallworld 5.1 and we need to import data to Smallworld with FME. I have downloaded and installed FME 2016.1 , after that i have copied "sworldswaf.dll", "sworldswaf.fmf" files from Smallworld installation path to FME path (dll file to C:\\Program Files\\FME and fmf file to C:\\Program Files\\FME\\metafile). After that when i opened FME Work Bench and trying to add the Smallworld reader, it is not showing the Smallworld reader. Please help me in this regard. Thanks in advance.

Hi,Would like to assign color to elements through colorbookIn AutoCAD Instead of Index Color, I would like to assign Color(ColorName) from the ColorBook (.acb file)I am not able to find FME attribute where I can set this value.Please suggest.RegardsZubair

FME 64bit hangs reading or writing to Geodatabase SDE (Oracle). I have ArcGIS 10.2.1 with background processing installed? When I run the workspace it hangs. Why is it hanging?The two last lines in the log file are:INFORM|An ArcGIS license is already checked out. The product checked out is 'Advanced' 2016-09-19 INFORM|Installed ArcGIS version is '10.2.1'

What happened to the Autodesk GIS Design Server (VISION) GINA(General INterchange and Archive) file format in FME 2016

My workbench uses an s3downloader to acquire a DWG, then uses a FeatureReader (Autocad DWG) to read in model space data, then I add a few layers to model, using a FeatureWriter (Real Autocad DWG) with original DWG as a template, and finally upload updated model to s3, using an s3uploader.The workbench completes without any errors in the log, but my updated model does not contain any of my original layers. It only contains the newly added layers. Further, the log states the following, "No AutoCAD Template file specified". Yet, the FeatureWriter has a template file specified (I save the template file as a parameter).Any thoughts? Thanks for your support!

Hi,I'm now working at Stedin, one of the Dutch electric and gas grid operators.I'm trying to do some analysis of land rezoning using the Dutch national development plan. Basically I want to checking if agricultural land has changed to industrial or residential use. The data is available to download from PDOK; however the GML file available (Enkelbestemming.gml) is 6Gb. I'm able to read and write 1.2 million of the polygon features with FME Desktop 2016.1 but then I get the following error:Error in input dataset:'file:///C:/Apps/Temp/Bestemmingdata/Enkelbestemming.gml' line:43002043 column:24505 message:input ended before all started tags were ended; last tag started is 'gml:posList''Is there anything I can do to fix this file or do I need to contact the data owner which is the Kadaster? I don't have a file editor that opens the file.Perhaps there is a better way to achieve this task?Thanks,Annette

I have a KML transformation workspace that seems to create the placemark (lat/lon) in the correct location looking at the text of the KML, but when it renders in Google Earth doesn't appear in the correct place. Has anyone seen this before. I have attached the KML. The icon should be placed on the final position of the aircraft which is close to Riverside Airport. Instead it places it closer to the beginning of the flight.

Hi,I'm trying to write existing features into a relationship class with the new SDE writer. My source and destination features already exist, and I want to populate the relationship class with the known PK of each features, but it seems impossible with this writer. I follow this article : https://knowledge.safe.com/articles/28340/working-with-geodatabase-relationship-classes-atta.html, but it seems we can only write to relationship class if we also write the corresponding features in their tables.Is there any way to write to a relationship class like a regular table?Thanks

I am currently translating from Microstation and want to take attributes from a cell and a text node and combine them to output one object. The cell and the text node do not know each other so I am guessing a neighborfinder will need to be used. I have been struggling on how to get it all done and was hoping for an example :)

I find that when I add a featurewriter to my workspace and try to open the settings FME crashes. How can I find out what is causing this? I can add another writer to the workspace, but it crashes when I try to get into the settings.It is a relatively decent size workspace with about 10 readers/writers and just over 140 transformers.

Hello,Is it possible to create a new schema in a PostGres/PostGIS database using FME?Thanks

I have around 1300 las (lidar) files. For these las files i have a few shp files with breaklines and polygons where i should remove the ground. (houses/lakes/rivers)I need to export contour lines for each las files using breaklines and also remove the ground inside those polygons.Each block should have a buffer around them to fix the problem on the edge.So i need to load each block with the buffer around it and generate contours after removing the ground and also to use the breaklines.But here is another problem. i need to drop the lines first and filter them out base on z difference of each vertexes and keep only the original line that fits the z difference.Now what i know to do so far (on a single block):i manage to filter the lines. is there a transformer to simply this? right now i compare each line start z and end z against each otheri know how to generate contours with breaklines.i know how to remove points inside polygons.i know to create a buffer around a tileWhat i don'

Hi!I'll try to describe my situation first: I heed to transfer data from an old database (DB) into an ArcSDE-DB (based on Oracle). In this old DB, I have feature classes (FC) that have many-to-many relations with each other. These relationships, however, are stored in a single FC in the following way: 'Origin_FID | Origin_FC | Destination_FID | Destination_FC'. I transferred the FCs into the ArcSDE-DB, enabled archiving and created N:M-relationship classes (RC). By using FME, I want to write the relationships from the FC in the old DB (filtered according to the respective FCs) into the RC of the new DB.The data and relationships have to be written not only als an initial, "complete" load, but also regularly in the form of incremental updates.My actual problems: On this FME-page, I've found a way to write data into relationship classes. Unfortunately, according to this tutorial, the ObjectID (in the form of geodb_rel_origin/destination_oid) must be present. In

I'm relatively new to using the ArcGIS for Server Data IO extension and I have experienced an odd behavior, that I think is unintentional:We have created an ETL tool in Workbench. The tool can read multiple shape files and converts them to different featureclasses in SQL Server. The input is set as a user parameter.When running the tool in Desktop (ArcMap) the input dialog automatically filters the file types, so the user will only sees the *.shp files in the directory he browses to. Different *.shp-files are selected, and the tool converts the data as expected.We then publish the tool as a service on ArcGIS Server (10.3.1) with Data IO extension. After publishing, the tool (GP-service) input dialog is opened, but now you'll have to specify all parts of the shapefile (shp, dbf, shx) in the directory - otherwise the tool will fail. This is not very convenient to an end user that could easily mistake something in the directory browser...Am I missing something here in my setup/con

Hi everybody,Anybody knows why if I have a map in V8 of 712 elements , the indicators of FME indicated that in the conversion has been converted like 14.000 ???. The ouput is correct only there are 712 elements but in FME appears that 14000 has been converted.The conversion is from V8 to V8.Thanks in advanced for your help !!

Hey,i try to write some Features with two Attributes A and B into an excel-sheet with an Excel Writer.It allready works but I want to write the Name of the Attributes into the first row of the sheet, so that it looks likeA | B1 | 32 | 23 | 4... | ...Is it possible? Thank you for your helpNicole

Is it possible to generate an empty ffs file?I have a data conversion process where some optional datasets used in a workbench might not exist. I do not want to use the Ignore Failed Readers option, as I want the translation to error-out if the required datasets are not present. A predecessor workbench will normally generate these optional ffs files if the input exists, but if no input exists, no ffs is created. I cannot find an option for the workbench to write the ffs file even when it has no input. I could also potentially copy an empty ffs file into the expected reader location, but I cannot figure out how to generate an empty ffs file.Or could this be handled a better way?Using FME Desktop 2016.1.1.0

I've created a simple workspace that streams tweets, does a point in polygon and and writes results to a CSV file. Now the Tweetstreamer is a perpetual streamer - i.e. it requires manual intervention to stop. The problem is that the CSV writer appears to flush all the writes only after correct completion of the workspace. If the user manual stops the workflow (as required by the Tweetstreamer) the CSV writes are not flushed and data is lost. Is there any way to automatically flush the CSV writing after each record (or another workaround?)