Using readers and writers to extract and load data.
Recently active
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?
I have a simple GML file with one building in it. When i run the file in FME to simply write it again without any operation somehting very strange happens. FME replaces the xlink.href statements in the data with the original data form the reference which already includes a gml:id and that duplicates the IDs in the file. for example:Original data:<gml:MultiSurface> <gml:surfaceMember xlink:href="#p_r_2"></gml:surfaceMember> </gml:MultiSurface>.........<gml:Polygon gml:id="p_r_2"> <gml:exterior> <gml:LinearRing> <gml:posList>2.00 0.00 3.00 2.00 2.00 3.00 1.00 2.00 3.50</gml:posList> </gml:LinearRing> </gml:exterior></gml:Polygon>Will become this:<gml:MultiSurface> <gml:surfaceMember> <gml:Polygon gml:id="p_r_2"> <gml:exterior> <gml:LinearRing> <gml:posList>2.00 0.00 3.00 2.00 2.00 3.00 1.00 2.00 3.50</gml:posList> </gml:LinearRing> </gml:exte
HelloI want to convert a DWG file to DGN. A celllibrary is attached and a correct seedfile. All lines and texts are converted correctly and the unrotated blocks are converted to the right cell as well. The rotated blocks are converted to cells and rotated in the DGN but the rotation totally wrong. I cannot see what the problem is. Units, Settings, I really don't know. Does someone have a solution? Thx for reading and/or answering!Mark
I have .3ds file, I want to convert in to that file into citygml file.If possible please share workspace
Hi I have a large number of file geodatabases with one feature class in each.I would like to merge all the feature classes and save in one single file geodatabase.Any suggestions what's the best way to achieve this?
Hi folks,I have a CityGML file with many buildings. These buildings have buildingParts with unique gml_ids. I need to access these buildingPart ids in an automatic way, so later I can use them as gml_parent_ids. Can somebody please suggest me a way how to automatically extract gml_id from CityGML feature type. Please and thanks!
I don't deal with writing XML very often (ever, really), so I'm struggling to do something and of course they need it yesterday. The vendor needs an export from my Esri database in XML format and I think the only thing I am missing is that my XML file (using the XML Writer) is writing "elements" instead of "attributes", so they say they can't import it. I can't for the life of me figure out what I need to do to achieve this without going down a very deep hole and learning XML in the next five minutes... Is there a setting I'm not understanding, or is it really that complicated? I don't need geometry, they just want to fill a table with my data.
I have an .ifc file with solids but when i convert them to ACAD it gives me AUTOCAD polymeshs....how is exactly the right way to keep the solids as ACAD solids?Thx Franco
I am going to use FME to run finalisation on ortophoto projects. Two of the products require JPEG to be part of final delivery. One require compression Q= 10, the other Q= 20. Producing the files is fast enough, and images look good when viewing in IrfanView. But when reading the header-info in "ISRU Display Header", I realise that the actual compression deviates from the set compression value in the Writer. I cannot deliver this to client, as they will simply not accept non-compliance of the specs given (when they say Q= 10, they mean it). Does anyone have experience in similar issues, and able to give me a hand?
Is there a way to transform IndoorGML (xml but not normal xml or GML) to Esri Shapefile?
I have a workspace where I read a shape file, clip the data and write it to a ESRI geodatabase with the Esri Geodatabase (ArcSDE Geodb) reader. The attributes in the shape file contains swedish caracters. The characters is right when I read the shape file in ArcGIS but when I write the data to the geodatabase the swedish characters is replaced. How can I handle that? I have try to change character encoding on the shape file writer to iso-8859-1 (which contain swedish characters).I'm attach print screens from ArcGIS when reading the shape file (as it should look like) and from ArcGIS when reading the geodatabase.
Every time I try and style a dgn for cells, I get a warning (9 heterogeneous aggregate features were split for the DGNV8 Writer into homogeneous features containing a total of 9 point, 9 curve, 0 area and 0 text geometries). Why is this happening and how can I get FME to create my cells in a dgn file?
I have a CityGML dataset that I want to test if its value is not in a range of values (codelist). There are generic attributes that are easy to test with the Tester transformer. These look like this: <gen:stringAttribute name="DatenquelleDachhoehe"> <gen:value>1000</gen:value> </gen:stringAttribute> <gen:stringAttribute name="DatenquelleLage"> <gen:value>1000</gen:value> </gen:stringAttribute> Others look like this: <bldg:roofType>3100</bldg:roofType> <bldg:measuredHeight uom="urn:adv:uom:m">7.808</bldg:measuredHeight> <bldg:storeysAboveGround>2</bldg:storeysAboveGround>How can I test these attributes? Thx
Back in 2012 I answered a question, which has a similar flavour to a question I have today.https://knowledge.safe.com/questions/5410/mapinfo-seamless-table.htmlSadly back then FME couldn't easily solve the problem and as far as I can tell it still can't?I'd like to be able to write metadata tags into MapInfo TAB files with FME, so that a process can be fully automated. As far as I know, the two MapInfo writers don't have any options for this to date.At the moment my train of thought is pursuing the angle of writing the TAB files out as normal and then running another FME Workspace to open the .tab file as text and appending the metadata tags as required. The metadata is extracted from an excel sheet, so this should be achievable. Anyone got any smarter ideas?Metadata tags look like this in MapInfo TAB files for reference and are appended to the bottom of the *.tab file:begin_metadata"\\IsReadOnly" = "FALSE""\\MapInfo" = """\\
So I am trying to run a large translation and i keep getting the error: 2015-12-18 11:31:42|2622.1| 0.1|FATAL |Insufficient memory available -- error code was 2 - please read the FME Help section 'Adjusting Memory Resources' for workarounds.Out of memory. Program terminating. Please read the FME Help section 'Adjusting Memory Resources' for workarounds.I have changed the fme_temp to a portable harddrive that is 2TB and completely empty. I also have 60 gigs free on my computers hard drive and i am only working with a 7 gig file and another sub 2 gig file. How can i get the entire process to work. i do not know what i am doing wrong. i have read the articles on performance tuning and still not getting it to work after playing with the temp.
I'm using FME Desktop 2013 and writing to a new table with the Oracle SpatialWriter . Is there any way to use the parameters clause for the spatial index creation statement? I'd like to specify a layer_gtype for my spatial indexes. For example like CREATE INDEX bar_si ON foo(geometry) INDEXTYPE IS MDSYS.SPATIAL_INDEX PARAMETERS ('layer_gtype=POINT') Thanks, Yola
Some data we have is stored in .mat files. Is there a reader/facility in FME that can access this data without invoking MATLAB?
Hello FME Knowledge Centre,I have been working with FME Server for just less than a month and have come across the following issue. I created a data download service then tried to run it as a html form. I tried it in Google Chrome and came across the following error:I spend a few hours delving into what CORS was and how it worked. I tried the templates provided by FME Server with no success. I then tried some custom CORS settings, again with no success. Before giving up I tried the form in IE and Firefox and it worked! I disabled to CORS settings in FME and tried again with IE and FF and it still worked. I am running FME Server on an Amazon EC2 and am trying to access the service from behind a corporate firewall and proxy. I have tried the form in Chrome an external computer but still no success.Help me FME Knowledge centre, you're my only hope...David McDermott