Data

Hi all, I am new to FME. Which transformers should I use to solve the following problem ? [1] The input Excel file has 3 worksheets, each with 4 columns (1 primary, 3 secondary). [2] The output Excel file should have 1 worksheet for each secondary column, and the data should be labelled by input worksheet name. [3] What if there are a few hundred secondary columns in each worksheet in the input Excel file ? In other words, "transform feature types to attributes". I was trying to use AttributeManager but did not know how to get hold of the name of the feature type. Thank you. * Input Excel file : * Expected Excel file :

Hello! I have ESRI feature classes stored in oracle Geodatabase. It uses ST_Geometry. I do not have oracle spatial installed on oracle database. Can I still use FME oracle spatial object writer to write to such ESRI Feature class?

I'm transferring data from an ESRI Geodatabase to ERSI AGOL cloud. One of the attributes in my feature is a string field that contains html text. When I run the workbench I get the following error message: ArcGIS Online Feature Service Writer: Encountered an unexpected error. The error code from the server was '400' and the message was: ''. Details: 'Field DESC4 has invalid html content.' An exampe of the string that is being transferred is Here is a video with more information on this project: <a href="https://www.youtube.com/watch?v=Kkce_ySK5Cs#t=17" target="_blank">Ripple.</a> If I remove the two '=' in the href portion of the html. The data is successfully loaded into AGOL. However without those the link does not work. Anyone have ideas as to how get this data into AGOL?

Hi, I am querying a DB table for some records and filtering few of them to create an XML string then sending this to an web service through HTTPCaller.After successfully sent this XML,i would like to update the table back with status filed = 'Y' for all the records i have fetched initially. The records i am fetching has got ID field which i would like to use for matching purpose but how could i store this ID within the workspace initially after fetching from DB and reuse for my update at the end of my process? Any help would be much appreciated. Thanks, reachmj

Hi , I am trying to convert an access file to gml. I have an attribute in an access table that is of URL data type (with a value: www.test.com). I am mapping this attribute with the corresponding attribute of the writer that is of xml_buffer data type (the writer is defined based on an existing application schema). Then, in the produced GML, it appears like this: #www.test.com# Could you please let me know how I could avoid these # (hashtags)? Thanks you in advance, Valantis

Tried to copy feature classes from a Microsoft SQL database to a postgresql database using SDE Connection files. The workbenche does fine on FME Desktop 2017 but on the fme Server 2017.1 i get following error: "Could not open the Enterprise Geodatabase. The error number from ArcObjects is: '-2147155644'. The error message from ArcObjects is: {Cannot connect to database because the database client software failed to load. Be sure the database client software is installed and configured correctly.} "

Hello, I'm working with some IFC files for a project. As part of the project I need to change the GeoLocation of some of these files to better match the final model that I'm making. I'm doing the final model in Infraworks and the IFC are exports from Revit.

Hi, I'm trying to export my data to excel. My workbench was working fine and suddenly I can't even run it. I'm having the following error and I don't know what could be the issue. I restart my computer and I close all the excel files on my computer but the issue persists. XLSX Writer: Saving changes to dataset 'folder_name'XLSX Writer: Failed to save changes to the spreadsheet 'folder_name'. Check that you have write permission to the file, it has no password protection and is not opened by another application. Error message is 'Permission denied.' A fatal error has occurred. Check the logfile above for details ... Last line repeated 2 times ... Note that folder_name is the localisation path where I want to export the data. Thanks

Has something changed within the JP2 reader between FME2014 SP4, and FME2017? I'm using a simple workbench to convert from JP2 to Geotiff, which worked fine in 2014. I'm getting a message in 2017 that I do not get in 2014, "JPEG2000 reader: Mercator projection should not define both StdParallel1 and ScaleatNatOrigin. Using StdParallel1 and ignoring ScaleatNatOrigin." The resulting geotiff does not seem to retain the coordinate system.

we have configured our Active Directory with FME server and some active directory user already added to access and run FME workspace. But when I try to add new user then its asking to set password. we no need to set password. User can use there AD default password.

I am converting Sketchup file to City Gml v2.0 , I want to give seperarate layer names for Building, Lift , door,park and lift ? Can anyone suggest me a the way to follow?

Hi all, I seem not able to rotate text objects written to a png file. They are rotated, rotationfield has correct value when arriving at the writer. Even using gif_text_rotation or fme_rotation...nothing seems to make the png have the text rotated . Anyone know this issue and maybe what I'm missing here? (please answer in relation to png writer if possible...;))

Hi all, I need to create a .mdb access file from excel file which have informations about field name, width and type datal. Could you tell me how to make it from FME workbench? This is my excel data (input). I want to make 4 columns in .mdb with type, width data the same here.

Hello, In the Text_File writer I cannot select an attribute I've just created How can I solve that? Best, Harmen

Regarding this thread: https://knowledge.safe.com/questions/43262/png-text-rotation.html Could somebody from Safe reach out to Gio? I don't know if he actually filed a support case regarding this, but it seems the only answer he's willing to accept is that it doesn't work.

I am using an AutoDesk Revit Reader to transfer an RVZ file to a Feature Class in an ESRI GEoDatabase (ArcObjects). When using the 2DForcer to transform the 3D RVZ data to 2D data the translation fails and there error I get is 'Cannot write a non-area feature to an area feature class.' I am using a Geometry Filter which has the solid and area options checked, followed by a GeometryValidator with all options checked. and the output feature class type is set to polygon.

. but not getting desired results

To get an xml file automatically we are currently storing all attribute table of sql server DB into a enterprise GDB in sql server, which is creating a trouble that everytime it is taking the primary key field as OBJECTID and changing the name of the field. So we want now to have the attribute table as it is in a non-spatial database, and want to read it's table name, field names and datatype into an xml file. But I cannot read the field names and data type as a list thus I can use it inside our own schema. Can anyone please guide me.?

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 inaccessible.'. Details: '' I s

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 parameter

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 data However 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 output