+ Reply to Thread
Results 1 to 8 of 8

Thread: NEED Help Designing a Price List

  1. #1
    Junior Member Lava is on a distinguished road
    Join Date
    Jul 2013
    Posts
    21
    Thanks
    1
    Thanked 2 Times in 2 Posts

    NEED Help Designing a Price List

    I'm designing a price list that will need to be updated frequently with a source from either a .xml or .xls containing various items. I need a way to automatically take this list of items create tables with these each set containing various lengths. The number of items per category change over time and it should account for this. Anybody know of a solution to do this? thanks!

  2. #2
    Junior Member Don_Macaroni is on a distinguished road
    Join Date
    Jul 2013
    Posts
    14
    Thanks
    1
    Thanked 3 Times in 3 Posts
    Filemaker PRO would suite your needs. You can import XLS / Excel, either adding data or overwriting the old (or both adding and updating in a single import). Filemaker is great in design and data handling. I use it daily, think of it as the child of Excel and Adobe Illustrator (not that extended of coarse).

    Also, you can consider doing it web-based... MySQL/php would work great...
    Last edited by Don_Macaroni; 07-18-2013 at 12:11 PM.

  3. #3
    Junior Member owenwn is on a distinguished road
    Join Date
    Jul 2013
    Posts
    20
    Thanks
    0
    Thanked 2 Times in 2 Posts
    I was also going to suggest Filemaker Pro. There are plugins out there which will also let InDesign and Filemaker talk directly, so you can have templates that are updated via script from Filemaker.

  4. #4
    Junior Member Lava is on a distinguished road
    Join Date
    Jul 2013
    Posts
    21
    Thanks
    1
    Thanked 2 Times in 2 Posts
    All the data is in a sql database. It contains a lot more information than I would use for a price book, so it kinda seems silly to have another database manager. I will try it though and see if it will meet my needs. Privileges are limited, so the dump out is either an XML or XLS file. Thus I'm really looking for some kind of script to take an excel file and properly flow it into a InDesign File with headings and table styles predefined. Any know of a direct solution?
    Last edited by Lava; 07-19-2013 at 06:48 PM.

  5. #5
    Junior Member Don_Macaroni is on a distinguished road
    Join Date
    Jul 2013
    Posts
    14
    Thanks
    1
    Thanked 3 Times in 3 Posts
    You will love Filemaker... If needed you can have it check the MySQL directly, but an export is easier. Filemaker allows you to do more than basic designing and can generate PDF files. Can even do mass emailing.

  6. #6
    Banned indio will become famous soon enough
    Join Date
    May 2013
    Posts
    41
    Thanks
    310
    Thanked 44 Times in 16 Posts
    yes you will need some basic database knowledge for that job, best approach is using ms office because you already mention xls. you might use ms-access for designing the layout for your price list. You can start with modifying free access template.

  7. #7
    Banned stradivarious is a splendid one to behold stradivarious is a splendid one to behold stradivarious is a splendid one to behold stradivarious is a splendid one to behold stradivarious is a splendid one to behold stradivarious is a splendid one to behold stradivarious is a splendid one to behold
    Join Date
    Dec 2013
    Posts
    905
    Thanks
    532
    Thanked 789 Times in 258 Posts
    could be in excel, it would seem a good idea. Greetings!

  8. #8
    Banned airunxi is on a distinguished road
    Join Date
    Jan 2014
    Posts
    38
    Thanks
    10
    Thanked 21 Times in 21 Posts
    Great! thanks for sharing!

+ Reply to Thread

Similar Threads

  1. Is pitstop worth the price?
    By Clevedemo in forum PDF & Workflow
    Replies: 34
    Last Post: 08-13-2013, 08:04 AM
  2. prinect suprasetter 2010 price help
    By LordAchenk in forum Computer To Plate
    Replies: 2
    Last Post: 02-02-2012, 01:36 AM
  3. Price of artpro v10
    By adilk in forum General Chat
    Replies: 1
    Last Post: 12-01-2011, 01:16 AM

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