|
csv and xml are both possible
Martin, 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" For the attendance id, you can give the name/id you want (eg: att20120722_user1) as long as they are unique. Best regards
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" CheersAs 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
