Using readers and writers to extract and load data.
Recently active
I create a CSV and define the schema at creation. if I modify the csv, I cannot go back and edit the fields (add or rename) as all of them are grayed out, I can only delete and recreate the reader to do this update.. is there a way to edit the csv reader once created? thanks!
Writing spatial index on File geodatabase with a specific grid size
Hi,is it possible to create password protection on AutoCAD dwg files?Thank you.
I am trying to join attributes from three SDE tables into an SDE feature class. I keep getting an error saying "Column 'Customer_ID' of type 'char(50)' specified in mapping file but not defined in existing table 'PARKS.CEMETERY_SPACES_BURIAL_CUSTOMERS'", where 'Customer_ID' is a new field I'm adding from one of the joins, and 'PARKS.CEMETERY_SPACES_BURIAL_CUSTOMERS' is the feature class I want to write all of the results to (I have built it so it has all of the resulting fields already created, but it is currently sitting empty). Has anyone seen an error like this before? I'm using an Esri ArcSDE writer and reader.
Hi, I have an XML-File which I read with flattening. Part of the XML structure is something like:<element> <points> <startPoint> <value1></value1> <value2></value2> </startPoint> <middlePoint> <value1></value1> <value2></value2> </middlePoint> <endPoint> <value1></value1> <value2></value2> </endPoint> </points></element> StartPoint and Endpoint must occur once, middlepoint can occur many times. I have to transform this in a structure like:<element> <newpoints> <pointNumber> <value1></value1> <value2></value2> </newpoints></element> Obviously newpoints must occur at least twice. Any Suggestion how to combine those points with different attribute-names into the newpoints?Thanks!
Hi,so, is it possible to add digital signature to AutoCAD dwg file and how?Thank you.
When translating an object with multiple lines of text into MicroStation is there any way of setting the line spacing. Currently it automatically sets to "0"
My dgn file has a rectangle shape in level 60 and I'd like to extract all elements within that shape and create a new dgn file.
I have been asked by a colleague whether FME is able to read or write to Cadcorp's BDS (Base Dataset) or FDB (Feature Database) file formats. Initially I thought this would probably be possible as FME can read/write to a large number of formats but upon checking further it doesn't look like this is possible. There doesn't even appear to be any mention of these formats within the Knowledge Base or Community Answers sections of the websites. Can anybody shed any light on whether FME can read/write to Cadcorp? Many thanks
Hello,i have a shapefile containing lines (and data), some of them are viewed as IFMEMultiCurves containing several FMElines. When i get these into autocad, they are inserted as blocks with data. This is not ideal for me, but i could work with this. When i want to convert these back into shape file I not able to recreate the original shapefile. (I Get all of the individual FMElines, so far more objects than the initial shapefile).Is there a way, to keep these Multicurves together when converting back to shapefile?
Trying to read Microstation V7 dgn files in FME desktop. How do you add .rsc file so that custom line styles and symbols can also be included?
I need to transform GML to other regarding to new XSD schema. I've got following problem, pointed during oldGML validation by new XSD schema:Element <gmd:CI_ResponsibleParty> is not allowed under element <przedstawiciel>Element <zrodlo> is not allowed at this location under element <GES_BudowlaPodziemna>Further elements required under element <wladajacy>Value 'BrakInformacji' is not allowed for element <bt:lokalnyId>Value 'zasuwa' is not allowed for element <rodzajUrzadz>.Some of them looks simple ("Value ...is not allowed") but changes of schema elements relations seems to bring some difficulties. What is the best practice to handle such GML tranformation? Attribute mapping using XMLTemplater? Constructing XSLT file or something else?
I am extremely new to FME. In my data-set, I have a column that displays number of seconds . I need this to be in a time format.Example: column data displays 181, I need this to read 0:03:01.Any help would be appreciated.
I'm looking to work with some information in Google's Protocol Buffer format, but it appears that FME doesn't naively support it. Short of creating some python/java (and external libraries) to read and convert it to JSON, but I wanted to see if anyone had any experience working with it and FME. I did a quick look around and found this blog post from a few years back describing how they use(d) it for sending messages back and forth in FME Server, but I can't seem to find anything else about it online.Anyone have any experience working with Protocol buffers and/or FME and would have tips on how to best proceed?
Hi there,I have seen two similar posts from 2013, unfortunately none of them had answers back then. Maybe something has changed until now. I have a citygml file and I need to add attributes from energyADE in at least semi-automatic way. My writer already recognizes energyADE, but it doesnt write it correctly. Has anybody ever achieved this right?Right now the most I can achieve is to write few simple attributes to a feature. I use attributeCreator and from thisI get thisNow, eaves height is written wrongly (231 is suppose to be a value, not a unit), but so be it for now. At least its in. I also figured that all xlink_hrefs (energy_construction_orientation{0}.xlink_href) seem to represent a relationship between classes according to schema, but in outcome that xlink_href is actually there although it shouldnt, for exampleAny ideas or pointers. Any tip will help. Also, if you have tried this, but came to realize its not possible, please let me know so I dont waste my time. Big thanks in
Hi,I have a polygon outline of the a river system with no elevation. Using contour shapefile, I generate a DEM raster, then drape the river polygon to get elevations for each point in the polygon.Problem I have is the data does not match. Occasionally the river edge covers the coastline so there is a slope across the river from one side of the river to its opposing side.Example being, if I stand on one side of the river and look to the other side, whilst being perpindicular, both z values should be the same. However, my results aren't the case.I've tried raster coercer to do some averages of z values and using neighbour finding to assign z values on the polygon, however when the neighbour is 'inbetween' points, it becomes inconsistent.is there a way to get clean centrelines without having the 'spider' legs along the way? Is there a way to draw perpendicular lines at each point of the polygon? Then I can use it to cut up the polygon to small segments. Use the seg
Hi all,Ia m facing problems in creating workbench in FME. I am need to know the clear process for creating fme workbench for DXF file data.What are my possible solutions?Please find the attachments for clear idea about my question. I am attaching same data for your refer. Any one create sample workbench for my sample data. Sampledata and explanation document palce in same folder.Thanks in advance for your help.
hi,I want to import DXF data into Smallworld by using FME. I have bellow doubts in exporting. When i try to add reader in "Reader Gallery"i found 5 type of "*,dxf,.dwg" formats.First i try to select "Esri Mapping Specification for CAD(MSC)" data in DXF file not visible. After that i tried with "Autodesk AutoCAD DWG/DXF" it displays layers from DXF source file but fields are not visible in work bench.I checked the dxf file in ESRI they have fields and values. But in FME those values are not populated in workbench for mapping."Layer,Color,Linetype,Elevation,LineWt,RefName,Angle" are the fields in layers. But these fields are not visible in FME workbench.Can any one tell me how to import DXF file data into Samllword by using FME.Please advise if I am missing something. Or how would I resolve this issue. Thanks in advance for your help.
Hi,I have CityGML buildings (LOD2). The footprint needs to be replaced with a more accurate one. With replacing the footprint the walls need to be re-created. I need to keep existing roofs.Can anyone help me? Any suggestions/tipps how to achieve this?I'm not overly familiar with FME,Thank you, Robert
Hi there, I'm definitely not new to FME, but I am new to this community, so hi there! I have a question concerning CityGML. I'm trying to convert data from an Oracle Spatial database to the CityGML format. I followed an example from FMEpedia which I modified for my own purposes. Now everything works quite well, as long as it is 'by the book'. However, I need to write some extra attributes that are part of a custom Application Domain Extension (ADE). I have a valid XSD that defines the extension attributes, but what should I do next? How can I ensure that FME exposes the custom ADE attributes in the CityGML writer, so I can map my Oracle data to it? I have been playing around with the writer settings (as described in http://docs.safe.com/fme/reader_writerPDF/citygml.pdf) but until now without any success. I would be happy to hear from someone who can give me a hint in the right direction! :)
Hi, I am writing tags to Microstation V8 DGNs. I want to set the tag colour and font style, but when reading the below article it seems that those attributes cannot be set when writing to tags. http://docs.safe.com/fme/2016.0/html/FME_Desktop_D...Do I use a DGN styler instead?Any help would be greatly appreciated.Thanks
HiI am writing to tags in Microstation v8 however, whenever I display the tags they are not showing up at the origin of the line. I think this is because the line is a complex chain rather than a line string within Microstation. Does anyone know how to ensure the tags are displayed at the origin of the complex chain?Thanks
Im having problems to list tables when using postgis reader, but if i list them with postgresql readers it fetches all tables from any of my schemas.The listing is inside schemas and there are both geometric tables and non geometric ones. It is able to fetch the existent schemas in database but not the the tables inside the schemas.In Qgis i can load and see all my tables.Any clues or ideas @paulatsafe
Hi guys,I transform a CSV file to excel inside an FME workbench to calculate some statistics. Everything goes smoothly, the only problem is that when writing to Excel, all numbers (decimal numbers mostly), are stored as text.Is this a known problem, or does somebody have an idea how to have numbers in excel that are stored as numbers?Thanks,Maxime
Hi,I have been asked to combine cells and tags in a Microstation V8 DGN file into a 'Graphic Group'. Does anyone know if this is possible in FME?Thanks,