openerp-community team mailing list archive

["Damian Soriano (Gmail)" <damiansoriano@xxxxxxxxx>]

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!