Mass data import

2 posts 0 new
Log in or register to post comments.

Mass data import

Hello everybody,

I need your help,

I’m trying to create a mass data Import.

Could you tell me, how to create an Import for quarter or half-year values?

How should we write it down in Excel? We’ve already tried it with blanks, “” or $

Thank you

 

Hi

If you use a date for period/value combination, you can use any date in the period definition, so 2019-1-1 is good for Q1 2019.

I personnaly prefer $Q1 / 2019 because dates are linked with regional settings

see http://kb.qpr.com/qpr2019-1/index.html?sql_mass_import.htm

Wim