Using readers and writers to extract and load data.
Recently active
Hi All, I have a workbench which calls several Feature Classes from a Feature Dataset on an SDE. Each month as property is processed, a new Feature Dataset is created on the SDE containing Feature Classes of the same names. I have tried to set a parameter which prompts the user for the Feature Dataset location each time the workbench is run (Parameter) but all to no avail. The closest I can seem to get is to point it to the SDE. Has anyone encountered this problem before? Know of a way around? I have mainly been trying with a "Directory (Existing)" parameter, however in desperation have even tried a "Text" parameter! Any assistance would be appreciated.
I try to convert an Oracle Spatial table to MapInfo .TAB. There is an MI_STYLE column. The spatial table looks all right in a MapInfo linked table. In the workbench I ticked ' Apply MapInfo Symbology' and set the Style Column to MI_STYLE and Index Column to MI_PRINX (as they are in the database) n the Oracle Spatial Object Parameters panel. However I get this eror message for all the objects and the style of all the objects in the output MapInfo table are the same (default): ORACLE Reader: Failed to parse MapInfo Symbology string. String was `Pen( 2, 2, 32768 ) ' All the objects are lines and polylines. Does anyone have an idea why FME cannot parse the symbols?
Hi all, new to FME and would like to know: I have an excel sheet with a column of (Attribute id's) and a column of (lengths m). I also have a tab file that relates to the excel sheet and has the same Attribute id's. Can I change the spatial length of the polylines in the tab file to be the same as the lengths in the excel sheet??
Hi I have an issue with using the Dynamic writer in FME Server 2013. It produces the zip file but its empty and the location is has written to on disc is also empty. When running the workbench it works but not when uploaded to server 2013. I had no issue with the dynamic writer on 2012, is there a setting that i have missed out? Even the standard ''easytranslator'' does not produce and files so something to do wth the writer rather then the individual workbench Regards
Hello! I'm writing data to an Oracle Spatial Database. Is it possible to write the data, that isn't written to the database to a log file (similar to the badfile with the sql loader). Regards Isabell
Bonjour, Je ne parviens pas à faire des sorties excel, le format .csv fonctionne par contre. J'ai le message suivant : ADO Provider not installed or not compatible with FME architecture. Try installing Microsoft Access Database Engine (x64); follow this link for more information: http://www.microsoft.com/download/en/details.aspx?id=13255 Plugin 'XLS_ADO' was loaded, but a writer could not be created. Error was #1: A fatal error has occurred. Check the logfile above for details J'ai installé le plugin se trouvant sur le lien donné au dessus mais ça ne fonctionne toujours pas. cordialement, jy
I'm using FME 2013 SP2 to translate GeoMedia parcel polygons into an ESRI File Geodatabase. Many of my parcel polygons contain arc segments (curves) in their geometry. When I write these polygons into my File Geodatabase, they are being stroked into numerous short line segments. I don't have any ArcStroker transformers in my workspace, and the "Stroking Tolerance" setting in the Advanced Workspace Parameters is set to 0. I'm using the GEODATABASE_FILE writer (ESRI Geodatabase, File Geodatabase ArcObjects) to write to my File Geodatabase. I would switch to the FILEGDB writer (ESRI Geodatabase, File Geodatabase API) but then I can't specify an XML template file for building the geodatabase. Is there some other setting I need to modify to get FME to stop stroking the arcs?
Dear All , I am getting an errror when I try to fanout the output to CAD file , below is the error message Layer x is not defined . Thanks ,
When converting OSTopo in Tab format into DXF or DWG for autocad I am having aweful problems with the final product. When I open the file in the Universal Translator it looks apsolulty fine. However when my colleagues open it in AUTOCad certain areas are for better word, filled in, solid. When investigating this I have come to the conclusion that the areas that are good are polylines but the other areas are Hatch. In QGIS the attribute table shows them as having a sub class of AcDbEntity: AcDbHatch and Text as SOLID. The good areas show the subclass as AcDbEntity:AcDbPolyline and no Text. This is not usful and causing all sorts of problems. I can not seem to reslove the issue, does any one have any ideas?
I really want to read and write the entities in the two kind of space including model and paper in CAD .However, in FME, I only can read those entity in paper space , it is badly dificult to write these entity to the paper space of dwg file. What I want is that some suggestions about how to creating paper space or transform the feaures from model space to paper space. It's no better that give me the FME model of solve it. Thank you very much!
Hello, I have a point.shp with items of X_coord and Y_coord, which is the centroid location. Eventually will have some 10,000's of images in folders and subfolders. I can do via QGIS, GDAL, excel, and DOS, but i'd like to see if FME has more streamlined process. Trying to rename Images and Image world files recursively and with subfolders. for example; existing file(s): 0805_IDA_STR233_001.ecw \\ .eww XY_concat: 1549962.5_16362527.5 Folder location: S:\\GO_GO_02\\CAD\\GIS\\GIS3\\Reports\\Ortho\\0805\\0805_IDA_STR233 New file(s) rename: 1549962.5_16362527.5_0805_001 I have seen some mentions of python scripts inside FME to perform the renaming, and this may work if there are no transformers available, but then might as well use the DOS RENAME feature. Thoughts, RL
Hello FME Universe, I have created a project that consists of 7 different FME workspaces which have been published to FME server and are meant to be run as a chain via notifications (When WS1 is successful, run WS2, When WS2 is sucessfull, etc.). All of these workspaces have a seperate output DWG file that gets stored in a temporary folder where a final workspace combines all *.dwg files into one final output, places it on a shared drive and then through a python shutdown script, sends an email to me and deletes the output folder. Now here is the problem, all of this works perfectly fine for me. But in order to make it universal so that my office can use it, I need to change certain parameters to have access to the FME system parameter $(FME_SECURITY_USER) (such as the temporary output folder so that it will read something like C:\\Temp\\$(FME_SECURITY_USER)\\*.dwg). Now this works fine for the first workspace (the one the external user initiates) and creates the folder C:\\Temp\\Dav
Hi all, I have a citygml file. I read it in FME and what I need to do is to create point on the wall surface, then draw the line between selected points of the buildings and finally, intersect those lines with buildings in between to calculate the visibility for each building. But I have a crucial problem. I create the point using "pointcloudcombiner" transformer and what I have as the results are the points that are not located on the wall so for intersecting process I have intersection for all lines which are not true in reality. Is there anyone who knows what is the problem of poincloudcombiner tranformer which creates points with a tiny distance to the wall surface?! That would be super great if I there is a solution for it. I appreciate you help in advance. Best regards, Many
Hi, My reader is a shapefile which is transformed to ten kml files. Each writer is composed by 2 files, one folder (included all hierarchical organisation folder: event type,country,year, month, event) and one placemark (included coordinate, styler...). So I would like to merge all these kml files (so 10 times : one folder and one placemark) in a single one in keeping the structure I have (event type,country,year, month, event). Then I would like to handle it in GoogleEarth but it would be too heavy. Is there a way to resolve this issue? Thanks in advance for your help. Regards Arnaud
Hi, I have a project which transforms one or more DGN v8 files from one coordinate system to another. The input files are specified by a user parameter and each input file results in one output file through the use of fanout where the input file name is used as the fanout attribute. I use the value of the user parameter that specifies the input files to set the value of the V8 Seed File parameter. (I want the same header information after the transformation as before the transformation.) However, I have not found a way where I can choose a different seed file per output file or change the seed file during the processing of the input files. Instead, the same input file is used as the seed file for all output files. Does anyone know of a way to accomplish this?
Hello, I am trying to run a workbench with both the reader and the writer in the AUTOCAD_OD file format. The problem is that when I set the Template File and run the workspace I get the following message: Database conflict detected using the template file. See the documentation to avoid conflicts. Skipping the use of the template file. So doing a little research I found this link: http://docs.safe.com/fme/2009/html/ReadersWriters/autocad_od_-_templatefile.htm Where it says that: Note: The template file will be skipped for AUTOCAD_OD in certain cases to avoid name conflicts. If the reader format is AUTOCAD_OD, and the AUTOCAD_OD writer is the first writer in a multiple writer translation, the template file will be skipped. The problem is I need to use an AUTOCAD_OD for the reader and the writer, so changing the file format is not an option. Does anyone know any way to get around this problem? Thanks, Gabriel
I am trying to figure out a way to plot a series of points based off xy values in a table. The initial xy values is a lat long and the each of the other points is a set of xy offsets. So, I may have record 1 with.. -107.55 36.55 and the offset is .01 .01. So, the new xy for 1 would be +.01. Then I need it to goto the next record and use the new offset xy. Keeping in mind that the 2nd record has no spatial and needs to adopt the new xy from the last record. In the end the table will create a line based off the 1st starting point. Any thoughts on this? I've tried using the offsetter but without the previous coordinate attached to the offset it doesnt work. Any thoughts?
I am trying to read in an excel document and the frist row contains my column names. After reading in the document all I see in FME is Column 1, Column 2 and so on. I am not sure what I am doing wrong, other than when I use the Microsoft Excel ADO (deprecated) format the headers appear in FME, and when I use the newer excel format the headers do not appear in FME. I would appreciate any healp with this.
is FME can be used to change name of file and folder and cut files in another? If you prefer I don't want that FME read, i want to use it basically because i have 100 folders to tidy.
I don't kown how to convert the dimension geometry entity,and I need a model of FME to solve the problem. Another, I also need convert the GDB feature like dimensions to CAD formate. thank you.
I have a workbench that works perfect in FME 2012 SP4 but when I run the same one in FME 2013 SP1 (and 2014 beta), the number of features that are created are different. I have narrowed it down to the PointConnector and the way it is handling lists. I set the connection break to the parent_id field (which is the same for all of them) and set the list name to origSeq. Now in 2012, the point are connected and the original attributes that were present on the points are stored in the list as origSeq{0}. I then add a ListIndexer and set to 0 then remove the list and now the lines have the original attributes from the points. In 2013, the last point to get processed has its original attribute shifted to the index of 1. Anyone else seeing wierd behavior with the point connector? I wanted to send this to the community before I send to Safe support. Thanks, Sean
Hi , I come across PSV (pipe separated values file) file as a data source. It is quite similar to to csv but I couldn't add as an input into my workspace. Is there any way to add to this file into my workspace? Cheers, Engin
Hi, My workbench is able to read xml files in FME desktop. While publishing, i upload needed files along with it and it works fine. But each time to change fil list, i have to download workbench and modify reader source file list. First please tell me how to read xml files using publish parameters. Second, How can i make this dynamic?like placing xml files in a directory and pointing my workbench to read all xml files inside that. Thanks. Subrat
attribute value of a field in a specific order of my attribute I have an issue as I would like to sort my output kml file in a hierarchical way. I have for the moment sort by country (alphabetic, 1order), by year(numeric,2 order) and I would like to sort now by month but not in an alphabetical way, but from jan, feb, mar...... That means in a monthly order. I have got the value in a field of my shapefile, but I do not know how to display it correctly by month. Does anybody know the way to do it ? Thanks in advance! Arnaud
My problem is that I have many files to convert with differents attributs and a static shema seems to be not avalaible (lost of attributs). It's very important to me to solve this problem and i work to solve it but with no success.I think it's a hard case. To understand my problem here is the link of my whole MIF data to convert : https://docs.google.com/file/d/0B90n7rx5ph0ZaXZXZ21RNUh1WkE/edit?usp=sharing Now how to obtain : R120_1-1_SHP_LAMB93_FR-ED121 with all the SHP 2D in the same folder than source.( I know how to do that but only in dynamic shema) thank you