- - Community Resources
Ideas
Product Updates
Events
Blog

Home
Forums
FME Form
Data

Data

Using readers and writers to extract and load data.

6,779 Posts
24,927 Replies

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

6779 Posts

Recently active

Most replies Most views Newest first

connecter

asked in Data

ExcelStyler first row no colour

Hello,my problem is to style a simple Excel table.When cell xy is 1 --> colour background set to red.It is working in many cases only the first row doesn't turn red. What am I doing wrong?Result in Excel: Thanks for your help. :)

Get Feature Service Item ID and URL from Reader/Writer

After running a feature service reader or writer a bunch of information is logged such as:ArcGIS Online Feature Service Writer: Getting item with ID '2b51386cf7b346d59fda3ff653deccc3'ArcGIS Online Feature Service Writer: Requesting metadata for Feature Service at 'https://services5.arcgis.com/7X0RdDUh866P5Y57/arcgis/rest/services/FeatureServiceName/FeatureServer' Is there anyway to get the item ID and URL of the feature service as attributes to use in FME? I want to be able to get the URL of the feature service that has just been written to, so I can then do another web request, but I don't seem to be able to get those attributes from the writer?

721

4 years ago

sameerContributor

asked in Data

FME Server login failed due to change of OU in Active Directory

HelloI would really appreciate it if someone could assist me in resolving the below issue as soon as.My AD account shifted to a different OU yesterday and as a result the canonical object name has changed. I can no longer login however the scheduled jobs are still running. I must investigate 2 failed jobs but can't do so anymore.I came across the following: https://knowledge.safe.com/idea/75118/fme-server-active-directory-away-from-distinguishe.html and wonder if that could be related. Sync AD did not work. Checked logs and nothing obvious found.I've moved my AD user account back to the original OU and I can now login but my user account must be shifted back to the new OU. I think what I'll need to do now is to re-assign the jobs to a different "owner" to avoid the above issue. The new "owner" will be a ServiceAccount type.Questions: Is there a way to manually amend DN / CN Names? How to re-assign all jobs to a new "Owner"? I'm planning on

Parsing a W3C Extended Log File

My goal is to read log files from Amazon 33 and parse them into a databaseThe log files look like this:-#Version: 1.0#Fields: date time x-edge-location sc-bytes c-ip cs-method cs(Host) cs-uri-stem sc-status cs(Referer) cs(User-Agent) cs-uri-query cs(Cookie) x-edge-result-type x-edge-request-id x-host-header cs-protocol cs-bytes time-taken x-forwarded-for ssl-protocol ssl-cipher x-edge-response-result-type cs-protocol-version fle-status fle-encrypted-fields c-port time-to-first-byte x-edge-detailed-result-type sc-content-type sc-content-len sc-range-start sc-range-end2020-07-03 13:39:54 LHR62-C3 1571 148.00.00.00 GET d36on651kzt577.cloudfront.net / 200 https://URL/2020/07/02/fooo/ Mozilla/5.0%20(Windows%20NT%2010.0;%20Win64;%20x64)%20AppleWebKit/537.36%20(KHTML,%20like%20Gecko)%20Chrome/83.0.4103.116%20Safari/537.36 - - Hit gIanUGtmvquSunAiRJFbhFdPbexwpIV2DbtYUJ7XtVOKZopkUl1uEw== foo.com https 427 0.001 - TLSv1.2 ECDHE-RSA-AES128-GCM-SHA256 Hit HTTP/2.0 - - 58606 0.001 Hit text/html;%20

Convert a .txt to excel and strip out some columns

I am complete novice to FME. I have a .txt file which I wish to convert to excel. But I only want some of the information to be brought into the excel spreadsheet. I'm not sure how to begin. All I want in the excel spreadsheet (bottom image) is the name e.g HP40 but without the .tif extension and the date e.g 04/03/2016 without the time.I am not sure what connectors to use or how to strip out the unwanted info from the .txt file.

geo-referenced energy database BIM-CityGML-ADE

HI EVERYONE. I AM LOOKING TO CONSTITUTE A GEOREFERENTIATED ENERGY DATABASE STARTING FROM REVIT. I AM NEW TO THE THEME, AND I HOPE YOU CAN HELP ME. IF I AM NOT WRONG, I have to CONVERT THE REVIT OR IFC FILE (VERY SIMPLE GEOMETRY) IN CITYGML AND THEN ADD ENERGY DATA WITH ADE? After this, on which tool can I see the mapped information? are there any tutorials to do it or some examples?Thank you very much for your help

mongodb reader 13 min to connecting my collection

Hi,To connect one collection to my mongodb database (20 collections) it takes 13 min.When i try with another database (4 collection) this is faster (10 seconds).Have you got an idea to accelerate time connexion ?ThanksBest regards

4 years ago

geoinspirationParticipant

asked in Data

How to generate 3d citygml road data

I want to produce 3d citygml road model (textured). I have road line data as shapefile and lidar data of the region (both aerial and terrestrial) and also orthophoto (10cm res). Is it possible to produce 3D citygml road data with these data using FME possibilities? Thank you.

FME file mover object

Hi all, does anyone have experience in using the filecopy/mover object.I have created a photo exiff extraction to o tab file workspace. what I would like to do its once its processed it moves it to a new location.I have no idea how to place the object, does anyone have an example of doing something similar> Dave

writing files with ssh

I want to write files with scheduled workspace on fme server to a Linux server using SSH. I think i have to use python. Does somebody have experience.

There is no geometry in this view?

I can preview data with Inspector in workbench. After I wrote the data out as a GML file based on XSD schema, I looked at the GML file in the FME Data Inspector. But it appears that there is no Geometry in this View. What is the reason? Is there an error with setting parameters for writing GML files?Can anyone help me?

gvenhorstContributor

Hi,Have multiple text files that need to be converted to a csv file.The source text file contains three lines per object, which must be merged into 1 line. (number of objects is unknown in advance)Example,100:00:00,000 --> 00:00:01,000F/6.3, SS 1000, ISO 100, EV -0.3, RTK (4.672639, 52.794202, 28), HOME (4.671729, 52.794208, 43.55m) 200:00:01,000 --> 00:00:02,000F/6.3, SS 1000, ISO 100, EV -0.3, RTK (4.672639, 52.794203, 28), HOME (4.671729, 52.794208, 43.55m) The result should be according to this example.Time,F,S,Iso,Ev,RTK.Longitude,RTK.Latitude,GPS,Home.Longitude,Home.Latitude,Home.Elevation.m,00:00:00.000,6.3,1000,100,-0.3,4.672639,52.794202,28,4.671729,52.794208,43.5500:00:01.000,6.3,1000,100,-0.3,4.672639,52.794203,28,4.671729,52.794208,43.55 Who can help me with that, if only to merge 3 lines into 1 line in a loop.Gerard

GOOD MORNING. I AM AN ITALIAN PHD STUDENT. I WOULD LIKE TO CLOSE MY THESIS INVETIGING THE INTEGRATION BETWEEN BIM AND GIS. I HAVE DISCOVERED THIS PLATFORM NOW. TIME FOR MY SEARCH IS VERY NARROW. THE TUTORIALS I FOUND ARE FROM 2013or2015, IS THERE SOMETHING MORE UPDATED THAT I CAN CONSULT TO ACCELERATE THE EXPERIENCE?

Revit to IFC Quick Translator Issue

Hello fellas,I've been trying out the new Revit reader and convert it to IFC similar to what Autodesk Revit could do. Nonetheless, the FME Quick Translator could not handle the translation. Is there a quick and "plug and play" workbench for this matter? I have tried setting up the workbench but creating multiple IFC sub-classes (e.g. IfcWall, IfcBuildingStorey, etc) but the result is not ideal. The converted data stored in a table instead of 2D/3D?I m looking for a solution to export IFC and CityGML from Revit in one workbench/ one source. Appreciate it.

Importing MS Access attachments to Esri Geodatabase

Hello,I was wondering if there is a way to import an attachment from MS Access 2010 record to ESRI geodatabase using FME 2015. Thanks.Samir

Dear all, i have question about looping. I have script, which is getting information from database - based on one parameter "_Powerline". I'd like to loop through several values of this parameter and have many ouputs in one script. is it possible? With custom transformer? I don't have experience with this stuff. Thanks in advance for help.

Raster Replacer to PDF

Hello!I have been pulling photos down from ArcGIS Online and have used the RasterReplacer to JPEG writer workflow to do this. I now need to pdf the images.Can I do this straight from the raster replacer or is it better to start a whole new workflow converting JPEG to PDF. Thanks

3d mesh from Geotiff heightmap

Hi I'm new to FME and have discovered this program and its capabilities. I was wondering if it is possible to create a georeferenced 3D mesh based on 1 or several heightmaps that are geotiffs that have been created in ArcGIS.

961

4 years ago

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

263

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

415

4 years ago

Page 65 / 272

Badge winners

danilo_fmehas earned the badge Webinar Watcher (Gold)
sjakohas earned the badge Teacher (Grey)
ahmed.shahinhas earned the badge Integrate Data with the FME Platform Training
sjakohas earned the badge Welcome Back
jcvanlingehas earned the badge Expert (Grey)

Show all badges

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