TROUBLE WITH EXPORTING MY OWN MODEL

[happyych]

Hello,

I want some advice to export my own model.

I tested "export" function using sample model in lifelib (ex) CashValue_SE and my simple model.

However, when I tried to export my complex model I faced a trouble.

When I typed the command to export the model as below,

"mx.read_model('DMF_20240326').export('DMF_20240326_EX')"

the command works without any error and the folder is also created as below.

However, when I import the exported model, an error occur as below

As you can see, there is an file "Param.csv" in the location the error messege show.

I think the problem is that the pickled file is not made in exported model folder.

Because, my simple model which I succesfuly export has pickled file like "lapse_use" and "mp_use"

Could you give me any advice to solve this problem?

Thanks every time!

[fumitoh]

What is in _mx_io.py ? It should look like below:

ios = (
{'disc_rate_ann.xlsx': {'type': 'PandasIO', 'file_type': 'excel'},
 'mort_table.xlsx': {'type': 'PandasIO', 'file_type': 'excel'},
 'surr_charge_table.xlsx': {'type': 'PandasIO', 'file_type': 'excel'},
 'product_spec_table.xlsx': {'type': 'PandasIO', 'file_type': 'excel'},
 'model_point_1.xlsx': {'type': 'PandasIO', 'file_type': 'excel'},
 'model_point_moneyness.xlsx': {'type': 'PandasIO', 'file_type': 'excel'}})

iospecs = (
{2592819563728: {'type': 'PandasData',
                 'io': 'disc_rate_ann.xlsx',
                 'kwargs': {'read_args': {'index_col': 0, 'engine': 'openpyxl'},
                            'squeeze': True,
                            'name': 'zero_spot',
                            'sheet': None}},
 2592822659024: {'type': 'PandasData',
                 'io': 'mort_table.xlsx',
                 'kwargs': {'read_args': {'index_col': 0, 'engine': 'openpyxl'},
                            'squeeze': False,
                            'name': None,
                            'sheet': None}},
 2592822669520: {'type': 'PandasData',
                 'io': 'surr_charge_table.xlsx',
                 'kwargs': {'read_args': {'index_col': 0, 'engine': 'openpyxl'},
                            'squeeze': False,
                            'name': None,
                            'sheet': None}},
 2592823031376: {'type': 'PandasData',
                 'io': 'product_spec_table.xlsx',
                 'kwargs': {'read_args': {'index_col': 0, 'engine': 'openpyxl'},
                            'squeeze': False,
                            'name': None,
                            'sheet': None}},
 2592823124432: {'type': 'PandasData',
                 'io': 'model_point_1.xlsx',
                 'kwargs': {'read_args': {'index_col': 0, 'engine': 'openpyxl'},
                            'squeeze': False,
                            'name': None,
                            'sheet': None}},
 2592823125648: {'type': 'PandasData',
                 'io': 'model_point_moneyness.xlsx',
                 'kwargs': {'read_args': {'index_col': 0, 'engine': 'openpyxl'},
                            'squeeze': False,
                            'name': None,
                            'sheet': None}}})

[happyych]

I think the difference is I don't have any ios information. That might be the reason.
I will try again to get ios information.

ios = (
{})

iospecs = (
{2809112027648: {'type': 'PandasData',
'io': 'C:/modelx/Tables/Param.csv',
'kwargs': {'read_args': {'index_col': 0},
'squeeze': False,
'name': None,
'sheet': 'sheet1'}},
2809112031344: {'type': 'PandasData',
'io': 'C:/modelx/Tables/Global.csv',
'kwargs': {'read_args': {'index_col': 0},
'squeeze': False,
'name': None,
'sheet': 'sheet1'}},
2809112020880: {'type': 'PandasData',
'io': 'C:/modelx/Tables/Renewal_Except_Cont.csv',
'kwargs': {'read_args': {'index_col': [0, 1, 2]},
'squeeze': False,
'name': None,
'sheet': 'sheet1'}},
2809157252096: {'type': 'PandasData',
'io': 'C:/modelx/Tables/Expected_Birth_Date.csv',
'kwargs': {'read_args': {'index_col': 0},
'squeeze': False,
'name': None,
'sheet': 'sheet1'}},
2809157238848: {'type': 'PandasData',
'io': 'C:/modelx/Tables/adj_factor.csv',
'kwargs': {'read_args': {'index_col': 0},
'squeeze': False,
'name': None,
'sheet': 'sheet1'}},
2809157254544: {'type': 'PandasData',
'io': 'C:/modelx/Tables/Exp_Prod_Mapping.csv',
'kwargs': {'read_args': {'index_col': 0},
'squeeze': False,
'name': None,
'sheet': 'sheet1'}},
2809157239952: {'type': 'PandasData',
'io': 'C:/modelx/Tables/GUNGANG_Ctrl.csv',
'kwargs': {'read_args': {'index_col': [0, 1]},
'squeeze': False,
'name': None,
'sheet': 'sheet1'}},

[fumitoh]

Maybe it's because the file paths are outside the model. If you want to store the data files inside the model, you should give new_pandas relative paths from the model path, such as 'Param.csv', in stead of 'C:/modelx/Tables/Param.csv'.

If you want to store the data files outside the model, you should use this workaround.

[happyych]

Thank you for your advice!
It works after fix the path thanks!