Page 1 of 3 123 LastLast
  1.    28 Jan 2017 #1
    Join Date : Jan 2017
    Ohio
    Posts : 13
    Windeow

    Indexing of MANY names for a cemetery book


    Need to create index for hundreds of different names. I know how to mark individual names but cannot find a more simple way to mark literally hundreds of names. Seems there should be a way but I cannot find it.
      My ComputerSystem Spec
  2.    28 Jan 2017 #2
    Join Date : Jul 2015
    Poole Dorset UK
    Posts : 2,559
    Windows 10 x64 Home Version(1709) Build16299.64

    Quote Originally Posted by Leila6300 View Post
    Need to create index for hundreds of different names. I know how to mark individual names but cannot find a more simple way to mark literally hundreds of names. Seems there should be a way but I cannot find it.
    You may not want to do this but how I did it for a friend was
    Create a main folder
    Then made 26 other folders of A-Z
    Then all we did was put all name with A in one right through to Z
    He has been using it now for over a year and so far has had no trouble
    When he wants them he opens main folder then goes to whatever folder he wants and up comes all the names beginning with that letter
      My ComputerSystem Spec
  3.    28 Jan 2017 #3
    Join Date : Jan 2017
    Ohio
    Posts : 13
    Windeow
    Thread Starter

    With over 110K names at currently half complete (over 25 books). the folder option is just too much. Additionally, there will be pagination changes after multiple edits so, this index will need automatic updates, too.

    Was thinking there might be a way using a special font???

    Additionally, this will be a printed book.
      My ComputerSystem Spec
  4.    28 Jan 2017 #4
    Join Date : Jul 2015
    Poole Dorset UK
    Posts : 2,559
    Windows 10 x64 Home Version(1709) Build16299.64

    Quote Originally Posted by Leila6300 View Post
    With over 110K names at currently half complete (over 25 books). the folder option is just too much. Additionally, there will be pagination changes after multiple edits so, this index will need automatic updates, too.

    Was thinking there might be a way using a special font???

    Additionally, this will be a printed book.
    Ok right got you
    His is just sat on his computer and when he needs a print out just goes to whatever names he wants
    Have you looked in Word at all and make like a mailing list
    But what I have put are the only ways I know how to get nearly what you are on about
    Have you looked under People in the App section of Windows 10 as all my contacts have been put in A-Z with their contact details etc
      My ComputerSystem Spec
  5.    28 Jan 2017 #5
    Join Date : Oct 2013
    Newport, South Wales, UK
    Posts : 1,814
    Windows 10 Pro x64 FCU - XP/Vista/Win7/Win8.1 in VM for testing

    If you have access to Office (either a recent MS office or one of the free clones), you should be able to use Excel to create a database of all your data and then use the available data functions of Excel to sort , print and many other options on your data.

    It would ideally be a task for a full blown database Management System such as Access, but Excel has a surprising range of database functionality as standard and then has VBA for writing your own specialist functions if the unlikely case of not being able to do what you need with the defaults.

    Excel can handle a table of 16000+ Fields and 1000000 records so is capable of handling your numbers

    You can also use the database table created to perform a mail merge with Word which could automatically mark any field or set of fields to be indexed
      My ComputerSystem Spec
  6.    28 Jan 2017 #6

    Hi there.

    Even if you DON'T have Office - WPS Office (free version) runs pretty much compatible with EXCEL (although can't run VBA macros).

    However for what you need to do the WPS EXCEL equivalent is fine (and can be read / manipulated with standard Ms EXCEL too.

    People often mention LibreOffice but WPS is much more compatible. (Works in LINUX too for those using Linux).

    The Most Compatible Free Office Suite - WPS Office

    I'd steer WELL CLEAR of ACCESS --it's a horrible DB system, breaks easily and can't handle concurrent usage. Use MySQL or DB MARIA (both free) if you want a decent FAST full blown DB system although this solution might be over the top for what I think you need.

    These Proper DB systems have good security, concurrent access and easily available from the Internet too so remote users can use it. Proper SQL available too for queries - although there are decent GUI's for this stuff as well.

    Look for W.A.M.P projects for Windows or L.A.M.P stuff for Linux (Windows/Linux, Apache MySQL, PHP)
    Good tool also phymyadmin is a great GUI for managing DB and users.

    Plenty of ways to implement -- such as WampServer, la plate-forme de developpement Web sous Windows - Apache, MySQL, PHP

    Link in spite of title is in English !!

    For Linux

    LAMP (Linux, Apache, MySQL, PHP) HOWTO: Installing MySQL and Apache with PHP support on Linux

    Cheers
    jimbo
      My ComputerSystem Spec
  7.    28 Jan 2017 #7
    Join Date : Jan 2017
    Ohio
    Posts : 13
    Windeow
    Thread Starter

    Okay... I appreciate your comments. Let me clarify that these names come from a database and each names contains other information consisting of several lines -- this is not a mailing list but a records of the dead in cemeteries. In order to make the information fit the (to be) printed page, the records are cut and pasted as text into Word and the formatted to be eye-pleasing.

    Sec, Row, Plot, Surname, Given, Maiden, Birth, Death, Age, Military
    Notations
    Example:
    A, 1, 3, Young, George, , 18 Apr 1876, 24 May 1900, 24y,
    2010: d. Pittsburgh PA Cholera.

    For each record's Surname, Given, Maiden I need to have an index which includes page number (which can be updated) with text additions to other parts of the book.

    The page numbers coming out of the database do not reflect the page numbers in the Word document (book).

    Hope this helps.
      My ComputerSystem Spec
  8.    28 Jan 2017 #8
    Join Date : Nov 2015
    Posts : 144
    W10

    It is not fully clear to me what you want with indexing and pagination, but an excellent database programme is Filemaker Pro. It is not free.
      My ComputerSystem Spec
  9.    28 Jan 2017 #9
    Join Date : Jul 2015
    Poole Dorset UK
    Posts : 2,559
    Windows 10 x64 Home Version(1709) Build16299.64

    Quote Originally Posted by Leila6300 View Post
    Okay... I appreciate your comments. Let me clarify that these names come from a database and each names contains other information consisting of several lines -- this is not a mailing list but a records of the dead in cemeteries. In order to make the information fit the (to be) printed page, the records are cut and pasted as text into Word and the formatted to be eye-pleasing.

    Sec, Row, Plot, Surname, Given, Maiden, Birth, Death, Age, Military
    Notations
    Example:
    A, 1, 3, Young, George, , 18 Apr 1876, 24 May 1900, 24y,
    2010: d. Pittsburgh PA Cholera.

    For each record's Surname, Given, Maiden I need to have an index which includes page number (which can be updated) with text additions to other parts of the book.

    The page numbers coming out of the database do not reflect the page numbers in the Word document (book).

    Hope this helps.
    The way you have set it out then Excel will be the one to use
      My ComputerSystem Spec
  10.    28 Jan 2017 #10
    Join Date : Jan 2017
    Ohio
    Posts : 13
    Windeow
    Thread Starter

    Well, like with the manual index marking and creation within Word, I need the LARGE index to automatically update when the pagination changes (when text changes the page numbers in Word AFTER the index has been created.

    I cannot created this LARGE index within Word -- that is what I need to do... If I create it outside of Word, Word does not recognize it to update it.
      My ComputerSystem Spec

 
Page 1 of 3 123 LastLast


Similar Threads
Thread Forum
Google: Mobile-first Indexing
Source: Official Google Webmaster Central Blog: Mobile-first Indexing
Windows 10 News
Indexing not running
While trying to do a search in outlook 2016, i got the notice "something happened and search cannot be executed" or something like that. A quick google led to the indexing service. I launched services.msc and looked at "Windows Search". It's set to...
General Support
Windows 10 Indexing
So i am having issues with searching for programs and files on my computer. At first i thought it just wasnt finding things on my D: drive(storage). But now ive recently installed origin on to my C: drive and i search for it but it does not find...
Performance & Maintenance
Indexing doesn't see files...
I've got a lot of PDF's in my User directory, which according to the Indexing service has been indexed (and it says it's done and has indexed thousands of files). PDF's are set to search file properties only. When I search for any of the PDF's by...
General Support
Search indexing is indexing my D: drive instead of C:
dual boot system 10 on C:, 7 on D: Search indexing insists on indexing drive D: instead of C: No matter how many times I uncheck indexing locations on D: and choose proper locations on C:, when indexing starts to rebuild it reverts back to D: I...
General Support
Our Sites
Site Links
About Us
Windows 10 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 10" and related materials are trademarks of Microsoft Corp.

© Designer Media Ltd
All times are GMT -5. The time now is 12:22.
Find Us
Twitter Facebook Google+ Ten Forums iOS App Ten Forums Android App



Windows 10 Forums