EDI: Electronic Document Interchange for Microsoft Great Plains – overview for Software Developer/Programmer/DBAWritten by Andrew Karasev
Continued from page 1
--Additional fields go here from SOP10100 a join SOP10200 b on a.SOPTYPE=b.SOPTYPE and a.SOPNUMBE=b.SOPNUMBE join RM00101 d on a.CUSTNMBR=d.CUSTNMBR join (select SOPTYPE as SOPTYPE, SOPNUMBE as SOPNUMBE, LNITMSEQ as LNITMSEQ, CMPNTSEQ as CMPNTSEQ from SOP10200 union select SOPTYPE as SOPTYPE, SOPNUMBE as SOPNUMBE, MIN(LNITMSEQ)-1 as LNITMSEQ, MIN(CMPNTSEQ)-1 as CMPNTSEQ from SOP10200 group by SOPTYPE, SOPNUMBE ) c on a.SOPTYPE=c.SOPTYPE and a.SOPNUMBE=c.SOPNUMBE and ((b.LNITMSEQ=c.LNITMSEQ and b.CMPNTSEQ=c.CMPNTSEQ) or (b.LNITMSEQ=c.LNITMSEQ+1 and b.CMPNTSEQ=c.CMPNTSEQ+1)) left join SOP10106 udf on a.SOPTYPE=udf.SOPTYPE and a.SOPNUMBE=udf.SOPNUMBE where a.ADDRESS3<>'Exported' and a.SOPTYPE=3 and upper(d.USERDEF2)='YES' order by a.SOPTYPE, a.SOPNUMBE, b.LNITMSEQ asc 2. Mark processed documents - for this reason we use SOP10100.ADDRESS3 field - which was not used in Great Plains Dynamics/eEnterprise version 6.0: update SOP10100 set ADDRESS3='Exported' where SOPTYPE=3 3. Communication with UNIX EDI Client or Server – each case requires individual approach. You may have to assign file directory, exposed to UNIX system or use old DOS command to move file, or you can have automatic email. Good idea is to write communication application in your favorite programming language 4. Scheduled DTS Package - you should probably create DTS package to do all steps: call SQL Query and save it as a file, then call DOS command or simple EXE application - which does communicate with UNIX Happy programming! if you want us to do job - give us a call 1-866-528-0577! help@albaspectrum.com
Andrew Karasev is Chief Technology Officer in Alba Spectrum Technologies – USA nationwide Microsoft CRM, Microsoft Great Plains customization company, based in Chicago, Los Angeles, San Diego, San Francisco, Denver, Houston, Dallas, New York, Boston, Atlanta, Miami, Canada, UK, Australia and having locations in multiple states and internationally ( www.albaspectrum.com ), he is Dexterity, SQL, C#.Net, Crystal Reports and Microsoft CRM SDK developer.
| | Your Hard Disk Failed... Don't Panic !Written by Emanuele Allenti
Continued from page 1
Anyway, there is something you CAN do; if you are having data access problems and your media has no symptoms of physical failure or damage, try and check some obvious issues before deciding if you need data recovery: - Are power and disk cables properly connected? - Is configuration or disk information correct? - Try defective unit with a different adapter/controller interface or on a different computer. - Is there an experienced technician at a local store or company help desk that you can consult, if these steps are beyond your capabilities? (Make sure whoever is in contact with your data loss situation is fully aware that they should do nothing during their troubleshooting that will risk hurting your data.) Doesn't work? Don't panic; if damage occurred to drive's electronics, it most likely could be fixed. If damage occurred to the, for example, system areas of disk, leaving data zone intact, those data could be theoretically, and (in some cases) practically, recovered by a professional. Look on Net for data recovery companies, ask them questions, explain them your situation. In most cases they will be able to understand your problem and fix it for a fair price.
Emanuele Allenti is the owner of Backup and data recover tips, a website with useful information written by experts for those interested in backup and data recovery
|