+ Post New Thread
Results 1 to 7 of 7
MIS Systems Thread, Custom date format in SIMS Report in Technical; Is it possible to have a custom date format in a SIMS report? I am exporting a SIMS csv file ...
  1. #1
    pod
    pod is offline

    Join Date
    Feb 2009
    Location
    Belfast
    Posts
    40
    Thank Post
    21
    Thanked 1 Time in 1 Post
    Rep Power
    0

    Custom date format in SIMS Report

    Is it possible to have a custom date format in a SIMS report? I am exporting a SIMS csv file to a mysql database and want to use the standard mysql format yyyy-mm-dd as opposed to the SIMS dd-mm-yyyy.

    Cheers,

    Chris

  2. #2

    Join Date
    Jun 2007
    Location
    London
    Posts
    894
    Thank Post
    64
    Thanked 171 Times in 140 Posts
    Rep Power
    55
    Open your csv report in Excel. Highlight the column containg dates. Right click and choose Format Cells. Choose "Date" (should already be if dates in column). Change Type to 2001-03-14. Save as CSV. Hey presto!

  3. #3
    pod
    pod is offline

    Join Date
    Feb 2009
    Location
    Belfast
    Posts
    40
    Thank Post
    21
    Thanked 1 Time in 1 Post
    Rep Power
    0
    Thanks, but I am trying to automate the process as much as possible, familiar with excel, I'd like SIMS to do the work.

    Chris

  4. #4

    Join Date
    Jun 2007
    Location
    London
    Posts
    894
    Thank Post
    64
    Thanked 171 Times in 140 Posts
    Rep Power
    55
    KB67226 would seem to suggest this isn't possible. You could temporarily change your computer's date format in Regional Settings but this is hardly automation.

  5. #5

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,390
    Thank Post
    368
    Thanked 637 Times in 519 Posts
    Rep Power
    158
    Assuming the file does magically appear in MySQL, can't you just have the import script convert it? What is it? A php file?

  6. #6
    superfletch's Avatar
    Join Date
    Nov 2007
    Location
    South
    Posts
    434
    Thank Post
    146
    Thanked 77 Times in 61 Posts
    Rep Power
    31
    I wanted to do exactly this and found it not to be possible I had to change the date format manually. This may have changed. Doing as timzim said might help but I'm pretty sure that SIMS insists on having the date set in a particular format.

    I also needed the format you describe which was a non standard format for excel as well as SIMS, I needed to tell it the date format in the custom area of format cells.

    I also found that if I reopened the spreadsheet after editting my changes were lost, so once you have the date format set then save the report and upload it before reopening it.


    You could create a Macro in the document the report goes into?
    OR
    Using the SIMSReportExporter (command line util for SIMS Reports) it may be possible to pull the data out with the date setup the way timzim said.


    I have to admit I'm rubbish with Macros and just used format cells.

    EDIT

    Matt 40k posted after I started writing this but that sounds like a good idea.

  7. #7

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,848
    Thank Post
    671
    Thanked 1,383 Times in 1,145 Posts
    Rep Power
    350
    rtf reports allow you to modify date formats, but you wont want an rtf output, unless you bung all data in a table and then access that in a spreadsheet somehow. probably just going to be as much manual manipulation as loading the csv in excel.

SHARE:
+ Post New Thread

Similar Threads

  1. [SIMS] Sims Templates - custom made
    By pooley in forum MIS Systems
    Replies: 11
    Last Post: 21st May 2011, 12:40 PM
  2. Short Date format
    By nwblue in forum MIS Systems
    Replies: 6
    Last Post: 10th December 2009, 11:59 AM
  3. Full time and Date to Unix format
    By danIT in forum Coding
    Replies: 9
    Last Post: 28th June 2009, 11:37 PM
  4. Replies: 8
    Last Post: 15th December 2008, 03:41 PM
  5. Windows XP SP3 change to Date/Time format
    By itwasntme in forum Windows
    Replies: 7
    Last Post: 11th July 2008, 01:18 PM

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
  •