Thread Details
  • State Verified Answer
  • Replies 3 replies
  • Subscribers 365 subscribers
  • Views 1685 views
  • Users 0 members are here
Forum Actions

Import Business Rules From Spreadsheet

John Boyes

Has anyone come across a tool that will create a Process Business Rule from a CSV file?

We are looking to assign Leads based on ZIP Codes and entering thousands of ZIP Codes through the UI will be very time consuming.

Parents
  • 0

    A very simple business rule like the example USA Regions rule is saved in the database with this record:

    If you encode the field rst_source_definition which contains the business rule definition you get the following JSON encoded tree:

    This single record contains so much information that a simple csv file is surely not the rigth place the handle it.

    It is another side of the coin when you decide to define an own csv syntax which is handled perhaps by an own module, eg.g custom_busines_rules.

    Here you could create all the rule lines in a certain structure and create a summarizing business rule on demand by a button click. But that's custom coding and should be done in this special custom module, for which an import would be available also.

Reply
  • 0

    A very simple business rule like the example USA Regions rule is saved in the database with this record:

    If you encode the field rst_source_definition which contains the business rule definition you get the following JSON encoded tree:

    This single record contains so much information that a simple csv file is surely not the rigth place the handle it.

    It is another side of the coin when you decide to define an own csv syntax which is handled perhaps by an own module, eg.g custom_busines_rules.

    Here you could create all the rule lines in a certain structure and create a summarizing business rule on demand by a button click. But that's custom coding and should be done in this special custom module, for which an import would be available also.

Children
No Data