The 3.6.8.219 release is checking for existense of this vstor.exe:
Microsoft Visual Studio 2005 Tools for Office Second Edition Runtime (build 8.0.50727.940) (x86)
Pls. install this vstor.exe before installing xls4oracle 3.6.8.219.
-
06Feb 10
-
05Feb 10
- update organizations – posted 05-02-2010
- update locations – posted 05-02-2010
- update party site – posted 05-02-2010
- update cust account site – posted 05-02-2010
- update cust account site use – posted 05-02-2010
- update cust account – posted 05-02-2010
Extract scripts is included.
-
04Feb 10
T42812.2944.3328.3220.3458.3728.3582.3601.3372 – 5-2-2010
-
03Feb 10
The dataload form is now completed. This enables validation of all parameters before dataload. Passwords are now encrypted and a new feature enables a lock on dataload and system sheet to prevent unintended updates of validated workbooks.
The user manual is also updated. A new chapter is added with an excercise in creating a template from scratch.
-
03Feb 10
T43579.3711.4095.3987.4225.4495.4349.4368.4577 – 4-2-2010
-
30Jan 10
The “update customer profile” and “update customer profile amounts” templates will enable you to extract profile and profile amounts (sql extracts included) – and do updates. The templates is using HZ_CUSTOMER_PROFILE_V2PUB.UPDATE_CUST_PROFILE_AMT and HZ_CUSTOMER_PROFILE_V2PUB.UPDATE_CUSTOMER_PROFILE procedures for update.
-
16Jan 10
A workshop is now planned to intruduce new users for the xls4oracle tool.
The agenda for this workshop is:
- Update customer data
- Customizations of a customer template (add new column)
- Update item data
- Customizations of an item template (add new column)
- Building a new template:
- Oracle.irep
- api.sql
- mapping
- Customizing the dataload script
- Test
- Script loading
- Troubleshooting
- Verify a load
Pls. get a quote for a workshop at your site – pls. contact: ThomasLundqvist@hotmail.com
-
16Jan 10
If you experience this pls verify all your tnsnames and if that does not work pls. re-install the Oracle 10G client.
Somehow the client installation can be messed up – you can tnsping and use sqlplus, toad and so on – but the 0040 connection is not working. Pls. uninstall / install the Oracle 10G Client software.
-
06Jan 10
All reported bugs is closed.
The sql extract is now many times faster…
-
04Jan 10
when non apps connection (preprod/prod) and script load – need for ability to generate apps_initialize…
is now checking for apps connection. when connection username is not APPS - only script load is allowed. this enables resp. selection when loading to prod env.
$filename – must handle ext. diff from len=3
$filename is now without extension and handles the new 2007 extensions: xlsb, xlsm…
must handle trace > 4 (dies when trace=99)
fixed…
Will do some more testing before publishing…
Recent Comments