SPSS Statistics

SPSS Statistics

Your hub for statistical analysis, data management, and data documentation. Connect, learn, and share with your peers! 

 View Only
  • 1.  Automating import

    Posted Wed January 15, 2025 09:12 AM

    Process:

    1. I first created a Google from, then linked it with Google Sheets which I linked with Excel which I linked further with SPSS. 
    2. Now i have created a syntax code for importing the excel data, saved it.
    3. Then i created a batch file to open spss and run the syntax editor code to import the excel data.
    4. then I created a task in Windows task scheduler to schedule the importing of data everyday.

    Problem: When i run the batch file code, it only opens the SPSS syntax editor but does not run it.

    Primary objective: To automate the process of real time reponse collection through google forms and eventually real time analysis of data.

    P.S: I still havent added the analysis code, just importing data for now



    ------------------------------
    Aryan Gupta
    ------------------------------


  • 2.  RE: Automating import

    Posted Wed January 15, 2025 09:22 AM
    have you included the spss batch facility step?  you call the .spj file in spss from the batch file not the actual syntax file.  





  • 3.  RE: Automating import

    Posted Wed January 15, 2025 11:25 AM

    i dont know how to do it



    ------------------------------
    Aryan Gupta
    ------------------------------



  • 4.  RE: Automating import

    Posted Wed January 15, 2025 11:33 AM

    for now i just want data editor to open, heres screenshot



    ------------------------------
    Aryan Gupta
    ------------------------------



  • 5.  RE: Automating import

    Posted Wed January 15, 2025 09:40 AM
    To run the code, you can use the Production Facility (Utilities > Production Facility) or directly in your batch file like this
    stats --production filename.spj  


    --





  • 6.  RE: Automating import

    Posted Wed January 15, 2025 11:26 AM

    can u explain, the settings in production facility, what to edit



    ------------------------------
    Aryan Gupta
    ------------------------------



  • 7.  RE: Automating import
    Best Answer

    Posted Wed January 15, 2025 11:51 AM





  • 8.  RE: Automating import

    Posted Wed January 15, 2025 12:23 PM
    Look at the help in the Production Facility dialog box.  As for running production mode, you just add the command I showed to  your batch file.


    --