Import any XML or CSV File to WordPress - Version 3.5.2

Version Description

  • improvement: match existing images by filename with underscores
  • API: add new action wp_all_import_before_preserve_post_data
  • API: add new filter wp_all_import_specified_delimiters
  • bug fix: attachment author not imported for API image imports
Download this release

Release Info

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

Code changes from version 3.5.1 to 3.5.2

Files changed (192) hide show
  1. actions/wp_ajax_auto_detect_cf.php +13 -7
  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/pt/br/functions +0 -0
  162. classes/PHPExcel/locale/pt/functions +0 -0
  163. classes/PHPExcel/locale/sv/functions +408 -408
  164. classes/api.php +70 -50
  165. classes/handler.php +1 -1
  166. controllers/admin/import.php +1 -1
  167. helpers/functions.php +54 -63
  168. helpers/get_file_curl.php +3 -3
  169. helpers/reverse_taxonomies_html.php +1 -1
  170. helpers/wp_all_import_addon_notifications.php +2 -2
  171. helpers/wp_all_import_clear_directory.php +0 -0
  172. helpers/wp_all_import_ctx_mapping.php +0 -0
  173. helpers/wp_all_import_get_image_from_gallery.php +2 -2
  174. helpers/wp_all_import_is_json.php +2 -2
  175. helpers/wp_all_import_json_to_xml.php +0 -0
  176. helpers/wp_all_import_rand_char.php +0 -0
  177. helpers/wp_all_import_remove_source.php +0 -0
  178. helpers/wp_all_import_rmdir.php +0 -0
  179. helpers/wp_all_import_sanitize_filename.php +2 -0
  180. helpers/wp_all_import_secure_file.php +0 -0
  181. helpers/wp_all_import_strip_tags_content.php +0 -0
  182. helpers/wp_all_import_url_title.php +0 -0
  183. helpers/wpai_util_map.php +0 -0
  184. i18n/languages/wp_all_import_plugin-ja.mo +0 -0
  185. i18n/languages/wp_all_import_plugin-ja.po +0 -0
  186. libraries/XmlImportCsvParse.php +9 -14
  187. libraries/XmlImportParser.php +1 -1
  188. models/import/record.php +74 -142
  189. plugin.php +3 -2
  190. readme.txt +8 -2
  191. views/admin/import/options/_reimport_options.php +5 -0
  192. views/admin/import/options/_settings_template.php +1 -1
actions/wp_ajax_auto_detect_cf.php CHANGED
@@ -14,10 +14,22 @@ function pmxi_wp_ajax_auto_detect_cf(){
14
  global $wpdb;
15
  $table_prefix = $wpdb->prefix;
16
 
 
 
 
 
 
 
17
  $fields = array();
18
  switch ($post_type) {
19
- case 'import_users':
20
  case 'shop_customer':
 
 
 
 
 
 
 
21
  case 'taxonomies':
22
  $fields = $input->post('fields', array());
23
  break;
@@ -31,12 +43,6 @@ function pmxi_wp_ajax_auto_detect_cf(){
31
  break;
32
  }
33
 
34
- $ignoreFields = array(
35
- '_edit_lock', '_edit_last', '_wp_trash_meta_status', '_wp_trash_meta_time', '_visibility', '_stock_status', '_downloadable', '_virtual', '_regular_price', '_sale_price', '_purchase_note', '_featured', '_weight', '_length',
36
- '_width', '_height', '_sku', '_sale_price_dates_from', '_sale_price_dates_to', '_price', '_sold_individually', '_manage_stock', '_stock', '_upsell_ids', '_crosssell_ids','_downloadable_files', '_download_limit', '_download_expiry', '_download_type', '_product_url', '_button_text', '_backorders', '_tax_status', '_tax_class', '_product_image_gallery', '_default_attributes','total_sales', '_product_attributes', '_product_version', '_thumbnail_id', '_is_first_variation_created', '_regular_price_tmp', '_sale_price_tmp', '_price_tmp', '_stock_tmp',
37
- '_order_total', '_order_version', '_order_tax', '_order_shipping_tax', '_order_shipping', '_cart_discount_tax', '_cart_discount', '_order_currency', '_order_key', '_prices_include_tax'
38
- );
39
-
40
  $result = array();
41
 
42
  if ($fields) {
14
  global $wpdb;
15
  $table_prefix = $wpdb->prefix;
16
 
17
+ $ignoreFields = array(
18
+ '_edit_lock', '_edit_last', '_wp_trash_meta_status', '_wp_trash_meta_time', '_visibility', '_stock_status', '_downloadable', '_virtual', '_regular_price', '_sale_price', '_purchase_note', '_featured', '_weight', '_length',
19
+ '_width', '_height', '_sku', '_sale_price_dates_from', '_sale_price_dates_to', '_price', '_sold_individually', '_manage_stock', '_stock', '_upsell_ids', '_crosssell_ids','_downloadable_files', '_download_limit', '_download_expiry', '_download_type', '_product_url', '_button_text', '_backorders', '_tax_status', '_tax_class', '_product_image_gallery', '_default_attributes','total_sales', '_product_attributes', '_product_version', '_thumbnail_id', '_is_first_variation_created', '_regular_price_tmp', '_sale_price_tmp', '_price_tmp', '_stock_tmp',
20
+ '_order_total', '_order_version', '_order_tax', '_order_shipping_tax', '_order_shipping', '_cart_discount_tax', '_cart_discount', '_order_currency', '_order_key', '_prices_include_tax'
21
+ );
22
+
23
  $fields = array();
24
  switch ($post_type) {
 
25
  case 'shop_customer':
26
+ $user_fields = array('first_name', 'last_name', 'nickname', 'description', PMXI_Plugin::getInstance()->getWPPrefix() . 'capabilities');
27
+ $billing_fields = array('billing_first_name','billing_last_name','billing_company','billing_address_1','billing_address_2','billing_city','billing_postcode','billing_country','billing_state','billing_phone','billing_email');
28
+ $shipping_fields = array('shipping_first_name','shipping_last_name','shipping_company','shipping_address_1','shipping_address_2','shipping_city','shipping_postcode','shipping_country','shipping_state');
29
+ $ignoreFields = array_merge($ignoreFields, $user_fields, $billing_fields, $shipping_fields);
30
+ $fields = $input->post('fields', array());
31
+ break;
32
+ case 'import_users':
33
  case 'taxonomies':
34
  $fields = $input->post('fields', array());
35
  break;
43
  break;
44
  }
45
 
 
 
 
 
 
 
46
  $result = array();
47
 
48
  if ($fields) {
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/pt/br/functions CHANGED
File without changes
classes/PHPExcel/locale/pt/functions 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/api.php CHANGED
@@ -62,8 +62,8 @@ class PMXI_API
62
 
63
  $is_set_with_xpath_visible = true;
64
  foreach ($params['enum_values'] as $key => $value): ?>
65
- <div class="form-field wpallimport-radio-field wpallimport-<?php echo sanitize_title($params['field_name']); ?>_<?php echo $key; ?>">
66
- <input type="radio" id="<?php echo sanitize_title($params['field_name']); ?>_<?php echo $key; ?>" class="switcher" name="<?php echo $params['field_name']; ?>" value="<?php echo $key; ?>" <?php echo $key == $params['field_value'] ? 'checked="checked"': '' ?>/>
67
  <?php
68
  $label = '';
69
  $tooltip = '';
@@ -74,7 +74,7 @@ class PMXI_API
74
  $label = $value;
75
  }
76
  ?>
77
- <label for="<?php echo sanitize_title($params['field_name']); ?>_<?php echo $key; ?>"><?php echo $label; ?></label>
78
  <?php
79
  if (is_array($value) and ! empty($value)){
80
  foreach ($value as $k => $p) {
@@ -387,14 +387,23 @@ class PMXI_API
387
  $wp_filetype = false;
388
  $attch = false;
389
 
390
- if($check_existing) {
391
- // trying to find existing image in hash table
392
- if ("yes" == $download_images) {
393
  $logger and call_user_func($logger, sprintf(__('- Searching for existing image `%s` by URL...', 'wp_all_import_plugin'), rawurldecode($img_url)));
394
  $imageList = new PMXI_Image_List();
395
  $attch = $imageList->getExistingImageByUrl($img_url);
396
  if ($attch) {
397
  $logger and call_user_func($logger, sprintf(__('Existing image was found by URL `%s`...', 'wp_all_import_plugin'), $img_url));
 
 
 
 
 
 
 
 
 
398
  return $attch->ID;
399
  }
400
  }
@@ -415,7 +424,15 @@ class PMXI_API
415
  'image_url' => $img_url,
416
  'image_filename' => $image_name
417
  ))->insert();
418
-
 
 
 
 
 
 
 
 
419
  return $attch->ID;
420
  }
421
  }
@@ -427,30 +444,34 @@ class PMXI_API
427
 
428
  $is_base64_images_allowed = apply_filters("wp_all_import_is_base64_images_allowed", true, $url, false);
429
 
430
- if ( $file_type == 'images' and base64_encode(base64_decode($url)) == $url and $is_base64_images_allowed ){
431
-
432
  $image_name = md5($url) . '.jpg';
433
-
434
- // search existing attachment
435
  $attch = wp_all_import_get_image_from_gallery($image_name, $targetDir, $file_type);
436
-
437
  if (empty($attch)) {
438
  $logger and call_user_func($logger, sprintf(__('- <b>WARNING</b>: Image %s not found in media gallery.', 'wp_all_import_plugin'), trim($image_name)));
439
- }
440
- else {
441
  $logger and call_user_func($logger, sprintf(__('- Using existing image `%s`...', 'wp_all_import_plugin'), trim($image_name)));
 
 
 
 
 
 
 
 
 
442
  return $attch->ID;
443
  }
444
 
445
- if ("yes" == $download_images){
446
  $img = @imagecreatefromstring(base64_decode($url));
447
- if($img)
448
- {
449
  $image_filename = $image_name;
450
  $logger and call_user_func($logger, __('- found base64_encoded image', 'wp_all_import_plugin'));
451
  $image_filepath = $targetDir . '/' . $image_filename;
452
  imagejpeg($img, $image_filepath);
453
- 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))) {
454
  $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));
455
  } else {
456
  $result = true;
@@ -460,8 +481,8 @@ class PMXI_API
460
  }
461
  }
462
 
463
- // do not download images
464
- if ( "yes" != $download_images ){
465
 
466
  $image_filename = wp_unique_filename($targetDir, basename($image_name));
467
  $image_filepath = $targetDir . '/' . basename($image_filename);
@@ -473,9 +494,9 @@ class PMXI_API
473
 
474
  if ( @file_exists($wpai_image_path) and @copy( $wpai_image_path, $image_filepath )){
475
  $download_image = false;
476
- // valdate import attachments
477
- if ($file_type == 'files'){
478
- if( ! $wp_filetype = wp_check_filetype(basename($image_filepath), null )) {
479
  $logger and call_user_func($logger, sprintf(__('- <b>WARNING</b>: Can\'t detect attachment file type %s', 'wp_all_import_plugin'), trim($image_filepath)));
480
  @unlink($image_filepath);
481
  }
@@ -484,9 +505,9 @@ class PMXI_API
484
  $logger and call_user_func($logger, sprintf(__('- File `%s` has been successfully found', 'wp_all_import_plugin'), $wpai_image_path));
485
  }
486
  }
487
- // validate import images
488
- elseif($file_type == 'images'){
489
- 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))) {
490
  $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));
491
  @unlink($image_filepath);
492
  } else {
@@ -497,12 +518,11 @@ class PMXI_API
497
  }
498
  }
499
 
500
- if ($download_image){
501
 
502
- if ($file_type == 'images'){
503
  $logger and call_user_func($logger, sprintf(__('- Downloading image from `%s`', 'wp_all_import_plugin'), $url));
504
- }
505
- elseif ($file_type == 'files') {
506
  $logger and call_user_func($logger, sprintf(__('- Downloading file from `%s`', 'wp_all_import_plugin'), $url));
507
  }
508
 
@@ -515,34 +535,33 @@ class PMXI_API
515
 
516
  if ( (is_wp_error($request) or $request === false) and ! @file_put_contents($image_filepath, @file_get_contents($url))) {
517
  @unlink($image_filepath); // delete file since failed upload may result in empty file created
518
- } else{
519
 
520
- if($file_type == 'images'){
521
- if( ($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))) {
522
  $result = true;
523
  $logger and call_user_func($logger, sprintf(__('- Image `%s` has been successfully downloaded', 'wp_all_import_plugin'), $url));
524
  }
525
  }
526
- elseif($file_type == 'files'){
527
- if( $wp_filetype = wp_check_filetype(basename($image_filepath), null )) {
528
  $result = true;
529
  $logger and call_user_func($logger, sprintf(__('- File `%s` has been successfully downloaded', 'wp_all_import_plugin'), $url));
530
  }
531
  }
532
-
533
  }
534
 
535
- if ( ! $result ){
536
 
537
  $request = get_file_curl($url, $image_filepath);
538
 
539
  if ( (is_wp_error($request) or $request === false) and ! @file_put_contents($image_filepath, @file_get_contents($url))) {
540
  $logger and call_user_func($logger, sprintf(__('- <b>WARNING</b>: File %s cannot be saved locally as %s', 'wp_all_import_plugin'), $url, $image_filepath));
541
  @unlink($image_filepath); // delete file since failed upload may result in empty file created
542
- } else{
543
 
544
- if($file_type == 'images'){
545
- 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))) {
546
  $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'), $url));
547
  @unlink($image_filepath);
548
  } else {
@@ -550,12 +569,11 @@ class PMXI_API
550
  $logger and call_user_func($logger, sprintf(__('- Image `%s` has been successfully downloaded', 'wp_all_import_plugin'), $url));
551
  }
552
  }
553
- elseif($file_type == 'files'){
554
- if( ! $wp_filetype = wp_check_filetype(basename($image_filepath), null )) {
555
  $logger and call_user_func($logger, sprintf(__('- <b>WARNING</b>: Can\'t detect attachment file type %s', 'wp_all_import_plugin'), trim($url)));
556
  @unlink($image_filepath);
557
- }
558
- else {
559
  $result = true;
560
  $logger and call_user_func($logger, sprintf(__('- File `%s` has been successfully found', 'wp_all_import_plugin'), $url));
561
  }
@@ -564,16 +582,15 @@ class PMXI_API
564
  }
565
  }
566
 
567
- if ($create_image and $result){
568
 
569
  // you must first include the image.php file
570
  // for the function wp_generate_attachment_metadata() to work
571
  require_once(ABSPATH . 'wp-admin/includes/image.php');
572
 
573
- if($file_type == 'images'){
574
  $logger and call_user_func($logger, sprintf(__('- Creating an attachment for image `%s`', 'wp_all_import_plugin'), $targetUrl . '/' . basename($image_filename)));
575
- }
576
- else{
577
  $logger and call_user_func($logger, sprintf(__('- Creating an attachment for file `%s`', 'wp_all_import_plugin'), $targetUrl . '/' . basename($image_filename)));
578
  }
579
 
@@ -583,6 +600,9 @@ class PMXI_API
583
  'post_title' => basename($image_filename),
584
  'post_content' => '',
585
  );
 
 
 
586
  if ($file_type == 'images' and ($image_meta = wp_read_image_metadata($image_filepath))) {
587
  if (trim($image_meta['title']) && ! is_numeric(sanitize_title($image_meta['title'])))
588
  $attachment['post_title'] = $image_meta['title'];
@@ -611,8 +631,8 @@ class PMXI_API
611
  $logger and call_user_func($logger, sprintf(__('- Attachment has been successfully created for image `%s`', 'wp_all_import_plugin'), $targetUrl . '/' . basename($image_filename)));
612
  return $attid;
613
  }
614
-
615
  }
616
- else return $result;
 
617
  }
618
  }
62
 
63
  $is_set_with_xpath_visible = true;
64
  foreach ($params['enum_values'] as $key => $value): ?>
65
+ <div class="form-field wpallimport-radio-field wpallimport-<?php echo sanitize_title($params['field_name']); ?>_<?php echo sanitize_title($key); ?>">
66
+ <input type="radio" id="<?php echo sanitize_title($params['field_name']); ?>_<?php echo sanitize_title($key); ?>" class="switcher" name="<?php echo $params['field_name']; ?>" value="<?php echo $key; ?>" <?php echo $key == $params['field_value'] ? 'checked="checked"': '' ?>/>
67
  <?php
68
  $label = '';
69
  $tooltip = '';
74
  $label = $value;
75
  }
76
  ?>
77
+ <label for="<?php echo sanitize_title($params['field_name']); ?>_<?php echo sanitize_title($key); ?>"><?php echo $label; ?></label>
78
  <?php
79
  if (is_array($value) and ! empty($value)){
80
  foreach ($value as $k => $p) {
387
  $wp_filetype = false;
388
  $attch = false;
389
 
390
+ if ( $check_existing ) {
391
+ // Trying to find existing image in hash table.
392
+ if ("yes" == $download_images ) {
393
  $logger and call_user_func($logger, sprintf(__('- Searching for existing image `%s` by URL...', 'wp_all_import_plugin'), rawurldecode($img_url)));
394
  $imageList = new PMXI_Image_List();
395
  $attch = $imageList->getExistingImageByUrl($img_url);
396
  if ($attch) {
397
  $logger and call_user_func($logger, sprintf(__('Existing image was found by URL `%s`...', 'wp_all_import_plugin'), $img_url));
398
+ // Attach media to current post if it's currently unattached.
399
+ if (empty($attch->post_parent)) {
400
+ wp_update_post(
401
+ array(
402
+ 'ID' => $attch->ID,
403
+ 'post_parent' => $pid
404
+ )
405
+ );
406
+ }
407
  return $attch->ID;
408
  }
409
  }
424
  'image_url' => $img_url,
425
  'image_filename' => $image_name
426
  ))->insert();
427
+ // Attach media to current post if it's currently unattached.
428
+ if (empty($attch->post_parent)) {
429
+ wp_update_post(
430
+ array(
431
+ 'ID' => $attch->ID,
432
+ 'post_parent' => $pid
433
+ )
434
+ );
435
+ }
436
  return $attch->ID;
437
  }
438
  }
444
 
445
  $is_base64_images_allowed = apply_filters("wp_all_import_is_base64_images_allowed", true, $url, false);
446
 
447
+ if ( $file_type == 'images' && base64_encode(base64_decode($url)) == $url && $is_base64_images_allowed ) {
 
448
  $image_name = md5($url) . '.jpg';
449
+ // Search existing attachment.
 
450
  $attch = wp_all_import_get_image_from_gallery($image_name, $targetDir, $file_type);
 
451
  if (empty($attch)) {
452
  $logger and call_user_func($logger, sprintf(__('- <b>WARNING</b>: Image %s not found in media gallery.', 'wp_all_import_plugin'), trim($image_name)));
453
+ } else {
 
454
  $logger and call_user_func($logger, sprintf(__('- Using existing image `%s`...', 'wp_all_import_plugin'), trim($image_name)));
455
+ // Attach media to current post if it's currently unattached.
456
+ if (empty($attch->post_parent)) {
457
+ wp_update_post(
458
+ array(
459
+ 'ID' => $attch->ID,
460
+ 'post_parent' => $pid
461
+ )
462
+ );
463
+ }
464
  return $attch->ID;
465
  }
466
 
467
+ if ("yes" == $download_images) {
468
  $img = @imagecreatefromstring(base64_decode($url));
469
+ if ($img) {
 
470
  $image_filename = $image_name;
471
  $logger and call_user_func($logger, __('- found base64_encoded image', 'wp_all_import_plugin'));
472
  $image_filepath = $targetDir . '/' . $image_filename;
473
  imagejpeg($img, $image_filepath);
474
+ 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))) {
475
  $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));
476
  } else {
477
  $result = true;
481
  }
482
  }
483
 
484
+ // Do not download images.
485
+ if ( "yes" != $download_images ) {
486
 
487
  $image_filename = wp_unique_filename($targetDir, basename($image_name));
488
  $image_filepath = $targetDir . '/' . basename($image_filename);
494
 
495
  if ( @file_exists($wpai_image_path) and @copy( $wpai_image_path, $image_filepath )){
496
  $download_image = false;
497
+ // Validate import attachments.
498
+ if ($file_type == 'files') {
499
+ if ( ! $wp_filetype = wp_check_filetype(basename($image_filepath), null )) {
500
  $logger and call_user_func($logger, sprintf(__('- <b>WARNING</b>: Can\'t detect attachment file type %s', 'wp_all_import_plugin'), trim($image_filepath)));
501
  @unlink($image_filepath);
502
  }
505
  $logger and call_user_func($logger, sprintf(__('- File `%s` has been successfully found', 'wp_all_import_plugin'), $wpai_image_path));
506
  }
507
  }
508
+ // Validate import images.
509
+ elseif ($file_type == 'images') {
510
+ 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))) {
511
  $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));
512
  @unlink($image_filepath);
513
  } else {
518
  }
519
  }
520
 
521
+ if ( $download_image ) {
522
 
523
+ if ($file_type == 'images') {
524
  $logger and call_user_func($logger, sprintf(__('- Downloading image from `%s`', 'wp_all_import_plugin'), $url));
525
+ } elseif ($file_type == 'files') {
 
526
  $logger and call_user_func($logger, sprintf(__('- Downloading file from `%s`', 'wp_all_import_plugin'), $url));
527
  }
528
 
535
 
536
  if ( (is_wp_error($request) or $request === false) and ! @file_put_contents($image_filepath, @file_get_contents($url))) {
537
  @unlink($image_filepath); // delete file since failed upload may result in empty file created
538
+ } else {
539
 
540
+ if ($file_type == 'images') {
541
+ if ( ($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))) {
542
  $result = true;
543
  $logger and call_user_func($logger, sprintf(__('- Image `%s` has been successfully downloaded', 'wp_all_import_plugin'), $url));
544
  }
545
  }
546
+ elseif ($file_type == 'files'){
547
+ if ( $wp_filetype = wp_check_filetype(basename($image_filepath), null )) {
548
  $result = true;
549
  $logger and call_user_func($logger, sprintf(__('- File `%s` has been successfully downloaded', 'wp_all_import_plugin'), $url));
550
  }
551
  }
 
552
  }
553
 
554
+ if ( ! $result ) {
555
 
556
  $request = get_file_curl($url, $image_filepath);
557
 
558
  if ( (is_wp_error($request) or $request === false) and ! @file_put_contents($image_filepath, @file_get_contents($url))) {
559
  $logger and call_user_func($logger, sprintf(__('- <b>WARNING</b>: File %s cannot be saved locally as %s', 'wp_all_import_plugin'), $url, $image_filepath));
560
  @unlink($image_filepath); // delete file since failed upload may result in empty file created
561
+ } else {
562
 
563
+ if ($file_type == 'images') {
564
+ 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))) {
565
  $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'), $url));
566
  @unlink($image_filepath);
567
  } else {
569
  $logger and call_user_func($logger, sprintf(__('- Image `%s` has been successfully downloaded', 'wp_all_import_plugin'), $url));
570
  }
571
  }
572
+ elseif ($file_type == 'files') {
573
+ if ( ! $wp_filetype = wp_check_filetype(basename($image_filepath), null )) {
574
  $logger and call_user_func($logger, sprintf(__('- <b>WARNING</b>: Can\'t detect attachment file type %s', 'wp_all_import_plugin'), trim($url)));
575
  @unlink($image_filepath);
576
+ } else {
 
577
  $result = true;
578
  $logger and call_user_func($logger, sprintf(__('- File `%s` has been successfully found', 'wp_all_import_plugin'), $url));
579
  }
582
  }
583
  }
584
 
585
+ if ( $create_image && $result ) {
586
 
587
  // you must first include the image.php file
588
  // for the function wp_generate_attachment_metadata() to work
589
  require_once(ABSPATH . 'wp-admin/includes/image.php');
590
 
591
+ if ($file_type == 'images') {
592
  $logger and call_user_func($logger, sprintf(__('- Creating an attachment for image `%s`', 'wp_all_import_plugin'), $targetUrl . '/' . basename($image_filename)));
593
+ } else {
 
594
  $logger and call_user_func($logger, sprintf(__('- Creating an attachment for file `%s`', 'wp_all_import_plugin'), $targetUrl . '/' . basename($image_filename)));
595
  }
596
 
600
  'post_title' => basename($image_filename),
601
  'post_content' => '',
602
  );
603
+ if (!empty($articleData['post_author'])) {
604
+ $attachment['post_author'] = $articleData['post_author'];
605
+ }
606
  if ($file_type == 'images' and ($image_meta = wp_read_image_metadata($image_filepath))) {
607
  if (trim($image_meta['title']) && ! is_numeric(sanitize_title($image_meta['title'])))
608
  $attachment['post_title'] = $image_meta['title'];
631
  $logger and call_user_func($logger, sprintf(__('- Attachment has been successfully created for image `%s`', 'wp_all_import_plugin'), $targetUrl . '/' . basename($image_filename)));
632
  return $attid;
633
  }
 
634
  }
635
+
636
+ return $result;
637
  }
638
  }
classes/handler.php CHANGED
@@ -97,7 +97,7 @@ class PMXI_Handler extends PMXI_Session {
97
  add_option( $session_expiry_option, $this->_session_expiration, '', 'no' );
98
  } else {
99
  update_option( $session_option, $this->_data );
100
- }
101
  }
102
  }
103
 
97
  add_option( $session_expiry_option, $this->_session_expiration, '', 'no' );
98
  } else {
99
  update_option( $session_option, $this->_data );
100
+ }
101
  }
102
  }
103
 
controllers/admin/import.php CHANGED
@@ -1967,7 +1967,7 @@ class PMXI_Admin_Import extends PMXI_Controller_Admin {
1967
  if ( ! $this->errors->get_error_codes()) { // no validation errors found
1968
 
1969
  // Attributes fields logic
1970
- $post = apply_filters('pmxi_save_options', $post);
1971
 
1972
  if ($this->isWizard) {
1973
 
1967
  if ( ! $this->errors->get_error_codes()) { // no validation errors found
1968
 
1969
  // Attributes fields logic
1970
+ $post = apply_filters('pmxi_save_options', $post, $this->isWizard);
1971
 
1972
  if ($this->isWizard) {
1973
 
helpers/functions.php CHANGED
@@ -1,20 +1,19 @@
1
  <?php
2
 
3
- if (!function_exists('pmxi_if')){
4
- function pmxi_if($left_condition, $operand = '', $right_condition = '', $then, $else = ''){
5
  $str = trim(implode(' ', array($left_condition, html_entity_decode($operand), $right_condition)));
6
  return (eval ("return ($str);")) ? $then : $else;
7
  }
8
  }
9
 
10
- if (!function_exists('is_empty')){
11
- function is_empty($var)
12
- {
13
  return empty($var);
14
  }
15
  }
16
 
17
- if (!function_exists('pmxi_human_filesize')){
18
  function pmxi_human_filesize($bytes, $decimals = 2) {
19
  $sz = 'BKMGTP';
20
  $factor = (int) floor((strlen($bytes) - 1) / 3);
@@ -22,10 +21,8 @@
22
  }
23
  }
24
 
25
- if ( ! function_exists('pmxi_get_remote_image_ext')){
26
-
27
- function pmxi_get_remote_image_ext($filePath){
28
-
29
  $response = wp_remote_get($filePath);
30
  $headers = wp_remote_retrieve_headers( $response );
31
  $content_type = (!empty($headers['content-type'])) ? explode('/', $headers['content-type']) : false;
@@ -35,18 +32,16 @@
35
  if (preg_match('%png%i', $content_type[1])) return 'png';
36
  if (preg_match('%gif%i', $content_type[1])) return 'gif';
37
  if (preg_match('%svg%i', $content_type[1])) return 'svg';
 
38
  if (preg_match('%pdf%i', $content_type[1])) return 'pdf';
39
  return ($content_type[1] == "unknown") ? "" : $content_type[1];
40
  }
41
-
42
  return '';
43
-
44
  }
45
  }
46
 
47
- if ( ! function_exists('pmxi_getExtension')){
48
- function pmxi_getExtension($str)
49
- {
50
  $i = strrpos($str,".");
51
  if (!$i) return "";
52
  $l = strlen($str) - $i;
@@ -55,9 +50,8 @@
55
  }
56
  }
57
 
58
- if ( ! function_exists('pmxi_getExtensionFromStr')){
59
- function pmxi_getExtensionFromStr($str)
60
- {
61
  $filetype = wp_check_filetype($str);
62
  if (empty($filetype['ext'])){
63
  $filetype = wp_check_filetype(strtok($str, "?"));
@@ -66,40 +60,28 @@
66
  }
67
  }
68
 
69
- if ( ! function_exists('pmxi_convert_encoding')){
70
-
71
- function pmxi_convert_encoding ( $source, $target_encoding = 'ASCII' )
72
- {
73
-
74
- if ( function_exists('mb_detect_encoding') ){
75
-
76
  // detect the character encoding of the incoming file
77
  $encoding = mb_detect_encoding( $source, "auto" );
78
-
79
  // escape all of the question marks so we can remove artifacts from
80
  // the unicode conversion process
81
  $target = str_replace( "?", "[question_mark]", $source );
82
-
83
  // convert the string to the target encoding
84
  $target = mb_convert_encoding( $target, $target_encoding, $encoding);
85
-
86
  // remove any question marks that have been introduced because of illegal characters
87
  $target = str_replace( "?", "", $target );
88
-
89
  // replace the token string "[question_mark]" with the symbol "?"
90
  $target = str_replace( "[question_mark]", "?", $target );
91
-
92
  return html_entity_decode($target, ENT_COMPAT, 'UTF-8');
93
-
94
  }
95
-
96
  return $source;
97
  }
98
  }
99
 
100
- if ( ! function_exists('wp_all_import_get_remote_file_name')){
101
-
102
- function wp_all_import_get_remote_file_name($filePath){
103
  $bn = wp_all_import_basename($filePath);
104
  $type = (preg_match('%\W(csv|txt|dat|psv)$%i', $bn)) ? 'csv' : false;
105
  if (!$type) $type = (preg_match('%\W(xml)$%i', $bn)) ? 'xml' : false;
@@ -114,12 +96,11 @@
114
  if (!$type) $type = (preg_match('%\W(zip)$%i', $bn)) ? 'zip' : false;
115
  if (!$type) $type = (preg_match('%\W(gz)$%i', $bn)) ? 'gz' : false;
116
  }
117
-
118
  return ($type) ? $type : false;
119
  }
120
  }
121
 
122
- if ( ! function_exists('wp_all_import_translate_uri') ){
123
  function wp_all_import_translate_uri($uri) {
124
  $parts = explode('/', $uri);
125
  for ($i = 1; $i < count($parts); $i++) {
@@ -129,47 +110,49 @@
129
  }
130
  }
131
 
132
- if ( ! function_exists('wp_all_import_cdata_filter')){
133
- function wp_all_import_cdata_filter($matches){
134
  PMXI_Import_Record::$cdata[] = $matches[0];
135
  return '{{CPLACE_'. count(PMXI_Import_Record::$cdata) .'}}';
136
  }
137
- }
138
 
139
- if ( ! function_exists('wp_all_import_isValidMd5')){
140
- function wp_all_import_isValidMd5($md5 ='')
141
- {
 
 
 
 
 
 
 
 
142
  return preg_match('/^[a-f0-9]{32}$/', $md5);
143
  }
144
  }
145
 
146
- if ( ! function_exists('wp_all_import_get_relative_path') ){
147
  function wp_all_import_get_relative_path($path){
148
-
149
  $uploads = wp_upload_dir();
150
-
151
- return str_replace($uploads['basedir'], '', $path);
152
-
153
  }
154
  }
155
 
156
- if ( ! function_exists('wp_all_import_get_absolute_path') ){
157
- function wp_all_import_get_absolute_path($path){
158
-
159
- $uploads = wp_upload_dir();
160
-
161
  return ( strpos($path, $uploads['basedir']) === false and ! preg_match('%^https?://%i', $path)) ? $uploads['basedir'] . $path : $path;
162
-
163
  }
164
  }
165
 
166
- if ( ! function_exists('wp_all_import_clear_xss') ){
167
  function wp_all_import_clear_xss( $str ) {
168
  return stripslashes(esc_sql(htmlspecialchars(strip_tags($str))));
169
  }
170
  }
171
 
172
- if ( ! function_exists('wp_all_import_get_taxonomies')) {
173
  function wp_all_import_get_taxonomies() {
174
  // get all taxonomies
175
  $taxonomies = get_taxonomies(FALSE, 'objects');
@@ -190,35 +173,43 @@
190
  asort($r, SORT_FLAG_CASE | SORT_STRING);
191
  // return
192
  return $r;
193
-
194
  }
195
  }
196
 
197
- if ( ! function_exists('wp_all_import_is_password_protected_feed')){
198
  function wp_all_import_is_password_protected_feed($url){
199
  $url_data = parse_url($url);
200
  return (!empty($url_data['user']) and !empty($url_data['pass'])) ? true : false;
201
  }
202
  }
203
 
204
- if ( ! function_exists('wp_all_import_cmp_custom_types')){
205
- function wp_all_import_cmp_custom_types($a, $b)
206
- {
207
  return strcmp($a->labels->name, $b->labels->name);
208
  }
209
  }
210
 
211
- if ( ! function_exists('wp_all_import_basename')) {
212
  function wp_all_import_basename($file) {
213
  $a = explode('/', $file);
214
  return end($a);
215
  }
216
  }
217
 
218
- if ( ! function_exists('wp_all_import_update_post_count')) {
219
  function wp_all_import_update_post_count() {
220
  global $wpdb;
221
  update_option( 'post_count', (int) $wpdb->get_var( "SELECT COUNT(ID) FROM {$wpdb->posts} WHERE post_status = 'publish' and post_type = 'post'" ) );
222
  }
223
  }
224
 
 
 
 
 
 
 
 
 
 
 
1
  <?php
2
 
3
+ if ( ! function_exists('pmxi_if') ) {
4
+ function pmxi_if( $left_condition, $operand = '', $right_condition = '', $then, $else = '' ) {
5
  $str = trim(implode(' ', array($left_condition, html_entity_decode($operand), $right_condition)));
6
  return (eval ("return ($str);")) ? $then : $else;
7
  }
8
  }
9
 
10
+ if ( ! function_exists('is_empty') ) {
11
+ function is_empty( $var ) {
 
12
  return empty($var);
13
  }
14
  }
15
 
16
+ if ( ! function_exists('pmxi_human_filesize') ) {
17
  function pmxi_human_filesize($bytes, $decimals = 2) {
18
  $sz = 'BKMGTP';
19
  $factor = (int) floor((strlen($bytes) - 1) / 3);
21
  }
22
  }
23
 
24
+ if ( ! function_exists('pmxi_get_remote_image_ext') ) {
25
+ function pmxi_get_remote_image_ext( $filePath ) {
 
 
26
  $response = wp_remote_get($filePath);
27
  $headers = wp_remote_retrieve_headers( $response );
28
  $content_type = (!empty($headers['content-type'])) ? explode('/', $headers['content-type']) : false;
32
  if (preg_match('%png%i', $content_type[1])) return 'png';
33
  if (preg_match('%gif%i', $content_type[1])) return 'gif';
34
  if (preg_match('%svg%i', $content_type[1])) return 'svg';
35
+ if (preg_match('%webp%i', $content_type[1])) return 'webp';
36
  if (preg_match('%pdf%i', $content_type[1])) return 'pdf';
37
  return ($content_type[1] == "unknown") ? "" : $content_type[1];
38
  }
 
39
  return '';
 
40
  }
41
  }
42
 
43
+ if ( ! function_exists('pmxi_getExtension') ) {
44
+ function pmxi_getExtension( $str ){
 
45
  $i = strrpos($str,".");
46
  if (!$i) return "";
47
  $l = strlen($str) - $i;
50
  }
51
  }
52
 
53
+ if ( ! function_exists('pmxi_getExtensionFromStr' ) ) {
54
+ function pmxi_getExtensionFromStr( $str ) {
 
55
  $filetype = wp_check_filetype($str);
56
  if (empty($filetype['ext'])){
57
  $filetype = wp_check_filetype(strtok($str, "?"));
60
  }
61
  }
62
 
63
+ if ( ! function_exists('pmxi_convert_encoding')) {
64
+ function pmxi_convert_encoding ( $source, $target_encoding = 'ASCII' ) {
65
+ if ( function_exists('mb_detect_encoding') ) {
 
 
 
 
66
  // detect the character encoding of the incoming file
67
  $encoding = mb_detect_encoding( $source, "auto" );
 
68
  // escape all of the question marks so we can remove artifacts from
69
  // the unicode conversion process
70
  $target = str_replace( "?", "[question_mark]", $source );
 
71
  // convert the string to the target encoding
72
  $target = mb_convert_encoding( $target, $target_encoding, $encoding);
 
73
  // remove any question marks that have been introduced because of illegal characters
74
  $target = str_replace( "?", "", $target );
 
75
  // replace the token string "[question_mark]" with the symbol "?"
76
  $target = str_replace( "[question_mark]", "?", $target );
 
77
  return html_entity_decode($target, ENT_COMPAT, 'UTF-8');
 
78
  }
 
79
  return $source;
80
  }
81
  }
82
 
83
+ if ( ! function_exists('wp_all_import_get_remote_file_name') ) {
84
+ function wp_all_import_get_remote_file_name( $filePath ) {
 
85
  $bn = wp_all_import_basename($filePath);
86
  $type = (preg_match('%\W(csv|txt|dat|psv)$%i', $bn)) ? 'csv' : false;
87
  if (!$type) $type = (preg_match('%\W(xml)$%i', $bn)) ? 'xml' : false;
96
  if (!$type) $type = (preg_match('%\W(zip)$%i', $bn)) ? 'zip' : false;
97
  if (!$type) $type = (preg_match('%\W(gz)$%i', $bn)) ? 'gz' : false;
98
  }
 
99
  return ($type) ? $type : false;
100
  }
101
  }
102
 
103
+ if ( ! function_exists('wp_all_import_translate_uri') ) {
104
  function wp_all_import_translate_uri($uri) {
105
  $parts = explode('/', $uri);
106
  for ($i = 1; $i < count($parts); $i++) {
110
  }
111
  }
112
 
113
+ if ( ! function_exists('wp_all_import_cdata_filter') ) {
114
+ function wp_all_import_cdata_filter($matches) {
115
  PMXI_Import_Record::$cdata[] = $matches[0];
116
  return '{{CPLACE_'. count(PMXI_Import_Record::$cdata) .'}}';
117
  }
118
+ }
119
 
120
+ if ( ! function_exists('wp_all_import_amp_filter') ) {
121
+ function wp_all_import_amp_filter($matches) {
122
+ if (empty($matches[1]) && !empty($matches[0])) {
123
+ return "&amp;";
124
+ }
125
+ return in_array($matches[1], array("amp;", "lt;", "gt;")) ? "&" . $matches[1] : "&amp;" . $matches[1];
126
+ }
127
+ }
128
+
129
+ if ( ! function_exists('wp_all_import_isValidMd5') ) {
130
+ function wp_all_import_isValidMd5($md5 ='') {
131
  return preg_match('/^[a-f0-9]{32}$/', $md5);
132
  }
133
  }
134
 
135
+ if ( ! function_exists('wp_all_import_get_relative_path') ) {
136
  function wp_all_import_get_relative_path($path){
 
137
  $uploads = wp_upload_dir();
138
+ return str_replace($uploads['basedir'], '', $path);
 
 
139
  }
140
  }
141
 
142
+ if ( ! function_exists('wp_all_import_get_absolute_path') ) {
143
+ function wp_all_import_get_absolute_path($path) {
144
+ $uploads = wp_upload_dir();
 
 
145
  return ( strpos($path, $uploads['basedir']) === false and ! preg_match('%^https?://%i', $path)) ? $uploads['basedir'] . $path : $path;
 
146
  }
147
  }
148
 
149
+ if ( ! function_exists('wp_all_import_clear_xss') ) {
150
  function wp_all_import_clear_xss( $str ) {
151
  return stripslashes(esc_sql(htmlspecialchars(strip_tags($str))));
152
  }
153
  }
154
 
155
+ if ( ! function_exists('wp_all_import_get_taxonomies') ) {
156
  function wp_all_import_get_taxonomies() {
157
  // get all taxonomies
158
  $taxonomies = get_taxonomies(FALSE, 'objects');
173
  asort($r, SORT_FLAG_CASE | SORT_STRING);
174
  // return
175
  return $r;
 
176
  }
177
  }
178
 
179
+ if ( ! function_exists('wp_all_import_is_password_protected_feed') ) {
180
  function wp_all_import_is_password_protected_feed($url){
181
  $url_data = parse_url($url);
182
  return (!empty($url_data['user']) and !empty($url_data['pass'])) ? true : false;
183
  }
184
  }
185
 
186
+ if ( ! function_exists('wp_all_import_cmp_custom_types') ) {
187
+ function wp_all_import_cmp_custom_types($a, $b) {
 
188
  return strcmp($a->labels->name, $b->labels->name);
189
  }
190
  }
191
 
192
+ if ( ! function_exists('wp_all_import_basename') ) {
193
  function wp_all_import_basename($file) {
194
  $a = explode('/', $file);
195
  return end($a);
196
  }
197
  }
198
 
199
+ if ( ! function_exists('wp_all_import_update_post_count') ) {
200
  function wp_all_import_update_post_count() {
201
  global $wpdb;
202
  update_option( 'post_count', (int) $wpdb->get_var( "SELECT COUNT(ID) FROM {$wpdb->posts} WHERE post_status = 'publish' and post_type = 'post'" ) );
203
  }
204
  }
205
 
206
+ if ( ! function_exists('wp_all_import_supported_image_types') ) {
207
+ function wp_all_import_supported_image_types() {
208
+ $supported_image_types = array(IMAGETYPE_GIF, IMAGETYPE_JPEG, IMAGETYPE_PNG, IMAGETYPE_BMP);
209
+ if (defined('IMAGETYPE_WEBP')) {
210
+ $supported_image_types[] = IMAGETYPE_WEBP;
211
+ }
212
+ return $supported_image_types;
213
+ }
214
+ }
215
+
helpers/get_file_curl.php CHANGED
@@ -29,8 +29,8 @@ if ( ! function_exists('get_file_curl') ):
29
  fwrite($fp, $rawdata);
30
  fclose($fp);
31
  }
32
-
33
- if ( preg_match('%\W(svg)$%i', basename($fullpath)) or preg_match('%\W(jpg|jpeg|gif|png)$%i', basename($fullpath)) and ( ! ($image_info = apply_filters('pmxi_getimagesize', @getimagesize($fullpath), $fullpath)) or ! in_array($image_info[2], array(IMAGETYPE_GIF, IMAGETYPE_JPEG, IMAGETYPE_PNG, IMAGETYPE_BMP)) ) )
34
  {
35
  $result = pmxi_curl_download($url, $fullpath, $to_variable);
36
  if ( ! $result and $iteration === false)
@@ -89,7 +89,7 @@ if ( ! function_exists('pmxi_curl_download') ) {
89
  fclose($fp);
90
  }
91
 
92
- if ( preg_match('%\W(jpg|jpeg|gif|png)$%i', basename($fullpath)) and ( ! ($image_info = apply_filters('pmxi_getimagesize', @getimagesize($fullpath), $fullpath)) or ! in_array($image_info[2], array(IMAGETYPE_GIF, IMAGETYPE_JPEG, IMAGETYPE_PNG)) ) ){
93
  return false;
94
  }
95
 
29
  fwrite($fp, $rawdata);
30
  fclose($fp);
31
  }
32
+
33
+ if ( preg_match('%\W(svg)$%i', basename($fullpath)) or preg_match('%\W(jpg|jpeg|gif|png|webp)$%i', basename($fullpath)) and ( ! ($image_info = apply_filters('pmxi_getimagesize', @getimagesize($fullpath), $fullpath)) or ! in_array($image_info[2], wp_all_import_supported_image_types()) ) )
34
  {
35
  $result = pmxi_curl_download($url, $fullpath, $to_variable);
36
  if ( ! $result and $iteration === false)
89
  fclose($fp);
90
  }
91
 
92
+ if ( preg_match('%\W(jpg|jpeg|gif|png|webp)$%i', basename($fullpath)) and ( ! ($image_info = apply_filters('pmxi_getimagesize', @getimagesize($fullpath), $fullpath)) or ! in_array($image_info[2], wp_all_import_supported_image_types()))) {
93
  return false;
94
  }
95
 
helpers/reverse_taxonomies_html.php CHANGED
@@ -14,7 +14,7 @@ if ( ! function_exists('reverse_taxonomies_html') ) {
14
  $i++;
15
  ?>
16
  <li id="item_<?php echo $i; ?>" class="dragging">
17
- <div class="drag-element">
18
  <input type="checkbox" class="assign_term" <?php if (!empty($child_cat->assign)): ?>checked="checked"<?php endif; ?> title="<?php _e('Assign post to the taxonomy.','wp_all_import_plugin');?>"/>
19
  <input class="widefat xpath_field" type="text" value="<?php echo esc_textarea($child_cat->xpath); ?>"/>
20
  <?php do_action('pmxi_category_view', $cat, $i, $ctx_name, $entry); ?>
14
  $i++;
15
  ?>
16
  <li id="item_<?php echo $i; ?>" class="dragging">
17
+ <div class="drag-element">
18
  <input type="checkbox" class="assign_term" <?php if (!empty($child_cat->assign)): ?>checked="checked"<?php endif; ?> title="<?php _e('Assign post to the taxonomy.','wp_all_import_plugin');?>"/>
19
  <input class="widefat xpath_field" type="text" value="<?php echo esc_textarea($child_cat->xpath); ?>"/>
20
  <?php do_action('pmxi_category_view', $cat, $i, $ctx_name, $entry); ?>
helpers/wp_all_import_addon_notifications.php CHANGED
@@ -11,7 +11,7 @@ if ( ! function_exists('wp_all_import_addon_notifications') ){
11
  $parent_theme_name = ($parent_theme) ? $parent_theme->get('Name') : '';
12
 
13
  $current_themes = array($theme_name, $parent_theme_name);
14
-
15
  $recommended_addons = array();
16
 
17
  // Reales WP Add-On
@@ -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
  }
11
  $parent_theme_name = ($parent_theme) ? $parent_theme->get('Name') : '';
12
 
13
  $current_themes = array($theme_name, $parent_theme_name);
14
+
15
  $recommended_addons = array();
16
 
17
  // Reales WP Add-On
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
@@ -19,7 +19,7 @@ function wp_all_import_get_image_from_gallery($image_name, $targetDir = FALSE, $
19
  $attch = '';
20
 
21
  // search attachment by attached file
22
- $attachment_metas = $wpdb->get_results($wpdb->prepare("SELECT * FROM " . $wpdb->postmeta . " WHERE meta_key = %s AND (meta_value = %s OR meta_value LIKE %s);", '_wp_attached_file', $image_name, "%/" . $image_name));
23
 
24
  if (!empty($attachment_metas)) {
25
  foreach ($attachment_metas as $attachment_meta) {
@@ -32,7 +32,7 @@ function wp_all_import_get_image_from_gallery($image_name, $targetDir = FALSE, $
32
  }
33
 
34
  if (empty($attch)) {
35
- $attachment_metas = $wpdb->get_results($wpdb->prepare("SELECT * FROM " . $wpdb->postmeta . " WHERE meta_key = %s AND (meta_value = %s OR meta_value LIKE %s);", '_wp_attached_file', sanitize_file_name($image_name), "%/" . sanitize_file_name($image_name)));
36
 
37
  if (!empty($attachment_metas)) {
38
  foreach ($attachment_metas as $attachment_meta) {
19
  $attch = '';
20
 
21
  // search attachment by attached file
22
+ $attachment_metas = $wpdb->get_results($wpdb->prepare("SELECT * FROM " . $wpdb->postmeta . " WHERE meta_key = %s AND (meta_value = %s OR meta_value LIKE %s ESCAPE '$');", '_wp_attached_file', $image_name, "%/" . str_replace('_', '$_', $image_name)));
23
 
24
  if (!empty($attachment_metas)) {
25
  foreach ($attachment_metas as $attachment_meta) {
32
  }
33
 
34
  if (empty($attch)) {
35
+ $attachment_metas = $wpdb->get_results($wpdb->prepare("SELECT * FROM " . $wpdb->postmeta . " WHERE meta_key = %s AND (meta_value = %s OR meta_value LIKE %s ESCAPE '$');", '_wp_attached_file', sanitize_file_name($image_name), "%/" . str_replace('_', '$_', sanitize_file_name($image_name))));
36
 
37
  if (!empty($attachment_metas)) {
38
  foreach ($attachment_metas as $attachment_meta) {
helpers/wp_all_import_is_json.php CHANGED
@@ -28,7 +28,7 @@ if ( ! function_exists('wp_all_import_is_json')){
28
  return new WP_Error( 'broke', __( "Unknown json error", "pmxi_plugin" ) );
29
  break;
30
  }
31
- }
32
- return true;
33
  }
34
  }
28
  return new WP_Error( 'broke', __( "Unknown json error", "pmxi_plugin" ) );
29
  break;
30
  }
31
+ }
32
+ return true;
33
  }
34
  }
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_sanitize_filename.php CHANGED
@@ -7,9 +7,11 @@ function wp_all_import_sanitize_filename($filename) {
7
  $ext = end($filename_parts);
8
  // Replace all weird characters
9
  $sanitized = substr($filename, 0, -(strlen($ext)+1));
 
10
  $sanitized = str_replace("_", "willbetrimmed", $sanitized);
11
  $sanitized = sanitize_file_name($sanitized);
12
  $sanitized = str_replace("willbetrimmed", "_", $sanitized);
 
13
  // Replace dots inside filename
14
  //$sanitized = str_replace('.','-', $sanitized);
15
  return $sanitized . '.' . $ext;
7
  $ext = end($filename_parts);
8
  // Replace all weird characters
9
  $sanitized = substr($filename, 0, -(strlen($ext)+1));
10
+ $sanitized = str_replace(".", "willbedots", $sanitized);
11
  $sanitized = str_replace("_", "willbetrimmed", $sanitized);
12
  $sanitized = sanitize_file_name($sanitized);
13
  $sanitized = str_replace("willbetrimmed", "_", $sanitized);
14
+ $sanitized = str_replace("willbedots", ".", $sanitized);
15
  // Replace dots inside filename
16
  //$sanitized = str_replace('.','-', $sanitized);
17
  return $sanitized . '.' . $ext;
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_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
libraries/XmlImportCsvParse.php CHANGED
@@ -918,26 +918,19 @@ class PMXI_CsvParser
918
  * @access protected
919
  * @return boolean
920
  */
921
- protected function parse()
922
- {
923
  if (!$this->validates()) {
924
  return false;
925
  }
926
 
927
  $tmpname = wp_unique_filename($this->targetDir, str_replace("csv", "xml", basename($this->_filename)));
928
- if ("" == $this->xml_path)
929
- $this->xml_path = $this->targetDir .'/'. wp_all_import_url_title($tmpname);
930
-
931
- $this->toXML(true);
932
-
933
- /*$file = new PMXI_Chunk($this->xml_path, array('element' => 'node'));
934
-
935
- if ( empty($file->options['element']) ){
936
- $this->toXML(true); // Remove non ASCII symbols and write CDATA
937
- }*/
938
 
 
 
939
  return true;
940
-
941
  }
942
 
943
  function toXML( $fixBrokenSymbols = false ){
@@ -1174,7 +1167,9 @@ class PMXI_CsvParser
1174
  'pipe' => '|',
1175
  'tabulation' => "\t"
1176
  );
1177
-
 
 
1178
  // specify allowed line endings
1179
  $line_endings = array(
1180
  'rn' => "\r\n",
918
  * @access protected
919
  * @return boolean
920
  */
921
+ protected function parse() {
 
922
  if (!$this->validates()) {
923
  return false;
924
  }
925
 
926
  $tmpname = wp_unique_filename($this->targetDir, str_replace("csv", "xml", basename($this->_filename)));
927
+ if ("" == $this->xml_path) {
928
+ $this->xml_path = $this->targetDir .'/'. wp_all_import_url_title($tmpname);
929
+ }
 
 
 
 
 
 
 
930
 
931
+ $ignore_special_characters = apply_filters('wp_all_import_csv_to_xml_remove_non_ascii_characters', true);
932
+ $this->toXML($ignore_special_characters);
933
  return true;
 
934
  }
935
 
936
  function toXML( $fixBrokenSymbols = false ){
1167
  'pipe' => '|',
1168
  'tabulation' => "\t"
1169
  );
1170
+
1171
+ $delimiters = apply_filters('wp_all_import_specified_delimiters', $delimiters);
1172
+
1173
  // specify allowed line endings
1174
  $line_endings = array(
1175
  'rn' => "\r\n",
libraries/XmlImportParser.php CHANGED
@@ -50,7 +50,7 @@ class XmlImportParser {
50
  $xml and $xml = preg_replace('%xmlns\s*=\s*([\'"]).*\1%sU', '', $xml);
51
 
52
  libxml_use_internal_errors(true);
53
- try{
54
  $this->xml = new SimpleXMLElement($xml);
55
  } catch (Exception $e){
56
  try{
50
  $xml and $xml = preg_replace('%xmlns\s*=\s*([\'"]).*\1%sU', '', $xml);
51
 
52
  libxml_use_internal_errors(true);
53
+ try{
54
  $this->xml = new SimpleXMLElement($xml);
55
  } catch (Exception $e){
56
  try{
models/import/record.php CHANGED
@@ -10,7 +10,7 @@ class PMXI_Import_Record extends PMXI_Model_Record {
10
  * Some pre-processing logic, such as removing control characters from xml to prevent parsing errors
11
  * @param string $xml
12
  */
13
- public static function preprocessXml( & $xml) {
14
 
15
  if ( empty(PMXI_Plugin::$session->is_csv) and empty(PMXI_Plugin::$is_csv)){
16
 
@@ -18,11 +18,11 @@ class PMXI_Import_Record extends PMXI_Model_Record {
18
 
19
  $is_preprocess_enabled = apply_filters('is_xml_preprocess_enabled', true);
20
 
21
- if ($is_preprocess_enabled)
22
- {
23
  $xml = preg_replace_callback('/<!\[CDATA\[.*?\]\]>/s', 'wp_all_import_cdata_filter', $xml );
24
 
25
- $xml = preg_replace('/&([^amp;|^gt;|^lt;]+)/i', '&amp;$1', $xml);
26
 
27
  if ( ! empty(self::$cdata) ){
28
  foreach (self::$cdata as $key => $val) {
@@ -84,7 +84,7 @@ class PMXI_Import_Record extends PMXI_Model_Record {
84
  parent::__construct($data);
85
  $this->setTable(PMXI_Plugin::getInstance()->getTablePrefix() . 'imports');
86
  $this->errors = new WP_Error();
87
- }
88
 
89
  protected function update_meta( $pid, $key, $value ){
90
 
@@ -943,7 +943,7 @@ class PMXI_Import_Record extends PMXI_Model_Record {
943
  'last_name' => $addons_data['PMUI_Plugin']['pmsci_customer_last_name'][$i],
944
  'description' => $addons_data['PMUI_Plugin']['pmsci_customer_description'][$i],
945
  'nickname' => $addons_data['PMUI_Plugin']['pmsci_customer_nickname'][$i],
946
- 'role' => $addons_data['PMUI_Plugin']['pmsci_customer_role'][$i],
947
 
948
  ), $this->options['custom_type'], $this->id, $i);
949
  $logger and call_user_func($logger, sprintf(__('Combine account data for customer %s...', 'wp_all_import_plugin'), $articleData['user_login']));
@@ -1079,9 +1079,9 @@ class PMXI_Import_Record extends PMXI_Model_Record {
1079
  $logger and call_user_func($logger, sprintf(__('Find corresponding article among database for post `%s`...', 'wp_all_import_plugin'), $this->getRecordTitle($articleData)));
1080
 
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';
@@ -1090,20 +1090,16 @@ class PMXI_Import_Record extends PMXI_Model_Record {
1090
  $duplicate_id = false;
1091
  }
1092
  }
1093
- }
1094
- // handle duplicates according to import settings
1095
- else
1096
- {
1097
- $duplicates = pmxi_findDuplicates($articleData, $custom_duplicate_name[$i], $custom_duplicate_value[$i], $this->options['duplicate_indicator'], $duplicate_indicator_values[$i]);
1098
- $duplicate_id = ( ! empty($duplicates)) ? array_shift($duplicates) : false;
1099
- }
1100
 
1101
  if ( ! empty($duplicate_id)) {
1102
  $duplicate_id = apply_filters('wp_all_import_manual_matching_duplicate_id', $duplicate_id, $duplicates, $articleData, $this->id);
1103
- if (class_exists('WPAI_WPML') && ! empty($this->options['wpml_addon']['lng'])){
1104
- // trying to find needed translation for update
1105
- $duplicate_id = apply_filters('wpml_object_id', $duplicate_id, get_post_type($duplicate_id), true, $this->options['wpml_addon']['lng']);
1106
- }
1107
  $logger and call_user_func($logger, sprintf(__('Duplicate post was found for post `%s`...', 'wp_all_import_plugin'), $this->getRecordTitle($articleData)));
1108
  switch ($this->options['custom_type']){
1109
  case 'import_users':
@@ -1192,7 +1188,10 @@ class PMXI_Import_Record extends PMXI_Model_Record {
1192
  continue;
1193
  }
1194
 
1195
- $articleData['ID'] = $post_to_update_id;
 
 
 
1196
  // Choose which data to update
1197
  if ( $this->options['update_all_data'] == 'no' ){
1198
 
@@ -1336,6 +1335,10 @@ class PMXI_Import_Record extends PMXI_Model_Record {
1336
  $articleData['comment_status'] = $post_to_update->comment_status;
1337
  $logger and call_user_func($logger, sprintf(__('Preserve comment status of already existing article for `%s`', 'wp_all_import_plugin'), $articleData['post_title']));
1338
  }
 
 
 
 
1339
  if ( ! $this->options['is_update_author']){
1340
  $articleData['post_author'] = $post_to_update->post_author;
1341
  $logger and call_user_func($logger, sprintf(__('Preserve post author of already existing article for `%s`', 'wp_all_import_plugin'), $articleData['post_title']));
@@ -1564,15 +1567,10 @@ class PMXI_Import_Record extends PMXI_Model_Record {
1564
  }
1565
 
1566
  // Update billing details for customer
1567
- if ( empty($articleData['ID']) or $this->options['update_all_data'] == 'yes' or $this->options['pmsci_is_update_billing_fields'] )
1568
- {
1569
-
1570
  $logger and call_user_func($logger, sprintf(__('- Importing billing data...', 'wp_all_import_plugin')));
1571
-
1572
  if (!empty($billing_data)) {
1573
-
1574
  foreach($billing_data as $key => $value) {
1575
-
1576
  if (
1577
  // Update all Billing Fields
1578
  ( $this->options['pmsci_update_billing_fields_logic'] == 'full_update' )
@@ -1581,38 +1579,27 @@ class PMXI_Import_Record extends PMXI_Model_Record {
1581
  ( $this->options['pmsci_update_billing_fields_logic'] == 'only' and in_array( $key, $this->options['pmsci_billing_fields_list'] ) )
1582
  or
1583
  // Leave these fields alone, update all other Billing Fields
1584
-
1585
  ( $this->options['pmsci_update_billing_fields_logic'] == 'all_except' and !in_array( $key, $this->options['pmsci_billing_fields_list'] ) )
1586
-
1587
  ){
1588
-
1589
  update_user_meta($pid, $key, $value);
1590
  $logger and call_user_func($logger, sprintf(__('- Billing field `%s` has been updated with value `%s` for customer `%s` ...', 'wp_all_import_plugin'), $key, $value, $articleData['user_login']));
1591
-
1592
  }
1593
-
1594
  }
1595
-
1596
  }
1597
-
1598
  }
1599
 
1600
- // Update shipping details for customer
1601
- if ( empty($articleData['ID']) or $this->options['update_all_data'] == 'yes' or $this->options['pmsci_is_update_shipping_fields'] )
1602
- {
1603
- switch ($this->options['pmsci_customer']['shipping_source'])
1604
- {
1605
- // Copy from billing
1606
  case 'copy':
1607
-
1608
  $logger and call_user_func($logger, sprintf(__('- Copying billing information to shipping fields...', 'wp_all_import_plugin')));
1609
-
1610
- if ( ! empty( $billing_data )){
1611
  foreach ($billing_data as $key => $value) {
1612
  $shipping_field = str_replace('billing', 'shipping', $key);
1613
-
1614
- if ( in_array($shipping_field, array('shipping_phone','shipping_email') ) ) continue;
1615
-
1616
  if (
1617
  // Update all Shipping Fields
1618
  ( $this->options['pmsci_update_shipping_fields_logic'] == 'full_update' )
@@ -1623,27 +1610,18 @@ class PMXI_Import_Record extends PMXI_Model_Record {
1623
  // Leave these fields alone, update all other Shipping Fields
1624
 
1625
  ( $this->options['pmsci_update_shipping_fields_logic'] == 'all_except' and !in_array( $shipping_field, $this->options['pmsci_shipping_fields_list'] ) )
1626
-
1627
  ){
1628
-
1629
  update_user_meta( $pid, $shipping_field, $value );
1630
  $logger and call_user_func($logger, sprintf(__('- Shipping field `%s` has been updated with value `%s` for customer `%s` ...', 'wp_all_import_plugin'), $shipping_field, $value, $articleData['user_login']));
1631
-
1632
  }
1633
  }
1634
  }
1635
-
1636
  break;
1637
-
1638
- // Import shipping address
1639
  default:
1640
-
1641
  $logger and call_user_func($logger, sprintf(__('- Importing shipping data separately...', 'wp_all_import_plugin')));
1642
-
1643
  foreach ($shipping_data as $key => $value) {
1644
-
1645
  $shipping_field = $key;
1646
-
1647
  if (
1648
  // Update all Shipping Fields
1649
  ( $this->options['pmsci_update_shipping_fields_logic'] == 'full_update' )
@@ -1652,17 +1630,12 @@ class PMXI_Import_Record extends PMXI_Model_Record {
1652
  ( $this->options['pmsci_update_shipping_fields_logic'] == 'only' and in_array( $shipping_field, $this->options['pmsci_shipping_fields_list'] ) )
1653
  or
1654
  // Leave these fields alone, update all other Shipping Fields
1655
-
1656
  ( $this->options['pmsci_update_shipping_fields_logic'] == 'all_except' and !in_array( $shipping_field, $this->options['pmsci_shipping_fields_list'] ) )
1657
-
1658
  ){
1659
-
1660
  update_user_meta( $pid, $key, $value);
1661
  $logger and call_user_func($logger, sprintf(__('- Shipping field `%s` has been updated with value `%s` for customer `%s` ...', 'wp_all_import_plugin'), $key, $value, $articleData['user_login']));
1662
-
1663
  }
1664
  }
1665
-
1666
  break;
1667
  }
1668
  }
@@ -1682,8 +1655,7 @@ class PMXI_Import_Record extends PMXI_Model_Record {
1682
  break;
1683
  }
1684
 
1685
- if (empty($pid))
1686
- {
1687
  $logger and call_user_func($logger, __('<b>ERROR</b>', 'wp_all_import_plugin') . ': something wrong, ID = 0 was generated.');
1688
  $logger and !$is_cron and PMXI_Plugin::$session->errors++;
1689
  $skipped++;
@@ -1752,17 +1724,14 @@ class PMXI_Import_Record extends PMXI_Model_Record {
1752
 
1753
  $import_functions = apply_filters('wp_all_import_addon_import', array());
1754
 
1755
- // deligate operation to addons
1756
- foreach (PMXI_Admin_Addons::get_active_addons() as $class){
1757
- if (class_exists($class)){
1758
  if ( method_exists($addons[$class], 'import') ) $addons[$class]->import($importData);
1759
  }
1760
- else
1761
- {
1762
- if ( ! empty($import_functions[$class]) ){
1763
-
1764
- if ( is_array($import_functions[$class]) and is_callable($import_functions[$class]) or ! is_array($import_functions[$class]) and function_exists($import_functions[$class]) ){
1765
-
1766
  call_user_func($import_functions[$class], $importData, $addons_data[$class]);
1767
  }
1768
  }
@@ -1969,7 +1938,7 @@ class PMXI_Import_Record extends PMXI_Model_Record {
1969
  }
1970
  }
1971
 
1972
- $is_images_to_update = apply_filters('pmxi_is_images_to_update', true, $articleData, $current_xml_node);
1973
 
1974
  if ( ! in_array($this->options['custom_type'], array('shop_order', 'import_users', 'shop_customer')) ) {
1975
  $logger and call_user_func($logger, __('<b>IMAGES:</b>', 'wp_all_import_plugin'));
@@ -2163,7 +2132,7 @@ class PMXI_Import_Record extends PMXI_Model_Record {
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,7 +2257,7 @@ class PMXI_Import_Record extends PMXI_Model_Record {
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
  }
@@ -2645,11 +2614,11 @@ class PMXI_Import_Record extends PMXI_Model_Record {
2645
 
2646
  if ($attch != null and empty($attch->post_parent))
2647
  {
2648
- $logger and call_user_func($logger, sprintf(__('- Attachment has been successfully updated for file `%s`', 'wp_all_import_plugin'), ($handle_attachment) ? $handle_attachment['url'] : $targetUrl . '/' . $attachment_filename));
2649
  }
2650
  elseif(empty($attch))
2651
  {
2652
- $logger and call_user_func($logger, sprintf(__('- Attachment has been successfully created for file `%s`', 'wp_all_import_plugin'), ($handle_attachment) ? $handle_attachment['url'] : $targetUrl . '/' . $attachment_filename));
2653
  }
2654
  $logger and call_user_func($logger, __('- <b>ACTION</b>: pmxi_attachment_uploaded', 'wp_all_import_plugin'));
2655
  do_action( 'pmxi_attachment_uploaded', $pid, $attach_id, $attachment_filepath);
@@ -2711,12 +2680,9 @@ class PMXI_Import_Record extends PMXI_Model_Record {
2711
  if ( ! empty($txes[$i]) ):
2712
  foreach ($txes[$i] as $key => $single_tax) {
2713
  $is_created_term = false;
2714
- if (is_array($single_tax) and ! empty($single_tax['name'])){
2715
-
2716
  $parent_id = ( ! empty($single_tax['parent'])) ? pmxi_recursion_taxes($single_tax['parent'], $tx_name, $txes[$i], $key) : '';
2717
-
2718
- $term = (empty($this->options['tax_is_full_search_' . $this->options['tax_logic'][$tx_name]][$tx_name])) ? is_exists_term($single_tax['name'], $tx_name, (int)$parent_id) : is_exists_term($single_tax['name'], $tx_name);
2719
-
2720
  if ( empty($term) and !is_wp_error($term) ){
2721
  $term = (empty($this->options['tax_is_full_search_' . $this->options['tax_logic'][$tx_name]][$tx_name])) ? is_exists_term(htmlspecialchars($single_tax['name']), $tx_name, (int)$parent_id) : is_exists_term(htmlspecialchars($single_tax['name']), $tx_name);
2722
  if ( empty($term) and !is_wp_error($term) ){
@@ -2779,16 +2745,12 @@ class PMXI_Import_Record extends PMXI_Model_Record {
2779
  }
2780
  }
2781
  endif;
2782
-
2783
  $assign_taxes = apply_filters('wp_all_import_set_post_terms', $assign_taxes, $tx_name, $pid, $this->id);
2784
-
2785
  // associate taxes with post
2786
  $this->associate_terms($pid, ( empty($assign_taxes) ? false : $assign_taxes ), $tx_name, $logger, $is_cron, $articleData['post_status']);
2787
-
2788
  }
2789
- else
2790
- {
2791
- $logger and call_user_func($logger, sprintf(__('- %s %s `%s` has been skipped attempted to `Do not update Taxonomies (incl. Categories and Tags)`...', 'wp_all_import_plugin'), $custom_type_details->labels->singular_name, $tx_name, $single_tax['name']));
2792
  }
2793
  }
2794
  if ( $this->options['update_all_data'] == "no" and ( ($this->options['is_update_categories'] and $this->options['update_categories_logic'] != 'full_update') or ( ! $this->options['is_update_categories'] and ( is_object_in_taxonomy( $post_type[$i], 'category' ) or is_object_in_taxonomy( $post_type[$i], 'post_tag' ) ) ) ) ) {
@@ -3145,8 +3107,9 @@ class PMXI_Import_Record extends PMXI_Model_Record {
3145
 
3146
  $to_delete = apply_filters('wp_all_import_is_post_to_delete', $to_delete, $missingPostRecord['post_id'], $this);
3147
 
3148
- if ($to_delete){
3149
  if ( ! in_array($this->options['custom_type'], array("import_users", "taxonomies", "shop_customer")) ){
 
3150
  // Remove attachments
3151
  empty($this->options['is_keep_attachments']) and wp_delete_attachments($missingPostRecord['post_id'], true, 'files');
3152
  // Remove images
@@ -3155,8 +3118,7 @@ class PMXI_Import_Record extends PMXI_Model_Record {
3155
  wp_delete_object_term_relationships($missingPostRecord['post_id'], get_object_taxonomies('' != $this->options['custom_type'] ? $this->options['custom_type'] : 'post'));
3156
  }
3157
  }
3158
- else
3159
- {
3160
  $skipp_from_deletion[] = $missingPostRecord['post_id'];
3161
  $postRecord = new PMXI_Post_Record();
3162
  $postRecord->getBy(array(
@@ -3357,54 +3319,35 @@ class PMXI_Import_Record extends PMXI_Model_Record {
3357
  * @chainable
3358
  */
3359
  public function deletePostsAjax($keepPosts = TRUE, $is_deleted_images = 'auto', $is_delete_attachments = 'auto') {
3360
-
3361
- $postList = new PMXI_Post_List();
3362
-
3363
- if ( ! $keepPosts) {
3364
-
3365
  $missing_ids = array();
3366
-
3367
  $sql = "SELECT post_id FROM " . PMXI_Plugin::getInstance()->getTablePrefix() . "posts WHERE import_id = %d";
3368
  $missingPosts = $this->wpdb->get_results(
3369
  $this->wpdb->prepare($sql, $this->id)
3370
- );
3371
-
3372
- if ( ! empty($missingPosts) ):
3373
-
3374
  foreach ($missingPosts as $missingPost) {
3375
-
3376
  $missing_ids[] = $missingPost->post_id;
3377
-
3378
  }
3379
-
3380
- endif;
3381
-
3382
  // Delete posts from database
3383
- if ( ! empty($missing_ids) && is_array($missing_ids) ){
3384
-
3385
- $missing_ids_arr = array_chunk($missing_ids, $this->options['records_per_request']);
3386
-
3387
  foreach ($missing_ids_arr as $key => $ids) {
3388
-
3389
- if ( ! empty($ids) ) {
3390
-
3391
- $this->deleteRecords($is_delete_attachments, $is_deleted_images, $ids);
3392
-
3393
  // Delete record form pmxi_posts
3394
  $sql = "DELETE FROM " . PMXI_Plugin::getInstance()->getTablePrefix() . "posts WHERE post_id IN (".implode(',', $ids).") AND import_id = %d";
3395
  $this->wpdb->query(
3396
  $this->wpdb->prepare($sql, $this->id)
3397
- );
3398
-
3399
  $this->set(array('deleted' => $this->deleted + count($ids)))->update();
3400
  }
3401
  break;
3402
  }
3403
-
3404
  return (count($missing_ids_arr) > 1) ? false : true;
3405
  }
3406
- }
3407
-
3408
  return true;
3409
  }
3410
 
@@ -3421,46 +3364,35 @@ class PMXI_Import_Record extends PMXI_Model_Record {
3421
  foreach ($post->getBy('import_id', $this->id)->convertRecords() as $p) {
3422
  $ids[] = $p->post_id;
3423
  }
3424
-
3425
  if ( ! empty($ids) ){
3426
-
3427
- $this->deleteRecords($is_delete_attachments, $is_deleted_images, $ids);
3428
-
3429
  }
3430
  }
3431
-
3432
  $this->wpdb->query($this->wpdb->prepare('DELETE FROM ' . $post->getTable() . ' WHERE import_id = %s', $this->id));
3433
-
3434
  return $this;
3435
  }
3436
 
3437
- protected function deleteRecords( $is_delete_attachments, $is_deleted_images, $ids = array() )
3438
- {
3439
  foreach ( $ids as $k => $id ) {
3440
-
3441
  if ( ! in_array($this->options['custom_type'], array('import_users', 'taxonomies', 'shop_customer')) ){
3442
- // Remove attachments
3443
- if ($is_delete_attachments == 'yes' or $is_delete_attachments == 'auto' and empty($this->options['is_keep_attachments']))
3444
- {
3445
  wp_delete_attachments($id, true, 'files');
3446
  }
3447
- else
3448
- {
3449
  wp_delete_attachments($id, false, 'files');
3450
  }
3451
- // Remove images
3452
- if ($is_deleted_images == 'yes' or $is_deleted_images == 'auto' and empty($this->options['is_keep_imgs']))
3453
- {
3454
  wp_delete_attachments($id, true, 'images');
3455
  }
3456
- else
3457
- {
3458
  wp_delete_attachments($id, false, 'images');
3459
  }
 
3460
  }
3461
-
3462
- if ( ! in_array($this->options['custom_type'], array('import_users', 'taxonomies', 'shop_customer')) ) wp_delete_object_term_relationships($id, get_object_taxonomies('' != $this->options['custom_type'] ? $this->options['custom_type'] : 'post'));
3463
- }
3464
 
3465
  switch ($this->options['custom_type']){
3466
  case 'import_users':
10
  * Some pre-processing logic, such as removing control characters from xml to prevent parsing errors
11
  * @param string $xml
12
  */
13
+ public static function preprocessXml( &$xml ) {
14
 
15
  if ( empty(PMXI_Plugin::$session->is_csv) and empty(PMXI_Plugin::$is_csv)){
16
 
18
 
19
  $is_preprocess_enabled = apply_filters('is_xml_preprocess_enabled', true);
20
 
21
+ if ($is_preprocess_enabled) {
22
+
23
  $xml = preg_replace_callback('/<!\[CDATA\[.*?\]\]>/s', 'wp_all_import_cdata_filter', $xml );
24
 
25
+ $xml = preg_replace_callback('/&(.{2,5};)?/i', 'wp_all_import_amp_filter', $xml );
26
 
27
  if ( ! empty(self::$cdata) ){
28
  foreach (self::$cdata as $key => $val) {
84
  parent::__construct($data);
85
  $this->setTable(PMXI_Plugin::getInstance()->getTablePrefix() . 'imports');
86
  $this->errors = new WP_Error();
87
+ }
88
 
89
  protected function update_meta( $pid, $key, $value ){
90
 
943
  'last_name' => $addons_data['PMUI_Plugin']['pmsci_customer_last_name'][$i],
944
  'description' => $addons_data['PMUI_Plugin']['pmsci_customer_description'][$i],
945
  'nickname' => $addons_data['PMUI_Plugin']['pmsci_customer_nickname'][$i],
946
+ 'role' => ( '' == $addons_data['PMUI_Plugin']['pmsci_customer_role'][$i]) ? 'customer' : $addons_data['PMUI_Plugin']['pmsci_customer_role'][$i],
947
 
948
  ), $this->options['custom_type'], $this->id, $i);
949
  $logger and call_user_func($logger, sprintf(__('Combine account data for customer %s...', 'wp_all_import_plugin'), $articleData['user_login']));
1079
  $logger and call_user_func($logger, sprintf(__('Find corresponding article among database for post `%s`...', 'wp_all_import_plugin'), $this->getRecordTitle($articleData)));
1080
 
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';
1090
  $duplicate_id = false;
1091
  }
1092
  }
1093
+ }
1094
+ // handle duplicates according to import settings
1095
+ else
1096
+ {
1097
+ $duplicates = pmxi_findDuplicates($articleData, $custom_duplicate_name[$i], $custom_duplicate_value[$i], $this->options['duplicate_indicator'], $duplicate_indicator_values[$i]);
1098
+ $duplicate_id = ( ! empty($duplicates)) ? array_shift($duplicates) : false;
1099
+ }
1100
 
1101
  if ( ! empty($duplicate_id)) {
1102
  $duplicate_id = apply_filters('wp_all_import_manual_matching_duplicate_id', $duplicate_id, $duplicates, $articleData, $this->id);
 
 
 
 
1103
  $logger and call_user_func($logger, sprintf(__('Duplicate post was found for post `%s`...', 'wp_all_import_plugin'), $this->getRecordTitle($articleData)));
1104
  switch ($this->options['custom_type']){
1105
  case 'import_users':
1188
  continue;
1189
  }
1190
 
1191
+ // This action fires just before preserving data from previously imported post.
1192
+ do_action('wp_all_import_before_preserve_post_data', $this, $post_to_update_id, $articleData);
1193
+
1194
+ $articleData['ID'] = $post_to_update_id;
1195
  // Choose which data to update
1196
  if ( $this->options['update_all_data'] == 'no' ){
1197
 
1335
  $articleData['comment_status'] = $post_to_update->comment_status;
1336
  $logger and call_user_func($logger, sprintf(__('Preserve comment status of already existing article for `%s`', 'wp_all_import_plugin'), $articleData['post_title']));
1337
  }
1338
+ if ( ! $this->options['is_update_ping_status']){
1339
+ $articleData['ping_status'] = $post_to_update->ping_status;
1340
+ $logger and call_user_func($logger, sprintf(__('Preserve ping status of already existing article for `%s`', 'wp_all_import_plugin'), $articleData['post_title']));
1341
+ }
1342
  if ( ! $this->options['is_update_author']){
1343
  $articleData['post_author'] = $post_to_update->post_author;
1344
  $logger and call_user_func($logger, sprintf(__('Preserve post author of already existing article for `%s`', 'wp_all_import_plugin'), $articleData['post_title']));
1567
  }
1568
 
1569
  // Update billing details for customer
1570
+ if ( empty($articleData['ID']) or $this->options['update_all_data'] == 'yes' or $this->options['pmsci_is_update_billing_fields'] ) {
 
 
1571
  $logger and call_user_func($logger, sprintf(__('- Importing billing data...', 'wp_all_import_plugin')));
 
1572
  if (!empty($billing_data)) {
 
1573
  foreach($billing_data as $key => $value) {
 
1574
  if (
1575
  // Update all Billing Fields
1576
  ( $this->options['pmsci_update_billing_fields_logic'] == 'full_update' )
1579
  ( $this->options['pmsci_update_billing_fields_logic'] == 'only' and in_array( $key, $this->options['pmsci_billing_fields_list'] ) )
1580
  or
1581
  // Leave these fields alone, update all other Billing Fields
 
1582
  ( $this->options['pmsci_update_billing_fields_logic'] == 'all_except' and !in_array( $key, $this->options['pmsci_billing_fields_list'] ) )
 
1583
  ){
 
1584
  update_user_meta($pid, $key, $value);
1585
  $logger and call_user_func($logger, sprintf(__('- Billing field `%s` has been updated with value `%s` for customer `%s` ...', 'wp_all_import_plugin'), $key, $value, $articleData['user_login']));
 
1586
  }
 
1587
  }
 
1588
  }
 
1589
  }
1590
 
1591
+ // Update shipping details for customer.
1592
+ if ( empty($articleData['ID']) or $this->options['update_all_data'] == 'yes' or $this->options['pmsci_is_update_shipping_fields'] ) {
1593
+ switch ($this->options['pmsci_customer']['shipping_source']) {
1594
+ // Copy from billing.
 
 
1595
  case 'copy':
 
1596
  $logger and call_user_func($logger, sprintf(__('- Copying billing information to shipping fields...', 'wp_all_import_plugin')));
1597
+ if ( ! empty( $billing_data )) {
 
1598
  foreach ($billing_data as $key => $value) {
1599
  $shipping_field = str_replace('billing', 'shipping', $key);
1600
+ if ( in_array($shipping_field, array('shipping_phone','shipping_email') ) ) {
1601
+ continue;
1602
+ }
1603
  if (
1604
  // Update all Shipping Fields
1605
  ( $this->options['pmsci_update_shipping_fields_logic'] == 'full_update' )
1610
  // Leave these fields alone, update all other Shipping Fields
1611
 
1612
  ( $this->options['pmsci_update_shipping_fields_logic'] == 'all_except' and !in_array( $shipping_field, $this->options['pmsci_shipping_fields_list'] ) )
 
1613
  ){
 
1614
  update_user_meta( $pid, $shipping_field, $value );
1615
  $logger and call_user_func($logger, sprintf(__('- Shipping field `%s` has been updated with value `%s` for customer `%s` ...', 'wp_all_import_plugin'), $shipping_field, $value, $articleData['user_login']));
 
1616
  }
1617
  }
1618
  }
 
1619
  break;
1620
+ // Import shipping address.
 
1621
  default:
 
1622
  $logger and call_user_func($logger, sprintf(__('- Importing shipping data separately...', 'wp_all_import_plugin')));
 
1623
  foreach ($shipping_data as $key => $value) {
 
1624
  $shipping_field = $key;
 
1625
  if (
1626
  // Update all Shipping Fields
1627
  ( $this->options['pmsci_update_shipping_fields_logic'] == 'full_update' )
1630
  ( $this->options['pmsci_update_shipping_fields_logic'] == 'only' and in_array( $shipping_field, $this->options['pmsci_shipping_fields_list'] ) )
1631
  or
1632
  // Leave these fields alone, update all other Shipping Fields
 
1633
  ( $this->options['pmsci_update_shipping_fields_logic'] == 'all_except' and !in_array( $shipping_field, $this->options['pmsci_shipping_fields_list'] ) )
 
1634
  ){
 
1635
  update_user_meta( $pid, $key, $value);
1636
  $logger and call_user_func($logger, sprintf(__('- Shipping field `%s` has been updated with value `%s` for customer `%s` ...', 'wp_all_import_plugin'), $key, $value, $articleData['user_login']));
 
1637
  }
1638
  }
 
1639
  break;
1640
  }
1641
  }
1655
  break;
1656
  }
1657
 
1658
+ if (empty($pid)) {
 
1659
  $logger and call_user_func($logger, __('<b>ERROR</b>', 'wp_all_import_plugin') . ': something wrong, ID = 0 was generated.');
1660
  $logger and !$is_cron and PMXI_Plugin::$session->errors++;
1661
  $skipped++;
1724
 
1725
  $import_functions = apply_filters('wp_all_import_addon_import', array());
1726
 
1727
+ // Deligate import operation to addons.
1728
+ foreach (PMXI_Admin_Addons::get_active_addons() as $class) {
1729
+ if (class_exists($class)) {
1730
  if ( method_exists($addons[$class], 'import') ) $addons[$class]->import($importData);
1731
  }
1732
+ else {
1733
+ if (!empty($import_functions[$class])) {
1734
+ if (is_array($import_functions[$class]) and is_callable($import_functions[$class]) or ! is_array($import_functions[$class]) and function_exists($import_functions[$class]) ) {
 
 
 
1735
  call_user_func($import_functions[$class], $importData, $addons_data[$class]);
1736
  }
1737
  }
1938
  }
1939
  }
1940
 
1941
+ $is_images_to_update = apply_filters('pmxi_is_images_to_update', true, $articleData, $current_xml_node, $pid);
1942
 
1943
  if ( ! in_array($this->options['custom_type'], array('shop_order', 'import_users', 'shop_customer')) ) {
1944
  $logger and call_user_func($logger, __('<b>IMAGES:</b>', 'wp_all_import_plugin'));
2132
  $image_filename = wp_unique_filename($targetDir, $image_filename);
2133
  $image_filepath = $targetDir . '/' . $image_filename;
2134
  imagejpeg($img, $image_filepath);
2135
+ if( ! ($image_info = apply_filters('pmxi_getimagesize', @getimagesize($image_filepath), $image_filepath)) or ! in_array($image_info[2], wp_all_import_supported_image_types())) {
2136
  $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));
2137
  $logger and !$is_cron and PMXI_Plugin::$session->warnings++;
2138
  } else {
2257
  }
2258
  // validate import images
2259
  elseif($bundle_data['type'] == 'images'){
2260
+ 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], wp_all_import_supported_image_types())) {
2261
  $create_image = true;
2262
  $logger and call_user_func($logger, sprintf(__('- Image `%s` has been successfully found', 'wp_all_import_plugin'), $wpai_image_path));
2263
  }
2614
 
2615
  if ($attch != null and empty($attch->post_parent))
2616
  {
2617
+ $logger and call_user_func($logger, sprintf(__('- Attachment has been successfully updated for file `%s`', 'wp_all_import_plugin'), (isset($handle_attachment)) ? $handle_attachment['url'] : $targetUrl . '/' . wp_all_import_basename($attachment_filepath)));
2618
  }
2619
  elseif(empty($attch))
2620
  {
2621
+ $logger and call_user_func($logger, sprintf(__('- Attachment has been successfully created for file `%s`', 'wp_all_import_plugin'), (isset($handle_attachment)) ? $handle_attachment['url'] : $targetUrl . '/' . wp_all_import_basename($attachment_filepath)));
2622
  }
2623
  $logger and call_user_func($logger, __('- <b>ACTION</b>: pmxi_attachment_uploaded', 'wp_all_import_plugin'));
2624
  do_action( 'pmxi_attachment_uploaded', $pid, $attach_id, $attachment_filepath);
2680
  if ( ! empty($txes[$i]) ):
2681
  foreach ($txes[$i] as $key => $single_tax) {
2682
  $is_created_term = false;
2683
+ if (is_array($single_tax) and ! empty($single_tax['name'])){
 
2684
  $parent_id = ( ! empty($single_tax['parent'])) ? pmxi_recursion_taxes($single_tax['parent'], $tx_name, $txes[$i], $key) : '';
2685
+ $term = (empty($this->options['tax_is_full_search_' . $this->options['tax_logic'][$tx_name]][$tx_name])) ? is_exists_term($single_tax['name'], $tx_name, (int)$parent_id) : is_exists_term($single_tax['name'], $tx_name);
 
 
2686
  if ( empty($term) and !is_wp_error($term) ){
2687
  $term = (empty($this->options['tax_is_full_search_' . $this->options['tax_logic'][$tx_name]][$tx_name])) ? is_exists_term(htmlspecialchars($single_tax['name']), $tx_name, (int)$parent_id) : is_exists_term(htmlspecialchars($single_tax['name']), $tx_name);
2688
  if ( empty($term) and !is_wp_error($term) ){
2745
  }
2746
  }
2747
  endif;
 
2748
  $assign_taxes = apply_filters('wp_all_import_set_post_terms', $assign_taxes, $tx_name, $pid, $this->id);
 
2749
  // associate taxes with post
2750
  $this->associate_terms($pid, ( empty($assign_taxes) ? false : $assign_taxes ), $tx_name, $logger, $is_cron, $articleData['post_status']);
 
2751
  }
2752
+ else {
2753
+ $logger and call_user_func($logger, sprintf(__('- %s %s has been skipped attempted to `Do not update Taxonomies (incl. Categories and Tags)`...', 'wp_all_import_plugin'), $custom_type_details->labels->singular_name, $tx_name));
 
2754
  }
2755
  }
2756
  if ( $this->options['update_all_data'] == "no" and ( ($this->options['is_update_categories'] and $this->options['update_categories_logic'] != 'full_update') or ( ! $this->options['is_update_categories'] and ( is_object_in_taxonomy( $post_type[$i], 'category' ) or is_object_in_taxonomy( $post_type[$i], 'post_tag' ) ) ) ) ) {
3107
 
3108
  $to_delete = apply_filters('wp_all_import_is_post_to_delete', $to_delete, $missingPostRecord['post_id'], $this);
3109
 
3110
+ if ($to_delete) {
3111
  if ( ! in_array($this->options['custom_type'], array("import_users", "taxonomies", "shop_customer")) ){
3112
+ do_action('pmxi_before_delete_post', $missingPostRecord['post_id'], $this);
3113
  // Remove attachments
3114
  empty($this->options['is_keep_attachments']) and wp_delete_attachments($missingPostRecord['post_id'], true, 'files');
3115
  // Remove images
3118
  wp_delete_object_term_relationships($missingPostRecord['post_id'], get_object_taxonomies('' != $this->options['custom_type'] ? $this->options['custom_type'] : 'post'));
3119
  }
3120
  }
3121
+ else {
 
3122
  $skipp_from_deletion[] = $missingPostRecord['post_id'];
3123
  $postRecord = new PMXI_Post_Record();
3124
  $postRecord->getBy(array(
3319
  * @chainable
3320
  */
3321
  public function deletePostsAjax($keepPosts = TRUE, $is_deleted_images = 'auto', $is_delete_attachments = 'auto') {
3322
+ if ( ! $keepPosts) {
 
 
 
 
3323
  $missing_ids = array();
 
3324
  $sql = "SELECT post_id FROM " . PMXI_Plugin::getInstance()->getTablePrefix() . "posts WHERE import_id = %d";
3325
  $missingPosts = $this->wpdb->get_results(
3326
  $this->wpdb->prepare($sql, $this->id)
3327
+ );
3328
+ if ( ! empty($missingPosts) ):
 
 
3329
  foreach ($missingPosts as $missingPost) {
 
3330
  $missing_ids[] = $missingPost->post_id;
 
3331
  }
3332
+ endif;
 
 
3333
  // Delete posts from database
3334
+ if ( ! empty($missing_ids) && is_array($missing_ids) ){
3335
+ $missing_ids_arr = array_chunk($missing_ids, $this->options['records_per_request']);
 
 
3336
  foreach ($missing_ids_arr as $key => $ids) {
3337
+ if ( ! empty($ids) ) {
3338
+ $this->deleteRecords($is_delete_attachments, $is_deleted_images, $ids);
 
 
 
3339
  // Delete record form pmxi_posts
3340
  $sql = "DELETE FROM " . PMXI_Plugin::getInstance()->getTablePrefix() . "posts WHERE post_id IN (".implode(',', $ids).") AND import_id = %d";
3341
  $this->wpdb->query(
3342
  $this->wpdb->prepare($sql, $this->id)
3343
+ );
 
3344
  $this->set(array('deleted' => $this->deleted + count($ids)))->update();
3345
  }
3346
  break;
3347
  }
 
3348
  return (count($missing_ids_arr) > 1) ? false : true;
3349
  }
3350
+ }
 
3351
  return true;
3352
  }
3353
 
3364
  foreach ($post->getBy('import_id', $this->id)->convertRecords() as $p) {
3365
  $ids[] = $p->post_id;
3366
  }
 
3367
  if ( ! empty($ids) ){
3368
+ $this->deleteRecords($is_delete_attachments, $is_deleted_images, $ids);
 
 
3369
  }
3370
  }
 
3371
  $this->wpdb->query($this->wpdb->prepare('DELETE FROM ' . $post->getTable() . ' WHERE import_id = %s', $this->id));
 
3372
  return $this;
3373
  }
3374
 
3375
+ protected function deleteRecords( $is_delete_attachments, $is_deleted_images, $ids = array() ) {
 
3376
  foreach ( $ids as $k => $id ) {
 
3377
  if ( ! in_array($this->options['custom_type'], array('import_users', 'taxonomies', 'shop_customer')) ){
3378
+ do_action('pmxi_before_delete_post', $id, $this);
3379
+ // Remove attachments.
3380
+ if ($is_delete_attachments == 'yes' or $is_delete_attachments == 'auto' and empty($this->options['is_keep_attachments'])) {
3381
  wp_delete_attachments($id, true, 'files');
3382
  }
3383
+ else {
 
3384
  wp_delete_attachments($id, false, 'files');
3385
  }
3386
+ // Remove images.
3387
+ if ($is_deleted_images == 'yes' or $is_deleted_images == 'auto' and empty($this->options['is_keep_imgs'])) {
 
3388
  wp_delete_attachments($id, true, 'images');
3389
  }
3390
+ else {
 
3391
  wp_delete_attachments($id, false, 'images');
3392
  }
3393
+ wp_delete_object_term_relationships($id, get_object_taxonomies('' != $this->options['custom_type'] ? $this->options['custom_type'] : 'post'));
3394
  }
3395
+ }
 
 
3396
 
3397
  switch ($this->options['custom_type']){
3398
  case 'import_users':
plugin.php CHANGED
@@ -3,7 +3,7 @@
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,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.1');
29
 
30
  define('PMXI_EDITION', 'free');
31
 
@@ -1160,6 +1160,7 @@ final class PMXI_Plugin {
1160
  'is_update_categories' => 1,
1161
  'is_update_author' => 1,
1162
  'is_update_comment_status' => 1,
 
1163
  'is_update_post_type' => 1,
1164
  'update_categories_logic' => 'full_update',
1165
  'taxonomies_list' => array(),
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.2
7
  Author: Soflyy
8
  */
9
 
25
  */
26
  define('WP_ALL_IMPORT_PREFIX', 'pmxi_');
27
 
28
+ define('PMXI_VERSION', '3.5.2');
29
 
30
  define('PMXI_EDITION', 'free');
31
 
1160
  'is_update_categories' => 1,
1161
  'is_update_author' => 1,
1162
  'is_update_comment_status' => 1,
1163
+ 'is_update_ping_status' => 1,
1164
  'is_update_post_type' => 1,
1165
  'update_categories_logic' => 'full_update',
1166
  'taxonomies_list' => array(),
readme.txt CHANGED
@@ -1,8 +1,8 @@
1
  === Import any XML or CSV File to WordPress ===
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.
@@ -105,6 +105,12 @@ Does it work with special character encoding like Hebrew, Arabic, Chinese, etc?
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
1
  === Import any XML or CSV File to WordPress ===
2
  Contributors: soflyy, wpallimport
3
  Requires at least: 4.1
4
+ Tested up to: 5.2.3
5
+ Stable tag: 3.5.2
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.
105
 
106
  == Changelog ==
107
 
108
+ = 3.5.2 =
109
+ * improvement: match existing images by filename with underscores
110
+ * API: add new action wp_all_import_before_preserve_post_data
111
+ * API: add new filter wp_all_import_specified_delimiters
112
+ * bug fix: attachment author not imported for API image imports
113
+
114
  = 3.5.1 =
115
  * improvement: add support for importing WebP images
116
  * bug fix: images in content not being imported when creating new simple WooCommerce products
views/admin/import/options/_reimport_options.php CHANGED
@@ -139,6 +139,11 @@
139
  <label for="is_update_comment_status"><?php _e('Comment status', 'wp_all_import_plugin') ?></label>
140
  <?php endif;?>
141
  </div>
 
 
 
 
 
142
  <div class="input">
143
  <input type="hidden" name="is_update_attachments" value="0" />
144
  <input type="checkbox" id="is_update_attachments" name="is_update_attachments" value="1" <?php echo $post['is_update_attachments'] ? 'checked="checked"': '' ?> />
139
  <label for="is_update_comment_status"><?php _e('Comment status', 'wp_all_import_plugin') ?></label>
140
  <?php endif;?>
141
  </div>
142
+ <div class="input">
143
+ <input type="hidden" name="is_update_ping_status" value="0" />
144
+ <input type="checkbox" id="is_update_ping_status" name="is_update_ping_status" value="1" <?php echo $post['is_update_ping_status'] ? 'checked="checked"': '' ?> />
145
+ <label for="is_update_ping_status"><?php _e('Trackbacks and pingbacks', 'wp_all_import_plugin') ?></label>
146
+ </div>
147
  <div class="input">
148
  <input type="hidden" name="is_update_attachments" value="0" />
149
  <input type="checkbox" id="is_update_attachments" name="is_update_attachments" value="1" <?php echo $post['is_update_attachments'] ? 'checked="checked"': '' ?> />
views/admin/import/options/_settings_template.php CHANGED
@@ -1,7 +1,7 @@
1
  <div class="wpallimport-collapsed closed wpallimport-section">
2
  <div class="wpallimport-content-section">
3
  <div class="wpallimport-collapsed-header">
4
- <h3><?php _e('Advanced Options','wp_all_import_plugin');?></h3>
5
  </div>
6
  <div class="wpallimport-collapsed-content" style="padding: 0;">
7
  <div class="wpallimport-collapsed-content-inner">
1
  <div class="wpallimport-collapsed closed wpallimport-section">
2
  <div class="wpallimport-content-section">
3
  <div class="wpallimport-collapsed-header">
4
+ <h3><?php _e('Configure Advanced Settings','wp_all_import_plugin');?></h3>
5
  </div>
6
  <div class="wpallimport-collapsed-content" style="padding: 0;">
7
  <div class="wpallimport-collapsed-content-inner">