Advertisements
Aquatic Avenue Banner Tropica Shop Banner Fishy Business Banner
Results 1 to 16 of 16

Thread: Volunteers Needed: Move Fish Shop Directory Data

  1. #1
    Join Date
    Dec 2001
    Location
    Singapore, Singapore, Singapore
    Posts
    8,958
    Feedback Score
    1 (100%)
    Images
    104
    Country
    Singapore

    Volunteers Needed: Move Fish Shop Directory Data

    Advertisements
    Fresh n Marine aQuarium Banner

    Advertise here

    Advertise here
    Dear AQ members,

    I need some help entering fish shop data for use in the new fish shop directory.

    The Task
    Browse through our existing Fish Shop Directory Forum and copy the data into a spread sheet.

    I have divided our fish shop list into groups of about 8 to 12 entries:
    1. North East (A-F)
    2. North East (G-Z) (ZackZhou is doing.)
    3. South (Done Thanks to Shadow.)
    4. East (A-K) (Done. Thanks to Bossteck.)
    5. East (L-Z) (Done. Thanks to Bossteck.)
    6. West (A-O) (Done. Thanks to Tiintinn.)
    7. West (P-Z) (Done. Thanks to Tiintinn.)
    (I've already done the North category while developing.)

    Instructions
    1. Pick one (or more) of the groups above. (Check replies below to see which has been taken)
    2. Reply to this thread and state which group you picked.
    3. Download the Excel sheet from: http://dl.dropbox.com/u/7993331/AQ/aqfsd_fishshops.xlsx
    4. Go through the relevant entries in the Fish Shop Directory and copy the data into the columns in the Spreadsheet. (See Column Details below for specific instructions about certain columns).
    5. Email the file to admin at aquaticquotient dot com, or upload somewhere that I can download from and drop the link here.

    Column Details (See the North sheet for example.)
    streetNo: Don't include words like "Blk", "No". Just the number.

    streetName: Please spell out words like "Road" and "Avenue" in full. Avoid "Rd" "Ave", etc.

    city: Leave it blank.

    altNames: Any alternate name that is used in the forum. Usually already include in the current Fish Shop Directory entry in brackets next to their real shop name. Separate with commas.

    aqUserName: The shops username in the forum, if any. E.g. Biotope used to be Biotopeshop. (If unsure, leave blank.)

    type: Select from the drop down list only. Please do NOT type your own. Choose Farm if they actually breed livestock or grow plants. If they occupy farm land, but only Import and Export, choose Importer/Exporter.

    remarks: Paste the Opening Hours only. Leave out the other remarks for now.

    lat & lng: Go to http://gmaps-samples-v3.googlecode.c...oder-tool.html to get the values. Download http://dl.dropbox.com/u/7993331/AQ/G...der%20Tool.pdf for instructions to use it. There should be some yellow sticky notes in the PDF file with instructions. If you don't see any, let me know.

    categories: Select or type "Y" (Capital) if the shop has those products or services. There can be more then one "Y" for each fish shop. If you don't know for sure, just put down what you know.

    Thank you.
    Last edited by vinz; 3rd May 2011 at 23:17.
    Vincent - AQ is for everyone, but not for 'u' and 'mi'.
    Why use punctuation? See what a difference it makes:
    A woman, without her man, is nothing.
    A woman: without her, man is nothing.

  2. #2
    Join Date
    Jul 2002
    Location
    Old Airport Road
    Posts
    1,890
    Feedback Score
    0
    Images
    67
    Country
    Singapore

    Re: Volunteers Needed: Move FIsh Shop Directory Data

    Hi Vincent,

    I can do 4. East (A-K) and 5. East (L-Z)
    - eric

  3. #3
    Join Date
    Dec 2001
    Location
    Singapore, Singapore, Singapore
    Posts
    8,958
    Feedback Score
    1 (100%)
    Images
    104
    Country
    Singapore

    Re: Volunteers Needed: Move FIsh Shop Directory Data

    Thanks Eric.

    Anyone else can help?
    Vincent - AQ is for everyone, but not for 'u' and 'mi'.
    Why use punctuation? See what a difference it makes:
    A woman, without her man, is nothing.
    A woman: without her, man is nothing.

  4. #4
    Join Date
    Jul 2006
    Location
    Telok Blangah, SGP
    Posts
    10,216
    Feedback Score
    3 (100%)
    Images
    78
    Country
    Singapore

    Re: Volunteers Needed: Move FIsh Shop Directory Data

    I can do south, since I'm staying at south
    -Robert
    Aquascaping is a marriage between Art and Farming
    My Blog: http://aquatic-art.blogspot.com/

  5. #5
    Join Date
    Dec 2010
    Location
    Ang Mo Kio
    Posts
    917
    Feedback Score
    17 (90%)
    Country
    Singapore

    Re: Volunteers Needed: Move FIsh Shop Directory Data

    vinz, so north done already or not? if undone i will do North(g-z). If done, i'll do west (a-o)

  6. #6
    Join Date
    Dec 2010
    Location
    Ang Mo Kio
    Posts
    917
    Feedback Score
    17 (90%)
    Country
    Singapore

    Re: Volunteers Needed: Move FIsh Shop Directory Data

    haha, just opened the spreadsheet, so northeast (g-z) is undone, thus i'll do that

  7. #7
    Join Date
    Dec 2001
    Location
    Singapore, Singapore, Singapore
    Posts
    8,958
    Feedback Score
    1 (100%)
    Images
    104
    Country
    Singapore

    Re: Volunteers Needed: Move FIsh Shop Directory Data

    Thanks, Robert.

    Thanks, Zack.

    P.S. The spreadsheet is NOT an indicator of what is done as it is the unfilled one. Those that are done (like East by Bossteck) are not updated into the online file.
    Vincent - AQ is for everyone, but not for 'u' and 'mi'.
    Why use punctuation? See what a difference it makes:
    A woman, without her man, is nothing.
    A woman: without her, man is nothing.

  8. #8
    Join Date
    Dec 2010
    Location
    Ang Mo Kio
    Posts
    917
    Feedback Score
    17 (90%)
    Country
    Singapore

    Re: Volunteers Needed: Move FIsh Shop Directory Data

    Can I add new fish shop into it? Like JZXboutique?

  9. #9
    Join Date
    Dec 2001
    Location
    Singapore, Singapore, Singapore
    Posts
    8,958
    Feedback Score
    1 (100%)
    Images
    104
    Country
    Singapore

    Re: Volunteers Needed: Move FIsh Shop Directory Data

    Zack,

    Yes, please do.
    Vincent - AQ is for everyone, but not for 'u' and 'mi'.
    Why use punctuation? See what a difference it makes:
    A woman, without her man, is nothing.
    A woman: without her, man is nothing.

  10. #10
    Join Date
    May 2008
    Posts
    213
    Feedback Score
    1 (100%)
    Images
    4
    Country
    Singapore

    Re: Volunteers Needed: Move FIsh Shop Directory Data

    can do west too ")

  11. #11
    Join Date
    Dec 2001
    Location
    Singapore, Singapore, Singapore
    Posts
    8,958
    Feedback Score
    1 (100%)
    Images
    104
    Country
    Singapore

    Re: Volunteers Needed: Move FIsh Shop Directory Data

    Great. Thanks Tiintinn.
    Vincent - AQ is for everyone, but not for 'u' and 'mi'.
    Why use punctuation? See what a difference it makes:
    A woman, without her man, is nothing.
    A woman: without her, man is nothing.

  12. #12
    Join Date
    Dec 2001
    Location
    Singapore, Singapore, Singapore
    Posts
    8,958
    Feedback Score
    1 (100%)
    Images
    104
    Country
    Singapore

    Re: Volunteers Needed: Move FIsh Shop Directory Data

    Tiintinn,

    Doing both West? Or just one of them?
    Vincent - AQ is for everyone, but not for 'u' and 'mi'.
    Why use punctuation? See what a difference it makes:
    A woman, without her man, is nothing.
    A woman: without her, man is nothing.

  13. #13
    Join Date
    May 2008
    Posts
    213
    Feedback Score
    1 (100%)
    Images
    4
    Country
    Singapore

    Re: Volunteers Needed: Move FIsh Shop Directory Data

    hey Vinz, can do the whole west. ")

  14. #14
    Join Date
    Dec 2010
    Location
    Ang Mo Kio
    Posts
    917
    Feedback Score
    17 (90%)
    Country
    Singapore

    Re: Volunteers Needed: Move FIsh Shop Directory Data

    vinz, when i think of it. JZXboutique is located in the north and not north-east if i'm not wrong. nearest mrt is AMK, which is in the range of mrt from woodlands to novena

  15. #15
    Join Date
    Dec 2001
    Location
    Singapore, Singapore, Singapore
    Posts
    8,958
    Feedback Score
    1 (100%)
    Images
    104
    Country
    Singapore

    Re: Volunteers Needed: Move FIsh Shop Directory Data

    Zack,

    Put it in anyway. The new Fish Shop directory will not be using the regional classification. I'm using it in this exercise to divide up the list into manageable chunks.
    Vincent - AQ is for everyone, but not for 'u' and 'mi'.
    Why use punctuation? See what a difference it makes:
    A woman, without her man, is nothing.
    A woman: without her, man is nothing.

  16. #16
    Join Date
    Dec 2010
    Location
    Ang Mo Kio
    Posts
    917
    Feedback Score
    17 (90%)
    Country
    Singapore

    Re: Volunteers Needed: Move FIsh Shop Directory Data

    Roger that

Bookmarks

Posting Permissions

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