- - Community Resources
Ideas
Product Updates
Events
Blog

Home
Forums
FME Form
Data

Data

Using readers and writers to extract and load data.

6,825 Posts
25,142 Replies

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

6825 Posts

Has anyone tried using FME 2017 with AGOL services with HTTPS turned on?

We recently had HTTPS turned on for our AGOL site and now cannot access layers in feature services in FME 2017. Has anyone else had this experience?

7 years ago

beatricemontele

asked in Data

Is anyone able to convert a geotiff raster image with multiple bands into csv file reporting longitude, latitude, values and band number ?

Here attached you can find an example of the geotiff image I need to convert.

Reading a Google Map from Map's URL

Hello,I have the following map:https://www.google.com/maps/d/viewer?mid=1mtB5peL8y8Xc0aj85d5OMZX-sFsWhere I would like to use FME to read directly (online) from the map and extract out the desired pieces of information to publish in our Open Data Catalogue.Everything I have found suggests to export to a KML file but that requires manual intervention and I want this as an automated process.I am open to suggestions.Thank you

Mapinfo writer populating -9999 to empty integer records

Hi, MapInfo writer is populating -9999 to attributes which have been manually set as integer or float and is empty. Cant figure out why? Thanks,Ashish

Reader does not recognize the MapInfo TAB files

Dear FME friends,I am using FME 2016 64-bit 16174. My workspace throws up an error with the following message.0.0|ERROR |No specified layers were found in MapInfo Dataset I removed the readers and inserted them again. Still do not read. Any idea?Thanks in advance.

Geodatabase Error (-2147219115): The row contains a bad value.

Hi, We are writing to a new geodatabase with FME 2012. Geodatabase Error (-2147219115): The row contains a bad value. FileGDB Writer: A feature could not be written. Has anyone experienced this error before. Basically the schema is written but no content is populated. The data is viewable mid-translation in the Universal Viewer. Thanks, Annette

XML Parser error: 'unable to open primary document entity 'G:/GISMapping/FME/DBYD/LineRequests.gml''

The XML Module halted on error, see the logfile for detailsI have a workspace that works fine with Desktop but fails with above errors when running through Server?

3890

7 years ago

angwanContributor

asked in Data

download a feature service from agol

7 years ago

13gamat

asked in Data

converting a pdf to excel

In my SW to Postgres geodatabase dynamic translation using SchemaMapper, there are two attempts to connect to Smallworld and the second one always hangs so the translation doesn't complete. Anyone know a way around this?

7 years ago

vikram

asked in Data

check if feature class exists

Hello, Is there a way to check if a feature class exists in a file geodatabase . If not , throw an error . Is this possible ?

970

7 years ago

f.kemminjeContributor

asked in Data

how can i read or write to smallworld PNI

I installed smallworld PNI(Physical network inventory)In the same machine also installed fme desktop 32 2017 with GE smallworld licensing 30 days eval license.also requested GE to provide *.dll and *.fmf files for fme(for GE smallworld reader and writer ), and placed in respective folders.I opened fme desktop and tried to add the smallworld reader , but fme saying “ unable to connect smallworld server, is it running?”now how to start smallworld server ? Do we need to start fme inside PNI ? if yes where should I go to start fme?I strucked somewhere. pls help me

file geodatabase raster histogram

Hi FME fans, Does anyone know if it is possible to create a histogram for a raster in FME? This would be similar to the 'calculate statistics' arcgis tool. I am using the file geodatabase raster writer. Thanks, Owen

Is there a way to Group Readers if the readers have been added individually?

Folks,Pardon my nomenclature, I suspect that's part of my problem.I've been adding Mapinfo Readers as I've needed certain tables to be converted to CAD. That's left me with a list of 10 separate readers in the navigator.Previously when I did something similar for MI > GML I just added ALL THE TABLES in a single Reader as a group.Changing data sets is snap you just open the new set.With the individually added one-reader-per-table I need to go into each Reader and open the corresponding table.Is there a way to "group" these readers so I can open the referenced tab files as a set?

Hiya,Im having a problem using an Airtable API https://airtable.com/ to pull data into FME. I have followed a similar solution to a previous API link, yet Im getting this error below. Can anyone help with the below?JSONFragmenter(JSONQueryFactory): A JSON syntax error was found at line 5, column 9JSONFragmenter(JSONQueryFactory): Unexpected character: 'v'. One of the following characters was expected: '"', '}'The below feature caused the translation to be terminated

WHERE Clause and SELECT Statement for reader plugin; feature type - Parameters tab

Hello,I have our own FME plugin which works fine on FME 2016 and 2017.On FME 2017 I see "Where Clause" and "Select statement" added to Parameters tab of Feature type dialog (dbl click on Reader). See the pict below:Question: do you know what changes / additions shall I make to my plugin .fmf file (or any other file(s)) to enable these "Where Clause" and "Select statement" settings for my custom plugin as well?I checked "oracle_spatial.fmf" but do not see what exactly code causes Oracle Spatial plugin to enable these two settings.Thanks!

Replicate in FME this Excel example

I have an example of something I can do in Excel but looking to do in FME. Please refer to the PDF attachment....The first image shows a snapshot of a fictional table of data. Each employee has a unique "EmployeeNumber" and also a unique "CardNumber". The field called "Event" shows a record of every instance over a week, where an employee has either "swiped in" their card to enter an office building, or has "swiped out" to leave. So for example, Hannah has used her card 5 times in the week to either enter (swipe in) or leave (swipe out) the office.The second image shows a pivot table in Excel, which sums the number of times an employee has either swiped in or swiped out. I have then added the field called "Difference" as I simply wish to compare the number of times an employee has swiped in compared to when they have swiped out. And I am especially interested where the difference is 1 or more.My query is this ; can FME replica

7 years ago

bbbutler

asked in Data

XML Newbie - field names and how to parse

Howdy y’all!XML newbie here and I have to build a workspace to parse a xml file. I’ve been messing around with the xml reader a bit this morning and cannot seem to get any results. One of the things I noticed immediately is that the field names seem to be only contained in the metadata. Can someone out there maybe show me how to parse these data and write them to something more favorable (excel, shapefile, geodatabase etc)?Here’s a link to the xml file I’m trying to translate - https://drive.google.com/open?id=0B52_Im1hHfSbOWM2cnA0NDAxdGcThanks in advance for any/all help.

How to consolidate Excel worksheets by columns ?

Hi all, I am new to FME.Which transformers should I use to solve the following problem ?[1] The input Excel file has 3 worksheets, each with 4 columns (1 primary, 3 secondary).[2] The output Excel file should have 1 worksheet for each secondary column, and the data should be labelled by input worksheet name.[3] What if there are a few hundred secondary columns in each worksheet in the input Excel file ?In other words, "transform feature types to attributes".I was trying to use AttributeManager but did not know how to get hold of the name of the feature type.Thank you.* Input Excel file :* Expected Excel file :

7 years ago

at101

asked in Data

Use Oracle Spatial Object writer for oracle GDB without Oracle spatial license?

Hello! I have ESRI feature classes stored in oracle Geodatabase. It uses ST_Geometry. I do not have oracle spatial installed on oracle database. Can I still use FME oracle spatial object writer to write to such ESRI Feature class?

Writing html string to an AGOL hosted feature layer

I'm transferring data from an ESRI Geodatabase to ERSI AGOL cloud. One of the attributes in my feature is a string field that contains html text. When I run the workbench I get the following error message:ArcGIS Online Feature Service Writer: Encountered an unexpected error. The error code from the server was '400' and the message was: ''. Details: 'Field DESC4 has invalid html content.'An exampe of the string that is being transferred isHere is a video with more information on this project: <a href="https://www.youtube.com/watch?v=Kkce_ySK5Cs#t=17" target="_blank">Ripple.</a>If I remove the two '=' in the href portion of the html. The data is successfully loaded into AGOL. However without those the link does not work.Anyone have ideas as to how get this data into AGOL?

How to store feature attribute and reuse within works pace?

Hi,I am querying a DB table for some records and filtering few of them to create an XML string then sending this to an web service through HTTPCaller.After successfully sent this XML,i would like to update the table back with status filed = 'Y' for all the records i have fetched initially.The records i am fetching has got ID field which i would like to use for matching purpose but how could i store this ID within the workspace initially after fetching from DB and reuse for my update at the end of my process?Any help would be much appreciated.Thanks,reachmj

URL data type to string

Hi ,I am trying to convert an access file to gml. I have an attribute in an access table that is of URL data type (with a value: www.test.com). I am mapping this attribute with the corresponding attribute of the writer that is of xml_buffer data type (the writer is defined based on an existing application schema). Then, in the produced GML, it appears like this: #www.test.com# Could you please let me know how I could avoid these # (hashtags)?Thanks you in advance, Valantis

7 years ago

wanta

asked in Data

FME Server 2017.1 cant write to PostgreSQL DB

Tried to copy feature classes from a Microsoft SQL database to a postgresql database using SDE Connection files. The workbenche does fine on FME Desktop 2017 but on the fme Server 2017.1 i get following error: "Could not open the Enterprise Geodatabase. The error number from ArcObjects is: '-2147155644'. The error message from ArcObjects is: {Cannot connect to database because the database client software failed to load. Be sure the database client software is installed and configured correctly.} "

7 years ago

harknessandrew5

asked in Data

Is there a way to update the GeoLocation of a IFC model in FME?

Hello, I'm working with some IFC files for a project. As part of the project I need to change the GeoLocation of some of these files to better match the final model that I'm making. I'm doing the final model in Infraworks and the IFC are exports from Revit.

150

7 years ago

Page 192 / 273

Badge winners

aawad.93has earned the badge Student (Grey)
aawad.93has earned the badge Arabic Speaker
aawad.93has earned the badge English Speaker
aawad.93has earned the badge French Speaker
aawad.93has earned the badge Welcome Back

Show all badges

30,457: 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.