I don't have their record number in Quickbooks, unfortunately. So after
getting the info into Excel, I was simply going to add a field for their
ebase record#, obtain this number from ebase and then manually go through
and plug these into the spreadsheet....cumbersome, but not impossible with
the number of payments I think we will have. Once it's done, we will then
change our internal procedures to route all payments received through ebase
FIRST!
> From: "Walt Daniels" <[EMAIL PROTECTED]>
> Reply-To: "TechRocks Support" <[EMAIL PROTECTED]>
> Date: Wed, 11 Jul 2001 10:34:14 -0400
> To: "TechRocks Support" <[EMAIL PROTECTED]>
> Subject: [support] RE: QBPro 2001 Data Export
>
> How are you going to link the payments to the people in ebase? Do you have
> their record number in QuickBooks? That would be most reliable.
>
> My guess is that the flat file will be easier to deal with than excel.
Thanks Walt. I'll play around with the ASCII file some more too.
>> -----Original Message-----
>> From: Colin Cooler [mailto:[EMAIL PROTECTED]]
>> Sent: Wednesday, July 11, 2001 10:13 AM
>> To: TechRocks Support
>> Subject: [support] QBPro 2001 Data Export
>>
>>
>>
>> Our organization just upgraded to QuickBooks Pro 2001 (from an earlier
>> version). The latest version lets you produce a report from which you can
>> export transaction data (such as checks received) to either an Excel
>> spreadsheet or an ASCII text file.
>>
>> I'd like to import this historical payment data from Excel into
>> the Payments
>> file. Unfortunately, the Excel file that results has all the
>> fields placed
>> in a single cell within the spreadsheet and quotes around each field data
>> within that cell. (Don't you just know Intuit deliberately made this
>> difficult!)
>>
>> Is there any way to strip out the quotes and place each field in
>> a separate
>> cell (column) so that I can import this directly into ebase?
>>
>> If necessary, I could wrestle with "IIF" format (but I know
>> nothing about it
>> at this point or how to get more detailed info on it).
>>
>> TIA
>>
>>
>> ------------------
>> Reminder to each recipient: To change your list account preferences, go to
>> http://email.sparklist.com/scripts/lyris.pl?enter=support and
>> enter the email address you used to subscribe to the ebase
>> support list:: [EMAIL PROTECTED]
>>
>> To unsubscribe send a blank email to [EMAIL PROTECTED]
>> ---------------------------------------------------------------------
>> ebase - Relationship Management for Nonprofits, http://www.ebase.org
>> ---------------------------------------------------------------------
>>
>>
>
>
> ------------------
> Reminder to each recipient: To change your list account preferences, go to
> http://email.sparklist.com/scripts/lyris.pl?enter=support and enter the email
> address you used to subscribe to the ebase support list::
> [EMAIL PROTECTED]
>
> To unsubscribe send a blank email to [EMAIL PROTECTED]
> ---------------------------------------------------------------------
> ebase - Relationship Management for Nonprofits, http://www.ebase.org
> ---------------------------------------------------------------------
>
------------------
Reminder to each recipient: To change your list account preferences, go to
http://email.sparklist.com/scripts/lyris.pl?enter=support and enter the email address
you used to subscribe to the ebase support list:: [email protected]
To unsubscribe send a blank email to [EMAIL PROTECTED]
---------------------------------------------------------------------
ebase - Relationship Management for Nonprofits, http://www.ebase.org
---------------------------------------------------------------------
