| Welcome to LawsonTalk. We hope you enjoy your visit. You're currently viewing our forum as a guest. This means you are limited to certain areas of the board and there are some features you can't use. If you join our community, you'll be able to access member-only sections, and use many member-only features such as customizing your profile, sending personal messages, and voting in polls. Registration is simple, fast, and completely free. After registration, please check your e-mail within 24 hours for an message from us, read it, and reply to it. Join our community! If you're already a member please log in to your account to access all of our features: |
| Writing Directly To Pa31 (applicants Tables) | |
|---|---|
| Topic Started: Jun 19 2007, 06:14 AM (481 Views) | |
| shanesmj | Jun 19 2007, 06:14 AM Post #1 |
|
SuperMember
  ![]](http://209.85.48.22/static/1/pip_r.png)
|
I am implementing a new Applicant Tracking System and we are looking to write hired applicants DIRECTLY to the Applicant table. I am wondering if anyone has done this and if anyone has suggestions for me???? I know about PA531 but I want to script the whole thing so that the users do not have to run a bunch of different processes. They will need to run something from the ATS (hosted system) - then I want to have something setup to just write the information to PA31 automatically. Thanks Shane |
 |
 
|
| schroncd | Jun 19 2007, 10:58 AM Post #2 |
Lawson Technorati
|
Unless you are either REALLY REALLY SMART or REALLY REALLY STUPID, *NEVER* write directly to Lawson's database tables. There are relationships and OBJIDs that get created as part of data insertion that you probably don't know about or understand completely, and writing directly into tables can hose the relationships to the rest of it's associated data. I'd stronlgy recommend writing your script to accumulate the input data into a csv file and use jqsubmit to execute PA531 so the data validation takes place. |
|
|
|
| « Previous Topic · Database · Next Topic » |
10:21 PM Jul 31
