This project is read-only.

userdatafield problems

Topics: Database Management
Sep 23, 2015 at 9:53 AM
Edited Sep 23, 2015 at 9:56 AM
Dear Jaromir,

I tried to load a csv file with several userdata for each series.

I tried with this command:

dq = dbload('quarterly.csv','commentRow=',{'comment'}','userDataFieldList=',{'name','definition','unit'});

It loads without error, but I can not find the loaded userdata.

What should I do if I save it to a different csv?

Thanks,
Andras

database:

https://drive.google.com/file/d/0B6ZQn6g1IpiPVWRHc3RoeWRhaDA/view?usp=sharing
Oct 12, 2015 at 12:08 AM
Dear Andras,

Your load command actually works for me. What eversion of IRIS are you using? Could you try with latest source? http://iristoolbox.codeplex.com/SourceControl/latest#

I get this:

>> d = dbload('quarterly.csv','commentRow=',{'comment'}','userDataFieldList=',{'name','definition','unit'});
>> d
d = 
    gdp: [62x1 tseries]
>> d.gdp
ans = 
    tseries object: 62-by-1
    2000Q1:   70989
    2000Q2:   71016
    2000Q3:   71422
    2000Q4:   71334
    2001Q1:   71847
    2001Q2:   72015
    2001Q3:   72612
    2001Q4:   73065
    2002Q1:   72409
    2002Q2:   74908
    2002Q3:   74643
    2002Q4:   74829
    2003Q1:   75447
    2003Q2:   76721
    2003Q3:   77632
    2003Q4:   78618
    2004Q1:   80104
    2004Q2:   80091
    2004Q3:   81037
    2004Q4:   83634
    2005Q1:   83450
    2005Q2:   84900
    2005Q3:   85394
    2005Q4:   86412
    2006Q1:   87940
    2006Q2:   89875
    2006Q3:   91919
    2006Q4:   93204
    2007Q1:   94936
    2007Q2:   95486
    2007Q3:   97576
    2007Q4:   99985
    2008Q1:   99662
    2008Q2:  100568
    2008Q3:  101188
    2008Q4:  100326
    2009Q1:  100812
    2009Q2:  101777
    2009Q3:  102523
    2009Q4:  103267
    2010Q1:  104443
    2010Q2:  105367
    2010Q3:  106054
    2010Q4:  108735
    2011Q1:  110335
    2011Q2:  112149
    2011Q3:  114455
    2011Q4:  115639
    2012Q1:  116782
    2012Q2:  117770
    2012Q3:  117386
    2012Q4:  118942
    2013Q1:  120155
    2013Q2:  123344
    2013Q3:  124536
    2013Q4:  126089
    2014Q1:  127978
    2014Q2:  128502
    2014Q3:  129740
    2014Q4:  130399
    2015Q1:  131513
    2015Q2:  132294
    'GDP 2008'
    user data: 
        name: 'Real GDP'
        definition: 'Gross domestic product at constant 2005 prices'
        unit: 'billions'
    export files: [0]
Oct 12, 2015 at 12:09 AM
just click the Download link on the Source Code tab. My link seems not to have copied correctly...