span8
span4
Hi,我在2014年的FME工作。I am trying to create a workspace that will have a reader grab all xls files from one folder (with multiple schemas),re-project the xy coordinates to two new attributes (x,y),and export the data to multiple xls files based on file name and new projection.Before the workspace is run,the user must manipulate the xls files to have columns with original coordinate system and original x and y coordinates.标题“original_coordinate_system”和“sourcex”和“sourcey”是所有Excel文件之间唯一常见的列名。
When I run the workspace I get an error saying
"Error fetching dynamic schema definitions from reader `XLSXR_1"
Attached are two xls worksheets as an example,and two screenshots to show a portion of the script.
有人能给我一些建议吗?Thanks in advance.
Set the Attribute Definition of the writer to automatic.
Hi@丽兹,
1。我会在要开始的写入程序参数中将Drop Table/Sheet设置为Yes,如果您一直在创建新的Excel文件,
2.Also the dynamic schema definition might have to be set on in the writers property
先试试第一个。
Just wanted to say thanks so much for the help,thanks to all the suggestion from you two I've finally got the script working!Cheers!!
Thank you for the suggestions!My output excel file now has the original attributes,但不是新的X,y attributes,but this is progress!
WRT自定义变压器:是否有一个变压器可以替换为自定义变压器?(I'm assuming my Esri Re-project transformers?) Or would you create a number of custom transformers?@gisinnovationsb
And here are the current excel sheets I'm working with.@stalknecht,@gisinnovationsb
Here you go...thanks again for looking taking the time to look at this!@gisinnovationsb,@stalknecht
The output excel files are completely blank;they don't even contain column headers@gisinnovationsb.It's like opeining up a new worksheet.
Hi@丽兹,是否尝试使用高级浏览器添加Excel文件以选择多个文件或文件夹?我已经能够阅读您在2014年的FME中随附的两份电子表格,使用此配置供读者阅读。
Hi Tia,thanks for the response.I finally got the outputs working thanks to the screenshots above,but my output excel files are now blank,with no attributes.Any suggestions here?Thanks again for your time!@ TiaA亚搏在线tSafe
感谢大家的回答!我已将我的工作区附加到此日志…I'm fairly new to FME so I'm guessing I'm making a beginner mistake..However any further suggestions would be amazing!我还附加了两个运行此工作区的Excel文件。Thanks again!
Hi,
可能是因为工作表中的列名称。
Your sample sheet nr.2 9601 Has无效字符在第一个4列。
在FME 2014中使用动态编写器时,这是否会导致问题?(can't test it as I no longer have 2014 installed)
It does not cause problem using 2016,FME只是删除无效字符。
In fme I use the dynamic writer schema definition with schema source
"96* [XLSXR]" or
"Schema From Schema Feature"
两者都工作正常© 2019 亚搏在线Safe Software Inc |Legal