openerp-community team mailing list archive

["W. Martin Borgert" <debacle@xxxxxxxxxx>]

On 2012-07-23 07:11, Eric Caudal wrote:
> First export your "user" list: it will give you the ids you require
> (__export__.xxxxx) in the id column and use them in the column
> "employee_id/id"

You mean the HR/HR/Employee export, not the user export, right?
There I get the employee id, indeed.

> For the attendance id, you can give the name/id you want (eg:
> att20120722_user1) as long as they are unique.

OK, this works like a charm. Many thanks, Eric!

Cheers


> *Eric CAUDAL*, Elico Corp, Shanghai.
> eric.caudal@xxxxxxxxxxxxxx  <mailto:eric.caudal@xxxxxxxxxxxxxx>
> Cell: + 86 186 2136 1670. Skype: elico.corp
> *Premium Certified Training Partner - OpenERP Ready Partner.*
> 
> 	
> Premium CTP
> http://www.openerp.net.cn
> 
> On 07/23/2012 04:20 AM, Damian Soriano (Gmail) wrote:
> >CSV is what was used in provious version of OpenERP. I think that XML
> >is now the standard.
> >
> >You can export XML from MS Excel and LibreOffice as well... this is
> >not a problem.
> >
> >Regards
> >
> >Damián Soriano
> >
> >On Sun, Jul 22, 2012 at 10:14 PM, W. Martin Borgert <debacle@xxxxxxxxxx> wrote:
> >>On 2012-07-22 13:18, Damian Soriano (Gmail) wrote:
> >>>As an alternative you can use XML for loading data. In XML you can
> >>>define ids that can be referenced later.
> >>Well, I have yet to learn how OpenERP really works :~) But I
> >>thought CSV is the way to go, because it is already there. CSV
> >>is the only import option, for export there is CSV and Excel.
> >>Also, the data I like to import is already in LibreOffice Calc,
> >>which makes CSV easy to create.
> >>
> >>So my question is: (How) can I create a CSV file acceptable for
> >>OpenERP, when the exported CSV looks like this:
> >>
> >>"id","action","name","employee_id/id"
> >>"__export__.hr_attendance_1","Sign In","2012-07-18 08:00:00","__export__.hr_attendance_2_13"
> >>
> >>Cheers
> >>
> >>
> >>>As an example you can see the file 'addons/base/base_data.xml' in the
> >>>official addons.
> >>>
> >>>Regards
> >>>
> >>>Damián
> >>>
> >>>On Sun, Jul 22, 2012 at 11:47 AM, W. Martin Borgert <debacle@xxxxxxxxxx> wrote:
> >>>>Hi,
> >>>>
> >>>>I like to use OpenERP (6.1-20120720-233345-1 on Debian) to
> >>>>manage employee's attendance. I already have data collected for
> >>>>the past and like to import it. Is the CSV import the right way
> >>>>to do this?
> >>>>
> >>>>I don't yet understand the CSV content. The fields "action"
> >>>>(Sign In/Sign Out) and "name" (date time in ISO format) are
> >>>>clear, but how can I specify the employee? Do I need IDs for
> >>>>every line? If so, how can I generate them?
> >>>>
> >>>>Thanks in advance!
> >_______________________________________________
> >Mailing list: https://launchpad.net/~openerp-community
> >Post to     : openerp-community@xxxxxxxxxxxxxxxxxxx
> >Unsubscribe : https://launchpad.net/~openerp-community
> >More help   : https://help.launchpad.net/ListHelp
> 

> _______________________________________________
> Mailing list: https://launchpad.net/~openerp-community
> Post to     : openerp-community@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~openerp-community
> More help   : https://help.launchpad.net/ListHelp