Using readers and writers to extract and load data.
Recently active
Greetings,I am trying to create an FGDB empty geodatabase with feature datasets, feature classes & attributes. I have all these information stored in a xls file, I want to read this xls and create the FGDB accordingly. If anyone has a workflow, please share. Thanks in Advance.
Hi,I have a lot of DXF Files in different folders. The DXF files have all the same layers.I don´t need every layer of the files for my work. So I want to read every DXF file, filter the layers which I need, summarize them to different groups and store them in a new file.How can I built such a workbench?Thanks and best regards.
Is there any transformer that help me to change from any of the python valid formats for GUIDs to the arcpy valid format to insert it in the geodatabase?The valid formats from python are:{00010203-0405-0607-0809-0a0b0c0d0e0f}00010203-0405-0607-0809-0a0b0c0d0e0f000102030405060708090a0b0c0d0e0f{000102030405060708090a0b0c0d0e0f}the valid format received by the geodatabase is:{00010203-0405-0607-0809-0a0b0c0d0e0f} thanks!!
Today is 2019-SEP-20%Y = 2019 / Year%b = Sep / Month%a = Fri / Day Name%d = 20 / Day%u = 37 / Week of Year??? = 3 (3rd Friday of September)What I'm trying to find this is the 3rd Friday this month?ie2019-SEP-06 is the 1st Friday of September2019-SEP-13 is the 2nd Friday of September2019-SEP-30 is the 3rd Friday of September2019-SEP-27 is the 4th Friday of September
I need to read an Excel spreadsheet. I use user defined parameters to set a filename and a sheet name.This is a simplified workflow:This is a parameter I use: and this is schema settings for FeatureReader It gives me the following error: Here is my test example
Hello, I am new to FME Server and would like to know if there is a way to filter the output of a workbench with automatons? I my case i have two Schedule triggers that run a workspace. When the workspace if finished it updates a Excel file on a network drive. Now I would like to filter the contents in the Excel file so that i send an email to one person or another depending on what values are in the updated Excel. IS this possible with automatons?
We're having significant performance issues with Xref drawings created by FME. In AutoCAD there are options in the "Save As" dialog to allow the drawing to be saved with layer and spatial indexes, but I can't find a way to set this in the DWG or Map OD writers in FME. Is this available somewhere or simply not possible with FME 2018? If it turns out this is not possible in the currently available writers, then as a work -around, if I save the template drawing with layer and spatial indexes, will this carry through to the drawings created by the writer in my workspace? Thanks,Gary
Hi Folks,I understand that the jobs on FME Server (v. 2018.1.1 - Build 18567 - win32 ) are executed with the user that uploaded/published the workbench to the server. We work with active directory on FME Server. So some people have rights to publish and schedule jobs on FME server.Where can you easily change the user that runs/executed that job in the web interface of FME Server?We also configured the fme engine service runs with a specific user with access to certain network drives. Does it mean that this access is only used in the workbenches that were uploaded on FME Server with that specific user account we configured for the engine service?Thanks for sharing your knowledge,Francis
I am trying to read from two large csv files with one FeatureReader for each file. Each FeatureReader is connected to a separate FeatureWriter to write to a Postgres database. I experience the problem that all data is cached first and then delivered to the writer, which will eventually exceed my memory. Since there are no transformers in between I do not now how to solve this issue. I experienced this problems in the past when I used ordinary writers, but never with a FeatureWriter, so I guess it has something to do with the usage of FeatureReader.
Hi Suddenly that the FME can't load the CSV file.When I select the csv file as input of the reader, there is exclamation mark on the Parameter. I checked the parameter is fine (delimiter, fields name, data start line) as the preview also look fine.But the "OK" button can't be clicked. Anyone know what is wrong? FYI, I can open the file normally with excel. I'm using FME Workbench 2018.
Dear people,I have an excel file which contains a dynamic table, in this table there are formulas referencing to parameters on another sheet. Without going into detail, there needs to be a recalculation of certain coordinates. So far i was able to get an excel sheet with the extracted coordinates into the right order and structure. At this point I just want to write away this coordinates into the excel file dynamic table and let excel do the calculations so i can use these new coordinates further on into my module. So the problems i have are: 1) How do i write away the data into a dynamic table? Now it just puts my data underneath the table...2) Is it possible for FME to get the values of parameters which are written on other sheets but in the same excel file to do this calculations (also the sheets don't look the same, different columns etc.) Any ideas that can put my in the right direction will be greatly appreciated, If you need any further info, just let me know, I hope you peo
I have come across some examples where FME 'appears' to change the names of levels which are read in from a dgn file. When viewed in Microstation and Bentley View (v8) features will be on a level called 'UT-UT-CAT_Survey_Underground_Unknown' but FME says these features come from a level called 'AR-AR-CEILING FINISH-Z'.What is FME reading to get this alternative level name?
I have a solar potential raster file which shows the solar potential on each building pixel wise at 0.5m resolution and no data in the rest of the area. I want to show that potential map on top of my 3d Building citygml. is there any way to overlay the raster over the 3d buildings.
Hi,When a job is run on our FME Server system, I see this list of shared folders for formats, transformers, coordinate systems and coordinate system exceptions:How does FME Server determine these folders? Which user is used? Does it depend on any user logged in onto the server? Is it documented somewhere?Thankx for any answer.
I often get this error, while the Workspace-Runner was started with new parameters. Reducing the log-level did not help Any idea how to fix this? I found no comparable community-Item .. I am calling a Workspace-Runner within the project. The workspace is called thousends of times. The calling workspace and the called one work each into their own log-Files. In this example 954 of 1461 calls crashed. In the logfile of the called wsp there are now errors mentionend.Many workspace-calls crash because the newly initialized workspace can't access the logfile because the last call has not yet closed it.This is the error description:I would like to use the option with concurrent processes, but it increases the error rate.The called wsp has one logger configured like this:What else is needed to give you an idea of the problem?Looking forward to a solutiion,Christoph
I have a logger output excel spreadsheet where the easting, northing, height, and sensor value are in one column but I need them each to be an independent column. So I need to add four new columns to the excel and populate them from the one column while leaving the loggercode and dateutcdate alone.
i have information table1 like below Colomn\\RowABCD1SNSFruitCOSTQuantity21Apple20per Peace32Banana3per Peace43Orange8per Peace54Mango50Per KG65Cherry250Per KG76Papaya40Per KG87Graps80Per KG98Dragon200Per KG109Kiwi30per Peace1110CustedApple60Per KG1211Fine Apple40per Peace1312Green Apple25per Peace and having another table2 Colomn\\RowAB1Fruitapple2Price i need write value at table2 Cell position B2 with 20 from table 1
hello,i am trying to texture a building but the image just stretches over the whole wall.what i want is for it to stay the size it originally was and if the whole wall is not filled in that it puts another one next to it.
HI,how can I adjust the writer, so I can specify the destination folder every time different?I have the same Workspace, but I need to write the results all the time in the other Folders. I do not want to create/add all the time a new one. And I need to publish it into a Server, so the writer, and also the reader need to be a flexible.Thanks
Hi. I'm a new to FME and so far I am excited and overwhelmed. I am trying to connect to an exteral SQL database (CAD 911), run query, geocode query results, and write to an existing esri point featureclass. I'd like this to be a scheduled job where it updates the featureclass with new sql database records daily. This seems like FME 101...
I have a set of the CityGML data (LoD2). I have to add the missing ground floor layer “building footprint”. Also, repair other errors in the geometry. Is there an automatic way to do that?
I am trying to connect FME desktop to ArcGIS Online. Taking hint from the article in this url, the networks team whitelisted www.arcgis.com and also bypassed authentication. Attached is the image showing the steps carried out by them (for people with knowledge of proxy/firewall). I have rubbed out some parts.I have been able to create Web Connection however unable to retrieve data from AGOL. I get the error file attached agol_fme_error.txt when trying to fetch Feature Service in the AGOL in Esri AGOL Feature Service Parameters dialog box.I didn't mention filtering to the networks team before carrying out the work. Could it be a reason? Any other suggestions are welcome.Extra information:a. FME Desktop 2018 64bitb. Able to login to AGOL in web browsersc. Able to connect to AGOL via ArcGIS desktop v 10.6 Thanks in advance Vidya
Hi,My problem is about a process that update a postgis table from an other geographic database. Sometimes the import stop working nearly at the end as you can see :POSTGIS writer: 6589 of 6765 features writtenPOSTGIS writer: 6601 of 6765 features writtenPOSTGIS writer: 6606 of 6765 features writtenPOSTGIS writer: 6628 of 6765 features writtenPOSTGIS writer: 6649 of 6765 features writtenand then, no more log for hours.The fact is that it doesn't seems to come from data, cause when i start the process by little packet sometimes it works, actually this slowness seems to be unpredictable. But always occur at the end of the process. And yes computer is working and doesn't seems to be saturated : Proc 8%; Memory 21%. Does someone have any idea of what can i try to understand what happen ??Thanks
Hi all,I noted that coordinate precision of the objects is changed when loaded into the ESRI FGDB.Using the coordinate rounder, all objects in my migration process are rounded on three decimals (on a mm), and even the data in the source system have only 4 decimals.I want to load them as such into the ESRI FGDB using FGDB writer. Source for writing is FFS file.After successful loading process, I checked results in ArcMap and in Inspector. What I can see is that objects and vertices have many more decimals then in the data, which I loaded.The resolution of the database is 0,0001 and tolerance is 0,001. This is also not clear to me, how I managed to write so many digits with 0,0001 resolution.I removed all coordinate systems in order to avoid coordinate transformations. I tried to set same coordinate system on the target as on the source, but unfortunately, the result is the same.Does someone have an idea why does extra vertices are appearing? How I can simply write the data which I have
I have a ESRI Geodatabase (ArcSDE Geodb) writer which is returning: An error occurred while attempting to start an edit session. The error number from ArcObjects is: '-2147217150'. The error message from ArcObjects is: {The current version does not support editing (base, consistent, or closed) [An open transaction was detected. All user transactions must be closed prior to StartEditing.]}The problem is there are no locks on this feature class layer so no open transactions?