Using readers and writers to extract and load data.
Recently active
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
Hi I have just received LiDAR data in .las format. I am using MapInfo but cannot directly open them in this program. I also have access to Engage 3D (but not Pro) Can someone please help me with advice as to how I go about converting them in FME workbench into a usable format for MapInfo. Essentially I would like to get contours, point data (x, y, z) as well as being able to create DEMs. Must warn you I don't use FME often - so please dumb down any advice. Thanks in advance. Keiryn McCartney GIS Technician - GTCC
Hello, I have converted mif to shp and someone quote that it's shape 3D. It's a pity to have z=0 for each point. I look the answers you still gave and try it but no satified results. So now i want the answer please. Why the setting i put are not effective?(2d forcer,2D in destination setting..) thanks
Hi, I use into ws FMEServerLogFileRetriever transformer that need to pass it the value of job id. I passe @Value(_job_id) but don't work!. Is there an issue on FMEServer? There is another idea to get job id value that i passe to my transfomer? thanks an advance. Farfar
I have a table in PostGIS with a timestamp(4) (with time zone) data type. I am trying to insert a value of: 2013-07-06 14:24:50.200 What i get is the following: 2013-07-06 14:24:50+04 The +04 is obviously the timezone, which is fine, however i loose my precision on the seconds. I have tried most everything and am stumped. I am currently on still stuck in FME2011. Thanks in advance for any insight!
I have a zip file that contains 2 excel files. The names of the files are dynamic (Name Current Date.xlsx), and there is one tab within each spreadsheet. For both spreadsheets, the tab has the same name. When I try to read the zip file, FME is pulling all the records from both spreadsheets, instead of just the first spreadsheet. Since the tabs are the same name, I can't see a place where I can specify which feature to read. Does anyone have advice on how to only bring in one file from a zip file where the file names within the zip change every day? Thanks!
Hi, I look for retrieving LogFileName and copy into my folder. example : When i launch a job, i get a log file in : serverjobsubmitter/FME_74061B13_1373896868934_15164.log. i'd like to move it into another folder like "C:/logs" for each traitment. Thanks an advance. farfar
Hi We have a GeoMedia Access Warehouse with about 170 tables in it. When we try to add a reader to this warehouse, we got an error-message: GeoMedia Reader: Reading from GeoMedia Access Warehouse version 5 or better Database error: '[Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1.' SQL is: ' SELECT "csguid","basestoragetype","geodeticdatum","ellipsoid","projalgorithm","zone","falsex","falsey","latoforigin","lonoforigin","hemisphere","latoftruescale","scalereductfact","standpar1","standpar2","stor2compmatrix1","stor2compmatrix6","stor2compmatrix13","stor2compmatrix14","stor2compmatrix15","azimuthangle" FROM "GCoordSystem"' Successfully closed GeoMedia Access Warehouse reader Adding readers to Warehouses with less tables