My list looks like this in the input csv file (I generated this list usign a
Java program)
[6,10,18,35,44,50,55,72,87,92,114,123,124,148,159,160,162,175,182,185,199,201,203,230,238,263,273,277,283,290,303,338,343,353,364,399,407,412,443,461,464,466,479,490,495,502,513,518,520,528,533,558,563,575,604,613,615,620,623,640,653,664,665,674,693,734,762,768,771,774,775,788,805,821,822,830,834,837,853,857,858,885,906,908,909,914,924,926,929,940,943,944,960,967,974,980,984,989,999,1021,1022,1028,1033,1043,1056,1063,1082,1083,1114,1126,1130,1135,1148,1156,1166,1193,1195,1208,1219,1222,1231,1241,1250,1257,1262,1274,1277,1289,1290,1300,1307,1320,1329,1332,1350,1352,1363,1386,1392,1415,1419,1427,1445,1464,1466,1475,1480,1498,1503,1512,1530,1532,1533,1539,1575,1576,1578,1594,1607,1609,1620,1626,1640,1674,1679,1684,1687,1689,1714,1719,1735,1741,1774,1797,1802,1803,1819,1823,1828,1838,1845,1848,1854,1862,1871,1891,1898,1907,1916,1920,1922,1930,1936,1937,1945,1964,1986,1999,2002,2012,2041,2100,2105,2115,2149,2164,2177,2181,2188,2189,2200,2203,2212,2216,2224,2225,2259,2280,2299,2310,2319,2342,2372,2375,2387,2389,2406,2424,2425,2429,2436,2469,2500,2503,2504,2513,2522,2535,2540,2542,2568,2598,2618,2628,2631,2641,2646,2648,2662,2673,2674,2679,2683,2685,2693,2703,2718,2727,2728,2730,2745,2751,2756,2764,2796,2809,2810,2825,2833,2858,2859,2880,2882,2888,2902,2905,2921,2923,2924,2937,2944,2945,2955,2957,2958,2963,2966,2968,2997,3002,3005,3039,3040,3054,3058,3072,3078,3081,3083,3086,3136,3140,3143,3156,3160,3164,3180,3181,3190,3196,3203,3215,3218,3225,3229,3242,3266,3279,3340,3347,3349,3361,3370,3376,3403,3424,3447,3462,3468,3488,3493,3495,3499,3513,3518,3551,3554,3560,3616,3625,3652,3664,3669,3672,3684,3711,3728,3729,3757,3760,3782,3802,3830,3854,3899,3915,3924,3929,3937,3948,3962,3976,3983,3986,3996,4007,4008,4014,4025,4034,4037,4040,4048,4057,4067,4099,4104,4107,4108,4115,4116,4122,4127,4141,4142,4148,4151,4171,4175,4189,4190,4200,4206,4211,4214,4217,4224,4231,4236,4247,4251,4258,4263,4266,4280,4297,4308,4314,4339,4342,4362,4382,4383,4388,4401,4411,4412,4421,4423,4430,4439,4445,4476,4486,4489,4493,4500,4503,4528,4551,4559,4589,4591,4599,4625,4639,4648,4652,4654,4662,4682,4684,4712,4723,4728,4743,4752,4765,4792,4793,4798,4802,4818,4831,4845,4850,4858,4865,4866,4887,4902,4909,4910,4921,4944,4948,4953,4955,4974,4979,4990,5008,5011,5018,5030,5036,5039,5049,5060,5063,5066,5093,5097,5114,5134,5140,5149,5153,5166,5178,5181,5189,5202,5205,5206,5215,5222,5226,5235,5251,5272,5288,5302,5309,5311,5317,5318,5340,5347,5369,5394,5432,5434,5441,5451,5458,5459,5472,5476,5479,5505,5508,5513,5525,5526,5532,5546,5560,5568,5578,5585,5586,5591,5604,5613,5614,5615,5630,5646,5662,5664,5669,5670,5672,5699,5723,5757,5776,5783,5799,5808,5811,5821,5825,5835,5849,5853,5855,5864,5874,5877,5883,5885,5896,5903,5909,5915,5928,5929,5930,5935,5953,5981,6021,6032,6037,6038,6039,6043,6046,6048,6061,6063,6081,6089,6094,6110,6112,6147,6150,6170,6171,6181,6183,6188,6196,6208,6214,6219,6220,6244,6262,6271,6273,6300,6308,6320,6333,6348,6366,6367,6372,6389,6407,6416,6422,6424,6425,6460,6465,6490,6505,6510,6516,6520,6540,6542,6546,6547,6559,6563,6579,6586,6624,6632,6643,6648,6649,6653,6661,6667,6682,6699,6707,6721,6727,6728,6732,6736,6739,6758,6765,6768,6769,6798,6806,6816,6847,6863,6867,6869,6873,6875,6893,6909,6919,6930,6950,6957,6960,6978,6979,6984,7002,7008,7013,7024,7031,7036,7063,7066,7068,7071,7075,7076,7078,7080,7085,7087,7094,7120,7134,7135,7148,7151,7153,7171,7183,7198,7242,7249,7262,7274,7304,7323,7347,7360,7373,7386,7391,7399,7403,7427,7428,7429,7431,7432,7435,7440,7457,7460,7467,7475,7477,7480,7488,7489,7507,7521,7530,7531,7567,7583,7609,7634,7635,7641,7651,7676,7681,7683,7691,7696,7700,7724,7725,7733,7734,7739,7740,7746,7806,7808,7830,7839,7863,7880,7889,7907,7948,7951,7955,7956,7972,7982,7988,8014,8015,8028,8049,8051,8054,8067,8070,8088,8101,8105,8106,8109,8116,8118,8154,8160,8170,8178,8180,8193,8229,8259,8276,8297,8300,8317,8320,8324,8341,8351,8356,8364,8381,8419,8421,8433,8438,8457,8464,8475,8498,8507,8508,8510,8528,8539,8548,8586,8591,8595,8606,8609,8612,8632,8637,8643,8649,8654,8671,8676,8684,8694,8696,8716,8726,8730,8734,8735,8736,8745,8763,8764,8768,8774,8797,8843,8847,8851,8873,8883,8884,8887,8903,8915,8917,8924,8939,8945,8963,8970,8973,8988,8991,8993,8996,9002,9014,9017,9019,9021,9031,9035,9038,9047,9052,9062,9063,9083,9108,9113,9127,9130,9137,9149,9153,9166,9181,9194,9215,9226,9245,9246,9253,9258,9266,9271,9298,9302,9327,9334,9336,9348,9367,9382,9389,9395,9405,9429,9430,9437,9440,9459,9469,9482,9484,9510,9512,9513,9517,9529,9530,9541,9569,9575,9581,9618,9625,9641,9655,9660,9661,9666,9672,9676,9683,9706,9714,9715,9735,9746,9758,9778,9779,9782,9801,9826,9828,9829,9832,9837,9839,9843,9888,9908,9910,9916,9951,
974]
When I uploaded this kind of list, it looks like [u'[', u'1', u'4'] in the
datastore viewer.
When I clicked the particular entity , I see the type of that attribute as
list, but why is it displayed like [u'[', u'1', u'4'] ?
Can someone please say how to specify the list in the input csv file so that
they will be uploaded as list in the datastore and I can access it as list
from the Java program ?
Thanks,
Deepika
On Thu, Aug 5, 2010 at 7:27 PM, Deepika M <drift2elys...@gmail.com> wrote:
> Welll, import transform helps me in uploading the data as integers.
>
> I'd like to know how to specify the list type if my csv file has list.
>
> Will the following line be correct for uploading the list?
>
> import_transform : transform.none_if_empty(list)
>
> Thanks,
> Deepika
>
>
>
> On Wed, Aug 4, 2010 at 3:20 PM, Deepika M <drift2elys...@gmail.com> wrote:
>
>> Hi Ikai,
>>
>> Yes, you're right. It is uploaded as String.
>>
>> Is it the property of the bulkloader to upload the data as String or have
>> I done something wrong because I have declared the source and destination as
>> integers?
>>
>> Also, I haven't specified any import_transform or export_transform in my
>> bulkloader configuration file.
>>
>> Thanks,
>> Deepika
>>
>>
>>
>> On Tue, Aug 3, 2010 at 6:00 PM, Ikai L (Google) <ika...@google.com>wrote:
>>
>>> It may have been uploaded as a string. Does the datastore viewer state
>>> that it is a String or Long? Try "1" in your query.
>>>
>>> On Wed, Jul 28, 2010 at 2:11 PM, Deepika M <drift2elys...@gmail.com>wrote:
>>>
>>>> Hi,
>>>>
>>>> I am trying to use the bulk loader to upload information about edges for
>>>> Java app engine.
>>>>
>>>>
>>>> I have an Edge entity and it has the source (int), destination (int) and
>>>> graph_id (long) as its attributes.
>>>>
>>>>
>>>> And the csv file contains sample data like this
>>>>
>>>> source,graphId,destination
>>>> 1,1,1
>>>> 2,2,2
>>>> 1,2,4
>>>> 7,1,5
>>>> 1,2,1
>>>>
>>>> I am able to upload the contents of this csv file to the datastore and
>>>> even able to view it in the datastore viewer.
>>>>
>>>> But when I do a JPQL query on the data like
>>>>
>>>> Query query = em.createQuery("SELECT x FROM Edges x WHERE
>>>> x.graphId=1");
>>>>
>>>> I get the result size as 0 and I am not able to retrieve the data from
>>>> the datastore using JPQL query.
>>>>
>>>> Any help is appreciated.
>>>>
>>>> Thanks,
>>>> Deepika
>>>>
>>>> --
>>>> You received this message because you are subscribed to the Google
>>>> Groups "Google App Engine for Java" group.
>>>> To post to this group, send email to
>>>> google-appengine-j...@googlegroups.com.
>>>> To unsubscribe from this group, send email to
>>>> google-appengine-java+unsubscr...@googlegroups.com<google-appengine-java%2bunsubscr...@googlegroups.com>
>>>> .
>>>> For more options, visit this group at
>>>> http://groups.google.com/group/google-appengine-java?hl=en.
>>>>
>>>
>>>
>>>
>>> --
>>> Ikai Lan
>>> Developer Programs Engineer, Google App Engine
>>> Blog: http://googleappengine.blogspot.com
>>> Twitter: http://twitter.com/app_engine
>>> Reddit: http://www.reddit.com/r/appengine
>>>
>>> --
>>> You received this message because you are subscribed to the Google Groups
>>> "Google App Engine for Java" group.
>>> To post to this group, send email to
>>> google-appengine-j...@googlegroups.com.
>>> To unsubscribe from this group, send email to
>>> google-appengine-java+unsubscr...@googlegroups.com<google-appengine-java%2bunsubscr...@googlegroups.com>
>>> .
>>> For more options, visit this group at
>>> http://groups.google.com/group/google-appengine-java?hl=en.
>>>
>>
>>
>
--
You received this message because you are subscribed to the Google Groups
"Google App Engine for Java" group.
To post to this group, send email to google-appengine-j...@googlegroups.com.
To unsubscribe from this group, send email to
google-appengine-java+unsubscr...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/google-appengine-java?hl=en.
