webOS Nation Forums >  webOS Developer Forums >  GlitchTech Science > Importing template
Importing template
  Reply
 
Thread Tools Display Modes
Old 05/14/2011, 01:45 PM   #1 (permalink)
Member
 
Posts: 40
I've been plaing with the import function (which I'd like to use in lieu of recurring transactions) but all my transactions come in as "Cleared" and as "Other" in the expense category so I have to pull up each imported transaction and correct them. Is there a way to code the Google doc to fix either of these issues?
cparsons1 is offline   Reply With Quote
Old 05/16/2011, 09:02 AM   #2 (permalink)
Member
 
ryltar's Avatar
 
Posts: 649
For importing, a column called 'cleared' (no quotes) should allow you to set its state. Blank or 'no' or 'not' should set it to not be cleared.

The column 'gtcat' is able to set the category. The current format for that column is 'Main Category|Second Category'. Example 'Income|Paycheck'

At least that is how it is programmed. I haven't tried custom entry into these fields in a few revisions but when I originally built it, those fields work fine.
__________________
Checkbook for webOS-enabled devices
Checkbook HD for webOS-enabled devices

ryltar is offline   Reply With Quote
Old 05/21/2011, 08:43 AM   #3 (permalink)
Member
 
Posts: 40
Ok so your directions for the first row (per the Import menu) of data is account, accountCat, date, amount, description, cleared, note (obviously in columns). Where does 'gtcat' go? I've tried adding it as the end column and tried changing the description to gtcat but in both cases I get the error "Attempting to fix bad import data". Do you have an example of your worksheet that you could make public so we have a good template to start with?

And again, regardless, still love the app!

Thanks!
cparsons1 is offline   Reply With Quote
Old 05/21/2011, 08:52 AM   #4 (permalink)
Member
 
Posts: 40
I'm such a DORK!! I just exported my data so I had all the correct headers and made my own template! That worked fabulously! Thanks again.
cparsons1 is offline   Reply With Quote
Reply

 

Tags
checkbook app, glitchtech

Thread Tools
Display Modes



 


Content Relevant URLs by vBSEO 3.6.0