Import any XML or CSV File to WordPress - Version 3.5.1

Version Description

  • improvement: add support for importing WebP images
  • bug fix: images in content not being imported when creating new simple WooCommerce products
Download this release

Release Info

Developer soflyy
Plugin Icon 128x128 Import any XML or CSV File to WordPress
Version 3.5.1
Comparing to
See all releases

Code changes from version 3.5.0 to 3.5.1

Files changed (230) hide show
  1. actions/admin_notices.php +2 -2
  2. classes/PHPExcel.php +0 -0
  3. classes/PHPExcel/Autoloader.php +0 -0
  4. classes/PHPExcel/CachedObjectStorage/APC.php +0 -0
  5. classes/PHPExcel/CachedObjectStorage/CacheBase.php +0 -0
  6. classes/PHPExcel/CachedObjectStorage/DiscISAM.php +0 -0
  7. classes/PHPExcel/CachedObjectStorage/ICache.php +0 -0
  8. classes/PHPExcel/CachedObjectStorage/Igbinary.php +0 -0
  9. classes/PHPExcel/CachedObjectStorage/Memcache.php +0 -0
  10. classes/PHPExcel/CachedObjectStorage/Memory.php +0 -0
  11. classes/PHPExcel/CachedObjectStorage/MemoryGZip.php +0 -0
  12. classes/PHPExcel/CachedObjectStorage/MemorySerialized.php +0 -0
  13. classes/PHPExcel/CachedObjectStorage/PHPTemp.php +0 -0
  14. classes/PHPExcel/CachedObjectStorage/SQLite3.php +0 -0
  15. classes/PHPExcel/CachedObjectStorage/Wincache.php +0 -0
  16. classes/PHPExcel/CachedObjectStorageFactory.php +0 -0
  17. classes/PHPExcel/CalcEngine/CyclicReferenceStack.php +0 -0
  18. classes/PHPExcel/CalcEngine/Logger.php +0 -0
  19. classes/PHPExcel/Calculation.php +0 -0
  20. classes/PHPExcel/Calculation/Database.php +0 -0
  21. classes/PHPExcel/Calculation/DateTime.php +0 -0
  22. classes/PHPExcel/Calculation/Engineering.php +0 -0
  23. classes/PHPExcel/Calculation/Exception.php +0 -0
  24. classes/PHPExcel/Calculation/ExceptionHandler.php +0 -0
  25. classes/PHPExcel/Calculation/Financial.php +0 -0
  26. classes/PHPExcel/Calculation/FormulaParser.php +0 -0
  27. classes/PHPExcel/Calculation/FormulaToken.php +0 -0
  28. classes/PHPExcel/Calculation/Function.php +0 -0
  29. classes/PHPExcel/Calculation/Functions.php +0 -0
  30. classes/PHPExcel/Calculation/Logical.php +0 -0
  31. classes/PHPExcel/Calculation/LookupRef.php +0 -0
  32. classes/PHPExcel/Calculation/MathTrig.php +0 -0
  33. classes/PHPExcel/Calculation/Statistical.php +0 -0
  34. classes/PHPExcel/Calculation/TextData.php +0 -0
  35. classes/PHPExcel/Calculation/Token/Stack.php +0 -0
  36. classes/PHPExcel/Calculation/functionlist.txt +0 -0
  37. classes/PHPExcel/Cell.php +0 -0
  38. classes/PHPExcel/Cell/AdvancedValueBinder.php +0 -0
  39. classes/PHPExcel/Cell/DataType.php +0 -0
  40. classes/PHPExcel/Cell/DataValidation.php +0 -0
  41. classes/PHPExcel/Cell/DefaultValueBinder.php +0 -0
  42. classes/PHPExcel/Cell/Hyperlink.php +0 -0
  43. classes/PHPExcel/Cell/IValueBinder.php +0 -0
  44. classes/PHPExcel/Comment.php +0 -0
  45. classes/PHPExcel/DocumentProperties.php +0 -0
  46. classes/PHPExcel/DocumentSecurity.php +0 -0
  47. classes/PHPExcel/Exception.php +0 -0
  48. classes/PHPExcel/HashTable.php +0 -0
  49. classes/PHPExcel/IComparable.php +0 -0
  50. classes/PHPExcel/IOFactory.php +0 -0
  51. classes/PHPExcel/NamedRange.php +0 -0
  52. classes/PHPExcel/Reader/Abstract.php +0 -0
  53. classes/PHPExcel/Reader/CSV.php +0 -0
  54. classes/PHPExcel/Reader/DefaultReadFilter.php +0 -0
  55. classes/PHPExcel/Reader/Excel2003XML.php +0 -0
  56. classes/PHPExcel/Reader/Excel2007.php +0 -0
  57. classes/PHPExcel/Reader/Excel2007/Chart.php +0 -0
  58. classes/PHPExcel/Reader/Excel2007/Theme.php +0 -0
  59. classes/PHPExcel/Reader/Excel5.php +0 -0
  60. classes/PHPExcel/Reader/Excel5/Escher.php +0 -0
  61. classes/PHPExcel/Reader/Excel5/MD5.php +0 -0
  62. classes/PHPExcel/Reader/Excel5/RC4.php +0 -0
  63. classes/PHPExcel/Reader/Exception.php +0 -0
  64. classes/PHPExcel/Reader/Gnumeric.php +0 -0
  65. classes/PHPExcel/Reader/HTML.php +0 -0
  66. classes/PHPExcel/Reader/IReadFilter.php +0 -0
  67. classes/PHPExcel/Reader/IReader.php +0 -0
  68. classes/PHPExcel/Reader/OOCalc.php +0 -0
  69. classes/PHPExcel/Reader/SYLK.php +0 -0
  70. classes/PHPExcel/ReferenceHelper.php +0 -0
  71. classes/PHPExcel/RichText.php +0 -0
  72. classes/PHPExcel/RichText/ITextElement.php +0 -0
  73. classes/PHPExcel/RichText/Run.php +0 -0
  74. classes/PHPExcel/RichText/TextElement.php +0 -0
  75. classes/PHPExcel/Settings.php +0 -0
  76. classes/PHPExcel/Shared/CodePage.php +0 -0
  77. classes/PHPExcel/Shared/Date.php +0 -0
  78. classes/PHPExcel/Shared/Drawing.php +0 -0
  79. classes/PHPExcel/Shared/Escher.php +0 -0
  80. classes/PHPExcel/Shared/Escher/DgContainer.php +0 -0
  81. classes/PHPExcel/Shared/Escher/DgContainer/SpgrContainer.php +0 -0
  82. classes/PHPExcel/Shared/Escher/DgContainer/SpgrContainer/SpContainer.php +0 -0
  83. classes/PHPExcel/Shared/Escher/DggContainer.php +0 -0
  84. classes/PHPExcel/Shared/Escher/DggContainer/BstoreContainer.php +0 -0
  85. classes/PHPExcel/Shared/Escher/DggContainer/BstoreContainer/BSE.php +0 -0
  86. classes/PHPExcel/Shared/Escher/DggContainer/BstoreContainer/BSE/Blip.php +0 -0
  87. classes/PHPExcel/Shared/Excel5.php +0 -0
  88. classes/PHPExcel/Shared/File.php +0 -0
  89. classes/PHPExcel/Shared/Font.php +0 -0
  90. classes/PHPExcel/Shared/JAMA/CHANGELOG.TXT +0 -0
  91. classes/PHPExcel/Shared/JAMA/CholeskyDecomposition.php +0 -0
  92. classes/PHPExcel/Shared/JAMA/EigenvalueDecomposition.php +0 -0
  93. classes/PHPExcel/Shared/JAMA/LUDecomposition.php +0 -0
  94. classes/PHPExcel/Shared/JAMA/Matrix.php +0 -0
  95. classes/PHPExcel/Shared/JAMA/QRDecomposition.php +0 -0
  96. classes/PHPExcel/Shared/JAMA/SingularValueDecomposition.php +0 -0
  97. classes/PHPExcel/Shared/JAMA/utils/Error.php +0 -0
  98. classes/PHPExcel/Shared/JAMA/utils/Maths.php +0 -0
  99. classes/PHPExcel/Shared/OLE.php +0 -0
  100. classes/PHPExcel/Shared/OLE/ChainedBlockStream.php +0 -0
  101. classes/PHPExcel/Shared/OLE/PPS.php +0 -0
  102. classes/PHPExcel/Shared/OLE/PPS/File.php +0 -0
  103. classes/PHPExcel/Shared/OLE/PPS/Root.php +0 -0
  104. classes/PHPExcel/Shared/OLERead.php +0 -0
  105. classes/PHPExcel/Shared/PCLZip/gnu-lgpl.txt +504 -504
  106. classes/PHPExcel/Shared/PCLZip/pclzip.lib.php +0 -0
  107. classes/PHPExcel/Shared/PCLZip/readme.txt +0 -0
  108. classes/PHPExcel/Shared/PasswordHasher.php +0 -0
  109. classes/PHPExcel/Shared/String.php +0 -0
  110. classes/PHPExcel/Shared/TimeZone.php +0 -0
  111. classes/PHPExcel/Shared/XMLWriter.php +0 -0
  112. classes/PHPExcel/Shared/ZipArchive.php +0 -0
  113. classes/PHPExcel/Shared/ZipStreamWrapper.php +0 -0
  114. classes/PHPExcel/Shared/trend/bestFitClass.php +0 -0
  115. classes/PHPExcel/Shared/trend/exponentialBestFitClass.php +0 -0
  116. classes/PHPExcel/Shared/trend/linearBestFitClass.php +0 -0
  117. classes/PHPExcel/Shared/trend/logarithmicBestFitClass.php +0 -0
  118. classes/PHPExcel/Shared/trend/polynomialBestFitClass.php +0 -0
  119. classes/PHPExcel/Shared/trend/powerBestFitClass.php +0 -0
  120. classes/PHPExcel/Shared/trend/trendClass.php +0 -0
  121. classes/PHPExcel/Style.php +0 -0
  122. classes/PHPExcel/Style/Alignment.php +0 -0
  123. classes/PHPExcel/Style/Border.php +0 -0
  124. classes/PHPExcel/Style/Borders.php +0 -0
  125. classes/PHPExcel/Style/Color.php +0 -0
  126. classes/PHPExcel/Style/Conditional.php +0 -0
  127. classes/PHPExcel/Style/Fill.php +0 -0
  128. classes/PHPExcel/Style/Font.php +0 -0
  129. classes/PHPExcel/Style/NumberFormat.php +0 -0
  130. classes/PHPExcel/Style/Protection.php +0 -0
  131. classes/PHPExcel/Style/Supervisor.php +0 -0
  132. classes/PHPExcel/Worksheet.php +0 -0
  133. classes/PHPExcel/Worksheet/AutoFilter.php +0 -0
  134. classes/PHPExcel/Worksheet/AutoFilter/Column.php +0 -0
  135. classes/PHPExcel/Worksheet/AutoFilter/Column/Rule.php +0 -0
  136. classes/PHPExcel/Worksheet/BaseDrawing.php +0 -0
  137. classes/PHPExcel/Worksheet/CellIterator.php +0 -0
  138. classes/PHPExcel/Worksheet/Column.php +0 -0
  139. classes/PHPExcel/Worksheet/ColumnCellIterator.php +0 -0
  140. classes/PHPExcel/Worksheet/ColumnDimension.php +0 -0
  141. classes/PHPExcel/Worksheet/ColumnIterator.php +0 -0
  142. classes/PHPExcel/Worksheet/Drawing.php +0 -0
  143. classes/PHPExcel/Worksheet/Drawing/Shadow.php +0 -0
  144. classes/PHPExcel/Worksheet/HeaderFooter.php +0 -0
  145. classes/PHPExcel/Worksheet/HeaderFooterDrawing.php +0 -0
  146. classes/PHPExcel/Worksheet/MemoryDrawing.php +0 -0
  147. classes/PHPExcel/Worksheet/PageMargins.php +0 -0
  148. classes/PHPExcel/Worksheet/PageSetup.php +0 -0
  149. classes/PHPExcel/Worksheet/Protection.php +0 -0
  150. classes/PHPExcel/Worksheet/Row.php +0 -0
  151. classes/PHPExcel/Worksheet/RowCellIterator.php +0 -0
  152. classes/PHPExcel/Worksheet/RowDimension.php +0 -0
  153. classes/PHPExcel/Worksheet/RowIterator.php +0 -0
  154. classes/PHPExcel/Worksheet/SheetView.php +0 -0
  155. classes/PHPExcel/WorksheetIterator.php +0 -0
  156. classes/PHPExcel/Writer/Abstract.php +0 -0
  157. classes/PHPExcel/Writer/CSV.php +0 -0
  158. classes/PHPExcel/Writer/IWriter.php +0 -0
  159. classes/PHPExcel/locale/bg/config +0 -0
  160. classes/PHPExcel/locale/cs/config +0 -0
  161. classes/PHPExcel/locale/cs/functions +0 -0
  162. classes/PHPExcel/locale/da/config +0 -0
  163. classes/PHPExcel/locale/da/functions +0 -0
  164. classes/PHPExcel/locale/de/config +0 -0
  165. classes/PHPExcel/locale/de/functions +0 -0
  166. classes/PHPExcel/locale/en/uk/config +0 -0
  167. classes/PHPExcel/locale/es/config +0 -0
  168. classes/PHPExcel/locale/es/functions +0 -0
  169. classes/PHPExcel/locale/fi/config +0 -0
  170. classes/PHPExcel/locale/fi/functions +0 -0
  171. classes/PHPExcel/locale/fr/config +0 -0
  172. classes/PHPExcel/locale/fr/functions +0 -0
  173. classes/PHPExcel/locale/hu/config +0 -0
  174. classes/PHPExcel/locale/hu/functions +0 -0
  175. classes/PHPExcel/locale/it/config +0 -0
  176. classes/PHPExcel/locale/it/functions +0 -0
  177. classes/PHPExcel/locale/nl/config +0 -0
  178. classes/PHPExcel/locale/nl/functions +0 -0
  179. classes/PHPExcel/locale/no/config +0 -0
  180. classes/PHPExcel/locale/no/functions +0 -0
  181. classes/PHPExcel/locale/pl/config +0 -0
  182. classes/PHPExcel/locale/pl/functions +0 -0
  183. classes/PHPExcel/locale/pt/br/config +0 -0
  184. classes/PHPExcel/locale/pt/br/functions +0 -0
  185. classes/PHPExcel/locale/pt/config +0 -0
  186. classes/PHPExcel/locale/pt/functions +0 -0
  187. classes/PHPExcel/locale/ru/config +0 -0
  188. classes/PHPExcel/locale/ru/functions +0 -0
  189. classes/PHPExcel/locale/sv/config +0 -0
  190. classes/PHPExcel/locale/sv/functions +408 -408
  191. classes/PHPExcel/locale/tr/config +0 -0
  192. classes/PHPExcel/locale/tr/functions +0 -0
  193. controllers/admin/addons.php +1 -1
  194. controllers/admin/home.php +12 -0
  195. controllers/admin/import.php +3 -3
  196. controllers/admin/settings.php +7 -7
  197. helpers/wp_all_import_addon_notifications.php +1 -1
  198. helpers/wp_all_import_clear_directory.php +0 -0
  199. helpers/wp_all_import_ctx_mapping.php +0 -0
  200. helpers/wp_all_import_get_image_from_gallery.php +3 -0
  201. helpers/wp_all_import_is_json.php +0 -0
  202. helpers/wp_all_import_json_to_xml.php +0 -0
  203. helpers/wp_all_import_rand_char.php +0 -0
  204. helpers/wp_all_import_remove_source.php +0 -0
  205. helpers/wp_all_import_rmdir.php +0 -0
  206. helpers/wp_all_import_secure_file.php +0 -0
  207. helpers/wp_all_import_strip_tags_content.php +0 -0
  208. helpers/wp_all_import_template_notifications.php +3 -3
  209. helpers/wp_all_import_url_title.php +0 -0
  210. helpers/wpai_util_map.php +0 -0
  211. i18n/languages/wp_all_import_plugin-ja.mo +0 -0
  212. i18n/languages/wp_all_import_plugin-ja.po +0 -0
  213. models/import/record.php +31 -6
  214. plugin.php +3 -3
  215. readme.txt +15 -11
  216. views/admin/help/index.php +2 -2
  217. views/admin/home/index.php +16 -0
  218. views/admin/import/confirm.php +2 -2
  219. views/admin/import/element.php +1 -1
  220. views/admin/import/index.php +16 -16
  221. views/admin/import/options.php +2 -2
  222. views/admin/import/options/_import_file.php +4 -4
  223. views/admin/import/options/_settings_template.php +13 -13
  224. views/admin/import/process.php +4 -4
  225. views/admin/import/template.php +3 -3
  226. views/admin/import/template/_custom_fields_template.php +1 -1
  227. views/admin/import/template/_featured_template.php +1 -1
  228. views/admin/manage/index.php +1 -1
  229. views/admin/manage/scheduling.php +3 -3
  230. views/admin/settings/index.php +1 -1
actions/admin_notices.php CHANGED
@@ -120,10 +120,10 @@ function pmxi_admin_notices() {
120
  $m = __('<strong>Warning:</strong> your content is blank.', 'wp_all_import_plugin');
121
  break;
122
  case 3:
123
- $m = __('<strong>Warning:</strong> You must <a href="http://www.wpallimport.com/upgrade-to-pro/?utm_source=free-plugin&utm_medium=in-plugin&utm_campaign=images" target="_blank">upgrade to the Pro edition of WP All Import</a> to import images. The settings you configured in the images section will be ignored.', 'wp_all_import_plugin');
124
  break;
125
  case 4:
126
- $m = __('<strong>Warning:</strong> You must <a href="https://www.wpallimport.com/checkout/?edd_action=add_to_cart&download_id=1748&edd_options%5Bprice_id%5D=0&utm_source=free-plugin&utm_medium=in-plugin&utm_campaign=custom-fields" target="_blank">upgrade to the Pro edition of WP All Import</a> to import data to Custom Fields. The settings you configured in the Custom Fields section will be ignored.', 'wp_all_import_plugin');
127
  break;
128
  default:
129
  $m = false;
120
  $m = __('<strong>Warning:</strong> your content is blank.', 'wp_all_import_plugin');
121
  break;
122
  case 3:
123
+ $m = __('<strong>Warning:</strong> You must <a href="https://www.wpallimport.com/checkout/?edd_action=add_to_cart&download_id=1748&edd_options%5Bprice_id%5D=0&utm_source=import-plugin-free&utm_medium=upgrade-notice&utm_campaign=images" target="_blank">upgrade to the Pro edition of WP All Import</a> to import images. The settings you configured in the images section will be ignored.', 'wp_all_import_plugin');
124
  break;
125
  case 4:
126
+ $m = __('<strong>Warning:</strong> You must <a href="https://www.wpallimport.com/checkout/?edd_action=add_to_cart&download_id=1748&edd_options%5Bprice_id%5D=0&utm_source=import-plugin-free&utm_medium=upgrade-notice&utm_campaign=custom-fields" target="_blank">upgrade to the Pro edition of WP All Import</a> to import data to Custom Fields. The settings you configured in the Custom Fields section will be ignored.', 'wp_all_import_plugin');
127
  break;
128
  default:
129
  $m = false;
classes/PHPExcel.php CHANGED
File without changes
classes/PHPExcel/Autoloader.php CHANGED
File without changes
classes/PHPExcel/CachedObjectStorage/APC.php CHANGED
File without changes
classes/PHPExcel/CachedObjectStorage/CacheBase.php CHANGED
File without changes
classes/PHPExcel/CachedObjectStorage/DiscISAM.php CHANGED
File without changes
classes/PHPExcel/CachedObjectStorage/ICache.php CHANGED
File without changes
classes/PHPExcel/CachedObjectStorage/Igbinary.php CHANGED
File without changes
classes/PHPExcel/CachedObjectStorage/Memcache.php CHANGED
File without changes
classes/PHPExcel/CachedObjectStorage/Memory.php CHANGED
File without changes
classes/PHPExcel/CachedObjectStorage/MemoryGZip.php CHANGED
File without changes
classes/PHPExcel/CachedObjectStorage/MemorySerialized.php CHANGED
File without changes
classes/PHPExcel/CachedObjectStorage/PHPTemp.php CHANGED
File without changes
classes/PHPExcel/CachedObjectStorage/SQLite3.php CHANGED
File without changes
classes/PHPExcel/CachedObjectStorage/Wincache.php CHANGED
File without changes
classes/PHPExcel/CachedObjectStorageFactory.php CHANGED
File without changes
classes/PHPExcel/CalcEngine/CyclicReferenceStack.php CHANGED
File without changes
classes/PHPExcel/CalcEngine/Logger.php CHANGED
File without changes
classes/PHPExcel/Calculation.php CHANGED
File without changes
classes/PHPExcel/Calculation/Database.php CHANGED
File without changes
classes/PHPExcel/Calculation/DateTime.php CHANGED
File without changes
classes/PHPExcel/Calculation/Engineering.php CHANGED
File without changes
classes/PHPExcel/Calculation/Exception.php CHANGED
File without changes
classes/PHPExcel/Calculation/ExceptionHandler.php CHANGED
File without changes
classes/PHPExcel/Calculation/Financial.php CHANGED
File without changes
classes/PHPExcel/Calculation/FormulaParser.php CHANGED
File without changes
classes/PHPExcel/Calculation/FormulaToken.php CHANGED
File without changes
classes/PHPExcel/Calculation/Function.php CHANGED
File without changes
classes/PHPExcel/Calculation/Functions.php CHANGED
File without changes
classes/PHPExcel/Calculation/Logical.php CHANGED
File without changes
classes/PHPExcel/Calculation/LookupRef.php CHANGED
File without changes
classes/PHPExcel/Calculation/MathTrig.php CHANGED
File without changes
classes/PHPExcel/Calculation/Statistical.php CHANGED
File without changes
classes/PHPExcel/Calculation/TextData.php CHANGED
File without changes
classes/PHPExcel/Calculation/Token/Stack.php CHANGED
File without changes
classes/PHPExcel/Calculation/functionlist.txt CHANGED
File without changes
classes/PHPExcel/Cell.php CHANGED
File without changes
classes/PHPExcel/Cell/AdvancedValueBinder.php CHANGED
File without changes
classes/PHPExcel/Cell/DataType.php CHANGED
File without changes
classes/PHPExcel/Cell/DataValidation.php CHANGED
File without changes
classes/PHPExcel/Cell/DefaultValueBinder.php CHANGED
File without changes
classes/PHPExcel/Cell/Hyperlink.php CHANGED
File without changes
classes/PHPExcel/Cell/IValueBinder.php CHANGED
File without changes
classes/PHPExcel/Comment.php CHANGED
File without changes
classes/PHPExcel/DocumentProperties.php CHANGED
File without changes
classes/PHPExcel/DocumentSecurity.php CHANGED
File without changes
classes/PHPExcel/Exception.php CHANGED
File without changes
classes/PHPExcel/HashTable.php CHANGED
File without changes
classes/PHPExcel/IComparable.php CHANGED
File without changes
classes/PHPExcel/IOFactory.php CHANGED
File without changes
classes/PHPExcel/NamedRange.php CHANGED
File without changes
classes/PHPExcel/Reader/Abstract.php CHANGED
File without changes
classes/PHPExcel/Reader/CSV.php CHANGED
File without changes
classes/PHPExcel/Reader/DefaultReadFilter.php CHANGED
File without changes
classes/PHPExcel/Reader/Excel2003XML.php CHANGED
File without changes
classes/PHPExcel/Reader/Excel2007.php CHANGED
File without changes
classes/PHPExcel/Reader/Excel2007/Chart.php CHANGED
File without changes
classes/PHPExcel/Reader/Excel2007/Theme.php CHANGED
File without changes
classes/PHPExcel/Reader/Excel5.php CHANGED
File without changes
classes/PHPExcel/Reader/Excel5/Escher.php CHANGED
File without changes
classes/PHPExcel/Reader/Excel5/MD5.php CHANGED
File without changes
classes/PHPExcel/Reader/Excel5/RC4.php CHANGED
File without changes
classes/PHPExcel/Reader/Exception.php CHANGED
File without changes
classes/PHPExcel/Reader/Gnumeric.php CHANGED
File without changes
classes/PHPExcel/Reader/HTML.php CHANGED
File without changes
classes/PHPExcel/Reader/IReadFilter.php CHANGED
File without changes
classes/PHPExcel/Reader/IReader.php CHANGED
File without changes
classes/PHPExcel/Reader/OOCalc.php CHANGED
File without changes
classes/PHPExcel/Reader/SYLK.php CHANGED
File without changes
classes/PHPExcel/ReferenceHelper.php CHANGED
File without changes
classes/PHPExcel/RichText.php CHANGED
File without changes
classes/PHPExcel/RichText/ITextElement.php CHANGED
File without changes
classes/PHPExcel/RichText/Run.php CHANGED
File without changes
classes/PHPExcel/RichText/TextElement.php CHANGED
File without changes
classes/PHPExcel/Settings.php CHANGED
File without changes
classes/PHPExcel/Shared/CodePage.php CHANGED
File without changes
classes/PHPExcel/Shared/Date.php CHANGED
File without changes
classes/PHPExcel/Shared/Drawing.php CHANGED
File without changes
classes/PHPExcel/Shared/Escher.php CHANGED
File without changes
classes/PHPExcel/Shared/Escher/DgContainer.php CHANGED
File without changes
classes/PHPExcel/Shared/Escher/DgContainer/SpgrContainer.php CHANGED
File without changes
classes/PHPExcel/Shared/Escher/DgContainer/SpgrContainer/SpContainer.php CHANGED
File without changes
classes/PHPExcel/Shared/Escher/DggContainer.php CHANGED
File without changes
classes/PHPExcel/Shared/Escher/DggContainer/BstoreContainer.php CHANGED
File without changes
classes/PHPExcel/Shared/Escher/DggContainer/BstoreContainer/BSE.php CHANGED
File without changes
classes/PHPExcel/Shared/Escher/DggContainer/BstoreContainer/BSE/Blip.php CHANGED
File without changes
classes/PHPExcel/Shared/Excel5.php CHANGED
File without changes
classes/PHPExcel/Shared/File.php CHANGED
File without changes
classes/PHPExcel/Shared/Font.php CHANGED
File without changes
classes/PHPExcel/Shared/JAMA/CHANGELOG.TXT CHANGED
File without changes
classes/PHPExcel/Shared/JAMA/CholeskyDecomposition.php CHANGED
File without changes
classes/PHPExcel/Shared/JAMA/EigenvalueDecomposition.php CHANGED
File without changes
classes/PHPExcel/Shared/JAMA/LUDecomposition.php CHANGED
File without changes
classes/PHPExcel/Shared/JAMA/Matrix.php CHANGED
File without changes
classes/PHPExcel/Shared/JAMA/QRDecomposition.php CHANGED
File without changes
classes/PHPExcel/Shared/JAMA/SingularValueDecomposition.php CHANGED
File without changes
classes/PHPExcel/Shared/JAMA/utils/Error.php CHANGED
File without changes
classes/PHPExcel/Shared/JAMA/utils/Maths.php CHANGED
File without changes
classes/PHPExcel/Shared/OLE.php CHANGED
File without changes
classes/PHPExcel/Shared/OLE/ChainedBlockStream.php CHANGED
File without changes
classes/PHPExcel/Shared/OLE/PPS.php CHANGED
File without changes
classes/PHPExcel/Shared/OLE/PPS/File.php CHANGED
File without changes
classes/PHPExcel/Shared/OLE/PPS/Root.php CHANGED
File without changes
classes/PHPExcel/Shared/OLERead.php CHANGED
File without changes
classes/PHPExcel/Shared/PCLZip/gnu-lgpl.txt CHANGED
@@ -1,504 +1,504 @@
1
- GNU LESSER GENERAL PUBLIC LICENSE
2
- Version 2.1, February 1999
3
-
4
- Copyright (C) 1991, 1999 Free Software Foundation, Inc.
5
- 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA
6
- Everyone is permitted to copy and distribute verbatim copies
7
- of this license document, but changing it is not allowed.
8
-
9
- [This is the first released version of the Lesser GPL. It also counts
10
- as the successor of the GNU Library Public License, version 2, hence
11
- the version number 2.1.]
12
-
13
- Preamble
14
-
15
- The licenses for most software are designed to take away your
16
- freedom to share and change it. By contrast, the GNU General Public
17
- Licenses are intended to guarantee your freedom to share and change
18
- free software--to make sure the software is free for all its users.
19
-
20
- This license, the Lesser General Public License, applies to some
21
- specially designated software packages--typically libraries--of the
22
- Free Software Foundation and other authors who decide to use it. You
23
- can use it too, but we suggest you first think carefully about whether
24
- this license or the ordinary General Public License is the better
25
- strategy to use in any particular case, based on the explanations below.
26
-
27
- When we speak of free software, we are referring to freedom of use,
28
- not price. Our General Public Licenses are designed to make sure that
29
- you have the freedom to distribute copies of free software (and charge
30
- for this service if you wish); that you receive source code or can get
31
- it if you want it; that you can change the software and use pieces of
32
- it in new free programs; and that you are informed that you can do
33
- these things.
34
-
35
- To protect your rights, we need to make restrictions that forbid
36
- distributors to deny you these rights or to ask you to surrender these
37
- rights. These restrictions translate to certain responsibilities for
38
- you if you distribute copies of the library or if you modify it.
39
-
40
- For example, if you distribute copies of the library, whether gratis
41
- or for a fee, you must give the recipients all the rights that we gave
42
- you. You must make sure that they, too, receive or can get the source
43
- code. If you link other code with the library, you must provide
44
- complete object files to the recipients, so that they can relink them
45
- with the library after making changes to the library and recompiling
46
- it. And you must show them these terms so they know their rights.
47
-
48
- We protect your rights with a two-step method: (1) we copyright the
49
- library, and (2) we offer you this license, which gives you legal
50
- permission to copy, distribute and/or modify the library.
51
-
52
- To protect each distributor, we want to make it very clear that
53
- there is no warranty for the free library. Also, if the library is
54
- modified by someone else and passed on, the recipients should know
55
- that what they have is not the original version, so that the original
56
- author's reputation will not be affected by problems that might be
57
- introduced by others.
58
-
59
- Finally, software patents pose a constant threat to the existence of
60
- any free program. We wish to make sure that a company cannot
61
- effectively restrict the users of a free program by obtaining a
62
- restrictive license from a patent holder. Therefore, we insist that
63
- any patent license obtained for a version of the library must be
64
- consistent with the full freedom of use specified in this license.
65
-
66
- Most GNU software, including some libraries, is covered by the
67
- ordinary GNU General Public License. This license, the GNU Lesser
68
- General Public License, applies to certain designated libraries, and
69
- is quite different from the ordinary General Public License. We use
70
- this license for certain libraries in order to permit linking those
71
- libraries into non-free programs.
72
-
73
- When a program is linked with a library, whether statically or using
74
- a shared library, the combination of the two is legally speaking a
75
- combined work, a derivative of the original library. The ordinary
76
- General Public License therefore permits such linking only if the
77
- entire combination fits its criteria of freedom. The Lesser General
78
- Public License permits more lax criteria for linking other code with
79
- the library.
80
-
81
- We call this license the "Lesser" General Public License because it
82
- does Less to protect the user's freedom than the ordinary General
83
- Public License. It also provides other free software developers Less
84
- of an advantage over competing non-free programs. These disadvantages
85
- are the reason we use the ordinary General Public License for many
86
- libraries. However, the Lesser license provides advantages in certain
87
- special circumstances.
88
-
89
- For example, on rare occasions, there may be a special need to
90
- encourage the widest possible use of a certain library, so that it becomes
91
- a de-facto standard. To achieve this, non-free programs must be
92
- allowed to use the library. A more frequent case is that a free
93
- library does the same job as widely used non-free libraries. In this
94
- case, there is little to gain by limiting the free library to free
95
- software only, so we use the Lesser General Public License.
96
-
97
- In other cases, permission to use a particular library in non-free
98
- programs enables a greater number of people to use a large body of
99
- free software. For example, permission to use the GNU C Library in
100
- non-free programs enables many more people to use the whole GNU
101
- operating system, as well as its variant, the GNU/Linux operating
102
- system.
103
-
104
- Although the Lesser General Public License is Less protective of the
105
- users' freedom, it does ensure that the user of a program that is
106
- linked with the Library has the freedom and the wherewithal to run
107
- that program using a modified version of the Library.
108
-
109
- The precise terms and conditions for copying, distribution and
110
- modification follow. Pay close attention to the difference between a
111
- "work based on the library" and a "work that uses the library". The
112
- former contains code derived from the library, whereas the latter must
113
- be combined with the library in order to run.
114
-
115
- GNU LESSER GENERAL PUBLIC LICENSE
116
- TERMS AND CONDITIONS FOR COPYING, DISTRIBUTION AND MODIFICATION
117
-
118
- 0. This License Agreement applies to any software library or other
119
- program which contains a notice placed by the copyright holder or
120
- other authorized party saying it may be distributed under the terms of
121
- this Lesser General Public License (also called "this License").
122
- Each licensee is addressed as "you".
123
-
124
- A "library" means a collection of software functions and/or data
125
- prepared so as to be conveniently linked with application programs
126
- (which use some of those functions and data) to form executables.
127
-
128
- The "Library", below, refers to any such software library or work
129
- which has been distributed under these terms. A "work based on the
130
- Library" means either the Library or any derivative work under
131
- copyright law: that is to say, a work containing the Library or a
132
- portion of it, either verbatim or with modifications and/or translated
133
- straightforwardly into another language. (Hereinafter, translation is
134
- included without limitation in the term "modification".)
135
-
136
- "Source code" for a work means the preferred form of the work for
137
- making modifications to it. For a library, complete source code means
138
- all the source code for all modules it contains, plus any associated
139
- interface definition files, plus the scripts used to control compilation
140
- and installation of the library.
141
-
142
- Activities other than copying, distribution and modification are not
143
- covered by this License; they are outside its scope. The act of
144
- running a program using the Library is not restricted, and output from
145
- such a program is covered only if its contents constitute a work based
146
- on the Library (independent of the use of the Library in a tool for
147
- writing it). Whether that is true depends on what the Library does
148
- and what the program that uses the Library does.
149
-
150
- 1. You may copy and distribute verbatim copies of the Library's
151
- complete source code as you receive it, in any medium, provided that
152
- you conspicuously and appropriately publish on each copy an
153
- appropriate copyright notice and disclaimer of warranty; keep intact
154
- all the notices that refer to this License and to the absence of any
155
- warranty; and distribute a copy of this License along with the
156
- Library.
157
-
158
- You may charge a fee for the physical act of transferring a copy,
159
- and you may at your option offer warranty protection in exchange for a
160
- fee.
161
-
162
- 2. You may modify your copy or copies of the Library or any portion
163
- of it, thus forming a work based on the Library, and copy and
164
- distribute such modifications or work under the terms of Section 1
165
- above, provided that you also meet all of these conditions:
166
-
167
- a) The modified work must itself be a software library.
168
-
169
- b) You must cause the files modified to carry prominent notices
170
- stating that you changed the files and the date of any change.
171
-
172
- c) You must cause the whole of the work to be licensed at no
173
- charge to all third parties under the terms of this License.
174
-
175
- d) If a facility in the modified Library refers to a function or a
176
- table of data to be supplied by an application program that uses
177
- the facility, other than as an argument passed when the facility
178
- is invoked, then you must make a good faith effort to ensure that,
179
- in the event an application does not supply such function or
180
- table, the facility still operates, and performs whatever part of
181
- its purpose remains meaningful.
182
-
183
- (For example, a function in a library to compute square roots has
184
- a purpose that is entirely well-defined independent of the
185
- application. Therefore, Subsection 2d requires that any
186
- application-supplied function or table used by this function must
187
- be optional: if the application does not supply it, the square
188
- root function must still compute square roots.)
189
-
190
- These requirements apply to the modified work as a whole. If
191
- identifiable sections of that work are not derived from the Library,
192
- and can be reasonably considered independent and separate works in
193
- themselves, then this License, and its terms, do not apply to those
194
- sections when you distribute them as separate works. But when you
195
- distribute the same sections as part of a whole which is a work based
196
- on the Library, the distribution of the whole must be on the terms of
197
- this License, whose permissions for other licensees extend to the
198
- entire whole, and thus to each and every part regardless of who wrote
199
- it.
200
-
201
- Thus, it is not the intent of this section to claim rights or contest
202
- your rights to work written entirely by you; rather, the intent is to
203
- exercise the right to control the distribution of derivative or
204
- collective works based on the Library.
205
-
206
- In addition, mere aggregation of another work not based on the Library
207
- with the Library (or with a work based on the Library) on a volume of
208
- a storage or distribution medium does not bring the other work under
209
- the scope of this License.
210
-
211
- 3. You may opt to apply the terms of the ordinary GNU General Public
212
- License instead of this License to a given copy of the Library. To do
213
- this, you must alter all the notices that refer to this License, so
214
- that they refer to the ordinary GNU General Public License, version 2,
215
- instead of to this License. (If a newer version than version 2 of the
216
- ordinary GNU General Public License has appeared, then you can specify
217
- that version instead if you wish.) Do not make any other change in
218
- these notices.
219
-
220
- Once this change is made in a given copy, it is irreversible for
221
- that copy, so the ordinary GNU General Public License applies to all
222
- subsequent copies and derivative works made from that copy.
223
-
224
- This option is useful when you wish to copy part of the code of
225
- the Library into a program that is not a library.
226
-
227
- 4. You may copy and distribute the Library (or a portion or
228
- derivative of it, under Section 2) in object code or executable form
229
- under the terms of Sections 1 and 2 above provided that you accompany
230
- it with the complete corresponding machine-readable source code, which
231
- must be distributed under the terms of Sections 1 and 2 above on a
232
- medium customarily used for software interchange.
233
-
234
- If distribution of object code is made by offering access to copy
235
- from a designated place, then offering equivalent access to copy the
236
- source code from the same place satisfies the requirement to
237
- distribute the source code, even though third parties are not
238
- compelled to copy the source along with the object code.
239
-
240
- 5. A program that contains no derivative of any portion of the
241
- Library, but is designed to work with the Library by being compiled or
242
- linked with it, is called a "work that uses the Library". Such a
243
- work, in isolation, is not a derivative work of the Library, and
244
- therefore falls outside the scope of this License.
245
-
246
- However, linking a "work that uses the Library" with the Library
247
- creates an executable that is a derivative of the Library (because it
248
- contains portions of the Library), rather than a "work that uses the
249
- library". The executable is therefore covered by this License.
250
- Section 6 states terms for distribution of such executables.
251
-
252
- When a "work that uses the Library" uses material from a header file
253
- that is part of the Library, the object code for the work may be a
254
- derivative work of the Library even though the source code is not.
255
- Whether this is true is especially significant if the work can be
256
- linked without the Library, or if the work is itself a library. The
257
- threshold for this to be true is not precisely defined by law.
258
-
259
- If such an object file uses only numerical parameters, data
260
- structure layouts and accessors, and small macros and small inline
261
- functions (ten lines or less in length), then the use of the object
262
- file is unrestricted, regardless of whether it is legally a derivative
263
- work. (Executables containing this object code plus portions of the
264
- Library will still fall under Section 6.)
265
-
266
- Otherwise, if the work is a derivative of the Library, you may
267
- distribute the object code for the work under the terms of Section 6.
268
- Any executables containing that work also fall under Section 6,
269
- whether or not they are linked directly with the Library itself.
270
-
271
- 6. As an exception to the Sections above, you may also combine or
272
- link a "work that uses the Library" with the Library to produce a
273
- work containing portions of the Library, and distribute that work
274
- under terms of your choice, provided that the terms permit
275
- modification of the work for the customer's own use and reverse
276
- engineering for debugging such modifications.
277
-
278
- You must give prominent notice with each copy of the work that the
279
- Library is used in it and that the Library and its use are covered by
280
- this License. You must supply a copy of this License. If the work
281
- during execution displays copyright notices, you must include the
282
- copyright notice for the Library among them, as well as a reference
283
- directing the user to the copy of this License. Also, you must do one
284
- of these things:
285
-
286
- a) Accompany the work with the complete corresponding
287
- machine-readable source code for the Library including whatever
288
- changes were used in the work (which must be distributed under
289
- Sections 1 and 2 above); and, if the work is an executable linked
290
- with the Library, with the complete machine-readable "work that
291
- uses the Library", as object code and/or source code, so that the
292
- user can modify the Library and then relink to produce a modified
293
- executable containing the modified Library. (It is understood
294
- that the user who changes the contents of definitions files in the
295
- Library will not necessarily be able to recompile the application
296
- to use the modified definitions.)
297
-
298
- b) Use a suitable shared library mechanism for linking with the
299
- Library. A suitable mechanism is one that (1) uses at run time a
300
- copy of the library already present on the user's computer system,
301
- rather than copying library functions into the executable, and (2)
302
- will operate properly with a modified version of the library, if
303
- the user installs one, as long as the modified version is
304
- interface-compatible with the version that the work was made with.
305
-
306
- c) Accompany the work with a written offer, valid for at
307
- least three years, to give the same user the materials
308
- specified in Subsection 6a, above, for a charge no more
309
- than the cost of performing this distribution.
310
-
311
- d) If distribution of the work is made by offering access to copy
312
- from a designated place, offer equivalent access to copy the above
313
- specified materials from the same place.
314
-
315
- e) Verify that the user has already received a copy of these
316
- materials or that you have already sent this user a copy.
317
-
318
- For an executable, the required form of the "work that uses the
319
- Library" must include any data and utility programs needed for
320
- reproducing the executable from it. However, as a special exception,
321
- the materials to be distributed need not include anything that is
322
- normally distributed (in either source or binary form) with the major
323
- components (compiler, kernel, and so on) of the operating system on
324
- which the executable runs, unless that component itself accompanies
325
- the executable.
326
-
327
- It may happen that this requirement contradicts the license
328
- restrictions of other proprietary libraries that do not normally
329
- accompany the operating system. Such a contradiction means you cannot
330
- use both them and the Library together in an executable that you
331
- distribute.
332
-
333
- 7. You may place library facilities that are a work based on the
334
- Library side-by-side in a single library together with other library
335
- facilities not covered by this License, and distribute such a combined
336
- library, provided that the separate distribution of the work based on
337
- the Library and of the other library facilities is otherwise
338
- permitted, and provided that you do these two things:
339
-
340
- a) Accompany the combined library with a copy of the same work
341
- based on the Library, uncombined with any other library
342
- facilities. This must be distributed under the terms of the
343
- Sections above.
344
-
345
- b) Give prominent notice with the combined library of the fact
346
- that part of it is a work based on the Library, and explaining
347
- where to find the accompanying uncombined form of the same work.
348
-
349
- 8. You may not copy, modify, sublicense, link with, or distribute
350
- the Library except as expressly provided under this License. Any
351
- attempt otherwise to copy, modify, sublicense, link with, or
352
- distribute the Library is void, and will automatically terminate your
353
- rights under this License. However, parties who have received copies,
354
- or rights, from you under this License will not have their licenses
355
- terminated so long as such parties remain in full compliance.
356
-
357
- 9. You are not required to accept this License, since you have not
358
- signed it. However, nothing else grants you permission to modify or
359
- distribute the Library or its derivative works. These actions are
360
- prohibited by law if you do not accept this License. Therefore, by
361
- modifying or distributing the Library (or any work based on the
362
- Library), you indicate your acceptance of this License to do so, and
363
- all its terms and conditions for copying, distributing or modifying
364
- the Library or works based on it.
365
-
366
- 10. Each time you redistribute the Library (or any work based on the
367
- Library), the recipient automatically receives a license from the
368
- original licensor to copy, distribute, link with or modify the Library
369
- subject to these terms and conditions. You may not impose any further
370
- restrictions on the recipients' exercise of the rights granted herein.
371
- You are not responsible for enforcing compliance by third parties with
372
- this License.
373
-
374
- 11. If, as a consequence of a court judgment or allegation of patent
375
- infringement or for any other reason (not limited to patent issues),
376
- conditions are imposed on you (whether by court order, agreement or
377
- otherwise) that contradict the conditions of this License, they do not
378
- excuse you from the conditions of this License. If you cannot
379
- distribute so as to satisfy simultaneously your obligations under this
380
- License and any other pertinent obligations, then as a consequence you
381
- may not distribute the Library at all. For example, if a patent
382
- license would not permit royalty-free redistribution of the Library by
383
- all those who receive copies directly or indirectly through you, then
384
- the only way you could satisfy both it and this License would be to
385
- refrain entirely from distribution of the Library.
386
-
387
- If any portion of this section is held invalid or unenforceable under any
388
- particular circumstance, the balance of the section is intended to apply,
389
- and the section as a whole is intended to apply in other circumstances.
390
-
391
- It is not the purpose of this section to induce you to infringe any
392
- patents or other property right claims or to contest validity of any
393
- such claims; this section has the sole purpose of protecting the
394
- integrity of the free software distribution system which is
395
- implemented by public license practices. Many people have made
396
- generous contributions to the wide range of software distributed
397
- through that system in reliance on consistent application of that
398
- system; it is up to the author/donor to decide if he or she is willing
399
- to distribute software through any other system and a licensee cannot
400
- impose that choice.
401
-
402
- This section is intended to make thoroughly clear what is believed to
403
- be a consequence of the rest of this License.
404
-
405
- 12. If the distribution and/or use of the Library is restricted in
406
- certain countries either by patents or by copyrighted interfaces, the
407
- original copyright holder who places the Library under this License may add
408
- an explicit geographical distribution limitation excluding those countries,
409
- so that distribution is permitted only in or among countries not thus
410
- excluded. In such case, this License incorporates the limitation as if
411
- written in the body of this License.
412
-
413
- 13. The Free Software Foundation may publish revised and/or new
414
- versions of the Lesser General Public License from time to time.
415
- Such new versions will be similar in spirit to the present version,
416
- but may differ in detail to address new problems or concerns.
417
-
418
- Each version is given a distinguishing version number. If the Library
419
- specifies a version number of this License which applies to it and
420
- "any later version", you have the option of following the terms and
421
- conditions either of that version or of any later version published by
422
- the Free Software Foundation. If the Library does not specify a
423
- license version number, you may choose any version ever published by
424
- the Free Software Foundation.
425
-
426
- 14. If you wish to incorporate parts of the Library into other free
427
- programs whose distribution conditions are incompatible with these,
428
- write to the author to ask for permission. For software which is
429
- copyrighted by the Free Software Foundation, write to the Free
430
- Software Foundation; we sometimes make exceptions for this. Our
431
- decision will be guided by the two goals of preserving the free status
432
- of all derivatives of our free software and of promoting the sharing
433
- and reuse of software generally.
434
-
435
- NO WARRANTY
436
-
437
- 15. BECAUSE THE LIBRARY IS LICENSED FREE OF CHARGE, THERE IS NO
438
- WARRANTY FOR THE LIBRARY, TO THE EXTENT PERMITTED BY APPLICABLE LAW.
439
- EXCEPT WHEN OTHERWISE STATED IN WRITING THE COPYRIGHT HOLDERS AND/OR
440
- OTHER PARTIES PROVIDE THE LIBRARY "AS IS" WITHOUT WARRANTY OF ANY
441
- KIND, EITHER EXPRESSED OR IMPLIED, INCLUDING, BUT NOT LIMITED TO, THE
442
- IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR
443
- PURPOSE. THE ENTIRE RISK AS TO THE QUALITY AND PERFORMANCE OF THE
444
- LIBRARY IS WITH YOU. SHOULD THE LIBRARY PROVE DEFECTIVE, YOU ASSUME
445
- THE COST OF ALL NECESSARY SERVICING, REPAIR OR CORRECTION.
446
-
447
- 16. IN NO EVENT UNLESS REQUIRED BY APPLICABLE LAW OR AGREED TO IN
448
- WRITING WILL ANY COPYRIGHT HOLDER, OR ANY OTHER PARTY WHO MAY MODIFY
449
- AND/OR REDISTRIBUTE THE LIBRARY AS PERMITTED ABOVE, BE LIABLE TO YOU
450
- FOR DAMAGES, INCLUDING ANY GENERAL, SPECIAL, INCIDENTAL OR
451
- CONSEQUENTIAL DAMAGES ARISING OUT OF THE USE OR INABILITY TO USE THE
452
- LIBRARY (INCLUDING BUT NOT LIMITED TO LOSS OF DATA OR DATA BEING
453
- RENDERED INACCURATE OR LOSSES SUSTAINED BY YOU OR THIRD PARTIES OR A
454
- FAILURE OF THE LIBRARY TO OPERATE WITH ANY OTHER SOFTWARE), EVEN IF
455
- SUCH HOLDER OR OTHER PARTY HAS BEEN ADVISED OF THE POSSIBILITY OF SUCH
456
- DAMAGES.
457
-
458
- END OF TERMS AND CONDITIONS
459
-
460
- How to Apply These Terms to Your New Libraries
461
-
462
- If you develop a new library, and you want it to be of the greatest
463
- possible use to the public, we recommend making it free software that
464
- everyone can redistribute and change. You can do so by permitting
465
- redistribution under these terms (or, alternatively, under the terms of the
466
- ordinary General Public License).
467
-
468
- To apply these terms, attach the following notices to the library. It is
469
- safest to attach them to the start of each source file to most effectively
470
- convey the exclusion of warranty; and each file should have at least the
471
- "copyright" line and a pointer to where the full notice is found.
472
-
473
- <one line to give the library's name and a brief idea of what it does.>
474
- Copyright (C) <year> <name of author>
475
-
476
- This library is free software; you can redistribute it and/or
477
- modify it under the terms of the GNU Lesser General Public
478
- License as published by the Free Software Foundation; either
479
- version 2.1 of the License, or (at your option) any later version.
480
-
481
- This library is distributed in the hope that it will be useful,
482
- but WITHOUT ANY WARRANTY; without even the implied warranty of
483
- MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU
484
- Lesser General Public License for more details.
485
-
486
- You should have received a copy of the GNU Lesser General Public
487
- License along with this library; if not, write to the Free Software
488
- Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA
489
-
490
- Also add information on how to contact you by electronic and paper mail.
491
-
492
- You should also get your employer (if you work as a programmer) or your
493
- school, if any, to sign a "copyright disclaimer" for the library, if
494
- necessary. Here is a sample; alter the names:
495
-
496
- Yoyodyne, Inc., hereby disclaims all copyright interest in the
497
- library `Frob' (a library for tweaking knobs) written by James Random Hacker.
498
-
499
- <signature of Ty Coon>, 1 April 1990
500
- Ty Coon, President of Vice
501
-
502
- That's all there is to it!
503
-
504
-
1
+ GNU LESSER GENERAL PUBLIC LICENSE
2
+ Version 2.1, February 1999
3
+
4
+ Copyright (C) 1991, 1999 Free Software Foundation, Inc.
5
+ 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA
6
+ Everyone is permitted to copy and distribute verbatim copies
7
+ of this license document, but changing it is not allowed.
8
+
9
+ [This is the first released version of the Lesser GPL. It also counts
10
+ as the successor of the GNU Library Public License, version 2, hence
11
+ the version number 2.1.]
12
+
13
+ Preamble
14
+
15
+ The licenses for most software are designed to take away your
16
+ freedom to share and change it. By contrast, the GNU General Public
17
+ Licenses are intended to guarantee your freedom to share and change
18
+ free software--to make sure the software is free for all its users.
19
+
20
+ This license, the Lesser General Public License, applies to some
21
+ specially designated software packages--typically libraries--of the
22
+ Free Software Foundation and other authors who decide to use it. You
23
+ can use it too, but we suggest you first think carefully about whether
24
+ this license or the ordinary General Public License is the better
25
+ strategy to use in any particular case, based on the explanations below.
26
+
27
+ When we speak of free software, we are referring to freedom of use,
28
+ not price. Our General Public Licenses are designed to make sure that
29
+ you have the freedom to distribute copies of free software (and charge
30
+ for this service if you wish); that you receive source code or can get
31
+ it if you want it; that you can change the software and use pieces of
32
+ it in new free programs; and that you are informed that you can do
33
+ these things.
34
+
35
+ To protect your rights, we need to make restrictions that forbid
36
+ distributors to deny you these rights or to ask you to surrender these
37
+ rights. These restrictions translate to certain responsibilities for
38
+ you if you distribute copies of the library or if you modify it.
39
+
40
+ For example, if you distribute copies of the library, whether gratis
41
+ or for a fee, you must give the recipients all the rights that we gave
42
+ you. You must make sure that they, too, receive or can get the source
43
+ code. If you link other code with the library, you must provide
44
+ complete object files to the recipients, so that they can relink them
45
+ with the library after making changes to the library and recompiling
46
+ it. And you must show them these terms so they know their rights.
47
+
48
+ We protect your rights with a two-step method: (1) we copyright the
49
+ library, and (2) we offer you this license, which gives you legal
50
+ permission to copy, distribute and/or modify the library.
51
+
52
+ To protect each distributor, we want to make it very clear that
53
+ there is no warranty for the free library. Also, if the library is
54
+ modified by someone else and passed on, the recipients should know
55
+ that what they have is not the original version, so that the original
56
+ author's reputation will not be affected by problems that might be
57
+ introduced by others.
58
+
59
+ Finally, software patents pose a constant threat to the existence of
60
+ any free program. We wish to make sure that a company cannot
61
+ effectively restrict the users of a free program by obtaining a
62
+ restrictive license from a patent holder. Therefore, we insist that
63
+ any patent license obtained for a version of the library must be
64
+ consistent with the full freedom of use specified in this license.
65
+
66
+ Most GNU software, including some libraries, is covered by the
67
+ ordinary GNU General Public License. This license, the GNU Lesser
68
+ General Public License, applies to certain designated libraries, and
69
+ is quite different from the ordinary General Public License. We use
70
+ this license for certain libraries in order to permit linking those
71
+ libraries into non-free programs.
72
+
73
+ When a program is linked with a library, whether statically or using
74
+ a shared library, the combination of the two is legally speaking a
75
+ combined work, a derivative of the original library. The ordinary
76
+ General Public License therefore permits such linking only if the
77
+ entire combination fits its criteria of freedom. The Lesser General
78
+ Public License permits more lax criteria for linking other code with
79
+ the library.
80
+
81
+ We call this license the "Lesser" General Public License because it
82
+ does Less to protect the user's freedom than the ordinary General
83
+ Public License. It also provides other free software developers Less
84
+ of an advantage over competing non-free programs. These disadvantages
85
+ are the reason we use the ordinary General Public License for many
86
+ libraries. However, the Lesser license provides advantages in certain
87
+ special circumstances.
88
+
89
+ For example, on rare occasions, there may be a special need to
90
+ encourage the widest possible use of a certain library, so that it becomes
91
+ a de-facto standard. To achieve this, non-free programs must be
92
+ allowed to use the library. A more frequent case is that a free
93
+ library does the same job as widely used non-free libraries. In this
94
+ case, there is little to gain by limiting the free library to free
95
+ software only, so we use the Lesser General Public License.
96
+
97
+ In other cases, permission to use a particular library in non-free
98
+ programs enables a greater number of people to use a large body of
99
+ free software. For example, permission to use the GNU C Library in
100
+ non-free programs enables many more people to use the whole GNU
101
+ operating system, as well as its variant, the GNU/Linux operating
102
+ system.
103
+
104
+ Although the Lesser General Public License is Less protective of the
105
+ users' freedom, it does ensure that the user of a program that is
106
+ linked with the Library has the freedom and the wherewithal to run
107
+ that program using a modified version of the Library.
108
+
109
+ The precise terms and conditions for copying, distribution and
110
+ modification follow. Pay close attention to the difference between a
111
+ "work based on the library" and a "work that uses the library". The
112
+ former contains code derived from the library, whereas the latter must
113
+ be combined with the library in order to run.
114
+
115
+ GNU LESSER GENERAL PUBLIC LICENSE
116
+ TERMS AND CONDITIONS FOR COPYING, DISTRIBUTION AND MODIFICATION
117
+
118
+ 0. This License Agreement applies to any software library or other
119
+ program which contains a notice placed by the copyright holder or
120
+ other authorized party saying it may be distributed under the terms of
121
+ this Lesser General Public License (also called "this License").
122
+ Each licensee is addressed as "you".
123
+
124
+ A "library" means a collection of software functions and/or data
125
+ prepared so as to be conveniently linked with application programs
126
+ (which use some of those functions and data) to form executables.
127
+
128
+ The "Library", below, refers to any such software library or work
129
+ which has been distributed under these terms. A "work based on the
130
+ Library" means either the Library or any derivative work under
131
+ copyright law: that is to say, a work containing the Library or a
132
+ portion of it, either verbatim or with modifications and/or translated
133
+ straightforwardly into another language. (Hereinafter, translation is
134
+ included without limitation in the term "modification".)
135
+
136
+ "Source code" for a work means the preferred form of the work for
137
+ making modifications to it. For a library, complete source code means
138
+ all the source code for all modules it contains, plus any associated
139
+ interface definition files, plus the scripts used to control compilation
140
+ and installation of the library.
141
+
142
+ Activities other than copying, distribution and modification are not
143
+ covered by this License; they are outside its scope. The act of
144
+ running a program using the Library is not restricted, and output from
145
+ such a program is covered only if its contents constitute a work based
146
+ on the Library (independent of the use of the Library in a tool for
147
+ writing it). Whether that is true depends on what the Library does
148
+ and what the program that uses the Library does.
149
+
150
+ 1. You may copy and distribute verbatim copies of the Library's
151
+ complete source code as you receive it, in any medium, provided that
152
+ you conspicuously and appropriately publish on each copy an
153
+ appropriate copyright notice and disclaimer of warranty; keep intact
154
+ all the notices that refer to this License and to the absence of any
155
+ warranty; and distribute a copy of this License along with the
156
+ Library.
157
+
158
+ You may charge a fee for the physical act of transferring a copy,
159
+ and you may at your option offer warranty protection in exchange for a
160
+ fee.
161
+
162
+ 2. You may modify your copy or copies of the Library or any portion
163
+ of it, thus forming a work based on the Library, and copy and
164
+ distribute such modifications or work under the terms of Section 1
165
+ above, provided that you also meet all of these conditions:
166
+
167
+ a) The modified work must itself be a software library.
168
+
169
+ b) You must cause the files modified to carry prominent notices
170
+ stating that you changed the files and the date of any change.
171
+
172
+ c) You must cause the whole of the work to be licensed at no
173
+ charge to all third parties under the terms of this License.
174
+
175
+ d) If a facility in the modified Library refers to a function or a
176
+ table of data to be supplied by an application program that uses
177
+ the facility, other than as an argument passed when the facility
178
+ is invoked, then you must make a good faith effort to ensure that,
179
+ in the event an application does not supply such function or
180
+ table, the facility still operates, and performs whatever part of
181
+ its purpose remains meaningful.
182
+
183
+ (For example, a function in a library to compute square roots has
184
+ a purpose that is entirely well-defined independent of the
185
+ application. Therefore, Subsection 2d requires that any
186
+ application-supplied function or table used by this function must
187
+ be optional: if the application does not supply it, the square
188
+ root function must still compute square roots.)
189
+
190
+ These requirements apply to the modified work as a whole. If
191
+ identifiable sections of that work are not derived from the Library,
192
+ and can be reasonably considered independent and separate works in
193
+ themselves, then this License, and its terms, do not apply to those
194
+ sections when you distribute them as separate works. But when you
195
+ distribute the same sections as part of a whole which is a work based
196
+ on the Library, the distribution of the whole must be on the terms of
197
+ this License, whose permissions for other licensees extend to the
198
+ entire whole, and thus to each and every part regardless of who wrote
199
+ it.
200
+
201
+ Thus, it is not the intent of this section to claim rights or contest
202
+ your rights to work written entirely by you; rather, the intent is to
203
+ exercise the right to control the distribution of derivative or
204
+ collective works based on the Library.
205
+
206
+ In addition, mere aggregation of another work not based on the Library
207
+ with the Library (or with a work based on the Library) on a volume of
208
+ a storage or distribution medium does not bring the other work under
209
+ the scope of this License.
210
+
211
+ 3. You may opt to apply the terms of the ordinary GNU General Public
212
+ License instead of this License to a given copy of the Library. To do
213
+ this, you must alter all the notices that refer to this License, so
214
+ that they refer to the ordinary GNU General Public License, version 2,
215
+ instead of to this License. (If a newer version than version 2 of the
216
+ ordinary GNU General Public License has appeared, then you can specify
217
+ that version instead if you wish.) Do not make any other change in
218
+ these notices.
219
+
220
+ Once this change is made in a given copy, it is irreversible for
221
+ that copy, so the ordinary GNU General Public License applies to all
222
+ subsequent copies and derivative works made from that copy.
223
+
224
+ This option is useful when you wish to copy part of the code of
225
+ the Library into a program that is not a library.
226
+
227
+ 4. You may copy and distribute the Library (or a portion or
228
+ derivative of it, under Section 2) in object code or executable form
229
+ under the terms of Sections 1 and 2 above provided that you accompany
230
+ it with the complete corresponding machine-readable source code, which
231
+ must be distributed under the terms of Sections 1 and 2 above on a
232
+ medium customarily used for software interchange.
233
+
234
+ If distribution of object code is made by offering access to copy
235
+ from a designated place, then offering equivalent access to copy the
236
+ source code from the same place satisfies the requirement to
237
+ distribute the source code, even though third parties are not
238
+ compelled to copy the source along with the object code.
239
+
240
+ 5. A program that contains no derivative of any portion of the
241
+ Library, but is designed to work with the Library by being compiled or
242
+ linked with it, is called a "work that uses the Library". Such a
243
+ work, in isolation, is not a derivative work of the Library, and
244
+ therefore falls outside the scope of this License.
245
+
246
+ However, linking a "work that uses the Library" with the Library
247
+ creates an executable that is a derivative of the Library (because it
248
+ contains portions of the Library), rather than a "work that uses the
249
+ library". The executable is therefore covered by this License.
250
+ Section 6 states terms for distribution of such executables.
251
+
252
+ When a "work that uses the Library" uses material from a header file
253
+ that is part of the Library, the object code for the work may be a
254
+ derivative work of the Library even though the source code is not.
255
+ Whether this is true is especially significant if the work can be
256
+ linked without the Library, or if the work is itself a library. The
257
+ threshold for this to be true is not precisely defined by law.
258
+
259
+ If such an object file uses only numerical parameters, data
260
+ structure layouts and accessors, and small macros and small inline
261
+ functions (ten lines or less in length), then the use of the object
262
+ file is unrestricted, regardless of whether it is legally a derivative
263
+ work. (Executables containing this object code plus portions of the
264
+ Library will still fall under Section 6.)
265
+
266
+ Otherwise, if the work is a derivative of the Library, you may
267
+ distribute the object code for the work under the terms of Section 6.
268
+ Any executables containing that work also fall under Section 6,
269
+ whether or not they are linked directly with the Library itself.
270
+
271
+ 6. As an exception to the Sections above, you may also combine or
272
+ link a "work that uses the Library" with the Library to produce a
273
+ work containing portions of the Library, and distribute that work
274
+ under terms of your choice, provided that the terms permit
275
+ modification of the work for the customer's own use and reverse
276
+ engineering for debugging such modifications.
277
+
278
+ You must give prominent notice with each copy of the work that the
279
+ Library is used in it and that the Library and its use are covered by
280
+ this License. You must supply a copy of this License. If the work
281
+ during execution displays copyright notices, you must include the
282
+ copyright notice for the Library among them, as well as a reference
283
+ directing the user to the copy of this License. Also, you must do one
284
+ of these things:
285
+
286
+ a) Accompany the work with the complete corresponding
287
+ machine-readable source code for the Library including whatever
288
+ changes were used in the work (which must be distributed under
289
+ Sections 1 and 2 above); and, if the work is an executable linked
290
+ with the Library, with the complete machine-readable "work that
291
+ uses the Library", as object code and/or source code, so that the
292
+ user can modify the Library and then relink to produce a modified
293
+ executable containing the modified Library. (It is understood
294
+ that the user who changes the contents of definitions files in the
295
+ Library will not necessarily be able to recompile the application
296
+ to use the modified definitions.)
297
+
298
+ b) Use a suitable shared library mechanism for linking with the
299
+ Library. A suitable mechanism is one that (1) uses at run time a
300
+ copy of the library already present on the user's computer system,
301
+ rather than copying library functions into the executable, and (2)
302
+ will operate properly with a modified version of the library, if
303
+ the user installs one, as long as the modified version is
304
+ interface-compatible with the version that the work was made with.
305
+
306
+ c) Accompany the work with a written offer, valid for at
307
+ least three years, to give the same user the materials
308
+ specified in Subsection 6a, above, for a charge no more
309
+ than the cost of performing this distribution.
310
+
311
+ d) If distribution of the work is made by offering access to copy
312
+ from a designated place, offer equivalent access to copy the above
313
+ specified materials from the same place.
314
+
315
+ e) Verify that the user has already received a copy of these
316
+ materials or that you have already sent this user a copy.
317
+
318
+ For an executable, the required form of the "work that uses the
319
+ Library" must include any data and utility programs needed for
320
+ reproducing the executable from it. However, as a special exception,
321
+ the materials to be distributed need not include anything that is
322
+ normally distributed (in either source or binary form) with the major
323
+ components (compiler, kernel, and so on) of the operating system on
324
+ which the executable runs, unless that component itself accompanies
325
+ the executable.
326
+
327
+ It may happen that this requirement contradicts the license
328
+ restrictions of other proprietary libraries that do not normally
329
+ accompany the operating system. Such a contradiction means you cannot
330
+ use both them and the Library together in an executable that you
331
+ distribute.
332
+
333
+ 7. You may place library facilities that are a work based on the
334
+ Library side-by-side in a single library together with other library
335
+ facilities not covered by this License, and distribute such a combined
336
+ library, provided that the separate distribution of the work based on
337
+ the Library and of the other library facilities is otherwise
338
+ permitted, and provided that you do these two things:
339
+
340
+ a) Accompany the combined library with a copy of the same work
341
+ based on the Library, uncombined with any other library
342
+ facilities. This must be distributed under the terms of the
343
+ Sections above.
344
+
345
+ b) Give prominent notice with the combined library of the fact
346
+ that part of it is a work based on the Library, and explaining
347
+ where to find the accompanying uncombined form of the same work.
348
+
349
+ 8. You may not copy, modify, sublicense, link with, or distribute
350
+ the Library except as expressly provided under this License. Any
351
+ attempt otherwise to copy, modify, sublicense, link with, or
352
+ distribute the Library is void, and will automatically terminate your
353
+ rights under this License. However, parties who have received copies,
354
+ or rights, from you under this License will not have their licenses
355
+ terminated so long as such parties remain in full compliance.
356
+
357
+ 9. You are not required to accept this License, since you have not
358
+ signed it. However, nothing else grants you permission to modify or
359
+ distribute the Library or its derivative works. These actions are
360
+ prohibited by law if you do not accept this License. Therefore, by
361
+ modifying or distributing the Library (or any work based on the
362
+ Library), you indicate your acceptance of this License to do so, and
363
+ all its terms and conditions for copying, distributing or modifying
364
+ the Library or works based on it.
365
+
366
+ 10. Each time you redistribute the Library (or any work based on the
367
+ Library), the recipient automatically receives a license from the
368
+ original licensor to copy, distribute, link with or modify the Library
369
+ subject to these terms and conditions. You may not impose any further
370
+ restrictions on the recipients' exercise of the rights granted herein.
371
+ You are not responsible for enforcing compliance by third parties with
372
+ this License.
373
+
374
+ 11. If, as a consequence of a court judgment or allegation of patent
375
+ infringement or for any other reason (not limited to patent issues),
376
+ conditions are imposed on you (whether by court order, agreement or
377
+ otherwise) that contradict the conditions of this License, they do not
378
+ excuse you from the conditions of this License. If you cannot
379
+ distribute so as to satisfy simultaneously your obligations under this
380
+ License and any other pertinent obligations, then as a consequence you
381
+ may not distribute the Library at all. For example, if a patent
382
+ license would not permit royalty-free redistribution of the Library by
383
+ all those who receive copies directly or indirectly through you, then
384
+ the only way you could satisfy both it and this License would be to
385
+ refrain entirely from distribution of the Library.
386
+
387
+ If any portion of this section is held invalid or unenforceable under any
388
+ particular circumstance, the balance of the section is intended to apply,
389
+ and the section as a whole is intended to apply in other circumstances.
390
+
391
+ It is not the purpose of this section to induce you to infringe any
392
+ patents or other property right claims or to contest validity of any
393
+ such claims; this section has the sole purpose of protecting the
394
+ integrity of the free software distribution system which is
395
+ implemented by public license practices. Many people have made
396
+ generous contributions to the wide range of software distributed
397
+ through that system in reliance on consistent application of that
398
+ system; it is up to the author/donor to decide if he or she is willing
399
+ to distribute software through any other system and a licensee cannot
400
+ impose that choice.
401
+
402
+ This section is intended to make thoroughly clear what is believed to
403
+ be a consequence of the rest of this License.
404
+
405
+ 12. If the distribution and/or use of the Library is restricted in
406
+ certain countries either by patents or by copyrighted interfaces, the
407
+ original copyright holder who places the Library under this License may add
408
+ an explicit geographical distribution limitation excluding those countries,
409
+ so that distribution is permitted only in or among countries not thus
410
+ excluded. In such case, this License incorporates the limitation as if
411
+ written in the body of this License.
412
+
413
+ 13. The Free Software Foundation may publish revised and/or new
414
+ versions of the Lesser General Public License from time to time.
415
+ Such new versions will be similar in spirit to the present version,
416
+ but may differ in detail to address new problems or concerns.
417
+
418
+ Each version is given a distinguishing version number. If the Library
419
+ specifies a version number of this License which applies to it and
420
+ "any later version", you have the option of following the terms and
421
+ conditions either of that version or of any later version published by
422
+ the Free Software Foundation. If the Library does not specify a
423
+ license version number, you may choose any version ever published by
424
+ the Free Software Foundation.
425
+
426
+ 14. If you wish to incorporate parts of the Library into other free
427
+ programs whose distribution conditions are incompatible with these,
428
+ write to the author to ask for permission. For software which is
429
+ copyrighted by the Free Software Foundation, write to the Free
430
+ Software Foundation; we sometimes make exceptions for this. Our
431
+ decision will be guided by the two goals of preserving the free status
432
+ of all derivatives of our free software and of promoting the sharing
433
+ and reuse of software generally.
434
+
435
+ NO WARRANTY
436
+
437
+ 15. BECAUSE THE LIBRARY IS LICENSED FREE OF CHARGE, THERE IS NO
438
+ WARRANTY FOR THE LIBRARY, TO THE EXTENT PERMITTED BY APPLICABLE LAW.
439
+ EXCEPT WHEN OTHERWISE STATED IN WRITING THE COPYRIGHT HOLDERS AND/OR
440
+ OTHER PARTIES PROVIDE THE LIBRARY "AS IS" WITHOUT WARRANTY OF ANY
441
+ KIND, EITHER EXPRESSED OR IMPLIED, INCLUDING, BUT NOT LIMITED TO, THE
442
+ IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR
443
+ PURPOSE. THE ENTIRE RISK AS TO THE QUALITY AND PERFORMANCE OF THE
444
+ LIBRARY IS WITH YOU. SHOULD THE LIBRARY PROVE DEFECTIVE, YOU ASSUME
445
+ THE COST OF ALL NECESSARY SERVICING, REPAIR OR CORRECTION.
446
+
447
+ 16. IN NO EVENT UNLESS REQUIRED BY APPLICABLE LAW OR AGREED TO IN
448
+ WRITING WILL ANY COPYRIGHT HOLDER, OR ANY OTHER PARTY WHO MAY MODIFY
449
+ AND/OR REDISTRIBUTE THE LIBRARY AS PERMITTED ABOVE, BE LIABLE TO YOU
450
+ FOR DAMAGES, INCLUDING ANY GENERAL, SPECIAL, INCIDENTAL OR
451
+ CONSEQUENTIAL DAMAGES ARISING OUT OF THE USE OR INABILITY TO USE THE
452
+ LIBRARY (INCLUDING BUT NOT LIMITED TO LOSS OF DATA OR DATA BEING
453
+ RENDERED INACCURATE OR LOSSES SUSTAINED BY YOU OR THIRD PARTIES OR A
454
+ FAILURE OF THE LIBRARY TO OPERATE WITH ANY OTHER SOFTWARE), EVEN IF
455
+ SUCH HOLDER OR OTHER PARTY HAS BEEN ADVISED OF THE POSSIBILITY OF SUCH
456
+ DAMAGES.
457
+
458
+ END OF TERMS AND CONDITIONS
459
+
460
+ How to Apply These Terms to Your New Libraries
461
+
462
+ If you develop a new library, and you want it to be of the greatest
463
+ possible use to the public, we recommend making it free software that
464
+ everyone can redistribute and change. You can do so by permitting
465
+ redistribution under these terms (or, alternatively, under the terms of the
466
+ ordinary General Public License).
467
+
468
+ To apply these terms, attach the following notices to the library. It is
469
+ safest to attach them to the start of each source file to most effectively
470
+ convey the exclusion of warranty; and each file should have at least the
471
+ "copyright" line and a pointer to where the full notice is found.
472
+
473
+ <one line to give the library's name and a brief idea of what it does.>
474
+ Copyright (C) <year> <name of author>
475
+
476
+ This library is free software; you can redistribute it and/or
477
+ modify it under the terms of the GNU Lesser General Public
478
+ License as published by the Free Software Foundation; either
479
+ version 2.1 of the License, or (at your option) any later version.
480
+
481
+ This library is distributed in the hope that it will be useful,
482
+ but WITHOUT ANY WARRANTY; without even the implied warranty of
483
+ MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU
484
+ Lesser General Public License for more details.
485
+
486
+ You should have received a copy of the GNU Lesser General Public
487
+ License along with this library; if not, write to the Free Software
488
+ Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA
489
+
490
+ Also add information on how to contact you by electronic and paper mail.
491
+
492
+ You should also get your employer (if you work as a programmer) or your
493
+ school, if any, to sign a "copyright disclaimer" for the library, if
494
+ necessary. Here is a sample; alter the names:
495
+
496
+ Yoyodyne, Inc., hereby disclaims all copyright interest in the
497
+ library `Frob' (a library for tweaking knobs) written by James Random Hacker.
498
+
499
+ <signature of Ty Coon>, 1 April 1990
500
+ Ty Coon, President of Vice
501
+
502
+ That's all there is to it!
503
+
504
+
classes/PHPExcel/Shared/PCLZip/pclzip.lib.php CHANGED
File without changes
classes/PHPExcel/Shared/PCLZip/readme.txt CHANGED
File without changes
classes/PHPExcel/Shared/PasswordHasher.php CHANGED
File without changes
classes/PHPExcel/Shared/String.php CHANGED
File without changes
classes/PHPExcel/Shared/TimeZone.php CHANGED
File without changes
classes/PHPExcel/Shared/XMLWriter.php CHANGED
File without changes
classes/PHPExcel/Shared/ZipArchive.php CHANGED
File without changes
classes/PHPExcel/Shared/ZipStreamWrapper.php CHANGED
File without changes
classes/PHPExcel/Shared/trend/bestFitClass.php CHANGED
File without changes
classes/PHPExcel/Shared/trend/exponentialBestFitClass.php CHANGED
File without changes
classes/PHPExcel/Shared/trend/linearBestFitClass.php CHANGED
File without changes
classes/PHPExcel/Shared/trend/logarithmicBestFitClass.php CHANGED
File without changes
classes/PHPExcel/Shared/trend/polynomialBestFitClass.php CHANGED
File without changes
classes/PHPExcel/Shared/trend/powerBestFitClass.php CHANGED
File without changes
classes/PHPExcel/Shared/trend/trendClass.php CHANGED
File without changes
classes/PHPExcel/Style.php CHANGED
File without changes
classes/PHPExcel/Style/Alignment.php CHANGED
File without changes
classes/PHPExcel/Style/Border.php CHANGED
File without changes
classes/PHPExcel/Style/Borders.php CHANGED
File without changes
classes/PHPExcel/Style/Color.php CHANGED
File without changes
classes/PHPExcel/Style/Conditional.php CHANGED
File without changes
classes/PHPExcel/Style/Fill.php CHANGED
File without changes
classes/PHPExcel/Style/Font.php CHANGED
File without changes
classes/PHPExcel/Style/NumberFormat.php CHANGED
File without changes
classes/PHPExcel/Style/Protection.php CHANGED
File without changes
classes/PHPExcel/Style/Supervisor.php CHANGED
File without changes
classes/PHPExcel/Worksheet.php CHANGED
File without changes
classes/PHPExcel/Worksheet/AutoFilter.php CHANGED
File without changes
classes/PHPExcel/Worksheet/AutoFilter/Column.php CHANGED
File without changes
classes/PHPExcel/Worksheet/AutoFilter/Column/Rule.php CHANGED
File without changes
classes/PHPExcel/Worksheet/BaseDrawing.php CHANGED
File without changes
classes/PHPExcel/Worksheet/CellIterator.php CHANGED
File without changes
classes/PHPExcel/Worksheet/Column.php CHANGED
File without changes
classes/PHPExcel/Worksheet/ColumnCellIterator.php CHANGED
File without changes
classes/PHPExcel/Worksheet/ColumnDimension.php CHANGED
File without changes
classes/PHPExcel/Worksheet/ColumnIterator.php CHANGED
File without changes
classes/PHPExcel/Worksheet/Drawing.php CHANGED
File without changes
classes/PHPExcel/Worksheet/Drawing/Shadow.php CHANGED
File without changes
classes/PHPExcel/Worksheet/HeaderFooter.php CHANGED
File without changes
classes/PHPExcel/Worksheet/HeaderFooterDrawing.php CHANGED
File without changes
classes/PHPExcel/Worksheet/MemoryDrawing.php CHANGED
File without changes
classes/PHPExcel/Worksheet/PageMargins.php CHANGED
File without changes
classes/PHPExcel/Worksheet/PageSetup.php CHANGED
File without changes
classes/PHPExcel/Worksheet/Protection.php CHANGED
File without changes
classes/PHPExcel/Worksheet/Row.php CHANGED
File without changes
classes/PHPExcel/Worksheet/RowCellIterator.php CHANGED
File without changes
classes/PHPExcel/Worksheet/RowDimension.php CHANGED
File without changes
classes/PHPExcel/Worksheet/RowIterator.php CHANGED
File without changes
classes/PHPExcel/Worksheet/SheetView.php CHANGED
File without changes
classes/PHPExcel/WorksheetIterator.php CHANGED
File without changes
classes/PHPExcel/Writer/Abstract.php CHANGED
File without changes
classes/PHPExcel/Writer/CSV.php CHANGED
File without changes
classes/PHPExcel/Writer/IWriter.php CHANGED
File without changes
classes/PHPExcel/locale/bg/config CHANGED
File without changes
classes/PHPExcel/locale/cs/config CHANGED
File without changes
classes/PHPExcel/locale/cs/functions CHANGED
File without changes
classes/PHPExcel/locale/da/config CHANGED
File without changes
classes/PHPExcel/locale/da/functions CHANGED
File without changes
classes/PHPExcel/locale/de/config CHANGED
File without changes
classes/PHPExcel/locale/de/functions CHANGED
File without changes
classes/PHPExcel/locale/en/uk/config CHANGED
File without changes
classes/PHPExcel/locale/es/config CHANGED
File without changes
classes/PHPExcel/locale/es/functions CHANGED
File without changes
classes/PHPExcel/locale/fi/config CHANGED
File without changes
classes/PHPExcel/locale/fi/functions CHANGED
File without changes
classes/PHPExcel/locale/fr/config CHANGED
File without changes
classes/PHPExcel/locale/fr/functions CHANGED
File without changes
classes/PHPExcel/locale/hu/config CHANGED
File without changes
classes/PHPExcel/locale/hu/functions CHANGED
File without changes
classes/PHPExcel/locale/it/config CHANGED
File without changes
classes/PHPExcel/locale/it/functions CHANGED
File without changes
classes/PHPExcel/locale/nl/config CHANGED
File without changes
classes/PHPExcel/locale/nl/functions CHANGED
File without changes
classes/PHPExcel/locale/no/config CHANGED
File without changes
classes/PHPExcel/locale/no/functions CHANGED
File without changes
classes/PHPExcel/locale/pl/config CHANGED
File without changes
classes/PHPExcel/locale/pl/functions CHANGED
File without changes
classes/PHPExcel/locale/pt/br/config CHANGED
File without changes
classes/PHPExcel/locale/pt/br/functions CHANGED
File without changes
classes/PHPExcel/locale/pt/config CHANGED
File without changes
classes/PHPExcel/locale/pt/functions CHANGED
File without changes
classes/PHPExcel/locale/ru/config CHANGED
File without changes
classes/PHPExcel/locale/ru/functions CHANGED
File without changes
classes/PHPExcel/locale/sv/config CHANGED
File without changes
classes/PHPExcel/locale/sv/functions CHANGED
@@ -1,408 +1,408 @@
1
- ##
2
- ## Add-in and Automation functions Tilläggs- och automatiseringsfunktioner
3
- ##
4
- GETPIVOTDATA = HÄMTA.PIVOTDATA ## Returnerar data som lagrats i en pivottabellrapport
5
-
6
-
7
- ##
8
- ## Cube functions Kubfunktioner
9
- ##
10
- CUBEKPIMEMBER = KUBKPIMEDLEM ## Returnerar namn, egenskap och mått för en KPI och visar namnet och egenskapen i cellen. En KPI, eller prestandaindikator, är ett kvantifierbart mått, t.ex. månatlig bruttovinst eller personalomsättning per kvartal, som används för att analysera ett företags resultat.
11
- CUBEMEMBER = KUBMEDLEM ## Returnerar en medlem eller ett par i en kubhierarki. Används för att verifiera att medlemmen eller paret finns i kuben.
12
- CUBEMEMBERPROPERTY = KUBMEDLEMSEGENSKAP ## Returnerar värdet för en medlemsegenskap i kuben. Används för att verifiera att ett medlemsnamn finns i kuben, samt för att returnera den angivna egenskapen för medlemmen.
13
- CUBERANKEDMEMBER = KUBRANGORDNADMEDLEM ## Returnerar den n:te, eller rangordnade, medlemmen i en uppsättning. Används för att returnera ett eller flera element i en uppsättning, till exempelvis den bästa försäljaren eller de tio bästa eleverna.
14
- CUBESET = KUBINSTÄLLNING ## Definierar en beräknad uppsättning medlemmar eller par genom att skicka ett bestämt uttryck till kuben på servern, som skapar uppsättningen och sedan returnerar den till Microsoft Office Excel.
15
- CUBESETCOUNT = KUBINSTÄLLNINGANTAL ## Returnerar antalet objekt i en uppsättning.
16
- CUBEVALUE = KUBVÄRDE ## Returnerar ett mängdvärde från en kub.
17
-
18
-
19
- ##
20
- ## Database functions Databasfunktioner
21
- ##
22
- DAVERAGE = DMEDEL ## Returnerar medelvärdet av databasposterna
23
- DCOUNT = DANTAL ## Räknar antalet celler som innehåller tal i en databas
24
- DCOUNTA = DANTALV ## Räknar ifyllda celler i en databas
25
- DGET = DHÄMTA ## Hämtar en enstaka post från en databas som uppfyller de angivna villkoren
26
- DMAX = DMAX ## Returnerar det största värdet från databasposterna
27
- DMIN = DMIN ## Returnerar det minsta värdet från databasposterna
28
- DPRODUCT = DPRODUKT ## Multiplicerar värdena i ett visst fält i poster som uppfyller villkoret
29
- DSTDEV = DSTDAV ## Uppskattar standardavvikelsen baserat på ett urval av databasposterna
30
- DSTDEVP = DSTDAVP ## Beräknar standardavvikelsen utifrån hela populationen av valda databasposter
31
- DSUM = DSUMMA ## Summerar talen i kolumnfält i databasposter som uppfyller villkoret
32
- DVAR = DVARIANS ## Uppskattar variansen baserat på ett urval av databasposterna
33
- DVARP = DVARIANSP ## Beräknar variansen utifrån hela populationen av valda databasposter
34
-
35
-
36
- ##
37
- ## Date and time functions Tid- och datumfunktioner
38
- ##
39
- DATE = DATUM ## Returnerar ett serienummer för ett visst datum
40
- DATEVALUE = DATUMVÄRDE ## Konverterar ett datum i textformat till ett serienummer
41
- DAY = DAG ## Konverterar ett serienummer till dag i månaden
42
- DAYS360 = DAGAR360 ## Beräknar antalet dagar mellan två datum baserat på ett 360-dagarsår
43
- EDATE = EDATUM ## Returnerar serienumret för ett datum som infaller ett visst antal månader före eller efter startdatumet
44
- EOMONTH = SLUTMÅNAD ## Returnerar serienumret för sista dagen i månaden ett visst antal månader tidigare eller senare
45
- HOUR = TIMME ## Konverterar ett serienummer till en timme
46
- MINUTE = MINUT ## Konverterar ett serienummer till en minut
47
- MONTH = MÅNAD ## Konverterar ett serienummer till en månad
48
- NETWORKDAYS = NETTOARBETSDAGAR ## Returnerar antalet hela arbetsdagar mellan två datum
49
- NOW = NU ## Returnerar serienumret för dagens datum och aktuell tid
50
- SECOND = SEKUND ## Konverterar ett serienummer till en sekund
51
- TIME = KLOCKSLAG ## Returnerar serienumret för en viss tid
52
- TIMEVALUE = TIDVÄRDE ## Konverterar en tid i textformat till ett serienummer
53
- TODAY = IDAG ## Returnerar serienumret för dagens datum
54
- WEEKDAY = VECKODAG ## Konverterar ett serienummer till en dag i veckan
55
- WEEKNUM = VECKONR ## Konverterar ett serienummer till ett veckonummer
56
- WORKDAY = ARBETSDAGAR ## Returnerar serienumret för ett datum ett visst antal arbetsdagar tidigare eller senare
57
- YEAR = ÅR ## Konverterar ett serienummer till ett år
58
- YEARFRAC = ÅRDEL ## Returnerar en del av ett år som representerar antalet hela dagar mellan start- och slutdatum
59
-
60
-
61
- ##
62
- ## Engineering functions Tekniska funktioner
63
- ##
64
- BESSELI = BESSELI ## Returnerar den modifierade Bessel-funktionen In(x)
65
- BESSELJ = BESSELJ ## Returnerar Bessel-funktionen Jn(x)
66
- BESSELK = BESSELK ## Returnerar den modifierade Bessel-funktionen Kn(x)
67
- BESSELY = BESSELY ## Returnerar Bessel-funktionen Yn(x)
68
- BIN2DEC = BIN.TILL.DEC ## Omvandlar ett binärt tal till decimalt
69
- BIN2HEX = BIN.TILL.HEX ## Omvandlar ett binärt tal till hexadecimalt
70
- BIN2OCT = BIN.TILL.OKT ## Omvandlar ett binärt tal till oktalt
71
- COMPLEX = KOMPLEX ## Omvandlar reella och imaginära koefficienter till ett komplext tal
72
- CONVERT = KONVERTERA ## Omvandlar ett tal från ett måttsystem till ett annat
73
- DEC2BIN = DEC.TILL.BIN ## Omvandlar ett decimalt tal till binärt
74
- DEC2HEX = DEC.TILL.HEX ## Omvandlar ett decimalt tal till hexadecimalt
75
- DEC2OCT = DEC.TILL.OKT ## Omvandlar ett decimalt tal till oktalt
76
- DELTA = DELTA ## Testar om två värden är lika
77
- ERF = FELF ## Returnerar felfunktionen
78
- ERFC = FELFK ## Returnerar den komplementära felfunktionen
79
- GESTEP = SLSTEG ## Testar om ett tal är större än ett tröskelvärde
80
- HEX2BIN = HEX.TILL.BIN ## Omvandlar ett hexadecimalt tal till binärt
81
- HEX2DEC = HEX.TILL.DEC ## Omvandlar ett hexadecimalt tal till decimalt
82
- HEX2OCT = HEX.TILL.OKT ## Omvandlar ett hexadecimalt tal till oktalt
83
- IMABS = IMABS ## Returnerar absolutvärdet (modulus) för ett komplext tal
84
- IMAGINARY = IMAGINÄR ## Returnerar den imaginära koefficienten för ett komplext tal
85
- IMARGUMENT = IMARGUMENT ## Returnerar det komplexa talets argument, en vinkel uttryckt i radianer
86
- IMCONJUGATE = IMKONJUGAT ## Returnerar det komplexa talets konjugat
87
- IMCOS = IMCOS ## Returnerar cosinus för ett komplext tal
88
- IMDIV = IMDIV ## Returnerar kvoten för två komplexa tal
89
- IMEXP = IMEUPPHÖJT ## Returnerar exponenten för ett komplext tal
90
- IMLN = IMLN ## Returnerar den naturliga logaritmen för ett komplext tal
91
- IMLOG10 = IMLOG10 ## Returnerar 10-logaritmen för ett komplext tal
92
- IMLOG2 = IMLOG2 ## Returnerar 2-logaritmen för ett komplext tal
93
- IMPOWER = IMUPPHÖJT ## Returnerar ett komplext tal upphöjt till en exponent
94
- IMPRODUCT = IMPRODUKT ## Returnerar produkten av komplexa tal
95
- IMREAL = IMREAL ## Returnerar den reella koefficienten för ett komplext tal
96
- IMSIN = IMSIN ## Returnerar sinus för ett komplext tal
97
- IMSQRT = IMROT ## Returnerar kvadratroten av ett komplext tal
98
- IMSUB = IMDIFF ## Returnerar differensen mellan två komplexa tal
99
- IMSUM = IMSUM ## Returnerar summan av komplexa tal
100
- OCT2BIN = OKT.TILL.BIN ## Omvandlar ett oktalt tal till binärt
101
- OCT2DEC = OKT.TILL.DEC ## Omvandlar ett oktalt tal till decimalt
102
- OCT2HEX = OKT.TILL.HEX ## Omvandlar ett oktalt tal till hexadecimalt
103
-
104
-
105
- ##
106
- ## Financial functions Finansiella funktioner
107
- ##
108
- ACCRINT = UPPLRÄNTA ## Returnerar den upplupna räntan för värdepapper med periodisk ränta
109
- ACCRINTM = UPPLOBLRÄNTA ## Returnerar den upplupna räntan för ett värdepapper som ger avkastning på förfallodagen
110
- AMORDEGRC = AMORDEGRC ## Returnerar avskrivningen för varje redovisningsperiod med hjälp av en avskrivningskoefficient
111
- AMORLINC = AMORLINC ## Returnerar avskrivningen för varje redovisningsperiod
112
- COUPDAYBS = KUPDAGBB ## Returnerar antal dagar från början av kupongperioden till likviddagen
113
- COUPDAYS = KUPDAGARS ## Returnerar antalet dagar i kupongperioden som innehåller betalningsdatumet
114
- COUPDAYSNC = KUPDAGNK ## Returnerar antalet dagar från betalningsdatumet till nästa kupongdatum
115
- COUPNCD = KUPNKD ## Returnerar nästa kupongdatum efter likviddagen
116
- COUPNUM = KUPANT ## Returnerar kuponger som förfaller till betalning mellan likviddagen och förfallodagen
117
- COUPPCD = KUPFKD ## Returnerar föregående kupongdatum före likviddagen
118
- CUMIPMT = KUMRÄNTA ## Returnerar den ackumulerade räntan som betalats mellan två perioder
119
- CUMPRINC = KUMPRIS ## Returnerar det ackumulerade kapitalbeloppet som betalats på ett lån mellan två perioder
120
- DB = DB ## Returnerar avskrivningen för en tillgång under en angiven tid enligt metoden för fast degressiv avskrivning
121
- DDB = DEGAVSKR ## Returnerar en tillgångs värdeminskning under en viss period med hjälp av dubbel degressiv avskrivning eller någon annan metod som du anger
122
- DISC = DISK ## Returnerar diskonteringsräntan för ett värdepapper
123
- DOLLARDE = DECTAL ## Omvandlar ett pris uttryckt som ett bråk till ett decimaltal
124
- DOLLARFR = BRÅK ## Omvandlar ett pris i kronor uttryckt som ett decimaltal till ett bråk
125
- DURATION = LÖPTID ## Returnerar den årliga löptiden för en säkerhet med periodiska räntebetalningar
126
- EFFECT = EFFRÄNTA ## Returnerar den årliga effektiva räntesatsen
127
- FV = SLUTVÄRDE ## Returnerar det framtida värdet på en investering
128
- FVSCHEDULE = FÖRRÄNTNING ## Returnerar det framtida värdet av ett begynnelsekapital beräknat på olika räntenivåer
129
- INTRATE = ÅRSRÄNTA ## Returnerar räntesatsen för ett betalt värdepapper
130
- IPMT = RBETALNING ## Returnerar räntedelen av en betalning för en given period
131
- IRR = IR ## Returnerar internräntan för en serie betalningar
132
- ISPMT = RALÅN ## Beräknar räntan som har betalats under en specifik betalningsperiod
133
- MDURATION = MLÖPTID ## Returnerar den modifierade Macauley-löptiden för ett värdepapper med det antagna nominella värdet 100 kr
134
- MIRR = MODIR ## Returnerar internräntan där positiva och negativa betalningar finansieras med olika räntor
135
- NOMINAL = NOMRÄNTA ## Returnerar den årliga nominella räntesatsen
136
- NPER = PERIODER ## Returnerar antalet perioder för en investering
137
- NPV = NETNUVÄRDE ## Returnerar nuvärdet av en serie periodiska betalningar vid en given diskonteringsränta
138
- ODDFPRICE = UDDAFPRIS ## Returnerar priset per 100 kr nominellt värde för ett värdepapper med en udda första period
139
- ODDFYIELD = UDDAFAVKASTNING ## Returnerar avkastningen för en säkerhet med en udda första period
140
- ODDLPRICE = UDDASPRIS ## Returnerar priset per 100 kr nominellt värde för ett värdepapper med en udda sista period
141
- ODDLYIELD = UDDASAVKASTNING ## Returnerar avkastningen för en säkerhet med en udda sista period
142
- PMT = BETALNING ## Returnerar den periodiska betalningen för en annuitet
143
- PPMT = AMORT ## Returnerar amorteringsdelen av en annuitetsbetalning för en given period
144
- PRICE = PRIS ## Returnerar priset per 100 kr nominellt värde för ett värdepapper som ger periodisk ränta
145
- PRICEDISC = PRISDISK ## Returnerar priset per 100 kr nominellt värde för ett diskonterat värdepapper
146
- PRICEMAT = PRISFÖRF ## Returnerar priset per 100 kr nominellt värde för ett värdepapper som ger ränta på förfallodagen
147
- PV = PV ## Returnerar nuvärdet av en serie lika stora periodiska betalningar
148
- RATE = RÄNTA ## Returnerar räntesatsen per period i en annuitet
149
- RECEIVED = BELOPP ## Returnerar beloppet som utdelas på förfallodagen för ett betalat värdepapper
150
- SLN = LINAVSKR ## Returnerar den linjära avskrivningen för en tillgång under en period
151
- SYD = ÅRSAVSKR ## Returnerar den årliga avskrivningssumman för en tillgång under en angiven period
152
- TBILLEQ = SSVXEKV ## Returnerar avkastningen motsvarande en obligation för en statsskuldväxel
153
- TBILLPRICE = SSVXPRIS ## Returnerar priset per 100 kr nominellt värde för en statsskuldväxel
154
- TBILLYIELD = SSVXRÄNTA ## Returnerar avkastningen för en statsskuldväxel
155
- VDB = VDEGRAVSKR ## Returnerar avskrivningen för en tillgång under en angiven period (med degressiv avskrivning)
156
- XIRR = XIRR ## Returnerar internräntan för en serie betalningar som inte nödvändigtvis är periodiska
157
- XNPV = XNUVÄRDE ## Returnerar det nuvarande nettovärdet för en serie betalningar som inte nödvändigtvis är periodiska
158
- YIELD = NOMAVK ## Returnerar avkastningen för ett värdepapper som ger periodisk ränta
159
- YIELDDISC = NOMAVKDISK ## Returnerar den årliga avkastningen för diskonterade värdepapper, exempelvis en statsskuldväxel
160
- YIELDMAT = NOMAVKFÖRF ## Returnerar den årliga avkastningen för ett värdepapper som ger ränta på förfallodagen
161
-
162
-
163
- ##
164
- ## Information functions Informationsfunktioner
165
- ##
166
- CELL = CELL ## Returnerar information om formatering, plats och innehåll i en cell
167
- ERROR.TYPE = FEL.TYP ## Returnerar ett tal som motsvarar ett felvärde
168
- INFO = INFO ## Returnerar information om operativsystemet
169
- ISBLANK = ÄRREF ## Returnerar SANT om värdet är tomt
170
- ISERR = Ä ## Returnerar SANT om värdet är ett felvärde annat än #SAKNAS!
171
- ISERROR = ÄRFEL ## Returnerar SANT om värdet är ett felvärde
172
- ISEVEN = ÄRJÄMN ## Returnerar SANT om talet är jämnt
173
- ISLOGICAL = ÄREJTEXT ## Returnerar SANT om värdet är ett logiskt värde
174
- ISNA = ÄRLOGISK ## Returnerar SANT om värdet är felvärdet #SAKNAS!
175
- ISNONTEXT = ÄRSAKNAD ## Returnerar SANT om värdet inte är text
176
- ISNUMBER = ÄRTAL ## Returnerar SANT om värdet är ett tal
177
- ISODD = ÄRUDDA ## Returnerar SANT om talet är udda
178
- ISREF = ÄRTOM ## Returnerar SANT om värdet är en referens
179
- ISTEXT = ÄRTEXT ## Returnerar SANT om värdet är text
180
- N = N ## Returnerar ett värde omvandlat till ett tal
181
- NA = SAKNAS ## Returnerar felvärdet #SAKNAS!
182
- TYPE = VÄRDETYP ## Returnerar ett tal som anger värdets datatyp
183
-
184
-
185
- ##
186
- ## Logical functions Logiska funktioner
187
- ##
188
- AND = OCH ## Returnerar SANT om alla argument är sanna
189
- FALSE = FALSKT ## Returnerar det logiska värdet FALSKT
190
- IF = OM ## Anger vilket logiskt test som ska utföras
191
- IFERROR = OMFEL ## Returnerar ett värde som du anger om en formel utvärderar till ett fel; annars returneras resultatet av formeln
192
- NOT = ICKE ## Inverterar logiken för argumenten
193
- OR = ELLER ## Returnerar SANT om något argument är SANT
194
- TRUE = SANT ## Returnerar det logiska värdet SANT
195
-
196
-
197
- ##
198
- ## Lookup and reference functions Sök- och referensfunktioner
199
- ##
200
- ADDRESS = ADRESS ## Returnerar en referens som text till en enstaka cell i ett kalkylblad
201
- AREAS = OMRÅDEN ## Returnerar antalet områden i en referens
202
- CHOOSE = VÄLJ ## Väljer ett värde i en lista över värden
203
- COLUMN = KOLUMN ## Returnerar kolumnnumret för en referens
204
- COLUMNS = KOLUMNER ## Returnerar antalet kolumner i en referens
205
- HLOOKUP = LETAKOLUMN ## Söker i den översta raden i en matris och returnerar värdet för angiven cell
206
- HYPERLINK = HYPERLÄNK ## Skapar en genväg eller ett hopp till ett dokument i nätverket, i ett intranät eller på Internet
207
- INDEX = INDEX ## Använder ett index för ett välja ett värde i en referens eller matris
208
- INDIRECT = INDIREKT ## Returnerar en referens som anges av ett textvärde
209
- LOOKUP = LETAUPP ## Letar upp värden i en vektor eller matris
210
- MATCH = PASSA ## Letar upp värden i en referens eller matris
211
- OFFSET = FÖRSKJUTNING ## Returnerar en referens förskjuten i förhållande till en given referens
212
- ROW = RAD ## Returnerar radnumret för en referens
213
- ROWS = RADER ## Returnerar antalet rader i en referens
214
- RTD = RTD ## Hämtar realtidsdata från ett program som stöder COM-automation (Automation: Ett sätt att arbeta med ett programs objekt från ett annat program eller utvecklingsverktyg. Detta kallades tidigare för OLE Automation, och är en branschstandard och ingår i Component Object Model (COM).)
215
- TRANSPOSE = TRANSPONERA ## Transponerar en matris
216
- VLOOKUP = LETARAD ## Letar i den första kolumnen i en matris och flyttar över raden för att returnera värdet för en cell
217
-
218
-
219
- ##
220
- ## Math and trigonometry functions Matematiska och trigonometriska funktioner
221
- ##
222
- ABS = ABS ## Returnerar absolutvärdet av ett tal
223
- ACOS = ARCCOS ## Returnerar arcus cosinus för ett tal
224
- ACOSH = ARCCOSH ## Returnerar inverterad hyperbolisk cosinus för ett tal
225
- ASIN = ARCSIN ## Returnerar arcus cosinus för ett tal
226
- ASINH = ARCSINH ## Returnerar hyperbolisk arcus sinus för ett tal
227
- ATAN = ARCTAN ## Returnerar arcus tangens för ett tal
228
- ATAN2 = ARCTAN2 ## Returnerar arcus tangens för en x- och en y- koordinat
229
- ATANH = ARCTANH ## Returnerar hyperbolisk arcus tangens för ett tal
230
- CEILING = RUNDA.UPP ## Avrundar ett tal till närmaste heltal eller närmaste signifikanta multipel
231
- COMBIN = KOMBIN ## Returnerar antalet kombinationer för ett givet antal objekt
232
- COS = COS ## Returnerar cosinus för ett tal
233
- COSH = COSH ## Returnerar hyperboliskt cosinus för ett tal
234
- DEGREES = GRADER ## Omvandlar radianer till grader
235
- EVEN = JÄMN ## Avrundar ett tal uppåt till närmaste heltal
236
- EXP = EXP ## Returnerar e upphöjt till ett givet tal
237
- FACT = FAKULTET ## Returnerar fakulteten för ett tal
238
- FACTDOUBLE = DUBBELFAKULTET ## Returnerar dubbelfakulteten för ett tal
239
- FLOOR = RUNDA.NED ## Avrundar ett tal nedåt mot noll
240
- GCD = SGD ## Returnerar den största gemensamma nämnaren
241
- INT = HELTAL ## Avrundar ett tal nedåt till närmaste heltal
242
- LCM = MGM ## Returnerar den minsta gemensamma multipeln
243
- LN = LN ## Returnerar den naturliga logaritmen för ett tal
244
- LOG = LOG ## Returnerar logaritmen för ett tal för en given bas
245
- LOG10 = LOG10 ## Returnerar 10-logaritmen för ett tal
246
- MDETERM = MDETERM ## Returnerar matrisen som är avgörandet av en matris
247
- MINVERSE = MINVERT ## Returnerar matrisinversen av en matris
248
- MMULT = MMULT ## Returnerar matrisprodukten av två matriser
249
- MOD = REST ## Returnerar resten vid en division
250
- MROUND = MAVRUNDA ## Returnerar ett tal avrundat till en given multipel
251
- MULTINOMIAL = MULTINOMIAL ## Returnerar multinomialen för en uppsättning tal
252
- ODD = UDDA ## Avrundar ett tal uppåt till närmaste udda heltal
253
- PI = PI ## Returnerar värdet pi
254
- POWER = UPPHÖJT.TILL ## Returnerar resultatet av ett tal upphöjt till en exponent
255
- PRODUCT = PRODUKT ## Multiplicerar argumenten
256
- QUOTIENT = KVOT ## Returnerar heltalsdelen av en division
257
- RADIANS = RADIANER ## Omvandlar grader till radianer
258
- RAND = SLUMP ## Returnerar ett slumptal mellan 0 och 1
259
- RANDBETWEEN = SLUMP.MELLAN ## Returnerar ett slumptal mellan de tal som du anger
260
- ROMAN = ROMERSK ## Omvandlar vanliga (arabiska) siffror till romerska som text
261
- ROUND = AVRUNDA ## Avrundar ett tal till ett angivet antal siffror
262
- ROUNDDOWN = AVRUNDA.NEDÅT ## Avrundar ett tal nedåt mot noll
263
- ROUNDUP = AVRUNDA.UPPÅT ## Avrundar ett tal uppåt, från noll
264
- SERIESSUM = SERIESUMMA ## Returnerar summan av en potensserie baserat på formeln
265
- SIGN = TECKEN ## Returnerar tecknet för ett tal
266
- SIN = SIN ## Returnerar sinus för en given vinkel
267
- SINH = SINH ## Returnerar hyperbolisk sinus för ett tal
268
- SQRT = ROT ## Returnerar den positiva kvadratroten
269
- SQRTPI = ROTPI ## Returnerar kvadratroten för (tal * pi)
270
- SUBTOTAL = DELSUMMA ## Returnerar en delsumma i en lista eller databas
271
- SUM = SUMMA ## Summerar argumenten
272
- SUMIF = SUMMA.OM ## Summerar celler enligt ett angivet villkor
273
- SUMIFS = SUMMA.OMF ## Lägger till cellerna i ett område som uppfyller flera kriterier
274
- SUMPRODUCT = PRODUKTSUMMA ## Returnerar summan av produkterna i motsvarande matriskomponenter
275
- SUMSQ = KVADRATSUMMA ## Returnerar summan av argumentens kvadrater
276
- SUMX2MY2 = SUMMAX2MY2 ## Returnerar summan av differensen mellan kvadraterna för motsvarande värden i två matriser
277
- SUMX2PY2 = SUMMAX2PY2 ## Returnerar summan av summan av kvadraterna av motsvarande värden i två matriser
278
- SUMXMY2 = SUMMAXMY2 ## Returnerar summan av kvadraten av skillnaden mellan motsvarande värden i två matriser
279
- TAN = TAN ## Returnerar tangens för ett tal
280
- TANH = TANH ## Returnerar hyperbolisk tangens för ett tal
281
- TRUNC = AVKORTA ## Avkortar ett tal till ett heltal
282
-
283
-
284
- ##
285
- ## Statistical functions Statistiska funktioner
286
- ##
287
- AVEDEV = MEDELAVV ## Returnerar medelvärdet för datapunkters absoluta avvikelse från deras medelvärde
288
- AVERAGE = MEDEL ## Returnerar medelvärdet av argumenten
289
- AVERAGEA = AVERAGEA ## Returnerar medelvärdet av argumenten, inklusive tal, text och logiska värden
290
- AVERAGEIF = MEDELOM ## Returnerar medelvärdet (aritmetiskt medelvärde) för alla celler i ett område som uppfyller ett givet kriterium
291
- AVERAGEIFS = MEDELOMF ## Returnerar medelvärdet (det aritmetiska medelvärdet) för alla celler som uppfyller flera villkor.
292
- BETADIST = BETAFÖRD ## Returnerar den kumulativa betafördelningsfunktionen
293
- BETAINV = BETAINV ## Returnerar inversen till den kumulativa fördelningsfunktionen för en viss betafördelning
294
- BINOMDIST = BINOMFÖRD ## Returnerar den individuella binomialfördelningen
295
- CHIDIST = CHI2FÖRD ## Returnerar den ensidiga sannolikheten av c2-fördelningen
296
- CHIINV = CHI2INV ## Returnerar inversen av chi2-fördelningen
297
- CHITEST = CHI2TEST ## Returnerar oberoendetesten
298
- CONFIDENCE = KONFIDENS ## Returnerar konfidensintervallet för en populations medelvärde
299
- CORREL = KORREL ## Returnerar korrelationskoefficienten mellan två datamängder
300
- COUNT = ANTAL ## Räknar hur många tal som finns bland argumenten
301
- COUNTA = ANTALV ## Räknar hur många värden som finns bland argumenten
302
- COUNTBLANK = ANTAL.TOMMA ## Räknar antalet tomma celler i ett område
303
- COUNTIF = ANTAL.OM ## Räknar antalet celler i ett område som uppfyller angivna villkor.
304
- COUNTIFS = ANTAL.OMF ## Räknar antalet celler i ett område som uppfyller flera villkor.
305
- COVAR = KOVAR ## Returnerar kovariansen, d.v.s. medelvärdet av produkterna för parade avvikelser
306
- CRITBINOM = KRITBINOM ## Returnerar det minsta värdet för vilket den kumulativa binomialfördelningen är mindre än eller lika med ett villkorsvärde
307
- DEVSQ = KVADAVV ## Returnerar summan av kvadrater på avvikelser
308
- EXPONDIST = EXPONFÖRD ## Returnerar exponentialfördelningen
309
- FDIST = FFÖRD ## Returnerar F-sannolikhetsfördelningen
310
- FINV = FINV ## Returnerar inversen till F-sannolikhetsfördelningen
311
- FISHER = FISHER ## Returnerar Fisher-transformationen
312
- FISHERINV = FISHERINV ## Returnerar inversen till Fisher-transformationen
313
- FORECAST = PREDIKTION ## Returnerar ett värde längs en linjär trendlinje
314
- FREQUENCY = FREKVENS ## Returnerar en frekvensfördelning som en lodrät matris
315
- FTEST = FTEST ## Returnerar resultatet av en F-test
316
- GAMMADIST = GAMMAFÖRD ## Returnerar gammafördelningen
317
- GAMMAINV = GAMMAINV ## Returnerar inversen till den kumulativa gammafördelningen
318
- GAMMALN = GAMMALN ## Returnerar den naturliga logaritmen för gammafunktionen, G(x)
319
- GEOMEAN = GEOMEDEL ## Returnerar det geometriska medelvärdet
320
- GROWTH = EXPTREND ## Returnerar värden längs en exponentiell trend
321
- HARMEAN = HARMMEDEL ## Returnerar det harmoniska medelvärdet
322
- HYPGEOMDIST = HYPGEOMFÖRD ## Returnerar den hypergeometriska fördelningen
323
- INTERCEPT = SKÄRNINGSPUNKT ## Returnerar skärningspunkten för en linjär regressionslinje
324
- KURT = TOPPIGHET ## Returnerar toppigheten av en mängd data
325
- LARGE = STÖRSTA ## Returnerar det n:te största värdet i en mängd data
326
- LINEST = REGR ## Returnerar parametrar till en linjär trendlinje
327
- LOGEST = EXPREGR ## Returnerar parametrarna i en exponentiell trend
328
- LOGINV = LOGINV ## Returnerar inversen till den lognormala fördelningen
329
- LOGNORMDIST = LOGNORMFÖRD ## Returnerar den kumulativa lognormala fördelningen
330
- MAX = MAX ## Returnerar det största värdet i en lista av argument
331
- MAXA = MAXA ## Returnerar det största värdet i en lista av argument, inklusive tal, text och logiska värden
332
- MEDIAN = MEDIAN ## Returnerar medianen för angivna tal
333
- MIN = MIN ## Returnerar det minsta värdet i en lista med argument
334
- MINA = MINA ## Returnerar det minsta värdet i en lista över argument, inklusive tal, text och logiska värden
335
- MODE = TYPVÄRDE ## Returnerar det vanligaste värdet i en datamängd
336
- NEGBINOMDIST = NEGBINOMFÖRD ## Returnerar den negativa binomialfördelningen
337
- NORMDIST = NORMFÖRD ## Returnerar den kumulativa normalfördelningen
338
- NORMINV = NORMINV ## Returnerar inversen till den kumulativa normalfördelningen
339
- NORMSDIST = NORMSFÖRD ## Returnerar den kumulativa standardnormalfördelningen
340
- NORMSINV = NORMSINV ## Returnerar inversen till den kumulativa standardnormalfördelningen
341
- PEARSON = PEARSON ## Returnerar korrelationskoefficienten till Pearsons momentprodukt
342
- PERCENTILE = PERCENTIL ## Returnerar den n:te percentilen av värden i ett område
343
- PERCENTRANK = PROCENTRANG ## Returnerar procentrangen för ett värde i en datamängd
344
- PERMUT = PERMUT ## Returnerar antal permutationer för ett givet antal objekt
345
- POISSON = POISSON ## Returnerar Poisson-fördelningen
346
- PROB = SANNOLIKHET ## Returnerar sannolikheten att värden i ett område ligger mellan två gränser
347
- QUARTILE = KVARTIL ## Returnerar kvartilen av en mängd data
348
- RANK = RANG ## Returnerar rangordningen för ett tal i en lista med tal
349
- RSQ = RKV ## Returnerar kvadraten av Pearsons produktmomentkorrelationskoefficient
350
- SKEW = SNEDHET ## Returnerar snedheten för en fördelning
351
- SLOPE = LUTNING ## Returnerar lutningen på en linjär regressionslinje
352
- SMALL = MINSTA ## Returnerar det n:te minsta värdet i en mängd data
353
- STANDARDIZE = STANDARDISERA ## Returnerar ett normaliserat värde
354
- STDEV = STDAV ## Uppskattar standardavvikelsen baserat på ett urval
355
- STDEVA = STDEVA ## Uppskattar standardavvikelsen baserat på ett urval, inklusive tal, text och logiska värden
356
- STDEVP = STDAVP ## Beräknar standardavvikelsen baserat på hela populationen
357
- STDEVPA = STDEVPA ## Beräknar standardavvikelsen baserat på hela populationen, inklusive tal, text och logiska värden
358
- STEYX = STDFELYX ## Returnerar standardfelet för ett förutspått y-värde för varje x-värde i regressionen
359
- TDIST = TFÖRD ## Returnerar Students t-fördelning
360
- TINV = TINV ## Returnerar inversen till Students t-fördelning
361
- TREND = TREND ## Returnerar värden längs en linjär trend
362
- TRIMMEAN = TRIMMEDEL ## Returnerar medelvärdet av mittpunkterna i en datamängd
363
- TTEST = TTEST ## Returnerar sannolikheten beräknad ur Students t-test
364
- VAR = VARIANS ## Uppskattar variansen baserat på ett urval
365
- VARA = VARA ## Uppskattar variansen baserat på ett urval, inklusive tal, text och logiska värden
366
- VARP = VARIANSP ## Beräknar variansen baserat på hela populationen
367
- VARPA = VARPA ## Beräknar variansen baserat på hela populationen, inklusive tal, text och logiska värden
368
- WEIBULL = WEIBULL ## Returnerar Weibull-fördelningen
369
- ZTEST = ZTEST ## Returnerar det ensidiga sannolikhetsvärdet av ett z-test
370
-
371
-
372
- ##
373
- ## Text functions Textfunktioner
374
- ##
375
- ASC = ASC ## Ändrar helbredds (dubbel byte) engelska bokstäver eller katakana inom en teckensträng till tecken med halvt breddsteg (enkel byte)
376
- BAHTTEXT = BAHTTEXT ## Omvandlar ett tal till text med valutaformatet ß (baht)
377
- CHAR = TECKENKOD ## Returnerar tecknet som anges av kod
378
- CLEAN = STÄDA ## Tar bort alla icke utskrivbara tecken i en text
379
- CODE = KOD ## Returnerar en numerisk kod för det första tecknet i en textsträng
380
- CONCATENATE = SAMMANFOGA ## Sammanfogar flera textdelar till en textsträng
381
- DOLLAR = VALUTA ## Omvandlar ett tal till text med valutaformat
382
- EXACT = EXAKT ## Kontrollerar om två textvärden är identiska
383
- FIND = HITTA ## Hittar en text i en annan (skiljer på gemener och versaler)
384
- FINDB = HITTAB ## Hittar en text i en annan (skiljer på gemener och versaler)
385
- FIXED = FASTTAL ## Formaterar ett tal som text med ett fast antal decimaler
386
- JIS = JIS ## Ändrar halvbredds (enkel byte) engelska bokstäver eller katakana inom en teckensträng till tecken med helt breddsteg (dubbel byte)
387
- LEFT = VÄNSTER ## Returnerar tecken längst till vänster i en sträng
388
- LEFTB = VÄNSTERB ## Returnerar tecken längst till vänster i en sträng
389
- LEN = LÄNGD ## Returnerar antalet tecken i en textsträng
390
- LENB = LÄNGDB ## Returnerar antalet tecken i en textsträng
391
- LOWER = GEMENER ## Omvandlar text till gemener
392
- MID = EXTEXT ## Returnerar angivet antal tecken från en text med början vid den position som du anger
393
- MIDB = EXTEXTB ## Returnerar angivet antal tecken från en text med början vid den position som du anger
394
- PHONETIC = PHONETIC ## Returnerar de fonetiska (furigana) tecknen i en textsträng
395
- PROPER = INITIAL ## Ändrar första bokstaven i varje ord i ett textvärde till versal
396
- REPLACE = ERSÄTT ## Ersätter tecken i text
397
- REPLACEB = ERSÄTTB ## Ersätter tecken i text
398
- REPT = REP ## Upprepar en text ett bestämt antal gånger
399
- RIGHT = HÖGER ## Returnerar tecken längst till höger i en sträng
400
- RIGHTB = HÖGERB ## Returnerar tecken längst till höger i en sträng
401
- SEARCH = SÖK ## Hittar ett textvärde i ett annat (skiljer inte på gemener och versaler)
402
- SEARCHB = SÖKB ## Hittar ett textvärde i ett annat (skiljer inte på gemener och versaler)
403
- SUBSTITUTE = BYT.UT ## Ersätter gammal text med ny text i en textsträng
404
- T = T ## Omvandlar argumenten till text
405
- TEXT = TEXT ## Formaterar ett tal och omvandlar det till text
406
- TRIM = RENSA ## Tar bort blanksteg från text
407
- UPPER = VERSALER ## Omvandlar text till versaler
408
- VALUE = TEXTNUM ## Omvandlar ett textargument till ett tal
1
+ ##
2
+ ## Add-in and Automation functions Tilläggs- och automatiseringsfunktioner
3
+ ##
4
+ GETPIVOTDATA = HÄMTA.PIVOTDATA ## Returnerar data som lagrats i en pivottabellrapport
5
+
6
+
7
+ ##
8
+ ## Cube functions Kubfunktioner
9
+ ##
10
+ CUBEKPIMEMBER = KUBKPIMEDLEM ## Returnerar namn, egenskap och mått för en KPI och visar namnet och egenskapen i cellen. En KPI, eller prestandaindikator, är ett kvantifierbart mått, t.ex. månatlig bruttovinst eller personalomsättning per kvartal, som används för att analysera ett företags resultat.
11
+ CUBEMEMBER = KUBMEDLEM ## Returnerar en medlem eller ett par i en kubhierarki. Används för att verifiera att medlemmen eller paret finns i kuben.
12
+ CUBEMEMBERPROPERTY = KUBMEDLEMSEGENSKAP ## Returnerar värdet för en medlemsegenskap i kuben. Används för att verifiera att ett medlemsnamn finns i kuben, samt för att returnera den angivna egenskapen för medlemmen.
13
+ CUBERANKEDMEMBER = KUBRANGORDNADMEDLEM ## Returnerar den n:te, eller rangordnade, medlemmen i en uppsättning. Används för att returnera ett eller flera element i en uppsättning, till exempelvis den bästa försäljaren eller de tio bästa eleverna.
14
+ CUBESET = KUBINSTÄLLNING ## Definierar en beräknad uppsättning medlemmar eller par genom att skicka ett bestämt uttryck till kuben på servern, som skapar uppsättningen och sedan returnerar den till Microsoft Office Excel.
15
+ CUBESETCOUNT = KUBINSTÄLLNINGANTAL ## Returnerar antalet objekt i en uppsättning.
16
+ CUBEVALUE = KUBVÄRDE ## Returnerar ett mängdvärde från en kub.
17
+
18
+
19
+ ##
20
+ ## Database functions Databasfunktioner
21
+ ##
22
+ DAVERAGE = DMEDEL ## Returnerar medelvärdet av databasposterna
23
+ DCOUNT = DANTAL ## Räknar antalet celler som innehåller tal i en databas
24
+ DCOUNTA = DANTALV ## Räknar ifyllda celler i en databas
25
+ DGET = DHÄMTA ## Hämtar en enstaka post från en databas som uppfyller de angivna villkoren
26
+ DMAX = DMAX ## Returnerar det största värdet från databasposterna
27
+ DMIN = DMIN ## Returnerar det minsta värdet från databasposterna
28
+ DPRODUCT = DPRODUKT ## Multiplicerar värdena i ett visst fält i poster som uppfyller villkoret
29
+ DSTDEV = DSTDAV ## Uppskattar standardavvikelsen baserat på ett urval av databasposterna
30
+ DSTDEVP = DSTDAVP ## Beräknar standardavvikelsen utifrån hela populationen av valda databasposter
31
+ DSUM = DSUMMA ## Summerar talen i kolumnfält i databasposter som uppfyller villkoret
32
+ DVAR = DVARIANS ## Uppskattar variansen baserat på ett urval av databasposterna
33
+ DVARP = DVARIANSP ## Beräknar variansen utifrån hela populationen av valda databasposter
34
+
35
+
36
+ ##
37
+ ## Date and time functions Tid- och datumfunktioner
38
+ ##
39
+ DATE = DATUM ## Returnerar ett serienummer för ett visst datum
40
+ DATEVALUE = DATUMVÄRDE ## Konverterar ett datum i textformat till ett serienummer
41
+ DAY = DAG ## Konverterar ett serienummer till dag i månaden
42
+ DAYS360 = DAGAR360 ## Beräknar antalet dagar mellan två datum baserat på ett 360-dagarsår
43
+ EDATE = EDATUM ## Returnerar serienumret för ett datum som infaller ett visst antal månader före eller efter startdatumet
44
+ EOMONTH = SLUTMÅNAD ## Returnerar serienumret för sista dagen i månaden ett visst antal månader tidigare eller senare
45
+ HOUR = TIMME ## Konverterar ett serienummer till en timme
46
+ MINUTE = MINUT ## Konverterar ett serienummer till en minut
47
+ MONTH = MÅNAD ## Konverterar ett serienummer till en månad
48
+ NETWORKDAYS = NETTOARBETSDAGAR ## Returnerar antalet hela arbetsdagar mellan två datum
49
+ NOW = NU ## Returnerar serienumret för dagens datum och aktuell tid
50
+ SECOND = SEKUND ## Konverterar ett serienummer till en sekund
51
+ TIME = KLOCKSLAG ## Returnerar serienumret för en viss tid
52
+ TIMEVALUE = TIDVÄRDE ## Konverterar en tid i textformat till ett serienummer
53
+ TODAY = IDAG ## Returnerar serienumret för dagens datum
54
+ WEEKDAY = VECKODAG ## Konverterar ett serienummer till en dag i veckan
55
+ WEEKNUM = VECKONR ## Konverterar ett serienummer till ett veckonummer
56
+ WORKDAY = ARBETSDAGAR ## Returnerar serienumret för ett datum ett visst antal arbetsdagar tidigare eller senare
57
+ YEAR = ÅR ## Konverterar ett serienummer till ett år
58
+ YEARFRAC = ÅRDEL ## Returnerar en del av ett år som representerar antalet hela dagar mellan start- och slutdatum
59
+
60
+
61
+ ##
62
+ ## Engineering functions Tekniska funktioner
63
+ ##
64
+ BESSELI = BESSELI ## Returnerar den modifierade Bessel-funktionen In(x)
65
+ BESSELJ = BESSELJ ## Returnerar Bessel-funktionen Jn(x)
66
+ BESSELK = BESSELK ## Returnerar den modifierade Bessel-funktionen Kn(x)
67
+ BESSELY = BESSELY ## Returnerar Bessel-funktionen Yn(x)
68
+ BIN2DEC = BIN.TILL.DEC ## Omvandlar ett binärt tal till decimalt
69
+ BIN2HEX = BIN.TILL.HEX ## Omvandlar ett binärt tal till hexadecimalt
70
+ BIN2OCT = BIN.TILL.OKT ## Omvandlar ett binärt tal till oktalt
71
+ COMPLEX = KOMPLEX ## Omvandlar reella och imaginära koefficienter till ett komplext tal
72
+ CONVERT = KONVERTERA ## Omvandlar ett tal från ett måttsystem till ett annat
73
+ DEC2BIN = DEC.TILL.BIN ## Omvandlar ett decimalt tal till binärt
74
+ DEC2HEX = DEC.TILL.HEX ## Omvandlar ett decimalt tal till hexadecimalt
75
+ DEC2OCT = DEC.TILL.OKT ## Omvandlar ett decimalt tal till oktalt
76
+ DELTA = DELTA ## Testar om två värden är lika
77
+ ERF = FELF ## Returnerar felfunktionen
78
+ ERFC = FELFK ## Returnerar den komplementära felfunktionen
79
+ GESTEP = SLSTEG ## Testar om ett tal är större än ett tröskelvärde
80
+ HEX2BIN = HEX.TILL.BIN ## Omvandlar ett hexadecimalt tal till binärt
81
+ HEX2DEC = HEX.TILL.DEC ## Omvandlar ett hexadecimalt tal till decimalt
82
+ HEX2OCT = HEX.TILL.OKT ## Omvandlar ett hexadecimalt tal till oktalt
83
+ IMABS = IMABS ## Returnerar absolutvärdet (modulus) för ett komplext tal
84
+ IMAGINARY = IMAGINÄR ## Returnerar den imaginära koefficienten för ett komplext tal
85
+ IMARGUMENT = IMARGUMENT ## Returnerar det komplexa talets argument, en vinkel uttryckt i radianer
86
+ IMCONJUGATE = IMKONJUGAT ## Returnerar det komplexa talets konjugat
87
+ IMCOS = IMCOS ## Returnerar cosinus för ett komplext tal
88
+ IMDIV = IMDIV ## Returnerar kvoten för två komplexa tal
89
+ IMEXP = IMEUPPHÖJT ## Returnerar exponenten för ett komplext tal
90
+ IMLN = IMLN ## Returnerar den naturliga logaritmen för ett komplext tal
91
+ IMLOG10 = IMLOG10 ## Returnerar 10-logaritmen för ett komplext tal
92
+ IMLOG2 = IMLOG2 ## Returnerar 2-logaritmen för ett komplext tal
93
+ IMPOWER = IMUPPHÖJT ## Returnerar ett komplext tal upphöjt till en exponent
94
+ IMPRODUCT = IMPRODUKT ## Returnerar produkten av komplexa tal
95
+ IMREAL = IMREAL ## Returnerar den reella koefficienten för ett komplext tal
96
+ IMSIN = IMSIN ## Returnerar sinus för ett komplext tal
97
+ IMSQRT = IMROT ## Returnerar kvadratroten av ett komplext tal
98
+ IMSUB = IMDIFF ## Returnerar differensen mellan två komplexa tal
99
+ IMSUM = IMSUM ## Returnerar summan av komplexa tal
100
+ OCT2BIN = OKT.TILL.BIN ## Omvandlar ett oktalt tal till binärt
101
+ OCT2DEC = OKT.TILL.DEC ## Omvandlar ett oktalt tal till decimalt
102
+ OCT2HEX = OKT.TILL.HEX ## Omvandlar ett oktalt tal till hexadecimalt
103
+
104
+
105
+ ##
106
+ ## Financial functions Finansiella funktioner
107
+ ##
108
+ ACCRINT = UPPLRÄNTA ## Returnerar den upplupna räntan för värdepapper med periodisk ränta
109
+ ACCRINTM = UPPLOBLRÄNTA ## Returnerar den upplupna räntan för ett värdepapper som ger avkastning på förfallodagen
110
+ AMORDEGRC = AMORDEGRC ## Returnerar avskrivningen för varje redovisningsperiod med hjälp av en avskrivningskoefficient
111
+ AMORLINC = AMORLINC ## Returnerar avskrivningen för varje redovisningsperiod
112
+ COUPDAYBS = KUPDAGBB ## Returnerar antal dagar från början av kupongperioden till likviddagen
113
+ COUPDAYS = KUPDAGARS ## Returnerar antalet dagar i kupongperioden som innehåller betalningsdatumet
114
+ COUPDAYSNC = KUPDAGNK ## Returnerar antalet dagar från betalningsdatumet till nästa kupongdatum
115
+ COUPNCD = KUPNKD ## Returnerar nästa kupongdatum efter likviddagen
116
+ COUPNUM = KUPANT ## Returnerar kuponger som förfaller till betalning mellan likviddagen och förfallodagen
117
+ COUPPCD = KUPFKD ## Returnerar föregående kupongdatum före likviddagen
118
+ CUMIPMT = KUMRÄNTA ## Returnerar den ackumulerade räntan som betalats mellan två perioder
119
+ CUMPRINC = KUMPRIS ## Returnerar det ackumulerade kapitalbeloppet som betalats på ett lån mellan två perioder
120
+ DB = DB ## Returnerar avskrivningen för en tillgång under en angiven tid enligt metoden för fast degressiv avskrivning
121
+ DDB = DEGAVSKR ## Returnerar en tillgångs värdeminskning under en viss period med hjälp av dubbel degressiv avskrivning eller någon annan metod som du anger
122
+ DISC = DISK ## Returnerar diskonteringsräntan för ett värdepapper
123
+ DOLLARDE = DECTAL ## Omvandlar ett pris uttryckt som ett bråk till ett decimaltal
124
+ DOLLARFR = BRÅK ## Omvandlar ett pris i kronor uttryckt som ett decimaltal till ett bråk
125
+ DURATION = LÖPTID ## Returnerar den årliga löptiden för en säkerhet med periodiska räntebetalningar
126
+ EFFECT = EFFRÄNTA ## Returnerar den årliga effektiva räntesatsen
127
+ FV = SLUTVÄRDE ## Returnerar det framtida värdet på en investering
128
+ FVSCHEDULE = FÖRRÄNTNING ## Returnerar det framtida värdet av ett begynnelsekapital beräknat på olika räntenivåer
129
+ INTRATE = ÅRSRÄNTA ## Returnerar räntesatsen för ett betalt värdepapper
130
+ IPMT = RBETALNING ## Returnerar räntedelen av en betalning för en given period
131
+ IRR = IR ## Returnerar internräntan för en serie betalningar
132
+ ISPMT = RALÅN ## Beräknar räntan som har betalats under en specifik betalningsperiod
133
+ MDURATION = MLÖPTID ## Returnerar den modifierade Macauley-löptiden för ett värdepapper med det antagna nominella värdet 100 kr
134
+ MIRR = MODIR ## Returnerar internräntan där positiva och negativa betalningar finansieras med olika räntor
135
+ NOMINAL = NOMRÄNTA ## Returnerar den årliga nominella räntesatsen
136
+ NPER = PERIODER ## Returnerar antalet perioder för en investering
137
+ NPV = NETNUVÄRDE ## Returnerar nuvärdet av en serie periodiska betalningar vid en given diskonteringsränta
138
+ ODDFPRICE = UDDAFPRIS ## Returnerar priset per 100 kr nominellt värde för ett värdepapper med en udda första period
139
+ ODDFYIELD = UDDAFAVKASTNING ## Returnerar avkastningen för en säkerhet med en udda första period
140
+ ODDLPRICE = UDDASPRIS ## Returnerar priset per 100 kr nominellt värde för ett värdepapper med en udda sista period
141
+ ODDLYIELD = UDDASAVKASTNING ## Returnerar avkastningen för en säkerhet med en udda sista period
142
+ PMT = BETALNING ## Returnerar den periodiska betalningen för en annuitet
143
+ PPMT = AMORT ## Returnerar amorteringsdelen av en annuitetsbetalning för en given period
144
+ PRICE = PRIS ## Returnerar priset per 100 kr nominellt värde för ett värdepapper som ger periodisk ränta
145
+ PRICEDISC = PRISDISK ## Returnerar priset per 100 kr nominellt värde för ett diskonterat värdepapper
146
+ PRICEMAT = PRISFÖRF ## Returnerar priset per 100 kr nominellt värde för ett värdepapper som ger ränta på förfallodagen
147
+ PV = PV ## Returnerar nuvärdet av en serie lika stora periodiska betalningar
148
+ RATE = RÄNTA ## Returnerar räntesatsen per period i en annuitet
149
+ RECEIVED = BELOPP ## Returnerar beloppet som utdelas på förfallodagen för ett betalat värdepapper
150
+ SLN = LINAVSKR ## Returnerar den linjära avskrivningen för en tillgång under en period
151
+ SYD = ÅRSAVSKR ## Returnerar den årliga avskrivningssumman för en tillgång under en angiven period
152
+ TBILLEQ = SSVXEKV ## Returnerar avkastningen motsvarande en obligation för en statsskuldväxel
153
+ TBILLPRICE = SSVXPRIS ## Returnerar priset per 100 kr nominellt värde för en statsskuldväxel
154
+ TBILLYIELD = SSVXRÄNTA ## Returnerar avkastningen för en statsskuldväxel
155
+ VDB = VDEGRAVSKR ## Returnerar avskrivningen för en tillgång under en angiven period (med degressiv avskrivning)
156
+ XIRR = XIRR ## Returnerar internräntan för en serie betalningar som inte nödvändigtvis är periodiska
157
+ XNPV = XNUVÄRDE ## Returnerar det nuvarande nettovärdet för en serie betalningar som inte nödvändigtvis är periodiska
158
+ YIELD = NOMAVK ## Returnerar avkastningen för ett värdepapper som ger periodisk ränta
159
+ YIELDDISC = NOMAVKDISK ## Returnerar den årliga avkastningen för diskonterade värdepapper, exempelvis en statsskuldväxel
160
+ YIELDMAT = NOMAVKFÖRF ## Returnerar den årliga avkastningen för ett värdepapper som ger ränta på förfallodagen
161
+
162
+
163
+ ##
164
+ ## Information functions Informationsfunktioner
165
+ ##
166
+ CELL = CELL ## Returnerar information om formatering, plats och innehåll i en cell
167
+ ERROR.TYPE = FEL.TYP ## Returnerar ett tal som motsvarar ett felvärde
168
+ INFO = INFO ## Returnerar information om operativsystemet
169
+ ISBLANK = ÄRREF ## Returnerar SANT om värdet är tomt
170
+ ISERR = Ä ## Returnerar SANT om värdet är ett felvärde annat än #SAKNAS!
171
+ ISERROR = ÄRFEL ## Returnerar SANT om värdet är ett felvärde
172
+ ISEVEN = ÄRJÄMN ## Returnerar SANT om talet är jämnt
173
+ ISLOGICAL = ÄREJTEXT ## Returnerar SANT om värdet är ett logiskt värde
174
+ ISNA = ÄRLOGISK ## Returnerar SANT om värdet är felvärdet #SAKNAS!
175
+ ISNONTEXT = ÄRSAKNAD ## Returnerar SANT om värdet inte är text
176
+ ISNUMBER = ÄRTAL ## Returnerar SANT om värdet är ett tal
177
+ ISODD = ÄRUDDA ## Returnerar SANT om talet är udda
178
+ ISREF = ÄRTOM ## Returnerar SANT om värdet är en referens
179
+ ISTEXT = ÄRTEXT ## Returnerar SANT om värdet är text
180
+ N = N ## Returnerar ett värde omvandlat till ett tal
181
+ NA = SAKNAS ## Returnerar felvärdet #SAKNAS!
182
+ TYPE = VÄRDETYP ## Returnerar ett tal som anger värdets datatyp
183
+
184
+
185
+ ##
186
+ ## Logical functions Logiska funktioner
187
+ ##
188
+ AND = OCH ## Returnerar SANT om alla argument är sanna
189
+ FALSE = FALSKT ## Returnerar det logiska värdet FALSKT
190
+ IF = OM ## Anger vilket logiskt test som ska utföras
191
+ IFERROR = OMFEL ## Returnerar ett värde som du anger om en formel utvärderar till ett fel; annars returneras resultatet av formeln
192
+ NOT = ICKE ## Inverterar logiken för argumenten
193
+ OR = ELLER ## Returnerar SANT om något argument är SANT
194
+ TRUE = SANT ## Returnerar det logiska värdet SANT
195
+
196
+
197
+ ##
198
+ ## Lookup and reference functions Sök- och referensfunktioner
199
+ ##
200
+ ADDRESS = ADRESS ## Returnerar en referens som text till en enstaka cell i ett kalkylblad
201
+ AREAS = OMRÅDEN ## Returnerar antalet områden i en referens
202
+ CHOOSE = VÄLJ ## Väljer ett värde i en lista över värden
203
+ COLUMN = KOLUMN ## Returnerar kolumnnumret för en referens
204
+ COLUMNS = KOLUMNER ## Returnerar antalet kolumner i en referens
205
+ HLOOKUP = LETAKOLUMN ## Söker i den översta raden i en matris och returnerar värdet för angiven cell
206
+ HYPERLINK = HYPERLÄNK ## Skapar en genväg eller ett hopp till ett dokument i nätverket, i ett intranät eller på Internet
207
+ INDEX = INDEX ## Använder ett index för ett välja ett värde i en referens eller matris
208
+ INDIRECT = INDIREKT ## Returnerar en referens som anges av ett textvärde
209
+ LOOKUP = LETAUPP ## Letar upp värden i en vektor eller matris
210
+ MATCH = PASSA ## Letar upp värden i en referens eller matris
211
+ OFFSET = FÖRSKJUTNING ## Returnerar en referens förskjuten i förhållande till en given referens
212
+ ROW = RAD ## Returnerar radnumret för en referens
213
+ ROWS = RADER ## Returnerar antalet rader i en referens
214
+ RTD = RTD ## Hämtar realtidsdata från ett program som stöder COM-automation (Automation: Ett sätt att arbeta med ett programs objekt från ett annat program eller utvecklingsverktyg. Detta kallades tidigare för OLE Automation, och är en branschstandard och ingår i Component Object Model (COM).)
215
+ TRANSPOSE = TRANSPONERA ## Transponerar en matris
216
+ VLOOKUP = LETARAD ## Letar i den första kolumnen i en matris och flyttar över raden för att returnera värdet för en cell
217
+
218
+
219
+ ##
220
+ ## Math and trigonometry functions Matematiska och trigonometriska funktioner
221
+ ##
222
+ ABS = ABS ## Returnerar absolutvärdet av ett tal
223
+ ACOS = ARCCOS ## Returnerar arcus cosinus för ett tal
224
+ ACOSH = ARCCOSH ## Returnerar inverterad hyperbolisk cosinus för ett tal
225
+ ASIN = ARCSIN ## Returnerar arcus cosinus för ett tal
226
+ ASINH = ARCSINH ## Returnerar hyperbolisk arcus sinus för ett tal
227
+ ATAN = ARCTAN ## Returnerar arcus tangens för ett tal
228
+ ATAN2 = ARCTAN2 ## Returnerar arcus tangens för en x- och en y- koordinat
229
+ ATANH = ARCTANH ## Returnerar hyperbolisk arcus tangens för ett tal
230
+ CEILING = RUNDA.UPP ## Avrundar ett tal till närmaste heltal eller närmaste signifikanta multipel
231
+ COMBIN = KOMBIN ## Returnerar antalet kombinationer för ett givet antal objekt
232
+ COS = COS ## Returnerar cosinus för ett tal
233
+ COSH = COSH ## Returnerar hyperboliskt cosinus för ett tal
234
+ DEGREES = GRADER ## Omvandlar radianer till grader
235
+ EVEN = JÄMN ## Avrundar ett tal uppåt till närmaste heltal
236
+ EXP = EXP ## Returnerar e upphöjt till ett givet tal
237
+ FACT = FAKULTET ## Returnerar fakulteten för ett tal
238
+ FACTDOUBLE = DUBBELFAKULTET ## Returnerar dubbelfakulteten för ett tal
239
+ FLOOR = RUNDA.NED ## Avrundar ett tal nedåt mot noll
240
+ GCD = SGD ## Returnerar den största gemensamma nämnaren
241
+ INT = HELTAL ## Avrundar ett tal nedåt till närmaste heltal
242
+ LCM = MGM ## Returnerar den minsta gemensamma multipeln
243
+ LN = LN ## Returnerar den naturliga logaritmen för ett tal
244
+ LOG = LOG ## Returnerar logaritmen för ett tal för en given bas
245
+ LOG10 = LOG10 ## Returnerar 10-logaritmen för ett tal
246
+ MDETERM = MDETERM ## Returnerar matrisen som är avgörandet av en matris
247
+ MINVERSE = MINVERT ## Returnerar matrisinversen av en matris
248
+ MMULT = MMULT ## Returnerar matrisprodukten av två matriser
249
+ MOD = REST ## Returnerar resten vid en division
250
+ MROUND = MAVRUNDA ## Returnerar ett tal avrundat till en given multipel
251
+ MULTINOMIAL = MULTINOMIAL ## Returnerar multinomialen för en uppsättning tal
252
+ ODD = UDDA ## Avrundar ett tal uppåt till närmaste udda heltal
253
+ PI = PI ## Returnerar värdet pi
254
+ POWER = UPPHÖJT.TILL ## Returnerar resultatet av ett tal upphöjt till en exponent
255
+ PRODUCT = PRODUKT ## Multiplicerar argumenten
256
+ QUOTIENT = KVOT ## Returnerar heltalsdelen av en division
257
+ RADIANS = RADIANER ## Omvandlar grader till radianer
258
+ RAND = SLUMP ## Returnerar ett slumptal mellan 0 och 1
259
+ RANDBETWEEN = SLUMP.MELLAN ## Returnerar ett slumptal mellan de tal som du anger
260
+ ROMAN = ROMERSK ## Omvandlar vanliga (arabiska) siffror till romerska som text
261
+ ROUND = AVRUNDA ## Avrundar ett tal till ett angivet antal siffror
262
+ ROUNDDOWN = AVRUNDA.NEDÅT ## Avrundar ett tal nedåt mot noll
263
+ ROUNDUP = AVRUNDA.UPPÅT ## Avrundar ett tal uppåt, från noll
264
+ SERIESSUM = SERIESUMMA ## Returnerar summan av en potensserie baserat på formeln
265
+ SIGN = TECKEN ## Returnerar tecknet för ett tal
266
+ SIN = SIN ## Returnerar sinus för en given vinkel
267
+ SINH = SINH ## Returnerar hyperbolisk sinus för ett tal
268
+ SQRT = ROT ## Returnerar den positiva kvadratroten
269
+ SQRTPI = ROTPI ## Returnerar kvadratroten för (tal * pi)
270
+ SUBTOTAL = DELSUMMA ## Returnerar en delsumma i en lista eller databas
271
+ SUM = SUMMA ## Summerar argumenten
272
+ SUMIF = SUMMA.OM ## Summerar celler enligt ett angivet villkor
273
+ SUMIFS = SUMMA.OMF ## Lägger till cellerna i ett område som uppfyller flera kriterier
274
+ SUMPRODUCT = PRODUKTSUMMA ## Returnerar summan av produkterna i motsvarande matriskomponenter
275
+ SUMSQ = KVADRATSUMMA ## Returnerar summan av argumentens kvadrater
276
+ SUMX2MY2 = SUMMAX2MY2 ## Returnerar summan av differensen mellan kvadraterna för motsvarande värden i två matriser
277
+ SUMX2PY2 = SUMMAX2PY2 ## Returnerar summan av summan av kvadraterna av motsvarande värden i två matriser
278
+ SUMXMY2 = SUMMAXMY2 ## Returnerar summan av kvadraten av skillnaden mellan motsvarande värden i två matriser
279
+ TAN = TAN ## Returnerar tangens för ett tal
280
+ TANH = TANH ## Returnerar hyperbolisk tangens för ett tal
281
+ TRUNC = AVKORTA ## Avkortar ett tal till ett heltal
282
+
283
+
284
+ ##
285
+ ## Statistical functions Statistiska funktioner
286
+ ##
287
+ AVEDEV = MEDELAVV ## Returnerar medelvärdet för datapunkters absoluta avvikelse från deras medelvärde
288
+ AVERAGE = MEDEL ## Returnerar medelvärdet av argumenten
289
+ AVERAGEA = AVERAGEA ## Returnerar medelvärdet av argumenten, inklusive tal, text och logiska värden
290
+ AVERAGEIF = MEDELOM ## Returnerar medelvärdet (aritmetiskt medelvärde) för alla celler i ett område som uppfyller ett givet kriterium
291
+ AVERAGEIFS = MEDELOMF ## Returnerar medelvärdet (det aritmetiska medelvärdet) för alla celler som uppfyller flera villkor.
292
+ BETADIST = BETAFÖRD ## Returnerar den kumulativa betafördelningsfunktionen
293
+ BETAINV = BETAINV ## Returnerar inversen till den kumulativa fördelningsfunktionen för en viss betafördelning
294
+ BINOMDIST = BINOMFÖRD ## Returnerar den individuella binomialfördelningen
295
+ CHIDIST = CHI2FÖRD ## Returnerar den ensidiga sannolikheten av c2-fördelningen
296
+ CHIINV = CHI2INV ## Returnerar inversen av chi2-fördelningen
297
+ CHITEST = CHI2TEST ## Returnerar oberoendetesten
298
+ CONFIDENCE = KONFIDENS ## Returnerar konfidensintervallet för en populations medelvärde
299
+ CORREL = KORREL ## Returnerar korrelationskoefficienten mellan två datamängder
300
+ COUNT = ANTAL ## Räknar hur många tal som finns bland argumenten
301
+ COUNTA = ANTALV ## Räknar hur många värden som finns bland argumenten
302
+ COUNTBLANK = ANTAL.TOMMA ## Räknar antalet tomma celler i ett område
303
+ COUNTIF = ANTAL.OM ## Räknar antalet celler i ett område som uppfyller angivna villkor.
304
+ COUNTIFS = ANTAL.OMF ## Räknar antalet celler i ett område som uppfyller flera villkor.
305
+ COVAR = KOVAR ## Returnerar kovariansen, d.v.s. medelvärdet av produkterna för parade avvikelser
306
+ CRITBINOM = KRITBINOM ## Returnerar det minsta värdet för vilket den kumulativa binomialfördelningen är mindre än eller lika med ett villkorsvärde
307
+ DEVSQ = KVADAVV ## Returnerar summan av kvadrater på avvikelser
308
+ EXPONDIST = EXPONFÖRD ## Returnerar exponentialfördelningen
309
+ FDIST = FFÖRD ## Returnerar F-sannolikhetsfördelningen
310
+ FINV = FINV ## Returnerar inversen till F-sannolikhetsfördelningen
311
+ FISHER = FISHER ## Returnerar Fisher-transformationen
312
+ FISHERINV = FISHERINV ## Returnerar inversen till Fisher-transformationen
313
+ FORECAST = PREDIKTION ## Returnerar ett värde längs en linjär trendlinje
314
+ FREQUENCY = FREKVENS ## Returnerar en frekvensfördelning som en lodrät matris
315
+ FTEST = FTEST ## Returnerar resultatet av en F-test
316
+ GAMMADIST = GAMMAFÖRD ## Returnerar gammafördelningen
317
+ GAMMAINV = GAMMAINV ## Returnerar inversen till den kumulativa gammafördelningen
318
+ GAMMALN = GAMMALN ## Returnerar den naturliga logaritmen för gammafunktionen, G(x)
319
+ GEOMEAN = GEOMEDEL ## Returnerar det geometriska medelvärdet
320
+ GROWTH = EXPTREND ## Returnerar värden längs en exponentiell trend
321
+ HARMEAN = HARMMEDEL ## Returnerar det harmoniska medelvärdet
322
+ HYPGEOMDIST = HYPGEOMFÖRD ## Returnerar den hypergeometriska fördelningen
323
+ INTERCEPT = SKÄRNINGSPUNKT ## Returnerar skärningspunkten för en linjär regressionslinje
324
+ KURT = TOPPIGHET ## Returnerar toppigheten av en mängd data
325
+ LARGE = STÖRSTA ## Returnerar det n:te största värdet i en mängd data
326
+ LINEST = REGR ## Returnerar parametrar till en linjär trendlinje
327
+ LOGEST = EXPREGR ## Returnerar parametrarna i en exponentiell trend
328
+ LOGINV = LOGINV ## Returnerar inversen till den lognormala fördelningen
329
+ LOGNORMDIST = LOGNORMFÖRD ## Returnerar den kumulativa lognormala fördelningen
330
+ MAX = MAX ## Returnerar det största värdet i en lista av argument
331
+ MAXA = MAXA ## Returnerar det största värdet i en lista av argument, inklusive tal, text och logiska värden
332
+ MEDIAN = MEDIAN ## Returnerar medianen för angivna tal
333
+ MIN = MIN ## Returnerar det minsta värdet i en lista med argument
334
+ MINA = MINA ## Returnerar det minsta värdet i en lista över argument, inklusive tal, text och logiska värden
335
+ MODE = TYPVÄRDE ## Returnerar det vanligaste värdet i en datamängd
336
+ NEGBINOMDIST = NEGBINOMFÖRD ## Returnerar den negativa binomialfördelningen
337
+ NORMDIST = NORMFÖRD ## Returnerar den kumulativa normalfördelningen
338
+ NORMINV = NORMINV ## Returnerar inversen till den kumulativa normalfördelningen
339
+ NORMSDIST = NORMSFÖRD ## Returnerar den kumulativa standardnormalfördelningen
340
+ NORMSINV = NORMSINV ## Returnerar inversen till den kumulativa standardnormalfördelningen
341
+ PEARSON = PEARSON ## Returnerar korrelationskoefficienten till Pearsons momentprodukt
342
+ PERCENTILE = PERCENTIL ## Returnerar den n:te percentilen av värden i ett område
343
+ PERCENTRANK = PROCENTRANG ## Returnerar procentrangen för ett värde i en datamängd
344
+ PERMUT = PERMUT ## Returnerar antal permutationer för ett givet antal objekt
345
+ POISSON = POISSON ## Returnerar Poisson-fördelningen
346
+ PROB = SANNOLIKHET ## Returnerar sannolikheten att värden i ett område ligger mellan två gränser
347
+ QUARTILE = KVARTIL ## Returnerar kvartilen av en mängd data
348
+ RANK = RANG ## Returnerar rangordningen för ett tal i en lista med tal
349
+ RSQ = RKV ## Returnerar kvadraten av Pearsons produktmomentkorrelationskoefficient
350
+ SKEW = SNEDHET ## Returnerar snedheten för en fördelning
351
+ SLOPE = LUTNING ## Returnerar lutningen på en linjär regressionslinje
352
+ SMALL = MINSTA ## Returnerar det n:te minsta värdet i en mängd data
353
+ STANDARDIZE = STANDARDISERA ## Returnerar ett normaliserat värde
354
+ STDEV = STDAV ## Uppskattar standardavvikelsen baserat på ett urval
355
+ STDEVA = STDEVA ## Uppskattar standardavvikelsen baserat på ett urval, inklusive tal, text och logiska värden
356
+ STDEVP = STDAVP ## Beräknar standardavvikelsen baserat på hela populationen
357
+ STDEVPA = STDEVPA ## Beräknar standardavvikelsen baserat på hela populationen, inklusive tal, text och logiska värden
358
+ STEYX = STDFELYX ## Returnerar standardfelet för ett förutspått y-värde för varje x-värde i regressionen
359
+ TDIST = TFÖRD ## Returnerar Students t-fördelning
360
+ TINV = TINV ## Returnerar inversen till Students t-fördelning
361
+ TREND = TREND ## Returnerar värden längs en linjär trend
362
+ TRIMMEAN = TRIMMEDEL ## Returnerar medelvärdet av mittpunkterna i en datamängd
363
+ TTEST = TTEST ## Returnerar sannolikheten beräknad ur Students t-test
364
+ VAR = VARIANS ## Uppskattar variansen baserat på ett urval
365
+ VARA = VARA ## Uppskattar variansen baserat på ett urval, inklusive tal, text och logiska värden
366
+ VARP = VARIANSP ## Beräknar variansen baserat på hela populationen
367
+ VARPA = VARPA ## Beräknar variansen baserat på hela populationen, inklusive tal, text och logiska värden
368
+ WEIBULL = WEIBULL ## Returnerar Weibull-fördelningen
369
+ ZTEST = ZTEST ## Returnerar det ensidiga sannolikhetsvärdet av ett z-test
370
+
371
+
372
+ ##
373
+ ## Text functions Textfunktioner
374
+ ##
375
+ ASC = ASC ## Ändrar helbredds (dubbel byte) engelska bokstäver eller katakana inom en teckensträng till tecken med halvt breddsteg (enkel byte)
376
+ BAHTTEXT = BAHTTEXT ## Omvandlar ett tal till text med valutaformatet ß (baht)
377
+ CHAR = TECKENKOD ## Returnerar tecknet som anges av kod
378
+ CLEAN = STÄDA ## Tar bort alla icke utskrivbara tecken i en text
379
+ CODE = KOD ## Returnerar en numerisk kod för det första tecknet i en textsträng
380
+ CONCATENATE = SAMMANFOGA ## Sammanfogar flera textdelar till en textsträng
381
+ DOLLAR = VALUTA ## Omvandlar ett tal till text med valutaformat
382
+ EXACT = EXAKT ## Kontrollerar om två textvärden är identiska
383
+ FIND = HITTA ## Hittar en text i en annan (skiljer på gemener och versaler)
384
+ FINDB = HITTAB ## Hittar en text i en annan (skiljer på gemener och versaler)
385
+ FIXED = FASTTAL ## Formaterar ett tal som text med ett fast antal decimaler
386
+ JIS = JIS ## Ändrar halvbredds (enkel byte) engelska bokstäver eller katakana inom en teckensträng till tecken med helt breddsteg (dubbel byte)
387
+ LEFT = VÄNSTER ## Returnerar tecken längst till vänster i en sträng
388
+ LEFTB = VÄNSTERB ## Returnerar tecken längst till vänster i en sträng
389
+ LEN = LÄNGD ## Returnerar antalet tecken i en textsträng
390
+ LENB = LÄNGDB ## Returnerar antalet tecken i en textsträng
391
+ LOWER = GEMENER ## Omvandlar text till gemener
392
+ MID = EXTEXT ## Returnerar angivet antal tecken från en text med början vid den position som du anger
393
+ MIDB = EXTEXTB ## Returnerar angivet antal tecken från en text med början vid den position som du anger
394
+ PHONETIC = PHONETIC ## Returnerar de fonetiska (furigana) tecknen i en textsträng
395
+ PROPER = INITIAL ## Ändrar första bokstaven i varje ord i ett textvärde till versal
396
+ REPLACE = ERSÄTT ## Ersätter tecken i text
397
+ REPLACEB = ERSÄTTB ## Ersätter tecken i text
398
+ REPT = REP ## Upprepar en text ett bestämt antal gånger
399
+ RIGHT = HÖGER ## Returnerar tecken längst till höger i en sträng
400
+ RIGHTB = HÖGERB ## Returnerar tecken längst till höger i en sträng
401
+ SEARCH = SÖK ## Hittar ett textvärde i ett annat (skiljer inte på gemener och versaler)
402
+ SEARCHB = SÖKB ## Hittar ett textvärde i ett annat (skiljer inte på gemener och versaler)
403
+ SUBSTITUTE = BYT.UT ## Ersätter gammal text med ny text i en textsträng
404
+ T = T ## Omvandlar argumenten till text
405
+ TEXT = TEXT ## Formaterar ett tal och omvandlar det till text
406
+ TRIM = RENSA ## Tar bort blanksteg från text
407
+ UPPER = VERSALER ## Omvandlar text till versaler
408
+ VALUE = TEXTNUM ## Omvandlar ett textargument till ett tal
classes/PHPExcel/locale/tr/config CHANGED
File without changes
classes/PHPExcel/locale/tr/functions CHANGED
File without changes
controllers/admin/addons.php CHANGED
@@ -24,7 +24,7 @@ class PMXI_Admin_Addons extends PMXI_Controller_Admin {
24
  'active' => (class_exists('PMWI_Plugin') and defined('PMWI_EDITION') and PMWI_EDITION == 'paid'),
25
  'free_installed' => (class_exists('PMWI_Plugin') and defined('PMWI_EDITION') and PMWI_EDITION == 'free'),
26
  'required_plugins' => false,
27
- 'url' => 'http://www.wpallimport.com/woocommerce-product-import'
28
  );
29
 
30
  // ACF add-on
24
  'active' => (class_exists('PMWI_Plugin') and defined('PMWI_EDITION') and PMWI_EDITION == 'paid'),
25
  'free_installed' => (class_exists('PMWI_Plugin') and defined('PMWI_EDITION') and PMWI_EDITION == 'free'),
26
  'required_plugins' => false,
27
+ 'url' => 'http://www.wpallimport.com/woocommerce-product-import/'
28
  );
29
 
30
  // ACF add-on
controllers/admin/home.php ADDED
@@ -0,0 +1,12 @@
 
 
 
 
 
 
 
 
 
 
 
 
1
+ <?php
2
+ /**
3
+ * Admin Home page
4
+ *
5
+ * @author Maksym Tsypliakov <maksym.tsypliakov@gmail.com>
6
+ */
7
+ class PMXI_Admin_Home extends PMXI_Controller_Admin {
8
+
9
+ public function index() {
10
+ $this->render();
11
+ }
12
+ }
controllers/admin/import.php CHANGED
@@ -254,10 +254,10 @@ class PMXI_Admin_Import extends PMXI_Controller_Admin {
254
  $this->errors->add('form-validation', __('Certain columns are required to be present in your file to enable it to be re-imported with WP All Import. These columns are missing. Re-export your file using WP All Export, and don\'t delete any of the columns when editing it. Then, re-import will work correctly.', 'wp_all_import_plugin'));
255
  }
256
  elseif($importRecord->options['custom_type'] == 'import_users' && ! class_exists('PMUI_Plugin')){
257
- $this->errors->add('form-validation', __('<p>The import template you are using requires the User Add-On.</p><a href="http://www.wpallimport.com/add-ons/user-import/?utm_source=wordpress.org&utm_medium=wpai-import-template&utm_campaign=free+wp+all+export+plugin" target="_blank">Purchase the User Add-On</a>', 'wp_all_import_plugin'));
258
  }
259
  elseif($importRecord->options['custom_type'] == 'shop_customer' && ! class_exists('PMUI_Plugin')){
260
- $this->errors->add('form-validation', __('<p>The import template you are using requires the User Add-On.</p><a href="http://www.wpallimport.com/add-ons/user-import/?utm_source=wordpress.org&utm_medium=wpai-import-template&utm_campaign=free+wp+all+export+plugin" target="_blank">Purchase the User Add-On</a>', 'wp_all_import_plugin'));
261
  }
262
 
263
  break;
@@ -1497,7 +1497,7 @@ class PMXI_Admin_Import extends PMXI_Controller_Admin {
1497
  if ( ! $this->errors->get_error_codes()) {
1498
 
1499
  // Attributes fields logic
1500
- $post = apply_filters('pmxi_save_options', $post);
1501
 
1502
  // validate post excerpt
1503
  if ( ! empty($post['post_excerpt'])) $this->_validate_template($post['post_excerpt'], __('Excerpt', 'wp_all_import_plugin'));
254
  $this->errors->add('form-validation', __('Certain columns are required to be present in your file to enable it to be re-imported with WP All Import. These columns are missing. Re-export your file using WP All Export, and don\'t delete any of the columns when editing it. Then, re-import will work correctly.', 'wp_all_import_plugin'));
255
  }
256
  elseif($importRecord->options['custom_type'] == 'import_users' && ! class_exists('PMUI_Plugin')){
257
+ $this->errors->add('form-validation', __('<p>The import template you are using requires the User Add-On.</p><a href="https://www.wpallimport.com/checkout/?edd_action=purchase_collection&taxonomy=download_category&terms=40&utm_source=import-plugin-free&utm_medium=upgrade-notice&utm_campaign=import-users" target="_blank">Purchase the User Add-On</a>', 'wp_all_import_plugin'));
258
  }
259
  elseif($importRecord->options['custom_type'] == 'shop_customer' && ! class_exists('PMUI_Plugin')){
260
+ $this->errors->add('form-validation', __('<p>The import template you are using requires the User Add-On.</p><a href="https://www.wpallimport.com/checkout/?edd_action=purchase_collection&taxonomy=download_category&terms=40&utm_source=import-plugin-free&utm_medium=upgrade-notice&utm_campaign=import-users" target="_blank">Purchase the User Add-On</a>', 'wp_all_import_plugin'));
261
  }
262
 
263
  break;
1497
  if ( ! $this->errors->get_error_codes()) {
1498
 
1499
  // Attributes fields logic
1500
+ $post = apply_filters('pmxi_save_options', $post, $this->isWizard);
1501
 
1502
  // validate post excerpt
1503
  if ( ! empty($post['post_excerpt'])) $this->_validate_template($post['post_excerpt'], __('Excerpt', 'wp_all_import_plugin'));
controllers/admin/settings.php CHANGED
@@ -637,13 +637,13 @@ class PMXI_Admin_Settings extends PMXI_Controller_Admin {
637
  }
638
 
639
  if ( $is_show_cf_notice && $is_show_images_notice ){
640
- $warning = __('<a class="upgrade_link" target="_blank" href="https://www.wpallimport.com/checkout/?edd_action=add_to_cart&download_id=1748&edd_options%5Bprice_id%5D=0&utm_source=free-plugin&utm_medium=in-plugin&utm_campaign=custom-fields">Upgrade to the Pro edition of WP All Import to Import Images and Custom Fields</a> <p>If you already own it, remove the free edition and install the Pro edition.</p>', 'wp_all_import_plugin');
641
  }
642
  else if ( $is_show_cf_notice ){
643
- $warning = __('<a class="upgrade_link" target="_blank" href="https://www.wpallimport.com/checkout/?edd_action=add_to_cart&download_id=1748&edd_options%5Bprice_id%5D=0&utm_source=free-plugin&utm_medium=in-plugin&utm_campaign=custom-fields">Upgrade to the Pro edition of WP All Import to Import Custom Fields</a> <p>If you already own it, remove the free edition and install the Pro edition.</p>', 'wp_all_import_plugin');
644
  }
645
  else if ( $is_show_images_notice ) {
646
- $warning = __('<a class="upgrade_link" target="_blank" href="https://www.wpallimport.com/checkout/?edd_action=add_to_cart&download_id=1748&edd_options%5Bprice_id%5D=0&utm_source=free-plugin&utm_medium=in-plugin&utm_campaign=custom-fields">Upgrade to the Pro edition of WP All Import to Import Images</a> <p>If you already own it, remove the free edition and install the Pro edition.</p>', 'wp_all_import_plugin');
647
  }
648
  }
649
  }
@@ -659,12 +659,12 @@ class PMXI_Admin_Settings extends PMXI_Controller_Admin {
659
 
660
  if ( ! defined('PMWI_EDITION') ) {
661
 
662
- $notice = __('<p class="wpallimport-bundle-notice">The import bundle you are using requires the Pro version of the WooCommerce Add-On.</p><a href="https://www.wpallimport.com/checkout/?edd_action=purchase_collection&taxonomy=download_category&terms=14&utm_source=free-plugin&utm_medium=dot-org&utm_campaign=woocommerce" class="upgrade_link" target="_blank">Purchase the WooCommerce Add-On</a>', 'wp_all_import_plugin');
663
 
664
  }
665
  elseif ( PMWI_EDITION != 'paid' ) {
666
 
667
- $notice = __('<p class="wpallimport-bundle-notice">The import bundle you are using requires the Pro version of the WooCommerce Add-On, but you have the free version installed.</p><a href="https://www.wpallimport.com/checkout/?edd_action=purchase_collection&taxonomy=download_category&terms=14&utm_source=free-plugin&utm_medium=dot-org&utm_campaign=woocommerce" target="_blank" class="upgrade_link">Purchase the WooCommerce Add-On</a>', 'wp_all_import_plugin');
668
 
669
  }
670
  }
@@ -674,7 +674,7 @@ class PMXI_Admin_Settings extends PMXI_Controller_Admin {
674
  case 'import_users':
675
 
676
  if ( ! class_exists('PMUI_Plugin') ) {
677
- $notice = __('<p class="wpallimport-bundle-notice">The import bundle you are using requires the User Add-On.</p><a href="http://www.wpallimport.com/checkout/?edd_action=add_to_cart&download_id=1921&edd_options%5Bprice_id%5D=1" target="_blank" class="upgrade_link">Purchase the User Add-On</a>.', 'wp_all_import_plugin');
678
  }
679
 
680
  break;
@@ -686,7 +686,7 @@ class PMXI_Admin_Settings extends PMXI_Controller_Admin {
686
  $notice = __('<p class="wpallimport-bundle-notice">The import bundle you are using requires WooCommerce.</p><a class="upgrade_link" href="https://wordpress.org/plugins/woocommerce/" target="_blank">Get WooCommerce</a>.', 'wp_all_import_plugin');
687
  }
688
  elseif ( ! class_exists('PMUI_Plugin') ) {
689
- $notice = __('<p class="wpallimport-bundle-notice">The import bundle you are using requires the User Add-On.</p><p class="wpallimport-upgrade-links-container"><a href="http://www.wpallimport.com/checkout/?edd_action=add_to_cart&download_id=1921&edd_options%5Bprice_id%5D=1" target="_blank" class="upgrade_link">Purchase the User Add-On</a></p>', 'wp_all_import_plugin');
690
  }
691
 
692
  break;
637
  }
638
 
639
  if ( $is_show_cf_notice && $is_show_images_notice ){
640
+ $warning = __('<a class="upgrade_link" target="_blank" href="https://www.wpallimport.com/checkout/?edd_action=add_to_cart&download_id=1748&edd_options%5Bprice_id%5D=0&utm_source=import-plugin-free&utm_medium=upgrade-notice&utm_campaign=images">Upgrade to the Pro edition of WP All Import to Import Images and Custom Fields</a> <p>If you already own it, remove the free edition and install the Pro edition.</p>', 'wp_all_import_plugin');
641
  }
642
  else if ( $is_show_cf_notice ){
643
+ $warning = __('<a class="upgrade_link" target="_blank" href="https://www.wpallimport.com/checkout/?edd_action=add_to_cart&download_id=1748&edd_options%5Bprice_id%5D=0&utm_source=import-plugin-free&utm_medium=upgrade-notice&utm_campaign=custom-fields">Upgrade to the Pro edition of WP All Import to Import Custom Fields</a> <p>If you already own it, remove the free edition and install the Pro edition.</p>', 'wp_all_import_plugin');
644
  }
645
  else if ( $is_show_images_notice ) {
646
+ $warning = __('<a class="upgrade_link" target="_blank" href="https://www.wpallimport.com/checkout/?edd_action=add_to_cart&download_id=1748&edd_options%5Bprice_id%5D=0&utm_source=import-plugin-free&utm_medium=upgrade-notice&utm_campaign=images">Upgrade to the Pro edition of WP All Import to Import Images</a> <p>If you already own it, remove the free edition and install the Pro edition.</p>', 'wp_all_import_plugin');
647
  }
648
  }
649
  }
659
 
660
  if ( ! defined('PMWI_EDITION') ) {
661
 
662
+ $notice = __('<p class="wpallimport-bundle-notice">The import bundle you are using requires the Pro version of the WooCommerce Add-On.</p><a href="https://www.wpallimport.com/checkout/?edd_action=purchase_collection&taxonomy=download_category&terms=14&utm_source=import-plugin-free&utm_medium=upgrade-notice&utm_campaign=import-wooco-bundle" class="upgrade_link" target="_blank">Purchase the WooCommerce Add-On</a>', 'wp_all_import_plugin');
663
 
664
  }
665
  elseif ( PMWI_EDITION != 'paid' ) {
666
 
667
+ $notice = __('<p class="wpallimport-bundle-notice">The import bundle you are using requires the Pro version of the WooCommerce Add-On, but you have the free version installed.</p><a href="https://www.wpallimport.com/checkout/?edd_action=purchase_collection&taxonomy=download_category&terms=14&utm_source=import-plugin-free&utm_medium=upgrade-notice&utm_campaign=import-wooco-bundle" target="_blank" class="upgrade_link">Purchase the WooCommerce Add-On</a>', 'wp_all_import_plugin');
668
 
669
  }
670
  }
674
  case 'import_users':
675
 
676
  if ( ! class_exists('PMUI_Plugin') ) {
677
+ $notice = __('<p class="wpallimport-bundle-notice">The import bundle you are using requires the User Add-On.</p><a href="https://www.wpallimport.com/checkout/?edd_action=purchase_collection&taxonomy=download_category&terms=40&utm_source=import-plugin-free&utm_medium=upgrade-notice&utm_campaign=import-users" target="_blank" class="upgrade_link">Purchase the User Add-On</a>.', 'wp_all_import_plugin');
678
  }
679
 
680
  break;
686
  $notice = __('<p class="wpallimport-bundle-notice">The import bundle you are using requires WooCommerce.</p><a class="upgrade_link" href="https://wordpress.org/plugins/woocommerce/" target="_blank">Get WooCommerce</a>.', 'wp_all_import_plugin');
687
  }
688
  elseif ( ! class_exists('PMUI_Plugin') ) {
689
+ $notice = __('<p class="wpallimport-bundle-notice">The import bundle you are using requires the User Add-On.</p><p class="wpallimport-upgrade-links-container"><a href="https://www.wpallimport.com/checkout/?edd_action=purchase_collection&taxonomy=download_category&terms=40&utm_source=import-plugin-free&utm_medium=upgrade-notice&utm_campaign=import-users" target="_blank" class="upgrade_link">Purchase the User Add-On</a></p>', 'wp_all_import_plugin');
690
  }
691
 
692
  break;
helpers/wp_all_import_addon_notifications.php CHANGED
@@ -138,7 +138,7 @@ if ( ! function_exists('wp_all_import_addon_notifications') ){
138
  <h4><?php _e("Export anything in WordPress to CSV, XML, or Excel.", "wp_all_import_plugin"); ?></h4>
139
  </div>
140
  </div>
141
- <a class="button button-primary button-hero wpallimport-large-button wpallimport-wpae-notify-read-more" href="http://www.wpallimport.com/export" target="_blank"><?php _e('Read More', 'wp_all_import_plugin');?></a>
142
  </div-->
143
  <?php
144
  }
138
  <h4><?php _e("Export anything in WordPress to CSV, XML, or Excel.", "wp_all_import_plugin"); ?></h4>
139
  </div>
140
  </div>
141
+ <a class="button button-primary button-hero wpallimport-large-button wpallimport-wpae-notify-read-more" href="http://www.wpallimport.com/export/" target="_blank"><?php _e('Read More', 'wp_all_import_plugin');?></a>
142
  </div-->
143
  <?php
144
  }
helpers/wp_all_import_clear_directory.php CHANGED
File without changes
helpers/wp_all_import_ctx_mapping.php CHANGED
File without changes
helpers/wp_all_import_get_image_from_gallery.php CHANGED
@@ -55,6 +55,9 @@ function wp_all_import_get_image_from_gallery($image_name, $targetDir = FALSE, $
55
 
56
  // Search attachment by file headers.
57
  if (empty($attch) and @file_exists($targetDir . DIRECTORY_SEPARATOR . $original_image_name)) {
 
 
 
58
  if ($bundle_type == 'images' and ($img_meta = wp_read_image_metadata($targetDir . DIRECTORY_SEPARATOR . $original_image_name))) {
59
  if (trim($img_meta['title']) && !is_numeric(sanitize_title($img_meta['title']))) {
60
  $img_title = $img_meta['title'];
55
 
56
  // Search attachment by file headers.
57
  if (empty($attch) and @file_exists($targetDir . DIRECTORY_SEPARATOR . $original_image_name)) {
58
+ if ( ! function_exists('wp_read_image_metadata') ) {
59
+ require_once( ABSPATH . 'wp-admin/includes/image.php' );
60
+ }
61
  if ($bundle_type == 'images' and ($img_meta = wp_read_image_metadata($targetDir . DIRECTORY_SEPARATOR . $original_image_name))) {
62
  if (trim($img_meta['title']) && !is_numeric(sanitize_title($img_meta['title']))) {
63
  $img_title = $img_meta['title'];
helpers/wp_all_import_is_json.php CHANGED
File without changes
helpers/wp_all_import_json_to_xml.php CHANGED
File without changes
helpers/wp_all_import_rand_char.php CHANGED
File without changes
helpers/wp_all_import_remove_source.php CHANGED
File without changes
helpers/wp_all_import_rmdir.php CHANGED
File without changes
helpers/wp_all_import_secure_file.php CHANGED
File without changes
helpers/wp_all_import_strip_tags_content.php CHANGED
File without changes
helpers/wp_all_import_template_notifications.php CHANGED
@@ -20,18 +20,18 @@ if ( ! function_exists('wp_all_import_template_notifications') )
20
 
21
  if ( $post['custom_type'] == 'import_users' && ! class_exists('PMUI_Plugin') )
22
  {
23
- $notifications[] = __('The import template you are using requires the User Add-On. If you continue without it your data may import incorrectly.<br/><br/><a href="http://www.wpallimport.com/add-ons/user-import/?utm_source=wordpress.org&utm_medium=wpai-import-template&utm_campaign=free+wp+all+export+plugin" target="_blank">Purchase the User Add-On</a>.', 'wp_all_import_plugin');
24
  }
25
 
26
  if ( $post['custom_type'] == 'shop_customer' && ! class_exists('PMUI_Plugin') )
27
  {
28
- $notifications[] = __('The import template you are using requires the User Add-On. If you continue without having this add-on active, your data may import incorrectly.<br/><br/><a href="http://www.wpallimport.com/add-ons/user-import/?utm_source=wordpress.org&utm_medium=wpai-import-template&utm_campaign=free+wp+all+export+plugin" target="_blank">Purchase the User Add-On</a>.', 'wp_all_import_plugin');
29
  }
30
 
31
 
32
  elseif ( $post['custom_type'] == 'product' && ! class_exists('PMWI_Plugin') && class_exists( 'Woocommerce' ))
33
  {
34
- $notifications[] = __('The import template you are using requires the WooCommerce Import Add-On. If you continue without it your data may import incorrectly.<br/><br/><a href="http://www.wpallimport.com/woocommerce-product-import/" target="_blank">Purchase the WooCommerce Import Add-On</a>.', 'wp_all_import_plugin');
35
  }
36
  // Realia Add-On
37
  elseif ( ! empty($post['realia_addon']) and ! is_plugin_active('realia-xml-csv-property-listings-import/realia-add-on.php') )
20
 
21
  if ( $post['custom_type'] == 'import_users' && ! class_exists('PMUI_Plugin') )
22
  {
23
+ $notifications[] = __('The import template you are using requires the User Add-On. If you continue without it your data may import incorrectly.<br/><br/><a href="https://www.wpallimport.com/checkout/?edd_action=purchase_collection&taxonomy=download_category&terms=40&utm_source=import-plugin-free&utm_medium=upgrade-notice&utm_campaign=import-users-template" target="_blank">Purchase the User Add-On</a>.', 'wp_all_import_plugin');
24
  }
25
 
26
  if ( $post['custom_type'] == 'shop_customer' && ! class_exists('PMUI_Plugin') )
27
  {
28
+ $notifications[] = __('The import template you are using requires the User Add-On. If you continue without having this add-on active, your data may import incorrectly.<br/><br/><a href="https://www.wpallimport.com/checkout/?edd_action=purchase_collection&taxonomy=download_category&terms=40&utm_source=import-plugin-free&utm_medium=upgrade-notice&utm_campaign=import-users-template" target="_blank">Purchase the User Add-On</a>.', 'wp_all_import_plugin');
29
  }
30
 
31
 
32
  elseif ( $post['custom_type'] == 'product' && ! class_exists('PMWI_Plugin') && class_exists( 'Woocommerce' ))
33
  {
34
+ $notifications[] = __('The import template you are using requires the WooCommerce Add-On. If you continue without it your data may import incorrectly.<br/><br/><a href="https://www.wpallimport.com/checkout/?edd_action=purchase_collection&taxonomy=download_category&terms=14&utm_source=import-plugin-free&utm_medium=upgrade-notice&utm_campaign=import-wooco-template" target="_blank">Purchase the WooCommerce Add-On</a>.', 'wp_all_import_plugin');
35
  }
36
  // Realia Add-On
37
  elseif ( ! empty($post['realia_addon']) and ! is_plugin_active('realia-xml-csv-property-listings-import/realia-add-on.php') )
helpers/wp_all_import_url_title.php CHANGED
File without changes
helpers/wpai_util_map.php CHANGED
File without changes
i18n/languages/wp_all_import_plugin-ja.mo CHANGED
File without changes
i18n/languages/wp_all_import_plugin-ja.po CHANGED
File without changes
models/import/record.php CHANGED
@@ -1081,8 +1081,11 @@ class PMXI_Import_Record extends PMXI_Model_Record {
1081
  $duplicates = array();
1082
  if ('pid' == $this->options['duplicate_indicator']) {
1083
  $duplicate_id = $duplicate_indicator_values[$i];
1084
- if ($duplicate_id && !in_array($articleData['post_type'], array('import_users', 'shop_customer', 'taxonomies'))) {
1085
  $duplicate_post_type = get_post_type($duplicate_id);
 
 
 
1086
  if ($duplicate_post_type !== $articleData['post_type']) {
1087
  $duplicate_id = false;
1088
  }
@@ -1780,7 +1783,7 @@ class PMXI_Import_Record extends PMXI_Model_Record {
1780
  $is_allow_import_images = apply_filters('wp_all_import_is_allow_import_images', false, empty($articleData['post_type']) ? '' : $articleData['post_type']);
1781
  $images_uploads = apply_filters('wp_all_import_images_uploads_dir', $uploads, $articleData, $current_xml_node, $this->id);
1782
 
1783
- if (!empty($articleData['post_content']) && $this->options['is_update_content'] && $this->options['import_img_tags'] && ( ! empty($articleData['post_type']) && $articleData['post_type'] == "product" && class_exists('PMWI_Plugin') || $is_allow_import_images)){
1784
 
1785
  require_once(ABSPATH . 'wp-admin/includes/image.php');
1786
 
@@ -1842,6 +1845,8 @@ class PMXI_Import_Record extends PMXI_Model_Record {
1842
  }
1843
  }
1844
 
 
 
1845
  $attid = false;
1846
 
1847
  if ($this->options['search_existing_images']) {
@@ -2103,7 +2108,7 @@ class PMXI_Import_Record extends PMXI_Model_Record {
2103
  $bn = wp_all_import_sanitize_filename(urldecode(wp_all_import_basename($url)));
2104
  $default_extension = pmxi_getExtension($bn);
2105
 
2106
- if ( "yes" == $this->options[$option_slug . 'download_images'] and ! empty($auto_extensions_bundle[$slug][$i]) and preg_match('%^(jpg|jpeg|png|gif)$%i', $auto_extensions_bundle[$slug][$i])){
2107
  $img_ext = $auto_extensions_bundle[$slug][$i];
2108
  }
2109
  else {
@@ -2158,7 +2163,7 @@ class PMXI_Import_Record extends PMXI_Model_Record {
2158
  $image_filename = wp_unique_filename($targetDir, $image_filename);
2159
  $image_filepath = $targetDir . '/' . $image_filename;
2160
  imagejpeg($img, $image_filepath);
2161
- if( ! ($image_info = apply_filters('pmxi_getimagesize', @getimagesize($image_filepath), $image_filepath)) or ! in_array($image_info[2], array(IMAGETYPE_GIF, IMAGETYPE_JPEG, IMAGETYPE_PNG, IMAGETYPE_BMP))) {
2162
  $logger and call_user_func($logger, sprintf(__('- <b>WARNING</b>: File %s is not a valid image and cannot be set as featured one', 'wp_all_import_plugin'), $image_filepath));
2163
  $logger and !$is_cron and PMXI_Plugin::$session->warnings++;
2164
  } else {
@@ -2283,7 +2288,7 @@ class PMXI_Import_Record extends PMXI_Model_Record {
2283
  }
2284
  // validate import images
2285
  elseif($bundle_data['type'] == 'images'){
2286
- if( preg_match('%\W(svg)$%i', wp_all_import_basename($image_filepath)) or $image_info = apply_filters('pmxi_getimagesize', @getimagesize($image_filepath), $image_filepath) and in_array($image_info[2], array(IMAGETYPE_GIF, IMAGETYPE_JPEG, IMAGETYPE_PNG, IMAGETYPE_BMP)) ) {
2287
  $create_image = true;
2288
  $logger and call_user_func($logger, sprintf(__('- Image `%s` has been successfully found', 'wp_all_import_plugin'), $wpai_image_path));
2289
  }
@@ -2391,7 +2396,13 @@ class PMXI_Import_Record extends PMXI_Model_Record {
2391
  if ( $this->options[$option_slug . 'set_image_meta_description'] and ! empty($img_descriptions[$k]) ) $update_attachment_meta['post_content'] = trim($img_descriptions[$k]);
2392
  if ( $this->options[$option_slug . 'set_image_meta_alt'] and ! empty($img_alts[$k]) ) update_post_meta($attid, '_wp_attachment_image_alt', trim($img_alts[$k]));
2393
 
2394
- if ( ! empty($update_attachment_meta)) $this->wpdb->update( $this->wpdb->posts, $update_attachment_meta, array('ID' => $attid) );
 
 
 
 
 
 
2395
 
2396
  $logger and call_user_func($logger, __('- <b>ACTION</b>: ' . $slug, 'wp_all_import_plugin'));
2397
  do_action( $slug, $pid, $attid, ($handle_image) ? $handle_image['file'] : $image_filepath, $is_keep_existing_images ? 'add_images' : 'update_images');
@@ -3289,6 +3300,20 @@ class PMXI_Import_Record extends PMXI_Model_Record {
3289
  }
3290
 
3291
  protected function associate_terms( $pid, $assign_taxes, $tx_name, $logger, $is_cron = false, $post_status = 'publish' ) {
 
 
 
 
 
 
 
 
 
 
 
 
 
 
3292
  $term_ids = wp_get_object_terms( $pid, $tx_name, array( 'fields' => 'ids' ) );
3293
 
3294
  $assign_taxes = ( is_array( $assign_taxes ) ) ? array_filter( $assign_taxes ) : false;
1081
  $duplicates = array();
1082
  if ('pid' == $this->options['duplicate_indicator']) {
1083
  $duplicate_id = $duplicate_indicator_values[$i];
1084
+ if ($duplicate_id && !in_array($this->options['custom_type'], array('import_users', 'shop_customer', 'taxonomies'))) {
1085
  $duplicate_post_type = get_post_type($duplicate_id);
1086
+ if ($articleData['post_type'] == 'product' && $duplicate_post_type == 'product_variation') {
1087
+ $duplicate_post_type = 'product';
1088
+ }
1089
  if ($duplicate_post_type !== $articleData['post_type']) {
1090
  $duplicate_id = false;
1091
  }
1783
  $is_allow_import_images = apply_filters('wp_all_import_is_allow_import_images', false, empty($articleData['post_type']) ? '' : $articleData['post_type']);
1784
  $images_uploads = apply_filters('wp_all_import_images_uploads_dir', $uploads, $articleData, $current_xml_node, $this->id);
1785
 
1786
+ if (!empty($articleData['post_content']) && (empty($articleData['ID']) || $this->options['is_keep_former_posts'] == "no" && ($this->options['update_all_data'] == "yes" || $this->options['is_update_content'])) && $this->options['import_img_tags'] && ( ! empty($articleData['post_type']) && $articleData['post_type'] == "product" && class_exists('PMWI_Plugin') || $is_allow_import_images)){
1787
 
1788
  require_once(ABSPATH . 'wp-admin/includes/image.php');
1789
 
1845
  }
1846
  }
1847
 
1848
+ if (empty($image) || !preg_match('%^(http|ftp)s?://%i', $image)) continue;
1849
+
1850
  $attid = false;
1851
 
1852
  if ($this->options['search_existing_images']) {
2108
  $bn = wp_all_import_sanitize_filename(urldecode(wp_all_import_basename($url)));
2109
  $default_extension = pmxi_getExtension($bn);
2110
 
2111
+ if ( "yes" == $this->options[$option_slug . 'download_images'] and ! empty($auto_extensions_bundle[$slug][$i]) and preg_match('%^(jpg|jpeg|png|gif|webp)$%i', $auto_extensions_bundle[$slug][$i])){
2112
  $img_ext = $auto_extensions_bundle[$slug][$i];
2113
  }
2114
  else {
2163
  $image_filename = wp_unique_filename($targetDir, $image_filename);
2164
  $image_filepath = $targetDir . '/' . $image_filename;
2165
  imagejpeg($img, $image_filepath);
2166
+ if( ! ($image_info = apply_filters('pmxi_getimagesize', @getimagesize($image_filepath), $image_filepath)) or ! in_array($image_info[2], array(IMAGETYPE_GIF, IMAGETYPE_JPEG, IMAGETYPE_PNG, IMAGETYPE_BMP, IMAGETYPE_WEBP))) {
2167
  $logger and call_user_func($logger, sprintf(__('- <b>WARNING</b>: File %s is not a valid image and cannot be set as featured one', 'wp_all_import_plugin'), $image_filepath));
2168
  $logger and !$is_cron and PMXI_Plugin::$session->warnings++;
2169
  } else {
2288
  }
2289
  // validate import images
2290
  elseif($bundle_data['type'] == 'images'){
2291
+ if( preg_match('%\W(svg)$%i', wp_all_import_basename($image_filepath)) or $image_info = apply_filters('pmxi_getimagesize', @getimagesize($image_filepath), $image_filepath) and in_array($image_info[2], array(IMAGETYPE_GIF, IMAGETYPE_JPEG, IMAGETYPE_PNG, IMAGETYPE_BMP, IMAGETYPE_WEBP)) ) {
2292
  $create_image = true;
2293
  $logger and call_user_func($logger, sprintf(__('- Image `%s` has been successfully found', 'wp_all_import_plugin'), $wpai_image_path));
2294
  }
2396
  if ( $this->options[$option_slug . 'set_image_meta_description'] and ! empty($img_descriptions[$k]) ) $update_attachment_meta['post_content'] = trim($img_descriptions[$k]);
2397
  if ( $this->options[$option_slug . 'set_image_meta_alt'] and ! empty($img_alts[$k]) ) update_post_meta($attid, '_wp_attachment_image_alt', trim($img_alts[$k]));
2398
 
2399
+ if ( !empty($update_attachment_meta)) {
2400
+ $update_attachment_meta['ID'] = $attid;
2401
+ $gallery_post = wp_update_post( $update_attachment_meta, true );
2402
+ if (is_wp_error($gallery_post)) {
2403
+ $logger and call_user_func($logger, sprintf(__('- <b>ERROR</b>: %s', 'wp_all_import_plugin'), $gallery_post));
2404
+ }
2405
+ }
2406
 
2407
  $logger and call_user_func($logger, __('- <b>ACTION</b>: ' . $slug, 'wp_all_import_plugin'));
2408
  do_action( $slug, $pid, $attid, ($handle_image) ? $handle_image['file'] : $image_filepath, $is_keep_existing_images ? 'add_images' : 'update_images');
3300
  }
3301
 
3302
  protected function associate_terms( $pid, $assign_taxes, $tx_name, $logger, $is_cron = false, $post_status = 'publish' ) {
3303
+ $use_wp_set_object_terms = apply_filters('wp_all_import_use_wp_set_object_terms', false, $tx_name);
3304
+ if ($use_wp_set_object_terms) {
3305
+ $term_ids = [];
3306
+ if (!empty($assign_taxes)) {
3307
+ foreach ($assign_taxes as $ttid) {
3308
+ $term = get_term_by('term_taxonomy_id', $ttid, $tx_name);
3309
+ if ($term) {
3310
+ $term_ids[] = $term->term_id;
3311
+ }
3312
+ }
3313
+ }
3314
+ return wp_set_object_terms($pid, $term_ids, $tx_name);
3315
+ }
3316
+
3317
  $term_ids = wp_get_object_terms( $pid, $tx_name, array( 'fields' => 'ids' ) );
3318
 
3319
  $assign_taxes = ( is_array( $assign_taxes ) ) ? array_filter( $assign_taxes ) : false;
plugin.php CHANGED
@@ -1,9 +1,9 @@
1
  <?php
2
  /*
3
  Plugin Name: WP All Import
4
- Plugin URI: http://www.wpallimport.com/upgrade-to-pro?utm_source=wordpress.org&utm_medium=plugins-page&utm_campaign=free+plugin
5
  Description: The most powerful solution for importing XML and CSV files to WordPress. Create Posts and Pages with content from any XML or CSV file. A paid upgrade to WP All Import Pro is available for support and additional features.
6
- Version: 3.5.0
7
  Author: Soflyy
8
  */
9
 
@@ -25,7 +25,7 @@ define('WP_ALL_IMPORT_ROOT_URL', rtrim(plugin_dir_url(__FILE__), '/'));
25
  */
26
  define('WP_ALL_IMPORT_PREFIX', 'pmxi_');
27
 
28
- define('PMXI_VERSION', '3.5.0');
29
 
30
  define('PMXI_EDITION', 'free');
31
 
1
  <?php
2
  /*
3
  Plugin Name: WP All Import
4
+ Plugin URI: http://www.wpallimport.com/upgrade-to-pro/?utm_source=import-plugin-free&utm_medium=wp-plugins-page&utm_campaign=upgrade-to-pro
5
  Description: The most powerful solution for importing XML and CSV files to WordPress. Create Posts and Pages with content from any XML or CSV file. A paid upgrade to WP All Import Pro is available for support and additional features.
6
+ Version: 3.5.1
7
  Author: Soflyy
8
  */
9
 
25
  */
26
  define('WP_ALL_IMPORT_PREFIX', 'pmxi_');
27
 
28
+ define('PMXI_VERSION', '3.5.1');
29
 
30
  define('PMXI_EDITION', 'free');
31
 
readme.txt CHANGED
@@ -2,7 +2,7 @@
2
  Contributors: soflyy, wpallimport
3
  Requires at least: 4.1
4
  Tested up to: 5.2
5
- Stable tag: 3.5.0
6
  Tags: wordpress csv import, wordpress xml import, xml, csv, datafeed, import, migrate, import csv to wordpress, import xml to wordpress, advanced xml import, advanced csv import, bulk csv import, bulk xml import, bulk data import, xml to custom post type, csv to custom post type, woocommerce csv import, woocommerce xml import, csv import, import csv, xml import, import xml, csv importer
7
 
8
  WP All Import is an extremely powerful importer that makes it easy to import any XML or CSV file to WordPress.
@@ -20,7 +20,7 @@ There are no special requirements that the elements in your file must be laid ou
20
 
21
  WP All Import can be used for everything from migrating content from a legacy CMS to WordPress to building a store with an affiliate datafeed to displaying live stock quotes or sports scores to building a real estate portal.
22
 
23
- Check out our [documentation and video tutorials](http://www.wpallimport.com/documentation/?utm_source=free-plugin&utm_medium=dot-org&utm_campaign=docs) to make the most of WP All Import.
24
 
25
  WP All Import integrates with our companion plugin, [WP All Export](https://wordpress.org/plugins/wp-all-export/). You can export posts, WooCommerce products, orders, users, or anything else with WP All Export. Then you can edit in Excel and re-import to the same site or migrate the data to another site with WP All Import.
26
 
@@ -43,9 +43,9 @@ For technical support from the developers, please consider purchasing WP All Imp
43
 
44
  * Guaranteed technical support via e-mail.
45
 
46
- [Upgrade to the Pro edition of WP All Import.](http://www.wpallimport.com/upgrade-to-pro/?utm_source=free-plugin&utm_medium=dot-org&utm_campaign=upgrade)
47
 
48
- Need to [import XML and CSV to WooCommerce?](http://wordpress.org/plugins/woocommerce-xml-csv-product-import/) Check out our WooCommerce add-on.
49
 
50
  = WordPress CSV Imports =
51
 
@@ -57,7 +57,7 @@ When importing CSV files, your CSV should have UTF-8 encoding if you are having
57
 
58
  In step 2 of a CSV import, you can specify an alternative delimiter if you aren't using a comma. WP All Import can import CSVs that are pipe-delimited, # delimited, or delimited/separated by any other character.
59
 
60
- For CSV import tutorials and example files, visit our [documentation](http://www.wpallimport.com/documentation/?utm_source=free-plugin&utm_medium=dot-org&utm_campaign=documentation). Please keep in mind CSV imports with WP All Import are just like XML imports - you have all the same functionality, and the process is exactly the same. Any of our tutorial videos that apply to XML files also apply to importing CSV files, so if you see a tutorial with us importing an XML file, know that you can follow the exact same steps for a CSV import.
61
 
62
  = Add-Ons =
63
 
@@ -68,27 +68,27 @@ A number of premium add-ons are available to add functionality to the importer a
68
  - User Import Add-On - XML & CSV importer for users, including user_meta
69
  - Link Cloak Add-On - Auto-create redirects for links present during an XML or CSV import
70
 
71
- Learn more about our add-ons at [http://www.wpallimport.com/add-ons](http://www.wpallimport.com/add-ons?utm_source=free-plugin&utm_medium=dot-org&utm_campaign=add-ons)
72
 
73
- A [developer API](http://www.wpallimport.com/documentation/developers/action-reference/?utm_source=free-plugin&utm_medium=dot-org&utm_campaign=documentation) (action hooks) is also available.
74
 
75
  == Premium Support ==
76
- Upgrade to the Pro edition of WP All Import for premium support.
77
 
78
- E-mail: support@wpallimport.com
79
 
80
  == Import To WooCommerce ==
81
 
82
  Need to [import XML and CSV to WooCommerce?](http://wordpress.org/plugins/woocommerce-xml-csv-product-import/) Check out our WooCommerce add-on.
83
 
84
- [WooCommerce XML & CSV Import Pro Version](http://www.wpallimport.com/woocommerce-product-import?utm_source=free-plugin&utm_medium=dot-org&utm_campaign=woocommerce)
85
 
86
  == Frequently Asked Questions ==
87
 
88
  **What Size Files Can WP All Import Handle?**
89
  It depends on your hosting provider’s settings. We’ve imported files of 200Mb and up, even on shared hosts. WP All Import splits your file into manageable chunks.
90
 
91
- [Various settings are available](http://www.wpallimport.com/documentation/advanced/import-processing/?utm_source=free-plugin&utm_medium=dot-org&utm_campaign=large-files) to make it possible to import larger files or speed up your import.
92
 
93
  *The answer to all of the following questions is yes:*
94
 
@@ -105,6 +105,10 @@ Does it work with special character encoding like Hebrew, Arabic, Chinese, etc?
105
 
106
  == Changelog ==
107
 
 
 
 
 
108
  = 3.5.0 =
109
  * improvement: add support for .tsv format
110
  * API: add current XML variable to pmxi_article_data filter
2
  Contributors: soflyy, wpallimport
3
  Requires at least: 4.1
4
  Tested up to: 5.2
5
+ Stable tag: 3.5.1
6
  Tags: wordpress csv import, wordpress xml import, xml, csv, datafeed, import, migrate, import csv to wordpress, import xml to wordpress, advanced xml import, advanced csv import, bulk csv import, bulk xml import, bulk data import, xml to custom post type, csv to custom post type, woocommerce csv import, woocommerce xml import, csv import, import csv, xml import, import xml, csv importer
7
 
8
  WP All Import is an extremely powerful importer that makes it easy to import any XML or CSV file to WordPress.
20
 
21
  WP All Import can be used for everything from migrating content from a legacy CMS to WordPress to building a store with an affiliate datafeed to displaying live stock quotes or sports scores to building a real estate portal.
22
 
23
+ Check out our [documentation and video tutorials](http://www.wpallimport.com/documentation/?utm_source=import-plugin-free&utm_medium=readme&utm_campaign=docs) to make the most of WP All Import.
24
 
25
  WP All Import integrates with our companion plugin, [WP All Export](https://wordpress.org/plugins/wp-all-export/). You can export posts, WooCommerce products, orders, users, or anything else with WP All Export. Then you can edit in Excel and re-import to the same site or migrate the data to another site with WP All Import.
26
 
43
 
44
  * Guaranteed technical support via e-mail.
45
 
46
+ [Upgrade to the Pro edition of WP All Import.](http://www.wpallimport.com/upgrade-to-pro/?utm_source=import-plugin-free&utm_medium=readme&utm_campaign=upgrade-to-pro)
47
 
48
+ Need to [import XML and CSV to WooCommerce?](http://www.wpallimport.com/woocommerce-product-import/?utm_source=import-plugin-free&utm_medium=readme&utm_campaign=upgrade-to-pro) Check out our WooCommerce add-on.
49
 
50
  = WordPress CSV Imports =
51
 
57
 
58
  In step 2 of a CSV import, you can specify an alternative delimiter if you aren't using a comma. WP All Import can import CSVs that are pipe-delimited, # delimited, or delimited/separated by any other character.
59
 
60
+ For CSV import tutorials and example files, visit our [documentation](http://www.wpallimport.com/documentation/?utm_source=import-plugin-free&utm_medium=readme&utm_campaign=docs). Please keep in mind CSV imports with WP All Import are just like XML imports - you have all the same functionality, and the process is exactly the same. Any of our tutorial videos that apply to XML files also apply to importing CSV files, so if you see a tutorial with us importing an XML file, know that you can follow the exact same steps for a CSV import.
61
 
62
  = Add-Ons =
63
 
68
  - User Import Add-On - XML & CSV importer for users, including user_meta
69
  - Link Cloak Add-On - Auto-create redirects for links present during an XML or CSV import
70
 
71
+ Learn more about our add-ons at [http://www.wpallimport.com/add-ons](http://www.wpallimport.com/add-ons/?utm_source=import-plugin-free&utm_medium=readme&utm_campaign=add-ons)
72
 
73
+ A [developer API](http://www.wpallimport.com/documentation/developers/action-reference/?utm_source=import-plugin-free&utm_medium=readme&utm_campaign=docs) (action hooks) is also available.
74
 
75
  == Premium Support ==
76
+ Support for the free version of WP All Import is handled through the WordPress.org community forums.
77
 
78
+ Support is not guaranteed and is based on ability. For premium support over email, [purchase WP All Import.](https://www.wpallimport.com/checkout/?edd_action=add_to_cart&download_id=1748&edd_options%5Bprice_id%5D=0&utm_source=import-plugin-free&utm_medium=readme&utm_campaign=premium-support)
79
 
80
  == Import To WooCommerce ==
81
 
82
  Need to [import XML and CSV to WooCommerce?](http://wordpress.org/plugins/woocommerce-xml-csv-product-import/) Check out our WooCommerce add-on.
83
 
84
+ [WooCommerce XML & CSV Import Pro Version](http://www.wpallimport.com/woocommerce-product-import/?utm_source=import-plugin-free&utm_medium=readme&utm_campaign=import-wooco-products)
85
 
86
  == Frequently Asked Questions ==
87
 
88
  **What Size Files Can WP All Import Handle?**
89
  It depends on your hosting provider’s settings. We’ve imported files of 200Mb and up, even on shared hosts. WP All Import splits your file into manageable chunks.
90
 
91
+ [Various settings are available](http://www.wpallimport.com/documentation/advanced/import-processing/?utm_source=import-plugin-free&utm_medium=readme&utm_campaign=upgrade-to-pro) to make it possible to import larger files or speed up your import.
92
 
93
  *The answer to all of the following questions is yes:*
94
 
105
 
106
  == Changelog ==
107
 
108
+ = 3.5.1 =
109
+ * improvement: add support for importing WebP images
110
+ * bug fix: images in content not being imported when creating new simple WooCommerce products
111
+
112
  = 3.5.0 =
113
  * improvement: add support for .tsv format
114
  * API: add current XML variable to pmxi_article_data filter
views/admin/help/index.php CHANGED
@@ -4,14 +4,14 @@
4
  <tr>
5
  <td class="left">
6
  <p style="font-size: 1.3em !important;">
7
- <b><?php _e('Support Form', 'wp_all_import_plugin'); ?> </b> - <a target="_blank" href="http://www.wpallimport.com/support">http://www.wpallimport.com/support</a>
8
  </p>
9
 
10
  <p style="font-size: 1.3em !important;"><?php _e('Thank you for using WP All Import.', 'wp_all_import_plugin'); ?></p>
11
 
12
  <p style="font-size: 1.3em !important;"><?php _e('While we do our best to provide technical support to users of the free version, we must prioritize requests from Pro users. If you need help with WP All Import please submit a ticket through the support form.', 'wp_all_import_plugin'); ?></p>
13
 
14
- <p style="font-size: 1.3em !important;"><a href="https://www.wpallimport.com/checkout/?edd_action=add_to_cart&download_id=1748&edd_options%5Bprice_id%5D=0&utm_source=free-plugin&utm_medium=in-plugin&utm_campaign=support" target="_blank"><?php _e('Upgrade to the Pro edition of WP All Import for Premium Support', 'wp_all_import_plugin'); ?></a></p>
15
 
16
  </td>
17
  <td class="right">&nbsp;</td>
4
  <tr>
5
  <td class="left">
6
  <p style="font-size: 1.3em !important;">
7
+ <b><?php _e('Support Form', 'wp_all_import_plugin'); ?> </b> - <a target="_blank" href="http://www.wpallimport.com/support/?utm_source=import-plugin-free&utm_medium=help&utm_campaign=premium-support">http://www.wpallimport.com/support/</a>
8
  </p>
9
 
10
  <p style="font-size: 1.3em !important;"><?php _e('Thank you for using WP All Import.', 'wp_all_import_plugin'); ?></p>
11
 
12
  <p style="font-size: 1.3em !important;"><?php _e('While we do our best to provide technical support to users of the free version, we must prioritize requests from Pro users. If you need help with WP All Import please submit a ticket through the support form.', 'wp_all_import_plugin'); ?></p>
13
 
14
+ <p style="font-size: 1.3em !important;"><a href="https://www.wpallimport.com/checkout/?edd_action=add_to_cart&download_id=1748&edd_options%5Bprice_id%5D=0&utm_source=import-plugin-free&utm_medium=help&utm_campaign=premium-support" target="_blank"><?php _e('Upgrade to the Pro edition of WP All Import for Premium Support', 'wp_all_import_plugin'); ?></a></p>
15
 
16
  </td>
17
  <td class="right">&nbsp;</td>
views/admin/home/index.php ADDED
@@ -0,0 +1,16 @@
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
1
+ <div class="wrap">
2
+ <?php
3
+ $homeurl = "http://www.wpallimport.com/adminpanel/index.php?v=".urlencode(PMXI_Plugin::getInstance()->getVersion());
4
+ $contents = @file_get_contents($homeurl);
5
+ if ( ! $contents) {
6
+ ?>
7
+ <iframe src='<?php echo $homeurl; ?>' width='600'></iframe><br />
8
+ <?php
9
+ } else {
10
+ echo $contents;
11
+ }
12
+ ?>
13
+ </div>
14
+
15
+
16
+
views/admin/import/confirm.php CHANGED
@@ -12,7 +12,7 @@
12
  <h2><?php _e('Import XML / CSV', 'wp_all_import_plugin'); ?></h2>
13
  </div>
14
  <div class="wpallimport-links">
15
- <a href="http://www.wpallimport.com/support/" target="_blank"><?php _e('Support', 'wp_all_import_plugin'); ?></a> | <a href="http://www.wpallimport.com/documentation/" target="_blank"><?php _e('Documentation', 'wp_all_import_plugin'); ?></a>
16
  </div>
17
  </div>
18
  <div class="clear"></div>
@@ -45,7 +45,7 @@
45
  <h4><?php _e("It has changed and is not compatible with this import template.", "wp_all_import_plugin"); ?></h4>
46
  </div>
47
  </div>
48
- <a class="button button-primary button-hero wpallimport-large-button wpallimport-notify-read-more" href="http://www.wpallimport.com/documentation/troubleshooting/problems-with-import-files/#invalid" target="_blank"><?php _e('Read More', 'wp_all_import_plugin');?></a>
49
  </div>
50
 
51
  <?php $custom_type = get_post_type_object( PMXI_Plugin::$session->custom_type ); ?>
12
  <h2><?php _e('Import XML / CSV', 'wp_all_import_plugin'); ?></h2>
13
  </div>
14
  <div class="wpallimport-links">
15
+ <a href="http://www.wpallimport.com/support/?utm_source=import-plugin-free&utm_medium=help&utm_campaign=premium-support" target="_blank"><?php _e('Support', 'wp_all_import_plugin'); ?></a> | <a href="http://www.wpallimport.com/documentation/?utm_source=import-plugin-free&utm_medium=help&utm_campaign=docs" target="_blank"><?php _e('Documentation', 'wp_all_import_plugin'); ?></a>
16
  </div>
17
  </div>
18
  <div class="clear"></div>
45
  <h4><?php _e("It has changed and is not compatible with this import template.", "wp_all_import_plugin"); ?></h4>
46
  </div>
47
  </div>
48
+ <a class="button button-primary button-hero wpallimport-large-button wpallimport-notify-read-more" href="http://www.wpallimport.com/documentation/troubleshooting/problems-with-import-files/#invalid?utm_source=import-plugin-free&utm_medium=error&utm_campaign=docs" target="_blank"><?php _e('Read More', 'wp_all_import_plugin');?></a>
49
  </div>
50
 
51
  <?php $custom_type = get_post_type_object( PMXI_Plugin::$session->custom_type ); ?>
views/admin/import/element.php CHANGED
@@ -9,7 +9,7 @@
9
  <h2><?php _e('Import XML / CSV', 'wp_all_import_plugin'); ?></h2>
10
  </div>
11
  <div class="wpallimport-links">
12
- <a href="http://www.wpallimport.com/support/" target="_blank"><?php _e('Support', 'wp_all_import_plugin'); ?></a> | <a href="http://www.wpallimport.com/documentation/" target="_blank"><?php _e('Documentation', 'wp_all_import_plugin'); ?></a>
13
  </div>
14
  </div>
15
  <div class="clear"></div>
9
  <h2><?php _e('Import XML / CSV', 'wp_all_import_plugin'); ?></h2>
10
  </div>
11
  <div class="wpallimport-links">
12
+ <a href="http://www.wpallimport.com/support/?utm_source=import-plugin-free&utm_medium=help&utm_campaign=premium-support" target="_blank"><?php _e('Support', 'wp_all_import_plugin'); ?></a> | <a href="http://www.wpallimport.com/documentation/?utm_source=import-plugin-free&utm_medium=help&utm_campaign=premium-docs" target="_blank"><?php _e('Documentation', 'wp_all_import_plugin'); ?></a>
13
  </div>
14
  </div>
15
  <div class="clear"></div>
views/admin/import/index.php CHANGED
@@ -18,7 +18,7 @@
18
  <h2><?php _e('Import XML / CSV', 'wp_all_import_plugin'); ?></h2>
19
  </div>
20
  <div class="wpallimport-links">
21
- <a href="http://www.wpallimport.com/support/" target="_blank"><?php _e('Support', 'wp_all_import_plugin'); ?></a> | <a href="http://www.wpallimport.com/documentation/" target="_blank"><?php _e('Documentation', 'wp_all_import_plugin'); ?></a>
22
  </div>
23
  </div>
24
 
@@ -92,7 +92,7 @@
92
  <div class="wpallimport-note" style="margin: 20px auto 0; font-size: 13px;">
93
  <?php _e('<strong>Hint:</strong> After you create this import, you can schedule it to run automatically, on a pre-defined schedule, with cron jobs.', 'wp_all_import_plugin'); ?>
94
  <div class="wpallimport-free-edition-notice" style="display:none;">
95
- <a href="https://www.wpallimport.com/checkout/?edd_action=add_to_cart&download_id=1748&edd_options%5Bprice_id%5D=0&utm_source=free-plugin&utm_medium=in-plugin&utm_campaign=download-from-url" target="_blank" class="upgrade_link"><?php _e('Upgrade to the Pro edition of WP All Import to Download from URL', 'wp_all_import_plugin');?></a>
96
  <p><?php _e('If you already own it, remove the free edition and install the Pro edition.', 'wp_all_import_plugin'); ?></p>
97
  </div>
98
  </div>
@@ -117,7 +117,7 @@
117
  <div class="wpallimport-note" style="margin: 0 auto; font-size: 13px;">
118
  <?php printf(__('Files uploaded to <strong>%s</strong> will appear in this list.', 'wp_all_import_plugin'), $upload_dir['basedir'] . '/wpallimport/files') ?>
119
  <div class="wpallimport-free-edition-notice">
120
- <a href="https://www.wpallimport.com/checkout/?edd_action=add_to_cart&download_id=1748&edd_options%5Bprice_id%5D=0&utm_source=free-plugin&utm_medium=in-plugin&utm_campaign=use-existing-file" target="_blank" class="upgrade_link"><?php _e('Upgrade to the Pro edition of WP All Import to Use Existing Files', 'wp_all_import_plugin');?></a>
121
  <p><?php _e('If you already own it, remove the free edition and install the Pro edition.', 'wp_all_import_plugin'); ?></p>
122
  </div>
123
  </div>
@@ -190,11 +190,11 @@
190
  $sorted_cpt['import_users']->labels = new stdClass();
191
  $sorted_cpt['import_users']->labels->name = __('Users','wp_all_export_plugin');
192
 
193
- if ( class_exists('WooCommerce') ) {
194
- $sorted_cpt['shop_customer'] = new stdClass();
195
- $sorted_cpt['shop_customer']->labels = new stdClass();
196
- $sorted_cpt['shop_customer']->labels->name = __('WooCommerce Customers','wp_all_export_plugin');
197
- }
198
 
199
  break;
200
  }
@@ -305,13 +305,13 @@
305
  <?php if ( ! class_exists('PMUI_Plugin') ): ?>
306
  <div class="wpallimport-upgrade-notice" rel="import_users">
307
  <p><?php _e('The User Add-On is Required to Import Users', 'wp_all_import_plugin'); ?></p>
308
- <a href="http://www.wpallimport.com/checkout/?edd_action=add_to_cart&download_id=1921&edd_options%5Bprice_id%5D=1" target="_blank" class="upgrade_link"><?php _e('Purchase the User Add-On', 'wp_all_import_plugin');?></a>
309
  </div>
310
  <?php endif; ?>
311
  <?php if ( class_exists('WooCommerce') && ! class_exists('PMWI_Plugin') ): ?>
312
  <div class="wpallimport-upgrade-notice" rel="product">
313
  <p><?php _e('The WooCommerce Add-On is Required to Import Products', 'wp_all_import_plugin'); ?></p>
314
- <a href="http://www.wpallimport.com/order-now/?utm_source=free-plugin&utm_campaign=wooco-products&utm_medium=in-plugin" target="_blank" class="upgrade_link"><?php _e('Get the WooCommerce Add-On', 'wp_all_import_plugin');?></a>
315
  </div>
316
  <?php endif; ?>
317
  <?php if ( class_exists('WooCommerce') && ( ! class_exists('PMWI_Plugin') || class_exists('PMWI_Plugin') && PMWI_EDITION == 'free') ): ?>
@@ -321,7 +321,7 @@
321
  <?php else: ?>
322
  <p><?php _e('The WooCommerce Add-On Pro is Required to Import Orders', 'wp_all_import_plugin'); ?></p>
323
  <?php endif; ?>
324
- <a href="http://www.wpallimport.com/order-now/?utm_source=free-plugin&utm_campaign=wooco-orders&utm_medium=in-plugin" target="_blank" class="upgrade_link"><?php _e('Purchase the WooCommerce Add-On Pro', 'wp_all_import_plugin');?></a>
325
  </div>
326
  <div class="wpallimport-upgrade-notice" rel="shop_coupon">
327
  <?php if (class_exists('PMWI_Plugin') && PMWI_EDITION == 'free'): ?>
@@ -329,18 +329,18 @@
329
  <?php else: ?>
330
  <p><?php _e('The WooCommerce Add-On Pro is Required to Import Coupons', 'wp_all_import_plugin'); ?></p>
331
  <?php endif; ?>
332
- <a href="http://www.wpallimport.com/order-now/?utm_source=free-plugin&utm_campaign=wooco-coupons&utm_medium=in-plugin" target="_blank" class="upgrade_link"><?php _e('Purchase the WooCommerce Add-On Pro', 'wp_all_import_plugin');?></a>
333
  </div>
334
  <?php endif; ?>
335
  <div class="wpallimport-upgrade-notice" rel="taxonomies">
336
  <p><?php _e('WP All Import Pro is Required to Import Taxonomies', 'wp_all_import_plugin'); ?></p>
337
- <a href="http://www.wpallimport.com/order-now/?utm_source=free-plugin&utm_campaign=taxonomies&utm_medium=in-plugin" target="_blank" class="upgrade_link"><?php _e('Purchase WP All Import Pro', 'wp_all_import_plugin');?></a>
338
  </div>
339
 
340
  <?php if ( class_exists('WooCommerce') && ! class_exists('PMUI_Plugin') ): ?>
341
  <div class="wpallimport-upgrade-notice" rel="shop_customer">
342
  <p><?php _e('The User Add-On is Required to Import Customers', 'wp_all_import_plugin'); ?></p>
343
- <a href="http://www.wpallimport.com/checkout/?edd_action=add_to_cart&download_id=1921&edd_options%5Bprice_id%5D=1" target="_blank" class="upgrade_link"><?php _e('Purchase the User Add-On', 'wp_all_import_plugin');?></a>
344
  </div>
345
  <?php endif; ?>
346
 
@@ -364,7 +364,7 @@
364
  <h4><?php _e("Contact your host and have them check your server's error log.", "wp_all_import_plugin"); ?></h4>
365
  </div>
366
  </div>
367
- <a class="button button-primary button-hero wpallimport-large-button wpallimport-notify-read-more" href="http://www.wpallimport.com/documentation/troubleshooting/problems-with-import-files/" target="_blank"><?php _e('Read More', 'wp_all_import_plugin');?></a>
368
  </div>
369
 
370
  <div class="rad4 first-step-errors error-file-validation" <?php if ( ! empty($upload_validation) ): ?> style="display:block;" <?php endif; ?>>
@@ -381,7 +381,7 @@
381
  </h4>
382
  </div>
383
  </div>
384
- <a class="button button-primary button-hero wpallimport-large-button wpallimport-notify-read-more" href="http://www.wpallimport.com/documentation/troubleshooting/problems-with-import-files/#invalid" target="_blank"><?php _e('Read More', 'wp_all_import_plugin');?></a>
385
  </div>
386
 
387
  <p class="wpallimport-submit-buttons">
18
  <h2><?php _e('Import XML / CSV', 'wp_all_import_plugin'); ?></h2>
19
  </div>
20
  <div class="wpallimport-links">
21
+ <a href="http://www.wpallimport.com/support/?utm_source=import-plugin-free&utm_medium=help&utm_campaign=premium-support" target="_blank"><?php _e('Support', 'wp_all_import_plugin'); ?></a> | <a href="http://www.wpallimport.com/documentation/?utm_source=import-plugin-free&utm_medium=help&utm_campaign=docs" target="_blank"><?php _e('Documentation', 'wp_all_import_plugin'); ?></a>
22
  </div>
23
  </div>
24
 
92
  <div class="wpallimport-note" style="margin: 20px auto 0; font-size: 13px;">
93
  <?php _e('<strong>Hint:</strong> After you create this import, you can schedule it to run automatically, on a pre-defined schedule, with cron jobs.', 'wp_all_import_plugin'); ?>
94
  <div class="wpallimport-free-edition-notice" style="display:none;">
95
+ <a href="https://www.wpallimport.com/checkout/?edd_action=add_to_cart&download_id=1748&edd_options%5Bprice_id%5D=0&utm_source=import-plugin-free&utm_medium=upgrade-notice&utm_campaign=download-from-url" target="_blank" class="upgrade_link"><?php _e('Upgrade to the Pro edition of WP All Import to Download from URL', 'wp_all_import_plugin');?></a>
96
  <p><?php _e('If you already own it, remove the free edition and install the Pro edition.', 'wp_all_import_plugin'); ?></p>
97
  </div>
98
  </div>
117
  <div class="wpallimport-note" style="margin: 0 auto; font-size: 13px;">
118
  <?php printf(__('Files uploaded to <strong>%s</strong> will appear in this list.', 'wp_all_import_plugin'), $upload_dir['basedir'] . '/wpallimport/files') ?>
119
  <div class="wpallimport-free-edition-notice">
120
+ <a href="https://www.wpallimport.com/checkout/?edd_action=add_to_cart&download_id=1748&edd_options%5Bprice_id%5D=0&utm_source=import-plugin-free&utm_medium=upgrade-notice&utm_campaign=use-existing-file" target="_blank" class="upgrade_link"><?php _e('Upgrade to the Pro edition of WP All Import to Use Existing Files', 'wp_all_import_plugin');?></a>
121
  <p><?php _e('If you already own it, remove the free edition and install the Pro edition.', 'wp_all_import_plugin'); ?></p>
122
  </div>
123
  </div>
190
  $sorted_cpt['import_users']->labels = new stdClass();
191
  $sorted_cpt['import_users']->labels->name = __('Users','wp_all_export_plugin');
192
 
193
+ // if ( class_exists('WooCommerce') ) {
194
+ // $sorted_cpt['shop_customer'] = new stdClass();
195
+ // $sorted_cpt['shop_customer']->labels = new stdClass();
196
+ // $sorted_cpt['shop_customer']->labels->name = __('WooCommerce Customers','wp_all_export_plugin');
197
+ // }
198
 
199
  break;
200
  }
305
  <?php if ( ! class_exists('PMUI_Plugin') ): ?>
306
  <div class="wpallimport-upgrade-notice" rel="import_users">
307
  <p><?php _e('The User Add-On is Required to Import Users', 'wp_all_import_plugin'); ?></p>
308
+ <a href="https://www.wpallimport.com/checkout/?edd_action=purchase_collection&taxonomy=download_category&terms=40&utm_source=import-plugin-free&utm_medium=upgrade-notice&utm_campaign=import-users" target="_blank" class="upgrade_link"><?php _e('Purchase the User Add-On', 'wp_all_import_plugin');?></a>
309
  </div>
310
  <?php endif; ?>
311
  <?php if ( class_exists('WooCommerce') && ! class_exists('PMWI_Plugin') ): ?>
312
  <div class="wpallimport-upgrade-notice" rel="product">
313
  <p><?php _e('The WooCommerce Add-On is Required to Import Products', 'wp_all_import_plugin'); ?></p>
314
+ <a href="https://www.wpallimport.com/checkout/?edd_action=purchase_collection&taxonomy=download_category&terms=14&utm_source=import-plugin-free&utm_medium=upgrade-notice&utm_campaign=import-wooco-products" target="_blank" class="upgrade_link"><?php _e('Purchase the WooCommerce Add-On', 'wp_all_import_plugin');?></a>
315
  </div>
316
  <?php endif; ?>
317
  <?php if ( class_exists('WooCommerce') && ( ! class_exists('PMWI_Plugin') || class_exists('PMWI_Plugin') && PMWI_EDITION == 'free') ): ?>
321
  <?php else: ?>
322
  <p><?php _e('The WooCommerce Add-On Pro is Required to Import Orders', 'wp_all_import_plugin'); ?></p>
323
  <?php endif; ?>
324
+ <a href="https://www.wpallimport.com/checkout/?edd_action=purchase_collection&taxonomy=download_category&terms=14&utm_source=import-plugin-free&utm_medium=upgrade-notice&utm_campaign=import-wooco-orders" target="_blank" class="upgrade_link"><?php _e('Purchase the WooCommerce Add-On', 'wp_all_import_plugin');?></a>
325
  </div>
326
  <div class="wpallimport-upgrade-notice" rel="shop_coupon">
327
  <?php if (class_exists('PMWI_Plugin') && PMWI_EDITION == 'free'): ?>
329
  <?php else: ?>
330
  <p><?php _e('The WooCommerce Add-On Pro is Required to Import Coupons', 'wp_all_import_plugin'); ?></p>
331
  <?php endif; ?>
332
+ <a href="https://www.wpallimport.com/checkout/?edd_action=purchase_collection&taxonomy=download_category&terms=14&utm_source=import-plugin-free&utm_medium=upgrade-notice&utm_campaign=import-wooco-coupons" target="_blank" class="upgrade_link"><?php _e('Purchase the WooCommerce Add-On', 'wp_all_import_plugin');?></a>
333
  </div>
334
  <?php endif; ?>
335
  <div class="wpallimport-upgrade-notice" rel="taxonomies">
336
  <p><?php _e('WP All Import Pro is Required to Import Taxonomies', 'wp_all_import_plugin'); ?></p>
337
+ <a href="https://www.wpallimport.com/checkout/?edd_action=add_to_cart&download_id=1748&edd_options%5Bprice_id%5D=0&utm_source=import-plugin-free&utm_medium=upgrade-notice&utm_campaign=import-taxonomies" target="_blank" class="upgrade_link"><?php _e('Purchase WP All Import Pro', 'wp_all_import_plugin');?></a>
338
  </div>
339
 
340
  <?php if ( class_exists('WooCommerce') && ! class_exists('PMUI_Plugin') ): ?>
341
  <div class="wpallimport-upgrade-notice" rel="shop_customer">
342
  <p><?php _e('The User Add-On is Required to Import Customers', 'wp_all_import_plugin'); ?></p>
343
+ <a href="https://www.wpallimport.com/checkout/?edd_action=purchase_collection&taxonomy=download_category&terms=40&utm_source=import-plugin-free&utm_medium=upgrade-notice&utm_campaign=import-users"><?php _e('Purchase the User Add-On', 'wp_all_import_plugin');?></a>
344
  </div>
345
  <?php endif; ?>
346
 
364
  <h4><?php _e("Contact your host and have them check your server's error log.", "wp_all_import_plugin"); ?></h4>
365
  </div>
366
  </div>
367
+ <a class="button button-primary button-hero wpallimport-large-button wpallimport-notify-read-more" href="http://www.wpallimport.com/documentation/troubleshooting/problems-with-import-files/?utm_source=import-plugin-free&utm_medium=error&utm_campaign=docs" target="_blank"><?php _e('Read More', 'wp_all_import_plugin');?></a>
368
  </div>
369
 
370
  <div class="rad4 first-step-errors error-file-validation" <?php if ( ! empty($upload_validation) ): ?> style="display:block;" <?php endif; ?>>
381
  </h4>
382
  </div>
383
  </div>
384
+ <a class="button button-primary button-hero wpallimport-large-button wpallimport-notify-read-more" href="http://www.wpallimport.com/documentation/troubleshooting/problems-with-import-files/#invalid?utm_source=import-plugin-free&utm_medium=error&utm_campaign=docs" target="_blank"><?php _e('Read More', 'wp_all_import_plugin');?></a>
385
  </div>
386
 
387
  <p class="wpallimport-submit-buttons">
views/admin/import/options.php CHANGED
@@ -19,7 +19,7 @@
19
  <h2><?php _e('Import XML / CSV', 'wp_all_import_plugin'); ?></h2>
20
  </div>
21
  <div class="wpallimport-links">
22
- <a href="http://www.wpallimport.com/support/" target="_blank"><?php _e('Support', 'wp_all_import_plugin'); ?></a> | <a href="http://www.wpallimport.com/documentation/" target="_blank"><?php _e('Documentation', 'wp_all_import_plugin'); ?></a>
23
  </div>
24
  </div>
25
  <div class="clear"></div>
@@ -62,7 +62,7 @@
62
  <h4 style="font-size:18px;"><?php _e("It has changed and is not compatible with this import template.", "wp_all_import_plugin"); ?></h4>
63
  </div>
64
  </div>
65
- <a class="button button-primary button-hero wpallimport-large-button wpallimport-notify-read-more" href="http://www.wpallimport.com/documentation/troubleshooting/problems-with-import-files/#invalid" target="_blank"><?php _e('Read More', 'wp_all_import_plugin');?></a>
66
  </div>
67
 
68
  <form class="<?php echo ! $isWizard ? 'edit' : 'options' ?>" method="post" enctype="multipart/form-data" autocomplete="off" <?php echo ! $isWizard ? 'style="overflow:visible;"' : '' ?>>
19
  <h2><?php _e('Import XML / CSV', 'wp_all_import_plugin'); ?></h2>
20
  </div>
21
  <div class="wpallimport-links">
22
+ <a href="http://www.wpallimport.com/support/?utm_source=import-plugin-free&utm_medium=help&utm_campaign=premium-support" target="_blank"><?php _e('Support', 'wp_all_import_plugin'); ?></a> | <a href="http://www.wpallimport.com/documentation/?utm_source=import-plugin-free&utm_medium=help&utm_campaign=docs" target="_blank"><?php _e('Documentation', 'wp_all_import_plugin'); ?></a>
23
  </div>
24
  </div>
25
  <div class="clear"></div>
62
  <h4 style="font-size:18px;"><?php _e("It has changed and is not compatible with this import template.", "wp_all_import_plugin"); ?></h4>
63
  </div>
64
  </div>
65
+ <a class="button button-primary button-hero wpallimport-large-button wpallimport-notify-read-more" href="http://www.wpallimport.com/documentation/troubleshooting/problems-with-import-files/#invalid?utm_source=import-plugin-free&utm_medium=error&utm_campaign=import-file-changed" target="_blank"><?php _e('Read More', 'wp_all_import_plugin');?></a>
66
  </div>
67
 
68
  <form class="<?php echo ! $isWizard ? 'edit' : 'options' ?>" method="post" enctype="multipart/form-data" autocomplete="off" <?php echo ! $isWizard ? 'style="overflow:visible;"' : '' ?>>
views/admin/import/options/_import_file.php CHANGED
@@ -11,7 +11,7 @@
11
  <h4><?php _e("Contact your host and have them check your server's error log.", "wp_all_import_plugin"); ?></h4>
12
  </div>
13
  </div>
14
- <a class="button button-primary button-hero wpallimport-large-button wpallimport-notify-read-more" href="http://www.wpallimport.com/documentation/troubleshooting/problems-with-import-files/" target="_blank"><?php _e('Read More', 'wp_all_import_plugin');?></a>
15
  </div>
16
 
17
  <div class="rad4 first-step-errors error-file-validation" <?php if ( ! empty($upload_validation) ): ?> style="display:block;" <?php endif; ?>>
@@ -28,7 +28,7 @@
28
  </h4>
29
  </div>
30
  </div>
31
- <a class="button button-primary button-hero wpallimport-large-button wpallimport-notify-read-more" href="http://www.wpallimport.com/documentation/troubleshooting/problems-with-import-files/#invalid" target="_blank"><?php _e('Read More', 'wp_all_import_plugin');?></a>
32
  </div>
33
 
34
  <div class="wpallimport-content-section">
@@ -78,7 +78,7 @@
78
  <span class="wpallimport-url-icon"></span>
79
  <input type="text" class="regular-text" name="url" value="<?php echo ('url' == $import->type) ? esc_attr($import->path) : 'Enter a web address to download the file from...'; ?>"/>
80
  <div class="wpallimport-free-edition-notice">
81
- <a href="https://www.wpallimport.com/checkout/?edd_action=add_to_cart&download_id=1748&edd_options%5Bprice_id%5D=0&utm_source=free-plugin&utm_medium=in-plugin&utm_campaign=download-from-url" target="_blank" class="upgrade_link"><?php _e('Upgrade to the Pro edition of WP All Import to Download from URL', 'wp_all_import_plugin');?></a>
82
  <p style="margin-top:16px;"><?php _e('If you already own it, remove the free edition and install the Pro edition.', 'wp_all_import_plugin'); ?></p>
83
  </div>
84
  </div>
@@ -104,7 +104,7 @@
104
  <?php printf(__('Files uploaded to <strong>%s</strong> will appear in this list.', 'wp_all_import_plugin'), $upload_dir['basedir'] . '/wpallimport/files'); ?>
105
  </div>
106
  <div class="wpallimport-free-edition-notice">
107
- <a href="https://www.wpallimport.com/checkout/?edd_action=add_to_cart&download_id=1748&edd_options%5Bprice_id%5D=0&utm_source=free-plugin&utm_medium=in-plugin&utm_campaign=use-existing-file" target="_blank" class="upgrade_link"><?php _e('Upgrade to the Pro edition of WP All Import to Use Existing Files', 'wp_all_import_plugin');?></a>
108
  <p style="margin-top:16px;"><?php _e('If you already own it, remove the free edition and install the Pro edition.', 'wp_all_import_plugin'); ?></p>
109
  </div>
110
  </div>
11
  <h4><?php _e("Contact your host and have them check your server's error log.", "wp_all_import_plugin"); ?></h4>
12
  </div>
13
  </div>
14
+ <a class="button button-primary button-hero wpallimport-large-button wpallimport-notify-read-more" href="http://www.wpallimport.com/documentation/troubleshooting/problems-with-import-files/?utm_source=import-plugin-free&utm_medium=error&utm_campaign=file-rejected" target="_blank"><?php _e('Read More', 'wp_all_import_plugin');?></a>
15
  </div>
16
 
17
  <div class="rad4 first-step-errors error-file-validation" <?php if ( ! empty($upload_validation) ): ?> style="display:block;" <?php endif; ?>>
28
  </h4>
29
  </div>
30
  </div>
31
+ <a class="button button-primary button-hero wpallimport-large-button wpallimport-notify-read-more" href="http://www.wpallimport.com/documentation/troubleshooting/problems-with-import-files/#invalid?utm_source=import-plugin-free&utm_medium=error&utm_campaign=invalid-file" target="_blank"><?php _e('Read More', 'wp_all_import_plugin');?></a>
32
  </div>
33
 
34
  <div class="wpallimport-content-section">
78
  <span class="wpallimport-url-icon"></span>
79
  <input type="text" class="regular-text" name="url" value="<?php echo ('url' == $import->type) ? esc_attr($import->path) : 'Enter a web address to download the file from...'; ?>"/>
80
  <div class="wpallimport-free-edition-notice">
81
+ <a href="https://www.wpallimport.com/checkout/?edd_action=add_to_cart&download_id=1748&edd_options%5Bprice_id%5D=0&utm_source=import-plugin-free&utm_medium=upgrade-notice&utm_campaign=download-from-url" target="_blank" class="upgrade_link"><?php _e('Upgrade to the Pro edition of WP All Import to Download from URL', 'wp_all_import_plugin');?></a>
82
  <p style="margin-top:16px;"><?php _e('If you already own it, remove the free edition and install the Pro edition.', 'wp_all_import_plugin'); ?></p>
83
  </div>
84
  </div>
104
  <?php printf(__('Files uploaded to <strong>%s</strong> will appear in this list.', 'wp_all_import_plugin'), $upload_dir['basedir'] . '/wpallimport/files'); ?>
105
  </div>
106
  <div class="wpallimport-free-edition-notice">
107
+ <a href="https://www.wpallimport.com/checkout/?edd_action=add_to_cart&download_id=1748&edd_options%5Bprice_id%5D=0&utm_source=import-plugin-free&utm_medium=error&utm_campaign=use-existing-file" target="_blank" class="upgrade_link"><?php _e('Upgrade to the Pro edition of WP All Import to Use Existing Files', 'wp_all_import_plugin');?></a>
108
  <p style="margin-top:16px;"><?php _e('If you already own it, remove the free edition and install the Pro edition.', 'wp_all_import_plugin'); ?></p>
109
  </div>
110
  </div>
views/admin/import/options/_settings_template.php CHANGED
@@ -78,11 +78,11 @@
78
  $sorted_cpt['import_users']->labels = new stdClass();
79
  $sorted_cpt['import_users']->labels->name = __('Users','wp_all_export_plugin');
80
 
81
- if ( class_exists('WooCommerce') ) {
82
- $sorted_cpt['shop_customer'] = new stdClass();
83
- $sorted_cpt['shop_customer']->labels = new stdClass();
84
- $sorted_cpt['shop_customer']->labels->name = __('WooCommerce Customers','wp_all_export_plugin');
85
- }
86
 
87
  break;
88
  }
@@ -180,7 +180,7 @@
180
  <?php if ( ! class_exists('PMUI_Plugin') ): ?>
181
  <div class="wpallimport-upgrade-notice" rel="import_users">
182
  <p><?php _e('The User Add-On is Required to Import Users', 'wp_all_import_plugin'); ?></p>
183
- <a href="http://www.wpallimport.com/checkout/?edd_action=add_to_cart&download_id=1921&edd_options%5Bprice_id%5D=1" target="_blank" class="upgrade_link"><?php _e('Purchase the User Add-On', 'wp_all_import_plugin');?></a>
184
  </div>
185
  <?php endif; ?>
186
 
@@ -188,7 +188,7 @@
188
  <?php if ( class_exists('WooCommerce') && ! class_exists('PMUI_Plugin') ): ?>
189
  <div class="wpallimport-upgrade-notice" rel="shop_customer">
190
  <p><?php _e('The User Add-On is Required to Import Customers', 'wp_all_import_plugin'); ?></p>
191
- <a href="http://www.wpallimport.com/checkout/?edd_action=add_to_cart&download_id=1921&edd_options%5Bprice_id%5D=1" target="_blank" class="upgrade_link"><?php _e('Purchase the User Add-On', 'wp_all_import_plugin');?></a>
192
  </div>
193
  <?php endif; ?>
194
 
@@ -196,7 +196,7 @@
196
  <?php if ( class_exists('WooCommerce') && ! class_exists('PMWI_Plugin') ): ?>
197
  <div class="wpallimport-upgrade-notice" rel="product">
198
  <p><?php _e('The WooCommerce Add-On is Required to Import Products', 'wp_all_import_plugin'); ?></p>
199
- <a href="http://www.wpallimport.com/order-now/?utm_source=free-plugin&utm_campaign=wooco-products&utm_medium=in-plugin" target="_blank" class="upgrade_link"><?php _e('Get the WooCommerce Add-On', 'wp_all_import_plugin');?></a>
200
  </div>
201
  <?php endif; ?>
202
  <?php if ( class_exists('WooCommerce') && ( ! class_exists('PMWI_Plugin') || class_exists('PMWI_Plugin') && PMWI_EDITION == 'free') ): ?>
@@ -204,22 +204,22 @@
204
  <?php if (class_exists('PMWI_Plugin') && PMWI_EDITION == 'free'): ?>
205
  <p><?php _e('The Pro version of the WooCommerce Add-On is required to Import Orders, but you have the free version installed.', 'wp_all_import_plugin'); ?></p>
206
  <?php else: ?>
207
- <p><?php _e('The WooCommerce Add-On Pro is Required to Import Orders', 'wp_all_import_plugin'); ?></p>
208
  <?php endif; ?>
209
- <a href="http://www.wpallimport.com/order-now/?utm_source=free-plugin&utm_campaign=wooco-orders&utm_medium=in-plugin" target="_blank" class="upgrade_link"><?php _e('Purchase the WooCommerce Add-On Pro', 'wp_all_import_plugin');?></a>
210
  </div>
211
  <div class="wpallimport-upgrade-notice" rel="shop_coupon">
212
  <?php if (class_exists('PMWI_Plugin') && PMWI_EDITION == 'free'): ?>
213
  <p><?php _e('The Pro version of the WooCommerce Add-On is required to Import Coupons, but you have the free version installed.', 'wp_all_import_plugin'); ?></p>
214
  <?php else: ?>
215
- <p><?php _e('The WooCommerce Add-On Pro is Required to Import Coupons', 'wp_all_import_plugin'); ?></p>
216
  <?php endif; ?>
217
- <a href="http://www.wpallimport.com/order-now/?utm_source=free-plugin&utm_campaign=wooco-coupons&utm_medium=in-plugin" target="_blank" class="upgrade_link"><?php _e('Purchase the WooCommerce Add-On Pro', 'wp_all_import_plugin');?></a>
218
  </div>
219
  <?php endif; ?>
220
  <div class="wpallimport-upgrade-notice" rel="taxonomies">
221
  <p><?php _e('WP All Import Pro is Required to Import Taxonomies', 'wp_all_import_plugin'); ?></p>
222
- <a href="http://www.wpallimport.com/order-now/?utm_source=free-plugin&utm_campaign=taxonomies&utm_medium=in-plugin" target="_blank" class="upgrade_link"><?php _e('Purchase WP All Import Pro', 'wp_all_import_plugin');?></a>
223
  </div>
224
 
225
  </div>
78
  $sorted_cpt['import_users']->labels = new stdClass();
79
  $sorted_cpt['import_users']->labels->name = __('Users','wp_all_export_plugin');
80
 
81
+ // if ( class_exists('WooCommerce') ) {
82
+ // $sorted_cpt['shop_customer'] = new stdClass();
83
+ // $sorted_cpt['shop_customer']->labels = new stdClass();
84
+ // $sorted_cpt['shop_customer']->labels->name = __('WooCommerce Customers','wp_all_export_plugin');
85
+ // }
86
 
87
  break;
88
  }
180
  <?php if ( ! class_exists('PMUI_Plugin') ): ?>
181
  <div class="wpallimport-upgrade-notice" rel="import_users">
182
  <p><?php _e('The User Add-On is Required to Import Users', 'wp_all_import_plugin'); ?></p>
183
+ <a href="https://www.wpallimport.com/checkout/?edd_action=purchase_collection&taxonomy=download_category&terms=40&utm_source=import-plugin-free&utm_medium=upgrade-notice&utm_campaign=import-users" target="_blank" class="upgrade_link"><?php _e('Purchase the User Add-On', 'wp_all_import_plugin');?></a>
184
  </div>
185
  <?php endif; ?>
186
 
188
  <?php if ( class_exists('WooCommerce') && ! class_exists('PMUI_Plugin') ): ?>
189
  <div class="wpallimport-upgrade-notice" rel="shop_customer">
190
  <p><?php _e('The User Add-On is Required to Import Customers', 'wp_all_import_plugin'); ?></p>
191
+ <a href="https://www.wpallimport.com/checkout/?edd_action=purchase_collection&taxonomy=download_category&terms=40&utm_source=import-plugin-free&utm_medium=upgrade-notice&utm_campaign=import-users" target="_blank" class="upgrade_link"><?php _e('Purchase the User Add-On', 'wp_all_import_plugin');?></a>
192
  </div>
193
  <?php endif; ?>
194
 
196
  <?php if ( class_exists('WooCommerce') && ! class_exists('PMWI_Plugin') ): ?>
197
  <div class="wpallimport-upgrade-notice" rel="product">
198
  <p><?php _e('The WooCommerce Add-On is Required to Import Products', 'wp_all_import_plugin'); ?></p>
199
+ <a href="https://www.wpallimport.com/checkout/?edd_action=purchase_collection&taxonomy=download_category&terms=14&utm_source=import-plugin-free&utm_medium=upgrade-notice&utm_campaign=import-wooco-products" target="_blank" class="upgrade_link"><?php _e('Purchase the WooCommerce Add-On', 'wp_all_import_plugin');?></a>
200
  </div>
201
  <?php endif; ?>
202
  <?php if ( class_exists('WooCommerce') && ( ! class_exists('PMWI_Plugin') || class_exists('PMWI_Plugin') && PMWI_EDITION == 'free') ): ?>
204
  <?php if (class_exists('PMWI_Plugin') && PMWI_EDITION == 'free'): ?>
205
  <p><?php _e('The Pro version of the WooCommerce Add-On is required to Import Orders, but you have the free version installed.', 'wp_all_import_plugin'); ?></p>
206
  <?php else: ?>
207
+ <p><?php _e('The WooCommerce Add-On is Required to Import Orders', 'wp_all_import_plugin'); ?></p>
208
  <?php endif; ?>
209
+ <a href="https://www.wpallimport.com/checkout/?edd_action=purchase_collection&taxonomy=download_category&terms=14&utm_source=import-plugin-free&utm_medium=upgrade-notice&utm_campaign=import-wooco-orders" target="_blank" class="upgrade_link"><?php _e('Purchase the WooCommerce Add-On', 'wp_all_import_plugin');?></a>
210
  </div>
211
  <div class="wpallimport-upgrade-notice" rel="shop_coupon">
212
  <?php if (class_exists('PMWI_Plugin') && PMWI_EDITION == 'free'): ?>
213
  <p><?php _e('The Pro version of the WooCommerce Add-On is required to Import Coupons, but you have the free version installed.', 'wp_all_import_plugin'); ?></p>
214
  <?php else: ?>
215
+ <p><?php _e('The WooCommerce Add-On is Required to Import Coupons', 'wp_all_import_plugin'); ?></p>
216
  <?php endif; ?>
217
+ <a href="https://www.wpallimport.com/checkout/?edd_action=purchase_collection&taxonomy=download_category&terms=14&utm_source=import-plugin-free&utm_medium=upgrade-notice&utm_campaign=import-wooco-coupons"><?php _e('Purchase the WooCommerce Add-On', 'wp_all_import_plugin');?></a>
218
  </div>
219
  <?php endif; ?>
220
  <div class="wpallimport-upgrade-notice" rel="taxonomies">
221
  <p><?php _e('WP All Import Pro is Required to Import Taxonomies', 'wp_all_import_plugin'); ?></p>
222
+ <a href="https://www.wpallimport.com/checkout/?edd_action=add_to_cart&download_id=1748&edd_options%5Bprice_id%5D=0&utm_source=import-plugin-free&utm_medium=upgrade-notice&utm_campaign=import-taxonomies" target="_blank" class="upgrade_link"><?php _e('Purchase WP All Import Pro', 'wp_all_import_plugin');?></a>
223
  </div>
224
 
225
  </div>
views/admin/import/process.php CHANGED
@@ -9,7 +9,7 @@
9
  <h2><?php _e('Import XML / CSV', 'wp_all_import_plugin'); ?></h2>
10
  </div>
11
  <div class="wpallimport-links">
12
- <a href="http://www.wpallimport.com/support/" target="_blank"><?php _e('Support', 'wp_all_import_plugin'); ?></a> | <a href="http://www.wpallimport.com/documentation/" target="_blank"><?php _e('Documentation', 'wp_all_import_plugin'); ?></a>
13
  </div>
14
 
15
  <div class="clear"></div>
@@ -73,7 +73,7 @@
73
  <h4><?php _e("Check out our guide on increasing import speed.", "wp_all_import_plugin"); ?></h4>
74
  </div>
75
  </div>
76
- <a class="button button-primary button-hero wpallimport-large-button wpallimport-speed-up-notify-read-more" href="http://www.wpallimport.com/documentation/troubleshooting/slow-imports/" target="_blank"><?php _e('Read More', 'wp_all_import_plugin');?></a>
77
  <span><?php _e('opens in new tab', 'wp_all_import_plugin'); ?></span>
78
  </div>
79
 
@@ -83,7 +83,7 @@
83
  <div class="wpallimport-notify-wrapper">
84
  <div class="found_records terminated">
85
  <h3><?php _e('Your server terminated the import process', 'wp_all_import_plugin');?></h3>
86
- <h4 style="width: 77%; line-height: 25px;"><?php printf(__("<a href='%s' target='_blank'>Read more</a> about how to prevent this from happening again.", "wp_all_import_plugin"), "http://www.wpallimport.com/documentation/troubleshooting/terminated-imports/"); ?></h4>
87
  </div>
88
  </div>
89
  <input type="submit" id="wpallimport-try-again" style="position: absolute; top: 30%; right: 10px; display: block; padding-top: 1px;" value="<?php _e('Continue Import','wp_all_import_plugin');?>" class="button button-primary button-hero wpallimport-large-button">
@@ -107,7 +107,7 @@
107
  <h4 style="width: 78%; line-height: 25px;"><?php _e("Ask your host to check your server's error log. They will be able to determine why your server is terminating the import process.", "wp_all_import_plugin"); ?></h4>
108
  </div>
109
  </div>
110
- <a style="position: absolute; top: 35%; right: 10px; display: block; padding-top: 1px;" class="button button-primary button-hero wpallimport-large-button" href="http://www.wpallimport.com/documentation/troubleshooting/terminated-imports/" target="_blank"><?php _e('Read More', 'wp_all_import_plugin');?></a>
111
  </div>
112
  </span>
113
 
9
  <h2><?php _e('Import XML / CSV', 'wp_all_import_plugin'); ?></h2>
10
  </div>
11
  <div class="wpallimport-links">
12
+ <a href="http://www.wpallimport.com/support/?utm_source=import-plugin-free&utm_medium=help&utm_campaign=premium-support" target="_blank"><?php _e('Support', 'wp_all_import_plugin'); ?></a> | <a href="http://www.wpallimport.com/documentation/?utm_source=import-plugin-free&utm_medium=help&utm_campaign=docs" target="_blank"><?php _e('Documentation', 'wp_all_import_plugin'); ?></a>
13
  </div>
14
 
15
  <div class="clear"></div>
73
  <h4><?php _e("Check out our guide on increasing import speed.", "wp_all_import_plugin"); ?></h4>
74
  </div>
75
  </div>
76
+ <a class="button button-primary button-hero wpallimport-large-button wpallimport-speed-up-notify-read-more" href="http://www.wpallimport.com/documentation/troubleshooting/slow-imports/?utm_source=import-plugin-free&utm_medium=error&utm_campaign=slow-imports" target="_blank"><?php _e('Read More', 'wp_all_import_plugin');?></a>
77
  <span><?php _e('opens in new tab', 'wp_all_import_plugin'); ?></span>
78
  </div>
79
 
83
  <div class="wpallimport-notify-wrapper">
84
  <div class="found_records terminated">
85
  <h3><?php _e('Your server terminated the import process', 'wp_all_import_plugin');?></h3>
86
+ <h4 style="width: 77%; line-height: 25px;"><?php printf(__("<a href='%s' target='_blank'>Read more</a> about how to prevent this from happening again.", "wp_all_import_plugin"), "http://www.wpallimport.com/documentation/troubleshooting/terminated-imports/?utm_source=import-plugin-free&utm_medium=error&utm_campaign=termination"); ?></h4>
87
  </div>
88
  </div>
89
  <input type="submit" id="wpallimport-try-again" style="position: absolute; top: 30%; right: 10px; display: block; padding-top: 1px;" value="<?php _e('Continue Import','wp_all_import_plugin');?>" class="button button-primary button-hero wpallimport-large-button">
107
  <h4 style="width: 78%; line-height: 25px;"><?php _e("Ask your host to check your server's error log. They will be able to determine why your server is terminating the import process.", "wp_all_import_plugin"); ?></h4>
108
  </div>
109
  </div>
110
+ <a style="position: absolute; top: 35%; right: 10px; display: block; padding-top: 1px;" class="button button-primary button-hero wpallimport-large-button" href="http://www.wpallimport.com/documentation/troubleshooting/terminated-imports/?utm_source=import-plugin-free&utm_medium=error&utm_campaign=docs" target="_blank"><?php _e('Read More', 'wp_all_import_plugin');?></a>
111
  </div>
112
  </span>
113
 
views/admin/import/template.php CHANGED
@@ -10,7 +10,7 @@
10
  <h2><?php _e('Import XML / CSV', 'wp_all_import_plugin'); ?></h2>
11
  </div>
12
  <div class="wpallimport-links">
13
- <a href="http://www.wpallimport.com/support/" target="_blank"><?php _e('Support', 'wp_all_import_plugin'); ?></a> | <a href="http://www.wpallimport.com/documentation/" target="_blank"><?php _e('Documentation', 'wp_all_import_plugin'); ?></a>
14
  </div>
15
  </div>
16
  <div class="clear"></div>
@@ -159,7 +159,7 @@
159
  <div class="wpallimport-collapsed-content" style="padding: 0;">
160
  <div class="wpallimport-collapsed-content-inner">
161
  <div class="wpallimport-free-edition-notice" style="text-align:center; margin-top:0; margin-bottom: 40px;">
162
- <a href="https://www.wpallimport.com/checkout/?edd_action=add_to_cart&download_id=1748&edd_options%5Bprice_id%5D=0&utm_source=free-plugin&utm_medium=in-plugin&utm_campaign=custom-fields" target="_blank" class="upgrade_link"><?php _e('Upgrade to the Pro edition of WP All Import to use the Function Editor', 'wp_all_import_plugin');?></a>
163
  <p><?php _e('If you already own it, remove the free edition and install the Pro edition.', 'wp_all_import_plugin'); ?></p>
164
  </div>
165
 
@@ -221,7 +221,7 @@
221
  <input type="hidden" value="<?php _e('Upgrade to the Pro edition of WP All Import to Import Custom Fields', 'wp_all_import_plugin');?>" class="wpallimport-dynamic-notice-cf-text"/>
222
  <input type="hidden" value="<?php _e('Upgrade to the Pro edition of WP All Import to Import Images', 'wp_all_import_plugin');?>" class="wpallimport-dynamic-notice-images-text"/>
223
  <input type="hidden" value="<?php _e('Upgrade to the Pro edition of WP All Import to Import Images and Custom Fields', 'wp_all_import_plugin');?>" class="wpallimport-dynamic-notice-cf-image-text"/>
224
- <a href="https://www.wpallimport.com/checkout/?edd_action=add_to_cart&download_id=1748&edd_options%5Bprice_id%5D=0&utm_source=free-plugin&utm_medium=in-plugin&utm_campaign=custom-fields" target="_blank" class="upgrade_link"></a>
225
  <p><?php _e('If you already own it, remove the free edition and install the Pro edition.', 'wp_all_import_plugin'); ?></p>
226
  </div>
227
 
10
  <h2><?php _e('Import XML / CSV', 'wp_all_import_plugin'); ?></h2>
11
  </div>
12
  <div class="wpallimport-links">
13
+ <a href="http://www.wpallimport.com/support/?utm_source=import-plugin-free&utm_medium=help&utm_campaign=premium-support" target="_blank"><?php _e('Support', 'wp_all_import_plugin'); ?></a> | <a href="http://www.wpallimport.com/documentation/?utm_source=import-plugin-free&utm_medium=help&utm_campaign=docs" target="_blank"><?php _e('Documentation', 'wp_all_import_plugin'); ?></a>
14
  </div>
15
  </div>
16
  <div class="clear"></div>
159
  <div class="wpallimport-collapsed-content" style="padding: 0;">
160
  <div class="wpallimport-collapsed-content-inner">
161
  <div class="wpallimport-free-edition-notice" style="text-align:center; margin-top:0; margin-bottom: 40px;">
162
+ <a href="https://www.wpallimport.com/checkout/?edd_action=add_to_cart&download_id=1748&edd_options%5Bprice_id%5D=0&utm_source=import-plugin-free&utm_medium=upgrade-notice&utm_campaign=function-editor" target="_blank" class="upgrade_link"><?php _e('Upgrade to the Pro edition of WP All Import to use the Function Editor', 'wp_all_import_plugin');?></a>
163
  <p><?php _e('If you already own it, remove the free edition and install the Pro edition.', 'wp_all_import_plugin'); ?></p>
164
  </div>
165
 
221
  <input type="hidden" value="<?php _e('Upgrade to the Pro edition of WP All Import to Import Custom Fields', 'wp_all_import_plugin');?>" class="wpallimport-dynamic-notice-cf-text"/>
222
  <input type="hidden" value="<?php _e('Upgrade to the Pro edition of WP All Import to Import Images', 'wp_all_import_plugin');?>" class="wpallimport-dynamic-notice-images-text"/>
223
  <input type="hidden" value="<?php _e('Upgrade to the Pro edition of WP All Import to Import Images and Custom Fields', 'wp_all_import_plugin');?>" class="wpallimport-dynamic-notice-cf-image-text"/>
224
+ <a href="https://www.wpallimport.com/checkout/?edd_action=add_to_cart&download_id=1748&edd_options%5Bprice_id%5D=0&utm_source=import-plugin-free&utm_medium=upgrade-notice&utm_campaign=images-and-or-custom-fields" target="_blank" class="upgrade_link"></a>
225
  <p><?php _e('If you already own it, remove the free edition and install the Pro edition.', 'wp_all_import_plugin'); ?></p>
226
  </div>
227
 
views/admin/import/template/_custom_fields_template.php CHANGED
@@ -7,7 +7,7 @@
7
  <div class="wpallimport-collapsed-content" style="padding: 0;">
8
  <div class="wpallimport-collapsed-content-inner">
9
  <div class="wpallimport-free-edition-notice" style="text-align:center; margin-top:0; margin-bottom: 40px;">
10
- <a href="https://www.wpallimport.com/checkout/?edd_action=add_to_cart&download_id=1748&edd_options%5Bprice_id%5D=0&utm_source=free-plugin&utm_medium=in-plugin&utm_campaign=custom-fields" target="_blank" class="upgrade_link"><?php _e('Upgrade to the Pro edition of WP All Import to Import Custom Fields', 'pmxi_plugin');?></a>
11
  <p><?php _e('If you already own it, remove the free edition and install the Pro edition.', 'wp_all_import_plugin'); ?></p>
12
  </div>
13
  <script type="text/javascript">
7
  <div class="wpallimport-collapsed-content" style="padding: 0;">
8
  <div class="wpallimport-collapsed-content-inner">
9
  <div class="wpallimport-free-edition-notice" style="text-align:center; margin-top:0; margin-bottom: 40px;">
10
+ <a href="https://www.wpallimport.com/checkout/?edd_action=add_to_cart&download_id=1748&edd_options%5Bprice_id%5D=0&utm_source=import-plugin-free&utm_medium=upgrade-notice&utm_campaign=custom-fields" target="_blank" class="upgrade_link"><?php _e('Upgrade to the Pro edition of WP All Import to Import Custom Fields', 'pmxi_plugin');?></a>
11
  <p><?php _e('If you already own it, remove the free edition and install the Pro edition.', 'wp_all_import_plugin'); ?></p>
12
  </div>
13
  <script type="text/javascript">
views/admin/import/template/_featured_template.php CHANGED
@@ -8,7 +8,7 @@
8
  <?php if ($section_is_show_warning and ( $post_type != "product" or ! class_exists('PMWI_Plugin'))):?>
9
 
10
  <div class="wpallimport-free-edition-notice" style="text-align:center; margin-top:-15px; margin-bottom: 40px;">
11
- <a href="https://www.wpallimport.com/checkout/?edd_action=add_to_cart&download_id=1748&edd_options%5Bprice_id%5D=0?utm_source=free-plugin&utm_medium=in-plugin&utm_campaign=images" target="_blank" class="upgrade_link"><?php _e('Upgrade to the Pro edition of WP All Import to Import Images', 'pmxi_plugin');?></a>
12
  <p><?php _e('If you already own it, remove the free edition and install the Pro edition.', 'wp_all_import_plugin'); ?></p>
13
  </div>
14
 
8
  <?php if ($section_is_show_warning and ( $post_type != "product" or ! class_exists('PMWI_Plugin'))):?>
9
 
10
  <div class="wpallimport-free-edition-notice" style="text-align:center; margin-top:-15px; margin-bottom: 40px;">
11
+ <a href="https://www.wpallimport.com/checkout/?edd_action=add_to_cart&download_id=1748&edd_options%5Bprice_id%5D=0&utm_source=import-plugin-free&utm_medium=upgrade-notice&utm_campaign=images" target="_blank" class="upgrade_link"><?php _e('Upgrade to the Pro edition of WP All Import to Import Images', 'pmxi_plugin');?></a>
12
  <p><?php _e('If you already own it, remove the free edition and install the Pro edition.', 'wp_all_import_plugin'); ?></p>
13
  </div>
14
 
views/admin/manage/index.php CHANGED
@@ -372,7 +372,7 @@ $columns = apply_filters('pmxi_manage_imports_columns', $columns);
372
  }
373
  ?>
374
 
375
- <p style='font-size: 1.3em; font-weight: bold;'><a href="http://www.wpallimport.com/upgrade-to-pro/?utm_source=free-plugin&utm_medium=in-plugin&utm_campaign=manage" target="_blank" class="upgrade_link"><?php _e('Find out more about the Pro edition of WP All Import.', 'wp_all_import_plugin'); ?></a></p>
376
 
377
  <a href="http://soflyy.com/" target="_blank" class="wpallimport-created-by"><?php _e('Created by', 'wp_all_import_plugin'); ?> <span></span></a>
378
 
372
  }
373
  ?>
374
 
375
+ <p style='font-size: 1.3em; font-weight: bold;'><a href="http://www.wpallimport.com/upgrade-to-pro/?utm_source=import-plugin-free&utm_medium=help&utm_campaign=upgrade-to-pro" target="_blank" class="upgrade_link"><?php _e('Find out more about the Pro edition of WP All Import.', 'wp_all_import_plugin'); ?></a></p>
376
 
377
  <a href="http://soflyy.com/" target="_blank" class="wpallimport-created-by"><?php _e('Created by', 'wp_all_import_plugin'); ?> <span></span></a>
378
 
views/admin/manage/scheduling.php CHANGED
@@ -24,7 +24,7 @@
24
 
25
  <p><i><?php _e('Example:', 'wp_all_import_plugin'); ?></i></p>
26
 
27
- <p>wget -q -O /dev/null "<?php echo home_url() . '/wp-cron.php?import_key=' . $cron_job_key . '&import_id=' . $id . '&action=trigger'; ?>"</p>
28
 
29
  <p><strong><?php _e('Execution Script', 'wp_all_import_plugin'); ?></strong></p>
30
 
@@ -36,7 +36,7 @@
36
 
37
  <p><i><?php _e('Example:', 'wp_all_import_plugin'); ?></i></p>
38
 
39
- <p>wget -q -O /dev/null "<?php echo home_url() . '/wp-cron.php?import_key=' . $cron_job_key . '&import_id=' . $id . '&action=processing'; ?>"</p>
40
 
41
  <p><strong><?php _e('Notes', 'wp_all_import_plugin'); ?></strong></p>
42
 
@@ -45,7 +45,7 @@
45
  </p>
46
 
47
  <p>
48
- See the <a href='http://www.wpallimport.com/documentation/recurring/cron/'>documentation</a> for more details.
49
  </p>
50
 
51
  <?php else: ?>
24
 
25
  <p><i><?php _e('Example:', 'wp_all_import_plugin'); ?></i></p>
26
 
27
+ <p>wget -q -O /dev/null "<?php echo home_url() . '/wp-load.php?import_key=' . $cron_job_key . '&import_id=' . $id . '&action=trigger'; ?>"</p>
28
 
29
  <p><strong><?php _e('Execution Script', 'wp_all_import_plugin'); ?></strong></p>
30
 
36
 
37
  <p><i><?php _e('Example:', 'wp_all_import_plugin'); ?></i></p>
38
 
39
+ <p>wget -q -O /dev/null "<?php echo home_url() . '/wp-load.php?import_key=' . $cron_job_key . '&import_id=' . $id . '&action=processing'; ?>"</p>
40
 
41
  <p><strong><?php _e('Notes', 'wp_all_import_plugin'); ?></strong></p>
42
 
45
  </p>
46
 
47
  <p>
48
+ See the <a href='http://www.wpallimport.com/documentation/recurring/cron/?utm_source=import-plugin-free&utm_medium=help&utm_campaign=manual-scheduling'>documentation</a> for more details.
49
  </p>
50
 
51
  <?php else: ?>
views/admin/settings/index.php CHANGED
@@ -152,7 +152,7 @@
152
  <br>
153
  <h3><?php _e('Function Editor', 'wp_all_import_plugin') ?></h3>
154
  <div class="wpallimport-free-edition-notice" style="text-align:center; margin-top:0; margin-bottom: 40px;">
155
- <a href="https://www.wpallimport.com/checkout/?edd_action=add_to_cart&download_id=1748&edd_options%5Bprice_id%5D=0&utm_source=free-plugin&utm_medium=in-plugin&utm_campaign=custom-fields" target="_blank" class="upgrade_link"><?php _e('Upgrade to the Pro edition of WP All Import to use the Function Editor.', 'wp_all_import_plugin');?></a>
156
  <p><?php _e('If you already own it, remove the free edition and install the Pro edition.', 'wp_all_import_plugin'); ?></p>
157
  </div>
158
  <textarea id="wp_all_import_code" name="wp_all_import_code"><?php echo "<?php\n\n?>";?></textarea>
152
  <br>
153
  <h3><?php _e('Function Editor', 'wp_all_import_plugin') ?></h3>
154
  <div class="wpallimport-free-edition-notice" style="text-align:center; margin-top:0; margin-bottom: 40px;">
155
+ <a href="https://www.wpallimport.com/checkout/?edd_action=add_to_cart&download_id=1748&edd_options%5Bprice_id%5D=0&utm_source=import-plugin-free&utm_medium=upgrade-notice&utm_campaign=function-editor" target="_blank" class="upgrade_link"><?php _e('Upgrade to the Pro edition of WP All Import to use the Function Editor.', 'wp_all_import_plugin');?></a>
156
  <p><?php _e('If you already own it, remove the free edition and install the Pro edition.', 'wp_all_import_plugin'); ?></p>
157
  </div>
158
  <textarea id="wp_all_import_code" name="wp_all_import_code"><?php echo "<?php\n\n?>";?></textarea>