Using readers and writers to extract and load data.
Recently active
Is there any documentation on how to use the Advanced Text Editor within FME? I want to find all attribute names that contain the source table name in a tabular (CSV)translation. Because I end up with several million features per input table I don't want to use substring on the fme_basename attribute - I want to extract the source table name from the Source parameter once per source table. There might be a substring operation in Advanced Text Editor, who knows? Thanks, Ian
Hi all, any experiences in terms of how much of the time we could save when running Workspace using SSD for temporary files storage instead of regular disk. Particularly, it would be interesting for following model situation: FME 2012 64bit Desktop, WS ran 20 hours and stored 250GB of temp files on regular disk (but separate one). Thanks, Jiri
We are exploring the possibility of using FME server in our workflow. We are currently running FME Desktop. One of our primary data inputs is in VPF data structure. With Desktop, we simply choose the entire directory when starting a project. However, I'm not sure how this would be accomplished with Server. It seems a specific file needs to be uploaded to server, rather than a set of directories and sub-directories such as VPF data. Has anybody ran into this before?
I'm trying to generate an unique ecw file, which contain at different scales, different information. For example: - at 1:100.000 a map - at 1:50.000 an satellite image - at 1:10.000 aerial photography Know anyone how to do it or if it's possible with ecw format? Thank's.
Hi, I have a workspace that read a personal geodatabase (pgdb) and updates it. That is, it creates no new pgdb, but instead updates the existing one. How can I solve this in FME Server? The co-workers at my office will use it, but they have no access to the server. Datadownload service normally does it, but in this case it creates a new pgdb, and I don´t want that. I have read this article (http://fmepedia.safe.com/articles/How_To/Data-Download-Service-Writing-to-a-template-ESRI-File-Based-Geodatabase), but it does'nt help me since the pgdb comes in different names and shapes. Any ideas? Regards Hans
Afternoon All, I have a ESRI file GDB with domains set on a wide range of attributes. Somehow there are attribute values in FGDB that dont conform to the domain list. (possibly entered before the domains were registered). I want to "Validate" that the values in all attributes conform to the domain values. I know there is the "Validate Features" options in the FGDB writer/advanced tab but this terminates the workbench on the first records it finds that does not validate. I want a list of ones that dont "Validate" How do i construct a table or list of values, records that are not in the domain list. ( i have many attribute fields and many records and many tables). Thanks for your suggestions Steve
I have a reader which reads textfile from a specified directory. I don't want to have to specify the textfile each time I run the job. Can I simply set up a directory published parameter and use this for the reader to process any textfiles within that directory. If it can be done how do I do it. Thanks
Hello, I'm working on a solution using FME Server's datadownload service on which I'm trying to write out to a DWG with an uploaded template file (via the datadownload web gui). Currently it fails with the log error: Failed to copy template file '\\prototyp.dwg' as the destination file 'C:\\Windows\\TEMP\\FME_1360689826165_4428.dwg'. Error is 'The operation completed successfully. A fatal error has occurred. Check the logfile above for details which is funny because it says it completed successfully but obviously it didn't. The test case I'm running is just a DWG reader connected to a DWG writer with the writer's template parameter published. If I remove the published parameter and provide the template as a resource the workspace translates successfully. I've checked the permission on C:/Windows/Temp and even tried with permission to Everyone on full. The FME Server is running on Windows Server 2008 R2. // Jonas
This should be easy but I'm getting conflicting answers/stories. I want workbench to write shapefiles into oracle 11g in such away that arcmap can than access them (to then create an AGS REST serivce). Do I want an SDE write or an Oracle writer?
Hi, Do you know how to get the value of the nodata of a geotiff image? Thanks
I'm reading polygons from SDE and selecting them with the spatial filter transformer. I add and calculate a few attributes and then output to file geodatabase but I get an error message saying that non poly feature can't be written to poly feature class in file gdb. Why the error? Data is coming from SDE so geometry is fine, and I'm not altering it in my script. This always seem to occur with the same polygon. Any ideas or suggestions? thanks
Hi I'm looking to translate some building multipatch 3D shapefile data into CAD format. We are using ArcGIS 10.1 and FME 2012. Could anyone help please? Thank you.
I have a job which has been added to FME Server. I would like a user to log into FME Server and run the workspace but allow them to process a textfile on their local drive and output a shapefile to their local drive also. The workspace connects to Oracle Spatial to retrieve some data also. Is this possible? Thanks
Hi, I have build a model that read a .dgn file, add MsLink and then write the result in a new .dgn file. I have a problem with the cells. When i run the model, I receive this message : DESIGN WRITER: The cells read from the cell file V8.cel' are as follows: META RESURG TOUR MINE RAPIDE GOUFFR BATIME PONT BRULEU COTTER COINFE PYLONE HUMIDE FLECHE CHUTE SILO PHARE HYDROB MARINA ROCHE SKI TOURT CAMPIN NUMOV ETANGE RESERV MAIMOB ENLEV LEGMAJ SCAN20 MODIF SEGABS REPRE AJOU SCANB SEGNCO SEGTRO SEGIMP NOTE_B DESIGN WRITER: Error - An attempt was made to write a cell but could not find the value of 'igds_cell_name' on the feature
hi, anyone know how to make 3d pdf? I can't understand it just only saw it from the webinar videos I'm so pleased if anyone here can share me the manual. thanks, asn
Untill FME 2012 the PostGIS writer wrote to PostGIS tables without geometry column even though the Allowed Geometries field within the Feature Type Properties was set to other than 'postgis_none'. Since FME 2013 this is no longer implemented, the Allowed Geometries field will strictly have to be set to 'postgis_none' in order to write to geometry-less tables. Strictly speaking, the new behaviour is correct, of course. It however gives me a big headache changing all the dozends and hundreds of Feature Type Proberties in all my dozends of workbenches in order to make them running properly again...
I am aware of the 2g file size limitation for DBFs but the DBF on my shape file is only slightly more than 1g and I'm still getting the f"file limitation" error on the Shapefile Reader when it is reading the source file. Another shape file with a slightly larger dbf file runs fine. Am I missing something? Does any one know how the file size is calculated?
Many thanks for the answer to my previous questions. Another question: does FME have an equivalent of the ArcGIS "Eliminate" tool? (http://help.arcgis.com/en/arcgisdesktop/10.0/help/index.html#/Eliminate/00170000005p000000/) (Default) The ArcGIS Eliminate tool replaces the selected polygons with the neighbour with longest boundary. (Using optional "ex_where_clause"), the Eliminate tool replaces polygons with the neighbour with longest boundary that doe not have a specified type. The FME "SliverRemover" does the same as the (Default) Eliminate, but does not have this "ex_where_cause" option. Application: I want to eliminate small holes and replace them with the neighbour with longest boundary except it this neighbour is a road, then it should choose the second longest shared boundary. How should I do this withFME? Thanks for your reply.
Does Safe has plans to support Autodesk SDF in the future?
So.. someone in my team wrote this custom ADE (see all the way below). I also have an example CityGML of how my output should look like. It shouldn't be so hard now to write a proper CityGML, right? Well, I'm getting quite desperate here... An example: for each building it should add this XML code to the feature: <bldg:Building gml:id="building_39"> <pan:project name="Test Project"> <pan:scenario name="Scenario 1"> <pan:doubleAttribute name="TestAttribute1"> <gen:value>43.5</gen:value> </pan:doubleAttribute> <pan:intAttribute name="TestAttribute2"> <gen:value>5</gen:value> </pan:intAttribute> </pan:scenario> </pan:project> ... etc. (geometry stuff) So, a feature can take part in 1~n projects and each project can consist of 1~n scenarios (bold). Each scenario contains 0~n generic attributes (double, string, integer), as shown
Hi, I'm trying to convert mulitple ASCII grids to a single CSV file in the following format: X, Y, Z, Z, Z, Z....etc.... where the Z is rainfall data over time. I can capture the XYZ info, but I don't know how to write out multiple Z value attributes while keeping the XY as a constant into a single CSV file. Any ideas on how to solve this are welcome. Thanks Ricky (newbie!)
I am doing a simple convert from an AutoCAD 2011 dwg file to an ESRI 10.1 File Geodatabase. I have an FME 2013 Workspace with the input data (DWG) linked to the output dataset (fGdb). The Reader for CAD uses all defaults for Parameters and is generating a single merged feature type. The Writer uses the File Geodatabase API and is set to produce Dynamic Schema. Projections are set to source (Nad27UTM15N) The transformation completes without errors. I then open ArcCatalog 10.1 to view the created Geodatabase and see all features are there. Clicking on a feature to preview it is where the problems start. Any attempt to Identify the feature will come back with nothing found. Any attempt to zoom in causes the graphics to disappear. The features do not display in ArcMAp either. Teir Attribute table contains the Shape and ObjectID fields only. Can anyone point me in the right direction to resolve this problem?? [OS: details Win 7 x64, ArcGIS Desktop Advanced (ArcInfo) 10.1 build 3035
Hi, I want to create a .dwg with clickable hyperlinks from a .shp file, however I can't see an attribute I can expose on the .dwg writer that can take the hyperlink attribute from the shp file. Does anyone know is this is possible? Also, bit of a secondary question (that may make the first one invalid!) , but could I write this straight to an interactive PDF? (I know I can create it via (Acrobat / AutoCAD). I'm not very familair with FME's PDF capability. Thanks.
My workspace's goal is to import the contents ot two old Access databases into a new, differently structured Access database. The new database has four fields that have forward slashes in the field names. These are being interpreted as underscores by FME. When I run the workspace, I get an error indicating that my new database doesn't have the field `Esmt_ppty_lease Date' (the first field it runs across with an underscore I guess) -which of course it doesn't. What's the simplest solution here? I'd rather not have to rename the four fields in the new Access database as that has other implications.
Hi, Does anyone know what is the FME quivalent of the "Update" tool? Thanks. Pietro