openerp-community team mailing list archive

[Colin MacMillan <colin@xxxxxxxxxxxxxxxxxxxxxx>]

Hello Martin,

You may try our module to import CSV data into OpenERP - ea_import -
http://apps.openerp.com/?filter={%22order_by%22%3A+%22click_counter+desc%22}&text_search=ea_import

There is also a module called ea_import_examples with some predefined
templates and csv file examples.

This is a fairly powerful tool that requires knowledge of the OpenERP
database.

Some video tutorials are here - http://www.youtube.com/watch?v=RTR4h_Y-_I8

Good luck!


On 23 July 2012 00:05, W. Martin Borgert <debacle@xxxxxxxxxx> wrote:

> 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 <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
>