+ Post New Thread
Results 1 to 4 of 4
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, ...
  1. #1

    Join Date
    Apr 2011
    Posts
    52
    Thank Post
    3
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    Fill blank columns in a report with custom information(constants) - CSV

    Hi,

    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.

  2. #2

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,589
    Thank Post
    638
    Thanked 1,306 Times in 1,088 Posts
    Rep Power
    336
    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.

  3. #3

    Join Date
    Apr 2011
    Posts
    52
    Thank Post
    3
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    Hey,

    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!!!!!

  4. #4

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,589
    Thank Post
    638
    Thanked 1,306 Times in 1,088 Posts
    Rep Power
    336
    Program your macro to open the other file and do the copy pasting for you. Reduce the human factor!

SHARE:
+ Post New Thread

Similar Threads

  1. [SIMS] How can I populate a column in a report with text
    By Nutty85 in forum MIS Systems
    Replies: 6
    Last Post: 23rd June 2012, 08:48 AM
  2. How do I make a page full page without a blank column on left in Joomla?
    By reggiep in forum EduGeek Joomla 1.5 Package
    Replies: 4
    Last Post: 12th November 2010, 09:18 AM
  3. [SIMS] AM7 Show formula column in report
    By philjones2000 in forum MIS Systems
    Replies: 3
    Last Post: 10th November 2010, 08:54 PM
  4. Custom date format in SIMS Report
    By pod in forum MIS Systems
    Replies: 6
    Last Post: 2nd November 2009, 12:37 PM
  5. All in one PC with built in TFT
    By Kyle in forum Hardware
    Replies: 28
    Last Post: 16th May 2006, 11:20 AM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •