Client Resource Center

We’re scientists helping scientists. Our team brings deep expertise from the lab bench to the digital space, giving us a unique understanding of your challenges. 

Need Help?

Our team of scientists and product experts are here for you. Please fill out the form below so we can assist you.

Professional woman using headset for customer service in office setting.
Always developing to support your success

Read the latest product release details

Additional Resources

Barcode Print Server

The Barcode Print Server (BPS) makes it easy for ELN, RegMol, and Inventory users to generate and print barcodes. BPS can be installed on either Cloud or Enterprise editions, and multiple servers can be set up across different sites or rooms to fit your workflow.

System Requirements

  • Windows machine (XP, Vista, 7, 8, or 10)

  • .NET Framework 2.0

Supported Printers
ELN, RegMol, and Inventory work with a wide range of barcode printers. For best results, we recommend Zebra barcode printers with USB and Ethernet connectivity, such as the H-9607 model.

Barcode Print Server

Assay Plate Calculation using Custom Formula

Supported API:

  • avg: Average of an array
  • stdev: Standard Deviation of an array
  • rsd: Relative Standard Deviation of an array
  • sum: Sum of an array
  • max: The maximum value of an array
  • min: The minimum value of an array
  • round: round all values
  • LOOPBEGIN(var:list)
  • LOOPEND

// loop A,B for 4 goups: A,B, C,D, E,F, G,H

LOOPBEGIN(A,B: A,B, C,D, E,F, G,H)

    var max = avg([A10.response, B10.response]);         // average of A10 and B10 response
    var low = avg([A11.response, B11.response]);         // average of A11 and B11 response

    var diff = max ‐ low; 

    A10.mean = diff;                                     // set A10 mean (C10, E10, and G10)

    A10.result =  100*diff/diff;                         // set A10 result (C10, E10, and G10)

 

    // loop I from column 1 to 0

    LOOPBEGIN(I:1,2,3,4,5,6,7,8,9)

        AI.mean = avg([AI.response, BI.response]) ‐ low; // calculate mean from column 1 to 9

        AI.sd = stdev([AI.response, BI.response]);       // calculate stdev

        AI.result = 100*AI.mean/diff;                    // calculate result

        AI.se = 100*AI.sd_od/diff;                       // calculate se

    LOOPEND

 

    // round all data

    round(2);

LOOPEND

PMF Workflow Script APIs

*It is able to run C# script in Workflow nodes.

Example 1 – Send Email:

SendEmail(“support@company.com”, null, null, “Test Email”, “This is a test email”, false);
return true;

Example 2 – Write form data into a database table:

Database.Row row = new Database.Row();
row.Add(“company”, “Scilligence”);
row.Add(“website”, “www.scilligence.com”);
InsertDB(“Data Source=(local);Initial Catalog=CompanyDB;User ID=sa;Password=;”, “Companies”, row);
return true;

Example 3 – Call SOAP Web Service:

Database.Row row = new Database.Row();
row.Add(“company”, “Scilligence”);
row.Add(“website”, “www.scilligence.com”);
string ret = CallSoap(“http://server/app/service.asmx”, “http://namespace.company.com”, “AddCompany”, row);
return ret;

Properties:

  1. this.data (Database.Row): contains workflow form data
  2. this.requestid (long): the current requestid
  3. this.CurrentUserID: the current user ID
  4. this.CurrentUserEmail: the current user email

Methods supported:

  1. bool SendEmail(string to, string cc, string bcc, string subject, string body, bool html)
  2. long CreateRequest(string form, Database.Row data, bool submit, string notes)
  3. long CreateRequestCopyData(string form, string keys, bool submit, long userid)
  4. bool SetFieldValues(Database.Row data)
  5. bool InsertDB(string connectionstring, string table, Database.Row row)
  6. bool UpdateDB(string connectionstring, string table, Database.Row row, string where)
  7. Database.Row ReadDB(string connectionstring, string sql)
  8. string ReadFile(string path, string credential)
  9. void WriteFile(string path, string contents, string credential)
  10. string CallWebService(string url, Database.Row postdata, string username, string password, int timeout)
  11. string CallSoap(string url, string ns, string method, Database.Row data)
  12. byte[] ReadFileStore(string s, string source)
  13. string ReadFileStoreAsText(string s, string source)
  14. string GetProjectCode()
  15. string GetCompanyCode()
  16. long CreateProject(string company, string parentproject, string projectcode, string name, Database.Row row)
  17. long CreateTask(string projectcode, long parenttaskid, string title, Database.Row row)
  18. bool DoAction(long requestid, string cmd, Database.Row items)
  19. bool SetFieldValue(string key, string value)
  20. bool SetFieldValues(Database.Row data)
Scroll to Top