FiveTech Software tech support forums

How to create a proprietary file to insert information such as csv but not visible

... aData ) converts any string values to the destination field type, before saving the data. This function is made keeping in view conversion from CSV. This type conversion is made using the function uCharToVal( cValue, cFieldType ) //--> Coverted value of the FieldType  Converting ...

Alguna idea de como hacerlo ?
Gracias!!

Buenos días a los amigos del Foro!!

Existe alguna función en Fivewin/harbour o alguien tiene una para convertir archivos XML a archivos CSV?

Hello Everyone,

Thank you for your responses. I have been investigating further and found the Windows Server 2019 does not allow for "unattended" access to open XLS through scheduled task. I will ask customer to change format to CSV and read as text.

Carlos,
I remember that I did tests with fileseek. But you need the paid version to get a CSV export of the results.
Best regards,
Otto

viewtopic.php?f=3&t=33244&p=196025&hilit=fileseek&sid=b0f3b637d2d0ef8daf74d1ff56516df8#p196025

When I convert from a csv file to an array, the fw_ArrayToDBF (aData ,, bProgress) function inserts me an empty record, how do I avoid this   local  csvfile:=".\csv\file.csv"   local  cSymbol := ","   local  cText ...

... testing, I created an Excel table with 800,000 rows and 20 columns. I could read the data directly from xlsx file into an arry (without creating csv file) in more or less the same time. I could write the entire 800,000 rows to DBF in about 10 seconds, much less than a minute. However I did not ...

Regards Mr Rao
Reading the CSV file by passing it to an array() not even 15 seconds, 780,000 lines, reading as XLSX took a few hours
The recording if it takes 1 hour and a half, because there are validations before recording record by record.

Enrrique Vertiz wrote:Thanks for your explanation, I worked with CSV and it was the fastest

Yes, this is the FASTEST.
May I know how much time it took for 1,000,000 records?

Thanks for your explanation, I worked with CSV and it was the fastest

... GetExcelRange() and FW_ExcelToDBF() for this purpose. But your data is huge, better to use a custom approach for this case. 1) Save Excel sheet as CSV and then copy to DBF. OR 2) Reading row by row is ok. Instead, read in chunks, ranges of 20,000 approx in a loop and save it in dbf.

Enrique aqui tienes un ejemplo de la implementación de la barra de progreso leyendo el CSV que está en el array. #include "FIVEWIN.CH"FUNCTION Main()    LOCAL oDlg, oMeter, nActual := 0    DEFINE BRUSH oBrush COLOR CLR_LGRAY        DEFINE WINDOW oDlg ...

Podrias probar pasando primero el archivo CSV a un array ya que esto lo hace bien rapido. #include "FIVEWIN.CH" FUNCTION Main() LOCAL cMsgRun := "Procedure in execution; please Wait...", cMsgArrayData := "Creating CSV ...

... es que el cliente lo recibe asi de otro sistema y no quiere meter mano, quiere que se importe "tal cual" ... Una idea es grabarlo como CSV y de ahi hacerle un APPEND FROM, por el volumen puede que tome varios minutos, por eso me gustaria ponerle un "progress bar", alguien ...