Moving data from custom tables to application tables

Timothy Ng
Timothy Ng
Seventh Anniversary Participant
in Blackbaud CRM™ General Discussions

We are trying to integrate our online database by writing to a custom table on the CRM. Is there a method, series of commands, or scripts that would allow for data to be written onto application tables such as ADDRESS or CONSTITUENT? We are encountering errors with the TSLONG and UDT_MONTHDAY fields in CRM.

Comments

  • Rick Root
    Rick Root
    Tenth Anniversary Kudos 2 Name Dropper Participant

    @Timothy Ng I don't think there's anywhere near enough information to provide any kind of answer here.

    However, when inserting data into any application table, you don't need to insert anything into the TSLONG field.

    As for the UDT_MONHTDAY field, just insert them as a for digit string likie 0105 or 1231

  • Chris Whisenhunt
    Chris Whisenhunt
    Fourth Anniversary Name Dropper Participant Facilitator 1

    @Timothy Ng great question! This really all depends on your organization's business rules outlined during their implementation. As a best practice most organizations send that data to batch so that it has the standard data validation steps and can have any custom work done through the extensions. Feel free to reach out if you have any specifics questions.


Categories