Closing with success....
If more people need to import data from CSV files and need to reference
other collections in MongoDB, just prepare the file in the way described
below (recipe).
In a separate file (py) do this
- search your term in MongoDB collection of your choice;
- convert the _id in int from hex [ like int('deadbeef',16) ];
- convert the int in str;
- save your csv with this string (shoul be the Looooooong integer above);
- import the file!
This is the code I've used to do this.
https://gist.github.com/jrborbars/63a82486bdddfc13e365
Best regards,
2015-05-29 22:12 GMT-03:00 José Ricardo Borba <jrborba...@gmail.com>:
> Hummmmm.......
>
> Seems that web2py converts the hex _id of ObjectId to the Loooooooooong
> integer that represent that number.
>
> So, this is not an issue. I need to think again.......
>
> Best regards,
>
> 2015-05-29 18:22 GMT-03:00 José Ricardo Borba <jrborba...@gmail.com>:
>
>> Hello all,
>>
>> I'm experiencing some issues with web2py and MongoDB 3.0.3 _id field.
>>
>> With web2py 2.10.4 the _id field (ObjectId) is showed in this way:
>>
>> 26418130264307745716389872944
>> 26418130264307745716389872963
>> .
>> .
>>
>>
>> With Ipython 3.1.0 (with [python2.7.9 or 3.4.3 and pymongo] OR mongodb
>> shell 3.0.3) the _id field (ObjectId) is showed in this way:
>>
>> 555c90af47439f0958f10530
>> 555c90af47439f0958f10543
>> .
>> .
>>
>> I think that the last is the correct way to show the _id, because both
>> pymongo and mongoshell showed the same. But why the web2py is not showing
>> the correct _id? Maybe I'm doing something wrong?
>>
>> The last record was imported from a CSV file, and the first was inserted
>> from web2py form (from SQLGRID).
>>
>> Best regards,
>>
>> --
>> José Ricardo Borba
>>
>>
>
>
> --
> José Ricardo Borba
>
>
--
José Ricardo Borba
--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
---
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
