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

Is Graph database really good for monitoring IT enterprise?

I have a simple question about graph database utility to monitor IT enterprise.

Many graph database vendors are suggesting that graph databases are optimal for monitoring IT resources. Such like Ref 1 or Ref 2

In order to monitor IT resources, it is necessary to manage log data from IT enterprise effectively.

However, there are many books for graph database modeling that leads us to model by the following time tree method.

I think that the time tree method will generate too much edges and will not be good for the performance of the graph database.

So... Is Graph database really good for monitoring IT enterprise ?
Search in a table of three columns where search criteria may be just one column or two column or three column?

I have a database table contains email, code, name. I have a view search page which can take just email as input or just code or just name or email and name or email and code or email, name, code or nothing. So whichever the search criteria is I need to return related rows from the database. How can I manage my query? Any suggestion? Is there any best practice?

Note: Actually I have three tables and from there I get those data by join query.

Thanks.

PHP MySQL not inserting data into database (a lot of data)

I have this piece of my php code:

$sql = "INSERT INTO megbizas (status,
bekuldesi_datum,
nev,
tipus,
ceg,
sikerdij,
leiras,
hely,
lat,
lng,
tavolsag,
melyviz,
zk_legidesszant,
legter_veszely,
c130,
utanpotlas,
legidesszant,
legidesszant_ar,
foldijarmu_dobas,
foldijarmu_dobas_ar,
rohamcsonak,
rohamcsonak_ar,
m252_dobas,
m252_dobas_ar,
m119a2_dobas,
m119a2_dobas_ar,
loszer_dobas,
loszer_dobas_ar,
jarmu_loszer_dobas,
jarmu_loszer_dobas_ar,
kulso_barat,
m252,
m252_ar,
m119a2,
m119a2_ar,
sera,
sera_ar,
paladin,
paladin_ar,
legi_tamogatas,
legi_tamogatas_ar,
sajat_adat,
sajat_adat_ar,
muhold_lathato,
muhold_lathato_ar,
muhold_infra,
muhold_infra_ar,
radiozavaras,
radiozavaras_ar,
sajat_muhold_lathato,
sajat_muhold_infra)
VALUES ('available',
'$dateNow',
'$nev',
'$tipus',
'$ceg',
'$sikerdij',
'$leiras',
'$hely',
'$eszaki',
'$nyugati',
'$tavolasg',
'$melyviz',
'$tavoliDesszant',
'$legterVeszely',
'$c130',
'$utanpotlas',
'$legidesszant',
'$legidesszant_ar',
'$foldijarmuutanpotlas',
'$foldijarmuutanpotlas_ar',
'$rohamcsonak',
'$rohamcsonak_ar',
'$m252legiutanpotlas',
'$m252legiutanpotlas_ar',
'$m119a2legiutanpotlas',
'$m119a2legiutanpotlas_ar',
'$loszerlegiutanpotlas',
'$loszerlegiutanpotlas_ar',
'$jarmuloszerlegiutanpotlas',
'$jarmuloszerlegiutanpotlas_ar',
'$kulsobarat',
'$kulsobaratm252',
'$kulsobaratm252_ar',
'$kulsobaratm119a2',
'$kulsobaratm119a2_ar',
'$kulsobaratsera',
'$kulsobaratsera_ar',
'$kulsobaratpaladin',
'$kulsobaratpaladin_ar',
'$kulsobaratlegi',
'$kulsobaratlegi_ar',
'$sajatfelderites',
'$sajatfelderites_ar',
'$muholdaslathato',
'$muholdaslathato_ar',
'$muholdasinfra',
'$muholdasinfra_ar',
'$radiozavaras',
'$radiozavaras_ar',
'$sajatlathato',
'$sajatinfra')";
 mysqli_query($con,$sql);

And it runs fine without an error, but still it doesn't upload the data..

I tried to make it to three pieces, still doesn't work.

I write a little test where I upload only two data and it worked, but I think it doesn't handle this much data.

Or if not, what could be the problem and how can I solve it?

Remove fields from a DBF stored in a StringIo
I try to remove fields from a DBF that I get from internet.

It is zipped, and in order to avoid write the file on disk before the modifications I have to apply on it, it is extracted into a StringIo object.

Then, first : Does dbf handles memory files like StringIo? Second : How to remove the unwanted fields efficiently?

Here is what I ended up with:
```
import dbf

table = dbf.Table('path_to_table') #Using disc actually
for record in table:
    del record['field']
    record.write_record()
#then export the table to another StringIo
```

DBF database conditional join correct syntax DBF - edited

I have 4 tables (ROUTBOM, HARD, MAT, ROUT). In the main table ROUTBOM I have ID, PROD_NO and TYPE columns. I had to select based on TYPE and (ID or PROD_NO). Conditions below. Can this be made with an inner join - with condition before join?

Database is FoxPro

using (OleDbConnection con = new OleDbConnection(@"provider=VFPOLEDB;Data source=c:\test\Data"))

Data: ROUTBOM

id      qty      prod_no    Type    Name
20322   0.15000             2       ???    get name from HARD
        2.00000 0066773     4       ???    get name from ROUT
37500   4.00000             2       ???    get name from HARD
29750   4.00000             1       ???    get name from MAT

HARD TABLE

ID      NAME
20322   H68NK0005
37500   HAS2-30XX-H HYBRID POWDER

MAT TABLE

ID      NAME
29750   NEOPRENE (McMASTER 8694K61)
02125   SPRING STEEL STRIP .008'' X .50'' X 60''

ROUT TABLE

ID      NAME
0066773 L.V. DOOR ARC PROOF J4
000198  DEVEL. L.V. DOOR J4

Required output

id      qty      prod_no    Type    Name
20322   0.15000             2       H68NK0005
        2.00000 0066773     4       L.V. DOOR ARC PROOF J4
37500   4.00000             2       HAS2-30XX-H HYBRID POWDER
29750   4.00000             1       NEOPRENE (McMASTER 8694K61)

Query:

Conditions:

if id is not null and type 2 JOIN ROUTBOM.id with MAT.id to get the name of material
if id is not null and type 1 JOIN ROUTBOM.id with HARD.id to get the name of hadware
if id is empty and type 4 JOIN ROUTBOM.prod_no with ROUT.id to get the name of part

Can be done in one query ? I do not know where condition have to be applied. Once I make the first JOIN the query bring the whole data from HARD.

Query for row data

@"SELECT    
                                    t0.Id, 
                                    t1.Name,
                                    t0.Per_Router,
                                    t0.Prod_No,
                                    t0.Rout_No,
                                    t0.Seq,
                                    t0.Type
                                    FROM {0} t0 , "Routbom", "Hardware", "Material", "Rout");

VFP indexing and saving with INDEX ON while CDX exists
Working with VFP 9, I've indexed a DBF file by group (a column in the DBF) using
```
 INDEX ON group TO group1
```
and the records are in correct order. But then, whenever I close and reopen the DBF, the indexing is lost (no order by group). I've found a .CDX file on the same folder, as my group.idx and the dbf, and it looks like it's giving a structure to the DBF but I dont know how to change it or see it.

To solve this issue I erased the CDX file (of course an error pop-up because it could not find the .cdx) and used the COPY TO function to keep the indexed DBF but this is not a real solution for the issue (which is a solution mentioned in a forum, but it doesnt seem the best approach to me). I've also tried to use the PACK function at the end, just before closing the database but didnt work to keep the dataset indexed.

Besides the above mentioned, I've couldn't find any answer to this particular issue on the web, so I really appreciate any comment to help me understand it and to resolve the indexing while coding, and of course making sure the index and changes will stay put whenever closing the database. Many thanks in advance!

Additional Question: usually when I index I give a name to the IDX file created but when working with similar DBFs I repeat the coding, and index on diferent tables with the same idx name (so I overwrite the .idx each time, thinking it has no use anymore), but I really don't know if this may cause me problems in the future.

Related questions

DBF File protected any workaround?

See also questions close to this topic