Freckle CSV import file for accounts with hashtags.

gistfile1.txt

Date,Person,Client/Project,Minutes,Hours,Tags,Description,Billable,Invoiced,Invoice Reference,Paid
2013-08-01,Thomas Fuchs,A new client,480,8.0,meeting,had the first #meeting with our new client,yes,no,,no
2013-06-28,Devon Kreider,Gear GmbH,60,1.0,marketing,#marketing,yes,no,,no
2013-06-27,Devon Kreider,Spannerwerx,60,1.0,"design, phone-call","Finishing the poster #design and made a #phone-call to ""Mary""",yes,no,,no
2013-06-21,Devon Kreider,Ukulele Beach,60,1.0,"WorkingOnMyTanLines, work_sandals",#WorkingOnMyTanLines #work_sandals,yes,no,,no
2013-06-21,Devon Kreider,Ukulele Beach,60,1.0,beach_meeting,#beach_meeting was a success,yes,no,,no
2013-06-21,Devon Kreider,Surf Shop,60,1.0,design,#design,yes,no,,no
2013-06-14,Thomas Cannon,Institute for Awesome,60,1.0,"billing, blog",#billing* #blog,no,no,,no
2013-06-14,Thomas Cannon,Institute for Awesome,90,1.5,billing,#billing*,no,no,,no

Please note:

• The "Hours" field is ignored if the minutes field is given
• You can use , or ; or tab-stops as delimiter characters (or select a delimiter character on importing in the advanced options)
• Strings containing the delimiter character must be wrapped in double quotes
• To escape a double quote character, use ""
• You can use \n or \r\n as line-ends
• We assume UTF-8 character encoding
• In order to properly import CSV files with hashtags intact, the tags in the "Tags" field must match the tags in the description field and be without leading "#" signs. This is to keep compatibility with existing Freckle CSV files and older accounts. We're working on making this more flexible in the future.