Re: [WebDNA] Integration with QuickBooks

This WebDNA talk-list message is from

2011


It keeps the original formatting.
numero = 107070
interpreted = N
texte = --Apple-Mail=_0FA749F0-2F12-43F8-BA6F-D9DCE422406F Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=iso-8859-1 You can export/save as an xls file as a tab-delimited txt file with = excel On Jul 26, 2011, at 10:04 PM, Stuart Tremain wrote: > You can "read" a csv file but you can not read an xls file. >=20 > Reading a csv file will involve doing a bit of cleaning and a bit of = fiddling to get the contents into a .db or [TABLE]. >=20 >=20 > If you write the .csv file to the server and then [INCLUDE] it. This = is the best place to start to understand what you are getting from the = file and the best way to attack it. >=20 >=20 > On 27/07/2011, at 11:55 AM, sgbc cebu wrote: >=20 >> Hi, >>=20 >> Is there a way to remove WebDNA's restrictions of reading an xls or = csv database file. >>=20 >> Thanks >>=20 >> On Wed, Jul 27, 2011 at 7:28 AM, Stuart Tremain = wrote: >> Very easy to do a manual export/import. Start by doing an export from = QuickBooks so that you know what need to be included when you export = from your web application. >>=20 >>=20 >> Regards >>=20 >> Stuart Tremain >> IDFK Web Developments >> AUSTRALIA >> webdna@idfk.com.au >>=20 >>=20 >>=20 >>=20 >> On 27/07/2011, at 8:17 AM, Diane Blackmore wrote: >>=20 >> > Hi >> > >> > Has anyone done any integration with Quickbooks using WebDNA, that = they're willing to share code on? I need a solution here that = preferrably doesn't use the Web Connector - I'd be happy with a straight = export as a .csv that can be imported into Quickbooks. Its an order that = needs to be imported, for existing clients, so there'd need to be a = one-to-many order/product relationship that is similar to the order file = structure of WebDNA. >> > >> > Cheers, >> > >> > >> > >>=20 >> --------------------------------------------------------- >> This message is sent to you because you are subscribed to >> the mailing list . >> To unsubscribe, E-mail to: >> archives: http://mail.webdna.us/list/talk@webdna.us >> Bug Reporting: support@webdna.us >>=20 >> --------------------------------------------------------- This = message is sent to you because you are subscribed to the mailing list . = To unsubscribe, E-mail to: archives: = http://mail.webdna.us/list/talk@webdna.us Bug Reporting: = support@webdna.us >=20 > --------------------------------------------------------- This message = is sent to you because you are subscribed to the mailing list . To = unsubscribe, E-mail to: archives: = http://mail.webdna.us/list/talk@webdna.us Bug Reporting: = support@webdna.us --Apple-Mail=_0FA749F0-2F12-43F8-BA6F-D9DCE422406F Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=iso-8859-1 You = can export/save as an xls file as a tab-delimited txt file with = excel


On Jul 26, 2011, at 10:04 PM, = Stuart Tremain wrote:

You can "read" a csv file but = you can not read an xls file.

Reading a csv file will = involve doing a bit of cleaning and a bit of fiddling to get the = contents into a .db or = [TABLE].


If you write the .csv = file to the server and then [INCLUDE] it. This is the best place to = start to understand what you are getting from the file and the best way = to attack it.


On 27/07/2011, at = 11:55 AM, sgbc cebu wrote:

Hi,

Is there a way to remove WebDNA's restrictions = of reading an xls or csv database file.

Thanks

On Wed, Jul 27, 2011 at 7:28 AM, Stuart Tremain = <webdna@idfk.com.au> = wrote:
Very easy = to do a manual export/import. Start by doing an export from QuickBooks = so that you know what need to be included when you export from your web = application.


Regards

Stuart Tremain
IDFK Web Developments
AUSTRALIA
webdna@idfk.com.au




On 27/07/2011, at 8:17 AM, Diane Blackmore wrote:

> Hi
>
> Has anyone done any integration with Quickbooks using WebDNA, that = they're willing to share code on?  I need a solution here that = preferrably doesn't use the Web Connector - I'd be happy with a straight = export as a .csv that can be imported into Quickbooks. Its an order that = needs to be imported, for existing clients, so there'd need to be a = one-to-many order/product relationship that is similar to the order file = structure of WebDNA.
>
> Cheers,
>
> <EmailSignature_Diane.gif>
>

---------------------------------------------------------
This message is sent to you because you are subscribed to
the mailing list <talk@webdna.us>.
To unsubscribe, E-mail to: <talk-leave@webdna.us>
archives: http://mail.webdna.us/list/talk@webdna.us
Bug Reporting: support@webdna.us

--------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: archives: http://mail.webdna.us/l= ist/talk@webdna.us Bug Reporting: support@webdna.us

--------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: archives: http://mail.webdna.us/l= ist/talk@webdna.us Bug Reporting: support@webdna.us

= --Apple-Mail=_0FA749F0-2F12-43F8-BA6F-D9DCE422406F-- Associated Messages, from the most recent to the oldest:

    
  1. Re: [WebDNA] Integration with QuickBooks (aaronmichaelmusic@gmail.com 2011)
  2. Re: [WebDNA] Integration with QuickBooks (aaronmichaelmusic@gmail.com 2011)
  3. Re: [WebDNA] Integration with QuickBooks (Stuart Tremain 2011)
  4. Re: [WebDNA] Integration with QuickBooks (sgbc cebu 2011)
  5. Re: [WebDNA] Integration with QuickBooks (Stuart Tremain 2011)
  6. [WebDNA] Integration with QuickBooks (Diane Blackmore 2011)
--Apple-Mail=_0FA749F0-2F12-43F8-BA6F-D9DCE422406F Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=iso-8859-1 You can export/save as an xls file as a tab-delimited txt file with = excel On Jul 26, 2011, at 10:04 PM, Stuart Tremain wrote: > You can "read" a csv file but you can not read an xls file. >=20 > Reading a csv file will involve doing a bit of cleaning and a bit of = fiddling to get the contents into a .db or [table]. >=20 >=20 > If you write the .csv file to the server and then [include] it. This = is the best place to start to understand what you are getting from the = file and the best way to attack it. >=20 >=20 > On 27/07/2011, at 11:55 AM, sgbc cebu wrote: >=20 >> Hi, >>=20 >> Is there a way to remove WebDNA's restrictions of reading an xls or = csv database file. >>=20 >> Thanks >>=20 >> On Wed, Jul 27, 2011 at 7:28 AM, Stuart Tremain = wrote: >> Very easy to do a manual export/import. Start by doing an export from = QuickBooks so that you know what need to be included when you export = from your web application. >>=20 >>=20 >> Regards >>=20 >> Stuart Tremain >> IDFK Web Developments >> AUSTRALIA >> webdna@idfk.com.au >>=20 >>=20 >>=20 >>=20 >> On 27/07/2011, at 8:17 AM, Diane Blackmore wrote: >>=20 >> > Hi >> > >> > Has anyone done any integration with Quickbooks using WebDNA, that = they're willing to share code on? I need a solution here that = preferrably doesn't use the Web Connector - I'd be happy with a straight = export as a .csv that can be imported into Quickbooks. Its an order that = needs to be imported, for existing clients, so there'd need to be a = one-to-many order/product relationship that is similar to the order file = structure of WebDNA. >> > >> > Cheers, >> > >> > >> > >>=20 >> --------------------------------------------------------- >> This message is sent to you because you are subscribed to >> the mailing list . >> To unsubscribe, E-mail to: >> archives: http://mail.webdna.us/list/talk@webdna.us >> Bug Reporting: support@webdna.us >>=20 >> --------------------------------------------------------- This = message is sent to you because you are subscribed to the mailing list . = To unsubscribe, E-mail to: archives: = http://mail.webdna.us/list/talk@webdna.us Bug Reporting: = support@webdna.us >=20 > --------------------------------------------------------- This message = is sent to you because you are subscribed to the mailing list . To = unsubscribe, E-mail to: archives: = http://mail.webdna.us/list/talk@webdna.us Bug Reporting: = support@webdna.us --Apple-Mail=_0FA749F0-2F12-43F8-BA6F-D9DCE422406F Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=iso-8859-1 You = can export/save as an xls file as a tab-delimited txt file with = excel


On Jul 26, 2011, at 10:04 PM, = Stuart Tremain wrote:

You can "read" a csv file but = you can not read an xls file.

Reading a csv file will = involve doing a bit of cleaning and a bit of fiddling to get the = contents into a .db or = [table].


If you write the .csv = file to the server and then [include] it. This is the best place to = start to understand what you are getting from the file and the best way = to attack it.


On 27/07/2011, at = 11:55 AM, sgbc cebu wrote:

Hi,

Is there a way to remove WebDNA's restrictions = of reading an xls or csv database file.

Thanks

On Wed, Jul 27, 2011 at 7:28 AM, Stuart Tremain = <webdna@idfk.com.au> = wrote:
Very easy = to do a manual export/import. Start by doing an export from QuickBooks = so that you know what need to be included when you export from your web = application.


Regards

Stuart Tremain
IDFK Web Developments
AUSTRALIA
webdna@idfk.com.au




On 27/07/2011, at 8:17 AM, Diane Blackmore wrote:

> Hi
>
> Has anyone done any integration with Quickbooks using WebDNA, that = they're willing to share code on?  I need a solution here that = preferrably doesn't use the Web Connector - I'd be happy with a straight = export as a .csv that can be imported into Quickbooks. Its an order that = needs to be imported, for existing clients, so there'd need to be a = one-to-many order/product relationship that is similar to the order file = structure of WebDNA.
>
> Cheers,
>
> <EmailSignature_Diane.gif>
>

---------------------------------------------------------
This message is sent to you because you are subscribed to
the mailing list <talk@webdna.us>.
To unsubscribe, E-mail to: <talk-leave@webdna.us>
archives: http://mail.webdna.us/list/talk@webdna.us
Bug Reporting: support@webdna.us

--------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: archives: http://mail.webdna.us/l= ist/talk@webdna.us Bug Reporting: support@webdna.us

--------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: archives: http://mail.webdna.us/l= ist/talk@webdna.us Bug Reporting: support@webdna.us

= --Apple-Mail=_0FA749F0-2F12-43F8-BA6F-D9DCE422406F-- aaronmichaelmusic@gmail.com

DOWNLOAD WEBDNA NOW!

Top Articles:

Talk List

The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...

Related Readings:

WC Database Format (1997) webcatalog developers in W. Pa. (1998) Stat analyzer (1997) WebDNA Payment Alternatives (2003) Protect vs Authenicate (1997) 2.1b2 was SLOW ... but 2.1b3 is FAST! (1997) interactive .pdf files and WebCatalog (2000) Misc Stuff That Might Help (1997) expired beta (1997) Database field limit? (1998) WebCat2 - [include] tags (1997) [WebDNA] TEst (2010) UPS charges (2000) Can't use old cart file (was One more try) (1997) [ot] Any One Want A WebDNA Billing Program? (2003) NewCart+Search with one click ? (1997) Date search - yes or no (1997) Another question about credit cards (1997) FEW QUESTIONS (1997) [Capitalize] (1998)