Re: [WebDNA] Integration with QuickBooks

This WebDNA talk-list message is from

2011


It keeps the original formatting.
numero = 107068
interpreted = N
texte = --Apple-Mail=_E04D9A1B-FA0E-4292-82CE-3521A21548E2 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=iso-8859-1 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, >=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 --Apple-Mail=_E04D9A1B-FA0E-4292-82CE-3521A21548E2 Content-Transfer-Encoding: 7bit Content-Type: text/html; charset=iso-8859-1 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/list/talk@webdna.us Bug Reporting: support@webdna.us

--Apple-Mail=_E04D9A1B-FA0E-4292-82CE-3521A21548E2-- 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=_E04D9A1B-FA0E-4292-82CE-3521A21548E2 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=iso-8859-1 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, >=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 --Apple-Mail=_E04D9A1B-FA0E-4292-82CE-3521A21548E2 Content-Transfer-Encoding: 7bit Content-Type: text/html; charset=iso-8859-1 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/list/talk@webdna.us Bug Reporting: support@webdna.us

--Apple-Mail=_E04D9A1B-FA0E-4292-82CE-3521A21548E2-- Stuart Tremain

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:

math problems (2000) [OT] Form Check java problem (2003) WebCat2b15MacPlugin - showing [math] (1997) [shell] (2002) error: Too many nested [xxx] contexts (1997) Template Encrypt Speed (1998) OFF-TOPIC: Lending investors ... (2002) WebCat2 several catalogs? (1997) F3 crashing server (1997) emailer (1997) [WebDNA] includes with includes (2009) How to unsubscribe (me too) (2001) Stopping bad HTML propagation ? (1997) Unstable on my server (2000) Finding max value for a field (1997) WebCatalog memory error. (1998) [sendmail] and [formvariables] (1997) Reselecting popup menu (2002) WebCat2 beta 11 - new prefs ... (1997) WebCatalog on Linux (2000)