User Tag List

Page 2 of 4 FirstFirst 1 2 3 4 LastLast
Results 11 to 20 of 31

Thread: Creating an Array Editor

  1. #11
    Clicker Fusion 2.5 Developer

    Join Date
    Jul 2008
    Posts
    1,302
    Mentioned
    13 Post(s)
    Tagged
    0 Thread(s)
    No worries
    If you let me know exactly what modifications you need, I can probably do them for you.
    eg. It needs to be a text array not a numerical array. At the moment you can't revert to the original order after sorting. Also, the CSV import/export is a bit lazy as I just used tokenizing instead of checking for quotes (so it won't work if the data values contain commas).
    Will the arrays contain numerical values as well as text? If so, will they be limited to specific columns? And if so, which column(s)? Also, will they always be integers, or is it possible there will be decimals as well? What about negative values? Sorting is pretty awkward when you have all those mixed together...
    And you mentioned a search function in your original post - exactly how would that work? What would the interface look like? Does it search the entire array for a specific string, or only a specific column, or is it more complicated than that? Presumably you need a "find next" option?
    Anything else you need?
    The more details you can give, the better - even if they seem like really trivial things.

  2. #12
    Clicker

    Fusion 2.5 DeveloperFusion 2.5+ DLCAndroid Export ModuleHTML5 Export ModuleiOS Export ModuleUniversal Windows Platform Export ModuleSWF Export ModuleXNA Export ModuleInstall Creator Pro
    nivram's Avatar
    Join Date
    Jul 2006
    Location
    Bandon, Oregon
    Posts
    6,725
    Mentioned
    9 Post(s)
    Tagged
    0 Thread(s)
    Hi MuddyMole. Just wanted to say thanks for the example and your good work on it.

    Marv
    ​458 TGF to CTF 2.5+ Examples and games
    http://www.castles-of-britain.com/mmf2examples.htm

  3. #13
    Clicker Fusion 2.5
    Fusion 2.5 (Steam)Fusion 2.5 Developer (Steam)Android Export Module (Steam)HTML5 Export Module (Steam)iOS Export Module (Steam)Universal Windows Platform Export Module (Steam)

    Join Date
    Oct 2006
    Location
    In a Dark room with only a lamp
    Posts
    367
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    you have given me so much already i am blown away.

    Ideally, this would be what I want, if you feel inclined to do it:

    Ability to import a text array with the following fields:

    Forename, Surname, 1st Line of Address, Postcode, Number of Visits, Date of Last Visit
    Ability to sort any column (ascending or descending)
    Export to CSV (don't need to import it)
    Search for a given piece of text in any column and jump to that cell

    That would be the perfect example of what i'm looking for.

    Thanks again for all this!

  4. #14
    Clicker Fusion 2.5 Developer

    Join Date
    Jul 2008
    Posts
    1,302
    Mentioned
    13 Post(s)
    Tagged
    0 Thread(s)
    That all sounds like it should be fairly straightforward - I'll see how I get on with it tomorrow...

    Just a couple of things:
    * How are the dates formatted? DD/MM/YYYY? MM/DD/YYYY? Other? (need to know this to be able to sort them properly - I presume you want them sorted in chronological rather than numerical/alphabetical order?)
    * Should addresses be sorted in numerical (rather than alphabetical) order if they start with a number? eg. "10 Main Street" comes after "9 Main Street" ?

    @Nivram - Thanks, always happy to help (well, usually...)

  5. #15
    Clicker Fusion 2.5
    Fusion 2.5 (Steam)Fusion 2.5 Developer (Steam)Android Export Module (Steam)HTML5 Export Module (Steam)iOS Export Module (Steam)Universal Windows Platform Export Module (Steam)

    Join Date
    Oct 2006
    Location
    In a Dark room with only a lamp
    Posts
    367
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Dates are DD/MM/YYYY with chronological sorting yes.

    Addresses should be sorted numerical.

    I had attached a copy of an older database however considering the data inside it, it probably isn't a good idea

    Thanks again

  6. #16
    Clicker Fusion 2.5 Developer

    Join Date
    Jul 2008
    Posts
    1,302
    Mentioned
    13 Post(s)
    Tagged
    0 Thread(s)
    Yeah, definitely not a good idea to post people's personal details.
    I think I made a slight mistake... I think I got X and Y backwards - presumably X=the person; Y=the property (must remember to transpose data when saving a csv in Excel...)

  7. #17
    Clicker Fusion 2.5
    Fusion 2.5 (Steam)Fusion 2.5 Developer (Steam)Android Export Module (Steam)HTML5 Export Module (Steam)iOS Export Module (Steam)Universal Windows Platform Export Module (Steam)

    Join Date
    Oct 2006
    Location
    In a Dark room with only a lamp
    Posts
    367
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Yeah, that's right. I actually attached it and then realised that it contained some people's data.

    Don't rush with this. If you need to do something else then that's fine.

    Thanks again for all your help

  8. #18
    Clicker Fusion 2.5 Developer

    Join Date
    Jul 2008
    Posts
    1,302
    Mentioned
    13 Post(s)
    Tagged
    0 Thread(s)
    I made a small array for testing purposes anyway - mostly just using randomized values.

    Does this look about right?
    egarray.jpg

    I'll probably be done later tonight, but if not then tomorrow. The actual amount of code required shouldn't be that much.

  9. #19
    Clicker Fusion 2.5
    Fusion 2.5 (Steam)Fusion 2.5 Developer (Steam)Android Export Module (Steam)HTML5 Export Module (Steam)iOS Export Module (Steam)Universal Windows Platform Export Module (Steam)

    Join Date
    Oct 2006
    Location
    In a Dark room with only a lamp
    Posts
    367
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Perfect and again it looks far better than anything i could have done. Thanks very much for all your help.

    Just one more quick question. Would it be possible to revert back to the original layout after it has been sorted? If it is a PITA to do then it's fine.

  10. #20
    Clicker Fusion 2.5 Developer

    Join Date
    Jul 2008
    Posts
    1,302
    Mentioned
    13 Post(s)
    Tagged
    0 Thread(s)
    Yeah, that's already taken care of (I saw you mentioned it in a previous post)

Page 2 of 4 FirstFirst 1 2 3 4 LastLast

Similar Threads

  1. Data Array viewer/editor for testing
    By DaveC in forum Multimedia Fusion 2 - Technical Support
    Replies: 4
    Last Post: 29th April 2012, 03:12 PM
  2. Creating a code editor?
    By JGooler in forum Multimedia Fusion 2 - Technical Support
    Replies: 4
    Last Post: 12th December 2009, 10:23 AM
  3. Array Viewer & Editor
    By wizkidweb in forum File Archive
    Replies: 0
    Last Post: 5th September 2009, 05:48 AM
  4. Array Level Editor
    By DJ_Wild in forum File Archive
    Replies: 14
    Last Post: 30th September 2007, 03:59 PM

Posting Permissions

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