Data

I have a database with fields for x-coordinate, y-coordiane and a textstring. Now ik have to create a Microstation dgn-file with the middle of the text on the xy-coordinate.I'm using FME Desktop 2015.0 In the workbench I start with a VertexCreator. Then I use LabelPointReplacer to place the text at the coordinate, but the coordinate is at the bottomleft corner of the text. When I set igds_oiginal_justification to 7 (centre-centre for Microstation), the coordinate moves to the middle of the text. So the text is not on the correct coordinate.How can I move the middle of the text to the coordinate?

Hi,I have this string for example : "Hello-World! Let's talk-about-you!"If I want to know the number of "-" (here would be 3) into that string, how could I do that with a transformer?Thanks!

Hi,I have created a graphic ORACLE table from a CSV file. The CSV file contains the coordinates X and Y to create points. Now the ORACLE table contains the points but the graphic column contains null values. It seems that I must : 1. Check the types of geometry it is passing to writer (i.e. line / point) , but how to do what ? 2. Define the parameter " oracle_type " with an attribute creator, but which value "point" or "oracle_point" or "SDO_point" ?Thanks you for yours answers

Hi All,I have attached dgn reader and connected to dgn writer (No transformers in between). Both reader and writer are V8 files and I have enabled "Write Tags" to "Yes". I'm getting the output dgn file without tags.Is there any action/option shall I have to do to get tags in target as present in source.Pratap

I would like to establish a QA script for photogrammetrically derived point clouds where a flag is thrown if there are double layers. I am trying to find a way to detect points on top of each other, or some other method of finding double layers of the same data.

I am trying to create routes for multiple inspectors in FME. I think ArcGISOnline Router may be the way to go. Has anyone tried it out? If someone is using some other method, what would they recommend?

The error says "SmallworldWriter Error: Object unset does not understand message field()with arguments: :fme_feature_type".Steps I have followed:-1- Opening a smallworld image.2- Making the alternative writable.3- TICS server was running on 30000 port.4- Mapped the reader to shape files, the writer configuration was given as local host & 30000 port. But the object & attributes got mapped to the writer directly from reader.It's easier to export data from smallworld, because the reader identifies the dataset & lists the objects. I am not sure about the the writer though.I am new to FME, please help me.

HiI am trying to transfer data from Oracle sde database from one server to other with same environment. But when i add reader and writer these get other columns but miss shape column.Please experts guide me.

Hi!We're stuck on a 3D geom linestringz import into a postgis 2.0 database. Seems not possible on FME 2014, right?Is it possible on newer versions?Working around with sql executer.

Hi, I want to copy files based on workspace result values. Example: a, b, c builders are applied for tenders of xyz road construction. All 3 companies tenders are integrated into one document and named as xyz road (its same as fme workspace result road names)so when fme workspace result record contains xyz road, then pickup "xyz road" excel/pdf tender files and copy them into a specified folder path (or create new folder and copy files). Any guidance on how to check the result road names with external files present in a directory (Lookup tables?)? is it possible in an easy way to automate it ? How can i compare result and copy respective files into a specified folder. Any guidance is helpful.Thanks,khk

I have an xml with feature bag_LVC:Pand with this structure (example): <bag_LVC:Pand>  <bag_LVC:identificatie>0003100000117485</bag_LVC:identificatie>  <bag_LVC:aanduidingRecordInactief>N</bag_LVC:aanduidingRecordInactief>  <bag_LVC:aanduidingRecordCorrectie>0</bag_LVC:aanduidingRecordCorrectie>  <bag_LVC:officieel>N</bag_LVC:officieel>  <bag_LVC:pandGeometrie>  <gml:Polygon srsName="urn:ogc:def:crs:EPSG::28992">  <gml:exterior>  <gml:LinearRing>  <gml:posList srsDimension="3" count="17">254059.737 593504.637 0.0 254059.227 593500.0 0.0 254059.216 593499.899 0.0 254058.242 593500.0 0.0 254057.914 593500.034 0.0 254057.893 593500.0 0.0 254057.807 593499.863 0.0 254052.074 593490.692 0.0 254052.182 593490.639 0.0 254058.138 593490.002 0.0 254057.932 593488.165 0.0 254074.487 593486.413 0.0 254075.981 593500.0 0.0 254076.265 593502.583 0.0 254076.561 593502.55 0.0 254

I am a newcomer to using FME products. I have been reading several documents relating to my question. However, I would like to have an answer directly from your staff.We are a two shop software (Bentley Product) MS – used by our designer. GIS – used as an asset management tool.At this time we are also maintaining our assets data in MS as well as in GIS. The purpose for this practice is that our designers are able to consume the historical data while designing a project from our MS asset registry data repository. This process is becoming a lot more Painstaking an enormous amount of work for our MS and GIS staff as well as major duplication of effort. My goal is to be able to maintain one assets data repository (GIS) and have our designer consume this data in the MS environment thru a conversation/extract tool from GIS to DGN. At the same time, thru transformation, be able to maintain and display the feature Standard developed by our designing staff with the collaboration of Bentl

??FME???2D?shape?????????????KML?3D??????????????1.??2d?KML?????????????????cad???cad??????? 2.????????KML????????????????? 3.??????3dForce?KMLpropertySetter??????3dKML???????????????KML?????2d???????   ??????????????????????????   ????????????????????????cad????????????????fme????????? https://knowledge.safe.com/articles/18762/basic-3d-kml.html

I try to follow this instructions https://knowledge.safe.com/content/kbentry/109/forcing-upper-case-attribute-names-when-writing-to.html but it seems that it is for FME 2015 and the metafiles are different.

Hi i've only just started using FME (2016) so this is likely a very simple problem. i've created a workspace that takes a series of MI tab files, and re-maps some attributes to a writer. it works fine. now that its finished i want to run the same tool again with different data (same structures). what is the best way of doing this?i've tried right clicking on the reader > edit 'NAME [MAPINFO]' parameters and changing the data there and that doesn't seem to work when i run the tool. nether does reader menu > update feature types.Data_1 Col_A Col_C Data_2 Col_C Col_B Data_3 Col_B Col_A  Output Col_A Col_B Col_C

Converting a shape file to a MySql table and all is working with the extraction of each attributes except i can not identify the latitude and longitude values that represent the point geometry. Can any one help me with how I identify and split out the coordinates in a shape file. thanks

hi,I am working on CAD to geodatabase: for which I will have .mdb(esri pgdb) as output, can I check how do I create a modal to push this mdb file into ArcSde, such that every time I run this modal it will append the new data. This will help me convert the data for different areas and migrate them in ARCSDE.Appreciate your suggestion ThanksAnshul

Hi,Although, I have worked with transformers but I am fully new to XMLs.I have an XML input file, but, unlike other XMLs, when I open this xml in notepad++, its as good as a text file only. Its not parsed ad segmented. Although, I tried some transformers, but didn't work. Once these XMLs are written, I would like to split it in 50 attributes in each file. Anyone with the solution !!

How can i manipulate a Excel spreadsheet when i want to write exactly 500 features each sheet?GreetzFranco

I have access to the sde30 reader but it is greyed out in the list of availible writers. I found this article https://knowledge.safe.com/articles/358/arcsde-lib...but I don't understand why the reader is available but not the writer, seems like the reader would need the sdk and dlls as well as the writer.

As a developer I want to automate the deployment of fme workspaces So that I can deploy fme code alongside the rest of my solution  Given that I have one or more fmw files that have been developed using FME desktop as part of a wider solution When I run my silent install/automated deployment Then there is an FME server workspace for each source fmw file and the workspaces are in the correct target repositories and these are available to the solution through the rest api  On install, the default workspaces of fme server 2014 SP3 are installed using a script (configureDemoWorkspaces.bat) that calls out to java and a class (WorkspaceServiceInstaller) which uses an xml file (serviceWorkspaces.defs) to control which services to create - Is the WorkspaceServiceInstaller java class documented anywhere?

Hi,I have Oracle table with 2 geometry in 2 columns (B_ETYKIETA_GEOMETRIA, B_ETYKIETA_ODNOSNIK). I need to transform it to GML with geometry columns (geometriaKarto, odnosnik) but in my process FME chosen only one geometry table B_ETYKIETA_GEOMETRIA. How can I choose and transform geometry from B_ETYKIETA_GEOMERIA to geometriaKarto and B_ETYKIETA_ODNOSNIK to odnosnik?

I am trying to write to several PostGIS databases. I can write to the version 9.3 with no trouble but cant to 9.4 or 9.5. I am trying to rule out incompatibility between FME and Postgis before I reinstall the PostGIS databases.

I'm still pretty new at FME Server. How do you determine the FME Server email address to send email data to with attachments? I'm at a loss to figure that out.

Hi,  I would like to use the ESRI Shape Writer in the dynamic mode. It works but it writes the shapefile by default with shape_polygon z and m.   I tried to change the settings in the configure dynamic schema parameters to 1. fixed Shape_polygon --> same result 2. First feature defines geometry Type (the geometry type is 2D) --> same result    Roger mentioned the same issue the 22. January: http://fmepedia.safe.com/CommunityAnswers?id=906a0000000cuXjAAI  I use FME(R) 2014 SP2 (20140528 - Build 14336 - WIN32)  Any idea?