Data

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   

I'm curious to know if someone in the community has attempted to do transformation from xml to jsoninsights appreciated

Does anyone have a good way to extract the center point of a text string from DWG format?In the past I've had very good luck in DGN format using a Bounding Box and Center Point Replacer.However in these DWG's I have, the Bounding Box appears incorrect. In the image the problem is exaggerated, I believe Inspector is enlarging the texts compared tot he DWG size. The closest thing to the center point I've found is the upper right corner of the BB, but results are inconsistent, especially for text placed at an angle. Image shows text string, insertion point, BB calculated by Bounding Box Replacer, and the BB center.  

I am new to fme and trying to read kml files from an http address, where the files may be spread out through different directories.I would like to recurse through the directories and find all the .kml files and write the placemarks out to a AGOL feature service.My issue is I do not know how to gather the .kml files from the http address. I keep getting errors about reading from the address and 404 with the http response. Should I be using the HTTPCaller, or can I simply use the FeatureReader or a direct KMLReader?I have tried all three, but with no success. Any help would be appreciated.

Hello, I have just started doing a bit of raster analysis in FME and was wondering if there was an alternative to the zonal statistics tool in ArcGIS? I have a raster grid containing landuse areas and need to sum them up to calculate total area, a tool to sum an entire raster (minus nodata values) would also do the job. Thanks very much, Ed

Hi, I want to be time efficient when updating a very long domain list in a SDE Geodatebase. I have created the new domain values in an excel document and would like to empty the current domain list and refill it with the values in this document. The geodatabase of course contains a name for the domain list, a field for the code and for the description. The excel i structured in the same way; a column for the code and a column for the description. Therefore it's essentially a copy/paste job from excel to geodatabase. Can anyone suggest at workflow with translators that can do such a thing?In the future it would be hugely beneficial for me to have a workflow that would read through the list and only add/write the values from the excel file that are not already in the domain list. Thanks for your time and tips,Sofia

When writing kml folders, how do I control the order they appear in the GE table of contents. It doesn't seem to be the order they are in the workbench or the creator number. Also I'm currently not getting any shape to kml translation, missing something easy in there. The goal is to eventually spilt nautical chart outlines by scale (ive done this in another workbench) and then conditionally pipe them to each folder by scale, but one thing at time. 

Hi How can read an Access DB stored in Sharepoint of my company ? Thx Francesco 

I know I'm well behind the times but has the formatting of an output (writer) ESRIJSON changed since FME 2012? If i use FME 2102 to extract 1 polygon from an ArcSDE 10.1 database and write it to ESRIJSON, attempting to use the standard ESRI "JSON to Features" (ArcGIS 10.4) tool errors out with a :"ERROR 001558: Error parsing json file ......".  Is there a difference in output format since FME 2012?

We just upgraded our AutoDesk products to 2019. Is there an FME plugin for Revit 2019...or will the 2018 plugin work with Revit 2019?

I have not seen a straight conversion for DWG to IFC. I have everything I need in the DWG, I just want to turn it into an IFC. there are no attributes or any other data besides 3D geometry.I'll settle for FBX to IFC, OBJ to IFC, DXF to IFC, etc.

Hi i have attached 2 ways i carried out my transformation from esri shapefile to citygml. The first way is shown below in the attachment. However, I am not able to upload the final citygml file into an online portal as it says there is an error with the file. I am not sure where i went wrong in my transformation. Can someone please help? Thanks.For the second way, i just used attribute creator and geometry setter after i extruded and then used the citygml writer to write the file. The forum that explains this is as follows. https://groups.google.com/forum/#!topic/fmetalk/R6QGevN7uGY

I am unable to run data from a PostGIS reader through a change detector against another reader type and get a match. I have an AutoCAD line layer that has been loaded into a PostGIS_linestring feature. When I compare the two features using the change detector, there are no matched features. I have tried several things:Removed all attributes from each featureExtracted the geometry to an attribute and only compare on that attributeForce both feature to 2DI have also tried pushing the AutoCAD data into SQL Server (GeoMedia format) and using that to compare against the PostGIS feature, with the same results.Can anyone provide any suggestions? Has anyone successfully used the change detector against a PostGIS reader?

I have a workspace that converts data from an IFC file to PostGIS. The IFC file contains data I would like to convert in IfcPropertySingleValue elements. Multiple IfcPropertySingleValues are combined in an IfcPropertySet, which is related to a IfcBuildingElementProxy element by means of a IfcRelDefinesByProperties. Converting the IfcBuildingElementProxy elements works, but I would like to have the related data in the IfcPropertySingleValue elements too. How could that be achieved? The classes IfcPropertySingleValue, IfcPropertySet and IfcRelDefinesByProperties do not show up as feature types in the IFC reader.

We are using FME to export some graphic geometry objects to microstation format. We are successful in writing simple text elements(single line text) using "igds_type = igds_text". But we have some multi text elements to be exported which we could not write using "igds_type = igds_text". Since this requires to build a complex element with a group of text strings under a text node, we thought we can do it using igds_multi_text type. So, we wrote the following code in VB.  Dim fmeFeatureObj As FMEOFeature    fmeFeatureObj.geometryType = FME_GEOM_POINT    fmeFeatureObj.attribute("igds_type") = "igds_multi_text"    fmeFeatureObj.attribute("igds_text_elements{0}.igds_text_string") = "Line1"  fmeFeatureObj.attribute("igds_text_elements{1}.igds_text_string") = "Line2"    //{comment: Set other attributes like size, font, rotation, justification for the "igds_text_elements{0}" and "igds_text_elemen

I've just updated from 2018.0 to 2018.1, and now the MS Access reader is very very slow. Prior to the update, it would read in a matter of seconds, now the same file is a matter of minutes.I've checked, and can confirm that both FME & MS Access are 64-bit, I have the correct linking files, and yet reading is still slow.Can anyone advise any other elements to check?

How can we fix an error like:plugins/udatasmith_fme.dll' was found but could not be loaded. Ensure that all the dependent modules exist for this libraryI already know the answer, but I wanted to share it with all of you good folks in case it's a problem for you too!Quick fix: Install Unreal Studio (https://www.unrealengine.com/en-US/studio) or install DirectX SDK from https://www.microsoft.com/en-ca/download/details.aspx?id=6812 The Details:Most likely your computer already has the necessary DirectX components, either from an Unreal Studio installation or from another application. However, there are some cases where these components may be missing. For example, you are likely to encounter this issue when running a Windows Virtual Machine.In any of these cases, you can install the necessary XINPUT1_3.dll by installing Unreal Studio or the DirectX SDK from the link given above. A bit of trivia: XINPUT1_3.dll is used for getting mouse input in DirectX-based games.

Hi,  Im having trouble writng to dgn with fanout on fme _feature_type, I get 0.0|ERROR |Couldn't extract a numeric level from the feature type `M-Korbanelinje'  see the image below.  It works fine If I dont use the fanout and just write everything to the same layer. In dgn v8 it works fine to use the fanout function for the layers within the file, why does it not work in dgn v7? Anyone that knows about this?  Best/ Johan

HyI need to read several excel files and remove a lot of columns (fields) so the usage of attribute manager isn't efficient How can do this in smart way ? thx Francesco