MIS Systems Thread, Fill blank columns in a report with custom information(constants) - CSV in Technical; Hi,
I was wondering if someone can help me. I've just been asked to make another report, a CSV file, ...
30th May 2013, 03:49 PM #1
- Rep Power
Fill blank columns in a report with custom information(constants) - CSV
I was wondering if someone can help me. I've just been asked to make another report, a CSV file, containing account information such as sort code, account number etc. This is going to be used to set up direct debits with our bank.
The csv file needs to have roughly 30 columns per person, but only 4 or 5 of these are pieces of information from SIMS, the rest are constants that will not change. I can create the report and add in blank columns which will then allow me to export to excel and fill in the information but I was wondering if there is any way to do this within SIMS by setting a value for each blank column so that the accounts department can just upload the file without any manipulation of the data?
Thanks in advance.
2nd June 2013, 10:10 AM #2
You could make aspects in assessment manager and fill the data in their. We've done that before, but it's better for student information, plus you don't really want certain info, possibly private, being accessible to all with assessment manager rights.
How often does it need to be run, can't you just set the blank columns and paste the data in.
You could do a complex Excel report, with a macro that adds the info in from another sheet / file at run time.
3rd June 2013, 08:58 PM #3
- Rep Power
What I set up was a report that just pulled out the information that was required from SIMS and I wrote a macro that converted the data into the right format and created the csv file. The problem is that it requires someone to cut and paste from one excel spreadsheet to another. That can be a major task for some people!!!!!
3rd June 2013, 09:10 PM #4
Program your macro to open the other file and do the copy pasting for you. Reduce the human factor!
By Nutty85 in forum MIS Systems
Last Post: 23rd June 2012, 08:48 AM
By reggiep in forum EduGeek Joomla 1.5 Package
Last Post: 12th November 2010, 09:18 AM
By philjones2000 in forum MIS Systems
Last Post: 10th November 2010, 08:54 PM
By pod in forum MIS Systems
Last Post: 2nd November 2009, 12:37 PM
By Kyle in forum Hardware
Last Post: 16th May 2006, 11:20 AM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)