FVVAQTR CDL Template

[Saumil1848]

Can anyone tell me what am I doing wrong on the template?

Case 1 - I have a variable that is already in the system. I am trying to create the fixed value using the template and assigning it a value of $20. It does not create the fixed value.

Case 2- If the fixed value is already in the system, it assigns it to the variable but does not import the fixed value

I am removing the headers, naming the file correct, data format is fine too. All the basics are fine. I just can't get this fixed value to load.

.fvvaqtr.png

[former_member127775]

Hello Saumil. The screenshot you show doesn't match the FVVAQTR template that I have. See the fields below that the import is expecting. I'm assuming that since you are using the quarterly template, your FVV has a required period type of Quarter. If not, then you need to be using another template. Let me know if the period differs and i can point you in the right direction.

[AG5]

Hi Saumil, Please delete Columns H & I (EFFECTIVESTARTDATE & EFFECTIVEENDDATE) and try loading the file. After the 'UNITTYPEFORVALUE' field, the next field should be 'PERIOD_VALUE'.