- - Community Resources
Ideas
Product Updates
Events
Blog

Home
Forums
FME Form
Data

Data

Using readers and writers to extract and load data.

6,810 Posts
25,086 Replies

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

6810 Posts

Most replies

Most views

Newest first

lazarlubomirContributor

asked in Data

AIXM - srsdimension tag causes problem with validation

Hello everybody,I exported AIXM datafile from FME and I tried to validate it here: https://swim.m-click.aero/validator/ with profile "AIXM, GML Aviation Profile, no Business Rules". Validation result told me that tag "srsdimension" is not correct for AIXM (exact form is "attribute 'srsDimension' is not declared for element 'ElevatedPoint'"). AIXM writer automatically puts SRSDimension tag to exported datafile. So I wanna ask, where is problem - in validator or FME has wrong schema definition for AIXM?I attached sample of my export.Thank You!Lubo

boubcherContributor

Hello Therewe have the 360 JPEG, in order to view them in 360 viewers we need to have EXIF metadata, to that we use tools with many manual stepsis there a way we could do that using FME when we read the image and save it with all the EXIF metadata Sample image attached

293

4 years ago

geouser97Contributor

asked in Data

How to count vertexes in a dgn or shapefile

bonjour j'ai un fichier dgn que je souhaite calculer le nombre de sommets qu'il contient puis afficher le résultat dans un fichier Excel. des idées commentent le faire avec fme.

4 years ago

sprongandre

asked in Data

dwg to gdb including symbology for arcgis pro

I can translate a dwg to gdb for in ArcGIS Pro. I can convert the autocad colors to rgb so I can match them in Arcgis. But....How can I translate all the symbology from the dwg-file to a gdb so I can see in ArcGis the drawing on exactly the same way as in Autocad?Thanks!

Could not Find a Layer/Table matching Feature type "name"

Nathan@safe I have created the Stop Sign Writer and the Height Restriction Writer and the RR Crossing Writer and then when I go to Insert the writer in the Workbench it requires a layer name that it already assigns or puts in there (we are free to change this to whatever we want as per FME Software Help) Everything runs beautifully ......right up to the very last instance of Global Variables Final State Summary When it runs …….it fails at the Writer because it cannot find that layer (I have used every conceivable Layer Name on this earth and it fails no matter what is used) ArcGIS Online Feature Service Writer: Could not find a layer/table matching feature type 'Stop' I am INSERTING and TRUNCATING on the writer to overwrite all and replace the FS with what I am writing out from the FME process No matter what I do it fails at the Layer Name Can you help me understand why it is failing there as I have searched everywhere in FME for this answer to a simple fail po

Error with ECW files in 2020.0.3

I can't read or use any ecw file in 2020.0.3 version.When I try to load them in FME Data Inspector, the program suddenly quits after a few seconds Even before seeing the image.I can't add an ECW reader to a blank workbench. It reports the next message: "Error running translation. Workspace generation filed."Everything is ok in 2015.1 version.

4 years ago

dina_dodo

asked in Data

how could i find the excel file by search by ID from the main excel file ,and extract the name beside this ID

i have main excel file that has attribute called ID and it includes lots of different IDs and i have different of excel files in specific folder , each file has the id plus his specific name . how could i find the excel file by search by ID from the main excel file ,and extract the name beside this ID ,if it is possible to extract specific row from the excel file when it matches Main excel file has as exaple id no. 10 i have excel file called 10 - FLM -doya so i want as first to find the excel file begins with 10 , then extract the name beside it in another column FLM-doya i need also ut after this step ,extract specific row C 1 inside the excel file that FME found Thanks alot for helping

filecopy writer error on no overwrite

I'm trying to use filecopy writer to copy a folder and its subfolders to a new location. I want to use FME to periodically copy my working folders to the server instead of using a script. I have set the 'overwrite existing file' option to 'No' - the intention being that only files that don't already exist in destinations location will be copied.I get an error indicating that a file i'm copying already exists in that location or I don't have permissions to the source and destination. The file definitely does not exist in the destination location. I'm just testing this on my C drive and writing from one of my document folders to C:\\temp so there should be no issue with permissions. Also, I have I have also tried the 'yes' option which just overwrites everything and that works fine. I'm using FME 2020. Any help would be appreciated.The picture below shows the simple workbench. I'm reading a folder and using a logger to output a list of

Generate numbers in pairs

Hello,how to generate numbers in pairs from 2 to 80 and from 3 to 77.ex: 2, 4, 6, 8,.....803, 5, 7, 9,.....77Nr. 1Nr. 2238077

290

4 years ago

simonhumeParticipant

asked in Data

Lat/Long how to display correctly

I'm looking for a bit of advice on how to correctly use the latitude and longitude information in a jpeg (from the exif information). I've exposed the jpeg_exif_gpslatitude and jpeg_exif_gpslongitude information in fme but, when i inspect the output, the lat and long are displayed with brackets like this; (52) (15) (7) (1) (9) (6) Which i think equates to Degrees, Minutes and Seconds? How exactly does this field need to be displayed so i can create a point using the vertex creator then output to shape? I've tried the StringSearcher with the following: Search in: jpeg_exif_gpslatitude Contains Regular Expression: [0-9][0-9] Which outputs 52 into a new column, but i'm struggling to add the other parts of this field to get a meaninful coordinate entry Any advice anyone can provide me with would be very helpfulregards

How to read an excel file, and write to the same file that FME is reading?

I receive an error when I try to read and write to the same excel file, is there something that I'm missing?

450

4 years ago

benvkContributor

asked in Data

Text File Writer is prefixing each line with a 'space' character

Has anyone had an issue when writing to text file, it prefixes each entry with a 'space' character?It is writing each new line nicely, appending to the existing data, but the data it writes always is inserted with a leading space.I can confirm the row being sent to be added to the text file does not have any leading space:When this is written, a space is appearing!

4 years ago

ivopaffrath

asked in Data

Directory and File Pathnames FME Server with Windows Login

Hello, I would like to access a protected network address with a reader (Path / filename) and search the folder structure. To do this, I have to log in with my user name and password. I get access through the Windows network, but not via the FME server. I have already tried all 5 network authentication methods. What to do here?

How to transform a shapefile of lines to a wavefront .obj file?

I wanted to transform a shapefile of lines to a wavefront .obj file. In the resulted file test_obj.obj, I did not get a list of vertices and a line starting with "l" to represent a line.Below are three images. The first one shows shapefile "test" with a line. The second image shows how I configured in FME to get an obj file of the line. The third image shows the resulted obj file, which is "empty".Can anybody help me?

How to keep color on the first row of excel writer?

I am writing out to excel and need to have the top row have different colors. Is there a way to just color top row? When I assign a color in the writer it applies it to the whole column.

Extracting geomtry from Oracle 12c database to WKT

I have a 12c Oracle database that has a line feature class and a point feature class that contains geometries , i want to know how i convert to OGC wkt and extract to a .csv file, i have tried to use the Geometry extractor and write to CSV , but when i view the file within the data inspector , no geomtry is present and no values to depcit the geomtry are present either, is there something that I am missing in my workbench ?

Process failing due to conflicts found in version

I have a fme process that runs daily that updates records in a geodatabase table. Every couple of days I get an error after the process attempts to reconcile the version. The version is dedicated soley for this process. The process fails after it can not successfully reconcile the version. I am getting the below error: "Conflicts were found when reconciling version 'GAS.FMEPROD' with target version 'SDE.DEFAULT'. Conflicts were found in the table(s): GAS.gValve. These conflicts must be manually resolved. The reconcile operation will be undone and none of the changes will be saved" I am not sure if anyone has had this issue before. Any solution or information that can be provided would be helpful. Thanks.

4 years ago

tfcwParticipant

asked in Data

Splitting an Oracle polygon into lines and arcs

I have an Oracle table full of polygons, I'd like to split them into the arcs and line segments they're composed of.Is there any way I can do this? The closest I've found is setting a Chopper to split every 2 vertices, but this has the effect of turning any arc segment into several straight line segments, which is unwanted.

280

4 years ago

boubcherContributor

asked in Data

feature reader where clause

Hello There I am reading a large file GDB , using the FeatureReader , but the where clause is disabled, when I user normal reader this option is enabled ?? andy reason for that the goal is to increase the performance when reading the featuresThanks

1600

4 years ago

tnarladniEnthusiast

asked in Data

Reading Excel formatting

Is there to read in the formatting of the excel? I need to find all the records that are filled in red and exclude them. I tried fme_fill_color and fme_color but those weren't it. Thanks!

Problem with Access in FME after Office365 migration

Hi,After a migration to Office365, FME is unable to open Access files. The following error is given:Microsoft Access Reader: Unable to find provider 'Microsoft.ACE.OLEDB.12.0', falling back to 'Microsoft.Jet.OLEDB.4.0'. The 2007 Office System Driver might be missing from your system; follow this link for more information: http://www.microsoft.com/download/en/details.aspx?displaylang=en&id;=23734Microsoft Access Reader: Connection failed. Connection string `Provider=Microsoft.Jet.OLEDB.4.0;Jet OLEDB:Engine Type=5;Data Source=K:\\dienst VR\\02_rapporten\\Lijst_SEVESO-inrichtingen 2016.accdb;User ID=admin;Password='. Provider error `(-2147467259) Onbekende database-indeling K:\\dienst VR\\02_rapporten\\Lijst_SEVESO-inrichtingen 2016.accdb.'We tried installing 2007 Office System Driver, as given via the link in the error message, but this did not solve te issue. The following error message still appears:Microsoft Access Reader: Connection failed. Connection stri

750

4 years ago

plidianContributor

asked in Data

SharePoint reader FME 2020 error retrieving list of lists

So today I learned about how to use webservices and connect to a SharePoint online list using my organization credentials.Regular old SAML wasn't cutting it so I had to use the WebService feature of FME.I created a new template by replacing the [tenant] with the subdomain to which I was trying to connect. And everything went swell, I authenticated successfully and the connection saved.Then I went and created a new workspace with a new reader for the SharePoint reader.The good news is that the authentication went successfully.The bad news is that when I then clicked on the ellipsis to select the list, it didn't work. Updating access token for 'NewConnectionFromWebServiceTemplate'Microsoft SharePoint List Reader: Client-side error: '401 Client Error: Unauthorized for url: https://subdomain.sharepoint.com/sites/subSite/_api/web/Lists?%24select=Title%2CId&%24filter=Hidden+eq+false' returned from SharePoint. Error message was: ''OK Fine I've permissions to authenticate against the site

Reading excel files from Sharepoint

Hi,i have to read an Excel-file from a Sharepoint-Site. The Authentication Method is Kerbeos. Any suggestions ?Barbara

Convert entire POSTGIS schema (1900 tables) to KML subfolders inside a single directory KML file.

I have 1900 tables inside a single schema inside a PostGIS database. I need to convert each table into a KML folder and then have all folders placed inside one giant KML parent folder and viewed in Google Earth. Additionally, I have 5 syle colors classes I need to apply to the tables as well.

PDF filename when using Data Stream service with PDF2D writer

Hi,I would like to set the default filename for the PDF which is opened in my Data Streaming service (using the PDF2D Writer). I can't work out how to do this. I have seen the following post which mentions setting the MIME Type, but I'm not sure how to do this..https://knowledge.safe.com/questions/85804/fme-server-data-stream-datafile-writer-pdfs.html Thanks!

160

4 years ago

Page 67 / 273

Badge winners

buraskyhas earned the badge Integrate Spatial Data
langdonmshas earned the badge Student (Grey)
langdonmshas earned the badge Teacher (Grey)
langdonmshas earned the badge Welcome Back
sclarke_97has earned the badge Welcome Back

Show all badges

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