Using readers and writers to extract and load data.
Recently active
I want to translat CityGML>IFC and i get this Error, at the end i cant get any geometry.
We run SSL and use a CNAME of gisdata.launceston.tas.gov.auFME Server 2017.0 is throwing:HTTPCaller(HTTPFactory): Received HTTP response header: 'HTTP/1.1 503 Service Unavailable' from 'http://papfme1.launceston.tas.gov.au:80/fmerest/configuration/migration/export'Terminator(TestFactory): Terminator: Termination Message: 'Unable to retrieve backup from FME Server `http://papfme1.launceston.tas.gov.au:80'. Please ensure that the credential are correct and that user `fmeadmin' has fmesuperuser role. The error was: HTTP/1.1 503 Service Unavailable - http://papfme1.launceston.tas.gov.au:80/fmerest/configuration/migration/export.'fmeadmin is in the fmesuperuser role and I have changed all hosts to use https and the CNAME above. The schedules>Backup Configuration form does keep reverting the password to 3 characters (which it isn't). If I paste http://papfme1.launceston.tas.gov.au:80/fmerest/configuration/migration/export into a browser it takes me
I successfully read autocad_insunits (Format Attribute) for any given DWG (In Autocad, this is the INSUNITS setting). Is it also possible to determine the DWGUNITS setting for any given DWG? I believe that I have tried all of the Format Attributes, with the word unit in the string, in FME 20160516 - Build 16494 - WIN64.Thanks.
We want to export a DGN V7 file to v8 version with some specifications. For example: In version 7 we have grouped some elements in the same level, but with different colors and styles. The objective would be to be able to make different selections of level, style and color and in the reader environment, and export that selection to a specific level in the output file v8. How can we do this? thanks for your help
Hi, is it possible to convert HTML page to jpg file.Thank you, cheers.
Good morning.I have the XML file of an ATOM feed. That XML has to be updated every time the resources provided by that service are updated. Several dates must be changed.My first approach is read the XML with the XML reader, calculate the current data, modify the XML using the XMLTemplater and wirting the same XML file using the Text File reader (with "Overwrite" set to YES)..The process reads the C:/ATOM_feed.xml, edits it and writes the file C:/ATOM_feed.xml.This doesn't work:"Error opening dataset 'Text File' for writing, ensure that file path and permissions allow for writing".I guess it makes sense.So, in order to avoid this, I have used "Creator" to create a feature with an attribute "join" set to "A". I have added the same attribute to the feed from the XML Reader and I have perfomed a Merge using "FeatureMerger" (Requestor = new feature, Supplier = XML). That way I can read and write the same XML file. The
Hi all, This might be completely in the world of fantasy! I've programmed FME to produce a MapInfo table (using MFAL writer) containing points at 25m intervals along road centres (using Ordnance Survey's ITN data), each point contains a URL including Long/Lat coordinates so that I can invoke Google Street View. In MapInfo, I need to add the Hotlinking capability after FME so that the URLs can be read and linked to. I've looked at the tab header file (in Notepad) and it seems to need a few lines of code at the bottom of it. I was thinking, could I program FME to add this automatically? Has anyone thought about this before? Perhaps this is beyond the use of FME. The closest way I could think of would be to create a text file and write the specific text to it then replace the actual .tab file component in Windows Explorer but it wouldn't be a tidy process. Regards, Ian
How can I download a file from Box.com, Google Drive, OneDrive or S3 by using the file name instead of the id?
Hello,I am evaluating FME for a project but have hit a hurdle trying to write to a MongoDB database. I have put together a very simple workspace that reads data from an Excel file and dumps it into MongoDB. When I run it, I get the following error:MONGODB writer: Existing feature type 'rawData' does not contain an attribute matching the schema attribute 'customerId'. Attributes named 'customerId' on incoming features will not be written to the existing feature typeI get the same error for each attribute that I have defined. The writer succeeds in creating the collection and populating it with documents, but all the documents only have the '_id' field set.On the writer, I've set Attribute Definition to Automatic and also given the collection name under the General tab. Otherwise I've left the defaults.Am I missing something?,Hello,I am evaluating FME for a project and put together a simple workspace that pulls data from an Excel spreadsheet and d
I've just opened one of my 2016.1 Workspaces that reads a ShapeFile in 2017.0 and some ArcSDE layers and writes to 2 File Geodatabases (FGDBs). I got the following message in the translation log:Attribute type 'fme_char' not found in ATTR_TYPE_MAP. Trying 'fme_int8' Attribute type 'fme_int8' not found in ATTR_TYPE_MAP. Trying 'fme_int16'I've still got 2016.1 installed so I'll run the Workspace in that, but I'd appreciate any explanations of what this means. I'll try re-creating the Readers and Writes in 2017.0 when I get a chance.
Hi,Yet another newbie here.I am just wondering if its possible to change writers output in some quick way (drop down list, etc).let me explain... I have an excel spreadsheet and 13+ feature classes (ArcGIS 10.3.1) I am using FeatureMerger to join the table with every single feature class (not always basing on the same common field). So far so good, it is working fine but sometimes i need to change an storing location, eg. output1: local test area, output2: internal server (SDE), output3: external server (SDE). How to change the output locations all at once. At the moment i have 13 writers and i don't want to change each of them every time and i don't want to create workbenches for each of the potential outputs. How to do that? Thanks,
Hi, is it possible to mix lod2 and lod3 geometries into a single CityGML file?
The area did not exist in the dwg-File, which parametres Needs the dwg polygon. In the DATA_Inspector out of des Workbench it Looks so:Which Settings are Missing for the Export to dwg?, to convert an area to dwg the area did nor exist. By Output in Dataexpector the Area are there. AutoCAD_entity=autocad_mypolygonDie Flächen werden nicht in im DWG gespeichert, bei der Ausgabe der Workbench in einen Datainspector werden diese angezeigt:autocad_entity (encoded: utf-8)= autocad_mpolygonautocad_mpolygon_object_type (encoded: utf-8)=0autocad_mpolygon_pattern_name (encoded: utf-8)=1autocad_with (64 bit integer)=2Für Hilfe wäre ich dankbar
I am trying to extract an Oracle spatial feature type to a text format. The geometry in Oracle has four dimension. I need to extract this fourth dimension in a text format. I was looking into extracting this into gml or geoJSON. However, I haven't managed to extract the Mth dimension coordinates...I was wondering if anyone has any idea how to do this?Thank you
Hello,I'm working on a workspace that will update a AGOL Feature Service. I need to pull from two different data sources, normalize the attributes and do some additional processing in the middle then write updates to the master. Both source data sets are fairly large so I am trying to not have to read each of them in their entirety every time the workspace runs. Rather I would like to leverage a "Modified On" field in the source data to only read in features that have been modified since the last time my workspace ran. I plan to push the workspace I'm building to FME Server and then sschedule it to run nightly. Currently I use the "time stamper" transformer to park the current data/time when the workspace runs in a .csv file. My thought is that I could then read in that timestamp and use it in my WHERE Clause. That's the thought however, I cannot seem to find a way to leverage that timestamp in my workspace parameters. Does anyone have some experience tr
Hello everyone, Does someone know how to set the srsName in a geometry for child nodes? So that it also appears in my AIXM File. This is how my ElevatedSurface looks like (ElevatedSurface has the right srsName=" urn:ogc:def:crs:EPSG::4326" but the srsName of curve is still "EPSG:4326" which is wrong) <aixm:ElevatedSurface srsName="urn:ogc:def:crs:EPSG::4326" srsDimension="2" gml:id="ts_4ccd28dc-d169-4905-bc3e-0d0908fa4042-0"> <gml:patches> <gml:PolygonPatch> <gml:exterior> <gml:Ring> <gml:curveMember> <gml:Curve gml:id="IDff4a11b2-b59c-4347-9b45-8872a5e8678b" srsName="EPSG:4326" srsDimension="2"> <gml:segments> <gml:LineStringSegment> <gml:posList>50.0298955820538...</gml:posList> </gml:LineStringSegment> </gml:segments> </gml:Curve> </gml:curveMember> </gml:Ring> </gml:exterior> </gml:PolygonPatch>
For example, I would like to add 40 meters to the current absolute value height.
I am working with FME 2017. I am quite a new user, now i tried to colorize point cloud with infrared color (i.e. integration of thermal images with 3D point cloud). LAS file has the local co-ordinate system but Jpg thermal images does not have any co-ordinate system. How can i integrate them on single file?
Hello, I have a bit of a problem that I can't find a solution to. I have a list of directories and sub directories. Some contain shapefiles. Some contain tables, gdbs etc. Eg: S:\\NEW\\170530\\test.shpS:\\NEW\\170529\\NewData\\NewTest.shpS:\\OLD\\170428\\test.xlsxS:\\OLD\\170428\\MoreData\\MoreTest.shpThere are more folders within those dated directories. The root drive is always the same "S:\\"The root data directories (eg, OLD, NEW) will be provided by users as a user parameter. There won't be any navigating to those specific directories. How can I have a workbench that reads all the shapefiles nested in all those different directories, once the root data directory has been passed to it? Everything from the PATH reader up to the FeatureReader only specifies up to the dated directory based on user input. Eg:S:\\NEW\\170530I saved the directory path and passing the following to the FeatureReader: S:\\NEW\\170530\\**Now it works.. but with a couple of drawbacks. For on
Hi I am trying to use FME to update data on AGOL. This works with small data sets, however on larger datasets I get a timeout error (see below), when the process takes more than about 20 seconds.I am using FME 2015.1.1.0 and can't upgrade at the moment :-(I have tried using system proxy settings (but this did not make any difference)If I process the updates in batches this works (but is messy), and I can't truncate a large tables (as this is one large transaction)Has anyone else had a similar issue with a known work around? FME Error: "The error was 'HTTPSConnectionPool(host='services2.arcgis.com', port=443): Read timed out"
I have set up my Geodatabase Writer but can’t write to it. The log file gives me this message: “Geodatabase Error (-2147024894): The system cannot find the file specified.” even though I’m creating a new file geodatabase within my workflow.
Hi,I have a simple workspace. I read a file (interlis2) and have 4 parallel transformers attached (GeometryReplacers, followed by GeometryFilter and AttributeRenamer).When I run the workspace it crashes at exactly the same data row in my input file without any further error message except "fme has stopped working". Nothing in log file either.If I disable two of the four parallel transformers and run the workspace and afterwards disable them and enable the two remaing ones all data is read and written (Autodesk sdf3).Memory is no issue - FME just uses 500 MB, there is plenty left.Any ideas why that happens? I would like to run the workspace in one go.Thank you, Rob
Hi.I have the following .json file:{ "0": { "0": { "Group 1": { "Sub 1": 0, "Sub 2": 70 }, "Group 2": { "Sub 3": 0, "Sub 4": 29 }, "Group 3": { "Sub 5": 136, "Sub 6": 120 } }, "1": { "Group 1": { "Sub 1": 0, "Sub 2": 76 }, "Group 2": { "Sub 3": 1, "Sub 4": 35 }, "Group 3": { "Sub 5": 157, "Sub 6": 115 } } },"1": { "0": { "Group 1": { "Sub 1": 5, "Sub 2": 72 }, "Group 2": { "Sub 3": 51, "Sub 4": 2 }, "Group 3": { "Sub 5": 16, "Sub 6": 20 } }, "1": {