We are looking for a person who would write a small application/executable for us that would build an indesign file from excel file (this will be printed directory, like yellow pages). Here is the information that will be provided:
photo_flag (yes, no), photo_dir_file_name (will provide standard size of photo),Type, Company Name, First Name, Last Name, building#1, street name, suite, city, state, zip, telephone...
You will need to create config file that program will be using, that will contain:
settings per each field (example:
Sort order (for example by type, state, city, name)
number_of_columns in one page
for each field, there would be own style/font based on type. For example: with Type1, last name could be font 12/italic, with Type 2, last name font 9/bold...etc Also, some fields would be converted to UPPER CASE, some to lower, and some Title. This would be in settings by field.
Attached is the small sample of the pages that we are looking to do. Some records will be in English and some in Russian.