Data

I have a workbench with CSV readers. Now I updated the CSVs and some of the attributes changed names (e.g. from GAS Service Connection to Service Connection). Is there a way how to update single attribute instead of updating the whole reader? Thanks, Jan

Lets say I have a routine with a writer and I run it. Now I want to run the same routine without having to change the writer file name. I want it to delete the old file and create a new one or Override the old file. How do I change the settings in the writer to do this?

Does anybody know a WFS link with up-to-date traffic information?It can be anywhere in the world.It has to be free of charge as I want to use it in a demo showing the WFS capabilities of FME.Thanks for any help,Erik Jan

Hi,I've run into a problem writing to tables in several different Oracle schemas using FME Server. In my workspace I have 5 different Oracle Spatial Object writers that I will write to depeding what data comes through. The Oracle schemas (users) are created with a .bat and several .sql files.The problem is that I only seems to be able to write data in 2 of the 5 schemas (the only differences between the schemas are password, srid and extent. All those have been verified). For example, writer 1 and 2 works but not number 3.If I delete all schemas and only create a schema for number 3 FME Server can write to tables in that schema. If I create all schemas (1-5), only number 1 and 2 will work.There are no differences between the Oracle schemas and FME will write data to all if I execute from Workbench. Unfortunately, I can't get it to work on FME Server. I have checked and rechecked the Oracle, FME Server and log files and I can't find any suspicious (connection ok, parameters

I am trying to Migrate CSV data into Smalworld by using FME.Using FME CSV_Reader for reading CSV data. I convert ‘X’ and ‘Y’ values into X_Coordiante,Y_Coordinate”.After this I am using “vertex creator” for creating point with “X and Y coordinates”.After that I add the vertex creator to “attribute creator” for attribute mapping. Here I got confusion what is the attribute name given for point geometry.But when I migrate data by using this the attributes are migrated successfully. But the geometry was not found.Previously I migrated ESRI Shape file data into smallworld by using FME successfully. In that I used “Attribute name=sworld_geometry{0}.sworld_point” for geometry mapping attribute connector.Can anyone tell me how to insert CSV coordinates point geometry into smallworld by using FME?After insertion “NOKTA, CBS NO” values are inserted. But geometry not showing in smallword.Summary: I am trying to migrate CSV file data into Smallworld along with geometry by using FME.

I'm trying to write a GML-File using a workbench and a xsd-schema-file, which I got from someone else, but I get an error. Obviously, there's something wrong in the xsd-File, as this error occurs when the schema document is beeing parsed, but how do I find out, what exactly is wrong?(And strange enough, it used to work, I used to be able to generate the GML ...???) The workbench used to be FME2015, but now I use FME2016, but get the same error in 2015 and 2016.Creating writer for format: GML (Geography Markup Language) Trying to find a DYNAMIC plugin for writer named `GML' Loaded module 'GML' from file 'C:\\Program Files\\FME\\plugins/GML.dll' FME API version of module 'GML' matches current internal version (3.8 20151127) FME Configuration: No destination coordinate system set FME API version of module 'GML' matches current internal version (3.8 20151127) Writer `GML_1' of type `GML' using group definition keyword `GML_1_DEF' FME

I have a 3D CAD drawing consisting mostly of disconnected lines and a few circles - see screenshot. When I try to export it to IFC with AutoCAD, all it outputs are six small circles which aren't even visible in AutoCAD on import (only Solibri Model Viewer), so I'm trying to do it with FME. I've played around with an autocad-to-ifc tutorial* however I'm not really getting anywhere. Right now I'm using the 3D enforcer with autocad_extended_data{0}.world_position{0}.z and that seems to elevate the lines properly in the inspector. However both autocad_shape_height or autocad_extrusion_z do the same, so I have no idea which would be the right one to pick. Sadly when I use the IFC writer, it outputs a 2kb file despite saying it wrote 2722 features. How do I do the transformation? All I want is to go from one format to the other and copy all values. * https://knowledge.safe.com/articles/595/autocad-t...

HiI have to draw lines between two points with different attributes. They have a common number but in another field.All point have to be connected with a line to the networkI have already made a table with the coordinates of the beginpoint and the endpoint in the same record.As the endresult i have to become lines with a unique Id and the attributes of the point where the ID starts with HP_.Can sombody help me please?Thx!Nathalie

Hi,I have a dgn file with dimensions for which value of each dimension is edited i.e. If we measure between the dimension lines then it is 105.456 but the dimension value has shown as 500.When I have seen in inspector it shows 105.456 but not 500. Do any one knows in which attribute does the value (500) store???

Is there a parameter that needs to be set or a specific trick to getting the legacy ESRI sde writer to update archive tables when inserting records?The current setup is as followsA direct connection to an ArcGIS v10 geodatabase in an oracle 11g database, writing directly to the DEFAULT database version. The schema for the feature class is derived from a workspace resource pointing at the same sde database with the same connection detailsThis correctly updates the Adds tables for the versioned feature clases but no records are inserted into the archive tables. Is this just a product limitation, a bug or am I missing something?I can get the archive tables to update correctly when using the ESRI Geodatabase writer, but want to avoid this due to the ArcGIS license requirements and the performance benefits of the legacy writer.

Does anyone know if it is possible to load ArcGIS Server feature services to ArcGIS Portal or will FME only work with the free outward facing ArcGIS Online.  Thanks 

Using FME 2016 writing to DGN (v8)Having trouble with custom linestyles that contain point graphics displaying within my DGN file after translation. I cannot draw or even change an existing line to one of those styles. These linestyles exist in the seed that I have attached to the DGN Writer and I can draw them within the seed. Note all other non point linestyles within the seed display correctly in the translated DGN. Any ideas?

I have a json object that contains nested arrays, a simplified example is:{   "Attr1" : [{      "Attr2" : [{         "Attr3" : "A"  }         ]       }, {      "Attr2" : [{  "Attr3" : "B"  }, {  "Attr3" : "C"  } ]       }, {      "Attr2" : [{         "Attr3" : "D"  }, {  "Attr3" : "E"  }, {  "Attr3" : "F"  } ]       }      ]}I would like to extract just attr3, either as a (complex) list, or a valid json ex. [{"Attr3":"A"},{"Attr3":"B"},{"Attr3":"C"},{"Attr3":"D"},{"Attr3":"E"},{"Attr3":"F"}]  If I use the JSONExtractor with json["Attr1"][*]["Attr2"][*]I get {"Attr3":"A"}{"Attr3":"B"}{"Attr3":"C"}{"Attr3":"D"}{"Attr3":"E"}{"Attr3":"F"}'without commas between elments.  The JSONFlattener with recursion does work, but the actual json has a couple of hundred additional elements, and I would like to avoid creating them unnecessarily if possible.

Reading a csv file with null entriesID, A, B, C, DQA123, 1,2,3,4QA456,,,,Into a table with character_varying, numeric, numeric, numeric, numericWriter fails on line QA456 with errorError was 'ERROR: invalid input syntax for type numeric: ""CONTEXT: COPY table, line 2, column A: ""How can I deal with this issue?ThanksUsing FME Desktop 2015.1

Hi,I have dgn files will features having unique number for each graphic group. I want them to convert them to graphic cells (CTRL+G in Microstation)Is it possible with FME?Pratap

Basically converting an ESRI polygon Shapefile or FeatureClass from spatial to non-spatial in a format ready for Tableau (i.e tabular like excel or CSV). Have researched and tested some possibilities but would think there are some quick start workspaces available from Tableau and FME users.Have some ideas that successfully converted polygon vertices to points (helpful VertexCounter)Other transformers helpful are DonutHoldExtractor, 2DForcer, Counter, Generalizer?, CoordinateExtractor - just hoping something already exists.

Creating PDF file from a .mdb access database

I want to make polygon (trapezoid) from each line segment that has information about trapezoid width at start and at the end.Is it possible with FME?

Is it possible to convert Access .mdb to .xml format

I want to use a UserParameter to define the OutPutFile, here a FileGeoDatebase.The Path and Filename generated generically in the Workbench.To make the Attribut to a Parameter is using a AttributCreator.The ParameterType ist testing with Text, Folder (Output), Filename (Output).No success

I'm new to FME.I've created a workspace that reads one Microstation V8 (dgn) file, and several shapefiles. It reads all features from the .dgn as well as all features from the shapefiles and outputs them into two new .dgn files. The first output file contains all features read, while the second one only contains the features from the shapefiles and not the features from the .dgn.Now, I actually need this to run on a whole bunch of datasets, so I exposed all of the input files as parameters and run it from a batch file. The default value of all the parameters is the files for the test dataset I was using. When I run the the workspace on the test dataset either in FME Workbench, or on the command line, everything works perfectly. When I run it on any other dataset, none of the features from the shapefiles is written to the output .dgn files. FME reports warnings, but the translation is always successful.I've attached the workspace file, as well as logs from a successful

Hi,I have used a dgn file with "Expand Names cells" as "Yes". I want to make cells again as it is before...Is it not possible to make the cell again without cel library?BTW, I have used aggregator with igds_type=igds_cell but it output is coming as same lines.Pratap

I have an excel spreadsheet with years of maintenance data (2006-2015). I need to join that to our current pavement database, but in order. So if something was done to a road in 2007, and again in 2014, I need it to join the 2014 data (over write the 2007 data). Not sure if this matters, but not everything will match from the spreadsheet to the existing database (many fewer records in the excel sheet as we do not do something to every road every year). I've tried joiner, but no luck. In the parameters you can select all of the spreadsheets to read, but in the join section, you can only pick one year? Doesn't make sense to me.

Hi,in my reader, I use the GUI TYPE "DYNAMIC_MULTI_SELECT_COMMAS" [1] so a user can selects/types some values. The sections in my metafile are:DEFAULT_MACRO HOST localhostDEFAULT_MACRO PORT 8080! ...some more codeDEFAULT_VALUE HOST $(HOST)GUI STRING HOST Host:DEFAULT_VALUE PORT $(PORT)GUI RANGE_SLIDER PORT 0%65535%0%OFF Port:DEFAULT_VALUE LAYERLIST $(LAYERLIST)GUI OPTIONAL DYNAMIC_MULTI_SELECT_COMMAS LAYERLIST HOST,$[HOST],PORT,$[PORT] Layer Names:This works fine, but  whenever I start a translation, I get the error:Undefined macro `HOST_MYREADER_1' dereferenced in file `C:\Users\User\AppData\Local\Temp\wb-xlate-1456160185578_8088'Program TerminatingTranslation FAILED.caused by $[HOST] in the DYNAMIC_MULTI_SELECT_COMMAS line. I can fix this by generating a Published Parameter called HOST_MYREADER_1 in my workspace, but I would like to understand the error. What is the problem here? I have created a macro called Host (and Port), why does FME crashes here?Another solution is  DEFAULT_VAL

I have been successfully using the GoogleGeocoder transformer (https://store.safe.com/transformers/googlegeocoder... to obtain coordinates based on addresses and intersection input for some time. (Thanks for that, by the way!) However, I am now being asked to generate intersection and address information based on X/Y's. Is there such an animal out there that already exists? Any thoughts on amount of effort to modify the GoogleGeocoder to provide that functionality?Thanks,Adam