• Problem generating documents from SQL database

    Home » Forums » AskWoody support » Productivity software by function » MS Word and word processing help » Problem generating documents from SQL database

    Author
    Topic
    #488751

    Background
    We evaluate testing laboratories against specific criteria to assess their capability of carrying out nominated tests of product for specific properties.

    The organisation must show that they have the capability and capacity (both resources and trained staff) to carry out the nominated tests.

    Generally, our staff evaluate the organisation for capacity. i.e. They have adequate accommodation and management systems documentation in place that should assure they function in a suitable manner. The capability is evaluated by what we term as a “Technical Expert”. These peers that have expertise in the areas that they will be evaluating.

    To support this we have a custom built SQL based CRM package that records the organisation, its contact detail, contacts and its “Scope of Accreditation”. The database also records the date jobs are scheduled, when they were carried out, by whom, how the team was made up, costs and resources used. It also schedules the next job at specified intervals depending on programme type.

    Problem
    When we were using Office 2003 operating in an XP environment we could generate a “Scope” document very easily (these can be up to 40 pages). This requires the database to create a Word document by picking all the information from the database and depositing it in the Word document at specified bookmarks. This was all done in the background allowing staff to carry on with other work. However, now we are using Office 2010 under a Win 7 environment the data extraction is done more in the foreground not allowing staff to do any other work. This made evident when staff noticed that if they were doing cut and paste operations, which they do frequently, they found that some of the information that should have been placed in the “Scope” document was being pasted into the document being worked on.

    What is happening is that the system is using the Windows cut and paste to create the “Scope” document. We are aware that with Office 2010 MS have increased the security around many operations.

    Can anyone tell me if this could be what is affecting our, what should be , simple operation?

    I have attached a 13 page “Scope” document for one of our clients. NOTE: These are public documents and could be obtained by anyone from our website http://www.ianz.govt.nz/directory/ and inputing the right information.

    Viewing 1 reply thread
    Author
    Replies
    • #1387313

      Phil

      Is your issue actually with the speed with which it happens? Or is the issue that you are using windows clipboard (which might wipe what the user had there)?

      I do this sort of stuff with content controls and an embedded xml file nowdays but it isn’t simple to setup initially and involves vba code and free third party tools. This lets the database populate the document quickly and avoids the use of the clipboard. It also allows a data flow in the reverse direction if you update the content in the Word document and want to send that info back to the database.

    • #1387833

      It sounds like issue 1 is related to issue 2.

      Do you have the ability to alter the CRM export method at all or is your only option to look for Word 2010 optional settings which might improve your experience? If your working document is saved as doc format does that perform better than a docx?

      • #1387834

        You are right, we believe they are related.
        No we do not have the ability to change the CRM but we do have a very good relationship with the developers so once we pin the problem down we will ask for a change.
        We have been trough the .doc versus .docx scenario.
        What we have found though, after much testing with various versions of Office and Windows, that there is not a problem generating the documents using Windows XP and Office 2003

    Viewing 1 reply thread
    Reply To: Problem generating documents from SQL database

    You can use BBCodes to format your content.
    Your account can't use all available BBCodes, they will be stripped before saving.

    Your information: