Using readers and writers to extract and load data.
Recently active
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
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
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 help me understand why it is failing there as I have searched everywhere in FME for this answer to a simple fail po
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 output a list of
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