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. > [email protected] <mailto:[email protected]> > 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 <[email protected]> > >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 <[email protected]> > >>>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 : [email protected] > >Unsubscribe : https://launchpad.net/~openerp-community > >More help : https://help.launchpad.net/ListHelp > > _______________________________________________ > Mailing list: https://launchpad.net/~openerp-community > Post to : [email protected] > Unsubscribe : https://launchpad.net/~openerp-community > More help : https://help.launchpad.net/ListHelp _______________________________________________ Mailing list: https://launchpad.net/~openerp-community Post to : [email protected] Unsubscribe : https://launchpad.net/~openerp-community More help : https://help.launchpad.net/ListHelp
