On 2012-07-22 22:20, Damian Soriano (Gmail) wrote: > CSV is what was used in provious version of OpenERP. I think that XML > is now the standard.
OK, I still work with OpenERP 6.1-20120720-233345-1, because I had problems with the 6.2 preview. In my version there is only CSV import/export and Excel export in the user interface. > You can export XML from MS Excel and LibreOffice as well... this is > not a problem. But this would need an adaptation from one XML format to another, right? And how can I import XML data anyway? The UI (web) does not offer this function. Cheers > 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
