Calling all developers...

[jxm28788]

I want to add some functionality to my actinic store, which would need to do the following -

scan the actinic DB and extract certain order/customer data (daily?)
add the data to an online SQL DB
query the SQL db from a page on the actinic site

It would be pretty simple stuff, nothing complicated other than those 3 steps.

So can anyone do this, and how much would you charge...?

[doug selby]

I should think you could do this yourself, using guides such as:
Methods of Transferring Databases from Microsoft Access to MySQL
and
PHP MySQL example: display table as HTML
I think you can just rename actinic generated pages to *.php so you're laughing!

[jxm28788]

Assuming that I don't want to keep opening sql or access and running reports, and instead wanted a program that would just extract access data and shove it into sql then what do I write the 'program' in...?

I'm pretty sure this is how all Jans utils work (a program written in 'something' pulling data out of access DB and doing 'stuff' with it). But what is the 'something'?

And while I am very technical there is the simple matter of time and learning more new stuff - is it easier just to pay someone else to do it...?

[Jan]

You can run programs at scheduled intervals with your automation mole, so that gets you part of the way there.

I write export programs every now and again, but I don't do the online web stuff that you want.

Are you trying to do online order status by any chance because it you are Andy at codepath has a very nice system for doing just that, works very much like the program you are asking for here.

Regards,

[jxm28788]

I could probably do the 'reading from SQL' in actinic myself. It's more the stripping data out of access and getting it into SQL in the first place that is the prob.

And no, not order status but something equally useful...

[Jan]

Send me an email, telling me all about it then :-) I can probably help out.

Regards,

[jxm28788]

I already did, read your e-mail!

[Jan]

So you did, will reply in the morning, thanks, :-)

Regards,

[jxm28788]

and PHP MySQL example: display table as HTML
I think you can just rename actinic generated pages to *.php so you're laughing!

Now there's great example of a really bad site. It looks really good, but what is the one thing that people entering that page will want to do more than any other? SEE THE CODE! Now how the heck do you do that? Where is the view/download/open button or link? how do I see the code??? Aaaaarrrrgggghhhhh! (pretty sure it involves registering, but it doesn't say that anywhere... It should ALWAYS be obvious what your supposed to do when you land on a page, and this page sucks!)

[Kermy]

Hotscripts doesn't store the code itself, its basically a directory of scripts held on other servers. Click the 'Visit' button to jump to the actual site that stores the script. Agreed, it's not particularly obvious.

[jxm28788]

no kidding, 'visit' would be the last button I would have pushed! Guess it makes sense when you know how the site works, but still...

[jxm28788]

PHP MySQL example: display table as HTML
I think you can just rename actinic generated pages to *.php so you're laughing!

I tried this and it works fine... however... once you're logged in everything goes through the bb000001.pl script so it's not a .PHP page anymore - it's a .pl page, and the PHP code doesn't work any more!

I can test it - works, log in, doesn't work, log out, works again...

Soooooo, is there another method of reading a mySQL db from a page when logged in...? eg. java?