Saving a CSV with the following format in iPhone application -


in application have simple logbook user can save simple posts event. format this:

date, duration(seconds), distance(km), comment , categories variable number between 0 - 4 , circumstances/conditions variable number between 0 - 4

an example be:

header of csv file
date,duration,distance,comment
then multiple rows this
07.02.11,7800,300,"a comment"
07.02.11,7800,300,"a comment"
07.02.11,7800,300,"a comment"

but how can add categories , conditions format , how know in categories/conditions end in csv if @ later point in application want import file again?

(i not need how save etc file, done that, need guidiance on how format it, thank you)

(this seems pretty odd)

header of csv file
date,duration,distance,comment, category, category, category, category, condition, condition, condition, condition
then multiple rows this
07.02.11,7800,300,"a comment", "categoryname", "categoryname", "categoryname","categoryname", "condtion", "condition", "condtion", "condition"

(would better)

header of csv file
date,duration,distance,comment, category, condition then multiple rows this
07.02.11,7800,300,"a comment", "multiple category names separted -", "multiple condition names separted -"

i think last proposal of separating conditions or categories using special separator symbol (the hyphen in example) right one. way suggest 2 things:

  1. use less common separator, can forbid user use without limiting user choice; hyphen character don't want forbid, use different sequence such 3 pipes: ||| not common.

  2. if possible (but careful in case final destination of csv file) can avoid using standard "comma separator". reason if comma used inside fields content, content must separated double quotes. time problematic if need custom parsing other software. when know csv not used source import other software (e.g. numbers or excel) prefer use different separator, e.g. sequence of 2 hash (##) or more "strange". note in case no more strict-csv compliant! there software, openoffice, more flexible special formats.


Comments

Post a Comment

Popular posts from this blog

c# - SharpSVN - How to get the previous revision? -

i trying find efficient way previous revision of file text comparison using sharpsvn. using (svnclient c = new svnclient()) { c.authentication.defaultcredentials = new networkcredential( configurationmanager.appsettings.get("svnserviceusername") , configurationmanager.appsettings.get("svnservicepassword") , configurationmanager.appsettings.get("svnservicedomain") ); c.authentication.sslservertrusthandlers += new eventhandler<svnsslservertrusteventargs>(authentication_sslservertrusthandlers); collection<svnfileversioneventargs> fileversioncollection = new collection<svnfileversioneventargs>(); svnrevisionrange range = new svnrevisionrange(0, this.hooks.revision); svnfileversionsargs args = new svnfileversionsargs(); args.retrieveproperties = true; args.range = range; foreach (svnchangeitem item in log.changedpaths) { string path = this.repositorypath + it...
Read more

c++ - Is it possible to compile a VST on linux? -

for class project i'm attempting write vst plugin backed cuda. current cuda workflow on linux box, i'd prefer compile , link there. according wikipedia , should possible (i couldn't find steinberg documentation relevant linux) can't find makefile or instructions on how build if aren't using xcode or visual studio. i'm vst 3 sdk doesn't support linux. when try compile plugin under linux, error: ./base/source/fatomic.cpp:39:30: fatal error: libkern/osatomic.h: no such file or directory this issue caused following code in "vst3 sdk/base/source/fatomic.cpp" #if mac #include <libkern/osatomic.h> #if mac_os_x_version_min_required > mac_os_x_version_10_4 #define native_atomic_type (volatile int32_t*) #else #define native_atomic_type (int32_t*) #endif #elif windows #include <windows.h> #endif but hope compiling under linux work vst sdk 2.4. reading. jvstwrapper seems run on lin...
Read more

url - Querystring manipulation of email Address in PHP -

i using third party application (email2http) send me emailid, body , message. unable retrieve email id due name appended on , enclosed < , >. here querystring getting. test.php?from=ajay+reddy &subject=cx&body=somebody when print variable in php returns name , not email id. $from = $_get['from']; echo $from; //output ajay reddy please suggest me how can emailid also. i dont want use post method due testing , debugging. it's working fine. forgot use htmlentities() in debugging.
Read more