Re: Import/Export with CSV

at 2:24 AM, Dave Crozier <da...@flexipol.co.uk> wrote: > Darren, > Good spotting! > > Dave > > -Original Message- > From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Darren > Sent: 29 February 2016 21:22 > To: profox@leafe.com > Subject: RE: Im

RE: Import/Export with CSV

Darren, Good spotting! Dave -Original Message- From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Darren Sent: 29 February 2016 21:22 To: profox@leafe.com Subject: RE: Import/Export with CSV Took a look at that link and it references an Excel add-on - "Power Query"

RE: Import/Export with CSV

d-in-exc?rq=1 -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Ted Roche Sent: Tuesday, 1 March 2016 2:07 AM To: profoxt...@leafe.com Subject: Re: Import/Export with CSV On Mon, Feb 29, 2016 at 6:30 AM, Ted Roche <tedro...@gmail.com> wrote

Re: Import/Export with CSV

On Mon, Feb 29, 2016 at 6:30 AM, Ted Roche wrote: > > Alternatively, there may be some option in the Excel import dialog to > turn off "Smart Parsing" or whatever Excel calls it. (LibreOffice > user, sorry.) See Also:

Re: Import/Export with CSV

Don't know if this helps, but you could try changing the number format of columns 1 and 3 in the worksheet to "Text". From VFP, you'd do something like this: *!* Assume oSheet is a reference to the Excel.ActiveSheet WITH oSheet .Columns(1).Numberformat = "@" .Columns(3).Numberformat = "@"

Re: Import/Export with CSV

Suppose you are correct however in the question Sytzke said Regards Koen Op maandag 29 februari 2016 heeft Ted Roche het volgende geschreven: > On Mon, Feb 29, 2016 at 6:47 AM, Koen Piller > wrote: > > > I would use VFP to edit your

Re: Import/Export with CSV

On Mon, Feb 29, 2016 at 6:47 AM, Koen Piller wrote: > I would use VFP to edit your csv table in orde to avoid Excel messing up > your character fields into numberic Well, sure, but Sytze is using Excel (or more likely, having a client use Excel) for some reason he hasn't

Re: Import/Export with CSV

I would use VFP to edit your csv table in orde to avoid Excel messing up your character fields into numberic Regards Koen Op maandag 29 februari 2016 heeft Ted Roche het volgende geschreven: > On Sun, Feb 28, 2016 at 6:36 PM, Sytze de Boer

Re: Import/Export with CSV

On Sun, Feb 28, 2016 at 6:36 PM, Sytze de Boer wrote: > > I make some changes to the price (using Excel) > I now import from this same file and the supcode has changed to 12345.56 > > Whats the best way to overcome this? If you're exporting a field that looks like a number,

Re: Import/Export with CSV

On Sun, 28 Feb 2016, at 11:36 PM, Sytze de Boer wrote: > Whats the best way to overcome this? Don't use Excel as a CSV editor. CSV is a text format, you need a text editor or something that is designed to work with CSV properly. I use CSVEd (http://csved.sjfrancke.nl/) which is a dedicated CSV

RE: Import/Export with CSV

Sytze, Do the export to XML and then you won't have the conversion problems. Dave -Original Message- From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Sytze de Boer Sent: 28 February 2016 23:36 To: profox <profox@leafe.com> Subject: Import/Export with CSV I have a p

Re: Import/Export with CSV

> Sent: Monday, 29 February 2016 11:20 AM > To: profoxt...@leafe.com > Subject: Re: Import/Export with CSV > > The Supplier code could be letters and number, just letters, or just > numbers. > > The supplier code may be 12345.1234567890 It's nothing to do with decimal > poin

Re: Import/Export with CSV

Sometimes I have to export data with fields that are all digits but are really character fields like PatientID, ClaimNumber, or similar where leadings zeros are necessary. I often prefix the field with an underscore to avoid have Excel screw me over. hth, --Mike On 2016-02-28 19:19, Sytze

RE: Import/Export with CSV

] On Behalf Of Sytze de Boer Sent: Monday, 29 February 2016 11:20 AM To: profoxt...@leafe.com Subject: Re: Import/Export with CSV The Supplier code could be letters and number, just letters, or just numbers. The supplier code may be 12345.1234567890 It's nothing to do with decimal point. It's a character

RE: Import/Export with CSV

to FoxPro. Mike ~~ -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Sytze de Boer Sent: Sunday, February 28, 2016 5:20 PM To: profoxt...@leafe.com Subject: Re: Import/Export with CSV The Supplier code could be letters and number, just

Re: Import/Export with CSV

The Supplier code could be letters and number, just letters, or just numbers. The supplier code may be 12345.1234567890 It's nothing to do with decimal point. It's a character. If the code is ABC12345.1234567890 all is fine. The import routine is append from file IMPFILE type csv On Mon, Feb

Re: Import/Export with CSV

I only dabble with Excel but I suspect that you can get your expected results by setting it up to use five decimal places instead of two. I thought you could convert it in Foxpro with str(val( '12345.56'), 10, 5) but for some reason that only gives 4 decimal places even with decimals set to 6. I

Import/Export with CSV

I have a problem and I hope someone can help I export 3 fields to a CSV file Code C(15), price N(10,2) , supcode C(30) The code and the supcode may be pure numbers Example supcode may be 12345.56000 I make some changes to the price (using Excel) I now import from this same file and the supcode