Using readers and writers to extract and load data.
Recently active
I have a Geotiff file where the colour (a real number) represents the elevation. I wish to generate contours form this data and can not see how to get the data into the contour generator in an appropriate way. What other transformers do I need and how do i use them?
I'm trying to write a dataset and featuretype fanout to ArcGIS Portal. The desired behaviour is:Each feature service is determined by Attribute Column X (dataset fanout) A layer in each feature service is determined by Attribute Column Y (feature type fanout) I have performed a few fanouts before on different writers and they seem to work, but I can't get Portal Feature Services to successfully produce a fanout. My workflow is similar to the fanout template here: https://knowledge.safe.com/articles/565/fanout-1.html (see Combination fanouts)A feature type fanout is successful, but a dataset fanout using this workflow generates the following error: https:\\portal.bluedot.global\\arcgis\\AttributeValue1' does not appear to be a valid domain I have also tried specifying the feature service parameters:firstname.lastname/@Value(attribute_values) with the following error:The error code from the server was '400' and the message was: 'Item does not exist or is inacces
Hi all,Workspace A is uploaded to FME Server as a Data Download and Job Submitter Service. Several files are written in the workspace (excel, sdf, json, txt) and -logically- they appear in the output .zip package of the data download service. Problem: A FileCopy writer is used to copy a .dwg file to the output folder. Because the files for the .zip package of the download service are stored an a temporary folder on FME Server, it is not yet possible to have to .dwg also in the download package. The Job Submitter does its job and all my files are written correctly (including the .dwg file). The data download .zip-package does not have this .dwg file and that is my problem. I just need the URL or the location of where the files for the download package are temporarily stored on FME Server, so I could use this URL as a parameter for the output location in the FileCopy Writer.The documentation online told me this should be the 'FME_SERVER_DEST_DIR' parameter? But when I use this
Folks, I know I am missing something simple here. What I am trying to do is convert polygons from a shapefile to a dwg while conserving the attribution. The shapefiles are polygons and may or may not have multiparts and donut geometries. As such it seems a mpolygon is the best fit as an AutoCAD datatype.Something similar has been asked Here: Shape to AutoCAD with attributes by @lmerino but no answer I can get to work.I have the cad writer set to extend entity dataHowever when I look at the output in CAD the polygons are coming through as blocks. @Mark2AtSafe suggested using a Deaggregator transformer but I am not sure how this will help. I have done as @erik_jan suggested and added autocad_entity set to autocad_mpolygon via a AttributeManager and everything in the target drawing will then end up as a mpolygon as desired. However there is no attribution.Sample data: Edit: Seems that using a different writer such as Autodesk AutoCAD Map 3D Object Data ends up with the desired outpu
If I move my database to a windows to a linux machine is there any impact on FME users of this database other than updating database connections
Prologue: this suggestion puzzled me, but it's right: in 2016.0 (what I'm using) you can't point a Directory and File Reader at a zip file. You can with a FeatureReader though. Now read on!I'm retrieving the file properties out of a zip file with a FeatureReader with format 'Directory and File Pathnames' and 'retrieve file properties:' set to Yes. Workspace attached, .The file name and file size comes back correct, but all the dates, path_accessed_date, path_created_date and path_modified_date, get set to now. I think FME should be returning the dates the files have inside the zip.P.S. It looks like FME is actually unzipping the files to get at the info:path_windows (string) = d:\\temp\\ea_admin_boundaries.zip_1481293489605_5384\\AREAPF_EA_NE_010K_V1_3.shx...which explains the dates. Still not the right output to give, though, IMNSHO.
Hello Everybody, I am facing trouble to use a writer file (xml) as a Reader file for the second step. I am writing ESRI format metadata in a text_line and saved as a .xml extension. At the second step i want to use this xml file as a input file. Nothing is working , please see the attached imge. I have tried several ways like user parameter, feature to writer and so on,
Hi, I am trying to produce a GML 3.2.1 file with elements based on an xsd. Any suggestions ? Thanks in advance,Valantis
I'm Transforming georeferenced EsriShape to IFC4 the problem is that when I convert the buildings are in millimeters and when I use Scale to switch to meters the location is scale too so the position (georeference) change but the buildings in 3D are scale to Meter. I can not find how to use FME to set the corresponding parameters in ifcSIUnit and IfcCoordinateReferenceSystem have some one use FME and IFC4 ?
p { margin-bottom: 0.25cm; line-height: 120%; }I would like to get the value of a specific attribute of an IFC data (data from BIM software). Whereas I can see this attribute in the "feature information" window in the inspector, I cannot see it in the user attribute tab or in the format attribute tab of the "feature type" window in the workbench. Thanks for any help.
We are having problems with certain IFC Parameter data not being available. The IFC Exporter has been installed and all settings correct, but some shared parameters in Revit are not coming through into the FME Data Inspector. Is anyone having the same problem?
Is it possible to use FME to convert a SQL MapInfo database into an ESRI SQL database? What are the steps needed to complete this task?
I'm trying to convert an ASTM e57 file to LAS, and retain the e57 station IDs as the LAS Point Source ID attribute. Is there a way to do this? Thanks!
I am having trouble converting the dwg/CAD file to a file geodatabase. I convert it to a shapefile; there is no problem. Any ideas whats going on?This file a has plan layouts of a building. It shows floor plans for 3 different floors.See attached file
Hi,if you try to write aggregates in AutoCAD you'll get block, which is kind of unwieldly, especially if you need to modify geometries in AutoCAD.As it looks like groups can't be written (only read) using FME.I'd like to ask you, what are your experiences with this. Are there some other workarounds...Thanks in advance,Želimir
I have a .OSM file of Australia.I can extract the roads by choosing the Feature Type "highway"But the result is missing the names of the roads.How do I get the names of the roads?I do get the type of road as an attribute, for example; "residential", "secondary", "tertiary"But I want the name of the road as well.
Is it possible to write Autocad groups to dwg.I have tried the available format_attributes.Setting these on objects causes them to not be written, other objects do.Any tips or hints?(NOT talking about reading groups )
Hi I would like to output only the rejected records on each transformer output to a CSV file, and also write total count of invalid records.Any suggestion what's the best way to achieve this?
I am trying to output CSV files to a specific directory structure like so:directory1/ bike/ ride_log.csv bike_features.csvdirectory2/ bike/ customers.csv When I run the Data Download job the resulting file structure in the output zip file looks like this:directory1/ bike/ ride_log.csv bike_features.csvdirectory2/ 2/ customers.csvThe CSV features ride_log and bike_features belong to the same CSV writer: bike_1, and the customers feature belongs to a CSV writer: bike_2.The bike_1 and bike_2 writers have Dataset Fanout applied based on an attribute named 'directory' which gets set to 'bike' in the transformation process of all three features. There is also a prefix directory set for bike_1 as 'directory1', and a prefix directory for bike_2 as 'directory2'. Both features have their output directory linked to $FME_SERVER_DEST_DIR, which as an FME server parameter is set to \. So how can I get the same folder name in two different subdirectories when using fanout
Hello all,I have an incredibly weird issue....Running the workspace from FME Desktop, and running manually via Server there is no issues at all. When the workspace runs via a schedule nightly it is writing files into different folders...FME Desktop and Manual Server run - \\\\server\\folder\\folder\\folder 1On server via a schedule - \\\\server\\folder\\folder\\folder 2 I have deleted the schedule and added a new one but the same issue occurs, and it is only for this workspace.Any ideas..?
Hello, my goal is to delete a previous' week file from google drive and upload the file of the current week on a weekly basis. The file name changes weekly. This week I would like to delete report_201729.xls and upload report_201730.xls, next week it would be report_201730.xls to delete and report_201731.xls to upload. The upload is working fine with the Google Drive Connector transformer of FME 2017, but I have troubles to delete the previous' week file. The transformer doesn't have a file name option, only an Object-ID, but this ID changes weekly. How can I solve this problem? Thanks!
Good afternoonOnce again i find myself trying to do something relatively simple in FME and failing miserably. Frustrating doesn't come into it.I have an excel spreadsheet with multiple worksheets, each one populated with planning data.I would like to end up with one spreadsheet for each of the individual worksheets, so i can then use them for some other work with some spatial tables.When i add the excel writer, i'm given the option of all the worksheets, which i select, then attach them to the corresponding reader. But the resulting output spreadsheet contains all the worksheets in one worksheet.Have tried the fanout option to no avail.Have tried adding the source spreadsheet as a a workspace resource, with all the worksheets selected, again, to no availI'm sure this is a simple thing to do in FME, but it's currently beyond me. Any advice would be gratefully appreciatedregardsSimon Hume