Cancelado

Access database update script.

I need an script, written in WSH that can synchronize certain fields in between 2 different access databases, and write fields that can't be matched to a CSV file.

Form/setting:

[Search field]

[Update field]

[Update field min. length]

[Target database]

[Source database]

[Override is existing (boolean)]

[Matching regular expressions]

E.g.

Database 1 (100,000 records):

Fields: seqno, address, name, url, email, description.

Database 2 (5,000 records):

Fields: url, email.

Search field: url

Update field: email

Update field min. length: 10

Target database: database 1

Source database: database 2

Override if existing: yes

1. Start with record 1 in database 2.

2. Check if length of email field in database 2 is at least 10. If less than 10, skip to next record.

3. Search database 1 for record where url matches url in database 2. Update email field of database 1 with email field in database 2 for that record.

4. If data exists in field email in database 1, override.

Notes:

1. Matching should allow for regular expressions (setting). The default regular expression should ignore space, e.g. if source field url="[url removed, login to view] ", then it should match with update field url="http://www.abc.com".

2. Records in database 2 that has no matches in database 1 should be written to a CSV file.

3. Test databases will be provided on award of job.

Habilidades: ASP, Programação C, Processamento de dados, Javascript, Área de trabalho do Windows

Ver mais: access update script, script update access database, database update script, access database update script, update script access, wsh jscript access database, script update access, asp script update access, access database update, update table access scripts, access script update field size, access update scripts, regular expressions in c, regular expressions c, regular expression no, regular expression in c, regular expression c, regular expression boolean, regular expression a, regular expression 0, job matches, i need an access database, c regular expressions, $5 script, script access database update data

Acerca do Empregador:
( 139 comentários ) Singapore, Singapore

ID do Projeto: #151831

8 freelancers are bidding on average $78 for this job

yousefla

Hi, Sent you more info in the PM Regards,

$90 USD in 2 dias
(58 Comentários)
7.1
lavr

See private message.

$60 USD in 3 dias
(42 Comentários)
5.6
wsh2

As Regex is not native to Access, your requirement for doing this type of comparison, although possible, really places a burden on this project, particularily if WSH is the platform. Note, trimming leading and trailing Mais

$89.95 USD em 1 dia
(12 Comentários)
4.6
dpspecialist

Will do it in MS Access...

$65 USD in 3 dias
(1 Comentário)
2.4
ATSol

Pls see PMB

$70 USD in 2 dias
(0 Comentários)
0.0
kaddubetu

I will do this in Java and MS Access or whatever Databse you offer MYSQL,DB2,Oracle. I can provide you Text Base interface or Simple GUI in swings or can be Property file configurable

$50 USD in 3 dias
(0 Comentários)
0.0
prakos

Provide you a WSH solution. Settings are stored in a text configuration file.

$100 USD in 4 dias
(0 Comentários)
0.0
mehveen

I have just finished the other 2 projects that were on hand and now ready to start this one in MS access. I can do the job in 1 day. Looking forward to work with u.

$100 USD em 1 dia
(0 Comentários)
0.0