def _root_translate():
file_input = root_path_file.get()
type_input = root_choose_in.get()
type_output = root_chooseext.get()
name_input = _basenameNotExt(file_input)
name_output = _basenameFullPathNotExt(file_input)
file_output_csv = '.'.join([name_output, TYPE_OUT_csv
]) if name_input != '' else CHAR_STD_INOUT
file_output_xls = '.'.join([name_output, TYPE_OUT_xls
]) if name_input != '' else CHAR_STD_INOUT
file_output = None
file_output = file_output_csv if (file_output is None) and (
type_output == TYPE_OUT_csv) else file_output
file_output = file_output_xls if (file_output is None) and (
type_output == TYPE_OUT_xls) else file_output
type_input = _root_combo_get(root_combo_out, type_input)
self_type_input.set(type_input)
self_file_input.set(file_input)
self_name_input.set(name_input)
self_file_output.set(file_output)
self_type_output.set(type_output)
if _trim(name_input) == '':
logs_info('Choose text file report, please!')
return
if not _fileExist(file_input):
logs_info("File report '%s' not exist!" % file_input)
return
manipulate()
def _root__execute_():
file_input_master = root_path_file_master.get()
file_input_addcsv = root_path_file_addcsv.get()
type_input = root_choose_in.get()
type_output = root_chooseext.get()
name_input_master = _basenameNotExt(file_input_master)
name_input_addcsv = _basenameNotExt(file_input_addcsv)
name_output = _basenameFullPathNotExt(file_input_master)
name_output = ''.join([name_output, '+merged+', name_input_addcsv])
#CZ#file_output_csv = '.'.join([name_output, TYPE_OUT_csv]) if name_input != '' else CHAR_STD_INOUT
#CZ#file_output_xls = '.'.join([name_output, TYPE_OUT_xls]) if name_input != '' else CHAR_STD_INOUT
file_output_csv = '.'.join([
name_output, TYPE_OUT_csv
]) if name_input_master != '' else CHAR_STD_INOUT
#CZ#file_output = None
file_output = None if (args.file_output
== CHAR_STD_INOUT) else args.file_output
file_output = file_output_csv if (file_output is None) and (
type_output == TYPE_OUT_csv) else file_output
#CZ#file_output = file_output_xls if (file_output is None) and (type_output == TYPE_OUT_xls) else file_output
type_input = _root_combo_get(root_combo_out, type_input)
self_type_input.set(type_input)
self_file_input_master.set(file_input_master)
self_file_input_addcsv.set(file_input_addcsv)
self_name_input_master.set(name_input_master)
self_name_input_addcsv.set(name_input_addcsv)
self_file_output.set(file_output)
self_type_output.set(type_output)
if _trim(name_input_master) == '':
logs_error('Choose csv file Master, please!')
return
if _trim(name_input_addcsv) == '':
logs_error('Choose csv file AddCSV, please!')
return
if not _fileExist(file_input_master):
logs_error("File Master '%s' not exist!" % file_input_master)
return
if not _fileExist(file_input_addcsv):
logs_error("File AddCSV '%s' not exist!" % file_input_addcsv)
return
if _fileExist(file_output):
#CZ#logs_error("File output '%s' exist!\n\nDelete or move/rename and retry..." % file_output)
#CZ#return
result = askyesno(
'question', "File output '%s' exist!\n\nOverwrite?" % file_output)
if result == False:
return
#CZ#else:
#CZ# logs_info("File output '%s' set overwrite!" % file_output)
manipulate()
file_input_addcsv = args.file_input_addcsv
file_output = args.file_output
type_output = args.type_output
run_gui = True if sys.platform == 'win32' else run_gui
run_gui = False if run_cmd else run_gui
name_input_master = _basenameNotExt(file_input_master)
name_input_addcsv = _basenameNotExt(file_input_addcsv)
exte_output = _basenameGetExt(file_output)
type_output = TYPE_OUT_csv if (type_output is None) and (
exte_output[1:] == TYPE_OUT_csv) else type_output
#CZ#type_output = TYPE_OUT_xls if (type_output is None) and (exte_output[1:] == TYPE_OUT_xls) else type_output
file_output_csv = '.'.join(
[_basenameFullPathNotExt(file_input_master), TYPE_OUT_csv])
#CZ#file_output_xls = '.'.join([_basenameFullPathNotExt(file_input_master), TYPE_OUT_xls])
file_output = file_output_csv if (file_output is None) and (
type_output == TYPE_OUT_csv) else file_output
#CZ#file_output = file_output_xls if (file_output is None) and (type_output == TYPE_OUT_xls) else file_output
file_output = file_output_csv if (file_output == CHAR_STD_INOUT) and (
type_output == TYPE_OUT_csv) else file_output
#CZ#file_output = file_output_xls if (file_output == CHAR_STD_INOUT) and (type_output == TYPE_OUT_xls) else file_output
#csv_delimiter = ',' if csv_delimiter is None else csv_delimiter
#csv_quotechar = '"' if csv_quotechar is None else csv_quotechar
#csv_quoting = csv.QUOTE_MINIMAL if csv_quoting is None else csv_quoting
csv_quoting = csv.QUOTE_NONE if csv_quoting is None else csv_quoting
#csv_lineterminator= "\r\n" if csv_lineterminator is None else csv_lineterminator
#key_columns_merge = '' if key_columns_merge is None else key_columns_merge
type_input = args.type_input
file_input = args.file_input
file_output = args.file_output
type_output = args.type_output
run_gui = True if sys.platform == 'win32' else run_gui
run_gui = False if run_cmd else run_gui
name_input = _basenameNotExt(file_input)
exte_output = _basenameGetExt(file_output)
type_output = TYPE_OUT_csv if (type_output is None) and (
exte_output[1:] == TYPE_OUT_csv) else type_output
type_output = TYPE_OUT_xls if (type_output is None) and (
exte_output[1:] == TYPE_OUT_xls) else type_output
file_output_csv = '.'.join([_basenameFullPathNotExt(file_input), TYPE_OUT_csv])
file_output_xls = '.'.join([_basenameFullPathNotExt(file_input), TYPE_OUT_xls])
file_output = file_output_csv if (file_output is None) and (
type_output == TYPE_OUT_csv) else file_output
file_output = file_output_xls if (file_output is None) and (
type_output == TYPE_OUT_xls) else file_output
file_output = file_output_csv if (file_output == CHAR_STD_INOUT) and (
type_output == TYPE_OUT_csv) else file_output
file_output = file_output_xls if (file_output == CHAR_STD_INOUT) and (
type_output == TYPE_OUT_xls) else file_output
#csv_delimiter = ',' if csv_delimiter is None else csv_delimiter
#csv_quotechar = '"' if csv_quotechar is None else csv_quotechar
#csv_quoting = csv.QUOTE_MINIMAL if csv_quoting is None else csv_quoting
csv_quoting = csv.QUOTE_NONE if csv_quoting is None else csv_quoting