How do I modify Easypopulate

[Guest]

I need to export some data from OSC to a logistics / purchasing system.

To avoid to double type all prices and information we definately need to do an automatic export from OSC on a regular basis.

Easypopulate seems like a very suitable contrib for that.

We will use EP to get products info into OSC since all vendors supply Excel price lists.

We need to modify EP so that it gives out theese fields as a tab, comma or semicolon separated list :

 

Description Field no. Length Comments

===========================

Identification 3 Always: XYZ

#Header

Type of information 1 Always: P - for Products

Version 2 Always: 15

#Data starts here :

Product no. 1 25 Text

Description/name 2 60 Text

Entity name 3 20 Text

Weight 4 10 Numeric

Volume 5 10 Numeric

Cost price 6 10 Numeric

Sales price 7 10 Numeric

VAT code 8 1 Numeric

Product group 9 4 Numeric

Sub Group 10 4 Numeric

Purchase price 11 4 Numeric

Supplier connection 12 25 Text

Stock 13 12 Numeric

Default warehouse 14 4 Numeric

 

I know some of those fields do not match the database structure of OSC, but those

fields could just be hardcoded so the output is set to a fixed value.

 

Summarized : Standard OSC import functionality.

Custom output with only some fields in the export. Export

format separated by tabs, commas or semicolons.

 

Can somebody give some hints on how to achieve this ?

 

Rgds

TAN