DBF File protected any workaround?

2018-07-12 07:44 killer429 imported from Stackoverflow

I am trying to access a dbf file but it is asking for a password. I asked my manager but he said that the there is a workaround. Any idea.

See also questions close to this topic

How can I store the user ID in the sessions table of the database with a Laravel app?
I'm using Laravel along with the recommended way of storing sessions in the database (https://laravel.com/docs/5.2/session). Everything's working correctly except for the fact that the user_id field in the sessions table is always being stored as NULL.

After doing some research, I found an SO post that recommended using Guard, the standard authentication library in Laravel to populate it. Here's the post:
Laravel sessions table user_id always null

The problem though is that the authentication for the Laravel app at hand is a bit unique, and so custom logic has to be used for it. With that said, I still want to populate the user ID in the sessions table in the DB.

That same topic above noted that you can change the following line in the vendor/laravel/framework/src/Illuminate/Session/DatabaseSessionHandler.php file to get it to work:
```
$payload['user_id'] = $this->userId();
```
I changed the line to the following:
```
$payload['user_id'] = session('id', null);
```
This does give me what I want, but changing the code in the core of the Laravel framework like that feels weird to me.

Is there a better way to store the user ID in the sessions table in the DB with Laravel without using Guard and Laravel's built-in authentication?

Thank you.
Mongo Collection Refresh

I've got a request from my developer to do something like a mongoDB collection refresh. The request goes like this.....

1) Take backup of source and target

2) Keep the backups in a safe location

3) If there are three specific fields in the source collection documents that match the fields in the target documents then replace it/Update it in the target collection else insert as new documents

example:

Lets say Panda is a mongo database. Panda has 2 collections called Cat and Dog. Cat is the source and Dog is the target. Cat has thousands of documents with some specific fields that match with Dog. The matched fields of the documents in Dog need to be updated/replaced with Cat's documents. For documents that do not have a match, insert the documents in Dog.

I've completed the first and second steps, but need assistance with the third step.

Note: The target collection will have data appended from the source. The target collection will not be dropped to make the collection free.

Is it possible in Cosmos DB to create a singly linked list of documents?

One problem I commonly solve is that of keeping immutable versions of a document rather than editing the document. When asked for the document, retrieve the most recent version.

One way to do this is with timestamps:

doc 0:

{
   id: "e69e0bea-77ea-4d97-bedf-d3cca27ae4b6",
   correlationId: "d00be916-10e3-415c-aaf6-9acb7c70cf4f",
   created: "11/17/2018 2:20:25 AM",
   value: "foo"
}

doc 1:

{
   id: "37ef6f99-bc87-45bb-87ae-a1b81070cc91",
   correlationId: "d00be916-10e3-415c-aaf6-9acb7c70cf4f",
   created: "11/17/2018 2:20:44 AM",
   value: "bar"
}

doc 2:

{
   id: "93fc913e-5ecc-4c59-a130-0e577ed4f2fb",
   correlationId: "d00be916-10e3-415c-aaf6-9acb7c70cf4f",
   created: "11/17/2018 2:21:51 AM",
   value: "baz"
}

The downside of using timestamps is you have to order by the timestamp (O(n*log(n))) to get the Nth most recent version.

I desire to make this O(n) by storing pointers to the previous version, like

{
   id: "e69e0bea-77ea-4d97-bedf-d3cca27ae4b6",
   previousId: null,
   correlationId: "d00be916-10e3-415c-aaf6-9acb7c70cf4f",
   created: "11/17/2018 2:20:25 AM",
   value: "foo"
}

doc 1:

{
   id: "37ef6f99-bc87-45bb-87ae-a1b81070cc91",
   previousId: "e69e0bea-77ea-4d97-bedf-d3cca27ae4b6",
   correlationId: "d00be916-10e3-415c-aaf6-9acb7c70cf4f",
   created: "11/17/2018 2:20:44 AM",
   value: "bar"
}

doc 2:

{
   id: "93fc913e-5ecc-4c59-a130-0e577ed4f2fb",
   previousId: "37ef6f99-bc87-45bb-87ae-a1b81070cc91",
   correlationId: "d00be916-10e3-415c-aaf6-9acb7c70cf4f",
   created: "11/17/2018 2:21:51 AM",
   value: "baz"
}

so it is a linked list like

NULL <- doc0 <- doc1 <- doc2

The only thing stopping me from doing this is that for creating a new version I would need some locking mechanism, like (in pseudo-code)

lock correlationId
   get latest
   new.previousId = latest.id
   insert new

but I'm not sure if it's possible at the database level.

Insert records in .DBF from c #

I have a web API in C # that takes the records that are sent and saves them in a.DBF table, but for some reason, every time I save I have to do REINDEX from Visual Fox Pro, to be able to see that record, I would like that when I insert the record from C # I do not have to do REINDEX, the problem is that when it is saved, for some reason the new record is not indexed

        public const String CCVEND = "Driver={Driver do Microsoft dBase (*.dbf)};collatingsequence=ASCII;dbq=C:\\DATABASE;defaultdir=C:\\DATABASE;deleted=0;driverid=533;fil=dBase 5.0;filedsn=C:\\DATABASE\\cx.dsn;maxbuffersize=2048;maxscanrows=8;pagetimeout=5;safetransactions=0;statistics=0;threads=3;usercommitsync=Yes";


 [HttpPost]
    [Route("ccfacl")]
    public IHttpActionResult addBillD([FromBody] Factl model)
    {
        String result = "";



        String DOCUMENTO = model.DOCUMENTO;

        DateTime FECHA = model.FECHA;
        String ARTICULO = model.ARTICULO;
        Double CANTIDAD = Convert.ToDouble(model.CANTIDAD);
        Double EMPAQUE = Convert.ToDouble(model.EMPAQUE);
        Double PRECIO_UNT = model.PRECIO_UNT;
        String CUENTAD = model.CUENTAD;
        String CUENTAC = model.CUENTAC;
        String LINEA_NUM = model.LINEA_NUM;
        String TIPO_MOVI = model.TIPO_MOVI;
        String CREACION = model.CREACION;
        String HORA = model.HORA;
        String USUARIO = model.USUARIO;
        String APROBADOP = model.APROBADOP;
        String APROBADO = model.APROBADO;
        String COMIS = model.COMIS;
        String CLAVEPPT = model.CLAVEPPT;

        try
        {


            using (OdbcConnection openCon = new OdbcConnection(Cx.CCVEND))
            {
                openCon.Open();

                string saveStaff = "INSERT into ccfactl (DOCUMENTO, FECHA, ARTICULO, CANTIDAD, EMPAQUE," +
                    "PRECIO_UNT, CUENTAD, CUENTAC, LINEA_NUM, TIPO_MOVI, CREACION,  HORA, USUARIO, APROBADOP,  APROBADO, COMIS, CLAVEPPT) VALUES  " +


                    "(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? )";

                using (OdbcCommand querySaveStaff = new OdbcCommand(saveStaff, openCon))
                {
                    querySaveStaff.Connection = openCon;
                    querySaveStaff.Parameters.AddWithValue("@DOCUMENTO", DOCUMENTO);


                    querySaveStaff.Parameters.AddWithValue("@FECHA", FECHA);
                    querySaveStaff.Parameters.AddWithValue("@ARTICULO", ARTICULO);
                    querySaveStaff.Parameters.AddWithValue("@CANTIDAD", CANTIDAD);
                    querySaveStaff.Parameters.AddWithValue("@EMPAQUE", EMPAQUE);

                    querySaveStaff.Parameters.AddWithValue("@PRECIO_UNT", PRECIO_UNT);
                    querySaveStaff.Parameters.AddWithValue("@CUENTAD", CUENTAD);
                    querySaveStaff.Parameters.AddWithValue("@CUENTAC", CUENTAC);
                    querySaveStaff.Parameters.AddWithValue("@LINEA_NUM", LINEA_NUM);
                    querySaveStaff.Parameters.AddWithValue("@TIPO_MOVI", TIPO_MOVI);

                    querySaveStaff.Parameters.AddWithValue("@CREACION", CREACION);
                    querySaveStaff.Parameters.AddWithValue("@HORA", HORA);
                    querySaveStaff.Parameters.AddWithValue("@USUARIO", USUARIO == null ? (object)DBNull.Value : (object)USUARIO);
                    querySaveStaff.Parameters.AddWithValue("@APROBADOP", APROBADOP == null ? (object)DBNull.Value : (object)APROBADOP);
                    querySaveStaff.Parameters.AddWithValue("@APROBADO", APROBADO == null ? (object)DBNull.Value : (object)APROBADO);
                    querySaveStaff.Parameters.AddWithValue("@COMIS", COMIS == null ? (object)DBNull.Value : (object)COMIS);
                    querySaveStaff.Parameters.AddWithValue("@CLAVEPPT", CLAVEPPT == null ? (object)DBNull.Value : (object)CLAVEPPT);
    /*                */
                    querySaveStaff.ExecuteNonQuery();

                    result = "10";
                }
                openCon.Close();


            }
        }
        catch (SqlException ex)
        {
            result = ex.ToString();
        }


        //do something with e-mail
        return Ok(result);


    }

Python - DBF Schema Extraction - 10 Character Limit for Field Names

I'm trying to get around the 10 character limit for field names when converting from a DBF. I have tried several different libraries (dbf and dbfimport) with no luck. I'm not sure if it's even possible.

Example:

Original
Field 1 = percentage
Field 2 = percentage_all

Converts to
Field 1 = percentage
Field 2 = percentag2

Code:

import dbf
import os, sys, collections

reload(sys)
sys.setdefaultencoding('utf-8')

path = r""

for dirpath, subdirs, files in os.walk(path):
    for file in files:
        if file.endswith(('.dbf', '.DBF')):
            dbflocation = os.path.abspath(os.path.join(dirpath, file)).lower()
            print dbflocation
            try:
                tbl = dbf.structure(dbflocation)
                print tbl

                for field in tbl:
                    print field

            except Exception, e:
                print Exception
                print e
                continue

DBF viewer only (NO editing)

Hello I am looking for a viewer capable of viewing DBF (DBase IV) files, but not editing them.
All viewers I know are allowed to edit data as well, and I do not want to give users such this permission.
Users need to view/move/delete DBF files, so I cannot achieve this by giving them read-only permissions. MS Windows platform. Thanks for any ideas.

Related questions

DBF File protected any workaround?

See also questions close to this topic