home recent topics recent posts search faq  

RC-WinTrans Forum



register | lost password | |
Messages in this topic - RSS

Home » RC-WinTrans Support » Excel AddOn

For support issues and specific questions related to RC-WinTrans' use, features and functions.
26.06.2017 18:49:55

lrms
lrms
Posts: 4
When migrating from RC-WinTrans X8 to RC-WinTrans 11, my Excel Import commands are not working. I did notice the macro was renamed (ExcelImportExportAddOnV4.macro) but changing the command line taking that in account was not enough. Previously there was a ExcelImportExportAddOn.chm help file with the macro, but version 11 doesn't seem to have this file (MTAddOn has both a .chm and .macro file, but not ExcelImportExportAddOnV4). Where else can I find a document to see how the Import command should be used (by command line) with this new macro?
Is a XLS created/used by version X8 compatible with /ImportExcel command from version 11??
0 permalink
27.06.2017 00:13:29

Support
Support
Administrator
Posts: 245
Hello Irms,

the Excel import/export is now integrated to RC-WinTrans 11.


> I did notice the macro was renamed (ExcelImportExportAddOnV4.macro) but changing the command line taking that in account was not enough.
>
Yes. Do not use the macro file. Use the new (diect) command line commands (and not via add-on macro functions).


> Is a XLS created/used by version X8 compatible with /ImportExcel command from version 11?
>
Should be but I'm not sure if this is true for all X8 / add-on created/exported XLS files.
The command line command /ImportExcel is tested only with Excel files exported with RC-WinTrans 11.


Excel Command Line Commands (with Example):
http://rc-wintrans.schaudin.com/Help11/Command_Line_Processing/CommandLineCommands.htm#ExportExcel
http://rc-wintrans.schaudin.com/Help11/Command_Line_Processing/CommandLineCommands.htm#ImportExcel


Regards,
Support, Schaudin.com
0 permalink
27.06.2017 18:52:28

lrms
lrms
Posts: 4
The same file that imports successfully from the GUI, gives a "-1" error when importing trhough Command Line. I've tried:

rcwintrans.exe /ImportExcel /proj <myproject>.rwproject /lang en-US /extfile <somefile>.xls -replace

Output is:

Import "en-US" from Excel workbook file "<somefilepath>.xls"...
Project: "<myprojectpath>.rwtproject"
Unsuccessful. Return value: -1

<somefilepath> and <myprojectpath> show the correct/real fullpathnames of the files.
If I open the same rwtproject inside RCWinTrans GUI and call File -> Import -> Excel File... select the same .xls file, and click OK ("Overwrite existing translation" is marked) it does work properly.
I am using version 11.0.0.26 (May, 2017).
0 permalink
27.06.2017 23:04:31

Support
Support
Administrator
Posts: 245
Hello Irms,

it is a bug in the /ImportExcel command function.

To get /ImportExcel "working", at least for importing data for one source file, use the /srcfile parameter and speify the name of one source file in your project.
This works -- for importing data for the one specified source file in the project.

Example:
RCWinTrans.exe /ImportExcel projname.rwtproject /lang fr-FR /srcfile resfilename.rc /extfile "u:\test{\xt.xlsx -replace

The bug will be fixed in the next RC-WinTrans 11 service release -- next to the current May 2017 build vesion 11.0.0.24.

Regards,
Support, Schaudin.com
edited by Support on 29.06.2017
0 permalink

Home » RC-WinTrans Support » Excel AddOn





Powered by AspNetForum 6.9.6.0 © 2006-2010 Jitbit Software