Problem in importing process sets

[saleh]

In the model that we use, they have defined different processes sets in the file Scen_Sets_****.xlsx (which is located in \SuppXLS\ScenDef) and based on those sets they have defined various constraints (e.g. share constraints), for some reason when we import the model in VEDA some processes sets do not import properly, as a result we get some dummy imports. I also tried to re-import these sets manually using import sets option under tools in VEDA but I still cannot import process sets properly. Another team do not have this problem with this model (we have exactly the same model) so I don't know what could be the reason for this. By the way I use VEDA FE v.4.5.5.

[Vikrant]

Hi Saleh,

I found multiple Process sets table in your sent Sets file like 'Proc' and '****_filters' sheets. But sets table identifier "~TFM_PSets" is written only in '****_filters' sheet.

Some useful tips:

• Scen_Sets****.xls/x file is not the regular scenario file, so user have to import this using "Tools => Import Sets" option.
  


• Veda is looking only for those table which have  "~TFM_PSets" or "~TFM_CSets" identifiers, so active tables should have with one of them.
  


• User can check imported sets on Browse(F7) right after the import sets processing. 
  


• Veda also showing the list of missing(not found) sets after SYNC processing.
  

I hope your issue will resolve after this.

[saleh]

Hi Vikrant,

Thank you for your help. Unfortunately that's not the case, if you look at '****_filters' tab it includes all of defined sets in 'Proc' sheet, and as I said the other team uses exactly the same file and they don't have my issue. For example one of dummy imports is related to S_CSCELC constraint which is defined based on CSC-ELC process set (this process set does not import in VEDA on my computer), if you look at '****_filters' tab it is defined in line 78. There is a similar story for all other dummies.

I also don't get a message that there these sets are missing after SYNC processing but when I look at RES they are not there and as a result the related constraints do not work properly and we get dummy imports.

I appreciate your help.

[Vikrant]

This functionality is working fine for us without any issue, so here should be some confusion which cause this issue.
If you can share ActiveDB.MDB and VEDA_SNT.MDB databases, then I can explain the cause more accurately.

Did you check this set on Browse(F7)?

You can send me the files at [email protected].

[Vikrant]

We can also do a quick web meeting to resolve this. Tell me when we can do this.

[saleh]

Hi Vikrant,

In Browse I can see these process sets but they are empty (they don't have their assigned processes). Please see your email.

Thanks!

[Vikrant]

Hi Saleh,

I found some clue for you to investigate at your end. First of all '****_filters' tab has duplicate entries.
And let's talk about CSC-ELC process set ( Name like "CSC*" and Comm-IN = "COMELC" ). Your sent ActiveDB.MDB don't have any commodity named as COMELC.

I suggest you to please validate the Sets definitions again before import.