CSV Method Call Passing Object Being Created

daryl · Décembre 14, 2020, 8:54

Hi everyone,

Is it possible to pass a record/item to a method while importing through CSV? It is possible to call a method as below, but if that method were for example take the object created as a parameter how can this object be passed in?

If ‹ validateSaleOrder › were to take an ‹ Order › object for example, how could the record being created through CSV be passed?

Example:

<input file=« sale-orders.csv » type="com.axelor.sale.db.Order"call=« com.axelor.data.tests.Validators:validateSaleOrder »>

Thank you in advance.

siddique · Décembre 14, 2020, 5:46

it’s possible have you checked docs?

daryl · Décembre 14, 2020, 6:15

H Siddique,

Thanks for getting back. The issue isn’t calling a method but passing the object being created by CSV data to the method, I don’t believe this is in the docs but please point out to me if I am wrong.

Thanks a mill.

siddique · Décembre 15, 2020, 5:37

in method you will get record, demo explains all things related to sale import data, let me know if you need more details

github.com

axelor/open-platform-demo/blob/8423bbe75ba47d4cc9656c5e6d597939fdfbe16b/modules/demo-data/src/main/java/com/axelor/data/tests/SaleOrderImport.java#L51


 * This method is called with <code>call</code> attribute from the <code>&lt;input&gt;</code> tag.
 *
 * <p>This method is called for each record being imported.
 *
 * @param bean the bean instance created from the imported record
 * @param values the value map that represents the imported data
 * @return the bean object to persist (in most cases the same bean object)
 */
public Object updateOrder(Object bean, Map<String, Object> values) {

  assert bean instanceof OrderLine;
  assert values.get("_saleOrder") instanceof Order;
  assert values.get("_customer") instanceof Contact;

  Order so = (Order) values.get("_saleOrder");
  OrderLine line = (OrderLine) bean;
  Contact cust = (Contact) values.get("_customer");

  if (so.getCustomer() == null) {
    so.setCustomer(cust);
  }

daryl · Décembre 15, 2020, 10:03

Hi Siddique,

This looks like it could do the trick. I will update you when I test it out.
Thank you a thousand for the help and quick replies as usual. It is really much appreciated.

system · Janvier 14, 2021, 10:03

Ce sujet a été automatiquement fermé après 30 jours. Aucune réponse n’est permise dorénavant.