📊 Mastering Data Import in Muyan: Your Go-To Cheat Sheet

Hey Muyan community!

Whether you’re a seasoned pro or just getting started, efficient data import is crucial for making the most of our low-code platform. To help you out, we’ve put together this handy cheat sheet with all the essential tips and tricks for smooth data importing.

:card_index_dividers: File Naming: Keep it simple! Use the class name without the package (e.g., Contract.csv).

:clipboard: Field Types:

  • Query Fields: Mark with () - e.g., name()
  • Dynamic Fields: Use (#) - e.g., Tags(#)
  • Associated Objects: Dot notation is your friend - e.g., ownerOrganization.name

:triangular_flag_on_post: Special Columns:

  • Want to mark something for deletion? Use ‘Y’ in the DELETE_FLAG column.
  • Need to add comments? Start lines with a semicolon (;).

:date: Data Formats:

  • Dates: “yyyy-MM-dd HH:mm:ss”
  • Booleans:
    • True: ‘Y’, ‘Yes’, ‘TRUE’, ‘1’
    • False: ‘N’, ‘No’, ‘FALSE’, ‘0’
  • Root Org Placeholder: $ROOT_ORG$

:warning: System Limits: Keep your files under 100 MB.

:key: Best Practices:

  • Always set query fields to avoid duplicates
  • Test imports in non-production environments
  • Regularly check ImportRecord logs
  • Consider object relationships when planning imports

:arrows_counterclockwise: Import Methods:

  • Automatic import on system startup
  • Manual import from domain list page
  • Reload or import seed data

Remember: In Muyan, everything is data - from user roles to business logic. It can all be imported!

:bulb: Pro Tip: Always test your imports in a non-production environment first. It’s better to catch any issues before they hit your live system!

Got questions or want to share your own import tips? Drop them in the comments below!

For more detailed info, check out our full documentation at Data Import | Muyan AI+ Low Code Development Platform

Happy importing, everyone! :rocket: