Re: [tryton] Help with importing csv data please

[ferreave]

>
> You have to click on the tools icon, to open a menu where you will see 
> the missing options. 
>
Thanks Sergi. The answer was too simple :) . 

-- 
You received this message because you are subscribed to the Google Groups 
"tryton" group.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/tryton/d637decc-c4b6-46eb-82fc-d72251ba5f7d%40googlegroups.com.

Re: [tryton] Help with importing csv data please

[ferreave]

> Use the menu by clicking the Spanner icon above the new button. It has all 
> those options.
>
> Regards,
> Prayash Mohapatra
>
Oh, my gosh! I missed it completely. Thank you very much. 

-- 
You received this message because you are subscribed to the Google Groups 
"tryton" group.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/tryton/93624a54-67c3-422c-9d5f-6478a497c7ee%40googlegroups.com.

Re: [tryton] Help with importing csv data please

[Sergi Almacellas Abellana]

El 20/07/16 a les 21:54, ferre...@gmail.com ha escrit:

Hi Sergi. Thank you very much for helping me. This is what I get on the
toolbar of the parties view: New, Save, Switch View, Reload/Undo,
Previous, Next, Attachment, Note, Actions, Relate, Report, E-mail, Print
and Search. I cannot see: Export, Import, Duplicate, Delete. Did I do
something wrong? I just checked, and my client says "4.0.2". I installed
from the jessie repositories.
You have to click on the tools icon, to open a menu where you will see 
the missing options.



--
Sergi Almacellas Abellana
www.koolpi.com
Twitter: @pokoli_srk

--
You received this message because you are subscribed to the Google Groups 
"tryton" group.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/tryton/94bceb6d-010d-6185-6764-7b855d9dd9a6%40koolpi.com.

Re: [tryton] Help with importing csv data please

[ferreave]

> On each toolbar of every tab you open in the client, there is the option 
> to import Data and Export Data. [1] 
> [1] 
> http://doc.tryton.org/4.0/tryton/doc/usage.html?highlight=import#tool-bar


Hi Sergi. Thank you very much for helping me. This is what I get on the 
toolbar of the parties view: New, Save, Switch View, Reload/Undo, Previous, 
Next, Attachment, Note, Actions, Relate, Report, E-mail, Print and Search. 
I cannot see: Export, Import, Duplicate, Delete. Did I do something wrong? 
I just checked, and my client says "4.0.2". I installed from the jessie 
repositories.
 

> Hope it helps. 
>
It does. Thanks.
 

-- 
You received this message because you are subscribed to the Google Groups 
"tryton" group.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/tryton/e5bb09ff-e956-4101-8d25-319f988087bc%40googlegroups.com.

Re: [tryton] Help with importing csv data please

[Sergi Almacellas Abellana]

Hi,

El 20/07/16 a les 16:43, ferre...@gmail.com ha escrit:

Hello, I did not want to create a new thread. I don't know how to import
or export. I am using Tryton 4.0 from the jessie repository, and I want
to import data (anything at this point). The only thing that I see
related to importing and exporting is Administration > Models > Exports
which gives me a rather crude tab as compared to what I see on
http://www.tryton.org/news/index.html. I would like to know how to bring
that nice interface to import, please.


On each toolbar of every tab you open in the client, there is the option 
to import Data and Export Data. [1]


You can use those wizards to import data from every model. In this 
wizard you will be asked for a CSV fields containing the data to import. 
You also have to select the fields you want to import.


Hope it helps.

[1] 
http://doc.tryton.org/4.0/tryton/doc/usage.html?highlight=import#tool-bar

--
Sergi Almacellas Abellana
www.koolpi.com
Twitter: @pokoli_srk

--
You received this message because you are subscribed to the Google Groups 
"tryton" group.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/tryton/2424982c-e0b5-7dbd-4918-d26cf5759590%40koolpi.com.

Re: [tryton] Help with importing csv data please

[Cédric Krier]

On 03 Jul 16:30, Dale Scott wrote:
 Hi Cédric, thanks for your feedback.
 
 On Wednesday, 2 July 2014 07:39:14 UTC-6, Cédric Krier wrote:
 
  On 02 Jul 06:05, Dale Scott wrote: 
  snip 
 
  
   Problem 1. If I view the detail of a specific product in Tryton (menu 
   Products  Products, select a specific product, Switch view to see 
   product detail), and then try to Switch view back to the grid view 
   showing all product, Tryton will warn that the record has been modified 
  and 
   ask if I want to save it - even though I did not knowingly edit it. What 
   can cause this? 
 
  Some data are not in the right format. So the client after displaying 
  it, re-format it and detect a change in the value. 
 
 
 Could you describe in a general way how you would investigate this?

I would put a print statement in the client:
http://hg.tryton.org/tryton/file/e5604ddea4c4/tryton/gui/window/view_form/model/record.py#l140

I know we should have logging for that.

   Problem 2. The PV BOM table includes two foreign key constraints to the 
   PV part table. Each row in [3] represents a child part on a BOM, 
  PLListID 
   is the PNID of the parent product in [1], and PLPartID is the PNID of a 
   child product on the BOM. Other fields in [3] give the quantity on BOM, 
  the 
   use-as UOM, the item number on the BOM listing, etc. Can Tryton import 
   multiple BOMs from a single csv file having this structure? Will someone 
   give me a hint as to the field names? 
 
  I did not look to close to your data structure but any way, csv import 
  only works for very basic/simple cases. Any even a little bit complex 
  import should be done using a proteus script. Python is an the ETL 
  (https://en.wikipedia.org/wiki/Extract,_transform,_load) 
 
 
 Is the csv import capable of importing one single-level BOM, but no more 
 complex?

Normally it is theoretically possible to import anything but it is much
more complex and difficult when it is not simple data than using
proteus.

-- 
Cédric Krier - B2CK SPRL
Email/Jabber: cedric.kr...@b2ck.com
Tel: +32 472 54 46 59
Website: http://www.b2ck.com/


pgpnIM54OLLKH.pgp
Description: PGP signature

Re: [tryton] Help with importing csv data please

[Paul Leverett]

 Can you give us information about the error first? 


Trying to import the 1-record example csv I get :

Application Error! 
ProtocolError for localhost:8000/name: 500 Internal Server Error
None

Re: [tryton] Help with importing csv data please

[Hendrik Brandes]

Hello Paul,

I have stucked with same errors and have done the following steps to solve 
this:

1) Create a debug-enhancement within modelstorage.py, so every exception 
within the validation gives me a hint, what went wrong
For example in modelstorage.py, method _validate. Before every 
cls.raise_user_error I have inserted a debug-statement like print or 
logging.

2) I also create some debug hints within the database-backend, method 
execute, so I can see, which records are read and what are the conditions
Under some circumstances, I found out, that some references are not stored 
correctly ( perhaps due to missing masterdata ) and those leads to my 
errors.

Finally, I could manage my imports by analyzing and add every needed field 
step by step. 
After I have known, what are my necessary fields, I created a pentaho 
transformation ( kettle ) and automate the creation of import data.

Kind regards,
Hendrik

Am Donnerstag, 27. März 2014 09:02:45 UTC+1 schrieb Paul Leverett:


 Can you give us information about the error first? 


 Trying to import the 1-record example csv I get :

 Application Error! 
 ProtocolError for localhost:8000/name: 500 Internal Server Error
 None

Re: [tryton] Help with importing csv data please

[Paul Leverett]

On Thursday, March 27, 2014 9:55:43 AM UTC, Hendrik Brandes wrote:


 Finally, I could manage my imports by analyzing and add every needed field 
 step by step. 
 After I have known, what are my necessary fields, I created a pentaho 
 transformation ( kettle ) and automate the creation of import data.


Thanks for your comments, I have now solved the problem and it seemed very 
simple... I wan't enclosing text in quotes.
If I do this and use a direct-matching name for the lookup field (not ID) 
it seems to work OK.

The notes in Spanish posted by Raimon were very helpful - muchas gracias.
(I used Google Chrome translator for instant page translation to English - 
fantastic.)
 
Now that I've go a basic example working I'm a lot happier in progressing 
various different imports - thanks for the help

[tryton] Help with importing csv data please

[Paul Leverett]

Hi, I'm struggling with importing csv data into Products.

From previous posts I understand that CSV import is not the direct 
opposite of csv Export, but I still can't get my head around how to import 
data that includes mandatory pick-list fields. I can do a text-only import 
OK, but can't get anything to work with look-ups.

e.g. As a test I try to import a single Product record CSV with the minimal 
mandatory fields:

Cost Price,List Price,Name,Type,Default UOM/Name,Cost Method
9.000,11.000,Minimal fields test product3,goods,Unit,fixed


This doesn't work and gives me a server error.

Can you give me any specific information about why this doesn't work?
For look-ups do I need to use an ID instead of a name?
It would be great if someone could give me a working one-line csv that will 
work as an upload into Products.

Many thanks,
Paul

Re: [tryton] Help with importing csv data please

[Raimon Esteve]

2014-03-26 12:48 GMT+01:00 Paul Leverett p...@marsguitars.co.uk:
 Hi, I'm struggling with importing csv data into Products.

 From previous posts I understand that CSV import is not the direct opposite
 of csv Export, but I still can't get my head around how to import data that
 includes mandatory pick-list fields. I can do a text-only import OK, but
 can't get anything to work with look-ups.

 e.g. As a test I try to import a single Product record CSV with the minimal
 mandatory fields:
 
 Cost Price,List Price,Name,Type,Default UOM/Name,Cost Method
 9.000,11.000,Minimal fields test product3,goods,Unit,fixed


 This doesn't work and gives me a server error.

 Can you give me any specific information about why this doesn't work?
 For look-ups do I need to use an ID instead of a name?

UOM need an ID, not name

You have examples in doc.tryton-erp.es (1) (2) (Use a translator to
translate Spanish to another language)

(1) http://doc.tryton-erp.es/trytond_doc/tryton_import_export.html
(2) http://www.tryton-erp.es/posts/importacion-de-productos-mediante-csv.html

Raimon

Re: [tryton] Help with importing csv data please

[Raimon Esteve]

 UOM need an ID, not name
 That's false. import_data for many2one accepts name:
 http://hg.tryton.org/trytond/file/8e5623672cdc/trytond/model/modelstorage.py#l555

Great!