FiveTech Software tech support forums

James,

Forgotten :

I also have to put for the half of all fields standard data, not provided into the csv.

Stock = "1"
Language = "NL"
Currence = "EUR"

These data can be pre filled than into the master file, since I create 1 record with relevant data.

... The csv file has a fielddata like this : Fieldname in CSV : Name with data -> "PANDS WITH A FULL COTTON INLINE IN POL/KAT" With the mapping now, I see the data in the right browse. I could put the folowing in the Masterfile field Name : "UpperLower(csv->Name)" Result ...

Marc, I think with the approach of mapping the fields, you are going to have to write a routine to add each file type and each record is going to have to be added via code. If you rename the fields by posting a new header into the CSV file ...

... aMenu:= validMenu()   local oMenu   MENU oMenu      MENUITEM "&Csv Transform" ACTION csvtransform()      MENUITEM "&Mapping data" action master()   ENDMENUreturn oMenufunction csvtransform()LOCAL hCsv, cLine, aLine, nI := 0,aFiles[ADIR("*.csv")]ADIR("*.csv", ...

... on paper. If there are lots of file types (and more are expected) and lots of people are going to be doing this, then yes, I would write code. For mapping fields on screen, I would suggest two side-by-side browses both with two fields, field-order and field-name. The master file would be displayed ...

James, I have this code so far : (Code snippeds from samples and forum) Program Menu 1 : CSV conversion from any csv to dbf file. First loop to determine the lenght of all data, the second to fill the database Limits : ONLY DELIMITED WITH ',' will work now (for my use ok for now) chekups from missin...

Here is a function to read the header record of a CSV file. // Get first record of CSV file (contains fields)Function GetHeader(cFile)   Local cBuffer:= space(1000)   Local cHeader:=""   Local nHandle:=0   if file(cFile)      nHandle:= fopen(cFile,0)      cH...

Here is a checksum() function you can use:

Code: Select all  Expand view

Function checksum( cString )
   Local nChecksum:=0, i:=0
   for I = 1 to len( cString )
      nChecksum:= nChecksum + asc(substr(cString,i,1))
   next
Return nChecksum

 

James

Marc, I have re-read your posts and now I think I have misunderstood. It seems that each CSV file has different fieldnames and in a different order than the master file. If so, then as you stated, you will either need to restructure each file before importing it, or you will need a separate routine ...

Marc, OK, I am not clear, but it sounds like they all have the same structure, but some of the fields may not be used. If so, this simplifies things a lot. First you need to import each file into a temp DBF. The temp DBF needs to be the same structure as the master DBF. Substitute the brackets with ...

James, The first record from the csv has indeed always a header. I'm able to convert a csv file to a dbf but I want 1 master dbf file where all the csv-files will be imported. The csv files contains different data (every supplier has it own structure data) but I want to import them in a correct fiel...

Marc, Does the first record of the CSV files, contain the fieldnames? What do you mean when you say you want to link the DBF and CVS files? Do you want to import the files into a standard DBF format? You say the CSV files are random in structure. Do you mean they contain the same data but it might b...

... field. Dbf CSV Field A Data1 Field B Data2 Field C Data3 example : The data1 should go in field C, Data2 in Field A,..... I believe it is called MAPPING fields. Any part of source to show how I should proceed. The csv are random in structure, since I get them from my brands and they contain many ...

I was trying to use a fivewin program of my own on the web by mapping it as a network drive with noooo luck. Finally (in windows 10) i decide to try to use onedrive without mapping any drive but, simply using the c:\pathtoLocalOnedrive\myexe.exe And booom, ...

... it seems to me like the tables must reside on a shared directory. For example; f:\Data\Customers.dbf (or whatever other name) and have a mapping to drive f: with read/write permissions. If this is so, then what helps you avoid a user who is working late and after exiting your app double ...