Using readers and writers to extract and load data.
Recently active
Hi, I am having issues connecting to a sharepoint site. I get an error 401-- Client access error.I confirmed having access via manually reviewing the site. Any pointers? or ways to trouble shoot?I am using FME 2016 or FME 2017Thanks in advanced.
I have a hexadecimal value '50C8BDA0' that I need to convert to it's text value. I have many unknown values but this is my test case. It should be '1355333024'. According to Hexed.it, it's UTF-32 bit Big Endian format. I have tried various combos of binarydecoder, textdecoder, etc. and cannot figure it out. Does someone know the right steps? Excel and Windows Calculator do it automatically the first time so I must be missing something.
Can FME write to NEPLAN?
Has anyone experience the problem with the exporting to the Cesium 3D Point Cloud format with "no creating tileset.json" file?
This seems like it should be an easy one, but I'm stumped. Getting this error when attempting to truncate the existing dbo.T_Inspector table and insert everything from a SDE Table of the same name. MS SQL Server Writer: A feature has arrived with 'fme_feature_type' of dbo.T_Inspector, but the feature type is not recognized. Halting translation The destination is MS SQL Server 2012 table. Not spatial at all. Here are the lines from the log (I've removed my usernames and server names for confidentiality). 2015-11-05 10:03:57| 1.6| 0.1|INFORM|FME Configuration: Named Connection Storage: 'G:\\MIS\\FME\\named_connection_files' 2015-11-05 10:03:57| 1.6| 0.0|INFORM|FME Configuration: Using Named Connection values from 'username/tamis_lookup' for MSSQL_ADO_1 2015-11-05 10:03:57| 1.6| 0.0|INFORM|Creating writer for format: Microsoft SQL Server Non-spatial 2015-11-05 10:03:59| 1.7| 0.0|INFORM|Trying to find a DYNAMIC plugin for writer named
hi, can some body share a transformer for using pdal library for lidar classification (using a json file as configuration).. Something like lastools transformer?thanks
I have created a mapping file to migrate Shapefile polygons into Smallworld GIS. Some of the polygons in the shapefile have coincident geometries: basically a hole within the polygon that has a shared vertex point with the outer boundary of the polygon (these are legitimate holes and I would like to preserve them upon import). When the mapping file encounters these geometries, it will not import that polygon feature. I was wondering if you had any suggestions on how to rectify?
Dear community, I've used FME before to generate building objs from CityGML files. It works perfectly. However, a caveat is, in CityGML building faces are stored as polygons, but the .obj files that FME outputs seem to triangularization these polygons into triangles. So there is redundant information. Is there any way to suppress this step to let FME output the original polygons instead? Thanks,Yuqiong
the smallworld reader is giving error in FME2018.It says "SWORLDSWAF reader: string too long" I am using 2016 and I don't take any error like this. Is there any idea to fix it?
Hello,I created a model view definition for IFC files. I exported it as XML and would like to apply the rules that I defined in the model view definition to an IFC file. I would like to filter an IFC file to include only the information that i described in my XML. What would be the best way to approach this topic?Best regardsTobias
I have about 1000 DEMs to mosaic. They are stored in various folders but I have a csv with all the file paths stored in a field. How can I read these paths and mosaic them into a single raster?
@MitaAtSafeI have been watching a YouTube presentation you did with AttributeManager. We are a mapping company and we map features directly into MicoStation in specific level names, colors, line weights and line styles. We have clients that would like us to convert those level names, colors, line weights and line styles in to their scheme. I'm hoping that your help and with AttributeManager I can build a workbench to take care of that. My thought is that I would like to build an excel spreadsheet with our scheme and cross reference to the specific clients scheme. Could you please let me know if that is possible?
I'm attempting to upload a file to a S3 bucket and getting errors even though uploading via Cloudberry Explorer has no difficulty on the same machine."Unable to execute HTTP request: Connection refused: connect"Does the S3Uploader use the Network proxy settings?I can't seem to find anything that says whether it does or not.The following looks correct (besides my little erased bits) right?
Hi Forum,Apologies if this has been posted before but speaking to the Live Chat team they were unfortunately unable to provide a detailed solution.I have a ESRI File Geodatabase containing features with attributes, Number, Address, Town. I am translating from one FGDB to another (also as a test the same FGDB) with the addition of an Attribute Manager in the middle in order to create a new field "SEARCH_ADDRESS" I create a new Attribute with the expression as follows:@Value(NUMBER), @Value(ADDRESS), @Value(TOWN). The attribute manager accepts these as valid field expressions, however the new field does not carry over to the output Feature class. When the translation is run I get the error that there conflicting Object ID's "User field name 'OBJECTID' conflicts with a value of feature type parameter ' Object ID Field' ('OBJECTID') for table/feature class 'DELETE_TEST_OUTPUT'. The user field will be ignored"I spoke with Safe Live
Hi Team I have had success with connecting into our ProjectWise instance using the connector (2018) and downloading files/folders. What I would like to do is to write out file properties such as Version, Description and Status (not just the output attributes that you have when you List )Has anyone had any luck with this or any ideas I could try?Thanks very much!Dominique
My organization would like to use a gopro to take repeated images of a road and have those images mapped out as points. What is the best method to create point features from a jpeg image with GPS location metadata?
Hi Folks,I tried to convert tags to text nodes and successful in the same and workspace is shown belowbut the problem comes after placing the text in dgn file. When I opened the text in text editor, it is shown as single line text as shown below...instead it has to be shown as If I edit any parameter in dgn then text is changing to single line text. Can any one correct me where am I doing wrong...
I have a zip file that has some shapefiles I need to load. Only problem is that the shapefiles are buried 3 folders deep. Any advice?
I am using a websocket to stream data from FME server (2018) to a web app in a browser. The data I am streaming out can be classified by its location, and the user of the web app only views one location at a time. So ideally the websocket stream id would be something like '<location>_data', where <location> is dynamic and set by the feature in the workspace.This doesn't appear possible though. Setting up the workspace like this seems to instantiate the stream id of the websocket sender with the first feature to pass through it, and then fixes it for the remainder of the job. E.g. if location 'X' was the first feature to be processed, the stream id would be 'X_data' even when locations 'A', 'B' or 'C' passed through. Is this how the websocket sender works? Is there any workaround for this?It is possible for me to stream all data for all locations out through a websocket with stream id 'data', however this is very wa
I am trying to import a csv file to a SQL Server geodatabase - 10.6.1. There are only 2 fields and 66 records. I am getting the following error: Destination Feature Type Routing Correlator(RoutingFactory): COM.safe.fmeobjects.FMEException: Feature attribute not found or could not be represented as UTF-8 String: fme_template_feature_type
I am trying to get the attributes from a point layer in a KMZ file stored in a HTML table within kml_description...... I have tried using HTMLToXHTMLConverter, but the features always fail. Currently using FME 2013 SP3. FME Data Inspector is able to read and list them under "Attributes". I followed the instructions from:https://knowledge.safe.com/articles/19918/how-to-expose-feature-attributes-from-kml-tag.html Here is an example of the html code that comes between <description> and </description><html lang="en"><head><meta charset="utf8"/><style> * { margin: 0; } html, body { height: 100%; margin: 0; padding: 0; } h2 { textalign: center; background: #e5eCf9; } #summaryData { fontfamily: 'Helvetica Neue', Arial, Helvetica, sansserif; fontsize: 12px; width: 350px; } #summaryData th{ paddingright: 20px; width: 40%; } .fire_title { background: #ffffff; marginbottom: 15px; } .box { textalign: left; padding: 1.5em; paddingtop: 1em; marginbottom: 1.5em; b
Hi, I'm working with a CSV of 7Millions + rows which takes ages to run,As I am working and amending/ improving the workflow I'd like to use a sample of the data.I want to only use rows where there is a AVL_ID field starting 101 or 110 or 111... data is looking like numbers (7 digits) e.g. 1011234I'd like to only read and use the rows where the AVL_ID field are starting with 110.1. 2016 workflow and datasetI started my workflow in 2016, so opening my CSV reader parameters, I see a Filter option . I thought I could filter it at source but my data came with the fields in Numeric format so I can't use the Filter AVL_ID ^110* as described on this web page: - (under Schema Attributes > Filter by Field Value) http://docs.safe.com/fme/2016.0/html/FME_Desktop_Documentation/FME_ReadersWriters/csv/CSV_reader.htm I tried AVL_ID >= 1100000 but it does not do anything. see image below 2. 2019 workflow - FME 2018.1 CSV reader If I add a new CSV working on it now on FME upgraded
Hi,i have autocad spatial drawing & pdf format file which contains different layers of data. i need to extract the attributes and save it as csv file.i tired the same and getting empty .csv file for all the layers.any help on this much appreciated. Thanks,Mani
Is there any update on reading (and writing) Civil 3D property sets ? (Actually they are Autocad Architecture property sets.) All the info I can find on the forum is at least a year old.
I´m able to connet to an arcgis featureservice with the "Esri ArcGIS Server Feature Service" reader via token authentication and can choose the available layers. When I want to read the features i get following output:ArcGIS Feature Service Reader: Requesting metadata for Feature Service at 'https://xxx/FeatureServer' ArcGIS Feature Service Reader: Found layer/table 'xxx' with ID 4 for feature type 'xxx' ArcGIS Feature Service Reader: Requesting metadata for layer/table 4 of Feature Service at 'https://xxx/FeatureServer' ArcGIS Feature Service Reader: Querying layer/table 4 for object IDs, where '1=1' ArcGIS Feature Service Reader: Encountered an unexpected error. The error code from the server was '400' and the message was: 'Unable to complete operation.'. Details: 'Unable to perform query operation.' A fatal error has occurred. Check the logfile above for detailsI get this error on all available layers. The fea