PS Query & SQL

Hello –

 I am reaching out to the brilliant minds of the FA community to see if anyone has found a way to save the PSQuery output to an extract file automatically.  I am able to manually download the file to excel, and then save (sftp) the excel file to our app-server.  Then, the extract file is used an input file for several of our customized sqrs.  I am looking for a way to "automate" the manual step of 'Download to Excel'. 

 Any ideas would be greatly appreciated.

 Thank you!

 Patty

Hello –

 I am reaching out to the brilliant minds of the FA community to see if anyone has found a way to save the PSQuery output to an extract file automatically.  I am able to manually download the file to excel, and then save (sftp) the excel file to our app-server.  Then, the extract file is used an input file for several of our customized sqrs.  I am looking for a way to "automate" the manual step of 'Download to Excel'. 

 Any ideas would be greatly appreciated.

 Thank you!

 Patty

Hey Patty - as a follow-up to Dan, I am attaching a document that I created for our users earlier this year.  It details how to schedule a query, and run it to email or to a file.  

Several notes:

• You will need to make sure that your instance of PS can write to the directory that from which your process will read it.  (It sounds as if you already have this piece taken care of, but I wanted to mention it.) 
• Since you can email a file to BOX, you can schedule a query to be set to a specific BOX directory.  
• Make sure you write the file as a TEXT file type.  That will produce a .CSV file, with no Summary row (above the Header row) in the file. 
• Finally, the most difficult part with this process is that the file name produced by these scheduled queries is always a unique name, since it writes the Process Instance into the file name.  This makes scheduling a process to consume this file a little more difficult.  You will need to create some sort of script/process to strip the delete the older file, and then rename the new file to the standard you want.  

Good Luck! 

Hello –

 I am reaching out to the brilliant minds of the FA community to see if anyone has found a way to save the PSQuery output to an extract file automatically.  I am able to manually download the file to excel, and then save (sftp) the excel file to our app-server.  Then, the extract file is used an input file for several of our customized sqrs.  I am looking for a way to "automate" the manual step of 'Download to Excel'. 

 Any ideas would be greatly appreciated.

 Thank you!

 Patty

Hey Patty - as a follow-up to Dan, I am attaching a document that I created for our users earlier this year.  It details how to schedule a query, and run it to email or to a file.  

Several notes:

• You will need to make sure that your instance of PS can write to the directory that from which your process will read it.  (It sounds as if you already have this piece taken care of, but I wanted to mention it.) 
• Since you can email a file to BOX, you can schedule a query to be set to a specific BOX directory.  
• Make sure you write the file as a TEXT file type.  That will produce a .CSV file, with no Summary row (above the Header row) in the file. 
• Finally, the most difficult part with this process is that the file name produced by these scheduled queries is always a unique name, since it writes the Process Instance into the file name.  This makes scheduling a process to consume this file a little more difficult.  You will need to create some sort of script/process to strip the delete the older file, and then rename the new file to the standard you want.  

Good Luck! 

Hello –

 I am reaching out to the brilliant minds of the FA community to see if anyone has found a way to save the PSQuery output to an extract file automatically.  I am able to manually download the file to excel, and then save (sftp) the excel file to our app-server.  Then, the extract file is used an input file for several of our customized sqrs.  I am looking for a way to "automate" the manual step of 'Download to Excel'. 

 Any ideas would be greatly appreciated.

 Thank you!

 Patty

Hey Patty - as a follow-up to Dan, I am attaching a document that I created for our users earlier this year.  It details how to schedule a query, and run it to email or to a file.  

Several notes:

• You will need to make sure that your instance of PS can write to the directory that from which your process will read it.  (It sounds as if you already have this piece taken care of, but I wanted to mention it.) 
• Since you can email a file to BOX, you can schedule a query to be set to a specific BOX directory.  
• Make sure you write the file as a TEXT file type.  That will produce a .CSV file, with no Summary row (above the Header row) in the file. 
• Finally, the most difficult part with this process is that the file name produced by these scheduled queries is always a unique name, since it writes the Process Instance into the file name.  This makes scheduling a process to consume this file a little more difficult.  You will need to create some sort of script/process to strip the delete the older file, and then rename the new file to the standard you want.  

Good Luck! 

Hello –

 I am reaching out to the brilliant minds of the FA community to see if anyone has found a way to save the PSQuery output to an extract file automatically.  I am able to manually download the file to excel, and then save (sftp) the excel file to our app-server.  Then, the extract file is used an input file for several of our customized sqrs.  I am looking for a way to "automate" the manual step of 'Download to Excel'. 

 Any ideas would be greatly appreciated.

 Thank you!

 Patty

Hey Patty - as a follow-up to Dan, I am attaching a document that I created for our users earlier this year.  It details how to schedule a query, and run it to email or to a file.  

Several notes:

• You will need to make sure that your instance of PS can write to the directory that from which your process will read it.  (It sounds as if you already have this piece taken care of, but I wanted to mention it.) 
• Since you can email a file to BOX, you can schedule a query to be set to a specific BOX directory.  
• Make sure you write the file as a TEXT file type.  That will produce a .CSV file, with no Summary row (above the Header row) in the file. 
• Finally, the most difficult part with this process is that the file name produced by these scheduled queries is always a unique name, since it writes the Process Instance into the file name.  This makes scheduling a process to consume this file a little more difficult.  You will need to create some sort of script/process to strip the delete the older file, and then rename the new file to the standard you want.  

Good Luck! 

Hello –

 I am reaching out to the brilliant minds of the FA community to see if anyone has found a way to save the PSQuery output to an extract file automatically.  I am able to manually download the file to excel, and then save (sftp) the excel file to our app-server.  Then, the extract file is used an input file for several of our customized sqrs.  I am looking for a way to "automate" the manual step of 'Download to Excel'. 

 Any ideas would be greatly appreciated.

 Thank you!

 Patty

Hey Patty - as a follow-up to Dan, I am attaching a document that I created for our users earlier this year.  It details how to schedule a query, and run it to email or to a file.  

Several notes:

• You will need to make sure that your instance of PS can write to the directory that from which your process will read it.  (It sounds as if you already have this piece taken care of, but I wanted to mention it.) 
• Since you can email a file to BOX, you can schedule a query to be set to a specific BOX directory.  
• Make sure you write the file as a TEXT file type.  That will produce a .CSV file, with no Summary row (above the Header row) in the file. 
• Finally, the most difficult part with this process is that the file name produced by these scheduled queries is always a unique name, since it writes the Process Instance into the file name.  This makes scheduling a process to consume this file a little more difficult.  You will need to create some sort of script/process to strip the delete the older file, and then rename the new file to the standard you want.  

Good Luck! 

Hello –

 I am reaching out to the brilliant minds of the FA community to see if anyone has found a way to save the PSQuery output to an extract file automatically.  I am able to manually download the file to excel, and then save (sftp) the excel file to our app-server.  Then, the extract file is used an input file for several of our customized sqrs.  I am looking for a way to "automate" the manual step of 'Download to Excel'. 

 Any ideas would be greatly appreciated.

 Thank you!

 Patty

Hey Patty - as a follow-up to Dan, I am attaching a document that I created for our users earlier this year.  It details how to schedule a query, and run it to email or to a file.  

Several notes:

• You will need to make sure that your instance of PS can write to the directory that from which your process will read it.  (It sounds as if you already have this piece taken care of, but I wanted to mention it.) 
• Since you can email a file to BOX, you can schedule a query to be set to a specific BOX directory.  
• Make sure you write the file as a TEXT file type.  That will produce a .CSV file, with no Summary row (above the Header row) in the file. 
• Finally, the most difficult part with this process is that the file name produced by these scheduled queries is always a unique name, since it writes the Process Instance into the file name.  This makes scheduling a process to consume this file a little more difficult.  You will need to create some sort of script/process to strip the delete the older file, and then rename the new file to the standard you want.  

Good Luck! 

Hello –

 I am reaching out to the brilliant minds of the FA community to see if anyone has found a way to save the PSQuery output to an extract file automatically.  I am able to manually download the file to excel, and then save (sftp) the excel file to our app-server.  Then, the extract file is used an input file for several of our customized sqrs.  I am looking for a way to "automate" the manual step of 'Download to Excel'. 

 Any ideas would be greatly appreciated.

 Thank you!

 Patty