PROTIP: Importing data into filepro

[Bob Simcoe]

Until recently, whenever I needed to import from an Excel spreadsheet ( every month, 7,000 lines ), it was very simple. Save the spreadsheet as a dbaseIV file and use fp's dbcopy. Then fix things up in Define Files and Screens.
The reason I said  "until recently", was that new versions of Excel do not offer saving as a dbase.

Bob Simcoe


-----Original Message-----
From: filepro-list-bounces+bob=midcityoffice.com at lists.celestial.com [mailto:filepro-list-bounces+bob=midcityoffice.com at lists.celestial.com] On Behalf Of Scott Walker
Sent: Monday, March 11, 2013 1:14 PM
To: 'filePro Mailing List'
Subject: FW: PROTIP: Importing data into filepro



-----Original Message-----
From: Scott Walker [mailto:ScottWalker at RAMSystemsCorp.com]
Sent: Monday, March 11, 2013 1:04 PM
To: 'Jay Ashworth'
Subject: RE: PROTIP: Importing data into filepro

Jay,

Thanks for the input.

I agree with you. If I ever have control I use "|".  

But, this is real world, and I often have no control, no input, no information, no common sense, no time, and no patience.

Customer just gets a spreadsheet from somewhere and hand it to me and says "Can you make this work?".

Regards,

Scott

> -----Original Message-----
> From: filepro-list-
> bounces+scottwalker=ramsystemscorp.com at lists.celestial.com
> [mailto:filepro-list-
> bounces+scottwalker=ramsystemscorp.com at lists.celestial.com] On Behalf 
> bounces+Of
> Jay Ashworth
> Sent: Monday, March 11, 2013 12:13 PM
> To: filepro-list at lists.celestial.com
> Subject: PROTIP: Importing data into filepro
> 
> If you have any control at all over the format of incoming variable- 
> length data that you need to import into filePro, you should specify
> 
> |
> 
> as your field separator, and no added commas at all.
> 
> While it's an ASCII character, it's not a character that anyone who 
> isn't a programmer ever types anywhere; I have been using it for this 
> for literally three decades, and it has never falsed *once* on me.  Ever.
> 
> Just sayin'...
> 
> Cheers,
> -- jra
> --
> Jay R. Ashworth                  Baylink
> jra at baylink.com
> Designer                     The Things I Think                       RFC
> 2100
> Ashworth & Associates     http://baylink.pitas.com         2000 Land
> Rover DII
> St Petersburg FL USA               #natog                      +1 727 647
> 1274
> _______________________________________________
> Filepro-list mailing list
> Filepro-list at lists.celestial.com
> Subscribe/Unsubscribe/Subscription Changes 
> http://mailman.celestial.com/mailman/listinfo/filepro-list


_______________________________________________
Filepro-list mailing list
Filepro-list at lists.celestial.com
Subscribe/Unsubscribe/Subscription Changes http://mailman.celestial.com/mailman/listinfo/filepro-list