Data

The logfiles for FME-server are put in the following location: ...\\Logs\\engine\\current\\jobs\\Would it be possible to write the logfiles to a database (SQLserver, Postgres) instead.

Is there someway to automatically add an IDENTITY column when writing to SQL Server spatial?I've found MapInfo data inserted into SQL Server spatial is flagged as invalid when I try to load it in QGIS. The solution seems to be to add an integer "id" column, which I set as an IDENTITYI can manually add the ID column after a first run of FME has created table plus columns. Then truncate the SQL table and run the workspace a second time to populate with the actual data and the ID column set by SQL Server.But I've got a lot of MapInfo layers to migrate, so is there a better way to do this in FME?

I use FME to change Esri shapefiles to Netezza Spatial all the time, until last night. It is only writing out a fraction of the rows. I don't understand why. I have tried both a polygon shapefile and a line shapefile. The shapefiles are fairly small -- 20-4,000 features with only 2-15 attributes.

FME says I need to scale it down however no matter how much I scale it the z value is always negative. I also have the exact same area as an excel file that I can use for converting. would this be any easier?

I have a road network with 1 attribute field (Road Name).There are duplicate values (road names) in this list (either same road name exists in two or more different towns OR the road is in multiple segments with the same attribute value).How can I split these duplicate road names out so I can process separately?I've tried Attribute Validator (unique) and Duplicate Filter but as you probably know, these transformers only split the second, third, fourth etc occurrences of a duplicate value, leaving the first occurrence in the "unique" (Duplicate Filter) or "passed" (Attrribute Validator) output.I also tried a tester after the Duplicate filter, ie, renamed Duplicate output attribute to DUPE and tested to see where Unique output was not equal to DUPE to leave me with a true unique set of road name attributes. All failed.Any help appreciated.

I am trying to connect to the following WFS link to obtain the data but can not get anythingThe link is http://environment.data.gov.uk/ds/wfs?SERVICE=WFS&INTERFACE;=ENVIRONMENTWFS--86ec354f-d465-11e4-b09e-f0def148f590&VERSION;=2.0.0Any ideas what is wrong??

Hi people, first of all sorry for my bad English. Is there any function who helps me to fulfill the empty spaces with the color around it? There must not be any blank space in it. how should I do it? Thanks

Hello,I am converting Microstation DGN (V8) to AutoCAD Map DWG (2010) file, reading DGN file as group by Schema - Level NamesIssue is OD that is created also has some Tag/DGN internals as attribute.e.g.CONTRACT_NO, CONTRACT_NO_name, CONTRACT_NO_prompt, CONTRACT_tagset_name, CONTRACT_NO_tagtype, CONTRACT_NO_value, igds_color etc.In above list only CONTRACT_NO should be created as OD attribute rest is not required, How do I restrict it not to write these Tag internals.I have used Attribute remover, bulk attribute remover , schema from Table but it has no effect on how the OD is created.FME Vversion = 2016.1RegardsZubair 

I convert shape files to autocad.....have given the different shape files an certain color index and write that index in the autocad_color attribute. But the default_color which is given in the Format parameter in the output autocad file is e.g. red and every layer is shown with red color in the layer table....the laye ritself has the right color (given by me)...how can i change that default_color? I want that every layer has the right color also in the layer list  Thanks and greetz Franco

Hi thereWhen I try to translate some TAB files to shape files in FME, I keep getting the errors:ERROR 3: InitBlockFromData(): Invalid Block Type: got 0 expected 2 ERROR 5: GetNextFeatureId() failed: unable to set read pointer to feature id 1GetNextFeatureId() failed: unable to set read pointer to feature id 1 Closing native MapInfo readerFailed reading feature from MapInfo fileCould anyone please tell me what this means?

Why is FME imported data into SQL Server not being found by QGIS? I've imported some MapInfo format data into SQL Server 2014 using FME. In SQL Management Studio (SSMS), I can do a query and the spatial results tab shows the various polygons as expected But if I switch to QGIS and connect to the database, but the data set isn't showing I have also loaded data using ogr2ogr and those data sets are showing, and can be displayed on a map in both QGIS and SSMS So why aren't FME loaded data sets showing?

Hey guys I'm converting an Esri Personal Geodatabase (.mdb) file into an Esri Geodatabase (.gdb)file. I need to include a new column in the new .gdb populated with data from another table. The column will be populated according to keywords within one of the columns in the original table and one way I have figured to do this is to run SQL Executor however, it doesn't look like SQL supports .mdb files. Is there any other way to do this or how can I work around SQL? I know this is a bit of a confusing or vague question but I'm very new to the world of FME and SQL

How do I view a seed file in Data Inspector to check the igds_textstyle_id?

I'm building a QA data validation tool and the first step in the process if the data aligns within the extent of the state of Alabama and more importantly in the rightful location. How do I determine this considering that the DGN files may have different coordinate references, ie. local coordinate, grid, state plane, etc.

I've tried searching for this ArcObjects error and couldn't find this issue. My FME workspace works fine on Workbench but I'm having problems with it on FME Server. When I run it on the server it fails and I get this message:Could not create the File Geodatabase '~'. A possible reason is that you may not have permission to create the Geodatabase. The error number from ArcObjects is: '-2147467259'. The error message from ArcObjects is: {}What does this mean? I couldn't find this in Esri's list of error codes.

I am using the Esri Geodatabase (ArcSDE Geodb) writer in FME Desktop 2015 to write to an Oracle Esri geodatabase. However, when I put the workspace into FME Server I get the message: ERROR 0.0 1.7 2016-06-28 12:42:21 Unable to perform licensing related tasks. Please ensure that ArcGIS is correctly installed Is there another geodatabase writer that I can use for this task, or do I need to install ArcMap on the FME Server?Thanks

Is it possible to read from Excel documents that are protected by a password?

I'm try to establish an SHP-Minecraft translation, but in the 2016 version of FME, I had some trouble with the AttributeKeeper. I have an input SHP (point), connected with a coordinate extractor. After that, I attached an AttributeKeeper. I want to keep some SHP attributes, and the coordinates, extracted by the CoordinateExtractor. For some reason, the Keeper lost the XYZ coordinates. If I took try the same in FME 2015, the keeper will keep the attributes. Is it a version error, or I missed something?The following pictures shows the connection, and the settings. In the keeper, I cannot tick the mother attribute, just the children attributes (XYZ).Thanks for your help.Bálint

I would like to write the name of an ESRI file geodatabase (FGDB) at runtime based on the current date/time, for example C:\\Temp\\Output_20151207131034.gdb. How best to accomplish this? It's easy to do so with datasets and feature types but not the FGDB itself. Any suggestions would be appreciated.Thanks,Aaron

HelloI am trying to convert a json file into an excel spreadsheet with each json attribute in it's own column. I am playing around with jsonflattener and attributeexposer however this has been quite difficult. I was wondering if any expert could help. Many thanks! @takashiHere is a view of the json file

Hi,I'm constructing a workspace to import some XML files, and converting them to proper spatial features for storing in SQL Server. The XML format gives me some headaches, unfortunately.One of the XML files contains named nodes with XY attributes, the other file contains polylines with references to the named nodes. I got the start and end points handled, but the intermediate points are stored as an XML group of node names with zero or more items. The order of these are of course important.When importing the XML these items get converted into a list attribute, but what is the best way to convert this list of names to intermediate nodes in the geometry ?I've twisted and turned my head around this problem, but I can't decide whether the best course of action is to create helper features from the list, or create a list from the XY node features, or something entirely different. And if it's at all possible or feasable to handle fetching the XY via node names in a custom tra

Hi,I have tons of styled MapInfo datasets need to transfer to ArcGIS format, and I hope keep these styles automatically in ArcGIS. As there are some styler transformers, such as MapInfoStyler, KMLStyler, is there any way to create common style for ArcGIS shapefile/geodatabase.Looking forwards to hearing any suggestions.@takashi I followed your answers to solve many questions, hope and appreciate you may have solution for this question.

I am writing to a feature class in a geodatabase. My workspace is going to run everyday. Most of the feature classes should be overwritten. However, in one particular feature class, it is not overwriting, but appending. What can I do?I am using FME 2016.

I am using an Excel file and an ArcSDE geodatabase to detect the changes using change detector tool. The output is an excel file with the changes. The tool runs fine on the small excel file, but as soon excel file exceeds 50000 records the error appears.

Hi all,I was wondering if there is a way to influence the creation of DWG files, without the use of a template file, so that it would be displayed in meters as working units in Microstation?