498 Commits

Author SHA1 Message Date
5166867b4a Added logic to allow a merge of 16-bit data into a 32-bit database. Also tried to add an update formats for all database, but isn’t working yet, so I commented the logic out for now. 2013-06-21 12:23:31 +00:00
1d6fb249c7 2013-06-14 14:19:50 +00:00
ca50815d38 added check for existence of DBF file before trying to process the procedure. Added message to error log stating that the DBF file was not found 2013-06-14 13:35:07 +00:00
1cc722cb67 Fixed logic to handle a user (sub) format as the procedure set default format
added more robust logic to handle outside transitions
supporting logic to add an additional annotation when multiple possibilities for an outside transition is possible
2013-06-12 19:00:37 +00:00
Rich
f03615dd7d Added IsLandscape property to WordDocument class
Utilized IsLandscape property to set WordDocument orientation
2013-06-11 18:40:11 +00:00
Rich
4885c21734 Used landscape parameter in call to SaveWordDoc in MigrateLibDoc method
Added new table function vefn_GetVersionFormatItems
Used comparison of DocStyle PageWidth to PageLength to determine value for landscape parameter in call to SaveSectionDocument
Added ability to disable checkoffs for a section based on 16-bit data
2013-06-11 18:39:39 +00:00
Rich
d099c1a881 Added boolean parameter to SaveSectionDocument and SaveWordDoc methods to support landscape word documents 2013-06-11 18:38:13 +00:00
Rich
ebccc32e4e Fixed logic to find ROs in procedure text. 2013-05-23 20:40:09 +00:00
Rich
e9f746a883 Logic to determine if a transition was acceptable was running into a limit. The limit was removed.
Changed logic so that Compare Check Box is visible if the PDF Output folder contains a folder named "Compare".
Pagination within a step was changed to more accurately fill a page taking account for continue messages at the top and bottom of the page.
Logic was added to try to find a place to break a step, if the minimum break location cannot be found using the standard logic.
Added YTopMost output to debug text on compare PDFs.
2013-05-21 15:37:19 +00:00
26ce21ccb9 connect library documents for procedures that have many sections (step/sequence was non-alpha) 2013-05-14 12:48:42 +00:00
63ebe985f1 2013-05-14 12:48:08 +00:00
e4f0e892d3 2013-04-23 13:37:37 +00:00
da370ae7f2 Convert back quote to a degree in (16-bit Ter Editor) / MSWord sections 2013-04-19 19:16:43 +00:00
Rich
f77a704f6c Added getJustFormat, vesp_TurnChangeManagerOFF and vesp_TurnChangeManagerON stored procedures 2013-04-19 13:53:39 +00:00
Rich
c24fd83bdf Added overloaded method RunScript to allow for executing a sql command from DataLoader
Made call to vesp_TurnChangeManagerOFF prior to converting a database and a call to vesp_TurnChangeManagerON after converting a database to improve adding 16-bit data to an existing 32-bit database
Made call to vesp_TurnChangeManagerOFF prior to fixing transitions and a call to vesp_TurnChangeManagerON after fixing transitions to improve adding 16-bit data to an existing 32-bit database
Modified PartialMatch method to handle cases when XTSETID.DBF entry for abbyproc does not have the .prc extension
Modified ExactMatch method to handle cases when XTSETID.DBF entry for abbyproc does not have the .prc extension
Added stored procedure stubs for vesp_TurnChangeManagerOFF and vesp_TurnChangeManagerON
2013-04-19 13:53:08 +00:00
Rich
a7c689f23a Modified getAnnotationAuditsChronologyByItemIDandUnitID to use derived applicability
Modified getContentAuditsSummaryByItemIDandUnitID to use derived applicability
Modified getContentAuditsChronologyByItemIDandUnitID to use derived applicability
2013-04-10 14:18:57 +00:00
Rich
1941ab1f2b Fixed Search Annoations. The code was looking for Items which contained annotations rather than looking for the annotations. The results would list all of the annotations for items that matched the search criteria rather than just the annotations that matched the search criteria.
The stored procedure "DeleteAnnotationType" was changed to delete any related records in the table tblAnnotations.  This allows the user to delete annotation types that are no longer is use.
The drag function for Folders, Procedures, Sections and Steps was changed to require the user to press the Control and Shift keys when dragging, thus making it more difficult to accidently move items in the Tree View.
2013-04-09 14:20:58 +00:00
Rich
55f918c150 Added logic to only process RO value updates for the specified DocVersion. 2013-04-08 19:26:16 +00:00
Rich
268df16b6e Modified vefn_GetMyChronology to include datetime parameter
Modified getContentAuditsChronologyByItemID to include datetime parameter
Modified vefn_ChronologyReport to include datetime parameter
Modified getAnnotationAuditsChronologyByItemID to include datetime parameter
Modified getContentAuditsSummaryByItemID to include datetime parameter
2013-04-08 14:37:56 +00:00
Rich
6046f905b1 Modified getAnnotationAuditsChronologyByItemID to include datetime parameter
Modified vefn_GetMyChronology to include datetime parameter
Modified getContentAuditsChronologyByItemID to include datetime parameter
Modified getContentAuditsSummaryByItemID to include datetime parameter
Modified vefn_ChronologyReport to include datetime parameter
2013-04-08 14:37:21 +00:00
Rich
3dac6dd926 Modified vefn_ChronologyReport to include datetime parameter
Modified vefn_GetMyChronology to include datetime parameter
Modified getContentAuditsChronologyByItemID to include datetime parameter
Modified getContentAuditsSummaryByItemID to include datetime parameter
Modified getAnnotationAuditsChronologyByItemID to include datetime parameter
Modified getAnnotationAuditsChronologyByItemIDandUnitID to include datetime parameter
Modified getContentAuditsChronologyByItemIDandUnitID to include datetime parameter
Modified getContentAuditsSummaryByItemIDandUnitID to include datetime parameter
2013-04-08 14:36:44 +00:00
Rich
d2796abac7 Added logic to trigger to allow an unused library document to be deleted. 2013-03-27 17:05:01 +00:00
Rich
49077fccb5 Added logic to keep this script from running in the system databases.
Added warning messages if changes exist to fmtxml or promsfixes.sql.
2013-03-14 20:42:06 +00:00
Rich
07fbc295d1 Added Stored Procedure to sort folders alphabetically
vesp_ResetFolderManualOrderAlphabetical
2013-03-14 14:41:36 +00:00
Rich
d60a7c79b2 Fixed status message 2013-03-14 14:40:57 +00:00
Rich
23b9f54614 Fixed logic to find dashes 2013-03-13 21:47:27 +00:00
Rich
23ad3d8d7b Made a few fixes to the Text Search Function
Created a Stored Procedure to move Procedures, Sections and Steps
Added set files to READ/WRITE if they are READ ONLY.
2013-03-12 14:59:13 +00:00
Rich
4abaceac23 Corrected comment
Added Ordinal to vefn_SiblingItems
Added Stored Procedure vesp_SortProcedures to sort procedures within a DocVersion
Added Error Handler in Range.Text
Corrected logic in FindRO to return a null when an RO is not found.
2013-02-28 15:47:52 +00:00
Rich
767e9762e0 Corrected comment
Added Ordinal to vefn_SiblingItems
2013-02-28 15:46:22 +00:00
Rich
e2797d2e2d Corrected the size of the input variable (List of Procedure Sets) so that all of the requested data sets will be searched 2013-02-20 19:50:26 +00:00
Rich
635b88de4d Exit on SQL script failure
Added error handling to RunScript method
Exit on SQL script failure
Changed vefn_ChronologyReport
Changed how check for prior existence of rofst
2013-02-08 23:47:21 +00:00
Rich
a2d30b72e1 Logic change to get Children in the correct order in the treeview and editor 2013-02-05 23:38:16 +00:00
Rich
676ec9fb30 Revised vefn_getChronology to speed up performance 2013-01-09 20:32:21 +00:00
d02d29f0e1 B2012-371 Fixed the bug with inserting an outside transition – needed stored procedure vefn_ParentItems 2012-12-13 22:54:58 +00:00
Rich
414378e0f3 Fixed logic to support text library documents
A couple more fixes to paste dashes from Adobe
2012-12-06 21:29:55 +00:00
Rich
5302c8a95f Improved getAnnotationAuditsChronologyByItemIDandUnitID execution speed
Improved getContentAuditsChronologyByItemIDandUnitID execution speed
Improved getContentAuditsSummaryByItemIDandUnitID execution speed
2012-12-05 20:57:02 +00:00
Rich
75e4d4767e Fixed code to hanlde empty ProcessOnlyInLocation field. 2012-12-05 12:07:02 +00:00
Rich
55bb5f8c95 Added ProcName attribute with value to History node of ConfigInfo xml
For multi unit data, added Applicability attribute with value to MasterSlave node of ConfigInfo xml
2012-12-04 22:41:01 +00:00
Rich
f7c9dde072 Added ProcName attribute with value to History node of ConfigInfo xml
For multi unit data, added Applicability attribute with value to MasterSlave node of ConfigInfo xml
Added private method AddApplicability to Loader class
Removed blank line
2012-12-04 22:40:30 +00:00
Rich
31d6e47b51 Added the following Stored Procedures to support master slave data
getAnnotationAuditsChronologyByItemIDandUnitID
	getContentAuditsChronologyByItemIDandUnitID
	getContentAuditsSummaryByItemIDandUnitID
	getCurrentRevisionByItemIDandUnitID
	getDocumentByLibDoc
	getRevisionByItemIDandRevisionNumberAndUnitID
	getRevisionsByItemIDandUnitID
	vesp_CanTransitionBeCreated
	vesp_ListItemAndChildrenByUnit
	vesp_WillTransitionsBeValid
Added the following Functions to support master slave data
	ve_GetItemApplicability
	ve_GetItemDerivedApplicability
	ve_GetParentItem
	vefn_CanTransitionBeCreated
	vefn_GetVersionIDByItemID
	vefn_WillTransitionBeValidFrom
	vefn_WillTransitionBeValidTo
2012-12-04 22:39:47 +00:00
Rich
4a7496482a Added ProcName attribute with value to History node of ConfigInfo xml
Added RevDate attribute with value to Procedure node of ConfigInfo xml
Added ReviewDate attribute with value to Procedure node of ConfigInfo xml
Changed how procedure applicability obtained from procedure APL file
For multi unit data added slave node to ConfigInfo xml
For multi unit data added Rev attribute with value, RevDate attribute with value and ReviewDate attribute with value to selected slave node of ConfigInfo xml
2012-12-04 22:38:19 +00:00
Rich
de08f24053 Added code to assure consistent case of node names of xml generated in AddNode method of PrivateProfile class
Added code to assure consistent case of attribute names of xml generated in AddParam method of PrivateProfile class
2012-12-04 22:37:17 +00:00
Rich
cd3e0af534 Added call to AddSlaveUnits method of ConfigInfo class when processing proc.ini file in Loader class
Added private methods AddSlaveUnits, GetUnitNames and GetMasterDir to Loader	class
2012-12-04 22:35:48 +00:00
Rich
7d1f4f4200 Added RevDate and ReviewDate properties to FixItem class
Added applicability and procedureset elements to ConfigFile class when
processing proc.ini file
Added masterdir attribute to ConfigFile class when processing proc.ini file
Replaced direct call to database with CSLA Command object in ClearData method of Loader class
2012-12-04 22:35:07 +00:00
Rich
81a2ad1267 Added public properties MultiUnitCount, Old2NewApple and New2OldApple to Loader class
Added relating slave index to specific unit
2012-12-04 22:33:38 +00:00
Rich
03d49ce2df Changed how Loader class processes 16-bit APL files
Added ReviewDate property to ProcInfo class
Changed how RevDate and ReviewDate values obtained from 16-bit data
Added AddSlaveNode and AddSlaveItem methods to ConfigInfo class
Added validity check to verify Procedure Set Path and Process Only In Location are in synch
2012-12-04 22:32:34 +00:00
Rich
6b959e09cb Fixed logic to eliminate errors when annotation is added 2012-11-16 20:14:51 +00:00
Rich
45fc9edcd3 Added logic to create annotations for transitions to un-numbered steps
Moved code to extension
2012-11-15 16:58:57 +00:00
754d4a8651 use the ordinal step number instead of the step tab if the transition is to a non-numbered step 2012-11-14 19:16:43 +00:00
Rich
77338c048d Added vefn_GetMyChronology user function
Fixed getContentAuditsChronologyByItemID stored procedure
Fixed getContentAuditsSummaryByItemID stored procedure
Fixed getAnnotationAuditsChronologyByItemID stored procedure
2012-11-13 16:08:14 +00:00