＃！ ＃！ ＃！ ＃！ ＃！ ＃！ ＃！ ＃！ ＃！ ＃！ ＃！ ＃！ ＃！ ＃！ ＃！ ＃！ ＃！ ＃！ ＃！ ＃！ ＃！ ＃！ ＃！ ＃！ ＃！ ＃！ ＃！ ＃！ ＃！ ＃！ ＃！ ＃！ ＃！ ＃！ ＃！ ＃！ ＃！ ＃！ ＃！ ＃！ ＃！ ＃！ ＃！ ＃！ ＃！ ＃！ ＃！ ＃！ ＃！ ＃！ ＃！ ＃！ ＃！ ＃！ ＃！ ＃！ ＃！ ＃！ ＃！ ＃！ ＃！ ＃！ ＃！ ＃！ ＃！ ＃！ ＃！ ＃！ ＃！ ＃！ ＃！ ＃！ ＃！ ＃！ ＃！ ＃！ ＃！ ＃！ ＃！ ＃！ ＃！ ＃！ ＃！ ＃！ ＃！ ＃！ ＃！ ＃！ ＃！ ＃！ ＃！ ＃！ ＃！ ＃！ ＃！ ＃！ ＃！ ＃！ ＃！ ＃！ ＃！ ＃！ ＃！ ＃！ ＃！ ＃！ ＃！ ＃！ ＃！ ＃！ ＃！ ＃！ ＃！ ＃！ ＃！ ＃！ ＃！ ＃！ ＃！ ＃！ ＃！ ＃！ ＃！ ＃！ ＃！ ＃！ ＃！ ＃！ ＃！ ＃！ ＃！ ＃！ ＃！ ＃！ ＃！ ＃！ ＃！ ＃！ ＃！ ＃！ ＃！ ＃！ ＃！ ＃！ ＃！ ＃！ ＃！ ＃！ ＃！ ＃！ ＃！ ＃！ ＃！ ＃！ ＃！ ＃！ ＃！ ＃！ ＃！ ＃！ ＃！ ＃！ ＃！ ＃！ ＃！ ＃！ ＃！ ＃！ ＃！ ＃！ ＃！ ＃！ ＃！ ＃！ ＃！ ＃！ ＃！ ＃！ ＃！ ＃！ ＃！ ＃！ ＃！ ＃！ ＃！ ＃！ ＃！ ＃！ ＃！ ＃！ ＃！ ＃！ ＃！ ＃！ ＃！ ＃！ ＃！ ＃！ ＃！ ＃！ ＃！ ＃！ ＃！ ＃！ ＃！ ＃！ ＃！ ＃！ ＃！ ＃！ ＃！ ＃！ ＃！ ＃！ ＃！ ＃！ ＃！ ＃！ ＃！ ＃！ ＃！ ＃！ ＃！ ＃！ ＃！ ＃！ ＃！ ＃！ ＃！ ＃！ ＃！ FME_PYTHON_VERSION 27 GUI忽略SourceDataset_REVIT_1，REVIT_IN_USE_SEARCH_ENVELOPE_REVIT_1，REVIT_IN_SEARCH_ENVELOPE_MINX_REVIT_1，REVIT_IN_SEARCH_ENVELOPE_MINY_REVIT_1，REVIT_IN_SEARCH_ENVELOPE_MAXX_REVIT_1，REVIT_IN_SEARCH_ENVELOPE_MAXY_REVIT_1，REVIT_IN_SEARCH_ENVELOPE_COORDINATE_SYSTEM_REVIT_1，REVIT_IN_CLIP_TO_ENVELOPE_REVIT_1，READERLIST_REVIT_1，DestDataset_XLSXW2_1，XLSXW2_OUT_OVERWRITE_FILE_XLSXW2_1，XLSXW2_OUT_TEMPLATEFILE_XLSXW2_1，TEMPLATE_SHEET_XLSXW2_1 DEFAULT_MACRO SourceDataset_REVIT $（FME_MF_DIR_USERTYPED）DCR_LOD_300 \建筑\ DC_Riverside_Bldg-LOD_300.ifc GUI的多文件SourceDataset_REVIT Revit_Export_Files（*.rvz）| * .rvz | All_files（*。*）| *。*资料来源的Revit导出文件（S）：。DEFAULT_MACRO DestDataset_XLSXW2 $（FME_MF_DIR_USERTYPED）数据\ Updates.xls GUI FILENAME DestDataset_XLSXW2 Excel_Files（* XLSX; * XLSM;。* .xls的）| *的.xlsx; * XLSM; * XLS | All_files（*）| *目的地Microsoft Excel文件：有[如果{{$（SourceDataset_REVIT）} == {}} {{puts_real参数 'SourceDataset_REVIT' must be given a value.};出口1;};] INCLUDE [如果{{$（DestDataset_XLSXW2）} {==}} {puts_real {参数 'DestDataset_XLSXW2' 必须被给出的值}。出口1;};]＃！START_HEADER＃！START_WB_HEADER READER_TYPE MULTI_READER MULTI_READER_TYPE {0} REVIT MULTI_READER_KEYWORD {0} REVIT_1 MULTI_READER_GEN_DIRECTIVES {0} SEARCH_ENVELOPE_COORDINATE_SYSTEM ,, EXPOSE_ATTRS_GROUP ,, SEARCH_ENVELOPE_MINY，0，SEARCH_ENVELOPE_MAXY，0，USE_SEARCH_ENVELOPE，NO，CLIP_TO_ENVELOPE，NO，_MERGE_SCHEMAS，YES，UPDATE_FEATURE_TYPES，是的，SEARCH_ENVELOPE_MAXX，0，READERLIST，大厦 空间，SEARCH_ENVELOPE_MINX，0，REVIT_EXPOSE_FORMAT_ATTRS，WRITER_TYPE MULTI_WRITER MULTI_WRITER_DATASET_ORDER BY_ID MULTI_WRITER_FIRST_WRITER_ID 0 MULTI_WRITER_TYPE {0} XLSXW2 MULTI_WRITER_KEYWORD {0} XLSXW2_1＃！END_WB_HEADER＃！START_WB_HEADER MACRO WB_KEYWORD “REVIT_1” ＃！END_WB_HEADER＃！START_SOURCE_HEADER REVIT REVIT_1＃！END_SOURCE_HEADER＃！START_WB_HEADER DEFAULT_MACRO SourceDataset有[如果{{$（SourceDataset）}！= “”} {\ {放DEFAULT_MACRO SourceDataset_REVIT_1 $（SourceDataset）} \}]＃！END_WB_HEADER＃！START_SOURCE_HEADER REVIT REVIT_1 DEFAULT_MACRO SourceDataset_REVIT_1 $（SourceDataset_REVIT）GUI的多文件SourceDataset_REVIT_1 Revit_Export_Files（* RVZ）| * .rvz | All_files（*。*）| *资料来源的Revit导出文件（S）：REVIT_1_SPACES_V003_DATASET “$（SourceDataset_REVIT_1）” REVIT_1_SPACES_V003_SourceDataset_Revit“$（SourceDataset_REVIT_1）”＃============================================================================ # The following GUI line prompts for files to be used as the # source of the RVZ files.＃从生成此映射文件的数据集是：GUI的多文件SourceDataset_REVIT_1 RVZ_File | * .rvz | All_files | * Revit中导出文件（S）（* RVZ）：DEFAULT_MACRO REVIT_IN_EXPOSE_ATTRS_GROUP_REVIT_1 REVIT_1_EXPOSE_ATTRS_GROUP “$（REVIT_IN_EXPOSE_ATTRS_GROUP_REVIT_1）” ＃包含在源文件 setting section to add external search envelope processing # Zero as a default means we don't do any search -- this makes workbench happier DEFAULT_MACRO REVIT_IN_USE_SEARCH_ENVELOPE_REVIT_1 NO REVIT_1_USE_SEARCH_ENVELOPE "$(REVIT_IN_USE_SEARCH_ENVELOPE_REVIT_1)" GUI ACTIVEDISCLOSUREGROUP REVIT_IN_USE_SEARCH_ENVELOPE_REVIT_1 REVIT_IN_SEARCH_ENVELOPE_MINX_REVIT_1%REVIT_IN_SEARCH_ENVELOPE_MINY_REVIT_1%REVIT_IN_SEARCH_ENVELOPE_MAXX_REVIT_1%REVIT_IN_SEARCH_ENVELOPE_MAXY_REVIT_1%REVIT_IN_SEARCH_ENVELOPE_COORDINATE_SYSTEM_REVIT_1%REVIT_IN_CLIP_TO_ENVELOPE_REVIT_1%REVIT_IN_SEARCH_METHOD%REVIT_IN_SEARCH_METHOD_FILTER%REVIT_IN_SEARCH_ORDER%REVIT_IN_SEARCH_FEATURE%REVIT_IN_DUMMY_SEARCH_ENVELOPE_PARAMETER Use Search Envelope # =========================================================================== GUI LOOKUP REVIT_IN_SEARCH_ENVELOPE_MINX_REVIT_1 ，0 DEFAULT_MACRO REVIT_IN_SEARCH_ENVELOPE_MINX_REVIT_1 0 REVIT_1_SEARCH_ENVELOPE “$（REVIT_IN_SEARCH_ENVELOPE_MINX_REVIT_1）” GUI OPTIONAL FLOAT REVIT_IN_SEARCH_ENVELOPE_MINX_REVIT_1最小X：＃=========================================================================== GUI LOOKUP REVIT_IN_SEARCH_ENVELOPE_MINY_REVIT_1 0 REVIT_1_SEARCH_ENVELOPE "$(revit_in_search_envelope miny_revit_1)" GUI OPTIONAL FLOAT REVIT_IN_SEARCH_ENVELOPE_MINY_REVIT_1 Minimum Y: # =========================================================================== GUI LOOKUP REVIT_IN_SEARCH_ENVELOPE_MAXX_REVIT_1 0 REVIT_1_SEARCH_ENVELOPE "$(revit_in_search_envelope maxx_revit_1)" GUI OPTIONAL FLOAT REVIT_IN_SEARCH_ENVELOPE_MAXX_REVIT_1 Maximum X: # =========================================================================== GUI LOOKUP REVIT_IN_SEARCH_ENVELOPE_MAXY_REVIT_1 0 REVIT_1_SEARCH_ENVELOPE "$(revit_in_search_envelope maxy_revit_1)" GUI OPTIONAL FLOAT REVIT_IN_SEARCH_ENVELOPE_MAXY_REVIT_1 Maximum Y: # =========================================================================== GUI LOOKUP REVIT_IN_SEARCH_ENVELOPE_COORDINATE_SYSTEM_REVIT_1 REVIT_1_SEARCH_ENVELOPE "$(REVIT_IN_SEARCH_ENVELOPE_COORDINATE_SYSTEM_REVIT_1)" GUI OPTIONAL COORDSYS REVIT_IN_SEARCH_ENVELOPE_COORDINATE_SYSTEM_REVIT_1 Search Envelope Coordinate System: # =========================================================================== # BUG18999: We now have a soft clip to fall back on like native spatial index # thus we are reintroducing the clip to envelop as an option for users.根据现有的数据库读取器，我们正在模拟GUI查找revit_in_clip_to_envelope ope_revit_1 REVIT_1_CLIP_TO_ENVELOPE "$(revit_in_clip_to_envelope revit_1)" GUI OPTIONAL CHECKBOX REVIT_IN_CLIP_TO_ENVELOPE_REVIT_1 YES%NO Clip to Search Envelope # ============================================================================ DEFAULT_MACRO REVIT_IN_ATTRIBUTE_READING_REVIT_1 ALL REVIT_1_ATTRIBUTE_READING "$(REVIT_IN_ATTRIBUTE_READING_REVIT_1)" # ============================================================================ REVIT_1_GENERATE_FME_BUILD_NUM 18567 # Add a new text field for the navigation tree in WB.更多的细节在BUG51426中。Revit Data View: REVIT_1_READERLIST "$(READERLIST_REVIT_1)"REVIT_1_DATASET " $ (SourceDataset_REVIT_1) "# !END_SOURCE_HEADER＃！宏WB_KEYWORD“XLSXW2_1”#!END_WB_HEADER＃！START_DEST_HEADER XLSXW2 XLSXW2_1 # = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = #首先获得数据库的数据集。对于Excel，它是文件名。现在，我们将使用他们在生成这个映射文件时所拥有的一切，而不是reprompt #!END_DEST_HEADER # !START_WB_HEADER DEFAULT_MACRO DestDataset包含[if {"$(DestDataset)"] != ""} { \ puts {DEFAULT_MACRO DestDataset_XLSXW2_1 $(DestDataset)} \ } ] #!END_WB_HEADER＃！START_DEST_HEADER XLSXW2 XLSXW2_1 DEFAULT_MACRO DestDataset_XLSXW2_1 $（DestDataset_XLSXW2）GUI FILENAME DestDataset_XLSXW2_1 Excel_Files（* XLSX; * XLSM; * XLS。）| *的.xlsx; * XLSM; * XLS | All_files（*）| *目的地Microsoft Excel文件。： # ============================================================================ # Whether or not to overwrite the file DEFAULT_MACRO XLSXW2_OUT_OVERWRITE_FILE_XLSXW2_1 Yes XLSXW2_1_OVERWRITE_FILE "$(XLSXW2_OUT_OVERWRITE_FILE_XLSXW2_1)" GUI CHOICE XLSXW2_OUT_OVERWRITE_FILE_XLSXW2_1 Yes%No Overwrite Existing File: # Template file option DEFAULT_MACRO XLSXW2_OUT_TEMPLATEFILE_XLSXW2_1 XLSXW2_1_TEMPLATEFILE "$(XLSXW2_OUT_TEMPLATEFILE_XLSXW2_1)" GUI OPTIONAL FILENAME_MUSTEXIST XLSXW2_OUT_TEMPLATEFILE_XLSXW2_1 Excel_Files(*.xlsx;*.xlsm;*.xls)|*.xlsx;*.xlsm;*.xls|Excel_Workbook_2007(*.xlsx)|*.xlsx|Excel_Macro_Workbook(*.xlsm)|*.xlsm|Excel_Workbook_Pre_2007(*.xls)|*.xls|All_files(*)|* Template File: # ============================================================================ # Parameters whose values will be percolated to the feature types, but will not # remain as writer level settings # Drop feature type first DEFAULT_MACRO XLSXW2_OUT_DROP_TABLE_XLSXW2_1 No XLSXW2_1_DROP_TABLE "$(XLSXW2_OUT_DROP_TABLE_XLSXW2_1)" # Truncate feature type first (removeallcelldata,retainformatting/headers,etc.) DEFAULT_MACRO XLSXW2_OUT_TRUNCATE_TABLE_XLSXW2_1 No XLSXW2_1_TRUNCATE_TABLE "$(XLSXW2_OUT_TRUNCATE_TABLE_XLSXW2_1)" # Whether to write out the field names (orjustthedata) DEFAULT_MACRO XLSXW2_OUT_FIELD_NAMES_OUT_XLSXW2_1 Yes XLSXW2_1_FIELD_NAMES_OUT "$(XLSXW2_OUT_FIELD_NAMES_OUT_XLSXW2_1)" # Default writer mode DEFAULT_MACRO XLSXW2_OUT_WRITER_MODE_XLSXW2_1 Insert XLSXW2_1_WRITER_MODE "$(XLSXW2_OUT_WRITER_MODE_XLSXW2_1)" #Default raster writing type DEFAULT_MACRO XLSXW2_OUT_RASTER_FORMAT_XLSXW2_1 PNG XLSXW2_1_RASTER_FORMAT "$(XLSXW2_OUT_RASTER_FORMAT_XLSXW2_1)" #Check whether to honor the output header flag when existing sheets or templates are used.DEFAULT_MACRO XLSXW2_OUT_HONOR_HEADER_FLAG_XLSXW2_1 YES XLSXW2_1_HONOR_HEADER_FLAG “$（XLSXW2_OUT_HONOR_HEADER_FLAG_XLSXW2_1）” ＃============================================================================ # Opt in for destination dataset type vs format type validation DEFAULT_MACRO XLSXW2_OUT_DESTINATION_DATASETTYPE_VALIDATION_XLSXW2_1 Yes XLSXW2_1_DESTINATION_DATASETTYPE_VALIDATION "$(XLSXW2_OUT_DESTINATION_DATASETTYPE_VALIDATION_XLSXW2_1)" # Add a new text field for the navigation tree in WB.更多的细节在BUG51426中。DEFAULT_MACRO TEMPLATE_SHEET_XLSXW2_1 GUI可选TEXT TEMPLATE_SHEET_XLSXW2_1模板页：XLSXW2_1_TEMPLATE_SHEET “$（TEMPLATE_SHEET_XLSXW2_1）” XLSXW2_1_DATASET “$（DestDataset_XLSXW2_1）” XLSXW2_1_GENERATE_FME_BUILD_NUM 15479＃！END_DEST_HEADER # !START_WB_HEADER＃！END_WB_HEADER＃！END_HEADER LOG_FILENAME”(FME_MF_DIR) SpacesToExcel美元。log" LOG_APPEND NO LOG_TIMINGS YES LOG_FILTER_MASK -1 LOG_MAX_FEATURES 200 LOG_MAX_RECORDED_FEATURES 200 FME_REPROJECTION_ENGINE FME FME_IMPLICIT_CSMAP_REPROJECTION_MODE Auto FME_GEOMETRY_HANDLING Enhanced FME_STROKE_MAX_DEVIATION 0 DEFAULT_MACRO DATASET_KEYWORD_REVIT_1 REVIT_1 DEFAULT_MACRO DATASET_KEYWORD_XLSXW2_1 XLSXW2_1 # ------------------------------------------------------------------------- REVIT_1_READER_META_ATTRIBUTES fme_feature_type # ------------------------------------------------------------------------- MULTI_READER_CONTINUE_ON_READER_FAILURE No # ------------------------------------------------------------------------- MACRO WORKSPACE_NAME SpacesToExcel MACRO FME_VIEWER_APP fmedatainspector # ------------------------------------------------------------------------- REVIT_1_DEF Space fme_type fme_solid AreaUnit char(200) BaseQuantities.GrossFloorArea double BaseQuantities.GrossPerimeter double BaseQuantities.GrossVolume double BaseQuantities.Height double BaseQuantities.NetFloorArea double "Building LongName" char(200) "Building Name" char(200) BuildingAddress.AddressLines{} char(200) BuildingAddress.Country char(200) BuildingAddress.PostalCode char(200) BuildingAddress.Region char(200) BuildingAddress.Town char(200) "Constraints.Base Offset" double Constraints.Level char(200) "Constraints.Limit Offset" double "Constraints.Upper Limit" char(200) Dimensions.Area double "Dimensions.Computation Height" double Dimensions.Perimeter double "Dimensions.Unbounded Height" double InteriorOrExteriorSpace char(200) LengthUnit char(200) Phasing.Phase char(200) Pset_SpaceCommon.Reference char(200) "Space LongName" char(200) "Space Name" char(200) "Storey Elevation" char(200) "Storey LongName" char(200) "Storey Name" char(200) VolumeUnit char(200) # ------------------------------------------------------------------------- FACTORY_DEF * RoutingFactory FACTORY_NAME "Router and Unexpected Input Remover" COMMAND_PARM_EVALUATION SINGLE_PASS MULTI_READER_KEYWORD $(DATASET_KEYWORD_REVIT_1) INPUT FEATURE_TYPE * ROUTE REVIT REVIT_1::Space multi_reader_keyword,$(DATASET_KEYWORD_REVIT_1) TO FME_GENERIC ::Space ALIAS_GEOMETRY MERGE_INPUT Yes OUTPUT ROUTED FEATURE_TYPE * REVIT_1_MERGE_DEF REVIT_1::Space EXACT Space # ------------------------------------------------------------------------- FACTORY_DEF * TeeFactory FACTORY_NAME "Space (REVIT_1) Splitter" INPUT FEATURE_TYPE Space OUTPUT FEATURE_TYPE Space_REVIT_1 DEFAULT_MACRO WB_CURRENT_CONTEXT # ------------------------------------------------------------------------- FACTORY_DEF * SortFactory FACTORY_NAME Sorter INPUT FEATURE_TYPE Space_REVIT_1 SORT_BY "Space Name" NUMERIC ASCENDING OUTPUT SORTED FEATURE_TYPE Sorter_SORTED # ------------------------------------------------------------------------- FACTORY_DEF * RoutingFactory FACTORY_NAME "Destination Feature Type Routing Correlator" COMMAND_PARM_EVALUATION SINGLE_PASS INPUT FEATURE_TYPE * ROUTE FME_GENERIC Sorter_SORTED TO XLSXW2 __GO_TO_FINAL_OUTPUT_ROUTER__ CopyAttributes 编码 房间 空间 数量 空间 空间 的名字 原始 空间 房间 空间 使用 空间 空间 LongName multi_writer_id 0 SupplyAttributes 编码 __wb_out_feat_type__ 空间 几何FEATURE_TYPE_ATTRIBUTE __wb_out_feat_type__输出路由FEATURE_TYPE *输出NOT_ROUTED FEATURE_TYPE __nuke_me__ @Tcl2 (“FME_StatMessage 818059 [FME_GetAttribute fme_template_feature_type) 818060 818061 fme_warn”) # - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - FACTORY_DEF * TeeFactory FACTORY_NAME“最终输出核武器”输入FEATURE_TYPE __nuke_me__ # - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - XLSXW2_1_DEF空间xlsx_drop_sheet没有xlsx_trunc_sheet xlsx_sheet_order”“xlsx_freeze_end_row”“xlsx_names_are_positions不xlsx_field_names_out是的xlsx_start_col”“xlsx_start_row”“xlsx_offset_col”“xlsx_offset_row”“xlsx_raster_type PNG xlsx_table_writer_mode插入xlsx_row_id_column”““房号”字符串(10版本 1 number_format_string 字体 font_color background_color pattern_color pattern_style text_alignment 没有 horizontal_alignment vertical_alignment 缩进 text_orientation text_control cell_protection 没有 hide_cells lock_cells )"Original Room Usage" string(30,version 1 number_format_string 字体 font_color background_color pattern_color pattern_style text_alignment 没有 horizontal_alignment vertical_alignment 缩进 text_orientation text_control cell_protection 没有 hide_cells lock_cells )"New Room Usage" string(30,version 1 number_format_string 字体 font_color background_color pattern_color pattern_style text_alignment 没有 horizontal_alignment vertical_alignment 缩进 text_orientation text_control cell_protection 没有 hide_cells lock_cells )