- - Community Resources
Ideas
Product Updates
Events
Blog

Home
Forums
FME Form
Data

Data

Using readers and writers to extract and load data.

6,817 Posts
25,110 Replies

When you subscribe we will email you when there is a new topic in this category

6817 Posts

jasperwisEnthusiast

Hi,I am new to JSON and I am trying to convert a JSON to a flat FME table.In the workbench attached, I found a way, but I was wondering if there is a moresimple way.My second question is: is there a way to convert this to a flat table without knowing the object attribute keys? Jasper

Timeout error 404 writer/arcgisonline

Hello,We use FME SERVER to transfer feature on arcgis online.We always have a problem of timeout."ArcGIS Online Feature Service Writer: Encountered an unexpected error. The error code from the server was '504' and the message was: 'Your request has timed out.'. Details: '' We try to send less packets each time bur the problem is the same. Could you help us? Best regards.

5 years ago

louisput

asked in Data

TextStroker ignores fme_rotation

Hey FME'ers, We have a problem with the TextStroker. It seems like it ignores the rotation of our text features. In attachment an example of our problem. Note that the textstroker doesn't change the fme_rotation but still the text is shifted 180° around a point different than that of the insertion point.It seems like the problem started since the update to Version_5. With version_4 there is only a slight shift in position (see attachment). I guess we could set back our textstrokers to version 4 to avoid this problem.Our FME version: 2019.1.3.0 (20191007 - Build 19642 - WIN64)we use python 3.6+ Thanks in advance!Kind Regards,Louis

Export xyz ascii tab delimited.txt from DGN v8 levels into level corresponding text files

I have a v8 DGN with say 25 different levels - I need to generate xyz coordinates of these specific levels into a tab-delimited asii text file (id y x z level#).txt So i.e dgn level "post level in the dgn" will output to post.txt I need to extract the coordinates of the point features:igds_xhigh 2014161.7674759198igds_yhigh 13799548.426837647igds_zhigh 73.6230882525444 the first number from which the data came from igds_level_name 77 Insulator Attachment at Structure and YXZ of nodes from the shapes also: as seen here i tired this so far: output file is blankany help is welcome - thank you

File Geodatabase Writer not creating shape_area and Shape_length fields

Hello,The shape_area and Shape_length fields are missing when I write data to a file geodatabase. I've experimented by including these fields from a reader that is at the beginning of the workbench. That seems to work, but shouldnt the writer create these fields for me? Also, the objectid field is written, but at the bottom of the table. Shouldnt I be able to control this to be at the top?

1550

5 years ago

asked in Data

How can I set header values when using HTTP Request in FME Automations?

Is there a way to set headers for the HTTP call? Ironically I am trying to call the FME Server API, so I need to set, for example, Authorization: token fmetoken=YourTokenHere

How to write feature by feature to ArcSDE Geodb?

Hi AllI would like to perform writing feature by feature to ArcSDE Geodb. I was trying to "roll" all feature attributes into one attribute (using Aggregator and GeometryExtractor) and provide such feature via WorkspaceRunner to slave workspace, "roll out" attribute into feature definition and then pass to Writer. Is it a good direction or any other suggestions?

5 years ago

olpotosiContributor

asked in Data

Can FME move an AutoCAD layout/viewport to align with a re-positioned model space?

I have over 100 layouts that reference a model space that is improperly located. I would like to use FME to move the model space to the proper location and have the layouts follow along. However, based on my testing and this post from 2017 that teases at improved AutoCAD layout handling, it seems unlikely. I can move the layouts manually in AutoCAD if necessary but I was hoping to FME them into position. Thanks for any information/advice you can offer.https://knowledge.safe.com/articles/34345/working-with-autocad-layouts.html

Diretory and File Pathnames check file gdb for locks

I am trying to implement a workflow that will check a specified FDGB directory for the presence of .lock files and use the ownership information of those lock files to email the users to disconnect so the data can be updated. The problem is that the path_ownername attribute is not being returned by the Directory and File Pathnames reader. I have tested this in multiple FGDBs and the only time I get a value for path_ownername is when I change the extension to .atx (which doesn't help) or when I use a directory that has some older (orphaned?) lock files with last modification dates of a day or more. What method does the reader use to harvest these attributes ? Perhaps there could be a security related interference or a default permissions problem

How do i convert a CSV file to a XML?

Append multiple ESRI geodatabases into one

So I'm trying to append approx. 600 geodatabases all containing 5 feature classes with everything in the same schema. All of the geodatabases are in the same folder and I need to parse through the entire folder appending each one into the Target.gdb. I don't know much about FME, but I feel like this should be pretty straight forward. Any ideas?

Is it possible with FME cloud to watch an AGOL feature service? So that when the feature service gets modified it trigger's an FME script on FME cloud to run.

Outputting published parameters to a textfile or json file

Im wondering if anyone can help me with the issue i am experiencing. Im attempting to output the published parameters used in a workbench to either a text file or json file, in addition to my shapefile writer. I have tried adding in a feature writer but when i run the workbench although my shapefile data is transformed as expected, the textfile which I want to contain my published parameters also includes all of the attributes which I do not need in the text file.Perhaps I have missed something extremely obvious or I need to approach another way?Many thanks

5 years ago

kees_v

asked in Data

connect to sql with different windows account

I want to make a connection with msSQL server with another windows userid/password than mine.If i select Windows Authentication in the connection set-up window, the windows credentials fields are disabled. In our organisation there is only 1 windows account for the SQL server.Is there a possibility to use a different windows account than mine for the connection.?Maybe an example connectionstring?Thank you very much, i hope someone can help.Kind regardskees@itay

Update mongodb reader

Hi,When i update my mongodb reader with "update reader and feature types" one column (properties.observations) of my collection (that i see with robomongo) doesn't appear in User attribute. I have try many times but nothing happen. It's really a big problem for me. The same thing when i delete and create my reader.When i use format attribute/mongodbjson i retrieve this column in the column mongodb_jsonIs it a bug ?Best regards

How can I avoid fatal errors when an input file is missing?

I have a number of DXF input files feeding a workspace that writes to a SQL Server File Geodatabase. These DXF files are sometimes there, sometimes not. The fme workspace fails with a Fatal Error when the Input Reader fails to find the dxf file during "version check". As failure occurs before there is opportunity to incorporate a transformer, I can't use FileExistanceChecker or other file exists processes. Is there a workflow I can use to ensure the translation continues if the input file is missing?

How to convert custom xml file to shape files

I need FME Desktop workbench to convert Custom XML (Smallworld) file to Multiple shape files based on the respective feature classes

New on the FME Cloud Pricing Calculator - Help me decide (Time)

Check out the FME Cloud Pricing Calculator for a new Help Me Decide. https://www.safe.com/pricing/fme-cloud/ Under the time frame section for Instances, this explainer has a number of different examples of how to use the calculator and situations your customers may find themselves in. A snippet from the pop-up.

5 years ago

saadi112

asked in Data

How to convert LAS to DWG/DXF

HelloI am totally new with fme software.I work with a drone to capture land photos, then i process the photos and add land coordinates. The output is in LAS format.When i try to enter this file to autocad map 3d, it's imported as one block and i cant manipulate the data.So i need to convert the LAS file to DWG or DXF so i can work with the dataIs that possible?Thanks

2550

5 years ago

alfonsContributor

asked in Data

Converting 4 channel Geotiff into 4 channel ECW

Hello, I'm trying to convert a 4-channel Geotiff to a 4-channel ECW. Unfortunately I always lose the fourth channel (in my case the IR channel). As far as I know, the ECW format supports the multi-channel system. After I had another problem at the beginning, which I could solve with the workaround described in https://knowledge.safe.com/questions/81297/ecw-writer-this-format-does-not-support-writing-th-1.html, I haven't yet found a way to integrate my fourth channel into the ECW file. Is this possible with FME and if so, how do I do it? Enclosed still with current attempt.Thanks a lot for your helpGeoTIFF2ECW4Multichannel.fmw

Workspace Runner runs only with Source of Child Workspace

I want to run a Workspace with each run a different Shapefiles as Source.I Use the "Directory and File Pathnames" Reader and set it to *.shp.Then i set the Source of the Shapefile in the Workspacerunner to windows_path. And here is the Problem:Now the Child Workspace runs with the Child Workspace Source Shapefile.But so many times as the "Directory and File Pathnames" Reader from the Main Workspace has.It doesnt get that he needs to Change the Source to another Shapefile in the Childworkspace.It only runs 8 times with the Child Workspace Source instead of Using the 8 different Shapes from the "Directory and File Pathnames". What am i doing wrong?

nicholasContributor

Hello all,I am trying to convert an ifc file (Industry Foundation Class STEP file) to MapInfo.I can get FME to read the ifc and it displays objects in FME. But if fails on writing to MapInfo.I understand that ifc is three-dimensional objects, so I just want a two-dimensional representation. I tried using 2DForcer, but am not getting results.I have attached the ifc file here

5 years ago

tjaParticipant

asked in Data

FME Docker: Module 'MSSQL_ADO' is unavailable for use with this FME edition

When running a workspace I get this error: FME Docker: Module 'MSSQL_ADO' is unavailable for use with this FME editionOther errors include:Could not load module '/opt/fme-engine-2019/plugins/fme_ado.so' : /opt/fme-engine-2019/plugins/fme_ado.so: cannot open shared object file: No such file or directory

Write to single excel file from multiple sources

Hi, I am working on a project to identify attribute values that do not match for many SDE layers (26 total). I would like to write the results into separate sheets within the same excel file; however, I currently am only able to write one sheet at a time in the same excel file. I would appreciate some advice and suggestions!

FME 2015- extract join fields from smallworld to GeoJson format

How to extract a smallworld data i.e., join fields from a collection?

120

5 years ago

Page 93 / 273

Badge winners

anneliesoosgishas earned the badge Teacher (Grey)
tomcolleyhas earned the badge Welcome Back
karen_tjalsmahas earned the badge Welcome Back
kihenhas earned the badge Student (Grey)
havermhas earned the badge English Speaker

Show all badges

30,407: Posts

Terms & Conditions Cookie settings

Sign up

Already have an account? Login

An FME Account is required to contribute

Login to the community

An FME Account is required to contribute

Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.

Enter your e-mail address

Back to overview

Scanning file for viruses.

Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.

This file cannot be downloaded

Sorry, our virus scanner detected that this file isn't safe to download.

A product of

Company Products Giving Back Careers Contact Privacy Feedback

Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.