Data

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.

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

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

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.

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 

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.

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?

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?

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.

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.

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

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.

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

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  

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.

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!

  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 hel

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.

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  

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

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

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

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