Clear field using Bulk Update

ERPNext
1

Hi ,

Is there a way to clear a field (i.e. null value) using the Bulk Update tool? I would appreciate any pointers

Thanks

2

Hi,

Bumping this up again… any ideas pls?

Kind regards,

3

Hi
This is unfortunately not possible in the Bulk Update tool at the moment
On how many records do you need to change the field to blank? The Report view can be handy for that, albeit a bit manual

1 Like
4

Thanks @dirkvdl16

Had to do it directly in the db (which is something I prefer to avoid if possible)

Cheers

5

Hii @wale

Have you found a solution for this issue? I also need to clear field values in multiple records.

6

Hi @Manav_Mandli

You can do by SQL Query

7

@Usama_Naveed Okay, thanks for your response, but is this possible using interface like bulk update tool.?

8

@Manav_Mandli

Can you please tell here the details.
Which doctype field you want to update by bulk and what is the field?

9

I want to update item doctype default warehouse in my existing records.

10

You can update the parent field from ‘Bulk Update or from interface’

default warehouse is the child table field.

Now, There are two ways to update default warehouse.

1)By SQL Query
2)Data Import Tool (this will done from interface. Let me explain this option more)

Data Import Tool
steps
1)Export all items from system in excel. (On the time of selecting field for exporting, select default warehouse also)
2)Add the default warehouse in the excel file and update it.
3)Go into Data Import List and import updated excel file.

11

okay got it
thank you

12

There is a way to clear fields using directly accessing the DB. Below is an example

erpuserVM:~/frappe-bench$ bench --site ucsctest_site.com console
Apps in this namespace:
frappe, payments, erpnext, hrms, ecommerce_integrations, education

In [1]: frappe.db.sql("UPDATE `tabStudent` SET middle_name = NULL WHERE middle_n
   ...: ame IS NOT NULL")
   ...: frappe.db.commit()
   ...: 

In [2]: exit