**FireWorks- replacing Labels with Description**
Posted: Wed Feb 18, 2009 11:16 am
FireWorks- replacing Labels with Description
The FireWorks system uses the SDU's LABEL in places that would be better if it used the SDU's DESCRIPTION .
There is a few settings within the FireWorks to replace the LABEL with the DESCRIPTION, but it falls short.
By going into the Exported gateway file (name.oxp) you can replace the LABEL's WITH DESCRIPTION's.
Things to note before starting:
You will need to think about Keyboard Characters that you used in your Descriptions.
You will need to keep the ( , comma ) free so it can be used in the CSV file extension.
Excel will replace 08010001 with 8010001 that is why you add a ~@ in front of the address - ~@08010001 will not be replaced
The ( * asterisk) in some programs is a wildcard.(excel,Word)
Duplicate Descriptions will be a problem because FireWorks will not import Duplicate Labels
Your computer may not be setup to see file extensions, go into control panel ->folder and fix it.
start:
Export the SDU and open the OXP file in Wordpad.
Remove any ( ,~@) in the file.
Replace (* asterisk) with (,~@), save, exit file
Rename OXP to CSV, and open in excel
Copy the Description column to the Label column.
Save, exit, Rename CSV to OXP
open file in Wordpad
replace the top few lines of the OXP file with the original lines, it will be easier.
Replace (,~@) with (* asterisk), save, exit
Before importing the SDU Verify the OXP file.
**** this is going to be a pain in the ass, stay with it, it will work ****
Punctuation - the Keyboard Characters and their Names
~ tilde
` back quote or grave accent or back tic
! exclamation point or bang or pling
@ at sign
# pound sign or hash sign or octothorp
$ dollar sign
% percent sign
^ circumflex or caret
& ampersand or and sign
* asterisk, splat, or star
The FireWorks system uses the SDU's LABEL in places that would be better if it used the SDU's DESCRIPTION .
There is a few settings within the FireWorks to replace the LABEL with the DESCRIPTION, but it falls short.
By going into the Exported gateway file (name.oxp) you can replace the LABEL's WITH DESCRIPTION's.
Things to note before starting:
You will need to think about Keyboard Characters that you used in your Descriptions.
You will need to keep the ( , comma ) free so it can be used in the CSV file extension.
Excel will replace 08010001 with 8010001 that is why you add a ~@ in front of the address - ~@08010001 will not be replaced
The ( * asterisk) in some programs is a wildcard.(excel,Word)
Duplicate Descriptions will be a problem because FireWorks will not import Duplicate Labels
Your computer may not be setup to see file extensions, go into control panel ->folder and fix it.
start:
Export the SDU and open the OXP file in Wordpad.
Remove any ( ,~@) in the file.
Replace (* asterisk) with (,~@), save, exit file
Rename OXP to CSV, and open in excel
Copy the Description column to the Label column.
Save, exit, Rename CSV to OXP
open file in Wordpad
replace the top few lines of the OXP file with the original lines, it will be easier.
Replace (,~@) with (* asterisk), save, exit
Before importing the SDU Verify the OXP file.
**** this is going to be a pain in the ass, stay with it, it will work ****
Punctuation - the Keyboard Characters and their Names
~ tilde
` back quote or grave accent or back tic
! exclamation point or bang or pling
@ at sign
# pound sign or hash sign or octothorp
$ dollar sign
% percent sign
^ circumflex or caret
& ampersand or and sign
* asterisk, splat, or star