Re: [WebDNA] Integration with QuickBooks

This WebDNA talk-list message is from

2011


It keeps the original formatting.
numero = 107071
interpreted = N
texte = --Apple-Mail=_7F77B35E-6F35-4E15-9877-AC74AC36A057 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=iso-8859-1 Has anyone here taken a crack at using the Web Connector with QB? I'm = interested to see how webDNA can push data automatically to QB. It's = been a project on the back burner for a while. Not that long ago when I was researching QBXML, I found somewhere that = if you use QB to manage product/part inventory lists, importing orders = will not automatically deduct items from inventory like when you create = purchases from within QuickBooks. That may not be true across the = board, but the info I read claimed so, at least for the manufacturing = edition of QB. =20 As Stuart said, you can export from QB, then open in text editor to see = how to format your own file for import. The thing I remember seeing, is = that though these files are tab-delimited, they have more than one field = declaration row. This could be tricky for exporting back to webDNA = application (if needed). 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=_7F77B35E-6F35-4E15-9877-AC74AC36A057 Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=iso-8859-1
Has anyone here taken a crack at using the Web Connector with QB? =  I'm interested to see how webDNA can push data automatically to = QB.  It's been a project on the back burner for a = while.

Not that long ago when I was researching = QBXML, I found somewhere that if you use QB to manage product/part = inventory lists, importing orders will not automatically deduct items = from inventory like when you create purchases from within QuickBooks. =  That may not be true across the board, but the info I read claimed = so, at least for the manufacturing edition of QB. =  

As Stuart said, you can export from QB, = then open in text editor to see how to format your own file for import. =  The thing I remember seeing, is that though these files are = tab-delimited, they have more than one field declaration row.  This = could be tricky for exporting back to webDNA application (if = needed).


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=_7F77B35E-6F35-4E15-9877-AC74AC36A057-- 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=_7F77B35E-6F35-4E15-9877-AC74AC36A057 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=iso-8859-1 Has anyone here taken a crack at using the Web Connector with QB? I'm = interested to see how webDNA can push data automatically to QB. It's = been a project on the back burner for a while. Not that long ago when I was researching QBXML, I found somewhere that = if you use QB to manage product/part inventory lists, importing orders = will not automatically deduct items from inventory like when you create = purchases from within QuickBooks. That may not be true across the = board, but the info I read claimed so, at least for the manufacturing = edition of QB. =20 As Stuart said, you can export from QB, then open in text editor to see = how to format your own file for import. The thing I remember seeing, is = that though these files are tab-delimited, they have more than one field = declaration row. This could be tricky for exporting back to webDNA = application (if needed). 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=_7F77B35E-6F35-4E15-9877-AC74AC36A057 Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=iso-8859-1
Has anyone here taken a crack at using the Web Connector with QB? =  I'm interested to see how webDNA can push data automatically to = QB.  It's been a project on the back burner for a = while.

Not that long ago when I was researching = QBXML, I found somewhere that if you use QB to manage product/part = inventory lists, importing orders will not automatically deduct items = from inventory like when you create purchases from within QuickBooks. =  That may not be true across the board, but the info I read claimed = so, at least for the manufacturing edition of QB. =  

As Stuart said, you can export from QB, = then open in text editor to see how to format your own file for import. =  The thing I remember seeing, is that though these files are = tab-delimited, they have more than one field declaration row.  This = could be tricky for exporting back to webDNA application (if = needed).


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=_7F77B35E-6F35-4E15-9877-AC74AC36A057-- 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:

.html with IIS4 (1999) creator code (1997) I've had it! (1999) Webcatalog acgi conflict? (1999) gateway application timeouts (1998) WebCat hosting providers? (1997) Orderfile Info is Dissappearing (1998) PIXO support (1997) Not really WebCat (1997) Optional new-style syntax for WebCatalog 4.0 (2000) Why don't Typhoon & Firesite work together? (and webcat) (1998) Looking for a Manual (1997) Sort Order on a page search (1997) [searchString] (1997) [WebDNA] [table] and COMMA in a Field (2015) Emailer choke (1997) RE: Can a database get stomped by simultaneous access? (1997) Search-context (1999) [WebDNA] Amazon EC2 (2009) [math date] with non-US date format (2000)