Fixtures...don't know what it is

camilopianos · December 2, 2014, 12:26pm

As a user I’ve seen the word Fixtures as part of installation process of ERPNext but also as a command on some forms of the application itself. I asumme after some changes on forms “Fixtures”, will apply (fix) them…

Is this relevant and if yes, is there some documentation about?

Many thanks

Camilo Correa
Happy implementing ERPNext

rmehta · December 3, 2014, 6:36am

Fixtures are to migrate data / settings for new apps.

~~https://frappe.github.io/frappe/user/en/guides/app-development/how-to-create-custom-fields-during-app-installation.html~~

Edit: fixed link

https://frappe.io/docs/user/en/guides/app-development/how-to-create-custom-fields-during-app-installation

edit: fix link again

camilopianos · December 3, 2014, 1:52pm

Thank you so much Rushabh!

Allways happy learnig more every day about ERPNext.
Camilo

yohendry_hurtado · March 9, 2016, 2:36pm

broken link, please can you proivide the new one?

rmehta · March 9, 2016, 4:21pm

~~How To Create Custom Fields During App Installation~~

https://frappe.io/docs/user/en/guides/app-development/how-to-create-custom-fields-during-app-installation

edit: fix link again

yohendry_hurtado · March 9, 2016, 5:12pm

thanks

aakvatech · January 10, 2018, 9:07pm

Link broken again!

Mohammed_Redha · January 10, 2018, 9:25pm

@aakvatech For your Reference:

https://frappe.io/docs/user/en/guides/app-development/how-to-create-custom-fields-during-app-installation

aakvatech · January 12, 2018, 8:42pm

Have gone through the link posted, and I see a need to have a more step by step document for a newbie. Should I post what I experienced as a user right here or is there a more appropriate place to share steps as per my experience?

Nimrod · January 23, 2018, 6:31am

Hi @aakvatech, it should be okay to post it here, I’ve found this thread through a simple search. And I think many others will find your experience useful if you’d be able to post it here.

strixaluco · January 23, 2018, 7:03am

Probably the most canonical way would be to fork the frappe repo and submit a pull request

https://github.com/frappe/frappe/blob/develop/frappe/docs/user/en/guides/app-development/how-to-create-custom-fields-during-app-installation.md

aakvatech · January 23, 2018, 6:32pm

Create new app e.g. - bench get-app library_management
Install new app into your site e.g. - bench --site erpnext.vm install-app library_management
Customize your form and ensure that the module name is changed to your app name e.g. - library_management
Open file hooks.py using a text editor, such as “vi” from the location e.g. - ~/frappe-bench/apps/library_management/library_management/hooks.py
At the end of the hooks.py file you can add line
fixtures = [“Custom Field”]
I would also add other usual customizations such as “DocType”, “Custom Script”, “Property Setter”, “Print Format”.
I can also use the same technique to add all setups that are done so that migrating setups from test to production and vice versa is easy.
Run command “bench --site mysite export-fixtures” to export all mysite customizations where you have selected Module name as your app name e.g. - library_management. The *.json files will be stored in the location ~/frappe-bench/apps/library_management/library_management/fixtures.

I haven’t tried using github yet but have read that one could upload the changes on github, or as I did, you can download those json files and put it into another system that has the same app created, into the same fixtures folder and use bench --migrate to apply the customization onto those sites that has the application installed.

hth

bghayad · March 12, 2019, 11:20am

Hello @avinash_upadhya28

This should be bench new-app library_management

This is not clear, can you please explain?
For example, I need to customize the Task doctype which is existed in erpnext application, so how to change the module name to be same as the created application name which is in your example is library_management?

You need to add DocType to be part of the fixtures that need to be exported because you need to include the changes that was made directly to the DocType and not through the Customize Form?

Regards
Bilal

aakvatech · March 12, 2019, 12:54pm

Yes, this could be required depending, whether you are getting ready app or making a new one.

Customizing a doctype form is recommended. Changing base doctype will break the updates and will require you to do bench update --reset that will undo all your work directly done on base doctypes. I have done this mistake too many a times already. Export the customized form to your “library_management” app.

Like above, better customize the form, and export form to your cutom app.

aakvatech · March 12, 2019, 12:55pm

Doctype of customized apps automatically get stored in the custom app/custom module/doctype directory and you have to git push it to your repository thereafter.

bghayad · March 12, 2019, 9:25pm

Hello @aakvatech

Thanks a lot for your kindly reply and help.

How? Can u explain the steps?
Do you mean export the fixtures or something else?
Where to be exported at the “library_management” app? At which directory?

Regards
Bilal

aakvatech · March 13, 2019, 2:19am

Set the developer_mode to 1 on server

image871×276 11 KB
Customize the form for the doctype:

image1172×627 29.8 KB
Select your custom app you created, in this example it’s called Recharge

If you don’t have a custom export then you need to make a new one like you indicated earlier.

You then run the command to export-fixtures:

if you have single site

bench export-fixtures

if you are multi-tenant

bench --site <> export-fixtures

The file will be stored in the apps/recharge/recharge/recharge/custom/
frappe@:~/frappe-bench$ ls apps/recharge/recharge/recharge/custom/
journal_entry.json purchase_receipt_item.json sales_taxes_and_charges.json
payment_entry.json purchase_receipt.json stock_entry_detail.json
purchase_invoice_item.json sales_invoice_item.json
purchase_invoice.json sales_invoice.json

hth

aakvatech · April 1, 2019, 4:30am

Further to this, I have realized that having filters defined helps to maintain only specific fixtures to be exported e.g.:

fixtures = [“Custom Field”, “Custom Script”, “Property Setter”, {“doctype”:“Naming Series”, “filters”: [{“doctype”:“Daily Checklist”}]}, {“doctype”:“Notification”, “filters”: [{“is_standard”:0}]}, ‘Auto Email Report’, “Translation”, {“doctype”:“Print Format”, “filters”: [{“module”:“Oil Management Solution”}]}, {“doctype”:“Report”, “filters”: [{“module”:“Oil Management Solution”}]} ]

Tropicalrambler · June 2, 2019, 12:44am

The data structure for fixtures is loosely defined by me as follows:
fixtures is a list of dictionary_objects:

fixtures = [object1, object2, objectN]

Each dictionary_object with filters contains:

*dictionary_object* = { "doctype":"*doctype_name*", "filters":"*list_of_filters*" }

doctype is self-explanatory, it is the DocType name you wish to export.

Each list_of_filters contains itself, a list_of_filter_criteria
The list_or_filter_criteria itself is a list containing:

*fieldname*, *operator*, (*value*)

Note that value is a Tuple!

*list_of_filter_criteria* = ["fieldname", "operator", ("Value1","Value2","ValueN", )]

So that:
“filters”: [list_of_filter_criteria]

For your convenience, these are the allowed operators:

Side note: I stumbled upon the operators during a traceback while running bench export-fixtures by using “not” and this was the message returned:

Operator must be one of =, !=, >, <, >=, <=, like, not like, in, not in, between, descendants of, ancestors of, not descendants of, not ancestors of, is```

aakvatech · June 4, 2019, 1:35pm

This is a much needed explanation for filters. If anybody is using with filters, please bookmark this reply by @Tropicalrambler, it will be very helpful.